OBJECTIVE

• Opportunity to effectively utilize more than 17 years of SAP BW experience as well as leverage extensive SAP functional and business knowledge in the areas of procure to pay, production, finance and order to cash.

SUMMARY

• SAP HANA Certified with experience in SAP BW on HANA including native architecting enterprise solutions in HANA Studio.
• Over 17 years of work experience on SAP BW at Confidential Foods, Confidential USA, Confidential, Confidential Consulting and Confidential Inc both on the Functional and Technical side using ABAP.
• Program Manager and BW Technical Lead overseeing the highly successful BW on HANA migration at Confidential Foods.
• Over five years of design and development experience in BW and APO environments.
• Extensive experience in RDBMS including Oracle, SQL Server, Clarify, Ingres. Middleware tools like Mercator, Informatica.
• Over thirteen years of experience in the field of IT working on applications related to Finance, Order to Cash, Materials Management, Manufacturing and Payroll.

TECHNICAL SKILLS

SAP Skills: SAP BW/HANA, HANA Modeling, Business Objects WEBI, Crystal, Analysis Office, Design Studio and Lumira, BODS, BPC

Development Tools: ABAP, HANA Studio, Mercator Ver 5.0, Informatica Ver 6.2

Java Technologies: JavaScript, JSP

RDBMS: Oracle 8.0.5, Microsoft SQL Server Ver 6.0, Clarify

Operating Systems: Unix, Windows NT, Windows 95

PROFESSIONAL EXPERIENCE

Confidential

BI/BW Lead

Environment: HANA Studio, BW 7.4 on HANA, BEx Query Designer

Responsibilities:

• Confidential implemented Supply Chain heavy for its Plants. I was involved in leading the effort for developing the Business Warehouse solution, this involved use of customized extractors and activating existing business content for pulling in data from ECC for the PurchaseToPay, Asset Life Cycle Management, Production Planning (Process Industries) and Product Costing Modules. Developed data models to support the above modules in BI.
• Played the role of technical lead in development, analysis, testing of different projects in supply chain reporting area including Dead material inventory reporting, Demand accuracy reporting, Contract Position reporting, Customer Profitability Reporting, Warehouse Scorecard reporting, Material ABC categorization.
• Lead the development, analysis, testing for Sales and Trade reporting area including design Customer Service reports, Invoice Accuracy reporting
• Lead Technical Architect for Product Costing area for developing Yield reporting which combined data from the process order data model with the costing information to calculate the Material Usage Variance, Purchase Price Variance and Inventory Adjustments.
• Played hands on technical lead role and was involved in End to End process in all above projects including the changing SAP delivered extractors, activating business content, building custom extractors with pseudo delta functionality, building the DSO, cubes, APD’s, aggregates and the reporting solution to support the data model. Setting up process chain and the triggering mechanism using Control - M scheduler. Reporting solutions was build using the BEx Analyzer and BOBJ toolset using WEBI and Crystal reports.
• Also worked on data models in APO and BI for gathering the forecast data from Demand Planning and the planned production data from Supply Network Planning. Also developed interfaces to feed the forecast, order and master data information to demand sensing third party solution and feeding the output from the same back to APO for further processing.
• Involved in trouble shooting issues in BI Production environment dealing with performance as well as data validation queries raised by users.
• Leading team of offshore developers to get better turnaround time to implement BI projects in Supply Chain Heavy reporting space.

Confidential

Environment: SAP R/3 Enterprise

Responsibilities:

• Working as a Data Expert for the Data Conversion from Legacy SAP to Globe SAP. Co-ordinating with the Offshore Development Teams in delivering the data for FI, HR and P2P objects correctly coded and tested.
• Involved in developing Data Object Structure sheets
• Coordinating the Functional and Cycle Testing On-Site.
• Resolving issues in the Data Loads through brainstorming sessions and communicating resolutions to the Offsite teams.
• Closely involved in the Process team cycle testing covering end to end business process scenarios and supplying the data required for the same.
• Testing out scenarios with the External systems to ensure compliance with the changes resulting from the implementation of the Confidential Globe Template.
• Co-ordination of design and development of interfaces for conversion of CO-PA historical data into Confidential Globe BW.

Confidential

BW & APO Development and Production Support

Environment: BW, APO

Responsibilities:

• Extended business content extractor to extract sales order, purchase order, material movement and batch classification data from SAP R/3 and loaded into BW ODS and thereafter into the respective Infocube.
• Developed update and transfer rules for loading master data, text and hierarchies for MM, FI and SD objects.
• Loaded master data and initialized deltas for FI Line Items and Transaction data.
• Developed Available Inventory report using multiple infocubes containing information of the infocubes that stored sales information, inbound and outbound STO, goods receipt etc.
• Developed flexible queries using filters and navigational attributes functionality of the Bex Browser and Bex Analyzer.
• Created Process chains to schedule complex data loads into data targets.
• Worked on BW Statistics to optimize the performance of Infocubes and to create aggregates.
• Developed extractor routine in R/3 for extracting shipment notification information and developed ODS in BW to store the information.
• Modified the standard material movements extractor to supply additional information to BW for the Material Movements ODS.
• Managed the development of solutions in APO for dynamic date determination for the SNP and DP planning runs, also developed monitoring tool for SNP optimizer.

Confidential

SAP R/3, Mercator Development for Master Data, Purchasing, SD and MM

Environment: SAP R/3 (4.0B), Mercator 6.5, Windows NT, Unix

Responsibilities:

• Coded user exits for Inbound PO Creation IDOC and also the Outbound invoice IDOC as per the business requirements.
• Interacted with the business users in the SD and MM teams to arrive at a flexible and robust solution for the PO and Invoice IDOCS.
• Analyzed, designed and implemented ABAP bolt on solution for saving CO-PA internal order settlement information into custom tables to enable easier reporting of Plan vs. Actuals expenses against divisional budgets.
• Implemented highly complex IDOC mapping rules for Master Data, Purchasing, Sales & Distribution.
• Coordinated with the functional team to effectively obtain the requirements from the user.
• Worked with IAC to test the IDOC, install maps and set up the destinations id for the files.
• Coordinated the upload of the data for Lookup tables in IDSS.
• Enhanced mapping rules for the Purchasing team to implement the Divisional FMS module.
• Worked with the Sales and Distribution team to implement the EDI mapping rules and provide quick turnaround during the GL-20 and production support that followed.
• Developed ABAP/4 reports for Profit Center Reporting and SAP Scripts for Dunning Letters, Customer Affiliate Statements

Confidential

Master Data Population Tool

Environment: SQL Server Ver 7.0, Windows NT, Unix

Responsibilities:

• Worked on complex stored procedures for writing filling and extracting data from SQL Server into flat files.
• Set up scheduled jobs to carrying out default process, field assignment and data manipulation routines to massage the material and Customer Data.
• Uploaded the Data into SQL tables for mass update by the Users.
• Utilized bulk copy procedures to extract data into files to be uploaded into SAP.

Confidential

Mercator Interface for SAP (SEM) Strategic Enterprise Management System

Environment: SAP R/3, Mercator v5.0, Unix

Responsibilities:

• Developed ABAP SAP Scripts for Purchase Order, Cheque Printing and Invoice
• Co-ordinated and successfully completed R/3 upgrade from 3.1H to 4.6B
• Designed, analysis and development of ABAP programs for feeding SAP data to various heritage systems like the HOGAN DDA/TDA systems for feeding CD, Savings, Money Market information in the standard Master Object Period Output Structure.
• Co-coordinating with the Operations group to test the maps in Unix and move maps through the testing landscape.