Resume 13

SKILLS HIGHLIGHT

• Oracle Applications Manufacturing Releases 11i/11.0/10.7 OE / INV / PO/ BOM / ENG / WIP

• Oracle Applications Financials Releases 11i/11.0/10.7 Modules AP /AR / GL / FA / PA AOL, WORKFLOW

• Oracle Tools: Developer 2000 Forms 6i / 5 / 4.5, Reports 6i / 3 / 2.5, Graphics 2.5, Designer 2000, Oracle Enterprise Manager, Oracle Discoverer, Data Query, SQL * Forms 3.0, SQL * Rep 1.1, SQL * DBA, SQL *Loader, SQL * Net, PL/SQL, Pro * C, Noetix Views, Web DB, Quest SQL Navigator, Toad

• Databases: Oracle 8i / 8.0 / 7.x, Unify, FoxPro, Paradox

• Operating Systems: UNIX, AIX, VAX/VMS, Alpha VMS, Windows NT & Windows 2000.

• Methodology: Oracle Methods, AIM.

• Life Cycle Expertise: Requirement Analysis, Logical / Physical Database Design, Custom Application Development, Software Maintenance, Testing, Quality Assurance and Documentation, Date conversion, Transition and System Administration.

• Other Products: Jdeveloper, Java 1.2, HTML, Foxpro, Dbase, MS Office, FORTRAN, BASIC, COBOL, C, PASCAL, PROLOG, Visual Basic, Barcode readers / Scanners, Signature and image retrieval systems.

Oracle Applications Custom Development - Specialized Skills:

• Custom Development reports, forms, interfaces & Conversions in Oracle Applications.
• PL/SQL based concurrent Programs
• Database Procedures, Packages, functions and triggers
• Flex fields setup / implementation.
• Applications System Administration.
• Conversion and interface programs development.
• Workarounds
• Technical lead & Support.

EXPERIENCE

• Customer Conversion Process AR .
• Conversion of Purchase Orders. PO
• Receiving Transactions Interface PO

Developed a custom extension called Refund Process for California DMV . Developed various forms and reports for this extension in Oracle Applications.

Developed a custom solution for spinal automatic incrementing process based on employee s anniversary date. This job will move each entitled employee up to the next point on his spine thus increasing his salary , unless he has reached the maximum point allowed on his grade or assignment.

This Application has a focus on enhancing the Police Department s ability to collect, manage and analyze the criminal records. This system replaces automates their manual system. Played the role of a Lead Developer of a project team responsible for creation of CHRIS system. Performed Requirement Collection, Design specification, Developed & Implemented the custom Applications

Environment: Oracle 8i, Developer 2000, Web DB, Oracle Enterprise Manager, Oracle Browser, SQL Loader, Oracle Designer.

• Implementation Assistance in Oracle Order Entry and Oracle Receivable modules.
• Played a Lead Developer in the Development of following Gaps, Interfaces, Reports & Forms.
• Built De-bill & Re-bill Invoice Program.
• Worked on Auto Invoice, Order Import Interface & Ship Confirm Interface.
• Worked on Cancel Included & Backordered items.
• Worked on Un-demand the original items & Demand Interface.
• Modified the Commercial Invoice, Certificate of Origin & Backlog Reports.
• Designed and developed Descriptive Flex Fields Setup and Application System Administration.

• Designed, developed & integrated a custom extension called Mortgage Billing System with Oracle Applications.
• Worked on Custom forms, Reports, Interface and Data Migration for this new Application.
• Involved in GL Consolidation rules mapping and developed custom reports according to the requirement of the client.
• Worked on AP Invoice Import process, AR Invoice import and Journal Entry Import Process.
• Modified the standard project entry report and Transaction reports in Project Accounting.
• Played the role of Technical Lead in all types of Customization and Integration with Oracle Applications in AP/AR/GL/FA modules.

• Worked on Inbound and Outbound interfaces between Legacy systems and Oracle Order entry module.
• Worked on Ship Confirm interface, Material transactions interface & Receiving Transactions interface.
• Integrated Point of Sale data through Order Import Interface.
• Developed a PL/SQL application to load the RMA Receipts from external system.
• Played the role of Technical Lead in all types of Customization and Integration with Oracle Application in AP/AR/GL/FA modules.

