SUMMARY:

• Over 13 years of SAP BW/BI experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementation, Upgrade and Production Support across various Industries.
• Five years of experience SAP BW on HANA and Enterprise HANA
• Experienced in using SAP HANA Backend tools for data extraction using SLT, DXC and BODS tools.
• Expertise in Modeling through (Attribute/Analytical/Calculation view)
• Well versed with SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL Scripts, CE functions .
• Expertise in SAP HANA Security including User Management, Roles, and Privileges
• Implemented4full life cycle projects in SAP BI/BW with different versions of BW 7.5, 7.4, 7.3, 7.0 & BW 3.X.
• Experience in BO Data Services
• Experience in configuring SAP Gate Way Services.
• Experience in Creating API’s through OData Services
• Experience in Using Sales Force Dash Board
• Experience on SAP Charm tool in solution Manager as part of Change request management
• Experience in migration of Non - SAP enterprise reporting solutions and data warehouse to BW &HANA
• Experience in Migrating the BEX Workbooks from 3.5 to 7.0
• Strong knowledge and experience on integration HANA with BW,ECC,BOBJ
• Experience in Migration Activities for BW 7.5 on HANA, Pre Migration and Post Migration Process.
• Experienced in BW/BI Integration using application tools like Web intelligence, Analysis for Office, UDT & IDT.
• 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 extensive technical knowledge
• Experience in BPC & EPM
• Strong knowledge on SAP SD,MM, PM,FI,PS,COPA, Point of Sales ( Confidential ),ISU,EHSM,HR& FERC.

TECHNICAL SKILLS:

Business Area: BW (MM, SD, FI, CO, BPC, PM, POSDM, EHSM, HR)

Product Versions: 3.x and 7.x, ECC 6.0, R/3 4.7, BO 3.1 BI 4.0, 4.1, BODS

Domain Expertise: Confidential, HealthCare, ISU, Manufacturing &Chemical

Operating System: UNIX, Windows (Servers, Client)

Reporting Tools: BEX, Workbooks, WEBI, AO, WAD

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

SAP-BW Lead

Responsibilities:

• Worked on Smart Distribution Operations (SDO) Project in Work Management (PM) area
• Worked with Solution Architecture team on the Solution Blue print of SDO
• Participated in Design& Gap Analysis meetings with business& functional teams
• Good Understanding of Plant Maintenance Orders, Notifications, Operations, Tasks.
• Worked on PM Order, Notification, Operation, task data sources like 2LIS 17 I3HDR,
• 2LIS 18 I3HDR, 2LIS 17 I0NOTIF,2LIS 18 I0NOTIF, etc.
• Developed BW technical design for the all line items in SDO Project
• Configured SAP Gate Way Services in BW System using SPRO Settings
• Enabled O Data services to expose BEX Queries through API, and these API are consumed by Sales Force for reporting
• Created system alias which is used in the generation of service
• Created BEX Queries to meet client reporting requirement
• Created DSO’s & Open Hub’s to pass data to external systems like SQL Tables
• Created BODS Jobs to pass data to SQL tables & Flat files
• Worked on SAP Charm tool in solution Manager as part of Change management
• Created Process chains to trigger BODS jobs from BW
• Scheduled BW batch Jobs using UC4 tool.
• Worked on start / end routines to derive required business logics

Environment: BW7.5, ECC 6.0, BODS, PM,FI, ISU.

Confidential, Port Land, OR

SAP-BW Lead

Responsibilities:

• Worked on Upgrade of BW from 7.3 to 7.5
• Migrated 3x data flows to 7x data flows
• Working closely with Business to understand business process for SAP BI implementations, design of data modeling and reporting.
• Worked on Cross application Time Sheet Data Sources Time Sheet Approved 0CA TS IS 1 and Time Sheet for Approval0CA TS IS 2.
• Created Business Objects reports on top BEX Queries.
• Worked on AWAIR Project For OSHA reporting needs
• Designed & Developed Generic Data Sources, Info-Cubes ODS and Custom report to fulfill user Reporting requirements
• Working Knowledge of CCA, PCA, and Project Systems.
• Worked on cost center accounting, data source issues 0CO OM CCA 01Plan
• And Actual 0CO OM CCA 09
• Monitor & Troubleshooting of Existing Data loads by using Process Chains.
• Scheduled BW batch Jobs using Control - M tool.
• Used BI Accelerator Indexes for Performance improvement.
• Working on Remedy tool for incident management to track the SLA timings.
• Worked on ABAP programming for business logic

