Sathish Mannepalli

Sr. Tibco Consultant - Sanofi

Jersey City, NJ

ac0h9w@r.postjobfree.com

• Sr. Developer with around 10 years of professional IT experience in Analysis, Design & Development and production support using TIBCO suite of Products.

• Experience in analysis, design, development, deployment, testing and production support of EAI projects using TIBCO products in Banking, Telecom and Pharma domain.

• Extensive Experience in installation, configuration, deployment and troubleshooting of TIBCO Active Enterprise Suite of applications TIBCO Business Works 5.x/6.x, TIBCO Designer, TIBCO EMS, TIBCO Active Database Adapter, TIBCO MQ Plugin, Big data Plugin, Salesforce Plugin, Salesforce Bulk API, Service Grid, TIBCO BW Administrator/ Enterprise Administrator, TIBCO SPOTFIRE.

• Experience in Migrating Services from BW 5.x to BW 6.x.

• Expertise in designing and developing real time and batch mode services using 6.x /5.x.

• Expertise in trouble shooting BW services build on 6.x.

• Excellent hands on experience in Web Services using SOAP, WSDL and Schemas XSD with strong skills in understanding and implementing Service Oriented Architecture (SOA).

• Expertise in using messaging standards such as TIBCO EMS for developing distributed applications.

• Thorough understanding of XML, XML Schemas (XSD, DTD), XPATH and XSLT.

• Expertise in using TIBCO Administrator/ Enterprise Administrator for Application deployment and Management.

• Hands-on with TIBCO SPOTFIRE to create visualizations that allow users to quickly recognize patterns, trends and outliers from multiple data sources.

• Worked extensively on visualization properties and complex interactive features such as multiple markings, filtering schemes, configure bar chart, line chart, graphical table, combination chart, scatter plot, pie chart, table, cross table, and summary table visualizations.

• Ability to understand analytic specifications, translate specifications into TIBCO Spotfire visualizations.

• Have given extensive Production Support on the Tibco Products, in various operating systems like Windows and UNIX.

• Hands on experience in python and java scripting.

• Experience in writing Database Queries, Stored Procedures in Oracle.

• Experience in preparing Message Flow Diagrams and Process Flow Diagrams to specify business logic of the work flow model using Microsoft Visio, design documents and release note.

• Used version control management such of Tortoise SVN, Clear Case.

• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Familiarity with JAD & SCRUM methodologies.

• Building and maintaining healthy business relations with clients, ensuring high customer satisfaction matrices by achieving delivery & service quality norms.

• Strong inter-personal, problem solving and analytical skills, proactive and hard working.

• Quick adaptability to new technologies.

• Ability to work in-group as well as independently. Willing to relocate: Anywhere

WORK EXPERIENCE

Sr. Tibco Consultant

Sanofi - Bridgewater, NJ - 2016-10 - Present

Project Name: Symphony.

• Sanofi-Symphony program developing a comprehensive Veeva CRM (Salesforce) solution by integrating it with legacy business units.

• These Legacy Source Systems will be integrated through Big Data Operational Data Store solution providing the functionality of Batch Interfaces.

• Tibco acts as middleware layer between Big Data and Veeva (Salesforce) to process inbound and outbound batches for different functionalities.

Responsibilities:

• Analyzed the existing 5.x services, platform and end systems.

• Identified issues in the current design and proposed new design applying tibco best practices.

• Defined coding standards and standard logging & error handling framework.

• Migrated/ Developed multiple services to 6.x to cater batch oriented and real time services.

• Exposed different functionalities in terms of web services.

• Created various XSD/Schemas, WSDLs, XPATH Transformations

• Configured Big-data plugin to interact with HDFS and Salesforce Bulk API & Salesforce plugin to interact with Veeva (Salesforce).

• Problem determination and trouble shooting for any issues in PROD and Non PROD environments.

• Worked closely with Admin and Infra teams in setting up environments for DEV, SIT and UAT.

