We provide IT Staff Augmentation Services!

Sr. Etl/bi/dwh Qa Analyst/data Analyst Resume Profile

St Louis, MO

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience in Quality Assurance and Data Analysis of various business applications in Client/Server environments, Web-based applications, Data Warehousing solutions, ETL and Business Intelligence solutions.
  • Excellent working knowledge of System Development Life Cycle SDLC and Software Testing Life Cycle STLC and Defect Life Cycle DLC .
  • Strong experience in writing Test Plans, Test Cases Test Scripts based on business requirements, rules and system specifications.
  • Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification.
  • Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing SIT , Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
  • Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down nd score cards.
  • Extensively worked on database query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
  • Extensive experience in writing complex SQL and PL/SQL scripts.
  • Experience on working with different models such as star and snowflake and strong working knowledge in dimensional modeling.
  • Expertise in test management using HP Quality Center and maintained versioned objects using Rational Clear Case.
  • Experience with Automating test scripts using Selenium IDE
  • Creating Scripts for Regression testing using Selenium web driver in Java environment.
  • Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking defects using HP Quality Center, Rational Clear Quest, Bugzilla, Jira.
  • Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
  • Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
  • Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
  • Involved in preparation of RTMs, Defect Reports and Weekly Status Reports.
  • Knowledge on the phases of agile methodology.
  • Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 9.x/8.x/7.x, SSIS, Data Stage, Ab Initio

QA Tools

HP Quality Center, Test Director, Quick Test Pro QTP , Selenium IDE, Selenium WebDriver

DBMS/Query Tools

TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages

SQL, PL/SQL, C, Java

Databases

Oracle11/g/10g, SQL Server 2008/2005/2000, DB2, Sybase

Teradata V2R6/V2R5

Version Control Tools

Rational Clear Case, WIN CVS

Requirements Tools

Doors, Rational Requisite Pro

BI / Reporting Tools

IBM Cognos 8.0, Business Objects BOXI, SSRS

Operating Systems

Microsoft Windows Vista, XP, 98, 2000, NT 4.0 UNIX Sun Solaris, HP-UX

Scheduling Tools

Autosys, Control M, Flux

Other Tools

TextPad, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL/BI/DWH QA Analyst/Data Analyst

Responsibilities:

  • Developed the complete Test documents like Test Plan, Test Cases and Test Scripts by analyzing Business requirement documents and Use cases.
  • Prepared Requirement Traceability Matrix RTM , Test Status reports and Test Sign off documents.
  • Involved with project backlogs and sprint backlogs.
  • Extensively involved in System testing / Functional, Regression testing and Integration testing
  • Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
  • Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
  • Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language
  • Involved in test management and defect management using Quality Center and TFS.
  • Performed Database metadata validation before loading the data into the target tables.
  • Performed Data Validation by testing the delta/daily and reconcile/data loads.
  • Created SQL compare statements to validate Actual results with the Expected Results and written complex SQL queries for validating Cognos Reports.
  • Tracked and executed the User Acceptance Test Cases UAT with respect to the requirements to determine the feature coverage.
  • Involved in validating SSIS and SSRS packages according to functional requirements.
  • Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
  • Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
  • Verified ETL logs and reject/discard files for errors and reported them to development team.
  • Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
  • Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
  • Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
  • Validated the data moving from multiple sources to target using Informatica data validation option.
  • Estimated level of effort LOE for testing effort and reported to Test Leads.
  • Performed Quality Assurance activities for data validation, data scrubbing, data profiling.
  • Created shell scripts and used Unix commands to manipulate input files for test execution
  • Created test data for all ETL mapping rules to test the functionality according to requirements.
  • Ensured quality products delivered and installed as specified in the statement of work SOW .
  • Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Informatica 9.1, Informatica Data Validation Option DVO , SQL, PL/SQL, Remedy, DB2, Selenium 2.4, Oracle 11g, TOAD, XML, PuTTy, Quality Center 10, TFS Team Foundation Server , MS Visual Studio, Cognos 10, Autosys, SQL Server 2008, SSIS, SSRS, SSAS, Windows XP, UNIX.

Confidential

Sr. ETL/BI/DWH /Web Tester/Data Analyst

Responsibilities:

  • Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
  • Analyzed the Functional Specifications and implemented their technical aspect in System and Integration testing SIT .
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix RTM .
  • Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System End to End and Backend Database .
  • Developed and executed test cases and test scripts.
  • Performed Integration, Regression, Performance and Functional Testing.
  • Worked with the UNIX shell scripts.
  • Used HP Quality Center as test management tool.
  • Validated the responses of web services by passing various requests in SOAP UI.
  • Tested Cognos Reports according to the business requirements.
  • Exclusively used Analysis Studio and Query Studio to test the Cognos Reports.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down reports.
  • Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
  • Extensively written SQL to confirm the data transfer from sources to target.
  • Tested the PL/SQL procedures, functions, packages according to the requirements.
  • Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
  • Verified test results viewing the log files, querying the database documenting the defects.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.
  • Involved in testing the functionality of Data Stage jobs.
  • Executed ETL mappings through data stage director and monitored status.
  • Tested the ETL Data Stage and other ETL Processes DW Testing .
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Data Stage 8.0, SQL, Cognos 8.0, Clear Case, Clear Quest, RequisitePro, Quality Center, SharePoint, Web Services, Soap UI, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, UNIX, PuTTy, Flat Files, Session Logs, Rally.

