Professional Summary

• Five (5+) years of expertise in SAP with over 4 years in SAP BW (2 year in BI 7.0).
• Two (2) complete life-cycle implementation in SAP BW in all phases like Gap Analysis, Blue-printing, design specification, development, performance tuning, testing, documentation, maintenance, training, Security authorizations and trouble-shooting.
• Excellent working Knowledge in BI 7.0 (Netweaver 2004s).
• BW Upgrade experience of Migrating Frontend solution such as Queries, Workbooks & Web reports, Unit of Measure migration with BI 7.0, successful implementation and Delivery.
• Modeling – Excellent working knowledge of datawarehouse concepts. Extensive experience in BW Architecture, Extended Star-Schema, Multi Dimensional Modeling, Data Flow Strategy, Defining Dimensions, InfoCube, Multi-Provider, InfoSets, DataSource, InfoSource, InfoObjects, PSA, DSO etc.,
• Extractions - Extracted data from LO Logistics Cockpit, CO-PA and Generic DataSources from Views Function Modules, DB Connect and Flat Files.
• Customizations - Experience in activating standard Business Content, extending and enhancing InfoCubes according to the requirements, Datasource Enhancements, User Exit Variables, Virtual KeyFigures, Start Routines and Formula Builder.
• Reporting - Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Visual Composer, Ad-hoc Queries, BEx Analyzer, Web application designer(WAD), Web Items.
• Performance Tuning - Evaluated statistical performance and optimization using Bi Statistics and BI Administration Cockpit. Improved data load and query performance by doing Compression, creating Aggregates, Indexes, Data packet size.
• Production Support - Extensive experience in support, Data loads, Validation and trouble shooting of transaction data and Master data, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and Process chains.
• Training - Extensively involved in End User training as well as Developer Training. Created Technical Documentation, Training Manuals etc.
• Excellent work ethics, Go-getter, Self-starter, Team player, Adaptable, Innovative with strong System Analysis, Design and Development skills, Good presentation and technical writing skills.

DATE:

April 2009- Current

CLIENT:

ConfidentialLyndhurst, NJ

POSITION:

SAP BI Consultant (BW Upgrade Project)

Technical Env.

SAP BI7, SAP BW3.5, ECC 5 Modules: SD, MM, FI, ABAP

RESPONSIBILITIES: BW Migration Project

• Worked on BW Upgrade project and did both Functional and Technical upgrade of BW 3.5 to BI 7 EHP1.
• Performed BW Technical upgrade which includes Validate ABAP Dictionary, Check Infoobjects inconsistency & System Codepage Settings, Check F Partitions, create Primary & Secondary indexes etc.,
• Fix Security issues with interval *, work on ASU system, setup Portal & Java instance, turn off RFC Connections, activate & replicate Source systems, Datasources, Migrate Authorizations. Convert Chart settings, Web objects, activate Hierarchy versions, adjust Customer developments & customizing settings, Run SGEN, activate all views, regenerating RSDRO* objects.
• Fix all Upgrade related issues , apply SAP Notes, Testing .

ANALYSIS : Extensive testing of Frontend tools such as BW Queries, Workbooks, Workbooks with VB Coding, Unit of Measure , RRI, Variables such as Replacement Path User Exit, user entry variable, formulae variable, selection option, Multiple entry variables, CKF, RKF, Exceptions, Structures, Cell definition, Formulas, Conditions etc., Workbooks with Single or multiple embedded queries, drop down box, embedded graphs etc.,
STRATEGIES : Discussed Strategies of rolling out Netweaver 2004s Tools to update all users desktop, new Authorizations and Security for all Front end tools for End user, super users, power users, Timeline for upgrading all front end tools such as queries, workbooks etc.
USER TRAINING :

• Provided Training for Super Users and Power users about How to Upgrade Queries and Workbooks, new BI 7.0 Tools such as 2004s Query Designer, Bex Analyzer, Web Reports, How To create Queries and Workbooks.
• Provided after-sessions to resolve doubts and Questions from Users with new 2004s front end tools and provided solution whenever possible.

DOCUMENTATION :

• Created lots of How To’s & QRC documents that provides detailed steps with screenshots of How to Migrate a Query, Workbook to BI 7 version, How to reproduce original BW 3.5 query version, How to do Information broadcasting with new 2004s, How to verify the version of Queries 3.5 or 7.0, Unit of Measure upgrade modifying the Numerator to Denominator ratios etc.,
• Also worked on creating, maintaining Infospokes for Digital Data for different systems.
• Maintained process chains and resolved Errors and Dumps.

DATE:

Mar 2008- Feb 2009

CLIENT:

ConfidentialAppleton, WI

POSITION:

SAP BI Consultant

Technical Env.

SAP BI7, SAP R/3 4.7, BW 3.5 Modules: SD, FI, ABAP

RESPONSIBILITIES:
Phase I – Order to Cash Project

