Sql Data

PROFESSIONAL SUMMARY

. Over * years Experience in database design, development, testing,

implementation, Tuning and up gradation of Oracle 9i, 10g, 11g

environments.

. Experience in data analysis, logical/physical data modeling, development,

testing and documentation of projects.

. Strong Coding and Designing Experience in Oracle PL/SQL & SQL.

. Experience in creating PLSQL and UNIX Scripts for Data validation, Data

conversion and Loading.

. Extensive experience in Oracle Back-end PL/SQL Development i.e. Packages,

Stored Procedures, Functions & Triggers using SQL Developer and Toad as

development tools.

. Good Experience in developing object oriented applications and web

applications using Java, HTML, XML and JavaScript.

. Experience in creating PLSQL and UNIX Scripts for Data validation, Data

conversion and Loading.

. Good Experience in UNIX shell scripting and using Autosys for Job

Scheduling.

. Good experience in developing applications using tools like oracle Forms

and Reports 10g/9i/6i .

. Proficient in developing PL/SQL packages, stored procedures and creating

Tables, Views, Triggers, indexes and developed various applications,

using Oracle built-in functions.

. Experience in complete SDLC of a project that included Requirement

Analysis, System design, Functional Specification, Design specification,

preparation of impact analysis, Coding, system test plan, Testing, code

review, coordinating user testing and user training, Project

documentation, Implementation, On-line support and Maintenance.

. Experience in Analyzing the business/ Functional requirements and writing

Technical Specification documents and Test documents.

. Good Experience in creating Relational and Dimensional data models using

Erwin.

. Experience in Database query tuning, Performance tuning (Explain Plan and

TKPROF utility) and troubleshooting Application and database issues.

. Excellent analytical, problem solving, communication and inter-personal

skills to manage and interact with individuals at all levels.

. Strong communication, organizational and interpersonal competencies

. Self-motivated and committed person with excellent interpersonal

communication skills.

. Familiar with configuration Management tools like Rational Clear Case,

Visual Source Safe.

EDUCATION and certifications

BACHELOR OF ENGINEERING IN COMPUTER SCIENCE

JNTU University India

Oracle Certified

[pic]

Oracle Database:

SQL Certified

Expert

TECHNICAL skills

OPERATING SYSTEMS : WINDOWS 98, WINDOWS NT/2000/XP, UNIX

Languages : Java 1.4, C, UML, SQL, PL/SQL, HTML, XML

Data & Modeling Tools : Erwin 4.2, Oracle Designer 10g

Scripting Languages : JavaScript, HTML, CSS, PERL, PHP

Database : Oracle 11g, 10g, 9i, 8i, SQL server, MS-

Access, MY

SQL, Oracle 9i/10g

RAC

Servers : Apache Tomcat, Oracle

Application server 10g R3,IIS

IDE's : Eclipse

Database Tools : TOAD, PL/SQL Developer, SQL-

Navigator, Forms

6i/9i/10g, Reports

6i/9i/10g, Discoverer 4i,

SQL*Loader, SQL

*PLUS, TOra, SQL Developer,

EXPLAIN PLAN,

TKPROF, OEM

Configuration Management : Rational Clear Case, Visual Source Safe,

Clear Quest

PROFESSIONAL EXPERIENCE

MED IMPACT HEALTHCARE SYSTEMS,

APR 09 - MAR 10

San Diego, CA

Oracle Consultant

. Worked closely with the business users and developers to make sure that

business requirements are correctly translated into database schemas and

ultimately into the application.

. Involved in gathering of business scope and technical requirements and

created technical specifications.

. Assisted with the design, implementation and support a multi-terabyte

point-of-sale data base, performing database design, implementation, and

the creation and tuning of data aggregation mechanisms.

. Involved in Architecture of the modules and developing supporting code

that controlled the whole flow drug management in the weekly process as

per specifications.

. Responsible for development and maintenance of Formulary Systems and

claims management applications.

. Worked with Erwin tool in designing a fully-normalized enterprise data

model of clients, members, providers, managed claim histories, and the

pharmacy claims which constitute the bulk of the transaction volume.

. Responsible for creating PLSQL Programs and UNIX Scripts for data

Transformation, data cleansing, data validation and data reporting.

