PROFILE
• Analyst with experience in sectors such as IT, Media & Communications, Metals and Finance
• Skilled in Financial Analysis using Financial Ratios and benchmarking them with Sector, Industry and S&P 500
• Understanding of capital markets with knowledge in commodities, risk management, equities, fixed income, derivatives and other non-traditional asset classes
• Strong team player with excellent communication, problem solving, organizational, interpersonal, leadership and presentation skills
STATISTICAL AND FINANCIAL MODELS
• Used advanced Excel functions such as VLOOKUP, Offset, Pivot Tables, Index-Match, Goal Seek, Data Table and developer tools such as spin box, scroll bars and combo box as well as basic VBA for financial modeling
• Used R, RapidMiner, SPSS Modeler and Solver to perform descriptive, predictive and prescriptive analysis
EDUCATION
Frank G. Zarb School of Business, Hofstra University, Uniondale, NY Sept. 2013- May 2015
Honors M.B.A. with distinction and double majors in Finance and Business Analytics
• GPA: 3.92/4.0
o Finance: 4.0
o Business Analytics: 3.94
• GRE Score: 1330/1600.
o 800/800 in Quantitative Reasoning
UIET, Panjab University, Chandigarh, India July 2007- May 2011
Bachelor of Engineering in Biotechnology, GPA: 3.14/4.0
PROFESSIONAL EXPERIENCE
Analyst, OpenLink Financial, Uniondale, NY Nov. 2015- Present
• Managing a team of two for the data migration efforts between the old and the new system
• Extracting data from the database and performing descriptive analytics and visualization using Power BI, Excel and SQL to create reports reflecting the current trends in the revenues
• Interviewing the PS leaders and other key stakeholders to document their requirements for the PSA system
• Keeping the data in sync among different systems such as client portal, Salesforce, HRIS, Oracle and NetSuite OpenAir, analyzing and providing reporting on key company metrics
• Data governance and operational risk analysis ensuring data accuracy, consistency & completeness
• Managing and bug fixing a VBA enabled Excel file that aids the FP&A team in the revenue forecasting and budgeting process
Intern Analyst, Five Element Analytics, Merrick, NY Aug. 2015- Nov. 2015
• Interviewing, eliciting and documenting requirements in a BRD and analyzing those requirements
• Responsible for financial ratio analysis and financial planning
• Collecting market data for performing detailed financial, market and competitive analysis
• Building statistical models such as regression analysis, PCA, Cluster Analysis, Classification Analysis, Linear Optimization, Association Rules, Visualization and Simulations including Monte-Carlo
• Recommending whether to invest in properties in the designated area
Business Data Analyst, Cablevision, Bethpage, NY Jun. 2015-Aug. 2015
• Interviewing the SMEs for eliciting and documenting requirements in BRDs
• Working closely with SMEs, developers, testers and other stakeholders to analyze the requirements
• Creating and reviewing test cases (QAT, UAT, Post Prod testing) with the SMEs, testers, developers and users
• Using SQL and MicroStrategy to query data from Oracle and Netezza databases for data analysis
• Assisting consultants in automation of existing reports validation process and documenting the whole validati...
Login or Register to view the full resume.
