SUMMARY:

• SAP HANA/BI/BW/BOBJ Architect with over 13 years in IT with 9 years as Techno - Functional architect with hands on development in SAP HANA/BI 7.4/7.3/7.0/3.5 and 3 yrs of SAP BOBJ Reporting experience in 4.1 using IDT, Universes and Webi reporting.
• 2 years of SAP HANA/BW on HANA migration/modeling experience in creating Attribute/Analytic and Calculation Views, Open ODS Views, Virtualized Real Time Views using Smart Data Access.
• Experience in using BODS in side-car approach to extract the data from SAP and non- SAP as sources using the batch jobs.
• Designed and maintained various InfoObjects, InfoSources, InfoPackages, ODS/DSO Objects, InfoCubes, MultiCubes Open Hubs and transfer/update rules/transformations, Start/End/Expert Routines. Implemented Hierarchies as per the requirements.
• Created Open Hub Destinations to transfer data from BI to Flat Files, Tables and 3rd party to load external systems. Designed Universes using the BW Queries and BW info providers for reporting in Business Objects.
• Data Modeling work included design of Info Cubes, DSOs, Multi Providers, UOM and Currency conversion, revenue and COGS calculation, material determination, data validation and error handling, start routine, update rules and transfer rules, transformations Extractions, Transformations & Loading (ETL) - Extracted data from Logistics (SD, MM), COPA, Generic data sources, Flat File source systems, and Legacy Systems (Non SAP R/3).
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Query Stripping, Mutiple Data Provider Webi’s, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Extensively worked on Performance Tuning using BW Statistics, Runtime Analysis, Aggregates, Compression, Partitioning and Database Statistics.
• Expertise in Report Generation, worked extensively in BEx Analyzer in building Queries and saving into Workbooks, created Custom Queries using Conditions, Exceptions, Variables and Structures, created Aggregates for frequently accessed queries for faster accesses.
• Worked on implementing the IP - Integrated Planning functionality for spreading the Unit Cost, Inflation data from Product Hierarchy Levels to Material Level.
• Excellent communication skills, ability to learn fast and ability to work in a team.
• SAP In-Memory Technology (SAP HANA):
• 2 years of SAP HANA/BW on HANA modeling experience in creating Attribute/Analytic and Calculation Views, Open ODS Views, Virtualized Real Time Views using Smart Data Access.
• Expertise in Data Provisioning techniques like SLT (SAP and Non-SAP), DXC, SAP BOBJ Data Services and Flat file upload.
• Experience in working with SAP HANA optimized DSO’s and Infocubes.
• Heavy experience in creating Information Models like Attribute, Analytical and Calculation Views with in HANA Studio.
• Solid Experience in creating Complex Calculation Views using SQL CE library functions and SQL
• Scripts. Hands-On experience in creating BOBJ Analytical reports using HANA Information
• Models.
• Architected Info Providers and data models in both standalone HANA environment and BW Powered by HANA environment (Ramp-up).
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT) as final model in HANA Studio.
• Good exposure on Schemas, table definitions, Attributes, Measures & Hierarchies, SQL and SQL Script in HANA.
• Load/Replication of data into SAP HANA Environment using SLT and Business Objects Data services.=

TECHNICAL SKILLS:

SAP HANA/BW/BO/BODS: SAP HANA / BI 7.4,7.3,7.0, BW 3.5, 3.1C, 3.0, 2.x, BO 4.0, XI 3.1,Data Services 4.0/3.1

SAP R/3: SAP R/3 4.X, ECC 5.0, ECC 6.0

Front End Tools: BEx Analyzer. Query Designer, Web Application Designer, Universe Designer, Webi, IDT

Databases: Oracle 10g/9i/8i, MS SQL server 2008/2005, MS Access, DB2

Languages: ABAP/4, VB, Java, ASP

Operating Systems : Windows XP/2000/NT

Others: HTML, JavaScript, MS OFFICE

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP BI/BOBJ/HANA/Lead

Responsibilities:

