Data Warehouse Quality Assurance

Doug Kielmeyer

ETL Data Warehouse Test Lead

Phone: 740-***-****

Email: ********@*******.***

PROFESSIONAL SUMMARY

• Proven Test Lead in both ETL and Web Testing.

• High level SQL writing and debugging skills.

• Experienced SQL writing and testing on many relational Data Base platforms:

o Oracle

o DB2

o Teradata

o Netezza

• Proven ability to work as a team player, mentoring less skilled testers and organizing overall test strategies and

formulating test plans in a manner which is clear and concise.

• On Shore Testing Lead for an International Data Warehouse Digital Marketing Installation.

• Technical Lead for Internet Banking app load into Enterprise data warehouse.

• Senior QA Analyst with over 24 years experience working and leading projects within the Insurance and Financial

Industries.

• Proven ability to Lead off shore resources, coordinating work efforts in a 24/7 development environment.

• Proven ability to Lead complex testing efforts during stressful phases of the project.

• Proven ability to work with both development areas, Help Desk, Production Support and business customers of all

levels, Front Line, Accounting, Service Center, Traders, Project Management, Directors, Vice Presidents… .

• Proven ability to understand complex entity relationship diagrams, business model, interpret changes being made to

an existing structure, as well as quickly adapt to change and anticipate change.

• Attention to detail with focus on accuracy and creating solutions that are best fit for individual situations.

• Excellent written, oral and interpersonal communication skills.

TECHNICAL EXPERTISE

Tools: .Net Testing, Ab Initio, Beyond Compare, Ruby, Cucumber, Brio, Business Objects, COGNOS, Control M Job

Scheduler, DB Artisan, Informatica, JAVA, JAVA 2 (J2EE), Lotus 123, Lotus Notes, Mercury Test

Director and Quality Center, Micro Strategy Reporting Tools, Micro Strategy Integrity Manager,

MS Excel, MS Project, PL/SQL Developer, SQL 2000 and up, SQL Assistant, SQL Loader, SQL

Navigator, SQL Plus, SUN Microsystems Environment, Tableau, Toad, TFS, UNIX, Windows 2000

Server and Windows XP Environments. TFS Test Manager, Power Suite Claims, SQL Developer,

JIRA, Selenium.

Data Warehouse Environments: Oracle, DB2, Teradata, Netezza, Business Objects/BI

Special Expertise: Internet Business Applications, Internet Website results reporting, Web Browsers, Devices,

Attribution Model Testing, Hadoop Testing and Q String reporting

PROFESSIONAL EXPERIENCE

eBay Enterprises Inc, Marketing Solutions May 2013 to Current

Doug Kielmeyer

ETL Data Warehouse Test Lead

Columbus, OH

Quality Assurance Test Lead

• Create Master Test Strategy for the Polaris Project. Polaris is an Attribution Reporting platform that is being

converted to MicroStrategy based front end. They are using Hadoop to process the Analytic SAS process.

• Led Strategy review sessions with the Development team.

• Wrote Master Test Plans for the project and created sub level test plans for the entire project.

• Created Test Cases for all test plans.

• Implemented Ruby scripts for test running of screen processes during performance Test.

• Developing Ruby/Cucumber scripts to automate testing of Attribution application screens.

• Wrote Test Scripts for highly detailed testing process of the Scenario Planner tool. Scenario Planner uses Analytics

to create detailed plans for Ad Spend to achieve the maximum revenue or minimize spending.

• Executed the Data Model test cases using MicroStrategy and Beyond Compare identifying data errors and working

to resolve them.

• Create and Lead the Performance test plan. Work with the Infrastructure team to plan and execute the entire

Performance tests. The initial tests were high volume on the Polaris application, the final level of testing was

performed in a simulated high volume web hits environment.

• Interviewed and hired Automated Testing resource.

• Implemented Automated Test Package Selenium for Web testing the application.

• Implemented MicroStrategy Integrity Manager for automate executing MicroStrategy reports for Automated Testing.

State of Ohio, Bureau of Workers Compensation (BWC) September 2012 to May 2013

Columbus, OH

Quality Assurance Tester SQL Writing

• Created Project overview documentation, prepared testers for Test Scenarios, including SQL training for less

experienced SQL testers

• Updated self developed ETL test tool, simplified and added improved summary section for defect reporting

• Wrote Expected and Actual results SQL for all Financial Based Testing for CORE Conversion Project.

• Wrote Expected and Actual results SQL for all Participant Based Testing for CORE Conversion Project.

• Worked with testers to make sure test plans contained all necessary conversion test scenarios.

JP Morgan Chase May 2012 to September 2012

Columbus, OH

On Shore Digital Marketing Test Lead

• Leading testing efforts in an Off Shore 24/7 development model.

• Hold daily 7am conference call to complete daily hand off and Status Meeting preparation

