Manager/Lead – Reporting at Omnicom Global Solutions (2023-12 – 2026-06)
Led end-to-end BI and AI initiatives across social media, marketing, influencer, survey, and advertising data for tier-1 global clients including PepsiCo, VW, RBI, and Audi.
- Engineered high-impact Power BI, Tableau, Looker, and Datorama dashboards tracking critical CPC, CTR, ROI, reach, and engagement metrics, leveraging Figma to replicate high-fidelity UI/UX designs.
- Integrated GenAI, Copilot, and Genie AI to embed intelligent insights into BI reports and web apps; analyzed GenAI usage feed data (cost, query runtime, prompt counts) to optimize performance.
- Built robust SQL queries, scripts, and ETL pipelines using dbt, BigQuery, Fabric Dataflow Gen2, Control-M, DAX, and Power Query.
- Owned end-to-end BI project delivery using Scrum and Agile methodologies; authored comprehensive BRDs, FRDs, user stories, acceptance criteria, and RAID logs.
- Secured dashboard deployments using SSO, REST APIs, and Azure token management; automated KPI alerting and refresh workflows via Power Automate and Power Apps.
Technical Lead (BI & Cloud) at Netsmartz (2022-08 – 2023-12)
- Connected directly to Dynamics 365 application modules to extract and model healthcare (Caresmartz360) and telecom (Acumen360) data into Power BI, Qlik, and Tableau reports.
- Built scalable ETL data pipelines and complex SQL scripts utilizing AWS Lambda, Azure SQL, Databricks, and Python.
- Embedded Power BI reports into external web applications and CRM platforms (Liferay) using secure tokens and JavaScript to boost user adoption.
- Established incremental refresh cycles, configured on-premises gateways, and implemented Row-Level Security (RLS) and SSO to optimize data security and report performance.
- Gathered client requirements and translated them into actionable FRDs, BRDs, and FSDs, managing automated notifications via Power Automate.
Business Data Analyst at Dalmia Bharat Group / Hippo Stores (2021-09 – 2022-02)
- Directed a 13+ member cross-functional team across data, engineering, and digital media to deliver high-priority, time-bound data products.
- Coordinated statistical data analysis and design flows, establishing robust KPI frameworks and retail data warehousing structures.
- Managed ETL operations from SAP HANA using PostgreSQL into Power BI datasets; leveraged AWS services (RDS, Lambda, S3, Glue) to generate live operational reports.
- Utilized DAX, Python, and advanced SQL queries to support real-time retail, sales, product, and warehouse inventory transactions.
- Managed international and domestic client projects, vendor onboarding, contract negotiations, software licensing (Power BI, G Suite, MS 365), and AWS billing scalability.
Senior Analyst at Simpli-Home.com / CCT GLOBAL (2017-09 – 2021-09)
Managed financial operations and reporting for $4M–$7M in sales across major e-commerce channels including Home Depot, Target, Walmart, and Amazon.
- Developed data modeling layers, predictive modeling, and statistical forecasting frameworks in Power BI and Tableau to minimize manual reporting and anticipate market trends.
- Supervised data governance and QA processes (Maple); handled high-level customer escalations, chargebacks, credit card fraud, and supply chain losses, compiling detailed incident reports.
Analyst at Namshi.com / EMAAR MALLS (2014-09 – 2017-09)
- Delivered financial and inventory reporting covering pricing, promotions, demand forecasting, warehouse capacity, and revenue modeling.
- Identified low-performing sales sectors, financial losses, and high product return rates; presented summarized data findings directly to senior stakeholders and account holders.
- Successfully migrated legacy Excel reports and static dashboards into dynamic Power BI and Tableau environments using BigQuery, SQL, SharePoint, and Python.
Technical Support at Ramy Infotech (2014-02 – 2014-08)
- Executed SQL queries to pull precise target datasets from databases to generate structural P&L reports in Excel and CSV formats.
Web Application Support at Corbus India LLC (2012-10 – 2014-01)
- Utilized Python (Pandas, NumPy) to build lightweight ETL processes, outputting structured reports via Excel, CSV, Pivots, and VBA.
