SUMMARY

• Overall 10+ years IT industry (QA) experience in Banking, Airline, Financial, Mutual Funds, eCommerce, Mobile Commerce, Utility(Energy), Billing System, Health Care & Hospitality/Hotel industries as Quality Assurance Tester with strong Business and Functional knowledge.
• Experience in using Automated Tools like Parasoft SOA Test, SOAPUI, STF (Webservices & API Testing tool), Winrunner, QuickTest Professional (QTP) & Autopilot for Web based and Client/Server Applications.
• Used JMeter tool for Load & Performance Testing for the Mobile Apps.
• Tested Web services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services. Knowledge on Selenium tools.
• Experience in Automation testing, Manual Testing, Grey Box, Smoke, Sanity, System, User Acceptance (UAT), Regression testing, System Integration Testing, Back - end Testing, GUI Testing, Product Test, Migration Testing, End-to-End testing, Validation Testing, Client Side Testing & Middleware Testing of the application.
• Experience in SDLC and STLC methodologies including waterfall, Agile Scrum Software Development methodologies & Test driven Development Approach
• Involved in writing Test Plans, Test Strategy & prepared Test Data, Test Scenarios, Test Scripts, Traceability Matrix, Test Matrix, Use Cases and Test Results
• Expertise in documentation including design, development, and execution of Test plans, Test scenarios, and Test cases.
• Efficiently performed Defect Tracking & Generating Reports using various Test Management and Execution tools like Quality Center, Test Director, Rational Clear Quest, TFS, Remedy Tool, PVCS Tracker, and Bugzilla.
• Have managed multiple releases, builds and projects with excellent coordination involving both Onsite and Offshore QA Teams
• Expert in writing queries in SQL and T-Sql by using the databases such as ORACLE, DB2 & SQL Server
• Extensive experience in writing SQL and PL/SQL scripts to validate the database and for backend database testing
• Experience in Testing complex Business rules by creating mapping and various transformations
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
• Good experience in Data warehouse (ETL) testing, Business Object Report (BO) testing & involved in testing the complex Business rules by creating mapping and various transformations
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting. Experience in testing XML files and validating the data loaded to staging tables.
• Experience in all the phases of the Data warehouse life cycle involving design, development & analysis and testing of Data warehouses using ETL/OLAP Tools.
• Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Managed VSS, CVS, PVCS and Clear Case for version control and configuration control.
• Performed cross browser testing and checked the application compatibility.
• Specialized in Testing JD Edward ERP applications for Financials, Inventory, Sales Order Management, Transportation, Manufacturing and Procurement modules.
• Working experience with Agile and Scrum methodology
• A good team player with excellent Analysis and ability to work with the team as well as individually under strict Deadlines. Ability to work collaboratively with Business Analysts, Testers, Developers and other team members
• Possess problem-solving skills, Ability to follow industry standards & procedures. Quickly master new concepts & applications. Strong communication and Interpersonal skills.

TECHNICAL SKILLS

Languages: VBScript, JavaScript, VB, C#, C++, Java, J2EE JSP, Jdbc, EJB, ASP & .Net

Protocols: HTTP/HTTPS, ODBC, TCP/IP

Databases: Oracle 9i/10g/11g, Ms-Access, Sybase, DB2 & SQL Server 2005/2008.

Application Server: IBM Web Sphere, BEA Web logic, Apache/Tomcat, JBOSS

Confidential Mercury: Quality Center (QC), QTP, Win Runner, Test Director, Knowledge of Load Runner

IBM Rational: Clear Quest & Clear Case, RTC, RQM.

Other Tools: PVCS, TIBCO, Bugzilla, Toad, SQL Editor, Team Foundation Server (TFS), Share Point, QAComplete, JIRA, Parasoft SOAtest, SoupUI, CI & CD With Jenkins. Selenium.

Web Tools: HTML, DHTML, Flex, Ajax, VBScript, JavaScript, ASP, XML and JSP

ETL Tools: Informatica Power Center & Business Object (BO)

Office Tools: MS Word, Excel, PowerPoint, Access, Outlook and VISIO

Version Control: Microsoft Visual SourceSafe (VSS)

O/S: Windows Vista/XP/2000, Solaris, Linux, AIX and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. QA Engineer

Responsibilities:

• As a senior Test engineer, working in Rate management division, understand user stories and attend sprint meetings.
• Develop Test plan for each sprint and attend review meetings.
• Prepared and executed Test Cases manually according to the user stories, identifying applications functionality, test requirements and coverage.
• Performed functional, integration, system and regression testing
• Defects were tracked, reviewed, analyzed and reported using Rally
• Wrote sql queries and tested the updated data in the application in the database
• Verified XML message and data is correct as per the updates in application.
• Attended shoulder check meetings once completed the testing on user story.
• Coordinated with development engineers and prepared test plans and endured functionality of all applications.
• Performed tests on various features of agile development process.
• Executed Selenium Test scripts for regression testing.
• Performed testing on web services using SOAP UI for smart rates testing

Environment: Rally, Jira, Squirrel SQL Client, Informix, MySQL, AGILE/SCRUM, SOAPUI, XML, Java and Web services, Selenium IDE, Selenium webdriver, Linux, Vagrant.

Confidential, Detroit, MI

QA Lead

Responsibilities:

• Coordinating the testing activities involving multiple IT systems
• Working as a lead in creation, preparation, and conduct of quality assurance reviews and the development and execution of test plans and test scripts
• Working with client to establish and maintain a consistent test methodology and to resolve questions during the testing process
• Extensively involved in Web Services and SOA testing by using (SOAP, REST)
• Testing web services designed to function in a Service Oriented Architecture (SOA) environment
• Specialized in testing and validating XML, XSD, XPath Syntax, Web Services, MQ, REST, HTTP, SOAP Messaging, etc.
• Involved in Mobile apps and mobile web testing on various operating systems e.g. iOS, Andriod etc
• Performed User Acceptance, System, Integration, mobile Testing of the Functional Requirements and business processes
• Involved in Testing the CSB (Customer Service & Billing) system.
• Used JMeter tool for Load & Performance Testing for Outage tracker mobile app and also for Mobile Payment Apps
• Documentation of Test System Scenarios, Test Cases and Test Scripts
• Definition and preparation of Test Data
• Identification and analysis of software defects
• Involveed in verifying the data in Master Data (MDM) for the plan and catalogue.
• Resolves data gaps with SE/BAs and developers as necessary.
• Used IBM WebSphere Message Broker Display Test and Performance utilities (RfhUtil) for the message queues.
• Co-ordinating with third party vender like Aclara for CEA (Insight) mobile app, VectorForm for AMI gas and Detroit Lab for the Outage Tracker Mobile app.
• Working with business users to ensure the quality of delivered software as well as ensuring timely bug resolution
• Used ETL tool (BO) to verify the Reports.

Environment: Windows 7, Java, SoapUI Pro 4.6.0, Rest, Documentum, QC, Clear Case, XML/JSON, DB2, Oracle, AIX Unix, iOS, Andriod, iDevices, Selenium, JMeter, ETL Informatica Dataware Tool, DbVisualizer, RfhUtil V7.0.2, Rest - Postman, Putty, WinSCP, BO/BI, Jenkins.

Confidential, Colorado Spring, CO

Sr. Automation Engineer

Responsibilities:

• Web service’s automation using SOAPUI Pro and Groovy Scripting.
• Involved in developing and managing test automation framework using SOAPUI Pro.
• Planning, deploying, and managing the testing effort for any given release.
• Implementation of automation framework on testing environment.
• Capturing the Web service’s request by using the Fiddler.
• Managing a team
• Interacting with team on need basis and providing timely solutions.

Environment: Windows 7, QTP, Java, Share Point, SoupUI, ALM, Fiddler, TFS, RQM, Agile, Scrum, XML Spy.

Confidential, Smithfield, RI

Sr. QA Consultant

Responsibilities:

• Prepare software scripts and SQL queries to assist with troubleshooting. Build temporary database tables to store test data and test results.
• Ensure that incidents and problems are escalated to service provider and management in a timely manner to protect business interests.
• Work directly with business and team members to analyze/translate business needs and test the technical solutions.
• Participate in team meetings and communicate and coordinated testing with offshore, work schedule and work tasks with team, manager and business as required.
• Build queries and extract ad hoc data using software scripts andSQL Developer
• Talented in creating automated testing scripts, utilizing the automated tools ParasoftSOATest for the webservices testing
• Experience and proficiency in working with the SOAP UI for the webservices testing.
• Mine and manipulate data to create system test data and system test cases for multiple and complex projects
• Used IBM Rational's RQM for requirements management, test execution, reporting and defect management.
• Used RTC which integrate tasks across the software life cycle for the tasks,build management and reports.
• Identify defects in multiple environments and throughout all phases of the development life cycle. Ensure that development groups address all open defects in a timely manner.
• Actively participate in project team meetings as required - communicate project/work status and issues to QA lead.

Environment: Windows 7, Java, Share Point, SQL Developer, Oracle, DB2, Parasoft SOATest, SoupUI, RTC, Agile, Scrum, RQM, XML Spy, Jenkins.

Confidential, Alpharetta, GA

QA Lead

Responsibilities:

• Leading & Coordinating across all internal and external groups.
• Validating the mappings, interfaces, routing rules, data structures, validation rules, workflows, user permissions and business rules to provide WBEI with a production ready environment specifically configured to meet their needs.
• Involved in manual testing, automated testing by using SOAPUI and back-end testing by using the SQL.
• Involveed in verifying the data in Master Data (MDM)
• Involved in developing & manageing test plans, resource plans and timelines for the project

Environment: Windows 7, Unix, Schema, QC (ALM), QTP, WSDL, SOAP, XPATH, SOAP, XML, Java, Agile, Scrum, Jira, Share Point, J2EE & Oracle10g/11g, Confluence (wiki), MS Visio.

Confidential, San Jose CA

Sr. Consultant

Responsibilities:

• Lead & coordinated testing on multiple projects & Managed testing of concurrent projects through multiple releases.
• Coordinated across all internal and external groups that will be involved and/or participating in the testing effort.
• Obtained a complete understanding of the project and work with stake holders to develop test materials.
• Act as a Confidential with the project team(s) & end user to ensure testing deliverables are met on time.
• Coordinated resources and task assignments with teams as it relates to the assigned area
• Collaborated with the Project Team members to explore, prioritize and resolve the issues discovered through the test cycles.
• Manage Testing Builds and Releases going into Regression testing, UAT and Production.
• Performed interactive walkthroughs of test scripts with developers, business users and Business Analysts.
• Performed Component/ API / SOA / Web Service testing using STF SHAM call that uses SOAP & tracing soap messages with tcpmon
• Created STF test automation scripts in XML format with custom fixtures, using the STF framework in UNIX platform.
• Tested the mobile payment Confidential apps in Android and iOS.
• Involved in manual testing, automated testing and back-end testing by using the SQL.
• Involved in developing & manageing test plans, resource plans and timelines for the project
• Coordinated end to end testing with clients and functional teams
• Responsible for test planning for Agile / Scrum, Test Harnesses and TDD
• Involved in mobile commerce testing specially in Android and iphone
• Verifying the logs for integration between TEP/PRS/PSS and the Thunderbird engine
• Responsible for data migration and ETL data warehouse testing
• Tested several Informatica Mappings to validate the business conditions.
• Written Test Cases for ETL to compare Source and Target database systems.
• Ability to work well with both the onsite and offshore testing teams to get the work done.
• Used IBM Rational's ClearQuest for defect tracking and Clear Case for version control .
• Detecting and classifying bugs based on the severity, tracking them to closure on a timely manner
• Prepare Test summary report, Defect report, Test Execution status report and matrix data
• Creating the Test Completion Report & Participated in defect reviews.
• Ensure the appropriate signoffs at the end of each stage of testing

Environment: Windows 7, Unix, C++, Schema, WSDL, XPATH, Clear Quest, DataStage, ERWin, Hudson, Clear Case, SOAP, XML, STF, Visio, Java, RQM, Android, iOS, Informatica, VMware, Business Object (BO), Agile, Scrum, Jira, Java, JDBC, Share Point, J2EE & Oracle10g/11g.

Confidential, MA

Sr. QA Consultant

Responsibilities:

• Single point of contact for manual and automated testing for the multiple products of super media such as Super Pages, Every Car Listed and Local Search.
• Consistently provided prompt and efficient results by meeting critical deadlines
• Tested the Super pages mobile application for multiple Blackberry models and compatible with the U.S. Cellular.
• Performed back-end or database testing by passing SQL Queries to retrieve data.
• Performed the cross browser testing; verified IE browser compatibility using IE Tester tool
• Performed Black Box, Manual testing & Usability Testing based on the functional requirements and product specification.
• Tested the Single Sign on between Super pages, Every Car Listed and Super Guarantee websites.
• Performed UAT & integration testing with the Face book, Super Guarantee, Every Car Listed and Mobil applications
• Tested the Every Car Listed iPhone App.
• Developed and executed automation scripts using QTP. Used DTS for data transformation
• Tested the Single Sign on (SSO) between Super pages, Every Car Listed and Super Guarantee websites.
• Verified SSL security for Log in, Registration and Profile modules
• Review Functional Specification Document and tracked requirement issues to closure. Actively discussed open requirement issues with client and team in the weekly meetings

Environment: Window, Unix, Java, JDBC, Visio, J2EE, .Net, ASP, C#, Flex, XML, Agile, Scrum, Microsoft Visual Studio (VSTS), Team Foundation Server (TFS), PHP, HTML, Web Sphere, REST, SOAP, T-SQL, SQL Server 2008 and QTP.

Confidential, NY

Sr. QA Consultant

Responsibilities:

• Involved in the review of B.R.D, Functional Technical Specification docs. Coordinated with all stake holders including Business users, Business Analysts, Development team Design sessions to get hold of the Applications under test well in advance.
• Involved in creating the Test Plan, Test scripts for various applications to perform the System, Integration, and End-to-End testing.
• Mapped the test cases to the requirements, stored on Quality center tool for traceability purposes.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Attend requirements and design meetings to gather testable requirements. Execute test cases to validate new and existing functionality of various modules, business logic and to determine the report performance issues.
• Debugging the SQL-Statements, stored procedures for various business scenarios & Involved in debugging the PLSQL code.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Used Actuate (Wealth Management) & Business Object Report (BO) tool for generating the reports for the stock trading.
• Verifying the reports against the functional & technical requirements & Validating the data in the report against the source house & staging database
• Conditional testing of constraints based on the business rules & Create and execute Unix/SQL scripts to help in test validation
• Tested several Informatica Mappings to validate the business conditions.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked as ETL Test Analyst and responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Did complex data validation using SQL queries for extracting data from multiple tables.
• Analyzed User requirements attended Change Request meetings to document changes and implemented procedures to test changes.
• Extensively used SQL to perform Data integrity testing & Involved in debugging the PLSQL code
• Generate requirement traceability matrix & updated management with reports to track testing progress
• Coordinating with Development Team and Deployment Team to get the builds on time and deploying on to the QA Environment Successfully.
• Tested data migration to ensure that integrity of data was not compromised.
• Performing workflow tests at the integration level after new build is incorporated
• Performed End-to-End testing manually & Followed the Scrum Methodology
• Closely worked with developers and System Engineers to nail down the technical problems
• Involved in preparing test data for UAT and participated in UAT signoff

Environment: Teradata V2R6, TOAD, Windows XP, Confidential Quality Center 9.2 (QC), Oracle 10G, Business Objects XIR2, SQL Server 2005/2008, SQL, PL/SQL, ETL Tools Informatica PowerCenter 8.1, Visio, T-SQL, SQL Server 2005, XML, XSLT, XSD, XML Spy 2008, Shell Scripting, TOAD, UNIX, VB Script, Actuate (Wealth Management Tool), DataStage, ERWin.

