SUMMARY

• Dedicated Software Analyst with over 19 years of IT experience, which includes extensive and varied experience in SAP ECC, BI/BW, BOBJ and SCM implementations.
• An expert in data modeling, ETL, data harmonizing, OLAP reporting and data design management of systems and architecture related to ERP environment.
• Worked in 5 full life cycle implementations of SAP BW/BI projects and several data conversion, merger and acquisition projects.
• Strong hands - on experience in BW/BI front-end and back-end development with a deep understanding of the data warehouse tools and techniques.
• Experienced in both application specific extractions like CO-PA and LO Cockpit as well as Generic Extractions (RSO2). Also developed extractions from Non-SAP sources using DBCONNECT, 3rd party and File extractions.
• Sound knowledge in identifying and activating the necessary Business Content. Extensively worked on standard and custom InfoCubes, ODS objects, InfoObjects, InfoSources and Process Chains, BW reporting tools like BOBJ InfoView, BO Design Studio, SAP Lumira, BEX Analyzer, BEX Query designer and Web application designer.
• Possess strong ABAP skills with expertise in creating, enhancing extractors (using CMOD, function modules), start and end routines in BI 7, transfer and update rules in BW 3.x, coding for virtual chars, KFs and also implementing BADI’s in InfoSpokes.
• Conducted several training sessions at client sites on Data Modeling, ETL and Reporting.
• Has a rich SAP R/3 experience in the areas of FI, CO, Enterprise Controlling, SD and MM.
• Familiar with creating, loading data models in HANA and used data services.
• Knowledge of Planning and Lifecycle Management on BW powered by SAP HANA.
• Result oriented individual with excellent communication skills, adept in analyzing complex project situations with Strong organizational, multi-tasking, time-management and conflict management skills.

TECHNICAL SKILLS

• SAP BI 7.0-7.4/BW 3.5/3.1C/3.0B/2.1C, SAP HANA, ECC 6.0, SAP R/3 4.6c/4.6b, ABAP, BO, BEx, BO Design Studio
• SAP Lumira, WEBI, Crystal Reports, SD, PS, MM, IM, PP, FI, CO, ERWin, MS Visio, Oracle 8.i/7.3, Developer 2000
• C, C++, PL/SQL, JAVA, PERL, HTML, UNIX, FORTRAN, VAX-VMS

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BW Consultant

Responsibilities:

• Developed a model to capture excess inventory data using IM, Purchasing, reorder point and material master, implemented user entry currency outputs in the reports. Main aim is to report exceptions to quickly assess opportunity and reduce existing inventory without negative impact to customer service
• Merged data from B1, ECC and Legacy(AXAPTA) to derive spend, gave alternatives to users to segregate consignments, direct and indirect spends.
• Customized the spend data from ECC to assign consumed quantities, condition prices using enhancement of datasource through CMOD also comprising currency and quantity conversions using standard SAP delivered function modules.
• Joined the existing models for sales, billing and delivery data using infoset to get customer on-time delivery metrics to help identify and track the delays, estimations and build times.
• Created the backend sources, logic for overhead costs(like Material COS, Reman Material, Variable OH, Subcontract, Transportation, Surcharges etc.) reporting that bring in cost components to show the historical comparison of data broken down by cost components to understand a sudden surge or dip in key measures due to changes in costing methods.
• Involved in several data conversion, integration and merger projects to harmonize the data in BW to make the end user reports consistent with previous data warehouse/reporting tools and run efficiently.
• Consolidated indirect spends from Medical, Industrial, Energy and non-SAP sources (Jaggaer application, Concur system, AXAPTA) and designed reports to find spend reduction opportunities.
• Combining KPIs from purchasing and invoicing to come up with single source for direct spend reporting that slice and dice with respect to material groups, sales types, product lines etc.
• Knowledge transition to offshore team which involved updating and/or creating the documentation for existing processes, identifying the gaps, developing during the stabilization phase.

Environment: SAP BI 7.4, SAP ECC 6.0, Solman 7.2, BEx, BOBJ WEBI, SD, IM, CO and FI.

Sr. SAP BW/HANA Consultant

Confidential

Responsibilities:

• Lead the BI upgrade from 7.0 to BW 7.4 on HANA with aggressive timelines, concept testing in sandbox, dev (change, before-after, transport mechanism tests) and QA (Quality, speed tests, user training) environments. Moving BO reports from Universe to BEx/cube based.
• Transformed and merged the major indexes (NYMEX, PLATTS and OPIS) legacy historical data and current ECC data into BW and developed the BO Design Studio interactive reports to show daily, weekly, monthly and year over year average prices.
• Implemented native HANA modeling on COPA data model using Attribute, Analytical and Calculation views for analyzing the margins, transaction profitability on fuels, lubes and services.
• Performed multiple POC’s on complex HANA models for BI reports based on Open ODS Views, CompositeProviders and Advanced DSOs.
• Created critical dash board reports for quantity purchased, sold, invoiced vs. delivered and for comparing sales and invoice document counts with respective amounts.
• Merged the Profitability, Accruals (orders that are delivered but not billed yet) and planned data (Integrated Planning) for the senior management visibility dash board using Lumira.
• Developed the Integrated Planning sequences to fill real time cube as per customer requirements and gave option to modify directly in the report and save to the InfoCube.
• Worked on SD reports related to invoiced vs. quoted prices, Movement margin analysis, carrier and invoicing performance, YTD customer sales volume, export invoice and order details, status of unbilled transactions and un-finalized dispatches. Also sent data to APO.
• Customized the Business Content reports on AR for showing the overdue customer balances, current month due, credit limit exceeding and showing DSO flexible buckets based on user prompts, reports on AP for vendor balances, due date and overdue analysis.
• Activated GL content for financial, income, balance statements and reports related to payables and receivables based on GL accounts, profit centers and segments.
• Replicated the actual cost line items (KSB1) from ECC into BI giving users the capability to see real time data using remote cubes.
• Merged data from standard purchase order items extractor with vendor rebate rates generic extractor and built WEBI reports to get the vendor eligible rebate volumes and amounts.

Environment: SAP BI 7.0/7.3/7.4, SAP ECC 6.0, BEx, BO Design Studio, Lumira, BODS, IP, SD, IM, CO and FI.

Confidential

Sr. SAP BW/BI Consultant

Responsibilities:

• Activated LO extractors in ECC for sales, deliveries, billings and created rules to organize the data for APO feed.
• Developed the BI extractor for Apacheta (hand held device data) to get the original order information and integrated with the SAP SD data sets.
• Extracted APO data into BW InfoCubes and created reports on Multiproviders that were built on planned and actual data InfoCubes.
• Activated FI/CO extractors (AP, AR, GL, CCA, IO, PC and AA) and developed corresponding staging, reporting layers in BW.
• Enhanced GL transaction figures (0FI GL 10) to accommodate a crucial characteristic “statistical key figure” that represents franchise sales, contract sales or produced units mainly used in management income statement summary reports.
• Developed process chains for extractions from ECC (SD, FI and DP), Margin Minder, Apacheta and APO in BW and connected them to UC4 a tool to trigger and monitor the loading activities.
• Built basic set of reports for SD, FI, CO and Demand Planning in BEx and BOBJ WEBI.

Environment: SAP BI 7.0, SAP ECC 6.0, BEx, BOBJ, Crystal Reports, SCM APO, SD and FI.