Data Integration Analyst Resume
Plano, TX
Summary
- Over 14 years of professional experience in Design and Development of software solutions by using SOA, EAI, J2EE and Web services technologies with expertise in Retail, Travel, Hospitality and Mortgage domains
- Over 11 years of experience in analysis, design, development, architecting and implementation of Enterprise Application Integration solutions using TIBCO suite of products
- Expertise in architecting, designing, development, testing, deployment and maintenance of Integration applications by using TIBCO Rendezvous, TIBCO Business Works, TIBCO Business Events, TIBCO EMS, TIBCO Hawk, TIBCO Adapter for Active Database, TIBCO Adapter for Files, TIBCO Adapter for SAP , TIBCO Adapter for OS/390 and TIBCO Administrator
- Extensive experience in installation, configuration and troubleshooting of TIBCO Rendezvous, TIBCO Business Works, TIBCO Business Events ,TIBCO EMS, TIBCO Hawk, TIBCO Adapter for Active Database, TIBCO Adapter for Files, TIBCO Adapter for SAP , TIBCO Adapter for OS/390 and TIBCO Administrator
- Expertise in using TIBCO Hawk tool for monitoring and managing distributed applications and operating systems
- Strong knowledge in XML, XSD and XPATH
- Extensive experience in SQL and PL/SQL, application integration experience with backend database systems that include Oracle, SQL, Informix and DB2
- Strong experience in application modeling and design using Unified Modeling Language (UML). Translating Business Requirements to system requirements using Use cases, Story Boards, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams etc
- Experience in handling all aspects of projects, meeting deadlines, distributing responsibilities, monitoring and performance reporting of the projects.
- Good understanding of Object Oriented Design and Analysis (OOAD) concepts and project documentation
- Highly motivated and adaptive with the ability to grasp things quickly and posses excellent interpersonal technical and communicational skills with ability to meet critical time schedules
Education: Bachelor of Science in Computer Science
Technical Skills :
TIBCO Skills: BusinessWorks, TIBCO Business Events ,IntegrationManager, MessageBroker ,
Rendezvous, EMS
TIBCO Adapter SDK, ADB Adapter, File Adapter, OS 390 Adapter, Siebel Adapter, SAP R/3 Adapter, AS 400 File Adapter
TIBCO Admin, TIBCO Hawk
TIBCO Inconcert
TIBCO Business Connect, EDI-X12, EbXML
TIBCO General Interface
Enterprise Application Suite: Weblogic 6.0, WebSphere, JBoss, JRun , Apache Tomcat, Silverstream, IPlanet Directory Server, Iplanet Web Server
Light Web Technologies: Java scripting (writing procedures, event handling etc.,), HTML (Forms, creating actions with servlets, etc.,) , Flash
RDBMS: Oracle, PL/SQL (forming queries, writing stored procedures, functions etc.,), Sybase , MySql, MS-Access , DB2 , MS SQL Server,Informix.
Other Languages: C, PRO*C, Perl scripting
Operating Environments: Windows, RedHat Linux, Solaris, HP-UNIX , and SCO UNIX. , OS/390,MVS,LAN/WAN.
PROJECT DETAILS :
Confidential,August 2012 to till date
SIMS Data Integration.
Location : Plano, TX
Rent-A-Center, Inc. is a rent-to-own operator in the United States. The Company operated 4,000 Company-owned stores nationwide and in Canada, Puerto Rico and Mexico, including 42 retail installment sales stores under the names Get It Now and Home Choice, and 18 rent-to-own stores located in Canada under the name Rent-A-Centre. Its subsidiary, ColorTyme, Inc. (ColorTyme), is a national franchisor of rent-to-own stores. As of December 31, 2010, ColorTyme had 209 franchised rent-to-own stores in 32 states.
- Working as a liaison between technical team and business team.
- Strong working knowledge using relational databases including Oracle and SQL Server.
- Coordinating with architect and development team during the design phase of the project also responsible for code reviewing of the product developed to ensure that it meets the business requirements.
- Self-motivated and highly committed to responsibilities. Excellent communication skills and ability to work independently and perform well within cross-functional teams
Confidential, April 2012 to July 2012
Deployment Automation Framework
Location : Plano, TX
Rent-A-Center, Inc. is a rent-to-own operator in the United States. The Company operated 4,000 Company-owned stores nationwide and in Canada, Puerto Rico and Mexico, including 42 retail installment sales stores under the names Get It Now and Home Choice, and 18 rent-to-own stores located in Canada under the name Rent-A-Centre. Its subsidiary, ColorTyme, Inc. (ColorTyme), is a national franchisor of rent-to-own stores. As of December 31, 2010, ColorTyme had 209 franchised rent-to-own stores in 32 states.
Deployment Automator is tool used to build the artifacts and deploy the Tibco BW applications automatically across all environments. This framework used to generate the artifacts(ear files, properties files for each environment like Dev, QA, Production environments) and deploy the Ears using the
AppMange utility automatically.
- Self-motivated and highly committed to responsibilities. Excellent communication skills and ability to work independently and perform well within cross-functional teams
Confidential, July 2011 to Mar 2012
Modernization of Applications, Processes, and Systems Program (SIMS Integration)
Location : Plano, TX
Rent-A-Center, Inc. is a rent-to-own operator in the United States. The Company operated 4000 Company-owned stores nationwide and in Canada, Puerto Rico and Mexico, including 42 retail installment sales stores under the names Get It Now and Home Choice, and 18 rent-to-own stores located in Canada under the name Rent-A-Centre. Its subsidiary, ColorTyme, Inc. (ColorTyme), is a national franchisor of rent-to-own stores. As of December 31, 2010, ColorTyme had 209 franchised rent-to-own stores in 32 states.
MAPS Release 5.0 is the rollout of the SIMS Point-of-Sale application to all domestic RTO Rent-A-Center locations. The SIMS POS solution will incorporate reengineered business processes and operations at the store to improve revenues, efficiencies and relationships with both customers and stores.
- Working as a liaison between technical team and business team.
- Strong working knowledge using relational databases including Oracle and SQL Server.
- Coordinating with architect and development team during the design phase of the project also responsible for code reviewing of the product developed to ensure that it meets the business requirements.
- Self-motivated and highly committed to responsibilities. Excellent communication skills and ability to work independently and perform well within cross-functional teams.
Confidential, March 2005 to June 2011
Soft Hotel and Opera Two Way Interfaces, TRIPS eDesk Integration
Location: Parsippany, NJ
Wyndham Hotel Group provides travel and real estate services primarily in the United States and the United Kingdom. It operates in six segments: Real Estate Franchise and Operations, Hospitality Services, Travel Distribution Services, Vehicle Services, Mortgage Services, and Marketing Services.
The SoftHotel and Micros Opera and Brilliant applications are host based Property Management Systems which communicates to systems located at the property for information related to Reservation, Inventory and Rates. The Two Way Interface Middleware project will integrate these PMSs with Wyndham Central Reservation System using Web Services and TIBCO EMS.
- Providing second level support, root cause Analysis for multiple applications in various technologies.
- Providing customer support to resolve the production issues.
- Working as a liaison between technical team and business team.
- Coordinating with architect and development team during the design phase of the project also responsible for code reviewing of the product developed to ensure that it meets the business requirements.
- Point of contact between the offshore team and Client.
- Responsible for Tibco technical expertise and guidance to the team members
- Responsible for configuration of the TIBCO Business Works Processes, TIBCO BusinessConnect, Integration Manager and Adapters
- Worked on creating XSD’s, AESchema’s and XPATH transformations and XSLT mapping
- Responsible for modeling the work flow for exception handling
- Responsible for administration and monitoring of the Soft Hotel and Opera TWI and TRIPS eDesk applications by using TIBCO Administrator.
Confidential, Nov 2004 – Feb 2005
B2B Integration
Location: Woodcliff Lake, NJ
- Wallenius Wilhelmsen Logistics (WWL) is a leading independent provider of global factory-to-dealer transport solutions for the automotive, agricultural and construction equipment industries. The company also specializes in handling complex project cargoes such as rail cars, power generators, mining equipment and yachts. WWL\'s sophisticated supply chain management services ensure an efficient integration of ocean transportation, inland distribution, terminal handling and a large comprehensive range of specialized technical services. The project at WWL involved building IT infrastructure for automation of B2B transactions between WWL and its trading partners.
- The following are the types of documents exchanged with the trading partners:
- 996 File Transfer(Yearly Sales Report)
- 867 Product Transfer and Resale Report
- 940 Warehouse Shipping Order
- 944 Warehouse Stock Transfer Receipt Advice
- 945 Warehouse Shipping Advice
- 947 Warehouse Inventory Adjustment Advice
- 852 Product Activity Data
- 856 Ship Notice/Outbound
Responsibilities:
Installation and Administration:
- Installed the following TIBCO products: Business Connect, EDI Plug-in, Business Works, TIBCO Adapters, TIBCO Administrator in development, testing UNIX systems
- Configured Business Connect DMZ and configured the RVRD for routing the messages across networks between Business connect Servers
- Execute code migrations using source code management tools across various environments
Business Requirements and Design
- Prepared technical design documents and mapping documents for 940,944,945,947,852,856,867,996 EDI documents exchange
- Created .ecs and .xsd files for 940,944,945,947,852,856,867,996,850 and 810 EDI documents using EDIFECS Spec Builder
- Configured Business Connect: set up trading host, trading partners, uploaded guideline files
- Configured secure FTP as the transport protocol for sending and receiving the documents in Business Connect
- Configured auditing and error handling tables on the database to capture Business Connect related information
- Created private processes using Business Works for receiving inbound documents and for preparing outbound documents and for performing various business validations
- Created error handler and auditing processes in Business Works
- Configured ADB Adapter for publishing the data to and subscribing the data from Business Works
- Configured File Adapter for subscription of data from Business Works
- Configured TIBCO adapters to publish data using R/3 Adapter
- Developed the criteria and implemented the rule bases in TIBCO Hawk
- Deployed the processes on Unix boxes
- Participated in user testing
- Production Support
- Environment: TIBCO Business Works, ADB Adapter, File Adapter, TIBCO Business Connect, EDI Protocol, Rendezvous, EMS
Confidential, Mar2004 to Nov 2004
CSSG Interfaces
Location: Moorestown, NJ
Cendant Mortgage focuses on providing real estate services. The Real Estate Services segment franchises the Company\'s real estate brokerage businesses. It also provides real estate brokerage services, mortgages and title insurance, appraisal review and closing services and employee relocation services. Cendant Mortgage is the 6th largest retail mortgage originator in the country.
Cendant Mortgage is using Tibco RV as their main bus for all the enterprise integration. It involves integrating various applications through different Tibco products. The challenges are to integrate these applications with complex data structure and do the data mapping between various applications still managing to make the interfaces generalize so as to have broad-cast model for publish-subscribe.
- Point of contact between the offshore team and Client.
Confidential, June03 to Feb04
Global Transformation Project(GTP)
Location : Columbus, OH
McGraw-Hill is leader in online learning and multimedia tools, students of all ages, teachers and professionals are engaged, stimulated and empowered to succeed by McGraw-Hill Education the world over
GTP is integrating Legacy application with Oracle Applications using Tibco Active Enterprise suite of products.
Confidential,, Jan03 to May03
CHIME (CRS Integration Project)
Location : Phoenix, AZ
Cendant is world’s largest hotel franchisor, the world’s largest vacation ownership organization, and one of the world’slargestcar rental operators, world’s largest hotel franchisor, the world’s largest vacation ownership organization, and one of the world’slargestcar rental operator
