SUMMARY

• Over 16 years of SAP experience where in 12 years in SAP - BI and 4 years in SAP-ABAP.
• Strengths lie in Architecture, Data Modeling of Business Intelligence and Leadership capabilities. Very good logical skills suitable for process design, development & implementation. Excellent communication and customer focused attitude.
• Worked with multiple clients L-Brands, Mylan, Confidential, Avantor, Epson, Fox Head, Confidential, Confidential, SanDisk, DuPont, LSI, Fender, GE, McAfee, 3COM, Eastman Chemicals, Marubeni and Dayzim.
• Worked on different technological platforms SAP R/3, BI, Business objects, BODS & HANA.
• Strong exposure in Functional areas of SD, MM, PP, QM, FI-COPA, SRM, PLM, FM, FS-CD, IS-OIL, IS-RETAIL, AFS and CRM
• Excellent trouble shooting, Analytical, problem resolution and organization skills.
• Involved in 6 SAP BW implementation projects and also BI-BO integration projects.
• Involved in TSW IS-OIL projects and also AFS-Retail implementation project.
• Having lead experience since last 8 years.
• 4 Projects experience in BW on HANA and HANA modeling on SAP & Non SAP data.
• Involved in 3 SAP-BW-CRM implementation projects.
• Well-Versed in development environment, which includes Data modeling, Data extraction and Reporting.
• Providing assistance to various teams by understanding the business processes and requirements of the users at a depth sufficient to design and implement an appropriate BI architecture and solution to meet their needs.
• Worked extensively on extraction of LO Cockpit and also involved in R/3, DB Connect and Flat file data extraction.
• Enhanced standard extractors using data source user exit and also worked on query variable user exits.
• Worked in Index creations, Aggregates, Statistics, Partitioning, and Compression of cubes.
• Worked on performance tuning at the Query Level as well as at the Data Target Level.
• Worked extensively on BEx Queries and Workbooks using BEx designer/Analyzer.
• Well-Versed in Web Reporting and also created Web Page where all the related Web Reports can be accessed from the same Web page.
• Configuration of Info Spoke according to client’s selection and also handled secondary data sources and retracted the data to flat file.
• Involved in creation of Process chains to stream line the data loads.
• Extensive knowledge and work experience in SAP Transport Management System.
• Implemented Virtual Characteristics and Key figures in reporting requirement.
• Well versed in BO WEBI reporting and Universe building.
• Extensively worked on APDs & Open hubs.
• Developed Advance Analysis reporting & worked on Business Objects Explorer
• Developed Webi reports on HANA models(Calculated views & Analytical views)
• Worked on converting BI 7.3 cubes to HANA optimized cubes
• Worked on SLT extraction and BODS extraction

TECHNICAL SKILLS

Programming Languages: ABAP/4, C, C++ and Java

Data warehouse: SAP BW 3.1, 3.5,Net weaver BI 7.3 & 7.4

Database: Oracle, SQL

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

BI Architect

Responsibilities:

• Designed and developed the Composite Providers & Semantic Partitions for FMR
• Involved in Business requirements and status review meetings.
• Provided the Product Costing Bex Queries to users for Self Service Reporting in BO.
• Developed the ADSOs layer for all the Sales & Procurement extractors by adhering to the LSA++ approach.
• Developed attribute, analytical, calculation views(Graphical/Scripted) and stored procedures for sales process.
• Good knowledge in security privileges in HANA studio administration with user creation.
• Transported the HANA objects through the landscape with CTS++ approach using solution Manager.
• Replicated COPA related tables to accelerate CE1-CE4 real time reports using SLT to HANA DB.

Confidential - Washington, DC

Business Planning

Responsibilities:

• Designed and developed the BI infrastructure for Business Planning & Staff Task Assignment Tool.
• Involved in Business requirements and status review meetings.
• Developed Business Planning report, WPA Report, Staff Weeks Report, Variable Cost Report and Task Detail Report.
• Developed the ECC extractors for the Business Planning and Staff Task tool
• Delivered the BO reports to business on time.
• Supported the business for ongoing issues and enhancements.
• Worked on performance improvements for the BO reports.
• Performed Data modelling & developed package, Analytical view for the transaction data and calculation view as final model in HANA Studio.

