C# Sql Server
Resume:
UMESH DHITAL
Senior IT Apps Programmer
ad5qvm@r.postjobfree.com
Fairfax, VA
Summary
.NET Full-Stack Developer with 12+ years of hands-on experience.
AWS Certified Developer
Designed, developed, and deployed web applications using modern .NET frameworks (Core 5 & 6, ASP.NET MVC), leveraging C#, ADO.NET, and SQL Server (2016 & 2019) to ensure robust data access and manipulation.
Architected and implemented complex database solutions for high-performance applications, including designing schemas, writing stored procedures, functions, triggers, and SQL jobs for automated tasks.
Built and integrated WCF and Web API services adhering to industry best practices, enabling seamless communication between applications.
Delivered dynamic and responsive user interfaces using MVC, Razor views, and modern frontend frameworks (AngularJS, Angular 10, 12, 14 & 16), TypeScript, RxJs library, coupled with HTML5 and CSS.
Extensively maintained and modernized legacy applications (VB.NET, C#, Ajax, LINQ, WCF), improving functionality and performance.
Developed and supported comprehensive reporting solutions using SSRS and SSIS for data visualization and analysis.
Pioneered cloud-native development by integrating AWS Lambda functions and S3 buckets into .NET projects, fostering scalability and agility.
Implemented serverless architecture on AWS leveraging SQS message queues, Lambda event-driven functions, and SNS for pub/sub notifications.
Empowered Junior Team Members: Provided guidance, mentorship, and coaching to junior developers, fostering their growth and development in getting up to speed on development.
Developed reusable Angular components, directives, and custom validators to streamline complex UI interactions and ensure data integrity.
Experience in automating software delivery workflows using YAML-based CI/CD pipelines.
Education and Certifications
MS Computer Science, Louisiana Tech University, Louisiana, 2011
AWS Certified Developer Associate (2024)
Technical Skills
Programming Languages
C#, VB, VB.NET, ASP.Net, .Net Core, .NET 5 &6, ADO.Net, HTML, HTML5, XML/XST, Java Script/Typescript, AJAX, NHibernate, Entity Framework 6.0, Angular 16, REST API
Development environment
Visual Studio 2003 to 2022, Jira, CI/CD pipeline, Confluence, Toad
Databases
SQL Server, AWS RDS, PL/SQL, Oracle 11g.
Version Control Tools
Git, SVN, TFS, Subversion
Cloud
Amazon Cloud Services (Lambda, S3, API Gateway, SQS, SNS, RDS)
SQL Server Tools
SQL Server Management Studio, Query Analyzer, SQL Profiler, Toad
Domain Knowledge
Insurance, Government, Finance
Work Experiences
IT Apps Programmer, Sr. (Contractor)
Progressive Insurance
March 2022 –April 2024
Worked as a senior developer in the Progressive Book Builder project. The project aims to develop a “best in class” efficient and flexible book transfer capabilities that deliver a great experience while maximizing efficiency and accuracy.
Worked with the team lead and other developers, taking the ownership of the Price Match component from design, development, deployment, and support.
oDesigned and developed various Restful Web API end points (Get, Post, Put, Head methods) needed to run price match component.
oDeveloped various lambda functions in AWS required to perform various calculations in price match.
oCoded various UI components and pages using Angular, CSS3, JavaScript
oIntegrated Lambda, API, and UI components.
Designed and Developed various API end points, complex UI components and cloud resources needed to integrate FAO (For Agents Only) system into Book Builder.
Redesigned the rule processing page to improve page load time by 3 times using server-side sorting and pagination.
Wrote complex re-usable wrapper code around MongoDB driver to implement aggregation, projection, and sorting capabilities.
Working on enhancements, improvements and bug fixing in various components of the Book Builder application.
Tools: VS 2022, C#, Angular 16, CSS3, .NET 6, AWS Lambda, AWS SQS, REST API, JavaScript, MongoDB, Terraform, Containers, Git
Senior Full Stack Developer/Team Lead (Contractor)
National Cancer Institute (NCI)
Jan 2020 – Feb 2022
National Cancer Institute (NCI), which is one of the NIH institutes dedicated for cancer research and training. It conducts research, training, and other activities related to causes, prevention, diagnosis, and treatment of cancer. Worked as tech lead and architect in efforts to modernize OASYS and FCAS applications. OASYS and FCAS are two enterprise web applications, written in .NET and angular, for managing contract life cycle all the way from planning, acquisition to the end of award.
Took lead on modernization of OASYS and FCAS applications to use cloud native services.
Performed technical analysis of applications for better performance, security, and availability.
Improved page load time up to 70% by separating the email notification service from the actual API call.
Implemented notification system using CloudWatch event triggered lambda function.
Researched on available options for moving inhouse MSSQL database to Amazon using tools like AWS Schema Conversion Tool (AWS SCT).
Moved inhouse SQL Server Database to Amazon RDS for better performance and security, saving hundreds of dollars per month on SQL licensing and server maintenance.
Wrote AWS infrastructure code (Cloud formation scripts) to deploy resources in AWS.
Wrote CI/CD deployment pipelines using Jenkins.
Wrote lambda functions to retrieve and process data from upstream data source.
Worked with other developers to fix critical and high security vulnerabilities reported by Netsparker security scan within 30 days of critical deadline.
Architecture and developed business complex COR Reporting tool within tight deadline.
Lead and mentor new developers to get familiar with the systems to get up to the speed.
Tools: VS 2022, C#, ASP.Net MVC, Angular 12, Web API, .NET Core, JavaScript, MSSQL 2019, Amazon RDS, NodeJS, JIRA, Git
Sr. Application Developer (Contractor)
The Carlyle Group
Oct 2018 – Jan 2020
The Carlyle Group is a multinational private equity, alternative asset management and financial services corporation based in the United States. Worked in a small group of developers to maintain and feature enhancement of FAM (Fund Accounting Monitor) and Investran application. FAM is an integrated web-based interface for centralized control, monitoring and execution of all automated Investran activities.
Designed and developed system to automatically generate investor reports on closing of Funds and uploading them to another portal, Investran Café.
Integrated enterprise service bus to publish message on closing of a fund.
Implemented system enhancements, provided support to the end users.
Developed new report types to be available for the FAM admin users.
Tools: VS 2017/2019, C#, SQL Server 2016, ExtJS, Web API, ASP.NET MVC, ASP.NET, .NET Framework 4.8, NHibernate, ReactJS, SSRS, SSIS VSTS
Senior Consultant
University of Pittsburgh Medical Center (UPMC)
Jan 2018 – Oct 2018
UPMC is a world-renowned health care provider and insurer. It has more than 40 hospitals, 800 doctors’ offices and outpatient centers across PA, MD and NY.
Worked on initiative to convert the existing WCF based services into Micro services using NServiceBus.
Coded a MSMQ listener, dispatcher and handler to handle HL7 messages.
Developed public facing WEB API in C# to allow clients to submit medical authorization request(s).
Integrated Azure AD to authenticate the request.
Worked on system enhancements and production support.
Tools: VS 2017, C#, SQL Server 2016, WCF, Web API, NServiceBus 6.0, MSMQ, Moq, Ninject, Git
.NET Consultant
Plus Consulting
Aug 2016 – Dec 2017
Worked on small cross-functional team to create technical design, develop, test and deploy new application as well as providing support for existing one in an Agile environment.
Worked in the team to analyze, create TDD/LOE documents and code to automate credit approval process by integrating with CreditPoint.
Worked as a full stack developer to implement new features and fixing production issues.
Developed new features to manage health insurance records for the end users.
Provided production support for the end client.
Tools: VS 2015, ASP.NET 4.6, C#, SQL Server 2012, WCF, Web API, SVN, VSTS
Developed common user controls for file uploading, displaying data in grid, pagination etc.
Developed pages to allow users to customize the application based on their preferences.
Tools: ASP.NET 4.0, VS 2010, VB.NET, Entity Framework, MSSQL 2008 R2, FileNet, jQuery, LINQ, WCAIS framework, SSIS
Application Developer Contractor
Deloitte Consulting
Nov 2012 – July 2016
Client: Department of Human Service (Allegheny County Pittsburgh, PA)
Allegheny county’s department of human service is division of the county office dedicated to meeting the needs of the county’s most vulnerable populations through an extensive range of prevention, early intervention, crisis management and after-care services.
Project 1: CYF Predictive Analytical Tool - An analytical tool to determine the risk of a child/victim within the household. The tool runs the algorithm to calculate the risk score value based on the various input variables like age, gender, address etc.
Took ownership of the project and worked in design, architecture, and code the web-based tool to calculate and display the risk score using provided algorithm.
Designed beautiful web interface to display the risk score in a graphical thermometer using HTML5 Canvas and jQuery.
Integrated the tool to another application to visualize the end results.
Tools: MVC 5.0, HTML 5 Canvas, Bootstrap, jQuery, VS 2012, C#, Oracle 12c, Toad, SCRUM
Project 2: Action Tracker - AT is web-based service provider management system.
Worked on team to implement change requests and enhancement of the provider management system.
Consumed API exposed from KIDS application to receive provider's contract information.
Tools: Entity Framework, Angular JS 1.0, Web API, Bootstrap, Visual Studio 2012, C#, Oracle 11g, Toad, TFS
Project 3: HMIS (Homeless Management Information System) - This is web-based information system designed to collect client-level data of housing and services to homeless individuals and families, and person at risk of homelessness.
Worked in a team of two developers design and code various pages that can collect demographic and economic information of the homeless users.
Consumed WCF service of CANS to populate assessments in the ASP.Net web page.
Integrated with Cognos to generate report on the page.
Tools: ASP.NET 4.5, Visual Studio 2012, C#, Oracle 11g, Toad, jQuery, TFS Server, HMIS Framework, Cognos server, Bootstrap
Client: Department of Labor and Industry (PA State Government)
Department of Labor and Industry administers benefits to unemployed individuals, oversees the administration of workers' compensation benefits to individuals with job-related injuries, and provides vocational rehabilitation to individuals with disabilities.
Project 1: Workers Compensation Automation and Integrated System (WCAIS) - A web-based system to automate the process of workers compensation in case of injury, disability, or death of employee at their workplace. It is used by individuals, staff members and external interested parties to interchange the information/ documents to complete the whole process of compensation.
Worked on Common team to develop common tools/frameworks to be used in different modules within the application.
Developed common user controls for file uploading, displaying data in grid, pagination etc.
Developed pages to allow users to customize the application based on their preferences.
Tools: ASP.NET 4.0, VS 2010, VB.NET, Entity Framework, MSSQL 2008 R2, FileNet, jQuery, LINQ, WCAIS framework, SSRS
Contact this candidate