Ramachandran Murugesan

(U.S. Citizen)

***** ********** ***

Cerritos, CA 90703

562-***-**** (h)

213-***-**** (w)

213-***-**** (cell)

562-***-**** (cell)

Email: ad4s3d@r.postjobfree.com

Education

Anna University, Chennai, India

M.E. in Computer Science and Engineering

Maduai Kamaraj University, Maduari, India

M.Phil in Mathematics

M.Sc. in Mathematics

B.Sc. in Mathematics

Technical Skills

Hardware: NCR 3550, NCR3600; SUN Workstations; Micro VAX; PRIME 6550; DEC 1090; 68020 Based Machines; IBM PC-XT/AT Machines; NT Machines.

Languages: JAVA, HTML; Visual Basic; PERL; C, C++; Pascal; PL/I; FORTRAN; COBOL; CLIPPER; SQLBase.

Operating Systems: UNIX 10.2; Linux 7.2; Windows 2000/NT; MS Windows 3.1; VAX/VMS; PRIMOS; TOPS 10; MS-DOS, OS/2; Novell’s Netware; MS ACCESS, VAX/RDB.

Software: ORACLE 19C/11g/10g/9i Database, App. Server, RMAN, Data Guard, RAC Hotsos Profiler; Forms 6i, Reports 6i; Dev 2000, Des 2000; Erwin, Maximo, SAP; Discoverer 4i; Dreamweaver2; Centura (Gupta SQL); TOAD, SQL Station.

SQL Server.

Professional Summary

Oracle DBA / Developer with extensive Information Systems expertise in the ORACLE arena; highlights include:

Installed and maintained Oracle 19C/12c/11g RAC under ASM.

Migrated the Oracle 11g to Oracle 19C under RAC.

Migrated the Oracle database 8i to Oracle 10g/11g and implemented Data Guard for Stand by database

Strong knowledge of SQL/SQL*Plus/PL/SQL stored procedures and packages.

Worked extensively in Web Development and Client Server arenas.

Provided regular backup and supported the data integrity using Oracle utilities (RMAN/expdp).

Maintained the production, development databases and performance tuning.

Experience

LA Unified School District, Los Angeles, CA 5/2002 – Present

Database Administrator/Developer

Assisted FIS with the design optimization and maintenance of Oracle databases.

Streamlined database design & development with Production, Development and Testing Systems.

Performed systems analysis and programming in SQL, PL/SQL, and SQL Loader.

Installed new Oracle instances 11G/10G/9i in Linux/NT and maintaining difference oracle instances.

Regular backup and supported the data integrity using Oracle utilities.

Maintained the production and development databases and performance tuning.

Assisted the developers and the FIRS Design by creating the tables, indexes, primary keys and the foreign keys using the business rules.

Monitored the daily data feed from IFS and Load the data from PIC and Expedition when into FIRS (Using PL/SQL program parse the data and put it into the right table).

Developed the facilities Invoice tracking system.

Wrote various DBA utility scripts used in tracking database comparison and DDL code generation.

Reversed engineered the database using data model tools Erwin and Designer 2000.

Database Administrator for a large database (2TB size) FIRS(Facilities Integrated Reporting System) which contained 1 billion records that tracked budget, cost and schedule of all New and Existing facilities. (Used Partitions and appropriate indexes for better performance)

Optimized the SQL using Method R (tracing event 10046).

Refreshed reporting database from production using Oracle Streams.

Migrated the Oracle database 8i to Oracle 10g and implemented Data Guard for Stand by database

Migrated the Oracle database 9i to Oracle 10g and implemented Data Guard for Stand by database.

Migrated the Oracle database 10g to Oracle 11g.

Migrated the Oracle database 11g to Oracle 19C.

Acted as a consulting resource and provided an oversight function for database related work performed by other developers.

Software expertise demonstrated: ORACLE Database 19C/11g/10g/9i/8.1.7.2, Application Server 10g/9i, Data Guard, Forms 6i, Reports 6i and Linux, TCL, ACS.

Paramount Farming Company, Bakersfield, CA 3/2002 – 4/2002

Oracle DBA (Contract)

Installation and configuration of Oracle 9iAS application server (ver 1.0.2.2.2) under the oracle database 8.1.7.1.5.

Helped in fixing bug during the migration of Discoverer 3.1(ver3.1.26.01) to Discoverer 4.1 (ver 4.1.41.05).

