Piyush Patel

PIYUSHKUMAR PATEL

Euless, TX 76039 

• Over 15 years of professional IT experience full life cycle development in designing, developing, deploying and implementing Web-based and Client-Server Applications using. Net Framework.
• My Day-to-Day Responsibilities of a .NET Full Stack Developer with expertise in C#, VB.NET, ASP.NET, MVC, Web API, REST-API Services, Windows Azure, DevOps, ADO.NET, Entity Framework, SSIS, jQuery/Angular, .NET Core 3.0+ and SQL SERVER 2022 and PowerShell. Bachelor's degree in Computer Science and or Master's degree in Master of Computer Application. 

Application Development:

Design, develop, and maintain web applications using C#, VB.NET, ASP.NET, and .NET Core, ensuring high performance and responsiveness. Implement features and functionalities in accordance with project requirements and specifications.

Develop new products and solving practical computing problems.

Front-End Development:

Create and maintain user interfaces using technologies like HTML, CSS, JavaScript, jQuery, and Angular.

Ensure that the web application is visually appealing, user-friendly, and responsive across various devices.

Back-End Development:

Build and maintain server-side components using ASP.NET, MVC, and Web API, handling business logic and data processing.

Implement RESTful APIs using Web API for communication between the front-end and back-end systems.

Experience in API design /development from scratch.

Database Management/SSIS/SSRS:

Strong knowledge of SQL Server Integration Services (SSIS) and SQL Server databases.

Proficient in writing complex stored procedures, user defined functions, T-SQL scripts and Triggers using SQL SERVER and Oracle 18C.

Design and maintain databases, including the use of Oracle, to manage data efficiently and securely.

Optimize database queries, manage data models, and ensure data integrity.

Experience in designing and developing Databases in SQL Server 2019, PL/SQL and Oracle database, which includes the development of functions, stored procedures, views, and triggers.

Extensive experience with Extract Transfer Load (ETL) processes and data migration.

Extraction, loading, and transformation (ETL) of data by extracting data from multiple sources, such as CSV, SQL Server database, Oracle database, and Excel files using SSIS.

Perform data cleansing between systems

Designed and developed SSIS packages to move data from various sources into destination flat files and databases.

Experience in designing and developing Reports & ETL solutions using SQL Server SSIS/SSRS/SSAS

Production Support:

Identify, diagnose and find ways to resolve the issue and collaborate with other team members to address the problem.

Analyze various metrics and logs to understand the reason for system failure or non-performance. Using different debugging and diagnostic tools find solutions to improve software performance.

identify potential improvement areas in the production system and implement suggestions such as code optimization and enhancement of the production infrastructure.

Windows Services:

Create and maintain Windows Services for background processing tasks, such as scheduled jobs and data synchronization.

Version Control:

Use version control systems like Git to manage code changes and collaborate with team members effectively. Debugging and Testing:

Identify and resolve issues and bugs in the code, performing thorough testing and debugging. Write unit tests to ensure the reliability of code.

Performance Optimization:

Continuously monitor and optimize the performance of the web application and database to ensure optimal user experience.

Security and Compliance: Implement security best practices to protect sensitive data and ensure compliance with industry regulations. Regularly update security measures to stay ahead of potential threats.

Documentation:

Maintain clear and comprehensive documentation of code, configurations, and processes for future reference and team collaboration.

Analyze and solve complex problems:

Analyze complex problems and develop solutions using algorithms and data structures using my knowledge of computer science to develop efficient and effective solutions to problems.

OOPS:

Working on implement OOP concepts include abstraction, encapsulation, inheritance and polymorphism.

Maintenance and Support:

Provide ongoing maintenance and support for existing applications, addressing user issues and enhancing functionalities as needed.

Research and Learning:

Stay up-to-date with the latest trends and technologies in the software development field,

especially in the .NET ecosystem, to continuously improve skills and knowledge.

Project Management:

Participate in project planning, task estimation, and progress tracking, ensuring that development tasks align with project goals and deadlines.

Troubleshooting:

Quickly identify and resolve technical issues, both in development and production environments, to minimize downtime and maintain system reliability.

Cloud Computing (Azure)

Develop and maintain Web Applications and databases in Azure environment.

Perform migration processes to or from Azure environment​

Design, develop, and maintain automated build, test, and deployment pipelines

Monitor and troubleshoot system performance and availability

Implement and maintain continuous integration and continuous delivery systems using CI/CD Pipeline.

PROFESSIONAL EXPERIENCE

California Student Aid Commission | NET Developer Nov ’22 – Present

Sacramento CA

Responsibilities:

• Architecture, UI design and coding using Angular 14, TypeScript 4.0, Node, CSS3, HTML5 and .NET Core APIs for creating the web application.
• Implemented Azure Logic Apps for creating and processing the Express packaging workflows automation.
• Designed an automated deployment Azure DevOps CI/CD pipelines that reduced deployments time from 1 hour to 10 minutes. 
• Implemented Azure Service Bus to process queued deployable applications, sending emails, planned and break-fix deployments.
• Working on gathering, documenting, and clarifying software requirements.
• Translate business requirements and established architectural patterns into detailed designs.
• Development code experience with Docker and Kubernetes 
• Used Entity Framework Core for migration and database connection. 
• NuGet package development and delivery – Manage NuGet package for NET. core It enables developers to create, share, and consume useful NET libraries.
• Performs all aspects of the software development lifecycle (SDLC).
• Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning, multi-tasking, and optimizing queries which takes longer time in execution with SQL server.
• Worked extensively with SSIS to import, export, and transform the data between the linked servers. 
• Resolve development issues that occur during the testing of existing projects.
• Implemented JWT token-based authentication to secure the ASP.NET core Web API and provide authorization to different users.
• Implemented modern security authentication managers and protocols such as SAML / OAuth / Certificate Authorization.
• Develops new features in complex, object-oriented, multi-tier, or Web applications.
• Translate business requirements and established architectural patterns into detailed designs.
• Develop and maintain Azure cloud infrastructure, including virtual networks, storage accounts, and virtual machines 

EB API, LINQ, Entity Framework, JavaScript, SQL Server 2019, DevOps, and Azure.

Roadzen | .NET / SQL Lead Developer Apr ’16 – Nov 22

India

• Roadzen is building technology infrastructure that powers the global insurance economy. Award-winning AI research producing industry-leading models in telematics, computer vision, language models and generative AI focused on insurance for mobility. Start-up Roadzen, which has emerged as a major global auto insurance technology company powered by artificial intelligence (AI), has been listed on NASDAQ. Its ordinary shares trading on the Nasdaq Global Market under the symbol "RDZN" 

Roadzen Lead Projects - StrandD, MyAssist, xClaim and Reliance Anywhere Assist – RSA

More than 6+ years’ experience on lead senior software developer

StrandD - On Demand Roadside Assistance 

• I lead above mentioned entire projects assign work item to our team members (6-7 employees).
• Working on Requirement analysis and divided entire project in number of modules like Signup Module, Login Module, Incident Module. Messaging Module, Operator Module, Vehicle Module, Communication Module, Service Provider Module, Insurance Module, Payment Module etc.
• I created a use case and design documents as per requirement analysis.
• Created Database ER diagram based on three components: entities, attributes, and relationships.
• -Discuss requirement with product development team and create a work item in Basecamp tool according to discussed requirement.
• Create a project and Configure Project structure. Adding a source control GitHub, create a Model, Configure Entity Framework package.
• Created a DB Context and Configure Entity Framework code. In Application setting configure connection string and secret ex. payment, send grid, API end points, SSL Secrete etc. and register application Db Context to program class file. 
• Create a database using code first approach of entity framework and complete migration of database with SQL Server. 
• Create a controller class and write a code to perform crud operations and access web API for handles user It retrieves data from the Model and renders view as response.
• Added Data Annotations to define the rules for the model classes or properties for data validation and display suitable messages to end users.
• Discuss with developers for assignment work as per requirement and assign items to particular developer as per their expertise knowledge.
• Review code written by developer and optimize the code for increase quality and reduce execution time.
• Create a number of test cases and test code manually as well as using selenium tool. 
• Reassign the work to respective developer if work item is not exactly work as expected and test cases.
• Asking developer to complete work in given deadline and help developer to facing any issues in development.
• Responsible for solving complex code challenge and developer facing coding issues during development.
• Re test the code properly and mark the work item ready for deployment process and commit the code in git hub.
• Manage the code using Source code management tool Git. Create a primary branch master where all the production code is stored and create a number of another branch where all the development and stagging environment code is stored.

