SUMMARY:

• ETL VALIDATION: Write complex SQL to validate the accuracy and completeness of ETL data loads. Verify that all transform logic corresponds to the data mappings and requirements. Proficient in MS SQL Server (T - SQL), Oracle (PL/SQL), DB2 (Interactive SQL), MySQL and Teradata SQL (BTEQ).
• BI DATA STRUCTURE VALIDATION:
• MOLAP: Use ProClarity Analytics, Cognos, Microsoft Analysis Studio and SQL to verify the data transfer from relational tables to BI Reporting Cubes. Validation covers source-to-target mappings for deliverable metrics sliced at each level of all applicable dimensions.
• ROLAP: Write SQL to verify the accuracy and completeness of data loaded in views and MQTs used to source BI reports and dashboards.
• BI REPORTING VALIDATION: Use SQL, Excel, Chameleon, etc. to verify that BI reports accurately display the data contained in the underlying data structures. Run reports and dashboards in ProClarity, Cognos, MicroStrategy, Business Objects, etc., and export data (xxls/delimited/fixed length) as the actual results data set for comparison to expected results queried from relational tables/views/MQTs.
• QA METHODOLOGY: Develop and document the testing approach for EDW, EBI and data mining projects. Includes defining the testing process, documenting test case standards and establishing test sets (functional/integration/system/regression). Configure test environments, produce test query guidelines/templates, select test data, create and maintain query libraries, and design the test automation approach (QTP/UNIX CShell).
• TEST CYCLE MANAGEMENT: Experienced in Agile and Waterfall methodologies. Schedule, monitor and adjust the test execution cycle and manage the defect feedback loop. Create and maintain requirements traceability matrices. Produce and publish test cycle results, testing status and burn-down reports.
• RESOURCE MANAGEMENT: Staff, schedule and manage EDW/EBI QA test teams (on-site and off-shore) for multiple concurrent projects.

TECHNICAL SKILLS:

• Teradata SQL Assistant
• SQL Server Mgt
• Studio 12.0 R2, MicroStrategy 9.0
• Cognos 8.4, SQL (BTEQ/DB2/ PL-SQL/T-SQL/MySQL)
• XML editor (various)
• SOAP UI
• Hyperion
• ProClarity
• HP Quality Center
• QTP
• LoadRunner
• HL7 v3 Chameleon
• E-Commerce
• Sarbanes-Oxley Compliance Act
• Health Care
• Automotive Wholesale
• Supply Chain Management
• Telecom
• Television Media

PROFESSIONAL EXPERIENCE:

ETL TEST ENGINEER / SQL ETL DEVELOPER

Confidential - Atlanta, GA

Responsibilities:

• Validate ETL loads from diverse data sources into relational tables in both OLTP (normalized) and OLAP (star-schema) databases.
• Mentor Data Quality team regarding the testing process. Establish SQL standards, best testing practices and design/maintain the defect feedback loop.
• Technical lead for User Acceptance Testing.
• Analyze user data needs to develop requirements and data mapping documents for ETL data flows and EBI reporting views
• Use T-SQL to write ETL processes to import data from various sources (xml, xxls, delimited/flat file, relational tables) into MS SQL Server tables.

SENIOR TEST ENGINEER

Confidential - Atlanta, GA

Responsibilities:

• Wrote complex PL/SQL queries to verify accuracy and completeness of initial and incremental ETL (Informatica) from source (ASCII files) to Oracle staging tables and then from staging tables to Oracle data marts.
• Reviewed the PL/SQL code in the views and MQTs used as data sources for BI reports/dashboards to ensure the data reporting requirements were met.
• Tested data in BI reports by exporting data from reports and bulk-loading it into Oracle tables as the expected data set. Then compared expected data to the data stored in BI reporting views/MQTs.
• Wrote SQL (T-SQL/DB2/MySQL) to validate Push-Pull data flows implemented in SQL queries, SSIS packages and web service APIs (SOAP/WSDL).
• Validated XML-to-RDBMS (DB2/Oracle/SQL Server) bulk data loads run by scheduled MS Agent jobs executing SSIS packages and web service (APIs).
• Prepared test data, test scenarios and data summary reports to support the User Acceptance Testing group.

