Samples represent that of an actual working technical professional found on the WEB and modified to protect the privacy of these professionals. Human names, company names, colleges, software product names are intentionally made up.

Change Your Career in 3 month: Software Testing Training, Internships, Job Placement

ORACLE DEVELOPER

 

CHANGE YOUR CAREER PATH IN 3 MONTH

TRAINING - INTERNSHIP - JOB PLACEMENT

Main page

SUMMARY :

RAO has over 4 1/2 years of experience in the field of software development.

• Expertise in Client/Server technology using Developer/2000 Forms 4.5/5.0/6i & Reports 2.5/3.0/6i as front-ends with ORACLE 7.3/8.0/8i as back-end.
• Good working knowledge on Designer 2000 Rel 1.3.2 and UNIX.
• Good communication and interpersonal skills with good analytic power.
• Learning Cold Fusion 4.5 to work in a forthcoming project.

SKILLS:

• HARDWARE : HP-9000, RS-6000, Sun SparkServer 20, Intel 80x86 based Computers, Compaq Pentium/486.

• OPERATING SYSTEM : Windows NT/95, Windows for WorkGroup 3.11, HP-UNIX, Digital UNIX, Sun SOLARIS

• RDBMS : ORACLE 7.x/8.0/8i

• LANGUAGES : SQL*Plus, PL/SQL, PRO*C, C

• SOFTWARE : Developer/2000[Forms 4.5/5.0/6i & Reports 2.5/3.0/6i], Designer/2000

• OTHER TOOLS : MS Office for Windows 95. PL/SQL Developer

EDUCATION :

• Post Graduate Diploma in Advanced Computer Application from CMC Limited, Calcutta, India 1995/1996 .
• M.Sc. Tech Applied Physics from Calcutta University, Calcutta, India 1994 .
• Diploma in Export Management from Indian Institute of Export Management, Bangalore, India 1995 .

PRESENT EMPLOYMENT :

Technical Analyst in Sheridian Benefits Services, Florida, from 10-Apr-00.

PREVIOUS EMPLOYMENT :

• NIIT Ltd, Calcutta, India, from 01-Oct-97 to 04-Apr-00 as Senior Systems Executive
• UBEST, Calcutta, India, from 10-Mar-97 to 30-Sep-97 as Module Leader.
• McBilly Bharat Engg. Co. Ltd., Bihar, India, from 05-Nov-96 to 07-Mar-97 as Management Trainee.
• HCL HP, Calcutta, from 11-May-96 to 04-Nov-96 as on job trainee.

VISA STATUS : H1-B

PROFESSIONAL EXPERIENCE :

#1 Web Based Enrollment Apr 00 - Till date

Client : Milton Albertson School, QUALXSERV etc.

Environment : H/W - Sun Server, Dell Optiplex - Pentium S/W - ORACLE 8i , Developer/2000 for WindowsNT FORMS 6i, REPORTS 6i , PL/SQL Developer 3.0

Role : Developer

Description : This is a generalized product that will setup various client and their benefits and participants. Depending upon various rules the system will determine which participant is eligible to which benefits. Participant can elect coverages or change election through web.

Responsible For : Backend Programming using Oracle 8i, screen designing using Forms 6i and developing reports using Reports 6i.

Features Used :

• Very high level of PL/SQL programming
• Database Triggers
• Stored Package & Procedure
• Views, Sequences etc.

• Most of the features of Forms 6i
• All features of Reports 6i

#2 Accountant General Voucher Level Compilation AGVLC Sep 98 - Dec 99

Client : The Accountant General Accounts & Entitlement, India

Environment : H/W - Sun Server, COMPAQ DESKPRO - Pentium S/W - ORACLE 8.0 , Developer/2000 for Windows 95/NT FORMS 5.0, REPORTS 3.0, GRAPHICS 3.0 , Designer 2000 Release 1.3.2 32-bit , Windows 95

Role : Team Member

Description : Government of India has employed NIIT Ltd., Calcutta, India, to computerize the working of the state Accountants General offices in the states of the Punjab, Haryana and Himachal Pradesh. The entire product will consist of various modules pertaining to the different section of the A.G Offices. The integrated software will provide all monthly departmental reports and yearly financial reports. So there is a high degree of dependency among all modules to achieve the end objective. The entire workings of the state AG office starting from the initial entry of the vouchers and challans received from the state treasuries and state/central government departments till the final settlement of the accounts and reporting to the CAG at New Delhi will be covered in the scope of the project. The project has comprises of Departmental Compilation activity, Accounting for Public Works and Forest divisions, Accounting for inter state transactions as well as accounting for transactions of the state with Central government departments/Reserve Bank of India, Loans and deposits of the state etc.

Responsible For : High level design HLD , Programming

Features Used :

• Database Triggers
• Stored Package & Procedure
• Views, Sequences etc.

• Very high level of PL/SQL programming
• Dynamic LOV, Programmatically Record Group handling
• Object Orientation using Reference Form
• Developing Forms 5.0 Library to use as common object
• All features of Reports 3.0
• Most of the features of DESIGNER-2000

#3 Sports Facilities Reservation System SFRS Jun 98 - Aug 98

Client : Singapore Sports Board, Singapore.

Environment : H/W - Sun Server, COMPAQ DESKPRO - Pentium S/W - ORACLE 8.0 , Developer/2000 for Windows 95 FORMS 5.0, REPORTS 3.0 & GRAPHICS 3.0 O/S - Sun Solaris, Windows 95

Role : Module Leader

Description : Singapore Sports Board had employed NIIT Asia Pacific Pte. Ltd., Singapore, to study and analysis the existing sports facilities reservation system. Sports facilities Reservation System SFRS will be developed to facilitate the computerized bookings of Singapore Sports Complex SSC facilities for different kinds of customers and different kinds of events. SSC has various types of facilities e.g. Stadiums, Sports Halls, Swimming Complexes etc. which can be booked by various sports associations, Government and private organizations and individuals for different purposes. Each facility may house a number of courts, pools, fields etc. SSC provides the accessories/misc. items required on their facilities to conduct the events that can also be booked by the customers. Apart from that, SSC sells commodities like swim caps, towels, admission tickets to Golf and Gymnasium. SFRS would be able to take care of all such bookings and commodity selling. SFRS would also help SSC to study trends about utilization of their facilities by means of management reports. SFRS will provide a one-stop and cross-center booking of sport facilities.

Responsible For : Study, analysis, requirement analysis RA and high level design HLD

Features Used :

• Triggers
• Stored Procedures
• Views, Sequences etc.

• Very high level of PL/SQL programming
• Dynamic LOV, Programmatically Record Group handling
• Object Orientation using Reference Form
• Library
• Multiple Form and MDI applications
• Security Features using Menu Roles

#4 Geuters Purchase Planning & Equipment Tracking System Oct 97 - May 98

Client : GEUTERS Asia Pte. Ltd., Singapore.

Environment : HP-UX UNIX , AIX Ver 4 , Digital UNIX, Windows 95 Oracle 7.3, Developer 2000 for Windows 95 & Digital Unix, FORMS 4.5, REPORTS 2.5, PRO*C

Role : Module Leader of Equipment Tracking System ETS

Description : Geuters Asia Pte Ltd, Singapore, world famous news agency, had employed NIIT Ltd, Calcutta, India, to develop an integrated system comprising of Equipment Tracking System ETS and Purchase Planning System PPS in ORACLE 7.3/Developer 2000. Equipment Tracking System ETS deals with the equipment movement among various centres. This movement is recorded by the various transaction documents. Equipment Tracking System ETS will handle In-house and Subscriber Opening Balance Maintenance & Opening Balance Closing, Batch Transaction, Opening Balance Adjustment, General Adjustment, Batch Transaction Posting, Month End Processing, Fixed Asset Relocation of equipment among various Centres & Locations. This system will generate various MIS reports as well as transaction reports. This system allows users to create & revoke user, take backup and perform many other necessary administrative activities.

Responsible For : As a team leader I was responsible for technical assessment, planning & scheduling, analysis, design, development, user acceptance testing UAT , implementation, training and technical support.

Features Used :

• Triggers
• Stored Procedures etc.

Used almost all important features. Some of the advanced features are mentioned below:

• Object Oriented Programming through the Use of Reference Form
• MDI application with multiple window interfaces
• Generation Of Forms 4.5 from Forms 3.0 etc.
• Designed highly complicated Reports using all important typical features Of Reports 2.5 like Placeholder & Formula columns, conditional Report Layouts, Group filters etc.
• This system was designed to run in UNIX platform.

#5 Computerized Maintenance Management System CMMS Apr 97 - Sep 97

Client : Visha Martin Industries Ltd., Jamshedpur, India.

Environment : HP-UX UNIX , AIX Ver 4 , Digital UNIX, Windows 95 Oracle 7.3, Designer/2000, Developer 2000 for Windows 95 & Digital Unix, FORMS 4.5, REPORTS 2.5, PRO*C

Description : Visha Alloys & Steels Division, Visha Martin Industries Ltd., Jamshedpur, comprised of four plants, namely Mini Blast Furnace MBF , Steel Melting Shop SMS , Wire Rods Mill WRM and Captive Power Plant CPP had employed UBEST to develop integrated information system for the maintenance activities of the entire organization using client/server technology. This will help maintenance team to organize, plan and monitor maintenance activities of four plants to increase equipment reliability, productivity and to increase profitability. CMMS was a total on - line computer software solution encompassing all the Maintenance activities e.g., Preventive, Corrective, Predictive & Breakdown Maintenance, Shutdown, Overhauling, Condition Based Monitoring etc. This project was developed to cover all the main activities of Maintenance Management, Stores, Purchase and Quality Assurance such as Maintaining Standards Register, Planning, Scheduling, Job Order Generation and Monitoring, Work Order Generation and Monitoring, Equipment Breakdown, Spare Parts Manufacturing & Conditioning, Materials Inventory & Control System, Purchase, Maintenance Information Management.

Responsible For : Preparation of guidelines for low level design LLD and high level design HLD , unit testing, integration testing, study, analysis, design.

Features Used :

• Triggers
• Stored Procedures etc.
• Views

DEVELOPER/2000 :

• Functions and procedures
• Almost all important Form triggers and Built-in packages.
• MDI application with multiple window and canvas interfaces
• Report triggers etc.

#6 Integrated Sales & Marketing System ISM Nov 96 - Mar 97

IN-HOUSE PROJECT

Environment : DRS 6000 UNIX SVR 4.2, PC-486, Windows3.1, DOS 6.22 Oracle 7.0, SQL Plus 3.1, PL/SQL 2.1, SQLForms 3.0, SQLMenu 5.0, SQLRep 1.1., PRO*C

Description : The objective of the project was to develop properly integrated information system for Sales & Marketing department. This system would take care various activities like Accepting Customer Purchase Order, Customer History Maintenance, Comparative Quotation Study CQS , Customer Feedback, Customer Follow-up, Analysis of Lost Order, etc. This project was developed to handle all the activities regarding sales and marketing and streamlines the information flow between various departments and management. This system generates various daily/weekly/monthly transaction reports as well as MIS reports.

Responsible For : System Study, Analysis [SRS], Design [SDD], Coding, Unit Testing, System Testing, Implementation and Documentation.

Features Used :

• Database Trigger
• Stored Procedures
• View, Sequence

• Used all features

#7 Computerized Integrated Manufacturing and Allied Systems CIMAS May 96 - Oct 96

Client : McBilly Bharat Engg. Co. Ltd., Bihar, India.

Environment : DRS 6000 UNIX SVR 4.2, PC-486,Windows3.1, DOS 6.22 Oracle 7.0, SQL Plus 3.1, PL/SQL 2.1, SQLForms 3.0, SQLMenu 5.0, SQLRep 1.1., PRO*C

Description : This was a Comprehensive Project meant for Integrated On-line computerization of a Jobshop Type as well as standard products Manufacturing Company. This was a total on - line computer software solution encompassing all the activities of a manufacturing unit like Accepting Customer Inquiry, Equipment Quotation Generation, Bill of Materials Preparation, Estimation, Sales Order Generation, Production Planning, Job Scheduling, Job Order Generation, Inspection, Purchase Order Generation, Despatch, Vendor Rating, Material Management, Payroll etc. This project was consisted of 10 modules - Engineering, Estimate, Purchase, Stores, Inspection & Quality Assurance IQA , Production Planning & Control PPC , Despatch, Finance, P & A and Payroll. This system was developed to streamline the organization s information flow and to eliminate many of the redundant manual operations. Provisions were made to provide all necessary MIS reports and to prepare and maintain ISO-9001 documents.

Responsible For : System Study, Analysis [SRS], Design [SDD], Coding, Unit Testing, System Testing, Implementation and Documentation.

Features Used :

• Database Trigger
• Stored Procedures
• View, Sequence

• Used all features

REFERENCES

ADDITIONAL INFORMATION

Awarded National Scolarship in Higher Secondary Examination 10+2 from West Bengal, India in the year of 1988.

Awarded National Scolarship of Government of India on B.Sc Physics Honours in the year of 1991.

Up

Visa Status : H1B held by CiberWay Inc., Open for both Contracting & Permanent Offer. Rate 35 dollars per hour for NYC/NJ.

Technical Summary:

Over 12 years of IT experience with strong Database Development of business application software using Oracle tools i.e. Developer 2000, Oracle Financials 10.7 to 11i and Data Warehouse, Business Intelligence with Discoverer 3i, 4i and COGNOS, Impromptu. 4 years of Oracle Financial 10.7/11i. General Ledger, Financial Statement Generator, Accounts Receivable, Accounts Payable, Order Entry, Order Management, Fixed Asset, Purchasing, iProcurement, Oracle Workflow, Application Object Library, XML Gateway & Oracle EDI e-Commerce Gateway, Discoverer 3i,4i . Including 4 years of Manual Testing, designing and developing test methodologies and test plan .

Implemented full life cycle project in iProcurement and core purchasing modules and carried out end to end integration between iProcurement, Core purchasing, Payables, Fixed assets and General Ledger. Experience in preparation of test cases, application testing Implemented full life cycle and upgrade projects. Strong PL/SQL coding experience using packages and stored procedures. Two Years of Discoverer 3i/4i Administrator and User Experience, including maintenance of Business Area and Work Book. Conversion of Oracle Financial 10.7 to 11i Developer 2000 and Oracle 7.3 to 8i Forms 4.5, Forms 5.0,Forms 6.0, Forms 6i and Reports 2.5, Reports 3,0, Reports 5.0, Reports 6.0,Reports 6i and Oracle Discoverer 3i, 4i Data Conversion with SQL Loader ver 7.3,PL/SQL ver 2.3.4

Technical Skills:

• Oracle Tool: Oracle 8i/8.X/7.X, Developer 2000 Forms 6i/6.0/5.0/4.5 and Reports 6i/6.0/3.0/2.5 , Designer 2000, SQL PLUS 8/3.3, SQL*Loader, Oracle Discoverer 3i

• Languages: PL/SQL, Pro*C, FoxBASE, Clipper.

• Operating System: Windows NT/98/95, Windows 2000, Unix and DOS 6.x

• Hardware: IBM PC compatible with Intel Pentium

• ERP: ORACLE Financial 10.7/11i.

PROFESSIONAL EXPERIENCE:

Developed interfaces in Oracle Purchasing and iProcurement.

• Upgradation of 10.7 to 11i and implementation of Self Service Purchasing 5 SSP5 Oracle Purchasing and iProcurement, Workflow.
• Implemented the upgrade project from Oracle financials 10.7 to 11i in a multi org, multi currency environment. Implemented an integrated iProcurement module SSP5, AP, PO for providing web enabled inquiries for merchant purchase orders, inventory availability and vendor purchase orders.
• Configured the set ups and validated the set ups in core purchasing and iProcurement modules and carried out end to end integration between iProcurement and GL modules.
• Carried out edi Gateway implementation for catalogue import and defined the code conversion values between the external suppliers system and Oracle Applications
• Created PO Approval hierarchy as per user requirements. Configured the workflow for requisition and PO approval including configuring the workflow process, mailing notifications and setting the profile options for iProcurement and auto creation of purchase orders during requisition import.
• Carried out initial catalog import and defined the mappings between catalog service providers and Oracle Purchasing. Setup various Account Regions, Procurement cards, attachments, catalog types, internal and external source catalogs. Performed application set up for AP and PO.
• Setup organizations and set of books in a multi org structure, including carrying out consolidation and translation in primary and reporting set of books before switching to multi org. Imported requisitions using Core Purchasing interface tables.
• Created template expense reports, enabled descriptive flexfields in the Excel spread sheets, customized documentation and messages by modifying the standard help files for the self-service expense module. Customized the Workflow process of expense reports by modifying existing procedures and developing new procedures in the Web Expense PL/SQL packages.

Loading the following through Oracle e-Commerce Gateway.

• PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, V_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE.
• Loading Some of the table using XML Gateway.
• Defining Suppliers Supplier Performance Evaluation
• Defining Items Locations, Organizations, Unit of Measure etc.

Developing and Customizing Impromptu Reports:

• Customized data by adding calculations, summaries and functions.
• Queried from different database tables as per the requirement.
• Using Portfolio, reports were presented Created List Reports and Cross Tab Reports and Drill Through reports.
• Created the Business Mix report and Top Ten reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created reports in HTML format for easy navigation of data from web browser.
• Created standard and Ad hoc reports using Cognos Impromptu tool.

Discoverer 4i Administrator Responsibility

• Identifying User requirements.
• Building useful and robust business area choosing the database tables that best meet requirement.
• Control User access to business area.
• Creating usable relational structure in EUL with joins and complex folders.
• Creating Summary tables to improve performance.
• Scheduling workbooks for a user or role.

Discoverer 4i User Responsibility

• Building Workbook in Discoverer 4i and edited the existing workbooks; adding/editing worksheets.
• Defining calculations, Formatting worksheets.
• Pivoting data, Applying exceptions.
• Creating/editing graphs.
• Creating/editing parameters.
• Preparing Reports for printing, Sending Reports with emails, Scheduling Reports.

Environment : Oracle 8i, Oracle Financial 11i,Oracle Purchasing, Oracle SSP5, Oracle iProcurement, Oracle Workflow Builder, Discoverer 4i, COGNOS, Impromptu.

Boston Speakers is a company involved in manufacturing Speakers for Audio systems Stereo, TV, Car etc .

Responsible for the development and testing of FSG reports in version 11i of Oracle Financials.

• Summary Balance Sheet.
• Summary Income Statement,
• Detailed Balance Sheet,
• Internal Net sales,
• Internal Quarterly/Monthly Operating Statement.
• Marketing Department Detail.
• Manufacturing Department detail
• Internal Monthly Cost of Goods Sold Statement.
• Cash Flow Statement.
• Summary of Total Manufacturing.
• Summary of total G & A
• Summary of Total Engineering
• Summary of Total Sales & Marketing.
• Columnar Income Statement OEM & Core
• Columnar Income Statement OEM etc.

Developed interfaces in Oracle Purchasing in Oracle Apps. 11.5.4.

• Loading the following through Oracle e-Commerce Gateway. PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE.
• Loading Some of the table using XML Gateway.
• Defining Suppliers Supplier Performance Evaluation
• Defining Items Locations, Organizations, Unit of Measure etc.
• Purchase Requisitions import, Creating Requisitions using templates.
• Creating internal requisitions, Auto creating requests for quotations
• Managing Standard P.O., Blanket Purchase Agreements, Planned and Contract P.O., Auto creation of P.O.
• Managing P.O. Receipts, Defining document security.
• Customization in Work Flow
• Customization of Oracle forms & Reports of Purchasing module.

Oracle iProcurement 11.5.4 setup & Oracle Workflow.

• Configuring Account Region, Defining Information templates, Realms, Setting up Procurement Cards, setting up attachments, profile options.
• Loading cataloge data from internal and external sources.
• Customizations of iProcurement Workflows like P.O. Requisition Approval, P.O. Doccumnt Creation, Account Generator, P.O. Send Notifications, Confirm Receipt workflows.
• Created Workflow process definitions by using Oracle Workflow builder like Item types, lookup types, messages, Activities, Attributes and roles.
• Defined Standard API s for PL/SQL procedures.
• Customized Oracle default workflow API s.

Environment : Oracle 8i, Oracle Financial 11i, General Ledger FSG Financial Statement Generator , Oracle Purchasing, Oracle iProcurement.

Toysrus.com is the Internet division of Toys R Us. It sells toys through Internet in collaboration with Amazon.com. This company sends the toys to the warehouse of Amazon.com. Amazon.com sells the toys to customers through Internet.

There was Oracle Apps 10.7. That was upgraded to 11i.

Some of the forms were upgraded using flint 60.All Customized reports has been converted to 11i using Reports 6i Some of The Report Names: PO Summary, Open Requisition /PO Reports, GL Accounts Summary.

Responsible for the in-house development of the package including the Accounts Receivable, Purchasing and Payables and Order Management of Oracle Financials. The design was standardized with template forms, Tool Bar, Menu, Library and database packages and procedures. Responsibilities included modification of the existing forms and reports and registering those in Application, using Application Object Library of Oracle Financial, solving user vantives for existing forms and reports.

This development work was done using Oracle Forms and Oracle Reports and Application Object Library of Oracle Application, PL/SQL and registered in Application. Also written packages and procedures, which are linked with the forms and reports.

Order Management Project : Setting up Oracle Order Management including Profile Options, Enabling Order Management Parameters, Defining taxation rules, Quick codes, Freight and special charge types, Credit types, Price lists, Price agreements, Shipping tolerances.

Loading the following tables through Oracle e-Commerce Gateway : OE_HEADERS_INTERFACE,OE_LINES_INTERFACE,OE_CREDITS_INTERFACE, OE_CREDITS_INTERFACE,OE_PRICE_ADJ_INTERFAC,OE_LOTSERIALS_INTERFACE

Managing Orders: Entering sales orders, Closing orders, Scheduling orders, Copying sales orders, Entering returns, Canceling orders and returns, Applying and releasing holds, Pricing orders, Item cross referencing, Outbound purchase order acknowledges, Scheduling order concurrent program. The forms of the above screens were modified .

Modifying standard reports as per users need: Comprehensive order detail report, Sales Order acknowledgement report, Sales orders and purchase order discrepancy report, Order discount detail and summary report, Unbooked orders report, Returns by reason report, Salesperson order summary report, Defaulting rules listing report.

Discoverer 3i Responsibility

Used Oracle Discoverer 3i for building new workbooks, modifying existing workbooks. Used most of the Discoverers features for the Management Analysis. Such as pivoting and drilling up and drilling down data. Creating graphs and preparing reports for printing. Scheduling reports and shared the worksheets with other users. Created parameters and conditions for the worksheets. Sending Reports to management personnel via email.

Environment : Oracle 8i, SQL/Loader, Forms 6.08, Reports 6.0, PL/SQL 2.3.4, Oracle Designer 2000, Oracle Financial 11i G.L., A.R., AP, PURCHASING,ORDER MANAGEMENT, Oracle e-Commerce Gateway , Oracle Discoverer 3i, Windows 2000/98, Unix.

Center for Claims Resolution CCR is a company formed by eighteen companies, who sells Hazardous materials and chemicals. People who suffer from these materials and chemicals Files law suit against these companies. CCR settles these claims with some amount of money and avoids the lawsuit procedures.

Project: The task is to migrate the operations with the objective of optimal modifications in existing business processes and help the incoming unit to fit into corporate business practices and set up specific to Accounts receivable.

• Analyze the requirements of the corporate unit about safeguarding the resident data against the incoming data and users. As a switch over to multi org is not feasible a work around through Folder security has been suggested and to be implemented
• Analyze the business practices of the migrating unit, study the business practices of the corporate unit and perform Gap Analysis.
• Suggest the optimal operating practices and participate in the process of merger of the two units from Oracle Receivables point of view.
• Troubles shoot the problems in the modification of standard and customized Oracle Receivables reports.
• Analyzed the business process and collected the test cases. Executed the test cases as per the schedule. Performed Unit test and Integration test. Directly interacted with the end user and was responsible for user acceptance.

Environment : Oracle Designer 2000, Oracle 8i, SQL/Loader, Forms 4.5, Reports 2.5, PL/SQL 2.3.4, Oracle Financial 11, Windows NT/95, Unix.

As a senior Programmer/Analyst, involved in the development of Beneficiary, Medical Service Providers, Contact Tracking System, in short BPCT using Oracle Financial 11.0 AR , Designer 2000 and Developer 2000 Forms 5.0/Forms 6.0, Report Builder 3.0/Report Builder 6.0.

The Beneficiary, Provider and Contact Tracking system is complaints, grievance logging and maintenance application to assist Michigan Department of Community Health to function well and provide better customer service for their Medicaid and Health care Beneficiaries.

Major components includes Data Modeling, User and System Requirement analysis, Application and Systems Design using ORACLE Designer 2000, Developer 2000 for Forms and Reports and EDI Gateway interface with Bull mainframe to fetch the existing Beneficiaries, Providers and Health Plan information using C program to access GTEA Bull mainframe gateway, Oracle External Procedures and Stored procedures to capture the stream data passed.

Highlight of this application is the Online Interface with Oracle and Bull Mainframe and was successfully implemented in Michigan Department of Community Health MDCH for the first time and this has created more opportunities for the client to develop and implement more new Oracle Projects without migrating their existing and other mainframe applications.

Other responsibilities include Data loading and conversion to oracle from other products. The source data were in FoxPro. Programs were written in FoxPro to clean the data. Then, those data was transferred to Oracle Table through SQL Loader. Now, It was found that there is no key item in the data. So the data was sent to Bull Mainframe through GTEA / PL/SQL programs to fetch the key items by matching First Name and Last Name. We got multiple records from Bull Mainframe. Those data were loaded in Excel Spread sheet and sent to the end user to pick one record out of those multiple record. This clean record was again loaded to a Temporary Table in Oracle. From this Temporary table, the data was distributed to different working tables through PL/SQL.

Environment : Oracle 8.0, Oracle Financial 11.0, SQL Loader, Forms 5.0 / Forms 6.0, Reports 3.0 / Reports 6.0, PL/SQL 2.3.4, Oracle Designer 2000, Oracle Developer 2000, Windows NT/95, EDI Gateway.

As a senior Programmer/Analyst and ERP consultant, involved in the development of General Ledger Reports, using Financial Statement Generator.

Responsibilities included defining Row sets, Column sets, Content sets, Display sets, Row Orders and analyzing the business functionality. Coding and testing all financial calculations involved in the reports such as

• Cost of Goods sold,
• Cost of Production,
• Controllable Cost Detail,
• Advertising Summary,
• Greyhawk Penny Report,
• National Net Revenue,
• Income statement,
• Expense Statement,
• Budget vs. Actual by Prime,
• Custom General Ledger Detail,
• Profit and Loss Summary,
• Balance Sheet,
• Tax Q-21 and some others.

Other responsibilities include Data loading job; i.e. Loading GL_INTERFACE table from a flat file. Development of new programs using PL/SQL, Reports 3.0 and Forms 5.0, packages and procedures. Besides this, has maintained AR package. The responsibility was changing the existing forms and reports of customized Accounts Receivables.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Oracle Financial 10.7, Financial Statement Generator, Windows NT/95, Unix

ABC Software, Inc is a Houston based Software Consulting/development Company provides Various services such as Database optimization. It has clients in all over world 50 countries .

To keep track of the sales and after sales services, The Company has developed an account package in Oracle Financial 10.7. I was involved with Accounts Receivable system. Apart from Oracle Corporation s fixed modules, the company has added its own modules like Revenue accounting, billing, licensing etc. The design was standardized with template forms, Tool Bar, Menu, Library and database packages and procedures. Responsibilities included modification of the existing forms and reports and registering those in Application, using Application Object Library of Oracle Financial, solving user vantives for existing forms and reports. The development work includes new forms and reports like

• Revenue Recognition Summary State Wise ,
• Credit Memo for converted Invoices,
• List of Orders not billed
• Four types of Invoice Register.

Designed and developed test methodology and test plan and test schedules. Analyzed the business process and collected the test cases. Executed the test cases as per the schedule. Performed Unit test and Integration test. If any discrepancy, discussed with the design team and re-implemented with the modified programs.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Designer 2000, Oracle Financial 10.7 AR, AOL , Windows NT/95, Unix.

As a senior consultant for Torren Standard, involved in design, development and Implementation of Flight safety parts system. It is a quality control system dealing with various part numbers, their characteristics, and safety category, model no. and other details for the parts used in space shuttle of NASA, helicopter and airplanes. Used Designer/2000 extensively during design phase of the system.

Responsibilities include all master file maintenance of safety history records, entry edit and query screen and overall project management. Designed the screens in Forms 4.5 and written all the triggers and procedures required.

Environment : Oracle 7.3, SQL/Loader, Forms 5.0, Reports 3.0, PL/SQL 2.3.4, Designer 2000, Oracle Financial 10.7, Windows NT/95, Unix Server.

As a lead, developed General Financial Accounting system for VideoElectronic Services Limited, a leading manufacturer of large-scale electronic products. Responsibilities included maintenance of various masters, sales/receipts transaction, sales/receipt register bill printing, dealer wise aging report, product category wise report, ledger printing, reminder to debtors, stock list printing.

Developed a system to handle the Customers/share holders letters and action taken by the company. Responsibilities include feasibility study and need analysis, design, coding, testing and quality assurance of various data entries and reporting module. Also, performed code walk through of fellow team members while managing a team of 10 programmers.

Developed Investment Accounting System to keep track of the various investments made by the company in the industrial sectors. The system consists of various module such as bill discounting, inter corporate deposits, hire purchase, lease finance, properties, investments, equity shares and debentures, daily payment reporting and voucher printing. Developed Share Debenture, Public Issue system to manage large and small public issues of a company. The system includes development of data entry programs, reporting required by Securities and Exchange Board of India, Certificate and Dispatch Report Printing, Bank Reconciliation reporting, Allotment Register, Refund Register and online queries.

Developed Share sub broking system to manage the customer query matching i.e. the sale and purchase of a particular script between the customer club, share purchase /sale entry, receipt entry bill printing and outstanding reporting.

Environment : Oracle 7.0, SQL/Loader, Forms 4.5, Reports 2.5,PL/SQL 2.3.4, Designer 2000, Windows 95, Novel LAN 3.1

As an analyst, developed Flat Sales System for Lodha Group to manage the Flat Sales activities to the customer. This system is used to collect installments from the customers and processes receipts, Invoice Printing, payment notice, customer wise outstanding reports are processed using these systems. Responsibilities included analysis, coding and quality assurance of the various modules such as Building Master Maintenance, Installments Entry, Receipts, Notice Printing and user training.

Environment : Oracle 6.0, Pro*C, SQL*PLUS, Novel LAN 3.1, DOS 6.x

As an analyst, developed Inventory Control System for Konkan Synthetic Fiber to manage the warehouse activities of cotton, thread and clothes. Responsibilities included analysis, coding and quality assurance of the various module such as Purchase Order and Issue slip entry, Inter warehouse transfer entry, Master maintenance and stock reports.

As a programmer, developed Financial Accounting System for Virash Diamond Company and Humphrys & Glasgow. Responsibilities included coding and quality assurance of the various modules such as maintenance of Department master, Customer master, General ledger, Sales register, Purchase register, Profit & Loss account, Trial balance, Balance sheet and Age wise customer outstanding report. As a programmer, developed Diamond Manufacturing System for Virash Diamond Company. Responsibilities included maintenance of Master and Transaction file, Export details report and Weight Loss report. As a programmer, developed Container Activities System for Kaybee Marine Pvt. Ltd. Coded and implemented data entry of Import and Export manifest, detention and transport charges, Billing and general ledger.

EDUCATION:

Bachelors Degree in Science, India
Diploma in Computer Science, India
Certificate Course in UNIX, Microsoft C, Oracle 5, Forms 2.3, Pro *C, India
Certificate Course in Oracle 7.3, Developer 2000 from Concourse Information Tech., India
Certificate Course in ORACLE FINANCIAL 10.7 from Concourse Information Technology, India
Certificate Course in Data Warehousing ERWIN, Cognos, Informatica, Business Objects, Data Junction, Microstrategy

Up

Technical Summary:

• 10 years experience in developing full life cycle systems.
• 9 years experience as a DBA/developer/Data warehousing
• 5 years experience in developing web applications.
• 3 years experience in a Lead Technical Role.
• Over 9 Years both in Oracle and UNIX Development Experience

These include Billing and Rating, Manufacturing, Financial and Project Accounting Systems. Application software expertise includes strong programming skills using Oracle, PL/SQL, Oracle Forms, Oracle Reports, Oracle Web Server, Pro*C, Data Warehouse, SYBASE, T-SQL, C, C++, Java, JavaScript, ASP. Developed numerous UNIX shell scripts to automate backup and recovery of ORACLE and SYBASE databases. Strong report writing skills using SQR and ORACLE Reports. Developed a Reporting module, which involved creating 165 major business reports. Performed extensive Oracle and Sybase Database Administration. Thorough understanding of Project Accounting and financial applications.

Technical Skills:

• Client/Server: Oracle 7.3, Oracle 8i, Oracle 9iAS, PL/SQL, webdb, SQLPlus, Pro*C, Developer 2000, Designer 6i, Designer 2000, Oracle Forms/Reports 6/6i , SYBASE, T-SQL, APT-SQL, VB 5.0, SQR, FRX, SQL*Loader

• Web Development: Oracle Web Server, Java, JavaScript, HTML, ASP, Visual Interdev, CGI, Perl, and WebSQL

• Programming Languages: C, C++, Unix, Java, Perl, RS/6000, HP9000, DOS, Windows 3.1, Windows 95, and Windows NT

Technical Experience:

Responsibilities:

• Used Oracle Designer 6i to perform data modeling.
• Documented Tech Specs for the proposed data base design.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Performed the set up the VSS source code architecture for the client.
• Performed code reviews.
• Used SQL Navigator to reverse engineer the model of the legacy applications.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

Tools/Environment: Sun Solaris, Oracle 8i, 8.0, 7.3 , Oracle Enterprise Manager, Developer 2000, Actuate, SQL, PL/SQL, CGI & Perl

Data Modeling

• Performed extensive data modeling using Designer 6i for the data warehousing application.
• Primary tasks accomplished using Designer 6i include:
• Modeling the business requirements
• Diagrammatic representation of business processes
• Define and represent entities, functions and flows between the entities
• Using the transformers to generate initial designs
• Re-visit the proposed/implemented designs to improvise/change existing business requirements.

Data Warehousing

• Designed the data warehouse application. Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Developed test plan, test cases and test scripts to thoroughly test the data warehousing application.
• Developed Actuate Reports and Oracle Reports to fulfill the reporting needs of the users.
• Developed webdb codes to web enable reports.
• Used XML to display the reports/forms.
• Developed several front-end screens using Forms 6i. Used OLE objects to facilitate the uploading/downloading of spreadsheets/datafiles between forms/reports and the network drives on users PCs.

Database development

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations
• Used Informatica s power mart to link different data sources.

Database Administration

• Installed and configured oracle 7.3 and oracle 8i.
• Configured tnsnames and Sqlnet files
• Created instances, schemas, users, profiles and roles.
• Managed users, privileges and roles

Completely designed and developed the Oracle 8 based database application for Sun Microsystems. This database serves as a storehouse of information for Sun Microsystems for their financial and accounting information. This database is primarily used by the accounting departments of Sun to make journal entries, keep track of account payables and receivables, and make journal postings to the General ledger.

The database consists of about 1000 base tables and several views, Procedures, packages, triggers. Coded several stored procedures, triggers and packages to incorporate the business logic into the application. Used Oracle DBMS packages to carry out dynamic SQL processing. Developed generic Oracle functions for business computations. Performed query analysis and enhanced Query performance by taking advantage of Oracle s indexing features and table partitioning features. Developed SQL Loader scripts to load flat files into Oracle database. Scheduled Cron jobs to perform automatic extraction of the data. Developed Oracle reports using Reports 2.5.

Responsibilities also included:

• Formulating
• Writing scripts to create tables and views
• Developing PL/SQL procedures, packages, triggers, functions
• Developing Kshell UNIX scripts to import, export operations
• Monitoring the query performance using explain plans
• Developing Oracle reports

Tools/Environment:
Oracle 8.0 was used as the backend for this system. Used constraints as well as triggers to enforce the referential integrity. The front end screens were developed in. Developed Java application to enhance the capabilities of the system. Front-end validations were handled by JavaScript while the server side validations were carried out using VBScript.

Involved in the design and development of the new Service order entry module of AT&T local services. This module serves as a tool for AT&T local services to create and manage the service plans of the customers. This system can be used to view existing service plans, accept new customer orders, and modify service plans. The backend database used for this application is Oracle 8.0. Developed several PL/SQL stored procedures to carry out the backend processing.

Performed table layout analysis and design with emphasis on referential integrity. Developed scripts to create the tables in Oracle. Developed PL/SQL routines to extract data from VMS database and load it into the Oracle database.

Performed performance tuning of the overall system by eliminating redundant joins, creating indexes, removing redundant code. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases. Monitored user profiles, roles and privileges for the Sybase database.

This web enabled part of the billing and rating module enables the customers as well as AT&T employees to view the previous bills, run reports, check account balances etc. Used JDK1.2 to develop the applications. JavaScript was used to perform the client side validations.

This utility was developed completely in Perl and C. The raw data is captured from existing AT&T billing files and then the date fields were aged.

Application Development

Developed a new FINANCIALS module for Yokogawa Industrial Automation, Inc. This entire system was developed in ORACLE 7.3. Coded several stored procedures, functions and triggers to process the financial transactions. Developed screens for the end users to access these processes. These screens were developed using Forms 4.5. Also provided Internet and intranet access for the users to access these screens. Performed web programming using Oracle Web Server to make these forms web compatible. Used SQL*Loader to load flat files into the database. Developed UNIX scripts to automate some of the batch processes. Developed several reports in SQR and ORACLE Reports. Some of these reports include Financial Account Activity, Trial Balance, and Audit Trail Activity etc. Developed UNIX cron jobs to run these reports on a nightly basis. This financials module comprised of the Accounts Payable, Accounts Receivable and General Ledger sub Modules. Some of the main transactions include:

• Creating and approving AR invoices
• Creating and approving AP invoices
• Posting invoices to sub ledger
• Consolidating sub ledger entries and posting to General Ledger
• Payment of checks

Reports Module

Developed several reports about 165 to be precise using SQR and also Oracle Reports. These reports provide the user detailed as well as summarized information of different transactions belonging to different Modules. These reports include daily downloads, normal hard copy print outs, as well as user initiated dynamic web reports.

Developed a new Web Based reporting system that interfaces with Oracle 8.0 server. This developed reporting system uses SQR to interact with Oracle 8.0 server. The retrieved results are then formatted into a web compatible screen. The entire web development for this reporting system was carried out on Oracle s web server. Several Perl, CGI, JavaScript scripts had to develop to achieve this.

Inventory Management Module

The objective of developed module is to enable the Organization to manage its inventories on both quantitative and qualitative levels. The Inventory Management process supports the Inventory Production and the Order Entry processes by providing critical information on the current levels of finished goods.

• Data Modeling
• Database Design
• Tables Layout Design
• User Requirement Study
• Designing User Interface
• Coding PL/SQL Procedures, Functions, Triggers

Developing Screens

The entire system was developed using Oracle 7.3, Developer 2000, and Forms 4.5, Oracle Reports on UNIX platform. Some of the tasks accomplished by this module include ability to create inventory part definitions and stocking locations, ability to retrieve availability information, perform inventory movements, and setup replenishment Processes etc.

Developed scripts using Perl 5.0 to automate the interfacing between different platforms. These scripts run the nightly batch processes required to carry out the routine posting of the financial transactions. Also these scripts make use of the extensive formatting capabilities provided by Perl to import and export the daily downloads.

UNIX Scripts - Worked extensively on the UNIX platform. Developed several UNIX scripts mainly in K shell. These scripts were developed to Perform several different tasks.

Developed UNIX scripts that automate the process of the posting the Inventory transactions to the General Ledger Developed UNIX script that prints the financial reports automatically on a daily, weekly and also monthly basis. Developed several scripts that facilitate the source code control for Oracles procedures. These scripts perform version control as well as source code control

Data Warehouse Design

This application serves as a storehouse of information for the client. The system was developed using Oracle Web Application Server 3.0, Oracle 7.3, Forms 4.5, Oracle Reports, Oracle Graphics, and OLE Embedded Objects. Developed about 30 PL/SQL stored procedures and functions to process the data based upon the user requests. Developed Pro*C and UNIX routines to load the data into the warehouse on a nightly basis. Used PL/SQL cursors to process the rows one at a time. Used SQL*Loader to load data in flat files into tables.

Responsibilities included requirements gathering and analysis, rapid Application development, development of a decision support framework Subject area modeling driving toward measure/dimensional modeling , and source system/data store analysis. Also responsible for the development of audit procedures and process for the loading of the Data Warehouse.

Developed an application serves a tool for Vendors in maintaining their U.P.C. catalog Developed web based on-line Vendor Catalog Maintenance for Vendors. This information. The Vendor would be able to load/modify U.P.Cs in the catalog.

This application also provides vendors with an ability to maintain access to retailers and also maintain their account information. This application was aimed towards major Vendors such as Sears, Dillards etc., a Sybase Product, as the database interface to interface with DB2 and Sybase Servers. The developed WebSQL HTML files execute a large number of Perl scripts. These Perl scripts were developed essentially to access and format the data that has been retrieved from the server using WebSQL. This application, due to the complexity involved, uses a large number of front-end validations. All the front-end Form processing/validations were carried out using JavaScript.

Performed intensive testing of various functionalities of Sybase SQL Server 11.

Responsibilities Included: Formulating assertions These are normally based upon the documentation provided by Sybase to its customers. The test developers would then develop code to test these assertions.

These developed strategies would then be used by test developers to develop the test code.

• Developed numerous scripts to test different functional aspects of SQL
• Server using the formulated assertions and underlying strategy pertaining to the assertion.

These test scripts were developed using Tcl Tool Command Language in conjunction with a testing environment called QuaSR Quality System Reengineering developed internally at Sybase.

These self-analyzing tests intelligence and analysis provided in the test scripts itself also ensure easy readability, easy maintenance and provide enough diagnostic information in case of test failure. Reporting bugs in case of any test failures encountered using a standard Bug Tracking System.

UNIX Experience: As part of the job duties at Sybase Inc., developed several UNIX scripts. These scripts were essentially developed to perform source code control of the code.

Designed and developed an On-Line Purchase Parts Maintenance system for the accounting department of B&W. This system serves as a tool for the management to track the purchase requirements for different departments, track quotations, generate batch reports of comparative statements, invoice discrepancies, purchase orders and scheduling payments. The developed system was also linked to the inventory management and financial accounting departments. This system was developed using SYBASE on UNIX with APT-SQL as the front-end. Coded routines using SQR to generate the batch reports for this system. Extensively involved in the CIIM 9.0 Foundation Project. The main aim of this project was to optimize the performance of the system to make the process more efficient and effective. Apart from process efficiency, emphasis was on standardizing the code to improve readability, consistency, ease of future modifications and current state of technology.

Responsibilities included rewriting major portion of the code for the accounts payable and purchasing modules and also enhancing the front-ends. The entire coding was done in SYBASE, T-SQL and SQR.

Involved in the design, development and implementation of General Ledger and Accounts Payable Modules of Sybase based Avalon 9.0 product. The Avalon product has about 1000 tables and more than 5000 routines to support the system. Responsibilities included:

• User requirement study System analysis and design
• Application development Testing and implementation
• Optimization and performance improvement of existing database design

Assisted with the analysis, programming and implementation of a Sybase/T-SQL based Order Processing System for a local bicycle manufacturing company. Technical accomplishments include the design and integration of the Order Scheduling and Purchase Accounting systems Assisted with the analysis and programming of a SYBASE/Power Builder based Library Management System. Responsibilities included rewriting and upgrading the already existing APT front-end screens with Power Builder screens

As a Software Consultant for a Industrial Waste Management firm, was Involved in the following: Computerization of various engineering projects involving engineering feasibility analysis, life cycle modeling, coding, debugging and technical support. Applications development using SYBASE, ORACLE, PRO*C. Also provided hardware and system support for the data center.

Education:

Up

OBJECTIVE

CMA, CPIM, MBA Senior Executive Consultant Specializing in Oracle Client Server Technologies

SUMMARY

Techno- Functional Consulting Professional with 13 years hands on experience in Core Oracle Manufacturing and Financial Systems implementation and Network configuration. Extensive Oracle project ERP implementation experience with successful implementations of all Core Oracle Financial & Manufacturing Modules, HR,Payroll and Oracle CRM. Performed turnkey project management, Quality assurance testing, business process analysis and reengineering, production and inventory management operational guidelines, operational and financial audit, planning, and financial reporting. Degreed and experienced in accounting, financial reporting and manufacturing operations. Performed extensive Oracle Manufacturing & Financial setup and configuration, fit and gap analyses, data mapping, data conversion, business requirements creation, training, business process reengineering, inventory control and valuation audits, manufacturing process audits, item routings and bills of materials audits, variance analyses and yield analyses.

ACCOMPLISHMENTS

Oracle hands-on for version 11.6.0, RDBMS 8.1.7.1.0. Setup and configured Oracle Inventory Control, Oracle General Ledger, Oracle Accounts Payable, Oracle Cash Management, Oracle Projects, Oracle Fixed Assets and Oracle Order Management with Advanced Pricing for April 1, 2002 go live. Assisted with phase one of Oracle Workflow, Oracle Advanced Planning & Scheduling, Oracle Purchasing, Oracle receivables, Oracle Bill of Materials and Oracle work in process. Also assited in the data mapping and the design of an interface from Oracle Payables to a legacy invoice imaging system by 170 Systems Incorporated. Currently phasing in Oracle Accounts Receivable, Oracle Purchasing, Oracle I-procurement and integrating Multi-currency reporting into Oracle General Ledger. Recently started the business process mapping for the implementation of all CRM modules. Started out as an upgrade from 10.7 to 11i. Convinced the client to go with fresh install since most of the scripts sent by oracle were not performing as indicated in the readme files. The clients longterm goal to use I-procurement facilitated the need to do a fresh install.

Oracle 11.5.1 11I. Fast track implementation of GL, AP, AR, FA, OE, PO, I-procurement, Oracle Projects and Oracle Inventory. Business process reengineering, documentation and setup configurations of Oracle s core financial suite. Setup Oracle Order Entry, Oracle Projects,Oracle OM with Advanced Pricing, Oracle Sales Compensation, Oracle Purchasing with I-procurement, Oracle General Ledger, Oracle Accounts Receivable, Oracle Assets, Oracle Inventory, Oracle Human Resources and Oracle Purchasing. Led a team of 12 consultants and completed on time and on budget. GL Setup with three business entities requiring a set of books for each entity. Setup multiple Inventory Organizations and Operating Entities to facilitate the integration with Oracle Purchasing and Human Resources. Oracle Order Entry was setup for Assemble to Order for specific customer requests with full implementation of Oracle Pricing which is licensed as Oracle Advanced Pricing. Currently providing remote production support on a part-time basis for the client. Upgrade from oracle 11.0 to Oracle 11i.

Hands on for version 11.5.6 Implementation team lead at Ultimate Pediatric Care Center in Houston, TX with the following modules: Projects, GL, HR, OE with ATO, AR, AP, PO, FA, MRP, CRP, BOM, WIP, ENG, CST, & INV. Built and managed a team of fifteen Oracle technology consultants. Directly setup and configured Oracle Inventory, Oracle Work in Process, Oracle Bill of Materials, Oracle Advanced Planning and Scheduling, Oracle Advanced Supply Chain Planning and Oracle Purchasing. Assited team members on the configuration of the remaining modules in a advisory role. Used RDBMS analysis to identify effective solutions for all business control objectives and provided technical design & guidance for core oracle developers. Set up a peer to peer Intranet system between the Houston and Austin Texas office. Fresh installation of Oracle 11i.

Participated in the Beta Quality Assurance Testing of Oracle s Version 11I, Oracle s Core Manufacturing and Financial Modules, all CRM Modules with specific emphasis on Internet Procurement, Oracle Service, Oracle Sales Applications, Oracle Advanced Planning and Scheduling, Oracle Advanced Supply Chain Planning, and Oracle Advanced Pricing.

Team Lead for Fast Track Implementation of Oracle 11.03, RDBMS 8.05.1.0 with Oracle Internet Business Applications, Accounts Payable, Oracle Human Resources with Payroll, Accounts Receivable, General Ledger, Order Entry, Oracle Sales Compensation, Oracle Service and Inventory. The specific Internet business applications implemented were Oracle email center concepts & procedures, oracle iMarketing, oracle iPayment, oracle iStore, and oracle iSupport. Assisted a team of 4 junior implementers to finalize the implementation.

Team Lead for Oracle 10.7 financials and Process manufacturing implementation. Hands on configuration, setup and consultation on Oracle Full Manufacturing and Financial modules with the exception of Oracle Assets. Managed a team of 18 consultants and employees for the full life cycle of the implementation.

Hands on Project Manager for Oracle Financials and Manfacturing Implementation Version 10.7.0 SC16 RDBMS 7.3.2.3.0. Led Oracle Bill of Materials, Oracle Work in Process, Oracle Inventory, Oracle Purchasing, Human Resources, HR & Payroll, Order Entry, General Ledger, Accounts Receivable & Accounts Payable. Setup and configured key flexfieds, employees, grades, position reporting hierarchy, payroll groups, tax categories, Jobs, Positions, Organization & Organization Hierarchy. Completed configured Analyzed, identified and documented business processes and gaps, prepared project scope documentation, setup and configured oracle applications to meet client business process requirements, created custom oracle training documentation and conducted in house education classes for Oracle Inventory, Purchasing, Accounts Payable, Accounts Receivable and General Ledger. Prepared project management spreadsheet for in house project planning.

Implemented Oracle Financials & Manufacturing Version 10.6 on Solaris 5 Operating System. Hands on project Lead on the design and configuration of Oracle General Ledger, Human Resources, Order Entry, Accounts Receivable, Accounts Payable, and Purchasing. Setup and configured Oracle Order Entry, Accounts Receivable, Accounts payable and purchasing to meet client s business requirements.

Electronic Data Systems upgrade of Oracle s Release 9 to Oracle Version 10.5. Assisted in the Upgrade of Order Entry, Accounts Receivable, Inventory, Bill of Materials, Engineering, Purchasing, MRP and Work in Process. Performed applications engineering and design, database testing and analysis, custom report specifications and testing, business process reengineering and documentation, and key end user functional training and support.

Administered an Oracle Manufacturing presentation, at the Los Angeles Oracle Users Group conference, in Norwalk California, to improve the visibility of the Application Group.

Oracle Manufacturing and Financials Implementation Release 10.4.2. Coordinated the utilization of client resources with external technical and functional resources. Implemented Oracle General Ledger, Payables, Purchasing, Receivables, Order Entry, Inventory, Cost, Work in Process, Bill of Materials, MRP & Capacity, and Engineering.

Oracle Manufacturing and Financials Release 10.5. Implemented Oracle General Ledger, Purchasing, Payables, Receivables, Order Entry, Inventory, Work in Process, Engineering and MRP/CRP.

Upgraded Oracle s Release 9 financials and Manufacturing to Oracle Release 10. Converted costing customizations in Oracle s Release 9 to generic functionalities in Oracle Release 10. Upgraded Purchasing, Order Entry, Inventory, Costing, MRP, CRP, Engineering, Work in Process, Accounts Payable, Accounts Receivable, General Ledger, Oracle Projects, and Oracle fixed Assets, from Oracle Release 9 to Oracle Release 10.4.2.

Implemented Oracle Fast Track Inventory and Purchasing Release 10.4.00.

Oracle Manufacturing and Financials Release 10.1. Implemented full suite of Oracle Manufacturing and Oracle Financials.

TECHNICAL SKILLS

• Database: Oracle, MS SQL Server
• OS: NT, WinXX, MSCE Certified Network Specialist, and Unix
• Languages: SQL, PLSQL
• Microsoft Office Tools: Project, Word, Excel, PowerPoint, Outlook, Visio etc.
• Oracle Products: Oracle Financials, Manufacturing, Designer 2000,Developer 2000,SQL Forms, SQL Navigator, Reports2.3 & Reports 2.5.

POSITIONS HELD

• TEAM LEADER
• PROJECT LEADER
• SOFTWARE ENGINEER
• BUSINESS ANALYST
• SENIOR APPLICATIONS CONSULTANT
• SENIOR SOFTWARE TRAINER AND/OR INSTRUCTOR
• VICE PRESIDENT-FINANCE
• CONTROLLER

EXPERIENCE

Systems Implementation -- Oracle Application Consulting -- The Alpha Group, 1995 to Present
Implementation of Oracle Manufacturing and Oracle Financials suites for various customers. Performed business process reengineering and Oracle applications design, training, and configuration.

Oracle Order Entry Lead with Electronic Data Systems at Modern Technology in San Jose, Ca., for the upgrade of Oracle s Release 9 to Oracle Version 10.5. Assisted in the Upgrade of Application Object Library, Order Entry, Accounts Receivable, Inventory, Bill of Materials, Engineering, Purchasing, MRP and Work in Process. Performed applications engineering and design, database testing and analysis, custom report specifications and testing, business process reengineering and documentation, and key user functional training and support.

Project Leader at Plussign Inc., in Greenville, TN, for Oracle Manufacturing and Financials Implementation. Project Lead responsibility coordinating the utilization of client resources with external technical and functional resources. Implemented Oracle General Ledger, Payables, Purchasing, Receivables, Order Entry, Inventory, Cost, Work in Process, Bill of Materials, MRP & Capacity, and Engineering.

