Lean Six Data Analyst

AYUSH BHARGAVA

Sunnyvale, CA 804-***-**** **********@*****.*** http://www.linkedin.com/in/ayush17/

EDUCATION

Virginia Commonwealth University, Richmond, USA Aug 2019 - May 2020

Master of Decision Analytics

Relevant Courses: Statistical Analysis & Modeling, Business Process Re-engineering, Analysis & Design of Database System, Data Centric Re-engineering, Management Science

Christ University, Bangalore, India May 2018 - May 2020

Master of Business Administration in Lean Operations and Systems

Relevant Courses: Enterprise Resource Planning, Business Intelligence & Analytics, Management Science

Ramdeobaba College of Engineering & Management, Nagpur, India

Bachelor of Engineering in Industrial Engineering

Relevant Courses: Database Management System (SQL), Operations Research

Jun 2013 - May 2018

TECHNICAL SKILLS

Programming Language:

Database:

Analytical Tool:

Framework:

Cloud:

Other Skills:

Python, SQL, R

MySQL, Microsoft SQL server

Tableau, Power BI, Excel, Google Sheets, Google Docs, Word

Pandas, NumPy, R Shiny, Matplotlib, Scikit-Learn

Amazon Web Services

Agile Methodologies, SDLC, Six-Sigma

WORK EXPERIENCE

Virginia Commonwealth University, USA Aug 2019 – May 2020

Data Analyst

•Extracted, interpreted and scrutinized data received in CSV format using MySQL for gaining meaningful data insight and data warehousing.

•Reduced redundancy in the Business Processes data file by approx. 30% using SQL queries to remove duplicate entries.

•Analyzed the databases using Python involving scripting and working with numpy, pandas, scikit to which increased accuracy by 70%.

•Performed system analysis, reporting dashboards and visualizations using Tableau to highlight growth difference.

•Changes made by conducting process mapping at a depth of 3 levels to smooth out the process.

Innoverro Capital, India Jun 2019 – July 2019

Business Analyst

•Delivered assistance and solutions to top management by analyzing data and locating pain points.

•Handled large amount of client data using analytical tools like Tableau, Excel, MINITAB and SPSS.

•Scripting in Python using pandas, matplotlib and scikit for effective visualizations and statistical analysis.

•Created Tableau dashboards involving multiple data sets.

Just Energy, India Apr 2019 – May 2019

Lean Six-Sigma Consultant

•Six-Sigma Green Belt project to improve completion rate in UK billing department using DMAIC approach.

•Improved completion rate by 8% from current levels.

•In-depth analysis of the process involving process mapping, root cause analysis, 5-whys, FMEA.

•Determined impact of given solutions using Control-Impact matrix.

•Developed a control plan to ensure consistency in the process.

•Use of conventional tools like VOC, SIPOC.

CERTIFICATIONS

•Lean Six Sigma Green Belt by KPMG.

Contact this candidate