SUMMARY

• Over Eighteen years of SAP BI/BW experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementation, Upgrade and Production Support across various Industries.
• Four years of experience in BW/Hana implementation, Design, Development, Testing and support.
• Implemented full life cycle projects in SAP BI/BW with different versions BW7.4,BW7.3,BI 7.0, BW 3.5B, 3.0B, and 2.1C. Extensive knowledge in different SAP functional areas, integrating BI various versions of ECC, CRM, SRM, Business objects and BPC5.1,BPC7.0 and BPC10.0 Net weaver
• Certified in SAP Hana 1.0 as Application Associate.
• Proficient at translating business goals and requirements into SAP BI solutions, guiding clients through effective blueprint workshops, facilitating decisions on best practice procedures, and overseeing.
• Participated in numerous BW scoping and project reviews. Recommended best Practices, approaches and standards for BW development and performance.
• Proven track record of improving ETL load and Query Performance by efficient design(e.g., data modeling, indexing, architecture, configuration, performance tuning, etc…) and overall understanding of the system landscape and experience technical knowledge.
• Strong functional knowledge on ECC Finance, SD, CRM and RAR.
• Supported two project on BPC/BW backend ..
• Experienced in Business objects reporting tools in Web intelligence and OLAP Analysis.
• Successful implemented two RAR BW projects to meet new revenue recognition regulations (IFRS 15 & ASC 606)
• Expert in using BI Front - end and Backend tools (BW/4Hana, BW 7.5, 7.4,7.3, 7.0,3.5B, 3.0B, 2.1C), development of various BI components.
• Experienced in using SAP Hana Backend Hana studio and data extraction using BODS, SLT and DEC/DCX tools.
• Experience in creating Hana models and writing procedures and Abap programs.
• Experienced in integrating and extracting data from Source systems, S/4Hana, ECC5.0/6.0, SAP R/3 (4.7, 4.6C, 4.6B), CRM, SAP R/3 SD, MM, FI/CO, SEM and SCM(5.0) using Standard, Generic extractors and DB Connect.
• Proficient in Using ABAP for BI, Open Hub Technology, Broadcasting.
• Excellent knowledge in modeling, design and development of various BI components using Administrative workbench.
• Excellent Knowledge on HANA integration with ECC, BW and BO tools.
• Experience on Business objects reporting tools Web intelligence, IDT, Business explorer, office Analysis and Lumira.
• Supervised, supported and maintained a BW solution for 1,000+ end users and a 25+ SAP development department. Experienced trainer for BW knowledge transfer (me.e., implementation, design, and development) purposes as well as on-going maintenance and support.Additional experience in batch jobs, proactive monitoring of BW and R3, trouble shooting, problem solving and data validation.
• Worked in Business objects/BI Integration, IDT, Web Intelligence, Crystal reports and BO Explorer
• Strong knowledge and experience in SQL programming

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

SAP BW/BI/HANA Architect

Responsibilities:

• Lead and drive new SAP BI/BW/HANA Enterprise Business Reporting BW/BPC Implementation project (Consolidations and Managerial reporting)
• Provided SAP BW/BI/HANA/BPC technical and architectural guidance to project and teams ensuring that new initiatives enable effective data reporting
• Worked on Finance Balance sheet, P&L and Trail Balance reporting using GL data using BW reporting.
• Worked on Master data reporting project on Material Master, Customer and Business partner etc.
• Integration of Finance Legacy data(Ax)System and SAP Data to generate Tax reports for the company.
• Created transformations using ABAP,advanced DSOs, composite providers, exposing BW models as HANA views, mixed scenarios, CDS Views, HANA Analysis process in BW and LSA ++ and performance optimization concepts
• Performed SAP HANA data modelling views with graphical and SQL scripting, and data provisioning technology..
• Worked on SAP Analytical cloud based on Bex queries and Hana views.

Confidential, San Jose, CA

SAP BW/BI/HANA Architect

Responsibilities:

