SEARCH

Data Warehouse Developer Resume Example

Resume Score: 90%

Love this resume? Build Your Own Now
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 SSC June 2012 to Current Data 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 SSC May 2011 to August 2011 IT 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.
STRATIX March 2010 to November 2010 Service 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 ISHOPABROAD October 2008 to March 2010 Atlanta, 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) 2012 MSc: Information Systems Information Systems
University of Sunderland 2007 BSc: Computer Studies UK Computer Studies
2013 TRAINING & Certification:
2013 Teradata Corporation *ITIL Foundation Certificate in IT Service Mgt.
2012 PinkElephant *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
Build Your Own Now

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.

Advertisement

Similar Resumes

View All

Data Warehouse Developer

Deloitte Consulting LLP

Camp Hill, Pennsylvania

Posted 1351 days ago