• Involved in HP SMO Split project for separating the companies as HP Enterprise and HP In corporation for data separation for Day 1.
• Worked on EG PPS Split project, which defines the official system split between Enterprise Group and Printing and Parts Supply business.
• Lead the team to deliver the SMO split project by customized program updates for the DSO’s for Sales Orders/PO’s/Invoices/Deliveries for historical data which should not be showing in both the companies after the split.
• Co-ordinated with SNP team who implemented ECC historical data split for HP to bring in the changes to BW and updated BW data as per SNP updates by creating extractors/DSO’s and custom code to read these DSO’s and update the historical data and send the feeds to partners.
• Involved in the Cutover activities, Cache and Flush, RTP process for smooth transition of the project for HP Split.
• Developed material master data extracts to partner systems like DHL by adding new indicator which segregates the part, assigning it to different business group.
• Created reports in SD module like open sales order report which include all organization levels, delivery status, shipping details and partner function details.
• Worked extensively in Warranty portfolio which deals with the service orders and the warranty of HP products and parts. Created extracts (open hubs) to send data to partner systems to do Service Activity Cost reporting and reconciliation.
• Supported all the MEC and QEC related issues with finance reporting by resolving all the tickets raised by business. Worked on user generated tickets like data inconsistency and other report related issues and fixed the same with root-cause analysis via BBF releases each month.
• Coordinated post FYE flush and caching activity to keep pulling the delta’s posted in R/3, due to changes in Product lines/business areas/cost centers/profit centers etc. All these huge volumes are pulled 24X7 by manually running the V3 job and lading them into staging layer into BW, thus reducing the load on daily night delta cycle.
• Involved in Post Sales Tax report desing and co-ordinated the development with team and business to deliver the reports before HP split GO-LIVE.
• Worked on Creating Calculation, Analytical and Attribute views in SAP HANA 1.0 based on reporting requirements using SAP HANA studio.
• Experience in various data provisioning options in HANA studio like replicating tables from SAP ECC into HANA using SLT for real time data used for operational reporting.

SAP BI/BOBJ Architect/Lead

Responsibilities:

• Involved in architecturing the data model for Full Funding Project to implement Penalities and Interests.
• Designed and developed the Custom Extractors from Full Funding Project customer tables which gets the files from different Report Source.
• Designed and developed the BW Datamodel with staging DSO’s, Consolidation Layer DSO and Multi Dimensional reporting Infocubes.
• Modified the existing PSCD extractor to provide more granularities in reporting for employers using the business partner data from PSCD.
• Designed BEx and BOBJ reports like Report Unit GASB Accrual Difference Report, START and BD Exception Report, Report Source Contribution Reports from the data models for end user reporting.
• Involved in meetings with Functional Leads to gather information to chart out the technical specifictions for the Full Funding Project.

SAP BI Architect/Lead

Responsibilities:

• Involved in Pilgrim Complaint Management project to provide Sales and Product Extract files.
• Involved in team meetings to gather requirements and design the technical documentation to design the datamodel.
• Desgined Infocubes, Open Hubs to create Outbound Sales and Product Extract files and place in the AL11 directly for Informatica to pick and process into Pilgrim Complaint Management System.
• Wrote routines to customize the file formats and formatting the data for external systems.
• Designed process chains to automate the process of writing the files to the specific directory to be picked up by Informatica.

SAP BI /BOBJ Architect

Responsibilities:

• Involved in SAP BW on HANA upgrade project and HANA POC development to leverage SAP HANA with the current data models for EMC.
• Involved in Pre-Processing, Technical Conversion and Post Processing of existing SAP BW on traditona database to SAP BW on HANA.
• Developed Information data models using side car approach for real time report scenarios for Real Time Bookings, Back Log for business needs.
• Rolled up R2 Propel implementation, involved in gathering requirments from Business meetings in various applications like Sales, Billing, Install Base, Variant Configuration (VC) for Sales Orders based on material classes and Variant Configuration of Equipment, PS and CPM.
• Involved in architecturing the data model to bring the SAP Landscape from RSA to EMC to tightly integrate in a GLOBAL implementation.
• Created Open hubs to source the data into GDW (Oracle System) for reporting on informatica/business objects/OBIEE.
• Involved in the cut-over activities including creating and maintaining the process-chains, managing and scheduling the data-loads.
• Involved in the support of the go-live activities, including resolving the HP Quality center defects, in coordination with the end-users and testing team.
• Involved in R1 release stabilization process to stabilize the Live SAP BI 7.3 system after the GO-LIVE. Involved in business meetings to resolve the business critical issues related to Bookings/Billings/Controlling.
• Supported Quartely Agile releases to stabilize the R1 BI system for business critical reporting by working on performance tuning, ABAP Coding, design modifications.
• Involved in the implementation project for Propel R1 at EMC, Data Modeling, Design and Data Extraction of Logisctics Extractors, Generic data extractors for Bookings, Backlogs (Sales and Distribution) with EMC internal process models like Hard Redirects, Soft Redirects, SCR (Sales Credit).
• Created generic extractors for 11i data via DB Connect.
• Extensively used Row Generation, History Preserving, Key Generation, Query, SQL, Merge, Case, Validation transforms to transform the data for loading into the warehouse tables.
• Analyzed functional requirements and developed ECC and BW Data Mapping, translated the functional specifications into technical specifications to be used for development purposes
• Worked on various BW components, Infocubes, DSOs, Open Hubs, Transformations (start & end routines), DTPs, Infoobjects, process-chains and infopackages to meet the customer requirements.
• Involved in the on-going maintenance, break fix and providing post-production level support on the Propel R1 Release

Environment: SAP BI 7.3, SAP R/3 ECC 6.0, ABAP/4, SAP BW, BEx, BODS 4.1, Business Objects XI 3.1/4.0 Designer, WEBI, Infoview.

SAP BI/BOBJ Lead Consultant

Responsibilities:

• Involved in the business requirements gathering for Sales and Distribution Reporting for both BEx and BOBJ reporting, development, testing and Go-Live.
• Installed and modifed Business Content Sales & Distribution Extractors like 2LIS 11 VAITM/2LIS 11 VASTI, 2LIS 12 VCITM, 2LIS 13 VDITM, 2LIS 08 TRTLP and to fulfill the gaps identified in the Business Requirements gathering by adding the custom fields and writing the ABAP code using BADI’s.
• Populated requested delivery date, Customer purchase order date and Created date from VBAK; broker and secondary broker from partner function (VBPA) in to sales item level extractor.
• Populated Proposed Revenue Recognition Date and Period from VBRK into billing item level extractor. Populated delivery fields from LIPS to Delivery Item in Shipment extractor.
• Designed and developed the data model with Data Staging Layer with Standard DSO’s with data cleansing routines for PO Numbers, Incoterms Conformance Layer with Standard DSO’s with the business logics, DataMart Layer with Company Global, Local Currency and Quantity conversions.
• Designed and Developed the Sales BEx Queries like Case Fill Order Fill By Brand, Case Fill Order Fill by Division, Daily Sales Reports, Reach Report, Order Detailed Report, Invoice Reports and Shipment Reports .
• Created Secured Connections to build the OLAP Universes using the Source as BEx Queries in the BOBJ Designer.
• Re-designed and Implemented the GL Summary and GL Detail applications to leverage the new 0FI GL 14 extractor.
• Used 0FI GL 20 for Balances and 0FI GL 14 for leading Ledger (Line Items). Also, used the special ledger extractors 3FI GL Z1 SI for US GAAP and 3FI GL Z2 SI for Local GAAP ledgers.
• Developed COPA reports - Profitability (Gross Margin),Gross Sales trend reports (by Material, Profit Centre, Financial Period), Gross Sales by Week, Basic PL by Country-State, Brand Net Sales, Redbook Detail section 199 calculation etc.
• Designed and developed WEBI Reports for Case fill order reports, Reach report, Invoice summary, Analysis, Sales Line details, Daily sales, Shipment detail, Profitability, Customer analysis, Gross Sales by week, Net Sales By Week, Reason Code Summary and Trend reports using the OLAP Universes.
• Captured the Run Time Criteria in a separate tab of the report to show the Document Name, Last Execution Date, Query Summary, Prompt Summary and Report Filter Summary using the standard BOBJ functions as per the Business Requirements.
• Extensively used Breaks, Sections, and Drills for drilling on the Hierarchies to display the data at different Node Levels when designing the reports.
• Created report variables to capture the User Response on the BOBJ Report as per the Business Requirement using the built in functions like User Response, IsPromptAnswered, SubStr, Length for reusing in other reports.

