SUMMARY

• Over 10 years of progressive experience in the Information Technology industry with emphasis on Quality Assurance in web based client/server applications, ETL/Data Warehouse implementations and Data Analysis.
• Experience working in Health Care, Directory Publishing, Telecommunications, Communication Services and Hospitality industries.
• Experience in all aspects of the Software Development Life Cycle with specific focus on testing.
• Involved in Project Planning, Test Planning, Coordinating and implementing various QA methodologies such as Waterfall, Rational Unified Process (RUP) and Agile.
• Hands on experience with Business Intelligence, Data Warehousing concepts, OLTP, OLAP, Dimensional Modeling (Star and Snowflake schema).
• Strong working experience in Data Analysis/Data Verification of ETL Applications, Back - End/Database Testing using complex SQL queries.
• Lead various software testing projects along with execution of testing processes, test strategies, test plans, defect documentation and regression testing.
• Experience in mentoring, coaching, guiding and managing junior testers in the team.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Experience in creating and reviewing the Requirements Traceability Matrix with project team to confirm test coverage and acquire necessary approvals.
• Experience in performing automated tests using Mercury Interactive tools such as QuickTest Professional 9.2 and HP ALM Quality Center 11.0.
• Experience in manual and automated White-Box/Black-Box testing techniques. Functional, Regression, System, Integration, User Acceptance, Parallel, Web Services and ETL/Data Warehouse testing.
• Experience in programming with Visual Basic 6.0/5.0, VBScript, SQL, PL/SQL, and UNIX.
• Experience in working with J2EE, XML, HTML/DHTML, C, and C++.
• Sincere, well-organized, quick learner, ability to deal with change with good interpersonal and leadership skills.
• Effective Team Player with excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Testing Tools: QuickTest Professional 9.2, HP ALM Quality Center 11.0, CM Synergy 6.3 Telelogic Doors 7.0, Toad 11.5, DBVisualizer 5.1.1, AQT 8.2.8, SQL Developer 4.1.1

Scripting Tools: VBScript, JavaScript, Perl, XML

Languages: C, C++, JAVA, Visual Basic, SQL, PL/SQL, HTML/DHTML

Operating Systems: Windows 98, 2000/XP/7, UNIX

Database: Oracle9i/10g/11g, MS Access 2003, DB2, MS SQL Server 2005, Netezza, PostgreSQL

ETL/Reporting Tools: Ascential DataStage 7.5.1A, Ab Initio, Cognos 1.1 MR2, Microstrategy 9

Web Servers: Microsoft IIS, Apache Tomcat 5.0.28, Sun Java System Web Server

Utilities: MS Office Suite, Eclipse, JCreator

PROFESSIONAL EXPERIENCE:

Confidential, GA

Senior QA/Data Analyst

Responsibilities:

• Perform System/Parallel/Data Validation testing and analysis for the Just in Time Rating (JiTR) project.
• Read and analyze the requirement specification documents to create Test Strategy and Test Plan documents.
• Conduct Test Plan reviews, knowledge transfer meetings, generate defect and test results reports.
• Create, document and execute manual test cases in HP ALM Quality Center 11.0
• Create, track and manage defects, gather and report quality metrics and analyze the collected data.
• Assign tasks, mentor and train team members of the testing team.
• Perform end to end data verification and data analysis of customer/subscriber information flowing from Vision to UBSR to JiTR/RBM systems.
• Verified the Usage Broker (UB) Customer/Subscriber Seeder workflow process developed to load the current customer/subscriber data from Vision into the Usage Broker Subscriber Repository (UBSR) and the Rating and Billing Manager (RBM) Oracle 11g database tables.
• Verify and analyze the Usage Broker (UB) Customer/Subscriber Reconciliation workflow process created to reconcile customer/subscriber data changes between Vision, UBSR and RBM database tables.
• Verify that the raw usage files are configured into RBM rate-able event files by the Usage Broker (UB) Rating Interface Workflow (RIW) as specified in the Vision to UB to RBM mapping document.
• Execute RBM’s Usage Rating jobs and processes to rate the event files using UNIX commands.
• Verify/Analyze the rated or rejected usage by querying the UBSR and RBM Oracle databases using SQL queries.
• Verify/Analyze error codes/exceptions from the customer/subscriber Seeder and Reconciliation workflows using SQL queries.
• Monitor application logs and retrieve information using UNIX commands to analyze and report error codes and exceptions.

Environment: HP ALM Quality Center 11.0, J2EE, Oracle 11g, SQL Developer 4.1.1, SQL, PL/SQL, UNIX, PuTTY, WinSCP, Microsoft Office 2007, MS SharePoint.

Confidential, Atlanta, GA

Senior QA Analyst

Responsibilities:

• Ensure that the QA process is documented and communicated and adequate to ensure agreed quality levels for the application in an AGILE environment.
• Work with the Agile Scrum master to plan and prepare for testing, monitor testing progress and ensure testing is being assigned for a particular module area.
• Create, track, estimate and manage tasks and defects in Rally/HP ALM Quality Center.
• Create, document and execute manual test cases in HP ALM Quality Center 11.0
• Perform functional and regression testing on the eleven IHG hotel brand websites.
• Create/Record automated test scripts using Selenium IDE for testing.
• Convert the Selenium IDE test scripts into Java unit tests using the implemented automation framework.
• Monitor application logs for exceptions using UNIX commands.
• Verify/Test logging, caching and throttling techniques using the MX4J Java Management Console.
• Test different application web services/methods/request invocations using an in-house tool called FuncTester.
• Execute cross browser testing using Internet Explorer, Firefox, Chrome and Safari browsers on all IHG brand websites.
• Execute cross platform testing using Windows and MAC operating systems for all IHG brand websites.
• Write SQL queries to verify the hotel, price, payment and reservation information in the Oracle 11g database.
• Execute Single Sign-On (SSO), Internationalization(I18N) and Localization(L10N) testing on the different hotel brand sites
• Build/Deploy/Revert the project code using Hudson to test environments as and when new code is available and ready for testing.

Environment: HP ALM Quality Center 11.0, J2EE, JavaScript, CSS, UNIX, PuTTY, Windows XP/7, Microsoft Office 2007, Rally, Oracle 11g, Apache 2.2, Resin, Akamai, Hudson

Confidential, Charlotte, NC

Lead ETL QA/Data Analyst

Responsibilities:

