SUMMARY

• Having 10years of experience in IT industry, with 7+ years in SAP BODS, Business Objects, HANA and Migration Cockpit and 2 years in Technical support and Python development
• Has expertise and full hands on LTMC & LTMOM with S/4 Hana Migration Cockpit 1809/1909
• Experience in Implementation, Support, Maintenance & Development
• Involved in Analysis, Design, Development, Testing, Implementation and Support phases of the Projects for both SAP BW, BO, HANA, BODS and SAP - Python integration
• Extensively worked on Info Cubes, DSO Objects, Info Objects, Info Sources, Data Sources, Transformations, Transfer rules and Update rules
• Good Knowledge in ABAP development Populating Hana data in MS Excel.
• Experience in CO-PA extraction HC process and have reports built on it.
• Proficient in handling errors error’s occurred during Code review and performance tuning.
• Experience in extracting the data from ECC6.0 and loaded into BW 7.0 / HANA using BODS.
• Involved in Business Objects Administration creating users and groups, scheduling reports, publishing reports, planning security, authentication and single sign-on in for the reports developed using Business Objects 4.2/4.0.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality in BODS.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP using BODS
• Involved in developing Decision Tables, procedures and analytic privileges.
• SAP HANA data provisioning using Business objects data services (BODS) and SAP Landscape transformation (SLT).
• Implementation, Upgrade and administration experience in Business Objects suite
• Created Transient Provider, Composite Provider.
• Good experience with all the Data Provisioning techniques (SDI, SLT and SAP BODS), Modeling constructs (Attribute, Analytic, and Calculation) and reporting solutions (BOBJ Suite of tools) with Native HANA Azure SQL information models as a source.
• Experience in handling the Business Objects Modules Designer, Web Intelligence, Central Management Console and InfoView, Crystal Reports, Lumira and Design Studio
• Experience in Data Visualization tools LUMIRA, TABLEAU
• Exposure in Oil & Gas, Pharmaceutical, Retail, Telecommunication, Production and Sales Data Warehouses.
• Good analytical, problem solving, communication skills.
• Followed Agile development technique while building solution
• Involved in Business continuity planning activities during unplanned shutdown
• Good knowledge in Eclipse based BW/4HANA & S/4 HANA

TECHNICAL SKILL SET

ERP Packages: SAP ECC 6.0,S4 HANA

Business Intelligence Tools: SAP Business Objects, HANA Studio

ETL Tools: BODS 4.1, 4.2, Business Objects Data Integrator

Data Replication Technique: SLT, Migration Cockpit, DDL Script

Databases: HANA1.0/2.0, Oracle 10g/11g, SQL Server 2008/2012/2016

Programming Languages: ABAP, Python

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

SAP S4 HANA

Responsibilities:

• Migrating using Migration Cockpit via LTMC, LTMOM.
• Implementation/Enhancements
• SAP Migration Cockpit 1909 Design and Development
• Write Mapping tasks & simulation HC process connecting the source system, applying business use case/transformation logic to fit the Stage and Target data models.
• Develop Mappings, Packages, Procedures and Scenarios in MC 1909 to implement the data flow from source systems to FIORI environment.
• Develop the ETL orchestration in MC, execute and monitor the data flow periodically and assist in troubleshooting data sanity and compliance issues.
• Build Migration objects in FM2 environment based on the selection criteria and assign the correct Instance.
• Map the Mapping tasks and perform the simulation and Migration with the correct documentation.
• In LTMOM, customize the required table with AFS table and Fashion table and update MDG blocks for row level security, Prompts & Dashboard variables.
• Develop code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Creation of new Migration Object templates and template files.
• Master Data includes Cust Master/GL account/Profit center/Material Master/Trade/Plan/Company Code/Cost Element/Cost Center/ Azure SQL etc.
• Transactional Data Includes Open Orders /Cost center /Daily Sales/GL
• 3 Layer Architecture - Extract data from source and load to Output Layer
• Target system data is posted to HANA 2.0
• Written SQL queries to extract source data to Data Services staging
• Managed Error Handling and Success results to trace data migration
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Performed Data Conversions/functions before migrating data

