Wreetojyoti Ray
Transforming complex data challenges into elegant solutions.
12+ years in Oracle & Database Engineering, now pioneering Generative AI innovations.
About Me
I'm a Senior Oracle Consultant with over 12 years of experience delivering enterprise data solutions for US healthcare and insurance clients. My expertise spans Oracle SQL, PL/SQL, and LabVantage (LIMS), with a proven track record of optimizing complex database architectures.
Currently, I'm actively pivoting to Generative AI Engineering, contributing LLM integration for automated reporting and building custom AI agents using Python and Prompt Engineering. I'm passionate about leveraging my deep data discipline in forward-looking AI Engineer roles.
Core Expertise: Oracle 11g/19c • SQL & PL/SQL • Unix Shell Scripting • LLMs (Gemini/GPT) • Prompt Engineering • RAG Concepts • LangChain • LabVantage (LIMS) • Linux • Git • VS Code
Work Experience
Senior Oracle Consultant
- Consistently retained by client (NeoGenomics) demonstrating exceptional domain expertise and value delivery
- Orchestrated end-to-end data loading lifecycle for new test onboards, transforming raw client specifications into LabVantage-compliant formats
- Engineered complex PL/SQL backend procedures for client-facing portal, enabling secure extraction of critical audit reports
- Optimized complex PL/SQL queries and triggers, ensuring 99.9% uptime for mission-critical laboratory workflows
- Collaborated with R&D team on Python-based automation tool utilizing LLMs to summarize complex SQL-based clinical data into natural language reports
- Assisted in optimizing system prompts for experimental RAG workflows to improve accuracy of historical patient data retrieval
Senior Oracle Consultant
- Managed ETL & Data Transformation for laboratory information management system
- Designed and maintained critical Jasper Reports for client deliverables and research results
- Provided portal backend support and performance tuning for mission-critical database operations
Oracle PL/SQL Developer
- Managed backend database operations for eBAO Policy Administration System
- Executed periodic data migration using advanced PL/SQL scripting
- Ensured database integrity during major patch updates for government insurance systems
System Engineer
- Maintained HRMS Portal and Database for government organization
- Executed query generation for complex payroll modules (7th CPC implementation)
- Performed regular database backups, upgrades, and module modifications
Database Developer
- Migrated mission-critical legacy data from IBM Mainframe (DB2) to Oracle Database
- Converted legacy COBOL/JCL scripts into modern Unix Shell Scripts for batch processing efficiency
Featured Projects
🌙 Dreamy Tales - AI Bedtime Story Generator
Built and deployed a full-stack Python web app allowing users to generate custom bedtime stories in seconds. Features family-friendly, culturally nuanced storytelling in Bengali and English with a one-click UI for non-technical parents.
✈️ Wander Master - AI-Powered Vacation Guide
Comprehensive AI travel planning application that generates personalized vacation itineraries with real-time pricing, hotel recommendations, transport options, and safety information. Features dynamic budget tracking with customizable options via an interactive bucket system, safety maps with emergency contacts, and downloadable PDF travel guides.
🔄 Legacy System Migration
Led migration of mission-critical data from IBM Mainframe (DB2) to Oracle Database for Bell Canada. Converted legacy COBOL/JCL scripts into Unix Shell Scripts, modernizing batch processing infrastructure.
Hobbies & Interests
Get In Touch
I'm always open to discussing new opportunities, collaborations, or just connecting with fellow tech enthusiasts.