Sr. Data Warehouse Analyst Resume Profile

OBJECTIVE:

To serve as a software team member in an organization where the following skills and proficiencies will be assets:
Communication skills and strong analytical skills.
Proficiency in application design, performance enhancement, and troubleshooting.
Solid skills with using DataStage, Oracle, and Teradata.

SUMMARY OF QUALIFICATIONS:

Application Development, Maintenance, and Support

Proficient in Source-to-Target data mapping.
Experienced with Physical data modeling using ERWin modeling toolset.
Proficient in the use of DataStage for ETL processes.
Very knowledgeable about the performance tweaks used to improve throughput within DataStage.
Proficient at iInstalleding, configured,configuring and developeding interfaces to multiple applications on multiple platforms.
Expert in Tuned tuning DB2 and OracleSQL queries to significantly improve application performance 15 years .
Proficient at dDevelopeding ad hoc queries requested by the SQL user community 1520 years .

Database Design, Maintenance, and Support

Performed DBA, data analysis, data mining, and data modeler duties 10 12 years .
Analyzed, designed, and maintained elements for data dictionaries.
Significantly reduced the volume of data converted from a legacy system to an Oracle Ddata wWarehouse by 50 using data mining, STAR, and 3NF modeling techniques..
Worked closely with Oracle's Ddata wWarehouse consultants to design and implement a STAR schema data warehouse.
Unloaded legacy data and staged it into a STAR schema warehouse using PL/SQL as ETL, also using DataStage as ETL tool..

Management, Confidential

Mentored junior team members in the use of DataStage for ETL and Data Warehouse operations.
Interacted with management and data analysts to define requirements for and to implement an executive management system.
Consulted with 20 JAVA developers to provide DB2 SQL database support.
Communicated extensively with tech support of third-party vendors to customize their software.
Facilitated multiple JAD sessions with end users and senior technical leads.
Supervised, directed, and aided multiple analysts in troubleshooting. Worked closely with Teradata Data Warehouse consultants and instructors to learn the nuances of Teradata's internal database structure.

WORK EXPERIENCE:

Confidential

Sr. Data Warehouse Analyst

Loaded data into Oracle Data Warehouse using DataStage 8.7 to replace SSIS packages, PL/SQL packages and SQL Loader processes.
Designed and implemented Teradata physical, access, and semantic database layers for use in new Teradata Data Warehouse.
Mentored analysts in the use of DataStage to perform Data Warehousing functions.
Used DataStage Scheduler to aid in unit and QA testing.
Improved performance of nightly batch with query tuning.