Confidential

Environment: BODS 4.2, Sql server 2012, SAP S4 HANA 2.0, BI 4.2, BW

Responsibilities:

• Implementation/Enhancements
• Troubleshoot BODS connectivity issues with source systems, Azure SQL, Sql server and Hana
• Develop code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Migrating using Migration Cockpit via LTMC.
• Creation of new Migration Object templates and template files.
• Master Data includes Cust Master/GL account/Profit center/Material Master/Trade/Plan/Company Code/Cost Element/Cost Center etc.
• Transactional Data Includes Open Orders /Cost center /Daily Sales/GL
• Sources include SAP & Non Sap (Flatfiles/Json/Excel)
• Worked on Data Quality Transforms Address Cleanse/Match/Data Cleanse
• Read Inbound shared point files and batch numbers and load automatically to extraction layer
• 3 Layer Architecture - Extract data from source and load to Output Layer
• Further load data from Staging Layer to Data Inbound/Data Hub
• Target system data is posted to HANA 2.0
• Perform Adhoc loads & Archive source file once data load complete to HANA 2.0
• Written SQL queries to extract source data to Data Services staging
• Managed Error Handling and Success results to trace data migration
• Data migration to SAP HANA Enterprise and build Information models (Cal Views), Azure SQL, SQL scripting
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Performed Data Conversions/functions before migrating data
• Setting up of Data store connection to read source data from multiple source systems in BODS
• Extensively used BODS Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and DDL Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target
• Extracted larger volumes of data(SDI) using ABAP data flow transform into HANA DB in BODS
• Retrieved data using SQL Select statements as part of performance tuning in Data services 4.2
• Worked on DDL scripts while reading files from a folder using WHILE Loop in Data services
• POC on SAP integration with Python for SD module data flow.
• Data flow from non-SAP source for Sale order creation in AWS environment.
• Developed a SAP connector using Python,
• Unit and integration testing in Python on AWS platform.

Confidential

SAPHAL

Environment: BODS 4.2, BI 4.2(WebI), Lumira, XML, WebService, SAP HANA 2.0

Responsibilities:

• Handling priority/problem tickets/incidents/ housekeeping activities
• Troubleshooting BODS connectivity issues with source systems and Soap Webservice
• Develop code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Migrating Internal, Partner, Admin, Principle, Marketing, Promotion, Service, Pricing and Super users
• Master Data, User core attributes and Roles
• Sources include LZ(flat file), log files and Oracle schema.
• Validate against HR database for internal or external user classification
• Generating unique identity for each user using a function
• Convert user level codes for internal and Partner users based on requirement
• Worked on SQL transforms, DBlinks and Stored Procedures
• Written SQL queries to extract source data to Data Services staging
• Consolidate data from source systems and build XML structure
• Managed Error Handling and Success results to trace every user migration
• Worked on incremental loading for all the dimensions after initial load from stage to Data Mart (Star schema
• Data migration to SAP HANA Enterprise and build Information models (Cal Views), SQL scripting
• Sending and Receiving IDOC’s from SAP through BODS Integration systems
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Written & Performed Data Conversions/functions in PL/SQL Oracle Azure SQL 11g before Data migration
• Worked on BO universes IDT, WEBI, Crystal reports as per Business requirements.
• Worked on Data integration transforms History preserving, Table comparison, XML pipeline
• Setting up of Data store connection to read source data from multiple source systems in BODS
• Extensively used BODS Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and DDL Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target
• Extracted larger volumes of data(SDI) using ABAP data flow transform into HANA DB in BODS
• Retrieved data using SQL Select statements as part of performance tuning in Data services 4.2
• Worked on scripts while reading files from a folder using WHILE Loop in Data services
• Extensively worked on data validation and reconciliation BW, ECC, BO, HANA, DATASERVICES

Confidential

Environment: SAP HANA 1.0, BODS 4.2, BI 4.2

Responsibilities:

• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• Created Native HANA information models Attribute, Analytical and Calculation Views
• Worked on Explain Plan Tables, Visual Plan, Sql Tracing as part of Performance tuning in Native Hana
• Configured and Replicated the data from SAP / Non-SAP sources to SAP HANA using SAP Landscape Transformation (SLT), extracted external system data using SDI/SDA
• Built graphical Calculation views using Table functions as datasources for complex calculation in Native HANA
• Worked on performance optimization of SQL Query/Models using Explain Plan, Visualization Plan and Expensive Statements trace
• Good experience in working on HANA optimized Calculation Engine functions (CE functions datasources access & relational operators)
• Built Calculation views on virtual tables with Smart Data Access(SDA) mechanism in HANA
• Converted Attribute and Analytic view to Calculation views to reduce data transfer between engines in HANA
• Created Sql script based calculation views
• Analyzed and fixed real time replication server SLT delta failures in HANA
• Followed Best practices/Performance tuning in designing and building HANA information models
• Transport HANA model objects using HANA ALCM Source to Target systems
• Functional verification activities of Development, Quality and Integration systems
• Enhancing reports in LUMIRA and Webi, working on Lumira 2.0 proof of concept source as HANA
• Worked on linking Datasets and Building and Publishing Lumira Stories to BI Platform
• Created reports including formatting options such as Chart, Grouping, Sorting, Alerter, Ranking, Breaks, Sections, parameterized prompts.
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Modified existing BO universes and WEBI reports as per Business requirements.
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible.
• Support Business objects WEBI reports, Universe handling issues through incidents
• Worked on Data integration transforms History preserving, Table comparison, XML pipeline
• Setting up of Data store connection to read source data from multiple source systems in BODS
• Extensively used BODS Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and DDL Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target
• Extracted larger volumes of data(SDI) using ABAP data flow transform into HANA DB in BODS
• Retrieved data using SQL Select statements as part of performance tuning in Data services 4.2
• Worked on scripts while reading files from a folder using WHILE Loop in Data services
• Extensively worked on data validation and reconciliation BW, ECC, BO, HANA, DATASERVICES

Confidential

Environment:SAP BODS, BO 4.0, HANASPS 11, BPC 10.0, BW 7.0

Responsibilities:

• Involved in Statoil BO BW transition from IBM to CapGemini
• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• SAP HC process area’s involved SD, CRM, HR, Treasury & Payments, Accounting & Controlling, Plant O&M
• Classic and Sql script Analytic privileges and assign users to restrict accessing data native hana
• Business Objects reports on HANA modeling constructs (analytic, Attribute & Calculation views)
• Created Data Visualization dashboards using embedded Excel sheet integrated with BEX Queries.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab and conditional display of groups, fields, and messages.
• Created, managed & formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Developed crystal reports and performed unit testing
• Migration of BO reports, folders and universes from one repository to other repository
• Support Business objects WEBI reports, Universe handling issues through incidents
• Developed and executed unit test and integration test plan for BO reports
• Data load experience to SAP BW as Target, Success Factor using Data services
• Extensively worked on Data Services (Code Migration, Error Handling, Recovery Mechanism, IDOCS)
• Making use of SQL transform to read data from source system i.e. Oracle in BODS
• Setting up of Projects, Jobs, workflow, dataflow and make them uniquely grouped while moving across different environment in BODS
• Extensive use of Data integrator and platform transforms such as Key generation, Table comparison, Case, Merge, Validation, SQL, Query for transformation
• Created Profile and Central repositories to manage data consistency in BODS
• Migrate data for SAP FICO and HCM module objects such as Vendors, Customer, Materials, Purchase orders, Cost Centers, Profit Centers, Transactional data such as AP, AR, GL to single system ECC 6.0 in BODS
• Worked on Data Services Management console to create users and grant privilege to access repositories
• Performed Full pushdown, Source & Target based performance tuning, Bulk loading in BODS

Confidential

Environment: SAP BODS, BI7.3, Sql server

Responsibilities:

• Involved in designing technical specification document for PES BW
• Involved in build phase of the project
• Developed BI data flows using FLAT file extraction
• Responsible for creation of test scripts and documentation
• Involved in Data Loading & HC Process chain Monitoring
• Involved in unit testing, test case reviews and documentation
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible
• Design and Develop BODS batch jobs for Material Master, Azure SQL, Purchase orders, Asset Master and Batch Determination
• Use of Try-catch and while- loop transforms during splitting records in multiple files in BODS
• Use BODS conditional clauses such as where, group by, order by while restricting records
• Generating Tab delimited output file as per load program
• Publishing Data Quality report for quickly status meeting and decision making
• As per data quality report assist business users to modify and correct the data
• Following are Objects worked as part of data reconciliation activity: PO vendor master, Asset PO, WBS master, asset location, cost center in BODS

Confidential

Environment: SAP BI7.3, BOXI R3, Sql server

Responsibilities:

• Involved in requirements gathering, designing technical specification document for Project Systems
• Involved in BUILD and UAT phase of Project Systems Module (Master Data and Transaction Data)
• Responsible for creation test scripts and documentation
• Involved in planning and co-ordination of tasks
• Involved in Report testing, test case reviews and documentation
• Involved in unit testing, test case reviews and documentation
• Migration of existing in SSIS to Crystal reports from scratch
• Migrated the reports using LCM and import wizard
• Developed and executed unit test and integration test plan for BO reports
• Creation and maintenance of BO Universe and reports
• Worked on CMC module in creating user groups and folders and managing security in BO
• Involved in designing technical specification document for British Gas and Data ware House
• Involved in build phase of BGDW (Master Data and Transaction Data)
• Developed BI data flows using LSA methodology
• Involved in enhancing CRM & ISU datasources
• Responsible for creation test scripts and documentation
• Involved in Data Loading &Process chain Monitoring
• Test case reviews and documentation
• Involved in unit testing, test case reviews and documentation
• Understanding the client business setup and structuring Object repository in Business object data services
• Developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies.
• Most of the BODS transforms used Case, Merge, and Sequence Generator, Query Transform, Map Operations, Table Comparison, SQL, Azure SQL and Validation Transforms
• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing.
• History preserving, capturing slowly changing dimension data at every interval, DDL script writing, preparing the data from initial load perspective in BODS

Confidential

Environment: SAP BI7.3, Oracle

Responsibilities:

• Involved in requirements gathering technical pre-upgrade and technical post-upgrade activities
• Responsible technical pre-upgrade and post-upgrade activities
• Responsible for creation test scripts and documentation
• Involved in planning and co-ordination of tasks
• Co-ordination in India with respect to testing
• Involved in unit testing, test case reviews and documentation
• Interacting with Business Analysts for Requirements Gathering and clarifications. Provided the weekly status update on Project Progress.
• Created Cubes, DSOs, Multiproviders, Infoset, Transformations, InfoPackages and DTPs.
• Involved in implementing logic at Start Routine level
• Created HC Process Chains for automating data load process
• Created Open hub for extracting data from info cube into Flatfile/table.
• Involved in developing Interaction Analysis Queries using Restricted Key figures, Calculated Key figures, Filters, Free Characteristics, and Variables.
• Worked on Report to report interfaces(RRI) to drilldown to detailed Report
• Involved in Transportation of all Objects like: Info Objects, Query’s and DSO objects, Routines, Programs, etc. into BI test system after validation and testing the same in development.
• Prepared Project documents like Transport Checklist, Go-Live check list, Support document and Provided the Support Training to the Support Teams
• Created Unit Test Cases and Performed Unit testing
• Extensively Involved in System Testing and User Acceptance Testing
• Created crystal reports including graphical reports, formula based and well formatted reports according to user requirements
• Enhancements in BO universes and reports
• Interacted with users for analyzing diverse BO reports and scheduling them
• Involved in creation of webi, crystal and dashboards according to user requirements