SUMMARY:

• Over 11 years of experience in Information Technology with 5+ years of experience as Tibco Spotfire Lead/Consultant in various industries.
• 6+ years of experience in Software Quality Assurance/Quality Control in Web - based, Client/Server applications on Windows environment and CRM application in Insurance, Financials and Telecom industries.
• Expertise in providing Business Intelligence Solution using Business analytic tool TIBCO Spotfire Professional, Spotfire Web player, Spotfire Automation Server.
• Experience in creating complex statistical and financial Spotfire dashboards or reports using Tibco Spotfire Professional.
• Ability to combine data from different sources and expose them to TIBCO Spotfire client users through Information Links.
• Analytical, troubleshooting, and Business Intelligence skills using TIBCO Spotfire (5.X, 6.X, and 7.X), Microsoft SharePoint 2007, Microsoft Office 2010 programs, and Microsoft SQL to collect, identify, analyse and design trends to present to management as well as implementing viable solutions.
• Expert in developing reports with rich visualizations like Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, 3D Scatter plot, Pie chart, Parallel coordinate plots, Gantt chart, Pareto chart, Table, Cross table, Summary table, Tree map, Heat map and interactive features such as multiple Markings, Filtering schemes, etc
• 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.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Experience in all aspects of the Software Development Life Cycle (SDLC) (V-Model, Waterfall, Agile, and Scrum) with specific focus on Testing, analysing the data and presenting analytic report.
• Hands on experience with System Testing, Functionality Testing (Black Box), Automation testing, End to End Testing, Integration Testing, Regression Testing, GUI Testing, Web application Testing, User Acceptance Testing (UAT), and Unit testing.
• Proficient in working with SQL statements to extract data from Oracle tables and verify the output data of the reports. Good at Creating tables, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
• Hands-on experience in developing testing approach such as preparing test plans, test cases, test data, test scripts, test scenarios and generating report based on business requirements using quality center.
• Specialized in Manual and Automated Testing on Client/Server based Applications and Web based Applications using Selenium IDE, Selenium RC, Selenium WebDriver, Quality Center etc.
• Extensively used core java in test scripts.
• Expertise in Understanding the code written in different programming languages like Java Script, Iron Python Script
• Expertise in Database Testing.
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILL:

