Sumit Agrawal

Sr. TIBCO Developer

Mobile : 443-***-****

acqgpo@r.postjobfree.com

Professional Summary:

10+ years of experience delivering SOA, B2B & Enterprise Application Integration solutions using TIBCO and Java/J2EE technologies. Extensive Experience with Large and Complex Integration Projects and Multi-Shore Teams.

Extensive Experience in Tibco EMS, Tibco Rendezvous, Tibco Business Works,Tibco Adapters (ADB Adapter, File Adapter, MQ Adapter etc), Tibco Administrator, Java Adapters SDK, Hawk.

Well experienced in Developing, Customizing, Testing, Interfacing and integrating different Web based, Client Server, Distributed, Enterprise Application Integration, Business Integrations and Applications.

Experience in Administration, Configuration, Deployment, Monitoring and Performance-Tuning

Good understanding of webMethods pub-sub architecture.

Excellent Banking Domain Knowledge

Experience in developing SOA-Compliant Integration applications.

Worked with WSDL/Soap and Rest Web Service/Web Service descriptor.

Expert in building Flow services and custom Java services

Hands-on experience in configuring and setting-up webMethods JDBC, SAP R/3 and MQ Adapters.

Experience in working with various Data formats such as XML, Flat Files (Delimited, Fixed length), EDI (ANSI X12) & other proprietary formats.

Worked on encryption – decryption at Channel level and at data level using AS2 for EDI, PGP and SSH for sFTP.

Well experienced in the conversions from one file format to another and highly knowledgeable of mapping and code logic concepts.

Well experienced in Debugging, Validating and Testing the developed applications

Experience in creating and configuring HTTP, HTTPs, sFTP, FTP, FTPs, File Polling and SMTP Ports for both Outbound and Inbound communications.

Worked on sharing and installing the certificates in case of HTTPs

Experience with Oracle triggers, views, SQL queries and procedures

Experienced in extending Support for the Projects that are in Production environment

Well-versed in preparing Technical Design Specification Document, Mapping Document and Deployment Check-list

Deep-involvement in Requirements gathering from Business Analysts, Study, Design and Development

Involved in UAT(User Acceptance Testing) and Go–Live cutovers

Possesses strong analytical, trouble-shooting and problem-solving skills.

Active team player and self-starter with immense ability to grasp new concepts and apply them.

Well versed with various Project development Methodologies such as Waterfall, Agile, and Iterative.

Excellent verbal and written communication skills and presentation skills

Professional Certifications:

TIBCO Certified Professional for TIBCO ActiveMatrix BusinessWorks™

TIBCO Certified Professional for TIBCO Enterprise Message Service™ 6

Professional Education:

Master of Computer Applications (MCA) from G.B.Pant Engineering College, India.

Bachelors of Science from Gurukul Kangri Hardwar, India.

Technical Skills:

Operating Systems:

AIX, Mainframes Unix, Windows XP/NT/2003, DOS

Languages:

JDK 1.4, HTML, XML, UML, Java Script, VBScript, SQL, PL/SQL, C, C++, Shell Script, Ant Build Script

TIBCO Expertise:

TIBCO Messaging EMS 6.0, Rendezvous 8.0, 7.5.2, TIBCO ActiveMatrix Business Works 5.x, Business Connect, TIBCO Adapters: ADB Adapter, File Adapter, MQ Adapter

TIBCO Custom Adapters/SDK, TIBCO Monitoring Hawk 4.7.

Technologies:

J2EE, Struts with Tiles, Servlets, JSP1.2, JDBC, JTA, JNDI, RMI, XML, SOAP, WSDL JMS, JNI, Java Mail, LDAP.

Databases:

IBM DB2 8.1, Oracle 9i, MS SQL Server 7.3, Sybase 10.0

Modeling Tools:

VISIO, Rational Rose

Design Patterns:

MVC, OOAD Methodologies, EJB Design Patterns

Application Servers:

IBM Rational Application Developer 6.0, IBM Websphere, BEA Weblogic, Tomcat, iPlanet

IDE Tools:

ECLIPSE 3.1, WSAD 5.1.1, RAD 6.0, IDEA and JDeveloper

Source Code Control:

TFS, CVS, CMVS, and VSS

Others:

Microsoft Project Plan, Test Director

Professional Summary:

BGE (Baltimore Gas & Electricity), MD Sep 2013 Present

