Badges
Certifications
Work Experience
Analytics Engineer II
First Solar• June 2018 - Present
Develop reporting and analytics using Tableau and SQL along with data sources like SAP, Salesforce, and Primavera Metrics development & Statistical analysis (forecasting, ANOVA, t-tests, factor analysis etc.) using SAS to capitalize on improvement opportunities independently and without appreciable direction Build predictive models (classification, regression, clustering) as appropriate to support business objectives in R Develop and optimize complex SQL queries to reduce processing time and prepare datasets for analysis Stimulate management thinking by creative solutions, challenge conventional wisdom by demonstrating the successful application of new methodologies and support continuous improvement Accomplishments Optimized data-source SQL queries and reduced the processing time of +20 minutes to less than 2 minutes Implemented automated reporting of project physical progress at a site with the help of drones which counted the product installation. Monitored Drone output for 8 weeks and improved accuracy from 67% to 100%. This leads to a reduction in manpower required at the site for reporting purposes. Automated SSRS (SQL Server Reports) delivery to the client on a monthly basis. Found a quick solution to generate service reports of fifteen months involving thousand plus work orders. This saved several weeks’ of time for the team Created a centralized search tool “Material Master Search” that saved 60% of the time each time the team searches an item, from thousands of items in SAP. This saved hundreds of hours’ time and cost on licenses for using SAP by other team members Developed a monitoring tool “Task Tracker” using SQL and Tableau that allows a user to input hard stop/constraint date to understand if a schedule needs to be accelerated and give the ability to non-schedulers to plan construction proactively. Created a Monte Carlo simulation in excel that analyzes risks and opportunities involved in a project cost by simulating thousand test scenarios and highlighted maximum risk exposure in dollar value with contingency gap Saved 50 hours of tableau users and, hence several hours overall in 200 reports by transforming, indexing and cleaning up 77% tableau reports in the company while retaining all the information
Analytics Consultant
Larsen & Toubro• July 2012 - July 2017
Generated actionable insights for different projects and clients using Tableau and other visualization tools Forecasted monthly cost, sales and profit using time-series analysis, moving average methods and regression Developed dashboards for project status, critical resources using Tableau & improved departmental performances Developed a forecasting tool that provides weekly need to fulfillment manager to proactively schedule item delivery Handled L&T’s in-house DBMS (EIP) for Order Inflow, Forecasting, MIS, Project Planning, SCM and Work orders Resolved multi-million USD certification issues for client payment through delay analysis using advanced excel, resulted in 0.5% of cost-saving Created Tableau dashboards that tracks status (On-track/Delayed/Need-to-expedite) of various development activities on a project & portfolio level. This promoted proactivity and accountability of project tasks from development to execution and avoided project delays
Education
Arizona State University, Tempe
Business Analytics, MS• August 2017 - May 2018
Courses studied: Enterprise Analytics, Marketing Analytics, Data Mining I & II, Data-driven Quality management, Applied Analytics, Analytical Decision Modelling, Business Analytics Strategy, Corporate Project
Jai Narain Vyas University
Electrical Engineering, BE• August 2008 - June 2012