Mayank Morya

PROJECTS

• The Satkar – Hospitality Management System

Description:
The Satkar is a comprehensive Hospitality Management System designed to automate and streamline daily hotel operations. The system covers a wide range of modules including guest booking, check-in/check-out, kitchen order tickets (KOT), settlements, invoice generation, and dynamic reporting. It also integrates role-based access control and secure authentication using JWT tokens. The system enables hotel staff to manage day-to-day operations with real-time updates, improving efficiency and guest experience.

Responsibilities:
• Involved in the full software development lifecycle, from requirement analysis to deployment
• Designed and implemented secure REST APIs using ASP.NET Core and Entity Framework Core
• Developed and optimized backend modules like Settlement, Booking, and KOT Management
• Integrated JWT-based authentication and custom role-based authorization middleware
• Built dynamic reporting modules with export functionality
• Collaborated with UI developers to ensure responsive and intuitive front-end behavior
• Participated in daily scrum calls, code reviews, and sprint planning sessions

Tech Stack: .NET Core, MVC, MS SQL, AJAX

• Doot – Background Job Scheduler

Description:
Doot is a lightweight and modular background job scheduler designed to automate periodic data processing and reporting tasks for the hospitality domain. It features custom scheduling logic, dynamic job configurations, and email-based report delivery using AWS SES. Doot enables centralized control over all background operations like invoice generation, data snapshots, and report emailing, ensuring high reliability and minimal manual intervention.

Responsibilities:
• Designed and developed core scheduling engine using Hangfire with support for custom job types
• Created job definition tables and admin interface for runtime job configuration
• Developed ADO.NET-based stored procedure execution layer for report data generation
• Integrated Amazon SES for automated email delivery with PDF and Excel attachments
• Built logging mechanism to track job execution, failures, and retry attempts
• Worked on deployment and configuration of scheduler service on production servers
• Optimized job performance for scalability and reliability across multiple tenants

Tech Stack: .NET 8, Hangfire, MS SQL, SES

• OpentForce - Independant Contractor Management

Led the migration of legacy MS SQL Server reporting procedures to Snowflake, rewriting complex T-SQL queries and stored procedures into Snowflake-compatible SQL and optimizing performance.

Implemented robust date-truncation, CTE, XML-parsing and string-function conversions, resolving key data-format challenges and ensuring accuracy.

Collaborated with ETL and BI teams to integrate these Snowflake solutions into existing data pipelines, improving query efficiency and maintainability.

Tech Stack: .NET MVC5, React, MS SQL, PostGres, Snowflake

• FENCE OUTLET

The Fence Outlet Appointments is a web application for creating new appointments for creating fences. The application helps to create appointments and assign a person to estimate the project on provided time. It also contains the functionality to check the availability of estimators and organization on the selected day of the appointment and provides reports for different parameters.

Tech Stack: .NET 6, Entity Framework

• CISOMATE

It's a cyberSecurity Project, it's divided into multi-project each project has different work like admin dashboard, CustomerProject, and BackEnd project.

Tech Stack: .NET 6, Entity Framework

PROJECTS

• FINTECH Services

Description:
The Fintech Services platform was designed to handle core financial operations such as money transfers, BBPS (Bharat Bill Payment System), utility recharges, and payment gateway integration. The system offered robust and secure API handling with support for third-party service providers, built-in logging, and dynamic service management. It was deployed across multiple clients serving large volumes of real-time financial transactions.

Responsibilities:
• Developed RESTful APIs for services like Recharge, Money Transfer, BBPS, and Utility Payments
• Integrated third-party APIs and handled response parsing, error mapping, and transaction validation
• Used Dapper and ADO.NET for high-performance database operations, stored procedures, and triggers
• Built service dashboards and admin portals for API status, logs, and transaction control
• Managed production deployments and versioning through FTP and Windows Server configuration
• Participated in technical discussions, code reviews, and system design with product and QA teams

Tech Stack: ASP.NET Core, MVC, MS SQL Server, Dapper, ADO.NET, Web API, Windows Server

PROJECTS

• Inventory & Employee Management System

Description:
This internal tool was developed to manage the day-to-day operations of the organization’s inventory flow and employee records. The inventory module helped in recording stock entries, tracking material consumption, and managing vendor-wise transactions. The employee module included staff registration, attendance tracking, and leave planning with dynamic report generation.

Responsibilities:
• Designed and implemented CRUD operations for inventory master entries and stock movement
• Developed employee registration, leave planner, and attendance log modules
• Built reporting dashboards using SQL views and stored procedures for real-time data visualization
• Applied form validations and client-side interactivity using jQuery and Bootstrap
• Implemented role-based access and approval workflow for leave management
• Ensured optimized SQL queries for data-heavy operations and monthly reporting

Tech Stack: ASP.NET MVC, MS SQL Server, ADO.NET, jQuery, Bootstrap