PROFESSIONAL SUMMARY:

• Having 12+years of experience in IT industry, SAP MDG on S/4HANA, BODS, Info Steward, Business Objects, BW HANA, Tableau and 2years in Microsoft .NET and Software Testing
• Experience in Implementation, Support, Maintenance & Development
• Involved in SAP MDG 9.2/9.1 Data, Process, UI modelling and Data Replication in MDG - M/S/C/F Domains S/4HANA 1809/1909
• Involved in Analysis, Design, Development, Testing, Implementation and Support phases of the Projects for both SAP MDG, SAP BW, BO, HANA, BODS and Microsoft .NET
• Extensively worked on BW Composite Provider, ADSO, Info Cubes, DSO Objects, Info Objects, Info Sources, Data Sources, Transformations, DTP’s, Multiproviders, Transfer rules and Update rules
• Good Knowledge in Generic extraction and LO Extraction
• Extensively worked on Web Analyzer and BEx Query Development for Reports creation.
• Experience in CO-PA extraction process and have reports built on it
• Proficient in handling errors error’s occurred during Profitability Analysis (CO-PA) data loads
• Familiar loading data to CO-PA data targets COPAo01B and COPA T02A
• 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.
• Used Open Hub Services to push data out of SAP BI using BODS
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality in BODS.
• Used Data Integrator and Platform Transforms extensively in BODS
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP using BODS
• Tableau desktop and server experience
• Exporting and Importing meta data in Native HANA and expertise in managing Native Hana modeling concepts, Hana Live (RDS) views
• Good experience on PL/ SQL(DDL, DML, DCL, Stored procedures) using Native HANA as a Database
• 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 information models as a source.
• Built Analysis Office reports (AO) on Hana information models
• 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
• Good knowledge in Universe designing, developing and generating complex, Adhoc Reports, Business views, List of values, reporting functionalities such as Master Detailed, Slice and Dice, drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. SME in Dashboards, Best Practices in Dashboard Design, KPI Formulation & Web Reporting, developing information spaces and exploration sets in BOBJ
• Exposure in Oil & Gas, Pharmaceutical, Retail, Telecommunication, Production and Sales Data Warehouses.
• S/4 HANA migration cockpit (LTMC) - Migration Object Modeler (LTMOM)
• Legacy Master Data (Business Partner/Material/Financials) & TD migration to S/4 HANA 1909
• Good knowledge in Eclipse based BW/4HANA & S/4 HANA (1809/1909)

TECHNICAL SKILLS:

ERP Packages: SAP BW 7.0, 7.3, 7.4, ECC 6.0Master Data Management SAP MDG 9.1, 9.2, DRF, DM, PM, UI Modelling, BRF+, DQ SEARCH

Business Intelligence Tools: SAP Business Objects (WebI, Crystal reports2013), AO, OBIEE

Data Visualization: BO Lumira 1.31,2.0 Design Studio 1.6, Tableau 10,10.3

ETL Tools: BODS 4.1, 4.2, BODI, Talend 7.1.1, 7.2.1, SAP RDM s/4 Hana

Data Replication Technique: SLT, SDI,SDA

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

Microsoft Technologies: .NET 2005, C#

Programming Languages: ABAP/4-BW

PROFESSIONAL EXPERIENCE:

Confidential, MI

Environment: BODS 4.2, BW 7.4, SAP ECC/CRM/SCM, AZURE, HANA 2.0

Responsibilities:

• Implementation/AMS
• Data migration from SAP ECC & Flatfiles to SAP HANA with BODS 4.2
• Data migration from SAP ECC & Flatfiles to Microsoft Azure Data lake
• Defect fix/Data Reconciliation
• Data Services Production system Improvement measures
• Perform Adhoc loads &Archive source file once data load complete to HANA 2.0

Confidential, MN

Environment: BODS 4.2, BW 7.4, SAP ECC/CRM/SCM,S/4 HANA, BIG DATA, AZURE, CLOUDERA, MDG

Responsibilities:

