Kiran K Sreeram

adjutj@r.postjobfree.com SAP BW Certified

Mobile: 405-***-****

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.

Education/Certification:

MS in Computer Science, Oklahoma City University, Oklahoma.

SAP Certified Consultant in Business Information Warehouse (BIW) by SAP America.

Oracle Certified Professional in SQL, PL/SQL, Programming Units, Forms.

Software Skills:

SAP BI 7.0-7.4, BW 3.5/3.1C/3.0B, 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, Solution Manager, ERWin, MS Visio, Oracle 8.i/7.3, Developer 2000, C, C++, PL/SQL, JAVA, PERL, HTML, UNIX, FORTRAN, VAX-VMS

Project Experience:

Wilco Technologies LLC Aug ’10 – Current

Sr. SAP BW Consultant at Gardner Denver Holdings Inc. (Ingersoll Rand), Milwaukee, WI

Designed and implemented BW solution for reports on Excess Inventory, On Time Deliveries, Global Direct and Indirect Spends, Overhead Costs.

Designed and developed Global Spend Analytics solution for Gardner Denver data to be merged into Ingersoll Rand OBIEE system. Consolidated data from ECC, B1, AXAPTA and GLOVIA in BW for direct & in-direct spend and sent to OBIEE.

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.

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, applying the patches 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 at Pilot Thomas Logistics, Oklahoma City, OK

BW/BOBJ implementation project in the areas of Pricing, SD, COPA, AP, AR, GL, Inventory Management, Purchasing and support after go-live.

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.

Dr. Pepper Snapple Group, Plano, TX (Sr. SAP BW/BI Consultant) Jul ’09 – Jul ’10

Setting up a new BW instance that provides the analytic foundation capability to create variety of daily operational reports on SD, FI, CO, non-SAP sources and feed APO with actual data.

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.

Goodyear Tire and Rubber Company, Akron, OH (Sr. SAP BW Consultant) Oct ’08 – Jun ’09

Designing and implementing an end-to-end BI Solution for the SD module from SAP to feed the Demand Planning and create appropriate reports on the forecast data.

Consolidated and realigned the SD data from ECC and EDW with APO specific rules, loaded this data to the SCM InfoCube which is used by DP team for forecasting and extracted the forecasted data from DP and SNP to BI data targets with more than 40 key figures.

Created the BEx Reports on testing accuracy of historical data and worked with business users in complying with their expectations.

Developed several Open Hub destinations and applied rules to send the data to EDW team.

Interacted with business users on report specs and lead the reporting development work.

Conducted training sessions for the BI support team on production support and OLAP reporting.

Environment: SAP NetWeaver 2004s, ECC 5.0, SCM (APO) 5.1, BEx, WEBI, FI, SD, ERWin

Saint Gobain Abrasives, Worcester, MA (SAP BW/BI Architect) May ’06 – Sep ’08

Designing the BI solution, developing the extractors and the data warehouse layer for the global upgrade to BI7, supporting the existing production system.

Designed the architecture and lead the development of data providers and reports on the Sales and Billing Conditions Data and COGS inter-company sales in BI 7 using extractors 2LIS_13_VDKON and 2LIS_11_VAKON.

Designed and developed Affiliate Order reports for open and planned requirements utilizing the MM components and purchasing data extractors from R/3.

Implemented BADI’s in InfoSpokes to transform the data and exported to DataStage.

Worked on simplifying the design and ABAP logic for SD, MM modules from BW 3.5 to BI 7.

Implemented Business Content Inventory Management extractors (2LIS_03_BF/UM) in BW.

Created the data source extents in R/3 and removed the complex code in BW lookups.

Worked with business users to analyze tax and exchange rate calculations for all the countries and helped in building reports in BEx Query Designer.

Extracted data from CRM and SRM systems and created reports for the power users.

Other tasks include monitoring and fixing daily loads, approving and moving transports, managing, prioritizing and assigning the work orders.

Environment: SAP BI 7/BW 3.5/3.0B, SAP R/3 4.6C, BEx, WEBI, FI, MM, SD, PP, PM

Mac Gregor Golf, Canton, MA (SAP BW/BI Part Time Resource) 2007-2008

On call based production support involving performance improvements of loads, reports and enhancements to the existing data providers, reports.

Implemented the BW data load sequences through process chains and automated the loads using trigger from ECC and meta-chains.

Enhanced many cubes and ODS’s with virtual characteristics and key figures and applied ABAP code to get accurate data at reporting time without disturbing the existing data in the data marts.

Fix day-to-day load issues and support the SD and FI users by enhancing the data providers and reports according to their ongoing requirements.

Built sales reports based on sizes, genders and product types for sales and marketing departments using Conditions, Exceptions, Cell Definitions, Calculated and Restricted Key Figures in BEx reporting.

Environment: SAP BW 3.5, ECC 5.0, BEx Analyzer, FI, SD, MS Visio

Philips Medical Systems, Andover, MA (SAP BW/BI Lead Consultant) Mar ’04 – Apr ’06

Involved in the development, performance tuning and post-production support for BW. Lead the off-shore production support and operations team.

Designed and implemented a pilot project with SEM-BPS for CO-PA: Published Key Figures (0COPA_C01) on various managerial planning levels.

Worked on performance tuning of data loading and improved the query response time using Aggregates, InfoCube Partitioning, Compressing, Indexing, BW Statistics, OLAP Caching and Parallelization techniques.

Redesigned and developed extractors, Infopackages, Process Chains, queries/workbooks that were affected by the controlling area merge.

Involved in cutover operations, data recovery efforts and changes in user exits, lookups and reports during controlling area merge.

Designed the data flow and reports for customer service department and developed a strategy to publish required data for Customer Profitability users.

Worked with SAP support team in resolving major operations issues that affect daily activities of end users.

Environment: SAP BW 3.5/3.1C, SAP R/3 4.7, BEx Analyzer, FI, CS, PS, SD, MS Visio

SC Johnson, Sturtevant, WI (SAP BW Consultant) Jun ’03 – Feb ’04

Worked actively on the enhancements, production support and performance tuning of the existing BW system.

Designed the architecture and developed extractors, reports for Days Sales Outstanding, Payment Review Analysis for credit collection department involving FI-GL and AR.

Developed an archiving strategy and carried out archiving of SD, FI InfoCubes and ODS objects using ADK.

Developed ABAP programs to save PSA data in flat files in the application server and restore them when required.

Enhanced query performance on multi providers with customer exit variable to choose the InfoProviders based on user entry for company or country codes.

Involved in performance tuning by utilizing BW statistics and early watch reports.

Created several generic DataSources (using tables and Function modules) for extracting the R/3 data from different tables.

Conducted training sessions for BEx users, designed and developed documentation on data marts and reporting. Developed test plan documents for partitioning and archiving projects.

Environment: SAP BW 3.1, SAP R/3 4.6C, BEx Analyzer, FI, CO, SD

Enogex Inc., Oklahoma City, OK (SAP ABAP/BW Developer) Aug ’01 – May ’03

Production Support: Environment: SAP BW 3.0, SAP R/3 4.6B, BEx Analyzer.

Contact this candidate