SUMMARY

• Comprehensive 7years of proven success in IT industry, with 4years of relevant experience as a Tibco Spotfire Developer/Admin.
• Experience in creating complex Spotfiredashboards and visualizations by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas TIBCO Spotfirereports using Tibco Spotfire Professional.
• Experience in Designing and developing the information links, Data Source, Columns, Joins, Filters and Procedures in TIBCO Spotfire.
• Configuring and Managing Scheduled updates for the analysis, managing user roles, supporting deployment process InSpotfire.
• Proficient in designing multiple enterprise levelSpotfire Analytical solutions.
• Developed Cross table, Bar chart, Pie Chart, Tree map and complex reports that involves Property Controls, Custom Expressions, information links with different data sources, SAS, ORACLE, SQL SERVER, Excel and Flat Files.
• Giving access to new users and maintaining Spotfire’s servers.
• Worked with users on how to useSpotfire as an analysis tool including as well as collaborating on report generation.
• Applying hot fixes for Siebel adapters in all environments and tested various scenarios and checked if the hot fixes help in fixing issues related to Siebel
• Good 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.
• Experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
• Have done installations and configurations and maintenance of Tibco server in Unix environment.
• Expert in designingSpotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Worked on designing dashboard / reports /applying Geomap to the data InSpotfire to give them consistent and professional looks using TIBCO Spotfire Professional.
• 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 TIBCOSpotfire Experience in installing, configuring and validating all components required to support users of TIBCOSpotfire Professional and TIBCOSpotfire Web Player.
• Hands on experience in creating and integrating statistical scripts and functions into applications, including TIBCOSpotfire.
• 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.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Excellent analytical, inter - personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Project Methodologies: Agile (SCRUM), Waterfall method

Business Modeling Tools: MS Visio, UML

Operating Systems: Microsoft Windows NT, XP, UNIX, Windows server.

Databases: Oracle 9i,10g, SQL Server 2000, DB2, SQL*Plus, TOAD, Teradata

Languages: HTML, JavaScript, R, Iron Python

BI/Visualizations Tools: TIBCO Spotfire Professional,6.x,7.x TIBCO Spotfire Web Player, Tibco Spotfire enterprise Player

Tools: TIBCOSpotfire 6.5/6.6,7.8/7.6 Business Objects XI R1/R2,6.5, Web Intelligence XI R2, Crystal Reports XI/10, SSRS 08 R2, Desktop Intelligence, Info View, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0.

PROFESSIONAL EXPERIENCE

Confidential, MALVERN, PENNSYLVANIA

SR. SPOTFIRE DEVELOPER

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Gathering requirements from users and designing reports as per the business requirements
• Responsible to document changes to the User requirements, Universe Design and Report functionality
• Worked on legacy data conversion from JDA to SAP and design functional specs documents
• Developed and documented severalTIBCOSpotfire business reports & dashboards on cross functional databases such as Oracle, Netezza & Excel spreadsheets
• Developed effective data mapping and SQL scripts usingSpotfire for efficient data extraction
• ManagedTIBCOSpotfire Web player to conduct user acceptance testing for several business reports
• Formulated dashboard specifications and generated status reports.
• Documented and maintained practices for system installations and configurations
• Responsible forTIBCOSpotfire platform administration tasks,TIBCOSpotfire database administration tasks, and providing production and operational systems support to Clients and Stakeholders
• Responsible in Migrating the code/ dxp file across all environments (Dev - QA - PROD)
• Involved in enhancing and deploying the Custom plugin's toSpotfire client (Export to word and task broker)
• Created information links using Information designer using parameterized procedures, published from ADS which uses two different data sources Oracle and Historian web services
• Implemented and managed automated monitoring solutions forSpotfire Platforms to ensure SLAs are maintained
• Responsible forTIBCO Spotfire Administration activities, Installing, configuring, user/group, library, server management etc.
• Provided mentoring and consulting to other BI team members inTIBCOSpotfire
• Advised onTIBCOSpotfire best practices, tools and specific technical solutions to support complex business requirements
• Responsible forSpotfire Administration activities, Installing, configuring, user/group, library, server management etc.
• Created and maintain User Acceptance Test (UAT) Plan and Test cases.
• Developed & merged PII information for email/direct-mail coupons in UNICA
• Updated coupon contact history based on host suppression/control records in UNICA
• Strong visual modeling and business process modeling skills In Rational Unified Process (RUP) and Agile Modeling with tools like MS Visio
• Developed a FTP solution using Talend to send coupon/campaign data to various third party vendors
• Followed Agile SCRUM methodology throughout the deliverables and switched roles between solutions architect,developers and product owner

