SUMMARY:

• Around 11 years’ experience in SAP which includes SAP BW, SAP HANA, SAP BPC, SAP ABAP, Business Objects verticals like Retail, HealthCare, Chemical and Manufacturing. Worked in the areas of Sales and Distribution (SD), Finance(FI), controlling (CO), Device Management (DM), Service Management(SM), Billing, Retail, Project Systems (PS), Material Management (MM), Inventory Management (IM) and Warehouse Management (WM) Reporting and have in - depth business process knowledge.
• 11 Years’ Experience in SAP BW (on HANA) with 8 full life cycle Implementations & 2 Enhancement & Support Projects
• 4 Years’ Experience on Enterprise HANA, BW on HANA and Hana Live with 2 full life cycle Implementations.
• 3 Years in SAP Business Objects (Web Intelligence, Lumira, Analysis Office, Design Studio)
• 1 Year in SAP BPC 10.1 on HANA

TECHNICAL SKILLS:

ERP Packages: SAP ECC 6.0

SAP Modules: SAP BW, HANA, BO, BI-ABAP, Data Services SAP BI - BW 3.5, 7.0, 7.3,7.4 (on HANA) SAP BO 3.1,4.0 SAP ECC 4.6,5.0,6.0 SAP BODS 4.0, 4.1 SAP HANA 1.5 SAP BO Suite - Design Studio, Analysis For Office, Lumira

Modules: FI, HR, SD,CO,PP,MM,CRM,IM,WM,DM,SM, Billing, Retail

Databases: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access,DB2,Teradata, XML, DTD,Web Services

PROFESSIONAL EXPERIENCE:

Confidential, OR

Senior SAP BW/HANA Consultant

Environment: SAP ECC 6.0, SAP FI, SAP HANA, SAP BW 7.4, SAP BO 4.0,SAP BPC 10.1,Tableau,ECC on HANA;HCI IBP

Responsibilities:

• Responsible for capturing requirements from NIKE SAP BPC Consolidation, Identifying the BW Extractors to UNITE consolidation from Nike/Converse SAP ECC Sources, Preparing Detail Design Documents, Configuring System/Interfaces, Preparing HPQC Test Plans to document Test Results, User Training, Post Go-Live Support, and Knowledge Transfer to Support Group.
• HANA and Business Objects Development done in Finance, purchasing Business Areas for the Nike Converse Projects: Developed Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Created Calculation views for Purchase Document Condition Model (Built on EKKO, EKPO, KONV, TCURX), New General Ledger HANA Model (Built on FAGLFLEXT, SKA1, SKB1,T001,TCUR* etc..), Sales Order Condition Model (Built on VBAK, VBAP,KONV,CDHDR,CDPOS).
• Expertise on configuring Hana Live for FI and OTC modules. Customizing HANA Live models to meet the business requirement.
• Expertise in Created Calculated Columns in Projection Views using Conversion Functions, Date Functions, String Functions in Expression Editor SQL Scripts, Stored Procedures, Function Calls, Triggers based on business requirements
• Expertise on Configuring using SLT replication & SAP Business Objects data services from ECC and CRM sources
• Created Universes on top of HANA calculation views and developed the WebI reports and dashboards using IDT Information design tool .
• Reports Developed in for Nike/Converse Project:
• Finance Reports: Vendor Due Payment Ageing Report, Customer Realization Bill Discount, Expense Variance Report
• Vendor Master Details Report
• OTC Reports: EMEA - Intrastat/Extra stat Report, Consignment Sales Report, Consignment Stocks, Sales Commission ReportCustomer Realization Report
• P2P Reports: PR to PO Cycle Time Report, Trading Company Commission Report.
• Extensively worked on creating SAP BODS Dataflow, DataStores, Batch Jobs to integrate CDB data & Amazon S3 tables into SAP BW of Nike & SAP HANA for Converse.
• Extensively used Query Transform, Map Operations, Merge, Case, SQL, and Validation Transforms.
• Extensively worked on integrating SAP BODS with Web Services
• Worked closely with SAP BW Basis team during SAP BW on HANA installations, performed one-time activities
• Extracted Converse New GL data into Nike SAP BW landscape (SAP BW(BMP/BWP/BIP) & SAP BW on HANA(BFP) Systems) views into Nike SAP BW Landscape
• Worked on creating Profit Center Accounting(0EC PCA 1) & New General Ledger(0FI GL 10) Data Models in SAP BW on HANA Creating InfoObjects, DataSource, Infopackage, DTP, Transformations, Advanced DSO, HANA optimized InfoCubes, MultiProviders, Composite Providers
• Integrate HANA models with SAP BW by developing objects like DSOs, InfoObjects, etc.
• Extensively worked on Data Flow Migration 3.x dataflows into 7.x dataflows using RSMIGRATE.
• Worked in Start routine, End routine, field routine, InfoPackage & DTP Routines in transformations - written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
• Created Transient Providers, Composite providers to import native HANA models to BW, exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
• SAP BW COPA Enhancements: Extensively worked on enhancing SAP BW COPA Dataflow, Extracting Consumer Package Quantity from CDB database into SAP BW using BODS Loading into 0MATERIAL and COPA dataflow lookup on 0MATERIAL to integrate Consumer Package Quantity and derive Nike Sales Quantity, Retail Consignment Quantity.
• Extensive worked in extracting SAP HR Systems using standard dataSources (0EMPLOYEE ATTR, 0EMPLOYEE 0077 ATTR, 0EMPLOYEE 0016 ATTR, 0HR PA 1, 0HR PA EC 02, 0HR PA EC 03. Created Open Hub Destination to load the BW data to Teradata Tables.
• Worked on Company Code Parameterization - Automating Company code/Plant Filters Nike Unite BPC Implementation.
• Enhanced the data 0EMPLOYEE ATTR from HR info type PA0077, 0EMPLOYEE 0016 ATTR from Infotype 0016, 0HR PA 1 from Infotype 0000 & Infotype 0302, 0HR PA EC 02 from Infotype 1500 & 1520, 0HR PA EC 03 from Infotype 0761.
• Implemented BADI’s for enhancing the datasources(RSU5 SAPI BADI).
• Worked on POC for Transforming SAP BW Queries into OData Service.
• Created Lumira dashboards (Proof of Concept) for Nike EFS reports on customized SAP HANA live View
• Worked on building BPC Environments, Dimensions, CONS & RATES Models
• Experience in loading the transactional ECC data into BW cubes and then into BPC cubes using data manager packages
• Extensively worked on loading PCA & New GL data from Converse ECC & Nike ECC to BW and using data manager package to load into SAP BPC CONS Model
• Extensively worked on loading Exchange rates Nike ECC to BW and using data manager package to load into SAP BPC RATES Model
• Extensively worked on Tableau, Smart Data Access (Data Virtualization).
• Good Understanding of Hadoop Architecture, Hadoop Mapreduce, HDFS PIG, HIVE, Apache Spark

Confidential, NJ

Senior SAP BI/BODS/HANA Architect

Environment: SAP ECC 6.0, SAP Vistex, SAP BI 7.4, SAP BODS 4.2,SAP HANA

Responsibilities:

• Actively involved in the conducting Reporting workshops for Confidential - Prism & SAP - EDW integration Project
• Involved in defining Reporting Strategy For Confidential ’s future analytic reporting & SAP - EDW detail design document.
• Installed Information Platform Services (IPS) 4.1 SP2 and SAP BO data services 4.2 on Sybase/Linux
• Assisted the SAP Basis Team in fixing BODS installation issues.
• Conducted Workshops with EDW Reporting team & SAP Functional Team to identify SAP Tables/Fields against Infinium Tables
• Designed SAP BODS dataflows (ETL) to extract SAP Vistex, SAP OTC, SAP Finance, SAP P2P Tables into Oracle EDW Staging tables which will be consumed into EDW Consolidation & Reporting Tables
• Involved in defining and ETL Strategy to extract data from SAP ECC transform the data and load into Oracle EDW to support Current Analytical reports running on Oracle EDW.
• Designed and modelled Business Objects Data Services dataflows to extract data from SAP ECC(on HANA)
• Extensively worked using ABAP Data Flows, ODP Standard & Custom Extractors, Importing BW Custom Extractors into BODS Designer, Data Load Monitor/Issues fixing using ODQMON
• Scheduled the Data Loads from SAP to EDW using BODS Management Console
• Scheduled batch jobs for processing flat files, XML files, XSD, DTD’s,Web Services as source as well as Target too.

Confidential, Shelton, CT

Senior SAP BW/BODS/HANA Consultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0,SAP BODS4.1

Responsibilities:

• Responsible for capturing Requirement (BRD’s) gathering, Conversion of BRD into Functional Spec’s, Converting the Functional Spec’s to Technical Specs for SAP ISU - Device Management, SAP ISU - Service Management, SAP Customer Service, SAP Billing, SAP Retail, SAP FICA, SAP HCM, SAP SCM Reports.
• Identifying the BW Extractors & Preparing the BW Technical Specs for Front Office modules Reports, Prepared HPQC Test Plans to document QA Results, User Training, Technical Documentation, Post Go-Live Support, and Knowledge Transfer
• Extensively worked on extracting & loading data from CAYENTA, ACCPAC to SAP HANA, SAP ECC, SAP BW using BODS 4.0
• Experience in Creating Attribute Views, Analytical Views, Calculation Views for following IS - Utility reports
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Worked on creating Data Models - Creating InfoObjects, DataSource, Infopackage, DTP, Transformations, DSO, InfoCubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ architecture.
• Extensively worked on creating SAP BW data flows for below IS Utility Reports.
• Worked in ABAP routines - Start routine, End routine, field routine and Expert Routines in transformations - written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
• Extensively Worked on Designing, Creating HANA analytical models, data provisioning into HANA tables, and designing and implementing Web Intelligence reports on HANA models.
• Created Composite providers to import native HANA models to BW and also exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
• Created and scheduled Master data and Transactional Data chains to automate data load process.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
• Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio.
• Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Extensively worked in integrating SAP BODS with XML, Webservices.
• Scheduled batch jobs for processing flat files, XML files, XSD, DTD’s as source as well as Target too.
• Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Enabled Business Objects Explorer to search data present in HANA.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO Analysis.

Confidential

SAP BI/BW HANA Consultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0

Responsibilities:

• Experience in improving Confidential ’s SAP BW Data Load Performance & Resolving Data Load Related Tickets
• Up gradation from SAPBI7.0 to SAP BW 7.3
• Experience in modifying the SAP BW dataflows to accommodate migration of SAPECC systems from multiple instances to Single Instance(Migrating SAPECC Local Systems )
• Resolving BWA related issues
• Expensively worked in converted “Rush OF” Weekly reporting to “Rush OF” Daily
• Worked on Infopackage, DTP’s Synch throughout the systems by reverse transporting objects from Production to Development to fix delta DTP issues
• Supports Confidential ’s Weekly, monthly, Quarter Yearly Financial closures.
• Utilized new BI 7.3, Dataflows, transformations and DTPs for all new developments.
• Developed numerous custom datasources using database views and custom function modules.
• Implemented new BI 7.3 security authorization objects.
• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
• Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3.
• Involved in creating many complex OLAP variables, DTP routines.
• Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
• Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billings by extracting Standard DataSources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.

Confidential, Canonsburg,PA.

SAP BI/BW Tech Lead

Environment: SAP ECC 6.0, SAP FI, SAP BW 7.0

Responsibilities:

• Interacting with client to gather Functional Requirements and Converting the Functional design to Technical Design. Worked on Technical Mapping Document for P2P,WM,OTC,QM Modules
• Designed on P2P (15), WM(3), QM(2), FI(3) Reports.
• Extensively worked on Generic DataSource using Function Module especially while extraction data from change log tables (CDHDR,CDPOS)
• Experience in designing, developing, testing P2P Reports like Lead time taken for PR to Payment, Due Date Vs Actual Paid Date; Pending 103,105 Movement Types,List of Amended Purchased Orders,Pending Purchase Requisitions Report
• Vendor Payment terms analysis,GR date Vs IR date report,Due date Vs Actual paid date report
• PR To Po Conversion Report for Specified Criteria,Closed PO's,Vendor wise Material Inventory
• GR Value Report,Percentage of Individual Material Price AnalysisProject System Report CAPEX Project System Report etc, PR release report etc
• Experience in designing, developing, testing Accounts Receivable reports built include Aging Summary by Customer - All Items, Vendor analysis, Customer Short Payment Items, Aging Summary by Customer - All Items - Net of Short-Pays, Customer due date analysis, Customer Overdue analysis.
• Created Inventory reports which include Vendor & Customer Consignment Stocks, Stock Analysis, Weekly Inventory Report, and Inventory analysis by plant & storage location.
• Experience in designing, developing, COPA Report - Sales & Profitability Analysis Report
• Extensively worked on designing Process chains integrating all modules Data Load.
• Designed and Tested the Confidential Process for Configuration Specification - OQ Test, Report FSF for OQ and PQ Test by using HP Tool.
• Extensively worked on enhancing Performed Master and Transaction data extractor business requirements.
• Training on SAP BI (Frontend) for Power Users and Business Users.
• Extensively worked with BEx Analyzer, Report Designer to create queries and design reports.
• Extensively worked with BEx to design reports and created queries using variables, conditions, filters, restricted and calculated key figures, formulas.

Confidential

SAP BW/BODS Consultant

Environment: SAP BW 7.3, SAP BODS3.2, SAP ECC6.0, SFDC, GMAT,SAP CRM

Responsibilities:

• Interacting with client to gather Functional Requirements and fixing the technical Issues.
• Installation of Business Objects Data Services 3.2, Address Directories, (Global, US, Canada, Germany), Cleansing Packages from on SAP BODS Server and configured the Data Store level setting to access the Address Directories.
• Established connectivity with Source Systems(SAP-R3,SAP-CRM,SFDC,GMAT)
• Expertise in creating SAP-BODS Projects, DataFlows, ABAP Work Flow, WorkFlows, Jobs
• Worked on Data Integration and Data Quality Transforms for effectively transforming the data from multiple source systems
• Extracted Customer Master data from SAP-R3,SAP-CRM,SFDC,GMAT Sources, apply data integration transforms to Standardize data, Data Quality transforms to Address Cleanse and Match Transform to apply de-duplication ( identifying the duplication records) and send the data to SAP-MDM
• Extracted Customer Master data from SAP-R3,GMAT Sources, applied data integration transforms to Standardize data, and Match to apply de-duplication ( identifying the duplication records) and send the data to SAP-MDM
• Applied Source level and Target level CDC( Change Data Capture) logic to extract delta records from
• SAP and non-SAP systems
• Performance Tuning while integrating, extracting, Customer and Material Master Data Standardization.
• Worked on BODS related Roles like ZBODS ROLE and Authorization for accessing the SAP-R/3, SAP-CRM tables through BODS Designer
• Transporting SAP BODS Related .ATL Files from Development to Quality and then to Production systems
• Created Central repository and connected the Job Server to Repository to connect to Database
• Scheduling, monitoring, and executing batch jobs using Management Console. Generated Data Validation Dash Boards and Data Quality reports to validate the data
• Extensively worked on Unicode Related Issues while doing Address Cleansing using Japan,
• China Address transforms.
• Created File Formats for Exporting Data into a Flat File
• Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions.
• Master and Transaction Data extraction from Flat files and loading into Info Objects, DSOs and Info Cubes.
• Performed analysis, design, development and implementation of standard/customized Info Cubes and DSO Objects for SD, FI and SCM modules.
• Created intermediate write optimized DSO Structures and APD’s in BI7.0 to improve performance while loading AP data.

Confidential

Sr. SAP BW/BODI Consultant

Environment: SAP BI7.0, BODI

Responsibilities:

• Interacting with client to gather Functional Requirements from business and prepared ETL Strategy and Reporting Strategy Document.
• Extracted data from Oracle, My SQL, ECC6.0 Transformed and Loaded into a staging Area using Business Objects Data Services.
• Worked on Data Integrator and Data Quality Transforms for effectively transforming the data
• Created Projects, DataFlow, Work Flow, Jobs and executed Jobs in Batch/Real-Time Mode
• Developed Universes on BW-BEX Queries and created Web Intelligence Reports
• Implemented parameters, filters, formulas, sorting and drill down and List of Values in the crystal reports.
• Created complicated crystal reports including sub-reports, Adhoc reports, graphical reports, formula base and well-formatted reports according user requirements

Confidential, NJ

SAP BW Consultant

Environment: BW 3.5/7.0, R3 4.6C, BEx, FI, SD, MM, PP.

Responsibilities:

• Involved in the project from User requirements gathering, Business Blueprint, Realization and Testing Phases.
• Integrated FI with CO, SD, MM and PP for the logistics and order management trade and Inter-company transactions.
• Configured the integration steps for Account determination and Revenue account Determination for inter-company transactions
• Maintaining consistency in the Master Data across systems.
• Written ABAP code for function enhancements (User Exits) to accommodate additional fields in the extract structure of the data source.
• To provide a simple, clean Open Hub Service for all kinds of data extraction requirements (Full/Delta/Complete Refresh) for the following six UPS Tables (Customer, Finished Product, Unit Price, Raw Material, Supplier, Supplier Component)
• To implement the dynamic filter logic within BW using Transformation BADIs for the six tables mentioned above.
• Process Chain Design and data load performance tuning.
• BW Data load Scheduling, Monitoring and Troubleshooting data extraction/ load Problems
• Involved in monitoring and scheduling of Info package groups and Process chain
• Involved in Converting InfoPackage Groups to Process Chains
• Ensure that all periodic schedules like daily/weekly and monthly are successful
• Analyzed the errors occurred while uploading the data if the request fails and make the latest data available in data target
• Wrote Routines to handle Invalid Characters
• Involved in creating and moving Transports from Development to Production using specific transportation tool GSKC (Development to Quality, then to Production)
• Provided user training and prepared user documentation for all important business processes.
• Extractions From SAP MM, FI, PP, SD, HR, SRM & Generic Data-Sources
• Performance tuning -- For Data load, Queries by using HINT table concepts, Aggregates, BWA indexes, Compression, implementing dynamic Semantic partitions (SPO) & analyzing by client Statistics data
• Reporting Automation of Data loads -- Creating Process Chains and Monitoring, Scheduling Delta loads & Performing Error Handling
• Moving data to Upstream -- Experience in Data Mart, Open Hub Services, APOs Defect/Change request tracking -- Experience with Mercury Quality Center & Remedy tools for test management, requirements gathering and defects tracking; functional testing and regression testing.

Confidential

SAP ABAP/BW consultant

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, MM, HR, FI, CO

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live and production support.
• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI in SD, MM and FI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
• Created report lists for the gross sales, credit returns, gross weight for the customer for the current year and comparing the same with that of the previous year for the same period. The data is selected from KNVV, BKPF, BSEG and MARA.
• Created commission report for the sales department sorted by sales representative. The data is extracted from VBAK, VBAP, KONV, and MARA tables
• Designed and implemented data migration from Legacy system to SAP R/3 using BDC.
• Designed and coded a BDC program for Open Sales Orders that updated records in the sales order screen or will create new sales orders depending on the source data file from external systems using VA01 and VA02 transactions.
• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Infocubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data targets in the system.
• Monitoring the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data targets.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates, indexing of Infocubes.