Sr. System Integrator

Smart Grid - Baltimore Gas and Electric’s Smart Grid Initiative (SGI) involves replacing or upgrading more than 2.1M electric and gas meters.

As part of Smart Grid project BGE integrated with various applications like MDM, CC&B, data warehouse . Smart Grid also integrated the third party companies like Opower to send notifications to customers. Opower is a third-party company being utilized by BGE to help meet its energy efficiency goals through effective customer engagement by converting interval data generated from AMI meters into home energy reports, high bill alerts and near real-time online metrics that will be integrated with the BGE.com website for a rich customer experience.

To support Opower analytics and delivery of home energy reports and bill alerts to appropriate customers, BGE is expected to sync customer contact preferences with Opower. This integration process will capture any customer notification preferences changes published from CC&B.

Responsibilities:

Involved with the architectural meetings for the development and designing of the processes.

Creation of technical designs for the Tibco Services.

Design of the integration flow between various tiers from source to target using SOA approach.

Developed several TIBCO/BW based services to integrate various Oracle applications.

Designed and developed main Business Works processes to implement the integration service.

Developed both synchronous and asynchronous web service.

Integration of Tibco services with Oracle application.

Involved with creating Continuous build and Test continuous integration environment using SOAP UI.

Creation of unit test plans, test cases and participated in code review meetings.

Helped the front end team to retrieve data from Hogan mainframe.

Worked extensively on IBM Rational Clear-case for version control and parallel development support.

Environment: TIBCO BW 5.9, TIBCO EMS, TIBCO Administrator, WebSphere MQ, Tibco ADB, File, MQ Adapter UNIX, MS-DOS scripting, Oracle 10.x, sybase, MS SQL, Java, html and JavaScript

NIH (National Institutes of Health), MD Feb 2013 Aug 2013

Sr. Tibco Developer

The National Institute of Health (NIH) is currently using and interfaces with the GovTrip eTravel solution. NIH will be migrating to the new ETS2 solution by early calendar year 2014. There will be a period of time during deployment that the NIH Business System (NBS) will process transactions from both Govtrip and ETS2.

NIH NBS-ETS2 Integration project includes replacement replacing of existing Oracle 10gAS Message Driven Beans (MDB)’s with the TIBCO interfaces for the integration between the eTravel vendor and NBS. Initially these TIBCO interfaces will be used for the integration with the existing vendor i.e. GOVTRIP and will be re-used for Phase 2.2 of NIH NBS-ETS2 Integration (integration of ETS2 vendor i.e. Concur) with some customization.

Responsibilities:

Involved with the architectural meetings for the development and designing of the processes.

Creation of technical designs for the Tibco Services.

Design of the integration flow between various tiers from source to target using SOA approach.

Developed several TIBCO/BW based services to integrate various Oracle applications.

Designed and developed main Business Works processes to implement the integration service.

Developed both synchronous and asynchronous web service.

Integration of Tibco services with Oracle application.

Developed the transformation by using state-of-art transformation technology “Contivo Analyst”. It was mainly used to transform XML format to FFD format and vice versa for integrating with Mainframe(HOGAN).

Designing of the .cpy file for parsing the data for COBOL Copybook.

Deployment of the project into various environment by using TIBCO BusinessWorks Administrator.

Involved with creating Continuous build and Test continuous integration environment using SOAP UI.

Creation of unit test plans, test cases and participated in code review meetings.

Helped the front end team to retrieve data from Hogan mainframe.

Worked extensively on IBM Rational Clear-case for version control and parallel development support.

Environment: TIBCO BW 5.6, TIBCO EMS, TIBCO Administrator, WebSphere MQ, Tibco ADB, File, MQ Adapter UNIX, MS-DOS scripting, Oracle 10.x, sybase, MS SQL, Java, html and JavaScript

Citi Group, MD Aug 2007 – Jan 2013

Sr. Tibco Developer

The purpose of the project was to integrate CRM (Chordiant) application is integrated with different end application using Enterprise Service Bus. TIBCO Business Works is used in ESB for data mapping & manipulation.

My Role here was to design, development, Requirement Gathering, Production Support for tibco services, mentoring the Integration development team, Ensuring the quality assurance of deliverables

Responsibilities:

Involved with the architectural meetings for the development and designing of the processes.

Creation of technical designs for the web services.

Design of the integration flow between various tiers from source to target using SOA approach.

