Kumar Subramani

Summary: Email Id:

absnxb@r.postjobfree.com Ph.: 614-***-****

Over 10+ years of experience in designing, development, and implementation of Information Technology

Systems in SAP BW/BI and R/3 it includes 4 Implementations and development. Hands on experience in

leading all stages of system development efforts, including requirements definition, design, architecture,

testing and project based efforts while managing, motivating, and guiding team.

SAP BI/BW Experience

Led 5 SAP Applications and worked on 5 Implementation projects, for CRM, FICO,

•

SCM,

APO, MM, SD and SCEM. Functional and technical expert CRM and FI/CO.

• Led/Architect multiple BW/BO project works and developed technical design specifications

for

Developments. Worked with Business Stakeholders, IT Infrastructure teams, and

Development

Teams to ensure that business requirements were properly configured within SAP and that all

Development objects perform as designed.

Strong team leadership skills including team player and ability to deliver large

•

scale/complex

Projects. Planned and coordinated/managed Go Live Projects (Data Migration and Pre

Migration

Tasks) using Microsoft Project.

• Followed SAP ASAP implementation methodology and strong systems development life

cycle

• Experiences, from project analysis, requirements gathering, process design, wrote blue print

phase

• Documentation, completed configuration during realization phase, prototype, and data loads,

cut-over

• Plan, Unit testing, integration testing, user acceptance testing (UAT), power user training, and

production/Go- Live supports.

• Resolved the Problems, Incidents, Change and Request Management issues using Peregrine

Service

• Center and complied ITIL (IT Infrastructure Library) Service Management.

• Data Modeling, ETL, Loading, extractor, Function Module extractor and created Customs tables.

• Hands on Experience in the design and development of Info Cubes, Virtual Cubes, MultiProviders, ODS Objects,

Hierarchies, Info Objects, PSA and ODS, writing Update routines, Transfer routines. Data Sources, CMOD,

BADI, Accelerator.

• Transfer of Business Content to active version with all its dependent objects like Queries, workbooks, updated

rules, Info Sources, Transfer Rules etc.

• Using a lot of transactions such as ST03, RSRT and RSRV, checked and tuned system performance

• Extracted from SAP R/3 FICO/PS/HR/SD/MM/ IN/APO/POS/SCEM/XRPM/CRM) using extract structures

such as General Legher (FIGL, CO, PS, LO Cockpit, Generic Extractors).

• Experience in enhancing data source as per user requirements using User Exits.

• Worked extensively with BEx Query Designer, BEx Analyzer and Web Application designer.

• Worked in ETL to move and transform data from several businesses into corporate Oracle data warehouse. Data

sources included Oracle, flat files, and SAP BW. Strong expertise in Data Modeling, Data Cleansing, Data

Governance and Data Quality Using BW ETL techniques.

• Expert in identifying the ways the end users want to analyze data and design data access solutions (BW reports) to

satisfy the business requirements.

• Performed performance tuning both back end and front end sides.

• Involved in the design and development of Info Cubes. Responsibilities include development of new Info Cubes &

Enhancements to the existing functionality as per the user requirements.

• Report delivery is via the web using queries, web templates, and security based roles.

• Extensively used process chains to automate the process of loading data into data targets.

• Training end users in query development using BEx.

Technical Skills:

• BW Versions: 3.0B, 3.1, 3.5 and BI 7.0,7.3

• SAP R3 Versions: 4.6C, 4.7 and SAP ERP (ECC 6.0)

• ABAP/4: Data Dictionary, Routines, Function modules, AWB, User Exits (CMOD, SMOD), SAP Query, Info

Sets, OLTP Reports, Classical and Interactive reports

• BI: DSO,DTP, Transformation, BI Accelerator.

• Modeling: Multi dimensional Modeling (MDM), ERWIN, Oracle Designer, SAS.

• Reporting: BEx Analyzer, BEx Query Designer, WAD, Visual Composer, Enterprise Portals integration, iView’s,

and Crystal reports, Xcelsius, SAP Portals, Business Objects Webi,

Net weaver 2004s/BI 7.0.

