SUMMARY:

• 5+ years of IT Experience implementing Data Warehousing Concepts and Business Intelligence Solutions over spectrum of industries.
• 4+ years of experience in designing, development, deployment and Administration using Spotfire
• Sound knowledge on relational databases, dimensional data modeling, structured query language (SQL), data warehouse and reporting techniques. Strong hands - on experience using SQL with a relational DBMS such as Oracle, DB2, SQL Server.
• Ability to adapt and respond appropriately to evolving work demands.
• Experience in integrating data from multiple sources like SQL Server, Oracle, Teradata, Excel, Flat files, etc.
• Interested in learning new technologies and have good knowledge on Tableau, Alteryx.
• Good experience in support and maintenance of Project Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject-level) in developing star schema and snowflake schema.
• Good knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Worked on Spotfire Automation Service Job builder for scheduling and delivering reports through mail as per business needs.
• SQL skills: Can analyze, troubleshoot and tune complex SQL queries for performance.
• Knowledge in installing, configuring and validating all components required to support users.
• Experience in Spotfire report migration, administration Manager and package deployment.
• Experience in customizing and tuning the Spotfire reports for performance.
• Designed the data profiling, data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data using SSIS.
• Strong Analytical and Problem-Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS:

BI/Visualization Tools: TIBCO Spotfire 5.x/6.x/7.x, Tableau 10.x

ETL Tools: Alteryx, AWS Glue, Informatica

Databases: Oracle, Teradata, Redshift

Scripting Languages: Iron Python, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, MA

TIBCO Spotfire Developer/Admin

Responsibilities:

• Created dashboards that provide fleet performance metrics, users reservations & revenue which helps the business to plan for the new markets launch.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Spotfire information designer.
• Creation of metrics, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Worked on handling report issues with the users and solving them on the fly to make sure reports show accurate data.
• Worked extensively on Information Designer, Scheduled updates and advanced concepts like database write back from Spotfire reports.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
• Creating complex Information Links using multiple joins, prompts, parameters to load data from different data sources.
• Worked on querying data and creating on-demand/ad-hoc reports using Spotfire Analyst and publish the same to Server.
• Strong knowledge on Property controls, Script control and document properties for automation.
• Created data sources by using Spotfire Information Designer to connect various DataMart’s with Oracle, REDSHIFT.
• Using Action logs created a report to continuously monitor which reports are being used to help client to migrate important reports.
• As Spotfire administrator helped users in getting appropriate permissions for various Groups assigned to Projects where Dashboards and worksheets are saved.
• Created connections, join tables, create & manage Extract and Monitor Queries using Oracle SQL Developer/REDSHIFT Spectrum.
• Extensively worked with the QA Team and the Business users during UAT & Sign-off process. Tracked issues/bugs and resolved it in timely manner to meet SLA.
• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links

Environment: TIBCO Spotfire 7.6, Oracle 11g, AWS Athena, Red Shift, Git

Confidential, NY

TIBCO Spotfire Developer

Responsibilities:

• To lead all the functional requirement gathering and functional design process for new Spotfire reporting applications.
• Creating complex Information Links using multiple joins, prompts, parameters to load data from different data sources.
• Creating dynamic Spotfire dashboards with data on demand, property controls, different charts to analyze the KPI’s on the tabs.
• Creating complex Tableau charts and dashboards using parameters, actions and filters.
• Installation & configuration of Spotfire servers, web player servers and professional clients on the windows server machines for development, test and production environment.
• Successfully upgraded Spotfire environment to higher end versions.
• Installation of required database drivers and data connectors for all three environments.
• Applying latest patches/hotfixes on Spotfire server, web player and professional client.
• Upgrading Spotfire servers with latest hotfixes, setting up users, groups, licenses and ps.
• Testing the Spotfire setup and then creating installation and operational qualification documents.
• Managing Library administration, providing access to users and groups.
• Enabled user authentication using LDAP groups and synchronized them with Spotfire server.
• To support user and development activities of Spotfire by providing production and development support to troubleshoot and resolve issues.
• Exporting & Importing of Spotfire dashboards from one environment to another.
• Conducting performance tuning of anything connected to data systems and ensuring efficient operations and maximizing resources to provide the best results for end users.
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications.
• Developed reports using various Charts like Pivot Tables, Summary Tables, Cross-tables, Pie-Charts, Line-chart, Combinational-chart, Bar-chart, Scatter-plot, Heat-map, and Tree-map.
• Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Documented and maintained Best practices for system installations, configurations and migration from one environment to another.

Environment: TIBCO Spotfire 7.10/7.5/7.0 , TIBCO Web Player, TIBCO Automation Services, Oracle 11g, SQL Server 2008/2012, Alteryx, GitHub.

Confidential, FL

TIBCO Spotfire Developer /Admin

Responsibilities:

• Customized data by adding prompts, Filters, Calculations, by writing complex custom Oracle SQL, Summaries and Functions.
• Worked on the Migration plan to move the Spotfire dashboards to Acceptance/Production and guide the end users to get the necessary access through the corresponding Active Directories.
• Worked on developing program, user guide for Spotfire professional and Spotfire web player in terms of best developing and design practices.
• Reviewed business application needs and worked on planning visualizations for several functional domains.
• Used R-script, Iron Python scripting and JavaScript to execute some key features like replacing the existing data tables based on selected data, update
• Used Marking and Filtering selection via IronPython scripts to automate the functionalities of dashboards.
• Some dashboards included visualizations such how many customers where added by each branch each month and how this compared with other branches.
• Created custom Text Areas via HTML scripts and JavaScript.
• Analyzed functional areas and formulated data requirements needs related to building visualizations.
• Performed day to day administration of Spotfire including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.
• Participated in Pivoting and transforming data in Spotfire professional before building visualizations.
• Implemented data security on the global dashboards using role-based accesses.
• Served as a primary point of contact for Production Support issue resolution and communicated problems, solutions, updates and project status to project manager in a timely and regular basis.
• Tested and reconfigured the ADB and file adapters to populate the correct data.
• Testing and debugging the dashboard for quality assurance.

Environment: TIBCO Spotfire 6.x/5.5, Spotfire web player, Spotfire enterprise player, SQL Server, Oracle 10g, SQL, MS Excel.

Confidential

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Migrated data from SQL Server 2000 to SQL Server 2005.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Involved in the analysis, design, development, testing, deployment and user of analytical and transactional reporting system.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Used complex expressions to calculate, group, filter, parameterize and format the contents of the report.
• Documented and prepared project status report updates and audit reports.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.