SUMMARY:

• Over 8 years of related experience in Information Technology with 5 years of experience as TIBCO Spotfire Developer/Consultant in various industries.
• Experience in creating complex Spotfire dashboards or reports using TIBCO Spotfire Professional 7.5.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Created Complex Information Links to pull the data from Oracle 10g/11g.
• Expert in Writing SQL Queries, complex Stored Procedures on Oracle and DB2 to pull the data into Spotfire.
• Data Modeling using ADS to build the commonly used views to pull into Spotfire.
• Create DXP file using spotfire.
• Implement Caching mechanism in spotfire to reduce the load and interactions with Database.
• Experience with extracting and combining different data sources, different databases and data warehouses.
• Business Analyst experience across multiple functional business areas.
• Thorough understanding of the Software Development Life Cycle.
• Proficient in developing and managing project requirements, budgets, timelines and deliverables.
• Aptitude for working with business experts and end users to understand needs and provide solutions.
• Experience in TIBCO Business Works, TIBCO Administrator, TIBCO AMX BW, TIBCO EMS, TIBCO ADB Adapter, TIBCO File Adapter, SAP Adapter, TIBCO Spotfire, TIBCO Hawk, TIBCO Rendezvous, TIBCO Common LE.
• Ability to analyze and evaluate technical problems and design effective solutions.
• Expert in preparing and converting system specification in to design using SDLC, including design, development, implementation, integration and maintenance.
• Extensive exposure with Windows and UNIX flavors.
• Involved in daily meetings with Business Analysts and Developers and other project stake holders.
• Strong Analytical and Logical skills with ability to follow project standards and procedures as per client specifications.
• Well experienced in version control integration, XML,XSD, XSLT, XPATH, JMS Messaging.
• Excellent Communication and Documentation skills.

TECHNICAL SKILLS:

EAI Tools: TIBCO Business Works, TIBCO Business Events, TIBCO EMS, TIB Administrator, TIBCOADB Adapter,TIBCO SAP R3 Adapter, TIBCO Spotfire, TIBCO File Adapter, TIBCO Hawk, Business Connect, Smart Mapper, TIBCO Rendezvous, TIBCO AMX BW, TIBCO Active Spaces

Databases: Oracle 7.3/9i/10G, 11i,MS SQL Server, IBM DB2, MySQL, Siebel 7.7.

Monitoring: TIBCO Hawk, Tivoli, RTView, HP Openview, Hawk Accelerator, Hawk SNMP

Tools: Iron Python,XMLSpy, TOAD, Microsoft VISIO, Smart Draw UML

Operating Systems: Windows 98/NT/2000/XP, NT/2000/2003 Servers, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Spotfire Developer/Administrator

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Created dashboards and applications and Spotfire workbooks(DXP) from scratch based on clients needs
• Worked with end users to explain TIBCO Spotfire workbooks, creating ad - hoc reports
• Installed & configured the TIBCO Spotfire on Single Server Environment, Administering the Servers, Troubleshooting, Performance Tuning and implementing security
• Coordinated an employee training program for various Spotfire applications and basic troubleshooting principles
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts/Filters.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting With Spotfire
• Customized Reports using HTML and JAVA SCRIPTS.
• Created Materialized views for improve the performance of the reports.
• Assigning work to the offshore team on daily basis.
• Setup Weekly Status Calls with offshore team.
• Coordinated training sessions and demonstration of Spotfire tools to End-users.
• Developed technical specification document for the offshore team.
• Extracted data from multiple complex hierarchies from cross table flat files and websites
• Extracted data from SQL, implemented Custom Queries in Spotfire and also pulled the data Using
• Information Links
• Used Iron Python to create power actions in test areas.
• Good knowledge in developing and designing reports through SSRS and Excel
• Involved in migrating the dashboards from Development to Production environments.
• Documented the entire effort. The documents generated during the process were User Requirements Specifications, Peer Review Log, Design Specifications, Validation Plan, Validation Summary Reports, Release statement, Production Approval Form and Project planning documents.
• Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Used SQL to join the data in the database.
• Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.
• Developed various operational Drill-through and Drill-down reports using SSRS

Spotfire Consultant

Responsibilities:

• Used TIBCO Spotfire to analyze and obtain insights into large data sets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Created visually compelling interactive reports and dashboards.
• Found the right balance between manipulating data using Spotfire versus using a programming language.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
• Used ADS in connecting to CRM sourceto build a data model so information designer can consume the data from ADS for data analysis.
• Used ADS in streaming ODATA from 3rd party web services.
• Created dozens of Data Connections, published on TIBCO Spotfire Server for usage with Operational/Monitoring Dashboards.
• Creating data sources, parameter information links, joins, filters in information designer for fetching data in to Spotfire as per the business needs.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.
• Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Created Tags, Bookmarks and transformations for data tables.
• Performed daily admin tasks of user registration, security configuration and usage monitoring.
• Unit testing and participation in UAT and production cut over plans.

TIBCO BW Developer

Responsibilities:

• Worked with Business Analysts, end users and third party vendors to finalize interface agreement documents that captured data mapping between various enterprise applications.
• Used various TIBCO Active Enterprise products to facilitate the integration of several enterprise applications
• Configured TIBCO Business Works processes to receive XML files from trading partners and generate messages to update the billing system.
• Developed XSDs, XPATH transformations and XSLT mapping using TIBCO Designer.
• Created BW SOAP Server processes to handle incoming requests for collections.
• Configured the publication and subscription services of the ADB (Active Database) adapter to integrate with backend Oracle 9i database.
• Installed and configured TIBCO EMS Server on a UNIX/Solaris platform.
• Configured several EMS client applications for durable subscriptions to ensure guaranteed delivery of messages.
• Modified various destination properties using queue and topic configuration files.
• Analtics and Visualization using Tibco Spotfire
• Setup bridges for several destinations to facilitate logging of mission critical messages into a database for archival purposes.
• Configured TIBCO Business Works billing system query and update processes to provide customer care system with real-time billing system data.
• Generated Unit test scripts, performed integration testing for the project and created the Unit and Integration test result Documents.
• Set the Load balancing and Fault tolerance properties for TIBCO BusinessWorks Engine.
• Developed and implemented the Audit and Error handling standards for all interfaces.
• Performed Development, Testing and Deployment of the application in different (development, testing and Production) environments
• TDD environment.

Environment: TIBCO Business Works, TIBCO Designer, TIBCO EMS, TIBCO AMX BW, TIBCO ADB Adapter, SAP Adapter, TIBCO Hawk, TIBCO Administrator, Oracle 9.i, SQL Plus, REST web services and JSON

Sr. TIBCO Business Works Developer

Responsibilities:

• Involved in complete SDLC for the project collecting Requirements, Design, Development, Deployment and Production.
• Developed SOA based Architecture that provide a suite of services that can be used in the products like EMS, Business Works, Business Events, Rendezvous.
• Involved in the performance of Business Works Administration, and Enterprise Messaging Service, Enterprise Management Advisor,TIBCO AMX BW,CLE, Hawk, XML Canon, Solaris and Oracle Database.
• Worked with Service Managers/Technical Leads, Database Administrators and Unix Administrators in the execution and deployment of code.
• Experience in Technical design reviews and CUT activities.
• Worked in Manual, Automation testing with extensive client management skills.
• Performed Unit Testing, Integration Testing, Load Testing & Performance Testing
• Involved in the Installation and Upgrading the TIBCO application.
• Participated in application performance tuning inSAP adapter.
• Used TIBCOAdministrator to manage TIBCO Components to monitor andmanage the deployments.
• Developed heavy Business Worksprocesses in TIBCO Designer involving complex business rules/logic and XPATH.
• Involved in Code reviews to ensure code quality standards as well as mentor Java/J2EEdevelopers.
• Working knowledge in Java, J2EE (Servlets, JSP, JDBC, EJB) as well as web services.
• Configured the MFT file transfer using the TIBCO toolset.
• Configured the Common Services in the TIBCO projects.
• Involved in script development and modified them to run on different browsers.
• Configured the TIBCO SAP Adapter, File Adapter, Database Adapter and set up the environment for TIBCO.
• Working experience with HP Quality Center: Able to define tests, test sets.
• Designed and developed various BW processes to complete the integration path.
• Configured SOAP/HTTP and SOAP/JMS Web Services using TIBCO BW.
• Created and configured queues, topics and users in TIB EMS/JMS.
• Involved in Creating Hawk rule bases to monitor and manage the processes.

Environment: TIBCO Business Works, TIBCO Designer, TIBCO Hawk, TIBCO Administrator,TIBCO EMS, Business Connect, TIBCO AMX BW, SAP Adapter, Oracle, Java/J2EE, UNIX, XML, JMS, SOAP, SQL Plus, REST web services and JSON, Visio, Clear Case, SVN, CVS QTP, File Zilla, Mercury Quality Center, HP-UNIX, NAS, Windows Server, HP-Open view.

TIBCO Business Works/EMS/ Developer

Responsibilities:

• Involved in complete SDLC for the project collecting requirements, design, development, deployment and Production.
• Worked as Development and Production support personnel actively involving with the Business, Development, Testing and Deployment teams.
• Involved in developing Business Agreements with different partners of the down stream applications.
• Deployed the projects on different environments using TIBCO BW Administrator and AppManage utility.
• Strong experience is using TIBCO Administrator and HAWK management techniques.
• Solid understanding of software migration and deployment best practices and principles.
• Experienced in working with TIBCO distributed architectures using application servers, DB's and messaging software.
• Used ADB adapter to configure the Oracle DB Connections and publish and subscribe interfaces from Database.
• Used TIBCOAdministrator to manage TIBCO Components, to monitor and manage the deployments.
• Involved in the integration of various interfaces such as Point to Point Interface from SAP to Oracle database, publish-subscribe interface from SAP to the oracle database. In these interfaces the data is polled from the source, business logic is implemented in TIBCO Process and the XML message is sent to JMS Queue which is then handed over to SAP XI.
• Troubleshoot and resolve incidents relating to interfaces implemented.
• Ensure adherence to client's processes and regulatory compliance needs.
• Transition knowledge to off-shore resources.

Environment: TIBCO Business Works, TIBCO EMS, TIBCO Administrator, TIBCO Designer, File Adapter, ADB Adapter, Oracle 9i, Altova XML spy, Mercury Quality Center, Mindterm, SubVersion.