We provide IT Staff Augmentation Services!

Sr. Sap Bods/hana Data Migration Consultant Resume

Houston, TX

SUMMARY

  • Over 15 years of experience in design, development testing and deployment of software solutions with over 10yrs of experience in SAP environments.
  • Over 10yrs of experience SAP Data Services.
  • Over 5yrs of experience in SAP HANA.
  • Experienced in requirement gathering, gap analysis and developed functional specifications, technical specifications and blueprint.
  • Experienced in data migration of objects related to SAP MM, FICO and CRM.
  • Experienced using SAP Best Practices Data Migration (BPDM) AIO/RDS methodology jobs for SAP BW/ECC/CRM
  • Experienced on Migration Cockpit (LTMC) and Data Services (BODS) for loading the data in to Confidential SAP systems
  • Experienced on Migration Object Modeler (LTMOM) to add/update the standard mapping provided by SAP.
  • Experienced in migrating legacy data from multiple source systems to SAP ECC/CRM
  • Worked on creation of users in the management console and in the central management console.
  • Data stores creation on sources and targets of ECC, BI and databases.
  • Worked on performance tuning using caches, parallel execution, using bulk loading and using dataflow execution.
  • Experienced in loading delta records on both source and Confidential level CDC on type1, type2 and type3 SCD.
  • Integration of Business Objects Data Services with SAP and Non SAP Data Sources
  • Developed complex data models using SAP Native HANA studio modeling tools.
  • Experienced with SQL and Procedures in Native HANA.
  • Possess Strong knowledge/experience of HANA View Modeling using Calculation views and Performance tuning.
  • Extracted and transformed the data remotely using Smart Data Access (SDA) and Smart Data Integration (SDI).
  • Worked on SAP HALM (Hana Application Life Cycle Management, transported objects from one environment to another using this brand new tool.
  • Worked on integration of Business Objects Data Services with SAP and Non SAP Data Sources.
  • Experienced in data migration using BODS from legacy to SAP ECC.
  • Point of contact to Off - shore team to resolve the issues and for any concern in requirement gathering.
  • Initiated and documented on lessons learned, acquired knowledge documents and circulated those to use for next projects.
  • Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.
  • Worked collaboratively with project managers, SAP Offshore Consultants and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

TECHNICAL SKILLS

Operating System: Windows XP/7/2003, Sun Solaris, Linux

Languages: PL/SQL and TSL

Data Warehouse: SAP - BI 7.3

ETL: SAP Data Services, Alteryx.

EIM Tools: Information Steward 4.0(Data Insight)

SAP: ECC 6.0, CRM 7.0, S/4HANA, BI 7.0/7.3

Reporting Tools: SAP BEx, BOBJ 4.0, BO Explorer, Tableau, PowerBI

Scripting: Shell Scripting, VB script and HTML

RDBMS: Oracle 9i/10g/11g, MS Access, SQL Server 2005/2008, SAP HANA

Testing Tools: ALM (Quality Center)

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SAP BODS/HANA Data Migration Consultant

Responsibilities:

  • Worked with Business process owners to understand and document requirements.
  • Worked data migration for Master Data objects in GEMS II project.
  • Used Migration Cockpit (LTMC) and SAP Data Services (BODS) for loading the data in to Confidential SAP systems
  • Developed BODS jobs for Extraction, Transformation and Load for custom developed IDOC for Order/Vehicle creation object.
  • Worked on Data Cleansing, Data Quality activities for SAP Master Data objects.
  • Developed BODS jobs for Extraction, Transformation and Load for IDOCs.
  • Delivered Load files, Validation reports, Unit Test reports for the developed objects.
  • Converted complex business requirements and developed HANA models for TDT and IFA projects.
  • Integrated UC4 scheduler for BODS and HANA objects.
  • Worked closely with Business for successful UAT.
  • Built and maintained HANA models for LUBES and Supply.
  • Created projects in ADP for Business Users to load flat file data.
  • Created Technical specs by analyzing functional specs.
  • Created HANA Procedures, Table functions.
  • Created Calculation Views by using various nodes like Aggregation, Join, Union and Projection.
  • Developed SAP HANA Information Models using Calculated Views.
  • Enhanced data models to accommodate additional data without impacting existing reporting setup.
  • Created and used virtual tables for extracting data from legacy source systems.
  • Supporting existing BODS and HANA jobs.

Confidential, Falls Church, VA

Sr. SAP BODS Consultant

Responsibilities:

  • Worked on BODS 4.1 and Information Steward 4.1 environment.
  • Involved in Customizing the AIO Jobs as per Confidential ’s global data requirements.
  • Responsible for Migrating data from Legacy SAP and Legacy Oracle to SAP through IDOCS(DATA SERVICES) AND LSMW.
  • Created the Local Repositories, Central Repositories, and Profiler Repositories in SQL SERVER 2008 and configured the Local, Profiler repositories with Job server and Management console.
  • Configured the Data services to connect to the SAP ECC 6.0.
  • Migrated Equipment with EQUIPMENT CREATE02 Idoc, by developing separate flows for generation of Serialized Equipment.
  • Involved in meeting with ATR functional team to gather requirements and migrated the Account Payable, Account Receivable data through ACC DOCUMENT03 Idoc.
  • Migrated the CPI (Commercial Project Inception) through LSMW.

Confidential, Houston, TX

SAP BODS/BW Consultant

Responsibilities:

  • Installed Information Platform Services 4.0 and Business Objects Data Services 4.0.
  • Installed SAP Best Practices Data Migration Solution V1.40
  • Gathered the functional requirements from the business users and done the business analysis.
  • Worked with business users from 3 legacy Mainframe systems and PeopleSoft system in mapping sessions to map the source systems data with SAP ECC fields.
  • Worked with business teams from Mainframe and PeopleSoft systems for the transformation rules and lookup values.
  • Worked on LSMW (Batch Input Recording) process to migrate some of the vendor objects.
  • Worked on Data modeling, created Info Objects, DSOs, InfoCubes and MultiProviders.
  • Worked on Process Chains.
  • Involved in testing UAT scenarios with Business.
  • Worked on loading the data into BW. Used the open hub destination services to read the data from BW and to load the data into the SQL server Database.

Confidential, Boston, MA

SAP Data Migration Consultant

Responsibilities:

  • Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
  • Responsible for migrating legacy Customer and Equipment data of Egypt and Turkey into SAP.
  • Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
  • Used the platform and data integrator transforms as a part of mapping.
  • Used the case, validation, merge transforms in validation process.
  • Worked on Enrichment process to give more detail level data to SAP.
  • Created user defined @prompts and complex conditions at Universe level for better performance.
  • Worked with SAP ECC team in Offshore.

Confidential, Minneapolis, MN

SAP BODS Consultant

Responsibilities:

  • Created repositories for all the individual developers and a central repository
  • Implemented the data cleansing and address cleansing using the rules provided by business users.
  • Worked on tuning the Data Services jobs using Join ranks, caching and nested tables
  • Interacted with both legacy and Functional team to get the mapping to load the data in to SAP CRM
  • Developed the data flows for mapping, validation and enrichment process for custom IDOC segments.
  • Defined the strategy and roadmap to use Information Steward for data profiling and address cleansing
  • Developed the exception rules in dashboard
  • Deployed global address cleansing package
  • Developed scorecards in Data Insight based on profiling rules
  • Used Information Steward 4.0 for profiling the Business Partner an Employees data

Confidential, Houston, TX

Data Migration Analyst

Responsibilities:

  • Used Data Integrator as ETL tool.
  • Installed Business Objects 3.2
  • Gathered the functional requirements from the business users and done the business analysis.
  • Helped in migrating legacy Canadian customers to SAP.
  • Scheduled the jobs in management console.
  • Installed the SAP best Practices, ATL files and worked on the AIO jobs.
  • Used the ABAP data flows to read data from the ECC and to load data into the BW.
  • Used North American Data Cleanse as per the client requirement in data Quality.
  • Performed address cleansing by using USA address cleanse.

Confidential, Detroit, MI

ETL Developer

Responsibilities:

  • Involved in requirements gathering sessions with business folks in commercial customer service area.
  • Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data ware house.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update Strategy and Sequence generator and stored procedure.
  • Modeled data according to the requirements using Framework Manager.
  • Developed Query Subjects, Query Items and added filters to customize data.
  • Implemented effective date range mapping methodology for accessing the full history of accounts and products transaction information.
  • Analyzed joins in Framework Manager to improve performance of reports.
  • Published Packages to Cognos connection for use in both Report Studio and Query Studio.
  • Developed Standard List reports, Crosstab reports and Chart reports.
  • Implemented Drill Through, Prompts and HTML text for better utilization of reports.

Confidential, Dallas/Tampa

ETL Developer

Responsibilities:

  • Worked in Voice customer group business area.
  • Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Files.

Hire Now