David B Coates Email & Phone Number

400 C Street Sw Washington Dc

Lead analyst for Federal Emergency Management Agency (FEMA) Flood Insurance Report modernization project. Liaison for upper management, contractors, developers, and end users in the implementation process, ensuring that consensus is reached on a project’s scope and requirements. Facilitate and lead JAD sessions with product owners to elicit business requirements, create user stories, and acceptance criteria, and provide developers with a good understanding of how business needs the system to perform. Document and communicate detailed requirements, define scope, objectives and business rules through user stories by utilizing JIRA. Attend agile ceremonies such as daily standup, sprint planning, sprint review, and sprint retrospective. Facilitate and lead user acceptance testing (UAT) efforts, leading weekly meetings, constructing external and internal UAT communications plans and schedules, communicating testing status to team and upper management, and responsible for obtaining final user approvals. Serve as point of contact for end user support tickets (issues), analyze and research submitted tickets, delegate tickets to developers for remediation, and attend cross functional support team meetings. Serve as Scrum Master at daily standups, sprint planning sessions, sprint reviews, and sprint retrospectives in absent of Scrum Master.

Bethesda, Maryland

Facilitated and led presentation for project implementation strategies to Managers and Executives. Led requirement grooming sessions with product owners to elicit business requirements as well as create user stories and acceptance criteria. Acted as feature lead for several cross-functional initiatives, including new Fannie Mae 45 day REMIC. Developed Business requirement document associated with each work package. Created process workflows utilizing Visio to document positive and negative scenarios for each business process. Performed gap analysis and process reengineering to recommend improvements in existing processes to pursue automated workflow. Communicated detailed requirements and business rules through user stories by utilizing JIRA. • Served as key liaison between product owners, developers, testers, and other stakeholders during all phases of software development and release lifecycle. • Attended Agile Scrum ceremonies, including daily standup, sprint planning, sprint review, and sprint retrospective.

Washington D.C. Metro Area

Directed day-to-day operations of a high-performing production staff of analysts. Managed production team analyzing complex, negotiated structured securities. Served as project lead and business SME for multifamily bond and tax administration business process outsourcing project for multifamily securities. Analyzed process improvements and business process reengineering. Identified solutions to overcome operational impediments and fielded recommendation for enhancements. Ensured process of business requirement definition achieved high quality, contained proper documentation, and remained consistent with corporate standards of internal controls and auditability. Communicated with Agile delivery teams, operation teams, and multiple stakeholders across project. • Planned, documented, managed, and evaluated performance of subordinate staff. Provided professional and technical development opportunities through assignments, mentoring, and training. • Maintained less than 1% error rate on investor payment and disclosures.

Washington D.C. Metro Area

Facilitated business process enhancement and software development life cycle, including analysis, user acceptance testing, and implementation of software applications. Ensured consistency with corporate standards of internal controls and audit ability. Coordinated application development, coding, testing, user acceptance testing, and production to consistently satisfy business requirements. Triaged and analyzed data integrity issues using SQL quires to extract information from local and data warehouse database.• Calculated investor to payments. Onboarded new securities to platform. • Created Federal Reserve Bank of New York payment extract file.

Washington D.C. Metro Area

Performed accounting functions related to monthly securities, including cash flow analysis, tracking incoming and outgoing wires, reconciling account payables and receivables, and submitting monthly accounting journal entries against critical timelines. Submitted journal voucher entries for consolidated mortgage-backed securities and prepared financial statement disclosures. Performed process analysis through reconciliation to evaluate whether preliminary/final trading factors properly reflected actual collateral payments. Supervised production team responsible for analyzing complex negotiated structured securities. Assessed impact of securities on existing processes and systems and created solutions to overcome operational impediments.

Washington D.C. Metro Area

Computed bond payments on roughly 50,000 structured securities through use of a proprietary Collateral Mortgage Obligation (CMO) payment model. Provide training and guidance as needed.