SRIRANGA H A
Mysore
Summary
Experienced Data Migration and ETL Consultant specializing in SAP BODS, Informatica MDM, and ETL processes. Proficient in SAP Data Services for extraction, transformation, and loading (ETL) from diverse data sources such as flat files, SQL databases, and SAP ECC. Skilled in optimizing data migration workflows, performing address cleansing, and ensuring data quality using SAP Information Steward. Expertise in developing and configuring Informatica MDM solutions, including match rules, base objects, and staging processes. Adept at enhancing data accuracy, consistency, and integrity, with hands-on experience in SQL Server, LSMW, and Jira for defect tracking and change management. Seeking opportunities to contribute to dynamic projects in data migration, MDM, and data analytics.
Overview
2
2
years of professional experience
Work History
Associate Data Migration|MDM Consultant
Utopia Global Limited (Prometheus Group)
05.2022 - 06.2024
- Configured and developed MDM Hub as per the business requirement.
- Created Landing, Staging, Lookup Tables and Base Objects as per the business data model.
- Created CMX_ORS, Data element, Relationship, Lookup, Configuring Stage process, and Mapping with cleanse function and validated the records.
- Created Cleanse list, Configuring Load Process, Trust, Validation rules and executed load jobs.
- Configured SAM and Entity 360 (E360) Involved in implementing the land process of loading the Product Data Set into Informatica MDM from various source systems.
- Performed stage jobs, load jobs, and match-and-merge jobs using the Batch Viewer
- Imported and exported from SQL server database and modified various stored procedures based on the client requirements.
- Worked on Jira for defect tracking and change requests.
- Developed Data Services jobs for extracting, transforming per business logic, and loading back to SAP using LSMW for the Vendor.
- Worked closely with the business IT team to set up the infrastructure for the projects.
- Optimized and enhanced Data Services job to achieve significant reduction in job run time by implementing several performance tuning options.
- Worked on data profiling, creation & validation rules also developed data quality job to address cleansing and duplicate and generated data quality reports for Material and vendor using SAP
Education
Master of Computer Applications -
Dayananda Sagar College of Art,science & Commerce
01-2022
Bachelor of Computer Applications -
PES University
01-2019
Skills
- Informatica MDM
- Microsoft SQL Server 2019
- Loading Data to SAP Systems
- Data Integration and ETL
- Data Mapping and Transformation
- Data Validation and Reconciliation
- Data Quality Management
- Data Governance
- Project Management
Accomplishments
- Developed data migration and master data management solutions for AdvanSix (USA), a leading chemical manufacturing firm, improving data accuracy by 20%.
- Worked on data migration projects for the Tax and Customs Authority (Saudi Arabia), utilizing LSMW, ETL processes, and Informatica MDM to ensure accurate and efficient data integration and management.
- Successfully implemented and optimized Informatica MDM solutions in Spectrum Brand, improving data quality, reducing duplicates by 30%, and enabling efficient master data management.
Timeline
Associate Data Migration|MDM Consultant
Utopia Global Limited (Prometheus Group)
05.2022 - 06.2024
Master of Computer Applications -
Dayananda Sagar College of Art,science & Commerce
Bachelor of Computer Applications -
PES University
Similar Profiles
JILL ELIZABETH KLEISTJILL ELIZABETH KLEIST
Senior Manager, Professional Services at Prometheus GroupSenior Manager, Professional Services at Prometheus Group
MANJUNATHA CHANNABASAPPAMANJUNATHA CHANNABASAPPA
S4 HANA Logistic Consultant at Prometheus GroupS4 HANA Logistic Consultant at Prometheus Group
Fabrice NgouzeFabrice Ngouze
Cloud Database Administrator at Prometheus GroupCloud Database Administrator at Prometheus Group