Summary:
- 7 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications.
- Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
- Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
- Experienced in testing both ETL and BI applications.
- Experienced in both Manual and Automation testing. Extensively used automation-testing tools such as Win Runner, Load Runner and QuickTestPro.
- Experiencein Business Intelligence in generating various reports using Cognos, Crystal Reports, Business Objects and SSRS
- Experience in bug reporting and bug tracking using management tools such as Test Director and communicated recorded problems to the responsible QA or development personnel.
- Adept in using testing tools like Test Director, HP Quality Center, Quick Test Professional to write and maintain automated Test scripts
- Experienced in DW projects ETL testing against DW testing with Informatica and data stage tools.
- Strong Skills in using Integration, Functionality, Regression, Performance, Stress and Configuration Testing.
- Extensive experience with Functional, GUI, Database, Stress, Volume, Regression, Load and Performance Testing.
- Strong SQL query Analyzer skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
- Was involved in setting up the test environment, created test data as per the requirement.
- Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
- Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, MS Access, Flat files into a staging area
- Good working experience on testing ETL, Reference Data and BI
- Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata
- Experience in testing and writing SQL and PL/SQL statements.
- Automated and scheduled the Data Stage jobs using UNIX Shell Scripting.
- Experience in all phases of Software Development life cycle.
Technical Skills:
QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology
QA Tools: Hewlett Packard (HP) – Quality Center, Test Director
IBM / Rational – Clear Quest
ETL Tools: Informatica Power Center 8.x/7.x,
Ab Initio 2.1.x, Data Stage 7.x/8.x
BI/Reporting Tools: IBM Cognos, Business Objects BOXI, SSRS, Micro Strategy
DBMS Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator
Operating Systems: Microsoft Windows – Vista, XP, 2000, NT 4.0, OS/2
UNIX – Sun Solaris, HP-UX
Databases: Oracle: 10g, 9i, 8i, Sybase
Microsoft: MS Access, SQL Server 2005/2008
IBM: DB2, DB2/UDB, Teradata: V2R6, V2R5
Languages: SQL, PL/SQL,
UNIX Shell Scripts, VB Script, COBOL, Java, C,
Version Control Tools: Clear Case, DOORS, And Requisite Pro