SUMMARY

• Over all 8+ years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applicationsCustomization of spotfire reports using spotfire APIs and scripts.
• Designed and developed Analytics solutions using TIBCO Spotfire for various business domains
• Proficient in designing multiple enterprise level Spotfire Analytical solutions
• Work with users on how to use Spotfire as an analysis tool including training as well as collaborating on report generation
• Responsible in creating the Analysis Design and Building dashboards by creating the information links from warehouse to display data in reports.
• Created Action Controls using Iron Python.
• Strong attention to detail in supporting management reporting with clear and concise data analysis and presentation.
• Ability to quickly learn new database design and development methodologies, concepts and tools.
• Knowledge of Oracle 10g/9i, Teradata, SQL server 2000/2003 and reporting tools.
• Experienced in delivering user training to different levels of user groups and conducted workshops.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Excellent problem solving skills with the ability to provide creative solutions.
• Worked on both Development and Support & Enhancements Engagements.
• Effective communicator with excellent relationship management & negotiation skills; possess a flexible & result oriented attitude
• Proven Client relationship management Spotfire Expertise (version 5.x, 6.x & 7.0.x):
• Expertise in working with Large Data Sets, In - Database Data, In-Memory Data
• On Demand Data through Information Links
• Worked with multiple data sources like (SQL Server, Oracle, ADS Composite Information Server & Flat Files)
• Custom Queries
• Data Transformation
• Visualizations: Map Chart, Combination Charts, Bar & Line charts, Graphical Tables, Pie charts, Tree Maps, Heat Maps, Scatter Plots
• Text Area: Editing HTML, Java Script, Action Controls Properties, Iron Python Scripts
• Did enhancements on Visualization Properties
• Filters: Filtering Schemes, Range, Item, Radio, Check, List box
• Lists, Bookmarks & Tags
• Information Designer: Creating Information Links, On Data demand, Use SP’s
• Setup the Spotfire Database (Microsoft SQL Server & Oracle Engines)
• Install the Setup & handle IIS in windows server
• Configure Bootstrap file
• Authentication: Basic, LDAP Active Directory
• Data Source Templates
• User Action Logs
• Configure Library Properties
• Configure Administration Panel
• Deploying & configuring Client Packages
• Restarting the Services
• Install the Web Player Server & configure IIS
• Deploying Web Packages to Spotfire Server
• Licenses & Library Rights
• Upgrading to the New versions
• Deploying or Migration of Analysis across multiple environments
• Managing User groups & Access

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Spotfire Consultant

Responsibilities:

• Provided application expertise and conducts discussion sessions by interacting with business users,identifying information needs, and requirements gathering.
• Worked with team and stakeholders to understand the business requirements.
• Understanding the design requirement, programming the system, unit testing the changes and working with business partners to ensure full system testing is complete and the implementation is successful.
• Created Data sources for Report creation. 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.
• Experience with creating DDL’s and DML’s using HIVE-QL, creating partitions, bucketing in Hadoop
• Experience in Writing SQL Queries against SAP HANA, Hadoop Hive and SQL Server
• Experience in Handling Multiple data tables in Analysis
• Converted Various Excel, Crystal Reports to Spotfire
• Conducting Unit testing of the reports developed in Spotfire Professional
• Responsible for the migrating the reports from Development to Acceptance / Production Server.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices
• Experience in copying the data from different RDBMS systems using MuleSoft
• 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
• Created SSRS Report Model Projects inBIstudio and created, modified and managed various report models with multiple model objects, source fields and expressions
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder
• Experience in creating needful visualizations using line & bar charts, filled maps, donut, scatter chart, pie chart inPowerBI

Environment: Spotfire 6.5, 7.x, SAP HANA, Haddop Hive, SQL sever, Microsoft Azure, Windows, Iron Python, R-Script, HTML and Javascript

Spotfire Consultant

Responsibilities:

• Worked on creating Pie chart, Scatter Plot, Stacked bar Chart and Map chart based on the requirement document provided by the business team.
• Configuring data tables for data on demand and parameters to fetch data from data sources based on user selections.
• Pivoting and transforming data in spotfire professional before building visualizations.
• Created reports and advanced visualizations by using the key concepts filtering scheme, Data on demand, property controls etc.
• Created the visualizations with complex calculations/functions.
• Worked on Information designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Worked on the defects raised by QA team.
• Testing and debugging the dashboard for quality assurance.
• Created stored procedures for each report.
• Conveying problems, solutions, updates and project status to project manager in a timely and regular basis.
• Worked on End-User training.
• Assisted the team in solving the defects using Ironpython Script.
• Responsible in writing scripts to create action controls, buttons and property controls to increase user friendliness to perform analytics.
• Responsible for creating cost effective efficient Data visualizations.
• Analyze and document process along with quick resolutions for typical issues in Deployment and which were critical to the process.
• Project Delivery aspects like UAT, Production Migration and Production Implementation.
• After the deployments to QA and UAT environments, involved in smoke tests to ensure reports are working.
• Coordination with various internal/external system interface team for design/integration testing/ deployment and production issues.
• Created spotfire design document and database design document for reference.

Environment: Spotfire 6.x & 7.x, SQL Server 2008, Iron Python, HTML and Javascript

Confidential

Spotfire Developer

Responsibilities:

• 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.
• Lead the team in an agile-driven environment of development
• Translate product requirements and business questions into report requirements and visualization dashboards.
• Lead all the prototype creations for the R&D effort involved w.r.t TIBCO Spotfire Visualizations and Extension development.
• Created dashboards, reports, analytics and advanced graphical virtualizations by using the key concepts filtering scheme, Data on demand, property controls etc.
• Created the visualizations with complex calculations/functions.
• Worked on Information designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Created information links and managed process analysts work to realize the required solution from a data perspective.
• Created visualizations using advanced concept of data on demand and marking functionality in Spotfire from oracle to historian web services to increase greater performance in user analytics.
• Responsible in writing scripts to create action controls, buttons and property controls to increase user friendliness to perform analytics.
• Experienced in configuring and administering Spotfire Server components TIBCO Spotfire Application Data Services and Automation Services.
• Worked with Automation job services, configurations blocks to pass the values to parameterised information link to generate and email the reports to customers.
• Responsible for Spotfire platform administration tasks, Spotfire database administration tasks, and providing production and operational systems support to Clients and Stakeholders
• Responsible in Migrating the code and DXP file across all environments (Dev - QA - PROD).
• Involved in enhancing and deploying the Custom plugin’s to Spotfire client (Export to word and task broker)
• Implemented and managed automated monitoring solutions for Spotfire Platforms to ensure SLAs are maintained
• Provided mentoring and consulting to other BI team members in Spotfire
• Advised on Tibco Spotfire best practices, tools and specific technical solutions to support complex business requirements.

Environment: Tibco Spotfire 5.x, 6.x, Iron Python, SQL Server.

Confidential

Java Programmer

Responsibilities:

• Involved in development of GUI using HTML and JSP where Java Servlets were used as the interface between the client and server.
• Effectively written JavaScript for the client side validations for the Job Portal.
• Developed Java Beans to handle business logic as a Model and Servlets to control the flow of application as controller.
• Involved in deployment of the Application on Web Sphere Application Server.
• Written JavaScript and Ajax functionality to get dynamic data and client side validation.
• Developed this application based on MVC Architecture.
• Designed and developed Customer registration and login screens using HTML, JSP, Servlets and JavaScript.
• Involved in Servlets, Java Bean programming on the server side for the communication between clients and Server.
• Involved in production support from client requirements to developmental aspects with coding, system optimization and testing.
• Worked extensively for loading/updating information asynchronously using AJAX.
• Involved in application testing manually and defects fixing.

Environment: J2EE, Java, Servlets, JSP, JDBC, Eclipse, Websphere, Oracle, CSS, HTML, JavaScript, HTML, PVCS.