Desiree Brown

About Desiree Brown

Diversified business analyst and data architect/engineer with 20 years of reporting and analytical experience supporting Real Estate and post-foreclosure business units within Fannie Mae. Extensive experience with Business Intelligence tools such as Business Objects, Tibco Spotfire, and Tableau; ThoughtSpot, SAS programming language; Oracle, Microsoft SQL Server, Netezza and AWS Redshift database programming for report development, analytics, and database ETL support. In-depth knowledge of Oracle and AWS Redshift database design and architecture, with emphasis on consolidation of multiple data sources into streamlined, consistent reporting tables.Indepth experience with database migrations from on-premise to AWS cloud as well as ETL tool conversion between different software. Personal strengths and soft skills include project and team management in addition to new hire training and mentoring.Coupled with an educational background in Operations Research, professional strengths include optimization of business and reporting processes, short and long-term reporting platform design concepts, and detail-oriented forensic data mining resulting in accurate and consistent reporting data.

Experience

1. Data Engineer Advisor

   Fannie Mae

   Jul 2006 — Present · Dallas, TX, US

   17 years of analytical and reporting leadership for REO operations with 4 years of managerial experienceProficient in BusObj, SAS, Oracle SQL, Microsoft SQL, Oracle DB Design, SDLC, ThoughtSpotCurrent responsibilities:Requirements, solution specs, and ETL development analyst for an Oracle dart mart that includes over 100 base tables for monthly and MTD reporting;Forensic data mining leading to the enhancement of the reporting platform related to a third-party application interface atop a Microsoft SQL Server database, housing all REO workflow operational data;Oversight of month-end reconciliation between internal applications, collaborating with tech and biz partners on database modifications;Technical requirements and design of daily delta-record change snapshotting process; champion of the adoption of ThoughtSpot as a new analytical search toolPast Responsibilities:Entry-Level Program Manager (1.5 years):Manager and recruiter for over 200 college graduates for an entry level Associates Program; manager, business trainer, and mentor for 3-5 recruits per school semester;Business Analysis Manager (2 years):Operational manager over a team of 5 analysts responsible for the modification and creation of REO reports;Oversight of a multi-million dollar reporting and database conversion project related to the movement to a third-party application and reporting platformCoordination of UAT and regression testing of a suite of 300+ reports and app codesReport development using BI toolsBusiness Analyst / Sr. Business Analyst / Team Lead (4 years):Responsible for the automation and distribution of over 400 operational reports for CLM operations; Implemented the use and maintenance of versioning software and task/request tracking using CVS and SharePoint;Prioritized tasks of 12 analysts and development of 150+ business reports per month;Coordinator of BO XI Desktop Intelligence training for 500 employees, a cost savings of nearly $1M in 3 yrs

Education

• Southern Methodist University

  Master’s Degree

  2008 — 2010

• Southern Methodist University

  Bachelor’s Degree

  2002 — 2006

• Southern Methodist University

  Certificate of Management

  2013 — 2013

Skills

• Project Management
• Sas
• Business Requirements
• Strategic Planning
• Sharepoint
• Databases
• Business Intelligence
• Financial Services
• Business Process Improvement
• Data Analysis
• Sdlc
• Analysis
• Business Objects
• Etl
• Analytics
• Leadership
• Powerpoint
• Program Management
• Research
• Strategy
• Risk Management
• Business Analysis
• Microsoft Office
• Process Improvement
• Oracle
• Data Mining
• Microsoft Sql Server
• Requirements Analysis
• Operations Research
• Management
• Sql