Evan Reese, Cdmp, Cdvp2 Email & Phone Number

Mount Joy, Pa, Us

Denver, Colorado, Us

Denver, Colorado, Us

Denver, Colorado, Us

Bala Cynwyd, Pa, Us

Philadelphia, Pa, Us

Blairsville, Pa, Us

• Led Data Management Enterprise Wide• Rollout of PowerBI• Mastery of Customers Accounts and Users Cross Platform• Lead Data Warehouse Build• Implement Data Vault 2.0 Warehouse• Determine required physical infrastructure for Development, QA, and Production environments• Spearheaded the design of a Java Spring application that allowed for staff augmentation by automating warehousing• Led RFP and modeling tool selection using Functional and Non-Functional Requirements completed in the first 3 months• Programmed and implemented a bash prototype of the automation application that provided automation of a majority of the manual tasks involved in the warehousing process within the first 3 months• Implemented SDLC for SalesForce, Data Engineering, and Business Intelligence teams

Lancaster, Pennsylvania, Us

• Lead Data Architecture and Governance (Also the lead for this track in addition to the overall), Data Engineering, and Reporting/Visualization Tracks• Design integration and migration strategy• Architect data solution for the commercial loan origination system implementation • Work with Enterprise Architecture to deliver best possible solution• Support Options Analysis for the Solution Design• Worked on ICDs for in scope integrations• Created data context, SV-1, conceptual, and component diagrams for the solution• Assisted in the development and review of business, stakeholder, and functional requirements• Authored data NFRs and job descriptions• Scored RFPs

Lancaster, Pennsylvania, Us

• Inmon Style Data Warehousing Initiative o Served as Project Lead, Scrum Master, Product Owner, and Data Quality Lead o Designed and presented overall architectural vision and roadmap for project redirection o Enhanced Physical Model o Lead effort to design ETL standards including delta file generation methodology o Designed Templates, Scripts, and outlined process for QA/UAT validation process o Lead QA/UAT Validations for data loads o Designed and Implemented RDM strategy• Data Controls Process Enhancement o Analyzed existing process and identified opportunities for enhancement o Designed and Modeled Logical and Physical Normalized Data Model o Developed SQL Objects including Tables, Views, and Stored Procedures o Generated sample data and populated the model • Strategic Initiatives o Prospect Inclusion in Data Quality Processes o Providing Enterprise Unique Key to ECM Documents o KDE Strategy o Data Quality Roadmap o Non-Invasive Data Stewardship o Enhanced Algorithms in MDM/Data Quality Tool • Validations o STTM for Floorplans o Full Commercial Spreading, Credit Relationship, Credit Card, Loan Servicing Integration o Partial Core System and CRM Integration• Automated Tools o Python ▪ Parser that reads SQL Statements from VBA and documents ▪ Audit Sample Record Generator from CSV files o VBA ▪ TFS Scraper ▪ Data Profiler ▪ Data Dictionary Generator for SQL Server and MS Access ▪ SQL Server Test Case Generator ▪ SQL Server Test Case Validator• Validated SQL Server Triggers that generate historical tables; designed and tested over 70k test cases in an automated fashion • Reverse engineered ETL process for all Credit Card information enterprise wide and rewrote all exports to external systems• Reverse engineered the logic for hundreds of stored procedures• Mentor multiple associate analyst/developers across the Data Quality, Data Architecture, and Application Development teams

Mclean, Va, Us

• Designed an application to load flat files from the recoveries core system to the production Hadoop data lake• Enhanced frameworks performing various functions into modular components of a custom built ETL application• Designed function to check the status of an Apache Tomcat server• Served as lead developer to a team of 6 engineers to design an application to load Credit Bureau information to production Hadoop Data Lake

Mclean, Va, Us

