SUMMARY

• More than 8 years of extensive experiences in the IT industry with emphasis on Business Analysis and Quality Assurance (Manual testing, automated testing and Overall Test Management).
• Excellent Expertise in complete financial software testing of Insurance, Finance and Investment Bank.
• Expertise in Backend Analysis and Testing by writing SQL Queries. Expert in Manual, Automation of Functional & Regression, UAT and Smoke Testing.
• Developing Test Plan, Test Cases, Test Scripts, Business Analysis, Gap Analysis, Test Defect Log, Test Case Checklist
• Extensive work experience and expertise in Business Analysis, Black Box Testing, White Box Testing, UI Manual testing, GUI Automation Testing, Integration Testing, System Testing, Regression Testing.
• Strong knowledge of Software Development Life Cycle (SDLC), Testing Methodologies and Techniques.
• Experience on testing on web based, client server, mainframe and mobile applications. Strong knowledge of SQL - Views, Stored procedure, Functions, Packages,, Joins, Group by, Having, Delete/Truncate difference, Sql loader, Creating reports/ exporting data, Fine tuning queries
• Understanding and Implementation of Agile Software Development Methodologies: - SCRUM.
• Experience in testing database applications of RDBMS in PL/SQL Server and Sybase. Strong knowledge in Table partitioning as well as database design.
• Experience in providing end-to-end solution for data extraction, transformation and loading.
• Extensive knowledge of SQL Server Management Studio for query designing and maintenance
• Experienced in Automation of software testing process using HP Test suite (UFT/Quick Test Pro and ALM/Quality Center)
• Expertise in cloud based testing using AWS (Amazon web services) Expertise in overall test management through Quality Center - Requirements in requirements tab, Test cases in Test Plan, Execution in Test Lab, Defects in Defects Tab.
• Expertise in maintaining traceability in ALM/Quality Center by linking defects to Test cases and Test cases to requirements.
• Expertise in backend testing by writing SQL and Perl Queries. Developed User-Acceptance Test scripts and assisted users in conducting UAT.
• Expertise in testing web services using SoapUI( Restful API) Experience in Business Process Testing (BPT) using Business Components.
• Extensive experience in Extracting Testing and Loading (ETL) Data. Expert in mainframe tools and techniques.
• Have a good knowledge of mainframe programming, test plan, regression testing, and technique. Experienced in Mobile Application Testing (Android and Apple IOS).
• Extensive experience in cross platform(iOS and Android) and cross browser tests configuration on wide range of mobile devices running different OS version configured with a wide variety of hardware capabilities.
• Developed automation testing infrastructure to enable hosting and execution of test cases for mobile devices on Sauce Labs.
• Developed automation BDD tests framework using Cucumber (Java binding), JUnit/TestNG, Selenium, JDBC, and Extent Reports.
• Created test scripts to automate testing of SOAP/ Restful web services using SoapUI pro.
• The BDD test suite was created using Java IDE (InteliJ) and checked into a SVN repository which hosted over Jenkins based Continuous Integration platform.
• Good team player with an ability to lead, manage and work independently. Have a good knowledge of different types of the networks: LAN, WAN, SAN.
• Expertise in working with the methods does SAN for attaching storage to the server. Have a good knowledge of SAN’s architecture to ensure the data availability to all the servers on the LAN as well as WAN.
• Experience working with business users, SME’s, IT technical staff as well as senior management

TECHNICAL SKILLS

Testing Tools: Selenium, QTP/UFT, Quality Center, SOAPUI, Ranorex

Languages: Java, C,C++,Visual Basic, .NET, C#, Perl, Swift

Scripting Language: VBScript, PHP

Operating Systems: Win XP/2000/ Windows 7,DOS

Software Packages: MS Project, MS Visio, UML, Microsoft office suite

DBMS: PL/SQL +, FORMS, Oracle 10g, SQL Server, PostgreSQL

Web Tech: HTML, DHTML, JavaScript, XML, Adobe Dreamweaver

Others: Data Flow Diagrams, ER Diagrams, Relational Data Modeling and UML,ETL, AWS, MS Dynamics 365 CRM

PROFESSIONAL EXPERIENCE

Confidential, OAKS, PA

QA Lead

Responsibilities:

• Tested company’s investment application by writing manual test cases for Portfolio Manager side, Control Manager and Broker Side.
• Tested and analyzed data input to the application from various 3rd party sources like Bloomberg Reuters.
• Worked on different communication infrastructures which provide the physical connections for the data transfer between the computing systems and the storage elements.
• Tested the data, messages from and into the application at various levels to check integrity of data leaving and getting into the application.
• Fine tune procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Worked on Control Trade Manager (CTM) to very trades and make sure allocation from the broker and trade side matches. Used SAN to connect storage arrays.
• Worked with Fibre Channel(FC) Protocols for the easy access of data in various network types.
• Checked various web services by using web services testing - SOAPUI Drive implementation of test process, and tools for a new Client Reporting and Client Lifecycle Management vendor software implementation including test strategies and test plans.
• Load and stress tested both client server and applet based Oracle Discoverer reporting tools
• Provided management and vendor with analysis reports and recommendations
• Load and stress tested a clustered Business Object's Web Intelligence deployment (IIS, Oracle, Sybase, Windows, Solaris Unix)
• Worked closely with OCC (Clearing Firm and Exchange) for testing of complete Trade booking and clearing of Trades in UAT environment.
• Wrote test cases and extensively executed them both manually and automatically for checking compliance rules.
• Lead manual & automated testing activities supporting integrated systems development teams
• Testing of enables accurate real time updating of portfolio and trading management systems for pre-trade, trade, and pre-settlement Worked with development team to fix defects.
• Worked with offshore, daily status update, triage meetings and work assignments.
• Testing SAN protocol to create electronic connectivity to all counter-parties for validating messages (ensuring that mandatory fields are present, verifying data types and verifying valid values).
• Developed test script in UNIX, Functional testing of backend data at server side for finance application in MQ Series and OCC DDS system
• Responsible for migrating the test cases from excel spreadsheets to the Quality center’s repository.
• Developed User-Acceptance Test scripts and assisted users in conducting UAT.
• Responsible for the tasks of testing and evaluating mainframe interactions with distributed system

Environment: XML, Web Services, SoapUI, ALM, UFT MS Office, XML, HTML, Agile, SAP, UNIX, Windows 2000, Ranorex, UFT, SoapUI, CTM, SAN, LAN, WAN

Confidential, Merrimack NH

Sr QA

Responsibilities:

• Gathered requirements, Developed test plan and test cases based on requirements.
• Developed test script for regression, Functional testing of backend data at server side for finance application in Reuters, Wombat, and TIBCO environment
• Lead defect analysis/reporting, prepare test scenarios and scripts, and defect tracking system.
• Implemented defect management, automated regression testing, performance testing, requirement review, code review, release management
• Identified functionality and performance issues, including: deadlock conditions, database connectivity problems, and system crashes under load
• Extensively used UFT for automation testing. Performed load testing by Enhancing test scripts by parameterization, correlation concepts, introducing check points, synchronization points.
• Created Load/Stress scenarios for performance testing using the Load Runner Controller.
• Provide input for systems release readiness reviews, change management/milestone reviews, and business Go/No-Go decision gates.
• Performed web service testing by reading wsdl (XML) in SOAPUI Extensively executed SQL queries on Oracle and SQL/MP tables In order to view successful transactions of data and for validating data.
• Analyzed the data using SPUFI.SQLs are written using SPUFI to query the DB2 database on Mainframe environment
• Developed User-Acceptance Test scripts and assisted users in conducting UAT. Worked on different network type including SAN for the quick and easy data transfer.
• Expertise in Fibre Channel switches to control the loss of the data packets. Worked on the architecture of the SAN.
• Responsible for generating weekly status report and documented complete Release notes.

Environment: ALM, Java, UFT/QTP, Quality Center, BPT, Terminal Emulator, HTML, XML, Mainframe, Agile (SCRUM), CSS, UNIX, BugZilla, .Net, C#, SOapUI, SAN

Confidential, Charlotte, NC

Sr. Systems Quality Analyst

Responsibilities:

• Analyzed Functional Requirement Document to understand the need of upgrading to the new system. Wrote Test scripts for Integration and Regression Testing for different modules and executed them.
• Staged activities and Site data for testing purposes along with verifying environment readiness.
• Created and configured company and user profiles on company’s system and managed account privileges.
• Participated in weekly off-shore team meetings and analyzed weekly Defect reports and Traceability matrix.
• Tracked and logged defects in HP ALM, attended defect review meetings and collaborated with the development team to resolve them.
• Checked and maintained linkage between test cases, requirements and defects in HP ALM.
• Communicated with BA’s during scripting and testing phases for further clarification on requirements on behalf of Test team.
• Assigned Smoke Tests and self to the team to be performed after deployments.
• Modified automation scripts in Selenium Webdriver/Cucumber incorporating Behavior driven development and discussed their reusability for robustness and executed them.
• Executed Smoke tests in Selenium Webdriver and analyzed results/issues in team review meetings.
• Created and enhanced test scripts using keyword driven methodology and descriptive programming.
• Created Feature File Scenario Outline with Cucumber framework. Performed Load testing and monitored HTTP traffic in Telerik Test Studio.
• Executed test cases for Performance testing in Test Studio. Validated XML files using SoapUI.
• Involved with UAT Testing. Involved in setting up Rational ClearCase with Visual Studio for testing environment.
• Participated in walkthroughs and Technical reviews throughout testing phases.

Confidential, Boston, MA

DHW/ETL Engineer

Responsibilities:

• Implemented the strategic plan for support of future company informatics requirements.
• Involved in predefining data mapping from ETL and BI to the relational source and running ad-hoc queries for providing optimized reports.
• Created test strategy for enterprise data warehouse in ETL framework, including business intelligence
• Develop test plans based on test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document (ETL STM).
• Involved in the meetings scheduling in the order to discuss the documented defects logged by the testing team using Quality Centre.
• Fully documented and replicated defects for developers, enabling them to fix defect faster and meet Production deadlines.
• Participated in load testing exercises and tested different reports and assisted development team with testing activities.
• Tested SSRS reports for verifying and validating the data. Performed front-end testing and functional testing using Quality center.
• Used Quality center for developing test cases, test case execution, defect log and defect tracking.
• Extensively used SQL programming in backend and front-end functions, procedures, packages.
• Implement business rules security. Performed automation database and DWH testing.
• Solid testing experience in working with SQL stored procedures, triggers, views.
• Validate the data after running the batch process from different mainframe systems.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads
• Provided technical guidance and support to end-users by developing the documentation required
• Expensively used SSIS for extraction, transformation and loading process Performed the tests in both SIT and test environment
• Extracted data from various sources like SQL server, CSV, excel. Worked on issues with migration from development to testing.

Confidential, Cincinnati, Ohio 

QA Analyst

Responsibilities:

• Reviewed Business and functional requirement documents and detail design documents.
• Performed ambiguity reviews of business requirements and functional specification documents.
• Wrote test cases to implement Desktop Lockbox Deposit (DTLD) and Remote Desktop capture (RTC) using Mercury Quality center.
• Performed manual and automation testing to check the working of Desktop Lockbox Deposit (DTLD) functionality.
• Verified the number of checks to be processed per day in Desktop Lockbox Deposit (DTLD) functionality.
• Validated the end to end scenarios by verifying server DB tables using SQL Queries for accuracy of check information transmitted by scanner.
• Tested Desktop lockbox Deposit application that allowed the customer to deposit checks from the office using scanners
• Tested scanner drivers, Active X controls on different versions of IE browsers, Windows XP, and Windows Vista
• Worked with different scanners as Digital Scanner, Panini, Flat bed, and RDM Coordinated with development team and business users to verify the functionality of application.
• Responsible for matching the HOGAN transaction codes against the database transaction codes and exception handling
• Worked extensively with Wholesale banking Process, Check21 and Backshop maintenance
• Analyzing transaction information and exceptions/error handling through HOGAN mainframe application.
• Created and maintained Customer account data using HOGAN mainframe system. Extracting customer data from HOGAN CIS and screen it against money laundry
• Tested the user interface manually to verify the functionality of various features
• Created GUI Maps to obtain comprehensive information about relevant objects; manually edited the maps as needed
• Conducted System Testing, GUI Testing and Cross Browser compatibility testing during the releases and interacted with the developers to resolve any technical issues.

Confidential, Cherry Hill, NJ

QA Analyst

Responsibilities:

• Followed Agile methodology throughout the project and conducted Scrum meeting with the team members on day to day basis for the update on project status.
• Wrote Test Plan, Test Cases using HPALM and performed internal and external Test Plan and Test Script walkthroughs to accommodate any other scenarios identified.
• Verified environment readiness for testing. Conducted GUI, Functionality and Regression testing on Bill Pay application manually using HPALM.
• Wrote Test cases and performed manual testing for the Remote Image Capture module.
• Performed validation and end-to-end testing on Item processing and Check Imaging.
• Used Hogan CIS (Main Frame Application) and TSO (Time Sharing Option) to validate the customer account transaction information.
• Created test reports and graphs under Dashboard in HP ALM for team reviews.
• Conducted System Testing, GUI Testing and Cross Browser compatibility testing during the releases and interacted with the developers to resolve any technical issues.
• Experience in using HP PPM tool for communication, accessing information and progress reports from time to time
• Studied and learned about Check 21 Act.
• Conducted Manual Testing for IOS, Android and Windows platform.
• Tested the application on a variety of digital and flatbed scanners. Tested scanner drivers, Active X controls on different versions of IE browsers, Windows XP, and Windows Vista.
• Responsible for manipulating the data on Oracle database using SQL queries to simulate different scenarios.
• Performed Browser testing to review the application on different browsers and different platforms
• Involved in Defect review meetings with team members and developers for analyzing defect and fixing the issues.
• Used Jira for Defect Reporting and Defect Tracking. Updated the status to Lead.
• Monitored and prepared progress reports and test summary reports reflecting project and testing status