SUMMARY:

• Enterprise Information/Data Architect Enterprise Information Architecture and Management
• Database developer with 28 years of experience in operational, data warehousing and analytical environments
• Data Warehousing Data Quality
• ETL/Data Integration Master Data Management
• Enterprise Data Modeling Business Intelligence/Analytics
• Data Governance Query Tuning/Performance Optimization
• Metadata Transactional/OLTP Database Development

TECHNICAL SKILLS:

RDBMS: SQL Server, Oracle, MySQL, PostgreSQL

BIG DATA: AWS Redshift, Pivotal Greenplum

NoSQL: Neo4j (Graph), MongoDB

ETL: SSIS, Informatica Powercenter, Matillion ETL for Redshift, SAP Data Services, Talend Open Studio

SCRIPTING: Python, C#

BI: SSRS, SSAS (OLAP), Spotfire, Qlikview, Tableau, Crystal Reports, Business Objects

DATA MODELING: ER, Dimensional (Star, Snowflake), Data Vault

ENTERPRISE DATA: Data Governance, Data Quality, MDM, Metadata, ODS, DW, Analytical, OLAP

QUERY LANGUAGES: T - SQL, PL/SQL, pl/pgsql, XPath

CLOUD: AWS (S3, EC2, RDS, Redshift, Quicksight)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Warehouse Team Lead/Architect

Responsibilities:

• Responsible for all aspects of data warehousing environment: architecture, modeling, ETL, performance, infrastructure, reporting, data marts, metadata
• Coordinate with other technical teams (DBA, servers, networking) to monitor performance and growth and develop support/maintenance plans for data warehouse environment
• Developed report/data mart intake process to track, prioritize and assign user requests
• Lead the effort to build a Pathology/Omics data warehouse using Oracle OHF and TRC
• Implemented process to refresh i2b2 data mart
• Worked on architecture and development of new, modernized data warehousing/analytics environment incorporating the Cloud, NoSQL, NLP and unstructured data
• Worked with Data Science team to build their pipeline incorporating data from the data warehouse
• Coordinated efforts to upgrade data warehouse environment (server OS, RDBMS, ETL)
• Worked on implementing API to accommodate self service

Confidential

Senior Data Warehouse/BI Architect

Responsibilities:

• Developed MDM solution used to automate the analysis pipeline and drive application development
• Designed and developed an API layer to provide Data as a Service (DaaS)
• Developed analytic solutions using visualization BI tools
• Built analytic databases/data marts to support downstream analysis of statistical analyses of genotypic and phenotypic data
• Responsible for data governance and data quality as well as metadata

Confidential

Senior Database Engineer

Responsibilities:

• Involved in the gap analysis and profiling of data sources
• Designed metadata driven ETL framework for loading Enterprise Data Warehouse
• Worked with Business partners on Data Governance and Data Quality
• Helped model the EDW
• Designed and developed code and ETL to build Data Marts for analytics

Confidential

Database Team Lead/Architect

Responsibilities:

• Developed a Customer 360 View module for mission critical in - house application
• Lead the design and development of the Enterprise Data Warehouse
• Lead the project to migrate data sources that feed the operational reporting and EDW environments from a legacy application to new in-house application
• Worked with in-house and offshore developers to design new schema for enhancements to in-house applications

Confidential

Enterprise Data Architect

Responsibilities:

• Developed custom applications to provide functionality missing in legacy system
• Performed all database administration and maintenance tasks
• Performed the data migration/integration of legacy data into the newer vendor applications
• Designed and implemented a Data Warehouse/Analytical environment to provide Leadership with an Enterprise-wide view of the business
• Designed and implemented automated data integration processes to replace manual processes saving the company time and money as well as making the data available to the Enterprise Data Warehouse

Confidential

Lead Database Developer/Architect

Responsibilities:

• Performed query tuning and optimization on legacy SQL code
• Crated an ODS environment, integrating operational data to support near real-time operational reporting
• Designed and implemented a Data Warehouse/Analytical environment integrating internal data as well as external data from vendors and business partners to provide Leadership with an Enterprise-wide view of the business
• Developed custom database applications that used data from the ODS and wrote data back to the ODS to be fed into the EDW
• Designed and implemented automated data integration processes to replace manual processes saving the company time and money, improving data quality and making the data available to the Enterprise Data Warehouse

Confidential

Enterprise Data Architect/Developer

Responsibilities:

• Wrote custom database applications to replace manual, paper-based processes, making all Enterprise data electronic for compliance and regulatory purposes
• Crated an ODS environment to support operational as well as compliance and regulatory reporting
• Designed and implemented a Data Warehouse/Analytical environment to provide Leadership with an Enterprise-wide view of the business
• Responsible for all database administration and maintenance as well as acting as the backup network administrator