• Implementation/AMS
• Designed and developed data ingestion (Replicate/ETL/ELT), conceptual, logical, physical data models, data marts, analytics and visualization, performance
• Ingest SAP ECC SCM Full & Delta loads to cloud-MS AZURE BLOB container
• Ingest SAP CRM/ECC BW EXTRACTOR data & flatfiles to cloud-MS AZURE BLOB
• Master Data Attribute, Text & Transactional Data
• Build DSO/OpenHub and Ingest Nalco system data to AZURE BLOB
• Collect and import BW transports to Production
• Build Batch jobs and perform Delta Initialization in Sap Data Services
• Automate Batch jobs with load type variable for Full, Delta and Adhoc loads
• Expose custom extractors to ODP API to consume in Data Services
• Import extractors in Query & CDC mode
• Perform archive operation, MD/TD Data reconciliation with source
• Define Primary keys, Delta type &Metadata for extractors (ECC, SCM, CRM)
• Assist HADOOP team for Schema creation, schema enhancement, FL, DL, Data Validation
• Automate the SAP DS jobs in UC4
• Data migration LTMC - LTMOM to S/4 HANA using Files & Staging Tables with BODS/Data Services
• Troubleshooting Data Service BW extractors Delta monitor
• Recovering files from Archive to Azure blob
• Analyze data in AZURE DATA BRICKS/AZURE DATA LAKE/AZURE DATA FACTORY
• Recovering failed Delta from BW extractors (SCM) in ODQMON
• Data Services Production system Improvement measures
• Handling Data Reconciliation issues Azure DATA LAKE and ECC/CRM/BW
• Setup Data Store connection to ATTUNITY and extract FULL load using BODS to Azure
• Knowledge in PYTHON scripts

Confidential, Delaware

Environment: BODS 4.2, Tableau, Sql server 2012, Windows Script, SAP HANA 2.0,BI 4.2, BW

Responsibilities:

• Implementation/Enhancements
• Troubleshoot BODS connectivity issues with source systems, Sql server and Hana
• Develop code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Migrating Specialty Products Data(SPECCO),CORTEVA(AGCO) MD/TD
• Master Data includes Cust Master/GL account/Profit center/Material Master/Trade/Plan/Company Code/Cost Element/Cost Center etc.
• Transactional Data Includes OpenOrders /Costcenter /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
• Confidential system data is posted to HANA 2.0
• Perform Adhoc loads &Archive source file once data load complete to HANA 2.0
• Analyze the reports built on Confidential System with Tableau
• Written PL/SQL queries to extract source data to Data Services staging
• Managed Error Handling and Success results to trace data 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
• 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
• 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 Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired Confidential
• 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

Confidential, New York

Environment: BODS 4.2, BI 4.2(WebI), Lumira, Oracle 11g, 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, Roles and Sellto Billto Information
• Sources include CNA UAM Oracle schema and LZ(flatfiles)
• Confidential system Soap Webservice and intern data is posted to Oracle db.
• 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 PL/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 11g before Data migration
• Worked on BO universes IDT, WEBI, Crystal reports as per Business requirements.
• Information Steward for data profiling, validating rules, scorecards, metadata management
• 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 Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired Confidential
• 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, NJ

Environment: SAP HANA 1.0, BODS 4.2, BI 4.2, Tableau, BW 7.4, IP

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 DataSource 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 DataSource 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 Confidential 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
• Information Steward for data profiling, validating rules, scorecards, metadata management
• 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 Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired Confidential
• 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, Tableau, HANASPS 11, IP, BPC 10.0, BW7.0

Responsibilities:

• Involved in Confidential BO BW transition from IBM to Confidential
• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• SAP 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 Confidential, 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 comparision, 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 & Confidential 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 & 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, 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, WBSmaster, 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

Confidential

Environment: SAP BODS,BI7.3, SAPCRM, SAP ISU, Oracle

Responsibilities:

• Involved in designing technical specification document for British Gas and Data warehouse
• 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, 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, script writing, preparing the data from initial load perspective in BODS