Ankit Singh

About Ankit Singh

As a Business Most analysts give you data. I give you the decision.Analyst at Penguin International (Gurugram), I own the full analytics lifecycle — from designing ETL pipelines that pull from 20+ fragmented data sources, to building Power BI dashboards that collapsed C-suite reporting from hours to under 10 minutes, to embedding predictive models that shift planning from rear-view to forward-looking. My toolkit: • Data engineering: ETL pipelines, BigQuery, SQL, Python (Pandas, NumPy, Scikit-learn)• BI & visualisation: Power BI (DAX, drill-throughs, slicers), Tableau, Advanced Excel• Analytics: EDA, regression, time-series forecasting, K-Means segmentation, predictive modelling• Business: KPI design, stakeholder reporting, market intelligence, data storytelling for non-technical audiences Before my current role, I interned at Labmentix (Delhi), where I cleaned records, built DAX-driven Power BI dashboards, and identified pricing drivers in the Dubai housing market that fed directly into a market entry feasibility study.My projects span FMCG demand forecasting, retail customer segmentation, and Netflix content strategy analysis — each built end-to-end and documented on GitHub. Credentials: EY Business Analytics · Google Data Analytics Professional Certificate · IIM Ahmedabad Pre-MBA Statistics · Accenture Data Analytics & Visualisation Simulation · I\'m actively exploring roles in Business Analytics, Marketing Analytics, and Consulting where I can combine data fluency with strategic business thinking.Let\'s connect if you\'re hiring for BA, analytics, or consulting roles — or if you want to talk FMCG data, Power BI architecture, or predictive models.

Experience

1. Business Analyst

   Penguin International

   Mar 2026 — Present · Gurugram, IN

   Redesigned data ingestion architecture across 20+ fragmented market sources, reducing reporting errors by ~30% and freeing ~8 hrs/week of analyst time — enabling the strategy team to shift from reactive reporting to forward-looking scenario planning.• Built an executive-facing BI suite (3 interactive dashboards, 10+ KPIs) that collapsed leadership reporting cycles from 4+ hours to under 10 minutes, directly accelerating two quarterly strategy decisions via real-time pipeline and market visibility.• Authored quarterly market intelligence briefs consumed by C-suite across 3 business units; embedded regression and time-series signals to shift planning from historical review to 8-week forward projection.• Applied AI-driven trend analysis to surface early-warning signals on competitor pricing and market share shifts, informing proactive adjustments to commercial strategy.Stack: Python (Pandas, NumPy) · SQL · Power BI (DAX, slicers, drill-throughs) · ETL pipelines · BigQuery · Advanced Excel

Education

• Institute of Management Studies (IMS) Ghaziabad - Business School

  PGDM, Business Administration and Management, General