Environment: BI7.5, 7.3, ECC 6.0,BO 4.1, FI, PS, PM,HR,ISU

Confidential, NY

SAP-BW/HANA Lead Consultant

Responsibilities:

• Worked on FI-CA, closed and open item data sources 0FC CI 01, 0FC OP 01
• Worked on HR CATS Extractor 0CA TS IS 1 for time Entry and did enhancements
• Worked on cost center accounting, installed commitment line Items data source 0CO OM CCA 10 and did enhancements as per requirements and created Actual plan commitment report.
• Worked on Upgrade of BW from 7.0 to 7.4
• Worked on HANA Migration, from Oracle to BW on HANA database
• Created Attribute, Analytical & Calculation Views (graphical and scripted)
• Replicated ECC tables to HANA using SLT
• Created Composite Provider using HANA View and BW objects.
• Migrated all the 3x BEX Workbooks to 7.0.
• Worked on Custom VBA Code while migrating the workbooks to 7.0
• Worked on Budget, Planning, Billing and HR Workbooks
• Worked extensively on BEX Broadcaster
• Created WEBI reports on BEX queries using BICS connection
• Monitor & Troubleshooting of Existing Data loads by using Process Chains.
• Worked on ABAP programming for business logic

Environment: BI7.0,7.4, ECC 6.0, BEX 3.5, 7.0,BEX Work books, BO 4.1, HANA,ISU, FI, HR, FI-CA.

Confidential, Pittsburgh, PA

SAP-BW/HANA Lead

Responsibilities:

• Worked on Full lifecycle Implementation of SAP EHSM (Incident Management) & replaced the old Legacy system
• Extensively worked on activating the delivered business content objects with customization, including all content reports Custom BW Queries for Dashboard and Backend Extractor changes as per Business Requirements for complex design
• Worked extensively on WEBI reports based on business inputs, measures
• And metrics by all possible dimensions.
• Historical Data migration from legacy system ILP to BW with DB connect.
• Functional report testing with business to satisfy all functionality and requirements.
• Involved in HANA Migration, from Oracle to BW on HANA database.
• Worked on Upgrade of BW from 7.3 to 7.4
• Prepared the test plan for HANA migration & tested the performance of Queries after Hana Migration.
• Worked on SAP HR in areas personnel Administration and Organizational Management.
• Worked on migration of HR Reports from old EDW system to HANA using HANA studio.
• Data provisioning and data replication from source system to HANA database using SLT
• Developed HR models by creating Attribute, Analytical & Calculation Views (graphical and scripted)
• Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views
• Created Universes using IDT (Information design tool) on top of HANA calculation views and developed WEBI reports
• Created transports in solution manager for HANA objects and transported using CTS+

Environment: BI7.4, 7.3,BI 4.0, 4.1,WEBI,AO, IDT, HANA Studio, SMR,EHSM, HR.

Confidential, Sunnyvale, CA

SAP-BW/BO Consultant

Responsibilities:

• Working closely with Business to understand business process for SAP BI implementations, design of data modeling and reporting.
• Worked extensively on BEX queries and generated OLAP universes
• Developed several Complex Reports include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database
• Design and development of Web Intelligence (Info View) for interactive analysis, sourcing data from SAP BW using single sign-on
• Worked on Business object OLAP reporting sytems based on Bex Reports
• Efficient analytical tool to quickly generate Web Intelligence ad-hoc reporting and plan verses actual comparison, allowing users to slice & dice the various KPIs, measures and metrics by all possible dimensions.
• Design and development of Web Intelligence (Info View) for interactive analysis,
• Involved in BOXI Upgrade from 3.1 to 4.0 testing and support of WEBI reporting
• Scheduled WEBI Reports in CMC on Daily, Monthly, Weekly basis
• Designed & Developed custom Data Sources, Info-Cubes and ODS to fulfill user requirements.
• Setup Central Management Console (CMC) Security for assigning users, roles and groups using SAP Authentication and Single Sign-on