Business Intelligence tools: TIBCO Spotfire (Spotfire Professional, Web Player, Spotfire Admin server Spotfire Automation Server, Spotfire Statistical Server, ADS

Database: MS SQL server 2008,2012, Oracle 8i/9i/10g/11g, Toad

Testing Tools: Mercury (HP-ALM)-Quality Center 11, Bugzilla, Rational Clear Quest Selenium Infra,Mantis, JMeter, JIRA, Firebug, Maven

Scripting Languages: IronPython, R script, JavaScript

Languages: SQL CRM Siebel, Chordiant

Web Technologies: HTML, XML, XPath

Packages: MS-Office Suite (Word, Excel, Access), MS-Project

Operating system: MS-DOS, Mac, Windows 2007, Unix, Linux

Source control: VSS, Clear Case

PROJECT EXPERIENCE:

Confidential, Irving, TX

Sr. BI Developer

Responsibilities:

• Working with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation.
• Involving in directing the BI strategic plan roadmap, development of business requirements, development of functional and program specifications, relational database design, programming, testing, implementation and documentation for applications.
• Creating technical design specifications, developing analytical reports, troubleshoot and resolve technical issues, debug, tune and optimize report performance.
• Developing Spotfire reports, dashboards, and supporting our client's Intelligence platforms and applications.
• Migrating Java, HTML and PHP monitor static report to Spotfire.
• Involving in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Involving in Spotfire setup, installation, administration.
• Developing and debugging many Dashboards / Reports with different Analytics Views (Pivot Tables, Summary Tables, Cross-tables, Pie-Charts, Line-chart, Combinational-chart, Bar-chart, Scatter-plot, Heat-map, and Tree-map), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Building various Spotfire reports and publish them on to the Spotfire Server.
• Creating Pie chart, Bar chart and Detailed Table Visualization from the data and then drill down, slice and dice the data to understand the data from different angles and perspectives.
• Developing visualization customization using Iron Python. Designed and developed the information links, Data Sources, Columns, Joins, Filtering and Procedures.
• Involving in providing ETL architecture & data load, transform strategy to handle huge volume of data from multiple sources like SQL, flat files, and OSIsoft PI real time data for Safety, Quality, and Delivery & Cost unit Global Supply Chain unit.
• Proposing various approaches and solutions based on PoCs like implementation of event base triggered scheduling for high visibility Business Dashboards used by global stakeholders.
• Perform initial problem investigation to determine scope and depth of problem and recommend additional steps and solutions by following established guidelines.
• Developing Iron Python script and utilized its power in text areas of Spotfire Dashboards for much useful custom functionality for business users.
• Optimizing Information links and queries to increase performance.
• Interface with the business for Spotfire demonstrations and User Acceptance Testing.
• Writing complex SQL queries to retrieve data from multiple database objects.
• Participate in troubleshooting visualization performance issues and involved in tuning reports for better performance

Environment: TIBCO Spotfire Professional 7.10, Spotfire Web Player, Spotfire Admin Server, Spotfire Automation Server, Spotfire Statistical Server, Windows 2008 server, SQL Server 2012,, SAP, BOD ETL tool, SharePoint, Statistical analysis tools/Engine TERR,R, Java Script, Iron Python script, SQL query

Confidential, New York

Sr. Spotfire Developer

Responsibilities:

• Worked as Centre of Excellence Expert in Business Analytics in Enterprise Application Analytics by using TIBCO Spotfire.
• Work with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation.
• Involved in directing the BI strategic plan roadmap, development of business requirements, development of functional and program specifications, relational database design, programming, testing, implementation and documentation for applications.
• Create technical design specifications, developing analytical reports, troubleshoot and resolve technical issues, debug, tune and optimize report performance.
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications.
• Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
• Involved in Spotfire setup, installation, administration.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Tables, Summary Tables, Cross-tables, Pie-Charts, Line-chart, Combinational-chart, Bar-chart, Scatter-plot, Heat-map, and Tree-map), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Build various Spotfire reports and publish them on to the Spotfire Server.
• Created Pie chart, Bar chart and Detailed Table Visualization from the data and then drill down, slice and dice the data to understand the data from different angles and perspectives.
• Developed visualization customization using Iron Python. Designed and developed the information links, Data Sources, Columns, Joins, Filtering and Procedures.
• Involved in providing ETL architecture & data load, transform strategy to handle huge volume of data from multiple sources like SQL, flat files, and OSIsoft PI real time data for Safety, Quality, and Delivery & Cost unit Global Supply Chain unit.
• Proposed various approaches and solutions based on PoCs like implementation of event base triggered scheduling for high visibility Business Dashboards used by global stakeholders.
• Performed various RnD related to Spotfire extensions like building JDBC data sources for Greenplum connector, PI System Data connector, SQL Parallel data warehouse database.
• Perform initial problem investigation to determine scope and depth of problem and recommend additional steps and solutions by following established guidelines.
• Developed Iron Python script and utilized its power in text areas of Spotfire Dashboards for much useful custom functionality for business users.
• Optimized Information links and queries to increase performance.
• Interfaced with the business for Spotfire demonstrations and User Acceptance Testing.
• Wrote complex SQL queries to retrieve data from multiple database objects.
• Participated in troubleshooting visualization performance issues and involved in tuning reports for better performance

Environment: TIBCO Spotfire Professional 6.5, Spotfire Web Player, Spotfire Admin Server, Spotfire Automation Server, Spotfire Statistical Server, Windows 2008 server, SQL Server 2012,, Hadoop Distributed File System, pgAdmin Query tool Pivotal Greenplum, OSI soft PI Datalink, SharePoint, Statistical analysis tools/Engine TERR, R, Java Script, Iron Python script, SQL query, ADS

Confidential, Bloomington, IL

TIBCO Spotfire Developer

Responsibilities:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• Implemented BI tools Like Spotfire.
• Analysed various reports existing in SSRS and created POCs for Spotfire.
• Created data sources by using Spotfire Information Designer to connect various data marts with Oracle, SQL Server, SAS/Share functions
• Using TIBCO Spotfire developed dashboards using calculated columns, custom functions, property controls
• Developed Spotfire data visualization using Cross Tab reports, Summery tables, Line charts, Bar charts Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Line Chat, and Density Chart.
• Applied data Table Properties, Property Controls, Filters, Joins and Custom functions to get formulated data from Information Links
• Identifying data from the back-end database tables and querying the same for reports creation
• Created Pie chart, Bar chart and Detailed Table Visualization from the data and then drill down, slice and dice the data to understand the data from different angles and perspectives.
• Build various Spotfire reports and publish them on to the Spotfire Server.
• Reviewed business application needs and worked on planning visualizations for several functional domains.
• Analysed functional areas and formulated data requirements needs related to building visualizations.
• Validated data at the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Provided solution to users who raised tickets and educated new users with basic Spotfire reporting.

