Muni Krishna

Oracle PL/SQL Developer with over 6+ years of experience in application development, specializing in SQL, PL/SQL, and Data Warehousing solutions. Possesses strong expertise in designing and developing robust database objects, including stored procedures, functions, packages, triggers, views, indexes, sequences, and synonyms, to support complex business requirements. Demonstrates solid proficiency in performance tuning and query optimization using execution plans, indexing strategies, and advanced PL/SQL techniques such as Bulk Collect and FORALL to efficiently handle large volumes of data.

Experienced in end-to-end ETL processes, including data extraction, transformation, and loading using SQL*Loader and PL/SQL, ensuring data accuracy and integrity across systems. Strong understanding of database design principles, data modeling, normalization, and constraint management, enabling the development of scalable and efficient database architectures. Adept at troubleshooting, debugging, and resolving issues with a proven ability to meet deadlines and improve system performance.

Comfortable working in Agile/Scrum environments, collaborating with cross-functional teams, and participating in code reviews, sprint planning, and continuous improvement initiatives. A quick learner with strong analytical and problem-solving skills, capable of adapting to new technologies and delivering high-quality back-end solutions in dynamic and fast-paced environments.

PL/SQL Developer at Exner technologies pvt Ltd (2024-02 – Present)

PCMH (Patient-Centered Medical Home) is a healthcare program by Care-First designed to improve patient care quality while reducing healthcare costs by incentivizing Primary Care Physicians (PCP's). The system manages patient and provider data, supports care coordination, ensures compliance with healthcare regulations, and processes high-volume transaction data across healthcare and claims systems.

• Developed complex SQL queries and PL/SQL procedures and functions based on business requirements
• Performed monthly data load processes and validations to ensure data accuracy and consistency
• Designed and maintained database objects including packages, procedures, functions, tables, and partitions
• Automated batch and data load processes using UNIX shell scripting, SQL*Loader, UTL files, and import utilities
• Implemented data validation and transformation logic to support financial data processing
• Monitored and managed batch jobs and data workflows, ensuring timely execution
• Troubleshot database and performance issues in development and testing environments
• Optimized SQL queries and PL/SQL code for better performance and efficiency
• Ensured data integrity, accuracy, and compliance with business and financial requirements

Sr PLSQL Developer at Exner Technologies Pvt Ltd (2022-01 – 2024-01)

FINNONE is a web-based enterprise lending and financial operations platform widely used by banks and financial institutions to manage assets, liabilities, core finance, accounting, loan servicing, and customer operations. The application consists of multiple modules such as CAS, LMS, GL, DD, GLD, and Collections. It enables seamless financial processing through automated workflows, validations, and multi-product integrations, ensuring accurate and compliant financial transactions.

• Developed complex SQL queries and PL/SQL procedures and functions based on business requirements
• Performed monthly data load processes and validations to ensure data accuracy and consistency
• Designed and maintained database objects including packages, procedures, functions, tables, and partitions
• Automated batch and data load processes using UNIX shell scripting, SQL*Loader, UTL files, and import utilities
• Implemented data validation and transformation logic to support financial data processing
• Monitored and managed batch jobs and data workflows, ensuring timely execution
• Troubleshot database and performance issues in development and testing environments
• Optimized SQL queries and PL/SQL code for better performance and efficiency
• Ensured data integrity, accuracy, and compliance with business and financial requirements

PL/SQL Developer at Exner Technologies Pvt Ltd (2021-01 – 2022-01)

The project involved developing and supporting banking applications handling high-volume financial data. The system ensured secure, reliable, and efficient processing of transactions while maintaining data integrity and performance.

• Developed and maintained PL/SQL objects such as Procedures, Functions, Packages, and Triggers
• Created indexes and optimized queries, improving performance by 30%
• Wrote complex SQL queries using joins, subqueries, and database links
• Designed reusable PL/SQL components for business logic implementation
• Monitored and managed batch jobs and analyzed logs
• Used database links for cross-database data retrieval
• Handled issues, debugging and resolving defects
• Created JIRA tickets and coordinated with teams for issue resolution
• Provided user support and system enhancements

PL/SQL Developer at Exner Technologies Pvt Ltd (2020-01 – 2021-01)

Hudson's Bay Company (HBC) is a large retail organization operating across Canada and the United States. The project involved building and supporting a data warehouse system to manage retail data, enabling efficient reporting, analytics, and business decision-making. The system processes large volumes of data through ETL pipelines and ensures data accuracy, consistency, and performance.

• Developed PL/SQL database objects such as Procedures, Functions, Packages, and Triggers
• Created and maintained tables, views, indexes, sequences, and constraints
• Designed and implemented ETL processes for data extraction, transformation, and loading
• Loaded data using SQL*Loader from flat files into Oracle database
• Used Bulk Collect and FORALL to improve performance and reduce context switching
• Performed query optimization using Explain Plan, Auto Trace, and optimizer hints
• Reduced batch job execution time by 40% through performance tuning
• Implemented exception handling for error tracking and debugging

B-TECH – JNTU ANANTAPUR (MJR COLLEGE - PILER) (2013-06 – 2017-05)