| ORACLE PROGRAMMER | ||||||||||||||||||||||||
| RESUME | ||||||||||||||||||||||||
|
|
Padma Koukutla Phone # Off: 610-832-2356 Email: [email protected] Experience Summary Over six years of professional experience in user interaction, systems analysis, design and implementation of many business application systems in Client/Server environment. Very strong in Client/Server architecture, Object Oriented Programming and relational databases. Strong development skills in Oracle, Oracle applications, Sybase, Visual Basic, Crystal Reports, MS Access, SQR. Lead designer of many application systems and the relational databases. Education B S Mathematics Hardware & Software Sun SPARC, RS 6000, UNIX, Sun Solaris, AIX, Windows NT 3.51, Windows 95, Oracle 7.1, SQL Plus, PL/SQL, SQL Loader, SQL Forms 4.5 / 3.0, Reports 2.5, Graphics 2.5, Sybase 10 / 4.9, TSQL, ISQL, MS SQL Server 6.0, Visual Basic 4.0/3.0, Crystal Reports, MS Access 97 / 2.0, SQR 3.0 / 2.0, HP-9000, Oracle applications 10.7.0. Professional Experience Yarway Corporation,Blue Bell,PA Mar.98 to Present Involved in customisation for Yarway Corporation. It was migrated from Mainframes to Oracle as database. Oracle Applications (financials & manufacturing) has been used. I was involved in doing the gap analysis and customisation of reports in manufacturing modules. As per the user request reports have been created and modified. Software & Hardware HP-9000 UNIX, Windows 95, Oracle 7.0 Oracle applications10.7. OSC 161 version 7.6.14 MCI SystemHouse, Harrisburg, PA Aug. 97 to Feb.98 Involved in the development, testing and implementation of Construction Documentation System (CDS) for Pennsylvania Department of Transportation using Developer2000. CDS is designed as a front-end processing system used to interface with ORACLE as database and to document the construction process. It was categorized into several modules like materials, work orders, force accounts, pay rolls, estimates etc. Worked in designing, coding and testing of force accounts and work order modules. Extensively used all the features of Oracle including creating Tables, Indexes, Views, Triggers, Stored Procedures and packages. Exporting/Importing data using SQL loader from the DB2 environment to the ORACLE database. Front end screens were designed using Forms 4.5. Reports were generated using Reports 2.5. Procedures and Functions have been used at all levels. Screen shots have been taken using 'Snag It' and used other features of MS Office Professional Edition for documentation purpose. Software & Hardware IBM PC Compatibles, Windows 95, Oracle 7.1,SQL Plus, PL/SQL, SQL Loader, Developer 2000 (Forms 4.5/Reports 2.5) Computech Inc., NJ July 96 to July 97 Involved in the design, development and implementation of Payroll and Human Resource Management System using Visual Basic 4.0, Oracle 7.1, MS Access 2.D, Crystal Reports and SQR 3.0. Extensively involved in all the aspects of Payroll and Human Resource modules. Some of the modules include pay-slips, salary statements time sheets, attendance, employee personal information, month-end, year-end procedures etc. Job responsibilities include interfacing graphical user interface with Oracle, database design, GUI design, rapid prototyping and generation of listings using APEX DBgrid, menus, user events, MDI forms, functions, coding and testing of the system. On-line reports were created using Crystal Reports and batch processing were done using SQR 3.0. Also extensively involved in the creation of tables, indexes packages, triggers, and PL/SQL procedures in Oracle and also used SOL Loader to import/export data between Oracle and MS Access. Job responsibilities also include backup and recovery of Oracle database. Software & Hardware RS6000, UNIX, AIX, Windows NT, Oracle 7.1 SQL Plus, PL/SQL, SQL Loader, Import / Export, Visual Basic 4.0, Crystal Reports, MS Access 2.0, SQR 3.0 Bull Power Systems, India Sep. 94 to May 96 Involved in the development and implementation of Order Processing System using Oracle 7.0 on a UNIX server. Order processing system is divided into five modules namely Purchase Ledger, Purchase Order Processing, Inventory, Sales Ledger & Sales Order Processing. Sales Ledger module provides information about the customer accounts and to control the outstanding debts. Purchase Ledger provides information about the Suppliers. Inventory module is the base for this system which keeps track of the stock. Sales Order Processing includes Sales Order, Invoice, Delivery Notes etc. Purchase Order Processing includes Purchase Orders, Goods Received Note, Goods Return Note etc. Marketing Information provides all the function to maintain details of the customer, sales analysis and service problems. Job responsibilities include creating tables, indexes, views, triggers, PL/SQL procedures, packages etc. Also extensively involved in the creation of front-end screens using SQL Forms 3.0 / 4.5. Extensively worked on SQL Loader and Import / Export tools to import/export the data and backup Oracle database respectively. Reports were developed using SQR 2.0. Software & Hardware Sun SPARC 10, UNIX, Sun Solaris, Oracle 7.0, SQL Plus, PL/SQL, SQL Forms 3.0 / 4.5, SQL Loader, Import / Export, SQR 2.0 Medwin Hospitals, India May 93 to Aug. 94 Involved in the design, development and implementation of Medical Information system using Visual Basic and MS Access. This system was developed to computerize the patients history, treatment history, employee personal information, payroll, attendance, inventory etc, All the reports for this system were developed using Crystal Reports, Extensively worked on all the advanced features and tools of Visual Basic including Menus, Grids, MDI Forms, modules, procedures, functions etc. Also extensively involved in the import / export of data from and to Access database. Software & Hardware MS Windows 3.11, Visual Basic 3.0, MS Access, Crystal Reports Panyam Cements Ltd., India Feb. 92 to Apr. 93 Involved in design and development of Financial Accounting System using Sybase and UNIX. This is an integrated system, containing Sales, Purchases and Payroll subsystems. This system was developed to handle accounts payable and receivable, petty cash, post dated checks, debit and credit notes. The reports generated by the system include balance sheet, monthly loss/profit statement, payable, receivable, expenditure statement and monthly/yearly budgets. Job responsibilities include creating stored procedures, triggers, tables, indexes, views, rules and defaults. Also involved in the creation of batch reports using SQR 2.0. Software & Hardware SCO UNIX, Sybase 4.9, TSQL, ISQL, SQR 2.0 | |||||||||||||||||||||||
|
|
I will be moving my belongings in shortly.In the meantime why not check out the link below to get your own 10MB of free webspace?www.fortunecity.com | |||||||||||||||||||||||
|
My interests:�Computers/Technology |
|
Favourite links
|
|
| ||||||||||||||||||||
|
This page has been visited
|