Data Sql Server
Resume:
Suchetha
********.*****@*****.***
PRFOESSIONAL SUMMARY:
Over 8 years of total IT Experience in Analysis, Design, Development and Testing of Client-Server and Enterprise Application Integration (EAI), A2A (TIBCO Business Works)
More than 6+ years of Experience in Integration of Systems with TIBCO Suite of Products.
Extensive Experience in Designing and Development using TIBCO products like TIBCO Business Works, TIBCO Business Events, TIBCO EMS, TIBCO Rendezvous, TIBCO Designer, TIBCO Administrator, TIBCO Hawk.
Good understanding of BPM (Business Process Management) and SOA (Service Oriented Architecture).
Administered Spotfire programs and supported library management.
Evaluated log files and implemented performance tuning.
Supported Spotfire logs for resolution of issues.
Worked in Finance Domain, which encompasses a broad range of organizations that manage money, including credit unions, banks, credit card companies, insurance companies.
Experience in using messaging standards such as JMS, MQ Series, TIBCO EMS and TIBCO Rendezvous for developing distributed applications.
Administrative experience in TIBCO EMS/JMS – installing the EMS, creating Queues, Topics, User’s and Roles & configuring various EMS options.
Expertise in implementing SOA concepts by designing and developing Web Services using WSDL, SOAP and Service palettes creating SOAP/HTTP and SOAP/JMS with TIBCO Business Works.
Expertise in implementing XML technologies–XML, Turbo XML, XPath, XML SPY, XSD schema, XSLT.
Worked on integrating various applications with TIBCO Active Database Adapter, TIBCO File Adapter, DB2 Adapter, TIBCO SAP R/3 Adapter, and Oracle Apps Adapters using TIBCO Business Works.
Implemented Restful service to be invoked by the frontend systems
Excellent experience in creating and deploying EAR files and running them in TIBCO Administrator in both load balancing and fault tolerance modes.
Extensive experience working with TIBCO Hawk in monitoring Business Works Engines and log files.
Worked on TIBCO Active Matrix Policy Manager for authentication and authorization.
Experience in Message Oriented Middleware (MOM) such as TIBCO Enterprise, IBM MQSeries5.3 and Sun Java Messaging Services (JMS) specifications, JNDI.
Having Upgrade Experience for Tibco Business Works, Business Events and I Process.
Experience in developing Complex Event Processing Applications using Tibco Business Events (3.x/4/x and 5.x).
Worked on TIBCO Active Matrix Lifecycle Governance Framework for governance of services.
Worked extensively in RDBMS technologies such as ORACLE 10g/11g (SQL and PL/SQL), MS SQL Server 2005 and My SQL.
Expert in writing Stored Procedures, Functions, Database Triggers, Packages, SQL Server Jobs using TSQL and PL/SQL. Proficient in SQL Server - Data Transformation Services (DTS).
Strong analytical and aptitude skills for trouble shooting, installation and configuration.
TECHNICAL SKILLS:
TIBCO Integration
TIBCO Business Works, TIBCO Active Matrix Service Grid, TIBCO Active Matrix Service Gateway, TIBCO Administrator, TIBCO TRA,
TIBCO Administrator
TIBCO Administrator, GUI/Silent/Console based installs
TIBCO Messaging
TIBCO Enterprise Messaging Service (EMS), TIBCO Rendezvous (RV), MS MQ, MQ Series.
TIBCO Protocols
SOAP, WSDL, Soap/http, Soap/JMS, EDI, HIPAA, EDIFECS Specbuilder
TIBCO Adapters
TIBCO Active Database adapter, TIBCO File adapter, TIBCO SAP R/3 adapter, TIBCO adapter for remedy, People Soft Adapter
TIBCO Monitoring
Tibco Hawk 4.7, Hawk Accelerator
Scripting
Shell Scripting & Ant Scripting
Languages
Java, Angular JS, C#, C++, HTML, XML XPATH, XSLT, XSD, SOAP, XSLT, WSDL, OOPS
Databases
Oracle,DB2, Sybase, Microsoft SQL Server.
Operating Systems
Windows XP/2000/2003, UNIX (Solaris, Linux), HP-UNIX, Macintosh OS
PROFESSIONAL EXPERIENCE:
Knoll, Implementing Partner- Velocistech, Plano, Texas Oct’2015 – Till Date
Sr TIBCO Developer/Admin
Roles & Responsibilities:
Created detailed design documents for all the business interfaces.
Involved in the creation of detailed design documents for the system as whole and all the integration interfaces.
Formulated data standards and implemented master data conversion.
Suggested and executed modifications for MDR and SDR levels.
Prepared new master data files by checking duplicates.
Implemented and supported data cleansing and maintenance tasks.
Analyzed and resolved repairing issues of end user devices.
Developed business processes by configuring shared resources, creating process definitions, creating activities, configuring message transports using TIBCO Business Works.
Extensively used Business Works to do the complex data mapping & transformations.
Complex integration of all the applications has been done with real-time data transfer (high throughput).
Involved in configuration of EMS server for high availability & high scalability (load balancing & fault tolerance).
Created BW EAR files containing process & adapter archives and deployed them by configuring in Administrator. Further all the process engines & adapter components had been started to check whether it performed as desired.
Configured design-time MQ Series Request / Reply adapter for connecting to external application.
Application integration using IBM WebSphere Enterprise Service Bus 7.x.
Involved with integration of the enterprise components system manager and data replicator.
Expertise in Websphere Cast Iron, IBM Web Sphere ESB and Mule ESB technologies
Configured design-time SAP R/3 Adapters for connecting to SAP system and external applications.
Unit-tested developed business interfaces and resolved development issues found during unit testing.
Extensive testing of TIB/SAP 6.2 adapter in various service modes against SAP applications, TIBCO designer, TIBCO Business Works, administrator, hawk, EMS, RV in various platforms.
Configured SAP Adapter services to read and send the data from SAP applications using BAPI and IDOCS Interface.
Documentation of technical specification, business requirements, functional specifications for the development of Informatics mappings to load data into various tables and defining ETL standards.
Development and configuration of TIBCO MQ Series Adapter for integrating with IBM MQ Series
Implemented various business processes with TIBCO EMS, MQ Series, FTP, MQ-FTE and secure transportation protocols.
Designed Workflow process with iProcess, assigned different level permission and task to client users according deferent steps.
Hands-on with CEP technologies and TIBCO Business Events in developing eventing applications using Complex Rules, State Machines, Decision Tables and Caching techniques
Worked on solution involving Business Events and Business Works to enrich event data and leverage legacy applications in Complex Eventing Application.
Proficient with Model Driven Architecture (MDA) and Complex Events processing concepts, its implementation with TIBCO Business Events.
Developed Tibco BW applications with use of file adapter, ADB adapter and iProcess pallete.
Configured Tibco BW applications in iProcess procedure as per business flow and also iProces procedure steps in BW application to work on cases
Worked on JMeter to perform web application testing and load testing.
Conducted Load testing on web applications using LOADUI and JMeter
Product list API Exchange (ASG), Policy Director, BWPM, BW, EMS, Hawk, Rest, Active Matrix Administrator, Spotfire Server 5.5/6.0.
Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
Conducting Unit testing of the reports developed in Spotfire Professional.
Requirement /Functional and technical specification of BPM applications.
System design of TIBCO IProcess BPM applications.
Design and development using TIBCO IProcess 10.6.
Proof of concept on SLA management using TIBCO Business Events 3.0 /Rule Management.
Business process modeling competency and best practices.
Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
An exclusive experience working with User Controls with VB.NET code-behind files, debugging and Quality Testing of the code.
Used different Telerik Rad Controls, Free Textbox in Visual Studio applications and Sitefinity.
Developed classes and interfaces for the Data Access layer using VB.NET, ASP.NET ADO.Net, and SQL 2000 data access library.
Designed user interface using ASP.NET.
Carried out System Integration Testing (SIT) where data flows between Legacy System via Internal Tibco application to 3rd party vendor application
Created trigger messages for BW Engine to activate Tibco jobs in batch processing.
Analyzes, tests, debugs, and documents programs in WebSphere, TIBCO, Fuze, Mule or Denodo technology
Manage re-architecture of Jenkins and integration with Confluence for release management and documentation assets. Re architect a Maven based system reducing build times.
Implemented a Continuous Delivery pipeline with Docker, Jenkins and GitHub and AWS AMI’s, Whenever a new GitHub branch gets started, Jenkins, our Continuous Integration server, automatically attempts to build a new Docker container from it, The Docker container leverages Linux containers and has the AMI baked in
Provided technical assistance for development and support on JBoss application server platforms.
Implemented procedures for configuration and deployment of production JBoss applications.
Review requirements and design documents with developers and quality assurance manager to confirm expected functionality with technical and business needs
Experienced with Implementation, evaluation and documentation of the developed test cases and scenarios
Experienced with Middleware, integration and testing in big data environment. Experience with SQL, End to end testing, integration testing and middleware testing
Environment: TIBCO Business works (5.x, 6.x), TIBCO Business Events, TIBCO Designer (v6.x), TIBCO Adapter for Files 6.x, TIBCO EMS (Enterprise Messaging Server, v4.x), ETL, TIBCO Administrator (Enterprise Edition, v5.x), TIBCO Hawk 4.8.x, Rational Clear Case, MQ Adapters (v6.2), SAP R/3 Adapters (v6.2), JBoss, Jenkins, VB.Net, ASP.Net.
Merck & Co., Inc, Dallas, Texas Aug’2014-Sep’2015
Sr TIBCO Developer/Admin
Project: COMET (Collaborating as One Merck to Enable Transformation)
The COMET (Collaborating as One Merck to Enable Transformation) initiative is SAP implementation at MERCK there by bringing in the Master data into one centralized SAP system. This project involves identifying that the systems and the modules that needs to be replaced or moved into the SAP system. This movement of the modules would also now involve re-pointing and re-visiting the existing interfaces which are mostly point to point.
Roles & Responsibilities:
Developed a TIBCO Business Works process which will read the request append to a file and transfers the file based on what type of a file it is (i.e. Real time or Batch file].
Worked on concept history in persistent data mode and solved business problems with very little database operations.
Implemented Database Concepts by DB import tool and worked with Oracle Database schema operations.
Configured ADB adapter to connect to Oracle 10i to get the disposition data from the Predictive Dialer application and call other services to update the interactions.
Implemented error handling, logging and auditing by making use of Common Services and TIBCO activities.
Configuring the Common Services in the TIBCO projects.
Created unit, integration and system test plans for the developed interfaces.
Facilitated establishing TIBCO Business Works coding and subject naming standards.
Involved in code walkthroughs with the Integration Architects and fine-tuned the application for better performance.
Created EAR Files for the developed BW components.
Deployed the projects onto different environments by using TIBCO Business Work Administrator.
Designing and Developing the Business Processes.
Maintained detailed documentation of MDM service mappings.
Designed and developed ETL, DQ and master data management programs.
Implemented data transformation activities utilized SQL and Perl scripts.
Prepared unit tests for maintenance of data quality and integrity.
Suggested enhancements for data warehouse and MDM solutions.
Build Integration Services to exchange messages and data between disparate Merck enterprise applications and external vendors.
BPM Code review for all deliverables.
To create various modules to cater the actual account opening process for corporate customers.
Worked on integration of AMX BPM with BW, Filenet, Spotfire related to project.
Unit testing of the modules along with regression and Integration testing.
Creation of Input/output Schemas for the services
Implemented Web services components SOAP, WSDL, and UDDI to interact with external systems by using TIBCO BW as part of SOAP.
Designed integration framework for real time, near-real time, and batch integration services.
Designed interfacing requirements for applications with Web-Services via SOAP/HTTP and SOAP/JMS
Created EAR Files for the developed BW components and deployed TIBCO components with support for Load balancing and Fault Tolerance using TIBCO Administrator.
Configured EMS servers in fault tolerance mode.
Derived the mapping documents
Used FTP and MQ-FTE protocol to transfer file from TIBCO to various legacy systems.
Designed and Developed process by using MQ Adapter to publish, request/reply messages from CC&B system to Outage Management System (OMS).
Conducting Unit testing of the reports developed in Spotfire Professional.
Responsible for the migrating the reports from Development to Acceptance / Production Server.
Installed and Configured the Spotfire Statistics Services on a standalone Installation
Optimized Information links and queries to increase performance Design and implementation of a global, enterprise class Spotfire environment.
Used CDISC knowledge to develop SDTM datasets for various domains and ADaM analysis datasets.
Performed extensive programming on SAS involving SAS/Base, SAS/Macros, SAS/Graph, SAS/STAT, SAS/SQL, T-Test, Fischer exact test, Chi-square test, One-Way ANOVA, proc means and freq etc.
Applied SAS/STAT to present results in BAR charts, LINE plots, and SCATTER plots. Extensively used various procedures such as PROC (Such as PRINT, SQL, UNIVARIATE, MEANS, FREQ, TABULATE, REPORT, SUMMARY, GPLOT, GLM and IMPORT.)
Prepared the unit test cases and deployment workbooks
Delivered the development specific documents
Handled Change requests, Bug fixing and performance tuning
Configuration of SSL in Composite Services
Involved in Designing and Developing the Composite views and understanding the mapping requirements and creating the composite views and published to Target systems
Involved in creation of Unit test case plan
Configuring the File and ADB and SAP R3 Adapters
Developing Hawk rule bases
Independent Unit Testing
Resolving technical issues during deployment.
Ensured that client and end-user requirements were met for various projects.
Worked with system engineers to develop and design production applications.
Prepared project proposals and participated in status meetings.
Maintained and updated code for various Dot Net applications.
Prepared system analysis reports and supporting documentation.
Environment: TIBCO BW 6.3, TIBCO EMS 6.0.1, TIBCO TRA 5.8, TIBCO Administrator 5.8, TIBCO RV 8.4.0, JDK 1.7, SOAP UI, Composite Studio 6.1,6.2, SmartSolve 7.04, Composite Server 6.1,6.2,Web sphere MQ, SQL Developer, SAS 9.1, Oracle 11g DB, Putty, VB.Net, ASP.Net, Angular JS, .
Oncor, Dallas, TX Dec’2012 – Jul’2014
Tibco Developer/Admin
Roles & Responsibilities:
Installed and configured the following TIBCO Active Enterprise Product Suite
Created Business agreements, participants, and operations in Business Connect.
Configured and deployed the Business Connect Gateway server.
Installed and configured ADB Adapter to integrate with Data Bases.
Working with offshore team members of 5
Designed and developed the TIBCO BW processes for the different flow of data formats.
Created Queues, Topics on TIBCO JMS Server for all the applications.
Created the Logging and Exception handling framework against the needs of an enterprise level solution.
Setting up the environment for upgrading TIBCO AMX BPM 1.3.1 HF 03 to 2.1.0 HF 4 (latest version).
Created different hierarchical, interactive storage reports using C# for Streams/OpComs, Locations, Datacenters that displays monthly, most recent Capacity, Assigned, Used, Unused, Efficiency, Cost figures
Utilized Java, Eclipse/ J2EE, tested programming code & Applications, collaborated with team and management.
Designed and developed the automated trading software for back testing historical trading data in java platform.
Deploying the application in Test, Staging and Production environments.
Migrating 100+ Interfaces in from 2.3.0 to 3.3 Tibco Active Matrix Service Grid.
Configured SOAP protocol in Business Connect.
Deployed applications using TIBCO Administrator/TIBCO Scripted Framework GUI in Dev & test environments.
Administered Spotfire programs and supported library management.
Evaluated log files and implemented performance tuning.
Supported Spotfire logs for resolution of issues.
Participated in connection of Spotfire with Oracle data sources.
Implemented system modifications as per established requirements.
Built calling services from BW to iProcess & iProcess to BW, integration with LDAP.
Good at using shared and global variables across crystal reports
Design and Implementation of IBM MQ Series Cluster environment.
Development and configuration of Tibco MQ Series Adapter for integrating with IBM MQ Series.
Validate any equipment, software or system that directly or indirectly affects their product.
Worked with marketing and sales to create a series of Crystal Reports. Instituted on-line reporting on the company intranet.
Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
Modeling workflows using iProcess modeler and developing TIBCO iProcess SSO API calls to get both XML and field case data from iProcess into Business works.
Created Hawk Rules, configured filters in RT-View.
Having hands full experience on installing TIBCO Rendezvous (RV) messaging product for real-time data distribution application.
Created mapping matrix to convert custom data to common data and common data to custom data.
Analyzed Rendezvous messages created by Tibco and validated them against XML messages and Schemas.
Involved in end-to-end testing of the Web/Mobile applications and its interactions with ERP Systems using SOA, Middleware - TIBCO systems.
Coordinated with the development team for any code deployment issues.
Involved in configuration of EMS connections and setting up TIBCO EMS Servers.
Environment: TIBCO Business Events 5.X, Pilgrim SmartSolve 7.04, Solaris, Windows XP Servers. EMS 7, TIBCO Business Works 5.10, Rest, Tibco CLE, TIBCO Hawk Microsoft Visual Studio.
Magna, Pune, India Jun’2011 – Nov’2012
Tibco Developer
Roles & Responsibilities:
Actively participated in the meetings to identify the interfaces required for integration with both the SAP and Legacy systems teams.
Configured Active Database Adapter for database transactions.
Involved in design, development and testing of the interfaces using TIBCO BW.
Developed BW Process Templates for reusability of BW Process logic.
Configured the SAP adapter in Publication, Subscription and Request-Response mode.
Configured the File adapter in publication and subscription mode to publish and subscribe to the legacy LogPro systems.
Involved in the deployment of the projects using the TIBCO Administrator.
Modified the WSDL's to interact with eCommerce systems.
Deployed the application in DEV and STG environments.
Involved in design and development of logging and error handling processes.
Installation, maintenance and monitoring of TIBCO Applications and EMS destinations. Deployment of TIBCO Business Works to the testing environments.
Monitored the cut over activities for smooth migration of code into PROD (Production)
Involved in creating EAR files and deploying BW projects in various environments.
Involved in the development and configuration of TIBCO BW business processes to various components such as Oracle database and also performing various data mapping and manipulation.
Used XML Canon, Perforce for implementing version control system.
Involved in peer review of UTP, UTP Results and Code Review docs.
Environment: TIBCO EMS 5.x, TIBCO Business Works 5.x, TIBCO SAP R/3 Adapter, File Adapter, XML, XSD, TIBCO Administrator 5.x, TIBCO Hawk, Oracle, Windows and UNIX.
CSM Software, Banglore, India Jul’2009-May’2011
Tibco Developer
Roles & Responsibilities:
Installed and configured TIBCO Active Enterprise products, ADB Adapter and File Adapter.
Customized and configured SQL queries and Active Database adapters to various applications.
Configured the Active Database Adapter to connect to Oracle 9i and SQL server.
Developed several processes to map incoming transactions from application specific messages to common messages and vice versa.
Designed and developed TIBCO Business Works processes to manage transactions and integrate with Oracle Applications.
Implemented TIBCO, SOAP Server processes to provide Warehouse Management functions to various third party vendors.
Wrote SOAP Server WSDL files to provide definitions for available operations.
To revamp existing tightly coupled codes to loosely coupled code based on SOA and also to eliminate all hard coding.
Designed Service oriented Architecture to enable users to dynamically discover services stored in the UDDI Active Matrix Registry.
Developed release notes documents to provide support personnel with build installation instructions.
Actively communicating with other middleware/backend teams, provide solutions, etc in requirement gathering, design, development and testing phases of Agile SDLC while rolling out the product.
Deployed EAR files within various environments using TIBCO Administrator.
Environment: TIBCO Business works 5.x, XML, JDBC, TIBCO Designer, TIBCO ADB Adapter, TIBCO Administrator 5.x, TIBCO Rendezvous, Active Matrix Registry, TIBCO JMS, TIBCO File Adapter, UNIX, Oracle9i, SQL Server, PL/SQL and SQL Navigator.
Education:
Bachelors in Electronics and Communication Engineering, Hyderabad, India, 2009.
Contact this candidate