Dev Pratap Singh

Experience

1. Sde Intern

   OpsTree Global

   Jun 2025 — Present · Noida, IN

   Client: LuxAsia• Built and deployed a backend service using Django, Python, and SQL to handle bulk Excel uploads (100+ files in a single click), streamlining workflows for analysts.• Implemented efficient database-driven CRUD operations and optimized table structures, improving query performance by 65% and reducing cloud costs by 66%.• Automated schema validation, error handling, and logging, reducing backend errors by 90% and cutting manual correction efforts from 12 analyst-hours/week to less than 1 hour/week.• Optimized backend performance, reducing processing time from 1–1.5 hours per batch to under 10 minutes (95% faster).• Containerized the application with Docker to enable consistent deployments, easier scalability, and simplified environment management.Client : S2i• Designed and maintained a production-grade backend pipeline on Azure Synapse for real-time social media sentiment analysis, leveraging SQL/T-SQL for efficient data modeling and transformation.• Developed REST APIs to deliver processed insights, integrated with Databricks for collaborative analytics, and built interactive dashboards in Power BI and Excel to visualize trends and support business decisions.