Atul Watal ******@***.***
**** ****** **, *** ***, Santa Clara, CA 95051 480-***-**** https://www.linkedin.com/in/atulwatal
SUMMARY:
Over six years of experience in Operations, working on large complex data sets. Proficient in application of Analytics in process improvement and in guiding business decisions using quantitative and modelling techniques. Seeks a role as a Data Analyst to leverage passion for data driven decision making.
EDUCATION:
Master of Science in Business Analytics, 3.90 / 4.00 GPA May 2016
W.P. Carey School of Business, Arizona State University
Bachelor of Engineering October 2008
K.D.K College of Engineering at R.T.M. Nagpur University, Nagpur, India
PROJECTS:
SPARC- Tempe Police, AZ January 2016 – May 2016
Created crime dashboards using Tableau. Extensively used Analytical functions in MySQL. Improvised crime metrics to analyze police performance and crime. Performed predictive analysis by evaluating trends and patterns in crime using machine learning algorithms and ARIMA model for crime types, location, and temporal factors.
Restaurant Revenue Prediction Model October 2015 – December 2015
Applied concepts of marketing analytics to generate revenue prediction model in R and secured first rank in Kaggle. Created data visualizations using ggplot package in R.
A.S.U. Healthcare Process Improvement August 2015 – December 2015
Identified key issues using Factor Analysis, developed predictive models for referral system process improvement with accuracy of 84% using machine learning algorithms in R and Azure ML.
Six Sigma Process Improvement Projects April 2009 – August 2015
Six Sigma Green Belt - Certified by Indian Statistical Institute
Applied DMAIC methodology and extensively used statistical quality control techniques, D.O.E., hypothesis testing, and regression analysis for multiple six sigma quality improvement projects while working for MPP Tech. Pvt. Ltd.
PROFESSIONAL SKILLS:
Descriptive/ Predictive Analytics
Tableau
Advanced Microsoft Excel
Microsoft Access
SPSS Modular
Forecasting
Statistical Analysis
SQL
Hypothesis Testing
SAS
R/Python
Minitab
ANOVA/Regression Analysis
Data Mining
Microsoft Azure ML
Project Management
A/B testing
ETL
PROFESSIONAL EXPERIENCE:
Lead - Operations Analyst November 2011– August 2015
MPP Technologies Pvt. Ltd. – Bangalore, India
Analytics:
Designed dashboards in Tableau to monitor product failures to help maintain process at six sigma level.
Reported daily KPIs using SQL queries and Minitab for throughput, capacity utilization, yield, turns, and others.
Extensively used Advanced Microsoft Excel functions, Pivot tables, and lookups to understand trends and seasonality for forecasting demand, predicting revenue, and developing product mix.
Championed inventory and transportation optimization initiatives using simulation modeling by partnering with replenishment analysts, translating into 4% savings for $1.2 million annual business to S. America.
Developed business models for marketing and revenue generation using classification, regression, and clustering algorithms with the help of Scikit Learn library in Python.
General Operations and Supply Chain:
Analyzed data for insights to help formulate business strategies and portfolio offerings as per customer and market risk profiling. This lead to Increase in sales from $2.7 million to $7 million in four years.
Established product costing using SAP-SD and monitored KPIs for cost, procurement, delivery, and others.
Reduced operational cost from 24% to 18% between 2011 to 2015 by working with internal and external supply chain partners for process improvement, cost reduction, and quality assurance.
Extensively used SAP BI reporting tools to monitor production process, reduce defects, and improve productivity.
Planning Engineer April 2009 – November 2011
MPP Technologies Pvt. Ltd. – Bangalore, India
Controlled production variance within 6% by developing production operations Excel spreadsheet models.
Optimized plant maintenance and manpower scheduling using spreadsheet forecasting models.
Reported daily KPIs using SQL queries and Minitab for throughput, capacity utilization, yield, turns, and others.