Neha Mandake

About Neha Mandake

Oracle PL/SQL Developer with 3.8 years of experience in the finance domain, specializing in database development, SQL optimization, and performance tuning for large transactional datasets. Skilled in PL/SQL packages, procedures, functions, ETL, and financial data modeling with strong focus on data accuracy, reporting, and compliance. Experienced across the full SDLC in Agile/Scrum environments delivering scalable financial solutions.

Experience

1. Pl Sql Developer

   Tata Consultancy Services

   Jan 2022 — Present

   Designed and optimized high-availability Oracle 11g/12c database systems supporting business-critical financial applications.•Developed complex PL/SQL packages, procedures, functions, triggers, and scheduler jobs, improving transaction reliability and scalability.•Optimized query execution and indexing strategies, reducing processing time by 40% using B-tree/bitmap indexes, EXPLAIN PLAN, SQL Trace, and TKPROF.•Built bulk data processing solutions (BULK COLLECT, FORALL, Ref Cursors, Collections) to efficiently handle millions of records.•Implemented robust exception handling and logging frameworks, reducing production errors and speeding up issue resolution.•Collaborated with front-end and analytics teams to provide data insights, stored procedures, and schema designs for accurate reporting and dashboards.•Managed LOBs (BLOBs/CLOBs) for document/image-centric financial modules, ensuring compliance and data integrity.•Authored technical documentation and deployment guides, validated database objects post-deployment, and supported seamless production releases.•Utilized Git/GitHub for version control and Jenkins for CI/CD, enabling efficient code management and automated deployments.•Actively engaged in Agile/Scrum ceremonies (planning, backlog grooming, stand-ups, retros), ensuring timely delivery of business features.

Education

• SVPM's College Of Engineering

  Bachelor of Engineering