Confidential

Responsibilities:

• Re-designed and developed the BI infrastructure for Sales & Distribution, Procurement, and Inventory Mgmt.
• Collected the requirements from Business for KPI metrics.
• Developed Sales KPI reports, Open Orders report, Shipped Orders report, Sales Analysis trend by month, Sales Analysis, Daily Sales, Open deliveries, Price Volume report and RGA report, PO Invoice Variance report etc.
• Improved performance to APO demand planning Queries.
• Worked with FI-BPC team for period end activities.
• Worked BW on HANA migration project.
• Worked on SAP based HANA Models ( Attribute, Analytical views )
• Composite Models using BW on HANA and HANA Models for global reporting.
• Developed a dashboard for Avantor Business Service report in BO 4.0
• Trained the end users on BO 4.0
• Created SLT transformation for COPA cost based extraction
• Created HANA Optimized Inventory cube.

Confidential

Responsibilities

• Designed and developed the BI infrastructure for Procurement, Inventory Mgmt, GTS Import Process and demand planning
• Worked on 2LIS 02 ITM, 2LIS 02 SGR, 2LIS 02 SCN, 2LIS 02 CGR, 2LIS 03 BF, 2LIS 03 UM, 9ADP MAIN and 0SLL CD 1 extractors.
• Developed PO Receiving, PO Details, In-transit, Inbound shipment, Inventory status, Inbound Outbound, ASP, Import Duties and Freight and Forecast Accuracy Bex and Webi reports.
• Successfully completed 3 Integration test cycles and business sign-off for all the reports.
• Developed Order performance time bucket metric report.
• Developed open hubs for SEIKO and third party.

Confidential

Responsibilities

• As an SAP BI Architect, responsible for gathering business requirements from Sales / procurement users.
• Created FTS, BRD, Test plan and Cutover documents
• Installed logistics extractors 2LIS 11 VAITM, 2LIS 11 VAHDR, 2LIS 11 VASCL, 2LIS 11 V SSL, 2LIS 02 ITM, 2LIS 02 SCL and 2LIS 13 VDITM.
• Designed and developed the BI infrastructure for Sales and Procurement
• Developed Sales and Procurement Bex reports like Booking vs Billing, Sales overview, Open orders, Revenue and Profit Margin, Daily Sales by Inside Rep / Out side Rep, POs by Year, Open POs, POs Freight Variance and PO details.
• Provided AFS specific reports like Orders or Revenue by Grid level.
• Streamlined inventory reconciliation process.
• Developed CFO dashboard, daily scheduled by BO 4.0
• Created aggregates on Sales and Billing cubes to improve the Sales Queries performance
• Trained users on how to use Bex Queries

Confidential - Rochester, NY

Lead KPI - C Perfect Order Track

Responsibilities

• As an SAP BI Architect, responsible in discussing business solutions for KPI-C with Business Analysts.
• Designed and developed the infrastructure for KPI-C metric Analytics project for the LVE Perfect order percent.
• Perfect order metrics were derived out of the 2LIS 11 VAITM extractor.
• Complex expert routine is developed to derive all the sales metrics requested by the business.
• Closely worked with the business from requirement gathering to Go-live.
• Resolved post go live performance issues by improving the code logic.
• Developed infrastructure for CRM Service Contracts, IBASE, Service orders and Confirmations.
• Installed extractors 0CRM SRV CONTRACT H, 0CRM SALES CONTR I, 0CRM SRV IBASE ATTR, 0CRM SRV PROCESS H, 0CRM SRV PROCESS I, 0CRM SRV CONFIRM H and 0CRM SRV CONFIRM I.
• Worked on BODS by sending CRM Partners address data to BODS for Qualitative analysis.

Confidential - San Antonio, TX

Lead Supply Demand Track

Responsibilities

