Rajender Dichpally
SENIOR ORACLE PL/SQL DEVELOPER | UNIX SHELL | AUTOSYS | FINANCIAL SERVICES
Hire this person
Send a job offer directly to this candidate
About
Senior Oracle PL/SQL Developer with 20+ years of application/database development experience supporting enterprise financial, capital-markets, compliance, reporting and data-processing applications. Deep hands-on Oracle PL/SQL expertise developing and maintaining packages, stored procedures, functions, triggers, views, tables, indexes, partitions and complex SQL for high-volume, business-critical systems.
Strong
Unix/Linux shell scripting and enterprise batch-processing background, including job scheduling and operational support using Autosys and Control-M environments. Experienced partnering with business users to gather and refine requirements, analyze functional gaps, develop technical designs and solutions, define test scenarios, support UAT, troubleshoot production issues and deliver end-to-end enhancements. Strong performance-tuning, ETL/data-integration, data analysis and Agile/SDLC experience across banking and financial-services organizations.
Extensive finance-domain data experience; Oracle Financials application-module expertise should be discussed separately if required by the client.
Experience
Senior Database / SQL Developer - Reporting & Data Platforms at HUDSON INSURANCE GROUP (2025-08 – 2026-06)
- Worked with business/reporting users to gather requirements, analyze data and functionality gaps, define processing rules and deliver database/reporting solutions for statutory and operational reporting.
- Developed and optimized complex SQL/database procedures, functions, views, tables and reusable processing logic for high-volume premium, claims and finance/reporting datasets.
- Defined validation scenarios, reconciled source and target results, supported testing/UAT-style business validation and resolved production data/process issues through root-cause analysis.
- Automated repeatable batch/reporting processes and documented operational procedures, controls and technical solutions.
Independent Database / Application Projects at TECHNOLOGY SME CONSULTING - THRIKASA (2024-09 – 2025-07)
Delivered Oracle/SQL Server development, PL/SQL/SQL, Unix/Python automation, ETL, data migration, reconciliation, performance tuning, requirements analysis and production-support services.
Senior Oracle / Database Developer / Data Analyst / Project Lead at MIZUHO BANK (2017-03 – 2024-08)
- Designed, developed and maintained Oracle PL/SQL packages, stored procedures, functions, triggers, views and complex SQL supporting Fixed Income, Equities, finance, market-risk/VaR, compliance and management-reporting applications.
- Developed Unix/Linux shell scripts for file processing, database operations, ETL execution, validation and production automation; supported scheduled enterprise batch workflows using Autosys/Control-M-style scheduling environments.
- Partnered with business, risk, finance, compliance and technology stakeholders to gather requirements, analyze gaps, document technical designs and translate business rules into scalable database/ETL solutions.
- Defined and executed validation/test scenarios, supported UAT and release validation, investigated defects and production issues, and implemented durable fixes and operational workarounds.
- Performed Oracle/SQL performance tuning using execution plans, indexing, partition-aware design, query rewrites and PL/SQL/ETL optimization for large financial datasets.
- Developed Informatica PowerCenter mappings/workflows and batch processes integrating multiple source systems into enterprise data warehouses and reporting platforms.
- Worked through full Agile/SDLC delivery and led/coordinated project activities across distributed development, QA, support and business teams.
Database Developer at PRICEWATERHOUSECOOPERS (2016-02 – 2017-03)
Supported a global compliance application through Oracle/database development, ETL/data integration, requirements analysis, testing, migration, technical documentation and production troubleshooting; led a remote development team.
Oracle / Database Developer at BANK OF AMERICA (2015-06 – 2016-02)
Developed and tuned Oracle/Exadata PL/SQL solutions for Actimize transaction-surveillance/risk applications; supported high-volume processing, Informatica integration, testing, performance tuning and controlled production releases.
Oracle / Database Developer at NOMURA SECURITIES (2004-01 – 2008-12)
Designed and supported Oracle PL/SQL, Unix and Informatica solutions for Fixed Income, Treasury, Asset Management, Mortgages and Management Reporting; partnered with controllers and business users on requirements and production support.
Oracle / Database Developer at JP MORGAN CHASE (2013-09 – 2014-07)
Built Oracle/SQL Server data marts, ETL and reporting solutions; automated reconciliation, monitoring and recurring batch processes and supported business validation and production delivery.
Principal / Founder at TECHNOLOGY SME CONSULTING - THRIKASA (2008-01 – Present)
Various Positions at Earlier Experience
United Nations / UNICEF, Thomson Reuters, The Vitamin Shoppe, United Water / Suez, Standard & Poor's - enterprise Oracle/database development, Unix/data integration, reporting, application support and project delivery.
Education
M.S. in Computer Science – New York Institute of Technology (1997)
M.B.A. in Finance – New York Institute of Technology (1994)
M.B.A. in Marketing – New York Institute of Technology (1993)
