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 implementation 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 with 10+ years of experience in SAP BW, HANA, Integrated Planning, BI 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 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.
• 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, in corporate 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 & 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 implementation 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.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

SAP BW/BO/HANA Onsite/Developer

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

Responsibilities:

• Initial 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 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, 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, 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.

Confidential

SAP BW BO IP Lead

Environment: SAP BI 7.0, BOBJ 4.X & ECC 6.0

Responsibilities:

• Involved in the end to end phase of the projects including Requirement gathering, Blueprint discussion, Realization, Testing and Go Live phase.
• Designed the layout of the project based on the requirements collected from the customer.
• Installed standard cubes and its related objects from business content and loaded the master data and transaction data.
• Developed custom DSO’s, Infocubes and Multiprovider for BI and IP reports.
• Loaded the setup tables for SD and MM related Datasources and extracted data to BW.
• Worked extensively with Inventory cube 0IC C03 with marker and no marker update compression.
• Performance monitoring and tuning of BO reports during application testing and production operations.
• The most challenging was the material replacement scenario which involved extensive ABAP work and BI.
• Loaded the historical and current data into Inventory cube by setting up marker and no marker update.
• Sending the inventory data to application server using open hub destination which is consumed by legacy systems.
• Created Unit of Measure conversion in BI to convert the UoM from Cases to Sticks in a particular report using the Infoobject 0material.
• Created Process Chains for Transaction Data and Master Data load in SD, MM and Finance.
• Created background event in BW and used it to trigger the Process chain which loads data to a DSO from a table which gets loaded from a flat file. ABAP program was written to upload data to table which in turn trigger the event to execute the process chain to load to the DSO.
• Developed formula type planning functions to derive the results based on the complicated requirements from the customer.
• Implemented user exits in BI to calculate version of the forecast dynamically in the planning reports.
• Created input ready queries in BEx Query designer based on the aggregation level and developed workbooks in BEx Analyzer based on the reports.
• Monitored the query results using RSRT to identify the bottlenecks in performance.
• Developed Aggregation Levels, Filters, Planning Functions, customer exit variables and Planning Sequences for IP reports.
• Created Yearly forecast and rolling forecast (monthly) reports based on the requirements by the customer.
• Worked closely and extensively with the Basis team in the Transport Management System to collect, release and import objects in the Development, Quality and Production system.
• Created test cases for the reports in the BW side and performed the same for inventory and sales module.
• Involved in the end user and all other documentation work.

Confidential

SAP BI/BO/ABAP Consultant

Environment: SAP BI 7.0 & ECC 6.0

Responsibilities:

• Provided solutions to the design flaws after extensively analyzing the system.
• Designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Structures, Formulas, Selections, Calculated Key Figure, Restricted Key Figure and Variables.
• Designed and developed many reports in WebI as per the business requirement in logistics area.
• Created a Report to Report Interface (RRI) for showing the sales data in region wise
• Enhancements and additional developments were done to ensure the accurate reporting requirements
• Provided proactive system monitoring to resolve critical production issues
• Extensive support with permanent solution & root-cause of analysis by meeting the Service level agreement.

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.