Creation schemas and WSDLs using US Bank standards.

Creation of SOAP over JMS and SOAP over HTTP Web Services and configuration of Web Services.

Developed several TIBCO/BW based services to integrate various retail banking applications.

Designed and developed main Business Works processes to implement the integration service.

Configured service for Activating and Unsubscribing the subscriber from Firethorn Mobile Banking application.

Developed both synchronous and asynchronous web service.

Integration of Tibco services with Siebel.

Integration of Tibco services with Orion.

Implementation of WS Security using certificate format like X.509 token and Username token.

Developed the transformation by using state-of-art transformation technology “Contivo Analyst”. It was mainly used to transform XML format to FFD format and vice versa for integrating with Mainframe(HOGAN).

Designing of the .cpy file for parsing the data for COBOL Copybook.

Deployment of the project into various environment by using TIBCO BusinessWorks Administrator.

Involved with creating Continuous build and Test continuous integration environment using SOAP UI.

Creation of unit test plans, test cases and participated in code review meetings.

Helped the front end team to retrieve data from Hogan mainframe.

Worked extensively on IBM Rational Clear-case for version control and parallel development support.

Environment: TIBCO BW 5.6, TIBCO EMS, TIBCO Administrator, WebSphere MQ, Tibco ADB, File, MQ Adapter UNIX, MS-DOS scripting, Oracle 10.x, sybase, MS SQL, Java, html and JavaScript

Western Union Money Transfer Nov 06 to Aug 07

Role: Tibco Developer

Project Description:

Compliance Workflow Management

Western Union is subject to a variety of legal requirements that entail pending and reviewing transactions conducted by certain consumers. The scope of this project is to automate the workflow activities for investigating transactions that are pended / queued for the some reason like over limit, security, duplicate transaction.

Responsibilities: -

Contributed significantly to application architecture and to the design of infrastructure frameworks and middle-tier components.

Involved in developing business layer, deployment layer and infrastructure layer components.

Coded Tibco Business Works processes for enriching Trade with Matrix/MCA information, submission rules, 9-Digit RED Id.

Developed a JMS based TIBCO BusinessWorks processes using TIBCO designer for processing DTCC Eligibility rules.

Participated in development of Multithreading Java and Tibco Core Framework for the application.

Involved with creation of Web Services TIBCO BusinesWorks using SOAP over HTTP approach

Involved with deploying and Managging Tibco applications using Tibco Adminstrator as well as utilities such as App Manage and BuildEAR

Involved in coding the value objects for better data exchange between the layers.

Developed generic Email Sending component to handle different types of email messages like text/plain and text/html during trade events and exception.

Involved with configuring TIBCO ADB adapter to integrate Oracle database

Responsible for assembling and deploying server-side J2EE components like MDB in WebLogic Application Server and configured Foreign JMS server in WebLogic server.

Application involves WebLogic (Clustered) architecture design to ensure Application Scalability, Load Balancing.

Developed a collection of Data Access Objects (DAO) in Access layer and each DAO have a well-defined interface and the associated implementation.

Developed business object components for Business Logic layer, each business object component that requires access to data have an associated DAO. All the components have a well-defined interface and implemented as POJOs.

Developed infrastructure components, which includes uniform exception handling, application monitoring JMX using Phoenix Lehman’s application monitoring framework.

Developed replay component to replay the exception message after fixing the data in the message.

Designed the UDB hybrid data model to persist the XML and required XPaths efficiently.

Created Synthetic transactions that are used expressly to perform application-level monitoring.

Performance tuning and analysis of Java Heap and used Unix Sar utility to monitor the entire process.

Created common Data model for all downstream systems, stored procedures, triggers, user defined functions and Views and wrote complex SQL queries to improve performance.

Environment: TIB/Business Works (BW) 5.X, TIBCO General Interface 2.x,Tibco RV 7.3,J2EE, JSP, AJAX, JDBC, Eclipse, Web Services, UML, Tomcat,, ADB Adapter, TIB/EMS, Web Services, WSDL, TIBCO Hawk, Smartmapper, Business Events, XML spy, C++, Win2K, HP-UX, Solaris, Oracle 10g, Telcordia LNP web Services,

Merrill Lynch Sep 06 to Oct 06

Role: Tibco Developer and Java Developer

