DAVID J. MCDONOUGH

ad43yl@r.postjobfree.com 301-***-**** Rockville, MD

SUMMARY OF QUALIFICATIONS

Microsoft Certified: Fabric Analytics Engineer Associate (Exam DP-600)

Microsoft Certified Solutions Associate (MCSA) Data Engineering with Azure. (Exams DP-203, 70-775, 70-776)

Microsoft Power Platform App Maker (Exam PL-100)

Disciplined Agile Scrum Master (DASM).

Project Management Professional (PMP).

TOGAF 9.2 Level 2 Certified, The Open Group (Enterprise Architecture).

Microsoft Certified Solution Developer (MCSD).

Microsoft Certified Database Administrator (MCDBA).

Master of Business Administration (MBA), University of South Australia, 1996.

Bachelor of Engineering Degree (Mechanical), Adelaide University, 1986.

PROFESSIONAL EXPERIENCE

Steampunk (Federal Government contractor) McLean, VA

Principal Data Architect, September 2022 – March 2024

United States Department of Agriculture

Gathered and analyzed requirements and built data model for a new Education and Training application for the SNAP program.

Developed data strategy for Assistant Chief Data Officer of Farm Production and Conservation (FPAC).

Researched metadata technologies (Informatica, Atlan).

Developed Reference Lakehouse Architecture (on AWS stack) for future Data Analytics projects.

Investigated lakehouse/open table formats, Hudi, Iceberg and Delta.

Created ETL method which, using AWS Glue and Python, replicated data from any DBMS to an updatable data lake (lakehouse) using Iceberg.

Provided data leadership for the Food and Nutrition Services (FNS) Innovation team.

Created prototype data models and data warehouses using Azure tooling (Fabric, Azure Data Factory, Azure Data Lake, Azure SQL, Power BI).

Created model driven Power App (using the Microsoft Dataverse). Application used Power Automate and integrated with Outlook and Teams.

RethinkFirst New York, NY

Enterprise Data Warehouse Architect, June 2022 – August 2022

Using Azure Data Factory, designed and developed data integrations from Snowflake and Postgres databases on AWS to SQL Server on Azure.

Developed and documented data strategy.

Lumark Technologies Inc. (Federal Government contractor) Washington, DC

Solution Architect, July 2020 – April 2022

Department of Education

Envisioned, designed, developed, and deployed a new tool, Cybersecurity Analysis and Tracking Tool (CATT), to help Lumark provide cybersecurity management support to the office of Federal Student Aid in the Department of Education (NIST 800-53 Rev4 and Rev5, STIG, POAM, CSAM, etc.).

Performed overall system design.

Designed and built custom SQL Server database (currently 128 tables), data migrations (SSIS), operational reports (SSRS), analytical reports (Power BI), and a prototype of web-based application (ASP.NET MVC).

Data Architect, January 2019 – June 2020

General Services Administration (GSA)

Provided data leadership for General Services Administration (GSA) to transition from legacy mainframe and Java/MySQL systems to AWS.

Consolidated 10 different databases, which supported 20 different applications, into one SQL Server database.

Analyzed existing architecture and documented according to The Open Group Architecture Framework (TOGAF) standards.

Documented and modeled existing databases using Erwin.

Analyzed and documented internal and external interfaces.

Created a new normalized consolidated data model.

Documented mappings between existing databases and new database.

Created ETL framework (using SQL Server and SSIS) for transition.

Created data synchronization and phased migration strategy.

Led team of 6 developers.

Commonwealth Care Alliance (remote contractor) Boston, MA

BI Engineer/Architect, April 2018 – July 2018

Created data warehouse development environment (Visual Studio/SSDT/SSIS, SVN, AnkhSVN, BIML).

Structured solution into separate projects (MDM, Staging, Data Warehouse databases, SSIS).

Created extensible, modular ETL framework with strict naming conventions and separation of concerns.

Designed star schema to support claims billing and membership (5 facts and 25 dimensions).

Developed T-SQL and SSIS code to populate tables.

United Educators Bethesda, MD

Senior Data Architect (Director), March 2016 – February 2018

Co-led (with actuary department staff member) “Data Analytics” strategic project to overhaul the enterprise data analytics capability.

Was responsible for database design, data security, data quality, Master Data Management (MDM), Business Intelligence (BI) and database administration (using SQL Server)

Led team of 4 on-site and 3 off-site, data warehousing and BI specialists.

Performed database administration and managed contracted database administration team.

Conducted extensive data cleanup and profiling of enterprise data assets.

Created ER Diagrams, data dictionaries, source to target mappings and data flow diagrams.

Designed and managed integrations between systems (Data warehouse / Legacy claims-policy / New claims- policy / Salesforce) using SSIS.

Designed and managed implementation of database design improvements on current OLTP (claims/policy) system.

Created ideal data model for future claims/policy system (using DBSchema modeling tool).

