Data Analyst
Capgemini - India
Total years of experience :6 years, 6 Months
• Resolving database and performance-related issues by Collaborating with data engineers to optimize database performance and ensure scalability of data infrastructure
• Designed and maintained data pipelines to automate data extraction, transformation, and loading processes
• Worked upon the M-load script to load data into the staging area from a flat file and processed the data end to end.
• Impact analysis on enhanced or decommissioned database objects.
• Developed custom dashboards and reports using advanced visualization techniques
• Closely collaborated with the CDL, FIRST LINE, SIT, & MFT teams to meet the objectives set by the stakeholders.
• Worked closely with stakeholders to define key performance indicators (KPIs) and establish data governance policies
• Conducted impact analysis of the billing system over time to identify areas for performance improvement, resulting in enhanced system efficiency.
• Implemented various MDM functionalities including approvals, hierarchy management, business rules, reference data, matching and survivorship.
• Analyzed existing SQL queries for performance optimization and modified procedures, views, and complex queries to align with project requirements.
• Developed and implemented data ownership coding structures to ensure data access and integrity.
• Optimized SQL queries and procedures, significantly improving data processing efficiency and meeting project specifications.