Senior Software Developer (Contractor)
Current[Automotive Collision Ecosystem]● Designed and implemented Orphan bill posting with Azure Data factory and Databricks● Implemented integration with Air Table, negotiated schema with end users● Designed and implemented Orphan retry/expire features with Azure function and Azure SQL database● Provisioned and updated Azure resources through Terraform CLI and Terraform Cloud● Designed and implemented Azure functions connection to VM hosted SQL servers via Azure Virtual Network● Implemented backfilling process to resolve missing data issue due to exceptions● Refactored the IntacctApiUpdater Azure function to handle Service King differently● Written Unit Tests and Integration Tests[Account Receivable Reconciliation Service]● Designed and implemented Account Receivable Reconciliation service with Azure Data Lake Storage Gen2, Azure Data factory and Databricks● Use various libraries to ingest data from various format: REST API, Microsoft excel, text files, PDF, Microsoft Teams SharePoint folders● Setup CI/CD pipelines● Integrated Power BI with the delta lake through Databricks SQL Warehouse ● Implemented Power BI report with template, filters, and refresh button● Integrated with Power BI service to facilitate report publish from Power BI reportLanguages and Libraries Used: C#, .Net Core, XUnit, Python, PyTest, Azure SQL, Azure DevOps pipelines, Terraform, Microsoft Teams SharePoint, Azure Logic App, Azure Storage account, Azure Data Lake G2, Azure Key Vault, ARM templates, Azure Data factory, Azure Databricks, Azure Storage blob, Azure Storage queue, Azure Event Grid, Azure functions, Azure SQL Database, Azure Virtual Network, Azure Application Insight