1. Coordinated with a Chinese vendor and business team to enable machine-specific real-time data integration into the MES SQL database.2. Developed a Data Lake in Databricks for the MES system of manufacturing plant, implementing a three-layer architecture: - Raw Layer: Established direct data ingestion from the MES SQL database with a pipeline refresh frequency of 15 minutes. - Intermediate Layer: Conducted data cleaning processes to ensure the storage of high-quality, garbage-free… Show more 1. Coordinated with a Chinese vendor and business team to enable machine-specific real-time data integration into the MES SQL database.2. Developed a Data Lake in Databricks for the MES system of manufacturing plant, implementing a three-layer architecture: - Raw Layer: Established direct data ingestion from the MES SQL database with a pipeline refresh frequency of 15 minutes. - Intermediate Layer: Conducted data cleaning processes to ensure the storage of high-quality, garbage-free data. - Model-Out Layer: Performed final data transformations and populated data according to business requirements.3. Coordination between Business and DE team to ensure data validation during the preparation of the data lake.4. Designed KPI dashboard wireframes using Figma for the manufacturing team, enabling real-time visualization of plant performance data.5. Engaged with cross-functional business teams to gather requirements and develop the BRD for data mapping, enabling the creation of a real-time plant performance dashboard6. Collaborated with the Power BI Team to develop a real-time plant performance dashboard, leveraging refined MES data through Direct Query methodology.7. Led daily cadences to track development progress and resolve conflicts between the development and visualization teams using Jira, while maintaining an agile approach.8. Developed Power Apps to streamline the recording of machine-wise cleaning time and enhance data accuracy and efficiency.9. Developed a Daily Generation Report app, using Power Apps, to streamline data recording processes for on-site personnel, improving efficiency and accuracy. Show less

- Real time plant performance dashboard preparation using Power BI- Data management and preparation of weekly, monthly & quarterly report - Data Handling of Plant Head, Manufacturing- Cap-EX Project Planning and Execution- Operating Cost per Wp calculation- Comparative analysis of different state solar policy- Electricity cost per Wp calculation for total factory and specific machinary to track the consumption rate.- Annual Budget data preparation.

-Responsible for managing whole Post Lam and Testing section. -Man power planning and optimization.-Responsible for daily 1.2 MW Production achievement to meet the Quarter Target.-Developed Team Performance Management Sheet, to get a detailed view of day to day target achievement.- Daily rejection trend analysis

-Responsible for daily production target achievement-Manpower utilization-Rejection analysis-Reduction of unplanned consumption-PV solar module calibration-Line throughput calculation based on different variant of modules

Worked on Through put Yield of Production and Cell Yield using Six Sigma.

Project done on Manufacturing Processes and Spare manufacturing.

Basic training on Power Plant and Improvement of Coal Feeding system for saving raw material consumption.