Environment: Spotfire Professional 5.5, Spotfire Server, Spotfire Web Player, Oracle, Server, SQL Developer, Oracle 10g, SQL Server 2008, Java Script, Iron Python script

Confidential

Sr. QA Engineer

Responsibilities:

• Involved in requirements gathering, project planning, QA estimates.
• Good experience on Siebel CRM end to end testing.
• Involved requirements gathering, project planning, QA estimates
• Developed test plans and test cases according to HLD, LLD, USECASES.
• Experience on Siebel CRM Order Management.
• Strong database testing using SQL server.
• Performed Functional, Regression, Back-End data validations and GUI Testing.
• Used Selenium Web driver, Test NG, Java script to automate regression test cases.
• Created Selenium automation scripts in Java.
• Hands on experience writing Selenium tests through Selenium Web driver.
• Created Selenium automation scripts in Java using data driven frame work.
• Experience on build automation, source control and deployment tool Maven.
• Experienced in java script coding, De-bugging and handling frequent updates to web application.
• Provide guidance and mentors junior QA Analyst, to help achieve maximum performance.
• Work closely with developers, business analysts, and customers in developing and testing innovative software solutions that are scalable, cost-effective and the highest of quality.
• Participate in requirements gathering and work with internal teams.
• Collaborate with business and technical team members as well as customer groups to evaluate or diagnose problems and recommend possible solutions.
• Logs, tracks, and verifies resolution of software and specification defects. Ensure quality of documents developed in all phases of QA process.
• Works with developers, business analysts, and customers, to establish and maintain a consistent test methodology and to resolve issues during the testing process.
• Analyses, tests, and certifies application-specific software and performs ambiguity reviews of business requirements and functional specification documents.
• Uses advanced knowledge of applications to provide technical assistance in identifying, evaluating, and resolving highly complex test problems.
• Created test cases for all the functionality.
• Leading and point of contact for all the testing activity
• Use queries to create test data and analyse the data flow.
• Work with developers, analytics, and Client Services staff to devise test plans and schedule.
• Prepared Requirements in Quality Center
• Prepared test cases in Test plan of Quality Center
• Mapped Requirements with Test plan in Quality Center
• Performing manual Testing with Various Go live Test data
• Involved in UAT.
• Logged defects in to the Quality Center and tracked bugs based on priority and severity in HPQC.
• Analysed execution results and provide status reports to the project team.
• Verified support and UAT defects.
• Performed Build verification testing.
• Involved in defect prevention activity (DPA) to deliver a quality product to client.

Environment: HP Quality center 11.0(HP-ALM), Manual testing, Agile, Siebel CRM, BizTalk middleware, MS excel, SQL Server, Selenium IDE, Selenium Web Driver, Test NG, Maven, JMeter, SQL, JIRA, MS excel, Java script, Windows

Confidential

QA Engineer

Responsibilities:

• Involved in SIT and MIT test execution.
• Involved in Data migration testing.
• Involved in data base Testing.
• Black Box testing of the Application.
• Involved in manual testing like functional testing, end to end testing, backend testing, sanity testing.
• Prepared test plan, Test scenarios, Test cases as per requirement document.
• Hands on experience on telecom application.
• Supporting change request for legacy system developed in ASP.
• Participated in system migration & enhancement to CAI (Core Application and Integration) using SCM (Software Configuration Management) standards Unit testing of development.
• Co-coordinating with Quality Assurance team for system functionality and performance.
• Co-coordinating with client/end user for system changes approvals.
• Creating and Updating Business Requirement Specification (BRS).
• Writing and executing the test cases.
• Reviewing Test cases.
• Bug reporting and Tracking it Till Closure.
• Co-coordinating with system administration and packaging team for new system & change request implementation.
• Supporting client for production data issues and/or human errors.