Skip to content

Krishna Srinivas Mugi

Oracle PL/SQL Developer • Visakhapatnam, India • m******************@gmail.com • +91*******255

Professional Summary

Focused Oracle PL/SQL developer with hands-on experience designing stored procedures, functions, triggers and performance tuning in Oracle 11g/12c/19c. Transitioned from high-volume operations into database development through a technical internship; skilled at building backend logic, implementing audit trails, and optimizing queries using EXPLAIN PLAN, Bulk Collect and FORALL. Strong attention to data integrity, regulatory compliance and reproducible code; seeking a PL/SQL/Database Developer role where I can apply backend development and tuning skills to deliver reliable, high-throughput data solutions.

Technical Skills

Databases: Oracle 11g,Oracle 12c,Oracle 19c,Materialized Views,Indexes B-Tree, Bitmap,SQL,Stored Procedures,Functions,Packages,Triggers,Collections Nested Tables,Collections Associative Arrays,Ref Cursors,Bulk Collect,FORALL,Exception Handling
Data and Analytics: Data Modeling Normalization,Tables,Views,DDL,DML,TCL
Tools and Methodologies: SQL Developer IDE,Audit & Compliance Logging,Reporting & Dashboarding,Code Reviews,Unit Testing Collaboration
Skills: PL,Joins,Subqueries
Performance & Tuning: Query Tuning,EXPLAIN PLAN,Cost Based Optimizer,Execution Plan Analysis

Work Experience

Conduent Business Services
Visakhapatnam, India
Transaction Processing Associate
Feb 2022 – Feb 2025
Tech Stack: Internal Claims Processing Systems, Internal Dashboards, Reporting Systems, Audit Documentation
  • Processed high-volume claims and policy data through internal claims systems, maintaining strict turnaround times and attention to data accuracy to support downstream reporting and reconciliation.
  • Validated and verified claim forms and supporting documents to ensure compliance with policy terms, reducing rework and improving first-pass acceptance of claim records.
  • Adhered to HIPAA and regulatory requirements when handling sensitive health and financial information, implementing secure handling and tracking practices for audit readiness.
  • Monitored aged and complex claims, escalating issues and coordinating cross-functional analysis to resolve exceptions and preserve data integrity in internal dashboards.
  • Identified recurring error trends in claim processing and recommended process improvements and checklist updates to reduce repeat issues and improve operational consistency.
  • Delivered training and onboarding for new associates on claim entry procedures, policy verification and internal system navigation to accelerate team productivity and quality.
Chetan Technologies
Visakhapatnam, India
PL/SQL Developer Intern
2024 – 2025
Tech Stack: Oracle 11g, 12c, 19c, PL, SQL, SQL Developer, EXPLAIN PLAN, Materialized Views, Indexes
  • Developed and deployed PL/SQL stored procedures, functions and triggers to implement backend business logic for transaction workflows, improving transaction processing consistency and maintainability.
  • Optimized complex queries and routines using EXPLAIN PLAN and execution plan analysis; applied Bulk Collect and FORALL to reduce context switches and improve batch processing throughput.
  • Designed reusable PL/SQL packages and participated in code reviews to enforce coding standards, modularization and reduce duplicated logic across transaction modules.
  • Implemented audit trails and compliance logging within database layers to ensure traceability of transaction state changes and to support regulatory reporting requirements.
  • Collaborated with QA to create test cases and validate data integrity across transaction scenarios, identifying and resolving edge-case exceptions prior to release.
  • Built reporting scripts and SQL-based reports to surface country-wise transaction volumes, exchange rates and profitability metrics for stakeholders.

Projects

Overseas Transaction & Currency Exchange System
Tools Used: PL, SQL, Stored Procedures, Triggers, Audit Logging, Query Optimization, Reporting
  • Designed PL/SQL procedures and functions to manage international money transfer workflows, update transaction statuses and maintain stage flags for end-to-end traceability.
  • Implemented cash payment handling logic for unbanked customers within the database layer, enabling inclusive transaction processing without compromising auditability.
  • Built comprehensive audit trails and compliance logs to record transactional events, user actions and state transitions for regulatory and reconciliation needs.
  • Created SQL-based reports for country-wise transaction volumes, exchange rates and profit margins to support business decision-making and partner settlements.
  • Developed revenue-sharing modules to calculate and record franchise partner commissions, integrating logic into stored procedures for consistent accounting.

Education

Welfare Institute of Science Technology & Management
Bachelor of Technology – Mechanical Engineering • Visakhapatnam, India • Dec 2022
Mrs. A.V.N. College
Diploma in Mechanical Engineering • Visakhapatnam, India • Oct 2017

Powered by Drivetube · Create your own profile at drivetube.ai