PROFESSIONAL SUMMARY:

• Software Testing professional with over 9 years of experience in the creation of Test Strategies, Test Plans, Test Scenarios, Test Case, Script Execution, Traceability Metrics and Status Reporting in various domains such as Healthcare, Federal, and Banking, where software development projects were implemented in Agile / Waterfall ( V - Model) principles .
• Have worked on global compliance measure like Dodd Frank act in Confidential with various applications and vendors like Hogan, SVP, SVT, Zoot, Web Confidential, RDS, COBRA, and POS.
• Certified Government Treasury Bonds and Shares which is a part of Capital Market.
• Able to quickly adopt and well versed in new areas (Technologies, Tools).
• Expertise in Functionality Testing, System Integration Testing, User Acceptance Testing, and End-to-End testing, with excellent communication and interpersonal skills.
• Has ability to handle multiple priorities and manage various projects within deadlines, by analyzing new functionality and identifying potential areas of impact.
• Provided resource allocation, requirements gathering, set up test environment, data management, and managed budget.
• Experienced in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environment.
• Passionately worked towards enhanced project knowledge of self and the team. Performed as an amicable team player as well as individual contributor.
• Triaged test execution results and validated the results against the product requirements. Logged defects where ever needed. Maintained and enhanced existing test scripts which are used during development and QA cycles.
• Gained Experience as ETL Tester in Informatica Power Center, SSIS, Data warehouse along with GUI based autosys job scheduler.
• Experienced in testing SQL statements using SQL Developer, and SSMS tools to retrieve data from Dimensional, FACT, and STAGING tables of Data warehouse as per requirements.

TECHNICAL SKILLS:

Testing Tools: ALM 11.00, Quality Center 9.x, Test Director 8.x, QTP 8.x, Silk Test, Rational Suite Test Studio, MKS 2009, WinRunner 8.x, LoadRunner8.x, Rational Clear Quest, Rational Robot.

Languages: T-SQL, PL/SQL, Visual Basic4.0, VBScript, C++, Cobol, JAVA

Web Technologies: SharePoint, HTML, XML, .NET, OpteView(TM).

Middleware: Servlets, JDBC,ODBC, Active Server Pages (ASP)

Database: MS-SQL 2000,2008, Oracle 11g, Sybase 10.x, FoxPro 2.5, MS Access 97

Operating System: Windows 95/98/NT/2000/XP, DOS, UNIX, Linux 7.0, Unix(Solaris)

SQL Testing Tools: SQL Developer 4.1, SSMS 2008, TOAD

Tools: Informatica 8.x, SSIS, Autosys job scheduler 11, MS Project, Visio, MS Word, Excel, Power Point, Open Office, UML, MS Dynamics Confidential

PROFESSIONAL EXPERIENCE:

System QA Analyst

Confidential, Charlotte, NC

Responsibilities:

• Performed Backend SQL code testing using SSMS tools to retrieve large volume of data from Dimensional, FACT, and STAGING tables of MSSQL Data warehouse .
• Scheduled autosys jobs to execute the scripts to perform ETL process via SSIS from several Confidential databases to FACT and STAGING tables in testing region of data warehouse.
• Tested, monitored and took actions in scheduled jobs along with dependency jobs by using several action method such as force-start, auto terminated and put job on-ice, off-ice, on-hold and off-hold per Testing Plan.
• Created test cases and requirement coverage into the test management tool called ALM by learning the stories related to the Confidential application.
• Created traceability matrix for the test lead to keep track of the progress.
• Prepared test scripts which support scenarios identified in system requirements and inputting these in ALM (QC), to perform end to end testing.
• Logged defects, reproduce the defect with the development team, retest the issues and support the testing effort throughout application deployment.

Environment: ALM 11, MSSQL 2008, SSMS 2008, SSIS 2008, Autosys 11, MS SharePoint, MS Dynamics Confidential

QA Analyst

Confidential, Charlotte, NC

Responsibilities:

