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 … Oracle … 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

WORK EXPERIENCE:

Sr. Spotfire Developer

Confidential, Nashua, NH

Responsibilities:

• Communication with Business Analysts and Testing Team to follow through on the end to end Life cycle of the Reports.
• Develop Reports for the Transactional Database from different applications like PStar, Oracle EBS (HR and Financials.)
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/ Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created Tableau workbooks with calculations, parameters, Quick Filters.
• Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Designing and developing the information links, Data Source, Columns, Joins, Filters andStore Procedures.
• Creating visualization using advanced Heat Map, Trellis, Scatter plots, 3D Scatter Plots, Map charts, Tree Map
• Creating Dynamic Visualizations using Text Area, Input Field, Lists, drop down lists, Property, Document Properties and On - Demand Data.
• Maintaining Maps for Custom Sales Territories by creating Shape files and integrating Geo-Spatial data from the Field agents & Customers.
• Structured the Spotfire library to publish and share all the analysis material, information links, data sources to end user according to their role and knowledge
• Created Information Links for many databases for populating data into Visualization from underlying databases such as Sql Server and Oracle.
• Managed created dashboards in Spotfire cloud with regarding to user's roles.
• Integrated Spotfire visualization into client's Salesforce environment.
• Trained Spotfire tool and gave guidance in creating Spotfire Visualizations to couple of colleagues

Environment: SPOTFIRE 5.0 & 6.5, Tableau 7.x, Qlikview 10.0/9.0, Sharepoint, Business Objects 3.1, WEB SERVICES, SQL Studio, Oracle 10g, EBS, EBIE Experts, ArcGIS, Team Track.

TIBCO Spotfire Developer

Confidential, Bloomington, IL

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, IronPython script, SQL query

Tibco Developer/Spotfire Developer

Confidential, Denver, CO

Responsibilities:

• Thorough understanding of the Functionality.
• Developed the Components, which taking the data from the Data Zone Kept by the Mainframe application.
• Putting the data in to database
• Retrieving the data from the database and send it to destination system (TDSP)
• Involved in Creating XML Schemas, Data map features of Monk.
• Handling EDI transactions Exa: 810, 867, 814,997 etc
• Involved in defining Test Conditions.
• Involved in Bug Fixing. Involved in Unit Testing & Integration testing
• The design and development of the project.
• Configuring ADB adapters to obtain real time data.
• Created an exception handler and notification system.
• Created XSD schemas used in the BW process.
• Configuring the deployment settings.
• Involved in documenting, testing, debugging, deploying, supporting this project.Collected data on various process measurements and formatted into graphs using TIBCO Spotfire software.
• Building, publishing interactive reports and dashboards, report scheduling using TIBCO Spotfire server.
• Created and assisted users in TIBCO Spotfire dashboard development.
• Defined and created procedures to install TIBCO Spotfire in silent mode.
• Defined best practices for TIBCO Spotfire report development.
• Set up TIBCO Spotfire, Data Analysis and publishing reports.
• Generated daily, weekly and monthly reports using TIBCO Spotfire.

Environment: TIBCO Designer 5.3, TIBCO Business Works 5.3, TIBCOBusinesEvents, TIBCO Administrator 5.3,Spotfire 4.x, 5.x,Tibco adapter for database (ADB) 5.3.0, TIBCO EMS4.1, TIBCO Hawk 4.5, XML Canon 3.1, XML, XSD, XSLT, Oracle 9i.

Sr. QA Engineer

Confidential, Pasadena, CA

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.
• Analyzes, 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

QA Engineer

Confidential

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.

Environment: Choridant 5.7., Windows operating system, Intec Singl.eView 6.0, Unix, Toad 9.1, EMM, QC 9.2., Bugzilla