We provide IT Staff Augmentation Services!

Qa Test Lead /etl Backend Resume

Chicago, IL

Professional Summary:

  • Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
  • Experience using query tools for Oracle, Teradata, Sybase, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Experience in Pharmaceutical, Financial, Banking, Brokerage, and Securities industries
  • Extensive testing ETL experience using Informatica 8.6.1/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and OBIEE
  • Experience with Agile Methodology.
  • Experienced in coordinating resources within Onsite-Offshore model
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Extensive experience with Reporting Tools like OBIEE and Siebel Analytics.
  • Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
  • Expertise in Testing complex Business rules by creating mapping and various transformations
  • Experience in testing XML files and validating the data loaded to staging tables.
  • Experience in Performance Tuning of SQL and Stored Procedures.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Experience in all phases of Software Development life cycle.
  • Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
  • Performed Unit, Integration and System Testing.
  • Good analytical and problem solving skills.
  • Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
  • Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
  • Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
  • Excellent analytical, programming, written and verbal communication skills.

Technical Skills:

Data Warehousing: Ab Initio CO>OP 2.14, GDE 1.14, Informatica 8.6.1/8.1/7.x, Data Stage 8.x
Reporting Tools: Business Objects, Microstrategy, OBIEE, XIR3, Cognos 8 Suite, Crystal Reports
Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin
Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center 10.0
RDBMS: Oracle 9i/8i/7.x, MS SQL Server 6.5/7.0, 2000, UDB DB2, Sybase, SQL Server 12.0/11.x, MS Access 7.0
Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++
Job Schedulers Auto sys, Maestro, Control - M
Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee
Education: B. Tech in ECE (JNTU, Andhra Pradesh, INDIA)

Professional Experience:

Confidential, Chicago, IL July 09 - Till Date
QA Test Lead /ETL Backend

Responsibilities:

  • Prepared extensive set of validation test cases to verify the data
  • Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
  • Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
  • Prepared the test plans and test cases for different functionalities involved in the application.
  • Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
  • Experience working in Agile environment.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
  • Validated the data of reports by writing T-SQL queries in PL/SQL Developer against ODS.
  • Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Conducted regression testing on the application under test.
  • Create and execute load test plans and scripts using Load Runner.
  • Developed regression test scripts for the application.
  • Extensively utilized the Hyperion intelligence (Brio), Hyperion Web Analyzer, SQL, PL/SQL and worked as a part of Data Warehouse group on projects relating to formulating and analyzing core data relating to business activity.
  • Involved in metrics gathering, analysis and reporting to concerned team.
  • Tested the Oracle PL/SQL testing programs.
  • Extensively tested the cubes developed using data from various OLTP systems and various relational data marts using Essbase Studio
  • Extensively tested several ETL Mappings developed using Informatica.
  • Design, build and test -reports, Dashboards and other functionality within the OBIEE suite.
  • Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
  • Extensively tested the reports generated by Hyperion Web Analyzer and Hyperion Interactive Reporting
  • Conducted test case reviews to ensure scenarios accurately capture business functionality.
  • Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
  • Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

Environment: Informatica, DB2,ORACLE,Microstrategy, SQL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 6.0, XML,TOAD, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, XML, DTS, ERWIN, Windows XP, Quality Center 9.0

Confidential, Charlotte, NC Apr 08- June 09
Sr. BI Tester - Team Lead (FDM PROJECT)

The Finance Data Mart Project provides an automated solution to the regulatory requirements imposed by the Lash Group Clients. This project provides: Finance Portability Reports for revenue, cost, Automated suspicious activity detection and reporting functions through individual customer transaction monitoring, customer peer group profiling, rules-based analytics using industry best practices & case management. A comprehensive solution for managing the customer Finance reports, identity verification, acceptance and on-going maintenance process, along with polices modeling for all customers.