Systems Implementation -- Oracle Application Consulting -- The Application Group, Inc. 1994 - 1995
Setup and implemented all modules of Oracle Manufacturing and Financials for numerous clients. Utilized Operations Expertise to handle client systems implementation needs. Responsible for ensuring that clients needs were met on all projects in my responsibility area.

Accounting -- Manufacturing Corporation Vice President Finance-1993-1994
Responsible for financial statement reporting and analysis including, operational and financial audit, analyzing data to determine costs of raw materials, material overhead and labor. Analyzed changes in product design, raw materials, manufacturing methods, or services provided, to determine effects on costs. Analyzed and reported cost of goods sold, gross margin, manufacturing variances, inventory, reserves and warranty accruals. Responsible for formulating and implementing policies and procedures, with autonomy, to improve the integrity and accuracy of in house manufacturing and financial Reporting. Participated in Financial Planning and budget preparation with various departmental group leaders. Setup, analyzed and implemented Oracle Manufacturing and Oracle Financials, with specific emphasis on Application Object Library, System Administration, Oracle Order Entry, Oracle Receivables, Oracle Payables, Oracle Purchasing, Oracle Work in Process, Oracle Inventory, Oracle Bill of Materials, Oracle Engineering, and Oracle Costing.

Financial Systems -- Controller -- 1988-1993
Responsible for preparing monthly and annual financial statements with inter-divisional transactions, financial planning and budgeting, inventory reconciliation, analysis of data to determine costs of raw material purchases , inventory and labor. Analyzed changes in production design and processes to determine their effects on costs. Developed in house PC based accounting systems, audited accounting systems and procedures for compliance and efficiency. Examined and evaluated format and function of business manufacturing processes to develop new, or improve existing processes format, usage, and control.

EDUCATION

1989 University of Houston Houston, TX Accounting and Computer Science BBA

2001 University of Texas Austin, TX MBA, Information Systems

OTHER TRAINING

Up

EDUCATION

Masters of Business Administration, Golden Gate University, Langley AFB, Virginia 1991

Bachelor of Science, Business Administration with a minor in Accounting, Virginia State University, Petersburg, Virginia.

SUMMARY

Ms. Crowford has over fourteen years of experience in information technology, management and accounting. Currently, she is a consultant specializing in Oracle Financial Applications with an emphasis on Accounts Receivable and Accounts Payable, as well as, project management, strategic planning, and enterprise management. She also specializes in Siebel Software and is working toward her certification. Ms. Crowford s knowledge and experience provides customers with consulting services that focus on business requirements, accounting practices and procedures, enterprise architecture development and integration, enterprise operations and management, strategic planning, Oracle financial applications, and Siebel software. Using these approaches, Ms. Crowford has provided customer solutions that are business driven, technologically sound, and strategically focused. Further, Ms. Crowford s experience with Project Management, Oracle Financial Applications and Siebel software assures customers that each solution is provided with documented, best-practice processes and procedures.

SPECIFIC KNOWLEDGE AND EXPERIENCE

• LANGUAGES SQL, PL\SQL, SQL*Plus

• DATABASES Access, Dbase III, Oracle8

• SOFTWARE MS Word, MS Excel, MS Project, MS PowerPoint, Lotus 1-2-3, WordPerfect, Access, FOCUS, Project Workbench, Harvard Graphics, Easytrieve Systems, Oracle Financial Applications Suite, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets, General Ledger, General Ledger Desktop Integrator, Multiple Reporting Currencies, Flexfields, EURO, Project Accounting, Introduction to Oracle Manufacturing Release 10SC, , Introduction to Oracle Human Resources Release 10SC Navigating Release 11, Technical Foundations, Multi-Org, Industry Verticals: Finance and Government, AIM Oracle Application Implementation Methodology , CDM Oracle Custom Design Methodology , Custom Development Processes: Training

• OPERATING SYSTEM MS DOS, Windows 95, WindowsNT

• HARDWARE PCs

• TRAINING latest Oracle Apps GL, AP, AR, HR, Procurement Certification class Siebel core partner training

EXPERIENCE

• Supervise seven plus employees on Billing, Invoice Procedures and Procurement contracts.
• Responsible for generating weekly and monthly reports to management to meet contract goals.
• Knowledge of PRISM, Microsoft Access, Oracle and Delphi, also responsible to teach incoming consultant on these applications.
• Serves as Functional Lead to our Information Systems Technicians on devising programs to enable EMA to track, retain and report financial information.
• Devised training schedule and tasks using Microsoft Project.

• Performed RFP and proposal writing and became subject matter expert on proposal writing.
• Generated and created technical documents that respond to current oracle financial applications for various locations.
• Implementing Oracle Financials GL, PO, AP, AR , Order Entry, Project Accounting, Human Resources and Inventory applications for clients.
• Taught Oracle Financials and Oracle Discoverer 2000 classes to 32 colleagues in order to update skill set and knowledge base.
• Lead the team in several net-meeting financial training modules and accounting practices. Devised training schedule and tasks using Microsoft Project.

Defense Energy Supply Center DESC Fuels Automated Systems FAS Project, Ft. Devens, Virginia

The Fuels Automated Systems FAS /Oracle Energy Downstream OED project is implementing Oracle Federal Financials GL, PO, AP, AR , Order Entry, Project Accounting, and Inventory applications for the Defense Energy Supply Center, including a Web interface to shortcut entry of transaction data and a Price Escalation extension to the Purchasing product to perform variable data based pricing.

• Produced template for user requests. Template to include type of user, i.e. Oracle/Unix, jobs group allocation and database access. Template to be completed by Business Support Group BSG members.
• Created new users using template. Administered the log of users and databases/business functions allocated.
• Generated procedure for user creation as a deliverable to the client, for hand-over to client consultant in GUI-II. Procedure to cover BOKS and OED user creation functionality.
• Produced request form for additional job group allocation. Template to be completed by BSG members.
• Generated procedure for job group as a deliverable to the client, for hand-over to client consultant in GUI-II.
• Produced template for batch program set-up, i.e. p-value generation. Template to be completed by BSG members.
• Created new p-values using OED menu. Generated procedure/notes for this task.
• First point of contact for batch failures. Logged calls and performed initial analysis and solution, i.e. prior run failed creating resident log file failure. Reported higher-level batch failures to BSG group for examination and possible TAR production.
• Checked log file status on a daily basis to ensure that no hanging logs in existence.
• Generated procedure/notes on batch program failure/analysis and reporting.
• Checked RFS extract and load logs to ensure all IR transmissions have run to completion. Notify BSG members of IR transmission failures. Created procedure for this task.

Defense Finance Administration Services DFAS Fuels Automated Systems FAS Project, Arlington, Ohio

The Fuels Automated Systems FAS project implemented Oracle Federal Financials GL, PO, AP, AR , Order Entry, Project Accounting and Inventory applications for the Defense Energy Supply Center, including a Web interface to shortcut entry of transaction data and a Price Escalation extension to the Purchasing product to perform variable data based pricing.

• Lead an Oracle team of 4 in providing testing status to Project Management in Virginia.
• Worked closely with client to research and resolve user testing issues and bugs.
• Provided business requirements to Oracle developers to fix bugs or build enhancements.
• Worked closely with Oracle developers to resolve user-testing issues.
• Tested reports and ad-hoc queries using Oracle Browser.
• Tested and validated setup steps for Oracle General Ledger and US Federal Financials.
• Tested and validated the setup of General Ledger, Federal Financials, Oracle Alerts, and Oracle Inventory.
• Performed Oracle Y2K testing for Oracle Bunkers
• Tested Oracle Financial applications, reports and scripts
• Setup and verification of reports
• Compilation of Custom Report Setup Documentation
• Developed a Quick Reference User s Guides for the client
• Taught Oracle Discoverer 2000 Classes
• Providing documentation through AIM and CDM and Microsoft Project
• Used Microsoft Excel to keep track time and billings on site.

Defense Energy Supply Center DESC Fuels Automated Systems FAS Project, Ft. Devens, Virginia

The Fuels Automated Systems FAS project is implementing Oracle Federal Financials GL, PO, AP, AR , Order Entry, Human Resources and Inventory applications for the Defense Energy Supply Center, including a Web interface to shortcut entry of transaction data and a Price Escalation extension to the Purchasing product to perform variable data based pricing.

• Provided testing status to Project Management.
• Performed Oracle Human Resources employer to employee information
• Provided business requirements to client for HR portion which consisted of 3 months of work.
• Worked closely with client to research and resolve user testing issues and bugs.
• Provided business requirements to Oracle developers to fix bugs or build enhancements.
• Worked closely with Oracle developers to resolve user-testing issues.
• Tested reports and ad-hoc queries using Oracle Browser.
• Tested and validated setup steps for Oracle General Ledger and US Federal Financials.
• Tested and validated the setup of General Ledger, Federal Financials, Oracle Alerts, and Oracle Inventory.
• Performed Oracle Y2K testing for Oracle Bunkers
• Tested Oracle Financial applications, reports and scripts
• Assist with the setup of Oracle receivables
• Entered new and updated existing customer information in AR
• Taught users how to review receipts, transaction histories, and customer account information
• Taught users how to create dunning letters in AR
• Taught users how to enter, apply and remit receipts in AR
• Setup and verification of reports
• Compilation of Custom Report Setup Documentation
• Assisted the Oracle DBA with installation, deployment and maintenance of Oracle 8 database and Oracle 11 applications
• Developed a Quick Reference User s Guide for the client
• Providing documentation through AIM and CDM

Student Entry Level Management System SELMS Project, Euless, Virginia

• In charge of planning and setting up testing environment for client
• Help prepare CDM documentation for training the client
• Worked on custom design project in the testing phase, for the Federal Government
• Responsible for delivery of custom training plan for the project
• Assisted with testing requirements, including hardware/software setup and testing materials.

10/98 - 12/98 Consultant

• Selected to attend Financial Applications Functional Bootcamp which included training in all Oracle financial modules and implementations using AIM and CDM methodology.

• Responsible For the Collection Of Delinquent Revenues Within Government, Education And Health Services GEHS .
• Provides weekly collection update reports to Project Directors, Project Managers and Supervisors using Microsoft Excel using lookup resources by verticle.
• Responsible for collector call tracking and follow-up on all aged GEHS accounts.
• Use of Oracle s Project Accounting System

• Provide analytical and administrative support to the Fuels Automated System Project Manager
• Prepare and run weekly and monthly reports using Microsoft Excel, Powerpoint and updating MS Project worksheets.
• Preparation and review of Oracle Energy Downstream time and expense reports.

Management Analyst II, April 1995 January 1998, Fire and Rescue Department

• Management and collection of revenue in excess of 2.8 million per fiscal year.
• Analyze, evaluate and prepare both oral and written analyses, as well as associated statistical revenue reports, forecasts and projections.
• Supervise, train and evaluate the personnel of the Revenue and Records Branch including staff responsible for fee collection, billing accounts receivable, records management, invoicing, plans review and fire prevention code permits.
• Respond and address inquires from the public regarding billing practices and responsible for resolving related problems including Freedom of Information Act FOIA requests.
• Lead a team of 4 to implement a new document imaging system and procedures by ensuring conformity with county policies and procedures performed duties as Project Manager.

Real Estate Appraiser, February 1995 April 1995, Department of Tax Administration

• Appraises the value of real property throughout Berlin County
• Researches and inspects property characteristics pertinent to the appraisal of real property for assessment purposes.
• Analyzes date on sale prices and construction costs and evaluates sales financing including the analysis of trends in real estate financing in determining property value.

Business Tax Specialist II, 2/93 2/95, Department of Tax Administration

• Responsible for generating over 600,000 in revenue through the assessment of county Business Professional and Occupational licenses and Personal Property Taxes.
• Performs financial assessments in reporting County Business Professional and Occupational License and Business Personal Property taxes.
• Reconciles caseload study on a weekly basis, reconciles revenue balances, provides assistance to internal auditors as needed.

• Performs financial administration and reporting of federal and state reimbursements which includes monitoring juror expenditures and revenues with prescribed requirements.
• Reconciles general ledger account balances and insufficient appropriations with the City s Financial Accounting System.
• Research financial records and monitors appropriation transfers, and prepares journal vouchers.
• Provide assistance to internal and external auditors in auditing financial statements and records.
• Reviews, monitors and analyze accounts, such as receivables, payables, capital projects and fixed assets for accuracy.
• Reconcile the Non-departmental Cost Analysis for the City s Cost Allocation Plan and assists with the City s Set-Off Debt system.

Up

Objectives

Be an excellent Oracle DBA and database designer and developer.

Highlights

• 5 year of extensive Oracle 7.3.x, 8.0.x, 8i and 9i Design/Operation DBA and database developer experience. Experienced with relational database design, including physical and logical design. Hand-on experience with data warehouse and online transaction database environment.
• Experience with data migration.
• In-depth experience in SQL, PL/SQL, Unix Shell and Perl scripts, SQL*Net and Net*8, SQL*Loader, ERWIN, and TOAD.
• Hand-on experience with Oracle designer, Oracle Developer Oracle Form and Oracle Report , Oracle Enterprise Manager OEM
• Experience with Solaris, Unix, AIX, Linux, NT, and Window 2000
• Excellent analytical & problem-solving skill. Good verbal, written, and presentation skill. Excellent team worker. Self-motivated and quick learner. Adaptable to a fast growing and changing environment.

Certificate and Awards

ORACLE Certified Professional OCP Database Administrator DBA . 1999
Database Award BC Institute of Technology, Vancouver, BC, Canada 1998

Computer Experience and Projects

Have full life-cycle B2B Database design and development experience. Designed logical and physical data models for telecommunication applications. Developed the application schema creation scripts. Developed the system and data migration processes from an object-oriented database Versant to the RDBMS database in Oracle 8i and 9i. Utilized ERWIN to describe the complicate relationships among the telecommunication business objects. Experienced with mapping object-oriented application to relational model. Wrote SQL scripts to extract the BLOB data both from VERSANT object-oriented database and ORACLE RDBMS database and expanded and loaded the objects into relational tables through SQL*Loader for reporting. Programmed the scripts for reporting using SQL scripts and crystal report. Load data into multiple databases for development or testing purposes. Documented the Database schema and Data Export Guide for all the applications. Designed end user queries and reports, participated in end GUI design and GUI development selection. Traced and tuned SQLs. Conducted performance tuning on both server side and client application side, dramatically improved the response time for the database application. Installed and configured Oracle Application Service for development environment.

Planed, installed, configured and maintained the multiple databases in development, testing and production environment. Planned capacity. Configured Net*8. Monitored Oracle log files and trace file. Monitored the Unix system, including the related processes, CPU, memory, and disk I/O. Implemented shell and cron scripts to automatically clean up alert files, trace files, archive log files. Enforced security policies. Maintained users. Designed the database backup and recovery strategies. Implemented the backup scripts, including hot backup, cold backup and exporting scripts. Tuned Oracle performance. Provided perl, shell, and sql scripts for the database maintainance. Troubleshoot the system. Assisted IT team on Veritas backup configuration. Evaluated the database related software.

Worked on a very large Database conversion project for the Gellus, BC, the 2nd largest telco in Canada. Involved designed telecommunication data models for telecommunication equipments inventory and management system. Implemented data conversion from BC Tel s legacy databases into Oracle 7.3.x based GTE s Telecom Business Solution TBS system. Implemented complex PL/SQL scripts to conduct data migration, error handling and reporting. Switched databases configurations for the different purposes for data migration, for data warehouse, and for online transaction . Tuned Oracle performance. Troubleshoot the system. Developed the data validation tool using Oracle Form and the conversion report using Oracle Report.

Wrote SQL, PL/SQL programs including triggers and stored procedures for a Oracle-based Web HR database. Tuned the Oracle database performance.

Technologies used: Oracle 8.0.5, SQL, PL/SQL

Designed and developed a program to retrieve messages and files from a SQL Server database and transported them to related nodes across the Internet securely

Implemented a building material management system: order management, customer management, price management, quotation and report generation subsystem, etc., using VB GUI interactingwith MS Access databases.

Other Career Experience

Educations

Sept. 1996 May, 1998 Computer Science Database
British Columbia Institute Of Technology BCIT BC, Canada
Major: Database System Highest GPA in the class of Database Program

Sept. 1986 July 1991 Department of Medicine
Bachelor of Medicine Fujian Medical University Fujian, China
Major: Medical Science Top 5 in the class

Database Trainings

Versant Versant Authorized Education 2000

• Advanced Object-Oriented Database Administrator

Oracle Oracle Authorized Education 1999

• Designer 2000

Oracle Oracle Authorized Education 1998

• Introduction to Oracle SQL and PL/SQL using Procedure Builder
• Oracle 7 Database Administration
• Oracle 8 Backup and Recovery
• Oracle 8 Performance Tuning

Additional Computer Experience and Skills

• Programming Languages Java, C, C++, BASIC, PASCAL, Delphi, etc.
• Database Systems MS Access, SQL Server, etc.
• Visual Tools Visual Basic, Delphi, Turbo PASCAL For Windows, etc.
• Client/Server ODBC, JDBC, RDO, ADO, ActiveX

Up

Objective:

To obtain a challenging Software Engineer position with opportunity for growth and career advancement.

Career Profile:

• 5 years of progressive IT development/support experience.
• Demonstrated expertise in all phases of systems development life cycle in clint/server environments Oracle PL/SQL,Forms, Reports .
• Extensive experience in the financial, manufacturing/export, tax and sales industries.
• Extensive experience in Oracle relational database and realated technologies.
• Formally trained in web development tools including HTML, JavaScript, Perl, ASP, JSP, Java Servlet, and Java.
• Sun Certified programmer for JAVA 2 platform.

Skills:

• Hardware : IBM PC
• Operating Systems : Unix, Windows 95/NT, DOS
• Languages : Visual Basic 5.0, Java 2, Natural, SQL, JavaScript, Perl, HTML, ASP, JSP, Java Servelt, C, C++, COBOL
• Databases : Oracle 7.3/8/8I, MS Access
• Software : Forms 6.0, Forms 5.0, Reports 6.0, Reports 2.5, Allaire HomePage, PVCS
• Industries : Manufacturing, Financial, Government
• Methodologies : Productivity Management
• Functional Areas : Accounting, Sales & Inventory

