We provide IT Staff Augmentation Services!

Quality Assurance Analyst Resume

Madison, WI

SUMMARY:

  • I have over 8+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications. Additional skills include:
  • Experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
  • Involved in complete software development life cycle (SDLC) of the projects and have experience in various domains like HealthCare, Insurance, Banking and Sales.
  • Directly work with EPIC system and EPIC date. The main source date from EPIC.
  • Validate the data from Clarity’s source to Netezza through Data Validation Option (DVO).
  • Extensively used SYSTEM QA methodology for testing data extraction, transformations and loading process, in a corporate- wide- SYSTEM QA Solution using Informatica, and other SYSTEM QA tools.
  • ETL testing in Data warehouse implementations ETL methodology using Informatica Power Center 9.6.1/9.1.0/8.6/8.1/7.1, Oracle 10g/9i/8i and MS SQL SERVER 2005/2000.
  • Expertise in Testing Complex Business rules by creating mapping and various transformations.
  • Experienced with creating Unit Test Cases for mapping and code reviews.
  • Good Experience in QA Methodology and Validations to ensure industry standards.
  • Excellent troubleshooting and debugging skills.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
  • Expert in writing SQL for validating complex business rules based on ETL mapping document.
  • Experience in testing XML files, flat files, others and validating the data loaded to staging tables.
  • Extensively used Service Now, Rational Clear Quest, Quality Center for Test Case and defect tracking management.
  • Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin.
  • Extensive Experience in writing SQL queries, stored procedures, functions, packages, triggers, exception handlers, Cursors, 3NF, PL/SQL records & tables.
  • Extensive knowledge of one or more leading ETL tools (e.g. Oracle Data Integrator, SAS Data Integration Studio, Business Objects Data Integrator, Microsoft SQL Server Integration Services).
  • Solid experience in Black box testing techniques, which includes, Unit, Integration, Functional, System, Regression Testing.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Good experience in Client/ Server applications and Good knowledge of Database testing.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • ETL testing on Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements.
  • Experience in various Industry Sectors Such as Banking, Health Care, Finance, Insurance, Sales.
  • Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS:

Data warehousing Tools: Informatica Power Center 9.x/8.x/7.x, Power Exchange, Data Profiler, Informatica Data Quality, Repository Server Administrator.

Databases: Oracle 10g/9i/8i, DB2, Netezza, Microsoft SQL Server.

Reporting Tools: QlikView 11, Business Objects, SAS.

Operating System: Windows XP/NT/2000, UNIX (Sun Solaris 8.0, AIX5.1)

Scripting Languages: Shell Scripting

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director

Modeling Tools: Erwin Studio

Scheduler Tools: AutoSys, Control-M

Database utility tool: SQL Developer, Aginity, Toad

Automation Tool: Data Validation Option(DVO)

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

QUALITY ASSURANCE ANALYST

RESPONSIBILITIES:

  • Designed & created Test Cases based on the business requirements and make complete Test Plan.
  • Worked with Business Analyst to gather business requirements and Involved in daily/weekly team meetings.
  • Communicated and documented test results and defect resolutions during all phases of testing.
  • Testing Experienced with creating Netezza External Tables and Views.
  • Testing Experienced in writing the Queries with Netezza SQL and Oracle SQL.
  • Validate the data from Clarity’s source to Netezza through Data Validation Option (DVO).
  • Involved in complete project Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Conducted source-system data analysis to understand current state, quality and availability of existing data.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that design meets requirements and function according to technical and functional specifications.
  • Extensive experience in manual testing the ETL and Business Intelligence Applications.
  • Responsible for testing all new and existing ETL data warehouse components.
  • Used defects tracking tools for open defect and also link defects with requirements.
  • Performed all aspects of verification and validation.
  • Worked with other members of the QA, BA and Developer teams in improving the processes, methods, effectiveness and efficiency.
  • Data Quality Analysis to determine cleansing requirements.
  • Used Netezza tools for Querying Database.
  • Dealt with slowly changing Dimensions (SCD).
  • Participated in walkthrough and defect report meetings periodically.
  • Every week status meeting for going on project discussion with QA team, Manager.
  • Participated in standing meeting every day (HIMC 38).
  • Impoted external data from excel and flatfiles into SAS in environment dear by onboarding them SAS data.
  • Documented and reported various bugs during Manual Testing.
  • Some exposure to SAS solutions and products.
  • Involved in running the ETL loads in development server.
  • Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
  • Retesting the resolved defects/issues after the developers fix the defects.
  • Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
  • Involved in Unit Testing, System Testing, Integration Testing and User Acceptance Testing of various task.

