Professional Summary

• Overall experience of 7 years in SAP Net Weaver BW 7.3, BO 4.0/ 4.1 and SAP HANA
• SAP HANA Certified Application Associate
• Experience in multiple full life cycle project implementations
• Experience in applying Agile software development methodologies to effectively capture changing requirement, reduce defects, engaging project stakeholders in feedback loops and consistently delivering business value ROI
• Extensively worked on creation of InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, ODS/DSOs, InfoCubes, InfoSets, MultiProviders and Data Transfer Process
• Experience in creating and enhancing BW data extractors for Master data and Transaction data from Business Content, LO Extraction Cockpit, FI, CO-PA, SRM and creating and enhancing Generic extractors
• Worked extensively with Transport Management using BW Transport Connection and involved in Cut-Over planning
• Expertise in creating, scheduling and monitoring Process Chains
• Improved data load and query performance using BI Accelerator BIA , Compression, Aggregates, Indexes, Partitioning, and Rollups
• Experience in BEx Query designer, BEx Analyzer and WEBI reporting tools
• Worked extensively with Open Hub Destination and APD's to store data from SAP BI to local databases for ad-hoc reporting
• Experience in designing/developing HANA Information Models Attribute Views, Analytic views, Calculation Views, SQL Script based Calculation views, Hierarchies, Decision Tables
• Sound knowledge in HANA Data Provisioning technologies using Flat File, SAP Landscape Transformation for SAP Non-SAP, Data Services, Direct Extractor Connections
• Experience in coding using SQL Procedures, CE Functions, SQL Scripts
• Sound knowledge in SAP BO Reporting on SAP HANA Models using Web Intelligence and Dashboard Design tools.
• Creation of Analytic privileges, users and roles using SAP HANA studio
• Migration of BW Database to SAP HANA prepare/export/import BW Data, Optimization of InfoCube's and DSO's
• BW- HANA EDW Publishing Hana Data Models, Creation of virtual providers based on HANA Models
• Sound knowledge in Business Objects Enterprise, Universe Designer, InfoView, Crystal Reports, Explorer and Advance analysis for Microsoft/OLAP
• Highly motivated, quick learner, ability to work under pressure, and great team player with excellent analytical and communications skills

Technical Skills

Work Experience

Confidential

Role: Sr. BI/HANA/BO Consultant

• Was responsible in the delivery of Record to Procure RTP reports. This includes 6 BEx, 6 WEBI and an Adhoc Integrated Spend query
• Worked extensively with business/ process team to gather requirements and played a vital role in developing a sustainable backend BW solution for future development needs and replace some of the existing reports due to issues like data quality, reporting performance etc.
• Key reports developed during this phase are Open PO, Pre-Commitments, Shopping Cart Item, Buyer Analysis, Vendor/ Material, Adhoc report to analyze details regarding PO's, Invoices and GR's
• Resolved numerous defects during the testing phase
• Planned, prepared and executed the tasks during Cut-Over
• Also responsible for tracking status of all development objects from PMO perspective and provide timely updates to the key stakeholders.
• Performed pre-migration activity to cleanse unwanted data that will help in accelerating time line of migration and optimized usage of HANA
• Gathered and analyzed requirements to replicate the ECC content in HANA using SLT data provisioning for real time reporting
• Developed data models including Attribute Views, Analytical and Calculation Views for generating reports on Integrated Purchasing query
• Published HANA data models in BW and developed WEBI reports on top of Transient providers
• Migrated HANA content from development, testing to production environment using Delivery Units

Environment: SAP BW 7.3, ECC 6.0, SAP HANA 1.0, BO 4.0, Oracle 11g

Confidential

Role: Sr. BI/ BO Consultant

• As a Senior BI Developer was responsible for the Solution Architecture, Design Implementation and Testing
• Implemented 10 WRICEF objects in following functional areas PTP, OTC and RTR. Was responsible for collecting requirements from end users, designing and developing the master design documents and development of the same
• Responsible for coordinating activities for testing with functional teams and business users for the WRICEF objects
• Primary responsibilities included communicating with functional leads and project managers on various approvals for FUT's, Ver/Val's and Solution manager Documentation that were required for meeting the deadlines
• Took part and ownership of various activities like System Readiness, Autosys integration, Security FUT testing, Transport issues etc.
• Played active role with key responsibilities like preparing release requirement document for Go-Live
• Other key reports developed are ACR Cycle time report, Accounts payable Allocation Summary, Invoice awaiting receipts, Purchasing cycle time report purchasing based reports
• Developed reports and related back end objects for MTD month to date / YTD Net Revenue Reports for use by Finance director
• Implemented numerous change requests for the ongoing SAP Realization Phase

Environment: SAP BW 7.0, ECC 6.0, Oracle 11g, SRM 5.0, BEx reporting

Confidential

Role: Sr. BI Consultant

• Responsible for the BI objects in production environment from Operations perspective. Involved extensively in performance tuning activities, change management and incident management.
• Involved in formulating the strategy for System Build in BI. Also, responsible for system build activities during the different phases of implementation of project life cycle.
• Formulated the strategy for testing the BI system after application of Support Packages. Also responsible for carrying out the testing activities.
• Responsible for reviewing and sequencing of transports both global and regional track before moving to other environments across the landscape.
• Responsible for looking up OSS notes to resolve issues.
• Responsible for monitoring BIA
• Involved in implementation of Inventory Management, Procure to pay, Quality Management, Plant Maintenance and APO. Involved in analyzing the user requirements and designing the Business Requirements, developed, tested and implemented BW Objects.
• Extensively used standard LO cockpit to extract data related to Inventory Management, SD into BW System.
• Designed Infocubes for Material Movements/ Stocks, Cycle Time, SCM Demand Planning, Supply Network Planning for North America and APO Sales Order Cube. Installed and activated the business content and created generic extract structures to extract data from 2LIS 03 BF, 2LIS 03 BX, 2LIS 03 UM, 2LIS 11 VAITM and 2LIS 11 V SSL. Also, performed compression to improve the reporting performance.
• Based on the business requirements extended the extractors for QM PM.
• Developed custom reports for Cycle time Infocube to report on Cycle time for Movements, Plant Cycle Time, and Cycle time report for Batch.
• Performed troubleshooting ETL functions during data loading that included viewing the system log, table locks, short dumps and searching for errors on OSS.
• Involved in designing Process chains in BW for loading data on daily, weekly and monthly basis.
• Monitoring of both Meta and Local Process chains for Automated Scheduling or all Data Loading jobs across different work streams such as STS, SCM, OTC and FBM
• Created Data verification test scripts, Technical specs, Standard Operating Procedure documents and other necessary documentation

Environnent: SAP BI 7.0, ECC 6.0, SAP GUI 6.40

Confidential

Role: SAP BW Consultant

• Responsible for performing front end development, post production Support and BW upgrade from 3.1C to 7.0.
• Developed reports required for County Water Department for Identifying the Top 10 Customer in terms of usage and outstanding balances. This required development of custom ODS, Cubes and data sources.
• Responsible for all the data load monitoring, seven days a week, as well as any of the necessary fixes that occurred from a loading error.
• Also, reorganized and rebuilt existing process chains to improve efficiency and accuracy. Built all the necessary process chains for the data loads, as well as PSA deletes.

Environment: SAP-BW 3.1C/ 7.0, SAP R/3 4.6C, ABAP/4, SAP GUI 6.40 and Win 2000.