Sap Mdg/data Steward &data Migration Architect And Lead Resume
SUMMARY
- SAP HANA Certified professional with over 10+years of experience inIT industry with expertise inSAP Data Services(BODS), Information Steward, MDG (Master Data Governance) & HANA with 4 complete lifecycle implementations involving data modeling, data extractions,data migration, installation, configuration,report development, administrationand performance tuning.
- Working and conceptual knowledge on SAPLumiraand SAPPredictive Analytics.
- Experience in Analysis, Design and Development of various Data Warehousing /Data Migration projects using SAP BODS/BODI, SAP MDG, information steward & HANA.
- Diversified Experience in Finance, Insurance, Retail, Health Care and Manufacturing domains.
- Experience in requirements gathering, gap analysis, business rules development, custom object development, data loading,unit testing, integration testing and go - live strategies.
- Develop RFPs, Road Maps, Conceptual Design and Blue Print for various scenarios for prospective global SAP EIM & HANA customers.
- Used Data Services as an external system for ETL between ECC and BI for cleansing the data using Data Quality transforms like Match, Associate, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
- Worked on loading data into differentIDOCSfor Customer Master, Material Master and Vendor Master using DEBMAS, MATMAS and CREMAS IDOCS.
- Worked onUser Defined Transform & Global Address cleaning, Match transformations to clean the data using Data Quality transformations in BODI/BODS.
- Sound understanding and experience in implementation of end to end Data Migration process including extraction, data profiling, transformation and generation of load ready data files in LSMW format.
- Extensive experienced in configuring and administering SAP BPDM
- Extensive Experienced in SAP Migration projects.
- Strong experience on UTD Quality Transformation and wrote Python Expression Script for eliminating the Invisible Special Characters in source system and loading into BW Target System.
- Involved to setup the Scorecards and associate the Data Quality dimensions in SAP Information Steward.
- Understanding requirements of SAP MDG for Customer, Vendor, and Material & Finance.
- SAP MDG Business set activation and configurations. Extend pre define data models as per the requirement. Configure ALE and data replication. Defining BRF modeling and FPM configuration.
- Strong functional and technical skills in implementing SAP Master Data Management solutions with focus on Central master data creation, maintenance, validation, harmonization and data governance/data quality management using SAP MDG toolkit; hands-on experience with multiple full-life cycle implementations of MDG 6.1
- Experience with SAP EIM DQM Components of Data Services (Address Cleanse packages) & Information Steward (cleansing package builder, data insight, metadata management, Matapedia).
- SAP MDG experience in multiple domains of data management such as Data Quality, Data Architecture, Data Management, Data Governance, Data Conversion, Data Sustainment, Data Strategy, Data Security, or Data Migration.
- Maintenance, Support and handled Admin activities of Data Services, SAP Information Steward & SAP MDG applications.
- Experienced working in onsite- offshore model, delegating tasks or responsibilities from Onsite & lead the team technically in delivering the required activities ontime.
- Good Knowledge onMaster Data Management to maintain the quality and healthy data for the business.
- Highly skilled, self-motivated team player, outstanding organizational and excellent communication and interpersonal skills with results oriented dedication towards goals.
TECHNICAL SKILLS
SAP EIM: SAP DS 4.2/4.1/4.0 SAP Information Steward 4.0/4.1/4.2 SAP MDG 6.1SAP Financial Information Management 7.0 SAP DQM 4.x
SAP ERP: SAP ECC 6.0/5.0
BOBJ Applications: BOBJ 4.0, Business Objects XI 3.1/3.0/XIR2, Xcelsius 2008/4.5, Crystal Reports 2011/2008/XI, Universe Designer, WebI, CMC, CMS
SAP BW/BI: SAP BI 7.3/7.0
ETL Tools: SAP DS/BODS 4.x, 3.x
Operating Systems: UNIX, LINUX, Windows
Databases: Oracle, SQL Server, MS Access, DB2
Data Modeler: Erwin 4.
Other Tools: HP Quality Center
PROFESSIONAL EXPERIENCE
Confidential
SAP MDG/Data Steward &Data Migration Architect and Lead
Responsibilities:
- Participated in all Technical discussions, meetings and mounted the discussion points.
- Understanding requirement of SAP MDG for Customer, Vendor, and Material & Finance.
- Understand the requirements of Data quality and Data Migration
- Understand the source systems to extract the data and migrate the data
- Profile the source data to understand and generate data quality reports
- Preparation of Technical Design documents based on Functional documents.
- Installed Information Steward 4.x and SAP DS 4.x
- Configured Information steward with data services and SAP MDG
- Associated the job server to registered IS Repository by using Server Manager.
- Extensively worked on creating repositories and established
- Data source connections.
- Created multiple data store configurations in Data services local object library with different databases to create unified data store.
- Prepared the functional mapping to CREMAS, DEBMAS, MATMAS IDoc and prepared GAP analysis.
- Design jobs and help the team to migrate the data using IDOC’s.
- Involved to define the validation rules and bind those rules to against the specific columns.
- Involved to setup the scorecards and associate the Data Quality dimensions.
- Develop Information Steward Exception Reports for project.
- Scheduling data Quality reports and notifying ‘End Users’ when there are exceptions.
- Understanding requirement of SAP MDG for Customer, Vendor, and Material & Finance.
- Business set activation and configurations. Extend pre define data models as per the requirement. Configure ALE and data replication. Defining BRF modeling and FPM configuration.
- Project estimation, Risk mitigation plan, Resource planning & allocation
- Training team on SAP Information steward & Data Quality.
- Manage a team of business and technical analysts.
- Worked as Administrator of DS, IS & DQ for the project
- Responsible for the Deliverables
Environment: SAP MDG 6.1, SAP BODS 4.2, SAP IS 4.2, SAP DQ R/3, ECC, SQL Server 2012.
Confidential
SAP Data Steward & DS Architect
Responsibilities:
- Installed Business objects Data services version 4.0 and configured different repositories (Local, Central, and Profiler) and job server.
- Understand the requirements and define data quality dimensions
- Validation of Accuracy, completeness, conformity, consistency & Uniqueness of Data with Information Steward Rules.
- Involved in development of FSD & TSD documents.
- Closely worked with business team to build validation rules for Customer/Vendor/Material & finance modules.
- Scheduling data Quality reports and notifying ‘End Users’ when there are exceptions.
- Configured Email notification to Business users when task is refreshed.
- Installed Information Steward 4.x and configured with data services.
- Associated the job server to registered IS Repository by using Server Manager.
- Helped the team to convert business rules to technical rules.
- Supported both Development & Enhancement of the Project.
- Created resource planning for the project.
- Risk mitigation plan, Project estimation.
- Training team on SAP Information steward & Data Quality.
- Manage a team of business and technical analysts.
- Admin of the DS, IS & DQ for the project
Environment: SAP BODS 4.1, SAP IS 4.1, SAP DQ R/3, ECC, and SQL Server 2008.
Confidential
SAP BODS Lead Consultant
Responsibilities:
- Involved in all phases of Software Development Life Cycle, Gathering, analyzing, documenting business requirements, and functional requirements and data specifications.
- Interacted with functional experts to gather the project/client requirements and conducted GAP analysis
- Participated in meeting with SAP functional team to prepare functional mapping and to give suggestion that, what we can achieve by using data services.
- Design and write jobs to fetch data fromSAP BWusing theOpen Hub Destination, kicking off the process chainsand also pushing the data to theBWDSOsusing the external source system configurations.
- Extensively Created SAP BW connection to interact with SAP BODS using RFC connection.
- Map and load legacy data into SAP ECC system using SAP FIM (SAP Financial Information Management).
- Configured the Data services to connect to the SAP BW and BI by using transport codes.
- Move the projects from DEV to ST, ST to UAT and UAT to Production using ATL files.
- Scheduled the Jobs in Management Console.
- Created new mappings and updated old mappings according to changes in Business logic.
- Design, install, and configure system for new implementations, upgrades, and maintenance.
- Conducted Capacity Analysis through technology lifecycle management, patch planning, efficient use of existing technology resources and recommending future needs.
Environment: BODS 4.0, SAP R/3, ECC, SAP BW, SQL Server 2008, Oracle 10g, SAP Information steward& SAP Financial Information Management 7.0
Confidential
SAP BODS Lead Consultant
Responsibilities:
- Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC (DEBMAS06).
- Developed the workflows to load the data into Customer Master Sale’s data (KNVV) and Partner roles (KNVP) from legacy systems.
- Developed workflows, data flows to extract. Transform, cleanse and load Material Master data into ECC with IDOC
- Developed jobs to load the Legacy system data into COND A04 IDOC (KOMG, KONH, KONP segments) by referencing the SAP AIO SD pricing job.
- Manage a team of business and technical analysts.
- Design functional and technical requirements for various conversion and integration management projects.
- Assist in the development of scoping and planning deliverables for the various Integration management projects.
- Develop preliminary technical specs based on future vision and currentbusiness processes.
- Analyze business requirements and design multi-scenario process flows.
- Develop use cases, testing plans and project specifications for both new applications and ongoing development phases of existing applications.
- Defined and implemented project requirements ensuring market competitiveness, while meeting client and consumer needs throughout the product lifecycle.
- Lead cross-functional teams in setting strategy, direction for development, and release of the product.
- Participate in validation of application architecture design and made recommendations for production release based on client requirements and inherent risk factors
- Create functional and technical specifications for system design.
Environment: BODS 4.0, SAP R/3, ECC, SAP MDM, Oracle 11i, SQL Server 2005
Confidential
SAP BODS Data Migration Lead Consultant
Responsibilities:
- Detailed Analysis of User requirements
- Map the user requirements with the SAP IDOC
- Creating the mapping documents based on the requirements.
- Creating Test case documents.
- Implemented SAP BPDM process for IDOC loading
- Involved in code review and fixing problems in code review.
Environment: BODS 4.0, SAP R/3, Oracle 10.2
Confidential
SAP BODS Data Migration Lead Consultant
Responsibilities:
- Develop preliminary technical specs based on future vision and currentbusiness processes.
- Highly involved in the ETL Mapping and Development
- Extracted SAP R/3 data to load into VectorWise database using BODS
- Worked on VectorWise database as Target
Environment: Business Objects Data Integrator 11.7.3, BODS 4.0, SAP R/3, VectorWise, Oracle 11i
Confidential
SAP BODS Lead Consultant
Responsibilities:
- Detailed Analysis of User requirements
- Map the user requirements with the operational systems.
- Creating the mapping documents based on the requirements.
- Creating Test case documents.
- Develop and Test the extract, transform and load jobs for different source systems like iSeries, FoxPro (.DBF), CSV files, SQL server to various target systems like SQL Server, CSV files.
- Used various BODI transforms like Query, Table comparison, Sql, History preserving .key generation.
- Develop SQL stored procedure to trigger the BODI loads from GUI (Java Front end).
- Involved in code review and fixing problems in code review.
Environment: Business Objects Data Integrator 11.7.3, SQL Server 2005, iSeries.