SUMMARY

• 10+ years of professional IT experience in HANA(one year) & SAP BI/BW with fair exposure in implementation and in Application support projects. Good experience in supporting Application maintenance system supporting BMC Remedy, Lotus Notes Tools for preparing the Analytics on Incidents. Designed and built BI/BW infocubes for cross application areas SD, MM and FI - GL/AP/AR. Worked extensively and good experience in Design, Dev and maintenance of BI/BW data loads, Reporting and Monitoring of BI systems.
• 9+ years of experience in HANA & BI 7.0+ includes Data-Modeling, Data Acquisition, Designed & Customized Info-cubes, Data Store Objects, Multi-Providers, Transformation, DTP (Data transfer Process), Open Hub Destination (OHD) and Process Chains.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Scheduled Data loads using Process Chains to load Transaction data and Master data from SAP R/3, Flat-files and Non-SAP Data Sources.
• Designed and built BW Info Cubes for Cross Application Areas FI - GL/AP/AR, SD and MM.
• Expertise in OLTP data extraction from SAP R/3, ECC 6.0 source systems using LO-Cockpit, Cross Application like Generic Extraction and Flat files.
• Experience in activation of Standard Business content based on the requirements
• Developed various transformations to cleanse the data and enhance the master and transaction data by creating start routine, End routine, Field routine and Expert routine to suit the business requirements.
• Created process chains to load the data into the targets and monitoring the same for daily, weekly and monthly schedules.
• Experience in Performance tuning for improving data loading and query performance by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes.
• Expertise on testing the extractors, data loads and reports before heading towards UAT and PROD.
• Developed Queries to access data from various Info providers like DSO's, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer
• Good experience in Transporting of objects from one environment to another environment (DEVàUATàPROD).
• Created Generic Data Sources (Custom Extractors) using Tables / Views and enhanced Business Content Data Sources using User Exits.
• Created Queries using BEX Query Designer and also have knowledge of Web Application Designer.
• Reporting - Worked extensively with BEx Analyzer, Query Designer, in building Queries and created Calculated Key Figures, Restricted Key Figures and Variables.
• Having good understanding capability on SAP BPC with FI knowledge.
• Internally trained on Business Objects & Tableau.

TECHNICAL SKILLS

SAP Data Warehousing: SAP BI 7.0; SAP BW 3.5, HANA

OLTP tools: SAP ECC 6.0 ; R/3 4.7

Languages: C, C++, Java/J2EE

Operating Systems: Windows XP, 2000 Server, 9X, UNIX

Databases: MS-Access, SQL Server6.5, Oracle

Web Applications: ASP.Net, JavaScript, VB Script, HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

HANA & SAP BI/BW Consultant

Environment: SAP HANA, SAP BI 7.0 / BW 3.5, SAP ECC, SD, MM, BEx Analyzer, Query Designer

Responsibilities:

• Designed & developed HANA models using Attribute view, Analytical view, and Calculation view using graphical and SQL script.
• Worked on Data Provisioning using both SLT & Flat file methods for loading data in SAP HANA.
• Worked on loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, and calculation views.
• Loaded Data into SAP HANA from BW using SLT Replication.
• Involved in creating Semantically Partitioned Objects(based on Infocube and DSO), InfoCubes, DSO’s and Info Objects.
• Knowledge on BODS to extract data from SAP & Non-sap sources to SAP HANA.
• Designed Schemas, table definitions, Attributes and Measures.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Preparing the Functional Design Document's and Technical design documents.
• Being part of Run and Maintain support team, responsible to keenly monitor batch network and address the process chain failures promptly to make sure the less possible delay in the data availability.
• Responsible for resolving the service tickets such as Incidents/Change requests
• Experienced in Ad-hoc data loading requests from the business via flat-file source system.
• Creating the Infospoke's to extract data from ODS, Cube and Multi-provider.
• Extraction of data from SAP and sending it to Informatica.
• Creating the transformations for extracting the additional data from the infospoke by using BADI.
• Extracting the data from BW and sending it to Informatica and Third party systems through CSV files.
• Coordinating with the Informatica team for unit testing, BIT and USAT.
• Independently handling all the development work and unit testing in the development.
• Handled production data loads effectively
• Attending the daily calls with onsite team and discussion on the open items.
• Actively participated in QMW (Quality Maintenance window) activities such as delta drain, stopping/scheduling V3 jobs.
• Creating Queries as per the client requirements.
• Experienced in SAP Transport Management system.
• Experienced in rectifying data load failures such as special character arrivals, editing PSA data, roll up failures, short dump analysis, etc.
• Involved in data source enhancements as part of Change requests
• Optimized the ABAP code in the routines to improve the load performance.
• Involved in internal sessions as a trainer as part of knowledge sharing.
• Involved in identifying performance improvement areas, such as DB statistics, SQL trace, etc..
• Extracted data from SAP and Non SAP systems.
• Responsible to give root cause analysis for all production issues.
• Responsible to load the Master and Transaction data of DuPont on Daily Basis.
• Worked extensively on business of DuPont in areas like SD, MM & FI-AP/AR/GL.
• Modified Update Rules to enhance performance to trouble shoot errors.
• Extraction of data from SAP and sending it to Informatica.
• Responsible to handle Category 2, 3, 4 and 5 Tickets.
• Responsible to make design changes for new requirements
• Responsible to create OSS messages and solve critical production issues with SAP coordination.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 Source system by using LO Cockpit.
• Involved in requirement gathering, design and delivery of build and 8 reports.
• Created generic data sources and replicated in BW to extract the master data.
• Scheduled data loads to BW from SAP R/3, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
• Reviewed performance bottlenecks and tuned inefficient queries using Aggregates, and Compressions.
• Reconciled the data in SAP R3 and SAP BW before and after data loads.
• Modified and enhanced existing queries to match the new business requirements.
• Performed system testing/integration testing of reports developed.
• Involved in 3 implementation projects which includes Queries, APDs, ODS, Infospoke objects.
• Have been POC for a major development module and ensured smooth and defect free Go-Live within the BI Space and also have been POC for APD and Infospoke issue in BI space.
• Worked parallel with ETL team and SAP BO team for sending the data to ETL through open hub and Infospoke.
• As part of this initiative we reverse migrated all queries/workbooks from production environment to Development environment which included activities like opening the Production system from SCC4 and SE06. Locking all Users except the team working on the Query/Workbook transports and stop all batch jobs
• Delete all non-transportable queries in the SAP BI Development system using the Tcode RSZDELETE
• Collect all the Global Variables in the SAP BI Production system in a transport request from the table RSZGLOBV and import it to SAP BI Development system
• Check the Currency translation keys in the SAP BI Production system and make sure the same exist across the BI landscape from RSCUR Tcode
• Need to have access to SE01, SE03, SE09, SM37, SE16, and RSRT Tcodes in the Production system for carrying out the Query Transports. RSA1 -> Transport connection -> Query Elements -> Query is from where we need to collect
• Post imports of queries identify the relevant workbooks from RSRREPDIR and RSRWORKBOOK tables.
• Once all workbooks are selected from RSA1 -> Transport connection selected make sure in the “Grouping” you have “Only Necessary objects”, and “Collection Mode” as “Start Manual Collection”. Click on the truck symbol and collect all the workbooks in a new transport

Confidential, Houston, TX

SAP BW Consultant

Environment: SAP BW 3.5, R/3, Bex Query Designer, Query Analyzer

Responsibilities:

• Scope of Solutions: Focus Areas - Sales & Distribution, Material Management.
• Gathered requirements from the user and worked closely with senior executives to define the key performance indicators (KPIs) in different business areas.
• Set up procedure for extracting R/3 data for Customers, Sales Order, Delivery, Shipping, Billing Document in Sales and Distribution using LO-Cockpit.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Used LO Extraction to extract data into DSO. Developed Sales Cube and Billing Cube for Sales Analysis.
• Worked extensively on Business Content and installed necessary BI objects for extracting data from SAP R/3 into BI
• Worked on Data warehouse workbench, Maintained and Created Info Object, Data Source, Infopackage, Transformations, routines and DTP
• Maintained the Customized Infocubes and creation of Infopackages and Scheduling the data into the Data Targets.
• Developed Infosets and Multi-providers. Created Aggregates for Info Cubes to improve performance.
• Uploaded master data and transactional data from SAP R/3 via Data staging to PSA, DSO and Info Cubes.
• Created Infopackages and scheduled them in order to load Master Data and Transaction Data from SAP R/3 as well as Flat File Source system into SAP BI Data Targets.

Confidential, Newark, NJ

SAP BW Consultant

Environnent: SAP BW 3.5, SAP R/3, Bex Query Designer, Query Analyzer

Responsibilities:

• Modified standard and created custom Info Source/Data Source, DSO, and Info Cubes (standard and MultiCube).
• Maintained and created Aggregates and Hierarchies.
• Created customer Defined Info Objects and Info Object Catalogues for Characteristics and Keyfigures in MM, SD, and FI.
• Used the Business Content Sales Overview Infocube (OSD CO3) for overall Sales Analysis.
• Used the Business Content Delivery Service Infocube (OSD CO5) for Reporting and Analysis. The data is analyzed based on Quantities delivered too early, Quantities Delivered too late, and Correctly Delivered Quantities and Average Delivery Processing time.
• Extensively worked on the Data Warehousing Workbench for Configuring, Scheduling and Monitoring functions
• SAP BI7.0 performance and tuning.
• Schedule Daily/Weekly/Monthly data loads schedule new jobs.
• Create and monitor aggregates.
• Create variables for BI Queries
• New Info cubes Creation and Apply BI Business Content.
• Involved in Transportation of all Objects like: Infoobjects, Query’s and DSO into BI production system after validation and testing the same in development system

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3, Bex QD, Query Analyzer

Responsibilities:

• Worked with several users, and interacted with them to gather requirements and transformed them into a data model with the concept of extended star schema.
• Analyzed business reporting requirements that could be satisfied with SAP business content and Kernel delivered cubes and installed the necessary objects.
• Provided Documentation on all the developed cubes in all the modules and also the changes made to the kernel delivered cubes to satisfy the business reporting in this specific site.
• Involved in the implementation of BW in SD and FI modules.
• Activated ODS objects and standard queries from the business content.
• Responsible for design, development and extraction from R/3 Source system and Flat file to BW for SD and FI using LO Cockpit extraction method.
• Extracted data from SD and uploaded the data into the procurement cubes.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Created info sources, info cubes, aggregates, ODS objects for incoming sales orders according to sales organization, distribution channels and divisions.
• Customized the Update rules using formula editor and before loading data into the info-cubes and ODS Objects.
• Designed permanent templates for web reporting, and configured the system to publish variables on the web.
• Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures and calculated key figures.
• Involved in testing the extractors, data loads and reports before going into production.