Bala Sriram B

Project# 1: Pepsico

• Helped in setting up and configuring CDGC cloud environment, including onboarding data source.
• Assisted in migrating business terms, classifications and custom attributes to CDGC, ensuing consistency with existing on-prem version.
• Performed metadata scans and lineage extractions for both cloud and on-prem systems to validate data flow visibility after migration.
• Worked closely with data stewards and governance teams to map glossary terms to technical assets and verify data lineage in the cloud.
• Provided user training and created simple documentation for teams to navigate CDGC, explore data lineage and use business metadata effectively.
• Worked on cataloging business assets in Axon data governance by collaborating with data stewards to gather metadata through standardised bulk upload templates.
• Integrated the data quality rules into axon and enabling visibility of quality scores and issue trends for each critical data asset.

Project# 1: Max life Insurance

• Mainly involved in ETL development, creating the mappings and transformations using Power Center and CDI.
• Developed the manual file mappings and loaded them to the target, involved in production activities, historical fixations and fact table sync up.
• Created tables, views and indexes in postgreSQL as per the requirements.
• Closely worked with the reporting team to ensure accurate data in the reports.
• Coordinate with the scheduling team for timely job run and avoiding batch delays.
• Conducted data profiling to assess data quality, identify anomalies and ensure completeness, accuracy and consistency using IDQ, while integrating with the CDI mappings and cloud databases to enforce data quality in the ETL process, designing rules, transformations and validations to standardise and cleanse data in compliance with business requirements.
• Involved in month-end activities and worked on the fixations for maintaining accurate data for the users. And taking care of ITIL process like incident, service request, change request through service now.

Project# 2: Liberty Mutual Insurance

• Worked on integration and load data into project-specific websites, ensuring alignment with business requirements, and seamless integration.
• Experienced in managing and maintaining metadata within CDGC for efficient data discovery, scanning, and cataloging CDI assets via MCC, implementing data governance access control policies, tracking lineage, conducting impact analysis and organising data assets for easy searchable and efficient data governance.
• Implemented data governance practices, including metadata management and data lineage to support the reporting needs.

• Mainly involved in ETL developing, creating the mappings and transformations using informatica.
• Responsible for the development of metadata transformations and establishing a load schedule.
• Optimising/tuning mappings for better performance and efficiency.
• Extensively used, required transformations based on the business requirements.
• Validating and loading the reject records into relevant tables, and sending them to users for resubmitting.
• Involved in designing the mapplet and reusable transformation, according to the business needs.
• Expertise on SCD types, dimensions and fact tables.