• Gatheird business requirements from different business groups around the globe and prepare requirements document.
• Worked on the Blue Print Document based on the Business user group meetings for Global Business reporting
• Designed the architecture for SAP BW Hana sales project to support the Business requirements for Sales and Finance Business users around the globe.
• Developed the solution and ensuring integration of data from ECC system.
• Owned and worked on all issues through resolution by ensuring overall integrity of all BW Models.
• Supported in the facilitation of end user testing and providing customer support during post-production phase
• Prepared documentation to support the implementation of best practices.
• Developed SAP BW Hana reports Booking, Billing, Delivery Backlog and Revenue Solution to support global Business .
• Worked on BW/BPC Integration project for supporting BPC Sales Planning
• Worked on HANA Studio - Schemas and tables on HANA, attribute view, analytical view & Calculation views, Advanced DSO and composite providers.
• Developed and handling hybrid scenarios - BW data models and HANA views as per the requirement.

Confidential, Sanjose, CA

BW Analyst

Responsibilities:

• Working on BW Revenue recognition (RAR) reporting project based on ECC SAP Revenue Accounting and Reporting (RAR 1.1) module for Finance and revenue users.
• Collected Business requirements from the Sales and Finance users around the globe.
• Designing the new architecture for BW Revenue Recognition (RAR) to meet the business reporting needs.
• Analyzing the impact of Revenue recognition solution on the existing BW Finance and Sales reporting
• Developed the Backend objects and new reports to perform daily operations and reporting the revenue to stock exchanges.
• Integrating new Revenue Recognition Reporting solution with the existing BW sales reporting architecture. working on traditional SAP BW 7.5. Version and EHP7.0 and Revenue Recognition module.
• Responsible for completing Fit-Gap analysis and should be able to write/review Functional and- Technical design specifications.
• Responsible and actively involved in all testing phases of the project with Business groups.
• Active participation in all aspects of the project life cycle, including gathering requirements

Confidential

BW Upgrade Lead

Responsibilities:

• Worked on BW upgrade project from BW7.0 to BW7.5 version for BW reporting solution.
• Analyzed the scope of the project for Frontend and Backend objects which will impact by BW Upgrade.
• Worked with Business to finalize the scope for remediation and regression testing for BW reporting solutions.
• Worked on remediation of Backend objects(ABAP code ) at Transformations and include programs.
• Worked on migration and remediation of front end object Bex queries, Workbooks and Broadcast settings.
• Worked with the business on UAT for the remediation reports for the upgrade project
• Designed the plan for Duel maintence and transports for future BW development projects.
• Supported BPC data loads and process chains to support BPC reporting.

Confidential, Sunnyvale,CA

SAP BW/BI Analyst

Responsibilities:

• Implemented BW Revenue Recong (RAR) reporting project based on new Revenue Recong module for Finance and revenue users to meet ASC 606 standards.
• Integrated Revenue Recong Reporting (RAR) with the existing BW sales reporting(Billing and Backlog)
• Designed upgraded and test plan from BW7.0 to BW7.4 SP7 Hana database around the BW landscape .
• Supported and tested BW side for ECC EHP7 upgrade.
• Upgraded Business objects from BOBJ 4.0 version to BOBJ 4.1 version. Validated the reports and data after upgrade.
• Worked with SAP closely to fix upgrade issues.
• Worked on ABAP Programming to Implement Business logics for the ETL process and reporting.
• Worked on data migration from Salesforce system to SAP BW system by using MS Biztalk Interface for BI CRM Analyticals reporting based on Cases data and shipping data.
• Implemented Service analytics BW reporting solution for Service users and Sales team.
• Integrated existing BW Sales and finance reporting with Service Contracts reporting solution.
• Interacted with key users to identify requirements and develop technical specifications..
• Transferred data from SAP BW thru open hub destination and easy queries to Hadoop system.
• Worked on easy queries to feed data into Microsoft Power BI with OData services.

Confidential, San jose,CA

SAP BW/BI Architect/Developer

Responsibilities:

• Worked on BW Upgrade from BW7.0 to BW 7.3 version.
• Conducted Workshops for Sales finance enduser groups and gatheird reporting requirements from Business.
• Implemented Booking, Billings, Backlog and Revenue reporting solutions for Sales Finance and Sales team.
• Implemented Custom ABAP extractors and Business logic to meet the Business requirments.
• Implemented Asia Reserve project by enchancing the existing BW architecure.
• Worked on Business object OLAP reporting sytems based on Bex Reports.
• Worked on Business objects webi reports on Bex queries and universes
• Improved performance on existing architecture and guiding the client on performance improvements and data storage.
• Working on poc on Enteprise Hana on Sales application.

Confidential, San jose, CA

Programmer analyst

Responsibilities:

• Worked on multiple projects in Confidential and GSI Finance Integration project, MRA & BOBJ reporting project, SRM BI reporting Project and Bank Balance Project with Hana Integration.)
• Implemented New GL finance solution for Confidential Cooprate and retail.
• Worked on Integration of GSI Commerce and retailfinancial solution with the existing Confidential BI/BW Business Reporting system.
• Implemented comprehensive BankBalancereporting solution for Bank Statements already available in ECC.
• Worked on BW/BPC for Planning and consolidation planning .
• Implemented BW reporting solution on APW invoice sytem.
• Enchaned New GL realtime and Non real time solutions with minimum impact to meet the business needs
• Implemented SRM BI reporting solution on shopping carts and Purchase order approvals
• Created and modified existing inbound and outbound interfaces(khalix, Metrices..) to flow data.
• Created new reports and modified existing reports to meet GSI and Confidential business reporting.
• Enchaned For management reporting, business needs the flexibility to move expenses between profit centers and reflect the changes on historical and new balances.
• Enhanced New GL realtime and Non real time BI back end solutions and making profit center as reporting attribute .
• Worked on Upgarde project from BW 7.0 to BW 7.3 system.
• Implemented Enterprise Hana for Bank Balance reporting solution
• Worked on a POC project forSAPHANA on new GL solution.
• Worked on BO explorer, Business objects Webinteligence reporting on BW queries and infoproviders.
• Conducted Workshops for end user groups and gatheird Inventory reporting requirements from Service depot Business users.
• Gatheird requirements and performed gap analysis for the areas of Inventory Material moments and stocks valvuation .
• Configured and designed BW reporting solution on Inventory module .
• Implemented Service planning and logistics planning for service depot by using BW/BI inventory .
• Enchanced BW extractors by adding additional fields related to Material doc level like Document header text, bill of landing ….
• Enchaned Master data extractors like 0material and 0material attr.
• Created reports on Inventory material moments and exported to BOXI Universes
• Created Inventory webi reports based on Plant, Storage loactions and material moments.
• Created universes and Webi reports based on Legacy Remedy database.
• Interacted with key users to identify requirements and develop technical specifications.
• Developed BW Planning and forecasting reports in Confidential BW system and modified existing reports to suit Business for Roche Group, North America.
• Worked on system performance tuning on existing landscape data loads (millions of records) and reports and automated the system process in BI in Confidential and HQ systems
• Developed Project related documentation standard for object designs, mapping rules, business rules, test plans and test results
• Worked on Finance applications in BW Accounts recievable, Accounts payable, GL, Costing and Profitablity analysis.
• Worked on Integrated planning for Cost center allocation.
• Enchanced and created new backend and frontend objects in BW.
• Enchaned existing ABAP codes in start routines and update routines.

Confidential

System Analyst

Responsibilities:

• Supported Version upgrade from BW3.1 to BI7.0 & worked on Various issues
• Developed performance reports on Existing Architecture and guiding the client on performance improvements and data storage.
• Extracted High volume of Historical data from Legacy system and ECC system to BW system.
• Performed performance tuning on critical and complex queries and acheived improvement.
• Implemented BI Adminstrative cockpit for support and matienance.
• Implemented BI Accerlator on the BI7.0 vsersion upgrade system.

Confidential

System Analyst

Responsibilities:

• Configured and designed BW reporting solution on Sales and distribution module.
• Designed and developed Booking reports for sales Business users.
• Suggested and helped client rebuild existing BW content around Sales.
• Developed performance reports on Existing Architecture and guiding the client on performance improvements and data storage.
• Creating and enhancing BI back end objects such as Info Objects, Info Cubes, Master Data, Multi-providers, Info sets, ODS and DSO’s.
• Extracted High volume of Historical data from Legacy system and ECC system to BW system.
• Performed performance tuning on critical and complex queries and acheived improvement.
• Worked on reports by using EVDRE Function in BPC
• Developed Open Hubs to transfer finance data to the BPC system. preparing project related documentation like object designs, mapping rules, business rules, technical information, test results etc .

Confidential

System Analyst

Responsibilities:

