[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

[ViewLinc Cloud]• Created cloud native microservices and implemented integration tests to cover corresponding endpoints• Implemented profile picture feature for both frontend and backend• Created lambda function alert notification and dashboard based on AWS CloudWatch Alarms• Created AWS AppConfig based application wide configuration to change log level at runtime• Disabled direct access to S3 for static website and profile pictures and created CloudFront• Created custom domains for both frontend and backend by using WAF (Web Application Firewall), Route 53 and ACM (AWS Certificate Manager)• Created sandbox CI/CD pipelines with CDK• Integrated Serverless Framework dashboard with AWS CI/CD pipelines• Integrate CodeCov with AWS CI/CD pipelines• Created admin onboarding email templates with Handlebars• Implemented Auto-logoff in frontend using React idle timer• Integrated zxcvbn password strength estimator in frontend to improve user experience• Added tenant scoped privacy in DynamoDB and S3 to increase defense in depth• Designed and implemented events service, added CloudSearch for structured and free text searchesLanguages and Libraries Used: Serverless framework, TypeScript, JavaScript, Python, Node.js, React, Redux, AWS-SDK, AWS-CLI, AWS IAM, APIGateway, APIGateway custom domain, Cognito, DynamoDB, DynamoDB Stream, Parameter Store, Secretes Manager, Lambda, CloudWatch, CloudWatch Alarms, AppConfig, CodeArtifact, CloudFront, S3, SNS, SQS, Code Build, Code Pipeline, CloudFormation, CloudFormation custom resource, CloudFormation macro, CDK, WAF(Web Application Firewall), Route 53, ACM(AWS Certificate Manager), CloudSearch

[EFT]● Designed and implemented Kafka and Azure cloud based the GL Processing microservice● Setup CI/CD pipeline for the GL Processing microservice● Created an Artifacts based NuGet feed and published a Kafka common message library into itLanguages and Libraries Used: ASP.NET MVC, C#, .Net Core, SQL-Server, EF and EF Core, WebAPI, WCF service, Azure DevOps, Kafka, Azure AppService, Azure Storage Blob, Azure Table, Azure KeyVault, Azure Artifacts

● Designed and implemented an independent dashboard to visualize and monitor Hangfire background job processing● Created a .net core library to detect contact duplicates and merge them based on specified criteria● Implemented always running mode for Hangfire server under IIS to make sure it is always ready to receive webhook calls from Nylas and process other scheduled and deferred jobs● Created an automated pipeline to generate NuGet package and publish to Artifactory● Provided constructive recommendations during code reviews according to business requirements, coding standards and best practices● Actively participated in sprint planning, daily standup and retrospective meetings.● Communicated directly with stakeholders to clarify requirements and provided solutions.Languages and Libraries Used: ASP.NET MVC, C#, JavaScript (ES5 & 6+), Node.js, SQL-Server, .Net Core, EF and EF Core, WebAPI, WCF service, AWS, Kinesis, Lambda

● Created a pipeline in Azure DevOps to deploy feature branch to an isolated feature environment to facilitate early QA verification to significantly reduce the development iterations● Designed and implemented spreadsheet-based accounting information importer, improved productivity by 500%● Created a .net core WebAPI service to let business unit to automatically generate 300 contracts and associated transactions in 5 minutes compared with 5 hours if they do manually● As the lead developer, successfully delivered GAP transaction project.● Acted as DevOps, responsive for production package preparation and deployed them onto production servers with all the coordination● Provided constructive recommendations during code reviews according to business requirements, coding standards and best practices● Actively participated in sprint planning, daily standup and retrospective meetings.● Communicated directly with stakeholders to clarify requirements and provided solutions.● Languages and Libraries Used: ASP.NET MVC, C#, VB.NET, JavaScript (ES5 & 6), Node.js, SQL-Server, .Net Core, EF and EF Core, WebAPI, WCF service, Graphql, React, Apollo, Selenium

[www.rew.ca]Full stack ruby and rails developer[data platform]AWS based python developer

[Mobile API]• Re-designed the mobile API by adding an abstraction layer between API clients and downstream services • Designed and implemented geo based clustering endpoint to improve map search experience• Used swagger as never out of sync API documentation to make it easy to understand and use• Created New Relic Insights dashboard to display real time Key Performance Indicators on the big screen• AWS services are extensively used: EC2, ELB, CloudWatch, DynamoDB, Kinesis and Lambda[Rentals API]• Use Apiray to create static mock API to have three way coordination on API specification definitions and iterations• Use agile SCRUM methodology to increase velocity and maximize business values.• Designed a unified data model to describe three different rental listings: community, MLS rentals and unit rentals• Used NuGet package manager to manage module dependencies• Contributed winding-polygon gem (Bentley-Ottmann algorithm based) to rubygems.org which has 15K+ download so far[MoveAPI]• Worked with product manager and data provider to define real-estate standard query and show API specifications• Designed and Implemented handlers to support (over 100 million properties, 1,000+ requests per second) listing search, sorting, paging and display on different details level• Integrated with existing infrastructures like PDS and Solr/Gate• Languages and libraries Used: C#, Log4Net, CastleWindsor IoC, MVC, SQL, SOLR, WCF[Find.realtor.com]• Designed and implemented an ajax based reporting system from UI to database schema• Built a client side graphing system which is more user friendly than server side solution• Designed and implemented solr based search including facet, sorting and paging

[Topproducerwebsites.com]• Implemented a profile page to let users to enter and edit personal information• Built a website creation wizard to guide user to choose look and feel from templates to website setup.• Created a home value page with Virtual Earth based map• Implemented a reverse proxy to seamlessly embed a third party content

Responsible for designing and developing web-based project management system with C#/ASP.Net/Java Script, ADO. Net, MS SQL Server