PROFESSIONAL EXPERIENCE

Working as Database Developer, was involved with the development and Maintenance of CIRAS. This is primarily Oracle-Forms based application which provides an interface to an Oracle database which tracks circuit information for Sprint s Local Telephone companies. The main functions of the application include tracking both the processing of orders and the engineering/provisioning of the circuits. The system is developed on Oracle 8i under IBM AIX environment.

Environment: ORACLE 8.X, FORMS 6i, Reports 6i, IBM AIX 4.3.3, PL / SQL, PVCS, SQL*LOADER, TEST DIRECTORY 7.2

Developed Internal Revenue Information System IRIS client/server tax application for a large city government. Worked on requirements gathering, high-level design, detail design, construction, unit and system testing phases for development of a payment plan component. This application was developed to offer a payment plan for taxpayers. Developed Amortization Schedule report to print latest balance due using Report 6.0. Developed MS Word notifications using Oracle Form OLE procedure to print notifications based on payment received from taxpayer. Developed calculation intensive PL/SQL modules to allocate payment to different taxcodes according to predefined allocation percentage. Constructed individual modules using Oracle Forms 6.0, Report 6.0 and PL/SQL 8.0. Implemented menu security to provide data driven access to users with different roles.

Environment: ORACLE 8, FORMS 6.0, REPORTS 6.0, PL/SQL 8.0

For a major insurance company, worked in accordance with the SCR system System Change Request for Annuity system. Supported customer annuity tracking application for changing business rules. This application helped in expediting annuity reporting. Prepared stored procedures, packages, functions and database triggers. Prepared reports through SQL Oracle 8.0 in Magic Language.

Environment: ORACLE, MAGIC LANGUAGE

Involved with a project to develop and cater to the needs of a Varment Export Company. The software was intended to integrate various components including sampling, merchandising, purchasing, documentation, shipping, finance and inventory. Worked on requirements gathering, high-level design, detail design, construction, unit and system testing phases for development of the Garment Export System. The major functionality of the system is Sales Order, Sample approvals from clients, purchase order, production, sales and purchase of garment quota, documentation and shipping, Letter of credit. Responsibilities included analysis and design of the project, which consisted of 210 tables. Prepared ER diagrams in Designer 2000 1.5 , and coded new Forms for developing the merchandising and Inventory components. Prepared stored procedures, packages, functions and database triggers, and also performed unit testing and system integration.

Environment: ORACLE 8.0, FORMS 5.0, REPORTS, DESIGNER 2000

Analyzed, designed, and coded a system for Foreign Exchange Currency to automate sales and purchase of foreign currency. Developed forms for data entry of purchases, and reports to keep track of inventory. This sytstem helped in cutting cost by autmating major tasks. Also, developed analytical reports to study trends and forecasting. Prepared stored procedures, packages, functions and database triggers and also performed unit testing.

Environment: ORACLE 7.3, Visual Basic 5.0, Crystal Report

Involved with the development of form, reports for manufacturing and sales system. This system automated sales and inventory functions. Developed sytstem from scratch after analyzing client requirements. Devlopment of this sytem resulted in elimination of manual traking of inventory and sales data. Prepared stored procedures, packages, functions and database triggers to implement required functionality.

Environment: ORACLE 7.3, FORMS 4.5, REPORTS

Involved with the development of Library System for Indian Government owned Physical Research Laboratory system. Part of production support team for library system. We developed this system in FoxPro.

Environment: Forpro

EDUCATION, CERTIFICATIONS AND TRAINING

Master of Computer Application, Rollwala Computer Centre, Gujarat University, Ahmedabad, Gujarat, India.
BS, Mathematics, Gujarat University
Sun Certified Programming for JAVA 2 platform
Web Developer Certificate program, Depaul University
Keane Productivity Management PM

Up

CAREER PROFILE

• Has FOURTEEN YEARS of professional experience in System Study, Design, Development and Implementation of various Software Applications.
• Has more than FOUR years of extensive Analysis, Design, Development and Implementation experience in Oracle Applications.
• His expertise includes extensive technical knowledge & work experience on ORACLE 7x/8x/8i, using Oracle Forms, PL/SQL, ORACLE Reports, SQL*Plus, DESIGNER 2000, DEVELOPER/2000, DEVELOPER/6i and other related tools and techniques on ORACLE database system.
• Has good experience in developing front-end GUI based applications using DEVELOPER/6i, DEVELOPER/2000, POWERBUILDER 5.0/4.0/3.0 , & UNIFACE v6.0 on INFORMIX.
• Has excellent Technical skills & Work Experience in Customisation & Implementation on ORACLE FINANCIALS & MANUFACTURING versions 10.7 SC, 11.03 NCA & 11i. Worked extensively on Financial modules like General Ledger GL , Accounts Payable AP , Accounts Receivable AR , Cash Management CM and Fixed Assets FA and also Manufacturing modules like Inventory INV , Work In Process WIP , Bill of Materials BOM Manufacturing Resource Planning MRP ,Work Flow, EDI, Order Entry OM/OE , Purchasing PO , iProcurement and iSupplier.

EDUCATION

Bachelor Degree in Science, Bombay University
Diploma in COMPUTER SOFTWARE APPLICATIONS

COMPUTING SKILLS

ORACLE FINANCIALS and MANUFACTURING Ver 10.7SC, 11.03 NCA & 11i including OE, AR, AP, PA, GL, Fixed Assets, Cash Management, Work In Process, Inventory, Bill of Materials, MRP, EDI, AOL, Oracle Work Flow and Oracle System Administration

ORACLE 7x/8x/8i, SQL*Loader, DEVLOPER/2000, DEVELOPER/6i, SQL* Plus, PL/SQL, POWER BUILDER v5.0/4.0/3.0 . UNIFACE v6.0

DESIGNER-2000, ERWIN Case Tool

ORACLE 7x/8x/8i, INFORMIX 4.0, UNIX, C, PASCAL, BASIC

PROFESSIONAL TRAINING

- Diploma in POWERBUILDER
- In-house training in ORACLE 7.1, FORMS 4.5, REPORTS 2.5

DESIGNER 2000 & UNIFACE
- Certificate in ORACLE FINANCIALS Ver 10SC

WORK EXPERIENCE

Environment: Windows NT 4.0, Oracle Applications 11i, Oracle 8i, Developer 6i, PL/SQL, SQL*Plus, HP Unix V4.4.4 on HP UX Release 11.

Currently working as IT Lead Analyst for designing custom interfaces from the client s legacy system to the Oracle Modules AP, AR, GL, CM and INV . Participated with company management and end users in defining and planning the systems requirements. Did feasibility study, gathered current system flows, designed the interface requirements and estimated the inventory of effort regarding the interface delivery. Helping the user community design strategies for loading data and overcoming gaps by designing interfaces.

Custom Order Picking System was developed, with the lots of help from the user community. This system consists of an Oracle Application Form, two PL/SQL procedures and two reports. Imported the Shipped Orders data from Optum to create the transaction in Accounts Receivable using the AR API. Customized invoice report, which was printed from the Auto-invoicing process. Developed a process to load data from Purchasing sub ledger to the General ledger. Was involved in development of Web Procure-To-Pay key component using iProcurement. Designed & developed web inquiry application in Self-Service Purchasing for suppliers to view their On-hand inventory on line. Customised Workflow Process to generate notification for PO Approval, Order Shipped and Invoice Printed.

Environment: Windows NT 4.0, Oracle Applications 11.03 NCA, Oracle 8i, Developer 2000, PL/SQL v2.1.3 , SQL*Plus v3.3 , DYNIX Unix V4.4.4 on SEQUENT server.

Worked as IT Lead Analyst for all the Oracle Applications Modules. This project involved customisations and extensions to Oracle Applications 11.0 using Forms 4.5 and Reports 2.5. Modules include General Ledger, Account Payables, Oracle Order Entry, Project Accounting, Oracle Purchasing and Oracle Receivables. Worked as a member of a team that developed the custom Photopens Projects module as an extension to Oracle Accounts Payable and Receivables module. Was responsible for the design and development of all the Photopens Reports. Led the users through Requirements definition, map/gap analysis and solution design. Designed and developed custom General Ledger reports. Contributed to the overall design of Photopens projects module that included designing the Stored Procedures, Database Triggers and Interfaces required for integrating/interfacing the custom Photopens module with other Oracle modules such as Purchasing, Accounts Payable and General Ledger. Created Quick Codes and Value Sets using Oracle Applications Set Up screens. Registered new Forms, Reports and Concurrent Programs using Oracle Applications Set-Up screens. Created a SQL loader script for importing cleared Checks flat file data provided by the Bank into a temporary table. Created a stored procedure to validate the imported data and moved them to the interface. Also created SQL Loader scripts for importing the Lockbox flat file data provided by the bank into the interface table, which were notified to the client using alerts with action through email.

Environment: Windows NT 4.0, Oracle Applications 11.03 NCA Oracle 8, Developer 2000, PL/SQL v2.1.3 , SQL*Plus v3.3 , Digital Unix V4.0F on COMPAQ Tru 64 server.

Designed, Developed and Implemented interfaces for Oracle Financial modules like GL, AR and AP and also for Manufacturing modules like Oracle Purchasing & Receiving, Oracle EDI Gateway, Oracle MRP, and Oracle Supplier Scheduling modules of Oracle Applications 11.03 NCA.

Was responsible for the the Vendor conversions from legacy data to Oracle AP. Customized existing Oracle reports to provide customized versions of Check Payment Files, Check Remittance Files and EFT Payment Files. Wrote many Oracle Alerts to help manage data files and to notify users of automated tasks that have taken place. Customized several AR and GL reports according to the user specification specifications.

Developed interfaces for Oracle Purchasing and Receiving like ASN Receipt Form/Barcode Traveller, Purchase Price Customisations and Automating Supplier Scheduling Sourcing Rules.

For Oracle EDI Gateway Customised EDI DELFOR to include additional information on the shipping details. Agreement with an international supplier required that their DELFORs have additional information. EDI Extensive Architecture was used to attain this functionality.

Developed a custom Supplier Scheduling bolt on that would help schedule supplier delivery on particular day of the week. The current Oracle Supplier Scheduling functionality was not capable of scheduling supplier deliveries on particular day of the week. This bolt on had a form, which stored Supplier, Supplier Site and Days of Delivery for an organisation. This information was used to alter the schedules that were created by MRP before releases are created.

Environment: Windows NT 4.0, Oracle Applications 10.7SC Oracle 7.3, Oracle Forms 4.5, Reports 2.5, PL/SQL v2.1.3 , SQL * Plus v3.3 , Digital Unix V4.0D on DEC ALPHA

Designed and developed interfaces for a customized Sales Compensation System. This system calculated the commission remuneration to the marketing personnel depending on the type of orders brought to the organization by them, eventually these data were used by HR department. Customized an existing Oracle report to provide a customized ACH Payment File. Customized several AP reports according to the user specifications. Created many new reports to support the Metrix Application.

Designed and developed interface called Equivalent Pieces which, calculated the resources used in manufacture of parts by all the departments into a custom table and used this data to in the budget calculation for the future periods. Also created a custom report to print this data on departmental basis.

Designed and developed interfaces, which take a snapshot of the inventory held by different organisations for monthly inventory reports used by the finance department and transfer demands of Child Organisation to Parent Organisation so that viability of the Child Organisation component demand be maintained within the Parent organisation. These interfaces belonged to Oracle Inventory INV .

Designed the process called Paper Traveller wherein Log Reports could be created on a users default printer, whenever the user created an inventory transaction, by using Oracle Alerts for calling the report from a temporary table, which was populated whenever there was an entry in the MTL_Transactions table. The Reports used tables from Oracle Work In Process WIP .

Was responsible for mapping existing COBOL data-set in IMS system to Oracle RDBMS.

Also is responsible for mentoring two permanent employees belonging to Systems Department in Fuel Systems Plant, by solving their day to day problems and helping them understand standards for development in Oracle Applications.

Environment: Windows NT 4.0, Oracle Applications 10.7SC Oracle 7.3, Developer 2000, PL/SQL, SQL* Plus

Migrated Fixed Assets data from the legacy system to Oracle Fixed Assets. Customized Account generator process for Fixed Assets. Written stored procedures to derive segment values from descriptive flexfields in the account generator process. Developed custom reports and customized oracle GL reports.

Also developed FSG reports for GL Account Summary and other financial reports using Oracle Reports.

Designed and developed a module called RECEIVING INSPECTION. The purpose of this project was to create a receiving audit scheduling, notification and tracking system to resolve a quality functional gap identified in Oracle Applications purchasing and quality modules. The objective of this project was to create this system to be integrated with Oracle Applications.

Was responsible for Analysis, Design, & Development of forms for inspection set-up, inspection results input, test type master and viewing item inspection status. Also helped in creating the User Documentation and System Documentation.

Mostly used the tables belonging to Oracle Inventory and Oracle Purchasing.

Was also responsible for mentoring a permanent employee and two contractors working at Jamestown Engine Plant.

Environment: IBM PC s, LAN Netware, UNIX Servers, WINDOWS NT, ORACLE 7.1, ORACLE FINANCIALS 10SC, PL/SQL 2.1.3, DEVELOPER/2000, DESIGNER/2000 UNIFACE v6.0, ERWIN, INFORMIX

Financial Accounting System

Lead a team of eight, which worked, on a project for a Trading Company based in India and having operations all over Asia. Was responsible for Analysis, Design and Development of this system using DESIGNER-2000, & DEVELOPER-2000 and other related tools on ORACLE database. Was also involved in implementation of ORACLE FINANCIALS 10.07SC, which replaced the old accounting system in a phased manner.

Worked on AP, PO, OE and GL modules of Oracle Financials 10SC. Generated reports using Oracle Reports 2.5 and SQL*Plus. Also was involved in the conversion of old SQL*Forms 3.0 application to Oracle Forms 4.5 GUI environment with referring to Oracle Financials database.

Remuneration System

Undertook System study, Design and Development of Remuneration system for the Field Staff of an Insurance Company based in Ireland. This system was specified using ERWIN, FORMS 4.5, REPORT 2.5 and with ORACLE Database as Back End.

Has lead a team of nine and was involved in the development of Logistics Module of an ERP package for a software company based in Germany. This module catered to the current needs of European market and had features like Multilingual, Multiple currency trading, and conversion of Units of Measurements according to the needs of the user and standards prevalent in the country. This system was developed on UNIFACE v6.0 with INFORMIX v6.0 Database.

Personnel & Human Resource Management System

Was also involved in Analysis, Design and Development of this system for Civil Aviation Authority of Bahrain, using ORACLE 7.1 and Developer 2000. Was the Project Leader for a team of 20 programmers.

Environment: INFORMIX FORMS, INFORMIX FORMS MENU and LIBs, INFORMIX v4.0 database.

Attendance Recording System

This was a conversion project. Was involved with System Design, Development and Training. The Project required converting the existing Attendance Recording System from Clipper dBASE platform to INFORMIX v4.0 platform using INFORMIX FORMS, INFORMIX FORMS MENU and LIBRARIES. Also responsible for the development of generalized subroutines used by various modules in the System. Used STORED PROCEDURES built in ESQLC for performance enhancement.

Human Resource and Development System

This system helped to store personal information of the employees as well as other details like promotions, increments, enhancement courses, experiences and other details for generating various MIS reports. This system was developed using INFORMIX FORMS, INFORMIX FORMS MENU and LIBRARIES on INFORMIX v4.0 database.

Piece Rate Calculation System.

This system captured the number of hours an employee has worked on a particular job for a product on various machines of the factory through data recording equipment attached to these machines. It was developed using INFORMIX FORMS, INFORMIX FORMS MENU and LIBRARIES on INFORMIX v4.0 database. Was involved in Analysis, Design, Development, Testing and Implementation of the system.

Environment: IBM PC s, LAN Netware, Clipper v5.0, Foxbase

Development of Investment Package

Was involved in Design, Development and Testing of various systems like Investment Package, Inventory Control System and Stock Maintenance System.

Up

CAREER OBJECTIVE

To use and improve my skills in providing quality consulting services in the areas of Project Management, Software Configuration Management, Database Design, Application Development, Systems Integration and Oracle DBA support.

RESUME HIGHLIGHTS

• Fourteen years data processing experience with broad exposure to different types of software and hardware, including personal computers, client server, and large scale mainframes.
• Eleven years Oracle experience, including Client Server with the current Oracle tool set.
• Certified in Configuration Management.
• Experienced in systems analysis & design.
• Knowledgeable in all aspects of systems development methodology with practical experience gained while working on major development projects.
• Excellent project management, interpersonal, leadership, and communication skills.

TECHNICAL SUMMARY

Application Development	Experience	Years	Last Used
----------------------------------	-------------	---------	-----------
Application Analysis/Design	Heavy	6 to 8	2002
RDBMS Logical/Physical Design	Very Heavy	6 to 8	2002
Project Management	Heavy	3 to 4	2000
Configuration Management	Heavy	3 to 4	2000

Software	Experience	Years	Last Used
----------------------------------	-------------	---------	-----------
Oracle Designer	Very Heavy	6 to 8	2002
Oracle Developer	Very Heavy	8 to 10	2002
Sql*Net	Very Heavy	5 to 7	2002
Clearcase	Heavy	1 to 2	2000
MS Office Suite	Very Heavy	8 to 10	2002
MS Project	Light	5 to 7	1999
TSO/ISPF	Medium	3 to 4	1992

Programming Languages	Experience	Years	Last Used
----------------------------------	-------------	---------	-----------
Sql*Plus	Very Heavy	9 to 11	2002
Pl*Sql	Very Heavy	8 to 10	2002
Cobol	Very Heavy	5 to 7	2000
Pro*Cobol	Medium	2 to 3	2002
Cobol II	Very Heavy	3 to 4	1992
SQR	Medium	1 to 2	1997
JCL	Medium	3 to 4	1992
IDMS ADS/O	Medium	1 to 2	1992
CICS	Light	1 to 2	1993

Hardware	Experience	Years	Last Used
----------------------------------	-------------	---------	-----------
IBM RS6000 UNIX	Medium	3 to 4	2000
Dec Alpha UNIX	Medium	5 to 7	2000
Dec Alpha NT	Heavy	3 to 4	2000
Desktop PC NT/98	Very Heavy	3 to 4	2000
IBM Mainframe	Medium	11 or more	2000

Operating Systems	Experience	Years	Last Used
----------------------------------	-------------	---------	-----------
Windows NT	Medium	3 to 4	2002
Windows 95/98	Medium	3 to 4	2002
Windows 3.x	Medium	1 to 2	1997
UNIX	Medium	6 to 8	2002
VMS	Medium	1 to 2	1993
MVS	Light	3 to 4	1992

CONSULTING EXPERIENCE most recent first

Currently contracted to EDS as a senior consultant on a government accounting system. Responsibiles included reverse engineering the application into Oracle Designer, training developers in the use of the Oracle Developer tools, and serving on an advisor to project management.

Product Definition: 3 years

Reported directly to Director level management while serving as a Technology Integration & Implementation Manager. As such, represented Product Definition to other Zemmins Engine Co. departments. Served on software selection teams. As an Oracle DBA, supported several Oracle databases. Set up and maintained multiple versions of the Oracle Designer/Developer tools. Designed both the logical and physical data models for PDF and CPL and created the front end application with the Oracle tool set. Created standard documentation practices for these applications. Designed the process for the use of the Clearcase software version control for the development teams. Mentored Zemmins employees in the use of the Oracle Designer/Developer suite.

Warranty Department: 6 months

Completed the analysis, design and implementation of an Oracle database application that determined the warranty status of customer s engines. Wrote the maintenance screens for the application. Trained other contract resources in the use of the Oracle Designer/Developer tool set.

Reliability: 1.5 year

As an application DBA, completed the analysis, design and implementation of an Oracle data warehouse application that support a ten year history of Zemmins engine failure information. Led the data migration and cleanup process. Served on the Zemmins Oracle Designer Case standards committee.

Advanced Fuel Systems: 1 year

Worked with a team that deployed the Oracle based Avalon MRP system. Was involved in modifying the application per user requirements. Created an add-on Indirect Materials system that allowed for the ordering, delivery, and cost tracking of material throughout the Southern Indiana manufacturing plants.

Served as the lead analyst in the migration of a legacy IMS system to a client server Oracle environment. Completed the analysis and documentation of the legacy system, designed the new system, and trained Army systems personnel in the use of Oracle tools.

Analyzed and consolidated several hundred Oracle reports into a few dozen reports. Developed an Oracle front end that allowed users to select reports, modify default parameters and execute the reports for their local office.

Supplied DBA support to the ADMIN/LIMS development team. Created database environments for user training courses. Designed and developed the "CHANGE CONTROL LOG SYSTEM" used by management for logging and evaluating change requests and problems.

Worked on external and internal design, as well as coding screens and programs on the SCHOLAR project; a complete rewrite of their college loan administration system.

Database administrator involved in the installation of a new Oracle database on an Ethernet network running under UNIX. Responsible for the design and development of an integrated database system that would support all phases of the company s daily operation.

Registration and Licensing System:

Participated as a systems analyst in the design and coding of batch reports and control programs. Developed batch programs for converting data from the old to the new tax system.

Accounts Receivable System:

Worked as a subcontracted consultant for Ernst & Young responsible for the primary collections and pursuit batch programs.

International Fuel Tax Agreement System:

Systems analyst, designer, and developer for the Registration and Licensing phase of the IFTA project.

Supported and modified the Internal Computer Software & Equipment Tracking System used for lease payment conformation and internal client billings.

Provided program development and support on an as-needed basis on the Transportation System which tracked and confirmed multiple venders freight billing charges.

Performed research to determine the best, cost effective computer system for the editorial department of the magazine.

Created a Manufacturing BOM system.

Developed a complete inventory control system, including multi-vender price analysis and purchasing. Created a Point-of-sale, Accounts Receivable system for retail/wholesale auto parts store.

TRAINING

Oracle Corporation Educational Services:

Designer/Developer upgrade training - Oracle Open World 1998 & 1999.
Oracle 8 for DBAs
Relational Database Design
Introduction To Oracle For Developers
Introduction To SQL*ReportWriter
Introduction To PL/SQL
SQL*FORMS30 New Features For Experienced Developers

Other:

Object Orientated Analysis and Design
Configuration Management II Certification - Arizona State University.

Up

EXPERTISE & SKILLS

• Ability to architect a custom solution. Design, development, distribution of custom client-server and WEB solutions. Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.
• Solid business practice of the Relational model for OLTP online Transaction Processing database design and architecture. Strong advocate and user of SQL relational Structured Query Language . Use VISIO, ERWin and SILVERRUN for data logical and physical data modeling.
• Strong OLAP OnLine Analytical Processing data warehousing strategies and techniques: snowflake, star, and constellation schemas for the integration of fact and dimension tables, OLAP Services, PivotTable Services, and Extended Multidimensional Query MDX for multidimensional analysis. Strong analytical skills for the understanding and transformation of business data using ETL Extract, Transform, and Load strategies. In the SQL Server world, makes use of DTS Data Transformation Services modules and Visual Basic for the implementation of the ETL process.
• Good customer management skills. Interact and conduct studies, join design sessions JAD , and interviews to gather information. Strong prototyping skills for gathering requirements: make use of Access for client-server, Windows-based interfaces; make use of FrontPage and ADO or Coldfusion / Dreamwaver WEB-based interfaces.
• Designer of graphical user interfaces for best business practices. Master Organizational Development. Full life cycle development experience waterfall & spiral . Prototyping for rapid development and analysis.
• Good interpreter and data modeler for the transformation of data into business information. Extensive use of prototyping techniques to help gather business requirements.
• Use variety of technologies. Among them: SQL Server 7; Access 2000, 97; ORACLE; Office 2000 Integration Developer; VB Script; Visual Basic 6; Active Server Pages; Coldfusion / Dreamwaver, XML, HTML, and other WEB technologies for the rapid integration and prototyping of databases supporting business solutions.
• Information analysis and database mining using SQL, Crystal Reports, Access.
• Strong use of stored procedures, views, T-SQL, Data Transformation System DTS- to provide for flexible and reusable modules to be used in WEB technology or client-server Windows technology.
• Make use of Excel s VBA programming techniques and pivot tables to provide a well-known interface model to Microsoft Access databases.
• Making transition to Microsoft s new operating system and development environment: Microsoft XP and Microsoft .NET dot Net .

Up

SUMMARY:

• More than Six years of strong IT experience in the field of software designing and developing using Oracle 9i ,Oracle 8i / 8 , 11i, Oracle 7.0/7.3, Oracle Web Forms 6i, Oracle Web Reports 6i ,Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Graphics 2.5, GL, AR, FA, AP,PO, Oracle Workflow ,Pro * C, Sql * Forms 3.0, SQL PLUS and PL/SQL, Import and Export under Unix, and Windows NT environment that involves system study and analysis, design, coding, preparation of user manual, testing and debugging of software , implementation and training for users.

• Proficiency in PL/SQL 8.0 programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT. Developed SQL Reports using SQL*PLUS.

• Developed several packages using VBA, Visual Basic 6.0, Crystal Reports 8.0, SQL Server 6.5 and MS Access.

• Good experience with VBScript, ASP, HTML, Java Script, JDBC, Servlet, Jdeveloper, RMI, Java Swing, SQLJ, Visual FoxPro 6.0. Good knowledge of Cobol and C programming.

TECHNICAL SKILLS:

• Internet Technologies : HTML, Java Script, JDBC, XML, Servlet, RMI, Java Swing, Jdeveloper, ASP, Perl , JSP

• Databases : Oracle 7.0/7.3, Oracle 8,8i, Oracle 9i, SQL-Server v 6.5, SQL PLUS 3.10, PL/SQL 2.0, 2.3,8.0 MS-Access v7.0, Oracle 11i, Oracle Server Pages

• Programming Languages : Cobol, C, C++, Pro*C

• GUI Tools : Visual Basic v6.0, Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Graphics 2.5 , Forms 6i, Reports 6i , Power Builder 6.5, Crystal Reports 8.0, VBA

• ERP : Oracle Applications-Financials Rel. 11i GL, AR, FA, AP, Oracle Workflow

• DBMS : Visual FoxPro v6.0

• Operating Systems : Windows 98/95, Windows NT/XP, Unix

• Applicatons : MS Office 2000 ,MS Word , MS Excel, MS Access, MS Powerpoint, MS Project , Lotus 1-2-3

PROJECT EXPERIENCE:

• Involved actively in full life cycle of he project which includes screen design, table design, preparation of user manual, preparation of test plans and development of the program using Developer 2000, Designer 6i & Discoverer.
• Interaction with Development Team in fine Tuning the SQL and PL/SQL 8.0 Codes.
• Implementation of Oracle & Application Software Patches.
• Designed and implemented the extract, transformation, and load of source data into the data warehouse and data marts. This included developing and building the transformation processes using Ardent Data Stage along with custom PL/SQL.
• Used Oracle Portal 3.0 to develop a customer tracking system
• Conversion of existing Forms 5 to Forms 6i and Reports to Reports 6i.
• Developed Forms using Forms 6i and custom reports were generated using Reports 6i.
• Writing database creation scripts & PL/SQL 8.0 server side stored procedures, functions and triggers, SQL*Net installation and configuration.
• The front end consists of Oracle Web forms which allow the user to login and enter the input processing information, such as file name, date, month and year and submit the form for the load process.
• Used Oracle InterMedia, which enables to manage documents, images, audio and video for full Text Search.
• Graphical representation was depicted used Graphics.
• Developed a web application for Customer Signups for internet service using PL/SQL packages , JavaScript, JDeveloper and Html.
• Creation of Users, Roles & Privileges, Table/Index/ Rollback Segments and Constraints.
• Loaded Oracle tables from flat files using SQL *Loader.
• Maintaining a Test & Development Databases.
• Effective use of Oracle Designer 6i ,Developer 2000 & Discoverer for generating .pdf reports according to the client s requirements.
• Developed Test Plans and test cases for coding.
• Provided User Training and dealt with customers of various degrees of computer knowledge.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT.
• Developed SQL Reports using SQL*PLUS.

Scope of the Project: AARP is a nonprofit, nonpartisan membership organization for people 50 and over. AARP provides information and resources; advocate on legislative, consumer, and legal issues; assist members to serve their communities; and offer a wide range of unique benefits, special products, and services for its members.

Environment: Oracle Designer 6i , Oracle Developer 2000 , Discoverer 2000, Oracle 8i/9iAS,11i SQL*Plus, PL SQL 8.0, Oracle Web Forms 6i, Oracle Web Reports 6i, ASP, JavaScript, HTML ,Oracle Portal, Jdeveloper, Windows 95/98/2000/NT-4.0/XP, UNIX HP-UX, Solaris .

• Responsible for converting vendors, sites and contacts from a legacy system into Oracle Payables 11i.
• Provided support of applications to team member.
• Used Discoverer 2000 to set-up ad-hoc queries and reports.
• The package has been designed using Oracle Financial Modules GL, AP, AR, FA .
• Developed Test Plans and Test cases for coding.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT.
• Developed SQL Reports using SQL*PLUS.
• Actively involved in the design and development of a number of custom applications centered around purchase order billing and administration applications. These applications were designed using Unix scripts, SQL*Menu 5.0, SQL*Loader 1.0 and PL/SQL.
• Extensively used Forms/Reports 6i to customize 11i Forms and Reports then attach it to the 11i Application.
• Analysis and design of data flow between the various components.
• Redesigned existing Reports to Oracle Web Reports 6i and 30 new Reports.
• Used FSG to build GL Reports.
• Involved in the implementation of the software.
• Developed Sub Reports & added parameters in Crystal Reports 8.0
• More than 15 Reports were created in Crystal Reports 8.0.
• Fixed reports that weren t working using Oracle Reports, SQR & Crystal Reports 8.0
• Oracle Financials modules include General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets, Cash Management, Order Entry and Inventory.

Project Details: Mostek has implemented the customized packages such as Vehicle invoicing, Spare parts billing, Payroll etc for its Maruthi and Bajaj Dealers.

Environment: The software was developed using Windows 98/ Windows NT/Unix, Pro*C, Oracle Financial Modules GL, AP, AR, FA ., Oracle 11i,8i Forms 6i, Reports 6i, Crystal Reports 8.0

• Table design, screen design and development of the program using Designer 2000,Developer 2000, SQL * PLUS and PL/SQL 2.3.
• Developed Forms and Reports using Forms 4.5 and Reports 2.5. Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Prepared the design specification documents, test plan for all the above modules.
• Provided support of applications to team members.
• Provided User Training.
• Oracle 8 was used as backend.
• Developed SQL Reports using SQL*PLUS.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Analysis and design of data flow between the various components.
• Provided support in the implementation of the project.
• Used SQR, Report writer 2.5 & Crystal Reports 7.0 to generate reports.
• Inventory reports were developed using Crystal Reports 7.0.
• Graphical representation was depicted used Graphics 2.5.

Project Details: The project was undertaken to deliver a proper systematic maintenance of Nightingales Home Health Services. The package was developed to maintain the duty timings of the doctors, nurses and other staff, doctors and other technical staff attendance details, lab maintenance, purchase of new equipments, availability and occupation of beds and rooms, supplier details who supply the medicines and equipment to the lab, stock details in the pharmacy and maintenance of accounts which includes the payments to the staff and the payment made by the patients.

Environment: The software was developed using Windows 98/NT/Unix, Pro*C, Designer 2000, Developer 2000, Forms 4.5, Report writer 2.5, Graphics 2.5 , Crystal Reports , Oracle 8.

• Screen design, preparation of user manual and development of the program using Developer 2000,Forms 4.5, Report writer 2.5, Graphics 2.5, SQL * PLUS and PL/SQL 2.3.
• Provided User Training.
• Prepared the design specification documents, test plan for all the above modules.
• Oracle 7.1 was used as Backend.
• Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Provided support in the implementation of the project.
• Analysis and design of data flow between the various components.

Project Details: It involves the maintenance of customer details who belonged to regular/ordinary category, marketing executive s details and the target assigned to them every month, rate details which describes the various rates assigned to various destinations like local, domestic and international, contract details with various companies .

Environment: The software was developed using Win 98/Unix, Pro*C, Dev/2000 , Forms 4.5, Report writer 2.5, Graphics 2.5 as Front-end and Oracle 7.1 as Backend.

• Development of the program using Developer 2000, SQL * PLUS and PL/SQL.
• Used Oracle 7.1 as Backend.
• Developed database procedures, functions and Packages.
• Developed database triggers and stored procedures using PL/SQL cursors and tables .
• Developed Forms and Reports using Forms 4.5 and Reports 2.5. Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Developed data entry screens and generated code.
• Developed Master-Detail forms for master tables and transaction tables.
• Analysis and design of data flow between the various components.
• Developed SQL Reports using SQL*PLUS.

Project Details: The software was delivered for the maintenance of sales executive s details and the target to be achieved by them every month, customer s details. The project highlights the maintenance of pager master which involves the details of pager booking and issuing date, pager type which the customer is interested in i.e. numeric/alpha numeric and the payment mode i.e. bi-monthly, monthly, quarterly, fortnightly, yearly .

Environment: The software was developed using Win 98/ Unix , Pro*C, Developer 2000, Forms 4.5, Reports 2.5, Graphics 2.5, SQL*PLUS and PL/SQL 2.3. Oracle 7.1 was used as Backend.

• Table and screen design and development of the program using Visual Basic 6.0 and MS-Access.
• Developed data entry screens and generated code.
• Developed Master-Detail forms for master tables and transaction tables.
• Prepared the design specification documents, test plan for all the above modules.
• Extensively used Crystal Reports for generation of Reports.

Project Details: The System study included to give a better management in Controlling the Student admissions, Course management, Student fee collections, Generation of fee receipts, customized Stock maintenance of books, stationeries, lab equipments, purchase of new lab equipments and maintenance of accounts which includes the payments to the staffs, suppliers of lab equipments, suppliers of stationeries and furniture. Staffs details such as staff attendance, staff leave details, classes and subjects handled, payroll were also dealt with. Developed custom VBA application for Excel that creates templates from spreadsheets and updates master XL files.

Environment: The package was developed using VBA, Excel 97, Visual Basic 6.0 , Crystal Reports, MS-Access 97 ,Win/98.

• Preparation of user manual and development of the program using Visual Basic 6.0 as Front end and SQL Server 6.5 as Backend.
• Developed data entry screens and generated code.
• Prepared the design specification documents, test plan for all the above modules.
• Crystal Reports was used to generate the reports.

Project Details: This software was developed to maintain the admission and discharge of patients. It also deals with the Inventory that includes receipts, issues and returns. Doctors, staffs schedule, and their duty lists were also maintained.

Environment: The package was developed for the Hospital using Visual Basic 6.0 ,Crystal Reports and SQL Server 6.5, Win/98

• Development of the program using Visual Basic 5.0 , SQL Server 6.5 .
• Developed Reports using Crystal Reports.

Project Details: The software was developed to maintain the library in a customized way. The maintenance included member details which was categorized into regular and ordinary, their membership details, books available in the library, books issue details, books return details, stock maintenance, book supplier details, payment to the suppliers, generation of receipts for the membership payment and issue of receipts for the fine amounts.

Environment: The software was developed in Visual Basic 5.0 , Crystal Reports, Ms Access.

ACHIEVEMENT:

Certified by Brainbench Oracle Developer 2000.

TRAINING UNDERGONE:

Diploma in Systems Management from NIIT, Chennai, India.
Diploma in RDBMS from Software Solutions Integrated Limited, Chennai, India.
Certificate Course in Advanced Java from Amionics, Chennai, India.

EDUCATION:

Master of Arts Public Administration from University of Madras, Chennai, India.
Bachelor of Arts English Literature from Justice Basheer Ahmed Sayeed Women s College, Chennai, India.

Up

CAREER OBJECTIVE:

A position in IT responsible for the design, development, support and maintenance of new business applications/software products and to leverage the existing ones. Identifying the new requirements to increase the business effectiveness, managing the overall application infrastructure including legacy system migration, process improvements, could be integral to this position.

