Umang Gupta
Auckland,AUK
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Logical thinking is my habit and always looking forward to making myself better. Confident, hardworking, quick learner, team worker, and love interacting with people. My biggest strengths involve out-of-the-box, logical thinking, being proactive, and an agile mindset.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Sr. Analyst
Capgemini Invent
11.2019 - Current
- Engaging with key Stakeholders and the Project Manager to define, communicate and implement the Product vision
- Created and maintained data visualizations that educates, informs and engage business partners on key metrics and performance measures
- Collaborated with enterprise data warehouse, Master Data Governance, and business teams on data quality issues, as well as architecture or structure of data repositories
- Performed cleansing, de-duplication, and harmonization of data across various systems
- Performed creation of visually impactful dashboards in Excel and Power Bi for data reporting by using pivot tables and VLOOKUP
- Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
- Worked with SQL & procedural SQL (procedures, functions, triggers, etc.)
- Wrote maintainable SQL queries to process multiple datasets perform data manipulation & cleaning
- Experienced on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and migrating on premise databases to Azure Data Lake store using Azure Data factory
- Communicating and coordinating with internal partner as necessary
- Bring inconsistencies and problems to the attention of the management
- Work with other teams in coordination for customer data governance, banking information management, collaboration with credit evaluation, taxes and compliance
- Authorized for creation and maintenance of customer master data through SAP MDG
- Responsible for maintaining, enhancing, and enforcing the discipline required for maintaining integrity of the process
- Expertise on SAP CRM/Mater Data Governance Tool
- Through Project Aurora, Microsoft Services has implemented a customer master solution
- Single consistent point of data entry and data integrity maintenance
- Collect and migrate raw data from the client to the Microsoft Server using SQL Queries
- Cleans, transforms, and validates data as a process for arriving at conclusions
- Performed User Acceptance Testing and System Integration Testing for new data
- Presented data in the form of charts, graphs and tables for immediate reference to the client for approval
- Performed audit on all data for the purpose of business development resolution
- Create, update and upgrade of customer data using SAP Tool
- Create new data with the validation process from DNB website
- Provided technical support for troubleshooting analytics and reporting issues.
- Generated standard and custom reports to provide insights into business performance
Education
Bachelor's of Technology - Electrical, Electronics And Communications Engineering
Jamia Hamdard
Delhi, India06.2019
Skills
- MS Excel, Azure Databricks, Power BI, SAP MDG, Azure Data Factory, MSXD 365, MS CompassOne, SAP Bulk Data Management
- Azure, Master Data Governance
- MySQL, Azure Synapse
- Python, ETL
- Analytic Problem-Solving, Data Migration, Data Cleansing, Tax Integrity
- Management and Leadership Skills
- Proven knowledge and experience in relevant data technologies
- Understanding and experience working with cloud infrastructure services Azure
- Unix Environments
- Advanced Excel Spreadsheet Functions
- Dashboard Designing
- Managing Client Relationships
- Statistical Methods
- Pivot Tables
- Database Schemas
- BI Tool and System Design
Affiliations
Capgemini
Certification
Azure-900 & Azure-104
Python Developer
Data Analyst certification
References
References are available on request
Timeline
Sr. Analyst
Capgemini Invent
11.2019 - Current
Bachelor's of Technology - Electrical, Electronics And Communications Engineering
Jamia Hamdard
Similar Profiles
Jad SlimJad Slim
Data consultant at Capgemini InventData consultant at Capgemini Invent
Blake KellyBlake Kelly
Senior Consultant at Capgemini InventSenior Consultant at Capgemini Invent
Kunal MulchandaniKunal Mulchandani
Manager at Capgemini InventManager at Capgemini Invent