Responsibilities:

  • Prepared extensive set of validation Test cases to verify the data
  • Prepared the Test plans and test cases for different functionalities involved in the application.
  • Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
  • Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
  • Worked in an Agile technology
  • Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
  • Involved Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems.
  • Submitted Status and Test Evaluation Reports to Project Lead on daily basis and Constantly updated test deliverables
  • As a Lead, was involved in weekly status, following up the development as well as the business testing teams, re-scoping project planning
  • Execute and analyze complex test cases and compare the results with expected results and product requirements.
  • Functioned as the Onsite / Offshore coordinator for a team.
  • Tested ad hoc and canned reports for OBIEE.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
  • Written several SQL statements. Tested the output of Statements from sql vs. ETL output.
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Experience in Leading the Offsite Project, managing a team of 8 Offshore and Onsite consultants..
  • Tested the reports like DrillDown, DrillUp and Pivot reports generated from OBIEE
  • Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
  • Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with OBIEE for Business Intelligence reporting
  • Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
  • Study of detailed requirement of end users of system & their expectations from Applications
  • Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative
  • Tested OBIEE and Web Intelligence reports
  • Worked as a lead to resolve issues during critical phase of projects and guide junior testers and even played the role of a mentor whenever required
  • Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2..
  • Experience in loading from various data sources like Teradata, Fixed Width and Delimited Flat Files.
  • Extensively used Control - M to schedule the jobs and run the scheduled jobs at specific time.
  • Involved in Data Extraction from Teradata and Flat Files using sql assistant.
  • Involved in extensive DATA validation using SQL queries and back-end testing

Environment: Quality Center 10.0, OBIEE,Oracle 10g, Informatica 8.6.1, Teradata V2R6, Teradata SQL Assistant 12.0, UNIX, Agile, Control-M job Scheduler

Confidential, Durham, NC Feb 06 - Mar 08
BI/QA DW Tester- Member Benefit Facts

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
  • Responsible for testing Business Reports developed by OBIEE
  • Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Extract data from Mainframe data sets to compare against Target Values.
  • Reported bugs and tracked defects using Quality Center 10.0
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Executed the Test Scripts in TOAD and documented the results in RTM.
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
  • Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
  • Written complex SQL queries for validating the data against different kinds of reports generated by OBIEE.
  • Lead team of 5~6 people and co-ordinate offshore team of 12 people in INDIA.
  • Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
  • Reviewed Informatica mappings and test cases before delivering to Client.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
  • Responsible for Extracting and Importing clinical data like prescription, adverse event records, laboratory records from Oracle database and other sources into SAS datasets using SAS/ACCESS SQL Pass-Through facility, Proc Import and Import Wizard.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Involved in developing test cases to test Teradata scripts (Bteq, Multiload, fast load).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
  • Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
  • Extensively written TeradataSQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Worked in an Agile technology with Scrum
  • Tested several data migration application for security, data protection and data corruption during transfer
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Analyzed the data and applied relevant transformations and verified that the source data types are correct.
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Used different sources for Input.
  • Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
  • Performed front-end testing on OBIEE Executive Dashboard portal
  • Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
  • Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
  • Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
  • Interacted with Users to understand the bugs in Business Reports generated from OBIEE
  • Created different user defined functions for applying appropriate business rules
  • Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: Quality Center 10.0, SQL,TOAD, PL/SQL, OBIEE, Informatica , XML Files, Flat Files, Teradata V2R6, Teradata SQL Assistant 12.0, COBOL II, UNIX, Oracle 10G, DB2, Shell Scripting, PERL

Confidential, Chennai, INDIA Dec 03 - Jan 06
Confidential, Manhattan, New York
Database Tester/Analyst - Credit Risk Data Compliance Ware house - CRDW

Responsibilities:

  • Created PL/SQL procedures, triggers, views, functions.
  • Gathered information about the transaction process, planning and development of the various screens.
  • Responsible for designing database tables and writing SQL & PL/SQL procedures, functions.
  • Developed various forms (screens) and some complex reports.
  • Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
  • Written complex SQL queries for each level of data validation.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Generated daily transaction reports with transaction no, loan no, borrower\'s address, particulars, credit, debits liability.

Environment:Oracle 7.x, Visual Café, Rational Rose, Clear Case, Clear Quest, Windows 2000

Hire Now