際際滷

際際滷Share a Scribd company logo

Resume of Sugavanan - Oracle Apps Technical Consultant

S
Sugavanan Arunachalam

Sugavanan is an Oracle Applications technical consultant with over 9 years of experience. He has expertise in various Oracle modules including HRMS, Finance, SCM, and EAM. He has strong skills in PL/SQL, SQL, and Oracle development tools. Sugavanan has experience leading large implementation projects for clients in various industries and locations.

Convert to study materialsBETA

Transform any presentation into ready-made study materialselect from outputs like summaries, definitions, and practice questions.

1 of 5
Downloaded 630 times
Sugavanan Oracle Apps Technical Consultant asugavanan@gmail.com 971-056-6860157 Resume of Sugavanan, Oracle Apps Technical Consultant Page 1 of 5 Objective Seeking a challenging and rewarding Managerial / Senior position in Organizations that will enable me to apply my skills & knowledge in providing efficient & effective solutions in new Implementations. Professional Summary Having 9+ Years of Oracle eBusiness Suite Experience. Expertise in SQL, PL/SQL, Oracle Reports, Forms, XML/BI Publisher, Discoverer, Workflow. Strong Experience in Implementation, Upgrade, RICE Development, Data Conversion. Strong Experience in Oracle HRMS, Finance, Property, Projects, SCM, CRM, OPM, EAM. Working Experience in Web ADI, OAF, ADF, SOA. Strong Functional knowledge in Oracle HRMS modules Core HR, Payroll, Self Services HR, OLM. Good Functional knowledge in Oracle Finance, Property, CRM, SCM, Projects and EAM modules. Working Domain Knowledge Pre-Sales, Pre-Lease, Contract Management. Working Experience PowerBuilder/Sybase. Knowledge in SAP / ABAP Programing. Strong Experience in Requirement gathering, Gap Analysis, Business Process Modeling. Good Documentation skills to prepare deliverables using AIM methodology. Excellent communication, interpersonal and Analytical and problem-solving skills. Education Master of Computer Applications (M.C.A.), Bharathidhasan University, Tamil Nadu, India. Bachelor of Science (B.Sc. Mathematics), Madras University, Tamil Nadu, India. Skill Set Oracle Applications Oracle HCM, Finance, Property, Projects, SCM, CRM, OPM, EAM Development Tools Oracle Developer Suite 6i/10g Forms/Reports, XML/BI Publisher, Discoverer, Workflow Builder and PowerBuilder, OAF, ADF Oracle Tools SQL*Plus, Toad, PL/SQL Developer, SQL Developer, Data Loader, Web ADI RDBMS ORACLE , Sybase, SQL Server, MS-Access Languages SQL, PL/SQL, Java, VB, HTML, XML, ASP, JSP, UNIX. Operating system Win XP, Windows 2000, Win NT and Windows 7 Others FTP Tool, WinSCP , Putty, Unix Shell scripts Work Experience Summary Company Position Period Global Technology Services L.L.C. (Member of ENOC Group of Companies), Dubai Senior Technical Consultant Dec09 Till Date Dubai World, ITC (PCFC), Dubai Senior Application Developer Sep03 Oct09 Thai Carbon Black, Thailand System Analyst Oct01 Aug03 Systems Logic, Bangalore Software Engineer Jul00 Sep01 Acsys Software, Chennai Software Engineer Feb00 Jun00 Soffia Software, Chennai Software Engineer Feb97 Jan00 InfoSoft Techno, Bangalore Programmer Jan96 - Jan97
Resume of Sugavanan, Oracle Apps Technical Consultant Page 2 of 5 Work Experience Details: Global Technology Services L.L.C. (Member of ENOC Group of Companies), Dubai. Mabanee - Kuwait Senior Technical Consultant Dec'14 Till Date Mabanee ProRate Customization Solution on Schedule Items Concurrent Programs Development. Auto Prorate Adjustment for all Schedule Items. Alerts: Periodic Alert for Auto Schedule Adjustment. Form Personalization for validation at Schedule Level and Finalize Lease. Mabanee Customer Invoice reports changes. Requirement Gatherings, Data Fixing, Reports Development, UAT and Production Implementations. ENOC - Dubai Senior Technical Consultant Jan'14 - Nov'14 Requirement Gatherings, Data Migration, Reports Development, UAT and Production Implementations. Property Reports: Utility Charges, PN Lease Summary, Lease Rent Payment Summary, Lease Accrual Rent, Property Manager GL Reconciliation, Normalization Transfer, Lease Expiry, Rent Recovery, Lease Expiry Schedule OPM Reports: Daily Blending, Daily Filling, Pricelist detail, Material planning, OPM Inventory Reconciliation, Period Closing Exceptions, Product Cost BreakUp Details, Production Pick Slip Report, Quality Sampling Statistical. eAM Reports: Material Demand (Shortage), Downtime Analysis, Work Order Status, Asset BOM, Maintenance History, Open Work Order Report By Area, Completed Break Down Work Order Status, Shutdown WO and PR with PO Data Linkage, Spare Inventory Breakdown by Asset Category. OM Reports: Customer Statement of Accounts, Budget/Actual Report, Invoice Cum Delivery Advice, Credit ON Hold Current History, Pending Order by status, Proforma Marginal Analysis, download of sales data Volumes. SCM Reports: Print Requisitions Report, Print Purchase Order - Singapore, Print Purchase Order, Standard PO. Finance Reports: Bank Transfer Letter - SCB, Bank Transfer/Demand Draft Letter ENOC. Custom Form: Property Custom Form Change on Utility Charge Entry Form. Data Migration: Supplier, Supplier Site, Supplier Bank, Supplier Contacts Data migration. AlDar - Abu Dhabi Senior Technical Consultant Jan'13 - Dec'13 Contract Management System - CMS: Oracle Applications Development, Enhancement and Customization on Oracle Sourcing and Procurement. Developed Custom form for Variation Order Creation and workflow process for the approval process of the same. XML Reports: Tender Committee Decision Form for Bidder List, Technical Evaluation, Award and Variation Order. BI-Reports: Project and Contract wise Work Done and Cash Payment report. Data Migration for Open POs and other custom tables. Pre-Lease: Modified Prelease forms and workflows as per business requirement, Reports for legal contracts. Developed custom form refund calculation for terminated leases with workflow process for approval hierarchy. Support: Ad-hoc/BI reports on Projects, Property Manager and Finance standard Modules. Technical/Functional/User Support on Pre-Lease, Contract Management, Service Charges and Property Modules. Data Fix, Custom Solution issue Fix, Workflow issue Fix and Pre-Lease changes (Forms/Reports/Workflow). Data Extraction/Reconciliation and custom module testing as part of Migration Project. Ewaan (Saudi Arabia) Senior Technical Consultant Apr'12 - Dec'12 HRMS: Package development for Auto Element Entry Creation (Annual Leave Salary Advance & Deduction, Lieu Leave, Loans & Advance, Business/Training Travel Allowance Domestic/International, Payments/Reimbursements ) Trigger creation for Employee self-service SIT validation HRMS: Personal Details Report, Assignment Details, Payroll Summary Reconciliation, Payslip Report, Salary Register, Cheque Format Print, Cash Register, Bank Transfer Report, Payroll Wire Transfer and Loans & Advances OLM: Emp Performance Appraisal, Training Enrollment, Employee Training Plan Summary, Plan & Budget. Alerts: Employee Training Class Expiration, Training Class Expiration Escalation, Employee Leave Resumption Reminder, Leave Resumption Escalation Pending Approval Escalation, Employee Passport Expiry Escalation, Employee Iqama Expiry Escalation. Pre-Sales: Developed Custom Forms and Approval Workflow process for property sales. Property Price List, Payment Schedules, User Access, Approval Hierarchies & Reservation Inquiry. Property Reservation/Registration /Cashier/ Cancellation /Transfer. Release / UnRelease Property for Sale. Property - Payment Schedule, Due Payment Schedules and PDI Compliance. Data Migration on Custom Presales, Supplier, Customer, AP Invoices, AR Invoices, ManualJV for different Orgs. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning, documentation. CMS: Report development: Print Payment Certificate, PC Proforma Invoice, GRN Print, Contract Print Report, Contract Status Report, Payment Log Report, Hard and Soft Cost Status Report, VO Tracking Summary Report. Involved in Post Implementation Production support for all modules.
Resume of Sugavanan, Oracle Apps Technical Consultant Page 3 of 5 ADEC - Abu Dhabi Technical Consultant Mar'11 - Mar'12 IT Helpdesk support, related to technical issues on HRMS, SCM &Finance modules. Reports development and corrections. School Teachers Data and Scholarship Students data uploading. HRMS IBAN SIT upload and Payment method update for all ADEC Employees Bulk data update on Grade Change, Salary Change, Position Change , Organization Change Region-wise Employee Data upload on Passport, Visa, Contract, Contact and Address. HRMS Reports: Employee Renewal of Contract, Employee Overtime Report, Employees Training Report, ADEC Vacant Position Report, Retirement Pensions & Benefits Fund Report and Employee Experience Letters Alerts: Above 60 Years Monthly Notification, Alert Contract Expiry, Resignation Approval & Probation Reminder Ad-hoc Reports: Employee accommodation housing details, SSHR pending transaction list, Licensed Teachers details, Employee Leave details for a periods, Transferred Teachers List, Employee Passport & Visa details, School fee Exemption details, SIT related reports, Leave balance detail, Payroll run element details report, ERP application users details and Contingent workers details. SCM: PO Summary, Buyer Assignment, PO with invoice and receipts Requisitions without POs specific accounts. Finance: Supplier Invoices Status Report, Supplier Payment Details, TSA Report, Invoice Aging Report, Fixed Assets Report, Bank Transfer Detail, Manual JVs for a given period and Journal Entries with Line descriptions. Arabtec (Saudi Arabia) Technical Consultant Dec'09 - Feb'11 Custom Form development of Payment Certificate and project variation for Project module. Custom Workflow development for Project Variation approval communications. Projects: Certificate of Payment, Cost Value Reconciliation, Cost Value Reconciliation Internal, Job Wise Profit Analysis, Job Summary and Payment Certificate Summary Reports. HRMS: Personal Details, Assignment Details, Salary Hours Detail, Payslip, Cash Register and Currency report. Finance: AP Sub-Ledger, Supplier Statement of Accounts, Outstanding Statement, Bank Guarantee Reconciliation. SCM: Quote Analysis Summary, Store Receipt Voucher report and Purchase Order Print. UAT Bug Fixing for all module issues. Deployment of all custom objects in Arabtec productions instance. Data Conversion: HRMS Employee Personal, Assignment, Basic Salary, Job Title and Additional Information Iqama, Passport, Labour Card & Entry Details for KSA and Effeco. Data Conversion: Projects Cost budget upload and AP Supplier Data Upload, AP/AR Invoices Transaction Data Upload. MD70 document Preparation. Involved in Post Implementation Production support for all modules. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning. Handling different kind of Business Process Analysis sessions, Requirement Gatherings, UAT Sessions and trainings. Other Assignments REMAR-Dubai: BI Publisher Reports Development in Oracle Fusion Cloud, Lead project submission, Investment Appraisal. Alshaya-Kuwait: Incentive Management System to calculate incentive for employees. Modified Forms & Reports and Packages as per new policy and business requirement. Developed Concurrent program to calculate incentive, extract & upload to HRMS. ACTVET-Abu Dhabi: Item Master, Item Categories and Item Assignments Data Conversion. Open Purchase Order and Un-invoced Receipts, Banks & Bank Branches / Bank Accounts Data Conversion. Supplier, Supplier Site, Supplier Bank, Supplier Contacts Data Conversion, Customer Data Conversion. GPSSA-Abu Dhabi: Finance Reports: Supplier Statement, Bank Statement Detail, Asset Depreciation, Asset Additions, Trial Balance, Journal Entries, Invoice Register, Payment Register, Prepayment Balance, Miscellaneous, Retention, CIP Asset Detail, Fixed Assets Assign, Asset Retirements, Asset List Depreciation Quarter, Fully Depreciated Asset, Summary Profit and Losses, Detailed Profit and Losses, General and Administration Expenses, Capital Expenses, Actual Vs Budget, On hold Invoices AR and HRMS Reports & SCM Reports.
Resume of Sugavanan, Oracle Apps Technical Consultant Page 4 of 5 Dubai World, ITC (PCFC), Dubai Thai Carbon Black, Thailand JAFZA, DMCC - Dubai Senior Application Developer Aug'06 - Oct'09 Ad-hoc Report generations. Application user/functional Support on identified issue. Data Extraction and Conversion from FZ legacy System and Excel flat file to FREECOMS, Membership data, Non- Sponsored employee conversion, Property Master Upload, etc. Existing report changes as per Business Requests and Demands. OA Framework application development & changes as per Business request. Package changes to fix the issue as per business requirement. BR100 setup preparation, review & testing in DWCS/DWCT and move to DWCP production. MRF Change request - code pack preparation & testing along with MD50, MD70, TE50. Script for data fixes, test and move to production through Data Update utility responsibility. Ad-hoc Reports: Call-Centre, Registered/Terminated companies, Customers actual and issued visas, Nationality wise employee, Dummy & Way-leave leases, BG Paper-Cash, etc. Data-Fix: Local Transfer, Customer account with multiple BU, Arabic info, ID-Card Printing, SR, OTC Lines, DNRD Job list, Employee, CIC, Registration, License, Sequence No, etc. Reports: Open Task SR List, Customer Registration License Details, Marketing Email Status Summary report, Employee / Abscondee Statistics Nationality report, Letter changes, etc. Performance tuning in Lease renewal Agreement, Letter generations, etc. Mass Closure Task update Standalone form, Membership form, Lease Termination form SR validate package change for salary certificate printing, BG, Country, Shareholder issues etc. Enable DFF (Urgency and In Country) for Dependent Visa along with pricing setup, etc. BR100: New responsibility, Profile setup, Personalization setup, Menu setup, etc. Portal License Renew service request process enables and changes. Code Pack movements (on demand/daily) for User acceptances and Productions. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning. Dubai Port Authority - Dubai Senior Application Developer Sep'03 - Jul'06 FZIS: Client Project proposal information, Facilities, Client Enquiry and Sales Forecasting. Facility Allocation & Booking, Sales tracking, Document verification, CED / EHS approval, Lease & License sales customer Transfer to Admin. Management reports (FZMR) FZCA: FZE/FZCO Client Formation Creation / Amendment License & Lease Preparation / Amendment / Renewal / Termination. Lease Billing, Insurance information, insurance reminder Client Level Amendment/ Licence Activity Amendment Lease / Licence Follow ups and Certificate printing Reports Generation / PDF file Generations for invoices. Staff Accommodation, Order Creation and Facility Allocation. FZPR: Sponsored /Non-Sponsored employee information maintenance of Free Zone Clients. Creation / Renewal of Resident Permit, Health Card, Access Passes of FZ employees. ID CARD Issue and Renewal of FZ employees. NOC Letters, Salary Letter certificates Services & myJaFza Web Services. Thai Carbon Black public Co. Ltd. System Analyst Oct'01 - Aug'03 Supplier master, Item Master, Contract Details, General Conditions. Department / Stores Indent and Auto Indent with Normal / Raw Material / Job Item intent Types. Preparation Includes Approval, Cancel. Indent Action By, Normal / Raw Material / Job Item Enquiry preparations. Normal / Raw Material / Job Item Quotation and Comparison chart preparations. Normal / RM / Job Purchase Order Preparation, Includes Approval, Cancel, Short Close Items. Import / Local Purchase Order with Standard / Blanket / Repeat Types. Letter of Credit Register, Shipment Register, Duty Calculations, Board of Investment Approval for Duty Exemptions. Clearing Agent, Bank Guarantee, Freight Charges, Customs Duty. Normal/ RM Goods Receipt Note, Job Completion Note Preparation Includes Approval, Cancel. Material Rejection and Damage Preparation Includes Approval, Cancel. Stores Purchase Voucher (SPV) Preparation Includes Approval, Hold Payment. Stores Purchase Import Expense Voucher (SPX) Preparation Includes Approval, Hold Payment. Issue Pass / Return and Gate Pass Preparation Includes Approval, Cancel. Database development, Analysis and Design of the flow for the Purchase and Stores module. Involved in documentation of the flow. Coding, Testing and Implementation of the Application.
Resume of Sugavanan, Oracle Apps Technical Consultant Page 5 of 5 Systems Logic, Bangalore Acsys Software, Chennai Soffia Software, Chennai InfoSoft Techno, Bangalore Thai Acrylic Fibre Co. Ltd Software Engineer Jul'00 - Sep'01 TAF-TCB Commercial system: One of the modules in this project is Purchase module which covers all activities like sending of enquiries to various suppliers and receiving quotations from them. Then prepare a comparative chart against the enquiries and selecting the best combination of rates after some negotiations will be taken up. The next process is raising a purchase order on the respective supplier. Purchase orders can also be raised directly on supplier. When the material is received at the Stores a Goods Receipt Note (GRN) will be prepared against the Dispatch advise. Database development, Analysis and Design of the flow for the Purchase and Stores module. Involved in Coding, Testing, Implementation and Documentation of the Application. Alliance Capital Asset Management (India) Pvt. Ltd Software Engineer Feb'00 - Jun'00 Investment Tracking System: New Investor Creations / New Brokers entry form. New scheme and policy creations. Dividend plan, Growth plan, liquid funds, income funds. Transaction Switch in/out, Investment, Redemption and additionally transferring from one scheme to another. Soffia Software Software Engineer Feb'97 - Jan'00 Amrep Online system: This Project deals with Stores, Production Planning, Marketing and Finance Module. STORES: Stores module contains item master which has the detail of all items available in the stores. It also contains supplier master which has both list of supplier and sub-contractors. The other masters are rejection code master, ecccode master (central excise purpose) and supplier category master. Open purchase order is generated for both supplier and subcontractor. Delivery schedule for supply of material for a supplier is set for a month. Goods are received from particular supplier only if Delivery schedule for the particular item is present. After receiving the items, they are inspected and accepted in the stores. PRODUCTION: Demand is received from marketing module and stock in stores is fetched. After making provision for minimum stock in stores, Production schedule is generated. From production planning, the production target for a component, sub assembly and assembly is approved for the month. Daily production target is fixed after taking into consideration material availability in stores, machine availability, operator availability, material expected from sub-contractor etc. Bill of material master is used to explode the item. One special feature included is ABM (Alternate bill of material code). This takes care of production of particular item in any method Fixed Assets Accounting: This package is for maintenance of fixed asset records. It prepares the schedule of fixed assets along with depreciation. Depreciation as per the companies act, Depreciation as per the income tax Act as well as depreciation for the purpose of section 350 of companies act, generated. The fixed assets can be classified up to three levels in addition to classifying the assets based on the location of fixed assets. Depreciation schedule can be generated either on Straight line method or on written down value method for the purpose of companies act. All the provisions of the relevant acts and rules were taken into account while preparing and computing necessary outputs. TDSSOFT: This product is meant for preparing Form 16A and the Returns like Interest- other than on securities, dividends and Interests, rents etc. It has flexible importing utilities for payments, challan details and also for the party details and importing of data can be done from any database. Standard report outputs can be taken in any size using the zooming facility. Integrated Assessment System: IAS is a powerful IT tool for the Income tax department, mainly for the Company circle. This product makes the computation of tax much easier and in no time. The main idea behind this product is to improve the revenue by making the demand and collection of tax at any time of requirement. It also has a flexible importing utility for bringing in the arrears data from any type of format. This application covers the entire process starting from filing of return, data entry to tax assessment. Sufficient queries for the tax department giving required results of pending notice, registers and proceedings. InfoSoft Techno Programmer Jan'96 - Jan'97 Power Control Panel System: This system maintains the Price List for fixed items according to the company and maintains the Information regarding service maintenance for the client. It registers the quotations received from customers for constructing power control Panel. The bill is printed based on the confirmed quotations. Sales Order Customization: This system maintains the details for the various house hold appliances according to the company and maintains the customer details. It registers the invoice raised to the customer based on the customer ordered for the various household appliances. It records all the transaction which includes, generation of cash bills/ invoices, handling customer payments, handling component receipts, updating of stock at the time of delivering and updates of stock at the receipt at raw material. It prints the Invoice Bill based on the invoice to be raised to the customer.

