Nikhil Kalia
Amritsar
Summary
With over seven years of IT experience in Data Analytics and Reporting, I am looking for a challenging opportunity where I can leverage my technical and analytical skills to drive business insights, support strategic decisions, and grow alongside the organization.
Overview
7
7
years of professional experience
Work History
Senior Consultant
Capgemini India Pvt. Ltd
07.2022 - Current
- Stakeholder engagement and close partnering with data scientists, data engineers and other data analysts.
- Ensuring all relevant support and structure for smooth business continuity.
- Project cost management.
- Designing and building solutions and visualization based on business requirements to enable ongoing monitoring of business health.
Consultant
Capgemini India Pvt. Ltd
07.2020 - 06.2022
- Data Integration, Data Mining.
- Redesigning, streamlining and standardizing business processes.
- Gather requirements and build dashboards/reports as per client requirements.
- Ensure data accuracy via UAT and different types of testing.
Associate Consultant
Liquidhub Analytics Pvt Ltd
02.2018 - 06.2020
- Providing support and service for updating and managing sales data.
- Analyzing sales data at different sales stages and providing solutions within the SLAs.
- Planning for system synchronization gaps and required updates, cleansing, enrichment.
- Preparing End to End process flow documentation.
Education
Bachelor of Technology - Computer Science and Engineering
Guru Nanak Dev University
05.2016
Skills
- Power BI
- SSIS
- SSAS
- SQL
- Azure Data Bricks
- Data Analytics
- Business Intelligence
- Reporting
Accomplishments
- Extra Miler Award 2018
Projects
Partner Account/Contact Deduplication:
Identifying Duplicates through SQL Scripts and extensively cleansing Data for saving manual hours of Service owners and BSO's of Microsoft and reporting the progress in Power Bi Report.
LinkedIn:
Helping in identifying the relationship b/w Microsoft Sales profile Data and LinkedIn Sales Sales Strategy Data by matching the data with MSX and MS Sales through multi-level matching approaches to ensure the highest level of matching and linkage coverage rates reporting the progress in Power Bi Report.
Account Certification:
Identifying account with defects i.e. Duplicate Accounts created and Accounts with Invalid /non mailable Address and running packages to cleanse duplicate and resolve the invalid addresses using DnB and Informatica in the MSX system. Power BI report to show the end to end picture of the process.
MSX CRM DQ Dashboard:
A centralized process and dashboard designed to provide insights on data quality of MSX Universe enabling users to monitor the defects and identify actions to improve data in their area. Defects being Stale Accounts, Duplicate Accounts and Accounts with Invalid Address.
Hobbies and Interests
- Music
- Movies
- Football
- Mobile, PC and Console Games
Languages
English
Proficient
C2
Hindi
Proficient
C2
Punjabi
Proficient
C2
Timeline
Senior Consultant
Capgemini India Pvt. Ltd
07.2022 - Current
Consultant
Capgemini India Pvt. Ltd
07.2020 - 06.2022
Associate Consultant
Liquidhub Analytics Pvt Ltd
02.2018 - 06.2020
Bachelor of Technology - Computer Science and Engineering
Guru Nanak Dev University