Karan Singh

Results-driven Logistics & Supply Chain Data Analyst with 4+ years of experience in Warehouse Management Systems (WMS), supply chain analytics, ERP/SAP integration, and data-driven process optimization. Strong expertise in SQL, Oracle, ETL pipelines, API integrations, and Power BI dashboarding. Proven track record of improving inventory accuracy, warehouse efficiency, and executive decision-making in high-volume logistics environments.

Data Analyst at Jobuss Resources Pvt. Ltd. (Present)

• Designed and developed advanced SQL queries using JOINs, CTEs, Window Functions, Views, and Aggregate Functions to analyze large operational datasets.
• Built interactive Power BI dashboards with DAX measures, drill-through reports, bookmarks, and KPI scorecards for executive reporting.
• Used Python (Pandas and NumPy) for data cleaning, validation, transformation, and automation of reporting processes.
• Optimized SQL queries and reporting workflows, reducing dashboard refresh and report generation time.
• Automated recurring MIS reports using Power Query and SQL, minimizing manual effort and improving report consistency. Created dashboards to monitor Inventory Turnover, Dispatch Accuracy, Warehouse Productivity, OTIF, Fill Rate, and SLA Compliance.
• Performed root cause analysis on inventory discrepancies and logistics performance issues, providing data-driven recommendations.
• Collaborated with warehouse operations, supply chain, and business stakeholders to gather reporting requirements and deliver analytical solutions.
• Supported ERP/SAP data integration and ensured accurate synchronization of warehouse operational data.
• Maintained data quality through validation, reconciliation, and exception reporting to improve business confidence in analytics.

Service Support & Project Development – WMS at Godrej Koerber Supply Chain Ltd (2022-03 – 2024-08)

• Led enterprise WMS implementation projects by gathering business requirements, designing warehouse process flows, and integrating ERP systems using REST/SOAP APIs.
• Developed complex SQL/Oracle solutions for multi-million-row datasets, automated warehouse operations, and improved inventory accuracy, reporting performance, and SLA compliance.

Data Analyst Intern at New Global & Top Mentor (2023-06 – 2023-12)

• Built KPI dashboards in Power BI for operational monitoring.
• Improved SQL data pipeline efficiency by 30%.
• Automated monthly reporting, reducing manual workload by 40%.
• Proficient in data validation, reporting automation, and performance analysis using Microsoft Dynamics 365, SQL, and Power BI.

Bachelor of Science in Information Technology – Thakur College of Engineering, Mumbai University (2018)