• Conducted Workshops for end user groups and gatheird reporting requirements for CRM Business users.
• Gatheird requirements and performed gap analysis for the areas of CRM Marketing and Sales like Activities, Opportunity, Lead, Service contracts, Survey Mgmt and partner mgmt for end users as well as for Management Reporting.
• Designed interfaces to bring legacy siebel and oracle historical CRM data into SAP BW system (Interface conversion) for each application for last two years of business data.
• Integrated BW with MDM system to bring Masterdata such as BPartner, product and channel partner.
• Delivered Functional Specifications and Technical Specifications for service contracts, survey mgmt, partner mgmt, Opportunity and lead reporting for end users as well as for global Management Reporting.
• Experience creating and modifying BI ETL processes such as extractors for master and transaction data, transformation routines, user exits etc
• Configured and designed BW/CRM Solution by using best practices to meet the client requirments.
• Experience setting up batch jobs and managing BI processes like§ aggregates, process chains and transports
• Experience debugging and developing ABAP development for BI/BW backend and§ reporting objects including BI BADI / CMOD enhancements
• Created BW queries and designed business reports(Dashboard reporting)by using BusinessObjects XI 3.1 application tools universe builder, Web inteligence, crystal reports and SAP integration Kit.
• Worked on performance tuning of queries with Business objects integration and data loading in BI.
• Imported BO Universes on BW queries as source and designed Web intelligence reports.
• Used Open hub to deliver data to third party systems

Confidential

Application Consultant

Responsibilities:

• Developed financial reports by using Business objects XI3.0 application by integrating SAP BI and legacy systems.
• Developed data sources and BW queries in legacy system and BW.
• Designed universes by using universe designer on BW Infocubes& BW queries
• Designed and exported universes on SAP BI queries and designed web intelligence and desktop intelligence reports.
• Designed multiple reports by using cross tab functionality in Webinteligence and desktop intelligence.
• Created Dashboards on multiple web intelligence reports and scheduled for Daily.
• Setup Email notification to the dashboard web intelligence reports.
• Designed crystal reports by extracting the BI queries and DSO objects from SAP BI.
• Designed crystal reports by using ECC Tables and info sets.

Confidential

Application Consultant

Responsibilities:

• Configured and designed solution by using best practices for order to cash (SD) logistics sales analysis by using sales, billing, delivery and pricing functionality.
• Worked on OTC Reporting on condition values, order, delivery, billing quantities, faultless sales order processing and Average delivery processing times.
• Installed Business content objects and setup the (data sources) for application sales order11, Delivery12 and Billing 13 applications.
• Created OTC Multiprovider based on order, delivery and billing cubes for Sales analysis reporting
• Conducted workshops and explored knowledge to the Business users on BI 7.0 support patch 15.
• Designed Test plans for ECC upgrade and BI Support patch upgrade.
• Configured and designed solution by using best practices for Financial Profit and Loss solution for Budgeting and financial Analysis.
• Worked on FI-AR Accounts Receivable, FI-AP Accounts Payable and General ledger Finance (FI-GL).
• Worked on performance on APO Demand planning Data loads to SCM (Vice versa)
• Conducted testing on different BI systems among the landscape for support patch 15 and ECC upgrade and recommended performance solutions.
• Coordinated with ECC Functional and Basis teams on various Business functional and system administration issues.
• Implemented OSS notes for support patch 15 and ECC Upgrade.
• Implemented BIA (BI Accelerator) for data loading and Query performance.
• Implemented BI Stats and Administrative Cockpit for performance analysis and system administration performance.

Confidential

Application Consultant

Responsibilities:

• Configured and designed solution by using best practices for supply chain management’s APO demand planning as per AFS standards and functionality for Sales Analysis and Plan/Actual Comparison of Sales Quantities
• Conducted workshops and installed SCM demand planning and supply network planning Business content.
• Developed Info cubes, multicubes, Reports as per AFS APO business requirements for Demand planning and Supply network planning.
• Application sales order11, Delivery12 and Billing 13 for Historical data to load into SCM system.
• Developed Planning Areas, Planning Books and Macros
• Created a Background job to load live cache data into BW cubes.
• 0APO DP FORECAST 01infosource to bring planned forecast data into BW
• Explored Business users on BI/APO Reporting functionality.
• Extracted transactional data from ECC and planning data from SCM to the BW.
• Worked on system performance tuning on existing landscape data loads (millions of records) and reports and automated the system process in BI and APO systems.
• Worked on early watch report recommendations to improve performances.

Confidential

Application Consultant

Responsibilities:

