VIJAY PURAM

404-***-****©

acavhb@r.postjobfree.com

PROFESSIONAL SUMMARY:

Programming experience as an Oracle PL/SQL Developer in Analysis, Design,

•

and Implementation of Business Applications using the Oracle Relational

Database Management System (RDBMS).

Strong Knowledge on oracle architecture and database design.

•

Involved in all phases of the SDLC (Software Development Life Cycle) from

•

analysis, design, development, testing, implementation and maintenance with

timely delivery against aggressive deadlines

Experience with Data flow diagrams, Data dictionary and Database

•

normalization theory techniques, Entity relation modelling and design

techniques

Experience in Client Server application development using Oracle

•

11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.

Created various reports using oracle reports developer like matrix reports,

•

matrix with group reports, and group above reports using Reports

10g/9i/6i/3.0/2.5 and designed user interfaces with Forms 10g/9i/6i/5.0/4.5.

Solid experience of creating PL/SQL Packages, Procedures, Functions,

•

Triggers and Materialized Views to retrieve, manipulate and migrate complex

data sets in Oracle Databases

Effectively made use of Table Functions, Indexes, Table Partitioning,

•

Collections, Analytical functions

Created Tables, Views, Sequences, Constraints, Indexes (B Tree, Bitmap and

•

Function Based)

Excellent technical and analytical skills with clear understanding of design goals

•

of ER modelling for OLTP and dimension modelling for OLAP.

Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL

•

Tables and Exception Handling.

Experience with Oracle Supplied Packages such as DBMS_SQL,

•

DBMS_JOB, UTL_FILE. Used DBMS_SCHEDULER to run jobs in parallel to

improve time constrained performance.

Used DBMS_PROFILER package, which enables the collection of profiler

•

(performance) data for performance improvement.

Created Packages and Procedures to automatically drop table indexes and

•

create indexes for the tables.

Worked extensively on Ref Cursor, External Tables, and Collections.

•

Experience in performance tuning and Query optimization using Explain

•

Plan, TKPROF, HINTS and SQL Trace utilities.

Experienced in Error Handling By Using Exceptions.

•

Experience in SQL performance tuning using Cost Based Optimization

•

(CBO)

Good knowledge of key Oracle performance related features, such as

•

Query Optimizer, Execution Plans and Indexes, for faster execution

Experienced in UNIX shell Scripting.

•

Proficient in developing front end interfaces using Oracle Forms and Reports.

•

Ability to be an effective team player and work under severe time constraints.

•

Performed database tuning and performance monitoring.

•

Take care of the Database design and implementation.

•

Good knowledge on Oracle data integrity.

•

Establish and maintain sound backup and recovery policies and procedures.

•

Work as part of a team and provide 7x24 supports when required.

•

Excellent communication, interpersonal, analytical skills and strong ability to

•

perform as part of a team.

TECHNICAL SKILLS:

Languages SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, HTML,

XML.

RDBMS Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2000/2005/2008,

Sybase, DB2 MS Access.

Oracle Utilities SQL*Plus, SQL*Loader, SQL developer, TOAD

11.0,10.0,9.0/9.1/9.5, Import, Export, Data Pump, Squirrel sql

Client 3.5.0

GUI Tools OracleForms10g,9i,6i,5.0,4.5 and Reports

10g,9i,6i,3.0,2.5,ERWIN,Cognos Reports

PROFESSIONAL EXPERIENCE:

Client: Sure scripts, Minneapolis, MN June’ 13 –

Sep’13

Role: PL/SQL Developer

Surescripts is a E prescription network. Surescripts certifies software used by

prescribers, pharmacies and payers/PBMs for access to three core services:

Prescription Benefit, Medication History and Prescription Routing. This Project is

for converting the entire system from Microsoft SQL Server to Oracle Exadata box.

Responsibilities:

Designed and developed Oracle PL/SQL Procedures, Functions, and Database

Triggers and involved in creating and updating SQL Packages to meet

business requirements.

Conversion of some Stored Procedures, Views, functions, Tables from T sql to

