SUMMARY

• Over 12+ years of IT experience, which includes more than 8+ years of Technical/Functional and experience in SAP BI 7.3/7.0,BW 3.5 and SAP HANA DB (EDW, Extractors, Reporting query and analysis & Webi).
• Excellent knowledge of SAP BI & BW components like Info Cubes, Multi - Cubes, Remote Cubes, Info Sources, Data Sources, Info Objects, Info Providers, Multi Providers, ODS objects, Info set, Update rules, Transfer rules, DTP & Transformations.
• Expertise in OLTP extraction from R/3 source systems such as LIS, LO-Cockpit, CO-PA, Generic Data Extractions using Function Module from non-R/3 source systems & Flat file.
• Expertise in Report Generation - Worked extensively in BEX analyzer, BEX XLS query, Query Designer, Web Application Designer, Info set queries, Jump analysis using RRI, Routines and enhancing user exits, Administration workbench.
• Hands on Experience in writing ABAP/4 code for User Exits/Customer Enhancements.
• Created and executed process chains to load the data into the Infocubes, ODS objects, Info Objects and monitored the process chains for daily, weekly and monthly schedule of loads.
• Involved maintenance of Roles and Authorizations to users for BI security.
• Expertise in testing the extractors, data loads and reports before heading towards Production.
• Effective in executing multiple tasks and assignments ahead of schedule. Having good analytical and communication skills, demonstration ability.
• Knowledge on SAP HANA.

TECHNICAL SKILLS

ERP Packages: ECC 6.0 and SAP R/3 - 4.7 / 4.6C.

Data Warehouse: SAP BI 7.5/7.3/7.0 and SAP BW 3.5 / 3.1C.

Reporting Tools: BEx Explorer, Business Objects, WAD, BEx Browser, Hyperion Brio.

Languages: ABAP/4, SQL.

Database: Oracle 9i, 10 g.

Operating Systems: Windows, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BW/BI Developer

Responsibilities:

• Involved in 24×7 Production Support.
• Daily trouble shooting of Incidents, Implementing changes and requests.
• Maintain Work History for all the Tickets until it is closed down.
• Worked on integrating Exceedra Trade Forecast data into SAP BI APO environment.
• Created customized Objects for TPM. Extracting Data from Exceed into BI.
• Supported BPC related issues & ran BPC jobs for quarter end & year end.
• Actively and regularly involved in Monitoring of Daily, weekly, and Monthly data loads using Process Chains, Monitoring logs, Scheduling, Cancelling long running jobs.
• Performance tuned process chain to run faster.
• Generated and supported Portal reports & iViews.

Confidential, TX

SAP BW/BI Developer

Responsibilities:

• Involved in testing & resolving SAP BI 7.3 & Hana DB issues.
• Involved in the migration of BW Database from DB2 to HANA
• Compared Front end reports with 7.0 & 7.3 systems.
• Help identify some of the issues raised by 7.3 system upgrade.
• Work extensively on resolving defect which were raised while testing.
• Extensively worked on getting back 800 GB of space.
• Identified and planned the high consuming DSO’s and Cube & interacted with the user for the retention of the data.
• Automated Selective Deletion through ABAP programs.
• Create Open Hub’s to transfer data into SQL Server DB using SSIS.
• Worked on Production Support.

Confidential, TX

SAP BW/BI Consultant

Responsibilities:

• Involved in designing, Testing & redesigning realignment of Materials in SAP BI APO
• Identified and Created semantically partitioned objects for Daily Sales order item Cubes (ZSDHSC01, ZSDHSC02) and DSO’s (ZSDSLD02).
• Execution of project plan in project system and production environments.
• Rewrote the logic to make sure realignment of materials, Location & customer happens.
• Extensively worked on Real time info Cube & DSO’s redesign.
• Worked on enhancing & extracting data from ECC by using LO extraction for 2LIS 11 VITM.
• Enhanced custom programs and tables to populate fields.
• Created logic to populate weekly and daily Materials.
• Coordination with Basis & Release management teams.

Confidential, TX

SAP BI/BO Consultant

Responsibilities:

• Involved in Optimization & Archiving projects.
• Extensively worked on Cube & DSO redesign to accommodate huge amount of Sales, HCM(HR).
• Created Cubes, DSO’s, Transformations, Routines, Open hubs to split FLNA (FritoLay) Data & NABQ ( Confidential ) data.
• Mapped new Cubes to existing Multi providers and changes the existing reports to populate FLNA data.
• Extensively worked on enhancing & extracting data from SAP ECC by using LO extraction (08.Shipment, 11.SD Sales, 13.SD Billing).
• Extensively worked on Compression of FLNA Cubes.
• Identified top 20 space consuming DSO’s and changed the once with Full load to Write optimize DSO.
• Creating a comprehensive archiving process flow & Identifying priority objects for data archiving.
• Identifying the impact of archiving the objects; i.e. which tables, reports and transactions are in scope.
• Created and Modified 30 existing Sales reports.
• Created Archiving DSO’s & Archived.
• Involved in production support activities & resolved tickets raised by the user.
• Generated HR reports using WEBi.

Confidential, CA

SAP BW/BI Consultant

Responsibilities:

• Extensively worked on Transport of info objects, Cubes, DSO, Process chain, Transformations etc from BD5 to BQ5, BD3, BQ3 & BP3 systems.
• Synchronized BD5, BD3, BQ5 and BQ3.
• Created the Master Data Process chain, APO DP Process chain & Meta Chain.
• Extensively worked on setting up of procedures for extracting data from SAP ECC by using generic extraction (ZINV MBEWH) & LO extraction (11.SD Sales, 13.SD Billing).
• Monitoring Daily loads & solving the load issues.
• Analyze recurring problems with data loads and identified the root causes.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Modified existing End Routines to improve Data load performance.
• Created reports on Order fill & Case fill rate, error free orders, Order by status, Ontime delivery over ISD C96 Cube.
• Involved in submitting the ticket status (open/close) report.
• Handled the tickets of priority by following Standard Operating Procedures and never missed the Service Level Agreement (SLA).
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages

Confidential, IL

SAP BW/BI Consultant

Responsibilities:

• Involved in complete End to End Implementation and Integration of Historical data from Oracle Database.
• Created the Data Flow Diagram and designed the complete data flow through different sources.
• Gathered requirements from Business users for Historical data modeling of different schemas from the legacy systems such as OMS, VISTA, Hyperion, PeopleSoft and worked on the development of modeling master data and transactional according to the change of business.
• Extensively work on extracting data from Oracle Database and integrated it with Actual Data.
• Worked with Flat file Data sources and established DBConnect to extract data from the OMS systems into SAP BI.
• Created Eight DBconnect datasources WO DSO’s, standard DSO’s, Info cubes and adjusted Multi providers so as to harmonize granular data from the actuals and history for reporting needs.
• Involved in building the reports Monthly Read Rate; Monthly Detail History.
• Optimized Query and loading issues.