SUMMARY

• A diligent professional around 10 years of development experience in SAP, worked in different areas of SAP BW, HANA, BO, IP, BPC and ABAP that involved various stages of development, providing better integration enabling rapid access to critical information, Comprehensive problem solving abilities, Good communication skills, a good team player and a good learner.
• Has worked in various capacities including Team Lead, Architect and Senior Consultant in consulting houses and has experience in using well known implementation and upgrade methodologies. Has good knowledge of design procedures and has the ability to translate business requirements into application system. Has proven track record as SAP BW lead consultant and possesses good skills gathered over years suitable for managing application design, development & implementation of projects of any complexity.
• Background includes leading blended teams, devising time lines, monitoring project standards for all deliverables, creating strategies and maintaining quality assurance throughout the entire project.
• SAP BW HANA consultant around 10 years of experience in SAP BW, BW on HANA, Integrated Planning, BPC, BO and ABAP.
• Experience in SAP HANA Modeling for an implementation project as a HANA consultant.
• Experience in 4 full life cycle end to end implementation and 2 upgrade and many support projects.
• Experience as techno functional consultant for different modules like FI, SD, COPA and MM.
• Proficient in carrying out requirement analysis, multi - dimensional data modeling, developing and testing both back-end and reporting objects.
• Good skill in liaising with end users/clients/business for the business requirements.
• Good team handling skills involving Onsite/Offshore model.
• Excellent communication, team handling and inter personal skills.
• Excellent conceptual/in depth knowledge in various aspects of HANA including modeling, transport, data provisioning, development standards, best practices and BOBJ reporting on HANA information views.
• Experience in HANA Modeling studio creating attribute, analytic and calculation views for BOBJ reporting. Performance tuning of the existing information views for better run time in BOBJ. Involved/coordinated the transport of views to the landscape.
• Experience in analyzing the performance of information views using plan visualizer.
• Specialization in configuration and setup of SAP business content and SAP BW extractors utilization, System Analysis, Requirement Analysis, Validation, Technical Solution Design, Development, Testing and Quality Control with a focus on better performance and easy maintenance of the system.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency and productivity
• Creating/Enhancing the Functional and Technical design document.
• Involved in development, implementation and maintenance of business intelligence solutions.
• Involved in End User Training & Support.
• Experience in various stages of SAP BI 7.0, 7.3, 7.4 and 7.5 including Data Modeling, Extraction and Reporting.
• Experience in the performance optimization in the data loading, reporting aspects of BW using BI Accelerator, customization and enhancements.
• Performance tuning of BO reports using BICS connection.
• Strong association with the architecture team and participated in the discussions regarding planning and implementation of the overall BW landscape and architecture.
• Competent skills in SAP BW Data Modeling of Composite Providers, Open ODS view, Advanced DSO’s, BW workspace, InfoCubes, DSOs, InfoObjects, Multi Providers, Infosets, APDs and Open Hub Services.
• Excellent skills to work on Business warehouse extractors such as LO-Cockpit, Generic Extractors, Standard Extractors and Generic Delta Extractors.
• Good experience with Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
• Excellent skills to develop all kinds of ABAP Routines (Start/End) during Transformations/update rules. Designed Custom extractors using User-exits, routines and Function Modules. Worked on all kinds of BI-ABAP requirements.
• Experience with Front-end Business Warehouse Components, which involved constructing custom queries for the business based on the requirements.
• Excellent skills to solve Data loading issues and Developed Detailed Cutover plans. Managed huge cutover activities and solved issues during the process.
• Good experience in SAP BI Integrated Planning and the different modeling scenarios using aggregation levels.
• Experience in SAP BO tools like Web Intelligence, Business Objects Analysis for Office, Lumira and Design Studio.
• Experience on SAP ECC with in depth knowledge in Data Dictionary, ABAP Reporting using Classical & ALV Reports, applications using dialog programming, ABAP objects, enhancement techniques including user exits, BADI’s and BAPI.
• Good understanding of SAP Retail, SD, MM, FI and POSDM.

PROFESSIONAL EXPERIENCE:

Confidential

Portland, Oregon

Senior SAP BW/BI/IP PAK Consultant

Environment: SAP BW 7.5 on HANA, BOBJ & IP

Responsibilities:

• Upgrade to SAP BW 7.5 from 7.3.
• Planned and executed in all aspects of the upgrade from the initial cost and effort estimation to testing and Go Live.
• Involved and executed the following phases of the project like System and Resource availability and planning, verify all SAP prerequisite notes, landscape validation, pre-upgrade tasks, technical upgrade tasks and post upgrade validation.
• Complete re-designing of the existing landscape using composite providers and Advanced DSO’s. Converted existing cubes and infoproviders into adso’s and used them in composite providers.
• Extensive usage of BWMT eclipse for the creation of reports and data models.
• BW to non-SAP data transfer using BODS.
• Implemented the BW workspace in 7.5 the Planning modeling for updating to the BW system.
• Implementing planning and forecast IP PAK. Using manual planning and planning functions with fox formulas. The planning reports are delivered using Design Studio and Analysis for Office tool.
• Supporting users and their requirements in functional areas like Order to Cash, Procurement, Inventory and Production planning.
• Complex modeling and data modeling design using advanced DSO’s to track all changes to Sale orders from CDHDR and CDPOS table using custom extractors. Consumed the same data using Design Studio dashboard development.

Confidential

Phoenix, AZ

SAP BW/BO/HANA Architect

Environment: SAP BW 7.4 on HANA, BO Analysis for Office & ECC 6.0, HANA CAR

