Dheena Dheena

Oracle ODI & SQL Developer with 5+ years of experience in ETL development, data integration, and data warehouse solutions across Insurance and Telecom domains. Skilled in ODI 12c, Oracle SQL, complex query optimization, and data pipeline development. Proven track record delivering accurate, high-performance data solutions at TCS and Accenture.

Oracle ODI & SQL Developer - Accenture - Chennai, India

(2024-02)

• Led end-to-end ODI project development at Accenture — designing table-to-table, file-to-table, and table-to-file mappings aligned with complex insurance business requirements, ensuring seamless integration across source and target systems.
• Designed and implemented incremental load strategies and Slowly Changing Dimension (SCD) logic, reducing batch processing time significantly while maintaining complete historical data accuracy in dimension tables.
• Configured ODI topology across Development, Testing, and Production environments — managing physical/logical schemas and contexts to ensure correct data source connectivity for each pipeline execution.
• Developed and executed complex ODI mappings applying advanced transformations — filtering, aggregation, multi-source joins, lookups, expressions, pivots, and subquery filters — to meet demanding insurance data integration requirements with high accuracy.
• Utilized Check Knowledge Modules (CKM) for both static and flow control data validation — routing invalid records to error tables in real time without disrupting pipeline execution, maintaining full data integrity throughout the load process.
• Monitored, executed, and managed ODI scenarios and load plans in production, handling session restarts and resolving errors promptly to ensure uninterrupted data pipeline performance and SLA adherence.
• Implemented ODI packages and procedures with automated load plans — streamlining end-to-end data processes and significantly reducing manual intervention across development, testing, and production environments.
• Performed data reconciliation between source and target systems, validating ETL outputs and ensuring 100% accuracy and compliance with business rules prior to each production deployment.

Oracle ODI & SQL Developer - Tata Consultancy Services - Chennai, India

(2020-02 - 2023-07)

• Designed and deployed ETL processes using Oracle Data Integrator to integrate and transform insurance claims, policy, and customer data from multiple heterogeneous source systems — ensuring 100% data accuracy and full compliance with business rules.
• Built and optimized Oracle SQL queries and stored procedures to support seamless ETL operations, developed data pipelines processing 10M+ records including audit data into the data warehouse with optimal performance.
• Collaborated with business and cross-functional teams to translate requirements into effective data models, views, and tables — supporting operational decisions and ensuring clear communication between stakeholders and the development team.
• Tuned Oracle SQL queries and optimized ODI workflows to accelerate large-scale telecom data transformations, processing 10M+ records with significantly reduced execution times and lower system resource consumption.
• Wrote targeted SQL scripts for production data patching — identifying and correcting missing or erroneous records with surgical precision to resolve defects without impacting surrounding data or downstream processes.
• Conducted ad-hoc SQL investigations for business and QA teams to verify transformations, investigate data discrepancies, and provide direct support during UAT activities, ensuring accurate and timely project delivery.
• Attended daily defect calls and consistently resolved 3–4 defects per day — troubleshooting SQL and ODI issues, applying effective fixes, and maintaining an uninterrupted delivery schedule across telecom project phases.
• Worked onsite with client stakeholders to gather business requirements, coordinate deliverables, and translate needs into precise SQL queries and data models — acting as the technical liaison between business and development teams.
• Performed comprehensive data profiling and analysis using Oracle SQL to surface quality issues including duplicates, nulls, and inconsistencies, delivering actionable insights to business teams to support data governance initiatives.

Master of Business Administration - MBA - Bharathiar University (2022-06 - 2024-12)

Bachelor of Computer Applications - BCA - Karpagam Academy of Higher Education (2016-06 - 2019-04)