More Related Content

Resume of Sugavanan - Oracle Apps Technical Consultant

  • 1. Sugavanan Oracle Apps Technical Consultant asugavanan@gmail.com 971-056-6860157 Resume of Sugavanan, Oracle Apps Technical Consultant Page 1 of 5 Objective Seeking a challenging and rewarding Managerial / Senior position in Organizations that will enable me to apply my skills & knowledge in providing efficient & effective solutions in new Implementations. Professional Summary Having 9+ Years of Oracle eBusiness Suite Experience. Expertise in SQL, PL/SQL, Oracle Reports, Forms, XML/BI Publisher, Discoverer, Workflow. Strong Experience in Implementation, Upgrade, RICE Development, Data Conversion. Strong Experience in Oracle HRMS, Finance, Property, Projects, SCM, CRM, OPM, EAM. Working Experience in Web ADI, OAF, ADF, SOA. Strong Functional knowledge in Oracle HRMS modules Core HR, Payroll, Self Services HR, OLM. Good Functional knowledge in Oracle Finance, Property, CRM, SCM, Projects and EAM modules. Working Domain Knowledge Pre-Sales, Pre-Lease, Contract Management. Working Experience PowerBuilder/Sybase. Knowledge in SAP / ABAP Programing. Strong Experience in Requirement gathering, Gap Analysis, Business Process Modeling. Good Documentation skills to prepare deliverables using AIM methodology. Excellent communication, interpersonal and Analytical and problem-solving skills. Education Master of Computer Applications (M.C.A.), Bharathidhasan University, Tamil Nadu, India. Bachelor of Science (B.Sc. Mathematics), Madras University, Tamil Nadu, India. Skill Set Oracle Applications Oracle HCM, Finance, Property, Projects, SCM, CRM, OPM, EAM Development Tools Oracle Developer Suite 6i/10g Forms/Reports, XML/BI Publisher, Discoverer, Workflow Builder and PowerBuilder, OAF, ADF Oracle Tools SQL*Plus, Toad, PL/SQL Developer, SQL Developer, Data Loader, Web ADI RDBMS ORACLE , Sybase, SQL Server, MS-Access Languages SQL, PL/SQL, Java, VB, HTML, XML, ASP, JSP, UNIX. Operating system Win XP, Windows 2000, Win NT and Windows 7 Others FTP Tool, WinSCP , Putty, Unix Shell scripts Work Experience Summary Company Position Period Global Technology Services L.L.C. (Member of ENOC Group of Companies), Dubai Senior Technical Consultant Dec09 Till Date Dubai World, ITC (PCFC), Dubai Senior Application Developer Sep03 Oct09 Thai Carbon Black, Thailand System Analyst Oct01 Aug03 Systems Logic, Bangalore Software Engineer Jul00 Sep01 Acsys Software, Chennai Software Engineer Feb00 Jun00 Soffia Software, Chennai Software Engineer Feb97 Jan00 InfoSoft Techno, Bangalore Programmer Jan96 - Jan97
  • 2. Resume of Sugavanan, Oracle Apps Technical Consultant Page 2 of 5 Work Experience Details: Global Technology Services L.L.C. (Member of ENOC Group of Companies), Dubai. Mabanee - Kuwait Senior Technical Consultant Dec'14 Till Date Mabanee ProRate Customization Solution on Schedule Items Concurrent Programs Development. Auto Prorate Adjustment for all Schedule Items. Alerts: Periodic Alert for Auto Schedule Adjustment. Form Personalization for validation at Schedule Level and Finalize Lease. Mabanee Customer Invoice reports changes. Requirement Gatherings, Data Fixing, Reports Development, UAT and Production Implementations. ENOC - Dubai Senior Technical Consultant Jan'14 - Nov'14 Requirement Gatherings, Data Migration, Reports Development, UAT and Production Implementations. Property Reports: Utility Charges, PN Lease Summary, Lease Rent Payment Summary, Lease Accrual Rent, Property Manager GL Reconciliation, Normalization Transfer, Lease Expiry, Rent Recovery, Lease Expiry Schedule OPM Reports: Daily Blending, Daily Filling, Pricelist detail, Material planning, OPM Inventory Reconciliation, Period Closing Exceptions, Product Cost BreakUp Details, Production Pick Slip Report, Quality Sampling Statistical. eAM Reports: Material Demand (Shortage), Downtime Analysis, Work Order Status, Asset BOM, Maintenance History, Open Work Order Report By Area, Completed Break Down Work Order Status, Shutdown WO and PR with PO Data Linkage, Spare Inventory Breakdown by Asset Category. OM Reports: Customer Statement of Accounts, Budget/Actual Report, Invoice Cum Delivery Advice, Credit ON Hold Current History, Pending Order by status, Proforma Marginal Analysis, download of sales data Volumes. SCM Reports: Print Requisitions Report, Print Purchase Order - Singapore, Print Purchase Order, Standard PO. Finance Reports: Bank Transfer Letter - SCB, Bank Transfer/Demand Draft Letter ENOC. Custom Form: Property Custom Form Change on Utility Charge Entry Form. Data Migration: Supplier, Supplier Site, Supplier Bank, Supplier Contacts Data migration. AlDar - Abu Dhabi Senior Technical Consultant Jan'13 - Dec'13 Contract Management System - CMS: Oracle Applications Development, Enhancement and Customization on Oracle Sourcing and Procurement. Developed Custom form for Variation Order Creation and workflow process for the approval process of the same. XML Reports: Tender Committee Decision Form for Bidder List, Technical Evaluation, Award and Variation Order. BI-Reports: Project and Contract wise Work Done and Cash Payment report. Data Migration for Open POs and other custom tables. Pre-Lease: Modified Prelease forms and workflows as per business requirement, Reports for legal contracts. Developed custom form refund calculation for terminated leases with workflow process for approval hierarchy. Support: Ad-hoc/BI reports on Projects, Property Manager and Finance standard Modules. Technical/Functional/User Support on Pre-Lease, Contract Management, Service Charges and Property Modules. Data Fix, Custom Solution issue Fix, Workflow issue Fix and Pre-Lease changes (Forms/Reports/Workflow). Data Extraction/Reconciliation and custom module testing as part of Migration Project. Ewaan (Saudi Arabia) Senior Technical Consultant Apr'12 - Dec'12 HRMS: Package development for Auto Element Entry Creation (Annual Leave Salary Advance & Deduction, Lieu Leave, Loans & Advance, Business/Training Travel Allowance Domestic/International, Payments/Reimbursements ) Trigger creation for Employee self-service SIT validation HRMS: Personal Details Report, Assignment Details, Payroll Summary Reconciliation, Payslip Report, Salary Register, Cheque Format Print, Cash Register, Bank Transfer Report, Payroll Wire Transfer and Loans & Advances OLM: Emp Performance Appraisal, Training Enrollment, Employee Training Plan Summary, Plan & Budget. Alerts: Employee Training Class Expiration, Training Class Expiration Escalation, Employee Leave Resumption Reminder, Leave Resumption Escalation Pending Approval Escalation, Employee Passport Expiry Escalation, Employee Iqama Expiry Escalation. Pre-Sales: Developed Custom Forms and Approval Workflow process for property sales. Property Price List, Payment Schedules, User Access, Approval Hierarchies & Reservation Inquiry. Property Reservation/Registration /Cashier/ Cancellation /Transfer. Release / UnRelease Property for Sale. Property - Payment Schedule, Due Payment Schedules and PDI Compliance. Data Migration on Custom Presales, Supplier, Customer, AP Invoices, AR Invoices, ManualJV for different Orgs. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning, documentation. CMS: Report development: Print Payment Certificate, PC Proforma Invoice, GRN Print, Contract Print Report, Contract Status Report, Payment Log Report, Hard and Soft Cost Status Report, VO Tracking Summary Report. Involved in Post Implementation Production support for all modules.
  • 3. Resume of Sugavanan, Oracle Apps Technical Consultant Page 3 of 5 ADEC - Abu Dhabi Technical Consultant Mar'11 - Mar'12 IT Helpdesk support, related to technical issues on HRMS, SCM &Finance modules. Reports development and corrections. School Teachers Data and Scholarship Students data uploading. HRMS IBAN SIT upload and Payment method update for all ADEC Employees Bulk data update on Grade Change, Salary Change, Position Change , Organization Change Region-wise Employee Data upload on Passport, Visa, Contract, Contact and Address. HRMS Reports: Employee Renewal of Contract, Employee Overtime Report, Employees Training Report, ADEC Vacant Position Report, Retirement Pensions & Benefits Fund Report and Employee Experience Letters Alerts: Above 60 Years Monthly Notification, Alert Contract Expiry, Resignation Approval & Probation Reminder Ad-hoc Reports: Employee accommodation housing details, SSHR pending transaction list, Licensed Teachers details, Employee Leave details for a periods, Transferred Teachers List, Employee Passport & Visa details, School fee Exemption details, SIT related reports, Leave balance detail, Payroll run element details report, ERP application users details and Contingent workers details. SCM: PO Summary, Buyer Assignment, PO with invoice and receipts Requisitions without POs specific accounts. Finance: Supplier Invoices Status Report, Supplier Payment Details, TSA Report, Invoice Aging Report, Fixed Assets Report, Bank Transfer Detail, Manual JVs for a given period and Journal Entries with Line descriptions. Arabtec (Saudi Arabia) Technical Consultant Dec'09 - Feb'11 Custom Form development of Payment Certificate and project variation for Project module. Custom Workflow development for Project Variation approval communications. Projects: Certificate of Payment, Cost Value Reconciliation, Cost Value Reconciliation Internal, Job Wise Profit Analysis, Job Summary and Payment Certificate Summary Reports. HRMS: Personal Details, Assignment Details, Salary Hours Detail, Payslip, Cash Register and Currency report. Finance: AP Sub-Ledger, Supplier Statement of Accounts, Outstanding Statement, Bank Guarantee Reconciliation. SCM: Quote Analysis Summary, Store Receipt Voucher report and Purchase Order Print. UAT Bug Fixing for all module issues. Deployment of all custom objects in Arabtec productions instance. Data Conversion: HRMS Employee Personal, Assignment, Basic Salary, Job Title and Additional Information Iqama, Passport, Labour Card & Entry Details for KSA and Effeco. Data Conversion: Projects Cost budget upload and AP Supplier Data Upload, AP/AR Invoices Transaction Data Upload. MD70 document Preparation. Involved in Post Implementation Production support for all modules. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning. Handling different kind of Business Process Analysis sessions, Requirement Gatherings, UAT Sessions and trainings. Other Assignments REMAR-Dubai: BI Publisher Reports Development in Oracle Fusion Cloud, Lead project submission, Investment Appraisal. Alshaya-Kuwait: Incentive Management System to calculate incentive for employees. Modified Forms & Reports and Packages as per new policy and business requirement. Developed Concurrent program to calculate incentive, extract & upload to HRMS. ACTVET-Abu Dhabi: Item Master, Item Categories and Item Assignments Data Conversion. Open Purchase Order and Un-invoced Receipts, Banks & Bank Branches / Bank Accounts Data Conversion. Supplier, Supplier Site, Supplier Bank, Supplier Contacts Data Conversion, Customer Data Conversion. GPSSA-Abu Dhabi: Finance Reports: Supplier Statement, Bank Statement Detail, Asset Depreciation, Asset Additions, Trial Balance, Journal Entries, Invoice Register, Payment Register, Prepayment Balance, Miscellaneous, Retention, CIP Asset Detail, Fixed Assets Assign, Asset Retirements, Asset List Depreciation Quarter, Fully Depreciated Asset, Summary Profit and Losses, Detailed Profit and Losses, General and Administration Expenses, Capital Expenses, Actual Vs Budget, On hold Invoices AR and HRMS Reports & SCM Reports.
  • 4. Resume of Sugavanan, Oracle Apps Technical Consultant Page 4 of 5 Dubai World, ITC (PCFC), Dubai Thai Carbon Black, Thailand JAFZA, DMCC - Dubai Senior Application Developer Aug'06 - Oct'09 Ad-hoc Report generations. Application user/functional Support on identified issue. Data Extraction and Conversion from FZ legacy System and Excel flat file to FREECOMS, Membership data, Non- Sponsored employee conversion, Property Master Upload, etc. Existing report changes as per Business Requests and Demands. OA Framework application development & changes as per Business request. Package changes to fix the issue as per business requirement. BR100 setup preparation, review & testing in DWCS/DWCT and move to DWCP production. MRF Change request - code pack preparation & testing along with MD50, MD70, TE50. Script for data fixes, test and move to production through Data Update utility responsibility. Ad-hoc Reports: Call-Centre, Registered/Terminated companies, Customers actual and issued visas, Nationality wise employee, Dummy & Way-leave leases, BG Paper-Cash, etc. Data-Fix: Local Transfer, Customer account with multiple BU, Arabic info, ID-Card Printing, SR, OTC Lines, DNRD Job list, Employee, CIC, Registration, License, Sequence No, etc. Reports: Open Task SR List, Customer Registration License Details, Marketing Email Status Summary report, Employee / Abscondee Statistics Nationality report, Letter changes, etc. Performance tuning in Lease renewal Agreement, Letter generations, etc. Mass Closure Task update Standalone form, Membership form, Lease Termination form SR validate package change for salary certificate printing, BG, Country, Shareholder issues etc. Enable DFF (Urgency and In Country) for Dependent Visa along with pricing setup, etc. BR100: New responsibility, Profile setup, Personalization setup, Menu setup, etc. Portal License Renew service request process enables and changes. Code Pack movements (on demand/daily) for User acceptances and Productions. Data Extraction, Data Migration, Bug Fix, Data Fix, Report development, performance tuning. Dubai Port Authority - Dubai Senior Application Developer Sep'03 - Jul'06 FZIS: Client Project proposal information, Facilities, Client Enquiry and Sales Forecasting. Facility Allocation & Booking, Sales tracking, Document verification, CED / EHS approval, Lease & License sales customer Transfer to Admin. Management reports (FZMR) FZCA: FZE/FZCO Client Formation Creation / Amendment License & Lease Preparation / Amendment / Renewal / Termination. Lease Billing, Insurance information, insurance reminder Client Level Amendment/ Licence Activity Amendment Lease / Licence Follow ups and Certificate printing Reports Generation / PDF file Generations for invoices. Staff Accommodation, Order Creation and Facility Allocation. FZPR: Sponsored /Non-Sponsored employee information maintenance of Free Zone Clients. Creation / Renewal of Resident Permit, Health Card, Access Passes of FZ employees. ID CARD Issue and Renewal of FZ employees. NOC Letters, Salary Letter certificates Services & myJaFza Web Services. Thai Carbon Black public Co. Ltd. System Analyst Oct'01 - Aug'03 Supplier master, Item Master, Contract Details, General Conditions. Department / Stores Indent and Auto Indent with Normal / Raw Material / Job Item intent Types. Preparation Includes Approval, Cancel. Indent Action By, Normal / Raw Material / Job Item Enquiry preparations. Normal / Raw Material / Job Item Quotation and Comparison chart preparations. Normal / RM / Job Purchase Order Preparation, Includes Approval, Cancel, Short Close Items. Import / Local Purchase Order with Standard / Blanket / Repeat Types. Letter of Credit Register, Shipment Register, Duty Calculations, Board of Investment Approval for Duty Exemptions. Clearing Agent, Bank Guarantee, Freight Charges, Customs Duty. Normal/ RM Goods Receipt Note, Job Completion Note Preparation Includes Approval, Cancel. Material Rejection and Damage Preparation Includes Approval, Cancel. Stores Purchase Voucher (SPV) Preparation Includes Approval, Hold Payment. Stores Purchase Import Expense Voucher (SPX) Preparation Includes Approval, Hold Payment. Issue Pass / Return and Gate Pass Preparation Includes Approval, Cancel. Database development, Analysis and Design of the flow for the Purchase and Stores module. Involved in documentation of the flow. Coding, Testing and Implementation of the Application.
  • 5. Resume of Sugavanan, Oracle Apps Technical Consultant Page 5 of 5 Systems Logic, Bangalore Acsys Software, Chennai Soffia Software, Chennai InfoSoft Techno, Bangalore Thai Acrylic Fibre Co. Ltd Software Engineer Jul'00 - Sep'01 TAF-TCB Commercial system: One of the modules in this project is Purchase module which covers all activities like sending of enquiries to various suppliers and receiving quotations from them. Then prepare a comparative chart against the enquiries and selecting the best combination of rates after some negotiations will be taken up. The next process is raising a purchase order on the respective supplier. Purchase orders can also be raised directly on supplier. When the material is received at the Stores a Goods Receipt Note (GRN) will be prepared against the Dispatch advise. Database development, Analysis and Design of the flow for the Purchase and Stores module. Involved in Coding, Testing, Implementation and Documentation of the Application. Alliance Capital Asset Management (India) Pvt. Ltd Software Engineer Feb'00 - Jun'00 Investment Tracking System: New Investor Creations / New Brokers entry form. New scheme and policy creations. Dividend plan, Growth plan, liquid funds, income funds. Transaction Switch in/out, Investment, Redemption and additionally transferring from one scheme to another. Soffia Software Software Engineer Feb'97 - Jan'00 Amrep Online system: This Project deals with Stores, Production Planning, Marketing and Finance Module. STORES: Stores module contains item master which has the detail of all items available in the stores. It also contains supplier master which has both list of supplier and sub-contractors. The other masters are rejection code master, ecccode master (central excise purpose) and supplier category master. Open purchase order is generated for both supplier and subcontractor. Delivery schedule for supply of material for a supplier is set for a month. Goods are received from particular supplier only if Delivery schedule for the particular item is present. After receiving the items, they are inspected and accepted in the stores. PRODUCTION: Demand is received from marketing module and stock in stores is fetched. After making provision for minimum stock in stores, Production schedule is generated. From production planning, the production target for a component, sub assembly and assembly is approved for the month. Daily production target is fixed after taking into consideration material availability in stores, machine availability, operator availability, material expected from sub-contractor etc. Bill of material master is used to explode the item. One special feature included is ABM (Alternate bill of material code). This takes care of production of particular item in any method Fixed Assets Accounting: This package is for maintenance of fixed asset records. It prepares the schedule of fixed assets along with depreciation. Depreciation as per the companies act, Depreciation as per the income tax Act as well as depreciation for the purpose of section 350 of companies act, generated. The fixed assets can be classified up to three levels in addition to classifying the assets based on the location of fixed assets. Depreciation schedule can be generated either on Straight line method or on written down value method for the purpose of companies act. All the provisions of the relevant acts and rules were taken into account while preparing and computing necessary outputs. TDSSOFT: This product is meant for preparing Form 16A and the Returns like Interest- other than on securities, dividends and Interests, rents etc. It has flexible importing utilities for payments, challan details and also for the party details and importing of data can be done from any database. Standard report outputs can be taken in any size using the zooming facility. Integrated Assessment System: IAS is a powerful IT tool for the Income tax department, mainly for the Company circle. This product makes the computation of tax much easier and in no time. The main idea behind this product is to improve the revenue by making the demand and collection of tax at any time of requirement. It also has a flexible importing utility for bringing in the arrears data from any type of format. This application covers the entire process starting from filing of return, data entry to tax assessment. Sufficient queries for the tax department giving required results of pending notice, registers and proceedings. InfoSoft Techno Programmer Jan'96 - Jan'97 Power Control Panel System: This system maintains the Price List for fixed items according to the company and maintains the Information regarding service maintenance for the client. It registers the quotations received from customers for constructing power control Panel. The bill is printed based on the confirmed quotations. Sales Order Customization: This system maintains the details for the various house hold appliances according to the company and maintains the customer details. It registers the invoice raised to the customer based on the customer ordered for the various household appliances. It records all the transaction which includes, generation of cash bills/ invoices, handling customer payments, handling component receipts, updating of stock at the time of delivering and updates of stock at the receipt at raw material. It prints the Invoice Bill based on the invoice to be raised to the customer.