Lokeshwar Reddy

• Developed and maintained Oracle stored procedures, functions, packages, triggers, and complex SQL queries, enhancing performance of business-critical applications.
• Optimized query performance by analyzing execution plans, indexing strategies, and rewriting SQL/PLSQL logic—improving overall system efficiency.
• Implemented robust data validation, exception handling, and logging mechanisms in PL/SQL/ETL, significantly minimizing data errors and rework.
• Designed ETL workflows to extract data from source systems, apply transformations, and load into target tables while ensuring data consistency and accuracy.
• Built and enhanced SSRS reports (parameterized reports, drill-downs, complex datasets) to support business stakeholders and daily operations.

Key Achievements (customize):

• Reduced report runtime by 30% by optimizing SQL queries and SSRS datasets.
• Delivered 25+ SSRS reports / enhancements for Finance/Operations/Management reporting.

• Developed ETL data integration routines, enhancing reliability of scheduled loads and incremental updates.
• Designed ETL mappings for handling joins, aggregations, cleansing rules, and slowly changing data requirements.
• Created PL/SQL scripts for batch processing, data migration, and reconciliation between source and target environments.
• Developed and optimized PL/SQL scripts for data retrieval and processing.
• Developed SSRS reports using stored procedures/views to improve maintainability and performance.
• Built dashboards and report datasets for business teams, optimizing joins and filters to efficiently manage large data volumes.
• Supported UAT and production releases by preparing data fixes and validation workflows, ensuring data accuracy and operational continuity.
• Supported application development by integrating Oracle databases with various systems.

• Collaborated with senior developers to build PL/SQL procedures/functions and write SQL for reporting and data processing.
• Supported ETL jobs for loading data into reporting tables and ensuring accuracy of historical records.
• Developed SSRS reports (basic/medium complexity) including parameters, formatting, and dataset changes.
• Debugged SQL/PLSQL logic and validated results across environments to resolve defects.
• Maintained documentation for database objects, ETL workflows, and report dependencies.
• Conducted system testing to ensure functionality and performance of applications.
• Provided technical support and troubleshooting for Oracle-related issues.
• Documented processes and procedures for database management activities.

• Designed and developed Oracle database objects including stored procedures, functions, packages, triggers, views, and materialized views to support application and reporting needs.
• Worked on complex SQL queries involving multi-table joins, window functions, and aggregations to generate datasets for business reporting and analytics use cases.
• Developed PL/SQL batch processing logic for periodic data loads, validations, and reconciliation to ensure reporting data accuracy.
• Implemented ETL integration logic:extracted data from source tables/systems,
  applied transformations (cleansing, mapping, deduplication, normalization),
  loaded into target/reporting tables,
  maintained incremental load strategies and audit columns (created/updated timestamps, batch id, status flags).
  
• Created and optimized ETL stored procedures for scheduled data loads using Oracle Scheduler/Jobs, incorporating restart mechanisms and error logging for reliability.
• Developed SSRS reports with:parameterized datasets (date range, region, category, customer/product),
  report filters, tablix formatting, and drill-down behavior,
  optimized datasets using stored procedures/views to reduce load time and improve reliability.
  
• Performance tuning activities:analyzed execution plans and query performance bottlenecks,
  improved indexes and query patterns,
  optimized PL/SQL loops (bulk operations, set-based processing) to reduce execution time.
  
• Production support & incident handling:investigated failed ETL/reporting jobs,
  fixed PL/SQL logic errors,
  ensured re-runs/reprocessing with minimal business impact.