PROFESSIONAL SUMMARY:

• Over 8+ Years of IT experience in Analysis, Design, Development, Implementation and Testing of Enterprise Applications in the Client/Server environment using Java/J2ee in Client - Server, 3-tier and n-tier applications.
• Six plus years of experience in creating complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, data on demand, Property Controls, text areas in TIBCO Spotfire reports using Tibco Spotfire Professional, Installation of Tibco Spotfire server, Administrative tuning and monitoring the server.
• Proficient in all phases of SDLC (analysis, design, development, testing and deployment) and highly competent in gathering user requirements.
• Involved in Spotfire administration activities including Administration Manager, Library Administration and Administrator console.
• Experience working with cloud environments such as Amazon AWS and Windows Azure.
• Knowledge and hands on experience on Visualizations, Details on Demand,Information Designer, Automation Job Builder, Property controls, Action controls and filters, Library Administrator, ADS, In-memory Architecture.
• Experience in Requirement gathering, Analysis, Design, Reviews, Coding and Code Reviews, Unit and Integration Testing.
• Experience in working with Atlassian tools like Jira, Confluence and Stash.
• Good understanding on Business Intelligence tools, data mining and connectivity with Hadoop clusters.
• Extensive Experience in installation, configuration, deployment and troubleshooting of TIBCO Active Enterprise Suite of applications TIBCO BusinessWorks, TIBCOEMS, TIBCO Active Database Adapter, TIBCO MQ Series Adapter,TIBCO Business Connect,TIBCO Administrator, TIBCO HAWK.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Expertise in designing and developing J2EE compliant systems using IDE tools like Eclipse, My Eclipse, RAD, RSA, WebLogic Workbench.
• Experience in T-SQL, SSRS, SSIS, Reporting and Data Analytics.
• Created multiple integrated dashboards with web integration.
• Experienced in exclusive design of reports, with Cross tables, Bar Charts, Combination charts, scatter plots and Pie charts.
• Strong understanding of Iron python scripting, TERR/R programming.
• Used data on demand to custom reports, well versed in using different data sources, components and schemas.
• Good knowledge of database connectivity (JDBC) for databases like Oracle, SQL Server, MySQL.
• Experience with Eclipse, My Eclipse, WSAD (Web Sphere Studio Application Developer), J Builder, Maven.
• Participation in all phases of Software Development Life Cycle (SDLC) including analysis, design, coding and testing with J-Unit, good knowledge in integration using J2EE Architecture.
• Experience with Databases like Oracle 10g/11g, MYSQL, SQL SERVER 2008, JDBC etc.
• Proficient in Quality Control - includes ensuring defect free releases, maintaining correct entries in Design Docs, UI specs, Test Cases, Traceability Matrix.
• Efficient team member with excellent work/time management skills excellent leadership, communication and interpersonal skills, ability to work under strict deadlines.

TECHNICAL SKILLS:

Web Technologies: JSP, Servlets, Ajax, Web Services (WSDL, SOAP, JAXB, JAXP, Spring-WS, JAX-RPC, JAX-WS), JQuery, JSF

TIBCO Active Enterprise Suite: TRA, TIBCO Business Works, TIBCO EMS, TIBCO Administrator, TIBCO Rendezvous, TIBCO General Interface, TIBCO adapters (file adapter, active database adapter, Seibel adapter, SAP R3 adapter), TIBCO HAWK, TIBCO XCD,TIBCO Business Connect, Business Events, TIBCO IPROCESS.

TIBCO Spotfire: 7.7,7.5,7.0, 6.5,6.0,5.5

Operating Systems: Windows XP/2003/NT/98/95, UNIX (Solaris 9/10, Linux), HP-UNIX, Solaris

Application Servers: JBOSS, Web Logic, Web Sphere

IDE s: Eclipse, WSAD, J Builder, My eclipse

Databases: Oracle10/11g, SQL Server, My SQL, DB2, Teradata IBM

Markup Languages: XML, VXML, XSL, XSLT, SAX, DOM, XPATH, DTD, Schemas

Source control Tool: Rational Clear Case, VSS, CVS

Reporting Tools: Spotfire, Power BI, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Tibco Spotfire Developer

Responsibilities:

• Interact with the customers and project manager to assess the needs and requirements, performed impact analysis, described and documented.
• Administered users and Library Management, access levels, rights and folder structure.
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Created the visualizations with complex calculations/functions.
• Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Created Action Controls using Iron Python Scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.
• Utilized the various joins in Spotfire to connect to the data sources in the database to pull data in for data wrangling and final display to the user.
• Dashboard/report migration across environments (Dev> QA > Prod).
• Root cause analysis and fixing the issues with the Spotfire environment.
• Analysis of the Server Issues, Library issues, etc
• Deployment of reports to the testing environments.