Confidential, Palo Alto, CA

Sr. QA Consultant

Responsibilities:

• Involved in the review of req. doc, Functional Technical Specification docs. Coordinated with all stake holders including Business users, Business Analysts, Development team Design sessions to get hold of the Applications under test well in advance.
• Attended the review meeting for the Business Requirement Documents (BRD) & Design Documents.
• Work closely with Business Analyst (BA), Business Intelligence team (BI) & Offshore development team (ODC) to form a unified team. Troubleshoot applications issue and investigate enhancement/new requirements requests.
• Participated in the development of Test Plan & was actively involved in writing Test cases for the CCM module with references to Use Cases, Design Documents & Business Requirement Documents.
• Involved in creating the Test Plan, Test scripts for various applications to perform the System, Integration, and End-to-End testing.
• Functional & Regression testing under various environments Like Microsoft Window & UNIX.
• Verified the encryption & decryption process by running the Unix script for Credit Card, eFinance & Gift Cards no’s.
• Performed database testing by executing the SQL Queries to check the data & Involved in debugging the PLSQL code.
• Used Test Director to record the test cases.
• Automated functional and regression test scripts using Quick Test Pro
• Executed Automated Test scenarios for GUI, Functionality, and Regression Testing using Quick Test Pro. The testing scripts were devised into different Actions and Sub Actions and stored as per the requirement of the Test Plan and Test Cases in the Test Suit Framework.
• Involved in developing automation test scripts, data driven and user defined functions in QTP for Regression Testing
• Used PVCS bug tracking system to report the defects & also used the configuration management tool.
• Tested the Telephone Order Management Interface (TOMI) from hard phone to softphone networking part.
• Performed database testing by executing the SQL Queries to check the data.
• Performed cross browser testing on various browsers like IE, Firefox & AOL to verify browser compatibility
• Performed Ad-hoc testing, Integration testing, End-to-End testing, System testing, Function testing, and User Acceptance testing.

Environment: Windows XP, Unix, C++, SecureCRT, TIBCO, PHP, HTML, QTP, JDBC, Java, .net, #C, JSP, J2EE, Quality Center, BEA WebLogic, Oracle Client, MQSeries, Tode, Visio, LoadRunner, SQL Server, PVCS, Web Services (SOA), SharePoint, .Net, Clear Quest.

Confidential, Denver, CO

QA Analyst

Responsibilities:

• Responsible for Functional and Regression testing of the financial and order management modules of the J D Edwards OneWorld applications.
• Involved in testing the module like Fixed Assets, General Ledger, Real Estate, Job Costing, Inventory, Order Management, Manufacturing & Procurement modules.
• Involved in Acceptance testing of JD Edwards EnterpriseOne & EDI Balancing testing.
• Develop and execute automation scripts using Autopilot 2.5 tool
• Involved in Functional & Regression testing for Enterprise Sales Planning & Forecasting (ESP) module.
• Functional & Regression testing under various environments Like NT, UNIX (AIX, Confidential ) & AS400.
• Responsible for building, running & analyzing Batch Scripts, through Remote desktop connectivity & Terminal server.
• Involved in testing the advanced pricing module which involved Rules Based Pricing (RBP).
• Troubleshooting & Debugging autopilot scripts for Logistics, Inventory, Sales Order Management, Transportation and Procurement modules
• Executed Automated Test scenarios for UAT, GUI, Functionality, and Regression Testing using Quick Test Pro. The testing scripts were devised into different Actions and Sub Actions and stored as per the requirement of the Test Plan and Test Cases in the Test Suit Framework.
• Manual testing (Thin & Fat client) for Financials, Inventory, Sales Order Management, Transportation, Manufacturing and Procurement modules.
• Wrote SQL, PL/SQL queries to access the data from the database tables and crosscheck the results.
• Carried out data validations using stored procedures and SQL scripts.

Environment: Windows XP, OneWorld Application, QC, Autopilot 2.5 & Test Manager, Web Logic, Net Support Manager, QTP, Citrix, Oracle Client, SQL Server 2000 Client, AS 400 Client.