ENVIRONMENT: TIBCOSpotfire 7.8/7.6, MS SQL SERVER 2008/2008, SSIS, SSRS, Oracle 10g/11g, Info View, SQL, Dashboard Manager, HTML, JSP, HTML, JavaScript, Windows XP.

Confidential, JACKSONVILLE, FLORIDA

SPOTFIRE DEVELOPER/ADMIN

Responsibilities:

• Analyzed existing complex systems to understand and document data elements, relationships, data flows, dependencies and related Interfaces
• Created a personalized information link based on user restriction
• Extracted the data from various source like flat file, html document, excel sheets and databases, combined the data to present in meaningful information
• Cleansing the data throughTIBCOSpotfire to detect the inconsistencies and removed the corrupt data, transform the data into right reporting format
• Designed and deployed solutions which utilizeTIBCOSpotfire hybrid in-memory/in-database analytics architecture to support the most demanding enterprise Needs, scaling to thousands of users and limitless rows of data
• Modified the SQL of an Information link
• Giving access to new users and maintaining Spotfire’s servers
• Administered users and Library Management, access levels, rights and folder structure
• Designing and developing the information links, Data Source, Columns, Joins, Filters and Procedures
• Created dashboards and visualization by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas
• Structured theSpotfire library to publish and share all the analysis material, information links, data sources to end user according to their role and knowledge
• Used Application Data Services (ADS Composite Information Server Connection) to setup data connections to analyze data
• Creating data sources, parameter information links, joins, filters in information designer for fetching data in toTIBCOSpotfire as per the business needs
• Integrating the Java application withTIBCO Spotfire reports to facilitate write back to database by building dynamic URLs fromTIBCOSpotfire
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.
• Co-ordinateTIBCOSpotfireDXP files till UAT/Production environments
• Implementing security for write back of claims amounts fromTIBCO Spotfire dashboards
• Customization ofTIBCOSpotfirereports usingTIBCOSpotfireAPIs and iron python scripts
• Formulated dashboard specifications and generated status reports
• Documented and maintained practices for system installations and configurations
• Developed User Security Groups in TIBCO Spotfire for Authenticating the Access to the tool and providing authorization to view limited data

ENVIRONMENT: TIBCOSpotfire6.0/6.5,7.6, MS SQL SERVER 2008/2008, SSIS, SSRS, Oracle 10g/11g, Windows XP/Vista/7, HTML, JavaScript

Confidential, COPPELL, TEXAS

SPOTFIRE DEVELOPER/ADMIN

Responsibilities:

• Giving access to new users and maintaining Spotfire’s servers
• Involved in reviewing Use Cases/Business Requirements and prepared detailed Technical Design documents
• Created a personalized information link based on user restriction
• Configured TIBCO File adapter to poll Member Information files in a batch mode from The Legacy systems
• Implemented Web Services In Tibco Business Works to implement cross- data Lookups from the Database
• Developed various business processes using Business Works for 834, 837 and 820 HIPAA transactions
• Created Operations Flow, Design and mapping documents for HIPAA standard Transaction sets of 278(Authorizations), 837(Healthcare claims), 834(Member Enrollment) and 820(Remittance advices)
• Supported 837, 834 and 820 interfaces during Maintenance window of production Release
• Created testing strategy to validate the code during migrations
• Configured SAP Adapter to publish & subscribe IDoc's in real-time from SAP systems
• Deployed Tibco Business works engines In LB and FT mode using App manage scripts
• Created Shell script to retrieve EAR files from CVS and deploy in targeted environment using App manage commands
• Created the Deployment package for various environments such as Tech test and Production
• Provide Continuous Integration using TIBCO App Manage, Jenkins, Ant, TIB Ant
• Worked In configuring Jboss servers in a clustering solution for high availability, Scalability, Load balancing and fail over support on highly distributed deployment servers
• Created TIBCO EARs containing Process & adapter archives and deployed them using Administrator. Further all the process engines & adapter components had been started to check whether it performed as desired
• Implemented SOAPUI groovy scripts to test Web service performance In Load Test environment
• Supported EAI team, Legacy team and Process team during production Issues and defect triage
• Developed TIBCO design time libraries for Common Error, Exception Handling and Common Data Models
• Integrated Tibco Hawk with Error handling system through RVD to provide better alerts view in a common dashboard

