SUMMARY:

• Highly accomplished and goal oriented SAP HANA Modeler with 17 plus years expertise in SAP BW World in Design/Development and Consulting in IT industry specializing in SAP HANA SP09, SAP Net Weaver Business Intelligence 7.5/7.1 Business Warehouse 3.5, SAP Business Objects 4.0, SAP Business Objects Data Services 4.0 and ABAP. Have a very strong background in business and technology with in - depth knowledge of Data Warehousing, Business Intelligence and Analytics. Technical expertise with SAP HANA, BW and BI (Business Objects)
• Multiple full life cycle projects with extensive knowledge in different SAP functional areas of Sales & Distribution (SD) and Materials Management (MM), QM Quality Management and Finance and Controlling (FI/CO) and integrating BW with APO, CRM, and ECC.
• Worked as a Team Lead/Architect, involved in planning, responsible for creating and managing project plans
• Expert in transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi- dimensional design/planning model after assessing against the usage of standard SAP delivered Business Content.
• Delivered executive presentations, technical discussions with strategic direction to solve customer's business analytics requirements while designing Executive Dashboard with XCelsius 2008 in BO 4.0 with Live Office Connections.
• Delivered Complex Client Specific requirements thru Design Studio
• Proficient with planning, Gap analysis, design implementation, trouble shooting, performance tuning, production support and user training of SAP Business Information Warehouse. Involved in building reports using SAP BO 4.0 and integrating BO with BI and HANA.
• Experienced in building hybrid reporting solutions on BW on HANA
• Recognized BI expert for mentoring client teams in delivering complex BI Projects at Fortune Five Companies and also as a leader responsible for managing global projects.
• Resource Management/Planning, Scoping, Estimations of project deliverables, Delegation, Project Deliverables Tracking, Risk Assessment, Project Planning.
• Experience in Extraction and ETL data flow developments to ensure successful data acquisition from SAP ECC, Non-SAP sources into HANA through SLT, SDA, SDI and BO Data Services along with monitoring and debugging of data loads.
• Expertise in SAP HANA data modeling using Attribute View, Analytic View and Calculation View. Good Knowledge in Direct Extractor Connections.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based).
• Knowledge in HANA advanced features like Dynamic Tearing, Smart Data Integration, establish business rules with Decision tables.
• Expertise in User Management and security in HANA by applying analytical privileges for row level security and column level security.
• Knowledge on data Integration from Hadoop and HANA.
• Expertise on HANA Data provisioning processes including SAP LT, Data Services and DXC.
• Implemented SAP HANA scale-out as an approach for optimization and for Load Balancing
• Expertise in Modeling Planning Applications in Integrated Planning (IP).
• Worked on BO XI components like CMC (Central management Console), CCS (Central Configuration Server), Publishing Wizard, Business view manager, Repository migration wizard and Import Wizard.
• Expertise in BO4.0 WEBIs, Live Office, Life Cycle Manager, BI Launch pad, IDT, XCelsius, Analysis Office and Dashboard designer tools.
• Strong OO ABAP skills (SAP R/3 enhancements, Function modules, BAPI, Implementation of Interfaces, Start Routines, End Routines, Expert Routines)

TECHNICAL SKILLS:

SAP BW/BI (2.X/3.X/7.0/7.3/7.5): Data Modeling, Complex Transformations, Rule Groups, Complex ABAP Routines, Remodeling of Info Providers, Custom Extractors, Custom APDs, Process Chains, Creating Open Hub Destinations, ETL using Informatica, Complex ABAP Utility Programs, Performance TuningQuery variables using CMOD/BADI and Virtual Char/KF variables, BEx Designer, WAD

SAP Business Objects (3.X/4.0/4.2): ETL using Data Services, Tools like Web Intelligence

SAP R/3 (4.7, ECC 5.0, 6.0): ABAP/4 includes List Reports, Interactive Reports, Complex ALV, SmartForms, BADI, BDC, User Exits, OOPs ABAP, ABAP Dictionary, SAP Query and other tools like Debugger

Operating System/Programming Concepts: Linux, UNIX, COBOL, C

Object Oriented Programming: C++

RDBMS: Oracle

Web-Based Technology: Java

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior BW/HANA Consultant

Environment: SAP BI 7.5(HANA), SAP ECC 6.0, BODS 4.2, IP, Tableau Design Studio 1.5

• Implemented Plant Maintenance Dash Boards global scope in Finance and Procurement reporting bring non-SAP using HANA Views
• Developed HANA Model for OPEX Reporting for North America
• Implemented performance tuning measures to ensure efficient dashboard Reporting
• Converted Upstream BW Models into HANA Models
• Performance tuning of existing HANA models using best practices
• Facilitated HANA training to end users to upskill on SAP HANA
• Performance tuning of Data Services Jobs which are running longer
• Data provisioning using BODS, developed ABAP data flows to perform huge data volume loads From ECC to HANA, created complex transformation as per Client requirements

Confidential, Houston, TX

Senior BW/HANA Consultant