• Designed a Financial Planning solution by using Business planning and Consolidation 5.1
• Conducted workshops and explored knowledge to the Business users on BPC5.1
• Worked on Data extraction process from ECC and BI to BPC
• Worked on SAP BI/BPC integration
• Created reports by EVDRE functionality in BPC with reference of Sap BI queries
• Used open hub method and rscrm bapi process to extract data from BI to bpc
• Extracted data from ECC by using Z function module.
• Worked on Backend by Creating Application sheets and Dimensions.
• Designed Security Authorizations and tested on different level of users
• Worked on Backup and restore system among the system.

Confidential

ERP Analyst

Responsibilities:

• Conducted Workshops for end user pilot groups and gatheird reporting requirements for CRM Users.
• Gatheird requirements and performed gap analysis for the areas of CRM customer care analysis like interaction analysis, Activities, service order mgmt, Opportunity and Lead reporting for end users as well as for Management Reporting..
• Delivered Functional Specifications and Technical Specifications for Interaction analysis, service order mgmt, Opportunity and lead reporting for end users as well as for Management Reporting.
• Drove the technical architectural design for the CRM BI environment including interfaces
• Led the BI development team.
• Assisted the team with inputs on Best Practices for CRM BI Implementations.

Confidential

Senior BI Consultant

Responsibilities:

• Provided a comprehensive reporting solution for Revenue Recognition which included Sales and Distribution (SD), Finance (FI-GL), Controlling and Profitability Analysis (COPA.) Finance(FI, FI/AR, and FI/AP) modules.
• Provided planning solution using SEM Business planning and simulation.
• Worked on data retraction bring financial data into source system.
• Primary responsibility was delivering custom staging and reporting solution for Revenue Recognition.
• Solution included MultiProvider, Info Providers, design, implementation, as well as reporting high included BEx Suite BW 3.5.version.
• Delivered complex solution within available time frame and budget.
• Assisted in Go-Live implementation simultaneously while working on other projects.

Confidential

Technical lead BI Consultant

Responsibilities:

• Lead the team as a technical lead for BI Upgrade
• Guided the Team members by giving suggestions on oncoming issues.
• Recommending solutions and resolving complicated data, business issues.
• Worked on performance tuning of queries and data loading in BI and Automated the BI process.
• Worked with other teams (Basis & DBA) at different locations.
• Made constituency among the BI system landscapes systems.
• Primary responsibility to deliver custom and standard delivered reporting solution for HCM/HR modules Benefits and Travel Mgmt.
• Solution included MultiProviders, Info Providers, design, implementation, as well as reporting which included BEx Suite Web reporting in BW3.5
• Generated Benefit application reports using KPI’s Average Employee Deductions, Employee Deductions, and Average Employee expenses.
• Generated reports and workbooks Participation Analysis According to Organizational based on Benefits and costs.
• Generated Travel management reports by using KPI’s Travel Expenses, Flight Bookings by Provider, Hotel Bookings by Provider, and Car Rental Bookings by Provider.
• Worked on mass volume of data loads and extractions from R/3 systems and oracle system. key BI player in wat is believed to be the world’s largest SAP BI HCM project
• Delivered over 20 Info Providers using Standard Delivered as well as over 20 custom Delivered Info Providers along with an upgrade to BW3.5.

Confidential

BI Consultant

Responsibilities:

• BI Reporting, integration of BI with SD, & FI
• Activated Business Content for standard objects, Data modeling, and Design andDevelopment of BI components for SD, MM, FI/CO modules.
• Developed several BI components, aggregates and MultiCubes for performance andefficient utilization of data.
• Customized Sales and Delivery Info cubes, Data Sources and Info Sources forData extraction and loading data from OLTP systems into SAP BI system.
• Monitoring the LO Cockpit and the Delta Queue Maintenance. Scheduled dataLoads (Full, init, delta) into BI from R/3. Involved in Master Data maintenance.
• Created Process Chains in scheduling and monitored data loads into SAP BI.
• Extensively used BEx Analyzer, Designer, Web Browser to create and runReports, defining queries, customization of the query data display layout, filters,Attaching of charts, Reporting agent, RRI, Personalization, Variables, Restricted& calculated key figures for filtering and formula requirement of query.
• Build Freight Charge Visibility transaction cube to support the recon of (amountBilled, amount Paid, Check Amount) Payments received from 3 major vendors.