ANKITA AGARWAL

*** ********** *****, **** #*** Phone: 650-***-****

Santa Clara, CA-95051 Email: ac27m0@r.postjobfree.com

Seeking a Full-time Opportunity as a Data Analyst

Business professional with analytical experience in Commercial Due Diligence (CDD) and Pre Due Diligence projects across industries and geographies. Experience in developing businesses, increasing business life cycle penetration & mapping competitive landscape.

Result oriented individual with strong analytical abilities and excellent interpersonal skills; proven ability to lead teams and cultivate strong relationships, highly collaborative, self-motivated and be able to work independently, demonstrated capability of a quick learner with high levels of adaptability, tenacity and drive to get things done, ability to juggle multiple priorities and a passion for technology.

Areas of Expertise

Business Development

Project / Product Management

Strategic Planning/Analysis

Investment & Divestment strategy

Financial analysis

Cloud computing

Market Sizing & segmentation

Data Analysis /Data Mining

R Programming

Market valuation & sizing

Competitive Benchmarking

Market Intelligence & rumour mapping

Heat Maps

Market Research

Capital & debt structural analysis

Stock chart annotation

Agile

CRM

Entity Relationship diagram

Technical Skills

Database: Oracle, SQL, Tableau, Salesforce, Capital IQ, Merger Market, Thomson One, Factiva, Debt Wire, SNL, Python (Basic)

Tools: Jira

Office: MS Power point, MS Excel, MS Word

Professional Experience

CIVICSOLAR, CA, USA May 2016-Aug 2016

Intern

Part of cross-functional teams and responsible for maintaining extensive timelines (Product Management and Finance team), assisted product management team in creating stories and EPICS & supported sales team

Work included financial analysis, product & pricing analysis of solar panels using SQL, industry and market analysis, product development and competitive benchmarking and marketing analytics

Ernst & young, India Dec 2013 – Dec 2014

Analyst

Created company profiles (business, financial & competitive description, recent press and intelligence) for private equity firms and strategic buyers across healthcare, telecommunication & media, consumer / industrial goods sector

Prepared company / industry decks and opportunity papers including macroeconomic, financial and competitor analysis using EXCEL to guide clients on mergers, acquisitions, divestures, diversification and market entry strategies

Tracked market intelligence and rumor mapping of potential opportunities

Worked on CAS (Commercial Advisory Services) projects which provides insight into a proposed transaction by evaluating the consistency of the transaction with overall strategy

Education & Training

Year

Degree

Institute / University

Present

MS in Engineering Management

(Anticipated graduation-Dec 31st 2017)

ITU, San Jose, CA

2016

Diploma in MBT (Finance, GBM)

UC Berkeley

2013

Master in Business Administration (MBA)

Indian Institute of Planning & Management (IMI, Belgium)

2011

Bachelors in Technology ( Computer Science)

MD University, Rohtak

Awarded Extra-miler spot award for exceptional performance in Q1’15 (Top 1% in E&Y) (2014)

Certified Associate Developer by IBM in Rational Application Developer (2010)

Certified Database Associate by IBM in DB2 9 Fundamentals (2010)

Academic Experience/Projects

Data Analysis using R programming & Python, ITU FALL 2017

Import the census data for particular regions in United States and performed basic exploratory data analysis using statistical methods, manipulated data, produced graphics, performed regression analysis

Project management (Redesigning website for restaurant), ITU SUMMER 2017

Managed project scope by developing work breakdown structure and critical path tasks for meeting project deadlines and producing deliverables and identified risks internally and externally and participated in scrum teams to self-organize and make changes quickly

Creating a database systems, ITU SUMMER 2017

Developed a fully functional relational database to give a detailed description of the requirements for the XYZ company DB design including system constraints, interface, entity relationship diagrams and interactions with other external applications

Product development plan, ITU SPRING 2017

Defining, researching and documenting the specific product requirements that meet the market and strategy needs (Travel Mobile app for SFO city). The project also included competitive benchmarking, Go-To-Market strategy, Financials (Break Even), Risk Assessment & Mitigation, Product roadmap, PRD and MRD

Stock track exercise, UC Berkeley Winter 2016

Constructed and managed our own personal $500,000 investment portfolio

Made assumptions of risk tolerance and financial goals and used stock market simulator called “Stock-Trak” to buy and sell the investments in your portfolio

PLAY BOOK for Risk Management, UC Berkeley Fall 2016

Constructed a risk agnostic play book for Unilever to evaluate and quantify the risk

Identified critical suppliers, mapped critical supply downstream to the raw materials and upstream to customer, measures to integrate risk management processes into supply chain management approaches

Strategic marketing Plan for launching Chipotle in Brazil, UC Berkeley Fall 2016

Included market overview, risks and opportunity analysis to help develop the product

Worked on 4P’s, market strategy, pricing strategy and budgeting

Macro-Economic Profile for a country, UC Berkeley Fall 2015

Implemented this for Germany using major economic indicators that forecast changes in interest rates, exchange rates, inflation and economic activity using Excel and macros

Contact this candidate