Data Analyst

Sapna Maheshwari

ac1o2v@r.postjobfree.com 408-***-**** github.com/sapnajhawar1991

EDUCATION

Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Information Systems (MSIS) June 2017 ITM Business School Navi Mumbai, India

Master of Business Administration - Marketing June 2014 Institute for Excellence in Higher Education Bhopal, India Bachelor in Commerce June 2012

EXPERIENCE

Kaiser Permanente Pleasanton, CA

Business Data Analyst January 2017 – June 2017

• Developing Business Intelligence product for Sleep Study by defining KPIs metrics, reports and dashboards.

• Gathered Business Requirements from cross-functional consultants at Somnoware Inc. and stakeholders at Kaiser Permanente to come up with an efficient Data Model for sleep study analytics.

• Involved in the process of building and deploying automated ETL process using MySQL and Talend.

• Using Tableau for data visualization by deploying dashboards over cloud based platform of SharePoint. Micron Technologies Milpitas, CA

Market Data Analyst June 2016 – September 2016

• Analyzed large data sets of consumers, products and vendors by creating market models and global vendor summary and reporting to the Marketing Research Manager.

• Used MS Excel tools like VLOOKUP, pivot tables, slicers, macros for data analysis on NAND and DRAM market.

• Prepared Dashboards by extracting data from large databases for data visualization.

• Worked on collecting market data related to smartphones and tablet devices and used it for market analysis. ADFactors Mumbai, India

Market Analyst April 2013 – June 2013

• Successfully earned client's business by gathering requirements. Developed and presented advertisements.

• Researched on past projects and completed market research to check the feasibility of client’s project proposal. Dainik Bhaskar Bhopal, India

Business Strategy Analyst January 2013 – March 2013

• Built and presented tailored strategies to increase existing business and attract new portfolios.

• Proposed and developed a strategy for client to take advantage of the seasonal events during Winter months. TECHNICAL SKILLS

• Languages: SQL, R, Python, UML

• Tools & Platforms: SAP, MySQL, Tableau, MS Excel, MS PowerPoint, SharePoint, MS Visio, Apache Spark

• Focus Areas: Database Management System, Information Systems Analysis and Design, Business Intelligence and Data Warehousing, Data Science with Python, Financial & Managerial Accounting, ERP ACADEMIC PROJECTS

• Data Analysis with Python: Successfully analyzed dataset and performed all steps of Data Analysis process including Question and data wrangling phase, exploring data and drawing conclusions; used Numpy and Pandas libraries; computed predictions through machine learning algorithms using Python scikit-learn library.

• BI Solution on impacts of California's ongoing drought on agriculture: Created a BI solution. Worked on data integration and ETL jobs, BI dashboards using Tableau. Created ERD using snowflake schema modeling.

• Reward Management System: Developed a database system, analyzed and extracted preferred business metrics using Tableau which helped to determine the success of the business.

• System Analysis and Design: Proposed an information system by stages of SDLC lifecycle. Determined core business processes, identified functional and non-functional requirements, use cases, constructed data flow diagrams and structure chart.

• Financial Analysis of Boeing VS Airbus: Successfully executed the analysis of the Industry, Key Competitors, Street’s Position and Business Segmentation along with Horizontal Vertical and Financial ratio analysis.

• Strategic Business Analysis: LinkedIn: Analyzed current and future position of company in the market. Research on Product Portfolio and created a Product Mapping. Worked on market models.

• Heels off – Created an innovative product design for females after Identifying market needs. Presented market opportunity by calculating TAM, SAM and SOM. Created prototype for final selected strategy and business case by creating financial model and performing NPV Tradeoff Analysis.

Contact this candidate