We provide IT Staff Augmentation Services!

Sap Bods/hana Modeller Resume

Omaha, NE

SUMMARY

  • SAP Consultant with 8+ years of experience in HANA/BWModelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types like Text, Left Outer, Right Outer, Referential and Inner.
  • Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting); Working Knowledge on SDI (Smart Data Integration)
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules - FICO, MM, SD, PP, PM
  • Worked on extracting data fromSAPECC,SAPCRM, MM, PP, MS SQL Server andSAPAPO toBWand then also worked on improving reporting performance.
  • Experience in Data Provisioning Technique Direct Extractor Connection- created Data Sources and transferring data to HANA Via SAP BW using extractors(ABAP).
  • Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Views.
  • Experience in creatingHANAModels on virtual tables usingHANASmart Data Integration technology from Hadoop and Oracle databases.
  • Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio.
  • Configured the connection in LT replication server between SAP source system (ECC) and HANA; Data provisioned CO-PA related data
  • Set up multi-node HANA clusters across various environments using Apache Hadoop, Hortwonworks and Cloudera distributions.
  • 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, and CE Functions as needed.
  • Working knowledge on Integrated Process
  • Worked with multiple teams like Informatics, R/3, APO to solve various issues inBW.
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, Web Intelligence, Business Explorer(BEx) and various reporting tools like Crystal Report Enterprise, Design Studio, XCelsius, Analysis for Office, Lumira.
  • Developed all relevant reports per user requirements including maintenance notifications, activity and malfunction reports.
  • Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
  • Responsible for peer review for regression changes before moving the change from a development system to another development system.
  • Worked with JSON formats to communicate withSAP S/4HANADB in Cloud usingDellBoomi
  • Worked on designing SAP BW data Flows (DSOs, ABAP Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
  • Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema.
  • Troubleshooting data issues in SuccessFactors Employee Central to ECC - Data Replication viaDellBOOMI.
  • Team player with demonstrated collaborative working relationship.
  • Transported objects from DEV to QA catalog and content objects using delivery unit mode.
  • Involved in the production support, and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements.

TECHNICAL SKILLS

ERP: SAP ECC 6.0

EDW Tools: BW 7.3, 7.4, 7.5 SAP HANA SPS 10, SPS 11

DBMS: Oracle, MS SQL, SAP S/4 HANA, HortonWorks, Cloudera

Reporting tools: BEx, BO 4.x, WebI, IDT, Analysis for office, SAP Lumira, CRE, Tableau

ETL: SAP BODS 4.2

Operating systems: Windows, SUSE Linux

Data Provisioning: SLT, BODS, DXC

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SAP BODS/HANA Modeller

Responsibilities:

  • Designing and creation of Attribute, Analytical, and Calculation Views(Graphical) using HANA Studio; Creates schemas, tables; Worked on different joins (left outer joins or referential joins; Inner Joins; Text Joins).
  • Created Batch jobs usingBODSETL Tool to extractSAPand Non-SAPData.
  • Created procedures in BODS to transfer the data from OTM to DB to Oracle DB.
  • Extracted data from OTM and FTI and gathered data in SAP HANA and Oracle
  • Created views in Oracle on top of table in Oracle for reporting purposes
  • Generated Physical Queries from Logical queries and performed field mapping as well.
  • Worked on RPD tool to locate where the FTI are being populated from.
  • Generated reports on WebI and Tabluea on views- Aggregations, Graphs

Confidential, Saint Paul, MN

SAP S4 HANA/BW/BI Modeller

Responsibilities:

  • Created Attribute views, Analytic views, and calculation views as a part of SAPHANA Modelling usingHANAStudio. Implemented the business models using SAP Tables
  • Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
  • Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading; Data provisioned data from multiple Modules like FICO, MM and SD.
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules-FICO, MM, SD, PP, PM
  • Setup planning structures and looking at modeling aspects; Configured input ready queries with the BEx Query Designer
  • Expert inSAPBPCPlanning, Master data and dimensions modelling,BPCModels Design and Architecture, System Administration, Data Manager Packages, Transformations, Script Logic, Business Process Flows, Business Rules, Work status, Data Access Profiles,BW/BPCintegration
  • Created the Analytic Views based on Info cube models in SAP BW/BI system. Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins
  • Involved in designing the Graphical star Schema View by following the necessary standards to deploy optimized Info cube Data Model both at the Database level and Reporting Level.
  • OLAP Universe design using SAP BEx Query and Info Cubes. To access DS and InfoSet data, created BEx queries first and created Universe on top of the BEx Query. Accessed SAP InfoCubes, Transient Providers, Virtual Providers.
  • Design, Development, and implementation of BW Objects like Info Cubes, DSOs, ABAP Transformations and DTPs; Worked on Start/End/Field ABAP Routines
  • Expert inBPC/ IBP Embedded Planning solutions, Planning Cubes, Aggregates, Planning Filters, Planning Functions and Sequences, FOX Formulas, Copy, Revalue, Repost functions and Analysis for Office (AO) Input Forms and Reports. Expert in BADI development for complex planning functions
  • Worked on designing SAP BW data Flows (DSOs, ABAP Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
  • Creation of local and secure connections and Universe in IDT; Created universe using IDT and report development in WebI.
  • Involved migrating Hive tables and underlying data from Cloudera CDH toHortonworksHDP.

Environment: SAP HANA 1610 SPS 10, SPS 11, BW 7.4, 7.5, BODS 4.2, Solution Manager 7.2

Confidential, Indianapolis, IN

SAP HANA/BW/BI Modeller

Responsibilities:

  • Creation of schemas and managing schema mapping; Developed & designed Attribute views, Analytic views, and Calculation views; Export & Import of Packages.
  • Configured and Extracted data from SAP ECC, SAP CRM, PP, MM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.
  • Data provisioned data from multiple Modules like FICO, MM and SD.
  • Experience inHANAModelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types
  • Experience in creatingHANAModels on virtual tables usingHANASmart Data Integration technology from Hadoop and Oracle databases.
  • Strong experience in building solution using Modelling toolsSAPHANA,HANA Liveand BW, creatingHANAmodels using Graphical views
  • Responsible for peer review for regression changes before moving the change from a development system to another development system.
  • Worked on extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP Landscape Transformation (SLT) to HANA Data Base; Replicating Data from SAP and Non SAP using SAP SLT server and Advanced SLT server.
  • Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Analytical Views; Worked on Start/End/Field Routines
  • BW Integrated Planning (BW-IP) and/or PAK (Planning Application Kit)
  • Develop hierarchical integratedHANAdata models & views between Success Factors &HCMusingDellBoomi&HANAserver side SQL scripting
  • Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Hands-on experience in XSJS scripting, ODATA services andSAPUI5
  • Worked with different Data Quality Transform such as Data Cleanse and Match Transform; Used transforms like the Case, Merge, and Row-Generator.
  • Promotion of HANA code to production using export/import of information models and delivery units.
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, Web Intelligence, Business Explorer(BEx) and various reporting tools like XCelsius, Analysis for Office, Design Studio, Lumira.

Environment: SAP HANA 1610, SAP HANA 2.0 SPS 09, SPS11, BW 7.3, 7.4, Solution Manager 7.2

Confidential, Lake Success, NY

SAP HANA/BW/BI Modeller

Responsibilities:
  • Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading; Data provisioned from multiple Modules like FICO, MM and SD.
  • Experience inHANAModelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use different joins
  • Created Data stores & importing metadata, creating Batch job, Data Flow, Query transform, Executing job, Validation, Tracing and debugging Batch job, built in Transformation, Built in Functions, Data services Scripting language and variables.
  • Expert in understanding of the complete Architecture (Data loading, Data modelling & Reporting).
  • Implemented best practices, development standards for Data Services andHANAModelling.
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules-FICO, MM, SD, PP, PM.
  • Experience in creatingHANAModels on virtual tables usingHANASmart Data Integration technology from Hadoop and Oracle databases.
  • Data Provisioned data related to COPA using SLT technique into HANA DB.
  • Overview working knowledge with SAP BO Data services & SLT replication methods.
  • Using BODS ETL for build complex dataflows, push down operations, Batch job; Capturing changes in data (Initial/Delta load) using Table Comparison, Key Generation Transforms.
  • Worked on Export/Import ofHANAModels across landscape inHANA.
  • Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master data.
  • Extracted data from legacy systems and as well as different modules like MM, PP, SD, PM to BW system with SAP BODI as ETL.
  • Define database Data Stores and File Formats to allow Data Integrator to connect to the source or target database and files.

Environment: ECC6.0, BODS 4.0, SAP HANA 1511, SAP BW 7.0, SLT, Solution Manager 7.2

Confidential, Mahwah, NJ

SAP HANA/BW/BI Modeller

Responsibilities:

  • Extensive knowledge with Modelling and Implementation of SAP BW/BI and SAPHANA, Involved in several Implementation and Support projects of SAP BW/BI.
  • Designed the ETL processes using Data Integrator to load data from multiple databases like Oracle, My SQL,XML, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
  • Worked on Export/Import ofHANAModels across landscape inHANA.
  • Experienced on end-to-end implementation of SAP BW and SAPHANAdata models using ASAP and Activate Methodology.
  • Data provisioned data from multiple Modules like FICO, MM and SD.
  • Used global Address Cleanse transform and USA Regulatory address cleanse transform to parse, correct, complete, and standardized the address components to de-duplicate the address data.
  • Used transforms were like the Case, Merge, Query, Map Operation, Table Comparisons, Row Generation.
  • Configured and managed Repositories as per business requirements.
  • Developing and modifying changes in data flow’s according to the business logic.
  • Experience in SAP Data Migration using Smart Data Integration as the tool and Data Cleansing, Address cleansing using Data Quality.
  • Transform the data and load the data to specified destinations using case in transforms.

Environment: SAP BW 7.0 and Business Objects (BOBJ) XI 3.1, BODS 4.2, SLT

Confidential, Neenah, WI

SAP BODS/BW Consultant

Responsibilities:

  • Prepare High Level ETL design - Process Flow, Source to target mappings, design of data standardization, de-duplication and Cleansing modules for subscriber, data validations, plan for historical data analysis and modification.
  • Extracted data from legacy systems to ECC 6.0(SAP R/3) using Data integrator as the ETL tool.
  • Used Data cleanse and Address cleanse transforms to correct the Customer Master data extracted from file formats.
  • Implemented the application of the Data Cleanse Transform on Customer and Vendor Master data to identify and parse the data to confirm to company standards.
  • Used the Data Cleanse Transform on first name, last name, title, phone no, mail id, firm name, etc. and used Match Transform to correct.
  • Designed the ETL processes using Data Integrator to load data from multiple databases like Oracle, My SQL,XML, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
  • Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master data.
  • Extracted data from legacy systems to BW system with SAP BODI as ETL.
  • Used global Address Cleanse transform and USA Regulatory address cleanse transform to parse, correct, complete, and standardized the address components to de-duplicate the address data.
  • Designed, developed, implemented and documented complex Batch jobs and Real time jobs to extract data from deferent data sources.
  • Transform the data and load the data to specified destinations using Data Integrator (ETL)
  • Configured Custom cubes, Transfer rules, ABAP Routines, Update Rules, DSO, Cubes, Aggregates, queries and workbooks.
  • Designed Universe on SAP BW Queries & Info Cubes and developed WebI reports.
  • Published and scheduled batch jobs and real time services via web services using Data Integrator Administrator.

Environment: SAP BI Net weaver 7.0, Business Objects (BOBJ) XI 3.1, Business Objects Data Services XI 3.2

Confidential, Detroit, MI

SAP BW/ BODS Developer

Responsibilities:

  • Created Repositories, Users & assigned the security in the Multi-Team Environment.
  • Worked in theBODS 4.0Environment, the entire project implementation was on 4.0.
  • Worked on the Batch-time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
  • Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, and Validation.
  • Designed the ETL processes using Data Integrator to load data from multiple databases like Oracle, My SQL, Flat Files (Fixed Width) to the target Data Warehouse.
  • Setup RFC communications between Data Services and SAP BW.
  • Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL and .txt and .CSV files.
  • Worked on the Data Quality, Address cleanse transformations for cleansing the data.
  • Used global Address Cleanse transform and USA Regulatory address cleanse transform to parse, correct, complete, and standardized the address components to de-duplicate the address data.
  • Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master data.
  • Provided the technical guidance & knowledge transfer of effectively using BODS 4.0.
  • Configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, DSO, Cubes, Aggregates, queries and workbooks.
  • Used Transport connection to move objects from development to quality environments.

Environment: ECC6.0, BODS 4.0, SAP BW 7.0, Business Objects (BOBJ)

Confidential, Stanford, CT

SAP BW Consultant

Responsibilities:

  • Gathered requirements from functional users in Sales and Finance for functional analysis.
  • Configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, DSO, Cubes, Aggregates, ABAP Routines queries and workbooks.
  • Re-Designing of DSO’s, Info Cubes, Multi Providers
  • Involved in redesigning the BEX queries as per the user requirement for the better usage.
  • Involved in enhancement of data source to enhance the targets for the additional fields required by the business.
  • Created Process chains for periodic schedules of Master data and Transaction data loads to automate the data loading in the organization.
  • Setup RFC communications between Data Services and SAP BW.
  • Designed and transferred data to PSA's, DSO's and to other stages from BODS
  • Extracted data from legacy systems to BW system with SAP BODI as ETL.
  • Worked on Info Package to schedule data loads to Info Cube and Monitor the Status of the data loads.
  • Used Transport connection to move objects from development to quality environments.
  • Designed, developed, implemented and documented Batch jobs and Real time jobs to extract data from deferent data sources.

Environment: ECC6.0, BW 7.0, Business Objects (BOBJ 4.0)

Confidential

SAP BW Consultant

Responsibilities:

  • Involved in redesigning the BEx queries as per the user requirement for the better usage. Using BEx Query Designer to design the reports.
  • Involved in enhancement of data source to enhance the targets for the additional fields required by the business.
  • Working in creation of custom queries and defined calculated key figures, restricted key figures, variables with different processing types, filters, selections and structures
  • Involved in enhancing the Data Sources. Involved in writing Variable exits for BEx reports.
  • Worked in extensive testing of newly created objects by doing Unit testing, Integration testing.
  • Worked in testing the enhanced objects in sand box and QA systems. Participated in end user training documents and trained end users in different sessions.
  • Created Process chains for periodic schedules of Master data and Transaction data loads to automate the data loading in the organization.
  • Worked on Info Package to schedule data loads to Info Cube, ABAP Routines and Monitor the Status of the data loads.
  • Created Attribute view with Hierarchies, Analytical views (FI Tables), Calculation views.

Environment: ECC6.0, ABAP, BW 7.0, Business Objects (BOBJ)

Hire Now