PROFESSIONAL SUMMARY:

• Over 10+ years of experience in BI (Business Intelligence),Data warehouse & Tibco Spotfire, QlikView, Qlik Sense & Cognos.
• Capturing & analyzing the business requirements in BRD & developing very complex visualization dashboards as per the organization standards.
• Extensive experience in developing Web based application using Tibco Spotfire, QlikView & Qlik Sense
• Working closely with the Stakeholders, Business teams (Department specific managers). To understand their requirement, gathering the source data & specific metrics methodologies.
• Capable of taking the responsibility & accountability of developing, deploying & maintaining the Database & BI projects
• Strong negotiable skills in understanding Data Management. Where I can help the Business team how to interpret or reconcile the data from the sources itself.
• Hands on experience in developing clinical reports in various areas like Drug Test SLA’s, Overall productivity across clinical trial case types, Quality assurance, Customer loyalty score from periodical customer satisfaction surveys.
• In - depth knowledge of large database design techniques; experience indata analysis, data cleansing, and data transformationandmigration using ETL tools.
• Lead and served as subject matter expert on projects requiring extensive requirements gathering, data analysis, data modeling, ETL, dashboard design/development and testing
• Ability to work independently and manage multiple tasks concurrently
• Extensive knowledge in writing Queries, Stored Procedures, Functions, Cursors and Triggers.
• Expertise at MS SQL-Server2005, 2008 & 2010, MS Access backend programming, configuring, client-server connectivity, Queries, Stored Procedures, Triggers.
• Experience in presenting project details and progress to the clients at various stages.
• Expert in creating data templates in the Composite Studio 6.0 from various data sources.
• Created Data Models & Published from Data Sources like XML & SOAP over HTTP web services using Composite Studio
• Data Models published Composite Studio later on pulled into the TIBCO Spotfire using Application Data Services Adapter in Information Designer for further analysis
• Created User Access & Authentication for all the published data in a Composite Information Server
• Data optimization has been done by using the Composite Monitor Web Interface& check logs regularly by individual users
• TIBCO Spotfire Development &Administration in Enterprise level.
• SQL SERVER 2005, 2008, 2010 Database Design.
• Data warehouse/ETL Design and Implementation
• Technical Architecture Definition/ online, batch, development
• Software Configuration Management Change Control code/data base, Application Environment
• Strong in T-SQL coding, creating procedures, view, functions, triggers.
• Expertise in working with Large Data Sets, In-Database Data, In-Memory Data
• On Demand Data through Information Links
• Worked with multiple data sources like (PostgreSQL, Hyperion ESSBase Cubes, MS SQL Analysis cubes, Hadoop, SQL Server, Oracle, ADS Composite Information Server & Flat Files)
• Visualizations: Map Chart, Combination Charts, Bar & Line charts, Graphical Tables, Pie charts, Tree Maps, Heat Maps, Scatter Plots
• Text Area: Editing HTML, Java Script, Action Controls Properties, Iron Python Scripts
• Did enhancements on Visualization Properties
• Filters:Filtering Schemes, Range, Item, Radio, Check, List box
• Lists, Bookmarks & Tags

TECHNICAL SKILLS:

EAI Technologies: TIBCO Spotfire (All versions), Cisco Composite Server, Automation Services, ADS

RDBM: SSQL SERVER & 2010Dev & Admin,ETL (SSIS)Dev, SQL on Oracle 10g

Scripting Languages: Bat scripting, CSS 3.0

Markup Languages: HTML 5.0, XML, PHP

Operating Systems: Windows XP/NT/2K,7 & UNIX

Documenting Tools: VISIO, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential - NY

Technical Skill Set: Tibco Spotfire V 7.6, HTML, CSS, R Scripting, Iron Python, PL SQL, T-SQL, SQL Server12. Janssen - 920 Raritan(NJ) USA Dec 7th - July 2016

Responsibilities:

• Interact with business on daily basis &develop Life Sciences Dashboards like Milestones Met on Time, MCweb, Severity, Output Metrics using various Data Visualization tools like Tibco Spotfire, QlikView& QlikSense
• Created Clinical Trail Dashboards by my interacting with the stake holder
• Creating InfographicDashboards using Adobe Photoshop & embed them with in a Spotfire &QlikView for Dynamic Data representation like Score Cards & KPI's
• Tibco Spotfire API Integration - This is specifically designed for Senior Management. Using this API implementation business is no more looks into traditional Spotfire web player rather they look into a web portal & choose what report they want to see from the site itself .

Technical Skill Set: Tibco Spotfire (6.5 to 7.0), QlikView, QlikSense, Photoshop, HTML, CSS &JavaScript.

Confidential - Malvern (PA)

Technology Architect

Responsibilities:

