Senior QA analyst and Developer Resume

SUMMARY:

Over 12 + years of experience in the IT Industry as a Senior QA analyst and Developer in the various Data warehouse / Business Intelligence applications.
Extensive experience in Manual Testing of ETL and BI applications in Integration Testing, System Testing, Performance Testing, Functionality Testing, Post - Implementation Testing and Regression Testing.
Exposure to Financial, Finance and Insurance, Health Care, TV Rating, Telecom, Sales domains with regards to Data Warehouse Testing.
Good experience in XP, Agile, V, Scrum and Waterfall Methodologies.
Expertise in design and development of test scenarios and Test cases to validate all the requirements.
Have good skills in all phases of Testing including test estimation and team management.
Good understanding of data warehouse development and testing methodologies and ETL concepts.
Proficient in ETL testing and methodologies like control mechanism of the batch loads, generation of error logs, loading and processing of rejected records, testing of SCD 2 implementations - ensuring surrogate key integrity and checking process dependencies.
Strong experience in various versions of ETL tools like Informatica, Data Stage, Sunopsis and good understanding with Ab Initio.
Strong experience in various versions of Reporting tools like Business Objects, Actuate, Web Focus and Cognos.
Proficient in various databases like Oracle, Netezza, DB2, SQL Server, MS Access, Sybase ASC, Sybase IQ and Teradata.
Extensive experience in writing complex SQL Queries, Analytical SQL, PL/SQL and T-SQL statements.
Proficient in T-SQL queries DDL/DML
Strong experience in various operating systems like UNIX Shell scripting and Windows XP/NT/2003/2000.
Excellent Debugging, Data Analysis, problem solving and communication skills along with string verbal and written skills.
Exceptional analytical and problem solving skills, communication skills, strong decision making skills and organization skills.
Experienced in developing custom tools in java for automating the load process and validating target tables for regression tests.
Expertise in automation of ETL process by various tools like Quality Center, Test Director, Clear Quest and Bugzilla.
Extensive experience in coordinating with off-shore Team and onsite projects.
Sound experience in Knowledge Transfer and Mentoring whenever required.
Good sense of teamwork, leadership quality, integrity, aptitude to learn and ability to put in sustained quality effort consistently.
Excellent Team player with good communication skills and coordination in team meetings.

TECHNICAL SKILLS:

RDBMS: Oracle, Sybase, Sybase IQ, DB2, Netezza and SQL Server

Testing Tools: Win-Runner 7.0, Quick Test Pro 9.0, Fitnesse, Selenium, Quality Center 8.2 and Bugzilla

ETL/BI Tools: Informatica PowerCenter 6x/7x/8x/9x/10.1, Sunopsis 3x, Datastage 7x, Business Objects 5.0, Actuate, Web Focus and Cognos, AbInitio

Languages: COBOL, VB 6.0, PERL, T-SQL and PL/SQL

Operating systems: Windows 2000/XP/NT, Sun Solaris, UNIX AIX/Linux

Scripting Language: Java Script, VBScript, XML, Unix Shell Script

Development Tools: DB Visualizer, WinSQL, Toad, Erwin, Power Designer, Control-MMS-Word, WS-FTP Pro, MS-Excel, MS-Access, PVCS, WRQ Reflection, Hummingbird V8.0, Putty, SharePoint and SAS/BASE,SAS/STAT,SAS/GRAPH,SAS/ACCESS,SAS/CONNECT

PROFESSIONAL EXPERIENCE

Confidential

Senior QA analyst and Developer

Responsibilities:

Proficient in ETL testing and methodologies like control mechanism of the batch loads, generation of error logs, loading and processing of rejected records, testing of SCD 2 implementations - ensuring surrogate key integrity and checking process dependencies.
Strong experience in various versions of ETL tools like Informatica, Data Stage, Sunopsis and good understanding with Ab Initio.
Strong experience in various versions of Reporting tools like Business Objects, Actuate, Web Focus and Cognos.
Proficient in various databases like Oracle, Netezza, DB2, SQL Server, MS Access, Sybase ASC, Sybase IQ and Teradata.
Extensive experience in writing complex SQL Queries, Analytical SQL, PL/SQL and T-SQL statements.
Proficient in T-SQL queries DDL/DM

Confidential

Data warehouse / Business Intelligence

Responsibilities:

Proficient in ETL testing and methodologies like control mechanism of the batch loads, generation of error logs, loading and processing of rejected records, testing of SCD 2 implementations - ensuring surrogate key integrity and checking process dependencies.
Strong experience in various versions of ETL tools like Informatica, Data Stage, Sunopsis and good understanding with Ab Initio.
Strong experience in various versions of Reporting tools like Business Objects, Actuate, Web Focus and Cognos.
Proficient in various databases like Oracle, Netezza, DB2, SQL Server, MS Access, Sybase ASC, Sybase IQ and Teradata.
Extensive experience in writing complex SQL Queries, Analytical SQL, PL/SQL and T-SQL statements.
Proficient in T-SQL queries DDL/DM

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship