www.cholaconsulting.com

From: Oracle Developer
Remote Name: 122.167.217.1
Date: Friday, December 12, 2008
Time: 01:39 AM

Resume

Nattuturai Palanichamy Mail Id : nattuduraip@gmail.com Mobile No: +91 9902807050 Objective To obtain a challenging position in the field of information technology that enables me to become adopt and competent in the latest, career advancement in an excellent Oracle Developer. Professional Summary I have 2+6 (2 years 6 Months) of experience in business software analysis, design, Database development and Customizations of application development using SQL, PL/SQL (9i) and forms 6i, Developer 2000 (forms & Report) Experience Summary 1. Chola Software Consulting Pvt. Ltd. Bangalore  From May 2006 to till date working as a Software Engineer at Chola Software Consulting Pvt Ltd in Bangalore.  Responsibilities: Developing Stored Procedures, Triggers, Queries using Oracle 9i Generating Reports using Forms 6i & Reports6i (Developer 2000). 2. Faculty experience in Sun InfoTech Computers  From May 2003 to April 2006 working as a Faculty at Sun InfoTech Computers in Ambilikkai.  Responsibilities: Teaching, Training & Development in Oracle 9i for final year students Academic project guidance in oracle and Ms Access. 3. Online Exam. I have completed my First test in OCA certification through online. Educational Qualifications 1. Master of Computer Applications (MCA). MaduraiKamaraj University, Madurai. Passed out 2007. 2. Bachelor of Computer Application (BCA). A.P.A.C College, Palani. MaduraiKamaraj University, Madurai. Passed out 2003. Project Work Experience Project #1 Project Name : AIRCRAFT INFORMATION MANAGEMENT SYSTEM Project Details : Customizations / Interfacing Done in Oracle Applications 11i Client : ETIHAD Airways Duration : From October 2007 to till date Team size : 4 members Environment : Oracle 9i, Forms6i. Responsibility : Oracle Database Design & Data Entry forms design. Project Description: Etihad allocates the costs incurred on landing, handling, overflying and airport charges to various locations, cost centers and other dimensions on the basis of rates derived from the data maintained by AIMS (AIRCRAFT INFORMATION MANAGEMENT SYSTEM) on the basis of flight data maintained by it. The forms and reports have been created to enter the flexible rates. Responsibilities: • A new form will be built to enter the DOC rates, view and updates the rates for each month • New Forms to enter and maintain the DOCs Rates • Upload existing Rates into Oracle Applications • Generate the rates automatically for every month • View and modify the rates • Generate exception reports for modified rates • Generate validation reports to ensure that rates are existing for all valid routes/ sectors and aircrafts • Keep audit tables to capture the changes to rates. • Three reports will be created as listed below. • Generate exception reports for modified rates • Generate validation reports to ensure that rates are existing for all valid entries • Generate exception reports on the mass allocation journals created to highlight material variation from previous months journal Contribution: Design, Development, Used the functional document to design application logical and the physical design using PL/SQL and Oracle Forms 6i, Testing and Implementation. Development of Stored Procedures to encapsulate Business processes, triggers, procedures, functions and package.  Table script creation.  Sequence script creation.  Index script creation.  PL/SQL Stored Procedures script creation.  Package specification and Package Body script creation.  Triggers script creation.  Front End designing Using Forms 6i & Report 6i Project # 2 Project Name : Viyasa Smart Accounting System. Client : Viyasa Leasing & Lending Services Role : Team Member Team size : 6 members Environment : Oracle 9i, Forms6i. Responsibility : Oracle Database Design& Data Entry forms design. Project Description: Enter and maintain the business transactions such as Payments & receipts. It enables the business to ascertain the Profit or loss for the period. It enables the business to view the financial position of the business at any cost of time, by using the balance sheet. It consists of Assets and liability. It also shows assets and liability information. Generate the required reports for business. Contribution: Design, Development, Used the functional document to design application logical and the physical design using PL/SQL and Oracle Forms 6i, Testing and Implementation.. Development of Stored Procedures to encapsulate Business processes, triggers, procedures, functions and package.  Table script creation.  Sequence script creation.  Index script creation.  PL/SQL Stored Procedures script creation.  Package specification and Package Body script creation.  Triggers script creation.  Front End designing Using Forms 6i & Report 6i Project #3 Project Name : Customer Maintenance System Client Name : Sands Instrumentation. Chennai. Role : Team Member Team Size : 5 Environment : Forms 6i, Reports 6i, Oracle 8i and Text Reports Project Description: Dispatching CMRI (Common Meter Reading Instrumentation) products to customers and its related reports. Contribution: Design, Development, Used the functional document to design application logical and the physical design using PL/SQL and Oracle Forms 6i, Testing and Implementation. Development of Stored Procedures to encapsulate Business processes, triggers, procedures, functions and package. Project #4 Project Name : Bill Processing System Client : Sands Instrumentation. Chennai. Role : Team Member Team Size : 4 Environment : Forms 6i, Reports 6i, Oracle 9i, PL /SQL Developers and Text Reports Project Description: This system is directly linked with Stores Inventory and Purchase System. The system generates cheques for the bills for the items that comes in stores through MRR’s (Material Receipt Report) and for the service Bills, Entry of Five series, Six series, Seven series Bills (terms used by the company for passing bills), Its daily reports, monthly reports, journal voucher for stores & service, Bills approval at the Works Accountant level. Contribution: System study, design, coding, debugging, adding database security, testing, implementation, documentation and user support for the system. Project # 5 Project Name : Stores Inventory and Purchase System Client Name : Mangalore Shipping Ltd, Mangalore. Role : Team Member Duration : 7 Months Team Size : 5 Environment : Oracle 9i, Forms 6i, Reports 6i. Project Description: The system covers generation and entry of requisitions for Bin Items, the entry of purchase requisitions for Direct Charge Items, Enquiry Entry, Purchase Order Entry, Change Of Orders, Follow-up Letter generation, Goods Arrival Entry, MRR (material receipt report) and SDR (shortage and defective report) generation, Indent valuation, Challan entries and related reports. Contribution: Design, Development, Used the functional document to design application logical and the physical design using PL/SQL. Skills Profile System Analysis, Design and Development • Collecting Client Requirements • Requirement analysis • Proposing System Architecture. • Design and Coding • Unit Testing and System Testing • Application Implementation • Acceptance and Production Support Languages : PL/SQL. GUI Programming : Developer 2000 (Forms 6i, Reports 6i), Visual Basic 6.0 Databases : Oracle 9i, MS Access Tools & Utilities : SQL Loader TOAD (Oracle Application Development) Personal Information Father Name : N. Palanichamy Date of Birth : 07-05-1980 Gender : Male Nationality : Indian Communication Address : NATTUTURAI.P No: 2334, first floor, I Main Road, II Gross Stage, Bangalore – 560017 I hereby declare that above mentioned information furnished is true to the best of my knowledge. Date: NATTUTURAI.P Place: Signature

-start of code- -end of code- &n bsp; Sponsor: ITC Software