QlikSense
Senior Manager
Data Analytics Solutions:
- Leveraged Outbound Truck Route data to optimize and generate monthly cost savings of $24,123, providing valuable business insights to Sales Logistics domain
- Implemented 15 predictive analytics solutions using data from IoT sensors, motors, and drives, resulting in significant reduction of breakdown minutes by 300 minutes per year
- Conducted in-depth analysis of robot 6-axis load data and modeled time series forecast to predict potential failures, saving 8 hours of downtime
- Delivered integrated and actionable insights on data from vehicle filling equipment's, resulting in elimination of key quality and hidden issues, saving 60 cars per year
Data Visualization:
- Deployed 25 Qlik BI Dashboards, delivering insights to key users and management across diverse domains, resulting in daily manual analysis work savings of 3+ hours
- Implemented RPA solutions using global defect data, performing correlation analysis, and achieving 1% reduction in overall defect ratio, enhancing product quality
- Delivered dashboard KPIs, heat maps, and actionable insights on enterprise energy utilization, leading to substantial savings in energy (KWH) wastage of $4500 per month
Data Engineering:
- Extracted data from sources, including sensors, PLCs, MES, ERP (SAP), EAI systems, to develop business intelligence models for real-time reporting and analysis
- Automated ETL process to ingest near real-time data schedules into SQL databases using Python
- Established ETL log monitoring solution for all programs handled by team, optimizing server and database resources
- Extracted, scheduled, and published data for 130 Qlik BI applications, ensuring seamless operations
Leadership and Project Management:
- Collaborated with stakeholders and shop engineers to implement dedicated IoT 4.0 infrastructure across plant (7 shops)
- Strategically managed capital budget and projects, leading to 10% reduction in overall expenditures
- Performed shop floor digital transformation initiatives, including Virtual Reality (VR) and paperless solutions
- Led team of 5 members to execute diverse analytics solutions, manage IoT and drive digital transformation initiatives
- Spearheaded Verna Car Project from Proto Stage to SOP, managing cross-functional teams and addressing quality and design issues
Future Focus and Achievements:
- Key role in securing prestigious "Frost Sullivan IMEA Smart Factory of Year Award" from 2020 to 2022, achieving No.1 rank
- Formulated detailed roadmap for establishing Global Lighthouse factory and served as SPOC for IoT implementation
Shop Floor Implementations & Projects:
- Implemented digital solutions including connectivity of electric tools, part traceability, pallet RFID, Digital Work Instruction for 100+ Assembly stations, and diverse digital transformation projects
- Achieved over 99% shop efficiency through projects like Auto Scanning, Poke yoke, and automation
Process Engineering and Standards:
- Managed engineering documents, including work standards, part identification sheets, process sheets, other ISO requirements
- Managed main line TCF, Sub Line Systems, and departmental KPIs, optimizing manpower, HPV, WIP, and profitability targets
- Engaged in job allotment based on process scrutiny, input ratio, and manpower utilization
Overseas Projects
- Led six new car and face-lift projects, resolving design challenges, trials in S.Korea, and surpassing targets by over 95% since SOP
- Played key role in establishing Disassembled knock down car project at Algeria plant and providing training to Myanmar DKD