Sap Project Manager

Syam Yerramilli

Email ID: ***********@*****.***

Mobile Number: 848-***-****; 732-***-****

PROFESSIONAL SUMMARY

• Over 13+ years of Information Technology experience as a Senior IBM

W ebSphere architect, Team Lead for integration group, Systems Integration Analyst

and project Manager for major re-platform project for large-scale projects using IBM

suite integration platforms and applications.

• Extensive domain knowledge on providing new reliable solutions and analyzing the

business scenarios to the customer in Retail and Manufacturing domains.

• Exclusive 5 years of experience in IBM products WebSphere Message Broker 6.0,

W ebSphere Application Server 6.0 and Datastage Tx 7.5 with implementation

includes design, develop, test, build and deploy with MQ series as communication

channel.

• Exclusively used WebServices, JDBC adapter, JMS adapter, JTEXT adapters,

Mainframes IMS bridge adapter and MQ Series in all the integrations.

• Experience in ESQL, JAVA, Oracle stored procedures, RDBMS concepts,

W ebSphere architecture, J2EE architecture and UNIX shell script.

• Developed, enhanced and maintained Message Broker flows and components for

providing stable environment.

• Excellent exposure on SOA Architecture and J2EE Architecture concepts

• 6+ years of exclusive experience in leading the Enterprise Applications using

different middleware business application tools Message Broker, Process Server,

W AS, Mercator/Datastage TX on UNIX and Windows Operating Systems with back

end Enterprise Applications like DB2, Oracle, Siebel, SAP and mainframes.

• 2+ years of technical Team Lead experience handling the whole project life cycle.

• Also experience in monitoring tools like Big brother, Nagios, ITS, NetIQ and Remedy

for production support and application maintenance support issues.

• Experience SAP integrations with different middleware tools using IDOCs and BAPI

methods.

• Had an experience doing internal training to the coworkers as a lead acting as a

Technical subject matter Expert (SME) on integration concepts

• Designed and developed the business needs to the technical specifications.

• Excellent communication skills, strong business and analytical skills, multi-tasking

ability, always team oriented and pleasant interpersonal skills

• Highly flexible with the work hours to meet with the deliverables. Worked as an on

call support team member in few projects

TECHNICAL SKILLS

Languages: Java, J2EE, ESQL, SQL, PL/SQL and RDBMS

Middleware apps: IBM WebSphere Message Broker,

IBM WebSphere Process server, IBM MQ Series, Mercator,

Datastage TX and Webmethods

Enterprise app: SAP SD and MM module, IDOC, BAPI, SAP BW, SAP CRM, Siebel and

Oracle apps

Web Tools: HTML, XML, WSDL, Web services, VB scripts and SSL

Databases: Oracle, SQL server, TeraData and DB2

Operating systems: Windows, DOS, UNIX, LINUX and Mainframes

Methodologies: WebSphere Architecture, SOA Architecture and J2EE Architecture

EDI standards: X12, EDIFACT and HIPPA

Page 1 of 8

PROFESSIONAL QUALIFICATION

Diploma in Computer Science 1990-1993

Bachelor’s degree in Computer science (BS) 1993-1996

Wipro Technologies Sep 2005 – Present

CONTINOUS EMPLOYMENT

Infinite Solutions May 2005 - Aug 2005

Panasonic North America Feb 2003 – April 2005

Miracle Software Systems May 1997 – Jan 2003

PROFESSIONAL TRAININGin EDI Mercator Integration tool in design, development and

• Trained and certified

implementing the interfaces to different Enterprise applications.

• Trained and certified in Webmethods Integration workshop.

PROFESSIONAL EXPERIENCE

Charming Shoppes Inc, Bensalem, PA Feb 2009 – Present

Lead Architect/Technical Lead

Environment: IBM WebSphere Message Broker, IBM Websphere Application Server, IBM

MQ series, Mainframe, Teradata, SQL Server, DB2, Oracle, Web services and eCommerce

W orking as a lead architect and technical lead for Charming Shoppes to replace the existing

