Anto Raj Mithun Roosewelt

<p>Designed and maintained complex Oracle SQL and PL/SQL solutions supporting enterprise applications.</p><p> Developed, optimized, and debugged complex SQL queries, stored procedures, packages, functions, views, and reusable database components.</p><p> Applied advanced SQL and PL/SQL techniques to support high-volume data processing, transaction processing, batch processing, and data validation.</p><p> Developed and optimized Amazon Redshift SQL solutions supporting enterprise analytical and data warehousing requirements.</p><p> Designed and maintained Redshift database schemas, tables, views, and data-processing components for scalable analytical workloads.</p><p> Supported bulk data processing, validation, and reconciliation between enterprise source systems and Amazon Redshift.</p><p> Performed SQL and PL/SQL performance tuning using execution plans, indexing, partitioning, query optimization, SQL Trace, and database performance analysis.</p><p> Performed Amazon Redshift query optimization and performance tuning by analyzing joins, filters, query execution behavior, and processing bottlenecks.</p><p> Analyzed data processing flows and implemented optimization techniques to improve performance.</p><p> Supported data migration and integration initiatives involving Oracle, Amazon Redshift, PostgreSQL, Snowflake, and AWS data platforms.</p><p> Investigated production application, database, SQL, and data-related issues and performed detailed root-cause analysis.</p><p> Implemented corrective solutions for database and data-processing issues while maintaining data accuracy and consistency.</p><p> Supported high-volume data processing and integration initiatives with data validation and reconciliation.</p><p> Monitored database tablespaces, partitions, index health, storage utilization, and server logs across Red Hat Linux environments.</p><p> Developed RESTful services using Java Spring Boot to integrate backend database services with enterprise application layers.</p><p> Collaborated with application teams, business stakeholders, and technical teams to translate business requirements into scalable database and data-processing solutions.</p><p> Worked closely with cross-functional teams to troubleshoot database, integration, and data issues.</p>

<p>Designed, developed, tested, and maintained complex Oracle SQL and PL/SQL solutions supporting mission-critical financial and customer transaction processing.<br>
Developed and maintained complex PL/SQL packages, stored procedures, functions, triggers, views, and database processing components.<br>
Developed advanced SQL and PL/SQL solutions for high-volume transaction processing, batch processing, data validation, and enterprise business workflows.<br>
Developed SQL solutions supporting data warehouse and analytical processing requirements using Amazon Redshift.<br>
Designed database schemas, tables, views, indexes, and database objects to support scalable application and reporting requirements.<br>
Performed SQL query optimization and database performance tuning using execution plans, Explain Plan, indexing, table partitioning, partition pruning, SQL Trace, and TKPROF.<br>
Optimized complex joins and database performance.<br>
Supported bulk data processing and batch workflows involving high-volume business transactions.<br>
Performed data validation, reconciliation, and troubleshooting to maintain data accuracy and consistency.<br>
Investigated production incidents and data-related issues, and implemented database and application fixes within SLA timelines.<br>
Supported ERP and enterprise transaction-processing business workflows.<br>
Supported database-driven reporting solutions for financial, transactional, and operational business requirements.<br>
Supported Oracle Forms and Oracle Reports applications used for enterprise business workflows and reporting.<br>
Performed Oracle database space management, including tablespace monitoring, storage-growth analysis, and file optimization.<br>
Developed Shell Scripts to automate batch processing, operational workflows, deployment activities, and database-related tasks.<br>
Collaborated with business analysts, application developers, and technical teams to understand functional and technical requirements and implement scalable database solutions.<br>
Worked with application and business teams to troubleshoot data-related issues and implement technical enhancements.<br>
Participated in Agile development, release management, source-control activities, technical documentation, and production support.</p>

<p>Designed, developed, tested, and maintained Oracle PL/SQL solutions supporting healthcare insurance claims processing, transaction processing, data integration, and automated validation workflows.<br>
Developed reusable PL/SQL packages, procedures, functions, triggers, views, and materialized views supporting complex business-process and reporting requirements.<br>
Developed complex SQL queries and PL/SQL programs for high-volume transactional processing and data validation.<br>
Supported bulk and batch data processing for healthcare transaction workflows.<br>
Supported Oracle Forms and Oracle Reports components used in enterprise application workflows and operational reporting.<br>
Developed database-driven reports and reporting components to provide business and operational information to application users.<br>
Performed SQL and PL/SQL performance tuning using Explain Plan, TKPROF, SQL Trace, indexing, and query optimization.<br>
Investigated SQL performance bottlenecks and optimized database processing for performance-critical application workflows.<br>
Troubleshot application and database issues in production environments and performed root-cause analysis.<br>
Collaborated with functional teams, business users, application developers, and database teams to resolve production incidents.<br>
Delivered application enhancements and database fixes within SLA timelines.<br>
Developed and maintained Linux Shell Scripts for batch processing and operational automation.<br>
Monitored database space and proactively identified storage and performance bottlenecks.<br>
Supported application maintenance, testing, deployment, and production operations.</p>

<p>Developed complex Oracle SQL and PL/SQL routines supporting high-volume enterprise batch processing and transactional business applications.<br>
Developed and maintained PL/SQL procedures, functions, packages, and database processing components.<br>
Developed and maintained automated batch-processing solutions using UNIX/Linux Shell Scripting and SQL*Loader.<br>
Automated daily batch execution, system health checks, data loading, and operational processes.<br>
Optimized heavy transactional SQL queries through execution-plan analysis, index tuning, partitioning, and partition-pruning techniques.<br>
Performed SQL and PL/SQL troubleshooting and optimization for performance-critical application processes.<br>
Supported Oracle Forms and Oracle Reports applications and performed technical troubleshooting for transactional business processes.<br>
Investigated application and database incidents, performed root-cause analysis, and coordinated fixes with application and technical teams.<br>
Performed database and server space management, including log monitoring, tablespace allocation, and storage-growth analysis.<br>
Provided Tier-3 production support and investigated application and database incidents.</p>

<p>Developed, customized, tested, and maintained Oracle PL/SQL packages, procedures, functions, and materialized views supporting ERP business operations.<br>
Developed SQL and PL/SQL solutions supporting enterprise transaction workflows, business processing, and operational reporting.<br>
Supported Oracle Forms and Oracle Reports-based enterprise applications and backend database processing.<br>
Performed database performance tuning using execution-plan analysis, index maintenance, table partitioning, and query optimization.<br>
Supported heavy month-end processing and financial closing activities through database performance optimization and space management.<br>
Performed database space and server storage maintenance to support high-volume business processing.<br>
Investigated database and application issues and performed root-cause analysis.<br>
Collaborated with application and business teams to troubleshoot production issues and implement technical solutions.<br>
Supported Oracle-based ERP application maintenance and backend database processing.<br>
Participated in application testing, deployment, production support, and technical troubleshooting.</p>