Oracle Dba Ya Rao

1999 Beach Park Blvd, #40 Foster City, CA 94404 USA

650-578-0106 [email protected]

Subramanya Rao Dear Sir/Madam, I am Subramanya Rao, currently residing in USA, looking for a job opportunity in India. I have worked with industry’s recognized companies such as Oracle Corp., Deloitte & Touché, American Airlines and Xerox during the past ten years. I have been involved in all phases of project life cycle, beginning from analysis to implementation. I am confident that with my extensive experience in the IT industry supported by an Engineering degree from JNTU college of Engg, Hyderabad, I will be able to make a positive contribution to your company. My DBA certification from Oracle will also be an added advantage. With my qualifications, I can play a leading role in fulfilling the objectives of your organization. I am interested in positions such as project manager, which will give me an opportunity to prove my capabilities. I am herewith enclosing my resume for your consideration. Thank you for your time and I look forward to talking to you soon. Sincerely, Subramanya Rao

Subramanya Rao Objective

Education

With about 10 years of extensive experience in analysis, design and development of applications using Databases and Object Oriented methodologies, would like to be part of a challenging environment where my technical skills and analytical abilities can be used towards achieving the objectives and goals of your organization.  B.Tech in Electronics and Communication Engineering, 1990 – 1994 JNTU College of Engineering, Hyderabad, India  Oracle Certified DBA

Technical Skills

RDBMS Tools Languages Technologies

Experience

Oracle 8i, 9i, Sybase 10.x PowerBuilder 6.5, PFC, Jdeveloper, SQL*Plus, SQL*Loader, Toad, SQL Navigator, ERWin, Oracle Enterprise Manager, Reports 6i PL/SQL, Java, JavaScript, C, Shell Scripts, XML J2EE

Jan 2002 – Present Oracle Consulting. Redwood Shores, USA Principle Consultant This system is developed for Western Conference of Teamsters Pension Trust for maintaining their accounting and claims activities. It is a complex system built using Oracle and Java technologies, as a replacement for the existing COBOL based system. The screens are developed using Oracle Forms to resemble the mainframe look of 32x70. The entire application is meta-data driven, i.e. information about the screens and the business rules associated with the fields is stored in tables which are used at run time to create the screens dynamically. The business rules are executed dynamically by a PL/SQL component called business rules engine. Environment: Oracle 9i, Oracle 9iAS, PL/SQL, Reports 6i, Forms 6i, Java Responsibilities:  Create functional and technical specifications for some of the modules.  Involved in writing large batch programs using PL/SQL.  Extensively used PL/SQL collections while coding the batch programs.  Made use of Oracle Advanced Queuing features for communicating between batch programs or between batch programs and reports.  Coded various business rules of the system into reusable modules.  Load data using SQL* Loader from the external files into the application tables.  Developed shell scripts to transfer the generated report files to various recipients. Aug 2000 – Dec 2001 Sabre, Inc. Dallas, USA Database Administrator This system was developed for American Airlines reservation agents. The

database is loaded with data coming from an external source. A Java based GUI is used to retrieve and modify the data using JDBC. Environment: Oracle 8i, Sun Solaris Responsibilities:  Creating entity relationship diagrams using Erwin.  Creating the database and the tables, indexes and synonyms required for the application.  Load data using SQL* Loader from the external files into the application tables.  Coded stored procedure and packages using PL/SQL..  Performed database backups in both cold and hot modes and also recovery.  Automation of regular processing activities using shell scripts and cron jobs. Apr 2000– Aug 2000 Servicelane.com Dallas, USA PL/SQL Developer Servicelane.com was an E-commerce company to connect customers with service providers. When a customer wants to request a service, he is presented with a list of providers based on the criteria input by the customer. Environment: Oracle 8i, Oracle Application Server 4.0, PL/SQL, HTML, JavaScript Responsibilities:  Involved in writing PL/SQL stored procedures and packages.  Involved in creating web pages using HTML, PL/SQL and PL/SQL cartridges.  Involved in loading files using SQL*Loader. Dec 1997 – Apr 2000 Greyhound Lines, Inc Dallas, USA Data warehouse Developer This data warehousing system was developed to assist the back office accounting personnel of Greyhound Lines at their HQ. The database is loaded with data coming from external files generated by a mainframe system. A set of intermediate tables are first loaded with raw data using SQL Loader, which is cleaned up using PL/SQL scripts, and then loaded into the main tables. Some of the data is adjusted using a front-end application developed using PowerBuilder. Environment: Oracle 8, PL/SQL, PowerBuilder 6.0, PFC Responsibilities:  Involved in the design of the warehouse and also the ETL process.  Used the transportable tablespace feature of Oracle for faster data loading.  Involved in writing SQL Loader scripts and PL/SQL procedures for loading data.  Created functional and technical design documents.  Involved in developing front-end application using PowerBuilder.  Involved in creating scripts for generating outbound interface files.  Involved in writing shell scripts for scheduling of jobs. Feb 1997 – Nov 1997 Deloitte & Touché Dallas, USA PowerBuilder / PL/SQL Developer This client/server system called Global Advantage was developed for those companies, which send their employees on overseas assignments. This application provides comprehensive solution to handle and administer virtually

every aspect of expatriate process, including Assignment Planning, Initiation, Administration, Budgeting and Cost control, Relocation and Repatriation, Payroll, Compensation and Tax Reporting (such as W-2 activities) and Tax Servicing. Environment: Oracle 8, PL/SQL, PowerBuilder 5.0, PFC Responsibilities:  Involved in writing PL/SQL procedures for the payroll module, which is the critical component of the entire system.  Involved in developing front-end application using PowerBuilder.  Involved in writing shell scripts for scheduling of jobs. Jul 1996 – Dec 1996 London Borough of Newham UK PowerBuilder Developer This system is for enforcing budgetary control on internal charges. The internal charges / invoices are raised by contractors. The clients can then dispute / accept the invoices raised by the contractors, due to budgetary constraints or for various other reasons. Contractors raise orders based on the client requests. Clients can accept or reject these invoices.. Environment PowerBuilder 5.0, Sybase Responsibilities:  Involved in preparation of functional specification, design and development of various data entry screens and reports.  Involved in developing object libraries using PowerBuilder.  Involved in developing interfaces to Microsoft Excel and Microsoft Mail. Jun 1995 – Jun 1996 Xerox Engineering Systems UK PowerBuilder Developer This product called Product Configurator was developed for the salespersons of Xerox based in Europe. It was designed to create a configuration of a product, consisting of various components based on a set of rules. These rules define the specifications for the products and solutions offered to the customers. Major part of the work was done at the client location in UK. Environment: PowerBuilder 4.0 Responsibilities:  Involved in development and testing of various data entry screens and reports.  Also involved in developing the interface from PowerBuilder to Microsoft Word using the Dynamic Data Exchange feature. The product configuration, generated by the salesperson is converted into a word document. This interface had to be developed for use by the salespersons of different languages of Europe. Aug 1994 – May 1995 Information Tech, Ltd. New Delhi, India PowerBuilder Developer This system was developed for the automation of all the functional areas of a Steel Plant based in India. Accounting, Purchase Management, Stores Management, Sales and Dispatch, Personnel & Payroll and Costing System were automated. Environment: Oracle 7, PowerBuilder 4.0 Responsibilities:  Involved in the development of screens using PowerBuilder for Personnel &

Payroll, Sales & Dispatch and Stores Management modules.  Involved in writing PL/SQL procedures for batch programs.