ecommerce application and Warehouse application in Distribution center from old integration

environment having MetaStorm and Commerce Quest with WebSphere Message Broker 6.0 and

MQ series.

My responsibility includes:

• Analyzing the current environment, analyzing the business and filling the gaps with the

new environment using IBM Message Broker.

• Propose the alternative solutions for the area where an IBM Message Broker component

doesn’t fit by researching with multiple vendors and get reliable and scalable product to

fill the gap.

• Provide a strategy and the timeline for replacing the current old integration environment

with IBM Websphere Message Broker environment.

• Also visualize the future and provide the solutions for improvement in the environment to

ESB platform with very less impact to the current design.

• Started re-platform project design by identifying the phases and start working on each

interface schematics and do transition from old platform to new platform with different

phases.

• Interfaces include file layouts, Integration with Oracle and DB2 relational databases,

W ebServices.

• Proposed One Exception handling Interface for the whole enterprise which goes through

IBM Message Broker and provide notifications to central systems to operators. This

minimizes handling of multiple organizations exceptions in different formats when needs

training and specialists for each application.

Achievements:

• Charming Shoppes had improved the sales capacity because of the real time integration

from ecommerce to the Distribution centers from their batch interfaces before

• The customer online status is real time

• Using IBM Message Broker solution and designs proposed the company gained in

productivity.

• Few Mainframe batch solutions converted to real time interfaces

Page 2 of 8

XEROX CORPORATION, Rochester NY March 2007 – Feb 2009

Senior IBM WebSphere Consultant

Environment: IBM WebSphere Message Broker, IBM Websphere Application Server, IBM

MQ series, Datastage TX, Web services, Oracle ERP, Siebel CRM and SAP ERP

Working as a Senior IBM WebSphere Message Broker consultant for XEROX CORPORATION in

Enterprise Business Integration Group for all integrations using IBM suite tools WebSphere

Message broker, Websphere Application Server, MQ series, Datastage Tx, web services with

Oracle, Siebel and SAP as back end enterprise applications and also involved in architect,

design, develop and implement and support the interfaces.

My core activities and responsibilities include:

• Responsible to design, develop, test and build deploy the message flows successfully in

the Integration competency center group using IBM Message broker tool kit and Broker

Administration tools.

• Developed different types of integration flows which consist of different nodes like

compute nodes, filter node, mapping node, MQ Input, MQ Output, Trace node, Try-Catch

node, HTTP input, HTTP request, HTTP reply nodes and more developing with ESQL.

• Handled all the exceptions using try catch blocks and writes all the key information from

the transaction entries to DB2 database for auditing.

• Used trace nodes and debugger to debug the error in the message flow

• Integrations are done for point to point, web services, publish and subscribe scenarios

with mainframe, Oracle, Siebel and legacy applications.

• Designed and developed EDI X12 transactions 810 and 856 interfaces using Datastage

Tx and uploaded into IBM Message Broker application as plug-in.

• Very good knowledge on managing full implementation project and leading the team

using different Metrics tools Risk management, Cost management, Quality management,

Time management, Scope management tools.

• Interacts across several organizations and involves in discussions on the requirements to

fill the gap analysis between the functional and technical specifications.

• Day-To-Day management with the team including providing technical guidance and do

the break fix's to the production flows.

• Analyzing, Design high level architecture, developing solutions, create the semantics

designs, build the technical requirements for all individual solutions.

• Communicate with the customers to get the requirements and convert the requirement

documents from functional specifications and technical specifications.

• Responsible to manage and compliance for all the standards in the Xerox to maintain the

software development life cycle implementations

• Integrated solutions using JCA and WBI adapters like JDBC adapter (for Oracle and

DB2), JMS adapter, SAP adapter, IMS mainframe adapter, WebServices, XML and JAVA

• Resolving all the technical issues in the team and review the documentation at every

phase of the development life cycle and deliver deliverables in time.

• Extensively used MQ series to connect between the applications and supported as a

consultant to the other business organizations to setup the MQ series in their

organization.

