SUMMARY

• Eight years of experience on Spotfire, Business Intelligence Applications
• Five 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 Spotfire reports using Tibco Spotfire Professional; Installation of Tibco Spotfire server, Administration, tuning, and monitoring the server
• Three years of experience in ETL - SSIS and Pentaho
• Three years of experience in SSRS
• Three years of experience in SQL Server T-SQL programming.
• Two years of experience with SAP Business Objects
• Proficient in Data warehousing, Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, SQL Server 2000/2008/2012, Teradata

TECHNICAL SKILLS

Software: Tibco Spotfire 7x/6.5, Business Objects XI R3.3, R2, 6.5/5.1, SSIS, SSRS

Database: Oracle 11g-9, MS SQL Server, Teradata, Redshift

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Senior Spotfire Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end
• Understanding existing business model and User requirements.
• End to End development dashboard
• Knowledge of Oracle 10g/9i, Teradata, Tomcat 4.0, SQL server and reporting tools.
• End to end support for Spotfire and Qlikview
• Involved in installation and configuration of Spotfire
• Creating High end visualization using most advance technology with Spotfire
• Involved in Project planning, estimation, Sow creation and implementation of successful project.
• AWS configuration for the project
• Spotfire Administration
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices
• Server Configuration and Installations of Spotfire
• Designing and Maintenance of the license
• Providing KT, Training, Maintaining the Project management, risk analytics for the project
• Providing the root cause analysis of the issue and problem tickets
• Setting up project management activities
• Configuration of ITIL for the project.
• Involved in creating database objects like tables, views, procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Wrote complex SQL queries to retrieve data from multiple database objects
• Development of dashboard using complex KPI/reports using SSRS and Power BI
• Writing SQL Server stored procedure
• Creating ETL using SSIS package.

Environment: Microsoft SQL server, Redshift, SSRS, SSSIS, Power BI, rave, Exadata, Iron python, R, Java script, R programming

Confidential, Memphis, TN

Spotfire Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use.
• Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Creating TERR script for predictive analysis using R statistical programming language.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
• Connected to Spotfire using different connectors like SQL, Teradata, and Active Spaces.
• Achieved complex requirements i.e. complex dashboards using HTML, Python and Java scripts.
• Executed the queries in the Teradata and validated the data.
• Customized Reports by writing complex custom SQL.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Worked on developing training program, user guide for SpotfireProfessional and Spotfireweb player in terms of best developing and design practices.
• Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
• Provided high level, complex support services and delegate low level support to off-shore support staff.
• Implemented system modifications as per established requirements.
• Prepared project estimates and analyzed reporting issues.
• Formulated dashboard specifications and generated status reports.

Confidential, Atlanta, GA

Tibco Spotfire Developer and Admin

Responsibilities:

• Used various visualizations like Bar, Line, Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.
• Used property controls, filters, joins and custom functions to get data from information links
• Relay dependencies and risks tostakeholders
• Used MVC FrameworkAngular.js in the development for data binding and to consume REST full web services
• Proficient in creating power BI Dashboards and visualizations
• Managed and trackedCiscodesktop virtualization pipeline across the commercial vertical
• Set up the Queues, Topics, Connection Factories, and Bridges inTIBCOEMSServer.
• Performed Complex calculations using OVER Statements
• Used Lists, tags and Bookmarks for some interesting snapshots of data
• Used Filter Schemes to isolate the filter behaviors on visualizations
• Data on Demand was used to load data on demand into dxp files
• Used Dynamic calculations based on the markings user selects in the visualizations
• Used iron Python scripting for some customizations
• Worked closely with theCiscoDataCenter sales and sales leadership to evangelize Citrix Solutions.
• UsedAgileMethodology for Project Implementation
• Work in anAgileteam and follow scrum model deploying code to production every month
• Implemented TIBCO Hawk rule base to monitor and test the BW engine, EMS Server, log files and database.
• SME forCrystalReportsand SAP Business Objects.
• Involved in development of commonly usedangularcomponents across teams such as Customer Directives for grid, pagination, conditional validations
• Used a graph table visualization to create a stand-alone Reports on corporate and Business Unit Dashboard Reports.
• Used Microsoft SQL server to hold Spotfire server database
• Strong Knowledge in understating of messaging concepts like EMS, RV, MQ Series
• Configured Spotfire server - Set up single sign on
• Analyzed the Action logs to find what the users are doing, when they login, who did what etc.
• Upgraded Spotfire from 6.5 to 7
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Action Controls and wrote scripts using Iron Python. Performed several customizations using the scripts
• Set up folder permissions using Library administration.
• Created configuration blocks in Spotfire and setting up guided analysis
• Set up Projects, Groups, Users and set up Permissions

Environment: Tibco Spotfire Professional 7.5, Spotfire Web Player, Spotfire server, Servlets, Windows 2008 server, SQL Server 2008, Teradata

Confidential, San Diego, CA

Spotfire Developer and Admin

Responsibilities:

• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links
• Created Information links, parameterization, defined join rules in Information designer.
• Used Filter Schemes to isolate the filter behaviors on visualizations
• C Programming, System Programming, Socket Programming on Linux, Network Programming through TCP/IP, 8051, ARM
• Involved in various SystemIntegrationtesting ofAPI
• Used Load on Demand to improve performance of spotfire dashboards
• Involved in logging, monitoring, and statistics facilities to effectively view system activities and track system performance usingTIBCO/EMS.
• Good experience in JSP, Struts,Javascript, angular JS, html, CSS, jQuery. Good knowledge in Apache ant, maven, Gradle, GIT, Jenkins/Hudson
• Worked Extensively onTibcoEMS andRV.
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Installed Spotfire Server, Database drivers, Hotfixes
• Configured Spotfire server - Set up single sign on
• Wrote Spotfire server Backup scripts to take backups regularly
• Hands on experience on compiling, installing and configuring software inLinuxandUNIXincluding Apache web servers, MySQL database servers and Tomcat.
• Involved in theAMSTIBCOApplication support team efforts in successfully providing support to the currentTIBCOframe work.
• Monitored Spotfire server to detect issues with server, LDAP Servers, network problems, external databases to reduce server downtime and eliminate performance bottlenecks
• Analyzed the Action logs to find what the users are doing, when they login, who did what etc.
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.
• Installed and Configured Spotfire Server
• Set up Projects, Groups, Users and set up Permissions

Environment: Tibco Spotfire 6.5/5.5, Windows 2008 server, Borland, JBuilder, SQL Server 2012

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Used dimension lookup/update step to populate data into SCDs.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schema.
• Identified, tested, and resolveddatabase performance issues(monitoring and tuning) to ensure database optimization.
• Created cubes using schema workbench on top of DW star schema
• Dealt with slowly changing dimensions type 2 and multi-level hierarchical dimensions.
• Published cubes and reports onto Pentaho repository and refreshed Pentaho BI repository after uploading each object to be available for central use.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL and stored procedures.
• Used MDX queries to generate custom ad-hoc reports with addition of calculated members in the reports.
• Prepared mapping document for ETL and user manuals for end users in order to educate them about execution of BI reports.

Environment: Pentaho Kettle, Windows 2008, oracle 11g, Oracle, AERS, TOAD

Confidential

ETL /SSIS Developer

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Involved in UAT of the applications by providing users with test cases and scenarios, and guiding them during the testing process.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.

Environment: SQL Server 2008/2005, C#., VB, VBA, UAT, ASP, .NET, Tableau, SSIS, HTML, XHTML, Java, JSP, Oracle, PL/SQL, MS Office