Patrick Ebner Email & Phone Number

Arlington, Virginia, Us

Arlington, Virginia, Us

Washington, District Of Columbia, Us

• Coordinated across multiple business units to prepare quarterly regulatory capital reporting for delivery to federal regulators (FHFA & SEC). Utilized SQL, Tableau, Python, Excel and other tools to analyze summary-level and loan-level data of 17M+ loans across multiple large databases. Summarized and packaged findings and regularly presented to senior management and other stakeholders.• Responsible for developing the original business process and control framework for implementation of the Conservator Capital Framework. In subsequent implementations, assisted with the development of business and technical requirements, process flows, testing plans and traceability matrices.

Washington, District Of Columbia, Us

• Reduced processing time of more than 10 operational tasks by up to 90% by developing and implementing Excel, Access and VBA-based solutions. Worked across teams to assist other groups with development and implementation of similar solutions. Finalist or winner of 3 department-wide innovation contests. • Gathered requirements and created documentation for multiple high-priority financial modeling applications. Coordinated project implementation between modeling, business, IT and testing teams in a high volume, deadline-driven environment.

Washington, District Of Columbia, Us

Reduced annual software licensing and support fees by 75%, and drastically reduced response time on many reporting processes by spearheading initiative to replace several legacy data systems (Salesforce, Investment Cafe, Investran, Excel, Access) with one single, integrated solution (AltaReturn). Identified and evaluated potential replacement systems and consulted with internal experts while performing process identification and requirements gathering for implementation project. Performed mapping and transfer of data from legacy systems, and configuration and customization of new systems. Tested data integrity and system functionality in pre-production and live systems, and coordinated QA and UAT testing. Maintained data and served as administrator for live system.

Washington, Dc, Us

Played instrumental role in multi-year, multi-million dollar implementation of new, firm-wide accounting and finance system (SAP) for large international law firm with $500M annual revenues. Collaborated with outside consultants and third party vendors while serving as Subject Matter Expert to develop and test new accounting modules for Cost Recovery, Electronic Invoicing and Employee Time Capture functions.

Washington, Dc, Us

Bs, Accounting

Bs, Integrative Studies With Business Administration Concntration