SUMMARY

• A Personable, focused and self - motivated individual with 6+ years of Software Quality Assurance and 4+ years of Software Development experience, in Financial (Bank), Health Care, Retailer Systems and Public Sectors of Information Technology.
• Extensive experience in Functional, Regression, Smoke, Performance, User Acceptance (UAT), Integration/System, Load, White and Black Box Testing phases in Manual and Automation modes.
• Expertise in Data Warehouse, Business Intelligence, and ETL tools Informatica, BO Data Integrator/Data Services, and Data Stage. Strong experience in RDBMS - Oracle, Teradata, MS SQL Server, DB2, PL/SQL.
• Software Testing Life Cycle (STLC).
• Agile (SCRUM) with TDD and ATDD, RUP and Waterfall Methodologies.
• QA Automation with Selenium Web Driver and QTP.
• Client-Server, Integration Environment and SOA based Architectures.
• Web Service, Database and Web Application Testing.
• Strong Development and Database background.

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

Quality Assurance Analyst

Responsibilities:

• Actively participate in 3 Week Sprints in Agile Methodology with Acceptance Test Driven Development (ATDD).
• Lead, Mentor and Coach QA team of 4 members within Agile team.
• Closely work with Developers, Business System Analysts (BSA) and Product Owners to nail down any testing Impediments.
• Track testing activities through Jira, the Agile Project management tool. Assign and maintain Stories/sub-tasks during the Sprint.
• Write, Test, Maintain Test Cases to show complete test and requirement coverage in ALM.
• Test different Web Services, Database and Front End Applications.
• Carefully analyze the test results on SOAP responses from the databases and make reports as required.
• Develop, Maintain and Enhance Automation Regression Suite for Web Services and GUI applications using Eclipse and SVN/Maven Repositories. Used Selenium Web Driver for WEB/GUI Automation.
• Reduced lot of manual scripts and implemented Automation for most scenarios to reduce regression testing time and increase the test accuracy.
• Lead Test Data Set up and maintain datasheets for Automation suite.
• Responsible to maintain Jenkins builds for DEV/QA Automation Suites.
• Participate in Automation checkpoint calls for any suggestions/issues with Regression suite.
• Coordinated with different teams while Migration/Upgrade of Automation tool to Selenium Web Driver.
• Maintain a Macro to post Automation results from Jenkins to ALM directly.
• Often check Server logs using Putty, WinScp, Jumphost and Splunk to get more details on the testing issues.
• Report Defects in Jira/ALM and participate in Defect Triage.
• Run DEV/QA/UAT Installs/Builds using QuickBuild.
• Coordinate with other Agile teams to resolve any gaps in the requirements.
• Help Performance, Load and UAT members with functionality queries.
• Document Automation related tips/troubleshooting notes in Confluence.
• Participate in shakedown/sanity checks during UAT/BreakFix Repoints.
• QA Support during Production Releases.
• Randomly support different QA activities across Agile teams within the Block.
• Generate Traceability Matrix reports from ALM at the end of each Sprint.

Environment: Selenium WebDriver, Java, Web Services, SOAP UI, Eclipse, SVN, Maven, X-Path, X- Query, XML, Quick Build, Jenkins, Jira, Jconsole, Splunk, FAST DS, Confluence, Control - M, Wily, HP ALM, Oracle, SQL Developer, NX, Jumphost, Jboss 4 and 6, Putty, WinScp, Unix, Visual Basic, Livelink, Share Point

Confidential, Camp Hill, PA

Technical Test Analyst

Responsibilities:

• Participated in JAD sessions to understand requirements and test Scenarios.
• Maintained requirements in Req.Pro.
• Extensively used Rational Quality Manager to write Test Cases/Scripts and executing them.
• Created child test plans, Test Environments, test schedules and Test Execution Records in RQM.
• Responsible for data preparation to test the application as per the pre-conditions and validated the post-conditions and record the results of each test case/script.
• Extensively worked on testing DB2 databases for CPR, CMR and ICIS builds using Teradata SQL Assistant and Mainframe IBM Rational Host-On Demand.
• Conducted Unit, Component Integration, Functional System tests.
• Created/Reported defects in Clear Quest.
• Maintained the business documents and test scenarios/testcases/testscripts/results in company’s collaborative site, the Share Point.

Environment: IBM Rational Quality Manager 2.0/3.0, IBM Rational functional Tester 7.0.1, IBM Rational Requisite Pro 7.1.2, Cleat Quest 7.1.2, Teradata SQL Assistant, IBM Rational Host-On Demand, DB2, Oracle 11g, Teradata, FTP/SFTP, Java, XML, IBM Mainframe, Share Point, MS Office.

