Leela vinodh anuganti

Jun 2022 — Nov 2024

• Technologies: Oracle 12c/19c, PL/SQL, Oracle RAC, GoldenGate, Data Guard, AWR/ASH/SQL Trace, TDE, FGA, Data Masking, Privilege Analysis, Python (cx_Oracle, SQLAlchemy, Pandas), Azure SQL MI, Informatica, DBMS_SCHEDULER, UNIX
• Led the design of core banking modules for a $90B regional bank, ensuring 100% ACID compliance for 3M+ active accounts.
• Engineered a real-time Fraud Detection Rule Engine that flagged 98.7% of fraudulent transactions with minimal false positives.
• Automated regulatory reporting for Basel III and AML, reducing reporting effort from 5 analyst-days to 6 hours per cycle.
• Implemented security hardening by revoking 340 excessive grants and enforcing PCI-DSS and GLBA compliance.
• Configured GoldenGate replication to Azure SQL MI, removing 100% of reporting load from core Oracle production.
• Redesigned hot-path insert procedures to reduce peak-hour database CPU by 47% via sequence caching and APPEND hints.
• Architected an automated data archival framework that reclaimed 4TB of tablespace while improving query performance by 35%.
• Directed Oracle 19c Data Guard Physical Standby configuration with Fast-Start Failover for sub-30-second recovery.
• Orchestrated the delivery of loan origination and interest calculation logic for complex commercial real estate portfolios.
• Mentored a team of 4 junior developers and established a comprehensive PL/SQL coding standards wiki for the organization.
• Conducted deep-dive AWR/ASH analysis to eliminate global cache service contention in high-volume RAC environments.
• Established automated static code analysis within the CI pipeline, reducing production defect escapes by 55% over 18 months.
• Built a Python reconciliation framework utilizing SQLAlchemy and Pandas to validate daily ledger balances.
• Developed sophisticated dynamic SQL modules to support configurable business rules without requiring application redeploys.
• Optimized Oracle Connection Pool (UCP) settings to handle massive transaction spikes during peak banking hours.

Jan 2021 — May 2022

• Technologies: Oracle 11g/12c, PL/SQL, Oracle RAC, AWR/TKPROF/ASH, TDE, FGA, ODI, SQL*Loader, Data Pump, Informatica, DBMS_SCHEDULER, SQL Trace, UNIX Shell, Python (cx_Oracle, Pandas), Control-M, Data Masking, RMAN, Oracle APEX
• Spearheaded PL/SQL development for an investment platform managing $25B+ in commercial real estate assets.
• Automated investor reporting processes, saving 300+ finance team hours per reporting cycle while eliminating calculation errors.
• Built an ODI ETL pipeline that validated 100% of loaded records against multi-source source system checksums.
• Engineered lease administration modules managing 2,000+ active commercial leases across industrial and retail properties.
• Developed a Python reconciliation tool that reduced monthly asset management effort from 4 days to 8 hours.
• Optimized quarterly fund valuation batches, reducing processing time from 9 hours to 2.5 hours via materialized views.
• Architected Net Asset Value (NAV) computation logic and waterfall distribution procedures for multi-tier fund structures.
• Implemented Virtual Private Database (VPD) policies to enforce fund-level row access security for investment teams.
• Designed Portfolio Performance Analytics Engines using advanced analytic functions to compute IRR and MOIC metrics.
• Directed the integration of property-level data from Yardi and MRI Software into a centralized Oracle data warehouse.
• Established RMAN backup strategies and Data Guard configurations to ensure high availability for accounting systems.
• Developed an Oracle APEX dashboard providing real-time visibility into property KPIs and lease expiry heat maps.
• Championed the use of Transparent Data Encryption (TDE) to protect sensitive investor PII and financial records.
• Authored technical documentation and disaster recovery runbooks in alignment with SEC books-and-records requirements.
• Defined complex rent escalation logic for commercial leases, incorporating CPI-indexed and fixed-step adjustments.

Jan 2019 — Dec 2020

• Technologies: Oracle 11g/12c, PL/SQL, Oracle EBS R12, SQL*Loader, ODI, Oracle APEX, XML Publisher, UNIX Shell, AWR/TKPROF, RMAN, SQL Developer, HIPAA, Medicaid/CHIP Compliance, Python (cx_Oracle scripting)
• Orchestrated HIPAA EDI transaction processing, handling 150K+ weekly claims with automated error-driven workflows.
• Streamlined Medicaid provider enrollment, reducing the average enrollment cycle from 45 days to 18 days.
• Automated monthly capitation payments for 40+ managed care organizations, eliminating manual finance intervention.
• Built a Medicaid Data Warehouse processing 8M+ monthly encounter records for federal CMS reporting requirements.
• Developed PL/SQL-backed REST APIs that reduced eligibility verification time from 10 minutes to under 30 seconds.
• Replaced a 3-day manual reconciliation process with a 2-hour automated Python script for federal extract validation.
• Architected the integration between Oracle E-Business Suite (EBS R12) and the Medicaid Management Information System.
• Led the implementation of T-MSIS and CMS-64 regulatory reporting packages to ensure 100% on-time federal compliance.
• Designed Star Schema dimensional models with SCD Type 2 tracking for beneficiary eligibility and enrollment changes.
• Championed the deployment of Oracle APEX portals for case workers to manage beneficiary services and care coordination.
• Established Fine-Grained Auditing (FGA) policies to generate HIPAA-compliant access logs for all sensitive PHI data.
• Managed Oracle 11g/12c databases in accordance with FedRAMP and NIST 800-53 security controls for government systems.
• Conducted SQL performance tuning using TKPROF and AWR to optimize mission-critical claims adjudication modules.
• Developed automated exclusionary screening procedures against OIG and SAM databases using UTL_HTTP.
• Mentored technical staff on Medicaid fee schedule logic and complex regulatory data structures.

Jun 2013 — Jul 2017

• Technologies: Oracle 9i/10g/11g, PL/SQL, Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL*Loader, SQL*Plus, TOAD, UNIX/Linux Shell Scripting, DBMS_SCHEDULER, AWR, RMAN
• Pioneered PL/SQL stored procedures for a global SaaS suite serving over 80M+ users across multiple financial products.
• Optimized multi-currency transaction processing engines, handling 50K+ daily financial transactions with sub-second response.
• Reduced unplanned DBA escalations by 70% through the development of an automated database maintenance suite.
• Improved financial report generation speed by 60% by implementing function-based indexes and query refactoring.
• Successfully delivered 3 major product releases through the complete SDLC, from requirements to production support.
• Engineered tax calculation engines for 30+ country jurisdictions, supporting global GST and VAT compliance.
• Developed Oracle Forms 10g interfaces for core accounting workflows, enhancing data entry efficiency for end-users.
• Architected inventory management modules featuring automated FIFO/LIFO costing and reorder point calculations.
• Created high-performance SQL*Loader routines for bulk data migrations and customer onboarding workflows.
• Designed complex balance sheets and profit & loss reports using Oracle Reports and XML Publisher.
• Established proactive monitoring scripts for tablespace utilization and redo log health in a 24x7 SaaS environment.
• Defined data models for multi-tenant financial applications to ensure strict isolation and high scalability.
• Mentored new hires on PL/SQL coding best practices and unit testing methodologies using utPLSQL.
• Collaborated with product managers to translate business requirements into efficient database schemas and logic.
• Optimized multi-location stock transfer procedures to provide real-time visibility across global warehouses.

Aug 2017 — Dec 2018

Graduated 2013

Get in Touch