SUMMARY:

• 7+ Years of experience in Business intelligence application design, development and maintenance of with TIBCO Spotfire and Tableau primary skills.
• Proficient in all phases of SDLC analysis, design, development, testing and deployment and highly competent in gathering user requirements.
• Very good Experience in BI using Tibco Spotfire Professional, and Tibco Spotfire Web player.
• 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
• Experience in creating complex Spotfire and Tableau Dashboards line charts, bar charts, pie charts, Combination charts, tree maps and Map charts.
• Good Experience in Customizing the Spotfire dashboards/Visualizations using HTML, Java script and Iron Python Scripting.
• Handled multiple data tables in an analysis and Spotfire Library administration and Experience with Automatic Job service Builder.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Spotfire
• Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Strong experience in writing complex SQL and PL/SQL programs, stored procedures in various databases Oracle, SQL Server, Netezza, Teradata,Hive and DB2.
• Utilized Level of detail expressions (LOD)’s, filters, date functions, window functions and Table calculations, sets, groups etc.
• Knowledge in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Extensively worked on Relational Databases like Oracle 11g/10g, IBM Netezza, Teradata, MS SQL Server, Sybase, Access, DB2 and database access tool TOAD, Rapid SQL and Agility.

TECHNICAL SKILLS:

Business Intelligence Tools: Tibco Spotfire Professional 5.5,6.5,7.6,7.10 Spotfire Web player, Tableau 5.0,9.1,10.3,10.5O

perating Systems: Windows 7,XP, UNIX.

Databases: IBM Netezza, SQLServer, Oracle11g/12C, Teradata, Hive, MS Access and DB2.

Programming Languages: C, PYTHON, R, SQL, PL/SQL

Operating Systems: Windows 7/ XP/ ME/ 2000/, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Senior Data and Reports Developer

Responsibilities:

• Working with Business Users, Analysts to gather the business requirements and Performed data analysis and Reporting.
• Developed Spotfire Visualizations Bar Charts, Line Charts, Pie Charts, KPI Charts table visualizations, Tree maps, scatter plots.
• Created Complex SQL scripts for data analysis and reporting against Oracle, Microsoft SQL Server.
• Created Data Sources, Information links using Information Designer and worked with Custom SQL.
• Responsible for handling adhoc data requests, Reporting requests and Dashboard enhancements.
• Created document property controls, custom expressions, calculated columns with in Spotfire.
• Created complex python script that accepts the user inputs via document property control and write back the data/delete the data from the database via spotfire GUI.
• Worked on handling multiple data tables, and filters with in spotfire.
• Worked on Data on Demand, Drill downs and Implemented Row level security with in spotfire.
• Developed scripts using Iron Python, created TERR/R data functions and created Home Pages with HTML scripting.
• Working with Automation Services Job Builder for job automation and created email Alerts based on threshold values using Alerts system.
• Responsible for Dashboard migration activities, Post Production support and user training.

Environment: Spotfire professional 7.10, Spotfire web player, Microsoft SQL Server, SQL server Studio, Oracle 12C and Toad.

Confidential, San Diego, CA

Spotfire Developer

Responsibilities:

• Gathered Business requirements and perform data analysis and reporting.
• Responsible for building the Dashboards on Billing, Meters Installations, Services, Readings using Tibco Spotfire.
• Represented the data in rich visualizations that helped management for their decision making.
• Created line charts, Bar charts, Combination Charts, Map charts, cross tables, Pie charts etc in TIBCO Spotfire.
• Created data sources and Information links that involve Joins, Filters, Prompts using Information designer to pull the data into the Spotfire.
• Extract the data from RDBMS databases like Oracle and IBM Netezza using SQL Quires.
• Created property controls, Custom expressions and calculated columns.
• Implemented Row level security with in the Spotfire to restrict the access to certain groups.
• Used Iron Python scripting and Java script for creating custom Visualizations and Action controls with in Spotfire.
• Handled multiple data tables and different Filter schemes in Spotfire Visualizations.
• Worked on On demand data table, created drill down visualizations, used prompts with in Spotfire.
• Used Automation Job services Builder and worked on Task schedulers and trained business users on how to use spotfire Reports.

Environment: Tibco Spotfire Client 6.5,7.0, Spotfire Web Player, Oracle 12C,Toad,Microsoft SQL Server, SQL Server Management Studio, Teradata, Teradata SQL Assistance.

Confidential

Senior Software Engineer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Created data sources and information links using Information designer.
• Worked with Complex Calculated columns, Ranking functions, Over Expressions, Markings and Custom expressions.
• Created complex KPIs and Drill down Reports that help both management as well as Analyst.
• Created Reports on Billing, Members, by age wise, Coordination of Benefits on senior members Medicare data.
• Worked on Tibco Spotfire Server, web player and Library administration.
• Created Action Controls using Iron Python scripting.
• Created complex calculations, various filters, Actions, Groups and Sets for representing Top and Bottom member’s data.
• Created Line Charts, Bar Charts, Cross tables, Pie charts and map charts to represent the complex data in the form of nice Visualizations.
• Published the dashboards into the Tableau server and provided access controls.
• Published the data sources into the Tableau Server and scheduled automatic updates.

Environment: Tibco Spotfire Professional Client 6.0, Spotfire web player, Tableau 6.0, Oracle 10g, Toad, MS SQL Server, SQL Server Management Studio.

Confidential

Software Engineer

Responsibilities:

• Gathered Business requirements and perform data analysis and reporting.
• Responsible for creating Complex Tableau dashboards like Line Charts, Bar Charts, Cross tables, heat map, Pie Chart etc.
• Create Complex SQLs and PL/SQL Procedures to extract the data from Oracle.
• Created Technical Specification documents from the Business Requirements documentation.
• Responsible for testing the Data/Reports against Existing Tableau Reports and Excel.
• Involved in developing new Tableau Dashboards as per the user requirements by identifying the required tables from Data mart and by defining the data source connections.
• Created custom SQL’s, Tableau Data extracts (tde) and scheduled the extracts based on the users need.
• Experience in SQL performance tuning.
• Developed Critical Reports like Drill drown for detail analysis of the loans.
• Created / Set up alerts and subscriptions in Tableau.

Environment: Tableau5.0, Microsoft SQL server 2008, Microsoft SQL Server Studio, SQL