SUMMARY:

• Over 15+ years of IT experience and Technical proficiency in Enterprise Application Integration (EAI) teamed with Analysis, Application Design/System Architecture, Development & testing, Review, Data Integration, Data Transformation, Business Requirements Analysis, Quality Control & full life cycle Implementation.
• Strong EAI experience in Application development & Quality Assurance testing using Websphere Transformation Extender (WTX)/IBM Transformation Extender (ITX)/Mercator and its toolsets (Type Tree Designer, Map Designer, Integration Flow Designer, Management Console, Partner Manager, Resource Registry, Database Interface designer, Event Server, command Server), IBM Sterling B2B integrator, Visual Mapper (Trusted Link), AMTRIX, Axway (AS2, Sentinel).
• Involved in Requirement gathering, Data Analysis, Application Design, Application Development, GAP Analysis, Implementation and Quality Assurance in different EAI Projects.
• Wide experience with Data Integration projects with multiple Data Sources including EDI (X12/EDIFACT), XML, Flat Files, RossettaNet, IDOC’s, Oracle & SQL Server Feeds.
• Worked on the following ANSI X12 versions: v3040, v4010, v4030, v5010, v5030 and X12 formats: 110, 210, 211, 204, 214, 810, 814, 820, 824, 830, 832, 846, 850, 856, 858, 860, 862, 867, 870, 940, 943, 944, 947, 990, 997 and HIPAA Transactions 834, 835, 837, 270, 271, 276, 277.
• Worked Extensively on SAP IDOC formats MATMAS, CREMAS, BOMMAT, PRICAT, GLMAST, DEBMAS & RosettaNet formats 3B3, 3B13, 3B18 & 4B2.
• Worked extensively with various source systems like Oracle, SQL Server, MS Access, Paradox, Sybase, flat files, XML & Cobol Copy Books (Mainframe), SAP IDOC’s.
• Worked extensively with various Client Server & Internet technologies like Visual Basic, PowerBuilder, Delphi, ASP, and ColdFusion.
• Worked with Utilities like TOAD, SQL Developer, WinFTP, Ultraedit, Text Pad and Putty.
• Worked on trading partner’s setup/configuring in Axway (AS2), GXS, and GHX. Exposure to Axway Sentinel Product Server/Monitoring/Data Collection environment.
• Worked on IBM Integration Bus (IIB)/WebSphere Message Broker (IIB/WMB), IBM Sterling B2B Integrator (BPML, GPM, Workflows, File Gateway).
• Proficiency in requirements analysis and realization deriving testable functional / non - functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
• Experience in creating efficient and effective BRD and FRD documentations involving data mappings.
• Experience in writing Functional specifications, Scenarios, Business processes, Workflows, Test cases and Test Plans.
• Experience in managing/leading/mentoring small to medium size teams (Performed the role of Team Lead/Offshore coordinator/Project Manager) for various projects related to development/Customer Support & Maintenance from Initiation, Planning, Executing and Closing Phases.
• Experience in coordinating with the configuration and change management groups for Clear Case Version Control and Build Making Process.
• Experienced in various domains like Manufacturing, Planning, Healthcare, HDMA (Healthcare Distribution Management Association), Accounts & Administration, Inventory & Logistics and Energy & Utilization, Pharmaceuticals.

TECHNICAL SKILLS:

EAI Technologies: WebSphere/IBM Transformation Extender (WTX/ITX), ITXA, Mercator 6.7/6.5, Visual Mapper, SAP XI, Gentran, EDI (X12 & EDIFACT), RosettaNet, Websphere Message Broker (WMB)/IBM Integration Bus (IIB), IBM Sterling B2B Integrator 5.2.6, AXWAY, GXS, GHX:

FrontEnd Tools: Visual Basic 6.0, Delphi 3.0, & PowerBuilder 7.0

ETL Tool: Ascential Datastage 7.5.1

Internet Technologies: ASP, Cold Fusion, Java, HTML, VBScript & JavaScript, XML

RDBMS: Oracle, Ms Access, SQL Sever, DB2 & Sybase

Configuration Tools: Visual Source Safe, PVCS, Starteam, Harvest.

Other Tools: TOAD, SQL Developer, WinFTP, UltraEdit, TextPad, Putty, HP QC

Operating Systems: Dos, UNIX, Windows NT and Novell NetWare.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Developer

Responsibilities:

• Gathered Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Analyzed and optimized the process of architecture and prepared the Functional Requirements Specification and Technical Specification.
• Developed Data Transformation Maps for EDI (X12) And Flat Files.
• Design/Import/Customize Type Trees for EDI (X12), XML, Flat Files.
• Coordinated between Analysts/Managers/team members from different Teams.
• Worked on ITXA for setting up the Envelopes/Partner profiles.
• Deploying the maps to ITXA via Standards Processing Engine (SPE).
• Configuring the maps (Dev, stage Environments).
• Customer Support & Maintenance (Post production/ongoing support/on call Support).
• EDI transactions widely used in this project are X12: 834, 835, 837, 999 and 997.
• Involved in Reviewing Maps/Code Review, Documents and Testing (Including the test cases and test results) done by other team members.

Environment: ITX (Type Tree Designer, Map Designer, Database Designer and Other ITX tool set), ITXA, IIB, Mainframes, EDI (X12), XML, Facets, SSH, SQLServer 9.0, EDI Notepad, MQ Series, AS2(Axway), FTP, Subversion.

Confidential

• Gathered Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Analyzed and optimized the process of architecture and prepared the Functional Requirements Specification and Technical Specification.
• Developed Data Transformation Maps for EDI (X12), COBOL Copy Books, XML, And Flat Files.
• Design/Import/Customize Type Trees for EDI (X12), XML, Flat Files, COBOL Copy Books.
• Coordinated between Analysts/Managers/team members from different Teams.
• Deploying & configuring the maps (Dev, stage Environments).
• Worked on Enhancements of existing Data Transformation Maps.
• Customer Support & Maintenance (Post production/ongoing support/on call Support).
• EDI transactions widely used in this project are X12: 834, 835, 837, 277, 277CA, 270,271, 999 and 997.
• Reviewing the Maps/Code Review, Documents and Testing (Including the test cases and test results) done by other team members.

Environment: WTX (Type Tree Designer, Map Designer, Database Designer and Other WTX tool set), WMB, Mainframes, EDI (X12), XML, Cobol, SSH, DB2, WinSCP, DBVisualizer, Beyond Compare, BMC, Putty, MQ Series, AS2 (Axway), GXS(VAN), FTP, HP Service Manager, Harvest.

Confidential, Philadelphia, PA/Frisco TX

• Gathered Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Analyzed and optimized the process of architecture and prepared the Functional Requirements Specification and Technical Specification.
• Performed System Architecture role for ABSG division and worked with IBM/HCL Technologies for Migrating to ITX/SI from WTX.
• Developed Data Transformation Maps for SAP (BAPI remote function calls, IDOC’s), EDI (X12), XML, Flat Files.
• Design/Import/Customize Type Trees for EDI (X12), XML, Flat Files, SAP (IDOC’s & BAPI).
• Developed MDQ using Database Interface Designer using Back end as Oracle 10g.
• Developed Systems using Integration Flow Designer.
• Developed the Functional & Process Documentations, Data Mapping Documents & Implementation Plans.
• Coordinated between Analysts/Managers/team members from different Teams.
• Deploying & configuring the maps (Dev, stage & Prod Environments).
• Worked on Enhancements of existing Data Transformation Maps.
• Trading partner Setups/configuration in Axway, GXS, GHX
• Customer Support & Maintenance (Post production/ongoing support/Oncall Support).
• Worked on Improving the Performance (Performance Tuning) of old maps which are taking longer duration for execution.
• Worked on writing/fine tuning the SQL Queries in order to increase the performance of the maps which access data from Oracle 10g.
• Monitoring the systems using Management Console.
• Reviewing the Maps, Documents and Testing (Including the test cases and test results) done by other team members.

Environment: ITX/WTX (Type Tree Designer, Map Designer, Integration flow Designer, Database interface Designer, Management Console & Other Websphere Transformation Extender tool set), IBM Sterling B2B Integrator 5.2.6.1 (SI), SAP ECC 6.0, EDI (X12), XML, Idocs, SSH, Oracle 10g, Windows NT, WSFTP, Ultra Edit, AS2 (Axway), GXS(VAN), GHX, ConnectNow, HP QC .

Confidential, Houston, TX

• Gathered Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Analyzed and optimized the process of architecture and prepared the Functional Requirements Specification and Technical Specification.
• Developed Data Transformation Maps for SAP (BAPI remote function calls, IDOC’s), EDI (X12), XML, Flat Files.
• Design/Import/Customize Type Trees for EDI (X12), XML, Flat Files, SAP (IDOC’s & BAPI).
• Developed MDQ using Database Interface Designer using Back end as Oracle 10g.
• Developed Systems using Integration Flow Designer.
• Developed the Functional & Process Documentations, Data Mapping Documents & Implementation Plans.
• Coordinated between Analysts/Managers/team members from different Teams.
• Migration of maps from version 8.0.1 to 8.2.0.4 and involved in all Unit/SIT/Performance /Regression testing.
• Deploying & configuring the maps (Dev, stage & Prod Environments).
• Worked on Enhancements of existing Data Transformation Maps.
• Customer Support & Maintenance (Post production/ongoing support/Oncall Support).
• Worked on Improving the Performance (Performance Tuning) of old maps which are taking longer duration for execution.
• EDI transactions widely used in this project are X12 (Texas Set Transactions): 814, 867, 810, 824 and 997.
• Worked on writing/fine tuning the SQL Queries in order to increase the performance of the maps which access data from Oracle 10g.
• Monitoring the systems using Management Console.
• Reviewing the Maps, Documents and Testing (Including the test cases and test results) done by other team members.