• Data Analyst lead for Recoveries ad-hoc big data UAT testing to convert Teradata SQL to HiveQL• Developed a shell script utility to load tables from Teradata directly to HDFS without using Sqoop that utilized BASH, HDFS, and Hive shell scripting• Served as team lead for a group of 5 Data Analysts at a hack-a-thon to ETL ASCII, EBCDIC, and JSON files on HDFS where our solution made use of Hive, Pig, and BASH shell scripting with awk commands and successfully handled the ASCII files provided• Designed and scripted process to recall accounts from 4th party law firms and place with new 4th party firms • Maintain, support, and improve approximately 30 automated processes related to Back Office and Legal Recoveries scripted in KSH, BTEQ, and SAS whose results were shared with everyone from operations managers to MVP level associates• Recoded VBA routine that transfers data to a log from multiple inputs, and designed the process, including text error handlers, to upload this log to Teradata by using VBA and Teradata SQL• Created a KSH script that can find dates defined with unique requirements such as the x weekday in the y week of the month that is not impacted by erroneous values in the UNIX system calendar• Made improvements to multiple operational processes to correct deficiencies caused by legacy operations and simplified results provided to end customers by modifying VBA code and KSH scripts • Designed VBA code to interact with internal web server to function like a pseudo file server despite not having a FTP connection to the server• Overhauled VBA code that generated heatmaps for each state Capital One conducts Legal Recoveries business in and reduced run time from ~2 hours to 1-2 minutes depending on system performance• Develop content and serve as course coordinator for Capital One’s Intro to VBA class • Develop content for, and teach the Capital One Big Data Academy Foundations Courses

Mclean, Va, Us

• Redesigned contingency agency bonus structure to provide meaningful bonuses determined by a simpler methodology, while at the same time driving cost savings through the program• Set monthly goals for external and internal contingency agencies, and as needed identified where adjustments were needed to model outputs, and sized as well as recommended adjustments to the monthly goals • Put together the presentation and story that described the monthly overall health of the external Recoveries contingency business, and worked with agency managers to gain additional insights to performance metrics not well represented by data• Ran the contingency agency bonus structure and calculated external agency bonuses• Performed ad-hoc analysis to verify that the results of the model that set agency goals were valid, and that the model was producing outputs that were obtainable for external agencies • Using VBA code and Teradata SQL designed an Excel interface to perform QA checks on all data provided for a monthly business health review• Designed a suite of VBA macros in Excel to automatically generate monthly and quarterly emails with the required information and attachments to send to all customers from QA Managers to Directors

Mclean, Va, Us

• Designed a system known as ADCS (Automated Data Collection System) that provides a proxy SAS environment in Excel and uses Excel userforms in combination with VBA code, and system environmental variables, to transform data into records that are imported to SAS datasets, these datasets are then uploaded to Teradata tables by a nightly process; this system was used to collect data for:o Phone call data including call type and resolution – Data was used in analysis by 3rd party consulting firm for recommendations on new case management system for this departmento Secured Messaging data including message type and resolutiono Information on fraud callso Information on chargebacks submitted to MasterCardo International wire claims – This project also included reports to track open claims and the ability to work open claims• Created documentation and a presentation to explain how to use the ADCS to other associates at Capital One that provided enough instruction that a call center supervisor, with some guidance, was able to develop his own data tracking system for call agents • Using VBA enabled automatic routing of certain fraud and disputes transactions to reduce the average time for provisional credit from around 7 days to 1-2 days on average• Created intraday reports to be used by call center supervisors in SAS to monitor agent performance and incoming calls• Completed analysis to review the MasterCard 1st Chargeback strategy and provided a recommendation for an improvement that had potential to generate almost 700k in savings• Served as a teaching assistant for Capital One’s Creating Effective Presentations class that instructs associates on how to create well planned and professional PowerPoint presentations • Served as a mentor to 2 associates, and worked with them to further their skills in VBA, SAS, and SQL while challenging them to push their thinking to find the root cause of issues and then remediate appropriately

Glen Allen, Virginia, Us

• Worked on Medicare Supplemental rate increase filings for multiple blocks of the business• Prepared historical information for rate increase objection responses• Furthered Microsoft Excel skills, and also worked in Microsoft Access and Microsoft SQL Server