Confidential, Mechanicsburg, PA

Sr. Quality Assurance Analyst

Responsibilities:

• Reviewed Business Requirement documents and Technical Specifications thoroughly and involved in planning, coordinating and executing project testing tasks.
• Written test cases corresponding to business rules and other operating conditions.
• Manual Scripting is done for the test cases on the UCMS application and execution in Rational Manual Tester.
• Worked on Automation of UCMS application using QTP.
• Used Object repository for handling the creating objects as and when required.
• Generated smaller scripts which help in reusing the scripts as needed.
• Used data pool for feeding the data to the scripts.
• Prepare data to test the application as per the pre-conditions and validated the post-conditions and record the results of each test.
• Used Clear Quest to log and maintain defects.
• Ran Batch Process and Job schedulers in the back-end for applications to create tasks for the end users
• Tested of backend objects like BPELs, MDBs, which calls various Web Services, individually through Jmeter scripts and SOAP Requests.
• Extensively tested External Interfaces though Data Stage Mappings and In-Out files. Cross check them in database.

Environment: HP QTP 11.0, IBM Rational Manual Tester, Java, HTML, XML, SOAP UI, Oracle 10g, DB2, Windows XP, WinSCP, MS-Office, Ascential DataStage, SQL Developer, WPS, WAS, MQ Series.

Confidential, Chevy Chase, MD

QA Analyst

Responsibilities:

• Developed standard SQA process templates for Test Plan, Test Cases and Defect Guidelines.
• Managed QA tasks, requirements and defects in HP Quality Center.
• Developed and implemented Quality Center Standards.
• Used PL/SQL to verify Back-End database integrity testing.
• Developed and executed functional test cases for a Web Feature Service using QTP.
• Used Quick Test Pro to automate a regression test suite of 200 test cases resulting in 85% reduction in test execution time per build.
• Wrote user Defined Functions in Library Source Files and Header files and enhanced scripts using QTP.
• Performed regression testing (used QTP) and formal acceptance tests for delivered systems and product upgrades.
• Used SQL queries to double-check the expected results based on test plans.
• Performed Integration testing and System testing and performance testing as well.
• Scripts are developed using modular method, where most of the scripts are reused.
• Implemented Traceability Matrix to trace test plans back to the requirements.
• Performed Smoke tests in most of the cases.

Environment: QTP 9, HP Quality Center 9.0, .Net, Windows, UNIX.

Confidential, Brentwood, TN

Data Warehouse/ETL Developer & Tester

Responsibilities:

• Contributed in Requirements Analysis, Design, Implementation, Testing of Ecommerce and Data Warehouse.
• Involved in coding different types of dataflows, ETL jobs for various requirements using Data Integrator (DI) Designer XIR2/ Data Services XIR3
• Participated in converting PL/SQL jobs into ETL and thus reduce the job running time in production
• Extensively worked migrating, Test and Deploy of the ETL job from XiR2 to upgraded version XiR3
• Performed Extensive Unit Testing of BusinessObjects Reports for Data Accuracy.
• Performed Extensive pre UAT Testing of BusinessObjects Reports.
• Contributed in developing and generating complex, Adhoc, Flash Sales Reports, Business views, List of values.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks

Environment: Business Objects Data Integrator XI R2/ Data Services XIR3, Business Objects Enterprise XiR2 for Reporting, Oracle 10g, Toad, Tidal Scheduler, HP Quality Center 9.0, PL/SQL, SQL *PLUS 10.2, Spectrum, Putty, Windows NT, Linux.

Confidential, Waukesha, WI

ETL Developer/ Associate Systems Engineer

Responsibilities:

• Design and Develop Informatica Mappings with different transformations including Source Analyzer, Lookup, Filter, Expression, Aggregator, Stored Procedure, Lookup Transformations and more
• Involved in Code Review, Unit, Integration and Regression Testing of mappings and Workflows
• Developed test cases/scripts using Mercury Test Director.
• Highly involved in tracking, monitoring defects and defect documentation using Mercury Test Director.
• Executed Test scripts in Test Director.
• Month end reconciliation of Order and Sales data from DWH to Sales compensation application.
• Involved in debugging of Mapping and other components like unix scripts.
• Fine tuned Transformations and mappings for better performance
• Job scheduling and monitoring in Redwood Cronacle
• Reconciliation of data after each phase development and testing
• Performance tuning of mappings and sessions

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, Teradata 5.0, Redwood Cronacle 5.6, PL/SQL Developer, Queryman, Mercury Test Director 8.0,Windows NT, Solaris