• Database: Oracle 8i/9i, SQL Server 2000

• Applications: Microsoft Office – Word, Excel (Macros), and PowerPoint.

• Web Technologies: Java, HTML, Java Script.

• Knowledge SEM, SEM, CPM, MDM, HANA, HANA Studio

Experience:

Mettler Toledo Inc. Columbus, OH Sep 2012 – Till date

SAP BI/BO Business Analyst

Working as BI consultant with North America team implementation on CRM Sales and Marketing team and Service

Management.

It involves complete flow that start with Lead, Quotation, Opportunities and end with CRM Sales Order also it include all

activities. It helps business to reconcile the Lead to Sales order data on month end activities.

• Development activities include Blueprint, Workshop, Design and Backend and front end development.

• Developed a WEBI Dashboard Lead to quote (unlinked) it generates Lead, Quotes and Opportunities Sales and

Billing number of activities by Sales organization. Involved in P erformance optimization of improving queries

with Multiprovider design and reduce the runtime of queries.

• Involved in optimizing daily data loads and monitoring.

• Created BO reports on top if BEX query through BICS connection .Implemented Lead to Quote Linked, Lead to

quote unlinked and Service Dashboard using BEX query and BOBJ WEBI.

• Used Formulas and Variables, Formatting data, Break, Sort, hide, Cross table, Filtering report data etc.

• Synchronizing data from multiple data sources, creating multiple queries in Document, Synchronize data with

Merge dimensions.

• Analyzing the Cube data and Drilling into an interactive analysis document.

Restricting data with query using Wild Card in Query filters and using prompt to restrict data. Also used Complex filter.

• Enhancing presentation of data in reports

Breaks and Calculation.

Sort and Hiding

Ranking data and Tracking the data changes.

Highlight information with formatting rules.

Organized reports into section.

Copying and pasting data Blocks.

• Migrated/Promoted WEBI reports from DEV to PRE PROD and PRE PROD to Production.

• Broad Casting and Publishing reports.

Environment: BI 7.3, BO 4.0, CRM 7.2, SAP ECC, APD, BWA,BODS Business Object Data services, BEX Query,

WEBI, Dashboard, BOBJ Migration.

Barnes and Nobles Lyndhurst, New jersey Feb 2012 – Aug 2012

SAP BI/BO Business Analyst

Working as BI consultant in CRM CIC Implementation project for Barnes&Noble’s call center to support their Customer

and Vendors. It involves Agent Interaction with Customer through different Channel, and Create Interaction, Service

Request, ERMS (Email responses Management system), Survey, Device and Component.

• Coordinated BI Blue print reporting meeting with B&N Customer Services teams and Department and gather

Current and Future requirements.

• Working as Lead Consultant and coordinated BI development work with Offshore.

• Workings in CRM Implementation on areas are. Interaction, Service request management, Complaints,

Email responses Management, Survey management, Trade Promotional management, Territory

management.

• Developed WEBI report to get ratio of MHC (Mishandled call) by Partner and how many Service request was

Mishandled in a week.

• Created Universe and Join BW data with SQL data through Complaints /Service request id using Merge

Functionality in order to show the unlimited text data from for each order Customer comments/issue were posted

by Agent during on call with Customer.

• Designed and Developed data model design for Interaction, Service request, Mishandling call, ERMS, Survey

and reported using Business Object using WEBI through Relational universes.

• Designed ETL and extracted customer services data from using BO Data services from CRM to SQL.

• Also used OLAP connection via BEX and build a WEBI report out of BEX query.

• Used If Logic to group the data and calculated at the runtime.

• Creating a Hyperlinks in interactive analysis Panel Drill through to Service request reports from Interaction

report

• Creating a Document with Hierarchical universe (Differentiating a call types).

• Number of Call and Complaints by Vendor / Call Center and shown by Pie Chart and Bar Chart.

• Analyzing the Cube data and Drilling into an interactive analysis document.

Restricting data with query using Wild Card in Query filters and using prompt to restrict data. Also used Complex filter.

• Function and Formula and formatting being used to build Interaction and Service request reports.

Data function and String function, Breaks and Calculation.