EXPERIENCE SUMMARY:

Over 8 years of experience in Information Technology that includes: application analysis, design, development, testing, implementation, support and maintenance, preferably using Oracle Tool Sets.

SKILLS SUMMARY:

• Consultative Selling: Develop technical solutions for business clients and implement applications and technologies.

• Product Validation: Validate and troubleshoot product features and ensure user delight.

• RDBMS and related tools: Expertise in Oracle 9i/8i/8.x/7.x, PL/SQL, SQL, Developer 6i/2000, Forms 6i/5.0/4.5/3.0, Reports 6i/3.0/2.5/1.1, Web Forms, Web Reports, SQL*Forms 3.0, SQL*Reportwriter 1.1, Designer 2000 v2.1, stored procedures, triggers, SQL*Loader, SQL*Plus, Import and Export.

• Other tools: TOAD, SQL*Navigator

• Reporting Tools: Oracle Reports 6i/3.0/2.5, SQL*Report Writer 1.1

• Version Control: PVCS, CVS, Visual Source Safe

• Operating System: UNIX SUN Solaris, Sco Unix, HP, IBM AIX, DEC Alpha and Windows 9x/2000/NT. Expertise in writing Unix shell scripts Korn-Shell, C-Shell .

• Programming Language: PL/SQL, C, Pro*C, PERL, CGI, HTML.

PROFESSIONAL EXPERIENCE:

• Worked for Major Clients like British Nuclear Fuel Ltd, General Mills, Adelphia Cable Communications and Orange County Marshal Dept.
• A full-fledged Oracle PL/SQL Back-end / Oracle Forms 6i-Reports 6i Front-end Developer.
• Expertise in development in Developer Forms 6i/Reports 6i.
• Expertise in PL/SQL Scripting.
• New Oracle Forms 5.0/Reports 3.0 development.
• Conversion of Oracle Forms 4.5 to Oracle Forms 6i.
• Creation of many Database Packages, Functions and Procedures.
• Creation of Database Triggers for Data Validations.
• New Oracle Shared Library Creations according to need.
• Creation/Modifications of the Forms 4.5 and Reports 2.5 .
• Making regular changes in the existing Forms Screens and Reports based in the User s requirement.
• Converting the Forms 4.5 screens into Oracle Web Forms and as well as Reports 2.5 to Oracle Web Reports.
• Conversion of Pro*C codes into Forms 6i Screens as well as Oracle Stored Packages.
• Implementation of Oracle Advance Queuing Techniques to interact with C files.
• Preparation of ERD/Data Modeling Design.
• Experience both on Two-tier and Three-tier Systems.
• Interaction with Kenan s ARBOR billing system.
• Used SQL*Loader for data uploading from flat files.
• Wrote PERL routines to extract data from Oracle tables and to Create flat data files.
• Co-ordination with the Front-end Power Builder and Reporting Crystal Reports teams.
• Using PL/SQL Dynamic procedures during Package creation.
• Maintenance of applications using PVCS/CVS/MS Visual Source Safe Version Control tools.
• Testing Forms/Screens/Database Packages based on the approved test plans.
• Co-ordination with the testing team in preparing test plans and test cases.
• Code walks through with team lead/end users on regular basis.
• Creating User Documentation for the applications developed.
• Providing hands-on training for the End users on appropriate screens.
• Preparing test plans and test cases.
• PL/SQL Coding and SQL tuning throughout the development wherever needed.

• Worked for Major Clients like Boy Scouts of America and Radian International Software.
• Expertise in PL/SQL Scripting.
• Expertise in development in Developer Forms 5.0/Reports 3.0
• Preparation of ERD/Data Modeling Design.
• Creation of many Database Packages, Functions and Procedures.
• Creation of Database Triggers for Data Validations.
• Worked on Two-tier and Three-tier Systems.
• Used SQL*Loader for data uploading from flat files.
• Using PL/SQL Dynamic procedures during Package creation.
• Maintenance of applications using PVCS Version Control tools.
• Testing Forms/Screens/Database Packages based on the approved test plans.
• Co-ordination with the testing team in preparing test plans and test cases.
• Code walks through with project managers and others on regular basis.
• Creating User Documentation as required.
• Providing hands-on training for the End users on appropriate screens.
• Preparing test plans and test cases.

• Worked for Major Clients like Amarjothi Exports, Amarjothi Spinning Mills Ltd etc.
• Developed user-friendly applications for various clients using Oracle 7.x/8.0, PL/SQL, SQL*Forms 3.0, SQL*Reportwriter 1.1, Developer 2000 Forms 4.5/Reports 2.5 , SQL*Plus, SQL*Loader, Export, Import, Unix Shell Scripting under Unix/Windows platforms.
• Created technical documents, program specifications and participated in client/user groups interactions.
• Performed basic Oracle DBA activities in projects and had worked as a technical lead for the entire Software Development Life Cycle for some projects.

EDUCATION:

BS in Computer Science and Engineering 1993
Diploma in RDBMS

REFERENCES

Up

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.

Up

SUMMARY

• More than Six of experience in Software, hardware, standalone systems utilizing C, C++, COBOL, Oracle Forms 6i/6.0,Crystal Reports, Designer 2000, Discoverer 2000, Database Administration, Data mining, Data warehouse, Data Modelling, Database programming and Oracle Developer Server 6.0 with a strong educational background, to meet the day today requirements specific to Information Technology.
• Sound Knowledge of Developer 2000, Forms 4.5/5.0/6.0/6i and Reports 2.5/3.0/6.0/6i.
• Expertise includes extensive technical knowledge and experience on ORACLE 8.0/ 7.3/7.1/7.0, Forms 5.0/ 4.5,Reports 3.0/2.5, PL/SQL.
• Hands on experience in writing, testing and implementation of the Triggers, Procedures, Functions at Database level and Form level using PL/SQL.
• Experienced in Database development and Database Administration.
• Robust hands-on project experience in developing in Medical, Pharmaceutical, Financial, Marketing and HR Modules with Oracle Forms 6i/6.0, Reports 6i/6.0, Crystal Reports 8.0, Designer 2000, Discoverer 2000 under Win NT Environment, Windows 95/98/ 2000 and UNIX.
• Experience in Internet Applications with Oracle Developer.

SOFTWARE SKILLS

• O/S : DOS, Windows 95/98, Windows NT and Unix, VMS

• Languages : C, C++ and JAVA 2.0 and PL/SQL, Pro C, COBOL

• RDBMS : Oracle 7.x and Oracle 8i, MS Access 2000, SQL Server 2000

• GUI s : Developer 6i/6.0 Forms 6i/6.0, Reports 6i/6.0 , VC++ 6.0, Visual Basic 6.0, Hansen 7.5

• Internet Technologies : HTML, DHTML, XML, VB / JAVA Script and ASP 3.0

• Reporting Tools : Crystal Reports 8.5, Microstrategy 7.0, Cognos, Web Reports

• Configuration Management: CCC Harvest 4.1.2

PROFESSIONAL EXPERIENCE

• Customizing sales procedures area wise and region wise.
• Wrote DDL statements and triggers in oracle forms.
• Involved in database design.
• Automated the recognition of agencies doing more business and inventory maintenance
• This application is used to effectively retrieve, view and update inventory information for raw materials required in this manufacturing site.
• Developed Database using Oracle 8.0
• Prepared Software Requirements Specifications and Design Documentation.
• It is an on-line system for maintaining the information about the required Materials and related order.
• This generates the reports like list of the vendors, their supply schedule, actual deliveries and Inventory level of raw material to be maintained periodically.
• This project provides the information like Date- wise index, Item-wise index and Material-wise index

Environment: Oracle 8.0,Forms 5.0, Reports 3.0, Web Reports, Designer 2000, Crystal Reports 8.0, Windows 98/NT, PL/SQL, SQL and Unix

Description :

SmartTrans will maintain all the highways in California. This project will mainly deals with all the systems which comes under the Department of Transportation.IMMS Integrated Maintenance Management System envisaged as a replacement for 7 existing Systems running different databases. Hansen v7.5 will be the central database maintenance application for all systems of SmartTrans.

• Business Process Reviews, developing Business Process Procedures and Change Control Procedures.
• Developed different types of reports using Crystal Reports 8.0 & 8.5
• Developed Critical reports like Accidental Damage Claim ACD , which involves more than 20 tables from the Database.
• Interacted with Users for analyzing various Reports created Sub Reports for ADC report.
• Involved in creating various Web Reports.
• Analysis, design and development of customizations into Hansen v7.5.
• Analyzed and designed the various Stored Procedures, Triggers to be created at the backend database to cater for the entire for the application.
• Developed different types of Reports using Crystal Reports 8.0 & 8.5
• Involved in Unit Testing of various kinds of Reports
• Designed and developed an innovative, real-time transaction system using Oracle 8i stored procedures, triggers
• Involved in functional specification, test plan and Documentation.

Environment: Oracle 8i, Hansen v7.5, Seagate Crystal Reports 8.0 & 8.5, CCC Harvest 4.1.2, Citrix ICA, Windows NT 4.0 and Unix.

Description : Medical Records Department maintains all the data of the patients. This project stores all the information in a database, which has 8 tables in it. The retrieval, modification of the data is done by the user through the forms. Six forms are used in the project. The project has four modules namely General, Inpatient, Outpatient, Reports.

General: This module takes all the details regarding the patient such as registration number, which is generated automatically and is unique, name address etc. This module also provides modification of existing patients and addition of new patient information. Searching for the registration number of existing patient can be done easily through search for the option.

Outpatient: All the details such as provisional diagnosis number, unit number etc. is taken for the patients that are treated outside of Hospitals. The registration number in this module is reflected from the General module.

Inpatient: If the patient is admitted into the hospital, all the details such as provision diagnosis number, discharge status, ward, unit etc. are gathered. If the patient is refereed from court this module also takes care of sending letter to the court. Regarding his discharge and the present status.

Reports: There are lots of reports used for monthly, yearly, fortnight etc. which are taken care here.

• Installing and configuring Oracle 8.0
• Analyzed and designed the various stored procedures, Triggers to be created at the backend database to cater for the entire for the application.
• Scheduling maintenance jobs and monitoring.
• Designing Back up and Recovery strategies.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed Front end with Forms 6.0
• Design and development of screen interface using SQL*Forms, Reports and Menu layout.
• Database designing and normalizing using Designer 2000.
• Responsible for performing various database administration duties using advanced querying protocols and PL/SQL scripting techniques.
• Interacted with Win NT administrator and with other team members for linking the various modules and ensuring the proper sequence flow of the application.
• Maintaining the applications on the production servers.
• Providing the logical data model design, generating database, resolving technical issues, and loading data into multiple instances.
• Leaded the reporting subsystem including the administration of the tools and reports, designed and maintained a library of reusable code, which all programs used to develop their reports
• Developed different types of Web Reports using Oracle Reports 6.0
• Developed programming standards, web form templates with menu driven facility, libraries of reusable code, oracle stored procedures and functions and row level and column level security using Roles for the development effort

Environment: Oracle 7.x/ 8.0, Forms 5.0/6.0, Reports 3.0/6.0, Web Reports, Designer 2000, Crystal Reports 6.0, Windows 98/NT, PL/SQL, SQL and Unix

Description : The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries. The following are the modules:

• Master Information
• Transaction entry
• Data import
• Report module
• Query module

• Responsible for system study & information gathering.
• Participated in-group meetings
• Primary responsibilities include preparing Data Flow Diagram, Process Model, Data Model & working prototype along with other members of team.

• Implemented a new database design using Designer/2000 in an Oracle 7.3 environment.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Responsible for performing various database administration duties using advanced querying protocols and PL/SQL scripting techniques.
• Installing and configuring Oracle 7.3
• Performed full Data base administration, Schema design tasks, including development of design specification standards, Procedures for system development
• Analyzing and designing of the Physical and Logical Database
• Provided guidelines for naming conventions, screen design using Forms 4.5
• Analyzed and designed the various Stored Procedures, Triggers to be created at the backend database to cater for the entire for the application.

Environment: Oracle 7.3, Designer/2000,Forms 4.5 and Reports 2.5, Data Reports, Windows 98/NT, Unix, HTML, Unix.

Description : The system helps to maintain all the details of agents, subscribers and their requirements through Agent Invoice, Credit Note, Journal, Ledger, Agent Deposits, Supplier Register, Receipts and Control Expenses. On the basis of the above information following MIS Report is generated, Circulation Progress Report, Publication Consumption, Agents Performance, Publication wise agent summary, dues check list Sundry debtors . Most of the MIS Reports are in Graphical Mode for a better understanding.

• Analyzed and designed the various Stored Procedures, Triggers to be created at the backend database to cater for the entire for the application.
• Developed different types of Reports using Oracle Reports
• Involved in drafting Production Schedule Procedures.
• Involved in Unit Testing of various kinds of Reports
• Designed and developed an innovative, real-time transaction system using Oracle 8i stored procedures, triggers
• Provided database maintenance, resolved technical problems in respect to performance of the database such as tuning SQL statements
• Involved in functional specification, test plan and Documentation.

Environment: Oracle 7.3, Forms 4.5, Reports 2.5, PL/SQL, SQL, NT and Unix

Description : The sales module, which is a part of whole Enterprise Resource Plan ERP , takes care of the Organization inward flow or raw material to the manufacturing unit. With the usage of basic definition date of the computerized organization, the system integrates the data by working with the sales system developed in view of the criteria of CMIS in an ERP package. The following areas of functional activities are customized. Data is integrated with GL Heads, which are required for the generation of Financial Statement by fixing with respect to budgeting amounts. The transaction activities are totally controlled by the budget. Each transaction is stored separately in the respective table of front-end, audited by the audit tables and posted to the GL Heads. The need that the database is taken here for storage of data is to provide Data Integration, which is a primary requirement of an Enterprise. The following activities are defined in the system :

• Companies of transaction
• Location/stations at which the transaction take place
• Departments in which the work is going on
• The banking transaction of the financial year
• The tasks schedule sales/custom/excise
• The parties which are involved Viz., customer, suppliers, brokers etc.,
• The mode and test of packing the finished goods.
• The product which was purchased or sold
• The daily pricing schedule
• The contracts, invoices, price-lists etc.
• Mode of sales, involvement of transportation
• Documentation and cash/credit details
• The respective report.

• Implemented a new database design using Designer/2000 in an Oracle 7.3 environment.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Involved in Unit Testing and Documentation design.
• Developed Reports using Oracle Reports 2.5 and Data Reports.

Environment: Oracle 7.3, Forms 4.5, Reports 2.5, Windows 95, PL/SQL, SQL Loader, HTML and Unix.

Description : It consists of 4 modules Production, Sales, Inventory & MIS.

Production: This part allows daily production and blend transaction Entering and updating and call pullout various reports like Daily production, Monthly Production, Report day and Brand wise . This also updates the utilized packing material in the inventory part when enter or update daily production in order to avoid entering data separately.

Sales: This allows daily sales transaction of various finished products available in different sizes and different firms, the purchase orders received and report like billing invoices and delivery challans, pending order left over for the further production during the given period. Daily sales purchase orders received, balance of purchase order and finally the stock statement.

Inventory: This allows addition and edition of various packing Materials Bottles, Caps, Labels, Mono cartons, Master cartons and etc. , other general items which were consumed during the process of production like Filter papers, Adhesive tapes etc. received, rejected, transferred to other units and wastage during the production.

Mis: This consists only reports, which were required to top, level management. We can pull out reports like daily performance reports. Monthly packing material statements, spirit position, packing material statement.

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Implemented a Database design using Designer/2000 in an Oracle 7.3 environment.
• Designed the database based on requirements of the system.
• Designed the User interface for forms with developer 2000 features.
• Generated necessary reports periodically using Reports.
• Created the database, table spaces, tables, indexes and other database objects.
• Loaded the data into the Oracle database using SQL Loader
• Responsible for performing various database administration duties using advanced querying tools and PL/SQL scripting techniques, Procedures.
• Responsible for troubleshooting various aspects of the client/server architecture in both a Unix and an Oracle setting.

Environment: Oracle 7.3, PL/SQL, SQL, Developer 2000 Forms 4.5, Reports 3.0, Unix and Windows 95.

Description : This project mainly deals with employee salaries and their benefit schemes and also it deals with employee performance, experience, health insurance, newly acquired qualifications and their performance in the various companies.

Role :

• Designed and Developed the Payroll Information Systems Database.
• Implemented a new database design using Oracle 7.3 environment.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Involved in Enhancements of both the systems in COBOL. The database and online features involved Oracle and CICS.
• Responsible for performing various database administration duties using advanced querying protocols and PL/SQL scripting techniques.
• Responsible for troubleshooting various aspects of the client/server architecture in both a Unix and an Oracle setting.

Environment: Oracle 7.3,PL/SQL, SQL, Visual Basic, Windows 95,COBOL

EDUCATION :

MASTER OF BUSINESS ADMINISTRATION MBA .
POST GRADUATE IN MANAGEMENT INFORMATION SYSTEMS AND COMPUTER APPLICATIONS.
GRADUATE IN PHARMACY B.Pharm .

Up

Profile

• Has 7 years of wide range experience in the Information Technology industry. My strongest skills are in all phases of SDLC Software Development Life Cycle, User interaction, On-call and Help desk support of various applications developed in Oracle 9i/8i/8.0.5/7.3, Forms 6i/6.0/4.5, Reports 6i/6.0/3.0/2.5, PL/SQL, Oracle Web Server 4.0/3.0, C, Pro*C, SQL Forms 3.0, EDI Electronic Data Interchange , HP-UX, Sun O/S, AIX, Sco Unix and Windows NT environment.

• Having strong technical, written and communication skills.

• Strong experience with Telecommunications, Banking and Financial applications

Academic Background

• Master of Computer Applications from Andhra University, India 1992 - 95
• Bachelor of Computer Science from Nagarjuna University, India 1989 - 92

Technical Skills

• Hardwares: HP-9000 series, Sun Sparc Servers, RS-6000, Sco Open Servers, Dec Alpha, IBM PC Compatibles, Diebold ATMs