Tested the WEB based reports 6i, forms 6i, discoverer views and discoverer plus in 9iAS application server on NT Server.

Software expertise demonstrated: ORACLE 8.1.7.1.5, 9iAS Application Server (ver 1.0.2.2.2), Discoverer4.1 (ver 4.1.41.05), Forms 6i, Reports 6i.

Justalent, Alexandria, VA 6/2001 – 2/2002

Oracle Developer (Contract)

Enhancement/Maintenance of Medical Management System.

This system consisted of patient records (inpatient, outpatient, rehab, front office accounting, and housekeeping modules) for long-term care nursing homes for IHS. This system allowed the front office staff a trouble-free environment and a user-friendly reporting system. Patient billing and analysis enabled increase in revenue. ORACLE (Forms 6i and Reports 6i) was used on the UNIX Server.

Software expertise demonstrated: ORACLE (Forms 6i, Reports 6i, PL/SQL, Stored Procedures and SQL Loader).

Naval Surface Warfare Center Carderock Division (NSWCCD), West Bethesda, MD 1/2000 – 4/2001

Oracle Developer (Contract)

Development and Maintenance of Workload Planning System.

This system collects data on Directorate programs funded by sources external to the Naval Surface Warfare Centers. It stores data for the current fiscal year and the next six fiscal years and feed the data for other accounting system. The client module is coded using Forms 6i and Reports 6i (Developer 2000) and the server modules are coded in ORACLE (ver 8i) on the UNIX server. The Web interface is implemented using the Oracle Application Server 9i.

Software expertise demonstrated: ORACLE (Application Server 9i, Developer Server, HTML, PERL, JAVA Script, Forms 6i, Reports 6i, PL/SQL, Stored Procedures, and SQL Loader).

Enhancement/Maintenance of Curator of Models Application. This uses the tracking of Naval Surface Warfare Center different navy models. The client module is coded using Visual Basic and the server modules are coded in ORACLE (ver 8i) on the UNIX (ver 10.2) server.

Software expertise demonstrated: Visual Basic and ORACLE (PL/SQL, Stored Procedures, and SQL Loader).

Enhancement/Maintenance of an Accounting System (A3910).

Accounting Personnel at the Naval Surface Warfare Centers use this system to track their job order numbers. The client module is coded using Power Builder and the server modules are coded in ORACLE (ver 8i) on the UNIX (ver 10.2) server. This system feeds data to and from various small systems developed in MS Access.

Software expertise demonstrated: PowerBuilder, ORACLE (PL/SQL, Stored Procedures, and SQL Loader) and MS Access.

Merck Pharmaceutical/PAREXEL International, Alexandria, VA 2/1998 – 12/1999

Oracle Developer (Contract)

Development of a National Osteoporosis Risk Analysis (NORA).

The system utilizes client/server architecture to create strong focus on patient and physician awareness and education in Osteoporosis for post-menopausal women over 50. The system incorporates the data from 1.5 million patients tested by 33,000 physicians across 33 states. Merck pharmaceutical company uses this system for evaluating osteoporosis data to market their drugs. The client module is coded using Developer 2000 and the server modules are coded in ORACLE (ver 7.3.2.3) in NT server. This system retrieves data from other systems developed in MS Access and generates management reports.

Software expertise demonstrated: ORACLE (Developer 2000, PL/SQL, Stored Procedures, and SQL Loader) and MS Access.

Spectra/ Market Metrics, Lancaster, PA 3/1997 – 2/1998

Senior Oracle Programmer/Analyst

Database Administrator/Maintenance of a Universal Stores System.

Merchants use this system to analyze their strengths as well as their opportunities in different markets. The system identifies the merchant’s key customers and pinpoints how best to reach them. ORACLE (ver 7.3.2.3) was used on the UNIX Server.

Software expertise demonstrated: ORACLE (Developer 2000, C, and Pro*C, PL/SQL).

AT&T/Lucent Technologies, Greensboro, NC 9/1992 – 2/1997

Lead Oracle Developer (Contract)

Development of a Management Compensation System.

This system utilizes client/server architecture to facilitate the compensation process for AT&T/Lucent Management Employees. It allows the construction and management of budgets as well as the assigning of ratings, salary increases, and annual bonuses to all AT&T/Lucent employees, enterprise-wide. The client module is coded using Centura (Gupta SQL Windows) and the server modules are coded in ORACLE.

