SUMMARY OF EXPERTISE

• Around 9 years of experience in SAP HANA,BI/BODS/ BOBJ BI 4.0 /ABAP/APO Design, Development, Integration and support.
• SAP HANA 1.0 Certified Consultant with experience in working on POC's, leveraging businesses to take competitive advantage with real-time reporting.
• Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
• Worked on multiple complete Full lifecycle implementations and support of SAP Netweaver BW/BI SAP Business Objects BOBJ including requirements gathering analysis, functional technical specifications, technical design and development, testing and UAT phase, cutover and go-live support and post-production support, maintenance.
• Data-Modeling Extensive involvement in Gap Analysis. Design and maintenance of InfoCubes, MultiProviders, APD, Cubes, ODS objects and efficient multi-dimensional data modeling techniques.
• Extraction Expertise in Data Extraction from SAP ECC, CRM, and flat files for Master and Transactional Data.
• Customizations Experience in activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data source Enhancements, User Exit Variables.
• Reporting Expertise in Design and Development of BEx Queries, Reports, Workbooks, Web Reports using BEx Analyzer, BEx Query Designer, WAD.
• Worked on multiple complex SAP Business Objects Web Intelligence Reports based out of SAP BW/BI.
• Performance Tuning Analyzed performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, and Data Compression.
• Production Support - Extensively worked on creation, scheduling and monitoring of Process Chains by variants and process types. Worked on Production tickets, data loads issues and Maintenance of Process chains and involved in break fixes.
• SAP HANA Enterprise Experience:
• SAP HANA 1.x Certified Professional with experience in working on one POC with real-time reporting.
• Hands on SAP HANA Data Provisioning using SAP LT Replication Server SLT and Data Extraction Transfer Loading ETL using SAP BOBJ Data Services 4.0 BODS .
• Developed SAP HANA Administration including managing schemas, data model objects, import/export content.
• Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, etc.
• Data model analysis on SAP ERP application tables using SD11 transaction code.
• Imported Meta data in the ETL process using the Import Selective Meta data for SAP BODS 4.0 prior to on boarding data into SAP HANA, created schemas and data provisioned using SAP LT Replication Server SLT .
• Created master data objects as Attribute views, joined multiple master tables when necessary, selected key figures and attributes to give context to the master data.
• Created Analytical Views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views , selected attributes and measures.
• Created Calculation Views using database tables, attribute views, and analytic views, Created SQL Script based calculation views to address complex business requirements.
• Created calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE studio.
• Used Information design tool to create connections to SAP HANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.

PROFILE OF SKILLS AND EXPERIENCE

• SAP HANA 1.x
• SAP BI/BW Skills: SAP BI 7.3,SAP BW 3.5.
• SAP R/3 Enterprise Version ECC 6.0.
• Reporting Tools : SAP BEx, BOBJ XI 4.0/3.1, Business Objects Designer, Web Intelligence, Crystal Reports , Xcelsius, Data Integrator, Query as web services, CMC, Live office, Adhoc Reporting, BEx Analyzer, BEx Query Designer, Web Application Designer, Report Designer.
• APO Version: SCM 5.0
• Languages : ABAP/4, SQL, PL/SQL, C, C .
• Others: Remedy, Ascendant, HP Quality Center Test tool .

PROJECT SUMMARY

Confidential

Sr. SAP BI Consultant

• Designing solution Interface for R1 R2 projects.
• Implemented the Technical design requirements in terms of R2 releases.
• Experience in SAP HANA migration SAP BI 7.4 On HANA Box.
• Experience in design Calculation Views attribute views, and analytic views, SQL Script based calculation views.
• Designed and developed Data Model for SAP BW OTC, PTP, RTR, FI COPA.
• Calculation Views using database tables, attribute views, and analytic views, Created SQL Script based calculation views
• Involved in UAT phase managed Transports.
• Delivering of New CR's and Review.
• Customized Function Module based Data Source Data Source Enhancement.
• Performance Tuning load performance using Aggregates, Partitions, Indices, Packet Size, Data Compression and ABAP code fine tune.
• Process chain maintenance Design. Incident resolution and monitoring.
• Designed Query Bex Analyzer, Server File upload interface.
• BI4.1 Reporting tool used on WEBI,OLAP Analysis, Office Analysis, Dashboard.

Confidential

Sr. SAP BI/BI 4.0 Consultant

