PROFESSIONAL SUMMARY:

• 8+ years of diversified experience in Quality Assurance Analysis / Business Analysis of stand - alone, legacy, client-server and web-based applications.
• Team player with an excellent interpersonal, verbal and written communications skills, and ability to work well with a diverse team as well as ability to work independently and with minimal supervision
• Participated in requirements Analysis reviews, Business reviews and working sessions to understand the requirements and system design.
• Experience in executing projects in AGILE methodology using ATDD and BDD approach as an Automation and Manual tester using Ruby Cucumber automation framework with Gherkin tests.
• Developed rich expertise in Mortgage, Financial, Commercial Loan and Investment industries.
• Strong knowledge in Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
• Working knowledge of consumer lending, credit/debit card operations (Origination, Maintenance, Inquiry, Security, Embossing, Batch Processing, ATM Transactions).
• Experience in developing business based Functional Test Scenarios
• Thorough understanding of QA Methodologies and tools and SDLC processes
• Proficient in developing and executing Test Cases/Test Scripts, Defect Management and Documentation of Test Case Results.
• Good working knowledge with JIRA and Selenium.
• Extensive experience with Web service (SOAP, JSON, REST) API Testing.
• Hands-on experience in using test management and defect tracking tools such as Jira, Bugzilla, Mingle, HP Quality Center and Confluence.
• Extensive experience in client server and web based application testing including Java API Testing manual and automated software testing techniques,
• Extensive experience in testing Mainframe applications
• Expertise in Manual Testing of applications developed on Windows and UNIX Environment
• Creating test database and data driven for Client/Server and Web-based applications with Manual and Automated testing tools like HP Quality Center, Sword, QTP and Rational tools for functional testing.
• Proficient in writing SQL scripts for Corporate Data Warehouse’s larger amounts of data
• Very strong in SQL, PL/SQL
• Proficient in writing SQL queries in SQL Plus and TOAD
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Experience in testing Online Transactional and Analytical Processing systems.
• Experience in back-end testing with SQL queries
• Tested the web pages manually as well as using automated tools like Selenium for image positioning and display quality.
• Extensive experience in analyzing business and system requirements.
• Experience in Robust Defect tracking and reporting.
• Extensively used MS Office for project documentation.
• Effective inter-personal and communication skills, team
• Extensive experience in System, UAT, Integration, Regression, End-to-End and Back-End Testing
• Expert proficiency in Manual testing using Mercury’s Quality Center, Rational tools include Test Manager, Doors, Clear Quest and Clear Case

TECHNICAL SKILLS:

Operating Systems/Languages: Windows 98/ME/XP/7/8/10, UNIX, C, C++, JAVA, SQL, VB

Quality Standards: Implementation knowledge of ISO 9001 & ISMS (Info. Security Management System)

QA/Testing: Functional, API Testing, Data Driven Testing, Staging Website Integration and Environment Validation testing. Testcase and use case scenario

Conversant: with Web Technologies - HTML, ASP, XML, DHTML, VB script, Java script, Java Servlets, JDBC, Applets

Documentation Tools: MS-Office, MS Project.

Test Automation Tools: Selenium, Ruby, HP QuickTest Pro, Perfecto Mobile, HP QC, HP ALM, Jira, Bugzilla, Mingle,AdventNet Q-Engine and Load Runner, Mercury Interactive Win Runner, Load Runner, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Sr. QA Analyst

Responsibilities:

• Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
• Reviewed test assignments, developed test plan and scripts, and conducted tests as assigned.
• Executing the jobs and validating the reports and output files as per Test Cases
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Tracked bugs and reported issues and defects using JIRA.
• User acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Manually tested and GTS modules using HP Quality Center.
• Report, track and verify defects usingALM.
• Tested the Web Service for payment processing, tested their WSDL file (Schema, Port Types, Messages, SOAP binding, and Ports).
• Used XML Spy during the testing of Web Service's so as to understand the WSDL file and also for making use of several XML related technologies such as XSLT, Xpath, XQuery, XML Schema.
• Maintain test matrices on various dimensions like client and test status to reflect the test progress.
• Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
• Backend testing team performs the API testing of REST Web services using tools like Soap-UI and Poster. API testing validates the JSON output with the expected output, and also compares the JSON output with XML input.
• Used Agile and ATDD methodologies for achieving deadlines.
• Validating SOAP requests as well as XML requests and responses in the back end after every transaction through the EPSI CON GUI.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Develop framework to test SOAP based Web Services using JUnit and TestNG.
• Used Quick Test Pro’s Data Table, to manipulate the data sets and create multiple test scenarios.
• Responsible for business units consolidated general ledger inclusive of preparation month end closing, including adjusting, closing and balancing accounts, journal entries, account reconciliations, inter-company analyses, and balance sheet, income statement, and cash flow analyses
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Coordinating with other teams like planning, applications, Environment and Media
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Involved automated activities to improve the existing processes.
• Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Test Director.
• Involved and responsible for creating weekly status reports regarding the progress of testing process.

