TECHNICAL SKILLS

Operating Systems: Windows 7, Windows XP, Windows 10, Linux, Unix

Tools: Datstage, Veritca, CA Autosys 11.4, Teradata Parallel Transporter, shell scripting, Toad DataPoint 5.2, Oracle SQL Developer, Teradata SQL Assistant, BTEQ, SQL SSIS, Red Gate SQL Data Compare, Quality Center, Perl, Jira

BI: MicroStrategy, Business Objects

Databases: Teradata, SQL Server, DB2, Oracle

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

Developer

Responsibilities:

• Ran and monitored scheduler jobs in CA’s Autosys workload automation tool
• Troubleshoot, identified and corrected errors in scheduler jobs involving Datastage jobs and shell scripts.
• Coordinated with offshore team with handoffs between shifts.

Confidential - Richardson, TX

Developer

Responsibilities:

• Implemented Datastage jobs and migrated them to production.
• Developed a scheduled process to extract data from the enterprise data warehouse into flat files for outside customers using Korn shell scripts and Teradata Parallel Transporter scripting.
• SQL Server DBA in support of the Sales Channel project.
• Teradata developer developing extracts for Mede Analytics.
• Training for UiPath robotic process automation

Confidential - Dallas, TX

ETL tester

Responsibilities:

• Verified ETL data loads of Ab Initio graphs using unix shell scripting and SQL queries.
• Developed and documented the process for detecting duplicates in flat files using PERL and Korn shell scripting.
• Developed a repeatable process to perform source to target tests of JMS messages from TIBCO message queues to Oracle staging databases and the Teradata data warehouse.
• Developed data profile, data verification tests for a Teradata data warehouse, 2 Tb capacity with 179 tables.
• Wrote and executed 265 EDW test cases using Quality Center
• Created the BRD and the data mapping document for the Paxfinder SOA application, mapping the xml elements to the web interface.
• Developed and documented a test process to verify xml source messages against Teradata data warehouse

Confidential - Frisco, TX

Consultant

Responsibilities:

• Verify ETL jobs in DataStage
• Write data validation queries for ETL jobs.
• Test lead for BI project with AT&T, reportingUverseandDSL Sales.
• Verified MircroStrategy reports using SQL queries in Oracle
• Verified report metrics using SQL queries in Oracle
• Verified ETL loads from staging to the production databases

Confidential - Dallas, TX

Analyst - Data Warehouse

Responsibilities:

• Developed test process for the transformations of complex XML source data.
• Developed CPOE module (Computerized Physician Order Entry) tests verifying consistency between ICD-9 codes and diagnosis descriptions.
• Managed and executed over 369 test cases covering ETL, XML data transformations, and stored procedures for the release of the new Confidential data warehouse product.
• Wrote custom stored procedures to support the ETL testing process.
• Utilized SQL Server administrative tools SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration in testing.
• Worked with client databases larger than 100 Gb. (351 tables and 46 M records, Windows 2003 OS with SQL server 2000/2005)
• Created test SQL scripts for random sampling of data transformation for large datasets (> 1M records)
• Utilized HL7 message tools in testing system messages.

Confidential - Dallas, TX

Data Analyst

Responsibilities:

• Provided data verification for a new property staging database comprised of 172 tables and 259 M records
• Used Quality Center to manage test scripts to test 38 stored procedures for the Confidential property cache database
• Wrote SQL scripts generating test data to test stored procedures for the property cache database.
• Wrote batch queries to monitor the staging database using the SQLCMD utility for SQL Server
• Responsible for testing the ETL process created with SSIS.
• Verified the correct loading of data files for Hotel inventory from Expedia and Sabre.

Confidential - Plano, TX

Consultant

Responsibilities:

• Developed a method to test random samples from flat files to delivery tables.
• Tested Informatica ETL processes against business requirements
• Developed scripts to verify consistent DDL of new database changes.
• Tested orphan and cleaner rules using korn shell scripts.
• Developed batch SQL scripts for data validation in DB2 and Sybase.
• Wrote korn shell scripts to test random samples of database tables in DB2 and Sybase.
• Tested data loads using Business Objects against data warehouse extracts.
• Managed test cases with Test Director for specialized testing of Informatica ETL processes.

Confidential - Richardson, TX

Data Analyst Enterprise Data Warehouse

Responsibilities:

• Wrote data transformation rules for new data elements in the data mart.
• Developed test SQL queries in Teradata to certifying data transformation rules were applied correctly.
• Performed data quality testing for the enterprise data warehouse.
• Uncovered data errors caused by the ETL process and recommended changes to the transformation rule to fix the problem.
• Executed data verification for web based customer reports, and flat files.

Confidential - Richardson, TX

QA Lead

Responsibilities:

• Quality assurance lead for the Mail Pharmacy managing three QA analysts
• Developed a test strategy for the online Drug System verifying test results against the Oracle 8i using TOAD.
• Programmed automated test scripts using WinRunner 7.0 for AdvancePCS RxSavings Plan web page.
• Decreased testing times by programming SQL queries to identify test data in AS/400, Sybase and Oracle databases.