Phirangi Manohar

IT professional (Architect/Lead) with 12+ years of experience in Enterprise Application development (OLTP), Oracle SQL, PL/SQL, Snowflake, and UNIX shell scripting, delivering database and data-warehouse solutions across domains Banking, Finance, Telecom, Products. Strong background in end-to-end application development, performance tuning, ETL activities, and production support, committed to continuous professional development and cross-functional collaboration, consistently delivering high-quality, efficient solutions that accelerate business growth and enhance operational efficiency.

SQL Lead (Freelance) at Direct Chassis Link, Inc. (Infihive Technologies) (2025-03 – 2025-06)

Transport shipping containers optimization and reporting

• Optimized 10+ reporting queries for chassis and transaction data (80K+ records estimate) using Oracle views, cutting report runtime from 20+ minutes to under 5 minutes
• Partitioned 7 high-volume tables by transaction date and region using Oracle partitioning, improving query I/O and parallel execution by 4× estimate
• Analyzed Execution plans using Oracle SQL Developer, identifying missing indexes and join issues to stabilize daily reporting

Technical Architect (PL/SQL) at Nityo InfoTech (Infosys Client) (2024-05 – 2024-07)

Trade Execution Report for Banking and Finance

• Gathered and analysed business requirements from stakeholders to design and develop comprehensive reporting solutions incorporating trade transactions, fund details, broker information, and client data
• Delivered automated CSV/PDF reports for trade and fund data using Oracle 19c PL/SQL, reducing manual effort by 60%
• Built and tuned 5+ PL/SQL procedures using collections, bulk collect, and ref cursors, improving execution time by 40%
• Reduced report runtime from 30 minutes to 10 minutes by tuning SQL with Oracle execution plans and indexes
• Executed unit testing with 90% coverage using PL/SQL test scripts, lowering production defects by 40%

System Analyst (Oracle PL/SQL / Unix Shell Script) at Hexaware Technologies (2021-03 – 2023-05)

Portfolio Management/Liability Driven Investment (FinTech)

• Developed 2 PL/SQL packages and 9 procedures using Oracle 19c to meet Functional Requirement, loading equity and portfolio files through ETL validation
• Monitored and Analyzed the Oracle Performance with use of tools AWR, Explain Plan
• Improved SQL performance in Procedures from 15 minutes to 2 minutes by tuning queries with execution plans, hints and indexes
• Automated 10+ batch processes using Unix shell scripts, integrating Oracle procedures
• Migrated 70+ jobs from FTP to SFTP using Linux shell scripts, meeting 100% security compliance
• Scheduled and monitored 30+ production jobs using Control-M, reducing Sev-2/Sev3 incidents by 30%

Previous Responsibilities at Tech Mahindra, Accenture, Wipro, Melstar, Government of Karnataka (Water Resources) (2001-08 – 2019-11)

Multiple roles across various organizations

• Built 13+ procedures, 5 packages, 25 tables, and 5 views, 3 Materialized Views using Oracle SQL, PL/SQL, supporting enterprise applications across multiple clients
• Written 6+ SQL*Loader scripts to load the feed files received into target database tables
• Improved stored procedure response times from 11–16 minutes to 4–7 minutes through SQL tuning, indexing and Table Partitioning
• Created 4+ Unix Shell script to transfer the feed file from Landing directory to Database Directory using FTP method to Load the data through SQL Loaders and to archive the loaded files to Archive Directory
• Scheduled new 12+ Unix Jobs having PLSQL Packages/Procedures through Control M Scheduler
• Monitored 30+ production jobs using Control-M, resolving Sev-2/Sev-3 tickets within SLA and lowering defects by 30%
• Created 3 New Design Documents for New Business Requirement and added Design content information for existing application for change requirement(s)
• Maintained MIS Section with Server and Client Node Infrastructure with Networking to maintain MIS application (Water Resources)
• Generated the MIS Reports and Submitted to Management for Analysis (Water Resources)

Professional Sabbatical at Self-Directed Learning (2019-12 – 2021-02)

Upskilling and professional development

• Upskilled in advanced Oracle PL/SQL, AWS using hands-on labs and self-practice, preparing for enterprise banking systems

Professional Sabbatical at Self-Directed Learning (2024-07 – 2025-02)

Upskilling and professional development

• Upskilled in Snowflake, AWS cloud related technologies using hands-on labs and self-practice, preparing for implementing enterprise systems
• Participated in Excel 360 Program for communication foundation programme

Professional Sabbatical at Self-Directed Learning (2025-10 – Present)

Upskilling and professional development

• Upskilled in DevOps, AWS cloud related technologies using hands-on labs and self-practice, preparing for implementing enterprise systems

Master of Computer Applications in Computer Applications – Karnataka University, Dharwad, India (1992-02 – 1996-12)

Bachelor of Science in Electronics – Veerashaiva College, Bellary (Gulbarga University), Bellary, India (1988-06 – 1991-08)