ETL Data Warehouse Test Lead Resume Profile

Reference Id: 82764     Posted on Thursday 17th September 2015      ETL Developer

Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

ETL Data Warehouse Test Lead Resume Profile


  • 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:
    • Oracle
    • DB2
    • Teradata
    • 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.


Tools: .Net Testing, Ab Initio, Beyond Compare, 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,Confidential Excel,Confidential 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



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.
  • 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.


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.


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
  • 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


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


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.


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.


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.
  • 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.


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


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


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.


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.
  • 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

Search Resumes

Looking for I.T Professionals on a Contract basis?