# Nitika Dua

Nitika Dua is a remote worker on Himalayas, Data & Talent Analytics Consultant at Consilio Pvt Ltd, based in India.

Source: https://himalayas.app/@nitikadua

```text
Data analytics and workforce strategy lead at INTRICATE RESEARCH, building executive Power BI models and forecasting portfolios.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 140k+ INR |
| Job categories | Data Analytics Lead, Workforce Planning Analyst, HR Business Partner, HR Operations Specialist, People Analytics Manager |
| Skills | Data Analysis, Workforce Planning, HR Operations, People Analytics, Executive MIS Dashboards, Report Automation, Root Cause Analysis, Gap Analysis, Data Profiling, Recruiting Governance, Employee Lifecycle Management, Headcount Analysis, Recruitment Analytics, Talent Management, Financial Modeling |
| LinkedIn | https://linkedin.com/in/nitika-d--905713163 |

## About

```text
At INTRICATE RESEARCH, I build financial models, cost frameworks, and strategic forecasting portfolios in Excel and Power BI for executive decision support and client proposals. I also partner with executive leadership on workforce planning, hiring pipeline health, and skill-gap analysis.

At PUBLICIS GROUPE, I authored SQL queries and Regex patterns for data validation across SAP platforms and built automated dashboards for campaign KPIs and data-quality incidents. I led a team of 10+ members across resource allocation, SOP development, and performance governance.
```

## Experience

### Data & Talent Analytics Consultant

Consilio Pvt Ltd. Apr 2025 - Sep 2025

```text
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%.
```

Skills: Power-BI, Excel, Data-Profiling, MIS-Dashboards, Report-Automation

### Lead Analytics & Workforce Strategist

Intricate Research. Sep 2024 - Mar 2025

```text
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.
```

Skills: Excel, Power-BI, Financial-Modeling, Workforce-Planning, Forecasting

### Business Operations Lead & Analytics Manager

[Publicis Groupe](https://himalayas.app/companies/publicis-groupe). Nov 2021 - Aug 2024

```text
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.
```

Skills: SQL, Regex, SAP, Power-BI, Excel, KPI-Tracking, Data-Quality

### Analytics & HR Operations Team Lead

[Affinity X](https://himalayas.app/companies/affinityx). Oct 2020 - Oct 2021

```text
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.
```

Skills: Google-Sheets, Google-Apps-Script, Power-Query, Macros, Adobe-Analytics, Google-Ads, Recruitment, Onboarding

### Data & Recruitment Analytics Specialist

Omnicom Media Group. May 2018 - Sep 2020

```text
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.
```

Skills: Tableau, Power-BI, RCA, Gap-Analysis, Recruitment-KPIs, Talent-Acquisition

### Operations & Research Analyst

Entra Solutions (BSI Financial). Mar 2016 - May 2018

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

Skills: Market-Research, Analytical-modeling, Workforce-Planning, HRIS, Onboarding

### Data & HR Operations Associate

[Clarivate (CPA Global)](https://himalayas.app/companies/clarivate). Mar 2014 - Mar 2016

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

Skills: Excel, SQL, Data-Extraction, Headcount-Reporting, Employee-Lifecycle

## Education

### IMT CDL, Ghaziabad

PGDBM, Systems and Operations Management

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

### Guru Nanak Dev University

M.Sc., Computer Science

```text
Master of Science in Computer Science.
```

### Guru Nanak Dev University

B.Sc., Economics

```text
Bachelor of Science in Economics.
```

## Tech stack

- Tableau
- Adobe Analytics
- Google Sheets
- SQL
- SAP
- Google Ads
- Power BI

To contact Nitika, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Satadru Das](https://himalayas.app/@satadrudas): Senior Data Analyst, WinWire Technologies
- [SHASHANK SAI](https://himalayas.app/@shashanksaie): Senior Associate Business Intelligence & Reporting, London Stock Exchange Group
- [Pratheesh Raju](https://himalayas.app/@pratheeshraju): Analytics Manager, Technicolor Creative Studios Pvt. Ltd.
- [Vijay Kumar](https://himalayas.app/@vijaykumar25): Data Analyst, Rostan Technologies Pvt Ltd
- [shubhangi gupta](https://himalayas.app/@shubhangigupta2): Analytics and Modeling Specialist, Accenture Solutions
- [sarthak Mehra](https://himalayas.app/@sarthakmehra): Senior Executive – Human Resources (People Analytics & Reporting), Teleperformance Global Services
- [Satish Bhatt](https://himalayas.app/@satishbhatt28user): Employee Data & Advance Analytics Manager, Freshworks
- [srushti jagtap](https://himalayas.app/@srushtijagtap): Independent Analytics Consultant, Freelance
- [Mayur Jain](https://himalayas.app/@mayurjain1): Data Analyst, Randstad Offshore Pvt Ltd
- [Shubani Shubani](https://himalayas.app/@shubanishubani): Manager, PwC