ENVIRONMENT: ETL (Informatica 9.1.0), Oracle, Data Validation Option for to connect two database(DVO), Aginity for Netezza, Microsoft SQL Server 2008, SQLTools 1.6, SAS, Call Logging, ServiceNow, Windows XP Professional, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Visio.

Confidential, St. Louis, MO

Data QA Analyst

RESPONSIBILITIES:

  • Involved in complete project Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Conducted source-system data analysis to understand current state, quality and availability of existing data.
  • Designed & created Test Cases based on the business requirements.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that design meets requirements and function according to technical and functional specifications.
  • Excellent experience in developing Business Intelligence applications using Cognos and MS Access Reports.
  • Extensive experience in manual testing the ETL and Business Intelligence Applications.
  • Responsible for testing all new and existing ETL data warehouse components.
  • Used defects tracking tools Rational Clear Quest for open defect and also link defects with requirements.
  • Performed all aspects of verification and validation.
  • Worked with other members of the QA and Developer teams in improving the processes, methods, effectiveness and efficiency.
  • Data Quality Analysis to determine cleansing requirements.
  • Used TOAD tools for Querying Database.
  • Participated in walkthrough and defect report meetings periodically.
  • Every week status meeting for going on project discussion with Test Lead, Manager, other test team and offshore team.
  • Participated in standing meeting every Friday.
  • Documented and reported various bugs during Manual Testing.
  • Involved in running the ETL loads in development server.
  • Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
  • Retesting the resolved defects/issues after the developers fix the defects.
  • Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

ENVIRONMENT: ETL (Informatica 8.6.1), Oracle, DB2, TOAD for Oracle 9.7.2, Toad for DB2 4.5, Defect Tracking Tools (DTS, IBM Rational Clear Quest), HP Quality Center 10.0, Windows XP Professional, Lotus Notes 8.5.3, MS Excel, MS Word, MS PowerPoint.

Confidential

QA/ ETL Analyst

RESPONSIBILITIES:

  • Involved in complete project Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
  • Conducted source-system data analysis to understand current state, quality and availability of existing data.
  • Designed & created Test Cases based on the business requirements.
  • DATA validation using SQL queries and back-end testing
  • Validated that design meets requirements and function according to technical and functional specifications.
  • Responsible for testing all new and existing ETL data warehouse components.
  • Experienced at testing ETL's and flat file data transfers.
  • Used HP Quality Center to state requirements, business components, test cases, and test runs for every iteration, defects. Also link defects with requirements.
  • Performed all aspects of verification and validation
  • Worked with other members of the QA and Development teams in improving the processes, methods, effectiveness and efficiency
  • Data Quality Analysis to determine cleansing requirements
  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Participated in walkthrough and defect report meetings periodically.
  • Documented and reported various bugs during Manual Testing.
  • Worked with SQL queries to validate the data in database (SQL Server, Oracle)
  • Involved in development of PL/SQL procedures & triggers.
  • If defects fund again retesting the resolved defects/issues after the developers fix the defects
  • Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

ENVIRONMENT: SQL, PL/SQL, UNIX, Toad, Informatica Power Center 7.1.2, MS SQL server, Oracle 9i, Oracle 8i, Windows 2007, Quality Center 9.0, MS-Word, MS-Excel, MS-Project, Windows XP.

Hire Now