Data Scientist / Analyst

Apoorva Nerkar

Data Scientist/Analyst with * years of professional work experience

***** ****** *** ****, *******, CA 94542 adb25n@r.postjobfree.com +1-650-***-**** LinkedIn EDUCATION

California State University, East Bay Hayward, CA

Master of Science in Business Analytics Aug 2019 - Dec 2020 G.H. Raisoni College of Engineering and Technology for Women Nagpur, India Bachelor of Engineering in Computer Science May 2013 TECHNICAL SKILLS

• Functional Skills: Business Intelligence Reporting & Data Warehousing, Data Engineering and Analytics, Data Science

• Programming Languages: Python, R programming, SQL

• ETL Tool: Informatica Power Center

• Databases: MS SQL Server, Oracle9i, MS-Access

• BI Tools: MicroStrategy, Tableau, Power BI, Microsoft Excel

• Machine Learning: Regression, Clustering (KMeans, Hierarchal), Association Rule Mining, Classification Algorithms, Deep Learning, Neural Networks

EXPERIENCE

InfoCepts Nagpur, India

Lead Analyst Jan 2019 – July 2019

Senior Business Intelligence – Data Analyst Mar 2016– Dec 2018

• Worked on various BI Analytics projects based on retail domain using MicroStrategy platform performing analysis, design, development, testing, and debugging of complex reports, ETL scripts and dashboards to provide meaningful data insights.

• Supported implementing BI solutions by addressing user questions/inquiries serving as technical expert and consultant; Provided inputs for application design w.r.t. performance monitoring; Suggested best practices/recommendations for robust and scalable BI environment by communicating functional and technical issues.

• Lead a team of 3 people as lead analyst and provided additional technical training to team members; actively supported and practiced company policies and encouraged industry standard procedures; used Jira for project tracking and held daily scrums to monitor progress.

Zensar Technologies Pune, India

Software Engineer - Data Nov 2013-Feb 2016

• Worked on analytical projects based on pharmaceutical domain and Involved in building data pipeline using batch scripts, python scripts and workflow designing using Informatica; involved in data modelling and designing database schema for reporting.

• Troubleshoot issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software (common examples: nulls in data causing joins to function incorrectly; ETLs running out of sequence; MicroStrategy Objects not set up properly).

ACADEMIC PROJECTS

• Data Analysis with Python: Analyzed student enrollment dataset and performed necessary steps for Data Analysis process which includes – asking right questions, data wrangling, exploring and drawing conclusions; used Pandas and Numpy libraries; applied machine learning algorithms to compute predictions using Python scikit-learn library.

• Data Mining with R: Analyzed Online radio dataset and used association rule mining to recommend sales team about music users are likely to enjoy and buy; used Apriori algorithm and Arules library in R; Analyzed Flight Delay dataset and used its input features to predict whether a flight has been delayed by more than 15 mins by using classification algorithms like Decision Trees, Random Forest, SVM, KNN, Naive Bayes; measured performance by calculating accuracy, precision, recall and F-measure.

• Database Management System: Created a database model for PF Chang’s restaurant chain; designed flowcharts, DFD’s, UML, relational tables with necessary primary and foreign key relationships, indexes and created functionalities to aggregate data using scalar functions, view data using views and multi tabled valued functions, and write series of insert, update and deletes

(dml’s) using stored procedures.

ADDITIONAL INFORMATION

• Awards: Client Centricity for excellence in client services and customer experience (Zensar); Star Award for accomplishing deliverables in short time and Synergy Team Award for delivering an end to end application with zero defects. (InfoCepts)

Contact this candidate