Oracle

RAMESH REDDY

SUMMARY

· More than ** years of experience in Client/Server, Web development, system design, database management, testing and implementation

· Extensively worked in the areas of Oracle applications, Developer Suite, Business Objects, PL/SQL programming, performance tuning.

· Extensively used tools like TOAD, SQL Navigator, SQL Tools, Unix / Shell Script and Data Migration.

· Extensive IT experience in all aspects of Software development life cycle.

· Strong skills in conversion of data from Legacy systems to Oracle using SQL Loader, PL/SQL Scripts, Database Packages, Procedures, Functions, Triggers.

· Sound knowledge of Data modeling, Data Warehousing, DBA concepts, roles and responsibilities.

· Knowledge of Oracle Application express(APEX,Web application development tool)

· Experience interacting with Management Team, Project Team, Clients with excellent communication and interpersonal skills

EDUCATION

Masters in Mathematics

Post Graduate Diploma In Computer Applications

CERTIFICATIONS / TRAINING

Oracle Applications Technical Foundation

SKILLS

RDBMS: ORACLE 10g/9i/8.x/7.x/6.0, Database Administration, Advanced Oracle PL/SQL ( Records, Types, REF cursors, Bulk binds, Autonomous Transactions), Partition Management ( Table, Index and View ) , Dynamic SQL, Complex Packaged Procedures & triggers, SQL tuning.

Languages: PL/SQL, Unix Shell Script, C, PRO*COBOL, PRO*C, COBOL, HTML and XML

GUI: Oracle Developer 2000 , Forms 6i/9i/10g, Reports.

Application Tools: SQL Navigator, SQL Plus, SQL Tools, Toad, Microsoft Office.

ETL and Reporting Tools: Business Objects, Crystal Reports, Cognos

Web Servers: Oracle Application Web Server (OAS) 4, 9iAS, 10gAS

ERP: Oracle Applications (eBusiness Suite) 11i (AOL/FND, OM, INV, GL, AP, AR, PO)

SAP CRM, BW3.5/BI7.0

Operating Systems: UNIX (HP-UX, SOLARIS), SUN OS, Windows, VMS

PROFESSIONAL EXPERIENCE

07/1996 – 04/2001 & 02/2002 – Till Date

SunGard IWORKS, Atlanta, GA

Compass development group

COMPASS is a uniquely designed group Life, individual pension, annuity, risk management, AD&D, Individual, group, Medical and Dental insurance system that utilizes relational database system and a fully parameterized rules driven process. It incorporates all the necessary functions for comprehensive Health, pension and risk benefit administration – product /investment administration, ledger accounting, member record keeping, and comprehensive reporting capabilities in a single integrated client/server/Web based software solution.

As a lead developer responsibilities include

· Development of several modules like Individual/Group/Member/Scheme/Investment installs, Quick Data Entry, Fast path claims/Quotes, Inquiry, Expenses, Collections, Commissions, Fund switch, Benefits, Cafeteria, Billing Modules and Call Center forms etc which includes complex forms, reports, data conversion scripts, stored procedures, functions, stored packaged procedures, database triggers, Objects, Types involving more than 1400 tables, 1800 forms, Various Reports and more than 1200 Packaged stored procedures.

· Created lot of PLL libraries of routines(Packaged Procedures, Functions) used by all Forms in PL/SQL. These greatly reduce the amount of programming required within each individual form.

· Developed PL/SQL package utility to store data as XML tags and read XML string to populate the Call Center Forms.

· Conversion of Forms / Reports from 6i to 10g.

· Conversion and Configuration of data into compass from various data sources.

· Development of Standards, Template forms, and common Error Handling Procedures/functions.

· Developed Various Stored Procedures for replicating data.

· Developed lot of Database packages to provide interfaces to COBOL

· Written PL/SQL wrappers for JAVA classes for web interface project.

· PL/SQL code performance tuning to improve execution time, Used Advanced Oracle PL/SQL Tables, Bulk Collections etc.

· Interaction with UAT, clients, client managers, business analysts and team members onsite/offshore.

· Finding solutions to the problems reported in the exception reporting form.