• Global Process project is to analyze and document the AS IS process of SAP BI Penguin education and publishing USA sector.
• Designed and developed Data Model for SAP BW Consolidation Reporting Implementation. Created MultiProviders, Cubes, DSOs and Transformations for Various Categories such as ISBN Substitution , Client Reserve, Baker Taylor Data, Ingrams Data etc.
• Created APD's for S909 file output requirement using Direct update DSO.
• Created BEx Queries such as ISBN Substitution , Client Reserve, Baker Taylor Data, Ingrams, BW Forecast, Master Data Query for SAP BW and Oasis Reporting project.
• Performance techniques using Compression, Aggregates, Roll up, Table Partitioning and reporting related issues.
• Experience in creating ETL mappings using Data Integrator to move Data from multiple sources like Oasis application systems into a common target area such as Data Warehouse, Data Marts.
• Design and develop ETL processes between OLTP and OLAP systems using SAP BODS. ETL design and implementation involving the extraction of data from a variety of legacy systems, integration, and cleansing of data before loading into data warehouses.
• Assist and train QA analysts to test ETL Applications. Assisted the business in data reconciliation.
• Created Web Intelligence reports such as Oasis Report's, ISBN substitution report, Penguin Report based on Universes such as Royalty, Master Data, Forecast and Opportunities.
• Design build Dashboards, reports using SAP Business Objects Suite of tools such as Web Intelligence reports and Designer to support business users. Create SAP BEx Reports using SAP Business Explorer, BEx Query Designer BEx Analyzer.

Confidential

SAP BI/BPS/BO Consultant

• Interacted with the Business Users to analyze the business process and Production support during Budgeting Forecasting plan cycle.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW.
• Developed Quarantine and Blocked time Status report for measuring of the average delay to get paid, from the invoicing date with drill down for Plant, Company, Customer and Cal day.
• Created the necessary BW configuration for the BPS implementation. Created planning areas, levels, packages, layouts functions and sequences necessary for forecasting.
• Mechanism for the user to directly load DPL data into BPS cubes using flat files.
• Created customer exits for variables to populate period value combinations for actual and forecast in planning.
• Successfully transported all the new developments and changes to QA and Production and success fully tested them.
• Worked with process-chains to automate the Data Loads, Rollups into Aggregates.

Confidential

SAP BI/CRM/BO Consultant

• Implement SAP BW/BI//Business Intelligence applications using SAP BW 7.3/7.0 SAP Business Objects BOXI 4.0/3.1 with various backend databases such as SAP ECC, SAP CRM and Sybase.
• Designed functional and Technical specifications for Implementation and Development of SAP BI.
• Installed the standard business content Cubes, DSO, Data source, Info source.
• Created data source by using UD connect to Customer legacy form the legacy system.
• Worked on standard Contract Accounting DataSources 0FC PAY, 0FC RET, 0FC DUN XXXX and cubes 0FC C20, 0FC C21, 0FC C10, 0FC C11 .
• Worked on ABAP part of BW such as Data Source enhancements, writing various routines, Function modules.
• Developed Transformations and DTP to extract data from various data sources.
• Created Classes and Objects by retrieving the data from DataSources like BW queries and defining necessary connections.
• Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligent.
• Created WEBI reports and formatted Crystal reports and deployed them through info view with BW universe as source.

Confidential

Sr. SAP BW/APO/BO Consultant

• Worked on various BI 7.0 NW'2004s specific features including Data store Object Standard, Write optimized, Direct update , Remodeling, DTP, Transformations, Infosets, Data Warehouse Workbench, Process chains, Monitors.
• Worked in the areas of MM-Purchasing and extracted data from DataSources like 2LIS 02 ITM, 2LIS 02 SCL.
• Worked extensively on LO Cockpit, application specific and generic extractors.
• Extracted Inventory data using 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM datasources. Initialized delta and Uploaded transaction data from R/3 system to Material stocks and Inventory valuation Infocubes.
• Customization according to requirement of data flow by writing ABAP routines at START, FIELD and END ROUTINE of Transformation.
• Configuration of APO Characteristic Value Combinations, Time Series Objects for Planning.
• Involved in selection of suitable forecasting strategies for business scenarios and their configurations.
• Maintaining prerequisites for Interactive Demand Planning like Storage Bucket profiles, Planning Bucket profiles, Master Planning Object Structure, Planning Area, Panning Books, Data Views in APO.
• Migration of Flow from BW3.5 to BI7.0 version which includes data source migration, transformations in place of update and transfer rules and Query migration, creation of DTP in place of Infopackage to load data to the target.
• Performed Tuning by creating aggregates based on BW statistics
• Configured use of restricted key figures, structures, variables and calculated key figures in queries.

