Profile

SAP NW PI/XI Consultant with 7 years of experience in Software Development and 6+ years in SAP design and development as Techno-Functional with emphasis on PI/XI, ABAP, HR ABAP, and IDOC including multiple full lifecycle project implementations. Highly proficient team player. Have extensive experience working with applications comprising of EAI, A2A, B2B and SOA.

Technical Skills

ERP:

SAP R/3 Version ECC 6.0/5.0, 4.7E , 4.6C ,4.5B, HR, FI , MM, SD, CO.

SAP Technology:

ABAP Workbench, Data Dictionary, Workflow, Reports, Interfaces, Conversions, Exits, BAPI, BAdIs, EDI/ALE, RFC and Idocs, OSS notes.

Netweaver Components:

SAP Exchange Infrastructure NW 2004s, Netweaver
Development Studio (NWDS), NWDI CMS, XMLSpy.

Third-party Adapters:

Seeburger, iWay.

Databases:

Oracle 11g/10i/8i/9i, DB2, MS SQL Server, MS Access, MySQL.

Other EAI Products :

BizTalk Server 2006/04.

Programming Languages:

ABAP, HR ABAP, C#, VisualBasic.Net, ASP.NET, ADO.NET, XML, XPath,
Java, JavaScript, HTML, SOAP, SQL, T-SQL and PL/SQL.

Operating Systems:

Windows XP/2000/NT and UNIX

Education

Master in Computer Applications.

Experience

Confidential,Dallas, (TX)(Onsite/Offshore Co-ordination)through K2 partnering Solutions.
Role : SAP PI 7.0 / ABAP Consultant. Feb’ 09 – Till Date
Description: To implement and sustain an integrated global Human Resource Management (HCM) and Financial (FI) system that will support Enterprise financial and human resource staff in the delivery of services and activities, take advantage of best practices, and significantly improve the efficiency and effectiveness of the Enterprise’s administrative processes.

ABAP-WebDynpro:

• Involved in design and development of SWA Tax Compiler for posting Non Sap Data to Vertex.
• This Non SAP data could be either sale from SKY-MALL, Liquor sales etc, from flights.
• Previous approach to calculate tax for this data was through Konfabulator used by Gran Thorton,

This approach of using Excel Sheets was against the development standards of SWA.

• Hence a Web-Based User Interface is been developed for Users in order to post documents to vertex (External Tax ware) for Tax calculations.
• Uploading of documents was done through Manual entry (using Table) or File Upload.
• In case of any errors, Posted document to vertex should be reversed back through Compiler.
• All the documents that have been posted to vertex will be saved to Custom Database table, so that duplication of upload’s and reversals can be avoided.

ABAP-Interfaces:

• Worked on Design and development of Global Template for sending Vendor Details to Five systems (Ariba, Wizard, Solarc, E-Commerce and Invoice Works) within the same interface using IDOC (Cremas) to File. Also a single vendor can be selected and sent to these 5 systems anytime when a particular vendor is errored out of a full file.
• Worked on Design and development of receiving Purchase orders from Ariba and Wizard using IDOC (Pordch) from File. In order to keep track of errored idocs we had to develop a custom program which will be scheduled to run every day after the interface is ran to get error idocs, which will be sent to legacy systems (or) manually correct the idocs and repost them again.
• Worked on Design and development in sending Benefit Information of employee and dependants to Aetna, BlueCross BlueShield, Delta Dental and Spectera using IDOC (Benrep) to File (834 Format).
• Worked on Sending Wire Payment data to CITI Bank by using Custom code for developing required TIF-LS by Citi Bank. TIF-LS as in Transaction Instruction File – Lite Streamlined is built upon the EDI 820 STP format and is a stripped down version of their MasterCard Transaction Instruction File (TIF).
• Worked on design and development of receiving invoices from CATTS and CRAS by using IDOC(FIDCC2) and File. Also worked on Error handling strategy by working on custom code which will be ran every time the interface will be ran so that all the errored out idocs can be reprocessed again.
• Worked on sending employee and dependant information including their insurance plans, benefit data, Payrolls, Hire dates and Termination dates to Access Database.

ABAP- Enhancements:

• Worked on sending additional fields to vertex while posting Purchase Orders (MIRO) and Invoices (FB60). Since vertex was new tax ware that SWA (Southwest Airlines) will be using here after, they wanted to send additional information to Vertex while PO’s and Invoices are posted.
• Vertex was configured with Flex fields, which are mapped to RFC_UPDATE_TAXES_DOC(FM) ,

The only function module used to post documents to vertex.

• Every time a Invoice or P.O is posted to vertex, User Id (SAP) of the posting person, Document type, cost object (Cost center, WBS, Internal Order), Profit Center, Commodity code etc, were posted to vertex along with taxes.
• Logic was implemented to compare between a Po and Invoice within the User exit to post appropriate data.

ABAP- Forms:

• Developed Adobe Interactive forms using WebDynpro for Java.
• Developed Interactive forms for the following requirements.

- Planning Career Development
- Organization Profile
- Position Profile
- Job Profile

PI- 7.0 – Configurations:

• Involved in working with the basis team for configuration of XI systems.
• Involved in requirement gathering and finalizing the specifications.
• Worked on System Landscape Directory by designing and creating technical and Business Services in Coordination with Functional teams.
• Worked on ALE Configurations of IDOC distribution lists.
• Worked on maintaining partner profiles and Logical systems wherever required in all the environments (Dev, QA and Prod).
• Worked on configuring the channels while setting up Adapter Engine.
• Defining Alert category of each module in HR and Finance so that each interface can use alerts belonging to their own division.
• Worked on designing PI Naming Conventions and PI development standards documentation in coordination with SWA.

PI- 7.0 – Interfaces:

• Developed generic structures for use in several interfaces utilizing industry standard of HR-XML like Indicative Batch and Timecard Batch.
• Developed an Inbound interface to post Purchase Orders (FI) from Ariba and Wizard applications to SAP through IDOC Receiving Adapter.
• Developed an outbound payroll interface to send payroll data (HCM) to multiple FI SWA (Southwest Airlines) affiliates like JPMorgan, Citibank.
• Developed an interface to send Fixed Assets data (FI) for all types of reporting and analysis (State Sales Tax Audit reports, Federal Income Tax Depreciation analysis) through Client Proxy to Tax Department where tax calculations are implemented.
• Developed an Interface with Dynamic File Name Concept depending on the Depreciation area to send the Fixed Assets data to the Tax Department.
• Developed outbound interface to prevent fraudulent checks to be cashed inappropriately, the payer bank (JPMorgan) need to be informed daily of all the checks issued/voided in-house.
• Developed an interface to post payment file to Citibank to process payments to vendors using credit card evaluated time from SAP using IDOC (pexr2002).
• Developed alerts based on category thereby grouping different service categories.
• Developed an interface to post payroll results to SWA Webmethods server using HTTP Post.
• Developed an interface from FI using Client Proxy to send outstanding check details from SAP Accounts Payable and Human Resources to Chesapeake Unclaimed Property Compliance System.
• Implemented ABAP mapping to modify outbound interfaces to add custom namespace tags.
• Developed a report to monitor queues and email status of queues with any error status.

PI- 7.0 – Interfaces:

• Worked on implementing techniques like Multi mapping, changing the occurrence of idocs, ABAP mapping, etc. whenever required.
• Worked on Implementing User Defined Functions for generating Dynamic File name, adding leading zeros in front of text, performing calculations based on age etc.
• Worked on splitting of Payload (Idoc) in to two different files based on the payment method in Wire payment.

PI- 7.0 – Encryption:

• Worked on Encryption and Decryption of messages that are moving In and Out of PI.
• Southwest Airlines had few (35) third Party Vendors like JP Morgan, Aetna, Conexis, BCBS etc which uses Sensitive data. Hence the requirement was to encrypt data while sending and decrypt it while receiving File.
• Worked with basis in installing .Jar files from Advantco.Inc on PI Server to use Encryption.
• All Third Party vendors are given each Public key for receiving file from SWA for decrypting file, vice versa.
• Worked on discussing with third party vendors in explaining the process and Uses of Encryption.
• Discussing with all Third Party Vendors in sending encrypted files with their Public keys by using sign or Armor etc, based on requirement.

PI- 7.0 – EDI-X12:

• Worked on developing EDI – X12 standards for third party vendors like Blue cross blue shield, Aetna, Spectera, Delta Dental. All these third party vendors require their data to be sent in only X12-834 formats.
• Worked on generating TIF-LS layout for sending Wire payment to Citi bank.

PI- 7.0 – Java, XML, XSL, HTML:

• Worked on Java Custom development wherever necessary, during interfaces there are few requirements where we require generating dynamic File names using Java mapping, calculation of ages or other calculations.
• Custom development of XML / XSD formats for inbound Purchase orders, to change Xml structure of a standard IDOC PORDCH and to develop xsd for EDI (834) formats.

PI- 7.0 – Monitoring:

• Worked on Developing Alerts from Business service to business service instead of namespace, so that, configuring multiple alerts could be avoided, always involved in Monitoring Communication channels and Runtime Workbench.

Solution Manager - Documentations:

• Worked on SAP Solution manager in creating Nodes for differentiating between functional, basis, Security and technical team configuration documentations.
• Worked on documentations for Batch Job Templates and Encryption Templates, also writing technical specifications for the Functional Specifications.

Confidential,GA)(Onsite/Offshore Co-ordination) Confidential

Role : SAP PI 7.0 / ABAP Consultant. March 07 – Dec’ 08
Responsibilities include:
Worked on Interfaces between SAP systems to third party services, web applications for transferring data bi-directionally. Designed, developed and tested around 40 interfaces.
Analysis and Design:

• Involved in the Requirement analysis and Design phase of the integration scenarios simulating the business processes.
• Worked with customers to define strategies to restrict/limit development collision by namespace, software component version (SWCV), and imports of RFCs and IDOCs into SAP PI for SAP R/3.
• Adapters/Transformations:
• Configured various XI sender/receiver Adapters: JDBC, File/FTP, HTTP , IDoc ,XI , JMS , SOAP , Mail and RFC adapters.
• Created a UNIX shell script file which is being executed after the adapter execution for copying the CO Master Data file to BankOfAmerica secured location across the network.
• JDBC adapter being used for executing DMLs both inbound and outbound and for calling Stored Procedures.
• Custom Java Module Processor configured for sender communication channel to extract custom formatted excel files based on business requirements.
• Posting Cayenta invoices to SAP: Experience working on Conversion Agent document processor’s to convert the AP invoices for customer refunds posted by legacy system to SAP, from the binary PDF format to a text format which is further parsed to a definite xml structure in PI and posted using FB60.

Business Process Management/Mappings:

• Designed BPM to communicate with BankOfAmerica and Wells Fargo for transferring employee ACH structured payment files.
• Designed POC to establish interfaces to and from Maximo System.
• Correlation defined for collecting messages based on the error type for Unsuccessful invoice account postings for creating the alerts to send to the User groups.
• Hands on experience working on Java/ABAP/XSLT mappings, created user defined functions for applying business rules on the incoming messages by creating java archives.

SPROXY Objects:

• Implemented ECC Proxy class objects for SWCVs in ABAP R/3 and HR ABAP for initiating outbound transactions to PI and transfering data to ECC via inbound transactions.
• Outbound Scenarios from SAP - : Employee wage types , MM contracts and check data , GL cost data , Invoices data, Customers data,GL Chart Of Accounts, FM Budget data , Time catsdb time entries , Public Employees Retirement System (PERS) Demographics (DTL1) and Amount(DTL2) data , ING wagetypes for employees.
• Inbound Scenarios To SAP: VendorComplaince Data ,Refunds from Bliss , Invoices , work orders , Chart Of Accounts from BankOfAmerica.
• Implemented logic for Initial and Delta load for outbound extraction programs.
• Runtime Workbench and Alert Mechanism:
• Responsible for monitoring message queues for error alerts, and conducting the initial log reviews to provide the technical support staff an assessment of system issues
• Configuired Alerts and Email mechanism in BPM to notify Application and System errors to the User groups with Mail adapter and by calling function modules.
• Performance tuning, troubleshooting, debugging and monitoring in Runtime workbench and bug fixing.
• Worked with Basis Team to resolve unprocessed messages in qRFC and tRFC Queues.
• SAP and Non-SAP Systems integrated with XI:
• Non-SAP Ssytems :Worked with BankOfAmerica ,Wellsfargo , Maximo, ING , Cayenta , IBIS payroll sytem , public employees retirement systems (PERS) .
• SAP Systems: Developed interfaces to extract data from BI by creating Souucesytems and Infopackages which will be called from XI as RFC transactions.
• IDOC/ALE/BADI/FunctionModule:
• ALE Configuration : RFC destinations, Partner Profiles, Ports to send and receive IDOCs on both R/3 and XI systems.
• Worked on IDoc’s - GLMAST / COSMAS / DEBMAS / CREMAS master data and ACC_DOCUMENT for posting errors back from ECC.
• IDOC-JDBC scenario: IDoc generated and posted to XI for changes in the vendor and customer master (DEBMAS06 / CREMAS06) data and from which the data is sent to SQL Server systems. IDoc is triggered and sent over to legacy system when goods receipt is generated for purchase orders made.
• Extracting GoodsReceipts - Trigger Custom events in MIGO transaction BADI for post-document method which inturn will initiate a job. The job calls a proxy program to pull the created Purchase Order details.

Transports:

• Baseline a process for creating Tracks (for both repository and directory artifacts) in NWDI for PI transports across the landscape.
• Worked with Basis tem to develop CMS and CTS Transport mechanism and implement the transports of Repository and Directory artifacts to Quality and Production systems.

Testing and Support:

• Involved in full Integration testing cycle with users involved for ensuring seamless integration of the systems and provided post-go live support.

Confidential,
Role : SAP XI 3.0/7.0 Developer. Apr’ 06 – Feb’ 07

As a XI consultant, worked on Interfaces between SAP systems to different intranet and third party services for transferring data bi-directionally. Migrating XI 3.0 development components into PI 7.0
Responsibilities include:

• IDoc–Web service Scenario: Master Data IDOCs being generated are consumed by a .Net web service through SOAP communication which will transfer the data to external systems.
• EDI-RFC Scenario: EDI (X12) file for Inbound Shipping Status from Vendor is processed with EDISubSystem and mapped to an IDoc in XI, further to make an RFC call and to do Outbound Shipping status mapping.
• POS – SAP Retail: POS server generates the sales data, which will be posted into SAP Retail as an IDoc message WPUUMS.
• Scheduled Jobs by running program RWDAPP01 for handling buffered Idocs during inbound processing To IS Retail.
• Used Advanced File Content Conversion in sender file adapter configuration for extracting the context parameters to customize the incoming filename from a FTP location.
• Designed C#.Net Web Service for extracting reservoir pump’s details for non-US regions and applying business rules on the data for extracting the data to XI.
• Designed POCs to have bi-direction connectivity with PeopleSoft, Siebel, and DB2 with iway Adapters.
• Worked on different Mapping Patterns (splitting large messages, creating multi-part messages, transformations of messages based on business requirement by using mapping functions and user defined functions)
• XSLT Mapping defined for creating html code to display customized message while sending data through Mail adapter.
• Accessing Mapping Runtime constants in user defined function to create a custom error message in case of process failures.
• Custom Adapter Module Processing programs implemented to read unstructured file data loaded for reservoir details of pumps.
• Design Alert mechanism to inform end user and basis team of the issues/errors.
• Upgrade objects to PI 7.0 to the latest SP from XI 3.0.
• Design a deadline monitoring mechanism and Transport Acknowledgments to trap and inform the FTP and database failures.
• Used BAPIs BAPI_ACC_DOCUMENT_CHECK and BAPI_ACC_DOCUMENT_POST for posting accounting documents to SAP in an inbound process to SAP.
• BPM Sync Process: Designed and implemented a synchronous process for posting invoices to SAP and acknowledging the unsuccessful Accounting documents back to external system.
• Transports implemented through File System and CMS.
• Worked on different BizTalk Adapters like PeopleSoft, Oracle E-business suite, Siebel, SQL and JDEOneWorld and implemented IDoc communication from SAP to BizTalk Server with Idoc adapter.