SUMMARY:

• Senior BI Analytics Developer with over 10 Years of IT Experience in Database and Business Intelligence Technologies with expertise in TIBCO Spotfire, Tableau and OBIEE .
• Experience in creating Complex Visualizations and Spotfire Dashboards.
• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Hands - on with creating solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Worked on the development of Dashboard reports for the KPI for the top management.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Used OBIEE to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in OBIEE.
• Good knowledge of Normalization, Collations, ETL, Data Modelling like Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
• In depth knowledge of Software Development Life Cycle (SDLC), Agile methodology, HP ALM and QC.
• Experienced in Unit Testing, Regression Testing and User Acceptance Testing.
• Experience in guiding the team to accomplish the goals set by management and play a vital role in supporting the team from front and yet at the same time work under a supervisor.
• Excellent communication skills in both written and oral along with ability to tell a story through data.

TECHNICAL SKILLS:

BI Tools: TIBCO Spotfire 7.6,7.0,6.5, WebPlayer,Tableau 7.0, 8.2, 9.0 and OBIEE

Programming: SQL, PL-SQL, UNIX Shell, C, C++, VBA, VB, R, Python

ETL Tools: SSIS, Informatica

Defect management tool: HP ALM and QC

Databases: Oracle SQL Server, MS SQL Server, MS Access, MS Excel, PostgreSQL

Platforms: Windows, Mac OS, DOS, UNIX, Linux, Ubuntu

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Sr. Tibco Spotfire Consultant

Responsibilities:

• Gathering the requirements from business team and transmuting them into technical design documents.
• Involved in estimation, analysis and solution documents. Created various complexes Waterfall Charts, Tornado Charts, Bullet Graphs, bar charts, combination charts and line charts.
• Customized data by adding Property Controls, Filters, Calculations, custom expressions and Summaries and Functions.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Created various prototypes and showed them to the users.
• Created Action Controls using Python Scripting, Action controls to navigate to the different pages or visualizations.
• Working knowledge in HTML, JavaScript to create Guided Analysis.
• Experience in enhancing the visualizations using Custom expressions.
• Experience in creating Bookmarks.
• Experience in Handling Multiple data tables in Analysis.
• Giving security access to the DXP files of folders or Information links.
• Conducting Unit testing of the reports developed in Spotfire Professional.

Confidential, NJ

Tibco Spotfire Developer

Responsibilities:

• Gathering the requirements from business team and transmuting them into technical design documents.
• Involved in estimation, analysis and solution documents.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Created the Materialized views on the aggregate functions and used that in the reports
• Created various Reports using Spotfire and involved in Performance tuning.
• Created reports using complex calculations and variables.
• Serve as a primary point of contact for Production Support issue resolution.
• Extensively worked with formatting the reports according to the user requirements.
• Created Action Controls using Python Scripting, Action controls to navigate to the different pages or visualizations.
• Involved in migrating the dashboards.
• 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.

Confidential, NJ

Spotfire Developer

Responsibilities:

• Created sophisticated visualizations, calculated columns and custom expressions and developed Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Created Complex Information Links to pull the data from Database.
• Created the Materialized views on the aggregate functions and used that in the reports.
• Created various Reports using Spotfire and involved in Performance tuning.
• Created reports using complex calculations and variables.
• Implemented User level security to the Reports.
• Serve as a primary point of contact for Production Support issue resolution.
• Extensively worked with formatting the reports according to the user requirements.
• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using Spotfire.
• Used Iron Python to create power actions in test areas.
• 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.

Confidential, NJ

Tableau Developer

Responsibilities:

• Involved in reviewing requirements and data sources form MS SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards. Created extract files for improving the performance.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization and created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Experienced with Unit testing, Regression Testing, and User acceptability testing.
• Worked on go-live phase and provided post live support, Coordinating and solving issues with QA and production.

Confidential, New York, NY

OBIEE Developer

Responsibilities:

• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Worked with ETL Team using SSIS.
• Developed automation tool to seed and purge the cache in Admin tool.
• Performed OBIEE Administration - including creation of Users and cache management
• Created hierarchies based on the territory level for territorial level sales and contact reports
• Used constrained filters, column filter prompts and various views such as Pivot tables
• Developed and executed Unit & Integration test cases scripts.

Confidential, Atlanta, GA

OBIEE Developer

Responsibilities:

• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Enabled Usage Tracking Table and Dashboards.
• Created Time Series Measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Used Guided analytics to display Sales below Threshold reports for different regions
• Performed OBIEE Administration - including creation of Users and cache management
• Developed interactive Dashboards using OBIEE Answers
• Experience in migrating the repository and web catalog from development to production environment.
• Experience in configuring security using LDAP server.
• Developed and executed Unit & Integration test cases scripts.

Confidential

Data Analyst

Responsibilities:

• Involved in multiple Siebel Analytics implementations for US clients.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level.