• Performed load/stress testing to derive AppNodes heap memories, thread count, flow limit and page threshold parameters to achieve best performance.

• Used TEA extensively to upload EARs, deployments and managing applications.

• Coordinating with upstream and downstream application teams for any support issues.

• Mentoring and providing required training to team on TIBCO 6.x.

• Managing team in offshore onsite model.

Technical Environment

Middleware Technologies Tibco BW 6.3.3/5.12, TEA 2.1, EMS 8.1, Bigdata plugin, Salesforce plugin, Salesforce Bulk API

Databases Oracle 11g.

Supporting Tools sqldeveloper, Jvisualvm, GEMS, Hive, Salesforce workbench, Service Now, etc. Sr. Tibco Consultant

Medtronic, Inc - Raleigh, NC - 2016-06 - 2016-10

Project Name: OOT Automation.

• The Operations Test Support (OTS) group receives many OOT (Out-of-Tolerance) support requests. Processing these requests vary in time & complexity, and take away from other engineering work we have.

• A tool has been developed to standardize OOT processing and to decrease the burden on the OTS group RESPONSIBILITIES:

• Responsible for gathering requirements, analysis, creating documentation, report creation and testing..

• Created Information Links By using Information Designer to pull the data from Oracle Database and SQL data sets required to create the reports.

• Applied data Table Properties, Property Controls, Filters, Joins and Custom functions to get formulated data from Information Links.

• Optimized Information links and queries to increase performance using On-Demand data.

• Involved in development of ANOVA Algorithm using R Scripting and used data functions to get formulated data to perform statistical analysis.

• Used calculated columns to produce p Value, CpK, %Mean shift, etc,. from the ANOVA Algorithm

• Designed and developed complex dashboards using calculated columns, custom functions, property controls.

• Used Iron Python to write scripts to export analyzed results to standard Excel sheets and to stdf (Spotfire Text Data File) formats.

• Used Java script and Iron Python extensively in text area to provide different controls/ filters to users, Validation of property controls etc,.

• Created technical and design documents, conducted review sessions for technical and business reviews to make sure that, the results are as expected by the business and followed the Medtronic's standards. Technical Environment

Tibco Technologies Tibco spotfire 7.0.

Databases Oracle 11g.

Operating Systems Windows 7.

Others sqldeveloper, Java Script, Java Script, Iron Python, R Scripting. Senior Tibco Consultant

CITI Bank, NJ - 2015-10 - 2016-04

Project Name: FlexiBUS Migration

• FlexiBUS is the ASB (Application Service Bus) layer for FLEXCUBE; It exposes the Flexcube Functionality in a very standard way, also provide Abstraction & encapsulate the implementation of Internal Flexcube Services. FlexiBUS will provide Real Time online services using TIBCO Technology Stack and File Based Services using Ab-Initio technology Stack.

• This project is aimed to provide assessment with BW 6.x and migrate internal project from BW 5.x to BW 6.x in the initial phase of migration, while next phases targeted to migrate entire BW 5.x stake to 6.x. RESPONSIBILITIES:

• Attended Tibco boot camp training on BW 6.x

• Performed several POCs to familiarize on 6.x concepts and make sure new versions suits for existing and ongoing requirements.

• Involved in migration planning, defining roadmap to migrate services from 5.x to 6.x in phases to avoid any BAU applications and external partners.

• Analyzed the services managed by FlexiBUS, categorized and defined phases for smooth migration.

• Migrated initial phase services to 6.x using BW migration utility in Business Studio.

• Created Migration scripts using bwmigrator utility.

• Created bindings to expose the services via JMS and HTTP protocols in a standard way as components services.

• Created new process modules for the impacted processes during migration.

• Created shared modules in place of design time libraries to avail reusability.

• Worked closely with Admin teams in defining Domains, appSpace and appNodes using TEA (Tibco Enterprise Admin)

• Involved in creation and deployment of migrated applications EAR file into Dev and SIT environments.

