Charles Henry
Seattle
Summary
Project management professional with proven success in delivering impactful projects across various sectors. Expertise in driving timelines and ensuring quality outcomes through effective strategic planning and execution. Strong collaboration skills and adaptability contribute to team success and high levels of client satisfaction.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Project Manager/Data Infrastructure Engineer
King County
08.2019 - Current
- Project: Redesign and implementation of Homeless Information System (HMIS)
- Skills: Project management, data modelling, SQL programming, software design, implementation, verification and maintenance
- Result: External reporting for King County Regional Homeless Authority
- Project: Design and implement an internal reporting system for an internal team of 50 evaluators
- Skills: Project management, data modelling, SQL programming, software design, implementation, verification and maintenance
- Result: Main reporting system for internal King County team (PME)
Azure Pipeline/ETL Developer
T Mobile
03.2019 - 07.2019
- Project: Analysis, design and implement Azure pipeline solutions as part of the merge process between TMobile and Sprint
- Skills: Analysis, design and implementation Azure ETL pipeline solutions using Azure Data Factory, Azure SQLDB and Azure Data Warehouse
- Established initial architecture and data transformations based on source to target mapping of Sprint data
- Result: First team at TMobile to create architecture design for pipelines used for merging data between TMobile and Sprint
Data Warehouse/ETL Developer
HomeStreet Bank
06.2016 - 11.2018
- Project: Redesign and implementation of auditing reports from the SAP Business Objects 4.1 to a VS 2014/ Oracle solution
- Skills: Project management, data modelling, VS 2014 and Oracle 11g programming, software design, implementation, verification and maintenance
- Result: Increased dependability and reliability of reports used to report to FDIC and external auditors
- Project: Management of project to convert 400 SAP Business Objects report from version 3.1 to 4.1 using the Fidelity Information Systems (FIS) service portal
- Skills: Project management, SAP Business Objects 4.1 and FIS expertise, report design
- Result: Increased dependability and reliability of reports sent to FDIC and external auditors
- Project: Managed audit reports scheduled to run daily, weekly and monthly reports implementing the SAP Business Objects 4.1 provided through the FIS software platform
- Skills: Expertise in the FIS banking software utilizing SAP Business Objects 4.1 and the FIS report scheduler software
- Results: Increased stability and performance for the in-house reporting
Data Warehouse/ETL Developer
Department of Revenue – State of Washington
12.2001 - 04.2016
- Project: Analysis, design and implementation of the Tax Compliance Data Warehouse (TCDW) project at the Department of Revenue (DOR)
- Skills: Dimensional data modelling using Kimball methodology, ETL development using the MS BI Stack (SSMS, SSRS, SSIS, SSAS), SQL stored procedure programming and SAP Business Objects universe and report design
- Result: The successful completion of this project resulted in $10.5 million dollars collected in the first year of operation and the 2004 Governor’s Award for Financial Management awarded by Governor Gary Locke to the project
- Project: Conversion of an application called Centrally Assessed Property System (CAPS) from Visual Basic/ Oracle to a .NET/ SQL Server solution
- Skills: Project management, relational data modelling including ER analysis and VB.NET and MS SQL Server 2012 programming including stored procedures
- Result: Software upgrade increased stability and accuracy of CAPS systems
- In addition, DOR was able to transfer from Oracle database licensing to less expensive database MS SQL licensing
- Project: Maintenance of ETL process for the Tax Compliance Data Warehouse (TCDW)
- Skills: Dimensional modelling, SQL stored procedure programming and SAP Business Objects universe design and maintenance
- Result: A well maintained in-house data warehouse system
Education
Certification - Data Visualization
University of Washington
Certification - Project Management
University of Washington
Certification - Business Intelligence: Building The Data Warehouse
University of Washington
Dimensional and Relational Data Modelling - undefined
The Data Warehouse Institute
B.S. - Computer Science
Evergreen State College
Skills
- Microsoft BI Stack and Power BI
- SAP Business Objects reporting
- R programming
- Tableau visualization
- ETL design and programming
- SQL Server and Microsoft BI tools
- Azure Data Factory pipelines
- Data transformation and mapping
- Data warehouse design
- Azure Data Warehouse and SQL programming
- Database architecture concepts
- Data warehouse documentation practices
- Development, test, and production environments
- Data warehouse modeling techniques
- Relational database design
- Dimensional design methodologies
Accomplishments
- Managed up to 3 projects at a time.
- Presented with the Washington State Governor's Award for designing a data warehouse that collects millions of dollars a year in additional tax revenue.
- Completed the Tax Compliance Data Warehouse Project on time and on budget.
Certification
• Certification in Data Visualization – University of Washington
• Certification in Project Management - University of Washington
• Certification in Business Intelligence – University of Washington
• Dimensional and Relational Data Modelling – The Data Warehouse Institute
Timeline
Project Manager/Data Infrastructure Engineer
King County
08.2019 - Current
Azure Pipeline/ETL Developer
T Mobile
03.2019 - 07.2019
Data Warehouse/ETL Developer
HomeStreet Bank
06.2016 - 11.2018
Data Warehouse/ETL Developer
Department of Revenue – State of Washington
12.2001 - 04.2016
Certification - Project Management
University of Washington
Certification - Business Intelligence: Building The Data Warehouse
University of Washington
Dimensional and Relational Data Modelling - undefined
The Data Warehouse Institute
B.S. - Computer Science
Evergreen State College
Certification - Data Visualization
University of Washington
Similar Profiles
Adrienne DavisAdrienne Davis
Court Processing Technician at King CountyCourt Processing Technician at King County
CHRISTINE WEBBERCHRISTINE WEBBER
ANIMAL CONTROL OFFICER at KING COUNTYANIMAL CONTROL OFFICER at KING COUNTY
David NixonDavid Nixon
Lead Rail Station Custodian at King CountyLead Rail Station Custodian at King County
TEJA IMMANENITEJA IMMANENI
Full-Stack Java Developer at NeverEnding Inc.Full-Stack Java Developer at NeverEnding Inc.
SARAH A. THOMASSARAH A. THOMAS
Maintenance Supervisor at Avenue5 ResidentialMaintenance Supervisor at Avenue5 Residential