. Created packages included PL/SQL methods, Functions REF CURSORS and Bulk

Collections

. Used AUTONOMOUS_TRANSACTION PRAGMA for logging the status when error

occurs.

. Extensively used the advanced features of PL/SQL like collections, nested

table, varray and dynamic SQL.

. Developed front end interface screens for data entry and data validations

using Java and JSP.

. Designed, developed and documented data synchronization and data

migration processes for Customers Meta data.

. Involved in the up gradation of existing software for meeting the

customers' new requirements.

. Designed and developed complex procedures to handle errors and exceptions

at both application and database levels using PL/SQL and SHELL scripts.

. Developed PL/SQL and UNIX scripts for creating and customizing adhoc

reports on claims for users.

. Used data pump to import and export Oracle database object and data.

Implemented a simple database backup and recovery process.

. Tuning and monitoring database and implemented Performance Tuning

activities that included SQL tuning, Optimizer hints, indexes, direct

load, table/index partition, configuring oracle parameters and redesign

process.

. Created Testing documentation that included Test cases and testing

procedures and involved in unit and integration testing of the modules.

. Coordinating with QA Team for System Test Specifications and bug fixing.

. Was responsible for User acceptance testing, building, packaging and

shipping of the application to the production environment.

. Tuning and monitoring database (database applications tuning, which

included testing the application and suggesting changes in code so as to

improve performance).

. Worked closely with DBA's and other teams for supporting and achieving

organizational and team goals.

. Provided troubleshooting support to client and business divisions.

Environment: Oracle 10g/11g, Java 1.4, JSP, Tomcat 5.0, Erwin 7.2, SQL

Plus, TOAD, PL/SQL, SQL Navigator, Data Pump, SQL*Loader,Oracle

Application server 10gR3, HP-UX, SSH Client, EXPLAIN PLAN, TKPROF, Autosys,

Windows NT/2000/XP, PVCS.

Citi Group

Jan 08 - Mar 09

Charleston, SC

Oracle Consultant

. Interacted with business representatives for requirement analysis and

to define business and functional specifications and created technical

specifications documents.

. Participated in the design and development and maintenance of automated

trading desk.

. Performed the database upgrade from Oracle 9i to 10g.

. Developed Procedures and Packages for implementing the programming

changes determined by NASD.

. Involved in the up gradation of existing software for meeting the

customers' new requirements.

. Involved in the development of the entity relationship diagrams for the

source and target tables

. Developed Stored Procedures for various validations while inserting data

into the tables and developed PL/SQL Packages for incorporating the

business rules.

. Depending on the requirements created database objects like tables,

indexes, views, procedures, functions, packages, Triggers, synonyms,

analytical functions.

. Responsible for implementing the Data conversion methodologies for data

transfer between client systems and the corresponding database.

. Responsible for creating many PL/SQL packages that were used by Java user

interfaces that interfaces to Oracle database in UNIX environment.

. Developed SQL Queries to fetch complex data from different tables in

remote databases using joins, database links and Bulk collects.

. Loading data using SQL*Loader (both conventional and direct path loading)

and Stored procedures.

. Developed several PL/SQL Triggers to monitor the database activities and

to implement some database constraints.

. Responsible for creating forms to do data entry and various utilities of

Customer Accounting.

. Implemented Query Optimization by using indexes, respective joins.

. Developed some of the Regulatory and Accounting reports for the end user

by using PL/SQL and UNIX scripting.

. Performance Tuning done by using explain plan and query optimization

techniques.

. Provided troubleshooting for the Trading problems to clients and business

divisions.

. Responsible for designing, developing and implementation of test plans.

. Prepared Test cases and testing procedures and involved in unit and

integration testing of the modules.

. Tuning and monitoring database and implemented Performance Tuning

activities that included SQL tuning, Optimizer hints, indexes, direct

load, table/index partition, configuring oracle parameters.

. Provided the production support for the applications after the CR

implemented.

. Created user-training documents that aids the end users and participated

in the UAT.

Environment: Oracle10g, Erwin 4.2, SQL Plus, TOAD, PL/SQL Developer,

SQL*Loader, SQL Navigator, TOra, EXPLAIN PLAN, TKPROF, Oracle reports 10g,

Autosys, HP-UX, Windows NT/2000/XP.