Confidential

ETL QA Analyst/UAT Tester/Data Analyst

Responsibilities:

  • Responsible for creating Test plan, development of Test scripts, execution and validate Test results and document test evidence.
  • Executed test cases, and test scenarios for User Acceptance UAT , Functional and Regression test cases.
  • Reviewed unit test cases and test results and certified the code for Integration testing
  • Created user acceptance testing documents and reviewed them with the customer.
  • Mapped test cases to requirements using Quality Center
  • Involved in entering and tracking defects using Rational Clear Quest.
  • Involved in communicating with support, business and development teams to resolve issues during test execution.
  • Tested initial and daily loads for various Ab Initio graphs.
  • Validated several SSIS and SSRS packages to verify that they are working according to BRS.
  • Involved in testing the batch programs by using the Autosys tool.
  • Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
  • Conducted reviews of test plans, test cases, and prepared test results.
  • Tested the functionality of Ab Initio graphs.
  • Tested the ETL graphs and other ETL Processes DW Testing .
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
  • Done data validations for Business Objects reports.
  • Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
  • Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
  • Created Test input requirements and prepared the test data for back end testing.
  • Involved in testing the reports and UI screens containing those reports.
  • Provided status reports on test execution, and defects identified during testing.

Environment: Oracle 9i, Toad, DB2, SQL, Ab Initio 2.12, PL/SQL, Business Objects XI, MS Visio, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, TIBCO, Remedy, SQL Server 2003/2005 SSIS, SSRS, HP Quality Center, UNIX, PuTTy, SQL Navigator

Confidential

DWH Tester/Data Migration QA/Web UI Tester

Responsibilities:

  • Develop test plans based on BRDs and Technical Specifications.
  • Created and executed test cases based on test strategy and test plans based on business requirement documents and ETL design documents.
  • Written complex SQL queries for querying data against different data bases for data verification process.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
  • Extensively used Informatica Workflow Manager to run the workflows.
  • Preparation of technical specifications and Source to Target mappings.
  • Verified the Data completeness, Data Migrations, Data transformations and Data Quality
  • Written Test Plans and Test Cases on Mercury Test Director Tool.
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
  • Strong Perl Scripting experience in writing conditionals, subroutines, Perl packages, OOP and Debugging in Perl.
  • Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
  • Tested a number of complex ETL mappings and reusable transformations for daily data loads.
  • Used Data Stage Director to run the ETL mappings and monitor the status.
  • Creating test cases for ETL mappings and design documents for production support.
  • Extensively used Informatica for extraction, transformation and loading process.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Extensively tested several Crystal Reports and Hyperion reports for data quality, fonts, headers cosmetic.
  • Participated in review meetings for defect status, priority and information exchange.

Environment: UNIX, Informatica, Perl Scripting, Mercury Test Director 6.5, SQL Loader, Crystal Reports, Hyperion Reports, Oracle 9i, SQL Server 2003, Terdata, SQL Assistant, PuTTY, Remedy, WinSCP, Erwin 3.5, HTML, XML, Micro Strategy, Java, J2EE, SSIS, TOAD, UNIX log files, vi Editor, XP.

Confidential

QA Consultant / ETL Tester / Reports Tester

Responsibilities:

  • Involved in writing the test plans, test cases and RTM involved in the process of analyzing the expected and actual results.
  • Worked on Extracting Data from Mainframe and load the data into Oracle.
  • Performed Integration, End-to-End and System testing.
  • Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
  • Extensively used ETL to load data from Flat files to Oracle.
  • Executed various SQL Queries to perform the backend testing.
  • Tested data stage jobs for various ETL functions and transformations.
  • Had regular meeting with Developers to report various problems.
  • Clearly communicated and documented test results and defect resolutions during all phases of testing.
  • Stimulated several production cycles. Worked with Data Validation, Constraints, Record counts, and source to target, row counts, random sampling and error processing.
  • Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing.
  • Implemented SDLC, QA methodologies and concepts in the Project.
  • Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts.
  • Tested UNIX batch jobs according to the specifications and the functionality.
  • Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit.
  • Involved in developing Unix Shell wrappers to run various SQL Scripts.
  • Extensively created UNIX shell scripts for scheduling and running the required jobs.
  • Tested the ETL Data Stage jobs and other ETL Processes Data Warehouse Testing .
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
  • Performed the tests in both the SIT, QA and contingency/backup environments.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Heavily involved in Cognos reports, extensively used SQL for testing reports.
  • Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.

Environment: Oracle 9i, Toad, DB2, SQL, Data Stage, PL/SQL, Cognos, MS Visio, DB2, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, TIBCO, Remedy, QTP, SQL Server 2005 UNIX, Putty

Hire Now