• Key role as a Functional analyst for Transportation module as a part of Order to Cash System, which involves preparation of FRICES, strategies of BI Objects developments, integration of Transportation Multiprovider with other modules(full life cycle implementation.)
• Designed the data model to integrate data from two different source systems – SAP and I2. I2 data is loaded via flat files into BI system and is integrated with R/3 data that is loaded through standard and customized SAP Extractors.
• Developed TMS Reports such as Shipment and Volume Reporting, Vendor Mileage Summary, Prerate and Actual Freight Comparison, Non Operational Freight Analysis, Freight Payment Reporting and Customer Mileage Summary.
• TMS Reports were developed for 2 main modules within, Inbound Transportation for Raw Materials from Vendors and Outbound Transportation for Finished products to Customers and other KC Facilities.
• Performed Unit Testing, Integration Testing and Regression Testing.
• Worked on Information Broadcasting to send reports to end users by e-mail.
• Report generation involved Variable, Replacement Path, calculated and restricted key figures, Report-to-Report Interface, Exceptions and Conditions.
• Extensively worked on performance tuning aspects with Aggregates, Partitioning, Compression and BI Statistics.

Phase II BI User Migration/ Upgrade Project :

• Analysis for potential migration of all BW 3.5 Queries & Workbooks to BI 2004s.
• Discussed Strategies of rolling out Netweaver 2004s Tools across multiple landscapes.
• Strategies for different level of security, User Access, different landscapes, Testing phase etc., for Migration Project.
• Deliverables and documentation for BI Reporting Workshops for End Users. Etc.,

DATE:

Sep 2007- Feb 2008

CLIENT:

Confidential Minnetonka, MN

POSITION:

SAP BI Front-End Consultant

Technical Env.

SAP BI7, ECC 6.0 Modules: SD, MM, FI, SCM, ABAP,HR,BPC

RESPONSIBILITIES:

• Created Queries, Workbooks for Super users and Power users for several modules SD, Billing, Finance, Purchasing etc.,
• Reports were Monthly Sales Volume, Trend Report for Billed Quantities at Monthly Level,
• Monthly trend report for Year over Year comparison, Trend Report for Billed Quantities at Weekly level, Weekly Sales volume for Billed Quantities and Net weight, Weekly Trend Report for Year over Year Comparison, Daily sales volume report, Supply Chain Management :Crew Size Report and lot more.
• Working along with lots of RKF, CKF, conditions, exceptions, Cell definitions, Text Variables and utilizing WAD, VB codes to create Web to provide nice features of query execution.
• Installed the Bi Administration Cockpit and Bi statistics and successfully tested around 40 Bi content queries for Bi Statistics, created Custom Queries for Bi statistics for Business purposes as per requirements.
• Successfully Installed , Scheduled and Monitor the 6 Process chains for Bi statistics such as Content Master data, System Master data, Delta Load Statistics Delta & Init, Query runtime Statistics Delta and Init, Researched several OSS notes so as to make sure that the data is updating perfectly in the Statistics Cubes and Multiproviders.

DATE:

Sep 2006 – Aug 2007

CLIENT:

Confidential, IL

POSITION:

SAP BI Techno-Functional Consultant

Technical Env.

SAP BI7, SAP R/3 4.6C Modules: SD, FI, ABAP4

RESPONSIBILITIES:

• Responsible for generating Function specifications & Technical Specifications
• Designed and developed Basic Infocubes, DataStores (DSOs) and Multiproviders
• Customized LO Cockpit extract structures and data sources in SD, FI to facilitate the data extraction to BW and to reporting using classification of various data elements.
• Created Data Transfer Process (DTP) to schedule the update in BI 7.0.
• Implemented BEx reporting and BW Web reporting , End User Training for Power users and Super Users.
• Developed flexible queries using filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Generated reports with replacement path, adjusted exceptions for detailed reporting and designed Exceptions, Variables, Structures, Restricted Key figures, calculated key figures on BEx Queries for Logistics, SD, Procurement and Finance(AR, AP, GL).
• Monitored Delta, Repeat Delta extractions and process chains.
• Responsible for conducting and monitoring test results from unit testing and regression testing and fixing defects.

DATE:

Jan 2006 – Aug 2006

CLIENT:

Confidential

POSITION:

SAP BW Technical Consultant

Technical Env.

SAP BW 3.5, SAP R/3 4.6 Modules: MM, FI, ABAP, BPS,BPC

RESPONSIBILITIES:

• Implemented extraction, transformation and loading of data to Business Warehouse from SAP R/3 after analyzing Technical Specifications Documents.
• Installed, modified & activated Business content & custom MM InfoCubes, ODSs, DataSources, InfoSources.
• Data extraction from flat files and SAP R/3. Used interface DB connect to get data from external sources.
• Handled performance tuning of queries using aggregates, table partitioning, indexing of InfoCubes.
• Used RRI jump queries for drilling down to other queries and R/3 transactions.
• Created Web reports using Web Application Designer WAD, , Publish the reports on portal, utilized Information broadcasting.

DATE:

Nov 2004 – Dec 2005

CLIENT:

Confidential

POSITION:

SAP BW Consultant

Technical Env.

SAP BW 3.5, SAP R/3 4.6C Modules: SD, MM, ABAP, BPC

RESPONSIBILITIES:

• Responsible for identifying business requirements and implementing ASAP methodology, Creating functional specification & Technical specifications.
• Sole BW Implementation for SD Module.
• Responsible for identifying SD, InfoCubes and ODS Objects in Business Content based on business requirements.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
• Created and maintained CO-PA datasources.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements.
• Excellent knowledge of WAD, Visual Composer, Report Designer, Portal Integration.
• Responsible for writing new ABAP/4 routines and also tuning existing start routines and update rules.
• Performance Tuning of Data Loads, Queries, Aggregates building for Query optimization

Education: Bachelor of Engineering in Electronics