We provide IT Staff Augmentation Services!

Data Warehouse Tester Resume

SUMMARY

  • I am a professional with 8 years of experience in IT. I have an MBA and I have completed 2 years towards completing a Doctorate in Business Administration.
  • I have performed interface testing, system testing, black box testing and white box testing. I have excellent communication, relationship, research, and analytical skills.
  • I have advanced knowledge of IT processes, and have worked on all cycles of the Software Development Life Cycle.
  • For the past several years, I have been working in an Agile development environment.
  • I have advanced of relational databases such as Oracle and Teradata, and I have 5 years of experience writing complex SQL queries.
  • I have always been responsible for creating my own test plans and test cases.

PROFESSIONAL EXPERIENCE

Data Warehouse Tester

Confidential, Richardson, Texas

Responsibilities:

  • Working as tester to validate the Extract, Transform, and Load (ETL) process into a Teradata enterprise data warehouse. The data warehouse contained many tables, some of them having almost a billion rows.
  • Verified the transformation of de - normalized data into a normalized model. In addition to validating the normalization of the data, validated the integrity of the data.
  • Participated in data modeling / architecture design and review meetings.
  • Writing and modifying complex SQL queries to very the migration of data from old databases to the new Teradata database. Queries include creating tables, transforming data, and performing source-to-target testing.
  • When data integrity issues were found, I was responsible for analyzing the data to identify the source of the problem. Once the problem was found, the issue was reported to the correct group to resolve.

Environment: Teradata database, enterprise data warehouse, data marts, SQL Assistant (writing SQL queries), Erwin diagrams, data requirements in Excel, data integrity, data analysis, data mining, ETL process

Business Intelligence Tester

Confidential, Plano, Texas

  • Tested data integrity for Extract, Transform, and Load (ETL) process
  • Enforced SDLC process for development, test, and implementation processes
  • Tested Crystal Reports and Web Intelligence reports created by Business Objects software
  • Tested data integrity of Business Objects data mart and data warehouse
  • Trained in creating reports in Business Objects as well as creating universes.
  • Used explain plan to optimize query performance
  • Performed load testing on web-based applications using Oracle database. We collected and reported metrics on how long the application required to open a Webpage, how long Oracle required to process the database transactions, and how many simultaneous users could be logged into the system.

Environment:, Oracle 10i, Toad (writing SQL queries), data warehouse, data marts, Mercury Quality Center (test cases and defects), Erwin diagrams, data analysis, data integrity, data mining, ETL process

Consultant

Confidential, Richardson, Texas

  • Coordinated testing activities for customer data migration to new Oracle platform
  • Worked on first testing group in ADS to test implementation of Peace billing application. Helped create testing processes, documentation, and tools such as PL/SQL scripts and SQL queries to be used by other groups for testing the Peace application.
  • Created Website using JAVA to accept and create test data for several testing teams.
  • Gathered requirements and created test case database in Microsoft Access 2003.

Environment:, Oracle 10i, Toad (writing SQL queries), data warehouse, data marts, Mercury Quality Center (test cases and defects), Erwin diagrams, data analysis, data integrity, data mining, ETL process

Consultant

Confidential, Irving, Texas

  • Tested automation of mortgage loan application and validation process.

Environment: DB2, Mercury Quality Center

Consultant

Confidential, Grapevine, Texas

  • As team lead, I managed several employees and oversaw testing for the new confidential product that Confidential was developing at the time.
  • Tested new automated order and customer service system for Confidential . This system received orders, kept track of the order status, and tracked fulfillment of the orders.
  • Improved the reputation of the group within IT by working closely with other team members to consistently meet testing deadlines and thoroughly test the software releases. Implemented SQL scripts that enhanced the effectiveness by providing the test team the ability to validate test data directly in Oracle database. Investigated issues found in test and initiated conference calls and impromptu meetings to resolve them.

Environment: Oracle 9g, writing SQL queries, Mercury Quality Center, data integrity, data mining, data analysis

Project Manager

Confidential, Lewisville, Texas

Responsibilities:

  • Managed the successful move of a database application from one server to another server. Tracked the status of the project using Microsoft Project.
  • Verified customer invoices were correct, new products and services were rated correctly, and that payments and adjustments could be processed correctly.
  • Helped plan the testing strategy for Siebel implementation with Vitria and Arbor applications.

Environment: Oracle 9g, data analysis, data mining

Consultant

Confidential, San Ramon, Texas

Responsibilities:

  • Interfaced with client to successfully test the implementation of customer order entry and billing network. Worked on team to test interaction of various applications.
  • Practiced Confidential ’s methodology of testing and implementing systems
  • Tested the implementation of Siebel order entry/CRM, Vitria middleware, and Arbor billing system.

Business Analyst/Project Manager

Confidential

Responsibilities:

  • Managed the successful modification and implementation of a billing mediation device. Met with business owners, end users, and members from engineering groups to define both functional and system requirements.
  • Helped re-define the process for gathering and processing billing records in the Embratel network. The new process include new systems which I helped define and implement.
  • Oversaw successful modification and implementation of a billing mediation device. Met with business owners, end users, and members from engineering groups to define both functional and system requirements.
  • Performed audit of Embratel call processing network in Brazil which required reviewing the configuration of each network node (switch) in the network. Found trunks (circuit) not generating billing records and requested their re-configuration. As a result of this configuration, revenue was being lost. Suggested audit points at strategic locations within the network to facilitate early detection of potential problems.
  • Worked with Brazilian business owners and engineers to understand how best to integrate the Embratel network with MCI’s. Compiled system and functional requirements for billing system nodes based on input from business owners, end users, and technical support personnel.

Business Analyst

Confidential, Richardson, Texas

Responsibilities:

  • Performed technical presentation of testing equipment to potential customers.

Hire Now