Environment: BI7.3, BOXI 3.1, BI4.0, WEBI, Crystal, ECC6.0, SD, MM.

Confidential, Beaverton-OR

SAP-BW Consultant

Responsibilities:

• Gathered Business requirements from business users for creating reports
• Created custom variants that allow users to choose report type based on variant conditions like sales division, sold-to-party and sales representatives.
• Extracted transaction data for sales from POSDM on a daily basis
• Designed & Developed custom Data Sources, Info Sources, Extractors, Info-Cubes and ODS to fulfill user requirements.
• Created open hub destinations to move the BW data to other systems
• Used BIAccelerator Indexes for Performance improvement.
• Used Solution manager to maintain over all documentation of the project
• Developed flexible queries using filters, navigational attributes in BEX Query designer to facilitate data analysis in a drill down/summarized way to give detailed levels of information.
• Created row & Column structures for queries to get detailed sales report on product hierarchies & cost center hierarchies
• Created cell formulas based on requirements
• Created Restricted Key figures, calculated key figures for % Growth versus Prior Year Month & % Growth versus Prior Year Quarter
• Created WEBI reports for daily sales summary, sales exception & tax recon etc.
• Created reports in WEBI which include the prompts for WTD, MTD, QTD, YTD, calculations.
• Created reports using OLAP analysis for office
• Checking data consistency and error handling
• Used Auto sys tool for scheduling, monitoring and reporting of production data loads.
• Experience in using Business objects analysis for office

Environment: BI7.1, BIA, BI4.0, AO, WEBI, ECC6.0, POSDM, SD, MM, SMR, HP QC.

Confidential, Minneapolis-MN

SAP-BW Consultant

Responsibilities:

• Analyzed the Client/End user reporting requirements, Involved in the Design & Test Phases
• Involved in Unit Testing, Integration Testing & User Acceptance Test
• Participating in the Status meeting with the Client.
• Advising the Client regarding the Performance improvement.
• Developed sales reports like Order to Cash (OTC), Weekly Deliveries, Sales Values, and Incoming Orders.
• Worked with GL data sources 0FI GL 10 and 0FI GL 14.
• Created reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports
• Developed flexible queries using filters, navigational attributes in BEX Query designer to facilitate data analysis in a drill down/summarized way to give detailed levels of information.
• Created custom variants that allow users to choose report type based on variant conditions like sales division, sold-to-party and sales representatives.
• Worked on Creating BEX Workbooks and embedded multiple queries in single workbook.
• Created BI Accelerator Indexes for Performance improvement.
• Extensively worked on activating the standard delivered business content
• Trained end users and supported them in resolving their issues.
• Determine structured and ad-hoc reporting requirements and business rules for finance sales domains

Environment: BI 7.0, BIA, BEX, BEX Workbooks 3.5 & 7.0, SD, MM, FI-GL, ABAP/4

Confidential, Minneapolis-MN

SAP-BW Consultant

Responsibilities:

• Involved in Design, Build & Test Phases, Fit-Gap Analysis and Process Design Documentation.
• Worked on data Sources Customer Service 2LIS 18 I3HDR, 2LIS 18 I0NOTIF
• Designed custom data sources using Function Modules
• Worked on ABAP programming for business logic
• Designed Data Store objects, Cubes, Multi providers based on requirements
• Built the query based on the design specifications
• Written Customer Exits for the Query in order to get summary & details levels in the Report
• Responsible for job scheduling for loading data into Info Cubes, ODS objects
• Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down/summarized way to give detailed levels of information
• Created reports and structures from purchasing data sources like Purchase Orders Quantities, Purchase Order Values.
• Created Daily Sales Reports which involves Daily Sales Orders, Order Reasons, Customer Group and other important sales data.
• Extracted data using LO Cockpit, data sources from SAP R/3, Source Systems.
• Worked on PM Data sources maintenance orders, notifications, Items 2LIS-17-I3HDR, 2LIS-17-IONOTIF, 2LIS-17-IOITEM etc.
• Created maintenance order, Maintenance task reports
• 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.
• Written routines at different levels like start routines, end routines.
• Worked on functions of BEX Query Designer in the state-of-the-art BEX Web Application Designer, excel-based application design with the new BEX Analyzer.
• Monitor & Troubleshooting of Existing Data loads by using Process Chains.
• Resolving the tickets according to priority.
• Participating in the Status meeting with the Client