• Responsible for production including Level-2 and Level-3 for existing 5.x services.

• Responsible for providing onsite and on call support during business and non-business hours.

• Engaging incident management team during Major outages to calculate business impact.

• Providing support for weekend activities such as, weekend releases, patch set upgrade of tibco products, PVT support, etc,.

• Responsible for repository management, system monitoring, performance tuning, high -availability and Disaster Recovery.

• Problem determination and trouble shooting for any issues in PROD and Non PROD environments.

• Tracking issues using HP QC and Service Now tools.

• Involving project discussions, implementation and implementation support.

• Co-ordinate and plan release activities right from DEV • SIT • UAT • PTE/NFT • PROD/DR.

• Coordinating with upstream and downstream application teams for any support issues.

• Mentoring and providing required training to team on TIBCO. Technical Environment

Middleware Technologies TIBCO Business Works 5.11/6.2, TIBCO EMS 6.3, TIBCO Administrator / Enterprise Administrator,, TIBCO Designer, Business Studio, TIBCO MQ Plugin. Web Services Technologies XML, XSD, XSLT, WSDL, SSL, and SOAP. Databases Oracle 11g

Supporting Tools sqldeveloper, SOAP UI, GEMS, Eagle, WinSCP3, Putty, HP QC, Service Now. Operating Systems Windows 7, Linux server environment. Version control TortoiseSVN

Senior Tibco Consultant

CITI Bank, NJ - Singapore - 2014-07 - 2015-09

Project Name: FlexiBUS CEEMEA Mass Payment integration Work location: Singapore.

• FlexiBUS is the ASB (Application Service Bus) layer for FLEXCUBE; It exposes the Flexcube Functionality in a very standard way, also provide Abstraction & encapsulate the implementation of Internal Flexcube Services. FlexiBUS will provide Real Time online services using TIBCO Technology Stack and File Based Services using Ab-Initio technology Stack.

• The objective of the CEEMEA Mass Payment integration project is to identify the required interfaces in achieving the current product offering of Integrated Payment Services (IPS). It would help in smooth flow of data between all the applications interacting with FLEXCUBE with respect to Mass Payments in CEEMEA. Responsibilities:

• Analyzing the end systems, including Data Model, Protocols, and legacy systems etc., based on functional requirements.

• Field level Analysis against end systems data model and functional requirements.

• Proposing the best solution to address the requirements.

• Preparation design documents and mapping documents.

• Reviewing the design with ICC and getting the approvals.

• Created various XSD/Schemas, WSDLs, XPATH Transformations and XSLT Standards.

• Developed various web services to expose multiple functionalities of Flexcube to partner systems.

• Prepared BW based XSD build tool to automate the XSD preparation.

• Developed key Business Works interfaces between Flexcube and multiple partner systems.

• Created different visualizations using spotfire client that allow branch users to Analyzes earmark Vs account posting ratios.

• Created visualizations for GI NAM and SC EMA transactions which helps Branch users to identify the potential HIT transactions, which helps to analyze and address fraud.

• Created Information Links with Oracle DB and prepared calculated columns using different transformation functions.

• Created code review template, performing the Code reviews and providing the review comments based on coding guidelines.

• Prepared unit test cases covering all touch points of Business Works interfaces.

• Prepared required JMS and MQ objects to enable end to end message flows across different systems.

• Problem determination and trouble shooting for any issues in PROD and Non PROD environments.

• Involving project discussions, implementation and implementation support.

• Co-ordinate and plan release activities right from DEV • SIT • UAT • PTE/NFT • PROD/DR.

• Coordinating with upstream and downstream application teams for any support issues.

• Involved in setting up max jobs and flow limit for the deployed applications by using Tibco Administrator or using application TRA file.

• Mentoring and providing required training to team on TIBCO.

• Responsible for production support during warranty period, L1/L2 knowledge transfer and then L3 support. Technical Environment:

