ANKIT GOEL
***** ** ********** ** • Portland, OR 97229
520-***-**** • *******.****@*****.*** • https://in.linkedin.com/in/ankitgoel3
PROFILE SUMMARY
Energetic, innovative, and adaptive leader seeking to leverage technology, financial modelling, project management, healthcare and banking experience to excel as a IT financial analyst
Proficient in financial analysis, planning, budgeting, forecasting, reporting, problem-solving, and trouble-shooting along with management of vendor, resource, and cross functional teams
Action-oriented professional with experience in developing & implementing technology solutions for a Wall-Street firm
EDUCATION
University of Arizona, Eller College of Management, Tucson, AZ Dec 2016
Master of Business Administration
Concentration: Finance
1st place in Internal PepsiCo Case competition
Vellore Institute of Technology, Vellore, India May 2012
Bachelor of Technology
Concentration: Information Technology
PROFESSIONAL EXPERIENCE
Roche Tissue Diagnostic/Ventana Medical Systems, Tucson, AZ May 2016 – August 2016
Finance MBA Intern
Assisted in the creation of the 5-year strategic business plan; created complex financial models and performed data-driven analysis
Created a NPV calculator spreadsheet to prioritize the project portfolio and at every project Stage Gate during the annual Business Planning process
Tested and validated Cognos TM1 tool for proposed projects resulting in finding major faults which were rectified
Standardized the Incremental Business Case Analysis by including various parameters such as Payback Period, MIRR, and profitability index, increasing efficiency of the Analysis by 32%
Generated a dashboard in Tableau server using various data sources
Sunquest Information Systems, Tucson, AZ Jan 2016 – May 2016
MBA Consulting Project
Facilitated a market research project to evaluate indirect costs associated with switching to a competitive Electronic Health Record
Created interview guide and conducted interviews with key personnel at hospitals across the United States
Leveraged qualitative and quantitative research findings to deliver operational recommendations
Merrill Lynch Bank of America, Chennai, India
Senior Software Engineer Feb 2015 – July 2015
Promoted within 2 years to Senior Software Engineer (normally given after minimum 3 years of experience in the company)
Implemented the use of linear programming to select the portfolio of projects for future investments; process improved by 56%
Designed and structured training programs; conducted Knowledge Transfer (KT) sessions for all new associates
Senior Tech Associate July 2012 – Jan 2015
Engaged in performance analysis and optimization with a major focus on requirement gathering, scripting, testing, and analyzing of all IT applications used by financial advisors
Displayed strong analytical skills by scrutinizing various performance related graphs and provided recommendations to the clients
Initiated & automated environment files and worked on big data in various tools which saved time (~20 hours/day) and resources
Underwent domain training in portfolio and wealth management to gain advance knowledge of finance
Started an Environment Club & led a team of 10 people; sole Environment Ambassador for our location
Mangal Sain Jyoti Prasad Pvt Ltd, YamunaNagar, India May 2008 – July 2012
Co-Owner/Partner
Created & implemented Point of Sale (POS) software using Java and SQL to keep track of prices and inventory
Learned how a business franchise works through financial analysis, vendor relationships, and inventory management
Completed training in SAP and Microsoft SQL server
ADDITIONAL INFORMATION
Tools/Technical Skills: Cognos TM1 & Planning, Oracle Hyperion Planning & Essbase, Macros, VBA, Agile SDLC, C, C++