Maria Francis A
Cuddalore
Summary
Detail-oriented and performance-driven PL/SQL Developer with over 4 years of experience across diverse domains, including logistics, finance, banking, and credit reporting systems. Proven expertise in designing and optimizing complex database solutions using Oracle PL/SQL, ensuring data integrity, performance, and scalability.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Dispute Process - Expert (PLSQL)
MAERSK GLOBAL SERVICE CENTRES (INDIA) PRIVATE LIMITED
Chennai
08.2023 - 03.2025
- Enhance and streamline PL/SQL packages, stored procedures, functions, triggers for managing free time calculations, customs status logic, appointment validations, and container gate movements.
- Enhance the efficiency of batch processing for container data regarding disputes and delays by leveraging CURSORS, alongside BULK COLLECT and FORALL functionalities.
- Implemented performance tuning strategies by optimizing queries and indexes, or suggesting improvements through analysis of execution plans as needed.
- Developed views and materialized views to monitor open, resolved, and pending disputes across terminals, customers, and container numbers, enhancing visibility for operations and finance teams, ensuring optimal performance.
- Scheduled automated batch jobs using DBMS_SCHEDULER to revalidate unresolved disputes daily, and trigger reminders, or escalations based on aging criteria.
- Instituted effective exception handling and logging protocols to identify errors and uphold data integrity during bulk operations.
- Enhanced notification system to automate alerts for customers, stakeholders, and internal teams when dispute statuses change.
- Automated container appointment and demurrage processes using advanced PL/SQL procedures, and bulk optimization.
- Collaborated with business analysts, QA teams, and stakeholders to understand requirements, deliver solutions, and support the testing of container dispute handling logic, ensuring alignment on project goals and deliverables.
Interpreter
Teleperformance Global Services Private Limited
Gurugram
04.2023 - 07.2023
- Client: Language Line Solutions.
- Understood and documented telecom billing processes, workflows, and database structures.
- Applied interpreter-like skills to act as a bridge between business logic and PL/SQL implementations, ensuring accurate translation of workflows, charge validation, and billing into automated database processes.
- I shadowed senior developers to understand backend procedures used in billing validation and customer plan mapping.
Rep01
Transunion Global Technology Center LLP
Chennai
10.2021 - 07.2022
- Developed and maintained PL/SQL procedures, functions, and packages for processing consumer credit data from external lenders and banks.
- Implemented logic to handle credit disputes, including automated status updates, data corrections, and logging workflows.
- Established validation routines with REGEXP_LIKE, CHECK, and data integrity constraints to guarantee accuracy of SSNs, credit limits, and account types.
- Optimized performance of large ETL operations using BULK COLLECT, FORALL, and indexed joins for high-volume datasets.
- Maintain detailed audit logs capturing user actions, data changes, and timestamped events, using custom logging procedures.
- Optimized complex SQL queries and developed PL/SQL packages for generating credit reports monthly, quarterly, and created comprehensive test cases to validate PL/SQL code accuracy in credit scoring logic.
Officer
Equitas Small Finance Bank Pvt Ltd
Chennai
11.2019 - 03.2022
- Write and maintain complex stored procedures, functions, triggers, packages, and views. Developed loan eligibility calculators, interest computation scripts, and repayment schedules.
- Refine SQL queries to elevate performance, especially regarding large loan datasets, and supervise management of customer loan data (EMIs, disbursement, foreclosure, overdue tracking).
- Diagnose slow-running queries, optimizing performance through EXPLAIN PLAN, indexing, and bulk operations.
- Design and schedule financial reports (loan aging, EMI due, NPA reports). Generate monthly portfolio reports for management and audit teams.
- Create and normalize loan-related tables (Customer, Loan Account, EMI Payment, Interest Rate). Apply constraints, indexes, and partitions for performance and integrity.
- Automate daily tasks using DBMS_SCHEDULER (e.g., auto-debit jobs, interest updates), and trigger alerts based on business requirements.
- Assist QA/Testing teams in writing test cases for loan modules.
Education
B.E - EEE
Krishnasamy College of Engineering And Technology
01-2013
Skills
- Databases: Oracle RDBMS 12c, 19c
- Development Tools: SQL Developer, PL/SQL Developer, SQL Server
- Ticketing Tool: JIRA
- Other Tools: Putty, ServiceNow, GitHub
- Technical Skills: SQL, PL/SQL, Linux, UNIX, Unix Shell Scripting, SQL*Plus commands
Affiliations
Container Management System
This project is a database system for managing logistics operations, including customer details, container tracking, terminal operations, currency management, and error logging
It also includes a PL/SQL package for calculating detention charges, converting currency, and a notification system for overdue containers.
LINK: https://github.com/Francis45-max/cms
Certification
- Successfully completed Lean Six Sigma Black Belt course, Skillsoft, March 2024
- Successfully completed the course in Managing Stakeholder Engagement - PMBOK
- Extra Mile Award: Recognized for delivering key automation features under tight deadlines, significantly improving container tracking and charge calculations during operational disruptions.
Languages
Tamil
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Custom
- https://github.com/Francis45-max/cms
Timeline
Dispute Process - Expert (PLSQL)
MAERSK GLOBAL SERVICE CENTRES (INDIA) PRIVATE LIMITED
08.2023 - 03.2025
Interpreter
Teleperformance Global Services Private Limited
04.2023 - 07.2023
Rep01
Transunion Global Technology Center LLP
10.2021 - 07.2022
Officer
Equitas Small Finance Bank Pvt Ltd
11.2019 - 03.2022
B.E - EEE
Krishnasamy College of Engineering And Technology
Similar Profiles
Harshad KalledHarshad Kalled
Transition Manager at MAERSK GLOBAL SERVICE CENTRES INDIA PRIVATE LIMITEDTransition Manager at MAERSK GLOBAL SERVICE CENTRES INDIA PRIVATE LIMITED
Surya GururajanSurya Gururajan
R2R Accountant at Maersk Global Service Centres India Private LimitedR2R Accountant at Maersk Global Service Centres India Private Limited
BARANI DASBARANI DAS
Customer Service Executive at Maersk Global Service Centres(India) Private LimitedCustomer Service Executive at Maersk Global Service Centres(India) Private Limited