Veerababu Geddati

IT Database Consultant

Cell – 901-***-****

Experience Summary

IT Professional with 2 years of experience in healthcare along with 11+ years of experience

in analysis, design, development, support, debugging, enhancement, tuning and

implementation of enterprise applications for commercial industries such as home

warranty and petroleum. Exposure to Web development using JAVA and PHP.

• Experience with Software Development Life Cycle adhering to well defined Quality processes and

methods along with database design and data modeling.

• Proficient in Oracle PL/SQL programming, in constructing Stored Procedures, Functions, Ref

Cursors, Packages, Indexes, Database Triggers, Joins, Oracle Regular Expressions, Pipelined

Functions, Partitions, Bulk, Collections, Views, Dynamic SQL.

• Experience in Java Development.

• Working knowledge of the open source technologies like Eclipse.

• Experience in ETL development using PL/SQL programming.

• Experience with data transfer tools, such as FTP.

• Extensive experience with performance tuning, unit testing, and optimization.

• Experience with logical and physical database design using ERwin

• Experience with data migration from OLTP to the Archival Database and across different

databases using Database Links.

• Experience with automation process using UNIX shell scripting.

• Experience in the design and development of complex reports in Cognos (both Report and Query

Studios), APEX, and PowerBuilder using PL/SQL, and SQL.

• Involved in scheduling and distributing of Cognos Reports using Cognos Connection.

• Experience with Dashboard Reports development in Cognos.

• Implemented Cognos security using Access Manager.

• Exposure to Virtual Private Database and Oracle DBMS_schedular.

• Responsibilities included working with Business and End Users on Report requirements,

developing appropriate specifications and building reporting objects.

• Exposure to framework manager to create metadata for Cognos reports.

• Experience in SQL*LOADER for loading from external Sources to Oracle DB.

• Exposure to oracle advanced queue

• 8 Years of experience as Serena ChangeMan Version Manager (PVCS) Administrator.

• Implemented proper version control, bug tracking, coding standards and testing infrastructure for

the web and non-web source codes.

• Self-motivated, organized team player with strong problem solving and analytical skills and total

commitment to the organizational goals.

• Strong troubleshooting and organizational skill.

2009 – Present IT Database Consultant - Mississippi Medicaid DSS/DW Project, Jackson, MS

Work with DSS (Decision Support System) Team to evaluate and enhance the performance of the

JSURS, MSIS Extracts. Also, develop reports in Cognos and APEX. Create models and cubes

using Framework Manager and Cognos Powerplay

Case Management

This application has been developed in the Oracle Application Express (APEX). The application is

being used by the Program Integrity Team at the Department of Medicaid to create complaints

and cases. Design; analyze the users’ requirements to develop the Reports. Also fix any issues

in the application. Enhance the application by adding new functionalities on client side as well as

backend such as procedures, functions, packages etc.

CSR Tracking

This application has been developed in the Oracle Application Express (APEX). This application

is being used to monitor the progress of the customer (DOM) requests. Enhance the application

by addition adding new functionalities. Also develop reports based on the users’ requirements.

PL/SQL Projects – Applications – JSURS and MSIS

• In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables,

collections, functions, collections, user defined datatype, procedures etc

• Exceptionally good and experienced in handling the problem and troubleshooting.

• Analyses and discuss the business requirements with the clients.

• Responsible for the development, implementation and maintenance.

• Optimized and modified the triggers, complex store functions, procedures, user base

datatype etc.

Cognos Reports

Involved in designing and developing Cognos metadata model and reports using Cognos Query

Studio, Report Studio, and Analysis Studio. Responsible for the development of complex reports,

and dashboards and cubes.

Web Development

Involved in the design and development of web application using JAVA and PHP under Eclipse

development environment.

2000 – 2009 System Application Programmer Analyst III - American Home Shield, Memphis, TN

Requirements gathering, system analysis and design, documentation, coding, testing,

implementation, monitoring production performance and production jobs, researching and

resolving production problems and dealing with end users to resolve issues along with design and

development of BI reports.

A. PL/SQL Projects

Involved in the development, enhancement of complex stored procedures, functions,

packages, tuning, debugging, support, and documentation of Projects written in PL/SQL,

such as Customer Renewal, Lead Management, and Service Applications along with

maintenance of existing applications

• Authored extensive SQL, PL/SQL stored procedures, oracle packages, ETL programs,

partitioning, materialized views, functions and triggers, UNIX shell scripts and

SQL*Loader programs to perform data migration.

• Using commands such as merge, ref cursors, Bulk regular expressions, etc in the code to

make the code more effective.

• Tuning the code for better performance using Explain Plan utility.

