SUMMARY:

• Seven years of experience in creating complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, data on demand, Property Controls, text areas in TIBCO Spotfirereports using TibcoSpotfire Professional, Installation of TibcoSpotfire server, Administrative tuning and monitoring the server.
• Proficient in all phases of SDLC (analysis, design, development, testing and deployment) and highly competent in gathering user requirements.
• Involved in Spotfire administration activities including Administration Manager, Library Administration and Administrator console.
• Knowledge and hands on experience on Visualizations, Details on Demand, Information Designer, Automation Job Builder, Property controls, Action controls and filters, Library Administrator, ADS, In - memory Architecture.
• Experience in Requirement gathering, Analysis, Design, Reviews, Coding and Code Reviews, Unit and Integration Testing.
• Root cause analysis and fixing the issues with the Spotfire environment.
• Created Action Controls using Iron Python Scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
• Installation, maintenance and monitoring of TIBCO Applications and EMS destinations.
• Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Iron Python scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
• Analyzed existing complex systems to understand and document data elements, relationships, data flows, dependencies and related interfaces.
• Extracted data from different sources like Excel files, flat files, MS Access, Oracle and another database.
• Developed the Stored Procedures for extensively reporting the system and used custom designed parameters for reports.
• Customizing Visualization using filters, markings, custom columns and custom expressions.
• Developed Test scripts and test cases for functional and regression testing.
• Installed and Configured Spotfire Server.
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.

TECHNICAL SKILLS:

BI Tools: Tibco Spotfire 7.0/6.x/5.x, Tibco Webplayer, Tibco Automation Services, Tibco Spotfire SDK, Excel, Tableau, Qlikview Excel, Tableau, Qlikview

Database: SQL Server Oracle 10g/11g, Teradata

ETL Tools: Informatica, SSIS

Languages: SQL, C, C++, HTML, .Net, Java

Methodology: Agile Scrum, JIRA and Version One

Versioning systems: SVN and GIT

Operating Systems: Microsoft Windows XP/NT/2007, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Senior Tibco spotfire Developer

Responsibilities:

• The project provides easy access to and analysis of historical stability data to allow reduction or elimination of new stability studies for new product initiatives. Accessing historical data is currently challenging, often resulting in the placement of new stability programs when a technical rationale recommending no or limited testing based on historical data would have been supportable.
• Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.
• Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.
• Installing Spotfire Server, Database drivers, and Hotfixes.
• Used Microsoft Sql server to hold Spotfire server database.
• Monitor Spotfire server to detect issues with server, LDAP servers, network problems, external database to reduce server downtime and eliminate performance bottlenecks.
• Configured Spotfire server set up single sign on.
• Worked on various Visualizations like Tree Map, Box Plot, Parallel Co-ordinate plots, Scatter Plot & Map Chart Etc.
• Deployed Tibco Spotfire DXP files to UAT/Production environments.
• Created Information links, Parameterization, defined join rules in information designer.
• Create Action Controls and wrote scripts using Iron Python Performed several customizations using the scripts
• Translate product requirements and business questions into report requirements and visualization dashboards.
• Administered users and Library Management, access levels, rights and folder structure.
• Followed Agile software development with Scrum methodology.
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.
• Developed Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance.
• Installation, maintenance and monitoring of TIBCO Applications and EMS destinations.
• Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Created the visualizations with complex calculations/functions.
• Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Root cause analysis and fixing the issues with the Spotfire environment.
• Analysis of the Server Issues, Library issues, etc.
• Iron Python scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.

Environment: TIBCO SPOTFIRE 7.8 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Microsoft SQL Server 2010/2012, PL/SQL, 5.x, Agile, ASP.NET 4.0, Windows Server 2008 R2.

Confidential, Dallas, TX

Tibco Spotfire Developer

Responsibilities:

• To lead all the functional requirement gathering and functional design process for new Spotfire reporting applications.
• Creating complex Information Links using multiple joins, prompts, parameters to load data from different data sources.
• Creating dynamic Spotfire dashboards with data on demand, property controls, different charts to analyze the KPI's on the tabs.
• Creating complex Tableau charts and dashboards using parameters, actions and filters.
• Installation & configuration of Spotfire servers, web player servers and professional clients on the windows server machines for development, test and production environment.
• Successfully upgraded Spotfire environment to higher end versions.
• Installation of required database drivers and data connectors for all three environments.
• Applying latest patches/hotfixes on Spotfire server, web player and professional client.
• Upgrading Spotfire servers with latest hotfixes, setting up users, groups, licenses and preferences.
• Testing the Spotfire setup and then creating installation and operational qualification documents.
• Managing Library administration, providing access to users and groups.
• Enabled user authentication using LDAP groups and synchronized them with Spotfire server.
• To support user and development activities of Spotfire by providing production and development support to troubleshoot and resolve issues.
• Exporting & Importing of Spotfire dashboards from one environment to another.
• Conducting performance tuning of anything connected to data systems and ensuring efficient operations and maximizing resources to provide the best results for end users.
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications.
• Developed reports using various Charts like Pivot Tables, Summary Tables, Cross-tables, Pie-Charts, Line-chart, Combinational-chart, Bar-chart, Scatter-plot, Heat-map, and Tree-map.
• Used HTML and CSS along with JavaScript features to design Text Areas.
• Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Provided 24X7 support for TIBCO Spotfire infrastructure and Visualizations support.
• Documented and maintained Best practices for system installations, configurations and migration from one environment to another.

Environment: TIBCO Spotfire 7.10/7.5/7.0, TIBCO Web Player, TIBCO Automation Services, Oracle 11g, SQL Server 2008/2012, GitHub.

Confidential

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Migrated data from SQL Server 2000 to SQL Server 2005.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Used complex expressions to calculate, group, filter, parameterize and format the contents of the report.
• Documented and prepared project status report updates and audit reports.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.