PL/SQL.

Generated SQL and PL/SQL scripts to install create and drop database objects

including Tables, Views, Primary Keys, Indexes, Constraints, Sequences

and Synonyms.

Extensively worked with Data stage, Production Team for migrating data from

Sql Server to Oracle Exadata box.

Extensively worked in Decision Support team for immediate assistance when the

project is in Production.

Loaded data into oracle database from flat files using SQL*Loader.

Worked on PL/SQL program units to include DML, DDL statements using

Dynamic SQL.

Used Explain plan, TKPROF to gather the statistics along with analyze command

for performance tuning.

Extensively used Oracle reports to run week end reports.

Extensively worked on Explain Plans and various hints for Performance tuning.

Environment:

Oracle 11.2.0.3.0 64bit Development, Microsoft SQL Server 2008 R2 (SP2)

10.50.4000.0 (X64), Oracle reports 9i/10g, Linux Version 11.2.0.3.0.

Client: AT&T, Atlanta, GA Apr’ 12 –

May’ 13

Role: PL/SQL Developer

AT&T is a global leader in delivering innovation in communications, information and

entertainment. Recently, AT&T offloaded around six million broadband and voice

customers in 13 states to Frontier Communications. The project named PARS

(Performance Analysis Reporting Services) used to deal with migration of data

from AT&T server to Frontier Communication server. Involved in creation and

customization of reports for various perspectives to the managers to help in their

decision making process.

Responsibilities:

Interacted with the end users and business analysts for gathering of requirements

and analyzed them.

Involved in design and performed reviews for Code or any other deliverables

prepared by the team members.

Preparation of effort estimation for various tasks taken up.

Rigorous technical analysis using Oracle’s 10g (upgrading to 11g) features for

providing better solutions.

Worked on SQL*Loader to perform bulk data loads into database tables from

external data files.

Designed and developed Oracle PL/SQL Procedures, Functions, Database

Triggers and involved in creating and updating SQL Packages to meet

business requirements.

Created UNIX shell scripts to automate data loading, extraction and to perform

regular updates to database tables to keep in sync with the incoming data from

other sources.

Created Materialized Views for extracting the data from remote database.

Wrote complex SQL queries to extract data from various source tables of data

warehouse.

Created various Function Based Indexes to significantly improve performance.

Involved in Creation of tables, Join condition, Correlated sub queries, Nested

Queries, Views for Business Application Development.

Extensively used Collections with bulk bind to insert and update large volumes

of rows into target databases.

Used Pragma Autonomous Transaction to avoid mutating problem in database

triggers.

Extensively used advanced features of PL/SQL like Ref Cursors, Collections

(Nested tables and Varrays) and Dynamic SQL.

Used Oracle packages like DBMS_STATS to collect statistics of many different

kinds as an aid to improve the performance and UTL_FILE to read and write

operating system text files.

Extensively used Exception handling for tracking and logging exceptions raised

during PL/SQL code execution.

Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by

creating indexes.

Extensively worked on Forms and Reports.

Extensively used bulk collect to fetch large volumes of data from the table.

Created Jobs and stored procedures using Dynamic SQL for refreshing

materialized views.

Preparation of wrapper scripts for all the database processes and data quality

checks using Unix Shell scripting.

Extensive usage of Oracle External Table Concept to extract Data from feed File

sent to FTP feed file location.

Monitoring the schedules and timely escalations to the project management and

client in case of any slippages.

Extensively involved in using HINTS to direct the optimizer to choose an

optimum query execution plan.

Performed unit test on the developed code to ensure that its bug free.

Handled Production issues and manage the same in issue log.

Environment: Oracle 11g, PL/SQL, Toad 10.0,SQL Developer, VI editor, Putty,

LINUX, SQL loader, Oracle Forms 10g.

Client: Lexmark Lexington, KY Apr’ 11

Mar’ 12

Role: Oracle Developer

The project involved development of customer service information system for

various products supplied to customers and data extraction & cleansing from data