Environment: Db2, HTML, HP Quality Center, HP ALM, JIRA, SOAP, REST, XML, WSDL, Oracle 11i/12c, WebLogic, unix, Javascript, Teradata, MS Word, MS Excel, MS Visio, Informatica, LoadRunner, WinRunner

Confidential, Oklahoma City, OK

Sr. QA Analyst

Responsibilities:

• Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
• Reviewed test assignments, developed test plan and scripts, and conducted tests as assigned.
• Executing the jobs and validating the reports and output files as per Test Cases
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Providing testing coordination and project management support for multiple projects.
• As part of Test coordinator responsibilities, determined and define system specifications, process improvement, quality assurance, interaction with customers and technical staff.
• Worked on Credit card Authorization, EMV testing, Overlimit modules.
• Tracked bugs and reported issues and defects using JIRA.
• User acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Manually tested and GTS modules using HP Quality Center.
• Report, track and verify defects usingALM.
• Maintain test matrices on various dimensions like client and test status to reflect the test progress.
• Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
• Backend testing team performs the API testing of REST Web services using tools like Soap-UI and Poster. API testing validates the JSON output with the expected output, and also compares the JSON output with XML input.
• Used Agile and ATDD methodologies for achieving deadlines.
• Employed a variety of technical tools to design applications for the Wealth Management system including: SQL, DB2, QMF, JCL, FTP, GDG, MS Excel, VB Macro, and PLI.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Used Quick Test Pro’s Data Table, to manipulate the data sets and create multiple test scenarios.
• Responsible for business units consolidated general ledger inclusive of preparation month end closing, including adjusting, closing and balancing accounts, journal entries, account reconciliations, inter-company analyses, and balance sheet, income statement, and cash flow analyses
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Coordinating with other teams like planning, applications, Environment and Media
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Involved automated activities to improve the existing processes.
• Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Test Director.
• Involved and responsible for creating weekly status reports regarding the progress of testing process.

Environment: JIRA, Db2, HTML, HP Quality Center, HP ALM, JIRA, SOAP, REST, Oracle 11i/10g, WebLogic, unix, Javascript, Teradata, MS Word, MS Excel, MS Visio, Informatica, LoadRunner, WinRunner

Confidential, Atlanta, GA

Sr. Tester / Business Analyst

Responsibilities:

• Core responsibility involved complete manually testing of the application under test (AUT)
• Followed software testing methodologies and plans to ensure software product quality.
• Analyzed Business requirements, module specific functionality’s, identified testing requirements and formulated Test plans, Test cases and Test scripts and documented them in Test Director.
• Responsible for gathering requirements, writing functional specifications, creating use cases and developing prototypes for conversion projects supporting multiple lines of business including Commercial, Investment Bank, Private Bank and Retail Bank.
• Has worked extensively in Empower/LoanSphere doc solutions.
• Studied the application flow, data to be used for exercising the different functionality’s and created Test cases for functionality, GUI, boundary and error testing. Test cases were documented and executed through Test director.
• Provide attorneys guidance and needed documentation and clarification on systems in MSP and Loansphere.
• Involved in testing Web services and XML with tool ‘SOAPUI’.
• Designed and tested a variety of applications to increase the efficiency and effectiveness of systems functionality and reporting capabilities on the Bank's Loan IQ, system. (Loan IQ, is a vendor-provided software widely used by financial institutions to track loan related data).
• Responsible to re-engineer the Loan IQ reporting solutions (Data Net) to a more reportable solution with enhanced performance and flexibility to 3rd party software integrations.
• Defined and performed the test strategies and associated scripts for the verification and validation of the application and ensured that it meets all defined business requirements and associated functionality.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies wat data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Executed test cases manually and reported bugs using HP Quality Center
• Worked on the customizing and prepping the jobs for the Test execution
• Executing the jobs and validating the reports and output files as per Test Cases
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Provided the management with test matrices, reports and schedules as necessary and participated in the design walkthroughs and meetings.
• Executed automated test case and scripts using QTP for the Front-end-applications and analyzed the results.
• Did API Web services testing using SOAP UI tool.
• Responsible for maintaining Test Director setup and configuration including setting up the project, users, groups and their permissions, custom fields and lists, defect state transition rules.
• Participated in requirements meetings, writing requirements in CaliberRM, converting requirements from Caliber RM to HP Quality Center
• Inserted Check Points to check the broken Links, Text, and standard properties of an object using Quick Test Pro.
• Tested various Service Oriented Architectures (SOAs) spanning across various web services using SOAP and WSDL.
• Tracked bugs and reported issues and defects using JIRA.
• Performed sanity testing on new builds prior to venturing into systems testing
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Validated database contents using SQL Queries.
• Created a variety of reports as Word Documents through Test Director’s Document Generator. Used Bug status reports, defect age reports in weekly team meetings.

Environment: Mainframe, Rational Tools, HTML, Oracle 10g, Unix, Teradata, Window 7/8, DB2, MS Office, MS Project, SQL, SOAP, REST, HP QuickTest Pro 10, JIRA.

Confidential, Pittsburgh, PA

QA Tester

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Test plan was developed in Test Director.
• Designed, developed and delivered a bespoke product planning as part of Client’s product offering. Key inputs into database architecture, design, testing and implementation.
• Responsible for following through processes from front to back end to ensure profitable, timely, and high quality completion of integration testing and quality assurance of a Client/Server project.
• Created Test plans, Test Cases, Test Scenarios as per the specs for data warehouse testing as well as web testing.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Interact and negotiate with Vendors to complete the tasks related to data conversion
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducted GUI and functionality testing using QTP for ATM testing.
• Conducted data driven testing using QTP to conduct backend testing.
• Prepared Test Data for Positive and Negative Testing which is used in Data Driven Test.
• Involved in database testing.
• Following Acceptance Test Driven Development (ATDD) approach in Agile Team.
• Built APIs with Salesforce.com Apex SOAP/REST Services.
• Test Case creation in the HP Quality Center / ALM Test Case repository.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Performed all phases of test cycle including unit and integration testing, regression, functional, stress, load, and performance testing.
• Worked extensively with systems architects, and development engineers to identify system design and implementation problems, as well as providing technical support and guidance, and product improvements
• Used SQL to collect the data from within the DB2 databases
• Performed browser-compatibility testing of the Application on IE and Netscape Navigator.
• Conducted Regression Testing on various builds of the application and reported the defects to the developers using Test Director.
• Tested different links for the users to navigate through the site with hyperlinks.

Environment: Mainframes, Unix, Rational Tools, XML, HP ALM, SOAP, REST, Quality Center, Oracle and SQL, Teradata, Informatica, IMS DB, DB2, Command Center

Confidential, Detroit, MI

QA / Business Analyst

Responsibilities:

• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Followed software testing methodologies and plans to ensure software product quality.
• Design and develop new processes to handle the merger between the clients and ultimately establishing the operational general ledger on the target platform
• Respond to user requests, troubleshoot dashboard/report issues, document procedures, design, develop, implement and maintain complex Business Intelligence applications
• Studied the application flow, data to be used for exercising the different functionality’s and created Test cases for functionality.
• Used Test Director and HP Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Defined and performed the test strategies and associated scripts for the verification and validation of the application and ensured that it meets all defined business requirements and associated functionality.
• Provided the management with test matrices, reports and schedules as necessary and participated in the design walkthroughs and meetings.
• Execution of PL/SQL on MS-ACESS in order to view successful transaction of data.
• Validated database contents using SQL Queries.
• Used Bug zero to report the defects and reports in weekly team meetings.
• Defined Quality Assurance requirements, and established advanced testing standards and methods. Designed and developed a full life-cycle hardware and software test environment.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, Quality Center, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner

Confidential, MI

QA Analyst

Responsibilities:

• Understanding the product functionalities & the product
• Creating Test Cases for various application in the product
• Performed GUI Test, System Test, User Acceptance Test (UAT), Compatibility Test and Performance Test. Planned, designed, implemented and executed test strategies, test procedures, test plans, and test cases according to specification given.
• Involved in Integration and Regression testing using QTP.
• Was responsible for creating both positive and negative test cases using Test Director.
• Developed automated test scripts using QTP.
• Created tests using both recording and programming.
• Participated in developing and implementing End-End testing manually.
• Involved in Regression & Alpha / Beta Tests.
• Was responsible for defect tracking, reviewing, analyzing and comparing bugs using Test Director. Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Prepared the Defect reports and interacted with developers for Debugging.
• Extensively used SQL queries to perform backend testing in the Oracle Database to check whether the required data is fetched.
• Analyzed, compiled and documented the product, financial report and financial line calculation requirements, coordinating meetings and presenting information to the Oracle Development Team.

Environment: Test Director, AS/400, JAVA, J2EE, Oracle9i, Java Script, JHTML, HTML, XML, Visio, WINNT, UNIX, SQL, PL/SQL, WEBLOGIC.