SUMMARY

• About 7 years of IT Experience on Business Intelligence Applications with Three years on TIBCO Spotfire BI Reporting
• Developed visualizations with interactive features such as multiple Markings, Filtering schemes, configuring Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, Pie chart, Parallel coordinate plots, Table, Cross table, and Summary table visualizations
• Used Iron Python Scripting for two way communication, for creating data forms, for creating workflow frameworks and for designing end to end solution.
• Worked in Agile Environment, conduct daily stand - up meetings, conduct personal interviews for gathering requirements from clients, used HP ALM tool for testing.
• Knowledge of Writing R functions to perform look ups between tables and to clean and compile data stored in Microsoft Excel spreadsheets.
• Experience in Installation, Configuration, Group setup, User Administration, Performance monitoring, Trouble shooting issues
• Experience of creating Groups and then set up Users, Groups and Licenses as Spotfire Administrator and restrict the group members to access only particular folders in the library as Library Administrator
• Worked on development of Dashboards for Key Performance Indicators for top management
• Proficient in Data warehousing, Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, DB2 UDB, SQL Server 2014
• Strong understanding of project life cycle and SDLC methodologies including RUP, Waterfall Agile and Scrum
• Excellent knowledge of Business Analysis methodologies and Project Management processes
• Proficient in development, support and maintenance for the ETL (Extract, Transform and Load) processes
• Having good knowledge of data mining, data cleaning and explored data visualization techniques on a variety of data stored in Microsoft Excel spreadsheets and text files using R

TECHNICAL SKILLS

BI / Visualization Tools: Spotfire Desktop, Spotfire Server, Tableau Desktop, Tableau Server

Databases: MS SQL Server 2014, MySQL, Oracle, MS Access, SAP BW

ETL/Data Integration: Pentaho Suite and SSIS

Languages: SQL, C, R

Scripting Language: Iron Python

Management Tools: MSOffice (Excel, Word, Access, PowerPoint), MS Visio, SSRS, MS ProjectCrystal Reports

Operating Systems: Windows 98/NT/2000/XP, UNIX, MS DOS

Process/Methodologies: Agile, Waterfall

Others Technologies: Knowledge of Big Data and Hadoop

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Tibco Spotfire Developer and Admin

Responsibilities:

• Installed Spotfire Server, Database drivers, Hotfixes
• Used Microsoft sql server to hold Spotfire server database
• Configured Spotfire server - Set up single sign on
• Monitored Spotfire server to detect issues with server, LDAP Servers, network problems, external databases to reduce server downtime and eliminate performance bottlenecks
• Set up database for Action logs, Analysed the Action logs DXP file to find what the users are doing, when they login, who did what etc
• Upgraded Spotfire from 6.5 to 7
• Set up Projects, Groups, Users and set up Permissions
• Used Library Import Export to deploy content from Dev to Prod server
• Set Up Automation Services, created jobs to automate dxp files refresh and email distribution
• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Information links, parameterization, defined join rules in Information designer.
• Created Action Controls and wrote scripts using Iron Python. Performed several customizations using the scripts
• Used Lists, tags and Bookmarks
• Used Filter Schemes to isolate the filter behaviours on visualizations
• Implemented Load on demand to load the data on demand
• Used Over statements for calculations
• Used Dynamic calculations based on the markings user selects in the visualizations
• Worked on Tibco SpotFire Server, Web Player and Library administration.
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.

Environment: Tibco Spotfire Professional 6.5/7.0, Spotfire Web Player, Spotfire server, Windows 2008 server, SQL Server 2008, SSIS

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
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Information links, parameterization, defined join rules in Information designer.
• Installed Spotfire Server, Database drivers, Hot fixes
• Used Microsoft sql server to hold Spotfire server database
• Used Load on Demand to improve performance of Spotfire dashboards
• Configured Spotfire server - Set up single sign on
• Wrote Spotfire server Backup scripts to take backups regularly
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc
• 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, Teradata Windows 2008 server, SQL Server 2012

Confidential

Tableau Developer

Responsibilities:

• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements
• Resolved the bugs reported by QA team in existing dashboards
• Involved in creating database objects like tables, views, procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Creation of packaged workbooks (.twbx) for end-users
• Administered user, user groups, and scheduled instances for reports
• Created Proof of Concept visualizations using Tableau and demonstrated capabilities to the management
• Involved in installation of Tableau desktop 7.0, Tableau server Application software
• Defined best practices for Tableau report development
• Good SQL reporting skills with the ability to create SQL views and write SQL queries
• Responsible for creating reporting data model as per the requirements
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Projected and forecasted future growth in terms of number of sales based on the products by developing Area Maps to show details of which products are being sold the most
• Actively participated in clarification meeting with the Clients
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables

Environment: Tableau 8, Oracle 9, Windows 2008 server

Confidential

Business Analyst

Responsibilities:

• Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• Used various types of inputs and outputs in Pentaho Kettle including Database Tables, MS Access, Text Files, Excel files and CSV files.
• Implemented miscellaneous transformations in Kettle Spoon Designer including Database Lookup, Database Join, Calculator, Generate Rows, Mapping Transformation, Filter Rows, Dimension Lookup/Update, Add Sequence, Add Constants, Row Normaliser and Row Denormaliser.
• Used SQL Loader to import bulk data in Oracle tables from data files of different formats including fixed record, variable record and stream record format. Created and scheduled Various Daily running and Month end SQL Jobs, using SQL Server Agent to perform various ETL operations.
• Created new tables, wrote PL/SQL stored procedures and user defined functions for Application Developers.
• Created SQL scripts for tuning and scheduling Created various ad-hoc reports using Pentaho Analyzer to allow users to generate reports on the fly by dragging and dropping dimensions onto rows and/or columns and dropping one or more measures to get the results.
• Created Triggers in PL/SQL to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimized long running SQL queries and PL/SQL stored procedures.
• Performed development support, documented reviews and test plans.
• Created and maintained Indexes for various fast and efficient reporting processes.
• Monitored the error log for any errors.
• Created users and roles in Oracle as well as Windows 2003 Server and maintained proper security procedures by assigning appropriate permission levels to the users.
• Worked with the Planning team to forecast the business requirement

Environment: MS Office Suite, MS Visio, Java, MS Visual Basic, Test Director, Client Server, Windows XP, MS Access, MS SQL, Agile, SOA