Sr Integration Lead/analyst Resume
Mechanicsburg, PA
PROFESSIONAL SUMMARY:
- Over 16 years of experience in Information Technology with knowledge and participation in Architecture, Systems Engineering, Analysis, Design, Implementation, Testing and Documentation.
- Over 14 years of experience in roles of a lead interface designer and developer on several Integration Projects.
- Primarily experienced in architecting, designing, reviewing, installing, developing and supporting enterprise application integration (EAI) / business to business integration (B2Bi) / EDI solutions, framework and processes using EAI, B2Bi tools & Java.
- Experienced through the stages of user requirement process, project planning and estimation, resource planning, project and technical documentation, software analysis and design, gap/impact analysis, capacity sizing and architecture, cluster installation, technical reviews, development, implementation, maintenance, establishing best practices, supporting and enhancing development/maintenance processes, peer/user evaluation and training, configuration and change management. Well Familiar with SDLC methodologies like Waterfall and Agile.
- Worked on technically challenging and complex web architectures using UML, SOA, Java/J2EE, XML, ASP VB and relational database (Oracle, MS SQL Server) technologies. Strong PL/SQL Skills.
- Technology areas include WTX, WMB, WebMethods (post and pre 6.x releases including old B2B and Enterprise versions), JD Edwards (PeopleSoft), Java, JDBC, JSP, EJB, SOA, Web Services, SOAP, REST, Servlets, Oracle, WebLogic, WebSphere, Java Beans, Data - Modeling, JavaScript, HTML, XML, UML, PL/SQL, SQL, SQL Server, DB2, Sybase and also RMI, ASP. Skilled on Windows and UNIX platforms.
- Highly motivated with strong communication, analytical and organizational skills.
TECHNICAL SKILLS:
Java
C++
C
VB
Mercator 5.0/6.5
WebSphere Transformation Extender (8.2/8.4)
WebSphere Message Broker (8.0)
WebMethods B2B 4.02/4.6/6.0/6.1
WebMethods for Trading Networks 4.0/4.6/6.0
WebMethods Enterprise 4.1
WebMethods Workflow 6.0
PERL
HTML/ JavaScript
Servlets
JSP(Java Server Pages)
ASP(Active Server Pages)
Web Servers
Apache 1.3.12
Jakarta Tomcat
IBM WebSphere 3.5, WebLogic 5.1
IIS 4.0
Visual Basic 6.0
IBM Visual Age 3.x
Front Page
Microsoft SQL Server
Oracle
Sybase
DB2
ERP
SAP R/3 (ABAP/4 Programming)
JD Edwards
CRM
Siebel
Windows 95/NT/2000
MS: DOS
AS/400
AIX 5.1/5.2
Messaging
IBM MQ Series 5.1
Visual Source Safe, CVS, PVCS, SVN
MS Office Applications
VISIO 2000
MS Project 2000, Crystal reports
WORK EXPERIENCE:
Sr Integration Lead/Analyst
Confidential, Mechanicsburg, PA
Responsibilities:
- Exel upgraded the proprietary integration hub to a new nextGen hub and as a part of this upgrade Exel needed to migrate all of its 250 customers to use the new integration hub.
- Planning, Analysis, Design, Implementation, Testing and Release.
- Leading the whole effort of upgrade with a team of integration analysts. Successfully migrated about 250 customers
- Helping the team by resolving the issue’s during the upgrade process.
- Co-ordination of test cycles with the operations team.
- Post-go live support.
- Meeting up with customers and gathering the requirements for integration between the customers and Exel using different file formats like EDI (ANSI X12/EDIFACT), XML, SAP IDOC’s, Flat files or any proprietary format that customer wants to use.
- Designing the mapping specs and go thru the approval process with the customer and the internal team.
- Setting up the partners in axway B2B interchange for transfer of files to and from the customers using various protocols like AS2, FTP or SFTP.
- Configuring METASTORM integration manager to monitor customer B2B folders to pick up inbound files and feed the data to Exel integration hub and also to deliver outbound files to B2B from the integration hub.
- Developing and unit testing the maps in WTX.
- Developing custom WMB flows if the customer is highly volatile and requires dedicated queues.
- Exel integration hub is a proprietary hub developed using WMB/WTX objects and using Oracle database for config tables.
- Configuring the flows in the oracle database for each of the maps or WMB flows that were developed.
- Creating web services and calling web services based on the client’s communication requirement using WSDL files.
- Pre QA testing with the internal WMS applications and Support for QA.
- Post-go live support.
Environment: WebSphere Message Broker (8.0.0.1), WebSphere Transformation Extender (8.2/8.4), Oracle Database (11.2), Axway B2B Interchange (5.1), METASTORM Integration Manager (8.5), MQ Explorer V7, MQ Visual Edit, EDIFECS Spec Builder (7.0.8), ANSI X12/EDIFACT standards, Altova XML Spy 2013, PVCS Version Manager, SVN subversion, SOAP, REST-Restful services using JSON, SOA, Web Services, WSDL, SDLC (Waterfall/Agile).
Technical Lead / Lead Developer
Confidential, St. Louis, MO
Responsibilities:
- Design and develop integration framework for reusability.
- Design and development of WebMethods services.
- Working with the team on implementations, Pre and Post go live support activities.
- Helping team members in debugging integration issue’s.
- Provided WebMethods training, code review sessions and mentored team members from technical perspective.
Environment: WebMethods (4.6, 6.0), Oracle (10.7, 11.0.3), Oracle Apps, Java and UNIX
Implementation Lead / Lead Developer
Confidential, Seattle, WA
Responsibilities:
- Design and development of the real time interface between Medco and Premera.
- Writing stored procedures to insert and retrieve the data as the interface is by directional.
- Developing Mercator maps to pick the data from a queue and map the incoming data to the staging tables for the inbound messages.
- Developing Mercator maps to format and put the outbound messages onto queue.
- Developing VB screens for the end users to insert data into the interface triggering tables.
- Testing components and tuning them for a better performance.
- Automated the whole process using Mercator event server.
- 24/7 Production Support for the whole interface.
Environment: Mercator, SQL Server7.0, XML, VB COM, and VB.NET
WebMethods Team Lead/Lead Developer
Confidential, Herndon, VA
Responsibilities:
- As Senior Developer I was responsible for establishing EAI standards at Confidential
- Actively involved in understanding user requirements, create data mappings and doing gap/impact analysis. Create integration design and develop integrations.
- Created Universal Data Models Canonical documents from a future re-usability and data center integration perspective.
- Providing Support and fine-tuning for the existing integration solutions.
- Design and develop services for WebMethods Metadata repository.
- Provided WebMethods training, code review sessions and mentored team members from technical perspective.
- Helped team members in debugging integration’s.
- Logging WebMethods Service Requests and getting them resolved.
- Installed and configured WebMethods components including the Enterprise one Adapter and JDBC adapters in a Clustered environment
- Created basic templates and standard services framework for various integration types (different pub-sub patterns, request-reply etc.).
- Developed framework for error handling, property management, and document routing and handling.
- Configured custom SOAP processor and expose WebMethods services as web services (WSDL).
- Provided WebMethods Integration Server developer/admin level training to various Confidential staff
- Wrote WebMethods Metadata services, which populate services/components information in the Metadata repository. Designed the Metadata application to maintain WebMethods related documentation.
- Worked with the team for establishing backup and recovery procedures, development strategy, support procedures and version/change management / migration procedures.
- Performed IS performance tuning and provided guidelines for creating better integrations.
Environment: Oracle 11i, PL/SQL, Webmethods6.x, JDBC Adapter, Enterprise One adapter and web services adapter.
Technical Lead/Lead Developer
Confidential, ADA, MI
Responsibilities:
- Design, Implementation, and testing.
- Team co-ordination.
- Convert database from Sybase to SQL Server.
- Migration of tables and converting Stored Procedures and Triggers.
- Configure Applications to access the new SQL Server databases.
- Performing Unit/system/stress tests of the application functionality and performance.
- Conversion of VB3 apps to .NET and VB3 reports to actuate reports.
- Conversion of Crystal Reports to actuate reports.
- Develop existing PowerBuilder apps in ASP.net.
Environment: Sybase, SQL Server, VB3, VB6, ASP.Net, Crystal Reports, and Actuate Reports.
WebMethods Consultant
Confidential, Chicago, IL
Responsibilities:
- Created Flat File Schema’s and IS Documents to parse the incoming messages from the MLF (Mobile Link Freightways) Application which resides on the phone.
- Created flow services to read the flat files and insert into Oracle staging area and from there to AS400 backend system using JDBC and AS400 adapter.
- Created Java services to validate and convert the incoming data to the appropriate format using IData object.
- Created JSP application that calls WebMethods services using the JSP WEBM tags and performs the actions chosen by the end. Purpose is to simulate the Mid App on the phone for testing.
Environment: Oracle 9i, Webmethods6.0, JDBC Adapter, AS/400 Adapter, AS/400, SOA, Web services, WSDL.
WebMethods Consultant / Mentor
Confidential, Indianapolis, IA
Responsibilities:
- Configuration and Setup of Sterling Commerce Mailbox, TP profiling and determining logging strategy
- Receive inbound 810 invoice transaction data by communicating to the VAN via ftp
- Mentoring developers through the process of mapping the 810 and the outbound 864
- Integration to/from JDE of the invoice data and text message responses
- Sending out the 864 text message transactions.
Environment: WebMethods Integration Server 6.1, EDI Module, Trading Networks 6.0, AIX 5.1, JDE One World Adapter, and Windows NT.
Technical Lead / Lead Developer
Confidential, Seattle, WA
Responsibilities:
- Designing the interface with respect to business requirement.
- Assigning tasks to the team.
- Writing stored procedures to get the data from three different legacy systems and consolidating into one single central database.
- Writing VB programs to convert the data into a hierarchal XML data.
- Created Mercator trees and Maps and writing business rules to map source to target.
- Testing components and tuning them for a better performance.
- Automated the whole process using Mercator event server.
- 24/7 Production Support for the whole interface.
Environment: Mercator, SQL Server7.0, XML, VB COM, VB.NET
EAI/Configuration Consultant
Confidential, Chicago, IL
Responsibilities:
- Creating new Siebel web templates and providing the functionality as per client’s requirement.
- Created an Open Order Template for equipment ordering, through which we can order multiple parts and have them on a single quote. This task is accomplished by calling Siebel Objects from an ASP page using SiebelApplicationControl object.
- Error handling.
- Created Integration objects using Siebel EAI as business service for the source system.
- Was responsible for integrating Siebel with web application using HTTP adaptors.
- Created business services to invoke the COM Objects at the UI layer and get the functionality as per client’s requirement.
- Developed Workflows, Business Services for Sending data Siebel to IBM MQ series and receiving messages from MQ Series to Siebel. Data is in the form of XML format. This is a bi-directional synch with the external application.
- Incorporated the above workflow process into Siebel application.
- Developed different Territory Assignment rules to assign employees to the new accounts as soon as they were created based on territory criteria. Different conditions and various parameters were involved in defining these territory rules and policies depending on their existing system.
- Database extension is done for the existing extension tables linked to base tables and build them to the user interface layer by creating the whole link between the business object layer and data object layer.
- Created various business components for the multi value fields need to be created and expertise in customizing an application with newly created applets, views, and screens and maintaining their links and joins.
Programmer /Analyst
Confidential, Novi, MI
Responsibilities:
- GUI design and development for data entry, Viewing and modification using VB 5
- Wrote several stored procedures to in corporate business logic and maintain data integrity
- Involved in the Unit and System testing.
- RDO was used extensively to access the data.
- File IO utilities were developed to bring various data sources into a common file layout.
Environment: Oracle 7.3, PL/SQL, Visual Basic 5.0, Crystal reports, Windows NT, Windows 95.
Database Administrator
Confidential
Responsibilities:
- Creating users and assigning privileges to them.
- Creating table spaces, rollback segments.
- Planning, designing, and development of new database applications or major changes to existing applications.
- Management of an organization's data and metadata
- Backup and recovery.
Environment: Oracle7.3, WindowsNT.