Sprint,

Sept 06- Nov 07

Dallas, TX

Oracle Developer

. Interacted with the business and tem lead to gather requirements and

performed analysis for design and development of applications

. Involved in billing system migration project from BCGI to AMDOCS.

. Analyzed and participated in the database design for better understanding

the relations, associations and dependencies within the database.

. Used Erwin for Physical and logical database modeling.

. Responsible for requirements gathering, design, configuration changes,

technical specifications, generating test scripts, documentation,

. Developed PL/SQL packages with UNIX Scripts for some

Conversion/interfaces.

. Responsible for creating procedures for Data Validation, Data conversion

and Loading for data migration.

. Developed back-end logic for business applications, e.g. views,

procedures/functions, triggers.

. Written UNIX shell scripts for adhoc reports and managed them for job

scheduling using Autosys.

. Sql Loader was used to load data from flat files into target tables.

. Developed SQL Queries to fetch complex data from different tables in

remote databases using joins, database links and Bulk collects.

. Developed stored procedures for Oracle database to improve performance.

. Responsible for tuning of SQL queries written in procedures/functions at

the back end which are called from the front end forms.

. Fixed a bunch of known billing performance issues by code optimization in

several bottleneck billing scripts.

. Tuned performance for billing system modules, e.g. SQL statement tuning

and data restructuring.

. Implemented Performance Tuning by using Explain Plan and TKPROF tools

that included Optimizer hints, using Indexes and also Query tuning.

. Developed billing scripts and reports using SQL, PL/SQL and UNIX

. Improving Application performances by analyzing the codes and replacing

with optimized elements.

. Prepared Test cases and testing procedures and involved in unit and

integration testing of the modules.

. Tuning and monitoring database (database applications tuning, which

included testing the application and suggesting changes in code so as to

improve performance).

. Provided Production Support and worked on production issues and resolved

in time.

. Maintained and developed Customer Care Front-End OLTP application for

call centers.

. Worked closely with DBA's and other teams for supporting and achieving

organizational and team goals.

Environment: Oracle 9i, SQL, SQL*PLUS, SQL*Loader, Developer 2000, TOAD,

SQL Developer, PL/SQL, PL/SQL Developer, PHP, XML, UNIX

Cracker Barrel OCS, Lebanon, TN

Apr 05 - Jun 06

Oracle Developer

. Developed a process to facilitate the daily load process that stages the

data in Tran-data into a staging table in the Retek database. Tracked

the data that was staged via a sequence-staging table.

. Developed a backfill process that loads the daily inventory fact table

with data from daily_td_stage. The daily_td_stage table contains all the

daily transactions. This process was developed to facilitate loading the

RDW with 13 months of data.

. Developed a new process to populate the RDW_PERIOD table with information

contained in DATE_INFO each day.

. Created views for all of the new daily fact tables and modified the

existing weekly views.

. Developed various stored procedures as per the requirement.

. Responsibilities include database Performance tuning using TKPROF,

explain/Plan, and utility and also performed Application tuning.

. Created Appworx modules and chains to scheduled daily batch jobs.

RDW Reporting

. Developed the Sales, Inventory & Labor Reports by Dept and Buyer. Created

staging tables, data staging process and both the reports.

. Developed new Sales, Inventory and Labor weekly flash report rolled up at

Company, Region, District and Store level.

. Developed a process that sends out reports in batch to the Directors,

RVP's DM's and Stores.

. Developed a new audit report that will show comparisons between what is

in RMS's TRAN_DATA_HISTORY table and the RDW Daily Fact tables. It sends

out an email to the user group on a regular basis.

. Developed a new audit report that takes the sum of daily fact table

transactions and compares those to the data that is loaded into the

weekly fact tables. This will compare 7 days of daily fact data to 1

week of weekly fact data.

. Developed a report displaying the percentage of stores that have had

sales included in the RDW Daily Load process. The daily load process

waits for this report and runs only when the required percentage is met.

. Developed a new audit report to indicate that all staged records were not

loaded into the RDW Daily Fact tables whenever this anomaly occurs. This

report will be sent as an email to the RDW Support group.

. Developed different reports like list reports cross tab reports and

several report templates using Cognos Impromptu and Power Play.

