Avanti Choudhary

⦁ Built a serverless claims submission platform using AWS Lambda, API Gateway, and DynamoDB.

⦁ Migrated a .NET application to Azure App Services and SQL Azure, improving availability and scalability.

⦁ Integrated Azure Monitor and Application Insights to track application health and performance and Practiced deployments via AWS ECS.

• Led a team in addressing and resolving complex client issues related to healthcare claims and Molina systems
• During this period, led technical support initiatives for healthcare clients, focusing on claims processing and system support.
• Developed and maintained interactive dashboards and reports using Power BI, providing actionable insights and performance metrics for claims management.
• Optimized and troubleshot complex SQL queries and database performance issues, enhancing system efficiency and reliability.
• Collaborated with cross-functional teams to address and resolve technical issues, ensuring high client satisfaction.
• Implemented data integration solutions and ETL processes to streamline data flows, improving accuracy and efficiency in claims processing.
• Conducted data analysis to identify trends and support strategic planning for healthcare clients.
• Created technical documentation and training materials to assist end-users and internal teams with new tools and processes.
• Increased team productivity through effective collaboration, clear communication, and regular progress updates.
• Streamlined software development process with the introduction of Agile methodologies, resulting in faster project completion times.
• Troubleshot complex issues impacting systems performance, applying root cause analysis techniques to prevent future occurrences.
• Provided mentorship to junior team members, fostering professional growth and strong work ethics in the workplace.
• Developed a secure web-based platform for seamless data sharing between internal departments, improving overall efficiency.
• Fostered strong relationship between technology team and managers to align efforts.
• Spearheaded cloud migration initiative to improve infrastructure scalability and reduce operational costs.

• During this period, I worked on various online applications, specifically e-commerce with CMS. These applications had functionality to manage product catalogue as well as other website content. I also worked on integrating multiple payment gateways for e-commerce web applications.
• Working directly with client starting from requirement elicitation to delivery. It includes planning, design, code, build and deplanement
• Create web forms
• Extensively used datasets, Data table and Data view to retrieve and manipulate data and display it in an application
• Wrote efficient SQL queries for the optimal performance of the system.
• Participated in day-to-day database development and administration tasks such as: creation and maintenance of DB objects (tables, constraints, indices, views, triggers, and stored procs).
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Created complex queries, functions, packages and stored procedures for Reports using T-SQL.
• Responsible for developing E-R diagrams, logical & physical data modelling, development and implementation of the system
• Responsible for Web API development as well as testing using Postman and swagger

• Being freelancer mostly played individual contribution / full-stack developer role. Responsible for Plan, Design, Development, Test and Deployment for my module.
• Worked on Requirement gathering, code, and deployment.
• Worked on WEB API, developed in C# and as a backend MS SQL as a database.
• Developed certain features of the application functionality CRUD features.
• Responsible for creating datasets using T-SQL and stored procedures.
• Creating and Modifying T-SQL stored procedures.
• Wrote efficient SQL queries for the optimal performance of the system.
• Responsible for deployment as well as maintenance for the same projects.

• Project: Recruitment and sales domain job portal (http://www.apply4u.co.uk)
• Technologies Used: ASP.NET, C#, Html, CSS, SQL.
• Apply4U is a web-based platform which enables jobseekers and Recruiters to get right Job as well as Candidate in recruitment and sales Sector. In this job Portal which having facility to manage candidates and Clients from admin Panel and complete reporting of the candidate and client.
• Participated in complete development life cycle activities like design, coding, Unit Testing.
• Involved in the design of the USE Case Diagrams and Class diagrams using Microsoft Visio.
• Developed Web-based User Interface using ASP.Net, HTML, C#.
• Developed ASP.NET Web customs controls, user controls, Data Controls like Data Grid.
• Responsible for design and development.
• Worked extensively with different ADO.NET objects to interact with SQL Server database and good experience in using ADO.Net objects such as SQL Connection Object, SQL Command Object, Data Reader, Dataset and Data Adapter.
• Analyzed and repaired of existing VB and VB.NET applications.
• Programmed ADO.NET for communication between application and the SQL Server.
• Developed SQL Queries, Views, Functions, PL/SQL Packages, Stored Procedures.
• Project: e-Commerce web application Fancy-Dress (http://www.fancydressshack.co.uk)
• Technologies Used: ASP.NET, C#, Html, CSS, SQL.
• Fancy-Dress is U.K. base online shopping website on which three kinds of user can operate Admin, Agent and Normal users.
• Participated in complete development life cycle activities like coding, Unit Testing.
• Responsible for design and development.
• Developed Web based Application using ASP.Net, HTML, C#.
• Worked extensively with different ADO.NET objects to interact with SQL Server database and good experience in using ADO.Net objects such as SQL Connection Object, SQL Command Object, Data Reader, Dataset and Data Adapter.
• Worked on optimizing the ASP.NET Web pages using C# and SQL Server stored procedure to call the application from the SQL Server database
• Used Unit testing to stimulate case scenarios to catch potential bugs. The Web
• Created Web methods using Web Service and deployed the Web Services on IIS in the production server.

• Project: Financial Management System to fulfillment of 8th semester of bachelor’s degree program
• Technologies used : Java, PL-SQL
• FMS is being developed to become the backbone of all finance activities of the finance department for the Government. The main objective of the proposed system is to come up with a flexible and state of the art solution, which will provide a long-term IT strategy, and will address the entire major information technology component necessary to implement an integrated suite of application systems that will provide the framework for effective e-governance. The area assigned to me was Pay Fixation Module.