SUMMARY

• 4.5 years of experience in IT industry with a strong background in Analysis, Design, Development and implementation of Business Intelligence applications.
• Experience with the BI tools Tibco Spotfire and Tableau.
• Developed cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions in Spotfire.
• Hands - on on Spotfire dashboard scripting using Iron python and Java/HTML.
• Good at designing and developing a best possible visual solution to KPIs requested by customer.
• Created Spotfire reports, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, etc.… using properties functionality.
• 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.
• Has worked on Developing Fonts, Web designing, generating automated test cases using python
• Proficient in designing techniques like Star schema, Snowflake schema, fact and dimension tables, logical and physical modeling.
• Worked on databases like SQL, Oracle, Teradata and MS Access.
• Good analytical strengths, successfully working through problems and implementing solutions in time.
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Programming Languages: C, Python

Web Designing Languages: HTML5, CSS

Database: Oracle, Teradata, MS Access.

Development Tool: Django

Reporting Tool: Spotfire 5.5 - 8.0, Business Objects XI R2

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential

BI Analyst/Developer

Responsibilities:

• Collect user requirements from study team members (study physicians and data managers)
• Load the clinical trial datasets (in Study Data Tabulation Model) in Spotfire
• Map existing data visualization templates in iDARTs to the clinical trial datasets
• Design new visualizations (Tables/Graphs) based on the user requirements
• Conduct review sessions with the study team members
• Facilitate User Acceptance Testing
• Function as a liaison between study teams and the iDARTs support team
• Follow-up on needed improvements and changes needed
• Identify additional needs for medical review
• Provide input to the iDARTs IT group
• DECISION-MAKING AND PROBLEM-SOLVING while balancing the need for further escalation of issues that require more complex decisions

Environment: Spotfire 7.8.0

Confidential

Onsite Coordinator

Responsibilities:

• Gathered user requirements, analyzed reports and provided the solution based on the requirements. analyzing the existing dashboards in Spotfire and enhancing them according to business need. touch base with users to know the report usage and existence.
• Creating the run book to have startup and detail level reverse engineering.
• Reverse engineering involved information regarding data source, functionality implementation for each individual visualization embedded in the report.
• Analyzing the functionality for the hierarchy build in report structure at organization level. worked extensively with Filters, Actions, Calculations, Parameters
• Configured Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts.

Environment: Spotfire 7.5.0

Confidential

SPotfire Developer

Responsibilities:

• Gathered user requirements, analyzed and designed the database and provided the solution based on the requirements.
• Involved in creating dashboards and reports in Spotfire.
• Created spotfire reports, dashboards using stack bars, bar graphs, scattered plots etc… using show me functionality.
• Worked extensively with Filters, Actions, Calculations, Parameters, Maps, and Trend Lines for preparing dashboards and worksheets.
• Hands-on on Spotfire dashboard scripting using Iron python and Java/HTML.
• Created individual tabs and incorporated them into Dashboards with the appropriate filters.
• Created Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts.
• Executed and tested required queries and reports before publishing and published them to server.

Environment: Sptfire 7.0, Oracle

Confidential

BI Developer (Spotfire)

Responsibilities:

• Set up business user meetings to define, design and document the reports as per user expectations.
• Gathering end users/customers’ requirements and creating functional and technical specification documents.
• Created Joins by combining tables, Created Column Elements from available data sources and Created Filter elements to limit the data retrieved.
• Added data to existing data tables by merging new columns or rows and Data Transformation.
• Involved in End to End lifecycle of Project which includes Requirement Gathering, Design, Development
• Extensively performed UAT on reports before migrating them from DEV to Production.
• Reviewing developer code in pre-production environments, analyzing long running queries, and make recommendations and suggestions for performance improvement.
• Functional Testing of individual outlier components
• Deployment of reports in the server
• Documenting knowledge-based articles on processes, fixes, etc. for the team in SharePoint.

Environment: Spotfire 5.5, SQL

Confidential

BI Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for data modeling and Reports.
• Worked on Troubleshooting and Bug fixing the Spotfire Analysis
• Created Information Links that retrieve data from one or more databases and shared with Colleagues
• Distributed and shared our analysis with users in the full client through Webplayer.
• Preparing Project documents like Weekly Status Report, KPI Reports
• Daily interaction with client for review of the developed versions of reports
• Developing reports using Tibco Spotfire Data Visualization.
• Deployment of Spotfire Reports on Report server using library to view on TIBCO Web player
• Created Functional and design documents.
• Documenting knowledge-based articles on processes, fixes, etc. for the team in SharePoint.
• Reports walk through to the application support team.

Environment: Tibco Spotfire 5.5, Oracle 10g

Confidential

Software developer

Responsibilities:

• Designing Fonts
• Writing automated test cases
• Updating Dashboards
• Interacting with users through bugzilla & Github
• Resolving errors
• New upstream test build & release

Environment: Python, Linux OS, Unicode Rule writing for Font development

Confidential

Software developer

Responsibilities:

• Designing web pages
• Interacting with users through bugzilla & Github
• Developing Packages
• Resolving errors
• Building & releasing new upstream tests

Environment: Python, HTML, CSS