Nitika Dua

Built interactive MIS dashboards in Power BI and Advanced Excel tracking business unit productivity, utilization, cost structures, and data profiling metrics. Automated reporting pipelines, reducing manual effort by 30%.

Built dynamic financial models, cost frameworks, and strategic forecasting portfolios in Excel and Power BI for executive decision support and client proposals. Partnered with executive leadership to define workforce planning requirements and analyze skill gaps.

Authored complex SQL queries and Regex patterns for data validation across SAP platforms. Built automated Power BI and Excel dashboards for post-campaign KPI tracking and data quality incident monitoring.

Automated monthly billing reports, vendor scorecards, and conversion dashboards using Google Sheets (App Scripts, Power Query, Macros) across Adobe Analytics and Google Ads. Coordinated recruitment execution, interview scheduling, and candidate onboarding experiences.

Developed Tableau and Power BI dashboards to track cross-channel marketing performance; executed Root Cause Analysis (RCA) and GAP analysis on enterprise data elements. Tracked recruitment KPIs, early turnover trends, and talent acquisition efficiency metrics.

Built corporate market research portfolios and analytical models while supporting workforce planning, HRIS recordkeeping, and joiner onboarding documentation.

Extracted and structured large IP/M&A datasets in Excel and SQL while assisting HR operations with headcount reporting and employee lifecycle records.

Post Graduate Diploma in Business Management with a focus on Systems and Operations Management.

Master of Science in Computer Science.

Bachelor of Science in Economics.