Environment: BI 7.1, BEX, BIA, ABAP, ECC 6.0, SD, CS, PM, QM, ABAP/4.

Confidential, Memphis - TN

SAP-BW /BO Consultant

Responsibilities:

• Worked on project (STP) See Through Profitability
• Worked on COPA Data extraction into BW for profitability project.
• Worked on COPA Data Source 1 CO PA CCA
• Created custom data source based on operating concern
• Coordination between user requirements and COPA functional Team
• Configured controlling area and cost center hierarchy
• Worked on functions of new BEX Query Designer in the state-of-the-art B-Ex Web Application Designer, excel-based application design with the new BEX Analyzer.
• Designed, Developed and Maintained Business Objects Universe over SAP BEX queries
• Designed and developed universes in the designer by connecting BEX to BO, Crystal reports
• Involved in Unit Testing, Data Loading, Execute Workbooks, Integration Testing, User Acceptance Test.
• Extensively worked on Extraction of Data using open Hub (Info spokes).
• Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains.
• Involved in the Upgrade Apps, Pre-checks, Tech Upgrade, Prepare, Post Activities, Migration to New Weaver 7.0, Web Objects to Net Weaver 7.0, Plug-in release.
• Testing has been done by taking the scenarios existing in the current BW 3.5 implementation and creating the same in BI 7.0 system
• Data flow analysis Queries/Workbooks in BW 3.5 System, Technical Upgrade BW 3.5 Dev. to BI 7.0 Dev., Post Upgrade Analysis (DEV environment).

Environment: BW 3.5/BI 7.0, BEX, ECC 6.0,ABAP SD, FI, CO-PA, BOXI 3.1, Crystal Reports

Confidential

SAP-BW Consultant

Responsibilities:

• Designed data models for custom Info Cubes & ODS objects. Involved in the design and development of Info Cubes in MM and SD applications
• Worked on Sales Order Data sources 2LIS 11 VAHDR and 2LIS 11 VAITM
• Activated Sales Cubes 0SD C01, 0SD C02, 0SD C03, from Business Content and customized to meet the requirements
• Worked on Inventory Management cube 0IC C03 to get the inventory reports like Stock overview and Inventory turnover ratio and used data sources 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM
• Set up procedure for extracting R/3 data for Inventory Management, in Material Management using LO-Cockpit.
• BW Data load scheduling, monitoring and troubleshooting data extraction and load problems
• Involved in Reconciliation of R/3 data and BW data
• Involved in mapping of data source to info source with transfer rules in SAP BW.
• Involved in mapping of info source with the Data targets using update rules
• Configured the use of variables, Filters, Free characteristics and restricted key figures in Queries.
• Worked on Extraction of Data using open Hub Destination
• Extracted data from SAP R/3 using Generic extraction techniques and LO cockpit and loaded into Sales Order Info Cube using Data Sources
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3 environments
• Created Multi providers on cubes for BEX reporting
• Worked on creating Aggregates, Compressions, Indexes, and parallel setups for data loading to improve performance and utilize data effectively.
• Used Root Cause Analysis (RCA’s) methods to cement the recurring problems and cause of High severity problems.
• Created reports using variables, conditions, exceptions, restricted and calculated key figures etc.

Environnent: SAP BW 3.0B, 3.5, SAP R/3 4.6C, SD, MM, BEX, BEX Work Books