Environment: TIBCO Spotfire 11 (Professional clients, Spotfire Web Player, Automations, Web Player Server Oracle 10g, PL/SQL, .NET Framework 4.0, Agile, Microsoft Internet Information Services 7.0, Windows Server 2008 R2.

Confidential, Boston, MA

Tibco Spotfire Lead

Responsibilities:

• Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.
• Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.
• Translate product requirements and business questions into report requirements and visualization dashboards.
• Administered users and Library Management, access levels, rights and folder structure.
• Followed Agile software development with Scrum methodology.
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.
• Developed Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance.
• Deployment of dashboards and reports to the testing environments.
• Developed and maintained SQL queries for use in Information links.
• Executed SQL queries for data validation testing in target database warehouse data mart.
• Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
• Changed the data sources of existing reports to reflect new data sources and retrieve data using the new data sources.
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Created the visualizations with complex calculations/functions.
• Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Converted reports created in Oracle business objects and Tableau into spotfire reports.
• Used D3.js to create interactive visualizations in the client to depict the various functions within the business that need more attention.
• Code migration across environments (Dev> QA > Prod).
• Performed v-lookups in Excel for data comparison within multiple excel worksheets.
• Root cause analysis and fixing the issues with the Spotfire environment.
• Created Action Controls using Iron Python Scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
• Worked with statistics teams to utilize R scripts and in corporate with Spotfire’s TERR engine for writing data functions and expression functions.

Environment: TIBCO Spotfire 7.7 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Microsoft SQL Server 2010/2012, PL/SQL,TIBCO Business works 5.x, Teradata, .NET Framework 4.0, Agile, Microsoft Internet Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2.

Confidential, Mason, OH

Spotfire / Tableau Developer

Responsibilities:

• Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.
• Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.
• Translate product requirements and business questions into report requirements and visualization dashboards.
• Administered users and Library Management, access levels, rights and folder structure.
• Followed Agile software development with Scrum methodology.
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.
• Developed Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance.
• Used joins and subqueries using SQL to cross- analyze data across multiple tables.
• Updated the sql query to write back to the database using the pre-update option in information link.
• Converting reports developed in Tableau and Cognos to spotfire.
• Connected Tableau server to publish dashboard to a central location.
• Connected Tableau server with share-point portal with auto refresh feature.
• Scheduled report/dashboard refresh for weekly and monthly reports
• Installation, maintenance and monitoring of TIBCO Applications and EMS destinations.
• Deployment of TIBCO Business Works to the testing environments.
• Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
• Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
• Created the visualizations with complex calculations/functions.
• Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Used d3 javascript library to create visualizations using the d3 library that was deployed in the spotfire server and used in the spotfire analyst client.
• Incorporated R scripts in spotfire’s TERR/R engine.
• Code migration across environments (Dev> QA > Prod).
• Root cause analysis and fixing the issues with the Spotfire environment.
• Analysis of the Server Issues, Library issues, etc
• Iron Python scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
• Used standalone Hadoop mode to run initial MapReduce job.
• Wrote Hive QL to load data on demand from Hortonworks Hive Metastore.

Environment: TIBCO Spotfire 6.5 & 7.0 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Microsoft SQL Server 2010/2012, PL/SQL,TIBCO Business works 5.x, SSRS, .NET Framework 4.0, Agile, Windows Azure, AWS, Redshift.

Confidential, Seattle, WA

BI / Spotfire Consultant

Responsibilities:

• Analyzed existing complex systems to understand and document data elements, relationships, data flows, dependencies and related interfaces.
• Configured Hawk rules for EMS queue depth monitoring and monitoring BW application as well as log files.
• Extracted data from different sources like Excel files, flat files, MS Access, Oracle and otherdatabase.
• Developed the Stored Procedures for extensively reporting the system and used custom designed parameters for reports.
• Performed the analytical analysis, use different visualization methods like Bar Chart, Line Chart, Combination Chart, Scatter Chart, Heat Map and Cross Tables.
• Built interactive dashboards for upper management that can provide quick information at a glance.
• Used Bookmarks to Create Guided Analysis to predicate the result for next coming years based on analytical analysis.
• Created dashboards using Tableau Dashboard and prepared user stories to create dashboards with actionable insights.
• Created joins between multiple tables and wrote sql queries to bring the appropriate data into the various charts developed.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Density Charts.
• Developed Processes in TIBCO Business works for the transforming the data to/ from XML and proprietary formats.
• Worked on TIBCOBusiness Events for analyzing complex patterns using events, concepts, scorecards,, functions, rules, channels and destinations of business event workbench palette.
• Developed MDM wrapper layer service for MDM integration with upstream/downstream applications and customized record CRUD operations using TIBCO BusinessWorks and MDM adapter.
• Involved in planning process of iterations under the Agile Scrum methodology.
• Used TIBCO BusinessWorks to design the private process and map the fields of the Outbound EDI 810 (Invoice), EDI 856 (Shipment Notification) and EDI 832 (Sales Catalog) processes and publish it to applications.
• Installed and configured TIBCO Business Works, TIBCO Administrator, TIBCO Business Connect and TIBCO Adapters.
• Structured the Spotfire library to publish and share all the analysis material, information links, data sources, etc.
• Design, implement, and collaborate Spotfire Visualization, portals, Dashboards for managers and executives.
• Creating Visualization Summary/Detail tables, Bar Charts, Pie Charts and scatter plots.
• Customizing Visualization using filters, markings, custom columns and custom expressions.
• Developed Test scripts and test cases for functional and regression testing.

Environment: Agile, TIBCO Spotfire 6.5 (Professional clients, Spotfire Web Player, Automations, Web Player Server) Oracle 10g, PL/SQL, Tableau, tableau server, TIBCO Business works 5.x,Tibco Hawk,TIBCO Business Events, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0,MDM, Windows Server 2008 R2.4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2.

Confidential, Atlanta, GA

BI / Spotfire Consultant

Responsibilities:

• 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.
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Information links, Parameterization, defined join rules in Information designer.
• Installed Spotfire Server,Database drivers,Hotfixes.
• Used Microsoft sql server to hold Spotfire server database.
• Configured Spotfire server - Set up single sign on.
• Implemented TIBCO Hawk rules for EMS queue and Tibco BW applications
• Configured Tibco BusinessWorks applications in iProcess procedure as per business flow and alsoiProces procedure steps in BW application to work on cases.
• Wrote Spotfire server Backup scripts to take backups regularly.
• Monitored Spotfire server to detect issues with server, LDAP Servers, Network problems, External databases to reduce server downtime and eliminate performance bottlenecks.
• Used TIBCO BusinessWorks to design the private process and map the fields of the Outbound EDI 810 (Invoice), EDI 856 (Shipment Notification) and EDI 832 (Sales Catalog) processes and publish it to applications
• 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.
• Worked on Business Events creating criteria, concepts, channels, rule sets, actions and conditions.
• Developed a generic error handling process for all MDM workflows using TIBCO BusinessWorks with MDM workflow activities, which suspends workflow execution and creates error notification work item, then either replays or rejects the payload message depends on choice.
• Followed Agile with SCRUM methodology to track project progress.
• Installed and Configured Spotfire Server.
• Set up Projects, Groups, Users and set up Permissions.

Environment: TibcoSpotfire 6.5/5.5,TIBCO Hawk,TIBCO Business Events,Agile, Windows 2008 server, MDM, SQL Server 2012, TIBCO Business works 5.x

Confidential, Austin, TX

Tibco Spotfire Consultant

Responsibilities:

• Installed Spotfire Server in Cluster set up, Database drivers, Hotfixes.
• Upgraded Spotfire from 6.5 to 7.
• Used Microsoft sql server for Spotfire server database.
• Configured Spotfire server - Set up single sign on.
• Set up Projects, Groups, Users and set up Permissions.
• Wrote Spotfire server Backupscripts to take backups regularly.
• 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 and what work they do.
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Developed Spotfire Views/Vizs for over 30 metrics for Call Handling, Customer Satisfaction and time to resolve metrics (Customer plank), Utilization, Effectiveness, Compliance metrics (Operational plank), Operational Costs, Service Cost metrics (Financial plank), Skillset Development and Employee Satisfaction (Employee Plank)
• Created Executive Scorecard that provides information about how agents of a Functional group have performed with respect to various metrics for a year and month. Key metrics like Average Talk Time, Cases per Head, Training Compliance, First Visit fix rate, OT Percent are shown on the scorecard.
• Worked on Dashboard Landing Page where most of the metrics are grouped into Customer, Operational, Employee and Financial planks.
• Used data table properties, Property Controls, Filters, Joins and custom functions to get formulated data from information links.
• Followed Agile development with Scrum methodology.
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart.
• Created Information links, Parameterization, defined join rules in Information designer.
• Created Action Controls using Iron Python.
• Worked on TibcoSpotfire 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: TibcoSpotfire Professional, Agile, Spotfire Web Player, Spotfire server, Windows 2008 server, SQL Server 2008, SSIS, TIBCO Business works 5.x

Confidential, Dallas TX

Spotfire Analyst

Responsibilities:

• Analyzed Business and Functional requirements documents.
• Configured the Information Links based on the limitation of the User Groups under Information Designer. .
• Performed the analytical analysis, use different visualization methods like Bar Chart, Line Chart, Combination Chart, Scatter Chart, Heat Map and Cross Tables.
• Built interactive dashboards for upper management that can provide quick information at a glance.
• Followed Agile software development with Scrum methodology.
• Used Bookmarks to Create Guided Analysis to predicate the result for next coming years based on analytical analysis.
• Structured the Spotfire library to publish and share all the analysis material, information links, data sources, etc.

Environment: TIBCO Spotfire 4.0 (Professional clients, Spotfire Web Player, Automations, Web Player Server) Oracle 10g, PL/SQL, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2.4.0, Agile, Microsoft Internet Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2.