Pawan Singh Kapkoti
Data Analytics Team Lead
Hire this person
Send a job offer directly to this candidate
About
Data Analyst and a Team Leader with an MSc in Data Analytics and hands-on experience building production analytics and ETL pipelines in a food manufacturing environment. At Copernus, worked extensively with SQL Server and Aptean SI-ERP to deliver yield, giveaway, weight variance, and batch traceability reporting. Built SSRS reports and Power BI dashboards for operational, quality, and complaint analysis.
Experienced in forward and backward traceability, HACCP and BRCGS compliance, product labelling, and role-based access for report delivery. Strong in SQL, Python, dbt, and Power BI.
Experience
Data Analytics Team Lead at Copernus (2025-04 – 2026-07)
- Produced and maintained detailed SRS reports from Aptean SI-ERP data for operational, production, and management reporting.
- Utilized Aptean SI-ERP and SQL Server extensively to query and analyze manufacturing data across a comprehensive ERP landscape.
- Supported batch traceability and product history reporting to ensure food safety, audit readiness, and compliance adherence.
- Applied knowledge of food manufacturing processes in alignment with HACCP principles and BRCGS food safety standards.
- Analyzed yield, giveaway, weight variance, and production metrics by department, shift, and product using advanced SQL Server queries.
- Developed incremental ETL processes keyed on ERP run numbers, loading data into rigorously tested dbt marts for yield, product mix, shift productivity, quality, and temperature breach reporting.
- Managed and enhanced Power BI dashboards addressing product complaints and consumer feedback, driving continuous improvement efforts.
Education
MS/M.Sc in Computers – Aston University, Birmingham (2024)
B.C.A. in Cloud Computing – Amity University (2022)
12th in CBSE, English (2018)
10th in CBSE, English (2016)
