Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic
Kumar Anurag

Kumar Anurag

Data Analyst
Bangalore

Summary

  • With 9 years of experience in IT and Data Analytics, including 6.5 years on Analyst Projects.
  • Supported product development and quality assurance teams.
  • Responsibilities include designing and maintaining SQL scripts, collaborating with developers and team members to ensure high-quality software. Possess excellent skills in writing SQL queries, including nested queries, grouping, sorting, joins, and data summarization.
  • Expertise in designing and developing Tableau visualizations, creating business requirement documents, and developing plans for creating dashboards.
  • Strong ability to quickly learn new technologies for project developments.

Overview

9
9
years of professional experience

Work History

Senior Associate - Tech & Data

PwC SDC
10.2022 - Current
  • Trained and supported new team members, maintaining culture of collaboration.
  • Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
  • Mentored junior associates, fostering professional growth and helping them reach their full potential.
  • Effectively collaborated with US Engagement team and core accountant teams to integrate analytics solutions seamlessly to deliver the quality deliverables. Played a key role in cross-functional communication and alignment.
  • Oversaw the planning and execution of client accounts, coordinating with project managers to meet timelines and deliverables. Implemented Agile methodologies to enhance team agility and responsiveness.
  • Leveraged SQL to analyze large datasets and extract actionable insights, contributing to strategic decision-making processes.
  • Migrated scripts from MYSQL to Databricks, loaded data using Azure data factory and implemented the processes end to end.
  • Created and executed an Alteryx workflow to automate the data preparation, data blending, and data analysis processes.
  • Developed workflows and dashboards to effectively communicate key insights to stakeholders.
  • Re-performed audit procedures and reconciled data to provide assurance to the audit clients.

Analyst – Property Reporting

Tesco
05.2021 - 10.2022
  • Partner with business stakeholders to understand key metrics and document business requirements for development
  • Build interactive dashboards on Tableau and work with businesses to tease out best stories to tell from a given dataset
  • Writing SQL queries, extracting data from Oracle SQL Server
  • Experience in implementing Data Modelling/Blending and pushing Dashboards to Tableau Server
  • Created Dashboards for Accidents Maintenance KPI for UK Region
  • Documents of projects artifacts and train end-user for better adoption
  • Collaborate with Analyst, Developers & Leadership

Partner Consultant- Contractual

Randstad India Pvt. Ltd
03.2021 - 05.2021
  • Worked in Excel & internal styling tool with a team member and delivered end to end reporting solution

Data Visualization & Analyst

Deluxe Entertainment Distribution India Pvt. Ltd
01.2017 - 03.2021
  • Company Overview: (Formerly Known as Deluxe DigiCaptions India Pvt
  • Ltd.)
  • Worked in Excel & Tableau with a team of 5 members delivered end to end reporting solution on BI platform (Localization cost analysis / Broadcast Delivery analysis/ Digital Delivery analysis and Sales analysis)
  • Hourly Sales Activity: Hourly Sales Activity report developed to compare and analyze this year vs
  • Last year’s sales activity
  • Price Change History: Report to compare old price and new price based on date and time
  • (Formerly Known as Deluxe DigiCaptions India Pvt
  • Ltd.)

Freelance Consultant QC Engineer

Deluxe DigiCaptions India Pvt. Ltd.
04.2016 - 01.2017
  • Quality checks and analysis on Multiple metrics

Education

B.Tech. - Electronics and Telecommunication Engineering

KEC

Skills

  • Excel
  • Tableau
  • MYSQL
  • Data Visualization
  • Quality Analysis
  • Snowflake
  • Alteryx
  • Monarch

Timeline

Senior Associate - Tech & Data

PwC SDC
10.2022 - Current

Analyst – Property Reporting

Tesco
05.2021 - 10.2022

Partner Consultant- Contractual

Randstad India Pvt. Ltd
03.2021 - 05.2021

Data Visualization & Analyst

Deluxe Entertainment Distribution India Pvt. Ltd
01.2017 - 03.2021

Freelance Consultant QC Engineer

Deluxe DigiCaptions India Pvt. Ltd.
04.2016 - 01.2017

B.Tech. - Electronics and Telecommunication Engineering

KEC
Kumar AnuragData Analyst