Aggregation by Transaction Id.

.

Environment: BI 7.3, BO 4.0, CRM 7.0, APD, HANA, Business Object Data Services, WEBI DASHBOARD, BO

Migration.

University of Cincinnati Cincinnati, Ohio Sep 2011 – Jan 2012

SAP BI/BO Lead Consultant

Working as BI/BO Consultant in FICO Funds Management/General Ledger, Planning and Budgeting, Controlling

Cost Center allocation and Supporting BI application of PBF (Public Budget formulation) and HR (Personnel, TM

and Payroll, Benefits) for University of Cincinnati employees.

• Working with UC Executives, IT teams/ Development teams to ensure that Business

requirements were properly setup and designed in order to satisfy the Customer requirement.

• Developed reports on Funding, Spending and Planning for University departments.

• Worked in Special Legher reporting in generate the report in detail about the Cost and Actual for Various

department in UC.

• Created an employee history Management reporting/Dashboard using WEBI.

• Lead the BW enhancement pack to 702 upgrade and Support pack implementation on across all

environments with data base DB2.

• Involved in performance of improving queries with Multiprovider design and reduce the runtime of queries.

• Designed and worked in BO Data services from Employee conversion project which are extracted from SQL into

SAP.

• Worked on FI/CO(Controlling)/Commitment items (0PU_IS_PS_31, 0PU_IS_PS_32,

0PU_IS_PS_33) to

add new Fields via customer exit ZXRSAU01.

Environment: BI 7 .2,SAP ECC6.0, APD, FICO/Funds Management, Grant Management, Controlling, PBF,HR

ABAP, Net weaver 2004s/BI 7.0,Query designer, BOBJ (WEBI), Xcelsius, SAP Solution Manager, Dash board, SAP

Portals (EP 6.0), Info Spoke, Accelerator BWA, SAP GUI, Info set, UNIX, APD,Windows XP,DB2.

Monsanto St Louis, Missouri May 2010 – Sep 2011

SAP BI/BO Lead Consultant

Working as a BI CRM Consultant/Lead in CRM Activities /Service Management/Marketing planning to support the

Monsanto customer/Dealer/Agent in order to do forecast and planning for upcoming events.

• Architect BW Implementation project works and developed technical design specifications for CIC Web Survey

project for Monsanto Dealer/Customer.

• Worked with Executives, IT Infrastructure teams, and Development teams to ensure that

Business

• Requirements were properly setup and designed in order to satisfy the Customer requirement.

• Implemented Functionality and WEBI report in BO of Email Management System for

Monsanto Dealers/Partners in order to send and receive Status of product and notification

from CRM to BW.

• System architect responsible for developing strategy to move existing data feeds into the

Enterprise Data Warehouse (EDW) and additional target data warehouses.

• Successfully created large-scale Enterprise Data Warehouses, incorporating appropriate SAP

schema designs and architecture.

• Designed and Coordinate with BO team to create WEBI/Query/XCELSIUS in graphical view by number of

responses/Question by Survey and Survey validity detail (Survey status, Survey Validity, Owner, Target group

etc.). And customized to extract the required details from different source system in order to satisfy the reports.

• Used BO Data services push Cost center data to third party system for their reporting.

• Designed and Architect CRM Survey responses and Survey detail WEBI reports to Monsanto dealer in order to

know about the responses and Feedbacks.

• Created WEBI/Universe reports using to track Customer interaction activities and Complaints, Service order,

Survey details and Dashboard etc.

• Worked on extracting CO Product costing details and generate a WEBI report.

• Number of Call and Complaints by Call Center and shown by Pie Chart and Bar Chart.

• Analyzing the Cube data and Drilling into an interactive analysis document.

• Restricting data with query using WEBI Wild Card in Query filters and using prompt to restrict data. Also used

Complex filter. CO ordinated with SAP for extractor issue in CRM.

• Used Solution Manager SAP to migrate the development changes to different environment and followed the

Monsanto governance process and BI Development process.

• Used Open Hub/APD for push data costing data to oracle for consolidation reporting for South America team.

• Created customs cube, DSO, customs extractor and Customized Response data source to get details