Confidential

Sr. SAP BI Consultant

• Worked as a Senior BI Consultant involving in multiple phases of the Implementation.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and ODS objects for MM, FI-CO, QM, PM modules.
• Successfully implemented 4-4-5 customized FM logic in order to convert legacy Wyeth applications to utilize new fiscal calendar in reporting.
• Extracted MM-Purchasing data at Schedule, Header and Line item level using 2LIS 02 xxx, Data Sources and generated reports on Purchase order deliver quantities.
• Updated technical specifications in GX Parma to generate unique VAL document number for the report.
• Developed front-end queries using Query Designer Web Application Designer and published results on the web. Used Navigational attributes, Filters, Structures, Exceptions and Conditions.
• Designed Data store Object standard, write optimized, Direct update for staging and reporting of sales data.
• Worked with Pfizer specific query collection tools for transporting the query elements along with Transport connection, Transport Organizer SE09 .
• Analyzed Query run times in ST03 and proposed aggregates solution to improve the performance of the query.
• Migration of Flow from BW3.5 to BI7.0 version which includes data source migration , transformations in place of update and transfer rules and Query migration.

Confidential

SAP BW Consultant

• Implemented SAP BW 3.5 for SD, PP, MM modules. Involved in analyzing and designing the data flow from R/3 to BW and responsible for deployment.
• Responsible for design, development and extraction of data from R/3 source system into BW from SD and MM using LO cockpit extraction methods.
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL, and 2LIS 03 S194 and populated into the procurement info cubes 0PUR C07, 0PUR C08, and 0PUR C09 to evaluate service levels.
• Creating setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.
• Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution SD module SalesOrder 2LIS 11 VAHDR/VAITM, Shipping/Delivery 2LIS 12 VCHDR/VCITM, and Billing 2LIS 13 VDHDR/VDITM .
• Created query Open Manufacturing Orders that shows the status of orders that are finally delivered and to analyze target quantities.
• Created reports like confirmed quantity and item purchase orders as requested, complete purchase order quantities delivered and purchase order values.

Confidential

Sr. SAP BW Consultant

• Analyzed business reporting requirements against standard Business Content and installed the necessary objects.
• Created data model with multi-providers to improve query performance.
• Activation Installed Business Content Objects for FI, SD, MM, IM and Enhancement Business content.
• Customized cubes such as Sales Order cube 0SD C03 , Sales Delivery cube 0SD C05 , Used ODS to stage the data before transferring the ODS contents to the InfoCube. Done ODS reporting to give details of delivery items and schedule line items.
• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization, Tracing problem to R/3 and resolution.
• Developed SAP R/3 User Exits in ABAP/4 to enrich enhanced material master, Logistics transactional data along with the 0FI GL 4 data source .
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW.
• Extended the extract structures by adding new fields and populating them with the user/function exits.
• Enhanced the standard extractors, by adding fields and User Exits to handle customer specific business requirements.
• Worked with process-chains to automate the Data Loads, Rollups into Aggregates.
• Worked on Performance Tuning to decrease the load time and Query run time.

Confidential

SAP BW Consultant

• Involved in the design and configuration of custom Cubes and ODS Operational Data Source for Financial business requirement to compare the applied costs Sales order and incurred costs FI-GL, FI-AR to evaluate the price of the material.
• Worked extensively in the Data Modeling of SD, FI and CO InfoCubes.
• Extracted data from SAP R/3 and loaded into SAP BW.
• Actively participated in the Gap Analysis and the design of the BW infrastructure.
• Created InfoAreas, Application Components, InfoObjects and InfoSources to build Master Data Tables, ODS Objects, InfoCubes and Aggregates.
• Loaded Transaction Data and Master Data via Flat files in CSV format.
• Managed and monitored several data loadings. Optimized the load performance by adjusting the packet sizes.
• Involved in scheduled Roll Up of data from aggregates into InfoCubes.
• Compressed the InfoCube data for better performance.
• Thoroughly analyzed Short Dump and Application Log reviews to debug errors.
• Involved in creation of role based security and authorization for certain InfoCubes and InfoObjects.
• Trained users on using BEx reports and explained the functionality of BEx features.
• Created test cases for unit, integration and regression testing of reports and workbooks.