David W. Duncan

***** ****** ***** **.

Ashburn, VA 20147

adosj1@r.postjobfree.com

571-***-****

PROFILE

Experienced business analyst, veteran, with extensive experience developing, integrating, testing, and deploying financial systems, both Agile and modified Waterfall methodologies, in controlled Software Development Life Cycle (SDLC) governance. Demonstrated skills in SQL, Microsoft Access, and Excel with the ability to integrate them all into actionable solutions. Ability to quickly grasp business, accounting, and technology terminology with purpose in bridging the gap between these organizations.

EXPERIENCE

Business Systems Analyst IV, Fannie Mae — Sep-2011 – Dec-2019

Hosting & Engineering Services

Chosen to lead on a team of experienced professionals to exert experience with Enterprise systems and perform early impact analysis on projects that will crossover business and technology portfolios.

Wrote narratives to support architectural illustrations for the Proof of Concepts (POC’s) and solution documents for a multi-year project where we successfully tested and failed-over our prime data center, without interruption, to an Out of Region (OOR) secondary location with fail-back.

Implemented a dashboard that consolidated data sources that simplified Configuration Items (CIs) using MS Access macros and Excel pivot tables with associated Tableau representations that helped the team perform portfolio level analysis for a myriad of constituents.

Development Security Operations (DevSecOps)

Elicited and wrote business user stories, along with supporting knowledge articles, that codified a broader Confluence menu for the purpose getting more zero level support for a JIRA Service Desk supporting our Centers of Excellence (COE) for Agile, Platform Services, DevOps, Security and Collaboration teams.

Collaborated with technologists to create knowledge share sessions to aide integration of DevOps tools for code quality, security and deploy capabilities to product owners to accelerate Continuous Improvement Continuous Deploy (CICD) execution and deployment across the Enterprise and within Application Teams.

Single Family Re-Platforming

Lead Analyst in an enterprise level effort to document current processes and data mappings which created baseline capability models signed off by senior management.

Collaborated with enterprise level teams to coordinate efforts on an industry changing project leading to the successful implementation of business solutions ultimately deploying to the Production environment.

Delivery Support Services

Championed a User Acceptance Team (UAT) over several Production releases expanding the product offerings for Fannie Mae’s Credit Enhancement System that created a new MBS risk sharing security beyond traditional mortgage insurance.

Coached less experienced analyst on the business processes supporting a Sybase application to achieve rigorous and thoughtful test execution.

Conducted root cause analysis of documented system defects, solicited team consensus as to origin and implement solution as needed.

Re-Engineering Analyst, Actualize Consulting — Mar-2011 – Aug-2011

Business Transformation Office

Provided professional expertise for the future state capability model and design of Freddie Mac’s financial and accounting data warehouse.

Conducted stakeholder workshops to acquire user input and business needs to fully understand legacy data sources from which we created operational and functional process flows.

Created Business Process Model Notation (BPMN) models, process narratives along with supporting Risk and Control Matrix (RCM) in support of final client product.

Senior Financial Analyst, Fannie Mae — Aug-2001 – Feb-2011

Single Family Accounting Operations

Served as Lead Analyst on the Data Analytics and Analysis team in support of the Operational Accounting unit responsible for an 18 million loan portfolio and a 2.7 trillion-dollar book of business.

Created backend, peer reviewed, SQL data queries against an Oracle database, with audit controls, which provided operational data supporting the monthly General Ledger close.

Led a team of analysts that moved an existing loan product on to a new application platform by eliciting user requirements and documented them into an enhanced user experience both functionally and non-functionally.

Master Servicing User Acceptance Test Team

Team lead, Financial Services, on the User Acceptance Test (UAT) group responsible for the re-platforming and implementation of Companies’ main servicing system Servicer and Investor Reporting (SIR) application.

Designed traceable business test cases from stakeholder requirements and test case expected results along with documentation of supporting artifacts.

Lead Business Analyst oversaw two unique MS Access Financial Reporting (FR) End User Computing (EUC) applications on a Visual Basic platform with supporting database.

Contract Lead Business Analyst, Robert Half — Aug-1997 – Jul-2001

Asset Development and Management - Fannie Mae

Lead contractor at Fannie Mae. Assisted with the development of three separate loan products with supporting processes and application database.

Airport Manager, National Car Rental — Feb-1991 – Jan-1997

Managed a staff of three managers and over 45 associates responsible for all airport operations and vehicle in fleeting and end of life.

Airport Manager, International Total Services — Dec-1988 – Jan-1991

Led the company’s largest single airport security contract with a staff of 125 and revenues more than one and one half million annually.

Lieutenant, United States Marine Corps — Dec-1984 – Oct-1988

Commanded Marines on various peacetime missions worldwide.

EDUCATION

Kent State University — Bachelor Science, Criminal Justice

Keller Graduate School of Management — Completed course work towards MBA

Contact this candidate