SUMMARY

• Ambitious and dedicated professional targeting assignments in SAP BW / BI, BW on HANA and BW4HANA preferably in IT industry
• 5.5 Years of SAP BW/BI experience, which includes Modeling, Extraction, Loading, Monitoring, Reporting and Performance Tuning.
• Techno functional skills in SAP BW 3.5/BI 7 in area of Data Modeling, Extraction, and Reporting.
• Experience in working with Modeling, Configuring and customizing BW Objects and also creation of Info Cubes, DSO, MP and APDs.
• Experience in creating Formula, Selections, CKFs, RKFs, Customer Exist Variables, Conditions to meet Business Requirements.
• Experience in creation of Process Chains to automate load process in BW.
• Created Start Routines, Field Routines and End Routines for Data Transformation.
• Knowledge and experience in ABAP.
• Involved in design, development and implementation stages of the system development lifecycle which includes analysis, design, coding, troubleshooting, documentation, testing and implementation of various business scenarios.
• Involved to create WEBI reports on BEX queries.
• Knowledge on LSA++ Architecture, Open ODS Views, Calculation Views and SDA Approach.
• Responsible for organizing weekly status calls in order to acquire status from team members and providing status reports to management regarding deliverables that have been planned.
• Reviewed and prepared documentation of flows that have been developed by team and own.
• Analyzed new requirements and involved in the preparation of Design (Data flow diagrams), Technical specifications documents.
• Collaborate with Business Analysts during requirement gatherings and provided guidance in preparing technical specifications.
• Act as Individual contributor in technology areas in ways that comply with architectural standards, best practices and methodologies.
• Involved in several Knowledge transfer sessions within the team.

TECHNICAL SKILLS

Software Tools: SAP ECC 6.0, SAP BW 3.5, SAP BI 7.0/7.5

Programming Language: SAP ABAP Data dictionary, SQL, Python

Reporting Tools: BEX, WEB Intelligence

Primary Skills: SAP BI - BW, SAP ABAP basics, SAP BW on HANA

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Responsibilities:

• Project supports client’s SAP Production system majorly includes resolving incidents, new developments and enhancements in existing system.
• The project provides real time business insights to client to facilitate real time decisions.
• Started with working on SAP BW 7.4, developing and maintaining BW objects-Info objects, info cubes, DSOs, writing ABAP Routines based on the business requirements.
• Later on, moved to SAP BW on HANA 7.5 and Native HANA both and worked extensively on modifying the existing flows, creating ADSOs, building queries, CKFs/RKFs, Enhanced calculation views, Stored procedures as per the requirements.

Confidential

Senior System Engineer

Responsibilities:

• Involved in frequent client meetings to discuss project status.
• Involved in full cycle SAP BI Implementation from requirement gathering, design and development, testing, go live and post production support phases.
• BEX REPORTING - Expertise in front-end Business Warehouse components for queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Constant selection and Exception aggregation.
• Responsible for loading master data and transactional data from R/3 Data sources, Non-SAP sources and flat files.
• Writing routines (Start/End/Exit/Expert/Field Routines) and BADIs, good in debugging ABAP Code.
• Data source Enhancement using BADI.
• BADI implementation for F4 values restriction.
• Developed process chains for Master and transactional data
• Involved in escalating tickets regarding extraction and performance issues and also load failures.
• Creation of Generic Data Sources from Table, View and Function Module.
• Complete automation of all BI Daily, Weekly and Monthly loads (Info Package Scheduling) using Process Chain.

Confidential

Production support

Responsibilities:

• Monitoring different components of the process chains and analyzing and correcting the failures.
• Resolving user tickets within pre-defined SLA regarding daily data loads, fix report issues and reconciliation issues.
• Involved in data reconciliation activity from source to BI end.
• Extensively working with Transformations, Info Package, Data Transfer Process (DTP), and PSA for data extraction to transform and load the Transaction and Master data from SAP ECC 6.0 to SAP BI.
• Checking and maintaining the indexes of the cubes and maintain them for good query performance.
• Enhancing and maintaining process chain to improve the performance of the chains so that it is seen that it always completes within the SLA.
• Extensively Worked on performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.
• Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
• Involved in frequent client meetings to discuss project status.

Confidential

Production support

Responsibilities:

• Part of the monitoring team.
• Supporting end users.
• Monitoring different components of the process chains and analyzing and correcting the failures.
• Ticket solving and Process chain monitoring.