• Prepare the daily Dashboard report for Project Management Distribution

• Coordinate UAT preparation

• Hold Test Case Review sessions

Doug Kielmeyer

ETL Data Warehouse Test Lead

• Coordinate Test case uploading to Quality Center

• Perform regular follow ups with Testers and Business Analysts to facilitating problem solving

• Create Defect Reports for Management review sessions

• Serve as the Testing Systems SME on Digital Marketing/Internet Business processing Issues

• Responsible for requesting database accesses for Team members

• Responsible for Test Team Distribution list maintenance and creation

• Report Testing Issues to upper management as needed

• Coordinated the Testing of XPlus1 Internet Clicks, Impressions and Activities into Landing, Integrated, Semantic

Layers and into Tableau reporting tool

JP Morgan Chase January 2011 to May 2012

Columbus, OH

Technical Test Lead

• Serve as the Technical Lead for Internet Banking JAVA app load into Enterprise data warehouse.

• Started the ETL Testing process on the Corporate Internet Group data for the Enterprise Data Warehouse Quality

Assurance area

• Developed ETL testing application for testing Expected vs. Actual Results loaded into Data Warehouse.

• Provide Testing result reports to project manager and project team.

• Work on Template documents for the test team, periodically reviewing Documentation of Processes, updating as

needed

• Write Test Strategy documents and Project Test Plans

• Coordinate changes to functional requirements with project Business Analysts

• Write and run complex SQL code for Expected and Actual Test Results

• Coordinate new hire test readiness tracking

• Created and modified “Exporting Quality Center Script” package

• Created and modified an ETL Testing Process tool

• Run test scripts using an array of SQL tools

• Lead groups of Testers in 5 testing Releases each year (March, May, July, September, November).

• Coordinate the testing activities for Production Defect Fixes

• Work with off shore resources to coordinate assignments and understanding of new processes using Teleconference

and Live Meeting screen share technology.

• Manually tested web based Applications.

• Used SQL, SQL Assistant, SQL Navigator and other query driven platforms to retrieve financial data to summarize

and report on Spreadsheets.

• Working on testing of new data warehouse being created in Teradata, loaded with Informatica and used UNIX for

file manipulation and job running

Avizent Risk April 2010 to December 2010

Dublin, OH

Doug Kielmeyer

ETL Data Warehouse Test Lead

QA Test Lead

• Run test scripts for VCS .Net and JAVA Claims application (Workers Comp and Auto Liability and General

Liability)

• Write test scripts for the Payment project, to make Voucher, Check and Bank Card payments

• Direct fellow testers on how to run the script

• Write and Manage Defects using IBM Team Foundation Server (TFS)

• Run Show and Tells for the Users (Accountants, Office Managers, Presidents), demonstrating the functionality

implemented in the previous weeks.

• Schedule Show and tells, using Go to Meeting CITRIX software.

• Creating scripts in Excel, using a formatting technique that simplifies the script for novice users by color coding

commands and bolding field names.

• Test initial feature installations, to verify that they are ready for test scripts to be written.

• Enter and track progress of assistant

• Prepare assignments for Contractor assistant and Avizent testers

• Review completed test scripts and make script adjustments as needed.

• Communicate script running and writing progress to Contracting Management and Avizent Management.

State Auto November 2009 to April 2010

Columbus, OH

QA Analyst

• Run test scripts on Bizx Business Auto and Business Owner Property Insurance Quote JAVA and .Net system.

• Write test scripts to be run Bizx Business Auto and Business Owner Property Insurance Quote system.

• Review and document the Bond Connect System for processing Surety Bond applications.

• Update Mercury Quality Center for Defects associated with testing in Agile release testing flows.

• Keep test leads current on defects as they are found, as well as when they are retested.

NetJets, Inc. June 2009 to November 2009

Columbus, OH

Sr. ETL QA Analyst

• Creates manual test cases in suitable format for regression testing and automation.

• Participates in documentation reviews and handoffs.

• Develops and maintains test plans.

Doug Kielmeyer

ETL Data Warehouse Test Lead

• Reviews and analyzes test results.

• Documents test and defects; validates status of corrected defects

• Reports test results and metrics to the Project Lead.

• Supported the V Model QA Methodology used at NetJets, Inc. in the Business Intelligence area.

• Used Quality Center to create and implement the test Plan.

• Developed SQL Statements to retrieve data from the Source system and from the Data Warehouse for data

comparison in Windows 2000 Server and Windows XP Environments.

• Created and maintained manual test scripts in Quality Center.

• Tested ETL loads from Oracle based source system into Oracle Enterprise Data Warehouse and Business Objects

Business Intelligence Tools for Reporting

• Prepare a process documentation for testing ETL loads.

Nationwide Financial April 2002 to April 2009

Columbus, OH

