PROFESSIONAL SUMMARY:

• ESB Developer with project experience utilizing integration and ETL technologies.
• Experience developing SOA - based Web Services utilizing Websphere Message Broker / Confidential Integration Bus.
• Experience interfacing with Websphere MQ-based legacy systems and accessing Oracle and DB2 DBMS systems.
• Experience in architecture within IIB, gathering requirements from business and consulting with senior architects on security, authentication and failover (DR) within IIB
• Maintaining design documents, naming standards and mapping documents for interfaces
• Expertise in creating WSDL’s, XSD’s.
• Exposure to WSRR Governance model integration with IIB / WMB.
• Very strong problem solving and technical skill set.
• Dedicated, motivated individual with excellent bilingual communication skills.
• Experience in government, private, and telecommunication industry sectors.

TECHNICAL SKILLS:

• Confidential Integration Bus (IIB) v9 and v10
• Websphere Message Broker 7 (WMB)
• Websphere Message Queue (WMQ)
• ESB, SOA, WS-Security, WSRR, Oracle, DB2, SQL Server 2012
• Windows Server 2012
• UNIX (AIX)
• Microsoft Windows 7
• Visual Studio 2012, ESQL, XML, REST API, SOAP, WSDL, XSD, Soap-UI, SharePoint, SVN, TFS, Informatica 7.1, 8 and 9.6.1, SQL, TOAD and Microsoft Excel

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Websphere Architect & Sr. IIB Lead Developer

Responsibilities:

• Gathered requirements from business team to build solutions using IIB
• Used queues to read messages build request for SOAP based web service and update DB
• Used the libraries for reusability of common flows like error handling and common configuration details
• ESQL was used to transform and manipulate data
• Used compute node to add custom code for transformations and database access
• Used rfhutil and soapUI for unit testing
• Built POC for a client requirement creating RESTAPI’s and publishing to API Connect
• Worked with support teams for deployments to test environments
• Worked with MQ admins to build deploy scripts for production environment
• Created multiple informatica mapping and workflows for ETL projects
• Used multiple source tables and flat files to update AS 400 systems
• Worked of different informatica transformations to transform source data.
• Created sessions and workflows to unit test
• Created workflows that would load data sequentially and in parallel into multiple tables in different environments.
• Involved in production support and on call rotations

Confidential, Durham, NC

Sr. IIB Lead Developer

Responsibilities:

• Used message modeler to create swagger documents
• Gathered requirements to build solutions using IIB
• Extensively used REST API's to create flows
• Used the new shared libraries for reusability of common flows
• Extensively used the graphical mapping node to transform and manipulate data
• Used java and compute node to add custom code for transformations
• Used rfhutil and soapUI for testing
• Involved in deployments to test environments
• Closely worked with deployment team to build deploy scripts for production environment

Confidential, Columbus, OH

Sr. IIB Lead Developer

Responsibilities:

• Create swagger documents to interface with Salesforce system.
• Importing WSDL’s and generating message models to interface with different external systems.
• Gathered requirements from Business and Clients to provide solution through IIB
• Maintaining interface design documents and mapping documents
• Maintained documentation for IIB architecture, naming standards and security
• Attending requirements gather meetings with Client and Business
• Involved in providing Clients demonstrations of builds to show the end to end processes of each build
• Actively involved checking for code quality and code reviews with team members Extensively use SoapUI to test, debug and load test.
• Built generic IIB framework which would allow reusability of flows
• Monitoring logs and queue depths to proactively find potential problems
• Using Informatica Powercenter 9.0 to build a batch process with Salesforce
• Used Informatica to extract data from flat files and oracle database to integrate with oracle target systems
• Developed mappings to stage data from salesforce to oracle target tables
• Used different transformations like expression, filter, normalizer in developing mappings

Confidential, Durham, NC

Sr. IIB Developer and Admin

Responsibilities:

• Gathered requirements from application teams and external web service providers to build IIB solutions
• Maintain interface documents, broker components, and MQ scripts.
• Maintained documentation for IIB architecture, naming standards and security Create WSDL’s to interface with different systems.
• Configure WMQ 7.5 and IIB 9.0 on Windows / Windows Server 2012.
• Import WSDL’s and created Message Models.
• Implemented flows to meet with requirements while maintaining the defined standards within IIB.
• Created requests and response mapping using ESQL.
• Create and deploy event monitoring profile XML documents.
• Generate reports on usage of deployed applications.
• Use the in-built cache to load configuration and end points.
• Expose the out of box web user interface feature for management to monitor statistics.
• Extract certificates and configured 2-way SSL for secure communicates with both external and internal systems.
• Upgrading communication protocol to TLS1.2 and SHA256 certificates.
• Configure WMQ for Pub/Sub to support event monitoring.
• Build an adapter layer which read from database and supported similar adapters. Actively involved checking for code quality and code reviews with team members Open service requests and worked with Confidential support to resolve product defects.
• Build automated scripts to deploy BAR files to various environments.
• Installed MQ and IIB to multiple environments (Dev, QA,UAT, DR and two PROD servers) Created queues for broker on the queue manager
• Extensively use SoapUI to test, debug and load test.
• Monitor logs and queue depths to proactively find potential problems.
• Built a threshold based flow which would cut off after certain call volume to avoid overages.
• Integrating IIB with Business Monitor.

Confidential, Durham, NC

WMB Developer

Responsibilities:

• Designed and developed messaging interfaces.
• Configured WMQ and WMB 7.0 on Windows / AIX.
• Implemented ESQL logic for aggregation, database lookups, metadata-driven processing, message validation / translation / transformation and exception handling.
• Created and deployed XML configuration documents utilizing WSRR.
• Mentored developers in Debugging ESQL and Java code.
• Performed problem determination and root cause identification.
• Configured and deployed the BAR files to test, dev and production environments.
• Debugged routing and data conversion issues.
• Drafted and submitted structure enhancements documents to the NIEM standards board.
• Worked closely with business to understand requirements and translated the same during development.
• Understanding of technical and business requirements in SDLC process.
• Designed and maintained documentation relating to mappings and data definitions that were used to integrate WMB with Curam applications.
• Prepared mapping documents for individual interfaces.
• Maintained interface documents, broker components, and MQ scripts.
• Monitored logs and queue depths to proactively find potential problems.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables conforming to the business rules.
• Developed re-usable transformations and map-lets - using various transformation concepts including like expressions, routers, filters, sequence generators, stored procedures, and connected and un-connected look ups in developing the mappings.
• Used Informatica to extract data from different source systems which were mainly Oracle and flat files and integrate to Workday.
• Performed job scheduling, batch, alert and E-mail notification settings.
• Investigated problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Involved in daily review meetings with offshore development and client teams.

Confidential, North Brunswick, NJ

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers
• Used Informatica Power Center 7.1 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers
• Extensively used Mapping Variables, Mapping Parameters to execute complex business logic
• Design and development of complex ETL mappings making use of Connected/Unconnected Lookups, Normalizer, Stored Procedures transformations
• Used debugger in debugging some critical mapping by setting breakpoints and resolving the issues by checking sessions and workflow logs
• 24x7 Informatica ETL on call support in production stage

Confidential 

Software Developer

Responsibilities:

• Used Informatica to extract data from different Source systems which were mainly Oracle and Flat files and integrate oracle target system
• Designed and developed the ETL mappings for the source systems data extractions, data transformations, data staging, movement and aggregation
• Used different transformations like expression, router, filter, sequence generator, stored procedure, connected and un-connected look ups in developing the mappings Performed Job Scheduling, batch, alert and E-mail notification setting.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Involved in different team review meetings