Shams Ahmad

Seasoned Oracle Developer with 15 years of expertise in Oracle Forms & Reports, PL/SQL programming, and Database management. Skilled in designing and optimising enterprise-level applications across diverse industries such as real estate, healthcare, transportation and manufacturing. Adept at data modelling, automation, troubleshooting in multi-platform environments and maintaining Project documentation.

Senior Oracle Developer at Accord Innovations Bhd Sdn. (Client: Allianz Technology Malaysia Berhad) (2025-11 – Present)

• Developing and maintaining custom Oracle applications supporting Insurance business operations.
• Designing and enhancing Oracle Forms, Reports, PL/SQL packages, procedures and triggers.
• Supporting application development, deployments & troubleshooting across DEV, UAT, and Production environments.
• Optimizing SQL and PL/SQL performance, reducing processing times and improving system efficiency.
• Executing data migration and data correction activities while maintaining data integrity.
• Collaborating with business users, analysts, and infrastructure teams to deliver system enhancements.
• Providing production support and incident resolution for critical business applications.

Senior Oracle Developer at Naptico Services Pt. Ltd. (Client: Covius Solutions, USA) (2022-03 – 2025-03)

• Enhanced and maintained Vault Link File Management System for residential mortgage banking.
• Designed, developed and optimised Oracle Database objects including Tables, Views, Indexes, Procedures, Functions and Triggers.
• Developed advanced PL/SQL Packages & Programs incorporating Pragmas, dynamic SQL, Ref. Cursors, Bulk collect, Collections and Records.
• Conducted application performance tuning and implemented business features.
• Created complex stored procedures, functions, triggers, and libraries for Oracle 12c systems.
• Improved application performance through QA and UAT feedback integration.
• Executed development, modifications, testing and release of oracle Forms & Reports.

Senior Oracle Developer at Business Communications & Management Services W.L.L. (2021-05 – 2022-01)

• Managed & administered remote CRM.
• Handled back office services of the Forex trading platform (Meta Trader 5) based on Oracle db. for the offshore client.

Senior Oracle Consultant at Macro Software Systems LLC (Client: Royal Court of Affairs, Oman) (2010-11 – 2020-12)

Managed a centralized system for 6000+ Royal Transport vehicles, automating key transportation processes.

• Developed an online authorization module with digital signatures for approvals.
• Automated insurance request emails and salary deductions for traffic fines.
• Created MIS reports and Application user functions tracking features to enhance decision-making and audit trails.

Senior Oracle Developer at Hepta Solutions Pt. Ltd (Client: Vivekananda Hospital, Lucknow) (2008-06 – 2010-07)

• Upgraded Oracle Forms 6i to 10g for web compatibility, improving system accessibility and security.
• Automated report status tracking with user-based permissions for PDF downloads and views.

Oracle Programmer at BBC Paints & Solvents Co. Ltd. (2006-01 – 2008-04)

• Automated goods receipt processes, integrating quality checks and inventory updates.
• Implemented real-time reporting for goods received, rejections, and discrepancies.
• Developing & maintaining Database objects: Triggers, Procedures and Functions, Normalization of tables, creation of Forms & Reports with numerous validation and checks.

Oracle Programmer at AlBeeah Planners, Architects & Engineers (2001-05 – 2005-04)

• Streamlined HR processes for attendance, payroll, and work permit renewals.
• Automated reporting for employee compensation and vacation eligibility.

MBA in I.T. and Management – AIMA-CME, New Delhi

B.Sc. in Computer Science – Lucknow University