An accomplished Information Architect and Database Administrator with demonstrated success in designing, developing, and implementing information solutions that have greatly improved business functionality. A well-seasoned technical background spanning multiple types of information systems including structured and unstructured data. I am a gifted professional with an enormous amount of experience in the design, development, and implementation of Traditional, Big Data and Cloud Systems. I also possess the ability to handle multiple tasks, manage, and mentor teams. I am also accomplished at decreasing overall information system cost and improving enterprise productivity.

QUALIFICATION HIGHLIGHTS

Expert Information Architect with 34 years of experience

Expert Database Administrator utilizing Oracle, SQL Server, Sybase, MongoDB, Amazon RDS (DynamoDB, MySQL, Postgres, and Redshift) Azure DB, IRIS DB

Expert Decision Support Architect. Responsible for designing, administrating, and implementing Big Data, Data Warehouse, Data Lakes, Lakehouse, Data Mart, and Data Mining applications.

Certifications:

TECHNICAL EXPERTISE

Databases Oracle (Version 5 through Version 21c),

SQL Server (Version 6.5 through Version 2019),

Sybase (Version 4 through Version 12), Azure DB, Cassandra,

MongoDB (Version 2.6.4), Netezza (Release 7.2.1.4)

AWS RDS, AWS Redshift, Snowflake, Google BigQuery, IRIS

Cloud Platforms AWS, Azure, GCP, OCI

Software Erwin, Oracle Designor, Oracle Enterprise Manager, Oracle

RMAN, PowerDesignor, Informatica PowerCenter,

Informatica Data Quality, SSIS, SSRS, IBM MQ Series,

MS Office, MS Project, System Architect, SAP, GIT, JBOSS,

TIPCO, Siperian. Quest Toad, Quest Shareplex, Essbase,

Autosys, Hyperion, BMC Patrol, Microsoft Data Quality\

Services, Data Quality (FirstLogic). AWS (Glue, Athena, S3, Streams, EMR, EC2, ML, Lambda, Redshift Spectrum)

Operating Systems Sun Solaris, MS Windows, Red Hat Linux, HP/UX,

SCO UNIX, IBM AIX

Languages Python, Spark, Scala, C, Java, SQL, PL/SQL, T-SQL,

Perl, Shell Scripting, Numerous 3GL Programming Languages

EXPERIENCE

Fontanelle Software Services, Oreland, PA November 2014 – Present

Senior Solutions Architect and Data/Database Architect

Senior Solutions Architect of a software consulting firm. Specialized in Information Systems Architecture, Relational Database Administration, Relational and Object Data Modeling, Data Warehousing and Decision Support Design (OLAP and Data Mining), Database Programming and SAP, PeopleSoft, and Oracle Applications Database Administration.

Senior Data Architect for MAS (JPMC) Project

Responsible for the following:

oParticipated in initial proposal to JPMC

oDeveloped architecture for data pipeline connecting Cassandra to AWS RedShift.

Accomplished utilizing DB Triggers, Kafka Messaging, and Lambda Functions

Senior Data Architect for Broadridge Inc. (WMAP) Project

Responsible for the following:

oLogical models of 22 subject areas

oClient/Search data model and ETL of all staging tables

oScala programs for high volume and high-speed loading operations utilizing AWS Glue

Senior Data Architect for Mortgage Connect

Responsible for following:

oLong-term and medium-term data strategies

oConversion of application data projects from on-premises dev-ops to a cloud-based Azure dev-ops strategy.

oDevelopment of database pipelines utilizing Azure DB, open-source repositories, and MS Database Projects

oImplementation of Azure DB converting from on-premise databases

Senior Solution Architect for Sanofi Pharmaceutical’s SURF (Sanofi Upgrade to Revitas Flex) Project

Responsible for the following:

oOversight over the technical delivery of the project

oReview and monitor relational data structures, data and process models for all environments together with internal Sanofi teams and external application teams

oReview and analyze boundary system dependencies and ensure the data flows are in good standing.

oResponsible for the effective coordination, communication, planning and/or validation of SDLC activities and reporting

oPrepare documentation including but not limited to

Unified Cutover Plan

Unified Data Migration Plan

Performance Testing Plan

Disaster Recovery Plan

High Availability Plan

Pre-go live signoff

Post go-live signoff

Post go-live infrastructure check list

oPerform quality control and process and technical documentation

oCreation of technical design and operations documentation

oKnowledge transfer

oAWS Services utilized (EC2, S3, and ElasticSearch) as on-cloud deployment option.

Data Architect for Wiley Publishing Business Management Information System (BMIS) Project

(Netezza Release 7.2.1.4, Erwin 9.64, Cognos, Qlik)

