Prarthana Dokh

System Engineer @Tata Consultancy Services

Navi Mumbai, IN

Designed and architected scalable PL/SQL modules for AEPS transaction processing, supporting real-time integration with BASE systems.• Led end-to-end development of Oracle database components including advanced stored procedures, bulk processing (BULK COLLECT, FORALL), and performance-tuned packages.• Engineered configurable charge calculation in PL/SQL supporting 20+ account types with dynamic pricing logic.• Spearheaded batch performance optimization initiatives using index tuning and data archival strategies — reducing processing time by 35%.• Developed automated reconciliation framework reducing manual intervention by 70% and increasing transaction accuracy to 99%+.• Implemented secure transaction validation mechanisms and database-level fraud control checks.• Conducted execution plan analysis and query performance tuning for high-volume financial datasets.• Managed zero-downtime production deployments and handled 24/7 critical production support during financial year-end processing.• Collaborated with cross-functional teams (QA, Business Analysts, Operations) to deliver 15+ production releases with zero critical defects.Key Achievements:• Maintained 99.8% system uptime for mission-critical banking systems.• Reduced recurring production incidents by 45% through preventive database optimizations.• Recognized with Technical Excellence and Performance Awards for backend and database optimization initiatives.