SUMMARY:

• 6+ Years of experience in Business intelligence application design, development and maintenance of with TIBCO Spotfire and Tableau primary skills
• Experience in a complete stack of TIBCO Spotfire like Spotfire Server, Web Player Server, Node Manager, Automation Services, upgrades, hotfix/patches
• Installed both Windows and Linux version of Spotfire and configured HTTPS
• The experience of migration of code from one environment to other, scheduling updates
• Experience working on TIBCO Spotfire 4.x/5.x/6.x/7.x
• Creating complex Information Links based on multiple tables joins to load the data into Spotfire Analyst.
• Experienced in developing dashboards using TIBCO Spotfire, Iron Python, Oracle DB, and SQL Expertise in debugging and optimizing Spotfire Dashboards / Reports and Designing and scheduling the jobs.
• Worked extensively on Information Designer, Scheduled updates, Custom HMTL templates and advanced concepts like database write back from Spotfire reports
• Good Knowledge on Iron Python and Spotfire APIs for customizations
• Strong knowledge on visualizations like Bar charts, Combination, Map, Tree Maps, CrossTable
• Worked with three different teams to guide them and support them how to build report dashboards.
• Created various complexes Crosstables, Bar Charts, Line Charts and Treemap.
• Strong knowledge on Property Controls, Script control and document properties for automation.
• Worked on Spotfire Automation Service Job builder for scheduling and delivering reports through the mail as per business needs.
• Excellent analytical and problem - solving skills to Resolves in-depth queries in a methodical manner independently to find appropriate resolutions.
• A good team player with excellent communication skills. Enjoy challenges and have the ability to adapt to any industry and learn quickly

TECHNICAL SKILLS:

BI Tools: Spotfire 7.x/6.x/5..x/4.x, Tableau 10/9.2/9.3, OBIEE, Qlik Sense, Power BI

Database: Oracle, SQL Server, Teradata

ETL Tools: Informatica, Alteryx

Operating Systems: Windows 2008 Server, Windows 2003 Enterprise Server, XP, 2000, LINUX 6.3, UNIX

Languages/Utilities: SQL, PL/SQL, Iron Python, JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, HOUSTON, TX

TIBCO Spotfire Developer

Responsibilities:

• Gathered Business requirements and designed technical requirements documentation.
• Setup the Spotfire environment from Scratch; installed Spotfire server, node manager, web player, and automation services;
• Installed both Windows and Linux version of Spotfire;
• Worked with three different teams to guide them and support them how to build report dashboards.
• Created various complexes Crosstables, Bar Charts, Line Charts and Treemap .
• Created Data sources for Report creation.
• Customized data by adding Property Controls, Filters, Calculations, Summaries, and Functions.
• Created Information Links By using Information Designer to pull the data from TIIED ;
• Created custom data source temples to connect to various types of databases;
• Deployed custom JSVIz in Spotfire server.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Created, modified, and administered Analytics Intelligence Dashboards with links to websites, HTML text, links to documents, and embedded content, such as images, text, charts, and tables.
• Experience in Writing SQL Queries.
• Created various prototypes and showed them to the users.
• Experience in enhancing the visualizations using Custom expressions.
• Experience in creating Bookmarks.
• Experience in Handling Multiple data tables in Analysis.

TIBCO Spotfire Developer

Responsibilities:

• Responsible for creating analysis, visualizations, development of business intelligence solutions, dashboards
• Create technical design specifications, develop analytical reports, troubleshoot and resolve technical issues, debug, tune and optimize report performance
• Excellent knowledge of Calculated columns, Custom expressions, Hierarchy,
• Details visualizations, Markings, Node Navigation Methods and Details on Demand
• Responsible for creating, managing and publishing Information Links and Data
• Sources to the library Responsible for publishing analysis for Web Player users
• Developed analysis and visualization for internal Marketing and Sales teams
• Integrated URLs in Spotfire and on-demand data refreshes in Spotfire.
• Expertise in data transformation, creating calculated, binned, predicted columns in Spotfire.
• Created bookmarks, tags, lists on Spotfire analysis templates.
• Implemented collaboration in Spotfire.
• Worked Extensively on Data Migration and Informatica/Spotfire Production Support(L2)
• Created numerous executive level reports. Dashboards were generated to provide insight into the sales/marketing/financial data.
• Expertise in developing Transact-SQL scripts for reuse in normalizing incoming files along with creating SQL queries
• Hands on experience in creating design document which outlines the approach of implementation Experienced in transforming business requirements into technical and functional specifications.
• Managing and motivating others in a cross-cultural /functional environment to achieve business and project objectives.
• Achieving consistent high performance in an area of rapid change and delivering high-quality business solutions.

TIBCO Spotfire Developer

Responsibilities:

• Utilized complex Spotfire features to build complex corporate dashboards and visualizations with multiple graphs and charts that analyzed the revenues of the hospital .
• Created detailed visualization and cross tab reports for each business unit to highlight the driving point.
• Used a graph table visualization to create a stand-alone Reports on Corporate and Business Unit Dashboard Reports.
• Used data table properties, property controls, filters, joins and custom functions
• Created complex query information link to connect to various data sources.
• Created complex dashboards using property controls, prompts, Filters, Calculated columns for different functionalities
• Worked on various visualizations like TreeMap, Box Plot, Parallel Coordinate Plot, Scatter Plot & Map Chart etc.,
• Performed several customizations using Iron Python scripts
• Used Filter Schemes to isolate the filter behaviors on visualizations
• Installed Spotfire Server, Database drivers, Hotfixes
• Used Microsoft SQL server for Spotfire server database, Configured Spotfire server
• Created personalized information Links for Row Level Security
• Used Multiple data sources for the DXP files, joined them using Relations Feature
• Used Dynamic Calculations based on the selection of markings in the visualizations
• Scheduled/cached the reports to improve the load time for users.
• Administered Spotfire Servers and monitored server performance and troubleshoot server issues.
• Created various custom permission groups, setup application groups and user setup that granted users distinctive permission to use Spotfire
• Participated in troubleshooting visualization performance issues and involved in tuning reports for better performance.
• Hosted upgrade strategy meeting and involved in server upgrade and smooth migration of visualizations to the new environment.
• Wrote complex SQL queries to retrieve data from multiple database objects
• Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Involved in performance tuning Queries by analyzing execution plans and building indexes as needed.
• 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.

TIBCO Spotfire Developer

Responsibilities:

• Gathered business requirements and Developed Solution design Specification.
• Created various Complex Scorecard Dashboard for the closing requirement for the analyti cal research of amortization factor and trend monthly.
• Worked on Spotfire Professional to create dashboards, and published them for end users Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Set up Information Links using Information Designer
• Worked on the Migration plan to move the Spotfire dashboards to Acceptance/Production and guide the end users to get the necessary access to the corresponding Active Directories.
• Worked on developing a training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• Participated in upgrade strategy meeting and also helped migrate visualizations from one environment to another
• Monitored Spotfire server to detect issues with server, LDAP Servers, network problems, external databases to reduce server downtime and eliminate performance bottlenecks
• Set up Guided Analysis DXP files-included Cover Page, Navigation Links, Filtering Schemes etc.,
• Used Transformations-Pivot and unpivoting
• Created DXP files from Multiple data sources
• Used Load on Demand Data tables for Performance Improvements
• Enhanced Visualizations using Trellis, Reference Lines, Custom Expressions, Details Tables
• Reviewed business application needs and worked on planning visualizations for several functional domains.
• Some dashboards included visualizations such how many customers were added by each branch each month and how this compared with other branches.
• Analyzed functional areas and formulated data requirements needs related to building visualizations.
• Created materialized views for quick and efficient data retrieval with minimized programming
• Provided 24X7 Production support.