EDW QUALITY ASSURANCE LEAD - ETL/BI

Confidential, Atlanta, GA

Responsibilities:

• Developed complex SQL scripts (DB2) to validate ETL (Abinitio) data flows from source data to relational data mart tables.
• Wrote detailed SQL (BTEQ) to verify the DDL and contents and structure of the Teradata BI reporting views.
• Used Teradata SQL Assistant to write queries to certify MicroStrategy Reports and Dashboards. Imported xxls data into Teradata as actual results and compared with data in underlying BI reporting views.
• Used HP Quality Center to create traceability matrices, test plans, test cases and manage the defect feedback loop for multiple concurrent testing projects.
• Staffed and managed multiple concurrent BI and ETL testing initiatives using both on-site and off-shore testers.
• Prepared Master Test Plans detailing the complete scope of QA testing (Functional, Non-Functional, Implementation & Performance) and presented Master Test Plans to internal review boards for approval.

DATA QUALITY CONSULTANT

Confidential, Baton Rouge, LA

Responsibilities:

• Wrote complex T-SQL queries to validate the ETL process and verify the accuracy of data loads into the Amedisys Data Warehouse. The Amedisys DW sources several operational systems and HL7 message feeds providing a data source for Cognos reports, dashboards and cubes.
• Used Cognos Analysis Studio and MS SQL Server (2008) to verify the accuracy and completeness of data in the Cognos Analytics cubes.
• Validated Cognos BI dashboards by using Analysis Studio to query Cognos reporting cubes and building expected results. Then used Cognos Report Studio to build actual results from reports and dashboards. Exported actual and expected results to SQL Server for comparison using T-SQL queries.
• Created BI Data Dictionaries for Cognos cubes, dashboards and reports.
• Developed the Testing Approach Methodology for the Data Warehouse & Reporting QA group. This includes QA process as well as detailed guidelines, templates and examples describing the procedure used to validate the analytics & reporting deliverables from source data through ETL to BI reporting.

ETL QUALITY ASSURANCE LEAD

Confidential, Atlanta, GA

Responsibilities:

• Designed and implemented the testing approach used to validate the ETL process for the Credit Data Provisioning Warehouse-2 (CDP2). The CDP2 project aggregates data from all SunTrust loan origination, servicing and collateral systems and uses a series of Abinitio ETL graphs to load a rolling 5-year data set into Data Marts used to analyze lending processes, exposure to loss, profitability, default & delinquency, cash-flows, balances, etc.
• Wrote SQL DDL/DML to encapsulate complex transformation logic to into Static Tables, Views and MQTs. These secondary data structures were used as source data by junior members of the ETL testing team.
• Wrote complex DB2 SQL validation queries to create actual and expected result sets used to validate ETL data loads.
• Created DB2 SQL validation query templates used by the ETL testing group to maximize the efficiency and effectiveness of the junior staff members.
• Used HP Quality Center to create a requirements traceability matrix and maintain 1500+ test cases and related SQL test queries & stored procedures.
• Mentored a staff of 20 on-shore/off-shore testers, leads and managers.
• Wrote defect reports, managed the defect-feedback loop and tracked ETL change requests.
• Developed QTP automation approach for ETL test queries and integrated test results into HP Quality Center defect management and reporting systems.
• Liaison between Confidential Vice President of Data & Analytics and the vendor selected to implement the CDP2 project.

SENIOR DATA QUALITY ASSURANCE ANALYST

Confidential, Atlanta, GA

Responsibilities:

• Wrote complex T-SQL queries to validate information presented in the Turner Movie Database; a web application used to schedule television programming and monitor Nielsen ratings performance for 150,000+ titles owned by the Confidential .
• Developed Oracle PL/SQL scripts used to verify the accuracy of the information available in the NewsDesk application. NewsDesk is a resource scheduling web application functioning as the primary tool used by CNN to allocate broadcasting resources and equipment among their worldwide broadcast affiliates.
• Wrote SQL test queries (Oracle 10g & SQL Server 2005) to assist QA Analysts responsible for testing Billing (Millennium), Human Resources, e-commerce (Insiders Advantage), and Scheduling applications.

EDW QUALITY ASSURANCE LEAD

Confidential, Atlanta, GA

Responsibilities:

• Responsible for system testing the ETL process for the Back End Automation and Re-engineering Enterprise Data Warehouse (BEAR EDW).
• BEAR is used to provide analysis for all aspects of the purchasing, receiving and distribution processes for 2000+ Home Depot retail stores.
• Developed complex SQL (DB2) and Brio/Hyperion queries to validate all data extracts and transforms executed in the Abinitio ETL graphs.
• Archived and maintained Test Artifacts including actual vs expected results as well as a suite of regression test queries with baseline data used to test post-release modifications and performance enhancements.
• Used Test Director to create a requirements traceability matrix, manual test cases and Quality Center Test Sets.
• Wrote defect reports, managed the defect feedback loop and tracked ETL change requests using Quality Center.
• MOLAP Cube Validation:
• Led the testing team responsible for QA of the Microsoft Analysis Services cubes in the BEAR EDW project.
• Created the Cube Master Test Plan, Quality Center organizational hierarchy and test query construction standards documents.
• Developed a SQL library used by the QA staff to validate Base Metrics and Calculated Metrics sliced by all Dimensions available in all cubes.
• Wrote LoadRunner scripts used to execute performance tests for the cube data accessed through a ProClarity BI interface.
• Managed and mentored junior testers working both offshore and on-site.

LEAD CONSULTANT

Confidential, Atlanta, GA

Responsibilities:

• Led a team of consultants responsible for implementing ADP Benefits Administration System projects for ADP clients in North America.
• Managed the implementation process including requirements definition, software customization, QA testing, UAT, system deployment and end user documentation.
• Gathered business requirements through client interviews and by reviewing existing applications, policies, processes and documents.
• Developed technical specifications and prepared workflow process models (Visio).
• Set the testing scope for each project, defined test procedures and established schedules for quality assurance and user acceptance testing.

SENIOR DATA VALIDATION ANALYST

Confidential, Atlanta, GA

Responsibilities:

• Senior Data Validation Analyst on the testing team responsible for certifying the operation of the BellSouth Parity Analysis Remedy Information System (PARIS).
• PARIS is a data mining application that sources data from a set of Oracle 9i data marts and uses SAS to statistically evaluate customer service performance for all activity in the nine-state BellSouth service region.
• Developed complex SQL queries (Oracle PL/SQL and SQL Server T-SQL) to extract, aggregate and format data from the warehouse according to the metric calculations described in the technical design documents.
• Created Excel templates to execute the statistical calculations specified in the requirements documents and wrote SQL scripts to compare the values in the Excel spreadsheets (sourced via ODBC) with those calculated by PARIS to validate the system-generated conclusions.
• Used Mercury WinRunner 7.0 to create data-driven test scripts used to automate the Regression Testing process.

QUALITY ASSURANCE MANAGER

Confidential, Atlanta, GA

Responsibilities:

• Established, staffed and managed the Quality Assurance department for a development group that produced enterprise-level utility billing and energy use analysis applications (C++ and VB) sourcing both Sybase and Oracle databases.
• Designed the testing approach, defect reporting process and feedback loop.
• Selected testing tools, maintained the defect database, prioritized defects, designed test case templates, and developed the testing artifacts archival procedures.
• Designed a web site providing remote access to the defect management system for off-site developers and client account representatives.
• Developed a formal release process, established & managed the test lab and produced a matrix of deliverables and responsibilities.
• Conducted performance reviews for QA staff, managed the product release process, and coordinated activities between Development Managers and the Marketing Department.