• Designed and developed a new functionality called SHIP DIRECT in Oracle Order entry Applications.
• Developed Forms & Reports for SHIP DIRECT method.
• Interfaced AP Invoices with external Sources.
• Customized Forms / reports in response to end users in PO, OE, AR modules.
• Modified the Standard Mass Addition report & Asset transfer Reconciliation reports in Fixed Assets.

• Developed Forms and Custom Reports & integrated with Oracle Application in Oracle Order Entry, Inventory, WIP, GL & PO modules.
• Developed AOL based custom GUI forms, Custom procedures, packages, functions and triggers.
• Customized and created reports as per user requirements. Customized different reports in GL, AR and AP such as Account Analysis Report, Expense Distribution Details Report, FYTD Vendor Volume Reports.
• Was responsible for defining and documenting customer requirements.
• Application System Administration.
• Modified and created new concurrent programs as well as executable files when new reports were created. Also responsible for defining user privileges.
• Played the role of Technical Lead in all types of Customization and Integration with Oracle Application.

• Designed and developed a Custom form for Delivery based shipping. Its main features were Ability to over/under pick quantity,
• Report over-picking and follow through to Invoice, ability to verify the quantity of the picked item falls within the allowable parameters for the item.

Oracle Environmental is a comprehensive, integrated environmental management information system that automates many environmental business functions. With a wealth of up-to-date reference information at our fingertips, the system will be able to mange the environmental program efficiently, track permits and ensure compliance with legislation, calculate emissions, coordinate projects such as waste minimization and to audit and respond quickly to emergency situations.

• Customized various Application interfaces & data loading procedures from other Applications to the E2MIS. Developed various MIS reports.
• Developed Ad hoc reports through Oracle Data query.
• Provided Overall Support and Maintenance of the system.
• Coordinated with Oracle Corporation in the enhancement of the Applications.

Environment: Oracle 7.3, Oracle Environmental 4.5.4, Developer 2000 Forms 4.5 / Reports 2.5 / Graphics 2.5 , Oracle Enterprise Manager, Oracle Browser, Data query, SQL * DBA.

The system is designed to track all the research and medical programs from date of receipt through evaluation, funding and completion. The Society is required to monitor the grant request, approval and funding process for research into the cure of MS.

• Involved in Analysis, Design, Coding and Deployment of the Research Application.
• Worked hand-in-hand with internal user community. Coordinated Installation of Oracle in Alpha, setup research database and forms, documented User Manual for the research application. Loaded the VAX Autopro Data, Beta Release & gave User Training.
• Involved in the Migration of the Development Environment from DEC VMS with Windows 3.11 for Workgroups to ALPHA VMS on Windows NT.

Involved in Conversion of the existing Applications Production and Financial Accounting systems running on UNIX-BASIX into Oracle 7.1

• Involved in Requirement Specification preparation, System Analysis and Design, most of which was conducted personally in Germany and Hong Kong. Developed various front-end forms, reports and back end procedures. Also involved in H/W and S/W negotiation from the vendors.
• Modules in the Production system include Sample Processing, Sales, Purchase & Manufacturing, Orders Warehousing & Inventory control, Quota / License Invoicing processing.
• Modules in the Financial Accounting system include A/P, A/R & G/L, Inter company processing, Credit / Debit notes, Cash control.

TRAINING

Oracle Human Resources Technical Foundation
Oracle Payroll Technical Foundation
Oracle Manufacturing Functional Foundation
Java Programming for Oracle Developers
Data Warehousing
Oracle Workflow 11i
Oracle Web Application Server - Develop Web-Based Applications
Define flex fields
Designer 6i
Customer Satisfaction Class

Academic Qualifications

Master of Computer Applications MCA
Madurai Kamaraj University, India.
April 92 GPA 4.0. First Rank Holder.

BS in Applied Sciences
Madurai Kamaraj University, India
April 89 GPA 4.0 First Class with Distinction.