Saikat B.

Saikat B.

Expert Oracle Developer

Kolkata , India

Experience: 14 Years

Saikat

Kolkata , India

Expert Oracle Developer

USD / Year

  • Start Date / Notice Period end date:

14 Years

Now you can Instantly Chat with Saikat!

About Me

Expertise in Oracle SQL, PL/SQL, D2K, Forms 6i, Forms 10g and Reports.

Expertise in Database Procedures, Functions, Packages, Triggers, Collections and Performance tuning using CBO (Cost Based Optimization).

Knowledge of HTML, Boot...

Knowledge of HTML, Bootstrap, CSS, JavaScript, JQuery, Ajax, PHP & MySQL.

Show More

Portfolio Projects

Description

Involving in feasibility study with various departments, analyzing all the process and designing database structures, creation of various database objects, query optimizing, development of forms & reports, testing, implementing and maintaining the application.

Show More Show Less

Description

Developed form modules by capturing Labour cost, Plant & Machinery cost and Overhead cost for making manufacturing items in Crusher, Bricks, Batching Plant unit and GRN of manufacturing items.

Show More Show Less

Description

This module includes financial activities from bank or financial institute. In Finance module, financial activities like bank guarantee, various types of loan, loan disbursement, schedule for loan, repayment for loan. It also includes Inter Corporate Deposits, Letter of Credit. Besides creating the forms for the modules, various types of reports are created such as financial statement ( profit & loss, balance sheet, cash flow, detailed trail ), audit, costing, tax, supplier related.

Show More Show Less

Description

Developed forms modules for Employee Master, Outsourced Master, Employee/Outsourced Activation or Deactivation, Employee Transfer Order, Employee NOC, Employee Joining, Leave Application, OD Application, Employee Shift Schedule, Contract wise Shift Schedule, Attendance, Attendance Adjustment, Salary Preparation and mediclaim modules like Insurance Coverage Limit For Employees, Mediclaim Declaration, Medical Insurance Details, Employee Mediclaim Reimbursement, Employee Mediclaim Information Details, Invoice For Insurance Premium And Insurance Claim and developed associated reports like Daily Attendance Report, Employee Nopay Report, Periodic Attendance, Employee Late Attendance Report, Report On Non-Attendance / No Leave / No OD Application, List of Claimants, List of Claimant Those Who Have Not Received Claimed Amount, List of Claimant Those Who Have Received Claimed Amount, List of Claimant Whose Claims Are Rejected.

Show More Show Less

Description

Developed forms modules for Daily Labour Invoice, Departmental Labour Invoice, PRW Labour Invoice, Item Supplier Invoice, Transporter Invoice, Service Provider Invoice, Sub-Contractor Advance Payment Invoice and Cash Invoice and different types of supplier payment modules against these invoices through and developed associated reports like Supplier Ledger, Supplier Payment Position, Supplier's Outstanding Amount, Spplier's Liability etc. on accounts payble. Developed Forms for receivable modules Customer Receipt Invoice, Customer Miscellaneous Receipt Invoice and developed reports Consolidated Customer Ledger and Details Customer Ledger.

Show More Show Less

Description

Developed forms for Charts of Accounts Master, Goods Inspection Note, Goods Receipt Note, Goods Issue Note, Issue Return Note, Customer Goods Requisition Note, Customer Goods Issue Note, Customer Goods Inspection Note, Requisition of Items for in Contract, Stock Transfer Note (In/Out), Stock Return Note, Material Return to Vendors, Stock Shortage Note, Return Shortage Note in FIFO method and developed associated reports on inventory i.e. Store Wise Stock Ledger report, Stock Valuation report, Material Receipt and Issue report.

Show More Show Less

Description

Developed forms for master modules Zone, Site, Contract, Contract Location, Supplier, Supplier Site, Supplier State, Supplier Address, Item Specification Master and Item Master.

Developed forms for purchase modules Indent, Request for Quotation, Quotation, Purchase Order, Amendment Purchase Order and developed associated reports on purchase modules.

Show More Show Less

Description

Developed forms for Material Planning, Daily Labour Planning, Departmental Labour Planning, PRW Labour Planning, Owned Plant & Machinery Planning, Hired Plant & Machinery Planning and Project Planning by considering WBS elements and developed associated reports for different planning modules by understanding the complex business logic.

Show More Show Less

Description

Database Design and Software Development

Show More Show Less