Middleware Technologies TIBCO Spotfire 6.5, TIBCO Business Works 5.11,, TIBCO EMS 6.3, TIBCO Administrator 5.8, TIBCO Runtime Agent 5.8, TIBCO Designer 5.8, TIBCO MQ Plugin 7.5, Web Services Technologies XML, XSD, WSDL, SSL, and SOAP. Databases Oracle 10g

Supporting Tools sqldeveloper, SOAP UI, GEMS, Eagle, WinSCP3, Putty, HP QC, Service Now. Operating Systems Windows 7, Linux server environment. Version control TortoiseSVN

Programmer Analyst

CITI Bank, NJ - Singapore - 2013-03 - 2014-06

Project Name: FlexiBUS Brazil Implementation

Work location: Singapore.

• FlexiBUS is the ASB (Application Service Bus) layer for FLEXCUBE; It exposes the Flexcube Functionality in a very standard way, also provide Abstraction & encapsulate the implementation of Internal Flexcube Services. FlexiBUS will provide Real Time online services using TIBCO Technology Stack and File Based Services using Ab-Initio technology Stack.

• The main aim of this project is to develop a service based applications to integrate the data flow between partners and Flexcube V12 for Demand Deposit Account (DDA) related modules like Customer Management, Account Management, Transaction posting,. Etc. We have used TIBCO ActiveMatrix platform to achieve the FlexiBUS requirements and functionality.

Responsibilities:

• Designed and implemented TIBCO BW processes as a web service exposing different DDA services of Flexcube towards partners.

• Extensively worked on Web Services using SOAP over HTTP and SOAP over JMS.

• Created various XSD/Schemas, WSDLs, XPATH Transformations and XSLT Standards.

• Developed key Business Works interfaces for Customer, Account, and Check & Account posting modules.

• Prepared required JMS and MQ objects to enable end to end message flows across different systems.

• Involved in requirements gathering and in design phase meetings.

• Installed and configured the TIBCO products.

• Prepared the detailed technical design documents for the interfaces.

• Deployed Ear files in different environments in the TIBCO administrator.

• Involved with performance tuning of BW Engines, BW Processes, EMS server and SQL queries

• Using open source utilities and tools in production support like SOAP UI, UNIX shell commands.

• Involved in upgrade of TIBCO BW applications to TIBCO BW 5.11

• Provided Production support/Business Validation support for applications that undergo for deployment changes/Change Requests/Emergency Change Requests/Production Issues.

• Responsible for Support Packages, Hotfixes, Backup/Recovery, repository management, system monitoring, performance tuning, high -availability and Disaster Recovery. Technical Environment:

Middleware Technologies TIBCO Business Works 5.9,, TIBCO EMS 6.1, TIBCO Administrator 5.6, TIBCO Runtime Agent 5.6, TIBCO Designer 5.6, TIBCO MQ Plugin 7.1. Web Services Technologies XML, XSD, XSLT, WSDL, SSL, and SOAP. Databases Oracle 10g

Supporting Tools sqldeveloper, SOAP UI, GEMS, Eagle, WinSCP3, Putty Operating Systems Windows XP, AIX environment.

Version control TortoiseSVN

Tibco Consultant

CITI Bank - Singapore - 2012-07 - 2013-03

Project Name: FlexiBUS SEPA Implementation

Work location: India, Singapore.

• FlexiBUS is the ASB (Application Service Bus) layer for FLEXCUBE; It exposes the Flexcube Functionality in a very standard way, also provide Abstraction & encapsulate the implementation of Internal Flexcube Services. FlexiBUS will provide Real Time online services using TIBCO Technology Stack and File Based Services using Ab-Initio technology Stack.

• The main aim of this project is to provide interface between partners and FLEXCUBE V4 via FlexiBUS for the countries of EMEA region for SEPA Payments module. FlexiBUS acts as pass-through gateway between partners and FLEXCUBE for the Payment/EODSOD Signal. Payments from partners would be initiated which are pass through in FlexiBUS and processed at the back end processing system FLEXCUBE and the Acknowledgements from FLEXCUBE will be propagate to the partners through FlexiBUS. Responsibilities:

• Designed and implemented TIBCO BW processes between Flexcube and Partner systems.

• Developed reusable interfaces to enable partners over 20+ countries across EMEA. Extensively

• Created various XSD/Schemas, WSDLs, XPATH Transformations and XSLT Standards.

• Prepared required JMS and MQ objects to enable end to end message flows across different systems.

• Involved in requirements gathering and in design phase meetings.

• Prepared the detailed technical design documents for the interfaces.

• Deployed Ear files in different environments in the TIBCO administrator.

• Involved with performance tuning of BW Engines, BW Processes, EMS server and SQL queries

• Provided Production support/Business Validation support for applications that undergo for deployment changes/Change Requests/Emergency Change Requests/Production Issues. Technical Environment:

Middleware Technologies TIBCO Business Works 5.9, TIBCO EMS 6.1, TIBCO Administrator 5.6, TIBCO Runtime Agent 5.6, TIBCO Designer 5.6, TIBCO MQ Plugin 7.1. Web Services Technologies XML, XSD, XSLT, WSDL, SSL, and SOAP. Databases Oracle 10g

Supporting Tools sqldeveloper, SOAP UI, GEMS, Eagle, WinSCP3, Putty Tibco Developer

Ladbrokes, UK - London, UK - 2010-05 - 2012-06

Project Name: Ladbrokes

Work location: India, London.

• Ladbrokes is the largest betting company in the UK and largest retail bookmaker in the world, Ladbrokes operates several online gambling websites offering sportsbook, poker, casino, games, bingo and backgammon. Ladbrokes uses the OpenBet system to manage the betting information and Hybris as in interface to the Customer along with some more third parties like Quova and Givex.

• The main aim of this project is to develop a service based applications to integrate the data flow among different third parties linked with Ladbrokes. We have used TIBCO ActiveMatrix platform to achieve the Ladbrokes requirements and functionality.

Responsibilities:

• Worked as onsite coordinator in understand existing business model and customer business requirements.

• Understand High level design document & API's.

• Preparing Service design documents & Technical design documents.

• Installed and configured ActiveMatrix Service Grid 3.0, TRA, EMS, and Business Works & AMX Administrator.

• Created SOA applications using composites, mediation & existing java application

• Debugging the developed composites using Business Studio.

• Created daa's & deployed the applications using ActiveMatrix administrator

• Developed various processes in TIBCO Business Works for various interfaces to integrate OpenBet and Hybris systems.

• Prepared test cases & tested the deployed SOA applications using soapUI.

• Provided training to fresher's on TIBCO BW & EMS. Technical Environment:

Middleware Technologies TIBCO ActiveMatrix Service Grid, AMX Administrator, TIBCO BW, BW Administrator, EMS, Web Services, & Java

Web Services Technologies XML, XSD, WSDL, SOAP.

Databases SQL Server..

Supporting Tools TOAD, XMLSpy, Clear Case, soapUI, Notepad++ Operating Systems Windows XP, AIX environment.

Tibco Developer

Vodafone - 2009-06 - 2010-04

Project Name: SOLAS

The main objective SOLAS program is to replace the existing ICCS billing system with a Kenan FX Core Billing system in order to support future products and services such as Total Telecoms. All non Core Billing functions such as Customer Management and Network Provisioning, currently residing in ICCS must be supported in the interim architecture. Within the target architecture all channel communication with Kenan FX will be through Tibco business and data services, with Kenan exposing a SOAP Web Service layer. Responsibilities:

• Involved in the development of Kenan adapter to communicate with Kenan FX Billing System

• Involved in impact analysis of retired services.

• Developed various processes in TIBCO Business Works for various interfaces to integrate Channels, Offerings Engine, VF1, etc.,

