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

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

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.
• 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.
• 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.
• 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

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.
• 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.
• 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

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.
• 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

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.
• 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.
• 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

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