Project Sales

Sumana Sarkar

Sr. SAP Techno Functional Consultant

******.******@*****.**.** 650-***-****

Page 1

Experience Summary:

Sr. SAP Techno Functional Consultant with more than 7 years of professional experience in multiple

•

full

• lifecycle SAP Implementation, Support, Upgrade and Enhancement projects. Expertise includes client

interaction,

• team coordination, requirement gathering, fit gap analysis, technical and functional documentation,

technical

• development, testing, user training, cutover planning, go live and post go live (Hyper care) support.

A broad range of experience across industries and business processes, especially in Order To

•

Cash (OTC), Finance

(FI), Material Management(MM), Supply Chain Management(SCM), Procure to Pay(P2P),

•

and in IS OIL module for

various functional areas such of PRA(Production, Revenue accounting, Regulatory

•

Reporting and Tax & Royalty

Reporting), SD, FI and RE FX and the use of ABAP to enhance, extracts the data and

•

customizing these modules

Technical Expertise in ABAP/4 includes ABAP Dictionary, Design and development of

•

advanced interactive reports using ALV Grid Control, Module Pool Programming, Function

Modules, BADI Implementation, BDC, BAPI, RFCs, ALE IDOC, User Exits, Object Orient ABAP

Subject Matter Expert (SME) in SAP EDI/ALE/IDOC and extensively worked on ALE interfaces

•

and IDOC

configuration. Configured Partner profiles, Ports, Logical systems and RFC destinations.

•

Worked on IDOC Extension

of the existing IDOC types or creation of new IDOC types, written several Function

•

Modules, User Exits and

Enhancements to customize the ALE Inbound and outbound interfaces.

•

Expert in troubleshooting of ALE IDOC issues

•

Extensive experience in B2B integration in areas of Order To Cash (OTC), Procure To Pay

•

(P2P), Finance (FI),

Material Management(MM) and Supply Chain Execution (SCE)

•

Great understanding of ANSI X12/EDIFACT/Rosettanet Transaction Sets and EDI

•

communication protocols

Good knowledge of various middleware tools like Seeburger, webMethods etc

•

Experience in BADI implementation for screen fields, validations, modification of standard and

•

custom data

Extensively worked on Interactive Reports, ALV and dialog programming

•

Good knowledge on BAPI’s to transfer data from legacy system to SAP

•

Experienced in using various modularization techniques i.e. subroutines, RFC’s and class

•

modules

Extensively worked on RICEF developments

•

Expertise in performance analysis and tuning using various debugging tools like run time

•

analysis and SQL trace.

Worked on checking and application of OSS Notes to the problem areas

•

Experienced in Workbench tools like LSMW, debugger and runtime analyzer

•

Excellent Trouble shooting and debugging skills

•

Demonstrated ability to complete multiple assignments simultaneously, maintaining quality of deliverables and work

•

efficiently in onsite/offshore model

SAP versions experience: 4.6c, 4.7 and ECC 6.0

•

Excellent communication, problem solving and analytical skills

•

•

Page 2

Technical Skills:

ERP Skills: SAP R/3 ECC 6.0, 4.7, 4.6C

•

Domain: Order Fulfillment(SD), SCM, P2P and IS OIL module for various functional areas such of PRA(Production,

•

Revenue accounting, Regulatory Reporting and Tax & Royalty Reporting), SD, FI, RE FX in SAP

Programming Languages: SAP ABAP 4.0 including core ABAP, Object Oriented ABAP, DDIC, Module Pool

•

Programming, BAPI, BDC, ALV, User exits, LSMW, BADI, Enhancement concepts

Interface: IDOC, ALE, RFC

•

Utilities: Runtime analysis, SQL tracer, Debugger

•

Testing tools: HPQC and Mercury,

•

Tools / Packages: Remedy, Solution Manager, Microsoft Word, Microsoft Excel, Microsoft PowerPoint

•

Database: Oracle

•

Environments: Windows

•

Professional Experience:

Ingram Micro, Santa Ana, CA, US: Ingram Micro Inc., a Fortune 100 company, is the world’s largest technology

distributor and a leading technology sales, marketing and logistics company for the IT industry worldwide. As a vital link in

the technology value chain, Ingram Micro creates sales and profitability opportunities for vendors and resellers through

unique marketing programs, outsourced logistics services, technical support, financial services and product aggregation

and distribution.

Duration: Jun’2010 to Aug’2012

Role: SAP ABAP Techno Functional Consultant

Domain: OTC, SCM, MM, P2P and FI

Environment: SAP R/3 ECC 6.0

Project: SAP Implementation for Ingram Micro Logistics and Distribution business in multiple countries

Scope of the project: SAP Implementation in 19 countries for Ingram Micro Logistics and Distribution business from

