TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, Sybase, MS SQL Server, MySQL, MS Access, PostgreSQL, Oracle Exadata, Oracle Database Appliance (ODA), Amazon AWS RDS/Redshift

Data Modeling Tools:  ERwin/ModelMart v9.x. Toad Data Modeler v3.x, ERStudio v8.x, Visio

Database Administration Tools:  Toad, Quest Spotlight, Oracle Enterprise Manger (OEM), SQL Developer, MS Enterprise Manager, MS Query Analyzer, MysqlCC, MySQL Workbench. Tableau

Data Warehousing Integration:  SAP Business Objects, XCelsius/SAP Dashboards, Crystal Reports, Microstrategy, BrioInformatica, Ab Initio, SAP Business Objects Data Integrator/Data Services

Data Warehousing Architectures:  Ralph Kimball methodology implementations, Bill Inmon methodology implementations, and hybrid solutions of both theories.

Platforms: Unix SunOS/Solaris, HP - UX, RedHat/Mandrake, FreeBSD

Microsoft: Windows Server 2003/2008/2008 R2

PC/Tools:  Microsoft Visual SourceSafe, WinCVS, SVN/Subversion/Tortoise. Cygwin, Microsoft Project, Microsoft Visio. Jira, Crucible, Wiki. SharePoint/MOSS. Control-M.

Methodologies:  Experienced with SDLC/Waterfall, Rapid Application development and Agile/Scrum/Kanban methodologies. Certified Scrum Master (CSM).

Languages:  Bourne, Korn and C shells, Perl (v5.8) sed, awk, HTML, some Wiki markup. SQL (T-Sql, PL/Sql). Perl/cgi-bin, Some JavaScript, some XML. Dos cmd/batch. Limited Visual Basic Script (VBScript), Limited Informatica.

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Senior Data Architect Consultant

• Lead technologist on the Database Scalability initiative, charged with evaluating existing database operations and recommending future database solutions for the entirety of Confidential ’s production database infrastructure. Conducted current state analysis on scalability topics related to security, performance, workload management, backup & recovery, high availability and disaster recovery.
• Evaluated multiple solutions for Database Scalability, including Oracle Database Appliance (ODA), Oracle Exadata, Amazon RDS/Redshift, and Oracle 12c new features (In-Memory, multi-tenant, Data Masking/Redaction). Wrote RFP for the $1.2M capital project and assisted in interviews/selection.

Confidential, Arlington, VA. 

Data Architect and Technical Lead for the GFMS Business Intelligence/DW Program

• Provided technical leadership for multiple BI initiatives, including Dashboard development, product upgrades, SAP HANA/Explorer POCs, and prod support.
• Designed Data Warehouse Architecture standards for dashboard development initiatives.
• Implemented an Inmon-Kimball hybrid Data Warehouse architecture with 3NF middle tier layer focused on Data Governance and conformed Dimensions from multiple data sources.
• Lead all Data Architecture activities for the warehouse and XCelsius dashboard initiatives.
• Performed all data modeling activity, including Conceptual, Logical and Physical modeling of 3NF and Dimensional schemas.
• Utilized ERwin and ModelMart to centralize and organize multiple subject area data models.
• Served as Scrum Master of several Agile sprints of Dashboard implementations. Coordinated efforts of Agile team, led daily sprints, led requirements gathering sessions, managed product back log, and provided technical leadership.
• Nature of the data is primarily Financial/General Ledger data consumed from Momentum source.

Confidential, McLean, VA

Database Architect and Team Lead 

• Designed and coordinated the multi-Oracle development database architecture for POC effort.
• Installed, configured, and maintained 4 development Oracle databases running 11g with RAC running over Redhat Linux 2.6.18.
• Developed and implemented the data migration architecture reading from legacy Microsoft SQL Server instances and being processed by Ab Initio.
• Designed ETL strategy and produced source-to-target mappings for Ab Initio developers.
• Performed data model analysis and re-design of a 200-table legacy model and converted the model to Oracle using Toad Data Modeler tool.
• Re-design included naming convention consolidation, expansion of data model logic to include new functionality, and denormalization for performance.

Confidential, Wash DC

Data Warehouse Architect and DBA Team Lead 

• Lead all data acquisition, data analysis and incorporation of new data sources to existing data warehouse.
• Perform requirements analysis, staging and dimensional data modeling, create source to target mappings and metadata/data dictionaries for incoming data sets.
• Manage the DBA team and direct other technical resources (business and data analysts)
• Designed ETL Architecture and lead Informatica ETL team to replace PL/SQL ETL code.
• Develop, test and implement custom GIS-enabled ETL code written in Visual Basic script (VBscript) and PL/SQL packages.
• Supported front end developers coding in Google Maps (KML extracts), Mobile web browsers, CSV/XLS downloads, Business Objects, XCelsius Dashboards, custom PL/SQL extracts, RSS feed.
• Serve as Lead DBA supporting a Grid-monitored Oracle 10g RAC clustered database using physical Data Guard failover and Streams on Windows Server 2003/RedHat Linux.

Confidential, Washington DC

Database and Data Warehouse Consultant

• Lead Oracle Database Administrator for the development and deployment of the Advisory Board’s (ABC) Business Intelligence (BI) reporting products and services. Managed 2 junior DBAs
• Provided Data Warehouse architecture consulting as needed while stabilizing Oracle operations.
• Maintained ten separate Oracle 10g databases on various platforms (Solaris, Linux, Windows) supporting four distinct BI initiatives within ABC.
• Stabilized entire production database environment, building all basic operational infrastructure while actively deploying BI products.
• Served as Development DBA, supporting a development team of 75 developers.
• Created database artifact configuration management strategy and created over 2200 SQL and documentation files.

Confidential, Fairfax, VA

Lead Technical Consultant/Oracle Database Architect

• Served as Database Architect and lead Database Administrator for the development and deployment of the Enterprise Human Resources Initiative (eHRI).
• Designed and implemented a 700gb Oracle 9i HR Data Warehouse (DW) using Oracle best practices DW physical configuration.