Environment: WTX/ITX (Type Tree Designer, Map Designer, Integration flow Designer, Database interface Designer, Management Console & Other WTX/Mercator tool set), SAP ECC 6.0, EDI (X12), XML, Idocs, SSH, Oracle 10g, Windows NT, WSFTP, Ultra Edit, Axway, GXS, FTP .

Confidential, Atlanta, GA

• Developed Data Transformation Maps for EDI (X12/EDIFACT), XML, Flat Files & IDOC’s.
• Design/Import/Customize Type Trees for EDI (X12/EDIFACT), XML, Flat Files, IDOC’s.
• Developed MDQ using Database Interface Designer (ODBC connectivity) using Back end as SQL Server 2005.
• Developed Systems using Integration Flow Designer.
• Developed the Implementation Plans.
• Deploying & configuring the maps (Dev, Test & Prod Environments).
• Worked on Enhancements of existing Data Transformation Maps.
• Customer Support & Maintenance (Post production/ongoing support).
• Gathered Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Worked on Improving the Performance (Performance Tuning) of old maps which are taking longer duration for execution.
• Monitoring the Acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners were being sent successfully.
• EDI transactions widely used in this project are X12: 110, 210, 211, 214, 810, 820, 850, 856 and 997. EDIFACT: INVOIC, IFTFCC, APERAK.
• Worked on writing/fine tuning the SQL Queries in order to increase the performance of the maps which access data from SQL Server 2005.
• Monitoring the systems using Management Console.
• Reviewing the Maps, Documents and Testing (Including the test cases and test results) done by other team members.
• Analyzed and optimized the process of architecture and prepared the Functional Requirements Specification and Technical Specification.
• Coordinated between Clients (Business Analysts/Managers/team members from different Teams).
• Effectively facilitated regular project meetings and follow up with team members as required to focus on business and operational issues and technical issues.
• Worked on version control & change management using tool Visual Source Safe (VSS).

Environment: WTX/ITX/Mercator 6.5 (Type Tree Designer, Map Designer, Integration flow Designer, Database interface Designer, Management Console & Other WTX/Mercator tool set), EDI (X12/EDIFACT), XML, Idocs, SQL Server 2005, Windows NT, VSS, AS2 Communication, Ultra Edit .

Confidential, Portland, OR

• Analyzed and optimized the process of old architecture (Mercator 6.5) and Prepared Business Requirement Document and then converted the business requirements into Functional Requirements Specification and Technical Specification to sute the new architecture.
• Developed Data Transformation Maps.
• Developed MDQ (Database Interface Designer) using ODBC connectivity.
• Developed Systems using Integration Flow Designer.
• Developed the Implementation Plans for projects worked by me or offshore team.
• Deploying & Configuring in UNIX for various environments (Dev, Preprod & Prod).
• Design/Import/Customize Type Trees for EDI, XML, Flat Files, IDOC’s, Cobol Copy Books.
• EDI transactions widely used in this project are X12: 210, 214, 810, 820, 830, 850, 856, 858, 860, 862, 867, 870, 940, 943, 944, 947 and 997. EDIFACT: INVOIC, ORDERS.
• Customer Support & Maintenance (Post production/ongoing support).
• Involved in gathering the Business Requirements, Interacted with Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes.
• Coordinated between Client (Business Analysts/CDG Managers/Technical Leads from different Teams) and offshore teams (Development and support).
• Sending an Acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
• Lead Mercator Development Team (Chennai) & support team (Pune) from Offshore.
• Involved in upgradation of partner manager from 6.5 to 8.0 by performing regression testing and the comparing the results between the two versions.
• Monitoring the systems using Management Console.
• Reviewing the Maps, Documents and Testing (Including the test cases and test results) done by offshore before delivering to the Client.
• Coordinated the Disaster recovery process testing for offshore from setting up of the replicated environment of the existing architecture in case of Building/City/Country Outage.
• Effectively facilitated regular project meetings and follows up with team members as required to focus on business and operational issues and technical issues.
• Extensively worked on version control & change management using tools PVCS & Starteam.

Environment: WTX/ITX/Mercator 6.7/6.5 (Type Tree Designer, Map Designer, Integration flow Designer, WMB, Database interface Designer, Management Console & Other WTX/Mercator tool set), Idocs, Oracle, Windows NT, UNIX, Starteam, MQ Series, EDI, Rosetta Net, Axway