Geeta Singh

Developed a Match API hosted on Cloud Run to interact with Cloud SQL (PostgreSQL) databases. The API retrieves StiristaIDs using user email inputs, supporting dynamic query handling. Implemented secure API endpoints with validation and optimized indexing for faster query performance. Enhanced API efficiency through caching and pagination mechanisms. Added structured response formats for improved system integration. Ensured CI/CD deployment using Cloud Build for consistent release management.

Developed an HTTP-based API on Cloud Run to fetch structured order data from PostgreSQL. Designed relational models for Order Header and Order Line tables for efficient querying. Implemented filters for dynamic queries like email, transaction ID, and order date. Optimized query performance with proper indexing and caching layers. Added input validation and structured JSON responses for client-side usability. Built a monitoring layer using Cloud Logging for real-time debugging and performance tracking.

Developed a gRPC-based Python client for the NCOA (National Change of Address) project, automating address updates. Integrated Pub/Sub triggers for event-driven data processing workflows. Designed workflows to move input/output files between Cloud Storage and BigQuery for analytics. Implemented robust error handling and retry mechanisms for reliable file processing. Automated BigQuery exports to Cloud Storage for easy data access and reporting. Enhanced the end-to-end automation to ensure secure and scalable data operations.

Developed a robust backend for managing massive datasets of customers, transactions, and orders. Implemented AWS Lambda for serverless operations, ensuring cost-efficient scalability. Integrated Amazon OpenSearch for rapid, flexible data querying and analytics. Combined RDS for structured and DynamoDB for unstructured data to optimize retrieval. Designed APIs for high-speed search and data filtering. Enhanced data consistency and system security using IAM-based role access controls.

Cozmo is a hotel booking and management platform for viewing availability and managing room details. Built APIs for real-time room availability and booking transactions. Integrated payment and calendar modules for seamless operations. Implemented authentication and role-based access for guests and admins. Enhanced query performance for large datase.

Performed large-scale web scraping for hotel booking systems like Cozmo and other projects. Collected and structured unorganized data into relational database formats. Developed automated scrapers for continuous data retrieval from multiple sources. Ensured error handling, deduplication, and scheduling with cron jobs. Built monitoring scripts to track scraping status and log performance metrics. Optimized data pipelines for high accuracy and low redundancy.