We provide IT Staff Augmentation Services!

Sap Hana/bods Lead Consultant Resume

Irvine C, A

PROFESSIONAL SUMMARY:

  • Over 10 years of experience working in IT Industry with in the field of SAP Data Services (BODS/BODI).
  • Data processing knowledge in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool SAP Data Services.
  • Expertise in Data Warehouse Implementation.
  • Experience in SAP BOBJ EIM Tools - Data Services (BODI/BODS).
  • Experience in extracting data from SAP ERP System (Tables, Hierarchies and RFC Function Modules) using SAP BOBJ Data Services (BODS/BODI).
  • Experience in extracting data from SAP BW Info Providers using Open Hub Destination and loading data to SAPBW Info Providers using BODS.
  • Having good experience with SAP Infrastructure in duel Landscape and connectivity.
  • Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
  • Expertise in scheduling and monitoring daily, weekly and monthly loads for master data and transaction data. Handling tickets as per SLA and rectifying loading issues.Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator .
  • Strong experience in the integration of BODS with SAP modules and Non-SAP data sources .
  • Strong experience in using BODS as an external system for ETL between ECC and BI .
  • Worked at multiple levels as an experienced subject matter expert in SAP infrastructure sizing and automated performance testing.
  • Extensive experience performing EDM Enterprise Data Management and MDM Strategy.
  • Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms ( Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
  • Strong experience in cleansing the data using Data Quality transforms.
  • Having good experience with design, Data quality, high volume transaction consumption, Tuning real time Web Services, Configuration & implementation in SAP ECC, (both as a source and target).
  • Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture .
  • Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
  • Developed conditioned, looped scripts for data load using Winshuttle Transaction.
  • Data modeling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modeling, fact and dimension tables.
  • Having good knowledge on TFS and SAP Lumira .
  • Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.

TECHNICAL SKILLS:

ETL: Business Objects Data Services (BODS), Data Integrator (BODI), SAP BO Data Services 4.2/4.1/4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5, SQL 2008 R2 SSIS.

Data Modelling:: Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Operating Systems: UNIX, Linux, AIX, Solaris, MS-Dos, Windows NT 4.0/2000/2003/2008 r2/XP/Vista/7

Databases: Oracle, Teradata, DB2, MS Access, MS SQL Server 2008 R2/2005

Other Skills: C, C++, Java, J2EE, JavaScript, Data loader, Apex Explorer, MS-Visio, Visualforce, XML

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, C A

SAP HANA/BODS LEAD CONSULTANT

Responsibilities:

  • Involve in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data at offshore location.
  • Involved in information gather phase
  • Migrated MS SQL Database into SAP HANA.
  • Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
  • Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Developed complex SQL scripts in Calculation views.
  • Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
  • Involved in SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.
  • Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
  • Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements.
  • Develop profiling queries/validation programs to cross check all the data before and after the data loading.
  • Identify problematic areas and conduct research to determine the best course of action to correct data.
  • Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
  • Develop conversion programs using ABAP and LSMW.
  • Involve in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
  • Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
  • Worked with MDM data which will allow the client to resolve issues with the quality of data, maintain consistent classification and identification of data, and data-reconciliation issues .
  • Implementing MDM was going to resolve unstructured data problem for the client. We reviewed structured data tables, records, semi-structured data XML .
  • Extensively involved in configuration of Material master record, vendor master record, Master Data for Vendor, Customer, Materials and Bill of Materials (BOM), Recipe management .
  • Gathered and analysed the requirement to replicate the ECC content in HANA using data provisioning . Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Created virtual info provider based on HANA models.
  • Created WEBI report based on HANA models using IDT.
  • Developed Dynamic Dashboards(XCelsius) using HANA Views and worked on Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
  • Used IDT to create connections and universes to the BEX Queries and HANA Calculation Views.
  • Developed scripts for data load using Winshuttle Direct.
  • Perform review of the Technical Designs, ETL Code and Unit Test Plan.
  • Worked with the infrastructure team to define reference architecture of the various reporting tools.
  • Work with downstream application users to gather reporting/data requirements.

Environment: SAP Business Objects Data Services 4.2, Data Quality, HANA 1.0 SP2, SAP R/3 ERP 6.0, MS Access, SQL Server 2008

Confidential, Livonia, MI

SAP BODS /IS Lead Consultant

Responsibilities:

  • Involved in profiling the vendor data (completeness and consistency).
  • Involved in profiling vendor data of OR9 available in ODS (SQL Server).
  • Configured profiling the business rules.
  • Reviewed list of potential duplicate vendors.
  • Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
  • Work with also defining an EDM / Master Data Management Strategy. This included using SAP MDM tool for data domains of Customer Master, Material Master, and Vendor Master.
  • Defined business rules of match/merge logic (duplicates identification) and address cleansing.
  • Validate and implement business logic mentioned in the specs to build in both Information Steward and Business Objects Data Services (BODS).
  • Involved in designing the approach document and the mapping rules defined by the customer .
  • Build and Bind rules to corresponding view or table
  • Create Tasks, Rules, Views
  • Tasks were exported from Development to Quality Environment using Information Steward.
  • Record final scores, failed records and total records count after the task is complete
  • Validating ETL design and development .
  • View term definitions, synonyms, keywords to help ensure appropriate terms are being used.
  • After approval of the term, associate a metadata or the Data insight object with the term .
  • Execute, Monitor and Trace jobs using Data Services Management Console

Environment: SAP Business Objects Data Services 4.2 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, Information Steward 4.2, MS SQL Server

Confidential, Waltham, MA

SAP BODS LEAD Consultant

Responsibilities:

  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Developed Source to Target Mapping as per the requirements.
  • ETL Design (converting business functional specifications into mappings/workflows), testing and code migration to difference environment.
  • Performance tuning using Recovery mechanisms for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows and data flows.
  • Involved in writing DS scripts and also used some built-in functions and Custom Functions.
  • Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Query, SQL Query Transform, Table Comparison, Case, Validation, and Merge etc. in Data flows.
  • Used SAP MDM tool for data domains of Customer Master, Material Master, and Vendor Master.
  • Involved in System integration testing along with other team members using various source data scenarios.
  • Experienced in scheduling and monitoring of jobs using DS management console during pre-production phases.
  • Worked extensively with data profiling tools (sap information steward 4.0) for ongoing project to understand the quality of data before loading into the SAP .
  • Worked with SAP Infrastructure in duel Landscape.
  • Worked on Creating Repository and associating the Job server to it.
  • Created Batch jobs using BODS ETL Tool to extract SAP and Non SAP Data and Build the EDW.
  • Daily Job monitoring for regular scheduled jobs.
  • Successfully worked on master data preparation including conversion, cleansing, migration and WinShuttle/SLMW troubleshooting during the load.
  • Used Debugger to troubleshoot the mappings between source and target tables.
  • Designed Business objects semantic layers (Universe) with SAP Warehouse and Non SAP warehouse.
  • Developed critical reports like drill down, Slice and Dice, master/detail for analysis
  • Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
  • Created different reports containing charts showing revenue, booking, and backlog and operating income by different verticals and Company codes.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Environment: SAP BODS 4.2, Information steward, SAP ECC, SAP BO XIR4, MS SQL Server 2008, Oracle 10g, SharePoint.

Confidential, Dallas, TX

SAP BODS Consultant

Responsibilities:

  • Extraction of Data from Legacy Source system to Staging Area.
  • Involved in sap R/3 source extraction by using sap Source Extractors using BODS 4.0.
  • Executing Batch Jobs that Contain ERP and R/3 Data Flows Generation of flat files
  • Working with DATA TRANSPORT Files Method to Specifies a staging file for data extracted from SAP ERP or R/3.
  • Involved in High Level design, Low level Design document, Unit Test Case and Integration Test case Preparation, Performance, and improvement of ETL
  • Involved in Normalized the existing model, Debugging existing ETL and Develop new ETL code.
  • Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and Logical Data Modeling by using ER-WIN V7/4.X/3.x and Oracle Designer.
  • Experience in Migration of Jobs and workflows from Development to Test and to Production Serverstoperform the integration and system testing.
  • Involved in extracting data from SAP R/3 OLTP System and generated ABAP code.
  • Involved in Installation, Configuration and Administration by using Business Objects Data Integrator 12.2.0
  • Involved in Migration of Mappings from BODI 6.5 to BODI 12.2.0 and migrated the code from development to Test database and to production db.
  • Extensively worked on development of mappings and worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation, Pivot Etc.
  • Involved in Data Profiling like source column data profiling, detail data profiling and used validation and address cleansing transformations by using Data Quality In SAP BODI 12.2.0
  • Have good knowledge on all kinds of lookups (Lookup Seq, Lookup Ext, Lookup).
  • Extensively worked with Local Repositories, Central Repositories, Job Server and Web Admin client tolls.
  • Created Custom functions to make the code reusable and created reusable components like Workflow, Data flows, Batch and Real Time Jobs.
  • Worked extensively with data profiling tools (sap information steward 4.0) for ongoing project to understand the quality of data before loading into the SAP .
  • Worked with multiple levels as an experienced subject matter expert in SAP infrastructure.
  • Extracting data from SAP BW by using Source &Target Extractors and involved in text data processing.
  • Have good knowledge about Web Admin &SAP Data Services Management Console (i.e. Scheduling, monitoring jobs).
  • Involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
  • Worked with Tivoli scheduling tool for scheduling, holding and cancelling the jobs.
  • Resolved high, medium tickets raised by the users and provided required support.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, SAP BW, SAP R/3 Source & Target Extractors, ERWIN V7 / 4x,DB2,UNIX, ORACLE 10G, SAP R/3, SQL, PL/SQL, Windows NT/2000/XP.

Confidential

SAP BODS Consultant

Responsibilities:

  • Led a group of BODS Developers.
  • Led the group in all the migration phases: Profiling, Cleansing and ETL development.
  • Migrated customer and vendor from different legacy systems to SAP ECC.
  • Setup BODS environment right from installation, configuration, authorization and testing the components.
  • Involved in gathering all the requirements related to ETL and interacted with SMEs to understand the data flow and integration of SAP & Non-SAP data.
  • Used Pivot and Reverse Pivot Transforms, to map the columns according the Dashboard Schema tables as per Dashboards requirement.
  • Implemented version management on top of the BODS local Repository by using the Central Repository.
  • Implemented using BODS features like Query, Merge, Row Generation, Lookup, Hierarchy Flattening, Key Generation and Table Comparison.
  • Implemented Slowly Changing Dimensions (SCDs).
  • Tested all the BODS ETL Jobs in DEV environment by loading sample data, validated and fixed the bugs.
  • Deployed all the BODS ETL Jobs from DEV to PRD after testing all the Jobs with the provided test scripts.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, SQL Server, BODS 4.0, Oracle.

Confidential

SAP BODS Consultant

Responsibilities:

  • Implemented version management on top of the BODS local Repository by using the Central Repository.
  • Implemented using BODS features like Query, Merge, Row Generation, Lookup, Key Generation, and Table Comparison.
  • Implemented Slowly Changing Dimensions (SCDs).
  • Developed a standard BODS ETL Job to load the Time Dimension table using Data Integrator Transform DATE GENERATION.
  • Applied BODS performance tuning techniques viz parallel processing (Degree of Parallelism), Multithread, Partitioning, and Database Throughputs to improve job performance.
  • Developed code with standard IDOC’s for transformation of SAP extracted data and loading it to SQL Server Table.
  • Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
  • Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookup ext and Custom Functions whenever an exception is raised.
  • Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
  • Involved in System integration testing along with other team members using various source data scenarios.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1BODS 3.2, SQL Server, Flat-files.

Confidential, Melbourne, Australia

SAP BODS Consultant

Responsibilities:

  • Performed transformation using BODS tool from SQL Server, Oracle database to Oracle database.
  • Developed BODS as daily and monthly cycle for loading, partitioning, cleaning and populating the data based on legal and business requirements.
  • Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
  • Implemented SCDs of master data as per bus requirement.
  • Implemented version management on top of the BODS local Repository by using the Central Repository.
  • Sophisticated transformations rules are implemented using BODS features like Query, Merge, Row Generation, Lookup, Hierarchy Flattening, Key Generation, and Table Comparison.
  • ETL Jobs are tested in DEV environment by loading sample data, validated and fixed the bugs.
  • Deployed BODS ETL Jobs from DEV to PRD after testing all the Jobs with the provided test scripts.
  • Prepared all the documentation related to ETL as part of project like Technical Design document, Data Flow document and migration document.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, BODI XI 3.0, BODS XI 3.1, SQL Server, Oracle 10g, Flat-files

Confidential

SAP BODI Consultant

Responsibilities:

  • Interacted with the business users to analyze the source data and gather requirements, technical specifications in migration of the data to the target SAP system.
  • Migrated data from the legacy Order Management System (OMS) to the new SAP R/3 ERP 6.0.
  • Staged the source data into Data Engine from SQL Server, flat-files and Excel spreadsheets.
  • Implemented necessary transformations to transform as per the target SAP architecture and loaded into the SAP R/3 system using the Idocs and custom load files.
  • Worked extensively in data analyzing, data profiling, data validation and data reconciliation.
  • Involved in data cleansing, de-duplication and data enhancement activities to enrich the master and transactional data.
  • Created complex source to target data mappings as a part of building the design according to the mapping requirements.
  • Built and Unit tested the jobs for migrating objects using SAP Business Objects following the AIO best practices to load Master and Transactional data objects into SAP ECC.
  • Extensively used Lookup ext, Lookup seq and also created custom functions.
  • Used global variables, local variables and parameters between work flow and data flow as per mapping requirements.
  • Performed the correctness test by running the DS jobs and validated the results by comparing the data from the test results of original legacy data.
  • Tuned and monitored Jobs and Transformations for the better performance of jobs.
  • Migrated jobs between different Central repositories and executed from Central Management Console as a part of different loads.

Environment: BODI, Data Quality, SAP R/3 ERP 6.0, Flat-files, SQL Server 2008

Hire Now