Kalpana Salaria

Business Analyst

Gurgaon, Haryana, India10 yrs 10 mos experience

Highly Stable

Key Highlights

Over 10 years of experience in data technology.
Expert in data analysis and visualization.
Proficient in advanced data solutions and automation.

Stackforce AI infers this person is a Data Analyst specializing in MarTech with strong capabilities in data governance and business intelligence.

Contact

Skills

Core Skills

Data AnalysisData VisualizationData ManagementQuality AssuranceData GovernanceCampaign ManagementBusiness IntelligenceData Processing

Other Skills

Power QueryExcel DashboardingSQLKnack databaseSharePointData ModelingCloud-based Planning ToolsGoogle BigQueryLooker studioLuminaDV360CM360Campaign FrameworkMicrosoft Power BIPower Pivot

About

With over 10 years of experience in the data technology space, I am passionate about transforming complex data into actionable insights that drive business growth and efficiency. As a Senior Data Technician, I specialize in utilizing a wide range of tools and platforms including Advanced Excel, Power Query, BigQuery (Google Cloud), Looker Studio, Python, and Power BI to deliver high-quality data solutions. My expertise lies in data analysis, data visualization, and automating data processes to provide impactful business intelligence.

Experience

10 yrs 10 mos

Total Experience

3 yrs 10 mos

Average Tenure

3 yrs 1 mo

Current Experience

Publicis global delivery (pgd)

2 roles

Senior Data Technician

Promoted

Nov 2024 – Present · 1 yr 6 mos · Gurugram, Haryana, India · Hybrid

Project - M-Dynamic - DMPT
As part of the DMPT initiative, I work on developing and maintaining advanced data solutions for global clients to support future-ready media planning through the M-Dynamic platform.
Key Responsibilities:
1: Manage and maintain client-specific dynamic media templates, ensuring data accuracy and consistency across planning cycles.
2: Utilize Excel, Power Query, SQL, Knack database and SharePoint to automate data flows, integrate complex datasets, and streamline reporting workflows.
3: Customize and enhance planning tools using the Knack Builder platform to support real-time data access and flexible planning for cross-functional media teams.
Support core components of M-Dynamic:
➤ Cloud List Management – Ensuring up-to-date data syncs across platforms.
➤ Dynamic Media Planning – Supporting flexible, scalable campaign strategies.
➤ Custom Planning Applications – Designing tailored tools to fit specific client needs.
Coordinate with client stakeholders and internal developers to ensure alignment with global media planning requirements, especially for brand-specific campaigns (e.g., COTY, Nestle, Adobe, Electrolux, Essity, Tork).
Identify inefficiencies in existing tools or processes and recommend solutions through data modeling, dashboarding, and optimization.
Ensure seamless integration of media strategy, performance tracking, and budgeting modules across multi-brand and multi-region setups.
Technologies Used:
Power Query · Knack · SharePoint · Excel Dashboarding · Data Modeling · Cloud-based Planning Tools.

Power QueryExcel DashboardingSQLKnack databaseSharePointData Analysis+1

Quality Assurance Specialist

Apr 2023 – Nov 2024 · 1 yr 7 mos · Gurugram, Haryana, India · Hybrid

Project 1: META
Maintain all Pre and Post campaign data and exporting Lumina, DV360, CM360, Trade Desk, LinkedIn data from Titan Dashboard and then comparing it into the Campaign framework.
Responsible to maintain Big Query in data, in which I have to upload data from Big Query to Looker and work on the dashboard according to clients' requirements.
Project 2: META B2B
Responsible for push the leads to the converter dashboard for all media partners and deliver weekly meta media pacing reports to all the media channels and partners.
Project 3: DISNEY PLUS
Was responsible for QA all the invalid and incorrect label properties in all the platforms through Emplifi Dashboard.

Google BigQueryLooker studioLuminaDV360CM360Data Management+1

Publicis sapient

Data governance analyst L2

Jun 2022 – Apr 2023 · 10 mos · Gurugram, Haryana, India

Project: Campaign Framework
CAMPAIGN : Build activation campaigns for trafficking
Generate taxonomy strings at the advertiser, campaign, package, placement, ad set, line item, and insertion order hierarchy levels
Locate errors in the taxonomy workbook before trafficking the campaign
Download a formatted taxonomy workbook to use for trafficking
CONFIGURATION : Build client dictionaries
Add client-specific data keys and values
Map data key values to inform conditional relationships
Configure platform taxonomies at different hierarchy levels
Assign data keys as metadata
CREATIVE : Enter creative names by completing pre-defined fields with selections from dropdowns and free-form fields
Assign creatives to placements created in Campaigns
Update creative rotation percentages
Generate final URLs, inclusive of tracking parameters inputted in Configuration
Download a final workbook to use for trafficking

Data GovernanceCampaign FrameworkCampaign Management

Globallogic

3 roles

Senior Analyst quality

Promoted

Jan 2018 – Jun 2022 · 4 yrs 5 mos

Project- KNOWLEDGE GRAPH
Experience across Data Analysis, research analysis and Data handling.
Powerful knowledge of BI tools such Power Pivot, Power BI Desktop, Google data studio, Looker, Power BI service.
Knowledge of Data Visualization and Modeling.
Preparing spreadsheets, Performance Reports, Error Summaries, maintaining database, reports using Microsoft Office suite Preparing dashboard for quality improvement using excel.
Conducting Training session to deliver detailed operational workflow of the process to resources by means of Power Point presentation and document specifications.
Using business intelligence and reporting tools.
Providing ongoing feedback on tools and processes.
Performing analysis to assess the quality and meaning of data.
Strong Analytical, Assessment, conversant with Data retrieval and Data management procedures.

Microsoft Power BIPower PivotData AnalysisBusiness Intelligence

Analyst

Promoted

Sep 2016 – Jan 2018 · 1 yr 4 mos

Project- PRODUCT IDENTITY
➢ Manipulating, cleansing & processing data using Excel, Access and SQL.
➢ Responsible for loading, extracting and validation of client data.
➢ Analyzing raw data, drawing conclusions & developing recommendations.
➢ Developing data analytical databases from complex merchant source data.
➢ Data entry, data auditing, creating data reports & monitoring all data for accuracy.
➢ Process workflow presentations to the team for improving the work quality.
➢ Advising on the suitability of methodologies and suggesting improvements.
➢ Carrying out specified data processing and statistical techniques.
➢ Supplying qualitative and quantitative data to colleagues & clients.
➢ Using SQL queries to extract, transform & data.