Arabic Royal

SENTHILKUMAR SUNDARAM

Post Box No: ***, Postal Code: 112, Mobile: +968-********

Ruwi - Muscat, Sultanate of Oman **************@*****.***

Profile Summary

** ***** ** ** ********** in Analysis, Design, Development, Customization, Implementation and Deployment using Oracle Forms10g/Reports10g and Forms12C/Reports12C Technologies.

Strong DB fundamentals, Data Modeling techniques and experts in developing, debugging PL/SQL Procedures in Oracle.

Good exposure in Contract Management Systems and Supply chain management Systems.

Education Details

Master of Computer Application (MCA) Bharathidasan University, Tamil Nadu,

India (2000-2003)

Bachelor of Science (Physics) Bharathidasan University, Tamil Nadu,

India (1997-2000)

Professional Experience

Working as Senior Software Engineer with Computer 2000 LLC, Muscat, since Aug 2009.

Worked as Software Engineer with United Systems, Muscat from Feb 2007 To Dec 2008.

Worked as Software Engineer with Accel Front line Ltd from Oct 2005 To Jan 2007.

Worked as Programmer with Cerebrum Software From Nov 2003 To Sep 2005.

Technical Expertise

Software : Oracle Forms12c,Oracle Forms10g, Forms6i, Visual Basic 6.0

Technologies : Oracle11g, Client Server.

Operating Systems : Windows 98/Win7/Win8/Win10.

Tools :TOAD, PLSQL Developer, MS-Visual Studio,

Databases : Oracle 8i/9i/10g/11g and MS-SQL Server 2000/2008.

Report : Discoverer, Oracle Reports12C, Oracle Reports10g,Oracle Reports6i

Industries Supply Systems, Contract Management system Manufacturing and HRMS.

1. Royal Court Affairs (DG Supply) - Sultanate of Oman. From Aug 2019 to Till Date

DG Common Supply Systems

Team Size: 2

Environment: Oracle 11g, PL/SQL, Oracle Forms12c/Oracle Reports12c

Description : The Supplies System will cover Stores, Purchases, and Commitment monitoring System. The System supports with English/Arabic User Interfaces. The Store Management System consists of Store Issues & Receipts, Stores Demand, Material Indent, SIV, SRV, Stores Dispatch Note, Cash Purchase Log, Loan Items, Stock Take, Goods Receipt Note, Goods Return Note, Supplier Delivery Note and Invoices. The Purchase Management System consists of Purchase Requisition, Quotation/Tender Processing, Local Purchase Order, Overseas Purchase Order, Cargo Clearance, Contracts and Insurance’s. The Commitment Monitoring System consists of Approved Budget, Budget Revision, Budget Transfer, Cost Center Allocation to Purchase Commitments, & Other Commitments.

Project is to consolidate the 3 Databases, located on different place into one single database (Muscat, Salalah & Royal Yatch).

Conversion of Application from Oracle 10g converted to Oracle 12c.

Sending LPO's electronically to DG of Finance for Commitment

Enhancement to Tender Module like Calling of single Tender for multiple directorates, Tender Invitation, Tender Allocation, Tender regret letters, Tender Extensions, Re-tender through E-mails

Linking of Supplies Insurance module with Transport Insurance module.

Design & development of new process like alternative items in LPO cycle.

Integration of Supplies System with Asset management system

Changes done to the application to generate MIS to find out average time taken in processing a requisition in every stage like Quotation, Order & Finance commitment.

Sending of Quotation online using Emails

Intermediate process is included to correct the items, units and quantities, before printing the LPO.

Enhancement to Stores module to suit Convoy / Palace Stores.

Sending LPO’s electronically to HE finance for Commitment

Sending RYS LPO’s electronically to finance for Commitment

SMS to Mobile like (Orders/Quotation/Tender invitation/Contracts etc.)

Roles & Responsibilities:

Direct Interaction with the client to discuss enhancement in the project and provide the estimation for the task. Also owned end to end delivery of the new changes by handling the team.

Data Correction

Coding and Front End designing and developed Forms & Reports.

Generating Reports in Excel Format.

2. Royal Court Affairs (Royal Opera House) - Sultanate of Oman. From Aug 2019 to Till Date

Gate Pass Systems

Team Size: 1

Environment: Oracle 11g, PL/SQL, Oracle Forms12c/Oracle Reports12c

Description : Royal Opera House Muscat is the leading arts and culture organization in the Sultanate of Oman. The vision of the Opera House is to serve as a Centre of excellence in global cultural engagement through artistic, cultural, and educational programs.

The multidisciplinary work of Royal Opera House Muscat showcases of rich and diverse artistic creations from Oman, the region, and the world. It provides a space for culture and socioeconomic development reflections and actions inspires audiences and nurtures creativity with innovative programs.

The royal opera house security department issues 6 different card types based on the locations such as (Main hall, Private hall, Administration, Main&Admin, Main&Priv and Admin&Priv) from the system. The photograph images are captured using the canon digital camera or by scanning a photograph automatically and stored in the system. The system helps them in issuing ID cards by printing using Fargo HDP 5000 Printer. The system supported with Arabic Interfaces

Roles & Responsibilities:

Direct Interaction with the client to discuss enhancement in the project and provide the estimation for the task. Also owned end to end delivery of the new changes by handling the team.

Data Correction

Coding and Front End designing and developed Forms & Reports.

Generating Reports in Excel Format.

3. Royal Court Affairs (Royal Estate) - Sultanate of Oman. From Aug 2010 to Till Date

CMS-Contract Management Systems

Team Size: 1

Environment: Oracle 11g, PL/SQL, Oracle Forms10g/Oracle Reports10g

Description: 1

Contracts Management System

This system is used by Directorate General Of Projects & Maintenance of Royal Court Affairs Ministry Oman, automates the process of project maintenance which involves User Request, Budget proposal, Budget Approval, Appropriation,Tendering,Commitment and Payment. Audit controls are implemented in order to maintain data consistency.

Description: 2

Financial Expenditure Module

Multi-currency financial system used by Expenditure department of Royal Court Affairs Oman. This involves budget appropriation, financial commitments, invoice processing, Payment under different modes, Maintain Bank Cash Flow Statements, project and supplier analysis.

Roles & Responsibilities:

Direct Interaction with the client to discuss enhancement in the project and provide the estimation for the task. Also owned end to end delivery of the new changes by handling the team.

Data Correction

Coding and Front End designing and developed Forms & Reports.

Generating Reports in Excel Format.

4. Ministry of Higher Education- Sultanate of Oman From February 2010 to July 2010

GSS- Graduate Survey System

Team Size: 4

Environment: Oracle 10g, PL/SQL, Apache, PHP,QTAFI

Description:

Graduates Survey is valuable single instrument for collecting systematic and reliable information on the link between study, subsequent employment and work.

This survey provides information about the whereabouts of graduates at some point in time after the award of the degree, linking this data with a few socio-biographical and study descriptors, such as gender, age, field of study, and institution attended.

Roles & Responsibilities:

Done Database Design, Procedures, Functions

Done the impact analysis and prepared Technical specification.

Review of report, interface and Extension functional design requirements.

5. Royal Court Affairs- Sultanate of Oman. From August 2009 to January 2010

SSM-Supply System Management (Royal Yacht)

Team Size: 2

Environment: Oracle 10g, PL/SQL, Oracle Forms10g/Oracle Reports10g.

Description:

The system handles the complete supply chain management. Developed for the Royal Yatch Squadron. System has multi level access for different users depending on their position in the hierarchy of the institution. This system is classified into different modules as Demand, Distribution, Procurement, Receipts, Stock Take and Loan.

The system provides provisioning for order and automatic order creation depending on demand and supply statistics. This system provides many facilities for stock take. The system generates a number of reports and statistics for analysis at different level of users.

Roles & Responsibilities:

Involved in Application Development and code review.

Supported in project Implementation and provide training to end users.

Interaction with clients for further enhancements.

6. Ministry Of Defence- Sultanate of Oman. From February 2007 to December 2008

ISS-Interim Supply System-Royal Air Force

Team Size: 4

Environment: Oracle Database9i, Oracle Forms10g / Reports10g. Oracle Forms5/Reports3

Description:

The system handles the complete supply chain. Developed for the Ministry of Defense. System has multi level access for different users depending on their position in the hierarchy of the institution. This system is classified into different modules as Demand, Distribution, Procurement, Receipts, Stock Take, Earmark and Loan.

The system provides provisioning for order and automatic order creation depending on demand and supply statistics. This system provides many facilities for stock take and earmark. The earmark module provides all the supply details for the war period. System also provides market research for efficient ordering process. The system generates a number of reports and statistics for analysis at different level of users.

Roles & Responsibilities:

Involved in application migration Oracle forms5 to Oracle Forms10g

Generating Data Reports.

Involved Oracle Application server configuration.

Bug fixing, Data Correction.

7. JRD International Dubai. From October 2005 To October 2006

MMS-Material Management system

Team Size: 11

Environment: Oracle 10g, PL/SQL, Oracle Forms10g/Oracle Reports10g.

Description:

It handles Item master definition, item Grouping, Opening Stock definition, Cycle count definition, cycle count calendar process, Goods Inward, Goods inward Inspection, Item Lot details, Material Return note, Stores Request and Issue and Material Transfer between stores. It also has various reports viz. Stock Statement, Stock Ledger Location wise stock details.

The Purchase module has Vendor Master, Vendor item relation, Vendor Rate list, Enquiry, Quotation, Purchase Order, Purchase Order amendment. It generates reports like Purchase Order, Pending PO details, Comparative statement and etc.

The maintenance module has Grouping of Machines, Machine master, Maintenance Types, Work instruction and Check list for Maintenances, Maintenance calendar, Maintenance Schedule and its transactions, Machine Breakdown logging and its transaction. It has reports of Maintenance schedule, Machine idle hours, Machine Break down analysis and etc.

Roles & Responsibilities:

Actively participated with the team discussion in project design.

Developed the Application.

Preparation of test cases and done the unit testing.

Generating Data Reports and provide user support.

8. MVM Tool Makers. From November 2004 to September 2005

MVM

Team Size: 20

Environment: Visual Basic 6.0, SQL Server2000 and Crystal Reports 8.5.

Description:

This package helps Cold storage Company to maintain information about their regular customers and their products. The operations such as purchase, sales, stock maintenance, billing, invoicing and generation of periodic reports were computerized. It maintains two types of sales – Credit sales for regular customers and Cash sales for others.

Roles & Responsibilities:

Actively participated with the team discussion in project design.

Developed the Application.

Preparation of test cases and done the unit testing.

Generating Data Reports and provide user support.

I hereby declare that the above written particulars are best of my knowledge and belief

Date:

Place: (S. Senthil kumar)

Contact this candidate