Data Analyst

Nikita Urunkar

San Jose, CA

******.*******@*****.*** +1-657-***-**** linkedin.com/in/nikita-urunkar/ github.com/nikitaurunkar

PROFESSIONAL SUMMARY

Passionate, result-oriented Analyst with proficiency in interpreting data, analysing results using statistical techniques

Ability to translate business questions into structured analysis and data analytics into business insights

Excellent understanding of data collection systems and ability to make data-driven decisions

Proven communicator and a team player, with strong interpersonal ability and well-defined problem-solving aptitude

Work closely across the matrix with teams like Finance, Marketing, Product, Engineering and senior executives

STRENGTHS AND EXPERTISE:

Strengths: Data Visualization, Statistical Data Analysis, Marketing Analysis, Business Analysis

Skills: Power BI, CRM Dynamics, Prism, Tableau, SQL Server, MS Visio, R Studio, Excel, Google Analytics, EDI, ERP systems

Certifications: SQL for Data Science, PostGre SQL, Introduction to R, Udemy Certified: Advanced Tableau, Data Science and Machine Learning with R

EDUCATION

MS in Information Systems, Business Analytics, California State University, Fullerton (GPA: 3.56) May 2018

Bachelor of Engineering in Electronics and Telecommunications, University of Pune (GPA: 3.5) May 2016

PROFESSIONAL EXPERIENCE

Business Data Analyst at Santa Monica Seafood August 2018-Present

Technology Stack: PowerBI, Advanced SQL, Advanced Excel, ERP, EDI, MS Visio, DAX, Plytix, Cognos

Responsible for creating/maintaining complex SQL queries, custom queries, views and stored procedures

Generated BI Reports, insights and produced visualizations in PowerBI to help in decision making for senior management

Participated in Product Brainstorming and helped to draw conclusions for managerial actions and strategy

Executed projects using Agile methodology, participated in sprint planning, daily scrums, retrospectives and sprint reviews

Collaborated in writing test plans and analysis for A/B, multivariate testing of marketing campaigns

Identified customer conversion KPIs and trends using Google Analytics, Power BI

Designed the ETL system for the IOS and Android App launch using Product Information management tool Plytix

Data Science Analyst at Futuredontics Inc. Feb 2018 – August 2018

Technology Stack: PowerBI, Microsoft Dynamics, R Studio, SQL, Advanced Excel, Prism CS, JIRA

Performed ETL from data sources like Prism CS, Microsoft Dynamics CRM and SQL and built exec-facing dashboards

Designed, developed and produced Ad Hoc reports in Power BI using DAX and SQL

Implemented production-level code for various reports using R and SQL and scheduled them to execute periodically

Increased code efficiency for report like Market Intelligence Report which made the execution faster by 4 hours

Wrote and optimized complex SQL queries to perform data extraction and merging

Automated the process to fetch outdated entries from SQL and prepared excel reports to identify discrepancies in R

Assisted in entering and updating project issues (Stories and Tasks) onto JIRA agile application.

Graduate Assistant (Data Analyst), California State University, Fullerton Dec 2016 - Feb 2018

Technology Stack: Microsoft Office Suite, SQL, Power BI, Pivot Tables and VLOOKUP

Carry out Data Integrity checks, data cleaning and maintenance using Excel and Power BI

Analyzed data using statistical techniques to identify trends that drive data-based decision making

Documented existing business processes and analysis reports, created ER diagrams in MS Visio

Developed data models for budget optimization using Advanced Excel (Pivot table, VLOOKUP, Macros)

ACADEMIC PROJECTS

Attrition and performance of IBM HR Analytic Employee: XL miner, Tableau Aug 2017 - Dec 2017

Performed data pre-processing by testing for outliers, data partitioning and correlation analysis.

Deduced results based on logistic regression, K-Nearest Neighbour (KNN) and classification trees.

Recommended solutions to improve the performance of the employees and used advanced Tableau to present a Storyline

Supply Chain management system: Advanced Excel, Solver Aug 2017 – Dec 2017

Forecasted demand and capacity management decisions using aggregate planning

Formulated statistical model to determine optimal production capacity and demand management

Based on the results took operational decisions which resulted in profit of $7 million

Digital marketing campaign for Restaurant in Buena Park, CA: Excel, AdWords, ESRI, Google Analytics May 2017 – Aug 2017

Participated in Google AdWords Campaign to create 5 ad groups, 32 ads, 163 keywords.

Generated 24000 impressions and achieved the target CTR of 2.7%.

Used Google Analytics, Tableau to analyse and visualize the reports and present the findings of the campaigns

Contact this candidate