CONTRACTOR, DATA ANALYST Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

CONTRACTOR, DATA ANALYST

Confidential

Responsibilities:

I report, manipulate, and stage data for analysis using Teradata and Tableau. Wif Teradata I optimize queries using Explain. Also, I create worksheets in Tableau wif dynamic components. My work at Confidential involves interpreting data to improve teh Confidential customer experience.

PROGRAMMER ANALYST

Confidential

Responsibilities:

I designed, developed, and implemented an ETL process dat allowed people to query journal data in relational tables. Wif dis process, I migrated teh data from flat tables to a data warehouse. I created ETL scripts dat automatically updated teh relational tables on a multi-terabyte schema. For dis process, I used SQL, PL/SQL, and Unix shell scripts.
Designed, created, and ran Oracle procedures to transform CLOBs wif XML data to load into relational tables using XSLT.
Designed and created Oracle tables, indexes, and constraints.
Created, modified, and debugged UNIX shell scripts and Perl.
Automated file transfers using Windows batch files.
Created Windows batch files for export of SQL Server data.

CONTRACTOR, REGULATORY REPORTING

Confidential

Responsibilities:

I created ETL transformations in Teradata by transferring rules and SQL from an Access database. I also created a QA tool for table data profiles using data dictionary views and BTEQ. dis process loaded tables for Sungard BancWare Capital Manager ODS, a tool for Basel II reporting - critical for banking regulations.
Modified joins, temporary tables, and data distribution to optimize Teradata functionality.

CONTRACTOR, APPLICATIONS SUPPORT

Confidential

Responsibilities:

Coded and executed queries wif SQL and PL/SQL against an Oracle 10g application database to create reports using SQL Navigator 5.1.
Created VBA modules in Outlook & Excel to automate ongoing tasks.

APPLICATIONS SPECIALIST

Confidential

Responsibilities:

In a HP UNIX/Oracle environment, I constructed and validated an ETL processing area for repair of supplier data wif ESP, Ab Initio, UNIX scripts, SQL, PL/SQL, and tuning. Teh processed data exceed 250 GB weekly.
Reviewed and reconciled vendor deliverable documentation, including system design documents, UML diagrams, test cases, and DB design.
Tested and debugged ASP.NET/C# web application using Visual Studio .NET.

CONTRACTOR, DATA WAREHOUSING

Confidential

Responsibilities:

I developed, automated, and documented an ETL process to load a DB2 data warehouse wif healthcare information. dis process streamlined, centralized, and automated existing scripts into a uniform library of Unix functions using Tivoli job scheduler. My work became teh standard for future ETL development.
Developed a utility to parse production database processes using Perl.