SUMMARY

• 13 years total experience in the technology field. 2 years as a DBA, 3 years testing ETL transformations using Oracle PL/SQL and 11 years total manual testing experience.
• Experience writing Oracle stored procedures to transform data received from the source. The procedures did row by row comparison to the ETL transformed data for validation.
• Datastage ETL tool coding experience.
• Experience in writing and performing Unit Test Cases, Software Integration Test plans (SWIT), Implementation Plans: Production Support Handoff, and Ad Hoc Support Documents.
• Analyzed customer needs and developed functional requirements.
• Test lead experience. Has completed all phases of the software lifecycle including writing Test Plan Documents, Test Case Development, Test Case Execution, and user test acceptance.
• Strong manual test experience for web applications, JAVA, and client server environment testing
• Strong UNIX scripting experience.
• Strong Oracle database experience. Experience accessing it from the command line or TOAD.
• Black box and white box testing experience.
• Sound Web testing experience.
• Conducted procedural and software training for new employees.
• Environments: UNIX and Microsoft Windows Operating System. Oracle and Sybase databases.
• Experienced using HP Quality Center and IBM Performance Tester

TECHNICAL SKILLS

• DataStage ETL tool
• Informatica ETL tool
• Microsoft Visio, Word and EXCEL
• PL/SQL
• TOAD
• Oracle and Sybase databases
• Tested JAVA (including GUI’s), C++, Python code and other languages.
• UNIX, Linux, and Microsoft OS
• HP Quality Center
• IBM Performance Tester
• HTML data file testing
• PVCS for reporting
• Sabrina software
• Clear Case
• DOORS
• WNSCP
• SharePoint document management and storage system
• AWK and SED scripting
• Regression Testing
• Functional Testing
• Performance Testing
• Defect tracking
• Strong System testing (black box) background
• Strong white box testing background.
• Web testing experience.
• DataStage ETL Software engineering
• Informatica ETL and DataStage ETL testing
• Experience in Iterative, waterfall, and agile test environments
• Writing stored procedures
• Database optimizing and tuning including replication.

PROFESSIONAL EXPERIENCE

Confidential, CO

ETL Test Engineer

Responsibilities:

• Wrote procedures to test data produced by the Informatica ETL tool data.
• Wrote PL/SQL procedures in TOAD software to test each piece of transformed data.
• Wrote test procedures to accurately test OBIE reporting from the Oracle database.
• Implemented, conducted, and led Test and Software Engineer status meetings.
• Involved in weekly status meetings wif the customer.
• Created test data in flat files and in the database for preparation of extract, transform, and loading by the ETL tool.
• Found defects and wrote detailed problem reports for the software engineer.
• Transferred files from Microsoft OS to Linux OS.
• Develop test strategies and wrote test procedure documents to be presented to the customer.
• Utilized Quality Center, PVCS and Sabrina software to track the progress of the software process.
• Utilized Microsoft EXCEL in my testing of data.

Confidential, Boulder, CO

Test Engineer

Responsibilities:

• Tested Software on a LINUX OS.
• Loaded new versions of the software for testing.
• Manipulated the configuration files (.bat, .cfg, etc.) to test the software.
• Tested data produced in HTML data files.
• Ran software to visually verify the behavior of the GUI.
• Tested GUI’s physical attributes and reported defects.
• Created Test Procedure Documents wif detailed analysis of test results.
• Performed regression tests
• Ran performance tests.
• Wrote detailed defect reports for the software engineers and system engineers.
• Tested defects to verify the fixes.
• Analyze logs produced by the software for accuracy.
• Attended defect status meetings.

Confidential, CO

Test Engineer

Responsibilities:

• Worked closely wif the software engineer to develop test plans.
• Developed DVR’s from Requirements.
• Created sequence diagrams and flow charts using Visio for test cases.
• Developed Test Case Documents.
• Created Test Procedure Documents in DOORS.

Confidential, Colorado Springs, CO

ETL Developer/Software Tester

Responsibilities:

• Developed DataStage ETL code to extract and transform data from three databases and load into one database.
• Designed plans to test transformed legacy data into new databases.
• Wrote Oracle stored procedures to transform data using cursors. This tested the migration accuracy of each row of data.
• Manipulated data in flat files and databases for testing.
• System Performance testing using IBM Performance Tester automated testing software.
• Write test steps for the user interface GUI (Share point).
• Ran software to visually verify the behavior of the GUI.
• Tested GUI’s physical attributes and reported defects.

Confidential, Littleton, CO

ETL Test Engineer

Responsibilities:

• Designed plans to test transformed legacy data into new databases.
• Wrote Oracle stored procedures to transform data using cursors. This tested the migration accuracy of each row of data.
• Wrote scripts to create Oracle external tables.
• Designed and wrote requirements.
• UNIX scripting to automate various aspects of the test process.
• Assisted in writing a Run Book to document procedures and processes for running the scripts.
• Developed a software engineer training document for the ETL tool.
• Created EXCEL spreadsheets for documenting progress.
• Logged, tracked, and identified improvement strategies for defects.

Confidential, Littleton, CO

Test Lead and Test Engineer

Responsibilities:

• Responsible for creating a plan for testing and leading testers through the software design lifecycle thru customer acceptance testing.
• Walked the floor in the customers workplace to report problems and answer questions for a new delivery.
• Responsible for the database and software testing.
• Wrote test plans and test cases to test Java GUI’s.
• Wrote and implement test plans and performed final testing.
• Collaborated wif test, development, quality assurance, and systems engineering colleagues to complete testing objectives.
• Created presentations to educate colleagues on UNIX scripting and writing SQL.

Confidential, Littleton, CO

Database Administrator

Responsibilities:

• Managed Sybase database issues.
• Wrote and updated stored procedures.
• Managed replication and data server problems.
• Assisted the software engineers wif database issues.