Resume # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Resume 1
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.
Rao Varkari
ST. PETERSBURG, FLORIDA
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 80×86 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 :
For Oracle 8i Server as Back-end :
- Very high level of PL/SQL programming
- Database Triggers
- Stored Package & Procedure
- Views, Sequences etc.
DEVELOPER-2000
- 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 :
For Oracle 8 Server as Back-end :
- Database Triggers
- Stored Package & Procedure
- Views, Sequences etc.
DEVELOPER-2000/ DESIGNER-2000
- 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 :
For Oracle 8 Server as Back-end :
- Triggers
- Stored Procedures
- Views, Sequences etc.
DEVELOPER-2000
- 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 :
For ORACLE 7.3 Server as backend :
- Triggers
- Stored Procedures etc.
DEVELOPER/2000
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
Role : Module Leader
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 :
For ORACLE 7.3 Server as backend :
- Triggers
- Stored Procedures etc.
- Views
DEVELOPER/2000 :
Used almost all important features. Some are mentioned below:
- 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
Role : Programmer
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 :
For Oracle 7.0 Server as back-end :
- Database Trigger
- Stored Procedures
- View, Sequence
Forms 3.0, Report 1.1 & Menu 5.0
- 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
Role : Programmer
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 :
For Oracle 7.0 Server as back-end :
- Database Trigger
- Stored Procedures
- View, Sequence
Forms 3.0, Report 1.1 & Menu 5.0
- Used all features
REFERENCES
Available upon request
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.
Resume 2
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.
Shrini Bamati
Newark, NJ
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:
March 2001 Present
Applewood eCom, Applewood, NJ
Programmer/Analyst
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.
July 2000 February 2001
Boston Speakers Inc., Boston, MA
Programmer/ Analyst
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.
The Row Sets, Column Sets, Content Sets and Reports are built by me. Also these are tested by me . The following are few of the reports.
- 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.
November 1999 June 2000
ToysRus.com, Fort East, NJ
Programmer/ Analyst
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.
July 1999 – October 1999
Center for Claims Resolution, Applewood, NJ
Programmer/ Analyst
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.
Environment : Oracle Financial Ver.11.0.3 Account Receivables Role:
- 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.
Jan 1999 – June 1999
State Department of Community Health, MI
Programmer/ Analyst
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.
July 1998 Dec. 1998
Pepsi-Cola Company, Concord, NY
Programmer/ Analyst
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
Jan. 1998 to Jun. 1998
ABC Software Inc., HOUSTON, TX
Role: Programmer/ Analyst
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.
This development work was done using Forms 5.0 and Reports 3.0 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.
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.
July 1997 – December 1997
Torren Standard, Hartford, CT
Programmer/Analyst
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.
August 1993 – June 1997
VideoElectronic Services Ltd., India
Team Lead/ Programmer Analyst
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
March 1991 – July 1993
Lodha Group of Companies, India
Analyst/Programmer
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
August 1989 – February 1991
Image Computer Systems Pvt. Ltd., India
Programmer
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.
Environment : Oracle 5.0, Pro*C, SQL*PLUS, Clipper 87, FoxBase, Novel LAN 3.1, DOS 6.x
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
Resume 3
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.
Rob Hoover
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:
Port of Annibal, Annibal, CA
November 01 Present
Database Architect/Developer
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.
Cisco Systems, Santa Clara, CA
August 2000 November 01
Data warehouse Developer/DBA
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
County of Alameda, Annibal CA
April 2000 – July 2000
LEAD Analyst
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
Verizon, San Antonio, TX
April 1999 – April 2000
LEAD Business Analyst Developer
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.
Rosco Corporation, Sacramento, CA
Sep. 97 – March 99
Lead Programmer/Analyst/Administrator
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.
Responsibilities Included:
- 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.
Chevron, Raymond, CA
Feb. 97 – Sep. 97
Web Applications Developer/Analyst
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.
Global Vessing, Sunnyvale, CA
June 96 – January 97
Technical Business Analyst
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.
Coding test cases to test the assertions
- 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.
Devew Communications, Santa Clara
Jan 95 – June 96
Technical Business Analyst
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.
Good Bargains, Brisbane, CA
Jun 94 – Dec 94
Technical Business Analyst
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
Sybase, Sommerville, CA
Feb 93 – May 94
Analyst
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
Software Fine Systems, San Jose, CA
August 90 – Jan 93
Analyst
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:
Masters in Engineering, University of San Francisco, CA
Resume 4
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.
Alain Blaw
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
June 2001-Present
Essilor of America, Dallas, TX
TeamLead
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.
February 2001-May 15, 2001
General Electric
Financials Lead
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.
August 2000-January 2001
Oracle Manufacturing & Financials
Project Manager.
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.
July 2000
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.
April 2000-July 2000
Whitemeteor, Chicago, Illinois
Team Lead
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.
August 1999-March 2000
Vaxair, Indianapolis, IN
Team Lead
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.
April 1997-July 1999
Selena Chemical Company, Memphis, Tennessee
Project Manager
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.
January 1996-April 1997
Sawer Greenhouses Inc., Denver, Colorado
Project Lead
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.
June 1995-December 1995
Modern Technology, San Jose, Ca
Oracle Order Entry Lead.
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.
May 1995
Administered an Oracle Manufacturing presentation, at the Los Angeles Oracle Users Group conference, in Norwalk California, to improve the visibility of the Application Group.
December 1994-May1995
Plussign Inc., Greenville, TN
Project Lead.
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.
September 1994-December 1994
Robertson Co., Boston, Massachusetts
Project Lead.
Oracle Manufacturing and Financials Release 10.5. Implemented Oracle General Ledger, Purchasing, Payables, Receivables, Order Entry, Inventory, Work in Process, Engineering and MRP/CRP.
July 1994-September1994
Dome Importers, Old Greenwich, CT
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.
April 1994 – June1994
Toys R Us Office, Concord, New Jersey
Implemented Oracle Fast Track Inventory and Purchasing Release 10.4.00.
January 1993 – March 1994American Instruments, Austin, Texas
Project Lead.
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
Certified Management Accountant, Certified in production and Inventory Management Network Design, Implementation and Administration.
Resume 5
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.
Ella Crowford
Lensas, Virginia
Consultant II
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
Executive Management Associates
June 2001 Present
Business Analyst/Consultant
Executive Management Associates
October 2001 Present
Financial Manager II
- 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.
Apachi Innovative Solutions Corporation
November 1999 June 2001
Business Analyst/Consultant
- 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.
Oracle Corporation
October 1998 – November 1999
Business Analyst
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.
Don Herbert Associates
February 1998 – October 1998
Accountant
Oracle Corporation, Euless, Virginia
March 1998 To June 1998
Accountant
- 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
Oracle Corporation, Ft. Devens, Virginia
June 1998 to October 1998
Project Control and Administration Analyst
- 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.
Berlin County Government, Berlin, Virginia
February 1993 – January 1998
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.
City of Trenton Government, Trenton, Virginia
February 1990 – February 1993
Senior Finance Accounting Specialist, Department of Finance
- 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.
Resume 6
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.
Kay Xemeng
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
Innovative Communication Inc., Seattle, WA
Feb.2000-Jun. 2002
Senior Oracle DBA
Software Engineer
Company-wide Oracle DBA
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.
Hired by Stone Network Group, Inc. to work in Contract Gellus, Vancouver, BC, Canada
June.1998-Feb. 2000
Oracle DBA
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.
Seamendo Consulting, Vancouver, BC, Canada
Jun. 1999 Dec. 1999
Oracle Developer
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
Work Compensation Board of BC, Richfield, BC, Canada
Jan.1998 Jun. 1998
Software Engineer
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
Technologies used: Client/Server, Web/HTML, Java, Oracle, ASP, Encryption/Decryption, SSL, CGI, ODBC, JDBC
Canada Best International Inc., Vancouver, BC, Canada
Jan.1997 Jun. 1997
Software Engineer
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
Fujian Medical Univ., Fuzhou, Fujian, P.R.C.
Sept. 1991 Sept. 1993
Lecturer
Doctor Secondary Hospital of Fujian Medical University, Quanzhou, Fujian, P.R.C.
Sept. 1990 Sept. 1991
Intern
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
Resume 7
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.
Ravish Totel
Des Plaines, IL
Authorized to work in the United States.
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
Circuit Administration System CIRAS , Sprint Ltd
May 2002 June 2002
Employer: Tinceton Information, Kansas City
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
City Government
November 2000 Mar-2002
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
InsuranceJuly 2000 – November 2000
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
Manufacturing/Export
August 1998 – June 2000
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
Financial
January 1998 July 1998
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
Sales
January 1997 January 1998
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
Physical Research laboratory Library System
June 93 May 94
Employer: Physical Research laboratory, Ahmedabad, India
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
Resume 8
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.
Rao Vanish
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
06/01 till date
Federal Modul – Skokie, Chicago, Illinois
Consultant
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.
01/01 06/01
National Glen Corporation, San Diego, California
Consultant
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.
11/99 12/00
Zemmins Engine Company, Inc., Alumber, Indiana
Consultant
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.
09/98 11/99
Zemmins Engine Company, Inc., Alumber, Indiana
Consultant
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.
02/98 09/98
Zemmins Engine Company, Inc., Lakewood, New York
Consultant
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.
05/94 01/98
Hexasoft Infosystems Ltd
Senior Consultant, Project Leader
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.
04/91 – 04/94
Divya Electro Technica Pvt. Ltd.
Systems Executive
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.
9/88 – 3/91
Microcell System & Software Ltd
Analyst Programmer
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.
Resume 9
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.
Tom Graham
Indianapolis, IN
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
Defense Modern Accounting System
2 Years
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.
Zemmins Engine Company
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.
US Army Enlisted Records Evaluation Center
1.5 year
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.
Vintage Health Care
6 months
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.
Ella Lilly
6 months
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.
American Group
8 months
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.
Truevision, Inc.
1 year
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.
Indiana Department of Revenue
3 years
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.
Public Service Indiana
6 months
Supported and modified the Internal Computer Software & Equipment Tracking System used for lease payment conformation and internal client billings.
Thomson Consumer Electronics
6 months
Provided program development and support on an as-needed basis on the Transportation System which tracked and confirmed multiple venders freight billing charges.
Saturday Evening Post
1 year
Performed research to determine the best, cost effective computer system for the editorial department of the magazine.
Airvac Inc
1 year
Created a Manufacturing BOM system.
Quality Auto Parts
1 year
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.
Resume 10
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.
Martin Weiver
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 .
Resume 11
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.
Taro Tarajan
Franklin , TN
Certified by Brainbench in Oracle Developer 2000
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:
State Retired Persons Services, VA
11/2000-5/2002
Sr. Programmer Analyst
Responsibilities :
- 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 .
Mostek Electronics, Chennai, India
Jul 99-Oct 2000
Senior Programmer
Responsibilities :
- 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
Nightingales Home Health Services, Bangalore, India
07/99-01/2000
Senior Analyst / Programmer
Responsibilities :
- 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.
ASIAN SOFTECH, CHENNAI, INDIA
May 97 – June 99
PROGRAMMER
Responsibilities :
- 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.
Pager System, Chennai, India
05/97-04/98
Programmer
Responsibilities :
- 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.
KLASSIC COMPUTERS, CHENNAI, INDIA
Nov 94 April 97
PROGRAMMER
Responsibilities :
- 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.
Hospital Management System, Sivananda Centenary Charitable Hospital, Chennai, India
09/95-06/96
Programmer
Responsibilities :
- 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
Library Book Maintenance, Chennai, India
11/94 – 08/95
Programmer
Responsibilities :
- 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.
Resume 12
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.
Sampath Vasami
Pittsburgh, PA
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:
SOFT FOR CLIENTS, INC., Sacramento, CA
August 1999- till date
Oracle Developer
- 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.
ALTEC TECHNOLOGY PARTNERS, INC., Dallas, TX
December 1998 – August 1999
Programmer Analyst
- 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.
BEST SOLUTIONS PVT LTD., Coimbatore, TN, India
December 1993- November 1998
Senior Software Programmer/Database Administrator
- 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
Will be provided upon request.
Resume 13
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.
Siva Verumal
Stamford, CT
Immigration Status : Permanent Resident of the United States Green Card Holder
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
Since JAN 1998
Oracle Corporation USA
Principal Consultant
Department of Transportation, Arlington, OK
Jun 02 till now
Oracle Federal Financials Application Implementation in Release 11i. multi org Involved in the Conversion Process of the legacy data from various transportation agencies into Oracle Applications.
- Customer Conversion Process AR .
- Conversion of Purchase Orders. PO
- Receiving Transactions Interface PO
Department of Motor Vehicles, Santa Clara, CA
Apr 02 May 02
Oracle Financials Application Implementation in Release 11i.
Developed a custom extension called Refund Process for California DMV . Developed various forms and reports for this extension in Oracle Applications.
Prince George County Public Schools, Westford, MD
Feb 02 Mar 02
Oracle HRMS Application Implementation in Release 11i.
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.
Peabody Police Department, Peabody, NJ
Jun 01 Jan 02
CHRIS Criminal History Information System
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.
ABC Corporation, Boston, MA
Jul 00 May 01
Oracle Application Implementation Assistance in Release 11.0.3 / 11i
- 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.
NYC Housing Development Corp., NYC
Sep 99 May 00
Oracle Application Implementation Assistance: Release: 11.0
- 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.
Texas Communications, Dallas, TX
May 99 Aug 99
Oracle Application Implementation Assistance Release: 11.0/10.7
- 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.
Trasoll Rand, Bismarck, ND
Nov 98 Apr 99
Oracle Application Implementation Assistance Release: 10.7 NCA
- 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.
ZENA Corporation, Baltimore, MD
Feb 98 – Sep 98
Oracle Application Implementation Assistance Release: 10.7
- 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.
D-lock Sealing Technologies, Palmyra, NY
Jan 98 – Feb 98
Oracle Application Implementation Assistance Release 10.7
- 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.
OCT 96 – JAN 98
Avistar Computer Services, New York, NY
Consultant
ComEdison, NYC
Aug 97 Jan 98
Environmental Excellence Management Information System
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.
Role
- 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.
National Multiple Sclerosis Society NMSS, NYC
Dec 96 Jul 97
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.
Role
- 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.
SEP 95 – SEP 96
Cartoon Fashion & Accessories Gmbh. Germany & Hong Kong
Software Engineer
Involved in Conversion of the existing Applications Production and Financial Accounting systems running on UNIX-BASIX into Oracle 7.1
Role
- 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.
Environment: RS6000/AIX, Oracle 7.1, Developer 2000, SQL * Loader.
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.
Resume 14
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.
Ravi Giani
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
Pharmalife Corporation, Sacramento, CA
Aug 01 Mar 02
PSS, PIS Database Programmer/Reports Developer
Role :
- 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
SmartTrans, Department of Transportation, Sacramento, CA
Feb 01 July 01
Database Programmer/Reports Developer
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.
Role :
- 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.
Children s Hospital, Medical Records Department, San Jose, CA
Feb 2000 Jan 2001
Sr. Programmer Analyst/Team Leader
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.
Role :
- 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
Global Trust Bank, India
May 99 – Jan 2000
Sr. Programmer/ Analyst – Credit Information System
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
Major Technical Tasks:
- 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.
Role :
- 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.
Indian Express P Ltd.
Sep 98 – May 99
Oracle Developer
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.
Role :
- 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
Amapurna Foods Ltd
Nov 97 Aug 98
Database Developer – Integrated computerized online system in MIS Department
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.
Role :
- 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.
Paramount Distilleries
Jan 97 Oct 97
Database Developer – Distillery Software
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.
Role :
- 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.
Sun Rise Pharma
Jul 96 Dec 96
Database Programmer – Payroll Information System
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 .
Resume 15
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.
Soma Murthy
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, Denver, CO, USA Client
Jun 2001 – till date
EDI/GXS Multi-mailbox
Oracle Developer, Implementation and Support
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.
Responsibilities involved:
- 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
Zwest, Denver, CO, USA Client
Jan 2001 – May 2001
EDI/GXS Translator Error Monitoring
Oracle Developer, Implementation and Support
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.
Responsibilities involved:
- 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
Zwest, Denver, CO, USA Client
May 2000 – Dec 2000
Inter-connect Mediated Access
Oracle Developer and Support
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.
Responsibilities involved:
- 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
The Dysya Bank Ltd, Mumbai, India
Aug 99 – Apr 00
Integrated Standard Banking System
Systems Analyst/Programmer
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.
Responsibilities involved:
- 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
The Dysya Bank Ltd , Mumbai, India
Apr 99 – Jul 99
Migration of ISBS from 4.02 to 4.05
Programmer/analyst
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.
Responsibilities:
- 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
The Dysya Bank Ltd, Mumbai, India
Nov 98 – Mar 99
Interconnected Stock Exchange Services
Software Engineer
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.
Responsibilities:
- 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
The Dysya Bank Ltd, Mumbai
Apr 97 – Oct 98
Branch Computerization
Software Engineer
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.
Responsibilities :
- 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
Datanet Corporation Ltd, Bangalore, India
May 96 – Mar 97
BPRO Business Processing
Programmer/analyst
BPRO is a product developed for supporting the retail banking operations. Some of the modules are Savings, Curent, Clearing, Deposits and Loans.
Responsibilities:
- 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
National Remote Sensing Agency, Hyderabad, India
Jun 95 – Apr 96
Cooperative Credit Society Accounting System
Programmer
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.
Responsibilities:
- Analysis of the requirements
- Design, coding and testing of the software
- Implementation of the software
Environment : Powerbuilder 3.0, Sybase 10, LAN, Novell NetWare
Resume 16
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.
Ervin Kei
Richmond Hill, ON, Canada
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:
Dyneca Foods Corp., Rochester, New York, USA
6/2001 – Present
Senior Oracle Developer / System Analyst
Type: Manufacture, MIS, ERP
- 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
Solaris Computing System Group, Toronto
1/1997 – 6/2001
Oracle Developer / Programmer Analyst
Type: Software, Leisure
- 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.
Lholl Group North America, Toronto, Canada
8/1995 – 1/1997
Programmer/Tech Specialist
Type: Manufacture, Technology, MIS
- 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.
The A-labs, Harvard University, Cambridge, USA
1991 – 1994
Research Collaborator
Type: R & D, Information
- 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.
Automation Institute of Fuzhou University, China
1989 – 1991
Designer/Researcher
Type: R & D, Hardware
- 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
Violin, opera and classic, financial investment, web surfing, fishing, driving, reading, outdoors, bridge