Performed POC to integrate structured and unstructured data using Azure Data Warehouse and Azure Data Lake, using U-SQL and Azure Data Factory.

Dimensions Healthcare System (contractor) Cheverly, MD

Data Warehouse Architect, October 2015 –February 2016

Investigated available commercial products for healthcare data warehouses.

Performed build versus buy analysis.

Produced proposed high level architecture for overall analytics/reporting solution.

Created data model for data warehouse to support clinical and financial operations.

Developed POC using Azure, Hive, SQL Server Polybase and HDInsight to integrate text files into database.

Inovalon (contractor) Bowie, MD

Technical Lead, March 2015 –October 2015

Designed and built a database driven automation framework to process medical data.

oDesigned and built a database to describe projects and tasks, and as a result minimized manual intervention and decreased processing times. Database was designed to integrate with the SSISDB catalog.

oUsed BIML, Entity Framework, C#, Linq, SQL Server 2014 and Visual Studio 2013 to dynamically build SSIS packages from the database.

oDeveloped SSRS reports to display processing performance.

oMet extensively with business users to gather rules and requirements.

oLed 1 other developer.

Pandora Jewelry (American Headquarters) Columbia, MD

Business Systems Developer - Database, Feb 2011 – March 2015

Envisioned, initiated, designed, built and maintained a data warehouse, based on the Kimball method, to service Pandora in the Americas.

oApprox. 2TB of data across 20 fact tables.

oUsed SQL Server 2012, SSIS, SSAS, MDX, SS Data Tools, SSRS, Azure Table Storage, Azure SQL databases (DaaS), TFS, MS Build automated deployments.

oLed team of 4 other developers (1 employee, plus 3 contractors).

oMet extensively with leadership and business users to gather rules and requirements.

oDeveloped a meta-data based data warehouse documentation tool.

oDesigned and led development of QA/reconciliation reports.

Designed, built and maintained data marts and numerous complex reports and scorecards.

Designed, built and maintained methods to receive, store and analyze sales, inventory and traffic count data from retail stores. Data was transmitted in various forms (multiple XML formats, CSV, Tab delimited, Azure table storage, MySQL).

Developed database designs for transactional systems.

Designed and built numerous data integrations from MySQL, Dynamics CRM, Dynamics GP (Great Plains) and Azure SQL databases (DaaS) and Azure Table Storage.

Performed database administration.

Provided solutions to data quality, Master Data Management (MDM) and data governance problems.

Small Business Administration (contractor) Washington, DC

.NET Architect, Sept 2010 – Feb 2011

Performed initial overall design of “SBIC Web”. The application allows Small Business Investment Companies (licensed venture capitalists) to report financial activity and the Small Business Administration to perform financial analysis.

Defined software architecture.

Met with client to gather business requirements.

Designed database.

Designed and developed user interface wire frames.

U.S. Department of Agriculture (contractor) Washington, DC

Application Architect/Project Lead, Feb 2008 – Sept 2010

Architect and project lead on multiple projects using: VB.NET, C#, ASP.NET, HTML, CSS, JavaScript, AJAX, third-party controls (Infragistics, FarPoint), Crystal Reports, SQL Server 2005, Embarcadero ER/Studio, Microsoft Project, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2005, Visual Studio 2008, CSLA (component-based scalable logical architecture), Agile methodology (SCRUM), Codesmith code generator, Visual Source Safe, Microsoft Team Suite. Projects were delivered on time and within budget.

IPATTS: Performed as architect and team lead on an application to assist the International Travel Section in management of diplomatic and official passports, travel and visas for the entire USDA.

oApplication involved many complex rules and 9 different user roles in a complex work flow.

oUsed fully object oriented architecture based on the CSLA framework.

oThe business layer was developed using Codesmith templates to greatly increase productivity, quality, and standardization.

oUser interface developed using ASP.NET 3.5, Visual Studio 2008 and Infragistics controls.

IAFTS: Delivered web based ASP.net 2.0 application that managed financial tracking of grants, agreements, invoices and travel for foreign research programs.

APHIS: Delivered web based ASP.net 2.0 application managing the request, internal approval process, and logistics for visiting foreign agricultural researchers.

TARIFFS: Transformed the entire set of the annual WTO trade and tariff data into a new strategically de-normalized database structure, and created a web-based user interface for agricultural economists to interrogate this data to assist in international trade agreements.

Led teams of business analyst, quality assurance, database administrator, and developers (varying from 3-7).

Set software architecture and coding standards.

Created project plans, estimates, and schedules.

Gathered and documented business and functional requirements.

Transformed requirements into application designs.

Designed databases (using Embarcadero ER/Studio modeling tool).

Designed prototypes and UIs.

Developed code for presentation, business and database layers.

Designed and developed data migration from legacy systems.

Coordinated testing and deployment.

Assisted/mentored team members.

