SUMMARY

• Having 10 + years of of experience as SAP BW/BI/ABAP/HANA Consultant .
• Worked in all kinds of BW projects like Implementation,Eupport,enhancement,roll up, upgradation and Migration.
• Expert in Upgrade porjects .
• Expertise in all phases of SDLC like Realization, Analysis, Functional and Technical specification, Development, Integration and UAT, End - User trainings and Post Go-Live support
• Experience in Leading and managing teams. Handled multiple roles like Senior BI consultant, Onsite Coordinator, BW Tech Lead and BW Developer
• Have hands on exprince in BW related ABAP.
• Experience in Data Modeling activities like creation and maintenance of InfoCubes, ODS/DSO, Info Objects, Multi Providers, Info sets, InfoPackage, Transformation and DTP.
• Strong knowledge in 24x7 Production Support
• HANA modeler experience includes creating Composite Providers, Advanced Data Store Objects, HANA Views (Analytic, Attribute and Calculation).
• Worked on SAP BW on HANA 7.3 to 7.5 Upgrade project
• Expert knowledge in Migration project .
• Having thorough knowledge on process chains
• Strong knowledge in Data Loading, Process Chains,Scheduling and Monitoring
• Strong Knowledge in Data Extraction: Flat File Extraction, Generic Data source Extraction of type View, Function module & tables and Lo-Cockpit extraction
• Strong knowledge in Reporting Environment using Calculated Key Figures, Restricted Key Figures
• Strong Knowledge on performance tuning activities like Aggregate, Compression, Partitioning,
• Excellent communication skills, systematic approach and ability to work effectively in fast paced environments .
• Expertise in ETL and Data Modeling (Data Extraction, Generic Extraction, Data Loading), Scheduling, Monitoring, Reporting .
• Worked as part of scrum team.
• Extensively worked on Data Source Enhancement using Customer Exit and Badi (Multiple Implementations).
• Proficient in all kinds of Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
• Expertise in design and development of Generic Data Source Extraction using Table, View, Info Set Query and Function Module with delta functionality.
• Extensively worked on Customer Exit Variables using Customer Exit and Enhancement Spot/New Badi (Multiple Implementations).
• Worked on Info Package and DTP routines.
• Expertise in Debugging, Performance tuning of various objects and designed the documents for best practices in BW environment.
• Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode ‘RSMIGRHANADB’.
• Good working knowledge in creation of Advanced DSO.
• Worked on Open ODS View, Composite providers and Transient providers.
• Proficient in importing HANA models into BW system.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Take Before and After Snapshots during 7.3 to 7.5 upgradation and make sure it behaves as it is.
• Perform SPDD and SPAU activities.
• Perform Queue clearing Delta initialization during cut over.
• Perform integration and Dress Rehearsal testing.
• Finding out All 3.X obsolete Data Flows.
• Covert existing Info spokes to OHDs
• Convert the existing Transfer rules and update rules to Transformations
• Migrate all existing routines carefully into Start or End Routines.

Confidential

SAP BW Consultant

Responsibilities:

• Take Before and After Snapshots during 7.3 to 7.5 upgradation and test thoroughly.
• Involved in Upgradation activities.
• Perform Queue clearing Delta initialization during cut over.
• Perform integration and Dress Rehearsal testing.
• Finding out All 3.X Data Flows.
• Migrate 3.X flows using RSMIGRATE tool and manually.
• Convert the existing Transfer rules and update rules to Transformations
• Migrate all existing routines carefully into Start or End Routines.
• Migrate export Data Sources to 7.X.
• Converted Return Table logic scenarios into end routine as and when required.

Confidential

SAP BW Consultant

Responsibilities:

• Analyzed the business requirements, proposes and implements new processing design.
• Worked extensively on enhancements and routines using ABAP
• Design and maintenance of DSO’s, Cubes, Info Objects, Info Packages, DTP’s, Data Source’s
• Involved in modeling the Data Flow as per Client requirement.
• Worked extensively on enhancements and routines using ABAP.
• Worked extensively on Data warehousing workbench
• Extracted data using Generic Extraction.
• Design and maintenance of DSO’s, Cubes, Info Objects, Info Packages, DTP’s, Data Source’s
• Created multiple queries as per client requirement.
• Worked extensively on BEx query designer to Develop reports.
• Optimized the existing reports performance.

Confidential

SAP BW Consultant

Responsibilities:

• Extracted data from IS-U system.
• Designed End to end solution based on Client requirements.
• Worked extensively on enhancements and routines using ABAP.
• Involved in modeling the Data Flow as per Client requirement
• Involved in gathering the requirement from Clients and deliver the reports.
• Worked extensively on Data warehousing workbench
• Extracted data using Generic Extraction.
• Design and maintenance of DSO’s, Cubes, Info Objects, Info Packages, DTP’s, Data Source’s
• Created multiple queries as per client requirement.
• Worked extensively on BEx query designer to Develop reports.
• Optimized the existing reports performance.

Confidential

SAP BW Consultant

Responsibilities:

• Interaction with client for requirement gathering .
• Worked on enhancements by using ABAP .
• Handled the tickets of Severity 1, 2, 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in system define tickets as well as user defined tickets.
• Manually Maintaining Work History for all the tickets until it is closed down.
• Handled different Tickets related to data mismatch, performed Data Reconciliation.
• Involved in Delta management and solve critical issues which are related with delta.
• Involved in performance issues like aggregate, compression, Indexes.
• Worked on Weekly and Monthly maintenance activities.
• Worked on BWA monitoring which involves creation and deletion of BWA indexes as maintenance activities during maintenance window.
• Worked on service improvements to eliminate the repeated failures.

Confidential

SAP BW Consultant

Responsibilities:

• Extracted data from ECC system using LO COCKPIT.
• Worked extensively on enhancements and routines using ABAP .
• Worked extensively on Data warehousing workbench
• Extracted data using Generic Extraction .
• Design and maintenance of DSO’s,Cubes,InfoObjects, InfoPackages, DTP’s, Data Source’s
• Testing the objects like Info Objects, DSOs, Info Cubes, Transformations, IP and DTP’s
• DSO has been taken as data staging area for consolidation before loading data into Info Cube
• Failed data packets are modified in error stack and reloaded to Info Cube using Error DTP.
• Involved in developing Info Objects, Info Cubes, DSO’s, Infosets and MultiProvider
• Involved in modeling the Data Flow as per Client requirement
• Creation and Modifications of Queries
• Conducting the peer-to-peer reviews and meetings