Sr. QA Analyst

• Completed Quality Assurance testing on Data warehouse, CITRIX, Oracle, Teradata and Netezza environments.

• Manually tested web based Applications in Windows 2000 Server and Windows XP Environments.

• Used SQL, SQL Assistant, SQL Navigator and other query driven platforms to retrieve financial data to summarize

and report on Spreadsheets.

• Created automated parsing sheets to breakdown flat files for comparison to data loads.

• Utilized SQL to write SQL code, Breakdown complex Financial Transaction data, used SQL Explorer, SQL

Assistant, Toad and other SQL Packages.

• Wrote SQL from the SQL prompt, without an automated package

• Used Oracle, UNIX and vi editor to run greps to search files

• Advanced knowledge of Excel including Spreadsheet Formula's for parsing output files into Databases for

comparison or reporting, Excel formulas reusable templates that generate html files, Excel formulas reusable

templates that generate SQL programs, Using files created by others and debug processes, Creating Management

reports that combine multiple files.

• Support Finance Department, Actuarial, Service Center and Financial Reporting areas, writing specification and

testing reports and data flows.

• Provided testing support for conversion of Data Warehouse to Netezza and then to Teradata a few years later

• Mapped Financial Transactions into Tier 2 and out of Data Warehouse applications

• Supported Data Warehouse testing for ETL, Reporting and Table Changes

• Supported testing in JAVA and CITRIX based applications

• Supported New Fund and New Product changes to Data Warehouse and Tier 2 System

• Created data parse application in and out of third party Fixed Life data conversion company

Doug Kielmeyer

ETL Data Warehouse Test Lead

Nationwide Financial June 1995 to April 2002

Columbus, OH

SR Business Analyst

• Wrote Business Requirements documents that detailed requirements for creating and modifying Database Tables,

Business Reports, Automated Data Entry forms, Data feeds between Financial Institutions, Actuarial Reporting

needs, Sales and Asset Reporting systems.

• Performed Financial Transaction Mapping and Business Process Mapping conversion from manual data entry to

automated reporting systems.

• Served as specialized liaison between the database area and the Accounting, Finance and Actuarial areas.

• Performed Data Warehouse Testing Implementations for Life, Pensions, Individual Investment Products, Immediate

Investment, and other Miscellaneous Investment Life Areas.

• Created COGNOS cube to illustrate the benefits to Business Officers of creating a Data Warehouse

• Wrote Specifications for New Creations and Modifications for: Data Tables, Reports, Data Feeds and

Reporting Flows

• Participated in the creation of Nationwide Financial Services data warehouse

Nationwide Financial July 1991 to June 1995

Columbus, OH

Business Reporting/Testing Analyst

• Prepared Sales Premium and Asset Reports for Nationwide Financial Individual Annuities (401k, 403B

• Used Lotus 123 to prepare reporting on over $100,000,000 in Assets and over $1,000,000 monthly premium reports.

• Initially these reports were created using data entered from Green bar reports.

• Upon my arrival an automated data entry form was created and over time, the entry was replaced with the creation

of an Oracle database system.

• My role was to verify that the data in the tables was accurate by performing parallel processing for several months.

Nationwide Mutual Insurance Company June 1985 to July 1991

Columbus, OH

Automated Tax Planning Analyst

• Prepared an 1120 Federal Tax Return and an 1120PC Federal Tax Return using Lotus 123 (Single sheet) Software

package.

• Created a Consolidated 1120 Federal Return, combining 10 Insurance Companies and 33 Non Insurance Companies

into one return.

• Was responsible for gathering data from the Insurance NIAC Annual Statement, mapping the data into the Tax

Return package.

• Created a customized Reserve Discounting package for internal use

• Supplied Auditors with data as needed and requested.

Doug Kielmeyer

ETL Data Warehouse Test Lead

• Served on a team that evaluated corporate tax software packages from various Accounting Firms.

• Worked alongside Tax Accountants to support the Premium Tax Reporting process, the 1099 processing and most of

the 50 state corporate tax returns.

• Organize several thousand Paychecks for National Mailing and Home Office distribution

• Organize several thousand W2 Forms for National Mailing and Home Office distribution

• Create and File Documents for Check stopping and replacement

• File Address Changes for employee Paycheck mailing

• Coordinate Home Office handling of Regional Office Payroll mailing changes

• Organizing Tax Schedules and Forms into Lotus 123 from paper copies

• Programming 1120 and 1120PC Tax Application on Lotus 123

• Support mapping Chart of Accounts into Tax Filing Software

EDUCATION

• The Ohio State University June 1992

• Bachelor of Business Administration, Finance Columbus, OH

Contact Information

Address: 14536 Cleveland Rd SW

Pataskala, OH 43062

Phone: 740-***-**** Email: ********@*******.***

Contact this candidate