• Currently working on Asset Management Project. Work closely with Stakeholders to capture the business requirements & share it with the team to develop various reports. As part of the requirements I work with various Data Management tools like
• Cisco Composite Information Server (Data Visualization tool) - A Data Federation Tool connects to multiple data sources & create a Data view for BI reporting tools like TIBCO Spotfire, Cognos, Tableau (BI Tools), Hadoop (Scoop & Impala).
• Cognos - Create dynamic, Tuned, Durable, Maintainable & Consumable reports based upon the requirements.
• Hadoop (Big Data): Under Learning Curve

Confidential - Nashville (TN)

Technology Architect

Responsibilities:

• Admin Activities: Installing & configuring the TIBCO SPOTFIRE in multiple environments.
• Analyze Data & detect the fraud happening in System.
• Creating & Monitoring the Dashboards using SPOTFIRE where business can easily take the decisions by doing further analysis on the Dashboard application.
• Understand the business requirements & helping them by creating various reporting visualizations in a SPOTFIRE.
• Business teams on SPOTFIRE web player like how to use different visualizations like Bar Charts, Line Charts, Combination Charts, Scatter Plot, Map Charts & …
• Creating & adding the user to the SPOTFIRE Server &managing them using Library Administration.
• Created VISIO diagrams for Data Security & User Authentication inside the Confidential system.
• Created User Auditing dashboard application to see how many users are using data sources through SPOTIFRE.
• Created Data models in a CISCO Composite server.
• Created Information links to access Data Models created in a CIS
• ADS Composite Information Server
• MS SQL
• MSSQL Analysis Services
• Oracle ESSBASE
• PostgreSQL
• Oracle
• Hadoop

Environment: TIBCO SPOTFIRE 6.0 & 6.5, SQL Server 2008, Windows 7, MAC, Windows Server 2008, ETL (SQL Server Integration Services)

Confidential

BI Architect; Business Analyst

Responsibilities:

• Employee 12 months Rolling Retention & Performance.
• Customer Loyalty & Dissatisfied.
• SLAs(Service Level Agreements)
• Quality Assurance (eSOP Compliance & CAPA compliance) and many more visualizations has been incorporated in this project
• Created standard data templates from various data sources like Oracle data warehouse, Flat files using Composite Studio.
• Configured Composite information server link in a Spotfire by installing Advance data services.
• Creating Clinical Trail Dashboards depends on the drug.
• Understanding the business requirement&grantingpermissions to the necessary stakeholders.
• Content migration on different Spotfire versions.
• Upgraded from 4.x to 5.x
• Backup & Restore

Environment: Tibco Spotfire 4.x & 5.x, Share Point, TRIO Application, Oracle PL SQL, Windows 7

Confidential

Responsibilities:

• Identify, Analyze and Resolve Job Failure
• Perform the maintenance activities of Spotfire reports on daily basis.
• Grant permissions to the business users using Spotfire Library Administration.
• Contact necessary source system on-call support to resolve upstream system issues
• Work with Production Control to resolve job failure
• Ensure US Flash available and email sent by 6:00AM
• Monitor BIM Messages to proactively identify job execution delays.
• Maintain US Sales Data Warehouse Job Failure Log eRoom Database.
• Maintain US Sales Data Warehouse US Flash Delay Log eRoom Database.
• Data Quality Support Activities - Daily
• Monitor Data QA Emails daily
• Analyze Data Issue
• For Known Issues apply documented procedures to resolve Data Issues.
• Update or create issue resolution procedures when necessary
• Record Software Bugs that cause Data Issues in RITS (System Service Requests -SSRs).
• Data Quality Support Activities - Monthly
• Address Data Issues Reported by Finance Department
• Provide Support to Finance Group in Closing Financial Books for Month End.
• Perform Necessary Changes through CCRs.

Environment: Spotfire 4.x,T-SQL, MICROSOFT SQL SERVER 2008, 2010 &ETL (SSIS, DTS, SP, BCP UTILITY, FTP, Control-M)

Confidential

Senior Analyst

Responsibilities:

• Check for the assign tickets in the Magic Service desk.
• Update the employee status in the Siebel databases
• Granting the permissions to the employee through Siebel CRM
• Terminate employee records from Seibel CRM when an employee contract was finished.

Environment: - Siebel CRM, Control-M, Magic Service Desk

Confidential

Senior Analyst

Responsibilities:

• Identify, Analyze and Resolve Job Failure
• Do the validation on the existing Spotfire visualizations.
• Perform the maintenance activities of Spotfire reports on daily basis.
• Grant permissions to the business users using Spotfire Library Administration.
• Contact necessary source system on-call support to resolve upstream system issues
• Work with Production Control to resolve job failure
• Ensure US Flash available and email sent by 6:00AM
• Monitor BIM Messages to proactively identify job execution delays.
• Maintain US Sales Data Warehouse Job Failure Log eRoom Database.
• Maintain US Sales Data Warehouse US Flash Delay Log eRoom Database.
• Data Quality Support Activities - Daily
• Monitor Data QA Emails daily
• For Known Issues apply documented procedures to resolve Data Issues.
• Update or create issue resolution procedures when necessary
• Record Software Bugs that cause Data Issues in RITS (System Service Requests -SSRs).
• Data Quality Support Activities - Monthly
• Address Data Issues Reported by Finance Department
• Provide Support to Finance Group in Closing Financial Books for Month End.
• Perform Necessary Changes through CCRs.

