We provide IT Staff Augmentation Services!

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

Hire Now