Venugopal R. Adla

6209 addison dr

Mechanicsburg,Pa 17050

Phone#in U.S 919-467-0908

Mobile No in India:9000283374

Summary

Technical experiencedmore than 18 Years with Oracle Applications, Oracle DBA,Oracle Tools (Oracle Reports, Oracle Discoverer, PL/SQL, SQL Pus, SQL Loader) and operating systems such as UNIX, Linux and Windows.

  • Oracle PL/SQL Developer with more than 10 years of experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using Oracle SQL, PL/SQL on Unix and Windows environment
  • Experienced as Database Developer for Oracle, experience includes design and implementation of databases on windows 2000/2003 servers
  • Extensive experience in developing Database Objects, Triggers, stored procedures, Functions, Packages
  • Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
  • Involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
  • Excellent in writing Shell Scripts using (Shell, Kron shell) for database transactions and batch processing
  • Moderate Level experience with T-SQL. .
  • Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
  • Tuning of SQL statements using EXPLAIN PLAN, Oracle Hints to improve the performance.
  • Tuning the schema, Full table Scans, indexed scans, optimization approaches,cost based and rule-based approaches.
  • Proficient in Oracle tools such TOAD and SQLNavigator
  • Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
  • Experienced in providing quality operational Support for Production Environments

TECHNICAL SKILLS

Databases / Oracle 11gr2/10g/9i/8i/8.x/7.x, Microsoft Access
Application Software’s / Oracle developer 6i, Reports 6i
Tools & Oracle Utilities: / * Plus, SQL Loader, Import/Export, Explain Plan, TOAD, SQL Navigator 4.4, SFTP, SQL Profiler, Query Analyzer.
Languages / Oracle (Sql Plus, Pl/Sql, Sql Loader, Oracle Reports,T-SQL), Visual basic, Shell Scripting (Bash, Ksh)
Operating Systems / UNIX, Windows NT/XP, 2000, 9x, Digital Alpha Server/VMS, IBM/RISC 6000/AIX, HP-UX/HP 9000, Dell-Linux, ULTRIX/SUN Systems.
Platforms / IBM RISC 6000 and IBM PCs

Management/Leadership Skills:

  • Managed and Lead the AR data conversion and interface project.
  • Lead a project in customization of Oracle application reports.
  • Lead and tra.ined the client employees in Oracle Financials.
  • Lead the HR conversion and interface project.

Ctrl-S, Hyderabad, India Jan-2008-Dec-2014

Senior Software Engineer

Responsibilities

  • Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
  • Involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
  • Excellent in writing Shell Scripts using (Shell, Kron shell) for database transactions and batch processing
  • Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to business and technical requirements
  • Formatting data extracts using Excel, and presenting the data extracted to the client management for reviewDeveloped and Tested database sub-programs (Packages, Stored Procedures, Functions) according to business and technical requirements
  • Formatting data extracts using Excel, and presenting the data extracted to the client management for review
  • Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges

Global Knowledge, Cary, NC10/2003 – 7/2007

Responsibilities:

  • Responsible for analyzing production data extracts and worked closely with business and technical support staff to identify Data Anomalies, Data Trends and other Production Based Data issues.
  • Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to business and technical requirements
  • Formatting data extracts using Excel, and presenting the data extracted to the client management for review
  • Used Sql Loader for data transfer.
  • Involved in providing data from oracle procedures to Oracle Advanced Queues.
  • Systems messages are sent to different retails stores throughout the country using to Oracle Advanced Queuing Technology.
  • Using UTL_FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.
  • Written shell scripts to automate SQL Loader process to load data into the tables.
  • Used SQL Profiler to monitor the server performance, debug T-SQL for slow running queries
  • Involved in Defining, Documenting and Maintaining the Data models by working with business analysts and through Reverse Engineering of Existing schemas
  • Process change requests through Remedy ticket system, including application wide data changes
  • Responsible for Deploying changes to production and non-production environments.
  • Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace

Oracle Corporation 07/1998 – 11/2002

List of Projects

Oracle Corporation/City of Chicago , Chicago 11/2001- 11/2002

Responsibilities:

  • Lead the Technical team in data conversion for HRMS application( Vacancies, Requisitions, Employee, Applicant, Employee Applicant, Address, SIT, Assignment, Salary, Terminate, Element, Fed Tax, NACHA, State Tax) using SQL Loader.
  • Design and develop Custom reports using Oracle Discoverer, developed Interfaces using PL/Sql. Sql loader used for data conversion.
  • Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to stated business and technical requirements.
  • Used cost – based approach to calculate execution plan with the lowest cost.
  • Used syntax-based rules to determine precedence
  • Gathered Statistics using Analyze command.
  • Used the Trace and TKPROF for tuning strategy.

Oracle Corporation/ Chicago Public School System, Chicago 08/2001-11/2001

Responsibilities:

  • Involved in data conversion for Oracle applications using Sql Loader.
  • Created custom interfaces using Sql Plus and PL/Sql.
  • Design and develop Custom Reports using Oracle Reports, Sql and Discoverer
  • Developed test cases and executed tests for database programs such as Packages, Stored Procedures and Functions according to business requirements.
  • Modified Oracle reports using Oracle Discoverer and Oracle Reports.
  • Tuned PL/Sql code for faster performance.
  • Created Indexes in the tables to optimize the PL/Sql scripts.
  • Used Rule-based and Cost-based approach on the Sql statements for different scenarios and chosen the best Optimization approach for Sql queries.

Oracle Corporation/State of Michigan Welfare Department - East Lansing,MI 12/2000-07/2001

Responsibilities:

  • Participated in the custom development interfaces for custom application using PL/SQL.
  • Created custom reports using Oracle Discoverer.
  • Created Procedures, Functions and packages with PL/SQL code.
  • Created Exceptions to handle errors.
  • Created Documentation for interfaces and for data conversions.
  • Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace
  • Developed temporary table to load legacy data, validated data in the staging table writing Triggers, stored procedures, Functions and Packages
  • Used Toad/Sql Navigator for writing and executing the queries.

Oracle Corporation/American Trans Air, Indianapolis, IN 05/2000 – 11/2000

Responsibilities:

  • Involved in data conversion for Oracle HRMS application Sql Loader. Created custom reports using Oracle Discoverer.
  • Developed PL/Sql used for interfaces based on functional requirements.
  • Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace
  • Converted data from legacy systems using SQL Loader and Unix operating system.
  • Registered SQL Loader scripts and interfaces in Oracle Application to get executed from Oracle Application.
  • Used Sql Navigator for creating and execution of SQL scripts.
  • Developed adhoc oracle reports using Sql Plusfor the client management as per request.
  • Using UTL_FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.

Oracle Corporation/Lucent Technologies, Reading & Allentown, PA 07/1998-07/1999

Responsibilities:

  • Implemented Integrated Circuits Information Solutions for Lucent Technologies by integrating Oracle Manufacturing Applications (WIP, MRP, BOM) from legacy systems using Sql Loader and Unix.
  • Data Mapping for WIP, MRP, BOM. Customized Work in Process, Material Resource Planning, Bills of Material conversions and interfaces. For Software Configuration Management used Intersolv’s PVCS. Created Report- Sets for the Manufacturing modules.
  • Designed custom reports using Discoverer.
  • Created custom interfaces with PL/Sql in Oracle Purchasing and customized oracle reports to suit the client needs.
  • Using UTL_FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.
  • Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace

ASC, Inc.,/FFM, Inc., Rockymount,NC 02/1997-06/1988

  • Independent Consultant

Responsibilities:

  • Gathered requirements , created Functional design documents and got approved from the business partners before the development.
  • Implemented Account Receivable, GL, Fixed Assets from legacy systems.
  • Customized Fixed Assets and Accounts Receivable reports.
  • Converted legacy systems into Oracle and interfaced using PL/Sql in Oracle Financials (GL, AP,AR).
  • Converted legacy systems into Accounts Payable and Purchase Order using Sql Loader.
  • Created SQR reports Oracle Database.
  • Created custom inbound and outbound interfaces with PL/SQL.
  • Modified Oracle Seeded Reports to suit the client needs.
  • Developed data mapping documents to bring data from external systems.
  • Developed documents based on Systems development Life Cycle after consulting the client.

Bellcan Services/Unifi, Inc., Greensboro,NC 11/1995-02/1997

Consultant

Responsibilities:

  • Implemented AP, GL, FA, OE from legacy systems using Sql Plus, PL/SQL and SQL Loader.
  • Customized FA, GL & AP reports. Converted legacy systems into Oracle and interfaced using PL/Sql with Oracle Financials.
  • Developed interfaces using PL/Sql for oracle purchasing and customized purchasing reports to suit client requirements.
  • Extensive usage of SQLLoader to bring in Legacy data into First time Oracle Application users client.

WTW, Inc., RTP, NC/Natlsco,Chicago, IL 11/1994 – 10/1995

Consultant

Responsibilities:

  • Implemented Laboratory Management System (HP-LIMS) using Oracle data base.
  • Extensive usage of LIMS is Laboratory Information Management System developed by HP.
  • Implemented Order Supply Application using Oracle Forms 4.0 and Oracle Reports 2.0.
  • Projects in Interactive Voice Response System Projects and Telephone Integration.
  • Interfaces using PL/Sql and adhoc reports with Sql plus.

CDSI/US EPA , RTP , NC 09/19 93 -10/1994

Consultant

Responsibilities:

  • Implemented Scientific Work Planning Module and Publication Module using Oracle 6.x & 7.x, Developed basic forms and reports using Power Builder.
  • Used PL/Sql for interfaces. Used Sql Plus to create adhoc reports.

Saint Augustine’s College, Raleigh,NC08/1988-7/1993

ASST.Professor

  • Taught computer courses to undergraduate students.
  • Taught COBOL, FORTRAN, MIS,and SYSTEMS ANALYSIS & DESIGN.

Saint Paul’sCollege, Lawrenceville,VA 08/1986-07/1988

ASST.Professor

  • Taught Computer courses to under graduate students
  • Taught COBOL, FORTRAN, MIS and SYSTEMS ANALYSIS & DESIGN.

`

EDUCATION

M.S., Computer Science, Jackson State University, Jackson, Mississippi

M.S., Food Science & Technology, Alabama A & M University, Huntsville, Alabama

B.Sc. Agriculture science, Andhra Pradesh Agriculture University, Hyderabad, INDIA