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
Similar Profiles
Surabhi ChawlaSurabhi Chawla
Senior Associate at PWC SDC Kolkata Pvt. Ltd.Senior Associate at PWC SDC Kolkata Pvt. Ltd.
HARSHVARDHAN SINGHHARSHVARDHAN SINGH
Associate 3 at PwC SDCAssociate 3 at PwC SDC
Om Parkash BhatiOm Parkash Bhati
Associate at PwC SDCAssociate at PwC SDC
Rajasree Sen GuptaRajasree Sen Gupta
Resource Manager - UK Assurance at PwC SDCResource Manager - UK Assurance at PwC SDC
Simran SSimran S
Travel Consultant at BCD TravelTravel Consultant at BCD Travel