• As an SAP BI Architect, responsible in discussing business solutions for TSW Analytics requirement with Business Analysts.
• Designed and developed the infrastructure for TSW Supply Demand Analytics project for the Bulk sales / Purchases, Bulk Nominations / Un Nominations and Rack Sales /Purchases through metric based snapshot approach.
• With this developed dash board tool Traders / Schedulers can track their in-transit inventory, physical inventory, Bulk Sales volume, purchase volume and Rack volume for a particular snapshot date.
• Custom Function module extractors are the source for deriving TSW metrics.
• Reconciled the supply demand metrics data with ECC IS-OIL tables and extractors.
• Worked on accelerator to improve the Query performance
• Working on BO 4.0 version as a ramp up customer.

Confidential - Milpitas, CA

Responsibilities

• As an architect proposed solution for CRM channel management business process and re-designed the existing BI data flow for Channel application.
• Designed the infrastructure for TPM email functionality in SAP BI system.
• Responsible for resolving post go-live issues in FI-CO and CRM area.
• Responsible for coordinate with offshore technical team and assist them in technical issues.
• Responsible for conduct meetings with users for requirement clarifications and provide demos on solution.
• Develop new reports for Balance sheet and Income statement.
• Single point of contact for FI / CRM period close activities.
• Worked on new GL 3FI GL 0L TT and 3FI GL NL TT extractors.
• Built Salesrep. Commission logic
• Worked on CRM TPM standard content and resolved the issues in the CRM Planning layout.
• Extensively worked with the TPM planning layout rendor engine BADI
• Extensively worked with CRM Funds Mgmt (0CRM FM FPO), Claims Mgmt (0CRM CLAIM) extractors.
• Developed Reported Channel inventory and Store level reported inventory flow.
• Scheduling of BO reports for users based on individual user requirement.
• Resolved the BI/BO integration issues during Enh. Pack upgrade to BI 7.01.
• Creation of OLAP universes based on the BEX queries.
• Worked on accelerator to improve Channel and Revenue Queries performance.
• Worked on integrating data from SAP SRM and ECC Purchasing extractors.
• Data sources used were 0BBP TD SC 1, 0BBP TD SC APPR 1, 0SRM TD PO ACC on SRM and 2LIS 02 ITM, 2LIS 02 SCL from ECC.
• Reports generated were shopping cart approvals, shopping cart cycle times and overall procure to pay cycle.
• Created universes for Channel and Revenue modules.
• Extensively worked on webi reports and complex reports.

Confidential

Responsibilities

• Responsible for analyzing problem requests and create Architectural Review document and Reload plan.
• Responsible for coordinate with offshore technical team and assist them in technical issues.
• Worked on Cost center accounting extractor 0CO OM CCA 1.
• Extensively worked on 0FI GL 4, 0FI AR 4 and 0FI AP 4 extractors.
• Designed and developed Material master, Vendor Master and Customer Master data flows for Reporting purpose.
• Extensively worked on improving extractor performance.
• Developed info spokes to push BW ODS data to ETL system.
• Worked on Cross Company Stock in Transit custom extractor.
• Developed a custom program to overcome the problems faced when NAV attributes added to existing Master data info object.
• Designed the Billing Conditions Cube for better performance.

Confidential

Responsibilities

• Designed Cubes and Multi cubes for KMAN Billing, Open Orders and Inventory data flow.
• Developed Daily Sales Dollars, Daily Sales Margin, Daily Sales Units, Daily Sales Margin Percent, Open Orders Details and Inventory Total reports.
• Worked on design of bringing APO data building reporting in BW

Confidential

Responsibilities

• Involved in resolving production tickets.
• Involved in Accounts Payable (0FI AP 03) enhancement for material characteristics.
• Involved in improving query performance by creating Aggregates to the cubes secondary index to the ODS.
• Worked on web reporting and Reporting Agent.
• Implemented EDW Layer for all the Info providers.

Confidential

Responsibilities