• Provided system requirements, supported test automation, created test plans, test cases, developed data requirements, executed test cases, and reported the results to the upper management in an organized fashion using ALM- MKS and MS office products.
• Co-ordinated international resources, obtained daily status from them, pull out report in Quality Center and present it to the client. The daily status included - defect management (number of defects fixed, planned to be fixed, number of defects closed) - Scripts execution status per project, daily number of scripts passed, scripts in no run status. Made sure that the projects met the timeline.
• Compiled operations analytics on a daily, weekly and monthly basis by developing accurate dashboards and reports of OS2 and Fleet ATMs systems.
• Analyzed business processes to identify problems and implemented solutions that improved the business process.
• Communicated and presented technical solutions for business problems to line of business.
• Worked closely with development teams to foster successful releases and assist them in implementation of the test deliverables to ensure all software products meet organizational standards.
• Prepared test scripts in the test management tool called ALM which supported scenarios identified in system requirements.
• Developed test Automation Assets and provided test scripts traceability back to requirements. Prepared test environment involving both hardware and software configuration.
• Troubleshoot issues found in the products, which included analyzing the codes, categorized them correctly, logged defects and retested the issues and supported the testing effort throughout application deployment.
• Identified opportunities for process improvement in conjunction with Business Analysts and Managers, by writing procedural job aids for new business processes and reporting.
• Communicated well with users, management, team members, and present data in a clear and concise manner that is easily understood. Maintained a professional attitude and flexible schedule toward excellence in work.

Environment: QTP 9.2, Oracle 11g, Java, Unix, MS SharePoint, .NET, OpteView(TM). Internet Explorer 6.0, XML, Mercury Quality Center 9.2, MS Excel, VB Script

QA Analyst

Confidential, Charlotte, NC

Responsibilities:

• Created use cases by learning the flow chart of the Confidential application.
• Tested PL-SQL codes using sql developer tool per end-user testing requirement
• Tested and scheduled autosys jobs to perform ETL process for transferring data to Dimensional, STAGING, FACT tables of Data warehouse.
• Created quality test conditions and test scripts by analyzing the requirements, design, business scenarios and conditions identified for the application. Quality test scripts covered all the required functionality, accurate navigation steps, input/localized data, and expected results.
• Identified the test data and other requirements for test conditions and test scenarios.
• Executed scripts according to the defined testing process, which included execution of completing java and Unix scripts, documenting actual results, defects and test case/ script status and participated in defect resolution process.
• Created traceability matrix to keep track of the progress, and modules for automation.
• Recorded risks and issues in accordance with the project's problem and made various methods to resolve those issues.

Environment: Rational Functional Tester, Oracle 11g, SQL Developer, Informatica 8.x, Java, Unix, MS SharePoint, MS Excel

Confidential

Responsibilities:

• Reviewed, analyzed Requirements, high level and low level design documents to create test deliverables including test plan, scenarios, and test scripts.
• Actively interacted with technology teams, business analysts, and developers to obtain testing scope, timelines, and clarifications.
• Coordinated testing efforts across multiple applications and releases simultaneously.
• Provided estimates for number of Test scripts and its execution time; forecasting testing times and resources for multiple initiatives.
• Coordinated and managed offshore, near shore teams with all testing activities - overlook creation, scheduling, & execution of test scripts, defect management in Quality Center. Made sure that the projects met the timeline.
• Ensured test coverage for all the requirements using test coverage matrix. Tracked and resolved Testing issues and Risks. Led Defect Meetings and Defect Triages.
• Communicated regular testing status to all the stakeholders - business, technology and testing teams to meet their expectations and obtain sign offs.
• Assisted Release Manager in various releases as a Release Coordinator.
• Wrote test scope, test strategies, test plans, test scripts, uploaded scripts on Quality Center and executed scripts, ran the reports and validated the reports.
• Certified Microsoft Hot Fixes, Production Fixes, Government Treasury Bonds, Adobe fixes in various zones like California, Model, Mid West and North West servers, before the packages goes in production. This is done on an onshore - offshore model.
• Set up the servers and the workstations at the frontend and the backend for the application for every release
• Conducted the estimation for the project, resources allocation according to the business partners’ allocated budget.
• Co-ordinated, managed and managed, onshore and offshore resources, got the daily status from them, both manual and automation, pulled out report in Quality Center and present it to the Client. The daily status included - defect management which included daily number of defects fixed, planned to be fixed, number of defects closed. - Scripts execution status per project, daily number of scripts passed, scripts in no run status.
• Coordinated with developers, functional testing team, Line of Business, Gasper, the Confidential vendors such Confidential, Confidential and Confidential .
• Clarified client requirements, business needs and project objectives using MS tools like as Visio diagram and MS project, Excel, via client meetings, with all stakeholders.
• Conducted business analysis, project assessment and feasibility determination, with large team of project managers, developers, testers, architects, and users by applying professional efforts in a prioritized manner to ensure all projects met their milestones.
• Worked with software installation team to install, upgrade, and patch Confidential software tools in the various windows based Confidential desktops and servers.
• Trained the users to verify the transactions, made sure they knew what error messages meant, analyzed them, then logged defect, and escalated them to proper channel.

Environment: MS SharePoint, QTP 9.2, NET, OpteView(TM). Internet Explorer 6.0, XML, Mercury Quality Center 9.2, MS Excel, VB Script, Oracle 10g, Java, Unix,