QA Analyst/ Developer

SAP PI Consultant

Full name: JIE GUO

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

SAP Netweaver PI Consultant having 6.5 years of IT experience, presently working as senior SAP Netweaver PI consultant and having 4.5 years in Netweaver PI and 2 years of experience in J2EE.

SAP Skills:

• 6.5 years of industry experience with the last 4.5 years dedicated extensively on SAP NetWeaver XI, SAP NetWeaver Process Integration (PI), and application development using JAVA.

• Having very good knowledge in System Landscape Directory (Software catalog, Technical and Business Systems).

• Configured XI for communicating with SAP, Non-SAP, Legacy system and Databases.

• Expertise in configuring ESR and Integration Directory.

• Experience in creating Data types, Message types, Message interfaces, Message and Interface mapping, Communication channels, Receiver/Interface determination. Experience in using Graphical mapping and XSLT mapping

• Excellent understanding and working experience with the XI/PI pipeline processes including Sender Agreement, Receiver Agreement, Interface, and Receiver Determination

• Expertise in SOA architecture and EAI technology.

• Expertise in developing the large complex architecture scenarios using SAP PI 7.1.

• Good Experience in SAP PI Development and Production Support.

• Expertise in working in all SAP PI monitoring tools.

• Hands on experience in SAP XI/PI adapters like File, RFC, IDOC, JDBC, JMS, HTTP, SOAP, Mail, Client/Server ABAP Proxies and Cross Applications like ALE, IDOC’s, RFC.

• Expertise in EDI interfaces development.

• Hands on experience in Graphical, XSLT and JAVA mapping, module deployment technologies.

• Expertise in Different Monitoring techniques such as Message monitoring, End to End monitoring, Component monitoring.

• Experienced in SAP Upgrade of XI 3.0 to PI 7.0 and PI 7.1 Version

• Experience with PI 7.1 Enhancement Pack 1.

• Experience on various BPM integration scenarios.

• Experience on JAVA Proxy development and deployment

• Expertise in Adapter Framework, Adapter Configuration, Alert Configuration (CCMS alerts), cache monitoring, queue monitoring, troubleshooting and proxy runtime.

• Hands on experience in Web Services, SOAP, HTTP Protocols and R/3 Workflow.

• Expertise in writing User Defined Functions, Alert configuration.

• Expertise in work with SAP ECC modules: SC, HR, FICO.

• Extensively involved in systems Study, Analysis, Debugging, and Performance Tuning.

• End-to-End Monitoring, Performance Monitoring and Cache Monitoring

• Alert Monitoring and triggering Alerts

• Adapter Monitoring and Trouble Shooting

• Excellent communication skills, leadership qualities, Systematic approach and ability to work effectively in fast Paced environments.

JAVA

• Extensive experience in developing scalable, reliable and efficient enterprise applications using in JAVA and J2EE Technologies

• Expertise in developing web applications using Java, JSP, Java Scripts, JDBC and XML. Strong Knowledge of Object Oriented Design and J2EE.

PROFESSIONAL EDUCATION

Master of Software Engineering from ShangHai JiaoTong University, China

Bachelor of Computer Science and Technology from East China Normal University, China

TECHNICAL EXPERIENCE, TOOLS AND METHODS

SAP

SAP ABAP, Netweaver XI 3.0, PI 7.0 & PI 7.1

SAP WAS 6.40

XML

Functional Knowledge of XML (Schemas & DTD)

Fluent in WSDL, SOAP, BPEL4WS, XPATH, XSL & related transformation technologies (XSLT, DOM)

Operating System, Application Servers & Databases

WIN2K/NT & XP

SAP J2EE Web Application Server, IBM Websphere, Tomcat

Oracle 9i, SQL SERVER 2000, DB2, Sybase, Derby

IDE & SDK’s

SAP Neweaver Developer Studio, IBM Websphere Studio Application Developer

Altova XMLSPY, Stylus Studio, Eclipse, J2EE 1.4 SDK

Employer Address From Date To Date

Value Consulting 13800 Coppermine Road, Suite 178, 1st Floor,

Herndon, VA 20171

703-***-**** August, 2011 Present

Infosys Technologies Ltd 6100 Tennyson Parkway,

Plano TX 75024

469-***-**** May, 2005 July, 2011

PROJECT 1-- Kraft SAP PI Upgrade Project

Client : Kraft, Missouri

Role : SAP PI Lead

Duration : Jan 2012 to till date

Software : SAP PI 7.0, SAP PI 7.1, SAP ECC

Project Description:

Client has hundreds of interfaces across different process areas developed based on SAP PI 7.0 in the past few years. Since the new version of SAP PI with lots of new features has widely implemented in the market, clients decides to upgrade the SAP PI system from 7.0 to 7.1.

This is a short project with high volume of interfaces transportation. Interfaces needs to be evaluated and tested through new SAP PI environment with proper configuration changes quickly. The coordinating work among different functional teams, technical teams, basis teams, security teams and testing teams should happen efficiently to meet the schedule.

Roles & Responsibility:

Senior PI consultant Activities:

• Coordinating with SAP PI testing team, technical teams and Process teams to test interfaces in upgrade SAP PI environment

