SUMMARY

• Over 8 years of experience in SAP Data Warehousing (BW/BI/BODS) and Planning tools (BPC, S&OP/IBP) involving in full life cycle implementations and upgrades.
• Expertise in BPC, admin configuration, Models, Dimensions, Script Logic, Business Rules, worksheet Logic, Data Manager Packages, Transformation, Conversion files, Scheduling, data loads using BW, flat files, Package Links, EVDRE, EPM Reports, Input Forms, Business Process Flows, Audit, Work status, drill through, Comments setup and Validation rules.
• End to End on - premise implementation of SAP S&OP (IBP) involving in creation of Dimensions for master data, virtual Master data, Planning Areas, Planning Levels and Key figures.
• Complete understanding of End to End architecture of IBP like time profiles, time series table, planning object table, combinations and staging tables.
• Experience in w designing BADI’s, run logics and MDX formulas as per the business requirements.
• Experience in Planning functionalities such as Sales Planning, Revenue Planning, Product, Volumes Planning, COGS Planning, Income sheet planning, Bills of Materials Planning
• Experience Consolidation functionalities such as Account transformations, Currency translation, Balance carry forward, Inter-company matching/Eliminations, Journals postings, Ownership data/hierarchy and Consolidation of Investments
• Extensive knowledge of Standard and Custom Info Cubes, Info Object and Info Sources, Web reporting, Extraction, Transfer Structures, Multi-Providers, Process Chains, Operational Data Store (ODS/DSO’s) and Business Explorer (BEx), Openhubs and APD’s
• Experience in activating standard Business Content, used ABAP coding for extending and enhancing using User Exits, transfer/update rules, Start routine, End routine, Expert Routines and Customer Exit enhancements.
• Expertise in using MultiProviders, Remote Cubes, Dash board reporting, structures, variables, exceptions, and conditions, restricted and calculated Keyfigures in reporting.
• Strong skills in data modelling in BW/DP, CVC, MPOS, Aggregates, Planning Area, Planning Books, Data views, Macros, data staging for APO DP, Forecast Models, Statistical Forecast Generation.
• Understanding of GATP Rule based ATP check scenarios and GATP settings in R3 and APO.
• Knowledge of CIF Integration Models for Master, Transaction Data between R/3 and APO.
• Strong understanding of OTC process in setting up new plants on OTC after a merger and acquisitions.
• HANA Data modeling using Attribute View, Analytic View and Calculation View, Schema Creation, Table definitions, applying privileges.
• Very good team player with excellent communication skills, critical thinking and problem solving skills

TECHNICAL SKILLS

SAP BI: BW 7.4, 7.0 (2004s), 3.5, 3.1/3.0B

SAP Planning Tools: BPC Net weaver (7.0 and 7.5, 10), IBP 5.0

SAP R/3: ECC5.0/6.0, 4.7/4.6C

Business Objects: XI 3.1, BI 4.0

ETL Tools: Data stage, Informatica, SSIS, BODS, HCI

Languages: ABAP/4, C, SQL, Java, C, C++, PL/SQL

Operating Systems: UNIX, Linux, MS Windows

Database: HANA, Oracle 11/10/9i/8i/8.0/7.x, SQL Server, MS Access

Web Technology: ASP, XML, JavaScript, JSP, HTML, Dream Weaver

Reporting /Design tools: BEx, WAD, WebI, Xcelsius and Crystal Reports

Scheduling Tool: Maestro, Redwood, Control M

Ticket Tracking Tool: Remedy, SAP Solution Manager

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SAPBI/BPC Lead

Responsibilities:

• Configured Master data objects and Virtual master data objects and interfaces to populate the corresponding data.
• Created attributes like UOM which can be enabled as Key figures.
• Created Planning areas, planning levels and key figures for the different levels of forecasting and reporting.
• Created stored key figures and calculated key figures based on the business requirements.
• Created templates for reports and inputs using EPM functions based on the Business requirements,
• Worked on exporting data from IBP to tables of Flat files using SAP’s RESTful web service API and HCI
• Created users, roles and configured Security.
• Performance tuning of reports, loads by analyzing the design of key figures and HANA performance traces.
• Involved in Functional, Regression, UAT and load testing.
• Designed and developed a process for Trans and Warehouse to calculate costs
• Enhanced the COPA data source by adding new values fields and implemented those changes in corresponding info providers, reports and in BPC.
• Added new attributes to existing dimensions and BPC and designed interfaces to populate corresponding attributes.
• Developed Script logics to implement the changes
• Optimized existing to BADIS to for better performance and modified them to include the new changes.
• Migration of data flows from BW 3.5 to BW 7.3 which is prerequisite for HANA.
• Experience in Running sizing reports prior to the implementation to get the memory foot print.
• Worked with SAP to Clone the extractors and implement up and running ETL in two BW boxes simultaneously.
• Troubleshoot and identified the issues after the migration and worked with SAP to resolve them
• Worked on creating new application in BPC serving the transport and warehouse business which involved in creating new application, dimensions, script logics and interfaces.
• Extensively developed script logics for calculation of incurred dollars, shipped, billed dollars, Trans incurred and breaking out total dollar for the Trans and warehouse.
• Created Wrapper scripts and process chains to automate the packages for the business processes.
• Developed HANA attribute views, calculated expressions for sales KPI for day sales, month to date ISO, Year to date and previous year date sales.
• Imported data from DSo’s and cubes in to native HANA and integrated them with non-SAP data by creating HANA tables and built views on them.
• Used Hana Analysis Process to recreate existing APD’s to improve Performance.
• Involved in migration of Data Services from 4.0 to 4.2 and developed different data services jobs to extract data from different SAP and non-SAP applications.
• Extracting Data from SAP application/ SAP BW systems using ABAP data flows, cleanse Data and stage them to Data marts.
• Extensively migrated data from different source system such as flat files to ODS, Data marts and Data warehouse.
• Used various transformations like Table Comparison, Hierarchy flattening, Query, History Preserve, Key Generation, Pivot and Reverse Pivot.
• Worked with different Data Quality Transform such as Global Address Cleanse, Data Cleanse and Match Transform.
• Working with Data Service Management Console to deploy and schedule batch jobs as Database Administrator.
• Worked on new features such Advanced DSO, Composite Providers, Hana Analysis Process, created analytics views, attribute views and calculated views.
• Provided 24X7 production support, supporting BW and BPC applications

