Shubham

Data Analyst with 3+ years of experience in Manufacturing and Automotive sectors, specializing in converting ERP data into actionable insights. Proficient in Excel (Advanced), Power BI (DAX, Power Query), SQL, and Python — independently built 8+ live dashboards, automated MIS workflows, and delivered cross-functional reports to senior management. Hands-on with Finsys ERP and GDMS 2.0 for multi-module data extraction.

Completed

Masters in Data Science with Big Data Engineering from ConsoleFlare, Noida — trained in Python, PySpark, Azure, and ML.

MIS Executive | Data Analyst - Livpower Tech International LLP - Sonipat, Haryana

(2025-10)

• Independently managing end-to-end departmental MIS reporting across Sales, Finance, and Operations — consolidating multisource data into unified dashboards for senior management.
• Designed real-time Power BI and Google Looker Studio dashboards providing live visibility into revenue trends, operational KPIs, and department-wise performance metrics.
• Built automated reporting workflows using Google Apps Script, eliminating manual data entry and reducing weekly reporting effort by ~40%.
• Sole analytics owner — architected complete reporting infrastructure from raw data extraction to final dashboard delivery without external support.

MIS Executive | Data Analyst - Swastik Polyvinyls Pvt. Ltd. - Kundli Industrial Area, Sonipat, Haryana

(2024-07 - 2025-09)

• Built 8-year Supplier-wise & Item-wise Raw Material Purchase Analysis in Excel/Power BI — directly used by procurement for vendor negotiations and strategic planning.
• Designed RM Inventory Dashboard (Google Sheets + Apps Script) with live stock levels, consumption trends, and automated low-stock alerts — fully replaced manual stock registers.
• Created FIFO-based Payment Adjustment System auto-matching incoming payments against oldest invoices, eliminating reconciliation errors across 100s of transactions.
• Built Monthly Rate Comparison Report tracking price fluctuations across 15+ suppliers — enabled data-driven procurement negotiations.
• Designed Fuel & Electricity Costing Sheet calculating per-kg production cost — contributed directly to energy wastage reduction.
• Extracted data from Finsys ERP across 5 modules (Sales, Purchase, Finance, Store, Production) into unified cross-departmental MIS reports.

MIS Executive | EDP & Sales Coordinator - Malwa Autosales Pvt. Ltd. (Hyundai) - Kundli Industrial Area, Sonipat, Haryana

(2022-02 - 2024-06)

• Managed data operations in GDMS 2.0 (Hyundai DMS) — invoice generation, billing documentation, and Hyundai compliance reporting.
• Prepared daily, weekly, and monthly sales and finance MIS reports; analyzed customer inquiry sources to optimize sales team follow-ups.
• Tracked vehicle delivery pipeline data, coordinating with insurance partners for 100% on-time documentation completion.

Bachelor of Business Administration (BBA) - General Management - Gateway Institute of Engineering and Technology (2020 - 2023)

Senior Secondary - Commerce with Mathematics - Ujjwal Senior Secondary School (2019 - 2020)