SUMMARY

• Around 9 years of dashboard software development experience with relevant 7+ years in developing analytic dashboards using TIBCO Spotfire.
• Rich experience with TIBCO Spotfire in analyzing data using statistics, developing dynamic analytic applications, implementing, integrating, customising, deploying and maintaining BI solution.
• I have worked extensively on visualization properties and complex interactive features such as multiple markings,filtering schemes,configuring bar chart, line chart, graphical table, combination chart, scatter plot, pie chart, table, cross table, and summary table visualizations
• Extensive TIBCO Spotfire Experience in installing, configuring and validating all components required to support users of TIBCO Spotfire Professional and TIBCO Spotfire Web Player.
• Successfully upgraded TIBCO Spotfire platforms in clustered environment and performed content upgrades.
• Ability to combine data from disparate sources and expose them to TIBCO Spotfire client users through information links.
• Hands on experience in creating and integrating statistical scripts and functions into applications, including TIBCO Spotfire
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Worked on TIBCO Spotfire Web Player APIs to automating, controling, and integrating with the TIBCO Spotfire Web Player.
• Strong Experience in developing with the TIBCO Spotfire Platform using Visual Studio,C# and Spotfire SDK to extend the TIBCO Spotfire Clients by adding custom functionality.
• Interacting with customer in gathering requirement and converting it to technical data.
• Ability to design back end database for internationalized application.
• Trained end users in using analysis and reporting.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Experience in Data Modeling (relational, hierarchical, dimensional), Database design, OLAP Cubes design, ETL process design, Enterprise Data Warehouse and Master Data Management .
• Kimball Method, Data Warehouse Lifecycle, Dimensional Modeling, Star Schema, PL/SQL, T - SQL, Oracle Database, Microsoft SQL Server, IBM DB2, ERWin, TOAD, Informatica, SAS, R language
• In-depth knowledge of industry best practices in both business management and technology domains.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• Experience in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions, triggers in SQL Server based on logical design model and user requirements.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in performance tuning, logging, error-handling of SSIS packages and deploying from development server to production server.
• Experience in report generation using SQL server reporting services(SSRS) from relational databases as well as OLAP cubes.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• A team player with good interpersonal skills and work independently.
• Expertise in problem-solving and trouble-shooting capabilities, creation and implementation of KPIs, deliveries as per SLAs. Possessing in-depth understanding of the business needs on multiple domains, logical problem solving approaches, good communication and motivation skills.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

PROFESSIONAL EXPERIENCE

TIBCO Spotfire Developer

Confidential - Foster City, California

Responsibilities:

• Hands on development assisting users in creating,modifying Spotfire visualization dashboard and getting data into Spotfire from different data source.
• Apply the best design practices for analyses and dashboards
• Expert in manipulate existing data columns, merge data, add data tables, connect to in-database data,using bookmarks, tags, and lists to capture aspects of your dynamic analysis and consider the available aggregation options and expression shortcuts
• Strong Experience in building expressions to in corporate functions to expand visualization options,applying lines & curves, data relationships, predictive modeling and configure data functions to use the functionality of TERR, open-source R, S+, SAS.
• Installed a configured and administered the server environment, including Users, Groups, Licenses, Preferences, and Properties.
• Configured the Spotfire Application Server and the WebPlayer Server for optimal use
• Suggested best practices for the Server infrastructure, Information Model, Library setup, and group administration
• Performed daily admin tasks of user registration, security configuration and usage monitoring
• Optimized Information links and queries to increase performance Design and implementation of a global, enterprise class Spotfire environment
• Installed and Configured the Spotfire Statistics Services on a standalone Installation
• Experience in working with embedding and integrating the TIBCO Spotfire Web Player into web sites and controling the Web Player from remote applications using the APIs.
• Using Visual Studio to create Spotfire Extensions.
• Developing C# language that are used while creating extensions and configure a development environment for the TIBCO Spotfire SDK .
• Creating and attaching custom nodes to the Document Model to maintain state
• End to end experience in designing and deploying data visualizations using TIBCO Spotfire
• Provided 24/7 customer support to TIBCO Spotfire users.
• Experienced in tuning Long running SQL queries for better performance.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Installed TIBCO Spotfire Server in Dev, QA, UAT and Prod environments.
• Deployed TIBCO Spotfire in clustered environment by mapping server nodes to primary machine.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Participated on business requirement document preparation.
• Rebuild dashboard applications on both frontend and backend, developing scripting templates, design and coding standards, design guidelines, migration strategy and implementation plan.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Designed and created the dashboard reports for Executive board of company.
• Developed scripts for data reloading, mapping and transformation
• Conducted visualization improvement on Usability and User Experience
• Designed the integration of Enterprise Management Reporting Portal to provide single point of entry, developing Drill-to-Detail (D2D) for deep linking and cross-system Interoperability
• Maintained and updated the dashboard reports as required by client.
• Analyzed the external and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Installed, configured and deployed TIBCO Spotfire application on top of Oracle DB.
• Conducted and guided TIBCO Spotfire BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning.
• Created and maintained OLE DB/ODBC connections for all environments.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Implemented security using TIBCO Spotfire section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation for TIBCO Spotfire applications.

TIBCO Spotfire Developer

Confidential - Pittsburgh, PA

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Administered user, user groups, and scheduled instances for reports in TIBCO Spotfire. Installed patches on server and documented upgrade plan form
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Use TIBCO Spotfire to analyze and obtain insights into large data sets.
• Create visually compelling interactive reports and dashboards.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Find the right balance between manipulating data using Spotfire versus using a programming language.
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.
• Created dozens of Data Connections, published on TIBCO Spotfire Server for usage with Operational/Monitoring Dashboards
• Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community
• Installed, configured, and deployed TIBCO Spotfire Server across all environments.
• Building, publishing interactive reports and dashboards using TIBCO Spotfire server.
• Administered user, user groups, and scheduled instances for reports in TIBCO Spotfire.
• Collected data on various process measurements and formatted into graphs using TIBCO Spotfire software.
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Building, publishing interactive reports and dashboards, report scheduling using TIBCO Spotfire server.
• Created and assisted users in TIBCO Spotfire dashboard development
• Administered and provided production support for CHOP Enterprise wide TIBCO Spotfire application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install TIBCO Spotfire in silent mode.
• Defined best practices for TIBCO Spotfire report development.
• Extensively used TIBCO Spotfire commands in creating backups and restoring backups of TIBCO Spotfire repository.
• Set up TIBCO Spotfire, Data Analysis and publishing reports.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Generated daily, weekly and monthly reports using TIBCO Spotfire.
• Developed Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports using TIBCO Spotfire and enabled ad-hoc reporting with report builder.
• Executed and tested required queries and reports before publishing.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in the system development process.
• Worked with cross functional team and business user to develop Business requirement document(BRD), define key performance indicators(KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via TIBCO Spotfire in-memory technology
• Designed and developed TIBCO Spotfire software applications and server-based TIBCO Spotfire dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided on going TIBCO Spotfire consultation to the development team.

QlikView Developer

Confidential - Peoria, Illinois

Responsibilities:

• Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.
• Provided technical leadership in QlikView BI/DW design, dashboard and KPI metrics design, data modeling, QlikView SAP integration, QlikView scripts development, QlikView Set Analysis, and QlikView Server/Publisher setup/configuration.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in the system development process.
• Worked with cross functional team and business user to develop Business requirement document(BRD), define key performance indicators(KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via QlikView in-memory technology
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to the development team.