EXECUTIVE SUMMARY:

• A diligent professional with 10+ years of development experience in SAP, worked in different areas of SAP BW, HANA, BI, IP 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 and Senior Consultant in consulting houses and has experience in using well known Confidential 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 & Confidential 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.

PROFESSIONAL SUMMARY:

• SAP BW HANA consultant with 10+ years of experience in SAP BW, HANA, Integrated Planning, BI and ABAP.
• Experience in SAP HANA Modeling for an Confidential project as a HANA consultant.
• Experience in 4 full life cycle end to end Confidential and 5 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.

TECHNICAL SUMMARY: 

• 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.
• POC in Design studio with HANA for the internal product development team for product ‘READ’.
• 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, Confidential and maintenance of business intelligence solutions.
• Involved in End User Training & Support.
• Experience in various stages of SAP BI 7.0 & 7.3 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.
• Develop, maintain and support WebI reports using Business Objects.
• Performance tuning of BO reports using BICS connection.
• Strong association with the architecture team and participated in the discussions regarding planning and Confidential of the overall BW landscape and architecture.
• Competent skills in SAP BW Data Modeling of 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 Crystal Reports, Web Intelligence, Dashboards and Business Objects Analysis for Office.
• 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.

PROJECT EXPERIENCE; 

Confidential, Phoenix, AZ

Confidential

SAP BW/BO/HANA Onsite/Developer

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

Responsibilities:

• Confidential system study for BW 7.4 upgrade and it’s corresponding development.
• Mapping all the POSDM components to the HANA CAR POSDT system and generating report on top of new POSDM system.
• HANA modeling using the BW POSDM content in the CAR HANA system and consuming the same in Lumira and BOBJ Analysis for Office.
• Implemented COPA account based data flow in the system from end to end including datasource creation and it’ corresponding mapping.
• Extensive experience in building Universes and retrieving data using Universes, Personal data files, stored procedures and Free hand SQL
• 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.
• Complete re-designing of the inventory cube modeling in BW to include the stock in transit value in the report for day to day reporting.
• Performance improvement in large volume of inventory data extraction to Access database using SPO based modeling.
• 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 Developer

Environment: SAP HANA SP 10, BW 7.4, BOBJ 4.0, BPC 10.1 Microsoft BI & ECC 6.0

Responsibilities:

• BW modeling using advanced DSO’s and composite providers.
• Reconciliation report for BW and BPC data for finance.
• Extensive involvement in the phases of the project including involvement in BOBJ report creation with HANA views.
• Involved in training end users, business users and customers on how to create modify and interpret Deski reports, WEBI reports and Crystal reports.
• HANA modeling with attribute, analytic and calculation views for data from different source systems including ECC, BW and legacy systems.
• 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.
• Involved/ coordinated with Basis on the transport of the views across landscapes.

Confidential

SAP BW Lead / QA Delivery Manager

Environment: SAP BW 7.3 & ECC 6.0

Responsibilities:

• Involved in cutover activities, Confidential loading of the data and other critical process for the BW Confidential 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.
• Sending the huge amount of inventory data from BW to ODS system and also to a MS Access database using APD.
• 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 from ECC SD access sequence tables.

Confidential

SAP BI IP/BO Project Manager

Environment: SAP BI 7.0 & ECC 6.0 & BO

Responsibilities:

• Liaising with the end users on a daily basis regarding the functionality of the reports and collecting further requirements.
• Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Created a broadcasting setting to send the report output as mail and worked with the Basis team regarding the configuration settings in scot.
• Monitoring of the Transactional and Master Process chains on daily, weekly and monthly basis
• Created Text variables to dynamically show the header of the columns in the report.
• Updated the planning queries with the totals and subtotals based on the customer requirement.
• Modified non input ready queries to input ready queries based on the end user requirement.
• Migrated the queries to WebI as per the business requirement. That involved all the queries which are not input ready queries.