Service Data

RANJANA SINGH

479-***-**** adjsbl@r.postjobfree.com

Charlotte,North Carolina

Objective

To obtain a position that will enable me to utilize my technical and communication skills for ample development of an organization that offers an environment to implement them in the best possible way.

Summary

About 7 plus Years of diversified experience in Development, Administration, Testing and Implementation on Ent erprise

Application Integration (EAI) systems.

Experience in TIBCO Business Works, TIBCO administrator, TIBCO EMS, and TIBCO ADB Adapter, TIBCO Web Services

Good experience in using Mercury Tools like Quality Center to log, track and fix defects.

Extensive use of Service Now ticketing tool in production support and development.

Used SVN and TFS to load the codes and share with team members.

Good knowledge of XML, XPATH, and building Web Services.

Very good knowledge in integrating various modules of SAP, Siebel and MQ Series with TIBCO Active Enterprise using XSDs and Common Data Model.

Well-versed in Object Oriented Programming (OOP).

Good experience in SQL, PL/SQL Programming.

Good Knowledge of developing Java and SQL Applications.

Good Knowledge of developing Html websites.

Technical skills

Operating System

Windows 98/2000/XP, Unix

Programming Languages

Java, PL/SQL

Web Technologies

XML, XSLT, SOAP, WSDL

EAI Tools

TIBCO Business Works 5.x, TIBCO EMS, TIBCO Administrator, TIBCO ADB

Application/Web Servers

Tomcat

Databases

Oracle 8i

Tools & Others

UML, Visio, Beyond Compare, HP Quality Center, Soap UI, Eclipse, SVN,TFS,

MySQL

Education Summary

Masters in Computer Science, University of Central Missouri,

May 2016 GPA 4.0/4.0

Coursework: Object Oriented Software Development and Engineering, Database Management Systems, Analysis of

Algorithms, Computer Networks, User Interface

Bachelors in Electronics & Instrumentation, West Bengal, India

August 2008 GPA 3.54/4.0

Coursework: C, Data Structures, Digital & Analog Communication, Computer Networks.

Professional Experience

Infosys Limited

Technology Analyst

Project Handled:

Enterprise Feb’ 2016-till date

Client: Allstate

Project involves handling all kind of data transfer from SAP system of Allstate to various Allstate vendors.

Working as a Team Lead for a team of four people.

Responsibilities:

Gather requirements from Business analyst and System Analyst

Estimation and analysis

Create functional and technical design

Building the service in BW designer

Unit test case plan and results

Projects developed:

Vertafore: Hosted a new Web service that acts as a middle layer between SAP and Third party vendor –Security Policy and

Association combination was used as means for web service authorization

Created a BW process that invokes third party service at regular intervals and provide the response to SAP system via SOAP ov er

HTTPS service call

FM: Built a BW process that consumes two large xmls and do data look up across the xmls to create an output that can be consumed by Third party vendor. Used Data Caching and Large XML file pallet in this project

POD: Built a process that does the Allstate data transformation to the format that can be consumed by Vendor system

Salesforce: Integration project with Salesforce soap API.

Built various TIBCO BW web service subscribers to either Update or Insert MDM records into Salesforce database.

The code reads each record from a large xml and upserts the salesforce SObject with various transformation rules.

The publisher code was developed for salesforce to call whenever needed and the code internally creates xml file to be sent to a third party vendor.

Ariba: Integration project with Ariba vendor.

Built a HTTP post based business process:

The process lists’s all the SAP files based on departments and creates it into a zip file.

The zip file is transferred to vendor via a MIME http post mechanism.

Responsibilities:

Deploy the TIBCO executable in various environments on TIBCO admin

Set up file transfers to pull/push data files from Allstate which involved setting up of Firewalls, addition of entries into Known host file and creating the XMLs that will be used by FTS Framework service to trigger the file transfers via FTP/SFTP

Production support activities that involves resolving the issue related to BW process that are live in production and file transfer

Created multiple Job aids which come handy for production support activities

Service now is used as ticketing tool for production support activities

Cognizant, BANGALORE Associate Projects

Projects Handled:

1. COMET-Collaborating as one Merck to Enable Transformation. Jan’ 2012-July’ 2014

Client: Merck (Pharmaceutical Company)

Developed various interfaces in OTC, FBM and SCM work streams using TIBCO BW designer

o Receive the invoices from SAP XI via EMS messaging

o Perform data validation and transformations based on the consumer application requirement

o Created XSLT to transform data from IDOC to other formats

o Extensively worked on JDBC to integrate SAP applications with various databases in the OTC stream

Creation of technical specification document

Utilized all sort of TIBO palettes available in developing interfaces.(JMS,JDBC,Adapter,Java

Code,Parser,Render,Mapper,Schema,Parse Data,Generate Error,Catch,etc)

Deployed the codes using shell scripting

Created gating documents for various environments. SVN is used as version control tool

Unit testing in development and service setup in all other environments

Used HP Quality center as part of QC testing

Production support handover to the L2 team

Worked on an enhancement project involving ADB adapter

EMS admin commands knowledge transfer sessions were conducted to team members

Also trained on Active Matrix SOA while working on this project

2. Broadspire

Client: Broadspire Sep’ 2010-Dec’ 2011

Broadspire is an employee insurance vendor who accepts medical claims from employees.

Tools & Technology: TIBCO Business works, JMS, Web services, XML, XSLT, SVN Tortoise, Tibco Business Studio, Tibco EMS, Tibco

Admin, Eclipse

Responsibilities:

Involved in designing and developing an integration framework which can be re-used in the project

Created a migration service which is used for one time document loading to enterprise electronic storage repository. This project involved reading the metadata file and pdf to be stored and invoking document storage service by passing the metadata and pdf document (binary format), receive the response and invoke third party service to store the unique document identification number

Attended meetings to gather requirements to develop new interfaces

Developed interfaces which uses EMS as messaging between SAP applications

Created global publisher interface, used bridging and routing on TIBCO EMS admin

Created interface requirement document, interface design documents to understand complete functionality of the project

Logging and Error Handling was implemented for the project and checked smooth flow of data from source to target

3. Project: PepsiCo

Client: PepsiCo

PepsiCo is a global fluid and drinks company May’ 2009-Aug’ 2010

Tools & Technology: TIBCO Business works, JMS, DB and File Adapters, XML, XSD, SVN Tortoise, Putty, WinScp, Notepad++, Beyond

Compare, JDBC, Dashboard

Responsibilities:

Involved in Migration of interfaces from Classic to AMX

Created the knowledge artefact that provides the end to end migration process starting from editing the config files to deployment

Developed interfaces on Tibco designer using XPATH rules for extensive transformation of data from one format to other

Involved in creating custom schema for mapper activities

Participated in detailed data mapping exercise

Involved in enhancement of legacy systems

Worked on Production support. Monitored the alerts and pro-actively resolved issues in stringent deadlines

Company: IMS Learning Institute Aug’2008-Apr’2009

Online Application System

The system allows the users to sign up and be the member of IMS.

The IMS member can access the list of courses with their availability status and register to any of the courses.

Created use case analysis and proposal and design document following iteration model.

Implemented the web based application on jsp using sql database.

Technologies/Tools Used: Eclipse, Tomcat, HTML, JSP, Servlet, My SQL.

Contact this candidate