Environment: SAP BI/BW 7.0, SAP R/3 ECC 6.0, ABAP/4, SAP BW, BEx, BODS 4.0, Business Objects XI 3.1 Designer, WEBI, Infoview.

SAP BI/BOBJ Consultant

Responsibilities:

• Involved in the business requirements gathering for Sales and Distribution Reporting for both BEx and BOBJ reporting, development, testing and Go-Live.
• Designed and Developed the Sales BEx Queries like Sales by Material, Sales 13 Month Rolling Forecast and also worked on modifying some of the existing queries for GL Profit & Loss Module to include the Hierarchies and reporting using the Hierarchies in BOBJ.
• Created Secured Connections to build the OLAP Universes using the Source as BEx Queries in the BOBJ Designer.
• Designed 3 OLAP Universes for Sales Reports and modified existing Finance Universes as per the changes using the BOBJ Designer from the BEx Queries as the Source for Hierarchy Activation in the BEx queries.
• Designed WEBI Reports Sales by Material, Sales by Customer, Sales by Territory, Sales by Ship to Customer, Sales by Customer & Material Combo and Sales by Material Rolling 13 Reports using the OLAP Universes.
• Customized the Universe to hide the L00 objects, renamed the L01 Objects for easy understanding, maintenance and disabled the LOV List for the dimensions which are not required to avoid performance issues.
• Modified the measure properties in OLAP Universe to control the projection of the measures at the report level rather than using them as is from the BEx Queries.
• Modified the Filter Properties for Prompts to avoid using of unnecessary prompts in the BOBJ Reports which are coming from the OLAP source.
• Extensively used Template tables like CrossTab, Horizontal Table, Vertical Table and Free Standing Cells in capturing the User Response on the report, Page Numbers, Company Logo.
• Captured the Run Time Criteria in a separate tab of the report to show the Document Name, Last Execution Date, Query Summary, Prompt Summary and Report Filter Summary using the standard BOBJ functions as per the Business Requirements.
• Extensively used Breaks, Sections, and Drills for drilling on the Hierarchies to display the data at different Node Levels when designing the reports.
• Created report variables to capture the User Response on the BOBJ Report as per the Business Requirement using the built in functions like User Response, IsPromptAnswered, SubStr, Length for reusing in other reports.
• Customized the User Response to show the values on the report based on the business requirements to show “ALL” if nothing is selected and show only 5 values if more than 5 values are selected on the report.
• Formatted Date Strings as per the Business Requirements, extensive used reporting formatting like Relative Positions, Horizontal Table for capturing the User Response for Excel Printing when designing the report for easy future maintenance and modifications.

Environment: SAP BI/BW 7.0, SAP R/3 ECC 6.0, 4.6C, ABAP/4, SAP BW, BEx, Business Objects XI 3.0 Designer, WEBI, Infoview.

SAP BI Lead Consultant

Responsibilities:

• Involved in the Unit Cost, Inflation and Manufacturing Productivity project from requirements gathering, Blue Printing, Development, Testing and Go-Live.
• Built Custom Extractors on COEP, COSS and MSEG, MKPF. Global centrally maintained warehouse with extraction from multiple source systems.
• Designed and developed the data model with Data Staging Layer with Write-Optimized DSO’s, Conformance Layer with Standard DSO’s, DataMart Layer with Company Global conversions.
• Extracted data from different source systems of PR2 (3.1i), CIP (4.7), E6P (6.0), E7P (6.0), E8P (6.0), and EXT Source System (4.5B) using generic extractors created using the Functional Module.
• Implemented Currency Conversions, Unit Conversions for reporting the data from Base Unit of Measure to Reporting Units and Alternate Units as per company standards.
• Implemented Error Stack in transformations to be intimated of any missing master data used during lookups.
• Implemented Currency and Unit conversion in transformations and at runtime during report execution.
• Created Transformations at Field Level, Start Routine, End Routine and Expert Routine for this data model to meet the business requirements.
• Developed Virtual Reporting Layer with 8 Multiproviders and developed the BEx reports with on the fly unit of measure calculations.
• Created BO Universes, Adhoc Universes based on the BEx Reports for Business Users with different calculations for Currency Impact, Material Inflation and Manufacturing Productivity.

Environment:: SAP BI/BW 7.0/3.5, SAP R/3 ECC 6.0, 4.6C, IP (Integrated Planning), ABAP/4, SAP BW BEx, Web Application Designer, Business Objects XI 3.0

SAP BI/BW Senior Consultant

Responsibilities:

• DC Inventory & Global Procurement Models for Bayer Health Care
• Designed the new DC Inventory & Global Procurement BW data model for Bayer Health Care.
• Developed different Info Cubes, ODS like GP FIGL, GPFIGLO4, GP PUR01, GP EKKN, GP HDR, GP ITM, GP SCL.
• Developed different reports like Header & Item Details, Vendor Comparisions, Purchase Orders Account Assignment, Delivery Activity Reports, Open PO reports on Multi Providers GP M02, GP M01.
• Developed DC Inventory Model with Info Cubes, ODS DCINV C01, DCINV PUR, DCINV ACT, DCSAL ACT, DC RESUP using the Infosources 2LIS 03 BF, 2LIS 03 UM, 0MMIC VAL and UB WM INVENTORY.
• Created Extractors using RSCRM BAPI for third Teradata system for reporting on Cognos.
• Designed the new BW data model for McKesson & Abbot data coming to Bayer HealthCare System and created WAD queries for analyzing the data.
• Created Info Cubes DBIL C1 for Billing, DSLS C1 Sales, CLAIM C1 Abbott Claims, CLAIM C2 McKesson Claims, ACCR C2, McKesson Accruals, Staging ODS like MCONT O1S, MCONT O2S, MCONT O3S, REB O1S, REB O2S, REB O3S, DBIL O1S, ACCR O2S and First level ODS like MCONT O1, MCONT O2, MCONT O3, REB O1, DBIL O1, ACCR O1, CLAIM O1.
• Created Multi Providers ACBIL M Accrual & Billing, BIL M2 Imaging Billing, CLAIM M1 McKesson Claims, and Infosets like CLAM O2S, DBIL O1S, DSLS O1S for various reporting purposes.
• Created Open Hub Destination using Flat Files, Tables for third party systems like EDW, IMS and BIS as a feed for Government Reporting, EDW Sales Reporting and IMS reports.
• Designed the new BW data model for BPS Planning for Seattle & Emeryville Business Group for CostCenter Actual data, HR Headcount data (Flat File) and HR Merit & Pre-Merit data.
• Created ODS for loading the flat files and loading the deltas into the CostCenter Actual Cube for reporting purpose.
• Automated the load process to run the files every month for Planning.
• Developed CostCenter, HeadCount and Advertisement & Promotions reports for BPS module.
• Designed the new BW data model for BPS Planning for WestHaven Business Group for CostCenter Actual data, HR Headcount data (Flat File) and HR Merit & Pre-Merit data.
• Implemented a custom Costcenter security design by creating a generic datasource in BW to load all the Business Users data with their roles to show only the CostCenters they are assigned to.
• Used DBConnect to extract HR Merit & Pre-Merit data from HR Oracle System.
• Enhanced 0COORDER, 0Costcenter to derive the State, Country fields for BPS Planning.
• Developed CostCenter, HeadCount and Advertisement & Promotions reports for BPS module.
• Involved in the identification of R/3 Extractors, BW Cubes, ODS, Queries and Workbooks that are hardcoded for the Controlling Areas, Company Code, Profit Centers.
• Modified the BPS BW Infoproviders, BPS Queries for hard coding values.
• Modified the BW infoproviders update rules, transfer rules for hard coding values, modified the queries, workbooks by creating new variables for Company Code, Controlling Area.
• Global Procurement & Prokon Q3 Changes Support - Germany
• Involved in Change Control Process (CMT) Process, Test Director Testing and CTS collection, trouble shooting the process of moving the development objects to Production System for the new Global Procurement Module and Prokon Q3 Changes with.
• Involved in changing the 0CostCenter and GP BUKRS master data datasources for correctness of data loads from NBP to B53 system.
• Modified COPA Health Care Queries & Workbooks to be used by Animal Health Group Users by removing the Hardcode values, filters, variable restrictions.
• Enhanced Plant Maintenance Extractors 2LIS 17 I3HDR, 2LIS 17 I0ITEM, 2LIS 17 I0NOTIF, 2LIS 17 I3OPER and 0NOTIFICATN ATTR to include new reporting fields for Berkeley Business Users.
• Modified the info cubes FAM Orders (ASPM C03), Maintenance Order Operations (ASPM C04), Notifications (0QM C10) to accommodate the new Plant Maintenance fields.
• Modified Overdue PM's, Notification Back Log, QMR queries with newly added fields in the extractor to see the Back Logs in the Plant Maintenance.

Environment:: SAP BI/BW 7.0/3.5, SAP R/3 ECC 6.0, 4.6C, ABAP/4, BPS, SAP BW BEx

SAP BW Consultant

Responsibilities:

• Developed Data Model for SD, FI modules for implementing Order to Invoice and Invoice to Cash using ASAP methodology by enhancing 2LIS 11 VAITM, 2LIS 11 V SCL extractors and created generic extractors for loading the Inventory, Stock Pricing and Shipment data to BW.
• Documented ETL Technical, Reporting Technical design and Unit Test documents as per the Functional design document for Order to Invoice and Invoice to Cash BW implementation.
• Data Modeled 12 ODS, 8 Cubes and 4 Multiproviders required for Order to Invoice and Invoice to Cash with Transfer Routines, Update Routines and Start Routines for custom logic implementation.
• Extracted Sap Sales data, billing data using LO Cockpit extractors for current transactions, extracted historical data from SOLO Baan, SOLO BPICS and SOLO OM systems using generic extractors and Plan data from flat files.
• As per Business requirements, modified the Item level data to show the Back Order quantity in the Order Quantity by dropping the Original Line Item in InfoCube using a Start Routine.
• Extensively created Start Routines, Update routines to meet the business requirements like Currency conversions, Unit conversions and other specific requirements as part of this implementation.
• Developed more than 20 reports namely Case Fill, Dollar Fill, FGI, DFC, Order Fill, Line Fill, Sales Performance, Profitability, Sales Flash (Month to Date, Year to Date, Net Margin) reports for Order to Invoice and Invoice to Cash Modules with different levels of granularity.
• Designed Custom HTML pages using Web Application Designer and post them on the portal and provide a Single Sign On (SSO) User login for all the reports on the SoloCup Enterprise Portal.
• Created Process Chains to automate data load process for Master Data Loads, Transaction Data Loads and integrated with the SoloCup Standard called AutoSys for scheduling.
• Supported the GO-LIVE Production environment for BW 3.5 implementation at SOLO CUP to fix the issues related to data loads, performance, changes to stabilize the system.

Environment: SAP BW 3.5, SAP R/3 4.6C, ABAP/4, SAP BW BEx, Web Application Designer.

SAP BW Consultant

Responsibilities:

• Developed Data Model for Chain and Designated Market Area Execution Planning (DMA/DEP) modules for MAPS Integrated Budget Reporting planning project.
• Documented ETL Technical, Reporting Technical design and Unit Test documents as per the Functional design document for the Customized Costs and Allocations Planning BW implementation.
• Data Modeled 4 ODS, 4 Cubes and 2 Multiproviders required for Custom MAPS project involving Plan and Target data for budget planning with Transfer Routines, Update Routines and Start Routines for custom logic implementation.
• Extracted data from SAP R/3 using business content extractors, Cognos data from flat files and MAPS SQL Server data via UDConnect.
• As per Business requirements, old versions of data load should be deleted and last version should be kept permanently for an OverLay (Version) in the info Providers. Implemented this Logic through ABAP 6 Routine in Info Package.
• Developed 36 Integrated Budget Reporting Calendar Year, Fiscal Year and Consolidated reports for Chain and DMA Modules which have different levels of granularity like Chain Headquarter, Chain Decision Point, National Sales Team, Regions, Market Area, DMA Clusters, Brand Segments and MSE Category Levels.

Environment:: SAP BW 3.5, SAP R/3 4.6C, ABAP/4, SAP BW BEx, Web Application Designer and Enterprise Portals