Mallika Sinha

Factory Automation Analyst

John Deere•  May 2019 - May 2020

Data Analytics Projects: • Led multiple SQL, Tableau, VBA, and Python-based automation projects to reduce manual operation time, optimize data processing functions and generate reports • Examined the SQL database for the analysis of data collecting methods from TCMES based application • Integrated a python code for multiple models and stations in a TCMES based application to improve factory shutdown recovery time by 15.3% with one fundamental code • Created a Tableau based paint shop defect tracking dashboard, its SQL tables, and stored procedures to save 25% time on tracking defects • Created a VBA based paint load scheduling application for optimized scheduling with 20% manual time reductions • Designed SQL Reporting (SSRS) and Tableau dashboard for data visualization of the override data to track monthly progress and presented it to Factory Automation team Continuous Improvement Project: • Led Lean Six Sigma Black Belt project on reduction of mistake-proofing overrides for the camera and torque tool event through DMAIC, Gemba Walk, Cause-Effect Diagrams, and Statistical analysis • Identified Voice of the customer (VOC), Critical-to-Quality (CTQ) metrics and designed hypothesis to identify pain areas in the assembly-line • Performed chi-square test in JMP for variance analysis of defects across different workstations and mistake-proofing events (Camera & Torque Tool) • Recommended control actions by analyzing results from Minitab, statistical methods and conducting Failure Mode Effect Analysis (FMEA) thereby reducing overrides by ~20%, increasing throughput by 580 mins and saving of $90,000 • Collaborated Lean Six Sigma project from John Deere with IMSE Defense project to develop Corrective and Preventive Actions (CAPA) on highlighted causes like inventory control and data analysis • Fabricated automated quick data analysis tool using Python machine learning text analysis, VBA, drop down to solve comment interpretation issue in the Lean Six Sigma project • Proposed inventory control VBA application to improve ‘missing part’ causes by 15% observed in the Lean Six Sigma Black Belt project • Forecasted optimal level of inventory to reduce the override causes due to insufficient parts in the assembly line

Business Operation Associate

ZS Associate•  January 2018 - June 2018

• Delved in Business Intelligence and the basic concepts of Data management around a US pharmaceutical industry • Assessed and examined the weekly data in SQL Server Management Studio to provide analytical and statistical support to the client • Developed, maintained, validated, and released weekly reports on Tableau for the client which helps to formulate a business strategy to improve the efficiency of business reps and increase sales by 12% • Solved tickets raised by dashboard users with data-related queries • Created compelling user interactive dashboards with trends, slicer, and drill-downs in Excel with pivot tables and VBA • Collaborated with cross-functional teams for QC Validations, Impact Analysis, Data Quality Management Framework, Robotic Process Automation, Targeting & Segmentation, and Incentive Compensation