Environment: SAP BI 7.5(HANA), SAP ECC 6.0, BODS 4.2, BPC10.0, Design Studio 1.5

• Implemented Asia CTD standardization solution to sites in China, Thailand and Dalian to provide full scope in Finance and Procurement reporting bring non-SAP using HANA Views
• Implemented and enhanced Finance Close Cockpit reports for real time monitoring Close Schedule, Analysis of Close Schedule and Close Performance using HANA Views
• Built a HANA Model to develop Bridge Report by integrating FCR and CIW functionality to provide analytics on Fixed Cost allocations in CIW to different businesses
• Finance Reporting Package (Management Reporting) - Implemented around 1200 Complex Key Metrics, delivered in 6 Packages with trend data ranging up to 5 years, which includes Important metrics Sales Volumes, Production Volumes, Inventories, Revenue, EBITDA, Capex, Variable Margin, Raw Material Margin, Prices and many others
• Supported creation and maintenance of Source and Target KPI dimensions in BPC
• Built Design Studio report on HANA Models for complex Finance Metrics (Trend Report)
• Involved in HFM System Upgrade project, enhanced all required HFM scripts
• FSCM module successful implementation delivered key information reports on Credit Checking, Collections and Disputes
• Solution for Reconciliation of Assurenet Balance Sheet Account to HFM Balance Sheet and migration to HANA models was successfully deployed
• Creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to dimentional attribute views
• Leverage SLT and BO Data Services to acquire data into BW on HANA
• Created Calculation views using SQL Scripts to meet complex business requirements
• Developed Tableau Dashboards for Plant Maintenance Metrics and Finance Close Cockpit (FCC)

Confidential, Palo Alto, CA

Senior BW/HANA Architect

Environment: SAP BI 7.0, HANA 1.0 SP5, ECC 6.0, BODS 4.0

• Extensively involved in a very complex end to end migration of existing BW 7.0 on Oracle to BW on HANA
• Experience in creating HANA information models using attribute view, analytic view and calculation views
• Worked on building new BW objects that are optimized for HANA
• Optimization of transformations for HANA
• Extend the HANA Live content by modifying the Calculation views and adding new fields
• Developed HANA Naming standards
• Designed and created Performance dashboards to measure, monitor and manage various business activities for different business units
• Developed XCelsius Dashboard for CIO
• Lead BI Systems Upgrades (End-to-End) to EHP1/ EHP2, upgrade ABAP Stack and JAVA stack
• Served as subject matter expert ()
• Lead Implementation HR Dashboard Reporting (End-to-End, dealing stakeholders for gathering requirements to delivering solution successfully)
• Developed Web Planning Layouts in BI-IP using Input Ready Query
• Conducted Training sessions and Provided Interactive Training Materials for End users
• Implemented BI Reporting Security for HR, Finance and Logistics using Analysis authorizations
• Designed and Implemented BI Standards and Processes for optimal utilization of systems
• Done Performance tuning for BI Reporting and BI Back End for efficient data loads
• Informatica workflows have been developed to load data from CDB to BW

Confidential, San Francisco, CA

Senior BI Architect

Environment: SAP BW 3.5, BI 7.0, SAP ECC, BO XI3

• Front-end and backend design and implementation, data modeling, non-SAP data integration
• Dashboard reporting for Finance Working Capital details
• Developed a detailed design for the development team which includes type of objects to be developed in each layer
• Created project timelines cut-over plan and execution plan
• Developed utilities to gauge and improve performance
• Creation and monitoring BIA indices to improve performance and maintaining BIA Indices using process chains
• Created jump Queries from Analytical reports to the Info-set queries created on top of the detailed operational data store objects and master data objects
• Developed staging Transactional ODS and Integrated cross functional operational data store (ODS) Objects
• New Data Transfer Process (DTP) functionality is used with Transformations routines for loading data into data targets
• Developed Virtual Char and Key Figures using BADI functionality, thus avoided limitations with the user-exit method
• Worked on Integration of Business Objects with SAP BW
• Created Universes(BO) based on various data sources (Infocubes/Multi Cubes/BW Queries) and defining the connections necessary
• Developing complex universes(BO) by using advanced features in Business Objects
• Exported the Universes to the Repository to make resources available to the users
• Designed and developed reports from SAP BW universes, personal data files and free hand SQL
• Created Linked Universe in Business Objects using Universal Join
• Created Custom Hierarchies for BO reporting

Confidential, Los Angeles, CA

Senior BI Architect

Environment: NW2004S, SAP ECC

• Developed a complex cross lookup logic to integrate various functional data into one source
• Worked on various Performance improvement initiatives to improve the load times and appropriately handling large volumes of data by portioning and using parallelism
• Resolved Complex Hierarchy Issues of Work Center Hierarchy which has more than 2 million+ nodes
• Developed utilities to gauge and improve performance
• Created complex transformations and start and end routines
• Enabled delta loads to multiple data targets (logically partitioned data providers)
• Significant improvement of Query and Load Performance
• Configuration of BI Accelerator and maintenance of BIA indices

Confidential, Beaverton, OR

Senior BW Consultant / BI Architect

