We provide IT Staff Augmentation Services!

Sap Hana/bw/bods Modeller Resume

Saint Paul, MN

SUMMARY

  • SAP Consultant with 8 years of experience in working on POC's, leveraging businesses to take competitive advantage with real - time reporting.
  • 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
  • Worked in parallel in Native Hana (Hana Studio) in creating end to end data models for reporting solutions like COPA & Logistics with data replication scenarios both from SLT and BODS.
  • Worked on creation of Master Data models in SAP BW 7.4 for use in Native HANA as Attribute Views.
  • Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Analytical Views.
  • Experience in Trigger-Based data Provisioning using SAP LT Replication Server (SLT).
  • 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;
  • Finally integrated these BW Objects/Views in End to End Flows in Native HANA modelling Studio.
  • 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.
  • Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer and MS Excel.
  • Working knowledge on creating universes using IDT on HANA views and report development in WebI, Lumira.
  • Leveraged using HANA Cloud Integration ( HCI ) to integrate with data on premise with Cloud based HANA Solutions.
  • 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, Lumira.
  • Planning Tools SAP IBP (Integrated Business Planning 5.0/16XX) along with SAP HCI (HANA Cloud Integration); Extracted data from C4C (Cloud for Customers).
  • Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
  • Coordinated and resolved Data Quality issues for smooth migration to production
  • Worked on designing SAP BW data Flows (DSOs, 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.
  • Motivated self-starter with excellent communication, presentation and interpersonal skills, willing to travel 100% and work in challenging and cross-platform environments.
  • Hands on experience of working on HANA Cloud Integration - HCI & relevant administration & SSO activities.
  • 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.4 SAP HANA SPS 09, SPS 10

DBMS: Oracle, MS SQL, SAP S/4HANA 2.0, SAPHANAcloud Integration

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, Saint Paul, MN

SAP HANA/BW/BODS 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)
  • 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 from multiple Modules like FICO, MM and SD.
  • Extracted SNP and DP data fromSAPAPO in toSAPBWand created reports combining inventory data and APO data.Developed Transformation Logic in both Start And End Routine.
  • Working experience on Data Migration from different data base systems to SAP HANA using SLT and SDA(Hadoop)
  • Responsible for developing complex SAP Data Services(DS) Data flows/Workflows using different types of transforms like Query transform, Table compare transform, Case transform, Map operation, Merge, History preserve based on the business requirements.
  • Designed and implementednativeHANAmodels in SAPHANA(SPS 11). Created Attribute, Analytical and Calculation views, Currency conversions, Procedures.
  • Had created Virtual, Transient Infoproviders and Composite providers in BW on top of HANA Model, created DB Connect to load data from HANA to DW.
  • 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, Transformations and DTPs; Worked on Start/End/Field Routines
  • Promotion of HANA code to production using export/import of information models and delivery units. Involved in transports using Delivery Units; Transported Universe from one System to another system.
  • Worked on designing SAP BW data Flows (DSOs, 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.
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, WebI, Business Explorer(BEx) and various reporting tools like Crystal Report Enterprise, Lumira.

Environment: SAP HANA 1.0 SPS 09, SPS10, BW 7.4, BODS 4.2

Confidential, Indianapolis, IN

SAP Native HANA/BW/BODS Modeller

Responsibilities:

  • Created end to end data modelling solutions in Native Hana for finance application called ''Accounts Planning'' to make the reports available through BO Front End.
  • Configured and Extracted data from SAP ECC, SAP CRM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.
  • Worked in parallel in Native Hana (Hana Studio) in creating end to end data models for reporting solutions like COPA & Logistics with data replication scenarios both from SLT and BODS.
  • Strong experience in building solution using Modelling toolsSAPHANA,NativeHANAand BW, creatingHANAmodels using Graphical views
  • Leveraged using HANA Cloud Integration ( HCI ) to integrate with data on premise with Cloud based HANA Solutions.
  • 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
  • Created HANA-optimized InfoCube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes; Used BW 7.4 Info Providers (Transient, Composite, Multi providers) for HANA models
  • Planning Tools SAP IBP (Integrated Business Planning 5.0/16XX) along with SAP HCI (HANA Cloud Integration); Extracted data from C4C (Cloud for Customers).
  • Extracted Data from all the Databases including oracle, Hadoop, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Developed MS analysis Reports, Input Templates and Tableau Dashboard onHANAviews.
  • 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 Crystal Report Enterprise, Lumira.

Environment: SAP HANA, SAP HANA 2.0 SPS 09, SPS10, BW 7.4, BODS 4.2

Confidential, Lake Success, NY

SAP BW/HANA/BODS Modelling

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.
  • 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).
  • Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
  • Created the Repositories, SAP data stores, read and modified the custom ABAP transformations, calling RFC reading the SAP functions to Data Services.
  • 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.
  • Core Data Services(CDS)views for front end Fiori apps
  • 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.
  • Developed data model using Attribute/Analytic/Calculation Views. Also achieved conversion of these views intoCDSviews using SQL query.
  • 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 2.0, SAP BW 7.0

Confidential, Mahwah, NJ

SAP BODS Developer

Responsibilities:

  • Responsible for scheduling batch and real time Jobs using Data Services Management Console and also responsible for Debugging and testing of ETL Jobs using Business Object data Services.
  • Created and used Jobs, Workflows, Data flows using Designer
  • 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.
  • Interacted with Business Users and Managers in gathering business requirements.
  • Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master 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.
  • Defined separate data store for each database to allow Data Integrator to connect to the source or target database.
  • 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 Data Integrator 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

Confidential, Neenah, WI

SAP BODS/BW Consultant

Responsibilities:

  • Interacted with business end users to gather requirements.
  • 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, SQL, 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 legacy systems to BW system with SAP BODI as ETL.
  • 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 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, BW 7.0, Business Objects (BOBJ)

Hire Now