Software expertise demonstrated: ORACLE (C, Pro*C, SQL*Net, Database Triggers and Stored Procedures) and Centura (Gupta SQL Windows).

Development of a Shipping Report System for FMC, Philadelphia.

This system is used in shipping chemical products. It generates SQR reports in shipping company format to move the chemical products from one location to another. Also, it updates the chemical database by converting the shipping company SQR reports. ORACLE is used in the server side.

Software expertise demonstrated: ORACLE (PL/SQL) and SQR.

Design, development, and implementation of an Exercise Tracking System.

Personnel at the AT&T Health Fitness Centers use this system to track and improve employee workout progress. The user interface is uses Centura (Gupta SQL Windows) and Oracle SQL*Forms. Oracle was used on the UNIX Server, and TCP/IP is used to connect the client and server.

Software expertise demonstrated: ORACLE (C, Pro*C, SQL*Net, SQL*Forms) and Centura (Gupta SQL Windows).

ITT Hartford Insurance Group, Hartford, CT 5/1992 – 9/1992

Oracle Developer (Contract)

Development of Risk Management Information System (RMIS).

This system supports the risk management functions of IIT Hartford's external and internal customers. RMIS helps the Risk Manager to control insurance costs by providing information on Losses and on Cost Containment initiatives.

Software expertise demonstrated: ORACLE (PL/SQL).

Citibank Consumer Service Group, Chennai, India 1/1990 – 4/1992

Oracle Developer (Contract)

Design, development, and implementation of ATS (Acquisition Tracking System).

ATS is a marketing campaign management system used in maintaining the mailing lists for various direct mail campaigns. It aids in tracking the responses of direct mail prospects and generating various MIS reports the marketing division uses to acquire new card members.

Software expertise demonstrated: ORACLE (SQL*Forms, Dynamic SQL using Pro*C) on PRIME, Novell LAN.

Design, development, and implementation of the Transaction Query System (TQ).

This system provides facilities for querying on the basic transactions that are posted during banking activities. The queries are primarily meant for tracking mismatched credit/debit pairs, excesses and shortages in a batch amount, and wrongly posted vouchers.

Software expertise demonstrated: ORACLE (Pro*C and SQL*Forms) on SUN Workstations (SPARC Systems).

Design, development, and implementation of AutoLoanMIS.

This system is used in the handling of automobile loans. It generates reports based on geography, tenure, dealer, make, and model.

Software expertise demonstrated: ORACLE (SQL*Forms and Pro*C).

Clinical Information Services Inc., Stamford, CT 6/1988 – 12/1989

Oracle Developer (Contract)

Design, development, and implementation of Adverse Reaction Information System (ARIS).

Pharmaceutical companies (Johnson & Johnson, Squibb Inc., and Sterling Drug) use this system for evaluating new compounds and marketed drugs to determine safety profiles and satisfy statutory requirements.

Software expertise demonstrated: VAX/VMS using RMS, ORACLE and 'C'.

Stanford Business Software Inc., Mountain View, CA 3/1987 – 5/1988

Oracle Developer (Contract)

Development of Gas Leak Program.

This system is used for compiling statistical information on gas leakage for Pacific Gas & Electric Company, San Francisco, California.

Software expertise demonstrated: PL/I on Personal Computer.

References

Mr. Kevin Meade, Oracle Consultant, IIT Hartford, Hartford, CT. 860-***-****

Dr. Neal Lalwani, LAUSD, Los Angeles, CA. 424-***-****

Mr. Michael Hurst, DBA Manager, Confie, Los Angeles, CA 951-***-****

Mr. Clayton Springfield, Accounting Director (Retired), LAUSD, Austin, TX. 512-***-****

Ms. Judy W. Carter, SAP Functional Analyst, LAUSD, Los Angeles, CA. 213-***-****

Mr. Ken Luper, Assistant Controller (Retired), LAUSD, Ventura, CA. 805-***-****

Mr. Andrew J. DiCarlo, AT&T, Greensboro, NC. 336-***-****

Dr. Jonathan F. Antin, AT&T, Greensboro, NC. 336-***-****

Mr. Ed Varner, IT Manager, Paramount Farming Company, Bakersfield, CA. (661) 399-4456x320

Ms. Olive Fox, Justalent, Alexandria, VA. 703-***-****

Mr. Doug Mauk, Computer Science Corporation, MD. 301-***-****

Dr. Michael Brown-Beasley, Senior Auditor, Phillips Medical Systems, MA. 978-***-****

Contact this candidate