Cloud ArchitectWorking with a team to design a private cloud to host DoD Development Environments.• Researching business opportunities.• Testing infrastructures that could support DoD business and security needs.Azure Data Engineer Migrated data from three SQL Servers & three Oracle databases to a Dataverse with a PowerApps UI.• Instantiated an Azure Datalake.• Built a metadata driven pipeline in Azure Data Factory.• Created Bronze, Silver and Gold layers in Azure SQL Server to extract transform and load data.Made Atlas-Tech's Innovation Challenge final round.

Built a Fabric analytical platform to report salesforce performance and project revenue.• Instantiated a Lakehouse• Imported Dataverse data into the raw zone in the Lakehouse with Dataflow Gen2s.• Instantiated a warehouse.• Wrote stored procedures to enrich data transform it into Fact and Dimension tables.• Created a semantic model to facilitate report creation.• Created reports and dashboards to assess sales performance and predict revenue.Reviewed an IoT data architecture for a client who produced systems that measure auto alignment and tread wear.• Assessed system for security, compliance, cost control, optimal use of resources, capacity, scalability, and availability. Built a system in Fabric to load data in irregularly formatted .csv files into a data warehouse.• Project required instantiating a data lake, importing .csv files, creating a notebook that could load data into DataFrames, identify and extract useful data points and load them into a data warehouse. Added Notebook to a parameterized Pipeline that ran daily.

Deposita leads the industry in managing cash for retailers.• Systems transfer data payloads from onsite Self-Checkout Machines, Point-of-Sale Systems, Recyclers and Smart Safes to the client’s Azure tenant where Deposita systems track cashflow, reduce shrinkage, identify aberrant transactions, forecast demand, optimize cash position, and ensure clients make best use of their cash.• Conducted UAT for a Synapse-based warehouse that replaced a legacy SQL Server data warehouse.o Identified bugs and deficiencies.o Suggested improvements and optimizations including moving to Lakehouse & Databricks.• Created a POC Databricks Lakehouse.o Demonstrated Delta Lake’s support ACID Transactions, unified batch and streaming, schema enforcement and evolution, time travel, versioning, rollback and caching as well as improved scalability, availability, reliability.o Used Python, PySpark SQL in Notebooks, Jobs, Workflows and Delt Live Tables to extract, transfer and load data between the Bronze, Siver and Gold Layers of the Medalion Architecture.o Used Unity Catalog to demonstrate consolidated governance, centralized asset control, Define Once, Secure Everywhere, auditing and lineage, data discovery, unified data visibility, single permission model and AI-Powered monitoring and observability.

Provisioned, administered & troubleshot Azure and DataBricks infrastructure services to ensure CDC infrastructure was dependable, available, and secure.• Troubleshot issues with DataBricks clusters.• Troubleshot issues with DataBricks Notebooks.• Granted, modified, and revoked user access to Azure and Databricks resources.• Assisted with the migration to Unity Catalog.• Cut average response time to ServiceNow Consultation Requests from four days to one.• Cut average response time to ServiceNow Incident from two days to six hours.• Reduced ServiceNow Work Item inventory from twenty-eight items to five.• Reduced Incident resolution time from three days to one.• Booz Allen Hamilton readjusted SLA objectives for CDC based on these new benchmarks.

Databricks Data Engineer Assisted in developing a DataBricks Lakehouse Accelerator.• Demonstrated Delta Lake’s support for transactions, unified batch and streaming, schema enforcement and evolution, time travel, versioning, rollback and caching.• Used Python and PySpark SQL in Notebooks, Jobs, Workflows in the Medalion Architecture to extract, transfer and load data between the Bronze, Siver and Gold Layers.• Used Unity Catalog to demonstrate consolidated governance, centralized asset control, Define Once, Secure Everywhere, auditing, lineage, data discovery and AI-Powered monitoring.Snowflake Databricks Data Engineer Designed, built, evaluated, and deployed Snowflake warehouses, databases, schemas, tables, views, and scripts to support a credit card company’s process for identifying credit card offer candidates. • Worked with PySpark SQL notebooks to create Jobs/Workflows to ingest, validate and enrich data in bronze, silver, and gold layers.• Automating cut report generation time from weeks to seconds.• Replicated a SAS business process in Snowflake. This allowed the client to drop its SAS dependency and cut process run times by orders of magnitude.Azure Data Engineer Designed, built, evaluated, and deployed metadata driven Azure Data Factory pipelines that pulled data from a subsidiary into parent’s data lake, data warehouse and Power BI presentation layer.• Automated testing which doubled code coverage and increased unit and integration tests quantity by a factor of four. Cut testing lead time from one person-month to two minutes.Azure Data Engineer Tested metadata-driven pipelines that moved OnPrem streaming data into Synapse for the largest grocery chain in the country. • Revised OnPrem NRT process to facilitate validation in Synapse. Prior to changes, client spent six months and over $500,000 trying to validate concurrence. With changes, testers validated agreement in less than a week.

Designed and built an analytical platform in Azure that allowed the Navy to determine how well it manages software and IT hardware assets.• Used Azure Blueprints for FedRAMP Moderate to ensure resources adhere to FedRAMP as well as DoD standards patterns and requirements.• Created metadata-driven Azure Data Factory pipelines to import data, Azure Data Lake to store it, Azure Synapse to warehouse it and Power BI to present it. • Created an Azure DevOps pipeline with automated testing, approval and release that promoted the application through Dev, SIT and UAT Test Environments.

Created an Azure Solution that allowed one of the nation’s largest mortgage companies to track, value and analyze mortgage servicing rights.• Created servicing rights valuation models in Python & .Net/C#.• Implemented Infrastructure-as-Code with PowerShell scripts and Azure CLI commands to ensure application had just enough infrastructure to meet SLA. Cut infrastructure costs and time to implement by over 90%.• Used Azure Data Factory to import data, Azure SQL Database to store it, Azure Functions to process it, and PowerBI to present it. • Automated Builds in Azure DevOps, which facilitated more efficient and productive developer collaboration.• Created an Azure DevOps Release pipeline that promoted application through Dev, SIT, UAT and Prod Environments, which automated testing, approval, and release. Pipeline saved person-hours, eliminated human error, cut delivery times, and made process repeatable, scalable, and self-documenting.

Data Engineer, Truist LearningDesigned and built an application that allowed Truist Learning to use data to drive decisions and identify return on investment for training programs.• Used Python in Databricks Notebooks to extract transform and load data from a targets including Workday & Salesforce.• Used infrastructure as Code (IaC) to ensure application had infrastructure to meet SLA. Cut infrastructure costs and delivery lead times by over 90%.• Used ADF to import data, Azure SQL Database to store it, and PowerBI to present it. • Created an Azure DevOps pipeline with automated testing, approval and release that promoted application through Dev, SIT and UAT. Saved person-hours, reduced risk of error, cut delivery times by over 90% and made the process repeatable, scalable, and self-documenting.Scrum Master, Data Science and AnalyticsLed a SCALed Agile Release Train that created marketing campaigns. Cut development lead time by more than 50%, Cut defect rate by 75%, increased throughput by 100%.• Managed Release Train from data capture to client Inbox for email Marketing campaigns.• Served as scrum master, led ceremonies, created Features, User Stories, Tasks and Defects. • Wrote, revised, and gained approval for Business Requirements documents. Cut lead times from months to weeks.• Identified sources for Mortgage, Checking, Credit Card, and Insurance data. Including data sourcing with requirement gathering removed ambiguity, eliminated rework, and cut development time by 50%.Led a development team that transferred data from legacy repositories to an Enterprise Data Lake. Took project from months behind schedule to on time and making a critical enterprise milestone.Business Intelligence Developer, Microsoft Center of ExcellenceServed as Microsoft Center of Excellence SME for SSRS, SSIS, Automated Testing and MS Office. Created and delivered Tutorials on Automated Testing, Automated Builds, DevOps and implementing Agile methodologies in Azure DevOps.

Led a SCALed Agile Release Train that created automated marketing campaigns. Cut development lead time by more than 50%, Cut defect rate by 75%, increased throughput by 100%.• Managed Release Train from data generation to client Inbox for Truist email Marketing campaigns.• Served as scrum master, led ceremonies, created Features, User Stories, Tasks and Defects. • Wrote, revised and gained approval for Business Requirements documents. Cut lead times from months to weeks.• Identified sources for Mortgage, Checking, Credit Card, and Insurance data. Including data sourcing with requirement gathering removed ambiguity, eliminated rework and cut development time by 50%.• Wrote, revised and gained approval for Data Requirements. Changed Data Requirement format to include more detail, leave less room for error and facilitate automated testing. Automated testing improved quality and cut man hours by 75%.• Wrote, revised and reviewed SAS programs to extract campaign data. Fluency with SAS ensured program pulled right data from right places and cut time to revise and test code from weeks to days.• Wrote, revised and reviewed PowerShell scripts to verify data files met requirements. Automated testing cut testing time and cost by an order of magnitude.Led a development team that transferred data from legacy repositories to an Enterprise Data Lake. Took project from months behind schedule to on time and making a critical enterprise milestone.

Served as Microsoft Center of Excellence SME for SSRS, SSIS, Automated Testing and MS Office. Created and delivered Tutorials on Automated Testing, Automated Builds, DevOps and implementing Agile methodologies in Azure DevOps.

Developed IBM’s Home Affordability Mortgage Programs (HAMP). Treasury and Fannie Mae cited IBM’s implementation as best in class and the model for other lenders. Fannie Mae used the code base in their own models.• Calculated NPV of scheduled payments, foreclosure scenarios and modification options to identify outcome with maximum expected NPV. Coded in Python, C#, xml and ASP.Net.• Calculated NPV of scheduled payments, foreclosure scenarios and modification options to identify outcome with maximum expected NPV. Coded in SQL, C#, xml and ASP.Net.

• Grew Countrywide’s Hard Money (Low LTV/Low Credit Score) Mortgage Acquisition program from inception to $80,000,000/month. Securitized over $1,250,000,000 making Countrywide’s Hard Money Desk the largest in the industry.• Created loan valuation models in Python & .Net/C#. • Created Countrywide’s OLTP Database for whole loan and securitization. Built SSIS packages to import data and data warehouse for reporting and analysis. When Bank of America acquired Countrywide, B of A adopted this system for use throughout all of Bank of America. It continues to serve Bank of America Capital Markets.

Converted a system for handling claims due to broken trades from Excel to Access.