senthil kumar

SENTHILKUMAR SUNDARAM

Post Box No: 721, Postal Code: 112,                                         Mobile: +968 99034897

Ruwi - Muscat, Sultanate of Oman                                            

Profile Summary

• 18 Years of IT Experience 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.

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

Date: ………………..

Place: ………………..                                                                         (S. Senthil kumar)

Profile Summary

• 18 Years of IT Experience 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)