SAP certified BI/BW consultant with 7 years of extensive experience in IT industry playing various key roles in Architecture, Design and Development.

Core Skill Areas:

• Excellent communication skills
• Quick Learner & Adaptable
• Goal Oriented
• Strong Interpersonal skills
• BEx, Crystal Reports 8.5, Webi, Xcelcius
• ABAP/4, C, C++, Java.
• SQL Server 2008, Oracle 10g
• MS Dos, Windows 98/NT/XP
• MS Office suite
• Unix, Linux
• SAP BW 7.0, 3.5, 3.1c
• ECC 6.0, SAP R/3 4.7/4.6b/4.6C

• 7+ years of experience in SAP with 6 plus years of experience in BI/BW in versions 7.0x, 3.5, 3.1c, 1 Year of experience as ABAP developer.
• Involved in multiple full cycle SAP BI implementations from requirement gathering, design and development, testing, go-live and post production support phases.
• Modeling –Extensive experience in data modeling using BW extended star schema and entity relationship model. Involved actively in enterprise data warehousing (EDW) strategies
• Customizations – Extensively worked on activating standard Business Content, extending the delivered structures and enhancing data sources according the business requirement.
• BEx Reporting - Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Implemented Virtual Key Figures and characteristics, Customer Exit Variables, Formula Builder and Bex broadcaster.

• APD – Created analysis process and used ABAP routine as a transformation for the analysis process design.

• BO Reporting – Involved in OLAP universe designing, well versed with Business Objects XI 3.1, Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Xcelsius.
• ABAP (Related to BW) – Expertise in ABAP programming for writing the User exits using CMOD and in writing the start routine, end routine, expert routine and info object routines.
• Excellent communication skills, leadership qualities, systematic approach and ability to work effectively in fast paced environments.

Professional Experience

Confidential, MN (Aug 2010 - Feb 2012)
Sap BW/BI consultant

Description:
Project involved the cross functional implementation of BW, SD and FI/CO modules for analyzing overdue for AR items, payment history of various customers, account balances, financial statements for different time frames.

Responsibilities

• As a Senior BI consultant involved in full life cycle including requirement gathering, GAP analysis and project scope planning.
• Accountable for BI reporting for Sales, Billing and Finance modules.
• Worked extensively with Sales Order, Billing, Delivery/schedule line and Document condition objects. Enhanced the data sources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_13_VDITM, 2LIS_13_VDHDR..
• Extracted data from non-SAP source system using DB connect and flat files interface.
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc.

• Created Transformation mappings, DTPs, Info packages for all above DSOs.

• Involved in Performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and cube Compression.
• Handled Various Post Production Support Issues related to Short Dumps, Data Loading, Monitoring, Database Space.

Reporting

• Created custom queries to compare and show sales according to region and cost center for the company products.
• Created reports to evaluate open items by due date for accounts receivable through BEx analyzer.
• Developed reports using query designer, BEx analyzer, Webi and xcelcius.
• Created customer exit/authorization variable, Restricted variable with Bex offset.
• Worked with Web Application Designer to create templates for presenting the sales and shipment history.
• Created and maintained universes on OLAP (Online Transaction Analytical Processing) databases. Created Universe pre-defined filters, Dimension Objects and Calculated measures in OLAP universe.
• Worked on deployment of Webi reports and Xcelcius dashboards
• Extensively created and used alerter, rankings, sorts, and drill-down in reports.
• Exported the universes to the Repository to making resources available to the users.

Environment: SAP Net Weaver 2004(BI 7.0), SAP R/3 ECC 6.0, BEx Analyzer, WAD,
Business Objects 3.1(SP 3), Webi, Crystal Reports XI.

Confidential, FL (Jan 2008 - Jul 2010)
SAP BW Consultant

Description:
The project involved the implementation of SD, MM modules for analyzing the product sales, improving the distribution by fulfilling the order requirements, comparing the value of incoming orders with the value of open orders, estimating the frequency of ordering materials, delivery delays and average delivery time taken by various vendors.

Responsibilities:

• As a Senior BW consultant Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, unit testing(UAT) to Go live production support.
• Implemented SAP BI 7.0 for SD, PP, MM modules.
• Involved in analyzing and designing the data flow from ECC to BI and responsible for deployment.
• Responsible for design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO cockpit extraction methods.
• Extracted data from Production (PP) and Process Orders (PP-PI) to analyze manufacturing orders.
• Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_02_HDR and populated into the procurement infocubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.
• Created setup tables for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.

• Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution (SD) modules (SalesOrder "2LIS_11_VAHDR/VAITM", Shipping/Delivery "2LIS_12_VCHDR/VCITM") and (Billing "2LIS_13_VDHDR/VDITM”).

• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded these files toBPCfor the purpose of Planning, Budgeting, Forecasting and Consolidation.
• Created reports like confirmed quantity, item purchase orders as requested, complete purchase order quantities delivered and purchase order values.

• Published the reports on the web using Web Application Designer using the wizard as well as drag and drop web items like ad-hoc, table and filterfor creating customized web templatesaccording to the user requirements.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom BOBJ reports.
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created Dash - boards in Xcelsius reports on purchasing data and periodic plant stock.
• Published Dashboardson toBusiness Objects Infoviewand provided access to the end users.

Environment: SAP BI 7.0, BW 3.5, SAP R/3 4.7, ECC 6.0, SD, MM, FI/CO, SAP BEx Analyzer.

Confidential, MA (Nov 2005 - Dec 2007)

SAP BW Developer

Description:
The project involved the implementation of SD, HR modules. The purpose of the project was for analyzing the sales process, incoming orders, compare the wage types of different areas, overview of illness hours and costs related to it.

Responsibilities

• Involved in full life cycle of the project in Technical design. Carried out the requirement analysis with users.
• Carried out end to end testing of interfaces required by the project.
• Developed and maintained the objects necessary for loading Master and Transactional data staging to PSA, DSO and Info Cubes.
• Defined and maintained transformations created DTP’s and Infopackage for scheduling the loads to data targets.
• Extracted data from SAP (FI & PCA extractions) and legacy systems (using DB connect). Involved in Generic Extraction of PCA data.
• Created Start routines and End routine in transformations to update characteristics and key figures in the InfoCubes.
• Performed Remodeling on existing cubes to accommodate new key figures and characteristics.
• Responsible for loading Master data (Texts, Attributes and Hierarchies) and Transaction data from R/3 Data Sources, Non – SAP systems and from Flat Files.
• Developed Process chains for Master and Transactional Data. Developed ABAP custom routine which facilitates the selective deletion of the requests in the info cube.
• Worked on the transformation processes between BW 3.5 and Net Weaver 2004S (BI 7.0).

Reporting

• Designed and developed Reports on multi providers (Chain and DMA) on Plan, target, Plan Vs Target Analysis web reports which are used by end users for actual reporting.
• Developed reconciliation reports which support system testing for comparing the MAPS source system to the Target info cubes.
• Developed Standard Web Templates for all the reports to be published in portals. Customized the Ad-Hoc Standard web templates for the purpose of adding some extra functionality like Printing, Variables, and Export to Excel.
• Developed reports using BEx Analyzer and BEx Query Designer. Vigorously used Aggregates, Restricted Key Figures & Calculated Key Figures for filtering and formula variables as per the requirement of query.
• Involved in documentation and involved in End-User training on Post Go-Live maintenance manuals, Web Application Designer, Portals.

Environment: SAP BW (3.5), SAP Net Weaver 2004s(BI 7.0), SAP R/3 ECC 6.0 , BEx Analyzer, WAD, FI/CO, Enterprise Portals, SAP Solution Manager, SQL Server, Unix, Windows, Oracle

Confidential, CA(Dec 2004-Nov 2005)
ABAP/4 developer

Description:
Project involves Development of Programs with help of BDC’s, Function Modules, Authorization Objects and also Module Pool Programming and displaying the results in the ALV Format output. The tool gets all the obsolete functions, database tables, security objects, and has the ability to navigate to the exact code line to fix the error.

Responsibilities

• Understood the Client requirement, prepared the technical specification of the report requirements.
• Created interactive reports in SD module extracting information on sales organization levels, delivery and invoice status, shipping details and partner function details.
• Created an Interactive Report to compare prices of products from various vendors.
• Worked extensively to debug the existing SAP program and modify the code using modification assistant to customize the program as per requirements.
• Developed routines to implement complex pricing requirements not handled by standard SAP.
• BDC upload programs for Purchasing Info Records, Vendor Master and Bill of Material Data.
• Create report to display the material master sales view and purchase views to cross verify with the legacy data to ensure data consistency.
• Involved in analysis, specifications, development and testing for the sales data conversion from legacy system to SAP database system using BDC sessions method.
• Generic Program to load data from Excel spreadsheet to custom tables.

Environment: SAP R/3, SD, MM, modules, ABAP Workbench

Academic Background & Credentials

Master of Science in Electrical and Computer Engineering,Ohio

Bachelor of Technology in Electronics & Communications Engineering