Oracle 10g Upgrade

. Worked on a report that was not compiling against 10g database. The

problem was with synonyms to remote systems in program units causing the

compile to crash. Developed a staging process, which collects the data

from the remote db link and used local variables in the program units to

hold the data, which solved the problem.

. The store cycle count entry form was taking almost 5 minutes to startup

during production. Underlying SQL is tuned and the process of staging SCC

tables was re-engineered.

. Tuned the performance of various reports and forms that are taking longer

time than before upgrade to 10g.

. Involved in the 10G Upgrade Stress Test.

Oracle RETEK - RMS Replenishment Enhancements

. Designed a process that enables the end users to upload Location Traits

from a CSV file into the Retek system. It involves in the development of

a Pro*C program and an Oracle form.

. Developed a weekly process to create a cross-reference file that will

contain the SKU and the corresponding Supplier VPN. The process places

this new file out on the FTP server.

. Developed a report and parameter form to be used by Merchandising to

review max cap exceptions. This report can be run online or in batch.

. Developed triggers for auditing the receiving adjustment form and

shipment receiving form

. Created user-training documents that aids the end users and participated

in the UAT.

Conversion of E-Commerce Data mart

. Involved in modification of existing T-SQL scripts

Involved in the conversion of the E- Commerce data mart from SQL Server

2000 to Oracle 9i

Environment: RETEK, RDW, APPWORX, RATS, HP-UX, Linux, Korne Shell

Programming, Oracle 8i, 9i and 10g, Toad, Sql Plus, Pro*C, Oracle Forms and

Reports 10g, 6i, Cognos Impromptu 7.0, SQL Server 2000, SCCS, PVCS.

IBM India, Bangalore, INDIA Jun 04 - Dec 04

Bank of America,

Software Developer

. Participated in Requirement gathering and analyzed the business

Functionality with users and created Technical Specification Document.

. Written JSP's using HTML, Custom Tags, CSS and JavaScript used to handle

client side validations.

. Developed Server side PL/SQL (Stored Procedures, Functions & Packages) in

Oracle 9i for implementing different modules like Bill Payment online,

Credit card Registration Home loans online etc.

. Used TOAD developer tools for faster application design and developments.

. Developed Stored Procedures for various validations while inserting data

into the tables and developed PL/SQL Packages for incorporating the

business rules.

. Developed several PL/SQL Triggers to monitor the database activities and

to implement some database constraints and to enforce security..

. Developed PL/SQL Functions, Cursors for various calculations in the

application.

. Extensively used PL/SQL tables, cursors and exception handling.

. Developed PL /SQL code for updating payment terms.

. Written complex SQL statements using joins, sub queries and correlated

sub queries.

. Tuning and monitoring database (database applications tuning, which

included testing the application and suggesting changes in code so as to

improve performance).

. Involved in writing unit test cases for various modules and implemented

them.

. Monitor and Control the test execution and defect resolution.

. Involved in Bug fixing for various modules.

Environment: Oracle 9i, Java, JSP, PHP, PL/SQL, SQL PLUS, SQL Loader,

TOAD, UNIX

IBM India, Bangalore, INDIA

Apr 03 - Mar 04

Sprint USA

Software Developer

. Developed database objects like Tables, Views, Indexes, Synonyms and

Sequences

. Written Packages, Triggers, Stored Procedure and Functions for the

following modules products & Plans, bill Payment, Online Accounting.

. PL/SQL coding for Exception Handling and duplicate data maintenance.

. Used Triggers in Customizing Error conditions.

. Developed UNIX Shell Scripts and PLSQL procedures to extract and load

data for month-end batch processing.

. Developed PL /SQL code and Perl scripts for various customized reports.

. Creation of Forms, Pop-up Menus and maintaining Master Detail relation-

ship.

. Involved in the design and development of User Interfaces using Forms 6i,

Reports 6i and coding modules in PL/SQL.

. Development of client side program units and sharing them among multiple

applications for processing business logic in the database.

. Testing all forms, PL/SQL code for logic correction.

. Preparation of Test cases documents for unit testing and implementing

them.

. CVS was used as the version control.

Environment: Oracle 8i, SQL, PL/SQL, Forms & Reports 6i and Win2000, PERL.

Contact this candidate