Experience

Client First Technologies

• United States
• Information Technology & Services
• 1 - 100 Employee

• Data Engineer

  • Oct 2022 - Present



Definitive Logic a ManTech Company

• Information Technology & Services
• 200 - 300 Employee

• Software Developer

  • Nov 2018 - Oct 2022

  Designed, developed, and maintained approx. 200 Power BI reports and data models used within the generation of VA’s Data Discovery and Finding Report (DD&F). In addition, created prototype reports to address the new 508 requirement requested of the DD&F. Developed PowerShell ETL script of over 1000 lines of code to extract, transform and load data into multiple relation-based tables within a SQL database, as well as creating views used within multiple applications. Also, designed and updated the functionality for testing the cleansed data for mapping errors, miss spellings, and unrecognized columns to identify issues before being loaded into the database. Designed SSIS packages within the government’s data ecosystem, which query different data cubes within government's data warehouse to pull data directly from the source to maintain fresh data for reporting. Maintained 1613 SQL views used to transform data before being piped into Power BI data models. Also, completed multiple data analyses to identify areas where new data was needed as well as data errors from changes to the main hierarchy structure used to connect most tables within the DL’s DB together. Designed, developed, and maintained the Power BI Export/Import Scripts, which were a collection of PowerShell scripts to synchronize Power BI Reports between the tenants, company's commercial cloud and the government’s Azure cloud, as well as transforming Power BI files to update database connections and autonomously republish reports that had been updated. Designed, developed, and maintained Power Automate flows to handle advanced approval processes within the government's SharePoint Online environment, controlling access, sending emails, and updating fields of multiple SharePoint lists at a time. Show less