Economic Analysis Group Washington, DC

Economic Analysis Group is the builder of CaseTrak, a COTS product for legal matter management.

Senior Application Developer, Jun 2006 – Feb 2008

Using HTML, ASP, JavaScript, VBScript, ADO and SQL Server, ASP.NET, XML, Web Services and WSE2.0, maintained and added new features to COTS web application.

Performed major object-oriented redesign of the legal matter management application and produced prototypes and proofs of concept in Visual Studio 2005 using ComponentArt controls, AJAX and the Component Based Scalable Logical (CSLA.NET) framework.

Completed intensive training course on the CSLA.NET framework.

Aristotle Washington, DC

Senior Application Developer, Jan 2006 – May 2006

Using ASP, JavaScript, VBScript, ADO and SQL Server 2000 maintained and added new features to an application that verified the age and identity of requesters. Application dynamically created a series of searches against very large databases of government and commercial records (such as voter rolls and credit records) and returned results to calling web sites in XML format.

Redesigned query generation method so that it improved performance and was more generic and so could query against a large number of different international data sources.

Designed databases of international identification information.

Star Compliance (contractor) Rockville, MD

Senior Application Developer, August 2005 – November 2005

Optimized the method used to search and page through data used in a financial application, by modifying table structure and indexes and optimizing T-SQL code. Improved time for search from over 3 minutes to 3 seconds.

Designed and implemented a new data import method used to routinely import 3.5 million records of financial data. Worked closely with business analysts and vendors of data to modify structure of data. Modified indexes, developed stored procedures and DTS packages. Greatly increased the flexibility and ease of maintenance of the import method while decreasing processing time from 2 days to 40 minutes.

Designed and coded a new module to monitor entertainment and gifts received and given by employees of financial institutions. Implemented a complex and flexible rules engine in T-SQL. Developed the front end using HTML, ASP, JavaScript, VBScript, ADO and Visual Basic 6.

Data Management Technologies Incorporated (contractor) Beltsville, MD

Application Developer May 2005 – August 2005

Developed a Web-based contact management application using VB, SQL Server 2000/T-SQL, ADO, CSS and ASP.

Performed as technical lead on a project to convert an Access mdb program to an adp based on SQL Server. The application (which consists of 240 forms and 150 tables) stores membership rosters, training and scholarship applications, recruitment records and fundraising data, and performs extensive mail merges with Word documents.

oTested, debugged and integrated code developed by other programmers.

oPerformed structural database changes and data conversion.

oImplemented new security model.

oLiaised with client regarding application specifications.

American Capital (contractor) Bethesda, MD

Senior Programmer, September 2004 – March 2005

Served as senior programmer on a four-member team to develop a system to manage financial transactions for capital investment firm.

Liaised with client to understand work process.

Designed database and user interface, and developed code for Web and Windows based cash receipts and accounts receivable modules.

Used ASP.NET, VB.NET, ADO.NET, Web Services, SQL Server 2000/T-SQL, JavaScript, XML, CSS, Crystal Reports, and Infragistics controls.

Data Management Technologies Incorporated Beltsville, MD

Senior Systems Analyst, May 1998 to September 2004

Regularly performed duties including requirements analysis, database design, program design,

programming, testing, documentation, database administration, data manipulation, maintenance, and troubleshooting.

Acquired experience in using a wide range of technologies, including Visual Basic, Visual InterDev, SQL Server/T-SQL, Data Transformation Services (DTS), ASP, HTML, CSS, ADO, VBScript, JavaScript, VBA, Access, Microsoft Office, Windows, and Crystal Reports.

Designed and implemented programs in a several industries, including:

Medical Research, Medical Clinics, Health Administration, Facilities Maintenance, and Training Management.

Clinical Data Warehouse (National Institute on Drug Abuse): Performed as lead developer on a large, critical, multi-tier project for the National Institute on Drug Abuse (Baltimore) that stored patient medical records, medical research data, and aided day to day operations of treating and researching drug abusers.

oAnalyzed and documented requirements and designed database (approx. 200 tables)

oDesigned, coded, tested and maintained the multi-tier, Web-based elements of the project using VB, ASP, HTML, JavaScript, CSS and SQL Server 2000/T-SQL.

oAssisted less experienced developers working on Windows-based applications of the project.

oDesigned and coded additional features after initial deployment.

Provider Relations System (Johns Hopkins Healthcare): Served as lead developer and was responsible for all database issues for the “Provider Relations” system at Johns Hopkins Healthcare. This system, maintained details of all healthcare providers in the Johns Hopkins network, using an Access Data Project and SQL Server 2000.

oExecuted ongoing upgrades to existing product.

oLiaised with client to determine requirements and intricate business rules that were implemented into the front-end application and complex stored procedures.

oPerformed data exports to related systems.

OTHER INFORMATION

US citizen

Public Trust Clearance

Contact this candidate