• Coordinating with process team to get test data

• Offer solutions to upgrade implement issues to the client

• Review configurations changes in upgrade SAP PI environment

• Prepare daily reports of the project progress to project manager and client.

PROJECT 2-- Monsanto Migration Integration Project

Client : Monsanto, Missouri

Role : Senior PI consultant

Duration : August 2011 to December 2011

Software : SAP PI 7.1, SAP ECC

Project Description:

Monsanto has multiple divisions of Information Technology which work in conjunction with each other to provide the complex business function. Monsanto already had the integration solution based on Oracle OSB. While to suit the large scale of SAP solutions implementing, Monsanto was looking for the solution to integrate with wide range of SAP and non-SAP systems within and outside the organization’s boundaries based on the reliable technical infrastructure. And this solution should be flexible to suit the quick business and IT change.

This migration project was planning to replace Oracle ESB solution in the progressive way. Short life cycle of development requires different teams working together in a more effective way. Multiple middleware tools -- SAP PI, Oracle ESB and CRM middleware were involved in integration among applications (A2A) and business to business (B2B). Hundreds of interfaces covered the SD, FI, HR, PP, BI, CRM, PM areas.

Roles & Responsibility:

Senior PI consultant Activities:

• Analyze Requirements Specifications by thoroughly studying the Functional Requirements

• Finish Technical Specification/unit test document/code/support document

• Manage develop process (documentation, transport etc) with SAP solution manager

• Develop and test for EDI interfaces (832 Price/Sales Catalog, 860 PO change, 855/865 PO Acknowledgment)

• Discussing and coordinating with third party system/legacy system/SAP folks to resolve issues during development, testing and deployment phases.

• Alerts creation and configuration.

• Helped in SLD configuration issue found among different PI environments

• EOIO configuration for some of the interfaces

• Review PI codes for other team members

• Provide resolution for performance issues or common design issues found in testing

• Helped in development of complex mappings and Adapter modules.

PROJECT 3 -- 212 AppDev Technical Integration Project

Client : Sysco, Texas

Role : Technology Lead

Duration : January 2011 to July 2011

Software : SAP PI 7.1, SAP ECC

Role : Senior PI consultant

Duration : February 2010 to December 2010

Software : SAP PI 7.1, SAP ECC

Role : SAP PI Developer

Duration : September 2009 to January 2010

Software : SAP PI 7.1, SAP ECC

Project Description:

Client’s Business transformation and SAP implementation is designed to offer features that should greatly improve service to customers, suppliers, and employees. The project is designed to establish common business processes and one IT platform to help leverage size and scope to improve productivity and efficiency in the following areas:

• Standardization of business processes across all Business units based on industry best practices

• Reliable data to improve decision making and to speed service levels through more accessible and accurate information

• Simplification of the IT landscape/architecture to significantly reduce the number of IT systems

• Technology, tools, and standards that will make it easier for customers and suppliers to do business.

The project involves development of interfaces in 4 major process areas like FI, SC, MD and SM - using SAP PI 7.1 and See Burger BIS for integration of SAP with various systems of its business units and partners. Interface development involved integration among applications (A2A) and business to business (B2B). Interfaces in B2B area comprised of complex EDI scenarios catered through both PI and BIS.

Roles & Responsibility:

Technology Lead Activities:

• Team supervision, analyzed the individual performance of the team and motivated them to perform even better.

• Handle schedule and process for project across develop, integration test, dress rehearsal test and go-live phases and ensure the project quality.

• Organized training for client.

• Prepare weekly reports of the project progress to project manager and client.

• Offer solutions to the top management regarding project related queries; Technical and Functional assistance to the team.

Senior PI consultant Activities:

• Analyze Requirements Specifications by thoroughly studying the Functional Requirements

• Review Technical Specification/unit test document/code/support document

• Discussing and coordinating with third party system/legacy system/SAP folks to resolve issues during development, testing and deployment phases.

• Alerts creation and configuration.

• Helped in SLD configuration issue found among different PI environments

• High Priority queue and EOIO configuration for some of the interfaces

• Provide resolution for performance issues found in testing

• Helped in development of complex mappings and Adapter modules.

• Involved in Transports of interfaces from Development to Quality/Staging/Production environments.

• Maintain the codes synchronize among different environments with different develop life cycles

SAP PI Developer Activities:

• Preparation of the Technical specifications.

• Preparation of mapping logic for the complex mapping

• Design the objects using Integration Repository

• Configuration of the designed objects using Integration Directory

• Worked with JDBC, SOAP, HTTP, RFC, IDOC, FTP and File adapters and Proxies

• Monitoring of messages, components…etc using RWB

• Preparation of UTP for the developed interfaces

• Communicate with onsite team for design issues

PROJECT 4-- Syngenta Migration

Client : Syngenta

Role : SAP PI Developer

Duration : February 2009 to August 2009

Software : SAP XI 3.0/SAP PI 7.0, SAP Netweaver Developer Studio, SAP R/3 4.7, SQL Server

Project Description:

This project is to create a system that is compatible with existing and newer technologies, and offer more flexibility resulting in improved efficiency. SAP PI is chosen to replace SeeBeyond as its standard for integration to deliver a large volume of interfaces in a short period of time while following standardized quality processes to meet unexpected business demand.

This project will focus on the data which needs to be updated in the Datawarehouse (DWS) application from Pivotal by SAP PI product.

Roles & Responsibility:

• Developed generic reusable Java proxy code to resolve complex process with DB

• Developed complex mapping logic(JAVA mapping is used)

• Helped in SLD configuration issue found among different PI environments

• Preparation for Unit Test plan and Support document

• Communicate with India offshore team and US/ Switzerland onsite team.

• Provide Java Proxy/NWDS training to China team, India offshore team and US/ Switzerland onsite team.

PROJECT 5 -- Syngenta EAI Implementation

Client : Syngenta

Role : SAP PI Developer, Module Lead

Duration : June 2008 to January 2009

Software : SAP XI 3.0/SAP PI 7.0, SAP R/3 4.7, SQL Server, SOAP UI, IPM+

Project Description:

This project is to create a system that is compatible with existing and newer technologies, and offer more flexibility resulting in improved efficiency. SAP PI is chosen to replace SeeBeyond as its standard for integration to deliver a large volume of interfaces in a short period of time while following standardized quality processes to meet unexpected business demand. The process has been used to deliver over 20 projects and 200 interfaces over a period of one year. Except developing, we have taken on additional responsibility like requirement gathering, Level 3 support etc.

This project involved the process of integrating SAP R/3 system with Existing Legacy systems spread across multiple locales using the SAP PI product. The project involved SAPCOMM interfaces; between BPCS and SAP interfaces, between BPCS to Reporting System.

Roles & Responsibility:

• Analyze the requirement of different interfaces

• Preparation of Technical Specification document for each interface

• Preparation of mapping logic for the complex mapping(XSLT’s used)

• Design the objects using Integration Repository

• Configuration of the designed objects using Integration Directory

• Worked with JDBC, SOAP, HTTP, FTP and File adapters

• Prepare Unit Test plan and Support document for developed interface

• Transport of interfaces from Development environment to QA environment.

PROJECT 6 -- Social Issue Data Migration

Client : ISS

Role : J2EE Developer, Configuration controller

Duration : June 2007 to February 2008

Software : Rational Rose, Websphere Studio Application Developer, SQL Server, VSS, Access, IPM+

Project Description:

This project is to carry out the data migration activity of the social issue from the existing access databases to a new SQL Server database, the consolidated database used for capturing social issue. In addition we will be involved in rewriting the portfolio screener feed from one database to another.

This project just focuses on database part, analyzing the different database structure between access databases and the new SQL Server database, writing the store procedure to perform the requirement.

Roles & Responsibility:

• Analyze the data in access databases and finish data mapping.

• Write and test store procedure to perform data migration.

• Finish requirement traceability, test cases documents.

• Configuration management for the whole project.

PROJECT 7 -- Data Masking Project

Client : Citi Group

Role : Developer

Duration : November 2006 to June 2007

Software : SQL Server, Oracle, DB2, Sybase, CVS, Eclipse

Project Description:

This project is based on Swing framework; the aim is to develop a tool to mask data before outsourcing it to offshore to resolve the data security and protection problem. We use the algorithms which is fast, effective and comprehensive.

The tool provides flexibility to:

-Configure rules for masking test data.

-Apply the rules to multiple test datasets.

Roles & Responsibility:

• Design for the masking rules on SQL Server data part, persistence of data masking part and report generator part.

• Coding and testing the masking rules on SQL Server data part, persistence of data masking part and report generator part.

• Communication with India team with work transfer.

PROJECT 8 -- NAO

Client : BCM Solution Team

Role : Developer

Duration : July 2006 to October 2006

Software : eForms 5.0, eForms Designer 4.0,FileNet Capture, FileNet Content Services, CVS

Project Description:

Design forms in eForms Designer or import files with scanner and then use them finish a workflow, also integrating these forms with j2EE environment.

Roles & Responsibility:

• Research for the installation of FileNet, eforms, capture and content services.

• Research for how to use the capture, eforms, content services and FileNet, and how to let them work together.

• Communication with India team for project collaboration and knowledge sharing.

• Implement the configuration management for the whole project.

PROJECT 9 -- BOFA

Client : Bank Of America

Role : J2EE Developer

Duration : November 2005 to January 2006

Software : Eclipse, Tomcat, VSS

Project Description:

This project is aiming to implementation a compliance program effectiveness indicator. This indicator is an index of metrics aligned to the Seven Elements of the Bank of America Compliance Program, a measure of compliance health and is reported quarterly for the major LOBs and some business units.

This project is based on J2EE architecture with Struts and hibernate.

Roles & Responsibility:

• Coding for adding, changing and deleting metric type parts.

• Unit test for utility methods.

ADDITIONAL Skills/Training

RDBMS : Oracle 9i, Sybase, DB2, SQL Server, Access, Derby

Operating Systems : Windows.

Query & Reporting : PL/SQL.

Internet Technology : HTML, XML, WSDL.

Others : JAVA and XSL Transformations.

Contact this candidate