Parth U. Sheth

Accomplished Senior Software Developer at Ashapura Softech Pvt. Ltd. with expertise in C# and Azure Functions. Proven track record in enhancing user experience through innovative web applications and effective debugging techniques. Adept at collaborating in Agile teams, ensuring high-quality code, and driving project success through strong problem-solving skills.

• Programming For Everybody (Getting started with Python) - Coursera
• Python Data Structures - Coursera
• Using Python to Access Web Data - Coursera
• Using Databases with Python - Coursera
• Capstone: Retrieving, Processing, and Visualizing Data with Python - Coursera

English, Fluent (written and spoken)

Auction Project

Platform Used: React, .NET C#, SQL Server
Contribution: API Development and Database Management

• Designed and developed a comprehensive backend system for managing online cricket auctions
• Built RESTful APIs that handle player registration, bidding, and team assignments in real-time.
• Implemented a robust database schema in SQL Server to manage player data, auction history, and bidding transactions.
• Integrated with a React-based frontend to ensure seamless user experience and real-time updates.
• Optimized stored procedures and queries to handle high concurrency and large datasets efficiently.

TDL Project

1. Budget Module

Platform Used: .NET C#, SQL Server, EPPlus Library
Contribution: API Development for Budget Processing & File Management

• Implemented advanced Excel handling using the EPPlus library, allowing dynamic creation and formatting of multiple Excel sheets within a single workbook.
• Designed an API-driven workflow for file management
• Create API: Generates a new Excel file dynamically.
• PUT API: Updates the existing file with new data and formatting.
• Delete API: Deletes the specified file from storage.
• Clone File Feature: Enables users to upload an existing Excel file and generate a cloned version with modifications using database-driven logic and EPPlus.
• Automated data validation, conditional formatting, and table structuring in Excel to enhance usability and accuracy.

2. Queries Module

Platform Used: .NET C#, SQL Server, EPPlus Library
Contribution: Advanced Excel Processing & Dynamic Formatting

• Developed APIs for handling file processing where formatting details (styles, layouts, filters) are retrieved dynamically from the database in JSON format.
• Used EPPlus library to apply formatting, filters, and styling dynamically based on database-driven configurations.
• Implemented logic for dynamically loading and structuring data into Excel sheets, ensuring accurate representation based on user requirements.

3. Azure Environment & Cloud Integration

Platform Used: Azure Functions, Azure Web Jobs, Azure Storage Accounts, Azure Key Vault
Contribution: Cloud Integration & Automation

• Developed multiple Azure-triggered functions, including:
• SQL Trigger Function: Executes operations when a new record is inserted into the database, automating file import/export.
• Timer Trigger Function: Runs at scheduled intervals to perform periodic tasks such as data updates and maintenance.
• Queue Trigger Function: Listens for queue messages in an Azure Storage Account and processes files dynamically.
• Configured Azure WebJobs to automate background tasks.
• Integrated Azure Key Vault for secure storage and retrieval of sensitive information, ensuring enhanced security within Azure functions.
• Managed Azure Storage Accounts for efficient handling of file uploads and retrieval processes in the cloud.

Brain Payroll

Platform Used: C#, Angular, SQL Server
Contribution: Analysis and Coding

• Developed and enhanced payroll management features, including salary structure configuration, tax computation, and payslip generation
• Integrated the payroll system with attendance tracking, and automated tax calculation based on government regulations
• Designed real-time reporting tools for HR personnel to monitor and manage employee salary distributions
• Ensured system security by implementing role-based access control and encryption for sensitive employee data

Pay & Bill

Platform Used: C#, Angular, SQL Server
Contribution: Analysis and Coding

• Developed a robust billing and payment processing system for salary and wage management.
• Implemented automated invoice generation, real-time payment tracking, and tax deduction compliance features
• Enhanced system efficiency by optimizing database queries and improving API response times.

• Worked with Azure Functions to create scalable and event-driven APIs.
• Integrated Azure Storage Accounts to handle large-scale data storage and retrieval efficiently.
• Deployed applications on Azure Web Apps.
• Managed background tasks using Azure WebJobs, optimizing system performance for recurring jobs.
• Configured and maintained Virtual Integration to connect on-premise and cloud systems seamlessly.