• Excellent exposure of creating channels between MQSeries servers, implement the

certificates using SSL and implement firewall rules at the gateway for more security.

• Responsible for Production support round the clock and break fixes for the production

issues.

• Used Message Broker flows to integrate with WebServices, JDBC, JTEXT, MQ Series,

Siebel, SAP, Mainframe application and other legacy applications.

Page 3 of 8

• Involved in full upgrade implementation for IBM MQ 6.0 to MQ 7.0 and WAS 6.0 to WAS

7.0.

Weyerhaeuser, Seattle, WA Sep 2005 - Mar 2007

Middleware Integration Specialist

Environment: IBM WebSphere Message Broker, IBM WebSphere Application Server, IBM

MQ Series, Web Development, DataStage TX and WTX

Serving as an Integration Specialist and Integration Analyst roles in Enterprise Integration group

and responsible to plan and implement migration from Mercator maps to WebSphere Message

Broker flows and Datastage TX, all technical and functional resolutions, maintenance and

installation supporting to different enterprise applications like Bann, PeopleSoft, JD Edwards,

Oracle, SAP and web development. Also involved in the business management role to provide

project estimation, schedule kickoff meetings, do a requirement gathering for new businesses,

recommending and give good functional and technical suggestions where there will be a value-

add in the design and coordinate in suggestions on implementing with better performance and do

production, infrastructure and application maintenance.

• Working as a key person in developing and implementing the migration project from

Mercator interfaces to IBM Message Broker and Datastage TX.

• Working closely with the business groups, external customers and development teams

and suggesting the way to develop the integration services which can be reusable with

different trading partners.

• Responsibilities include for both B2B and A2A applications to create architecture

definitions, software specifications and design activities, including the writing of the

requirements and design documents. Translated business needs into technical system

solutions.

• Developed some Critical Pre processor, Post processor and routing flows services which

will use the Publish and subscriber method to route the data. This increase the

reusability of the interface to many subscribers for the same solution with very less

development cost.

• Used XML canonical documents to translate the source data to common message format

and then map it to different applications which will give very less impact on any trading

partner application changes and good for Production support.

• Extensively used ESQL all the nodes functionality from the message broker and

deployed all the migrated flows to the Solaris environment.

• Setup the failover infrastructure and disaster recovery environment with no impact to the

customers interfaces with very less downtime.

• All the interfaces are been re-developed through the message broker flows uses

W ebServices, JDBC adapters, JTEXT adapters and Mainframe using IMS bridge

adapter.

• Responsible for the production support and application maintenance of the interfaces

developed by the integration group using WebSphere Message Broker and WebSphere

Process Server.

EAI Technical Lead June 2002 - Aug 2005

Panasonic North America, New Jersey

Environment: Mercator 6.5 SP2, Mercator 6.7 SP1, DataStageTX 7.5, AIX Version 4, AIX

Version 5.1, AIX Version 5.3, UNIX, Windows 2000, MQSeries 5.x and Webmethods 6.1

Panasonic Corporation of North America is a fortune 500 company engaging in manufacturing,

sales and service of various consumer and industrial products around the world.

Page 4 of 8

• Working as an EAI/EDI specialist in the Panasonic EAI/EDI PMIT team, with

responsibilities including the Project proposals, Project estimation, resource

loading, Specification designs, development, testing, implementation and upgrade

of EDI/EAI data for different companies PIC, PCEC, Warehouse, FPS, DELTA and

Import system to support electronic transfer documents such as purchase order,

Invoices, shipment notices, ASN, Goods Receipts for their trading partners.

• Integrated the application systems like SAP, Data Warehouse management system

SARA (Legacy), Sales system PASC in AS400, Nextlinx project using XML, Maintaining

MQ-Series data, handling all preparatory structure design, Specifications design,

Development and implementation and deploying systems in AIX/UNIX box.

• MQ Series is the communication channel for all the interfaces I designed and developed

in Panasonic.

Responsibilities and duties involved in architecture design, project design estimation,

Specifications designs, maintaining infrastructure, development, testing, implementation,

and production support.

Extensively used Unix Shell script programming for Legacy systems design to create type tree,

Cobol Importers, XML DTD importer, SAP IDOC importer, Resource Registry and MQ Series on

AIX UNIX box.

I am involved in design, development and Implement 5 live implementation from start to end and

also involved in production support for these interfaces.

• Worked on 810, 820, 830, 850, 855, 856, 860, 990 and 997 EDI transaction sets

interface from SAP R/3

• Created a complicated router maps which reads any message for all interfaces from

MQ Series and redirect the input data to the specific location directories, where particular

map will get triggered automatically, and also handled exceptions, store them in errors

directory and also send PAGER message and E-mail message with details of the error to

corresponding person.

• Designed and developed a mapping interfaces for SAP Customers DEBMAS05 IDOC,

Material MATMAS03 IDOC, BOM BOMMAT03 IDOC, Sales order ORDERS05 IDOC,

Inventory management ZSARAIM01 custom designed IDOC, Delivery note DELVRY03

IDOC, Goods Receipt and Goods Issue WMMBID02 IDOC to a legacy system which is

using ORACLE database for SARA through MQ Series and vice-versa. The Legacy type

trees designed with COBOL programming.

• Developed interfaces supporting different business in the company to share the data in

real time.

• Supported to the EDI PROD team to resolve many critical data related issues.

Mercator EAI Consultant Jul 2001 - May 2002

Menasha Corporation, Appleton, WI

Environment: Mercator 6.0, IBM mainframe system and Windows NT.

As a member of the Development Team, worked on the following out sourced Project Mercator is

used for mapping the EDI document and their Mainframe system. Made extensive use of COBOL

Copybook Importer, XML adapter, COM adapter, FTP adapter and DB adapters.

• Worked with Integration Flow Manager, Event Server and Database Interface designer to

extract data from the Database using Store Procedures and updating and adding the

data in the Output Database.

Page 5 of 8

• Mapped the 810,850 and 862 EDI data into the XML format by using the XML adapter.

• Created XML DTDs for the EDI transactions.

• Used MQSeries for transferring the files from the Bulletin board system to OS/390

system.

• Designed type trees for the COBOL copy files by using Type tree wizard. And utilized

these trees to develop several maps which basically communicated between the

Mainframe system and SQL-server database.

Sr SAP / Mercator developer Jan 2001 - Jun

2001

Kimberly Clark Corporation, Appleton, WI

Environment: Mercator 5.0, SAP 46B, Windows NT and UNIX

Work as a member in an MRP Interface Team where they integrate their legacy system to SAP

through PAPS and Mercator. Main role is to create new Mercator maps and BAPI function

modules, to get the data through to SAP from Mercator BAPI adapter. In this interface team I

also worked on User exits and also worked on LIVE INTERFACE program designed by Intel

Corporation and also working as a production support issues.

EAI Consultant Apr

2000 - Dec 2000

Delphi Automotive, Troy, MI

Environment: CrossWorlds, SAP 46B, Lotus notes, Windows NT and UNIX

Working as a Part of VEGA Team, Involved in Developing Interfaces, which Integrate the real

time integration with IBM Mainframes data with SAP 4.6B, working with technology connectors

like JText and Email. Application Connectors like SAP46. Used Data Handlers to read data from

Legacy System to SAP by using JText Connector and SAP46 Connector. And also Used Test

Director to test the whole scenario and is also used as a testing tool for Unit Test Plan. For

mapping used CrossWorlds mapping tool and also used Mercator 5.0 mapping tool for

cross-reference and comparing the performance of the system.

As a part of my job I had developed the following objects.

Inbound Inventory Adjustments Interface: Created an SAP46 Business Object, which uses

Transaction code MB1A or MB1B and posts data into SAP4.6B by populating the Data

into an IDOC structure YXRIAD01. This interface uses the IDOC Handler and a

function module to fill data into IDOC structure and posts into SAP.

Mercator Consultant, June 1999 -

Mar 2000

General Motors, Detroit MI

Environment: SAP 4.0B, Mercator 5.0 and Windows NT

As a Mercator consultant involved in the design and development of a prototype for integration of

Legacy Systems for General Motors with the web enabled systems of their Vendors.

Demonstrated the integration of the following Systems using Mercator 5.0:

• SAP ALE to MQ Series

• MQ Series to Flat File

• Text File to E-mail

• Commerce One Procurement software to MQ Series

Page 6 of 8

Worked on the following Interfaces using Mercator 5.0, R/3 ALE, IDocs, Mercator Type

Trees, Maps, R3 ALE Adapters, IDOC Importer, DB Editor, System Editor, Mercator

Launcher for data mapping and integration

• BOM creation with Alternatives (Inbound, IDOC: custom)

• BOM changes (Inbound, IDOC BOMMAT01)

• Material Creation and Changes (Inbound, IDOC MATMAS02)

• Material Request from SAP to Legacy (Outbound, IDOC ALEREQ01)

• EDI 850 (Outbound, Purchase Order)

SAP Consultant, Sep 1998 - May

1999

Bacton Dickinson, Paramus NJ

Environment: SAP 45B, W indows NT and UNIX

As a SAP Consultant involved in working in Conversions, Interfaces and reporting and used

Mercator 5.0 to convert the IDOC data into a fixed format required by Legacy system.

Data transfers:

• Developed an interface, which reads the data from EXCEL file and populate this data

to the SAP by using the transaction code f-02. Before calling this interface, the

program checks for the accuracy of data by summing of debits and credits. If the total

is zero then the process should be continued.

• Developed an interface for preprocess the Excel G/L upload file from cash

Management. The Program will determine the corresponding clearing account for

each cash account transaction based on the transaction type. The Preprocessor will

transfer this to a Unix file.

• Developed a program to create a sequence file as expected by direct input standard

program RMDATIND, which is used to upload the material master data coming from

Legacy system in an Excel file. All the sessions are scheduled to execute on Friday

evening. All error records are trapped and processed later.

• Loaded the Accounts Receivable and Accounts Payable using call transaction for the

transaction F-22 and F-43 respectively.

ABAP/4 Programmer Nov 1997 -

Aug 1998

Client: SDA Tissue, WI

Environment: SAP 45B, W indows NT and UNIX

Was part of a Major SAP R/3 Implementation as an ABAP/4 Programmer, Responsibilities

include coding and analysis of ABAP/4. Writing reports, User enhancements and coding BDC’s in

SAP modules FI and SD. Was also responsible for the development of several dialog

Programming modules for the Warranty System.

• Worked in dialog programming to build a grind end screen to the sap end users and

data interfaces BDC programs to upload the legacy data in to the system tables for

the SD module.

ABAP/4 Programmer Aug 1996 - Oct

1997

Client: L & T Welding Electronics, India

Environment: SAP 45B, W indows NT and UNIX

Page 7 of 8

As part of the job was involved with the Design / Modification of Several ABAP/4 reports, Layout

Sets, Data Interfaces in the SD MM and FI modules.

Reports:

Involved in writing several Report Programs in the areas of SD and MM. A few of them are as

listed below.

• Created an interactive report to list all the customers who are active and inactive

(deleted) from company list for a specific company code or in all areas and drilled

down to get more details of particular customers.

• A report to print address of a particular employee and the corresponding payment in

one selection using interactive reporting. And had also developed to get the payment

details for monthly, by weekly and weekly to the date specified by the user during run

time.

Data Interfaces (BDC):

Coded ABAP/4 programs for batch data communication by classical method. And also used

standard SAP programs to upload legacy data.

• Developed an ABAP/4 conversion program for the updating Customer Master

Using standard program RFBIDE00. The data has to be checked prior to updating in

the Customer master. The sessions created were processed using RSBDCSUB.

• Created an ABAP/4 program to extract data for explore Bill of Material from SAP and

the flat file is stored at application server. The flat file generated is send to the

production department for further evaluations.

Page 8 of 8

Contact this candidate