• Construct complex SQL queries with sub-queries, inline views, as per the functional

needs in the Business Requirements Document (BRD).

• Review business requirements with the Analysts, Business Users and Developers to

construct SQL queries for implementation in PL/SQL packages.

• Schedule the process with Oracle DBMS_schedular

• Creating row-level security using Virtual Private Database (VPD)

• Extensive experience with performance tuning, unit testing, and optimization.

B. Cognos Reports

• Develop dashboard reports and AdHoc reports using Report Studio, Query Studio in

Cognos.

• Scheduling and distributing Reports using Cognos Connection.

• Creating the portal pages.

• Enable drill-through access to another report for the users who can navigate from one

report to the next.

• Develop an ETL process using PL/SQL to populate staging tables for the Cognos

Reports.

• Experience with Framework Manager to create models

• Ran batch jobs for loading database tables from flat files using SQL Loader.

• Using Oracle Data Warehouse Builder to carry out the ETL process.

• Implemented Cognos security using Access Manager.

• Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts

utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing

performance and productivity to the projects.

• Developed data models using ERWIN data modeler for the report application.

C. Enterprise and Data Warehouse Reports

• Involved in generating enterprise/data warehouse reports using PL/SQL, SQL in

PowerBuilder.

• Running AdHoc queries for the user community.

• Experience with ETL development using PL/SQL.

• Wrote shell scripts to schedule the reports to run.

D. Data Archival Project

• Involved in design, development, enhancement, tuning, debugging, and documentation of

the Project.

• Wrote packages, procedures, triggers, cursors, ref cursors, and functions using the

dynamic SQL to move the data from OLTP to archival database.

• Wrote shell scripts to automate the process.

• ETL Process Development Using PL/SQL.

• Loading from external sources to Oracle Database using SQL* Loader.

• Performed Unit Testing for the Scripts.

• Involved in performance tuning which included creating indexes and modifying tables

using explain plan utility.

• Designed database schema as per technical specifications.

• Prepared Data Flow Diagrams for existing PL/SQL code.

• Involved in the logical and physical database design using ERwin for the archival tables.

E. PVCS Version Control Administrator

Implemented proper version control, bug tracking, coding standards and testing infrastructure

for the web and non-web source codes.

• Set up the PVCS Version Manager to version the source code such as PL/SQL

packages, functions, procedures, shell scripts, PowerBuilder objects and web projects.

• Provide support to developers in PVCS.

• Prepared documentation on how to use PVCS in PL/SQL and PowerBuilder for the users.

• Migration of the source code from one server to other.

• Set up security at project database and sub-project level.

• Implemented Power Builder and PVCS Version Manager interface.

• Implemented PL/SQL Developer and PVCS Version Manager interface.

1999 – 2000 Oracle Programmer Consultant - CITGO Petroleum Corporation, Tulsa, OK

• Involved in migration (upgrading) of Oracle 7.3 to 8.0 and pre-developed Forms 3.0 and

Reports 1.1 to Forms 4.5 and Reports 2.5 respectively along with Menus of commercial

applications.

• Development, testing and debugging of Oracle Forms and Reports.

• Rewrote triggers, cursors, packages and procedures to meet user requirements and

improve performance.

• Developed and modified PL/SQL packages, procedures, functions, triggers, reports per

customer requirement to make new enhancements or resolve problems.

E

ducation

PGDCA (Computer Applications) - Messoline Computer Academy, Kurnool, AP, India

Ph.D (Science) - Sri Venkateswara University, Tirupati, AP, India.

Operating Systems – Windows 98/2000,/NT/XP, UNIX, MS DOS

Microsoft Office – MS Visio, MS Excel, MS Access, MS Power Point, MS Project

Databases – Oracle 8i/9i/10g/11g, Data warehouse

ETL Tools – SQL Loader, Oracle Warehouse Builder, Cognos Powerplay

Design Tools – ERWIN, Cognos Framework Manager

Version Control – Serena ChangeMan Version Manager 8.1 (PVCS)

Web Tools – XML, VB Script, HTML, JAVA, C Sharp, VB Net.

Business Objects – Cognos

Scheduler Tools – Oracle DBMS Scheduler, Cognos Scheduler, and Shell Scripting

Security Tools – Cognos Access Manager, Virtual Private Database (VPD)

Reporting Tools – Cognos, PowerBuilder 7.0, Oracle APEX

Programming and Other Languages – PL/SQL, SQL, SQL*Plus, SQL.Net, UNIX Shell Scripting, VB

Script, JAVA. C# (C-Sharp), PHP.

IDE - Eclipse

Contact this candidate