Responsible for all data architecture tasks related to BMIS project. The BMIS projects included:

oExtraction and Mapping from an SAP system

oCreation of multiple star schemas including

Sales

Invoices

Revenue Recognition

Sales Targeting

oCreation of conversion layer star schemas that incorporate legacy data with the above-mentioned star schemas

oCreation of aggregate level tables and cubes used to support BI development

oAWS Services utilized (Oracle, EC2, S3, Glacier, Redshift)

oHadoop – Loading and querying of large volumes of data.

Data Architect and Database Administrator for PHH Mortgage’s Technical Transformation Project

(Oracle 9, 11g, 12c, SQL Server 2014, Sybase 12, Erwin 9.64, SQL Developer, Quest TOAD)

Responsible for all data architecture, data mapping and database administration tasks related to Technical Transformation projects. The Technical Transformation projects included:

oNew LOS (Loan Origination System)

oEnterprise Data Dictionary Repository

oESMS (Enterprise Software Management System)

oLG (Lead Generation), Data Archiving using Mongo DB

oCL (Scoping and prototype for Correspondent Lending)

oEstablishment of ERwin Metamodel Repository

oAWS Services (Oracle, EC2, S3, and ElasticSearch)

Computer Sciences Corporation, Berwyn, PA

Big Data and Data Warehousing Group, Principal Consultant April 2005 – October 2014

Principal Consultant Level database expert. Database expert position encompasses Big Data, Data Warehouse architecture, ETL Architecture and Programming, Database Administration and Data Modeling.

ETL Architect for AECON Project (Informatica PowerCenter, Informatica Data Quality, Microsoft SQL Server, Microsoft SQL Server Integration Services – SSIS, SAP). Team lead for ETL group, group encompasses six people located in three different countries. Group is responsible for migrating multiple data sources into a new SAP environment.

Source systems included:

oSQL Server Databases

oIntuit QuickBooks Systems

oIBM ISAM Files

oUnstructured Data – Documents of multiple formats (Big Data concepts used)

Project Manager for Shire Pharmaceutical’s Database Re-Architecture initiative. Shire is a specialty biopharmaceutical company that focuses on meeting the needs of the specialist physician. Shire focuses its business on attention deficit and hyperactivity disorder (ADHD), gastrointestinal (GI) diseases, human genetic therapies (HGT) and regenerative medicine (RM), as well as opportunities in other therapeutic areas. I was responsible to lead and manage a group of twenty-seven people (DBA’s, Process Designers, Testers, etc.) spread across three different countries. The group was responsible for re-architecting 2400 Oracle and SQL Server databases. The group concentrated on the following areas:

oMonitoring

oBackup and Recovery

oDatabase Lab

oStandard Installation and Creation Configurations

oAWS Services (EC2, S3, RDS)

ETL Architect for CONED Project (Informatica PowerCenter, Oracle, PL/SQL). Team lead for ETL group, group encompasses seven people spread across several continents.

Technical Lead for Data Integration Layer (DIL) (Informatica PowerCenter, Informatica B2B, SQL Server, Web Services) for American Life Insurance Company (ALICO). ALICO is a subsidiary of Metlife Corporation. ALICO’s primary business is delivering and managing life insurance to non-US countries. The DIL was created to automatically manage the distribution and flow of data sets between internal and external ALICO partners.

Source systems included:

oSQL Server Databases

oUnstructured Data – Microsoft Work Documents (Big Data concepts used)

Team Lead for Database Administration for United Launch Alliance (ULA) Corporation. ULA is a company that was created to combine the rocket launching capabilities of both the Boeing Corporation and the Lockheed Martin Corporation. I was responsible and lead a group of twelve DBA’s spread across four different time zones. The group was responsible for managing 400 databases residing on one hundred different servers. The databases that were managed consisted of Oracle, SQL Server and Sybase databases. The team was also responsible for managing all data warehousing activities.

Team Lead for Master Data Management, Data Warehousing, Data Analytics and Data Governance project for Hess Corporation, group encompasses multiple people. Project utilizes Data Maturity Models, Data Governance Models, product selection for Master Data Management (Siperian MDM, IBM WCC), Data Quality (Business Objects – Firstlogic, Trillium) and Business Intelligence (Microstrategy, Business Objects, Cognos) tools.

Team contributor for a performance engineering group, group encompasses 10 people and was responsible for a major DOD application performance improvements. Project utilized (Sybase, JBoss, Java, Powerbuilder, CA Introspec, PL/SQL, and Shell Scripts). Obtained Top-Secret clearance.