Overview of the Survey. Used Start and End routine on complaints and ERMS.

Environment: SAP ECC6.0, SCM APO,CRM(6.0 Customer Interaction center, Activity) Service Management, Order

management, SD, IP, ABAP,APD, Net weaver 2004s/BI 7.0,Query designer, BOBJ (WEBI), Xcelsius, BODS Business

Object Data Services, SAP Solution Manager, BI Accelerator, Crystal, Dash board, SAP Portals (EP 6.0), ABAP, WAD

/Web Template, Info Spoke, SAP GUI, Infoset,UNIX, APD,Windows XP,DB2.

Kraft Foods Glenview, IL Jan 2010 – Apr 2010

Sr. SAP BI Architect

Working as a Customer Trade project in CRM/IP and SCM APO Production Support enhancement project with IBM in

order to support Customer budget planning system and Trade report for Kraft customers.

• Led/Architect BW enhancement project works and developed technical design specifications for new Kraft

customers.

• Worked with Executives, IT Infrastructure teams, and Development teams to

ensure that business requirements were properly setup and designed in order to satisfy

the customer requirement.

Used Defect tracking tool for testing and identify and tracking the issues.

•

• Extracted the CRM data (0CRM_FM_FPO, 0CRM_FM_BPO) and BI planning data to generate a planning

report for the Customers. Also extracted data through APD for Planning.

• Designed customs table and extracted from Customs hierarchy for Customer and Sales from ECC into BI

• Created Process chain for Transaction, Master data, Territory hierarchy structure and planning cubes to be loaded

into consolidated cubes. Trouble the failure load during off hours.

• Extracted the CRM data (0CRM_FM_FPO, 0CRM_FM_BPO) and BI/IP planning data to generate a planning

report for the Customers. Also extracted data through APD for Planning.

• Used write Optimized DSO for Hugh data extraction and further update to DSO’s in order to include a business

rule and logic for reporting.

• Extracted the Billing details (Header and Item), GL accounts, A/R, Claims, dispute management for OTC

(Order to Cash reports).

• Extracted the Billing, Funding, Spending and Planning, Actual, Plan balance, Live rates to generate the

Customer budget plan, Trade spending and Funding, BU revenue Trade summary, Payment and deduction which

also involve customer territories summary etc report.

• Troubles shoot the production issue and provided the solution. Also co coordinated with SAP for Patch/OSS notes

due to version upgrade and short dump.

Environment: SAP ECC6.0, CRM(TPM), SD, IP, FI A/R, IP, SCM APO4.1,BPC, ABAP, Net weaver 2004s/BI 7.0,Query

designer, BI Accelerator, Crystal, WEBI, Xcelsius, BOBJ, SAP Portals (EP 6.0), WAD /Web Template, CONTROL M

agent, Info Spoke, Visual Composer, SAP GUI, Info set, UNIX, Windows XP.

Limited Brands Columbus, OH Dec 05 – Jan 10

SAP BI Lead Consultant/Architect

Limited Corporate strategy is to implement SAP systems for Enterprise Resource Planning (ERP). SAP BW (Business

Warehouse) is part of the Business Intelligence strategy includes 4 implementations which supports critical functionalities

like FIGL –Finance, accounting, CO Cost accounting, Product costing, Profitability analysis COPA, Project systems

PS, Supply Chain event management (PO and shipment tracking) Demand planning APO and SNP (Finished and

Raw material APO) Article Master data tools (AMT) to report to various departments in the Limited Brands. Actively

involved in the end to end design/development/implementation of Go Live Projects and existing current production support

of executive reports and business intelligence systems.

Bath and Body Works Limited Brands, Columbus, OH

• Implemented the standard functionality of GL and Cost allocations, Project systems, COPA and Statistical key

figures and configured mappings to extract the balance sheet specially formatted reports like Income statement,

cost accounting reports, and management P&L reports using BEx (Business Explorer) reporting tools/Workbook.

• Implemented COPA Profitability analysis reported in BI which included Sales and Margin reporting for all

brands.

• Developed Cost center allocation and Internal orders to help the Management for Month end closing .