ENVIRONMENT: TIBCOSpotfire6.5/6.6,MS SQL SERVER 2008/2008,Oracle 10g/11g, Windows XP/Vista/7

Confidential, MECHANICSBURG, PENNSYLVANIA

SPOTFIRE DEVELOBER/ADMIN

Responsibilities:

• Worked on Upgrading TIBCO systems for EMS, BW, TRA and MQ across all environments
• Security and enforcing usage of NTID's in lower environments and propagating the same In higher environments
• Creating New Domains In Lower Environments
• Performance tuning for Environments and maintaining Param's across the board for different Agents
• Worked with International teams for deployment of various applications across the board
• Worked with Tibco Support to resolve issues with TIBRV configurations
• Wrote scripts to generate reports for Health Checks on servers. Also, prepared a chart with list of servers and daily health check Report. Generated and monitored a complete health report of all machines owned by TIBCO
• Working with Performance Team to test interfaces In QA for Performance Tuning
• Configured JDBC resources, connections and database schema for Business Works configuration, logs and run-time data store
• Applying hot fixes for Siebel adapters In all environments and tested various scenarios and checked if the hot fixes help in fixing issues related to Siebel
• Worked with Testers to perform load test on the system and monitored the systems closely and reported issues timely
• Providing support for daily deployment Issues and support fordevelopers when they run Into Issues
• Providing on call support 24/7 and production support for CRM and Non-CRM Applications across the Board
• Maintain and do health checks on 30 servers including production and pro-actively work with other teams to resolve Issues and work with them

ENVIRONMENT: HTML, JavaScript, TIBCOSpotfire 7.8/7.6, MS SQL SERVER 2008/2008, TRA 5.6.2, Administrator 5.6

Confidential

Business Analyst II

Responsibilities:

• Researched and assessed client systems andbusiness processes
• Explored all aspects of the claim processing lifecycle, starting from Identifying a claim to Its closure
• Used MS Word document for requirement gathering
• Worked intensively on various phases in the project lifecycle to design the system in such a way that the high-risk claims could be easily identified and monitored
• Participated in preparing basis for Project Vision documentation
• Involved in walkthroughs withbusiness team, architects and developers to refine the requirements
• Generated use-case diagrams using UML
• Implemented Traceability Matrix, User Requirement Specification Document (URS) to verify the functionality
• Streamlined clerical work processes and mapped to the automated system
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans

ENVIRONMENT: MS Visio, UML, Oracle, Windows 2000, TIBCOSpotfire 6/6.5 MS SQL SERVER 2008/2008

Confidential

Data Analyst

Responsibilities:

• Employing SQL and Excel to extract, clean, and organizedata
• Using R to run statistical reports to provide the client with informative solutions to their business problems
• Creatingdata visualizations for my clients through R ggplot2 and Tableau
• Creating daily reports through SQL to track the efficiency and accuracy of our automated system
• Being directly responsible for the maintenance of 33% of our clientele’s shipmentdata
• Prioritizing up to 500 incoming files based on volume and aging
• Conducting peer reviews of product coding daily
• Working with clients to analyze, evaluate, and develop meaningful solutions to theirdata Issues
• Using an automated Interface to assign client products to Trade Pulse reporting structure

Environment: Tableau Desktop 8.x/9.x, Erwin, Tableau Server, MS Office Suite (Word, Excel, and PowerPoint), Oracle 11g, and MS SQL Server.

Confidential

Jr.Sales force Admin

Responsibilities:

• Customize existing applications: sales cloud, service cloud, Chatter and communications
• Formed Queues, Private and Public Chatter groups for the purpose of collaborating with communities, support management and assignment
• Involved with the Data Integrating Siebel CRM to Sales force
• Exported and Schedule data for backup and imported external data for migration
• Monitored ongoing integration from Siebel info Sales force using web services API
• Effectively translate business needs into functional systems requirements
• Work independently and in groups to solve high - Complexity system, data and business problems
• Participated in systems Setup, setting up a system which is a copy of customer’s environment

Environment: Sales Force, Oracle, Web services, Ms Office, Call Centre, Call Flow, Ms Project, Ms Visio, Ms Project, sales performance management software, Jira