Lead Sap Data Migration /bods Consultant Resume
Dallas, TX
SUMMARY:
- 11+ Yrs. of SAP Data Migration experience, out of which 8+ yrs. of extensive ETL experience with SAP Business Objects Data Services/Data Integrator and Data Quality.
- 6+ Yrs. of Experience in Data warehouse and Business Intelligence Technologies such as SAP BOE Product suite (BO XIR2, BO3.1, Data Services 12.x/Data Integrator 11.x), SAP Xelcius, Microstrategy 8.x, Informatica 8.x, Oracle 11g, SQL Server 2000/, MYSQL 3.x / 5.x, Infobright 5.x
- Worked on S/4 HANA migrations version 1503/1511/1610/1709.
- Experience in SAP S/4HANA migration cockpit (LTMC) and SAP Agile Data Preparation (ADP)
- Trained on S/4HANA migration cockpit (LTMC) by Open SAP.
- Extensive experience in areas of software engineering such as Software engineering principles, Implementing CMM Process for much CMM level 5 companies implementing quality procedures to maintain industry standards. Also conducted Quality Audit for other projects to ensure the CMM standards.
- Supported Integration testing, multiple conversions by loading and gathering the time durations during the data loads based on the sequence of activities, and were part of the performance tuning related to database indexes based on the input structures and key fields.
- Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script.
- Experience with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.1 for loading data from SAP ECC system to SAP HANA
- Worked on various SAP ECC on data migration, conversion and interface projects and involved from the inception the projects till go - live including requirements gathering, analysis, design and implementation of 2 SDLC implementations using SAP best practice migration methodologies.
- Strong experience in data migration, conversion and interface SAP projects involving SAP ECC, MDM, CRM & NON-SAP like SQL Server, DB2, and Oracle.
- Excellent understanding and skills in the Integration of SAP SD, MM, SCM, CRM, MDM and FICO .
- Expert level knowledge and hands on experience in using SAP Business Objects Data Quality for Data Migration, Address Cleansing and Matching in large projects.
- Worked with Information Steward, profile and analyze data, define rules, Cleansing Package Builder and creating Cleansing Package.
- Used Autosys to schedule batch jobs
- Strong knowledge on designing and developing complex ETL solutions by translating design requirements into feasible, reusable and scalable technical implementations.
- Migrated data flows, workflows, scripts, and jobs between repositories. Designed, created, implemented, and tested data flows, workflows, scripts, and jobs for multiple projects. Well versed with troubleshooting and performance tuning which reduced several jobs from several hours to less than one.
- Demonstrated ability as a lead to streamline operations to increase efficiency of the project, and proven record of consistently exceeding corporate goals through strategic planning, business expansion, staff development and project execution.
- Has good expertise in Data Migration Projects. Very familiar with SAP data Migration Framework/AIO Methodologies. Worked on Master Data, MDM and BW conversion/migration projects. Exposure in PI related to XIF and IDOC adapters, MDM, and error analysis and tracking.
- ETL (Extract, Transform, Load), Data Quality and Data Profiling experience from source systems including Flat Files, Legacy systems and SAP R/3 including SD, MM, HR and FICO
- Strong Functional experience in SAP SD (Sales and Distribution), SAP SM (Service Management) and EDI (Electronic Data Interchange). Exposure to SAP CRM (Customer Relationship Management) and HR (Human Resource) module
- Involved in various SAP ECC and BO projects including Implementation, Enhancements, Roll-out, Data Warehousing and Business Intelligence, Rapid Marts, Data Migration, Data Cleansing, Data Warehouse and Support projects with more than 3 SDLC implementations using ASAP Methodologies
- Experience in BI / Data warehouse projects involving Informatica suite of products. Experience in data warehousing using various ETL tools (Informatica).
- Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
- Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
- Extensive work with PL/SQL, performance tuning of Oracle. Data Modeling experience using ERWIN 3.x
- Extensive experience with relational databases ( Oracle 8i/9i/10g, SQL Server 2000/2005 ).
- Experience in working with COBOL, XML and Flat Files. Experience in creating complex models (dimensions/hierarchies/categories) in BODS designer. Experience in Load balancing /optimizing resource usage and defining Environment Variables for performance tuning.
- Excellent communication, interpersonal, analytical skills and strong ability to perform in a team.
- Understanding, flexible, and adept at working in high paced environments, adapting quickly to different business organization’s needs.
- Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations, Star schema and Snowflakes schema.
- Generating and deploying Power play cubes and reports in UNIX and windows environments. Proficient in network installations and troubleshooting. Reliable, responsible, hardworking and good team player.
EXPERIENCE:
Confidential, Dallas, TX
Lead SAP Data Migration /BODS Consultant
Responsibilities:
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Responsible for interacting with various business stakeholders for creating and finalizing data migration strategy, creating the migration plan and procedures and performing the data migration.
- Responsible for creating and presenting the status reports to clients on data migration.
- Responsible for executing data migration activities from various sources to target applications.
- Downloaded and reviewed the out of box BPDM Solution for SAP ECC and created the technical and functional specs.
- Involving in adopting and implementing SAP Activate Methodology to load data from Legacy to ECC System as Target.
- Mainly working on Finance, SD and MM Master Data Loads and Transactional loads.
- Worked on objects Bill of Materials(BOMs), Routings, Batch, Open Sales Orders, Inventory Balances, Material classification, Bath class and characteristics, Open Purchase orders, customers, vendors, Fixed assets, A/R past due balances and Purchase info records etc.
- Created the Mapping Documents between Legacy and RDM’s
- Worked with Functional Consultants and collected the requirements for the data mapping (key fields, mandatory fields, formatting etc.)
- Created and configured Data Stores to SAP BI, ECC, DB2 and Oracle Systems.
- Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
Confidential, Mt. Laurel, NJ
Lead SAP S4 HANA Data Migration /BODS Consultant
Responsibilities:
- Leads data team on the enhancement, refinement or improvement of legacy master data.
- Gathered and analyzed the requirement to replicate the ECC content in HANA using BODS.
- Responsible for extracting financial data from HANA into Oracle Hyperion for an efficient elimination, consolidation and reconciliation process.
- Develop ETL jobs with heavy transformations for data acquisition from SAP ECC and Non SAP systems.
- Used various transformations like Map Operation, Table Comparison, Row-Generation, History Preserving, Query and SQL transformation.
- Responsible for the identification, documentation and resolution of data quality issues in the legacy system
- Validates and troubleshoots user cases to conform to business process definition and configuration and research resolutions as needed.
- Validates data as well as supporting the system testing from Unit Testing, Integration Testing and User Acceptance Testing.
- Resolves integration issues, supports ad hoc data uploads, and implements change requests.
- Maintains data integrity in systems by running queries and analyzing data; resolves data integrity issues as needed.
- Creates, maintains, views, and conducts reporting to extract necessary data.
- Load BP (Customer & Vendor) and Material master data in S4 Hana 1709 Sandbox using LTMC.
Confidential, Milwaukee, WI
Lead SAP S4 HANA Data Migration /BODS Consultant
Responsibilities:
- Lead and developer for development and integration activities, responsible for coordinating and leading various development activities in an onsite and offshore model. Worked on multiple plants at the same time.
- Assisted Project Manager with data load schedule and estimates. Also, planed data load order by functional areas.
- Coordinate functional work teams to achieve business results.
- Involved in Data mapping workshops and gap analysis between legacy Sources and S4 HANA.
- Used SAP Data migration strategy to migrate from Non-SAP to SAP S4 HANA using SAP Business Objects Data Services (BODS) with SAP BPDM Jobs using IDocs.
- Worked on extracting data from various sources (Ex. JD Edwards, AS 400, Oracle, PeopleSoft, Access, SQL, Excel and Flat files.
- Analysis and Development of the requirements with the business users and write ETL technical specifications and Designed ETL Templates and provide data analysis reports to Business teams for clean-up.
- Data Migration of Master data objects like BP (Customer, Vendor), Material objects and also Transaction objects like Open AP,AR, Sales Orders, Purchase Orders, PIR, GL Account posting etc.
- Worked extensively on Address Cleanse (USA Regulatory certified address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in Customer Master, Material Master and Vendor Master tables.
- Experience in source data and target data requirements and mapping using SAP BODS.
- Used MS Excel and VLOOKUP functions to validate data loads, exceptional reports.
- Build flat files from BODS and to support LTMC, LSMW, BAPI and BDC programs to load master data.
- Lead business in data validation and Assist in cut-over planning.
Confidential, Portland, OR
SAP Data Migration /BODS Consultant
Responsibilities:
- Gathered business requirements from key stakeholders and translate them to a comprehensive data solution design.
- Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from AS400 to SAP.
- Followed Active methodology for S/4 HANA data migration, analyzed Legacy data mapping with S/4 Hana templates and implemented the mapping rules & transformation logic.
- Worked in Vendor Master, Customer Master, Bill of Materials, Purchase info Record, Open PO.
- Proficient in BPDMs, LSMW, IDOC, BAPI.
- Work with the legacy system analysts to understand the legacy data and the expectations.
- Workshops for data identification from the legacy and preparation of the detailed data requirements.
- Prepare the field mapping documents of the legacy tables to the SAP tables with all the validation rules to be implemented on the data.
- Develop conversion routines in BODS which implements all the rules in the mapping document for a subject area.
- Unit test the development done using BODS .
- Extracted Data from SAP and load to SQL server for reconciliation reports and analytical team.
- Cut over planning and preparation.
Confidential, Greensboro, NC
SAP Data Migration /BODS Consultant
Responsibilities:
- Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from SAP to SAP.
- Extracted data from SAP and stage into SQL server then transformed and load into a new SAP system.
- Developed data migration approach and strategies using SAP best practice methodology.
- Developed validation programs to cross check all the data before and after the data loading.
- Identifies problematic areas and conducts research to determine the best course of action to correct data.
- Created SAP Data Services jobs for the following objects: Customer Master, Vendor Master, CMIR, Open AR, Production Order, QIR, PIR, BOM and Routs.
- Consolidated Material Data in Data Manager by performing validation, match and merging.
- Involved in Configuration of Enterprise structure for Plant, Purchase Organization, Storage locations and their assignments.
- Involved in Configuration of different kinds of Material types, Material Master screens with field selections
- Loaded data into Ztables through LSMW.
- Worked with Subject Matter Experts, Business System Analysts, Data Architects, System Integrators and others to provide data migration and master data managements solutions.
- Responsible for gathering business requirements as well as Data Mapping, Validation and Enrichment activities.
- Designed and implemented De-Dup and Delta processes to be used across all data migration streams. .
- Configured DS Components including job server and repositories.
- Expert with transforms such as Query, Validation and Case transforms as well as DQ transforms like Match & Address Cleanse.
- Expert at Data Quality and Data Profiling.
- Created SAP query report in ECC for users to validate the data in real time.
- Modified BPDM jobs to accommodate business requirements.
- Root cause analysis of the master data incidents, mass maintenance and mass uploads in ECC using LSMW and iDoc.
- Migrated code from Local/Central repository to different environment repository.
- Maintenance of BODS server including creating users and repositories.
Confidential, Secaucus, NJ
SAP Data Migration Consultant
Responsibilities:
- Involved in data migration from various corporate systems and interacted with end users and functional consultants
- Reviewed the functional specifications and technical specifications and reviewed the existing mappings and Worked on data migration and conversion activities For Finance Objects (Cost Center, Profit Center, Chart Of Accounts, GL Balances, Accounts Receivable, Accounts Payable & Bank Master)
- Used Back office methodology
- Transforming, migrating, validating and reconciliation of data.
- Utilized BPDMs for several of the objects.
- Created SQL views to externally assign logical system values.
- In depth and hands-on development experience of using SAP BODS 4.1, LSMW, BDC &IDocs
- Debugged existing SAP BODS AR and AP Jobs.
- Modified SAP BODS jobs as per the new mapping rules and business requirements.
- Worked closely with business to gather new business requirements.
Confidential, Oklahoma City, OK
SAP Data Migration / SAP BODS Consultant
Responsibilities:
- Interacted with Business Users and data owner in gathering business requirements for Fixed Assets, Customer Master and AR load
- Involved in data migration from various corporate systems and interacted with end users and functional consultants
- Reviewed the functional specifications and technical specifications and reviewed the existing mappings and redesigned the mappings to meet the perfect requirements.
- Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator.
- Prepared data Extract from legacy system and populating SQL Database on which data store for BODS has been created.
- Designed Customer Master Jobs in DS from Legacy to create IDOC Load Files
- Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
- Designed templates to transform Legacy Master and Transactional data compatible to target SAP ERP system
- Developing and modifying changes in data flows according to the business logic.
- Creating Variables, substitution Parameters
- Creating Workflows, Data flows using Designer.
- Used SAP AIO templates for generating IDOCS and applied SAP best practices in development.
- Worked extensively with IDOCS and LSMW for loading data into SAP ECC 6.0
- Coding & Debugging, Sorting out their time-to-time technical problems.
- Analyze the types of business tools and transforms to be applied.
- Tuned performance for large data files by increasing block size, cache size and target based commit interval.
- Implemented performance tuning logic on sources, workflows, dataflows and targets in order to provide maximum efficiency and performance.
- Involved in data profiling and used validation and address cleansing transformations by using data quality
- Developed custom functions per business requirements for loading the data into SAP.
- Identified errors in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs and redesign the existing mappings for improving the performance.
- Analyzed data cleansing, validation process using Information Steward to understand where the data changed that affects the cleansing/validation process on output.
- Used Information Steward to view data quality reports via dashboard and scorecards
- Involved in writing the Unit Test Cases.
- Involve in migrating the jobs from Dev QA and to Production.
- Dealt with Unit Testing of all the mappings end to end and also with UAT.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Confidential, Somerset, NJ
Lead Data Migration/SAP EIM Consultant
Responsibilities:
- Worked in planning, developing, implementing and managing data conversion part of Single Thread / R2 project deliverables, design documents and high level data mapping for ETL specifications.
- Handled Administration covering Upgradation / Installation / Configuration of SAP BI 4.x and SAP Business Objects Data Services14.1.x components (Job Servers, Profiler Servers and Repositories),configuring to handle data in and out of SAP.
- Handled Performance Tuning the ETL jobs for better performance, optimization of the resources and fit in the allocated Timeframe window, design Staging Area (Persistent and Transient) for data from SAP, Mainframe Source Applications (Movex / PCIS) using ODBC Connections, Great Plains (Oracle), XML files and flat files etc.,
- Worked in ETL Development /Template involving DI Objects like Batch Jobs, Workflows, Dataflows, ABAP Dataflows, Scripts, Variables (Global/Local/Parameters), Transformations (Global/Local/Parameters), Transformations (Query, SQL, Table Comparison, Map, Validation, Pivot, Hierarchy Flattening, Case, Merge, Row-Generation, Global / USA Address Cleansing, Data Cleanse, Match) and Text Data Processing.
- Worked closely with the Business teams to insure that the capabilities of the content enrichment pipeline meet and exceed the requirements for maintaining world class content.
- Worked closely with technical peers to insure successful integration of developed applications within the corporate architecture.
- Worked in Development of functional requirements and design documentation, Implementation, test and support of complex jobs and workflows.
- Communicate and work with people of all levels in a team environment
- Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
- Administration tasks like Installation/Configuration of SAP BI 4.x and SAP Business Objects Data Services14.x components (Job Servers, Profiler Servers and Repositories),configuring to handle data in and out of SAP.
- Participate in designing the architecture of the data migration to SFDC (Sales Forces) CRM system.
- Prepared detailed design documentation including ETL data mapping documents and report specifications.
- Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
- Utilized several transformations in ETL jobs developed using Data Integrator including Date Generation, Effective Date, Table Comparison, History Preservation, SQL, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
- Extensively used lookup and lookup ext functions to perform database lookups.
- Involved in writing the High-level and Detail-level documentation of the project.
- Wrote custom functions to produce the derived fields using the source table fields for each record from source
- Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and Data profiling process
- Captured changes in data using slowly changing dimension logic.
- Worked on integration of Sales Force Dot Com (SFDC) with Data Services
- Debugged failed Data flows and used audits to identify records with missing data and emailed concerned parties.
- Identified issues in the workflows and optimized the performance of the jobs.
- Transported the jobs from DEV to UAT and UAT to Production.
- Designed the Universes using Business Objects Designer Module and created number of standard reports and queries based on the existing classes/objects.
Confidential, Stamford, CT
Data Migration / BOBJ Developer
Responsibilities:
- Worked with business in gathering requirements, analyzed the legacy data and meet with different stake holders to understand the source and target requirements. Identified the flow of information by analyzing the existing systems.
- Analyzed the source data coming from legacy systems, Oracle, Flat Files, and DB2 coordinated with data management team in developing a robust data migration and conversion process.
- Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files.
- Investigated legacy systems, SAP ECC and CRM and documented mapping from legacy data to ECC and CRM.
- Worked with the business and documented transformation and validation rules.
- Used SAP data services to extract, data quality check, conversion (as per business rules) and loading legacy data to SAP ECC.
- Working knowledge on loading data in SAP ECC by applying various businesses rules and reloads the same using LSMW.
- Extensively worked on IDOC processing using SAP Business Objects Data Services and loading CRM data to SAP CRM.
- Good functional knowledge in SAP ECC, SD, CRM master data such as Business Partner, Product Master and Org Structure.
- Developed complex data flows and jobs using different transformations such as SQL, pivot, map, validation, table compare, and sequence generator, global address match etc.
- Worked on data store setup for SAP, DB2, Oracle and SQL server. Good knowledge on script writing, function creation, call oracle functions and SQL scripts from BODS scripts etc.
- Used Data Quality transformations while applying business rules to correct names, addresses and zip codes.
- Extensively worked on AIO templates to load legacy data and loaded converted data to SAP ECC and CRM.
- Deployed code to Central repository and from central to local repository. Maintained code versions.
- Worked on full life cycle (FDLC) Implementation, Enhancements, Roll-out, Data Migration and Data Cleansing using SAP Best Practice Migration Methodologies.
- Created shell scripts to run daily jobs and extract the files from remote location for data loads.
- Created, updated and maintained ETL technical documentation for Production Migration.
- Extensively used Cascading LOVs, Conditional Objects, and Complex Filters to make the universe user friendly.
- Hands on experience on creating row level and object level restrictions to provide cross line of business (XLOB).
- Worked on all advanced reporting features in WebI XI like Drill Down, Drill Up, Breaks, Scope of Analysis, Ranking and report level variable based filtering to create complex reports.
- Created report using Excel data and free hand SQLs.
- Responsible for scheduling reports as email attachments in .xls or .pdf format.
- Extracted ECC data for Personal Management, Payroll, Personal Administration in HR, Delivery, Shipping Document in Sales and Distribution
- Maintained BW InfoProviders/Queries/Reports in HR area
Confidential, Jersey City, NJ
Data Migration Consultant /BODS Consultant
Responsibilities:
- The scope of this project was to load G/L master, vendor master and customer master data from different legacy systems into SAP ECC using SAP AIO templates.
- Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
- Worked with Business and conducted several meetings with both legacy system and SAP ECC stake holders to gather the requirements.
- Developed complex ETL jobs to pull the data from different sources, done conversion and loaded into SAP ECC and MDM.
- Done data cleansing using the data quality transformations like country id, address cleanse, data cleanse available in sap data services.
- Working of RFC function modules in data services to perform loads on SAP BW and legacy systems
- Worked on SAP Business Objects Data Quality XI to do address profiling, parsing, standardization, cleansing, matching for master data such as org structure, customer and vendors.
- Worked on setting automatic validation logic for supplier, product and material data using SAP Business Objects Data Quality XI.
- Worked on deploying and code migration from Data Services in dev and QA. Performed code install and post install configurations and validations, performance tuning and repository maintenance.
- Working experience on inbound and outbound IDOC mapping and creation on SAP ECC using SAP BO Data Services.
- Developed logical and physical dimensional data models using ERWIN 7.1. Developed test cases and test plans to complete the unit testing. Support System testing.
- Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc. Designed, developed and improved complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
- Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Data Services using transformations like table compare, map, history preserve, custom functions and sql scripts.
- Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
- Performed metadata validation, reconciliation and appropriate error handling in ETL processes
- Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
- Scheduled batch jobs for processing flat files, XML files, XSD, DTD’s as source and Target.
- Strong experience on Central Management Console, Metadata reporting, metadata documentation, calling data quality functions from designer, repository and jobserver maintenance etc.
- Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
- Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs
- Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
- Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
- Defined Full client & webi reports and published to corporate documents and viewed by info view.
- Created reports using multiple data providers.
- Extensively Used Lookup ext, Lookup Seq and also created custom functions where repetitive code is needed.
- Created and administered Local and Central Repositories for multi user environment.
- Managed work assignments and coordinated within the development team.
Confidential, Albany, NY
Business Objects Data Integrator Consultant
Responsibilities:
- Worked on analyzing the ETL Mappings and created a New Version of Mappings.
- Wrote complex PL-SQL stored procedures to support complex business rule/complex validation rule and implement within work flow in data integrator jobs.
- Involved in designing of the mappings for migrating data from older system (Optare to the newer system Metavance).
- Involved in configuring the Repositories to the Job Server in the Unix Environment.
- Created automation for some logics for which business does not have to enter manually.
- Used Shell scripting to call the jobs in to Tidal and run it from there.
- Automated a job to take the parameters and run successfully through Shell Scripting.
- Used the SQL Transformation very extensively and wrote complex SQL.
- Created various work flows, data flows to coordinate the initial data loads as well as incremental load in to development, QA and Production environments for the Warehouse and Data Mart.
- Developed number of Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
- Identified and developed mapping logic for handling slowly changing dimensions.
- Involved in all phases of (Unit, Integrated) testing/debugging for PL SQL as well as DI workflow codes.
- Coordinated creation of regressive data for unit testing in development and QA environment, validated results with expected results.
- Involved in User Acceptance Testing (UAT), and solving issues.
- Created specs and technical specs for the reports.