Reliance Anywhere Assist - RSA

Create application RSA Sign up for a free account for Reliance policy users and request for assistance in seconds with this easy to use and simple app road side assistance. Provide service to access Reliance insurer users to access road side assistance features. We check vehicle insurer policy is expired or not.

If its policy is not expired or it renewed, we allow access our roadside assistance functionality to reliance users. I discussed reliance anywhere assist team and manage this project as per requirements.

xClaim - Automated Smart Claims Management- xClaim is an end-to-end claims management platform that enables insurers to fast-track motor claim processing. xClaim's loss assessment and damage estimation tool utilize computer vision to automatically determine the severity of damage and calculate repair costs, helping you minimize claims processing times from weeks to only a few hours. I handle Back- end part and perform service side lead for this project.

• Develop Web Applications using Single Page Application Architecture using Angular 10, TypeScript 4.0, CSS3, and HTML5.
• Performs all aspects of the software development lifecycle (Agile Method).
• Coding implementation – Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end.
• Written WEB-API code base to build a cross-platform application (Mobile App and Web Client).
• Work on SQL SERVER Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types and functions for this project.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2015 to SQL Server 2019.
• Build Restful Web API for front-end application consumes and manipulations.
• Created admin tool and company website with ASP. Net Core 6.0 (C#.Net), Angular 10 using Typescript 4.0 to create Directives, Components, Services, Pipes, form validators, and routers for multiple components utilizing Router Guards and Navigation. 
• Dedicated to applying principles of Agile management to projects and tasks. 
• Software Maintenance - changing, modifying, and updating software to keep up with customer needs.
• Championed numerous enhancements to existing web applications, including upgrading the backend from SQL Server 2019 to 2022, converting older visual Studio asp.net application to 2022 and web server upgrades, and creating web services/RESTful Services in C#.Net to meet various business requirements.
• Software Maintenance - changing, modifying, and updating software to keep up with customer needs. 
• Testing- Conducted end-to-end testing before the application was released to production, troubleshooting for program errors in existing systems.
• Implemented database standards and naming conventions for the database objects.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Performed database consistency checks.
• Developed Database Backup Scripts and automated this process.
• Responsible for Solved critical production problems.
• Testing Web-API using the Postman tool.
• Implemented modern security authentication managers and protocols such as SAML / OAuth / Certificate Authorization.
• Deployment of Web and Mobile Applications and Databases to Azure Cloud Production environment.
• Designed and implemented a monitoring and alerting system using Azure Monitor, resulting in a 30% reduction in downtime
• Implemented and maintained Azure Active Directory, improving user management and access control for cloud-based applications and services.
• Use Azure Key Vault to securely store and manage sensitive information, such as application secrets. 
• Working on Azure Web Application, Mobile Application, and Services deployment process and allocating resources and applying best features of Azure for increased security.
• Storage all types of unstructured data like audio, video, and images are adaptable with Blob.
• Perform End-User testing before deploying an application to production to reduce the impact and error in production.
• Cerate documents to keep track of various stages of production incidents and for production deployment.
• Notification of Production Error, Investigation or Analysis of Production Error, Resolution of Production Error
• Analyze Web application source code to identify the coding issue and communicate with the development team for resolution.
• Provide 24×7 operational support to all production Environments on holidays and weekends.
• Coordinate with various teams and raise support tickets for all issues, analyze root causes, and assist in the efficient resolution of all production processes.
• Run Web application code step by step in a debugging tool like Visual Studio, to find the exact point where the developer made a programming mistake and then understand what corrections the developer needs to make in application code and resolve it quickly.
• Created a log file to track server errors and identify application errors.
• Migration of database from local to production Azure SQL Server.
• Debugging code to resolve existing issues for finding the root of a problem in a code base and fixing it.
• Working on Software Enhancements - modifications or improvements made to the existing software application code and store procedures code to improve the performance of the web application/mobile applications.
• Working on increasing SQL Server stored procedure performance to reduce the overall execution time of store procedure.
• Review the web application code to optimize web application performance.

Environment: 

Visual Studio 2022/2019, Angular 10, Azure, Typescript 4.0, ASP. Net Core 7 (C#.Net), MVC, WEB API, LINQ, Entity Framework, WPF, JavaScript, Azure Mobile Web service, jQuery, SQL Server 2019, JSON, XML, Postman, GIT, Azure Blob Storage, Windows Azure, DevOps.

Avacara | Senior .Net Developer May ’10 – Mar ‘16

Pittsburgh (Offshore from India)

Responsibilities:

• Prepare Architecture and implementation of the applications in the Azure, on-premises environments. 
• Design Restful API with best practices that conform to specific architectural constraints, like stateless communication and cacheable data.
• Work with business analysts, technical leads, and developers to overview the solutions and discuss technical challenges. 
• Coding implementation – Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end.
• Written WEB-API code base to build a cross-platform application (Mobile App and Web Client).
• Work on SQL SERVER Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types and functions for this project.
• Build Restful Web API for front-end application consumers and manipulations.
• Created admin tool and company website with Angular using Typescript to create Directives, Components, Services, Pipes, form validator, and Router for multiple components utilizing Router Guards and Navigation. 
• Dedicated to applying principles of Agile management to projects and tasks. 
• Software Maintenance - changing, modifying, and updating software to keep up with customer needs.
• Create a Responsive Website Using HTML5, CSS 3 & JavaScript.
• Building interactive and engaging user interfaces for web applications that can easily be upgraded and scaled to meet new business needs.
• Coding implementation – Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end.
• Written WEB-API code base to build a cross-platform application (Mobile App and Web Client).
• Software Maintenance - changing, modifying, and updating software to keep up with customer needs. 
• Testing- Conducted end-to-end testing before the application was released to production, troubleshooting for program errors in existing systems.
• Implemented database standards and naming conventions for the database objects.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Performed database consistency checks.
• Backup recovery schedules and backup database scripts.
• Developed Database Backup Scripts and automated this process.
• Solved critical production problems.
• Deployment Project and Database on Azure Server.
• Testing Web-API using the Postman tool.
• Deployment of Web and Mobile Applications to Azure Cloud Production environment.
• Perform End-User testing before deploying an application to production to reduce the impact and error in production.
• Cerate documents to keep track of various stages of production incidents and for production deployment.
• Notification of Production Error, Investigation or Analysis of Production Error, Resolution of Production Error
• Analyze Web application source code to identify the coding issue and communicate with the development team for resolution.
• Provide 24×7 operational support to all production Environments on holidays and weekends.
• Coordinate with various teams and raise support tickets for all issues, analyze root causes, and assist in the efficient resolution of all production processes.
• Run Web application code step by step in a debugging tool like Visual Studio, to find the exact point where the developer made a programming mistake and then understand what corrections the developer needs to make in application code and resolve it quickly.
• Created log file to track server errors and identify application errors.
• Migration of database from local to production Azure SQL Server.
• Debugging code to resolve existing issues for finding the root of a problem in a code base and fixing it.
• Working on Software Enhancements - modifications or improvements made to the existing software application code and store procedures code to improve the performance of the web application/mobile applications.
• Working on increasing SQL Server stored procedure performance to reduce the overall execution time of store procedure.
• Review the web application code to optimize web application performance.

India

Responsibilities:

• Involved in the development of Web Forms and classes using C#. NET that incorporates both N-tier architecture and database connectivity
• Developed ASP. Net pages using ASP. NET 3.5 web form controls, Controls, HTML server controls in C#.
• Used Visual Studio. NET 2008 IDE to design the forms, and develop and debug the application.
• Wrote SQL Queries to create tables, stored procedures using SQL server.
• Implemented version controlling using SVN.
• Deployed web application on Internet Information Server for production.
• Enhanced and developed UI functionality using ASP. NET, jQuery, HTML, and XML.
• Created CSS files to be applied to various web forms on the web pages.
• Used ADO. NET extensively for retrieving, querying, storage, and data manipulation.
• Used Page and Data caching concepts to increase the throughput of the ASP. Net pages.
• Used Ajax toolkit, regular expressions, regular expression validates, user search controls
• Created Crystal reports on the web page by accessing the database.
• Created stored procedures for application data access and manipulation.
• Involved in writing Transact-SQL Queries, stored procedures, user-defined functions, views, and good understanding of Normalization Database design, and modeling.
• Designed SQL Scripts, for creating relational database tables with primary-foreign key relations and temporary tables in SQL Server 2008 using T-SQL.
• Mainly involved in coding the business logic for the entire system based on the requirements in C# and used Design Patterns such as Abstract Factory, Facade & Singleton patterns for writing the business logic based on the requirement by using. Net Framework 3.5, C#, Visual Studio 2008.
• Maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.

Aim Global | .Net and SQL Developer Feb ’07 – Oct’ 07

India

Responsibilities:

• The Presentation Layer is implemented in ASP. Net with HTML, Cascading Style Sheets (CSS), and Web Controls. The Web Forms are developed utilizing the C#.
• Extensively used Ajax Controls to reduce the client server turnaround time, hence enhancing the performance of the application also used JavaScript for client-side validations.
• Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts for specific functionality in the project search module.
• Written LINQ-enabled queries to access the data from the SQL Server database. Used bindings to control the construction of the WCF channel stack at runtime.
• Used Grid View, Data List, and Repeater controls with Paging and Sorting for displaying various data onto the page.
• Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques. Modified database via Entity Framework code first migrations.
• Used XML intensively to bind the data to the web controls, data manipulation, and store data and send it as a parameter to the stored procedures Implemented Serialization and Deserialization of objects.
• Integrated HTML, CSS, and JavaScript into ASP. NET environment.
• Design responsive and intuitive user interface for the web using XHTML/CSS and both custom AJAX scripts as well as MS AJAX for ASP. NET library.
• Used AJAX-enabled grid to display the data to display the data fetched and used AJAX Toolkit to develop the controls also developed light-weight rich UI via extensive usage of jQuery
• Intensive use of CSS and XHTML to design the look and feel of the web pages.
• Used Microsoft patterns and practices recommended PRISM framework with features such as regions, modules, event aggregators, and delegate commands in implementing the (MVVM) Model-View-View-Model design pattern to develop a WPF application. 
• Developed user and custom controls using C#, Visual Studio, and Expression Blend for the WPF application.
• Developed a stored procedure search and obtained the data reports using facets to narrow down the search using ADO. NET Entity Framework and C#.
• Used ADO. Net Technology to connect the web forms to data sources such as MS SQL Server and XML files for manipulating data in the database.
• Worked extensively on web forms and data binding controls like Grid View, Data List and drop-down boxes and Mapping page fields to the database fields.
• Visual Studio is utilized as the IDE tool for the management of the project and controls as they are developed and deployed.

• Master of Computer Applications | Bhavnagar University Gujarat, India, 2006
• BS in Computer Science |South Gujarat University Gujarat, India, 2003