Resume of QA Analyst

Title
QA Analyst

Primary Skills
QA, Testing, SQL Server, ETL, Data Modeling, Oracle, T-SQL, SQL, PL/SQL

Location
US-MI-Farmington Hills (will consider relocating)

Posted
Jun-06-07


Experience Summary:

· Over Five years of experience in Quality Assurance, Design, Development and Implementation of Client/Server & Web based applications.
· Complete understanding of Quality Assurance Life Cycle (QALC), QA Methodology, QA Strategy and Software Development Life Cycle (SDLC).
· Working knowledge of ISO 9000 standards.
· Extensive experience in Test Plan and Test Strategy
· Extensive experience in programming and executing test cases using Rational Robot, Win Runner and QTP.
· Experience in developing and maintaining test artifacts including Test Plans, Test Cases, Bug Reports, Bugs using Test Director, Quality Center, Rational Clear Quest and Bugzilla.
· Good experience in testing Insurance, Financial, Banking, Telecom and Health-Care applications.
· Experience in Project Management, Business Analysis and Documentation.
· Experience in documenting the testing process using MS-Office tools including Word, Excel and MS-Project.
· Involved in various tests like Functional Testing, Regression Testing, Database Testing and Integration Testing.
· Strong experience in SQL-Programming for various databases like Oracle and SQL Server.
· Possess good programming skills in T-SQL, SQL and PL/SQL.
· Developed complex Stored Procedures, Triggers, User-Defined Functions and Packages in SQL Server T-SQL environment.
· Comfortable working with Oracle 9i - PL/SQL programming and SQL * Plus
· Worked on Logical and Physical data modeling and other design review sessions to determine and describe data flow from source to target databases by coordinating with Business Analysts, DBA's and Application Architects
· Good command in modeling using CASE tools like Erwin & ER/Studio and building reports using Business Objects.
· Good knowledge in datawarehousing, data modeling and database management systems
· Good knowledge in creating ETL objects using Informatica & DT/Studio.
· Experience in testing various applications under UNIX and WINDOWS XP/ NT/98/2000 environments.
· Involved as active team member in the projects so far done.
· Extensively involved in System Testing, GUI, Load Testing, Performance Testing, Volume/Stress Testing and White Box Testing.
· Maintained good relations with development/management team.
· Excellent verbal / written communication and interpersonal skills
· A self-starter, team player, worked on fast-faced development environments committed to the deliverables.
· Excellent Communication, Analytical and Problem solving skills.

Skills:

Languages: Java, C, C++, XML and VB
Defect Tracking Tools: Bugzilla, Quality Center 8.2, Test Director and Rational Clear Quest
Automated Tools: Rational Robot, Win Runner and Quick Test Pro
Operating Systems: UNIX, Windows NT 4.0/XP/2000/2003
Databases: Oracle 8i/9i, SQL Server 2000/2005 and Ms Access.
Database Programming: T-SQL, SQL and PL/SQL.
Reporting Tools: Business Objects 6.5/XI
Data Modeling Tools: Erwin and ER/Studio
ETL Tools: Informatica, DT/Studio, Ab-Initio (GDE 1.14.2.6) and Co>Operating system (2.10)
Version Control: VSS, CVS.
Packages: MS-Office


Education:

· BS in Computer Science and Engineering

Certification:

· International Software Testing Qualifications Board (ISTQB)


Professional Experience:

Embarcadero, CA
Dec 05 -- Till Date
Sr. QA Analyst/ ETL Developer

Description: Embarcadero's DT/Studio is an ETL tool that helps companies to integrate corporate data from disparate data sources.

Responsibilities:

· Performed Installation Testing of the application on different Operating Systems and Browsers.
· Created ETL tasks for several data sources.
· Extracted data from different data sources (Oracle, SQL Server, Sybase, DB2, Teradata, Informix, MySQL 4.x/5.x, Flat Files, JMS, CDC and XML's etc.) and Loaded the data into target OLTP systems by performing Transformations based on the business requirements.
· Deploying the created ETL tasks to Java-based DT/Engine.
· Troubleshooting the problems involved in the deployment of ETL tasks using DT/Console.
· Generating HTML and RTF reports for different data flow tasks based on the business requirements.
· Created Logical and Physical data modeling in ER/Studio tool, importing those business models into the DT/Studio tool and comparing them with the existing models.
· Performed Compatibility Testing with different relational database management systems.
· Performed Ad-hoc, Functional and Regression Testing of the application.
· Created and executed automated test scripts using Test Director and Quality Center.
· Developed Test Plan, Test Cases and Test Scripts.
· Executed regression scripts by using Rational Robot automation tool.
· Performed Black Box and White Box Testing.
· Strong experience in developing complex Stored Procedures, Functions, Triggers and Packages using SQL and PL/SQL.
· Written SQL queries and Database checkpoints to verify data quality.
· Involved in Database Testing for databases like Oracle, SQL Server, Teradata and DB2.
· Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
· Prepared weekly/monthly productivity reports.
· Created testing metrics using MS-Excel
· Defects were tracked, reviewed and analyzed using Bugzilla.
· Performed IST (Integrated System Testing), regression testing on different operating systems and browsers.
· Interacted with developers for all stages of the Testing Life Cycle

Environment: Windows XP/2000/2003, UNIX, Japanese OS, Chinese OS, Java, DT/Studio, DT/Engine, DT/Console, ER/Studio, Oracle, SQL Server, T-SQL, SQL, PL/SQL, Bugzilla, Test Director, JDBC, Rational Robot, Quick Test Prof, Manual Testing, Visual Source Safe 6.0, Microsoft Office.



JP Morgan Chase, Oh
Oct 04 - Nov 05
ETL Developer/ QA Analyst

Description: The project involved merging of Reader's Digest's Young Families business into the BHE data mart. This requires the BHE Data Mart to be ready for RDYF's reporting usage

Responsibilities:

· Preparation of Test Plan which specifies Testing Overview, Testing approach, Testing strategy, roles & responsibilities and scope of testing
· Test Scripts were developed after reviewing business requirements documents and technical specifications
· Bug Verification and giving walk through with the developer's about open bug's status on weekly basis.
· Defect Tracking records for each build and reporting the bugs using Test Director and Bugzilla.
· Conducted Regression Testing before and after the code conversion using Rational Robot.
· Interacted with Business Analysts, Developers and QA team members in different defect raising situations.
· Presentation of QA Status reports and Defect Status reports in weekly meetings.
· Performing queries to the database using T-SQL to check successful transaction & to create particular test cases
· Developed subject area graphs based on business requirements using various Ab Initio components like Filter by Expression, Partition by Key, Partition by round robin, Run SQL, Reformat, Join, Gather, Merge, Rollup, Scan, Replicate, De-dup sorted and database components like Update Db Table, Input Table, Output Table.
· Extensively used Ab Initio functions like is_valid, is_defined, string_substring, string_concat and other string functions etc.
· Developed Data transformation, loading, scrubbing and extraction programs using Ab initio ETL tool.
· Developed Ab Initio graphs for Data validation using validate components.
· Wrote Stored Procedures to convert data logically as per the business requirements.
· Used Scalar User Defined Functions in SQL queries to retrieve calculated values.
· Interacting with users and troubleshooting the problems involved with the development of Stored Procedures and Triggers.
· Tested this application on different configuration systems like Windows 2000(server), Windows XP, and Unix

Environment: Ab Initio GDE 1.14.2.6, Co>operating system 2.10.11,Rational Robot, Manual Testing, Test Director, Bugzilla, Windows 2000(server)/XP, UNIX, SQL Server 2000/2005, T-SQL, Query Analyzer, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, JMS, XML, and UNIX


EDS, TX
Feb 04 -- Sept 04
QA Analyst

Description: This project offers a variety of consumer lending and deposit products, including credit cards, installment loans, small business loans, auto loans etc.

Responsibilities:

· As part of the QA team we tested more than 8 releases. These releases were prioritized depending on the business needs and the criticality involved.
· Involved in Manual Testing of the application.
· Reviewed and analyzed business requirement documents, technical requirements and functional specification of various functionalities.
· Experience in Test Plan formulation from requirements, Test Scenario creation from use-cases, and Test Case design from design document.
· Involved in writing Test Plans based on Business rules and functional specification documents.
· Performed Black Box Testing and White Box Testing of the application.
· Extensively used T-SQL, SQL and PL/SQL in writing SQL queries, Stored Procedures, Triggers and User-Defined Functions.
· Involved in writing the test cases and test conditions from the use cases and the business specs.
· On execution of each cycle, validated the test results using the SQL queries and also looked at the generated actuate reports.
· Generated different types of reports for various businesses needs using Business Objects.
· Worked on Inform atica tool to create ETL tasks for various business applications.
· Extensively worked with Informatica Lookup, Update Strategy, Sorter and Union transformations to deliver the business solutions to the customers on time as per the requirements.
· Coordinated with the team in preparing the test data and analyzing the output data.

Environment: Windows XP, SQL Server, Oracle, Business Objects 6.5, Informatica, T-SQL, SQL, Microsoft Project, MS Office, Word, Excel, Manual Testing, Bugzilla.

Certifications
International Software Testing Qualifications Board (ISTQB)


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-MI-Farmington Hills »
View all resumes in US-MI »

View other QA Analyst resumes, Tester / QA resumes