SUMMARY

• A goal - oriented professional, offering 8 years of experience with SAP BW, HANA, BO and Oracle applications
• Possesses adept consulting skills, involving understanding client’s business pre-requisites, architecting viable solutions and guiding the implementation of end product
• Performed well in both managerial and architectural aspects; completed complex project tasks; identified key drivers of defined problems and proposed innovative solutions
• Highly skilled in managing Full Life Cycle Implementation, Business warehouse complete workflow, ETL (Extraction, Transform & Load) processes and Agile methodology.
• Exhibited excellence in developing reports in Webi Dashboards by using SAP BEx Queries and experienced in running HANA queries
• Holds rich experience of BW for BEx Query Analyzer and Designer
• Created dashboards using SAP Lumira/Design Studio using Client specifications
• Proficiently created BEx Reports, Workbooks, Variables, Calculated / Restricted Key figures, Structures
• Thorough understanding of Business Objects and Dynamic Dashboards, Created and tested various VBA macros for implementation
• Profound knowledge in writing packages, procedures and functions with ABAP code
• Well experienced in SAP HANA Data Modeling
• Successfully provided fixes to bugs raised by onsite during final phases of project delivery
• Team-based Management style with expertise in driving the company’s vision into reality

TECHNICAL SKILLS

OLAP: SAP BEX, SAP BO, SAP HANA, SAP Lumira

Programming Languages: PL/SQL, SAP ABAP, C, Java

Web Technologies: HTML, VBA, XML

Databases: Oracle 11g

Functional Areas: Banking Domain, FLEXCUBE, Product Testing

PROFESSIONAL EXPERIENCE

SAP BW HANA Consultant

Confidential

Responsibilities:

• Extensively used BEx Query Designer and developed Queries to retrieve the Analysis Actuals and Budget data for the chemicals data used in Sasol
• Worked on Lumira Designer to create dashboards for Various chart applications
• Developed scripting code to retrieve data from BW backend and created dynamic dashboards, reports in Business Objects
• Integrated data from data sources into SAP HANA using ETL replication
• Involved in Full Life Cycle Implementation from extraction till implementation
• SAP Hana Data Modeling and creation of triggers and sequences in HANA schemas
• Created Info objects, DSOs and Info providers in CO-PA area to support Business reporting and Sales forecast/planning.
• Troubleshooting Report and query issues reported by users, to retrieve resolutions
• Supported Sales and Marketing team with solutions for workbook and query issues
• Created Aggregation levels, planning functions and planning filter in BW-IP to develop 5-year forecast tool for Sales and Marketing team
• Hands on Experience in BW support during BW on HANA migration
• Extensively used BEx Query Designer and developed Queries to Facilitate Sales forecast data Analysis in a Drill Down or Summarized way to provide Detailed levels of information
• Written VBA macros code to convert data to BW flat files for data loads
• Updated BEx queries and reports using BEx Query Designer/BEx Analyzer and evaluating performance of queries
• Generated several Sales forecast planning workbooks using BEx and created planning filters in BW-IP
• Designed ABAP based extractors for data extraction
• Interacted with onsite team members to resolve issues related to Workbook macros and structures/variables
• Involved in project planning and resource planning for Offshore team, and worked with Onsite lead to provide weekly status reports on tasks finished by Offshore team
• Day-to-day support for Management team power users
• Worked on data loads in Business Reporting, Management Reporting, Operational Reporting & Data Validation process
• Written packages, procedures and functions using PL/SQL Developer

SAP BW/BO Consultant

Confidential

Responsibilities:

• Created Management Analysis tool for Sales team using Business Objects Dashboards
• Worked extensively on creating queries using BEx Query Designer
• Designed various analysis applications using different charts to depict the various data selections
• Worked extensively on BEx Query Designer and developed Queries to obtain Chemicals data
• Design Studio application implemented to create dashboards for different chart applications such as Waterfall, Pareto, Ranked analysis, and Scatter graphs
• Written scripting code to retrieve data from BW backend
• Developed reports in Webi Dashboards by using SAP BEx Queries
• Managed Full Life Cycle Implementation, involving initial analysis, configuration, testing, training, conversions, customization, documentation, roll-out and support activities

Associate Consultant

Confidential

Responsibilities:

• Creation of new forms and reports, enhancement of existing forms and reports
• Assisted team leads during onsite call and project closure, implemented fixes to various bugs during closure stages using PL/SQL code

Associate Consultant

Confidential

Responsibilities:

• Carried out the role of programming backend code to implement relevant customer changes
• Interacting with clients to resolve various critical issues faced during UAT support
• Simulating and providing fixes to the issues raised by onsite team during project support