This project at Veritas involved migration of Oracle 11.0.3 to Oracle 11i and integration of various applications (Marketing applications) with Oracle 11i. It involved the integration of Customer master with various sales application systems (VCompass, Titan, Pivotal) and also the automation of sales order submission from various sales applications systems, EDI and oracle apps.

Responsibilities:

Name and Address Implementation

Involved in the design of the integration flow between Oracle 11i Customer Master and Sales Application.

Developed the XSD for Common Data model for Customers using TIBCO/Turbo XML.

Configured the TIBCO/ADB adapters for publishing the Data from Sales Application

Developed the transformation logic in TIBCO/Business Works for transforming the data from Sales application format to Common data Model and publish the data JMS messages

Configured the TIBCO/Oracle Apps Adapter for publishing the customer data from Oracle Apps

Developed TIBCO/BW Process for transforming the data between Common Data model and Oracle Apps format

Sales Order – Oracle 11i - Titan

Developed XDS for Sales Order Common Data Model using TIBCO/TURBO XML

Configured TIBCO/ADB publication services for Sales Order Publication for all the sales applications

Developed TIBCO/BW processes for transforming the data Sales Applications format to CDM and to Oracle Apps Staging tables

Configured Subscriptions service on TIBCO/Oracle Apps adapter for Sales Order subscription to the staging tables

Set up the PL/SQL procedures to call the Order Import API to move the data from staging tables to Oracle Order workbench

Sales Order – Oracle 11i – EDI (850)

Configured the TIBCO/Business Connect to – set up the trading host, trading partners and EDI protocol to receive the order data

Configured the private process to receive the order data and submit it TIBCO/Business works process to load the order data into the order staging tables of Oracle 11i

Testing and Migration

Created the test scripts and test cases for unit and integration testing

Involved in UAT and load testing

Environment: TIBCO BW 5.1, TIBCO ADB, TIBCO Siebel Adapter, EMS 4.2, Hawk 4.5.1, Oracle 9i, Windows, Solaris 8

AE Shipping System Aug 05 to Aug 06

Role & Responsibilities: Tibco & Java Developer

Project Description:

Shipping System

This project is being developed for AE Ltd, which is into granite business. The company has sales office at Chicago, Finance and Directors office at London and Buyers office at Chennai. A lead is generated by sales office and is converted into an order. The order is send to buyer's office. The buyer’s office purchases the material from suppliers and sends it to client. Through out the process approval is taken from finance office and director’s office at different stages. The system automates the whole process on web. Different reports are generated which can be views by different users depending on rights given to them by administrator.

Access Service Request Outbound Project

The project involved the address verification of the supported vendors of Level (3) Communications to provide Offnet services by connecting regional enterprises, local service providers, and regional carriers with high availability, nationwide network access and high performance data, voice and internet solutions.

Responsibilities:

Analysis of the issues and bugs reported or any new enhancement requests.

Coded using Java, Servlets, EJBs, JavaScript and XML.

Developed a common object model based on SOAP 1.1 specifications.

Developed a java based FTP program to FTP data from the DMZ server to JMS.

Developed a TIBCO interface to integrate the FTP program with a file poller which polls for new data from 3COM’s server.

Developed a content-based router to route messages to various destinations.

Wrote the stateless session beans for the business logic.

Involved with reverse engineer and migration of Integration Manager processes to Tibco Business Works flows.

Involved with maintenance and production support of old IM Processes, maintenance of IM engines, Monitoring Jobs and integration with Hawk.

Reviewed the code by team mates and resolved code review reports to meet coding standards.

Fixed CRs (Change Requests) and completed unit testing and verification of CRs.

Prepared test cases and performed the testing as per test case.

Responsible for developing the XML’s by querying the relational data using SQLX.

Documented the analysis to solve issues.

Implemented the fixes in production as per the change management cycle.

Environment: TIB/Business Works (BW) v5.2, JMS- TIB/EMS v4.0, TIBCO Integration Manager 4.X, Cyclone Server v4.1, Oracle 9i, eclipse 3.0, Ant v1.4, Tomcat v5.0.28, PL/SQl developer v 6.0.5, XML spy, JSP,XSLT, Servlets, EJB, XML. XSLT,AJAX, Adobe Flex, Oracle 9i/10g, TOAD, Eclipse3.1, RAD, JavaScript, Java Parser for XML (SAX, DOM), WebSphere 6.0, WebLogic, UNIX shell scripting, Windows XP.

Contact this candidate