SUMMARY:

• Having over 9+ years of working experience in IT and experience BI using Tibco Spotfire Professional, and Tibco Spotfire Webplayer.
• Hands on experience in administering, deploying, and maintaining Models, Reports.
• Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Documenting Business Information
• Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process.
• Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Worked on designing dashboard / reports to give them consistent and professional looks using TIBCO Spotfire Professional.
• Extensively worked on Power Center Client Tools - Designer, Workflow Manager, Workflow Monitor
• Expertise in Data Warehouse and Database development skills using Oracle SQL.
• Extensive Working Experience in Testing for UAT testing and Production for Support through Tickets and Involved in Executing Scripts.
• Excellent analytical and problem solving skills to Resolves in-depth queries in a methodical manner independently to find appropriate resolutions.
• As a team player, enjoys sharing knowledge and encouraging development of others to achieve specific team goals.

TECHNICAL SKILLS:

BI Tools: TIBCO Spotfire Professional 4.5,4.0,3.X,6.0,6.5,7.0, TIBCO Spotfire Webplayer, TIBCO Spotfire enterprise player,

Operating systems: Windows 2008 server, Windows 2003 Enterprise Server, XP, 2000, UNIX

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: JAVA, VISUAL BASIC, COBOL, JCL

Database: SQL Server2005/2008, Oracle 9i/10g, Teradata

Legacy systems: IBM Mainframe S/390,AS400

ETL Tools: Informatica 8.6.1/8.1, Abinitio

WORK EXPERIENCE:

Confidential, Plano TX

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.

Confidential, Dallas, Tx

Spotfire Developer/Administrator

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
• Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Creating TERR script for predictive analysis using R statistical programming language.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
• Use In-memory capabilities of Tibco Spotfire, Spark as well as rich Machine Learning applications with easy to use Data visualization of Models using built inTERR (Tibco Runtime R engine) and Revolution R/R Studio.
• Customized Reports by writing complex custom SQL.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
• Provided high level, complex support services and delegate low level support to off-shore support staff
• 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 SQL data sources.
• Executed the queries in Teradata and verified the data. Also connected to spotfire using Teradata connector.
• Implemented system modifications as per established requirements.
• Prepared project estimates and analyzed reporting issues.
• Formulated dashboard specifications and generated status reports.
• Documented and maintained practices for system installations and configurations.
• Experienced with load balanced web architecture using Apache Tomcat.
• Experienced with continuously available Spotfire Server configuration
• Experienced with RDBS including SQL Server and Oracle, SQL skills

Environment: TIBCO ActiveMatrix Adapter for Databases 5.6.0, TIBCO Spotfire 7.x, 6.x, 5.x, Spotfire Automation Services 7.0, Spotfire Statistics Services 7.0, Spotfire Webplayer 7.0, Spotfire ADS 7.0.

Confidential, Atlanta, GA

Spotfire Developer

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

Environment: TIBCO Runtime Agent TRA 5.6.2 + Hotfix1, TIBCO ActiveMatrix Adapter for Databases 5.6.0, TIBCO ActiveMatrix Business Works 5.8.0, CFTC, SEC, FSA, JFSA TIBCO CIM 8.2, TIBCO Spotfire 7.x, 6.x, 5.x,TIBCO Business Events EE 3.0.1 + Hotfix 9 TIBCO ActiveMatrix Business Works BPEL 5.8.0 TIBCO Administrator EE 5.6.1, TIB/Hawk 4.7, Clear Case, clear quest, BMC Remedy, XMLCanonand Solaris Sun One5.1, LINUX.

Confidential, Conway AR 

Spotfire Developer/Administrator

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Use TIBCO Spotfire to analyze and obtain insights into large data sets.
• Create visually compelling interactive reports and dashboards.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Find the right balance between manipulating data using Spotfire versus using a programming language.
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.
• Created dozens of Data Connections, published on TIBCO Spotfire Server for usage with Operational/Monitoring Dashboards
• Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community
• Building, publishing interactive reports and dashboards using TIBCO Spotfire server.
• Collected data on various process measurements and formatted into graphs using TIBCO Spotfire software.
• Building, publishing interactive reports and dashboards, report scheduling using TIBCO Spotfire server.
• Involved in migrating the dashboards from Development to Production environments.
• Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
• 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.
• Responsible in peer reviewing the study specific and standard reports of Data Management and Programming Department.
• Involved in analyzing the source data coming from different sources such as SQL Server, Oracle.
• Created the Materialized views on the aggregate functions and used that in the reports.
• Responsible for scheduling and report bursting of the reports.

Environment: TIBCO Business Works Components 5.4, CIM 8.2, SOAP, Service, EMS, JDBC and adapters (ADB, File, SAP R/3 & MQ), Administrator 5.4, Java, GEMS (Graphical Administration Tool for EMS),TIBCO Spotfire 4.x, 5.x,6.x, 7.x, TIBCO Business Events EE 3.0.1 EMS 4.4.1, TIB/Hawk 4.7, Clear Case, clear quest, BMC Remedy, XMLCanon and Solaris Sun One5.1

Confidential, Seattle, WA 

ETL/Data warehousing Developer

Responsibilities:

• Involved in data modeling and database design of the new P&C Legal management database by applying Ralph Kimball methodology of dimensional modeling and using Erwin.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server and flat file sources targeting the views (views on the target tables) in the target database.
• Created Sessions and Workflows to load data from the SQL server and flat file sources that exist on servers located at various locations all over the country.
• Used pre-session shell scripts to generate User IDs that are loaded into a flat file and then into the target tables.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for P&C Legal management reporting.
• Involved in unit testing, integration testing and user acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Designed and developed reports using Microsoft Reporting Services tool.

Environment: Informatica 7.1, Microsoft Reporting Services, Oracle 9i/8i, SQL Server 2000, Erwin 4.1, VSS. Flat files

Confidential, Chicago IL 

Responsibilities:

• Understand Business Requirements.
• Provide production support to Development and QA environment.
• Design architecture options for future enhancements and suggest improvements in current architecture.
• Generate (if needed) throwaway prototypes to understand complex business requirements.
• Involved in configuration of different environments like development. Testing and production for the TIBCO Responsible for debugging and fixing the bugs reported by LIC.
• Developed business work flows using Business Works.
• Involved in configuration mode for deploying TIBCO Hawk rule bases and issues involved with creating or editing rule base.
• Migration of all the TIBCO components to the current versions from 2.x versions.
• Responsible for introducing the Administrator concept using TIBCO Administrator and deployed the Business process - Implement and Administer TIBCO Business Works.
• Responsible for installation and deployment of Business process in Solaris environment.
• Help the team in meeting their deadlines, solve technical problems and provide technical design suggestions, guide them in designing Schemas for their interfaces, validate and suggest how to design BW process flows, do the code review of their interfaces and help them fixing the bugs.
• Complex integration of all the applications has been done with real-time data transfer using TIBCO Rendezvous.

Environment: TIBCO Designer 5.3, TIBCO Business Works 5.3, MQ Adapters, TIBCO Administrator 5.3, TIBCO adapter for database (ADB) 5.3.0, TIB/Rendezvous 7.5,TIB/Hawk 4.x, Java and Oracle 9i.