Kokila Devi

Spinsoft Learning Solutions Pvt Ltd - Nov 2015 - Present - Database Architect - Team Size: 10

Designed and implemented a scalable PostgreSQL database architecture for a SaaS learning management platform. Implemented complex data models for courses, assessments, progress tracking, and analytics.

• ✓Optimized queries for 60% faster response times
• ✓Implemented real-time progress tracking
• ✓Built analytics aggregation pipelines

Spinsoft Learning Solutions Pvt Ltd - Nov 2015 - Present - Database Architect - Team Size: 8

A comprehensive degree planning platform that enables students to create, manage, and track their academic journey. Students can plan their coursework across semesters, track prerequisite requirements, monitor credit hours, and visualize their path to graduation. The system provides personalized recommendations based on degree requirements and helps students make informed decisions about their academic progression.

• ✓Designed database schema for degree requirements and course prerequisites
• ✓Built complex validation logic for course eligibility and credit tracking
• ✓Implemented semester-wise planning with drag-and-drop interface
• ✓Created graduation requirements tracking and progress visualization

CNSI - Nov 2014 - Oct 2015 - Developer - Team Size: 15+

Managed care compliance tracking system that incorporates managed care contract requirements, tracks performance and compliance with managed care contract requirements, audit requirements, structures workflow to handle issues, appeals, and information requests. The system assesses and tracks penalties and withholds against contract terms, configures rules for compliance event enforcement, captures and processes clinical data, performs data quality checks, and automates reconciliation processes.

• ✓Developed compliance tracking and contract management features
• ✓Built workflow automation for issues, appeals, and information requests
• ✓Implemented clinical data processing and quality checks
• ✓Created automated reconciliation processes

EnSteps Solution Private Limited - Nov 2010 - Oct 2014 - Software Engineer - Team Size: 7

A desktop application to automate the billing process and transaction maintenance in a database with monthly report generation for the transport companies network. It features a fully customized user interface to access the database for adding entries or modifying them. The system can generate bills for both new and older entries from the database as a token of authentication for customers.

• ✓Automated billing process and transaction management
• ✓Built customized UI for database access and entry management
• ✓Implemented monthly report generation for transport network
• ✓Created bill generation system with authentication tokens

EnSteps Solution Private Limited - Nov 2010 - Oct 2014 - Software Engineer - Team Size: 7

A web application developed to automate the tracking of external physical transport of products from companies by maintaining complete details about the drivers, vehicle, route, and goods. It provides accounts-related transactions and processes management. Loading of goods, transit, and delivered status are given appropriate flags and are reflected in the application immediately, which can be viewed by the users in real-time.

• ✓Built real-time tracking system for transport operations
• ✓Implemented comprehensive driver, vehicle, route, and goods management
• ✓Developed accounts and transaction management features
• ✓Created instant status updates for loading, transit, and delivery

EnSteps Solution Private Limited - Nov 2010 - Oct 2014 - Developer - Team Size: 4

A biometric fingerprint-based system to monitor employee presence hourly and automate employee management, roster management, and monthly report generation. Employees register their fingerprint along with personal details for the first time in the database, which helps in calculating their attendance automatically.

• ✓Implemented biometric fingerprint authentication system
• ✓Built hourly employee presence monitoring
• ✓Automated employee and roster management
• ✓Created monthly attendance report generation

Architected and built a microservices-based backend system for educational content delivery. Designed service boundaries, API contracts, and data synchronization strategies.

• ✓Deployed 12 independent microservices
• ✓Implemented event-driven communication
• ✓Achieved 99.9% uptime

Led the migration of legacy database systems to modern PostgreSQL infrastructure. Designed data transformation pipelines and optimized database schemas for performance.

• ✓Migrated 10M+ records with zero downtime
• ✓Reduced storage costs by 40%
• ✓Improved query performance by 70%

Led the migration of the company's on-premise MySQL Learning Management System table data to AWS Cloud RDS database. The project enabled seamless cloud migration with improved scalability, automated upgrades, patch releases, and comprehensive backup strategies for data protection and disaster recovery.

• ✓Migrated 10M+ records from on-premise MySQL to AWS RDS with zero downtime
• ✓Designed and executed ETL pipelines for data transformation and validation
• ✓Implemented automated backup strategies and disaster recovery procedures
• ✓Configured automated upgrades and patch management in AWS RDS
• ✓Performed data integrity checks and reconciliation post-migration
• ✓Reduced storage costs by 40% through optimization
• ✓Improved query performance by 70% with cloud infrastructure
• ✓Set up monitoring and alerting using AWS CloudWatch