Responsibilities:

• Initial system study for BW 7.4 on HANA upgrade and its corresponding development using Composite providers and Advanced DSO.
• Mapping all the POSDM components to the HANA CAR POSDT system and generating report on top of new POSDM information views.
• HANA modeling using the BW POSDM content in the CAR HANA system and consuming the same in Lumira and BOBJ Analysis for Office.
• Data Provisioning in SAP HANA using SLT.
• Ensuring the HANA information views are based on the best practices with respect to modeling views, using joins and filters.
• Involved in the data archiving process in BW for better performance.
• Extensive performance optimization researches and suggestions for the BW system on SQL server.
• Liaising with users/business to find out the scope for the enhancement of the report.
• Handled the inventory scenarios for the business involving stock in transit for reporting purpose.
• Designing/creation of workbook, worked closely with the security team to restrict/assign access to users different regions based on the authorization.
• Modeled the moving average cost works from the extractor perspective so that it aligns with the business/reporting need.
• Re-designed the complete process of modeling side for a Purchasing report which involves change in the back end for capturing the deletion indicator.
• Worked along with Basis for the pre upgrade activities for a patch upgrade in 7.3
• Created aggregates in the system for cubes with long running queries as part of performance optimization.

Confidential

Phoenix, AZ

SAP HANA BW BO BPC

Environment: SAP HANA SP 09, BW 7.4, BOBJ 4.0, Microsoft BI & ECC 6.0

Responsibilities:

• Extensive involvement in the phases of the project including involvement in BOBJ report creation with HANA views.
• Extensive HANA modeling with attribute, analytic and calculation views for data from different source systems including ECC, BW and legacy systems.
• BW backend data modeling using Advanced DSO’s and Composite Providers.
• Extensive experience in building Universes and retrieving data using Universes.
• Identified the bottlenecks for performance using plan visualizer and did performance tuning on the views for better run time for the BOBJ reports.
• Developed reports in Webi using information views containing data from legacy systems and AFS module.
• Worked with Security on the Analytical privileges and proposed best practices.
• Involved/ coordinated with Basis on the transport of the views across landscapes.
• Worked in the BPC EPM Add In for forecasting and budgeting reports.

Confidential 

SAP BW Lead / QA Delivery Manager

Environment: SAP BW 7.3 & ECC 6.0

Responsibilities:

• Involved in cutover activities, initial loading of the data and other critical process for the BW implementation phase of Go Live.
• Created a report in BW to show the financial movements based on a store and a day. It shows the Cash Receipt vouchers, Cash Payment Vouchers, Gross sales, Layaway deposits etc. It involved creating cubes and Multiprovider in the backend to achieve the same
• Custom datasource/DSO creation for the extraction of certificate, environment and disposal fees from ECC which involves end routines in BW to combine header and item data.
• Created Financial Statement report for profit centers comparing current year to date and previous year to date values.
• Created many custom reports in FI, MM and SD using selection, formulas, RKF, CKF and cell structures.
• Implemented many Business content reports aligned with the requirements from the business with the use of RRI.
• Created an APD application to send data from a BW Multiprovider as a text file to a folder in the application layer. It involved ABAP routine and formula.
• Created Generic Datasources using Table/View option for a custom table using the timestamp field and loaded the same into a standard DSO.
• Created a custom query for the APD process to pull data from the cube and used the query as source in APD.
• Created write optimized DSO’s, standard DSO’s, end routine and process chains. It was done to extract the Adjustment and Forecast fee to BW from ECC.
• Enhanced the standard Datasource for sending data from POSDM to BW using BADI.
• Created extractor and did the modeling in BW for bringing the pricing information to BW.

Confidential

SAP BI Consultant

Environment: SAP BI 7.0, ECC 6.0

Responsibilities:

• Developed queries in BI based on the Custom CRM tables.
• Designed the ETL for BI/CRM Integration
• Validated all the variables, formulas, text variables, restricted and calculated key figures, custom exits
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads
• Resolved the source system error with the Basis team with the help of SAP Note ‘1478123 - FAQ: Source system’ and also checked various parameters using the note.
• Created Unit test Case documents for the developed objects.
• Validation and testing of the reports based on BEx Queries.

Confidential

SAP BI/BO/ABAP Consultant

Environment: SAP BI 7.0, ECC 6.0

Responsibilities:

• Developed a Generic DataSource for Master Data, Text and Transaction Data using the transaction RSO2
• Developed a Functional module based DataSource to handle delta extraction
• Developed a custom DataStore Object and InfoCube which displays sales data
• Developed a Query which displays the total sales details in year wise
• Involved in the development of pricing routines for SD.

Confidential

SAP ABAP/BW Consultant

Environment: SAP ECC 6.0, BW

Responsibilities:

• Reviewed the existing data model and gathered requirements from the functional consultants regarding the new approach.
• BW support phase handling process chain monitoring.
• Enhanced couple of reports in SD using BEx Query Designer.
• Worked together with the functional consultant in creating new condition records and pricing conditions.
• Implemented BTE to retrieve field descriptions for custom fields in VK11, VK12 and VK13.
• Involved in the support project of SD module various phases of development such as reports, exits and BADI’s.
• Implemented a Function Exit for checking the material details while extending a material in MM01.
• Implemented a BADI (LE SHP TAB CUST HEAD) to add a custom tab for delivery in transaction VL01N / VL02N.
• Developed an interactive report using object oriented ALV in MSD showing the checklist of the proof of delivery of products to customers based on the date, courier agencies and customers.
• Implemented a user exit in SD module to check a duplicate purchase order.