• Involved in the Requirement Analysis and creation of Technical Specifications.
• Involved in the development of BEX reports Channel Inv Mgmt, Sell Thru, Stock data, Subsidiary Ledger Recon and H/W & S/W Recon for HTCM (Subset of CRM System) and also developed jump queries.
• Involved in the data source enhancements for HTCM (Subset of CRM System).
• Developed the generic extractor for Material Price.
• Involved in Setting up of Inventory Management System.
• Involved in Activation of all Business content Data sources (2LIS 03 BX, 2LIS 03 BF & 2LIS 03 UM) and Cube 0IC C03.
• Involved in the development of update routines for currency conversion.
• Involved in the design of COPA (0COPA C01) cube.
• Installed 0FI GL 4 extractor and reloaded historical data.
• Involved in the UAT and Performance testing for the reports.
• Developed VB MACROS for HTCM reports.
• Designed HR Personnel Administration infrastructure for 0HR PA PA 1
• Created Head Count reports.

Confidential

Responsibilities

• Designed and Developed the Custom objects used (ODS, Info cubes).
• Deployed the best Data modeling techniques and the efficient Data flow
• APO-BW data source enhancement with selection option
• Transfer of Exchange rates from AS/400 to BW
• Created Generic Data sources on R/3 Inventory, Parcel Shipping Label, Spa Picking tables to meet the Sales & Marketing Group reporting needs
• Created process chain for product hierarchy upload
• Developed queries and query exits for Daily Sales Forecast, Monthly Sales Forecast, Forecast summary, Margin, Units, Sales Forecast for MTD QTD YTD, Actual vs. Forecast, Forecast vs. Margin, New Orders, Current and Future inventory supply, Pending delivery and etc. to meet the user requirements.
• Experience in data loading, data validation, data monitoring and data scheduling from SAP R/3 and other source systems into SAP BW.
• Experience in improving performance tuning by using aggregate and indexes.

Confidential

Responsibilities

• Created queries on using Query Designer for analysis through BEx
• Created reusable structures and exceptions in reporting
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Created custom queries using variables and structures, worked on Web Reporting and Web Publishing
• Analyzed business reporting requirements that could be satisfied by Business content Sales info cubes
• Used Aggregates for query performance Asset Conversion

Confidential

Responsibilities

• Created Function Module for Materials requirement planning
• Prepared design documents and developed various Reports according to the client need
• Worked on variety of reporting requirements using concepts of variable offsets, Exceptions and Conditions.
• Involved in Integration Testing and Unit Testing

Confidential

Responsibilities

• Created Start Routines, Transfer Rules for CD, Claims and AE
• Involved in Designing of Cubes and ODS by identifying the entities and attributes
• Created Function Module extractor for AE and CD
• Involved in Integration Testing and Bug Fixing on Reports
• Involved in writing update rules, start routines and transfer routines as per the client’s requirement
• Involved in performance tuning of reports to meet GE Six Sigma standards of 30sec for report output
• Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame

Confidential

Responsibilities

• Label Printing on Zebra & HP LaserJet Printers
• Check Printing for India and Australia
• Worked on Sales & Purchase registers
• Worked on many SD Pricing Condition Routines
• Worked on User exits& Customer exits

Confidential

Responsibilities

• Involved as a developer for the Upgrade team. Functional Areas included Sales & Distribution (SD), Materials Management (MM) and Financial Accounting & Controlling (FI-CO).
• Optimizing and analysis the ABAP code, using both the BPA and without it
• Testing and In-line Documentation of ABAP code
• Quality Assurance and Delivery

Confidential

Responsibilities

• Developed an interface for Dunning in FI module.
• Developed an inbound interface, which uploads Bill of Material details from file to SAP.
• Developed inbound interfaces (BDC), which uploads routing material using transactions CA01, CA02 etc.
• Developed Smart forms for Debit memo and Credit memo
• Developed a Payment Instruction HDFC File Format for Online Payments after the Automatic Payments run through F110 Transaction

Confidential

Responsibilities

• Developed interfaces on benefit related like COBRA
• Developed an inbound interface, which uploads Routing Material Assignment details from file to SAP
• Created Developed a report which is used to get the information like which material was shipped to which route, on which date, what is the shipping point and whether this message should be sent through email or fax or just take print
• Developed custom SE38 reports for HR personnel administration.

Confidential

Responsibilities

• Developed an inbound interface, which uploads Routing Material Assignment details from file to SAP.
• Developed upload programs for initial stock and material classification
• Upload of material master, vendor master and customer master through LSMW