• Analyze and review business requirements from business analysts, developers and system analysts for a thorough understanding of the application.
• Worked closely with the architects, developers and business analysts to clarify/understand functionality, to resolve issues and provide feedback in an AGILE software development life cycle environment.
• Design and develop test plans/scenarios to satisfy the functional and architectural requirements of the application.
• Verify all test results to ensure the system is performing functions as described in the business acceptance criteria.
• Provide estimates for tasks and mitigated issues in a lead role for the testing team.
• Manage, assign tasks, mentored and train the team members of the testing team about the ETL applications.
• Verify multiple ETL(Extract, Transform and Load) applications like SBASE, SBASEAE, SQA, CDW, SCDW, HCDW, I3 and ACDW by executing table count check, data transformation check, Not Null check, Duplicate record check, Primary Key(PK and Foreign Key(FK) check between source and target databases.
• Verify the Fast Pub table copy process developed to copy tables over to different databases across different environments using SQL queries and UNIX shell scripts.
• Verified the scheduled Autosys batch process jobs run within the datawarehouse environment using SQL queries.
• Identify ETL test data/ units of work in the source databases and put them on queue for every ETL run.
• Develop complex SQL queries and UNIX shell scripts to perform source-to-target verification of the Ab Initio ETL graphs.
• Verify the data on the MicroStrategy Reports with the data in the data warehouse.
• Create, document, execute test cases, track execution and maintain the test suite using HP Quality Center 10.0
• Created, track and manage tasks/stories/defects using JIRA.

Environment: HP Quality Center 10.0, J2EE, JavaScript, MicroStrategy 9(Reports), Oracle 11g, Netezza, PostgreSQL, Ab Initio(ETL), UNIX, Autosys, Microsoft Office 2007, JIRA, Subversion, SQL, PL/SQL, Advance Query Tool(AQT)

Confidential, Atlanta, GA

Lead QA Analyst

Responsibilities:

• Prepare and review Test Plan and Test Strategy documentation to ensure they were clear and testable.
• Involved in creating test cases from the test plans and identifying test scenarios and test harnesses of varying complexity.
• Provided realistic and reliable project estimates to the project management team.
• Lead a team of four testers and carried out lead tasks like assigning the applications, reporting on the applications and decision making regarding the status of the applications.
• Closely interacted with product management, business and development teams to ensure effective project execution.
• Worked with the data management team for creating and managing test data created from various sources.
• Used Mercury Quality Center 9.2 to create and execute test cases, track execution against the plan during testing and manage defects from inception to resolution.
• Involved in functional and regression testing of the jPayment payment processing application.
• Created complex SQL queries perform end to end backend testing to verify payment and transaction data.
• Tested and verified the front end web pages, screen navigation, data entry/data retrieval and performed backend database testing.
• Involved in functional, regression, white-box and black-box testing of Remedy - Action Request System, Streamline intranet, TMobile.com and MyTMobile.com web based applications.
• Involved in functional and regression testing of the CSM component of the Amdocs Samson 9.20 billing application.

Environment: Mercury Quality Center 9.2, MS SharePoint, J2EE, ASP, VB, HTML, JavaScript, Power Builder v 10.2.1.9004 , SQL, Microsoft SQL Server 2005, UNIX, Windows XP and Citrix Metaframe.

Confidential, Birmingham, AL

Senior QA Test Analyst

Responsibilities:

• Reviewed design documents and business requirements to learn the function and scope of the applications.
• Developed test cases, maintained the test suite and tracked defects using Mercury Quality Center 9.2.
• Created test cases for the Medicare hospital Outpatient Prospective Payment System (OPPS) regulations for the calendar year 2008 set by the Centers for Medicare Medicaid Services (CMMS), implemented in the Surgery applications.
• Tested the administrative and clinical processes from scheduling, registration, clinical documentation and inventory management to billing, collections and revenue cycle management for Ambulatory Surgery Centers and Surgical Hospitals on SurgiSource, AdvantX and Vision applications.
• Data Verification of UB04, UB92 and HCFA state reports for different states in the U.S for Vision, AdvantX and SurgiSource applications.
• Used SQL Query Analyzer to access the database to retrieve and verify and test data.

Environment: Quality Center 9.2, Microsoft Window Server 2003, Microsoft SQL Server 2005 SP1, Microsoft.NET, Visual Basic 6.0, Crystal Reports, C++, XML, Visual SourceSafe 6.0.

Confidential, Newton, MA

Lead QA Analyst

Responsibilities:

• Conduct reviews for business requirements and functional specifications of the web portal application.
• Set test schedules, generated test results reports, defect reports and assigned tasks to members of the team.
• Trained and lead a team of four testers.
• Created metrics for meaningful presentation of testing progress.
• Developed test artifacts from Requirements (Use Cases and Supplementary specifications) for the application.
• Managed all types of change requests, defects, enhancements, issues and documentation changes with a flexible workflow process.
• Implemented and developed test cases, test scenarios, test strategies and test plans of varying complexity, ensuring accurate coverage of requirements and business rules.
• Created test cases, maintained and executed the test suite using Quality Center 9.2.
• Involved in creating automated scripts to perform functional and regression tests using QuickTest Professional 9.2.
• Developed SQL queries to retrieve the test data from the database using DBVisualizer 5.1.1.
• Used PuTTY to view and monitor the Tibco application log files.
• Worked closely with the development/business to meet deadlines for the project.

Environment: Quality Center 9.2, QuickTest Professional 9.2, SQL, PL/SQL, UNIX, Oracle10g, DBVisualizer 5.1.1, Apache Tomcat 5.0.28, Windows XP, MS SharePoint, Tibco.

Confidential, Denver, CO

QA Test Analyst

Responsibilities:

• Reviewed business requirements and functional specifications of the applications.
• Managed all types of change requests, defects, enhancements, issues and documentation changes with a flexible workflow process.
• Involved in the testing and implementation of functional, regression and system testing.
• Developed, maintained, executed test scripts and tracked defects using Mercury TestDirector 8.0.
• Developed automated test scripts to execute functional and regression tests using Mercury QuickTest Professional 8.0.
• Reviewed detailed design specification documents, created and executed test cases to test Cognos reports.
• Data verification using SQL queries of reports developed using the Cognos reporting tool for the National Datamart project.
• Developed and executed complex SQL queries to perform backend testing using TOAD 8.0
• Verified/Tested the Extract, Transform and Load (ETL) applications/jobs created using the Ascential DataStage tool for the RHD integration project.
• Tested the Keystone ACMS (Advertising Content Management Solutions) delivery module by creating items/charges on the CRM application and validating them on the database.

Environment: TestDirector 8.0, QuickTest Professional 8.0, J2EE, SQL, PL/SQL, JavaScript, UNIX, DB2, Oracle10g, Toad 8.0, Cognos 1.1 MR2, Ascential DataStage 7.5.1A, Apache Tomcat 5.0.28, Windows XP.

Confidential, Atlanta, GA

QA Test Engineer

Responsibilities:

• Incorporated the best practices, methodologies as advocated by the Rational Unified Process (RUP) to develop a structured approach during the Software Development Life Cycle.
• Implemented and developed test cases, test scenarios, test strategy and test plans of varying complexity, ensuring accurate coverage of requirements and business rules.
• Created test scripts, executed, and maintained the test suite using TestDirector 8.0.
• Involved in creating automated scripts to perform system tests, functional and regression tests, user acceptance tests, smoke tests, cross-platform and cross-browser using QuickTest Professional 8.0.
• Executed tests for cross-browser and cross-platform testing on Windows and MAC operating systems using VMware Console 3.1.
• Created SQL queries to retrieve and verify data from the Oracle database using TOAD 8.0.

Environment: QuickTest Professional 8.0, TestDirector 8.0, VMware Console 3.1, J2EE, SQL, JavaScript, UNIX, Oracle9i, Toad 8.0, CM Synergy 6.3, Telelogic DOORS 7.0, MAC OS 9 and OS X, Windows 98, ME, XP, 2000.