• Converted all Financial and Management report using BEx analyzer in order to support for Month end close.

o Balance Sheet Lvl 1, 2.

Income Statement Lvl 1, 2,3,4,5.

o

Margin Cost statement Lvl1 1, 2.

o

Cost accounting statement Lvl 1,2

o

Capital Budget and Forecast details,

o

Cost allocation and Freight Statement,

o

Statiscal Key figures air and Ocean.

o

Adhoc, Reconciliation etc.

o

• Configured POS/PIPE Data management to view the sales achieved in the store and details

Extracted for the credit card settlement process. Extracted and loaded the SAP BW with Retail Point

Of Sale data (PIPE), Material, Plant, Unit of Measure, and Articles, Plant and pushed to Retails from

POS Data management.

• Extracted the Article data from R/3 tables into BW .It contains Article details, SKU

Book of Business, Color, Variant, Merchandise and Product hierarchy details.

• Used the ABAP routine the status (Pushed /Pending) of Articles are calculated.

• Created Dashboard report (WAD) to display the Article in different Views (Daily and

Weekly report.

Victoria Secret Stores Limited Brands, Columbus, OH

• Architect BW project works and developed technical design specifications for developments.

• Configured, developed and implemented the Data modeling design in SCM APO4.1 (Demand planning/SNP) to

extract the data from planning area to BW cube and push the data back to APO box for back up. Created the

finished goods and raw material reports for Vendor and factory from DP/SNP planning projection by monthly

bucket.

• Extracted master data (Color, Article, department, Choice, product, vendor) from R/3 .Also extracted on order

goods receipts along with master data in order to FG projection.

• Formatted BO Crystal reports are : predefined report views

o VSP FG Region

o VSP FG Vendor Total

o VSP FG Basic Fashion Vendor

VSP FG all data

o

VSDP FG Region

o

VSDP FG Vendor Total

o

VSDP FG all data

o

VSP & VSDP FG Region

o

VSD & VSDP FG Vendor Total

o

VSP FG B&F + VSDP Total Vendor

o

VSP + VSDP FG all data

o

All Factories for a specific Vendor

o

• Created Web templates reports for SCEM, APO and maintained centrally sing through SAP Enterprise Portal

(SAP EP 6.0) using Net weaver 2004s/BI 7.0 Created Report To Report Interface (RRI) on queries.

• Designed the Customer order visibility report, Transport weight report, Transport gross weight by Purchase

Orders reports for building the SAP BW and Supply Chain Event Management (SAP SCEM) objects.

• Developed State tax apportionment report and Sales reports by country by combining SAP FI, SD, and MM

modules. Used CMOD for 0FI_GL_2 to get PO number from VBPA (Sales document flow) in order to fill

the missing PO from BSEG.

• Extensively worked in ETL, Data Modeling, Loading, extractor, Function Module

Extractor Data Design and modeling

• Created the Dashboard with Metrics of 3 companies Finance details in one View.

• Customized the Income statement and Balance sheet based on FSV update.

MAST Companies Limited Brands, Columbus, OH

• Architect BW project works and developed technical design specifications for developments.

• Designed the Customer order visibility report, Transport weight report, Transport gross weight by Purchase

Orders reports for building the SAP BW and Supply Chain Event Management (SAP SCEM) objects.

• Created Web templates reports for SCEM, Finance, APO and maintained centrally sing through SAP Enterprise

Portal (SAP EP 6.0) using Net weaver 2004s/BI 7.0 Created Report To Report Interface (RRI) on queries.

• Created process chain and connected to Control m scheduling tool and trouble shoot the issues.

• Performed performance tuning both back end and front end sides.

• Prepared code block in order to transfer the GL data (General Legher accounts) from PeopleSoft to Enterprise

Data warehouse system SAP BW using data stage interface. Also using Open hub tool to push the Profit /Cost

center to Teradata to maintain Store Operating cost expenses.

Limited Technology Services Limited Brands, Columbus, OH

• Architect BW project works and developed technical design specifications for developments.

• Activate the business content for xRPM and loaded the data for Resource Project Management (SAP xRPM) and

configured, validated the xRPM reports in SAP Enterprise Portal.

• Designed and scheduled the cost element hierarchy for the Limited Brands to user in the Cost accounting reports.

Developed the Syskoplan files to transfer the data from SAP BW server for month end reporting. Scheduled,

monitored and troubleshoot the EFS (Enterprise financial services) the Month end financial accounting and sales

loads and refresh.

• Created, configured and worked with the Control M agent to run the SAP BW jobs using Process Chains.

• Supported and monitored the SAP BW Production live system (24X7) and resolved the technical and functional

issues with SAP Functional, SAP BASIS, SAP BW Security and SAP technical teams. Assisted and prepared SAP

BASIS admin activities for setting up the SAP BW landscapes for development, quality testing and production

systems.

• Resolved the Problems, Incidents, risk, compliances, and Change and Request Management issues using

Peregrine Service Center and complied ITIL (IT Infrastructure Library) Service Management using

Governance, Risk and compliance process.

• Used Governances and compliance fixing the issues on time and help business to support on Month end

Book closing.

Environment : SAP R/3 FIGL, CO, PS, MM,SD, IN, xRPM SAP BW 3.5,ABAP, SAP SCEM 4.0, BPC,

SAP Portals (EP 6.0), WAD /Web Template, OLAP,SAP PIPE, CONTROL M agent,Info Spoke, Live

link, MSi Tools, Visual Composer, SAP BEx, SAP GUI, SAP BW Workbooks, Info set UNIX, Windows

XP.

Proctor&Gamble Cincinnati, OH Mar ’05 – Dec 05

SAP BI consultant

• Worked in development and enhancement of HR project.

• Enhanced HR Master Data and update the HR cube and report accordingly.

• Worked with backend Security and enabled new report available to users.

• Worked in product support and educate the users.

• Worked in Gillette acquisition project for BI development.

Environment: SAPBW3.5, SAPR/3, SAP Portals, HR, BEx Analyzer, WAD /Web Template, Oracle 8.0, Windows NT,

Workbooks.

Gillette Boston, MA May ‘04 Feb ‘05

Sr. SAP BI Consultant

Worked as BW consultant in SAP BW implementation of logistics controlling for entire Divisions this project was designed

to capture data of inventory, logistics costs, sales trends resulting in better sales planning, reduction in logistics costs,

service levels.

Responsibilities:

• Interacting with management and the end users to identify the business requirements and documented them.

• Worked on Inventory handling and material movement (Article) to Distribution center and Customer.

• Extracted the Purchasing details for Pre packs from R/3 to BW.

• Extracted the A/P, A/R, GL and Controlling/COPA and build the customs reports for Stock holders and Internal

Management.

• Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report to Report

Interface and R/3 thrill through for drill down analysis, and developed SAP BW reports for performing the

analysis of purchasing documents and inventory management

Environment: SAP R/3 4.6C, BW 3.0B, SAP Portals, MM, FICO, BEx Analyzer, BEx Browser, WAD Web Template,

ABAP Query, Oracle 8.0, Windows NT.

Alstom (I) Ltd, Chennai, India, May ’02 Apr ’04

SAP Analyst

Modules: MM

• Interact between Business analysts to ensure problem resolution of integration test TPRs.

• Review business initiated integration test, Test problem reports (TPRs) against design, replicate problem, identify

cause and propose solution.

• Involved in creating TEO (Test object).MTE (Master test object) and HLD (High level design).

• Identify the problem which is directly related to a requirement in the DER (Development request).

• Involved testing in workflow screen to validate the signoff roles and approve for PLA2.

Environment: SAP BW 3.0B, R/3 4.6C, FI/CO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Oracle

8.0, Windows NT.

Educational Qualification: Masters of Computer Applications (MCA)

Bachelor degree in Physics (BSC)

SAP Training:

• SAP Business Information Warehouse(BW), SAP

• SAP ABAP Programming, SAP

• SAP Business Process in Financial and management Accounting, SAP

• SAP SCEM Supply Chain event management, SAP

• BI Adminstration&Performance Tuning,SAP

• APO Demand planning, Onsite

Contact this candidate