Data Warehouse Developer Resume Profile Atlanta, GA - Hire IT People

PROFESSIONAL SUMMARY

Over 15 years of database development experience with DB2, Oracle, and SQL Server
Experience developing both relational and dimensional data models.
Comprehensive knowledge of Data Warehouse architectures.
Excellent SQL and PL/SQL tuning skills.
Developed database applications on multiple platforms including MVS, Unix, Linux and Windows.
A hardworking team player with result oriented approach to problem solving with willingness to adapt to new technologies as well as helping Team members to meet the Target dates.

TECHNICAL SKILLS

Data Base Systems: Oracle 9i, 10g, 11g, RAC,Oracle Exadata, DB2, MS Access, VSAM, IMS, SQL 2008

Programming Languages: SQL, PL SQL, UNIX Shell, COBOL, JCL, CICS,

ETL Tools: Oracle Warehouse Builder OWB , Informatica Power Center 8.6 9.1, SQL Server Integration Services SSIS

Data Modeling Tools: Erwin, Embarcadero ER Studio, Visio

Operating Systems: Linux, UNIX, MVS/TSO ISPF, CICS, Dos, Windows

Confidential

Pincipal Consultant

Assess previous unsuccessful atempts to develop a Data Warehouse.
Develop a logical dimensional model for reporting and analytics.
Design a secure framework for consuming extract files from desparate sources.
Develop encryption policies to insure HIPPA compliance.
Assist in laying out a project plan.

Confidential

Senior IT Admin Enterprise Business Intelligence Operations

Trouble shoot and perform root cause analysis for ETL failures and data issues.
Collaborate with ETL design teams to insure supportability, and adherence to data governance policies.
Collaborate with off shore support teams to insure proper coverage and monitoring.
Collaborate with production DBA team to review ETL database errors, troubleshoot EXADATA issues, review maintenance and upgrade plans, identify and tune poor performing database processes.
Perform run time trend analysis and failure rate reporting to identify trouble areas.
Key participant in the migration of Informatica Power Center from version 8.6 to 9.1.
Key participant in the migration of the Cox's Data Warehouse from Exadata V2 to X2.
Research and resolve OBIEE Reporting performance and data issues.

ETL DBA - FTE

Primary responsibility was to provide 24/7 on call DBA support, and insure ETL processes completed within given SLA.

Key responsibilities

Provide 24/7 on call DBA support for ETL failures.
Performance tune existing ETL processes.
Develop new ETL processes.
Research and resolve MicroStrategy Reporting performance and data issues.

Data Warehouse Developer - FTE

Key responsibilities

Design and develop the logical and physical data marts for the Diversified Financial Services Data Warehouse.
Design and developed ETL processes using Oracle Warehouse Builder, PL SQL, and Unix Shell scripts.
Provided tier 2 and tier 3 support for all ETL processes
Research and resolve Cognos Reporting performance and data issues.
Performance tuning of all ETL processes, was able to achieve a 25 reduction in overall run time.

Mainframe Programmer- Contract

Key responsibilities

Research, repair, and test problem tickets entered for the ACS Pharmacy Claims Adjudication Process.

ETL Developer Contract

Key responsibilities

Design and develop ETL processes to load commercial account transactions into the OASIS Oracle Data Warehouse.
ETL was developed using COBOL/DB2, EASYTRIEVE, JCL, Unix Shell scripts, PL SQL, and Oracle SQL Loader.

Data Warehouse Developer - Contract

Key responsibilities

Designe and develop logical and physical data marts for the Episode of Service Data Warehouse.
Developed ETL processes using APS Cobol, and PL SQL to source from the GENESYS Call Tracking system and load into a DB2 Data Warehouse.

Database Developer

Key responsibilities

Developed external specifications to extract and load Tesseract, GEAC, and Genesys HR information into the Total Compensation Data Warehouse.
Developed ETL transactions using COBOL, DB2, VSAM, JCL, SORT, and DB2 Utilities to extract, reformat and load HR and Payroll data into the Total Compensation Data Warehouse.

Programmer Analyst

Key responsibilities

Support, maintain and enhance Tesseract's Next Dimension Web Engine. This product is the middleware tier between Tesseract's host database and the Neon Shadow Web Server.

Programmer Analyst

Key responsibilities

Supported, maintained and enhanced the County of Alameda's Automated Warrant System. AWS allows Law Enforcement officers to query court issued warrants in real time.
Assisted in the Y2K remediation and testing.

Programmer Analyst

Key responsibilities

Developed and maintained Chevron's Credit Card Processing System. Primary area of responsibility was the development and maintenance of the Account Maintenance COBOL/DB2/CICS transactions.

We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume Profile

Atlanta, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship