Resume 14

SUMMARY

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

SOFTWARE SKILLS

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

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

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

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

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

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

• Configuration Management: CCC Harvest 4.1.2

PROFESSIONAL EXPERIENCE

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

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

Description :

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Role :

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

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

EDUCATION :

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