Charles Dove

Client: National Financial Services Provider

Role: Data Architect

· As part of a team to design and develop a business information dashboard environment based on AWS Kinesis, Glue, Redshift and QuickSight.

Client: National Financial Institution:

Role: Data Consultant/Architect

· Created data mapping from a SAAS cloud-based financial core system to Vendor AML (Anti-Money Laundering) system and the requisite data transformations. Effort included working with client SSIS development team to implement data transformations and parsing JSON data.

· Resolve data discrepancies between core financial system and client data warehouse.

· Provided risk and data availability analysis for client’s “Customer 360” roadmap.

· Created mapping from SAAS cloud-based financial core system to Vendor Identity Check system.

· Data and process analysis for close of line of business to ensure data was secured and correct for audit and regulatory compliance.

Client: National Payments Provider

Role: Data Architect

· Designed a process and mapped client data sources/attributes on Azure for consumption by a Vendor based risk management system. Effort included negotiating technology, function, and process design for using Azure Data Factory, Azure function calls and SSIS packages to drive and automate a daily process.

Client: Regional Financial Institution

Role: Data Architect

· Provided tuning and process modifications for clients RedShift data warehouse. Tuning optimizations included: optimal attribute data types, table re-design for optimal access and data retrieval, correcting potential data duplication within existing tables.

· Provided roadmap/design for future state moving from AWS Glue and custom python code-based data warehouse loading to an “external table” approach with JSON data converted to parquet for optimal storage and retrieval into Redshift.

Client: National HealthCare Service provider

Role: Data process Analyst

· Re-designed and advised on implementation of Azure SSIS package(s) migration from existing on-premises SQL Server stored procedures/C# code for data input.

Client: Global HealthCare Services Provider

Role: Data Analyst

· Analysis of preliminary and formal third-party Vendor vetting processes and the data provided by each process for synchronizing third-party response information and reducing redundant response data and categorizing required responses.

Client: Major Airline

Role: Data Modeler

§ Re-modeled baggage tracking Oracle repository from Oracle to Cassandra for improvement in data handling and horizontal scalability.

Client: Cloud-based Financial Core Service Provider

Role: Systems Data Analyst

· Mapped Fedwire massage/response to client’s API’s and data model. Effort included complex data/process analysis to provide:

§ Technical mapping documentation for use by development.

§ Identification of gaps in client processes for business decisioning.

Client: International Supply Chain Software Services Provider

Role: Database Administrator

· As part of a team migrate customer’s web/database application from on-premises data center to AWS. Primary responsibilities included:

§ Implementing multi-tenant AWS RDS Oracle from client single instance/server “on premises”.

§ RDS Oracle tuning and loading.

§ RDS Oracle Developing process for DevOps future database changes.

• Design and implement ELT/ETL processes and databases for Enterprise Risk Datamart
• Part of Technical team architecting processes to support company’s completion of FDIC CECL certification
• Administration of SAS intelligence Server and SAS Enterprise Guide business development environment
• Provide Data Quality analysis and advice on implementable practices for “cleaning” and maintenance of incoming source data
• Database and process design for integrating new data sources into data warehouse.

• Conversion of desktop process for Risk Reserve Analytics to dynamic web process on data warehouse.

• Database interfaces to Enterprise Data Warehouse
• System Process Design
• Ab Initio development and process design
• Trillium development and Administration for Master Data Management system
• Complex ETL process design and maintenance
• Technical support for systems access and business interpretation and problem resolution for Enterprise Data Warehouse and sources
• Customer and data warehouse data quality issue analysis, mitigation, and resolution.

• Multiple long-term and short-term client engagements on a variety of operating systems, software, and programming languages
• Assignments included the following responsibilities: Data architecture and integration
• SAS administrator for house holding and match results for Customer Master Data Management system
• Systems analysis and integration for international customer/prospect data warehouse
• ETL process design and implementation
• Development DBA
• Logical and physical database modeling
• Application design and development.