SUMMARY:

• 12 years of IT experience in Analysis, Design, Development, Implementation, Testing, Deployment and post production support.
• 8 Years of strong technical expertise and proficiency in B2B Integration/ Enterprise Application Integration/ Electronic Data Interchange (EDI) using IBM’s Sterling Integrator/ Gentran Integration Suite
• Extensive work experience in creation of Business process flows using Business Process Modeling Language (BPML) and Graphical Process Modeler (GPM) in Gentran Integration Suite/ Sterling Integrator to support B2B Integration and Enterprise Application Integration
• Experience in working with various B2B communication methodologies like VAN (Value Added Network), FTP, SFTP, AS2, HTTP and HTTPS
• Experience in using IBM Sterling File Gateway (SFG) to implement Managed File Transfer (MFT)
• Highly proficient in using Sterling Integrator Map Editor to create complex mapping of various data formats such as EDI, Positional, XML, CSV, SAP IDOC
• Experienced in working with EDI Standards ANSI X12, UN EDIFACT, XML
• Hands on experience in Manufacturing EDI ANSI X12 transactions like 830, 862, 856
• Strong expertise in retail/ supply chain transactions like 850, 855, 860, 856, 810, 857, 820, 824, 823, 821, 828, 832, 841, 845, 846, 812, 816, 997
• In depth knowledge of Transportation/Logistics EDI ANSI Transactions like 204, 210, 214, 990, 300, 301, 940, 943, 944, 945, 947
• Experienced in handling EDIFACT transactions like DELFOR, DELJIT, DESADV, INVOIC, REMADV, APERAK, CONTRL
• Strong experience in Oracle E - Commerce Gateway (EDI Gateway/ XML Gateway) to interface EDI with Business Applications also to create trading partner set ups and code conversions
• Well versed with various Oracle Apps ERP modules like Order Management, Purchasing, Accounts Receivable, Accounts Payable, Transportation Management, Release Management etc.
• Experience in using Oracle PL SQL
• Experience in using LINUX and Unix environments, also experienced in creating LINUX/ UNIX Scripting
• Specialized in on boarding new EDI trading partners and EDI conversion projects, implemented over 600 new trading partner set ups
• Industrial exposure/ Functional experience in Manufacturing, Logistics, Supply Chain, Retail, Automobile, Marine, Utility Services
• Solid Onsite Offshore experience and strong analytical and problem-solving skills with excellent communication and interpersonal skills

TECHNICAL SKILLS:

EDI Integration tool: IBM Sterling Integrator 5.x, Gentran Integration Suite 4.x, Liaison, SPS Commerce

EDI Mapping tool: Sterling Integrator Map Editor 5.x

EDI Standards & Transactions: ANSI X12 850, 830, 855, 860, 856, 810, 857, 820, 824, 823, 821, 828, 832, 841, 845, 846, 812, 816, 940, 943, 944, 945, 947, 997, UN EDIFACT DELFOR, DESADV, INVOIC, REMADV, APERAK, CONTRL, SAP IDOC, XML, Tradacoms

EDI Spec Builder: EDIFECS Spec Builder

Programming Languages: BPML, SQL PL/SQL, UNIX Shell Scripting, Confidential, XML

Communication Protocols: VAN, FTP, SFTP, AS2, HTTP, HTTPS

ERP: Oracle E-Commerce Gateway, Oracle E-Business Suite

Databases and DB Tool: Oracle 8i/9i/10g/11g, R12, SQL Developer, TOAD, SQL *PLUS

Operating Systems: UNIX, LINUX, Windows

Version Control Tools: WinCVS, PVCS

Other Software Tools: Putty, WinSCP, Secure CRT, Autosys, JIRA, Service-now

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Software: Oracle EBS, IBM Sterling Integrator, SPS Commerce

Platform: UNIX, Windows, Linux

EDI Analyst

Responsibilities:

• Involve in discussions with functional, application, business users with in the organization and trading partner IT and Business teams to refine business requirements
• Provide functional specifications, business process design and documentation for business solutions
• Perform Gap Analysis to create new Business Systems from existing model
• Analyze various data elements on Invoice (810), Purchase Order (850), Purchase Order Acknowledgement (855) and Advance Ship Notice (856) documents suggest business
• Create customer set up on Oracle e-commerce Gateway System
• Create test case scenarios for each of the data fields on EDI X12 810, 850, 855 and 856 for each customer
• Work on various Oracle EBS modules like Order Management, Account Receivables, Accounts Payable and Procurement for transmission of inbound and outbound EDI documents
• Perform data validations on back end Oracle EBS modules like OM, AR, Inventory etc.
• Communicate with SPS Commerce, a third-party EDI Implementation partner of Confidential on Customer set up, map development, unit testing and communication set up
• Create the test samples for unit testing and UAT
• Create and manage Issue logs
• Train various technical and functional teams like Development, QA, Business communities on EDI process, that involves conducting Demo sessions, creating presentations
• The project involves developing B2B Integration with in the company and with its trading partners using IBM Sterling Integrator
• Creating Business Process flows using Graphical Process Modeler (GPM) /Business Process Modeling Language (BPML) and configured adapters and services as per business needs
• Using BPML in GPM and its Adapters and services to create Generic as well as customized Business processes
• Developing maps to transform different data formats like EDI, Positional, XML, CSV using Sterling Integrator Map Editor
• Developed multiple maps for various trading partners various EDI ANSI X12 transactions like 850, 855, 856, 810, 820, 870
• Creating code lists in Sterling Integrator and using them in Business Processes and Maps
• Setting up of trading partner mailboxes, routing rules
• Creating style sheets using Confidential and creating reports. Use/Reuse them in email notifications
• Exporting and importing packages with code components in to respective environments
• Developed Generic Business Processes for secure data transfer using FTP, SFTP and MQFTP
• Creating LINUX shell scripts to run Oracle concurrent jobs in e-Commerce Gateway which import and export data to and from ERP
• Using SQL PL/ SQL to create data base packages and procedures for interfacing EDI data with ERP in e-Commerce Gateway

Confidential, Fond Du Lac, WI

Software: IBM Sterling Integrator / Oracle e-Commerce Gateway

Platform: UNIX, Windows

EDI Analyst/ EDI Programmer/ EDI Technical Leader

Responsibilities:

• Involve in discussions with functional, application, business users with in the organization and trading partner IT and Business teams to refine business requirements
• Provide functional specifications, business process design and documentation for business solutions
• Create EDI Specification documents for various business transactions using EDIFECS
• Identify and propose appropriate data formats or transactions as well as communications method to exchange with trading partners
• Educate business users in organization to handle the implemented EDI applications/ processes
• Perform Gap Analysis to create new Business Systems from existing model
• Act as single point of contact for Business teams and trading partners
• Perform project planning, coordination and management of projects
• Understand business requirements and provide technical guidance to team for achieving the business goals
• Conduct training sessions and share technical and functional knowledge with team
• The project involves developing B2B Integration with in the company and with its trading partners using IBM Sterling Integrator/ Gentran Integration Suite and supporting the developed components
• Creating Business Process flows using Graphical Process Modeler (GPM) /Business Process Modeling Language (BPML) and configured adapters and services as per business needs
• Using BPML in GPM and its Adapters and services to create Generic as well as customized Business processes
• Creating Envelopes using Sterling Integrator for multiple transactions of trading Partners
• Developing maps to transform different data formats like EDI, Positional, XML, CSV using Sterling Integrator Map Editor
• Developed hundreds of maps for various EDI ANSI X12 transactions like 850, 830, 855, 860, 856, 810, 857, 820, 824, 823, 821, 828, 832, 841, 845, 846, 812, 816, 940, 943, 944, 945, 947, 997 and EDIFACT transactions like DELFOR, DESADV, INVOIC, REMADV, APERAK, CONTRL
• Creating code lists in Sterling Integrator and using them in Business Processes and Maps
• Setting up of trading partner mailboxes, routing rules
• Creating style sheets using Confidential and creating reports. Use/Reuse them in email notifications
• Setting up trading partners on VAN. Different VAN providers worked with are GXS Trading Grid Management Services, nuBridges
• Exporting and importing packages with code components in to respective environments
• Developed Generic Business Processes for secure data transfer using FTP, SFTP and MQFTP
• Creating Customer/ Supplier/ Bank trading partner set up in Oracle e-Commerce Gateway
• Creating UNIX shell scripts to run Oracle concurrent jobs in e-Commerce Gateway which import and export data to and from ERP
• Using SQL PL/ SQL to create data base packages and procedures for interfacing EDI data with ERP in e-Commerce Gateway
• Preparing different test cases for data validation, involving in unit testing, integration testing and user acceptance testing
• Interacting with business teams and trading partners in testing and data validation
• Cut-Over Planning and Post Go-Live support
• Instrumental in migrating EDI partnership with direct suppliers from Mainframes Gentran to Gentran Integration Suite
• On boarded hundreds of trading partners which include Customers/ Drop ship Suppliers/ Financial Institutions/ Logistics
• Solving Problem Management Tickets in Service-now for various problems encountered in the application with priority 1, 2, 3 and 4
• Providing on call support for high priority/ severity issues

Confidential, WI

Software: Oracle PL/SQL, UNIX Shell Scripting

Platform: Windows XP, UNIX

Team Member/ Quality Leader

Responsibilities:

• Executing Work requests, which involve analysis, design, coding, testing, implementation, and documentation
• Solving Problem Management Tickets in Service Desk Express for various problems encountered in the application with priority 1, 2, 3 and 4
• Proactive support for all applications written in different technologies like Unix Shell Scripts, Oracle PL/SQL
• Proactive monitoring of daily scheduled jobs. Cancel/Rerun jobs in critical situations
• Proactive escalation of application, server and database issues like application failures, breakdowns and outages
• Interacting with the Clients for analysis and implementation of Production Upgrades, Work Requests, Production Issues and Problems
• Work on Ad hoc Requests as and when required and processing client requests and ensuring timely deliveries
• Peer review for code components developed in different technologies in the project for Critical, Major, Minor and Cosmetic defects.
• Forward the code components to Software Quality Assurance team in the organization
• Plan, gate review and execute the production migration of code components
• Track and document the peer defects, SQA defects and Client raised defects in defect tracking tools and generate monthly/ quarterly reports. Conduct meetings with project teams to mitigate defects

Confidential, NJ

Software: Oracle PL SQL, UNIX Shell Scripting and SQL Server

Platform: Windows XP, UNIX

Team Member/Team Leader/Onsite coordinator

Responsibilities:

• Executing Work requests, which involve analysis, coding, testing, implementation, and documentation
• Solving Problem Management Tickets in Remedy regarding various problems encountered in the application with priority 1, 2, 3 and 4
• Proactive support for all applications written in different technologies like Unix Shell Scripts, Oracle PL/SQL, VB, PB and SQL Server
• Proactive monitoring of daily scheduled jobs. Cancel/Rerun jobs in critical situations
• Proactive escalation of application, server and database issues like application failures, breakdowns and outages
• Interacting with the Clients for analysis and implementation of Production Upgrades, Work Requests, Production Issues and Problems
• Work on Ad hoc Requests as and when required and processing client requests and ensuring timely deliveries
• Perform maintenance jobs weekly/monthly/yearly archiving of database tables etc
• Guide the team to work towards delivering all customer requests by effective coordination and communication with onsite
• Distribution of tasks and assigning them among team members
• Make sure the team doesn’t miss any SLAs and review the tickets being delivered
• Identify training requirements for improving technical skills and application knowledge and then conduct trainings accordingly
• Provide technical help when necessary to the team members
• Conducting inductions to new resources
• Primary on-call support to achieve business objectives
• Understanding Client’s requirements and coordinating with Offshore