warehouse. This system maintains information about customer details, products

supplied & warranty and inventory information. Other important feature of this

application is that it keeps track of the details of customer complaints and the

concerned action taken.

Responsibilities:

Analyzed and overviewed the database design for better understanding the

relations, associations and dependencies within the database.

Discussed and analyzed business functionality with the client and the developers.

Generated SQL and PL/SQL scripts to install create and drop database objects

including Tables, Views, Primary Keys, Indexes, Constraints, Sequences

and Synonyms.

Developed and modified PL/SQL packages, procedures, functions as per

customer requirement to make new enhancements or resolve problems.

Wrote complex SQL queries to retrieve information from the databases

depending on user requirement.

Created PL/SQL program units to implement DML, DDL statements using

Dynamic SQL.

Used the Merge statement to select rows from one or more sources for update

and insertion into one or more tables.

Created triggers to automatically populate different tables and also to restrict the

data being inserted to the tables.

Created Bitmap Indexes on low cardinality columns as they result in reduced

response time for queries and substantial reduction of storage space.

Wrote control files and loaded the data into the Oracle database with SQL Loader.

Writing SQL reports and scheduling these reports from UNIX scripts.

Used PL/SQL Developer Tool to do the backend development.

Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.

Implemented Materialized View for extracting the data from remote database.

Handled various Exceptions to trouble shoot PL/SQL code.

Used PL/SQL Collections (Nested Tables and Varry) in complex backend

packages.

Coded Unix shell scripts to call SQL scripts and to manipulate the returned data.

Developed test plan documents for all back end database modules.

Developed Oracle Forms for form end user using oracle form builder 10g.

Worked with different triggers in forms like Block processing triggers, Interface

event triggers, navigation triggers and validation triggers etc.

Developed Grouping report and matrix reports using oracle reports 10g report

builder.

Extensively worked on Explain Plans and various hints for Performance tuning.

Environment: Oracle 10g, Windows XP, SQL, PL/SQL, SQL*Loader, Forms and

reports 10g, PL/SQL Developer, UNIX, TOAD.

Client: Intergraph Hyderabad, India May 2009– Oct

2010

Role: Oracle Developer

Description: Development and enhancement of Sales tracking and forecasting

system. This application supported the sales team to enter Sales Leads, create

Opportunities based on leads and to generate the quotes for any product lines.

Forecasting functionality facilitated the sales teams to generate sales forecasts for

any quarter/year. This system was developed using Oracle Forms 6i, Reports, SQL

and PL/SQL.

Responsibilities:

Involved in Database Design and Analysis.

Analyzed and Created Partitions on the tables to improve the performance and

enhance parallel processing.

Design and Developed data validation, load processes using PL/SQL, Stored

Procedures, Functions, and Triggers using Oracle 10g.

Created Control Files and used SQL* Loader to upload bulk data into database

from external files.

Involved in formulating general methodologies, naming conventions and coding

standards for various procedures and packages

Involved in Code Standardization and Documentation.

Involved in Logical and Physical Database design and Star Schema design.

Identified Fact tables, Transaction tables.

Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.

Involved in database Performance Tuning and monitoring.

Designed and developed user interfaces using Oracle Forms.

Designed Report output formats, complex filtering and formula calculations, as well

as the rendering of multi band and multi grouped reports.

Developed complex triggers in reports before/after for validation of user input.

Involved in designing of required end user forms and reports using Oracle

forms 10g & Reports 10g.

Coordinated between management, users and technical teams for Requirement

Gathering.

Developed UNIX Scripts to create FTP Jobs and data upload.

Involved in various activities like preparation of Technical Documentation, Client

Discussions for purposed solution and User Acceptance Testing.

Environment: Oracle 9i, Oracle Web Server (OAS), HTML, DB2, UDB, XML,

JavaScript, Developer suite 9i, UNIX.

EDUCATION & CERTIFICATION

Bachelor of Technology (Computer science Engineering) JNTU, India.

Masters in computer science NPU,California,United states

Contact this candidate