STRENGTHS:

• Database Infrastructure
• Data Architecture
• Data Modeling
• Data Profiling
• Metadata Mgmt.

SKILLS / UTILITIES:

Modeling Tools: ERwin, ER/Studio, Enterprise Architect, Power Designer, System Architect

RDBMS: SQL Server, Oracle, Teradata, Informix, Non - Stop SQL, DB2

Tools & Utilities: SSMS, SQL Developer, SQuirrelSQL, Data Studio, Notepad++, Beyond Compare, SVN, TortiseSVN, HP ALM, VersionOne, MS TFS, MS Office, SharePoint, Teamwork, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Lead Data Architect

Responsibilities:

• Responsibilities included setup and administration of ER/Studio Enterprise environment and a SharePoint document library to publish data models and data dictionaries for 300+ legacy databases.
• Data Architecture Principles
• Data Modeling Standards
• Data Model Scorecard
• Data Classification Capture & Maint. Using ER/Studio
• ER/Studio macros to facilitate the above

Confidential

Vacation Ownership

Responsibilities:

• Lead Data Architect on a conversion / enhancement project transitioning an application from SQL Server / .NET platform to Oracle / Java.
• Assisted with defining / cataloging the current state architecture including inventory and assessment of existing data stores as well as documenting current data flows.
• Designed and developed the database architecture and standards for the new application to ensure alignment with business and IT objectives which includes:
• Creation and maintenance of Process and Data Flow diagrams using PowerPoint
• Creation and maintenance of Conceptual, Logical and Physical data models using ERwin
• Generation of table, sequence and permissions DDL scripts to instantiate Physical data models within client database instances

Confidential

Senior Data Architect / Data Modeler

Responsibilities:

• Preparing and presenting Conceptual data model diagrams using Embarcadero's ER Studio Data Architect to communicate recommended scope and direction to the review board and project teams.
• Developing and presenting Logical and Physical data models according to corporate data standards for both agile and waterfall project methodologies, across Oracle, SQL Server and Teradata platforms.
• Ensuring alignment with enterprise strategic direction for data management, naming standards and data modeling best practices.

Confidential

Data Architect

Responsibilities:

• Designed and implemented a metadata repository to store and expose the data dictionary, ETL logic and run logs and data lineage
• Data modeling and DDL generation for a highly normalized ODS to support the current legacy systems’ data and the “to be created”, next generation operational system
• Data modeling and DDL generation for a number of dimensional data marts

Confidential

Client Solutions Lead

Responsibilities:

• Lead the data consulting teams on client engagements
• Worked with client project managers to facilitate data discovery, mapping, extract and transmissions to Confidential

Confidential

Data Warehouse Architect

Responsibilities:

• Hardware and software selection, purchase and installation
• Design and implementation of metadata structures to maintain the Data Dictionary, Source-To-Target Data Mapping, ETL Derivation, Validation & Disposition logic, Data Profiling Results, Data Quality and Usage statistics and Research Project information
• Data modeling and DDL generation for a highly normalized ODS to store data from multiple subject areas including Cancer Registry, Radiology, Radiomics, Bio-Banking, LIMS, Microarray and Patient Survey

Confidential

Principal / Client Solutions Lead

Responsibilities:

• Data model maintenance and change management with the development staff in the Confidential Republic
• Project management over Proof of Concept data loads
• Business requirements analysis, data analysis, metadata management, project management, customer support, authoring documentation, developing a training curriculum, presenting training, product sales demonstrations, functionality and performance testing and both product and strategic planning

Confidential

Sr. Consultant

Responsibilities:

• Developed groups of Data Warehouse, Business Objects reports for the Finance organization including a series of Pricing Adjustments audit and trend reports and Data Warehouse summary calculation validation reports
• Developed processes, procedures and tools to perform “data readiness” analysis as part of ERP system upgrades and conversions
• Expedited a huge data cleansing effort by developing a utility to assist in setting acceptance thresholds for address standardization updates using Status Codes provided by First Logic address standardization tools
• Special Data Processing - Designing, modeling and documentation for both a highly normalized logical and first cut physical data model(s) using ERwin for a complete reengineering of the company's core operational systems.
• A set of fully attributed data models along with new operational system screen mockups were delivered providing a roadmap to a new enterprise data architecture

Confidential

Director of Data Warehousing

Responsibilities:

• ERwin data model maintenance for an ODS and 6 datamarts
• Project management of the database (Informix to Oracle) and ETL tool (ESQL C programs to Informatica) reengineering effort
• Capacity and performance and disaster recovery planning
• Departmental budget responsibility, staff career development / training plans, and performance evaluations

Confidential

External Consultant

Responsibilities:

• Produced hardware and software specifications for an infrastructure that would be capable of delivering a large volume of reports within specific time window
• Oversaw the delivery, installation and configuration of the hardware / software combination across development, test and production environments
• Firm wide, biweekly engagement reports were deployed and for the 10 days surrounding the end of each month, the system generated 2,000+ Monthly Operating Reports for more than 15,000 employees on a daily basis

Confidential

Consultant

Responsibilities:

• Ported the domestic Data Warehouse Operational Data Store data model to Europe
• Designed an initial data mart and developed the ETL routines to populate both
• Implemented a report development, scheduling and delivery environment along with developing a set of 35 reports