SUMMARY:

• QA Analyst with more than 14 years of IT experience in Telecommunications, Healthcare, Insurance, Banking and Engineering domains.
• More than 10 years experience in Functional, Application, White box, Manual, Unit, Integration, UAT, Commissioning, Verification and Regression testing.
• Experience in data verification and validation with SQL.
• Extensive experience in SDLC including Software Programming, Analysis, Design, Coding, Testing, Implementation and Maintenance in Data Warehousing, Client - Server and Web environment.
• Extensive experience in Test Management, Automation and defect tracking tools (QA Director, HP Quality Center/ALM, Test Partner and Track Record)
• Experience in testing database applications, GUI and web applications with Oracle, MS SQL Server, and ETL tool (DataStage).
• Experience in Test Strategy, Planning, Designing, and Execution, Risk based testing and reporting.
• Extensive experience in coordinating with the SME/business/development teams in understanding the requirements and the application under test.
• Experience in Projects using Agile and Waterfall methodology, an incremental approach to deliver projects

TECHNICAL SKILLS:

Systems: UNIX, Windows NT/XP/2000/98/95, PTN

Databases: Oracle 6.0/7.x/8.0/9i, MS SQL Server 2000/7.0/6.5 , MS Access

Tools: DataStage 7.5 / 8.0,Compuware QA Director, HP Quality Center (QC 9.2), Test Parmer (Automation Tool), VMware4.1, Reconcile File Aid/ CS, QALoad and Track Record, PVCS, ALM, SQL Loader

Reporting Tool: Oracle Reports 4.5/5.0. Developer 2000, Cognos 8.0

Applications: PTN, SCADA, AFC

Languages: SQL, PL/SQL, Java Script, VB Script, ASP, Oracle Forms 4.5.

Bachelor of Science: Electronics and Telecommunications Engineering .

Post Graduate Diploma: Management

EMPLOYMENT HISTORY:

Confidential

QA Analyst/Lead

Responsibilities:

• Reviewed Telecom application software design, BRD and QA Test Plan with Business users.
• Conducted Unit, Integration, Acceptance, Commissioning and Installation tests for Telecommunication systems and it’s integration with software applications including Radio, Public Address System (PAS), Public Information Display System (PIDS), Access Control, Supervisory Control and Data Acquisition ( SCADA) System, PTN (Networking) and CCTV applications.
• Provided inputs for test efforts, time and resources for application under test to Test Manager
• Captured requirements, maintained traceability matrix, created defects reports and enforced standards in HP Quality Center/ALM.
• Created and maintained traceability matrix for application under test.
• Wrote and executed test scripts for System testing, CAT/UAT (black box), Regression and commissioning tests.
• Provided regular status updates to stakeholders, vendor and finalized QA specifications.
• Worked in scrum and Agile environment.
• Verified data quality and validated data with SQL in Oracle and SQL server tables.

Environment: Windows XP, Unix, PTN

Tools& Applications: SQL Server, MSOffice, SQL, Oracle, AFC, HP Quality Center/ALM, PTN, AFC

Confidential

QA Analyst

Responsibilities:

• Analyzed and mapped data coming from TSYS and Core mainframe through ETL, evaluated testing requirements and wrote ETL test cases in QC for Internal Fraud Risk credit card application of Chase.
• Verified and validated data with SQL in target tables.
• Executed Cognos Reports and ETL test scripts in Quality Center for Chase Credit card processing application.

Environment: Unix, Windows 7, Mainframe, TSYS, VM ware, Oracle 11g

Tools: Cognos 8.0, QC 10.0, Tivoli, MDES, SQL, Compuware Automation tool Test Partner

Confidential, LANSING, MI

Data Analyst

Responsibilities:

• Participated in system requirements and design review meetings.
• Reviewed testing of junior testers and assigned test cases.
• Maintained traceability matrix
• Analyzed data and completed data profiling for new data coming from Meta files.
• Tested data stage ETL jobs for HPDM Data Warehouse.
• Evaluated project specifications, translated the web application and data warehouse ETL job TSD into test conditions and test scripts for Aetna Healthcare web application and Enterprise Data warehouse (EDW) data load.
• Created and added new business and functional requirements in Quality Center.
• Executed SQL queries to validate the completeness, integrity and accuracy of data within an ETL process testing cycle

Confidential, Detroit

ETL Tester

Responsibilities:

• Executed DataStage jobs for Actionable Consumer Intelligence (ACI) project and verified data in target tables in UAT, System Integration and Regression testing.
• Tested ETL jobs data for Dealer, Party, Vehicle Ownership, and Repair order, Promotion Attribute, Email Response etc. in target tables.
• Executed and tested Cognos ACI dashboard reports for functional testing and UAT
• Identified bugs and attended meetings with developers and stakeholders.

Environment : MS Windows, Unix, HPDM, DB2, SQL Server, and Oracle

Tools: DataStage7.5/8.0, Cognos 8.0,SQL

Confidential, GA

QA Specialist

Responsibilities:

• Reviewed Confidential Insurance BRD, FSD, Code, test cases (negative positive and exception) and new requirements for Michigan and Kentucky with business teams and involved in the sign-off process.
• Created Test Plan, traceability matrix for Functional, Regression and UAT testing and added new business and functional requirements in HP Quality Center.
• Worked with the development team to verify defects, produce reports and track defects to closure.
• Wrote and executed repeatable test cases for web based Auto/ Home Insurance Quote and ETL.
• Tested bugs fix and attended meetings with developers for follow-ups.
• Prepared Test reports for all the tested features after execution with different sets of test data.
• Provided test estimates for assigned testing.

Environment : UNIX, Confidential Main frames, Java web application, DB2, Oracle 10g,

Tools: Automation tool Test Partner, Track Record, HP Mercury Quality Center 9.2, and DataStage 7.5

Confidential, Vancouver, NY

QA Analyst

Responsibilities:

• Involved in study/analysis of business functional specifications/SRS document of Personal (credit cards, Insurance, Accounts, Savings, loan, mortgage) and Business Banking.
• Converted use cases / business and functional requirements into test scenarios for UAT with traceability matrix and requirement mapping in Quality Center.
• Led the team in the absence of the project leader.
• Wrote and executed the test scripts in Quality Center for UAT, regression, functional and system testing for web application developed in .NET and Java.

Environment: Windows NT/2000/XP, XML, Unix, Oracle, IIS, SQL Server, Java

Tools: Quality Center 9.x, MS Excel, Word

Confidential

Programmer Analyst

Responsibilities:

• Gathered requirement, coded, tested and enhanced Oracle Reports and Forms for the Confidential and verified data in oracle tables with SQL.
• Analyzed, Coded, Tested and maintained Confidential ’s Global Export Ordering System ( Confidential ) for placing spare parts orders and created SQL server tables for new screens and reports.
• Designed, enhanced, maintained, tested and coded functions in VB script and ASP for the message board, purchase order, order list, archive and batch job query features of Confidential .
• Wrote test plan and test scripts for SIT and followed CMM (Capability Maturity Model)

Environment: MS Windows / NT/Vista, PC/LAN and Mainframe

Tools: SQL, Oracle, SQL Loader, UNIX, SQL Server 2000. VMware 4.1,QALoad, Test Partner, QADirector, Abend-AID Fault Manager 3.2, Track Record 6.02, Quality Center 9.2,Test Partner, Oracle Reports 2.5/3.0/6i, Oracle 7.3/8i/9i/10.7/11i, SQL, PL/SQL, TOAD, Active Server Pages (ASP), JavaScript, MS Excel 2000, Visual InterDev 6.0, VB Script, PVCS, Quality Center, PL/SQL