• O/S: HP-UX 11.0, Sun O/S 5.8, AIX 4.0/3.0, Sco Unix 5.05, Digital Unix, Windows NT/Me/00/98, Novell Netware 4.1

• Databases: Oracle 9i/8i/8.0.5/7.3.4/7.1.6, Sybase 11.9.2, SQL Server 2000/7.0/6.5

• Languages: PL/SQL, SQL*Plus, Pro*C, C, C++, EDI, HTML, Java, Perl, Shell Scrpting and MS-Excel

• Tools and utilities: OEM, TOAD, SVRMGR, SQL*Loader, EXP/IMP, TKPROF, EXPLAIN PLAN, SQL TRACE, RMAN, e*Gate, Net8

• Web Servers: Oracle Web Server

• Front end tools: Designer 6i, Developer 2000 Oracle Forms 4.5/5.0/6.0/6i, Reports 2.5/3.0/6.0/6I, Graphics 2.5 , SQL Forms 3.0, Power Builder and Visual Basic

• ETL Tool: Informatica 4.6

• Case Tools: Designer 2000, ERWIN

• Others: GXS AI Application Integrator , ATM Automated Teller Machine

Professional Experience:

Zwest is one of the telecom majors in US and sole local service provider in 14 states of United States. IMA system enables Co-providers like AT&T, MCI, Sprint, Ameritech etc. to access the Zwest Network for purchasing certain services on a wholesale basis and resell these services to their customers. IMA supports EDI and Java GUI.

Multi-mailbox is an EDI transaction tracking database which stores EDI inbound and outbound transactions. As Zwest implements multiple machines to accommodate production EDI transactions, multiple instances of EDIOPEN/GXS translator must also be implemented.

The purpose of this application is to determine which system received and processed a specific transaction, find the status for that specific transaction, ensure that the CLEC s functional acknowledgements inbound 997 for Zwest s outbound transactions will not return to the issuing translator making reconciliation more difficult.

• Analysis and design of the the complete system for Multi-mailbox
• Logical and Physical data modeling using Designer 2000 and Erwin
• Extensively used Oracle Web Server and PL/SQL for development of the system
• Created several SQL Plus reports and queries for IMA EDI users
• Developed many stored procedures, triggers, functions and packages used for the system
• Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQL TRACE
• Implementation and support of the system and several third party applications
• 24X7 Production Support on a rotation basis
• Population of the datawarehouse tables using SQL*Loader
• Developed many scripts using perl and Ks
• scripting
• Developed test plans for system and Unit testing of some third party products Interactive agent, EDIHub and Recovery Manager
• Underwent the Corporate training for EDI mapping using GXS AI Application Integrator
• System and Regression testing of the Multimailbox

Environment: Oracle 9i/8i/8.0.5/7.x, Oracle Web Server 4.0/3.0,SQL, PL/SQL,Perl, HP-UX 11.0, AIX 4.0/3.0, Windows NT/2000, SQL Plus, Java, C, HTML, DHTML, ERWIN, Net8, OEM, GXS AI Application Integrator , EDI and TOAD

This project is installation, configuration and maintainence of EDI/GXS translator error monitoring processes. Once installed and configured these processes activity monitor data during EDI translation and 1. Capture EDI errors 2. Process and Report errors 3. Nightly maintenance routines and utilities 4. On going administration of the process. Errors are reported via a HP-Open View interface file. If HP-Open View is not used the Optional Email/Text page Alert processes may be configured to email or page predefined individuals when errors occur.

• Developed many stored procedures, triggers, functions and packages and implemented them successfully
• Coding using Pro*C and Ks
• Scripting
• Development using Oracle Forms and Reports for enhancements of EDI Translator
• Installation and configuration of the error monitoring processes on all EDI boxes
• Implementation, Maintenance and Trouble shooting of the project
• 24X7 on-call production support on a rotation basis
• System testing of the various utilities and programs

Environment: Oracle 8i/8.0.5/7.x, Forms 6.0/4.5, Reports 6.0/3.0/2.5, SQL, PL/SQL, C, Perl, HP-UX 11.0, Sun O/S 5.8, Windows NT, C, SQL Plus, RMAN, Net8, OEM, Sybase 11.9.2, GXS AI Application Integrator , EDI and TOAD

There are several third party products those will be taking care of verifying, transferring and archiving IMA-EDI data inbound and outbound transactions for ex: 850, 855, 860, 865, 997 etc between Zwest and it s CLECs Competitive Local Exchange Carriers . Interactive Agent, EDIHub, Recovery Manager, EDI and GXS translators are main applications used in IMA-EDI environment. These products are developed in PL/SQL, Oracle, Java, C, C++ and Unix shell scripting.

• Installation of Zwest third party products used in IMA-EDI
• Development of PL/SQL stored procedures, triggers, functions and packages
• Migration of existing applications from Forms 4.5 to 6.0 and Reports 2.5 to 3.0
• Created numerous wizards, forms and reports using Oracle Forms 6.0 and Reports 3.0
• Handling the networking problems with IMA-EDI Oracle databases
• Development of system and Unit test plans for several third party products Interactive Agent, EDIHub, Recovery Manager and GXS translators
• Performing system and unit testing of Interactive Agent, EDIHub, EDI and GXS Translators
• 24X7 on-call production support on a rotation basis
• Technical Documentation
• Unix scripting using Perl and Ksh
• Coordinating between vendors and client regarding the enhancements and bug-fixing of the new releases of IMA EDI products

Environment: Oracle 8i/8.0.5/7.x, Forms 6.0/4.5, Reports 3.0/2.5, SQL, PL/SQL, C, Perl, RS 6000,HP-UX 11.0, Sun O/S 5.7, RS 6000, Windows NT, C, C++, Java and SQL Server 6.5/7.0

Integrated Standard Banking System ISBS is a huge banking application, which deals with several areas of retail banking. It has several modules named Savings, Curent, Deposits, Loans ,ATM and foreign exchange transactions.

• Installation and configuration of Oracle Databases and Unix O/S
• Coding using Developer 2000 Oracle Forms and Reports as part of the enhancements
• Implementation and Maintenance of client applications
• Unix System Administration
• On-call and Helpdesk support
• Backup and recovery of the databases
• Writing several utilities using PL/SQL, Pro*C, SQL Plus and Shell scripting
• Customizing several MIS reports according to the client s requirements
• End user training

Environment : Oracle 8.0.5/7.3.4, PL/SQL, Pro*C, Developer 2000 Forms 4.5 and Reports 2.5 , Sun O/S 5.6, Sco Unix 5.05, SQL*Forms 3.0,Windows NT/98

ISBS 4.05 included a lot of enhancements and this is a migration project from ISBS 4.02 to 4.05.It has some new modules like ATM Automated Teller Machine and automation of Demand Draft s processing etc.

• Implementation of the ATM s
• Development using Oracle Forms 4.5 and Reports 3.0/2.5
• Unix System Administration and Shell scripting
• Implementation of the project which includes loading of new software, conversion processing and Y2K processing of entire data using several utilities
• Performance tuning of the application programs
• Coding and testing several utilities according to the requirements of several branches

Environment : Oracle 7.3.4, Pro*C, Sco Unix 5.05, Oracle Forms and Reports, SQL Forms 3.0,Windows NT/98

ISE Interconnected Stock Exchange has 15 centers all over the country and having the central office at Mumbai.Every member should have a current a/c pay-in and pay-out in any of the ISE 15 centers. Wherever the business is being done by the shareholders his/her account will be updated on-line and an advice will be sent to central office immediately.

• Implementation and maintenance of the project
• Database Administration
• Development using Pro*C, PL/SQL and Shell Scripting
• Customizing MIS reports and other utilities

Environment: Oracle 7.3.4, SQL Server 6.5, Forms 4.5, Reports 2.5, PL/SQL, Pro*C, Sco Unix 5.05, Windows NT/98

Branch Computerization is a project of converting the banking application softwares from Foxpro and COBOL to Oracle and Unix environment in several branches of the bank.

• Migration of applications from FoxPro and COBOL to Oracle and Unix
• Coding using Pro*C, SQL*Forms 3.0 and Shell Scripting
• Installation of ISBS software
• Maintenance of the new and existing products
• Migration of data
• End user training
• Applying patches regularly for the existing application softwares and Unix.
• Underwent corporate training on General Banking

Environment: Oracle 7.1.6, Pro*C, Sco Unix 5.04, Forms 3.0, Foxpro,COBOL and Windows 95

BPRO is a product developed for supporting the retail banking operations. Some of the modules are Savings, Curent, Clearing, Deposits and Loans.

• Analysis, design, coding and testing
• Implementation and maintenance of the product in client sites
• User interaction and getting the enhancement requirements

Environment: Powerbuilder 4.0/5.0, Sybase 11, LAN, Windows NT/95

Any NRSA employee can join NRSA CCS department by following certain procedures .A CCS member can be eligible for investing on Recurring and Fixed deposits and getting some kind of loans.This project is automation of entire NRSA CCS operations.

• Analysis of the requirements
• Design, coding and testing of the software
• Implementation of the software

Environment : Powerbuilder 3.0, Sybase 10, LAN, Novell NetWare

Up

OBJECTIVES:

A senior level Oracle developer / programmer analyst position permanent / contract on corp.-to-corp., independent or employment base in software, financial or manufacturing sectors with database, inter-/intra- net, e-commerce development or application. Willing to take part of Oracle DBA duty.

PROFILES

Highly innovative Oracle developer with DBA skill with over 10 years IT working experience in software, manufacture, R&D, academic environments, including:

• 6+ years Oracle programming / analysis / database design experiences using Developer 2000 / Developer 6/6i, Designer 2000 and PL/SQL developing large system in software environment aiming tour operation industries, warehouse management system WMS in manufacturing environment and ADP / PeopleSoft human resources applications.

• Profound understanding of entity relationship ER design and Oracle Database both from system and application sides .

• Oracle Certified Professionals OCP for both Developers and DBA.

• More than 5 years experience in modeling, architecture, designing, coding, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms.

• Familiar with the strategy, logistics and methodology for the life cycle of software development. Fair to good understanding of business processes in accounting, marketing, inventorying, manufacturing, human resource and financial.

• Good verbal and excellent written communication skills, able to relay technical information to non-technical staff and fellow developer.

• Effective team player and quick learner.

COMPUTER SKILLS

• Oracle / Database: Fluent in RDBMS, Oracle 7.x/8.0.5/8i, SQL*Plus, PL/SQL, Developer/2000 2.0/2.1/6i, Form 4.0/4.5/5.0/6, Report 2.0/2.5/3.0/6, SQL*ReportWriter1.1, PB 1.5, SQL Loader, Report Server, Stored Procedure, Graphics 2.5 and ProC, Oracle Enterprise Manager, DBA Studio, Designer 2000, Discover 3/4, ERWin 3.5, Toad v.5-7 Quest software , SQR v 4.3 , 9iAS. Knowledge of Oracle Applications and Peoplesoft

• Language: C, Java, Visual Basic 4/5 , Basic, Fortran and Assembly, Cobol, FoxPro 2.5 , Some C++

• Platforms: MacOS 7.0-9.0 , Windows NT, 2K, 9x, 3.x /DOS, Sun Solaris 2.5,2.6 , SunOS 3.5,4.0 , Citrix MetaFrame, RedHat Linux 6

• Web/Net: HTML, ASP, InterDev, JavaScript, Web Authoring, Web Server Construction, Netscape Suite / IE, Telnet, Ftp/fetch, Gopher, Internet Conferencing

EXPERIENCE:

• Creating new Warehouse Management System WMS using Developer 6i From & Report 6i in client/server and web mode on Oracle 8i databases. Designing, implementing and testing security control in various levels database, application and fine grain access control
• Participating WMS data modeling, prototype design, document preparation; Creating form templates, object libraries and generic package/stored procedures for standardization of the WMS application. Developing stored procedure based forms to integrate with legacy system.
• Designing, creating or modifying payroll, benefit and human resource applications based on Automatic Data Processing ADP / Horizon Corp s ERP application Platinum Human Resource Management System HRMS / Payroll using SQR, SQL languages in a Citrix MetaFrame environment with Oracle database and PeopleSoft backend.
• Modifying, tuning and trouble-shooting current STONE inventory and process control system with Oracle Developer 1.2 Form 4.5 and Report 2.0 and current Stash agriculture management system with Oracle Developer 6 Form 6 and Report 6 .
• Installing Oracle 9iAS middle-tier and configuring Form Server for internet deployment of current OLTP / DSS applications.
• Converting current applications total over 300 modules to version 6i in client/server and web-centralized mode. Participating architecture design and migration of enterprise wide multi-tier system with different version Oracle server backend.
• Creating Oracle databases for development and repository on IBM AIX and PC NT 4 based machines and configuring instance parameters, storage layouts, rollback segments, database links and Net8 architecture with Oracle Enterprise Manager OEM , DBA Studio and Toad; Importing and mapping data from current systems including EDI legacy system with various tools such as SQL Loader and Import / Export utilities.
• Tuning and optimizing current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Assisting Senior DBA with configuring Oracle Name server, load balance and fine-tuning production database parameters and providing assistance for database related errors from individual plants across North America. Also cooperating with DBAs and production personals for annual database purge and rollover.
• Creating and implementing ad hoc reports using SQL and SQR for various users in different environments. Also providing technical supports to end users in different locations.
• Installing, configuring and administering Visual SourceSafe 6.0 for the version control of various applications

• Participated the system design business analysis, ER, and table definition of the comprehensive and complicated Centre Reservation System CRS software consisting of more than 900 modules and 300 tables, developed with Oracle developing tools in the front-end and run on Oracle databases in the back-end targeting leisure and international travel suppliers, with major subsystems including Booking, Financial, Product, Management, Costing, GDS, Sales and Operations.
• Responsible for designing, coding, modifying and debugging TourTek s Financial subsystem AP, commission, contract, GL, insurance, disbursement, recovery, supplier check ; Most of AR subprogram pricing, sales, invoice, cash receipt, refund, check printing ; Part of Inventory Management; Most of Costing section and part of Reservation, using PL/SQL, SQL* plus, Form, Report, graphics, ProC and PVCS version control tool. Have developed and modified more than 300 forms, reports, procedures/functions and libraries.
• Coded and tuned large PL/SQL stored procedures more than 20 thousand lines of codes for Payable subsystem and enhanced the performance through the fine-tune of queries and creation of appropriate indexes, tablespaces and rollback segments.
• Worked closely with QA s/testers and business analysts for development, modification and implementation of new and existing modules.
• Integrated TourTek application with VSI Fax server, report server and InterOffice to provide automatic or background process.
• Integrated Microsoft Office products Word, Excel with application program.
• Written server and client side PL/SQL procedure and scheduled the execution of large batch transaction process and massive reports through background job process and report server.
• Prepared specification and documented results for the design and development database objects; Instructed and lead new or junior Oracle developers in business rules, programming analysis, coding standards and preliminary test method.
• Helped Installation of Oracle database 8 and 8i and developer tools on server and client machines in Window NT, 9x and Unix DEC environments and configuring the Net setting. Assisted configuration and modification of database storage structures and allocation.
• Created and altered database tables, defined user roles for developing environment of 10G data size using Oracle Enterprise Manager.
• Interacted with clients through remote database connection and internet for demonstration, debug of the application in a production environment.
• Involved conversion / upgrade / regeneration of application modules from lower versions to higher ones.
• Worked on Translation Builder and compilation of resource files for the future use of TourTek application in multiple language environments under client/server or multi-tier architecture.

• Modeled, designed and programmed and debugged program for color formulation database and processing optimization software ColorMaster, SolutionOne using Access, Oracle 7.x, VB, Crystal Report and C for high end office furniture company s project.
• Converted and imported Company s unique color information database from various source access, excel and DB2 to Oracle 7.x.
• Developed new formulation using optimization software and spectrophotometer and fine-tuned the pigment/dye ingredients to match client request using drawdown and trial and error method; Input the final formulations into color database.
• Setup and integrated Colorimeter and other testing device with PCs for automatic in-line motoring of processes and products,
• Documented standard operation procedure and trained new tech members and production staff for the use of these instruments.
• Developed system maintenance utilities and automated test tools using script to improve efficiency.
• Created unit test and integrity test plans and test cases, executed test cases and documented the test results.
• Implemented existing programs by making modifications as required.

• Participated in a cooperative project of polyamines s biological function and responsible for development and implementation of the hardware and software for highly sensitive chromatographic and chemiluninescence detector.
• Set-up procedure and standard for the comparison in their sensitivity of various analytical detector and dialogistic method.
• Participated in modeling, designing and developing application software that tracks and simulates the revolution tree of living species based on their polyamine content.
• Helped setup and maintenance of the lab s Macintosh computer network through AppleTalk protocol and Ethernet card, and connected to Bitnet. Configured SCSI and SCSI-2 and other device or peripheral, as well as maintenance of IBM PC s 386,486.
• Performed weekly backup of whole research lab s data with backup tape and Retrospect.

• Designed and developed driver for automatic analytical instruments using C, Fortran and Assembly;
• Designed chromatographic and mass spectrum database for information analysis Fingerprinting using FoxBASE 2.0, 2.1 , DOS FoxPro 2.5, FoxPro 2.6 for Window, Microsoft Access.
• Instructed senior / graduate courses: the application of microprocessor in the analytical instrument

CERTIFICATIONS OCP

Oracle Certified Professional - Internet Application Developer 6/6i.
Oracle Certified Professional - Oracle Application Developer Rel. 1 and Rel. 2 .
Oracle Certified Professional - Oracle 8 DBA
Oracle Certified Professional - Oracle 8i DBA in preparation

EDUCATION AND TRAINING

Oracle Application 11i Introduction, Oracle Corporation, USA
Certificate, Oracle 8i Database Administration, Mountains College, Canada
Certificate, Java Programming, Seneca College, Canada
Certificate, Marketing, Harvard University, USA

M. S. chemistry , Michigan Tech. University, USA
B. S. computer science , Fuzhou University, China
B. S. chemistry , Fuzhou University, China

INTERESTS

Up