PROFESSIONAL SUMMARY:

• SAP Consultant with 8+ years of experience in working on POC's, leveraging businesses to take competitive advantage with real - time reporting.
• Experience in HANA Modelling 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
• Worked on extracting data from SAP ECC, SAP CRM, MM, PP, MS SQL Server and SAP APO to BW and 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 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; Data provisioned CO-PA related data
• Demonstrated to the end user's utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence. 
• 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. 
• Testing of the developed objects and documenting those-UAT
• Worked with multiple teams like Informatics, R/3, APO to solve various issues in BW.
• 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. 
• Coordinated and resolved Data Quality issues for smooth migration to production
• 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.
• Motivated self-starter with excellent communication, presentation and interpersonal skills, willing to travel 100% and work in challenging and cross-platform environments.
• 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.
• Certifications:
• SAP Certified Application Associate - SAP HANA (C HANAIMP151)

TECHNICAL SKILLS:

ERP: SAP ECC 6.0

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

DBMS: Oracle, MS SQL, SAP HANA 2.0

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/ BOBJ Modeller

Responsibilities:

• Created Attribute views, Analytic views, and calculation views as a part of SAP HANA Modelling using HANA Studio. 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.
• Data provisioned CO-PA related data using SLT into HANA DB
• Real time data streaming from SAP HANA to Hadoop as well as Hadoop to HANA cluster 
• 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.
• 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 creating Generic Extractors using Table and view. 
• 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.
• 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
• 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, 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.
• 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 XCelsius, Analysis for Office, Lumira.

Environment: SAP HANA 1610 SPS 09, SPS10, BW 7.4, 7.5, BODS 4.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 in HANA Modelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types
• Developed WebI reports on top of HANA models and Universe. 
• Strong experience in building solution using Modelling tools SAP HANA, HANA Live and BW, creating HANA models 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
• 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
• Successfully adopted the change from their current legacy systems to the entering SAP Hana system
• 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.
• Developed MS analysis Reports, Input Templates and Tableau Dashboard on HANA views.
• 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, SPS10, BW 7.3, 7.4, BODS 4.2, Tableau

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 in HANA Modelling 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. 
• 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 and HANA Modelling. 
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• 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 of HANA Models across landscape in HANA. 
• 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.
• Developed data model using Attribute/Analytic/Calculation Views. Also achieved conversion of these views into CDS views 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 1511, SAP BW 7.0, SLT

Confidential, Mahwah, NJ

SAP HANA/BW/BODS Modeller

Responsibilities:

• Extensive knowledge with Modelling and Implementation of SAP BW/BI and SAP HANA, 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 of HANA Models across landscape in HANA. 
• Experienced on end-to-end implementation of SAP BW and SAP HANA data 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.
• 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, BODS 4.2, SLT

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 the BODS 4.0 Environment, 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 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)