· Did Various database activities like Creating Tables, Indexes, Constraints, Views, Sequences, Database triggers, Packages/procedures.

Environment :Oracle10g/9.x/8.x, Oracle Forms10g/9i/6i/4.5, Oracle Reports, Oracle Application Web Server, Business objects reports, PL/SQL, SQL Plus, SQL Trace, TKPROF, Explain Plan, OC4J, TOAD, SQL Navigator , SQL Tools, Java, XML, PVCS, Lotus Notes, SUN Solaris, Unix, Windows 9x/NT, SGI servers, Sun Enterprise Servers E10000 2.x, HP Vclass /Nclass 11.x

05/2001 – 01/2002

Southwest Gas Corporation

Sr. Oracle Consultant - GTS ( Gas Transaction System)

Involved in the development of Gas Transaction System for Southwest Gas Corporation. GTS is divided into various subsystems, which provide solutions to specific business activities performed by local distribution companies (LDC's) where applicable, GTS complies with industry standards developed by the Gas Industry Standards Board (GISB). GTS has numerous on-line and batch transactions. Functioning as a Consultant in the GTS team. The primary responsibilities include evaluating the standards, requirement analysis, impact analysis, design, technical specs writing, development etc. Involved in developing generic application packages, libraries, and templates to enforce application standards. Also involved in QA testing, application tuning and implementation of various components of the modules.

As a Consultant

· Upgraded 60 User client Machines with Oracle 6i forms/reports/graphics Software

· Converted more than 600 forms from Oracle Forms 4.5 / Reports upgrade to Oracle Developer6i environment and added various 6i Features.

· Added Oracle’s Built in toolbar into GTS system menus and Removed the referenced

Toolbars from the forms which reduces size of the forms and moved all the toolbar code

Into library.

· Developed various security standard forms and common error handling.

· Developed Various complex forms, reports, data conversion scripts, stored procedures, functions, stored packaged procedures, database triggers involving more than 300 tables and Views.

· Interaction with Users, client managers, business analysts and team members.

· Assisting project team in production and enhancement initiatives

· Finding solutions to the problems reported in the Client Report.

· Installed Oracle Report Server on some of the Clients to work with the print queue and various report parameter forms.

· Did Various database activities like Creating Tables, Views, Sequences, User roles, Synonyms, Database triggers, Packages/procedure, Data Import/Export across various Databases and wrote conversion scripts and used Advanced Oracle 8i PL/SQL like Records, Collections, REF cursors etc.

Environment : Sun Sparc Server, Sun Solaris, Unix, WindowsNT, Oracle 8i, Designer 2000 , Developer 2000 Tools(Forms, Reports), PL/SQL, SQL*Plus, SQL Loader, SQL Navigator, Exceed.

03/1996 – 06/1996

US WEST Communications, DENVER , CO.

The order entry system was built in conjunction with oracle financials and oracle manufacturing applications customized to the client's business requirements. This module is designed and developed using some standard features of Oracle Order entry.

· Developed custom form for Sales order in order processing system.

· Was primarily involved to convert data from various legacy systems into Oracle order entry and inventory using PL/SQL AND SQL loader.

· PL/SQL code performance for the custom packaged procedures using explain plan, Trace, TKPROF, Forcing Hints, Evaluating RULE/COST based optimization and tuning.

· Used oracle AOL to define concurrent programs, value sets, additional menus, responsibilities, and flex fields.

· Customized several oracle applications reports to meet company's requirements.

Environment : (DG-AViiON 9500, UNIX, Oracle Forms 4.5, Reports 2.5/2.0, PL/SQL, SQL*Loader, Oracle*Manufacturing10.7, Oracle* Financials 10.7)

06/1991 – 02/1996

Ministry of Health (Oman)

Logistic and Drug distribution system, Purchase and general stores system, Medicom (Medical billing system).

Developed oracle Forms, Reports, Menus, Library of procedures, Packaged stored procedures and Functional Testing.

Environment : Oracle 6.0, Oracle Forms, Oracle Reports, PL/SQL, SQL * ReportWriter 1.0,

SQL*Menu 5.0.

Work Status - U.S Citizen

Contact this candidate