[misc] Dean Geary - DB Developer/Designer/Modeler/Architect

[Profile Register/Log In] (What's This?)

Dada Mail » misc » Archives » [misc] Dean Geary - DB Developer/Designer/Modeler/Architect

From: "Green, Leslie" <lgreen@sesc.com>
Subject: [misc] Dean Geary - DB Developer/Designer/Modeler/Architect
Date: Fri Jun 14 04:35:55 2013

Hi RMIUG’ers,

I would like to refer to Dean Geary to the group. He’s an excellent DB professional and he just came off of a project. He’s worked for me twice and I highly recommend him for any Database role from Development and ETL to Design and Modeling to Architecture. Though I’d love to keep him working, we just do not have a spot for him right now. Please contact him directly for new job opportunities.

THANKS!

Dean A. Geary

dgeary2874@q.com, 719-964-0363

Summary: Expertise in Oracle Server, data warehousing, database design and management. Skilled with data manipulation tools, including ETL, XML, and batch processing functions. Demonstrated experience in performance tuning of SQL, procedures, and jobs within the database.

Database Architect

System Engineering Services Corporation/Worldpay US

August 2011 to present

· Analyzed Cobol copy book files with clients subject matter experts to develop dimensional and fact attributes and definitions. Designed Data Warehouse for OBIEE implementation utilizing the Kimball method of Data warehouse design.

· Developed 3 phase architecture plan to migrate data, replace datastore with Kimball dimensional model in support of new business portal.

· Adapted design proposal to Worldpay Global strategy.

· Database lead for Royal Bank of Scotland migration proposal and design team. Engineered migration strategy, tools, manpower level of effort/budget assessments.

· Managed database team of 1 data modeler, 7 local database developers and 2 remote database developers for migration of Sybase ASE 15 database to Oracle.

ETL Developer

System Engineering Services Corporation/Barclay Card US

October 2010 to August 2011

ETL Development Lead
Proposed and spearheaded new direction of single stage ETL utilizing Oracle External Tables and pipelined functions for the data warehouse. The first implementation stage reduced batch job time by over 20%. This also reduced the physical storage size in the database 100%. The target data mart eliminated the staging and transform layers from the database.
Developed PL/SQL ETL jobs for Credit Card Processing in numerous data warehouse and data mart environments, processing data from multiple sources utilizing Oracle pipelined functions and external tables.
Developed Korn shell scripts for the inclusion of ETL jobs in the batch stream.
Performed maintenance and tuning of existing jobs to meet regulatory requirements.

Database Developer
DaVita Inc., July 2009 to October 2010

Designed and implemented XML framework of packages to over 20 external entities supporting the government HL7 file format. Re-factored existing interfaces to standardize the inbound and outbound XML to the HL7 file format saving an average of 700 lines of coding per entity. This also produced a non-quantifiable savings in testing, debugging, and QA regression testing time.

Database Analyst

L-3 Communications and AFSCN contract, July 2006 to April 2009

Lead DBA in database re-design effort for ESD 3.0. Analyzed and redefined data definitions and dictionary to facilitate proper modeling and normalization of database.
Designed and developed extensive Oracle 10g packages and procedures utilizing TOAD to support application Data Access Layer of the ESD 3.0 database.
Designed a menu driven set of Korn shell scripts allowing the test team controlled access to internal database functions, to manage schemas and data sets during the test cycles saving hundreds of hours of DBA support for the test team.
Designed Korn Shell scripts and packages to add/rebuild Oracle advanced replication across the network. These were later modified to use Oracle Streams.

Database Analyst

Verizon Business Colorado Springs, Co November 2004 to July 2006

Designed and developed the Location Directory Phonebook Oracle 10g database to specification from Use Cases.
Managed package and procedure development in TOAD, of batch processing and XML output thru web based access.
Achieved 67% decrease in process run time of rewritten PL/SQL procedures through performance tuning.
Designed Oracle portal database to marketing requirements including procedure standards, security, and XML.
Analyzed Marimba documents and standards for developing requirements of custom Marimba database.