Environment: NW2004S, SAP BW 3.1C, 3.5, SAP4.6C

• Designing, development and deployment of Logistics and Finance ODS/InfoProviders for reporting Purpose
• Designing and development of data extraction procedures of InfoSpokes
• Enhanced standard LIS extract structures and Master Data objects and extractors and Created generic delta extractors
• Designed custom Roles/Profiles to provide required access to Users/Developers
• Data has been loaded from Oracle to BW using DBConnect
• Done extensive performance tuning batch loads, Query designing and Systems have been tuned to perform at optimum level
• Designed and scheduled process chains to run batch loads efficiently based on system resources by using load balancing round robin method
• Created custom processes to use in process chains
• Informatica workflows have been developed to load data from CDB to BW
• DTPs have been created to perform loading in NW2004s environment
• Resolved NW2004S security issues

Confidential, Federal Way, WA

Senior BW Consultant

Environment: SAP BW 3.1C, SAP 4.6C

• Extensively worked on Administrative Workbench for Configuring, Customizing, Monitoring and Scheduling
• Defined, Analyzed InfoCubes and maintained InfoObjects in SAP BW
• Worked on Front End, Defined Query in the BEx Analyzer, presenting the result in Workbook and integrating the Workbook with BEx Browser from InfoCubes and ODS
• Created different types of variables and enhanced existing variables thru customer exits
• Evaluated Business Content for Sales, Billing, Marketing, and Finance and activated the relevant Business Content Objects

Confidential, Los Angeles, CA

SAP BW Consultant

Environment: SAP BW 2.1C/3.0B, SAP 4.6C

• Created Aggregates and Multi Cubes for performance and efficient utilization of data
• Performed Delta Upload Management with OLTP extraction
• Extracted data from R/3, Non-R/3 (SQL Server) and flat files
• Set the extraction process using LIS, LO execution cockpit and V-3 updates
• Monitored the LO Extraction Cockpit and the Delta Queue Maintenance
• Performed detailed analysis to improve the performance using InfoCube Compressions and Aggregates.
• Incorporated transfer rules for InfoCubes and customized update rules using ABAP/4.

Confidential, Sunnyvale, CA

SAP BW Consultant

Environment: SAP BW 3.0B SAP 4.6C FI, MM, SD

• Evaluated BW 3.0B features and functionality
• Created custom InfoCubes in Sales, Purchasing, Procurement as per client specifications
• Enhanced LIS Extract Structures
• Created and developed Master Data Objects

Confidential, Eden Prairie, MN

SAP BW Consultant

Environment: SAP 4.6C, SAP BW 2.0B, 3.0B FI, CO, SD, MM

• Involved in mapping the SAP R/3 data starting extraction from data source till Uploading the Master/Transaction data
• Extensively worked on Administrative Workbench for Configuring, Customizing, Monitoring and Scheduling Functions
• Evaluated Business Content for Finance, COPA and activated the relevant Business Content Objects
• Performed GAP and cost analysis for upgrade
• Extensively worked Back End, Data Extraction, Data Loading and Data Staging
• Worked on Batch Job Scheduling and LO data extractors in BW Worked on Standard InfoCubes, ODS for Financials in FI Accounting (GL, AP, AR)

Confidential, Atlanta, GA

Senior ABAP Consultant

Environment: SAP 4.6C FI, CO, MM, SD

• Wrote BDC programs to create and change customer master data by session method for transactions VD01 and VD02 to update KNA1 table
• Data Migration - Asset Accounting - Assets and testing of data
• Processed lockbox data to collect customer payments
• Written data extract programs to send data to Business Warehouse from PO, Invoice and Sales Order
• Created a report to show status of documents in Sales Order flow
• Wrote BDC program to transfer G/L Account data into R/3 system using the FS01 transaction to update tables SKA1, SKAT and SKB1 in SAP GL for FI Module
• Developed a data interface program to create work centers using transaction CR01

Confidential, Milwaukee, WI

Senior ABAP Consultant

Environment: SAP 4.6C, SAP 4.5B, FI, MM, WM, OS/390

• Technical Design and Coding and modification of different Reports, Data Interfaces programs, Layout sets related to Alternating Premise Project
• Modified Data Interface which creates Sales Orders, to create Alternating Premise Sales Orders according to client requirements
• Modifications of print program (RVADIN01) and layout set (RVINVOICE01) of invoice
• Written a program to generate electronic bank confirmation
• Created a consolidation report to customer’s overdue balances by SBU customer

Confidential

Senior ABAP consultant

Environment: SAP 4.5B, SAP 4.0B, SAP 3.1H, SD, PP, HR, FI, CO, MM, AS/400

• Reports, Interfaces, SAP Scripts. ABAP Query, Report Painter development
• Involved as a Team Lead of development team from start till the staging phase of the project, responsible for developing standards for development, Functional specifications, Technical Design and Coding for different programs related to FI, CO, HR, PP, MM and SD modules
• Involved in Data Extraction and Data Cleansing and Modifying and creating programs for Reports, Interfaces, BDC’s and dialogue programming