• Used X-path extensively to do map the fields as per the mapping document.

• Involved in different types of testing like, Unit testing, Regression testing and Sanity testing. Technical Environment:

Middleware Technologies TIBCO Business works 5.6, TIBCO EMS, Mediation Adapter, Kenan FX, Java. Web Services Technologies XML, XSD, WSDL, SOAP.

Databases Oracle 9i.

Supporting Tools TOAD, XMLSpy, Clear Case, soapUI, Junit. Operating Systems Windows XP, Linux environment.

Tibco Developer

Cisco - IN - 2006-09 - 2009-05

Project Name: SFDC- Opportunity, Account and Lead Integration.

• Salesforce.com is a web-based Customer Relationship Management (CRM) application which has been selected by Cisco as the CRM platform for all sales teams globally.

• The main objective of this project is to integrate the data between SFDC (Salesforce.com) and OMF (a Siebel based tool for Opportunity Management and Forecasting) and provide the synchronization between these two applications. Whenever an Account or Opportunity created or updated in SFDC should flow to OMF and vice versa. TIBCO is used as a middleware tool to achieve this functionality. Responsibilities:

• Used XML messages to parse through the TIBCO XML parser and subsequently mapped them to data format required by TSA.

• Developed various processes in TIBCO Business Works for various interfaces.

• Used X-path extensively to do map the fields as per the mapping document.

• Involved in Deployment of bw components in DEV, Stage and Production environments.

• Involved in different types of testing like, Smoke testing, Sanity testing and load testing. TECHNICAL ENVIRONMENT

TIBCO Business works 5.4, TIBCO EMS, TIBCO ADB Adapter, TSA (Tibco Siebel Adapter), Windows XP. Tibco Developer

Souli Medical Centre - 2005-11 - 2006-08

Project Name: Souli Medical Centre

• This is a web-based application where a user can get necessary and speedy information about different drugs. The application presents the user with a catalogue of Drugs. This project fetches all the necessary queries from the patient and gives necessary response/solutions.

• Customer perception module contains new registration, view profile, view health tips, information about new updated medicines, post queries to get information about disease. The customers can select the desired drugs and buy them. The customer can revise or cancel the order. When the customer is ready to accept the order, the customer provides a credit card number to cover the costs and supplies a shipping address.

• Pharmacy module contains regular duties of pharmacist like maintaining the product details. Administrator can control over all application. His responsibilities are View the patient list, view the profile of any individual patient, and administrate all the users.

Responsibilities:

• Involved in the development of Customer Perception module.

• Involved in coding servlets and Jsp's.

• Done client side validations using JavaScript.

• Done Unit Testing.

TECHNICAL ENVIRONMENT

JSP, Servlets, Oracle and Tomcat5.0.

SKILLS

TIBCO, XML, WINDOWS XP, SOAP, ORACLE

ADDITIONAL INFORMATION

TECHNICAL SKILLS

EAI Technologies TIBCO Business Works 5.x/6.x, Business Studio/ Eclipse, TIBCO Designer, TIBCO EMS, TIBCO Active Database Adapter, TIBCO MQ Plug-in, Big data Plugin, Salesforce Plugin, Salesforce Bulk API, TIBCO BW Administrator, Enterprise Administrator, TIBCO SPOTFIRE. Programming Languages Java, J2EE (JDBC, Servlets, JSP,JMS), SQL, PL/SQL XML Technologies XML, XSD, XSLT, WSDL

Database SQL, PL/SQL, Oracle 10g

Design Tools Microsoft Visio

Versioning Tools Rational Clear Case, TortoiseSVN

Unit Testing Tools JUnit, JMeter, SOAP UI

Build Tools Apache Ant

Operating Systems Windows XP, Unix, Linux

Other Jvisualvm, Putty, SSH, sqldeveloper, Eagle, JEMS, WMQ Explorer, XML Spy, HP QC, Service Now, BMC Remedy.

Contact this candidate