Laxminivas R. Pabbathi

acga81@r.postjobfree.com

Professional Summary

A developer and database administrator with 23 years of Technical knowledge in Computer

software. Knowledge in UNIX shell scripting and Unix Network file systems, principles and

processes involved in business and organizational planning, coordination, and execution, JAD

(joint application development) sessions to bring management, user and technical teams together

to derive the business rules for new IT application development. Using the industry-standard

tools such as ORACLE DISCOVERER, TOAD, ERWIN, SYSTEM ARCHITECT, DATA

JUNCTION, Business ObjectsXIR3, FLAT FILE DATABASES, EXCEL and RELATIONAL

DATABASES like MS ACCESS, DB2, GLASSFISH 3.1.1, WEB LOGIC 10.3.6, APEX4.0,

APEX4.2, REST_DATA_SERVICES (2.0.8).

Work History

Senior Database Analyst 03/2006 to Current

Florida Department of Children & Families

Tallahassee, FL

In the process of creating the virtualized platform in order to migrate the applications &

data in order to make simple, make more efficient, to deploy faster, for high

performance & availability and cost reduction by automating the business process.

Installed WebLogic Server 10.3.6 and configured Rest_Data_Services 2.0.8

to access multiple database instances.

Installed Apex4.2 and configured with rest_data_services

Creating web applications in Apex4.2 and deploying them with Glassfish open-source

application server and Oracle WebLogic application server.

Installed and configured Oracle Fusion Middleware 11g Release (11.1.1.8.0).

Unloading high volumes of data with different formats (CSV, XLS, TXT) into database,

using external table concept.

Installed open source Glassfish server 3.1.1 on Linux.

Installed & configured Business Objects Enterprise XIR3.

Database Upgrade from 10G to 11G.

Applying patches to database & application server periodically as recommended by

Oracle.

Created scripts to clone the databases from Production to Test and Development .

Installed 11.2 client.

Installed & Configured APEX 4.0, Apex Listener 1.0 to develop Web Based applications.

Configured Oracle Enterprise Manager which enable monitor and tune the databases.

Creating Packages, Procedures in PL/SQL

Creating jobs and schedule them .

Creating Scripts on Linux.

Use TOAD for DB administration.

Making connections from Oracle to SQL server by defining a Data Source Name (DSN)

with windows ODBC.

Creating and Modifying Custom Reports to satisfy the needs of Providers.

Installed WebLogic Server 10.3.6 and configured Rest_Data_Services 2.0.8

to access multiple database instances.

Senior Database Analyst 09/1998 to 03/2006

Florida Department of Education

Tallahassee, FL

Created text Files from DB2 database and loaded the data into Oracle Data Warehouse.

Presenting the data at the database conferences to the district MIS personal, and

explaining them about the data submission errors in batch files and its impact on state and

federal funding.

Creating reports with SAS PROC REPORT and exporting the reports into various plat

forms like EXCEL, RTF, PDF and HTML by means of SAS output delivery system.

Creating TABLES, TRIGGERS, STORED PROCEDURES, VIEWS, USERS, and

CONSTRAINTS to implement the business rules on database.

Create Reports in Oracle Discoverer 4.1 & MS Access.

Systems Project Analyst 05/1997 to 09/1998

Florida Department of Juvenile Justice

Tallahassee, FL

Used ERWIN for data modeling and created the JJIS database.

Created text Files from DB2 and load the data into Oracle Data Warehouse

Using Bulk Copy utility to load the data into SQL server.

Identifying the user needs and creating the customized reports.

Tuning the databases by writing effective SQL Scripts and stored procedures.

Automate the TASKS with Transact-SQL statements.

Distributed Computer Systems Analyst 06/1991 to 05/1997

Florida Department of Law Enforcement

Tallahassee, FL

Served as the bureau point of contact and coordinator for Office of Finance &

Accounting for IT needs.

Assist the Bureau with development, maintenance and all data reporting needs.

Created an in house SAMAS data warehouse for the Office of Finance & Accounting,

FDLE.

Co-op Application Programmer 01/1989 to 08/1989

IBM Corporation

Cary, NC

Modified a Presentation Manager Application using the relational database. Developed a

test application in C for INFO product version 4.2 under MVS system.

Technology & Skills

Database design.

Windows and Linux.

Database Upgrades 10g to 11g and 11gR2.

Applying Patches Periodically.

Excellent written and verbal communication skills.

Excellent Diagnostic Skills.

BOE Administration and Security.

WebLogic Administration.

Oracle Forms 6.0.

Apex4.0 to Apex4.2

Unix Shell Programming

Oracle 8i, 9i, 10G & 11G Database Base Administration

SAS Programming, ODS & Oracle Reports

Crystal Reports 8.5

Microsoft Office 2010 and creating custom reports with MS Access.

SQL server admin and Data Warehousing .

DB2 database Programming.

SQL and PL/SQL Programming.

Review of Contracts and Create Technical Specifications.

Flowcharting.

Attending the service team meetings and the technical meetings periodically.

Maintain good relationship at work place.

Provide on job training as needed.

EDUCATION

MS in Computer Science 1989

Jackson State University, Jackson, MS.

MS in Applied Mathematics 1975

Osmania University, Hyderabad, India.

AWARDS & CERTIFICATIONS

Davis Productivity Award for Batch Upload Pilot Project at

Florida Department of Children & Families. 2008

Davis Productivity Award for Pay Roll Automation at

Florida Department of Law Enforcement. 1996

Contact this candidate