Environmnet: SAP BW 7.3/74,SAP BO XI4.0/ 3.1, SAP BPC 7.5/10 NW, SAP BODS 4/4.2, CRM, APO, Oracle 11, SQL Server 2010, HANA 1.00.85.01 SP8, SAP IBP 5.0,HCI

Confidential, Commack, NY

SAP BW Consultant

Responsibilities:

• Worked on creation of Appset, Applications, Dimensions and its properties
• Worked closely with business in preparation of Master data settings like member properties requirements and its configuration during retraction/extraction.
• Develop the Logic Script for different planning scenarios to meet business requirements including inter/intra application logics
• Modified the Input Schedules to perform better by removing all the Excel Calculations and moving them to Script Logics/BADIs.
• Also Responsible for BI side of the enhancements especially in the interfaces and data movement between BI and BPC for both master data and Transactional Data.
• Activated standard content Info cubes, data sources, master data objects in Marketing and Campaign analysis, Lead analysis and Opportunity analysis.
• Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting
• Performed ETL techniques to Load Data from R3 to BW and further to APO Demand Planning Areas.
• Created open hub to distribute data from BW system to external data marts.
• Worked on gathering functional specifications and technical specifications documents for BOBJ reporting
• Designed Universes, Web-I Reports.
• Performed troubleshooting of universe and implemented security.
• Extracting Data from SAP application/ SAP BW systems using ABAP data flows, cleanse Data and stage them to Data marts.
• Extracting Data from Different Sources like access excel and flat files and loading them into requested target flat files, excel sheets, Oracle Tables in Data Warehouse.
• Involved in using SQL *loader to load the data from excel sheet or flat file in to oracle tables without using ETL tool.
• Extensively migrated data from different source system such as flat files to ODS, Data marts and Data warehouse.
• Used various transformations like Table Comparison, Hierarchy flattening, Query, History Preserve, Key Generation, Pivot and Reverse Pivot.
• Coordinated with off-shore team and provided 24X7 Production support, involving process chain maintenance, monitoring data loads and PSA maintenance.

Environmnet: SAP BI 7.0.3,SAP BO 3.1, SAP BPC 7.5, CRM, APO, Business Objects Data Services XI 3.1Oracle 11, SQL Server 2010, Qlik View 10

Confidential, KC, OK

SAP BI Consultant

Responsibilities:

• Worked on BI/BW 7.0 data modeling and Extraction along with BIBO Integration.
• Discussion with functional team to discuss end user requirement. Developed Technical design specs.
• Installed Business Content for, CRM, HR, Sales and Financial Info Cubes to meet with user requirements.
• Created Data sources, Export Data Sources and Back up cubes for loading data in to BW from APO DP and created to logic to store the locked forecast.
• Designed ETL Process to load the data seamlessly between ECC, APO and BW.
• Extensively worked on customizing CRM data Sources.
• Dealt with Time dependent/independent data in HR Cubes.
• Worked on FI-COPA Cubes to store the information for the next level usage.
• Extensively worked on several kinds of COPA structures: Net sales, Contribution Margin, Operating profit.
• Designed Transformations and DTPs as per the requirement. Developed ABAP routines and User -exits for this purpose.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Extensively worked on Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Worked on COPA queries & COPA workbooks: Contribution margin, Customer sales trend.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as I Views.
• Worked with BEx Broadcaster to schedule monthly sales reports as e-mail to the users.
• Created aggregates to do performance tuning so that it improves the query performance.
• Worked extensively on testing, end user documentation and power user training.

Environment: SAP BI 7.0. SAP B.O. 3.1, SD, APO, CRM 7, HR, Oracle10

Confidential, Toledo, OH

Sr.SAP BI Consultant

Responsibilities:

• Actively Involved in Modelling/Designing, Developing and implementing data warehouse using SAP BI with SAP ECC and integrating other heterogeneous systems in the Landscape.
• Coordinating with clients to mine corporate data to identify, analyze and integrate data from multiple sources and turning data into useful information using BW.
• Expertise of various data design models - Entity Relationship (ER), Multi Dimensional/Star Schema and Extended Star Schema models.
• Worked in building InfoObjects, InfoSources, DataSources, Transformations, DSO/ODS, InfoCubes, Multiproviders, Infospokes and process chains.
• Created the data flows for year end activity objects
• Worked on secondary Index creation on ECC tables for FI extractors to improve the load performance.
• Good experience in creating generic Delta for tables which do not have standard extractors.
• Extensively coded routines: Start routines, End routines, Transformation routines, Expert routines.
• Experience in activating standard Business Content, extending and enhancing using User Exits according to the end-user requirements.
• Involved in the upgrade project from 3.5 to 7.0 - prepared the project plan with basis team, analyzed the system and all objects.
• After the basis work done, test all data providers, data flows, converted reports.
• Generating BW queries in SAP Enterprise Portal using Visual Composer, WAD, customizing the queries and making them role specific.

Environment: SAP Bi 7.0/BW 3.5. SAP PS, SD, MM, HR, Oracle 10g/9i