Experience

United Millers Limited

• Kisumu, Kenya

• IT Manager - Oracle

  • Feb 2020 - Present



Convergence Consultants

• Chennai Area, India

• Oracle Applications Technical Consultant

  • Jul 2015 - Jan 2020

  Oracle Apps Technical Responsibilities: • Involved in development of reports based on business requirements and registered them in Oracle applications • Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures and Packages • Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables • Involved in sysadmin activities and clearing monthly pending transactions Conversions: • Developed Customer Conversion to load historical data into Oracle base tables • Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables Interfaces: • Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report • Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package Reports: • Purchase Report Detailed Item wise allows you to have a detail study of purchases made during a given period using XML publisher • Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details • Developed Supplier Payments Report using XML Publisher Forms: • Customized Sales Order Form • Customized the sales Order Form using Personalization. It should not raise sales order on weekends or public holidays • Customized PO Form using Personalization. Whenever user enters data on Sunday, form should exit.



PMR Engineering College

• Chennai Area, India

• Assistant Professor

  • Jun 2010 - May 2015

  • Assisted Professors in daily academic activities • Prepared and revised lesson plans. • Provided assistance to students during laboratory experiments • Analyzed student requirements and provided support as per requirement • Creating individualized plans and programs to facilitate a targeted, personalized approach to education while stimulating student’s enjoyment and appreciation for the subject • Assisted students in completing projects and career development • Assisted Professors in daily academic activities • Prepared and revised lesson plans. • Provided assistance to students during laboratory experiments • Analyzed student requirements and provided support as per requirement • Creating individualized plans and programs to facilitate a targeted, personalized approach to education while stimulating student’s enjoyment and appreciation for the subject • Assisted students in completing projects and career development



CIG SOFT TECH INDIA PVT LTD

• Chennai Area, India

• Oracle Applications Developer

  • Jul 2007 - Jan 2010

  Developer responsibilities • Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR and GL. • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information. • Closely worked with users to understand business needs and objectives. Interfaces: • Developed validation packages to Load data to interface tables (OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_CUSTOMER_INFO_IFACE_ALL) • Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface) • Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system. Reports: • Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software. • Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher. • Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher. Forms: • Customized forms using custom.pll to change the functionally of the standard forms. • Customized Sales Order form to add customer fax, email and phone number contacts. • Customized the existing forms with descriptive flex fields. • Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.



DSRC

• Chennai Area, India

• Oracle Applications Technical Consultant Trainee

  • Nov 2006 - Jun 2007

  As a trainee involved in the development of customization of Forms, Reports, Coding PL/SQL scripts for Interface, data loading using SQL Loader etc in the financial modules of Oracle Applications (GL,AP,AR and FA) As a trainee involved in the development of customization of Forms, Reports, Coding PL/SQL scripts for Interface, data loading using SQL Loader etc in the financial modules of Oracle Applications (GL,AP,AR and FA)



Solutions Systems and Technologies

• Chennai Area, India

• System Administrator/ Oracle Database Administrator

  • Aug 2002 - Oct 2006

  Installing Windows NT / 2000 servers and Workstations Users and privileges management, Access Control on Database Objects Modem and Internet Configuration for Dialup Connections Configuring and Troubleshooting Internet connectivity Maintaining oracle 9i database in Linux & Windows Creation of backup and recovery procedures using RMAN Finding Performance bottlenecks using ESTIMATE, ANALYSE, EXPLAIN PLAN, SQL TRACE, TKPROFF, STATSPACK Installing Windows NT / 2000 servers and Workstations Users and privileges management, Access Control on Database Objects Modem and Internet Configuration for Dialup Connections Configuring and Troubleshooting Internet connectivity Maintaining oracle 9i database in Linux & Windows Creation of backup and recovery procedures using RMAN Finding Performance bottlenecks using ESTIMATE, ANALYSE, EXPLAIN PLAN, SQL TRACE, TKPROFF, STATSPACK