Titto Bobby

Database Developer @thinkingcode.ai

Kochi, IN

Designed and implemented high-performance databases using Oracle PL/SQL and PostgreSQL in DBeaver.• Developed and maintained stored procedures, functions, packages, triggers, and views, automating business logic and reducing manual processes by 50%.• Built and optimized scalable data models and enterprise data warehouses, reducing complex query run-time by 35% and supporting reliable reporting and analytics.• Collaborated with cross-functional teams to enhance the company’s data ecosystem, improve data models, and integrate external/internal APIs.• Implemented batch processing workflows using PL/SQL and Shell scripting.• Optimized existing SQL queries and procedures through index tuning, CTEs, query refactoring, and execution plan analysis, reducing average execution time by 45%; applied deep knowledge of normalization, indexing, partitioning, and relational database design to ensure scalability and maintainability.• Created and automated Jobs using Shell scripting for scheduled data ingestion and transformation, improving processing efficiency.• Developed and integrated ClickHouse queries into Helical Reports, enabling real-time dashboards and reducing reporting latency by 50%.• Created dynamic chart, calendar, and table widgets using ClickHouse queries, and integrated visualizations with Python APIs & Plotly.• Designed and delivered JasperSoft reports for compliance, audit, and operational reporting.• Developed and enforced business rules using a custom SQL Rule Engine, streamlining rule management across systems.• Analyzed claims, policy, and exposure data to identify trends in injury types, loss costs, and claim durations, informing strategy and reducing high-cost claims.• Actively participated in QA and testing activities, executing test scenarios, validating features, and collaborating with the QA team during UAT and release cycles to ensure defect-free deployments.• Migrated business-critical datasets and schemas from Oracle SQL to PostgreSQL.