existing mainframe system

Contribution:

• Worked as a SAP Techno Functional consultant as part of B2B integration project in areas of Order To Cash (OTC),

Procure To Pay (P2P), Finance (FI) and Supply Chain Execution (SCE)

• Extensively worked on handling tasks of requirement gathering, fit gap analysis with current business users, Task

Estimation, functional design document preparation for ALE Interfaces, Interface development, ALE configuration,

Functional acceptance testing, assisting on integration testing, partner testing, managing cutover activity and

supporting during Hyper care period till stabilization phase for Ingram Micro distribution and Logistics rollout in

multiple countries

Worked on ALE configuration like Configuring Partner profiles, Ports, Logical systems and

•

RFC destinations. Designed and Implemented new ALE –EDI and XML asynchronous

interfaces for SKU Create/update and response, suggested PO create and response

transactions which were manual earlier

BADI_MATERIAL_CHECK was implemented to modify description of material during material master update.

• Customized existing Inbound Order, outbound order response, Outbound ASN, Inbound/Outbound invoice

transactions as per business need by enhancing ORDERS05, DELVRY03, INVOIC02, MATMAS05 IDOC types

• Extensively worked with middleware team on mapping of Application layout fields of ANSI X12/EDIFACT/Rosettanet

Transaction Sets to IDOC fields

Page 3

• Valuable suggestions made to the Business to avoid duplicate Enhancement by proposing reusable and steady

solutions which are extensively used by Ingram Micro Business and contribute most of the EDI/XML Business

• Organized training program for Ingram Micro Logistic project's all trading partners (Best Buy, Visioneer, BenQ,

Yamaha etc) on the following Interfaces in new SAP EDI platform

Interfaces: Inbound/outbound order and Order Response, Order change/response, Inbound/Outbound ASN(Advance

shipment Notification), Inbound Material Creation and Change/ Response, Inbound Suggested PO Create/Response,

Order inquiry and response and Order status

• Coordinated and performed Functional acceptance testing for Ingram Micro distribution and Logistics rollout in

multiple countries

• Participate in integration and Partner testing for Ingram Micro Logistics North America rollout and Ingram Micro

Distribution multiple country rollout as part of ALE/EDI business solution which involves following activities

1. ALE IDOC Configuration set up for EDI and XML transactions(Interfaces) for each trading partner

2. Following up with other teams on master data setup/configuration and following up with business to get details of

partner id and legacy data which we need to set up as part of EDI configuration for Partner testing

3. Fixing issues on time came up during testing

• Worked on fit gap analysis and requirement gathering phase for SAP implementation with Apple/Walmart/Cisco/ Best

Buy and Microsoft Reverse Logistics for Ingram micro logistics business by Participating in fit gap meetings with

Business and providing valuable inputs on ALE/EDI side regarding current functionality and how we can leverage that

for new trading partner’s business need along with solution approach for new requirements

• Prepared and executed cutover plan for multiple country go live in different time zone at same time and s upported

during Hyper care period by taking immediate action on critical issues

Chevron: Chevron Corporation, USA is the world’s fourth largest non government energy company. Chevron is engaged

in every aspect of the Oil & Gas Industry, including Exploration, Production, Refining, Marketing and Transport; Chemicals

manufacturing & sales; and power generation

Duration: April 2005 to May 2010

Role: SAP ABAP Technical consultant

Domain: PRA, SD, FI and RE FX functional areas of IS OIL Module

Environment: SAP R/3 4.6C, 4.7 and ECC 6.0

Project 1: SAP PRA Production support

Scope of the project: Technical Support to in PRA functional area of IS OIL Module

Contribution:

Handling tasks of estimation, technical specification preparation, coding for PRA functional area of IS OIL Module, unit

•

testing, code review, and solving production issues

Support to key applications like Royalty Gross up, Wyoming Supplemental, Gas balance, GasWiz Inbound/Outbound

•

process

Extensively worked on Interactive reports, ALV reports, Screen Painter, Module pool, ABAP Dictionary, Function

•

Modules, BDC, Smartforms & OOPs ABAP

Handled job scheduling and monitoring

•

Analyzed and applied OSS notes to problem areas

•

Page 4

Support during regression testing every month, reimporting objects which were yet not gone to production after

•

refresh of staging system

Mentoring new team members regarding production support processes and PRA related processes

•

Provided training to the new team members on ABAP (ALV, Modularization, File Handling, Inbound/Outbound

•

interfaces)

Reviewer for Technical Specification and Coding tasks

•

Identified and improved performance of existing processes which were appreciated by customers and senior

•

management

Assured Quality Process compliance using Defect tracking Sheet, Work Allocation Sheet, Project Action Log, Risk

•

Monitoring Log and Minutes of Meetings.

Successful transition and steady support to production activities

•

Improved quality of documentation including Technical specifications, Test Plans and Knowledge capture document

•

for future references

Project 2: Chevron’s upstream business process server Upgrade from SAP R3 4.6C to ECC 6.0

Scope of the project: The scope of this project included PC1 (Chevron’s upstream business process server) Upgrade

from SAP R3 4.6C to ECC 6.0

Contribution:

• Worked on fixing issues in standard objects coming in SPAU (Transaction that allows to process Repository objects

needing adjustment in new environment)

• Use of tools like SPAU, SPDD

• Worked on many custom objects for removing obsolete code and Function modules and replacing them with new

upgraded Function modules

• Worked on synchronization activity comparing old system’s (4.6C) custom objects with new system’s (ECC 6.0)

custom objects

• Experience in Unicode conversion

• Resolved issues during testing phase of upgrade project

• Contributed on reviewing objects changed during upgrade activity

Project 3: Chevron–Reserves Process Development

Scope of the project: The scope of this project included developing five new programs which will support new CRS

(Chevron Reserves System).This was a critical project as Chevron was developing a new Chevron Reserves System that

was going to replace the old Chevron Reserves System. The purpose of this project was to send the output from

Production & Revenue Accounting to new reserves system with new layouts and validation rules.

Contribution

• Developed SOX compliant complex programs in SAP R3 4.6C where reserves data were extracted from SAP tables

and files, consolidated in file format required by reserves team and placed those files in application server for

processing it further using outbound to send it to reserves server.

• Provided functionality to display application log through SLG1 after completion of each program

• Specially designed programs with optimized performance

• Worked as a coordinator and Assured Quality Process compliance using Defect tracking Sheet, Work Allocation

Sheet, Project Action Log, Risk Monitoring Log and Minutes of Meetings

• Post Go live support documentation were provided to the user along with User Training

Page 5

Project 4: Chevron–Joint Interest Billing Information(JIB )Report development

Scope of the project: Joint Interest Billing Information (JIB) is provided to the JVA Group on a monthly basis for all the

Convenience Netting (CNET) and Net Profit Interest (NPI) so as to allow them to book the Revenue generated from PRA

before offsetting any Expenses booked in JVA. Developed report for extracting Joint Interest Billing Information and

sending to the JVA Group on the 8th workday after the close of PRA postings for the previous Month

Contribution:

• Involved in requirement gathering and blueprinting of the process.

• Developed program in SAP to Extract JIB data and generate CNET & NPI Spool in format required by JVA

Group

• Provided facility to download the Spool into PDF file or excel Spreadsheet in desired format and facility to

send mail with PDF attachment to intended recipients.

• Worked on Requirement Analysis, Creation of Technical Specifications, Coding, Unit & Integration Testing

• Transitioned new process with Post Go-live support documentation to user

Project 5: Chevron–Texas Tax New Engine

Scope of the project: Development to merge TIPS data for and PRA data to help electronically generate Tax

report via SAP for the State of Texas. Gas accounting data was imported into SAP system by external solution

called TIPS (The Intelligent Plant Solution). During the Texas tax engine migration, this Development helped to

merge TIPS data into PRA using BADI and populating OIUX3_TX_TAXTXN table for the Texas Tax Rewrite

New Solution data.

Contribution:

• Have done feasibility study of the New Engine solution for Texas Tax to merge TIPS data using BADI’s

• Created new Data Dictionary Objects (Structures, data elements and domains) as required in the EDI format

• Created custom functionality that would upload the TIPS data into Custom tables. This program would also

check for known erroneous data and other test that are done by the new engine to avoid error data at further

level.

• File error handling and Analysis report were developed

• BADI implementation to populate the data into SAP tables

• New solution had improved process performance and Less chances of error due to this process automation

Project 6: Chevron CATTs to BDC Conversion

Scope of the project: Development of BDC Reports that would automate the process of manual loading of Master data

and selected transaction data that was done using CATT scripts. The BDC programs were provided with additional checks

for known errors in uploaded file and lookup against existing Master records.

Contribution:

• Involved in analysis of the current CATT scripts and feasibility study as well as scope of the automation.

• Created custom functionality where BDC Programs uploaded the Excel/CSV files from

Presentation/Application server, Ran the data validations checks and called the BDC to upload the data into

ztables.

• 12 BDC were submitted covering more than 30 CATTs which improved Quality of data and Turnaround

time

Project 7: Chevron –New Mexico Royalty Process Automation

Scope of the project: Development of a tool that would automate the existing New Mexico Royalty filing process. It

previously involved downloading data from SAP and third party (File comes from accountant), processing these files using

UNIX scripts to get the file in the format required by State of New Mexico and sending to EDI group.

Contribution:

• Participated in analysis of the current design and feasibility study as well as scope of the automation

• Analyzed the existing process defined in UNIX scripts(50) and Developed new Data Dictionary Objects (Structures,

data elements and domains), table maintenance

Page 6

• Developed Complex Selection screen to support multiple functionalities, i.e. downloading data from SAP reports,

uploading third party data in custom tables and creating final files in EDI format

• Created SOX compliant custom functionality where reports generated/finalized by state were displayed in ALV and

EDI format and interfacing with EDI using outbound functionality. These reports can be downloaded and directly

uploaded to the State EDI website.

Project 8: Chevron– Statistical Key Figure (SKF) Process automation

Scope of the project: Development of a new tool, replacing existing manual SKF process. SKF data is used by Joint

Interest Accounting for billing overhead, distributing cost, etc to partners. SKF job in PRA captures Well Count data from

the Production Module. This process is a critical part of month end closing activities in PRA and it is executed on 5th

workday of every month. The manual process involved execution of standard SAP transaction O3UPR_SKF, downloading

spool data on local machine in text format, modifying text file data by deleting some unwanted lines and then converting

the file in Excel to sort the data and get rid of junk data. This excel file is then queried in MS Access to create summary file

and sent to user along with original txt file for verification of SKF posted and audit record.

Contribution:

• Analyzed existing MS Access queries and developed a tool in SAP R/3 4.6C to replace the entire manual SKF

process described above replacing MS Access queries that reduced process execution time from 2 hours to 60

seconds.

• Eliminated scope of human errors and ensured SOX compliance to take care of sensitive data

• Provided spool data download functionality and automatic notification capability by sending email to key users at the

end of SKF process

Project 9: Chevron Project Olympic SD to RE Master Data synchronization (Implementation Project)

Scope of the project: The scope of this Project was to create a program which has to run as a periodic batch job to

synchronize master data between the Sales and Distribution rents receivable contracts and Real Estate master data

Contribution:

Developed a program which has to run as a periodic batch job to synchronize master data between the Sales and

•

Distribution rents receivable contracts and Real Estate master data.

Created new BAPI and used existing BAPI for extracting rents receivable contracts and Real Estate master data

•

Macro was used to add values to selection options

Provided functionality to display application log through SLG1 with all exceptions and status.

•

User Training along with Post Go live support documentation were provided

•

Project 10: Project Olympic SAP R3 4.7 Implementation in Asia Pacific and South Africa region

Scope of the project: The scope of Project Olympic was a global business initiative to maximize the value of systematic

harmonization, standardization, and consolidation of Global Downstream's business systems. Olympic Project was to

deliver common business platforms which streamlined operations, improve processes and enable a comprehensive view

across global Business Unit and Service Organization.

Contribution:

• Worked as ABAP Technical consultant in RICEF developments in SD, FI areas on interactive reports, ALV

reports, Screen Painter, ALE-IDOC, Enhancements, ABAP Dictionary, RFC, Smartforms & OOPs ABAP

Create transaction variants using SHD0

•

MB_MIGO_BADI implemented to add custom subscreen for MIGO. This screen had fields to specify source and target

•

BIN details. Initial data fetching, validations and populating custom tables is taken care through BADI implementation.

Logic was implemented in BADI to validate data and trigger TO once MIGO posting is successful.

Page 7

Another implementation of the same BADI was created to populate custom table with Vendor stock data. It is being

•

fetched in enhancement within MMBE to display Vendor stock data

Worked on developing following major interactive reports:

•

1. The Going Past Due report: All of the current AR Aging Reports are being moved to BW (Business Warehouse)

so there was a need for this new Going Past Due Report to be available real time via SAP

2. Generic Billing Report for Export Sales Report: This report was developed to clear all the bunkers in a month.

The report is populated by the Bunker Delivery Receipt numbers on the original Bunker Delivery Receipt. These

items are submitted to SARS within 7 days of the month end. Used for Fuel Levy and Road Accident Fund.

3. Rebate Report for South Africa: This report was developed to gather details of rebate agreements which is used

for the purpose of reports and work lists.

4. Domestic, International And Export Trade Report: This report was developed to represent actual sales volume

by industry and material which gives details of Total sales to industrial customers by sub sector and fuel type and

Total sales by region (in barrels). All functionalities were handled in a single interactive report which can give

multiple levels of drop down facility

Educational Qualification:

B. Tech in Information Technology – 2004

Professional Affiliations:

• Attended SAP ABAP training program consisting of ABAP Dictionary, Reports, ALV, Function module, ALE, Idoc, BSP,

BDC, LSMW, BAPI, BADI, Workflow, SmartForms

• Trained in Workflow, WebDynpro, XI

• Attended training on MS SQL, Linux, C, C++, Core Java

Page 8

Contact this candidate