Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Kapil Dua

Data Specialist
Haryana

Summary

Experienced Data professional with extensive experience in designing and developing state-of-the-art dashboards, reports, and BI data models. Proven ability to transform business requirements into data-driven solutions, contributing significantly to product and service offerings. Proficient in Power BI, and Tableau, with hands-on experience in data preparation, data modeling, and analytics engineering. Strong analytical skills, a proactive problem-solving attitude, and a collaborative approach in agile team environments.

Overview

11
11
years of professional experience
6
6
years of post-secondary education

Work History

Data Analytics Lead

Aon
4 2023 - Current
  • Developed and optimized visually appealing and engaging dashboards/reports using Tableau and Power BI
  • Led creation of Wellbeing Maturity Index Dashboard using Tableau and Snowflake show
  • Developed Benefit Activity Dashboard in Tableau using Amazon Redshift as data source, highlighting changes in employee and dependent coverage
  • Developed automated workflows in Alteryx for data preparation and blending, which streamlined reporting processes and reduced manual effort
  • Migrated dashboards from Tableau to Power BI for the Select & Project product, integrating Google Analytics for email performance, Web Interaction and Page Performance Dashboard
  • Created dashboards in Power BI for Benefit Take-up, Annual Enrollment, and Employee Events, using Snowflake as data source
  • Developed Health Analytics Hub Dashboard in Power BI with SQL Server data to track story access and client engagement
  • Engineered and refined advanced SQL queries, enhancing decision-making and reducing data processing time by 25%
  • Automated data processing tasks using Python scripts, improving efficiency and accuracy in data preparation
  • Implemented data quality checks and transformations in Databricks, optimizing data workflows and enhancing data model performance
  • Collaborated closely with data engineers to resolve deployment issues and improve data quality, reconciliation, and data wrangling
  • Created semantic models for self-serve content teams based on user requirements
  • Lead a team of 3, ensuring timely deliverables and conducting regular Knowledge Sharing Sessions (KSS).

Associate Data Analytics L2

Publicis Global Delivery
08.2021 - 04.2023
  • Developed queries in GCP Big Query to extract data from various social platforms, Campaign Manager, and DV360 for Dunkin Brands & Baskin Robbins
  • Leveraged Alteryx to automate data extraction and transformation from various media platforms, integrating with GCP Big Query for enhanced data analysis and visualization
  • Collaborated with cross-functional teams to integrate Alteryx with Looker Studio, enhancing ability to visualize and interpret large datasets
  • Created high-impact KPI visualizations using Looker Studio and Power BI, enabling clients to monitor campaign performance and optimize advertising strategies
  • Automated weekly data extraction, cleaning, and loading processes using SQL and Python, reducing data processing time
  • Designed interactive dashboards that provided comprehensive view of multi-channel marketing data, including key metrics like click-through rates, impressions, and conversions.

Reporting Analyst

Department of Training & Technical Education, Govt of Delhi
07.2013 - 08.2021
  • Managed online admission process for Industrial Training Institutes (ITIs) in collaboration with the National Informatics Centre (NIC), ensuring a smooth and efficient admissions cycle
  • Worked closely with stakeholders across various ITI to gather requirements, provide data insights, and support decision-making processes
  • Developed and executed complex SQL queries for data insertion, updates, and retrieval, facilitating accurate and timely data handling within admissions database
  • Lead the design and development of interactive dashboards and visualizations to monitor application statuses, seat availability, and admission outcomes, enhancing transparency and stakeholder engagement.
  • Analyzed reporting functions and efficiency to reduce error rates and increase efficiency.

Education

M.SC Computer Science - Computer Science

Guru Jambeshwar University
Haryana
01.2018 - 04.2021

B.Tech Information Technology - Computer Engineering

Kurukshetra University
Haryana
08.2009 - 08.2012

Skills

    Power BI

    ETL development

    Tableau

    Data Quality Management

    Data Warehouse

    BigQuery

    SQL Expertise

    PySpark

    Databricks

    Locker Studio

    Data Integration/Migration

    Microsoft Excel

    Jira

    Alteryx

    Python Programming

Accomplishments

  • Big Data Master Programs from Trendytech
  • Power BI Desktop for Business Intelligence Udemy
  • Insta Award
  • Received Aon Star Award for my contributions to team development and performance.

Timeline

Associate Data Analytics L2

Publicis Global Delivery
08.2021 - 04.2023

M.SC Computer Science - Computer Science

Guru Jambeshwar University
01.2018 - 04.2021

Reporting Analyst

Department of Training & Technical Education, Govt of Delhi
07.2013 - 08.2021

B.Tech Information Technology - Computer Engineering

Kurukshetra University
08.2009 - 08.2012

Data Analytics Lead

Aon
4 2023 - Current

Similar Profiles

CREATE PROFILE
Kapil DuaData Specialist