Data Warehouse Developer Resume Example THE HOME DEPOT SSC

DATA WAREHOUSE DEVELOPER

Career Overview

I am seeking a competitive and challenging environment where I can serve your organization and establish a career as Data warehouse developer. Extensive experience working on all phases of ETL development lifecycle, from gathering requirements to design, testing, implementation and support *Excellent technical and analytical skills with clear understanding of design goals and far-reaching experience in preparing technical design specifications documents including source to target mapping documents. *Strong leadership and problem solving abilities with experience assisting others and advising them on ETL best practices

Qualifications

Ab Initio
Teradata
UNIX Korn shell
SQL, Hadoop HDFS, HIVE, Python
Cloud Computing with Google BigQuery *IBM Tivoli Workload scheduler
HP Quality Center 10
OOAD, E-R design, MS Project
E-R design, MS Visio
Project management

Work Experience

THE HOME DEPOT SSCJune 2012 to CurrentData Warehouse Developer
Atlanta, GA

Worked with my manager and team leads to review projects' requirements and decide on resource allocation and timing.
Involved in architectural and design discussions of new projects under Supply Chain Data Integration.
Develop data pipelines for moving source data (from Oracle/DB2 LUW) to Google Cloud Platform, and transforming data in Google BigQuery.
Worked closely with Ab Intio ETL infrastructure team to define the sandbox directory structure for each new project.
Provided file space growth estimation to the UNIX infrastructure team and devised archiving strategies for each project.
Redesigned the Ab Initio ETL codes of critical jobs to improve their performance, and reduce their CPU consumption in Production to ensure that they met targeted SLAs.
Worked closely with ETL infrastructure team to grant project check-out/check-in and migration privileges to developers on a need basis.
Communicated with Ab Initio Support to resolve product related issues/concerns such as product integration with Hadoop ecosystem.
Responsible for code promotion from QA to Production environments for projects worked by the offshore team.
Performed clean up on the Standard Sandbox and EME to remove unnecessary files checked-in by other developers.
Extensively worked with UNIX environment and created UNIX processes through the korn shell scripts and worked closely with UNIX administrators to resolve performance related issues.
Designed the schedule and automation of over 50 Ab initio jobs through IBM Tivoli Workload Scheduler (Maestro).
Presented key performance metrics and impact analysis to a Change Control Committee 3 days before deploying every project to production.
Supervised the code migration from Ab Initio 3.1 to Ab Initio 3.4 Performed Ab Initio jobs' performance analysis when the target database was upgraded from Teradata 13 to Teradata 14.
Provided troubleshooting support for code deployed to Production by my team in collaboration with ETL production support.
Responsible for impact analysis and rescheduling of about 32 data movers' jobs following a major upgrade of the DCM (Demand Change Management) system.
Automated scripts to move data between Teradata systems (EDW and DCM).

THE HOME DEPOT SSCMay 2011 to August 2011IT Intern
Atlanta, GA

Developed Ab Initio graphs to extract data from DB2, Oracle, flat files and XML files.
Developed graphs with multiple sub-graphs in a large Teradata database environment with massive parallelism that handled complex data sources.
Used various Ab initio database and program components i.e.
READ MULTIFILE, WRITE MULTIFILE, REFORMAT, NORMALIZE, DE-DUPSORT, ROLLUP, SCAN, LOOKUP on GDE.
Applied data partitioning and parallelism mechanisms to improve code performance.

STRATIXMarch 2010 to November 2010Service Technician
Atlanta, GA

Performed setup, configuration, basic testing and functionalities validation of over 3000 Motorola mobile POS handhelds and truck tracking applications.
Built part of the technical infrastructure required to deploy POS handhelds.

Website Administrator ISHOPABROADOctober 2008 to March 2010Atlanta, GA

Helped maintained the websites functionalities for this company.
Collaborated with development teams to discuss, analyze, and resolve website usability issues.
Identified and addressed interoperability requirements.
Tracked, compiled, and analyzed web sites usage data.
Documented application and web sites changes.

Education and Training

Kennesaw State University (GA)2012MSc: Information SystemsInformation Systems

University of Sunderland2007BSc: Computer StudiesUKComputer Studies

2013TRAINING & Certification:

2013Teradata Corporation *ITIL Foundation Certificate in IT Service Mgt.

2012PinkElephant *Ab Initio Training

Ab Initio Inc.

Skills

automation, basic, Change Management, CPU, Data Integration, database, ETL, XML, graphs, HP, IBM, DB2, ITIL, Korn shell, Maestro, MS Project, 3.1, migration, Motorola, OOAD, Oracle, performance analysis, POS, processes, Project management, promotion, Python, Quality, QA, READ, scripts, SQL, Supply Chain, Teradata, Tivoli, troubleshooting, UNIX, upgrade, validation, Visio, website, web sites, websites

Resume Overview

Companies Worked For:

THE HOME DEPOT SSC
STRATIX
Website Administrator ISHOPABROAD

School Attended

Kennesaw State University (GA)
University of Sunderland

Job Titles Held:

Data Warehouse Developer
IT Intern
Service Technician

Degrees

MSc : Information Systems
BSc : Computer Studies
TRAINING & Certification:
Teradata Corporation *ITIL Foundation Certificate in IT Service Mgt.
PinkElephant *Ab Initio Training
Ab Initio Inc.

Data Warehouse Developer Resume Example

Resume Score: 90%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes