SUMMARY:

• Having 10 years of working experience in IT and experience 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. Implemented CDISC, SDTM standards for the Spotfire Reports.
• Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process.
• Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Worked on designing dashboard / reports / applying Geomap to the data in Spotfire to give them consistent and professional looks using TIBCO Spotfire Professional.
• Extensively worked on Power Center Client Tools - Designer, Workflow Manager, Workflow Monitor
• Expertise in Data Warehouse and Database development skills using Oracle SQL.
• Created SAS aggregates for ad hoc reports, issue resolution, compensation reporting, targeting analysis, business development, sales operations, and the analysis of market potential
• Extensive Working Experience in Testing for UAT testing and Production for Support through Tickets and Involved in Executing Scripts.
• Excellent analytical and problem-solving skills to Resolves in-depth queries in a methodical manner independently to find appropriate resolutions.
• As a team player, enjoys sharing knowledge and encouraging development of others to achieve specific team goals.
• Used PerkinElmer’s Connector for Medidata Rave which allows quick access to clinical, operational and audit data in an industry standard CDISC ODM format.
• This connector facilitates the instantaneous export of Medidata Rave data and creates one TIBCO Spotfire data table per form / view thereby enabling the power of exploration of Medidata Rave data in TIBCO Spotfire with a few clicks.
• The benefit of this connectivity is clinical development teams can run their analytic workflows directly against the source EDC data bringing clinical development teams closer to the source data, improving the quality and speed of decision making.
• Automation capabilities eliminate the need for manual refreshes of the Medidata Rave data providing Clinical IT groups a low maintenance solution.
• Timely and accurate data can be provided to key decision makers thus accelerating the time to market for therapeutics across the entire portfolio of clinical candidates.
• Automatically export Clinical, Operational and Audit data from Medidata Rave in the industry standard CDISC ODM format for fast analysis in TIBCO Spotfire

TECHNICAL SKILLS:

BI Tools: TIBCO Spotfire Professional 7.0, 6.5,6.0, 5.5,4.5,4.0,3.X, TIBCO Spotfire Web player, Tibco Automation Services, TIBCO Spotfire Statistical Services. Open Source R

Operating systems: Windows 2008 server, Windows 2003 Enterprise Server, XP, 2000, UNIX

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: JAVA, VISUAL BASIC, COBOL, JCL

Database: SQL Server2005/2008, Oracle 9i/10g,11g

Legacy systems: IBM Mainframe S/390, AS400

ETL & Analytic Tools: SAS, Informatica 8.6.1/8.1

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior TIBCO Spotfire Consultant

Responsibilities:

• Interacted with the Business users and documented and Involved in Requirement gathering from Business Users.
• Upgraded and configured the TIBCO Spotfire on Single Server Environment, Administering the Servers, Troubleshooting, Performance Tuning and implementing security.
• Provide an integrated enterprise-wide system solution encompassing all of the current operational and support requirements across compliance
• Created dashboards from scratch using SBDF and Information links, Executed iron python scripts and custom expressions.
• Developed complex reports involving multiple data sources
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts/Filters.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting with Spotfire
• Customized Navigation to reports for Dev, UAT, prod Reports using HTML and JS.
• Coordinated training sessions and demonstration of Spotfire tools to End-users.

Confidential, MD

SR. TIBCO SPOTFIRE CONSULTANT

Responsibilities:

• Implemented complex reports for different teams like USIS, CRM 360 etc. involving multiple data sources in Spotfire 7.6, 6.0.
• Developed different reports for desktop/iPad/iPhone devices using python scripting and bookmark approaches.
• Enhanced the Layout of the report with HTML customization in Text area for best look & feel.
• Dealt with different types of information links like Personalized, Parameterized, prompted to implement security for different groups and also to avoid performance issues while bringing huge sets of data.
• Used Iron Python scripting and JavaScript to execute some key features like switching between different mobile views, show/hide of document property controls, action-controlled buttons.
• Created plenty of sample dashboards using database function to validate the dashboards against Prod database to avoid UAT issues during development phase.
• Executed iron python scripts and custom expressions within Spot fire.
• Administration: Managed Folder level permissions for various reports as part of compliance and reports migration across different environments like DEV, QA and PROD.
• Well versed with TSG Service now, HP ALM/Quality center.

Confidential

SR. SPOTFIRE CONSULTANT

Responsibilities:

• Strong hands-on working knowledge of Tibco Spotfire architecture including Spotfire Professional, Spotfire Web Player, Spotfire Developer SDK, Spotfire Server, Spotfire Automation Services, Spotfire Application Data Services, and Tibco Business Events
• Extensive experience in using Spotfire to automate the creation and delivery of analytics in a rich, contextual and interoperable enterprise framework
• Understood the project scope, identified activities/ tasks, task level estimates, schedule, dependencies, risks and provided inputs to Module Lead for review
• Created logical measures in the Information Link of Spotfire as per the requirements
• Worked on various new Chart developments like Bar Chart, Scatter Plot, Cross Table & Map Chart
• Worked on complex topics in TIBCO Spot fire like Statistical Analysis, Iron Python Scripting & Property controls
• Deployed/Migrated Spot-fire DXP files till UAT/Production environments.
• Provided inputs to testing strategy, configuration, deployment, hardware/software requirement
• Reviewed plan and provided feedback on gaps, timeline and execution feasibility as required in the project
• Participated in KT sessions conducted by customer/ other business teams and provided feedback on requirements

Environment: TIBCO Spotfire 6.X, Spotfire Web player, Spotfire enterprise player, Oracle10g, MS SQL Server 2008, TOAD, SQL, Windows server

Confidential

SPOTFIRE DEVLOPER

Responsibilities:

• Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite.
• Installed Tibco Statistical Services with Open Source R
• Involved in multiple Spotfire Environments upgradation and performance improvement projects from 3.3 to 5.5 ;4.5 to 7.0 & 5.5 to 7.0
• Applied application bug fixes and patches, which was challenging because AbbVie’s is a validated environment and required large numbers of custom complex process and increased Spotfire Performance for the end user
• Architect and design multiple SpotFire infrastructure environments with a user base of 100 developers & 2000 web users
• Implemented web player server/Spotfire server clustering on 5 different servers to handle user loads effectively and developed architectural diagrams of the new environments
• Worked on LDAP Configurations as there was a domain migration from Abbott to AbbVie net domain
• Created various complex Visualizations, Information Links, automated whole process using Tibco Automation Services to create the study data template.
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire Web player server for end user use.
• Conducted Occasional load tests with about 100-200 concurrent users and ran the biggest files to check memory usage and their throughput
• Configured SpotFire automation services to load incremental data coming from SAS daily into SpotFire.
• Deployed SpotFire custom made visualizations developed in C# on IIS.
• Troubleshoot issues by having one-one communication regarding Script Authors, Schedule updates, report development & Web player.
• Created Database connections and Spotfire Dashboard file (DXP) in Spotfire server.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Created interactive Dashboards, applying Geomap to the data in Spotfire and Business Presentations by importing data fromSAS, Excel Filesusing Spotfire.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• As a Spotfire admin monitored the performance of the tool as required made necessary changes in the schedule updates. Monitoring Webplayer logs and licenses changing consistently according to user requirement.
• Lead the migration project from Abbott to Abbvie servers, which consisted migrating the Active directory, Oracle Forms and reports of all projects

Environment: Tibco Spotfire Server & Professional V3.x to the latest 7.0, Spotfire Web player, Spotfire Automation Services, Tibco Statistical Services, Open Source R, Oracle, Excel, SAS & Windows servers

Confidential, PA

SPOTFIRE DEVELOPER

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite.
• 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.
• Created interactive Dashboards and Business Presentations by importing data fromExcel sheetsusing Spotfire.
• 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 Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: Spotfire Professionals 4.5, Spotfire Web Player, Spotfire enterprise player, SQL Server, TOAD, SQL, windows server.

Confidential, COLUMBUS, OH

SPOTFIRE DEVELOPER

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Created dashboards and applications and Spotfire workbooks(DXP) from scratch based on clients needs
• Worked with end users to explain TIBCO Spotfire workbooks, creating ad-hoc reports
• Installed & configured the TIBCO Spotfire on Single Server Environment, Administering the Servers, Troubleshooting, Performance Tuning and implementing security
• Coordinated an employee training program for various Spotfire applications and basic troubleshooting principles
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts/Filters.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting with Spotfire
• Customized Reports using HTML and JAVA SCRIPTS.
• Created Materialized views for improve the performance of the reports.
• Assigning work to the offshore team on daily basis.
• Setup Weekly Status Calls with offshore team.
• Coordinated training sessions and demonstration of Spotfire tools to End-users.
• Developed technical specification document for the offshore team.

Environment: TIBCO Spotfire Professional, Spotfire web player, Spotfire enterprise player, Oracle 10g, Windows 2000.

Confidential

ETL DEVELOPER

Responsibilities:

• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Developed Mappings using various transformations like connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Stored procedure, Sequence Generator, Update strategy and Joiners etc. depending upon requirement.
• Worked with Informatica components like designer, Work flow manager, Work flow monitor, Repository Manger,
• Designed Type1 (overwriting, no history) and Type2 (flag, version, date) mappings.
• Implemented code migration from development to testing.
• Tuned sources, targets, mappings and sessions to improve the performance of data load into Oracle database
• Knowledge in Star Schema and Snow Flake Schema to fit reporting, query and business analysis requirements.
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.6.1/8.1, DB2, SQL, PL/SQL, Sql Developer, WINDOWS XP, UNIX Shell Scripting.

Confidential, SEATTLE, WA

ETL/DATA WAREHOUSING DEVELOPER

Responsibilities:

• Involved in data modeling and database design of the new P&C Legal management database by applying Ralph Kimball methodology of dimensional modeling and using Erwin.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server and flat file sources targeting the views (views on the target tables) in the target database.
• Created Sessions and Workflows to load data from the SQL server and flat file sources that exist on servers located at various locations all over the country.
• Used pre-session shell scripts to generate User IDs that are loaded into a flat file and then into the target tables.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for P&C Legal management reporting.
• Involved in unit testing, integration testing and user acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Designed and developed reports using Microsoft Reporting Services tool.

Environment: Informatica 7.1, Microsoft Reporting Services, Oracle 9i/8i, SQL Server 2000, Erwin 4.1, VSS. Flat files