SUMMARY

• 5+ years of Experience in IT industry in implementing Data Warehousing Concepts and Business Intelligence Solutions over spectrum of industries.
• Extensive experience of 3 years in designing, development, implementation and Administration of TIBCO Spotfire suite of products like Spotfire Analyst, Spotfire Web Player, Spotfire Server, Spotfire Node Manager, Advanced Data Services, Spotfire Statistical Services in large and complex environments.
• Extensively developed Business Requirements Documents, Functional Design Documents and high level Technical Design Documents.
• Actively participated and conducted sessions with business users, technical leads and with development personnel in all aspects of the SDLC to discuss on the requirements.
• Efficient in identifying and analyzing business requirements from documents and end - user discussions and deliver the data requirements necessary to support DW subject areas.
• Experienced in designing and developing rich Interactive reports and dashboards in Spotfire integrating data from multiple sources like SQL Server, Oracle, Teradata, Excel, Flat files, Web Services etc.
• Expert in creating complex statistical and financial reports, trend over time reports, ranking, and forecast reports, executive dashboards using TIBCO Spotfire.
• Expert in developing reports with rich visualizations like Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, Pie chart, Parallel coordinate plots, Pareto chart, Table, Cross table, Summary table, Tree map, Heat map and interactive features such as multiple Markings, Filtering schemes, etc.
• Integrated geographical mapping capabilities in Spotfire using map charts and map layers like WMS and TMS.
• Wrote IronPython scripts to customize dashboards by implementation of Tagging Analysis, Document Properties manipulation, Visualization properties manipulation, Table manipulation and file-data manipulation.
• Interested in learning new business intelligence technologies and have good knowledge on Tableau, Power BI, 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.
• Working with Tableau Extracts, Table Calculations, Statistical Functions, LOD Expressions.
• Used HTML, CSS, and JavaScript features for UX/UI design.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• 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 7.10/7.x/6.x/5.x, TIBCO Spotfire Node Manager, TIBCO Spotfire Server, Spotfire Advanced Data Services, Tableau 10.5, Power BI, Qlikview

ETL Tools: Alteryx, SQL Server Integration Services (SSIS), Informatica

Databases: Teradata V2R5/ V2R6/ V2R12, Oracle 9i/10g/11g, IBM DB2, MS SQL Server 2008/2012, MS Access.

Database Tools/SQL Tools: Oracle SQL Developer, SQL Server, Teradata SQL Assistant.

Repository Tools: Microsoft SharePoint, Bugzilla.

Defect/Test Management Tool: Quality Center, Test Director.

Languages: SQL, Iron Python, JavaScript

Operating Systems: UNIX, Mainframes, Microsoft Windows (2000/XP/NT/Vista).

Microsoft Tools: Microsoft Office Visio, Microsoft Office Project Office Suite (Word, Excel, Outlook, Publisher, PowerPoint, Desktop Deployment.

PROFESSIONAL EXPERIENCE

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, webplayer 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, webplayer and professional client.
• Upgrading Spotfire servers with latest hotfixes, setting up users, groups, licenses and preferences.
• 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.
• Used HTML and CSS along with JavaScript features to design Text Areas.
• Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Provided 24X7 support for TIBCO Spotfire infrastructure and Visualizations support.
• 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, Toad, GitHub.

Confidential, FL

TIBCO Spotfire/Admin 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 dashboards.
• 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 training 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, TIBCO Active Database Adapter, TIBCO File Adapter, Spotfire enterprise player, SQL Server, Oracle 10g, SQL, DB Visualizer, 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 training 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