Environment: - Spotfire 4.x, Control-M, Microsoft SQL server 2008, SQL SCRIPTS, SSIS.

Confidential

Senior Analyst

Responsibilities:

• Identify, Analyze and Resolve Job Failure
• Do the validation on the existing Spotfire visualizations.
• Perform the maintenance activities of Spotfire reports on daily basis.
• Grant permissions to the business users using Spotfire Library Administration.
• Contact necessary source system on-call support to resolve upstream system issues
• Work with Production Control to resolve job failure
• Ensure US Flash available and email sent by 6:00AM
• Monitor BIM Messages to proactively identify job execution delays.
• Maintain US Sales Data Warehouse Job Failure Log eRoom Database.
• Maintain US Sales Data Warehouse US Flash Delay Log eRoom Database.
• Data Quality Support Activities - Daily
• Monitor Data QA Emails daily
• Analyze Data Issue
• For Known Issues apply documented procedures to resolve Data Issues.
• Update or create issue resolution procedures when necessary
• Record Software Bugs that cause Data Issues in RITS (System Service Requests -SSRs).
• Data Quality Support Activities - Monthly
• Address Data Issues Reported by Finance Department
• Provide Support to Finance Group in Closing Financial Books for Month End.
• Perform Necessary Changes through CCRs.

Environment: - RDBMS - Oracle 10g, Spotfire 4.xBusiness Objects Data Integrato,DTS (SQL Server),PL/SQL developer, JavaExcel Macros/VBA Power Play DesktopControl-M and AutoSys

Confidential

IT Analyst

Responsibilities:

• Responsible for developing SSIS automation including all error handlings.
• Involved in creating the entire Database structure
• Responsible for developing business Objects for Database Tables.
• Database and application’s test server’s maintenance.
• Responsible for taking database back up’s and restoring
• Involve in generating the reports in the TIBCO SPOTFIRE
• Involved in Unit testing
• Utilized features such as multiple tables, visualizations, drill down and other analyticsreporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Created and managed stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, backup s, restoring and recovering databases, user and security management, database optimization, determining common performance problems, monitoring, configuring servers.

Environment: SPOTFIRE2.X, SQL SERVER 2005, MSBI

Confidential

IT Analyst

Responsibilities:

• Responsible for developing SSIS automation including all error handling.
• Involved in creating the entire Database structure
• Responsible for developing business Objects for Database Tables.
• Spreading the table and index data on different tablespaces for better performance.
• Database and application’s test server’s maintenance.
• Created a Database mirroring setup with high “High Performance”
• Responsible for performance tuning of the SQL SERVER 2005 and 2008
• Involved in Unit testing
• Developed TIBCO Spotfire Reports to Provide Business Insights for Strategies and Tactics to Reduce Expenses
• Remotely administrating the production database through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks and taking backups for disaster recovery.

Environment: Tibco Spotfire 2.x, SQL SERVER 2005 & 2008, MSBI

Confidential

IT Analyst

Responsibilities:

• Supporting Build Acceptance Testing, Automation, Product Integration Testing and Performance Testing.
• Integration of TIBCO Spotfire professional to the data sources
• Responsible for data modeling, creation of database device logical and physical design of the database
• Responsible in creating the normalization techniques, performance tuning of all the databases.
• Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Report generation based on various outlier metrics
• Functional Testing of individual outlier components
• Deployment of reports in the server

Environment: Tibco Spotfire, SQL Server 2005 & 2008, MSBI

Confidential

Database Developer

Responsibilities:

• Designed and created an interface between custom application and accounting application,
• Upgraded client server web Forms and Reports application to web based and ran the application through SSMS Portal and Single Sign-on.
• Responsible for creating a replication process, mirroring techniques
• Responsible for performance tuning.
• Assisted in setting up the Forms and Reports Services on standalone SLQ 2005 server.
• Performance Monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance

Environment: SQL SERVER 2005 &MSBI

Confidential

Database Developer

Responsibilities:

• Created Logical diagram for dynamic Database structure (3 Dimensional DB Structure)
• Created Stored Procedures, Triggers, and Functions
• Created Tables and Relationship between tables using constraints and Relationship between the entities
• Responsible for installation of SQL Server and ODBC Connectivity issues
• Data import from source file SQL Server Express using DTS/SSIS Wizard and queries and Source file can be many form like Excel, Notepad and MS access Database
• Supporting the SQL SERVER production and development databases. There are about 12 production, 40 development servers and 50 databases

Environment: SQL SERVER 2005 &MSBI