SUMMARY

• 8 years of related experience in Information Technology with 5+ years of experience as Tibco Spotfire Developer/Consultant in various industries.
• Experience in creating complex Spotfire dashboards or reports using Tibco Spotfire Professional.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Created Complex Information Links to pull the data from Oracle 10g/11g.
• Expert in Writing SQL Queries on Oracle and DB2.
• Created various Reports using Spotfire and involved in Performance tuning.
• Experience with extracting and combining different data sources, different databases and data warehouses.
• 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.
• Adept Designing/Developing the Business Objects Universes, Ad - hoc/ Canned Reports, Complex Reports using predefined conditions.
• Business Analyst experience across multiple functional business areas.
• Thorough understanding of the Software Development Life Cycle.
• Proficient in developing and managing project requirements, budgets, timelines and deliverables.
• Aptitude for working with business experts and end users to understand needs and provide solutions.
• Aided senior management decision-making through accurate and actionable business intelligence inputs on effort estimation and design issues

TECHNICAL SKILLS

BI Tools: Business Objects XI 4.0/3.1/3.0/ XI R2/6.5, Designer

TIBCO Tools: TIBCO Spotfire 4.X/5.X/6.x

Databases: Oracle 9/10/11g, DB2, SQL Server, Teradata12.0/V2R5.

Languages: C, C++, HTML, Iron Python, SQL, PL/SQL

Environment: Windows 8/7/XP/2000, UNIX (Solaris 9/10, Linux), HP-UNIX

PROFESSIONAL EXPERIENCE

Confidential, Mason, OH

Sr. TIBCO Spotfire Developer

Responsibilities:

• Gathering the requirements from business team and transmuting them into technical architecture and design documents.
• Involved in estimation, analysis and solution documents.
• Responsible in creating the Analysis Design and Building dashboards by creating the information links from oracle to display data in reports.
• Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross Tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Created the visualizations with complex calculations/functions..
• Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Code migration across environments (Dev > QA > Prod).
• Root cause analysis and fixing the issues with the Spotfire environment.
• Analysis of the Server Issues, Library issues, etc
• Iron Python scripting to refresh data tables, changing filtering schemes, reset axis, reset marker size, jittering, refresh calculations, on demand data.

Environment: Spotfire 6.5 6.5.3, Oracle SQL Developer, Oracle 11g, Iron Python

Confidential, Minneapolis, MN

Sr. TIBCO Spotfire Developer

Responsibilities:

• Translate product requirements and business questions into report requirements and visualization dashboards.
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.
• 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.
• Created information links and managed process analysts work to realize the required solution from a data perspective.
• Pivoting and transforming data in spotfire professional before building visualizations.
• Implementing security for write back data from spotfire.
• Conveying problems, solutions, updates and project status to project manager in a timely and regular basis.
• Testing and debugging the dashboard for quality assurance.
• Serve as a primary point of contact for Production Support issue resolution.
• Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process.
• Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.

Environment: Spotfire 5. 5, SQL Server 2008, Oracle 11g,IronPython

Confidential, Pittsburgh, PA

Spotfire Developer

Responsibilities:

• Used TIBCO Spotfire to analyze and obtain insights into large data sets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Created visually compelling interactive reports and dashboards.
• Found the right balance between manipulating data using Spotfire versus using a programming language.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
• Created dozens of Data Connections, published on TIBCO Spotfire Server for usage with Operational/Monitoring Dashboards.
• Creating data sources, parameter information links, joins, filters in information designer for fetching data in to Spotfire as per the business needs.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.
• Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Merging data tables in Spotfire and creating Pareto charts, waterfall charts etc.
• Created Tags, Bookmarks and transformations for data tables.
• Performed daily admin tasks of user registration, security configuration and usage monitoring.
• Unit testing and participation in UAT and production cut over plans.

Environment: Spotfire 4.0Oracle10g, SQL Server 2008, TOAD, SQL, windows server.

Confidential - Stamford, CT

Spotfire consultant

Responsibilities:

• Assembled Business requirements and designed technical requirements documentation.
• Created Data sources for Report creation.
• Created various complexes Cross tables, Bar Charts, Line Charts and Tree map.
• Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
• Used Automation Job Service Builder to Export DXP file during Migration Process.
• Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports.
• 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.
• Experience in Writing SQL Queries.
• Created Action Controls using Python Scripting.
• Experience in creating Bookmarks.
• Experience in enhancing the visualizations using Custom expressions.
• Converted Various Excel, Tableau and BO Reports to Spotfire.
• Experience in Handling Multiple data tables in Analysis..
• Responsible for the migrating the reports from Development to Acceptance / Production Server.
• Conducting Unit testing of the reports developed in Spotfire Professional.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: Spotfire 4.0, Business objects, Oracle 11g, SAS, Toad.

Confidential - Secaucus, NJ

BA/Reporting Consultant

Responsibilities:

• Participated in project and team meetings interacting and collaborating with team members and other departments as necessary.
• Refine client requirements and guide them through the decision making process.
• Designed and Constructed reports.
• Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies and worked on linking of the Universes using Business objects Designer.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects reports.
• Designed and developed extensive BO reports using combination of chart and tables
• Performed unit testing on developed reports.
• Executed SQL queries, stored procedures and integration with software development.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Understanding of relational database structures, theories, principles, and practices.
• Contributed to successful completion of project deliverables.
• Proof-read all documents and maintain accuracy of information and preparing.

Environment: Oracle 8, Business Objects 5.1, BO Designer, Supervisor, Windows XP

Confidential

Business Analyst

Responsibilities:

• Worked with Project Sponsors and Stakeholders to complete Project Charter outlining scope, goals, deliverables and timing.
• Effectively communicated project expectations to team members and stakeholders in a timely and clear fashion.
• Worked closely with the Developers and QA team in order to maintain schedules for testing and any issues related to the application.
• Participated in documenting User Manual and UAT and followed up to resolve the issues.
• Thoroughly evaluated information gathered from multiple sources and derived conclusions.
• Reconciled conflicts, decomposed high-level information into details, abstracted information from low-level to a general understanding, and distinguished user requests from the underlying true needs.
• Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: (Functional requirements (Business Requirements Document), Use Cases, GUI, Screen and Interface designs).
• Identifying and comprehending business issues and data challenges of client's organization and industry and help devise solutions.
• Created use cases and cross functional diagrams to showcase various departments roles and needs using MS Visio.
• Planning, execution, monitoring the project progress during all the phases of SDLC.
• Ensured all artifacts are delivered to meet the Project timelines. Helping teams to resolve defects and meet high quality standards.