Team Lead of Multi-dimensional cube development group for Verizon Financial Project, group encompassed five people. Project utilized (Oracle 10g, PL/SQL, Shell Scripts, Hyperion Essbase, and Hyperion MDM)

ETL Architect for DLL Project (IBM Datastage, IBM Metastage, Oracle, PL/SQL, Oracle Portal)

Team lead for ETL group, group encompasses seven people spread across multiple continents.

Lockheed Martin, Valley Forge, PA

Database Architect Staff April 2004 – April 2005

Staff level database architect. Database architect position encompasses database programming, database administration and data modeling.

Database Architect for IR&D Project for Message Routing Service for Guards (MQ Series, Oracle, Messaging)

Database Architect for TMOS Proposal (Oracle, Messaging, Multilevel Security, SOA)

Database Architect for UCIDS Proposal (Multilevel Security, Adhoc Networks)

Project Leader for Formal Training Curriculum (Various Subjects)

Database Architect for the Evolutionary Environment Project (SQL Server, Expert Systems)

Database Administrator for the Charitable Giving (United Way) Project (Oracle, PL/SQL)

Database Architect for the GRID Project (internal capabilities project) (SQL Server, DTS)

Mentor of Junior Level co-workers

Fontanelle Software Services, Oreland, PA September 1995 – March 2004

Senior Database Architect and Senior Database Administrator

Senior Database Architect of a software consulting firm. Specialized in Information Systems Architecture, Relational Database Administration, Relational and Object Data Modeling, Data Warehousing and Decision Support Design (OLAP and Data Mining), Database Programming and SAP, Peoplesoft, and Oracle Applications Database Administration.

Boeing Corporation Senior Database Architect and Senior Database Administrator

(Oracle 9i, SQL Server 2000, Oracle Designer,

Data Warehousing, Datastage)

Drexel University Adjunct Teacher – Oracle 9i Certification Curriculum

(Oracle 9i)

VIPS Corporation Senior Database Architect

(Oracle, Erwin, Informatica)

Computer Science Corporation Senior Database Architect

(Oracle, CA Unicenter, Quest Shareplex)

True Position Senior Database Administrator and Team Lead

(Oracle, Erwin)

Automated Data Processing Senior Database Administrator

(Oracle, Erwin, Oracle Applications)

Susquehanna Investment Partners Senior Database Architect and Senior Database Administrator

And Team Lead (Oracle, SQL Server, Data Marts, Tivoli)

Wyeth-Ayerst Laboratories Senior Database Administrator and Team Lead

(Oracle, PowerDesignor, SAP, Peoplesoft,

Data Warehousing)

IMS Incorporated Senior Database Architect (Oracle, Data Warehousing)

Bentley Systems Senior Database Administrator (Oracle, SQL Server, Erwin)

First USA Bank Senior Database Administrator and Team Lead

(Oracle, Erwin, Data Warehousing)

Premier Solutions, Malvern, PA October 1994 – September 1995

Senior Database Architect and Senior Database Administrator

Responsible for database architecture and relational database administration in a multi-platform environment consisting of Alpha OpenVMS, HP9000 and Pentiums PC’s, running the OPENVMS, HP/UX and MS-DOS (Windows) operating systems, respectively.

Senior database architect for a large monetary trust management system. System included over 600 tables and 2300 indexes. The system incorporated a generic data model that was customizable for multiple customers.

Senior database administrator responsible for implementing and customizing physical database design.

Walklett Burns Ltd., Great Valley, PA October 1993 – October 1994

Senior Software Engineer

Responsibilities included database administration, software development and project leadership in a multi-platform environment. The environment consisted of VAX clusters (Oracle Parallel Server), and 386/486 microcomputers, running the VMS, MS-DOS (Windows) operating systems.

Database Administrator of FIX Development Team

Team leader of FIX Data Conversion Project

Naval Ship Systems Engineering Station October 1988 – June 1994

Philadelphia, PA

Computer Engineer and Project Leader

Responsibilities included project leadership, software development and database administration in a multi-platform environment. The environment consisted of VAX Clusters (Oracle Parallel Server), Hewlett Packard, SUN and 386/486 microcomputers, running the VMS, UNIX and MS-DOS (Windows) operating systems.

Database Administrator of Central VAX/VMS ORACLE Site

Project Leader of Aegis Information System

Programmer of Specialized Naval Inventory System

Project Leader of Ship Maintenance Cabling System

Project Leader of Knowledge Based Authoring System

Programmer of Integrated Survivability Management System

Project Leader of Flooding Casualty Control System

EDUCATION

La Salle University, Philadelphia, PA

Bachelor of Arts in Computer Science (1988)

Currently Attending:

Penn State University, Great Valley, PA

Master of Science in Information Sciences

Contact this candidate