Build Signup + OTP Verification Module Using SQL Server Stored Procedures

Job ID: 40012333

Budget: ₹12,500 – ₹37,500 INR

I need a complete signup and OTP-verification module developed in React, wired directly to the SQL Server stored procedures I already have in place. The form must capture full client information—name, email, phone number, and address—together with a website URL field that is validated in real time. The state dropdown will be populated by calling my existing GetStates SP, and the final Create button should invoke InsertClientMasterData.

On execution the SP returns status codes; the component should interpret them, surface friendly messages, and, on success, redirect users to Sign-In. Immediately afterward, the workflow triggers Generate_Insert to create an OTP, deliver it (I will plug in the SMS/email provider later), and finally Verify_Auth to confirm the code the user enters.

Key requirements
• Front end built with React (per my preference).
• Custom styling—please avoid canned Bootstrap or Material elements so the look matches the rest of our site.
• Secure password hashing on the client before transmission.
• Clean separation of UI logic and call-layer that hits the SQL procedures (Axios or fetch is fine; TypeScript welcomed).
• Proper error handling for each status code returned.
• Clear, well-commented code and a short README explaining build and deployment steps.

In your proposal, let me know:
1. Estimated turnaround time.
2. Fixed-fee quote for the full module.
3. Any libraries or tooling you’d add to the React stack (form handling, validation, encryption, etc.).

I will provide the SP signatures and connection details as soon as we start. Looking forward to working with you.