I’m putting together an Android-only mobile app that talks directly to our on-premise SQL Server; nothing is stored or synced to any cloud service. The devices will be on the same local network, so the app should open a secure connection to the existing database, read/write data, and gracefully handle moments when Wi-Fi drops. Core workflow • Task management – users need to create, assign, update and close tasks that already live in a Tasks table on the server. • Phone-number login with OTP – the first screen asks for a mobile number, sends an SMS through our gateway, then verifies the code before opening the main dashboard. No email or social logins are required. I will provide: • Database credentials and table structure • Access to our SMS gateway for OTP delivery • UI wireframes showing the three main screens (login, task list, task detail) You will deliver: • Full Android Studio project (Java or Kotlin) • Signed APK plus install guide for our in-house MDM • Brief setup notes explaining how the connection string, OTP endpoint and any required ports are configured Acceptance criteria 1. Successful connection to the local SQL Server when the device is inside our LAN. 2. Tasks can be created, edited, filtered by status and synced instantly. 3. OTP flow completes in under 15 seconds, locking the user out after three failed attempts. 4. Source code is clean, well-commented and compiles without warnings in the latest Android Studio. If you have questions about the schema or the network environment, let me know and I’ll clarify right away.