Developer Sql

[pic]

[pic]

SUMMARY OF QUALIFICATIONS

Over 7+ years of IT experience in various phases of software development especially

in Analysis, Design, Development, testing and implementation as Oracle PL/SQL

developer.

Good experience in writing PL/SQL scripts for the database objects like tables,

views, procedures, functions, packages, database triggers, indexes and sequences,

Generated forms for data validation according to the business rules using Oracle

Forms 6i/10g and fixed some bugs that were already developed.

Experience in scheduling processes and maintaining up to date information, manage

folders for sharing reports, exporting data generating Crystal Reports 8.5/10g and

Oracle Reports 6i/9i/10g.

Experience in System Development Life Cycle (SDLC), which involves Analysis,

Design, Development, Testing, Implementation and support with extensive exposure in

database.

Very Good Knowledge about the Oracle tools like SQL, PL/SQL, SQL*PLUS, SQL*Loader,

and data pump utilities like Export/Import.

Experience in application fine-tuning and database fine-tuning using Explain Plan

and TKProf.

Experience in writing shell scripts for loading data and running the batch

processes through Control+M .

Experience in handling tools like TOAD, PL/SQL Developer, Visual Sleek Edit, also

used the X Windows for handling the Oracle Forms in Unix environment.

Experience in using Oracle development tools like SQL Developer, Oracle Enterprise

Manager, PL/SQL Developer, and using TOAD in secure databases.

Transferred data using FTP (File Transfer Protocol), SFTP (Smart FTP), WRQ

Reflection, Visual Sleek Edit, Winscp, Humming Bird took back-ups of the data using

SCP (Secured Copy).

Able to work independently and as team member; adept at motivating staff to ensure

smooth workflow and increased productivity.

Developed proactive monitoring shell scripts for loading of data and also for

loading the data files into the archive directories for easy processing.

Documented business rules, functional and technical designs, test cases, and user

guides.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 5.8/5.6/2.6, AIX 4.3/5.3, HP

UX 10/11i, Unix, Red Hat Linux, Win

NT/2000/9x.

Database: Oracle 10g//9i/8i/8.0/7.x and SQL Server

2000,SQL Server 2005.

Database Tools: Import, Export, SQL*Loader, SQL*Plus,

OEM, TOAD and Net8

Case Tools: ER Studio 7.1.2, Designer/2000/6i/9i,

Erwin

Languages: C,C++,JAVA, Shell Script (Bourne, Korne),

Perl, SQL, PL/SQL and BASIC.

Web: HTML, XML, JavaScript, and VBScript.

Reporting Tools: Oracle Reports (reports 2.5/3.0/6i/9i),

Crystal repots

Utilities SQL Navigator, TOAD, SQL* Loader,

PCAnywhere, SQL Developer, PL/SQL

Developer, SmartFTP, WRQ Reflection,

Visual Sleek Edit, X Windows

GUI Forms 6i/9i/10g, Reports 6i/9i/10g,

CERTIFICATIONS

. Introduction to Oracle SQL 9i (1Z0-007)

. Oracle 9i Program with PL/SQL (1Z0-147)

. Brainbench certified Oracle Developer

PROFESSIONAL EXPERIENCE

WELLS FARGO, CA (Oracle developer) Aug

2009 - Mar 2010

Responsibilities:

* Worked on developing the AFS Framework.

* The business process here are embedded in SQL and perl and most of

them do the same functionality so globalize all the SQL's and perl

scripts

* Created Stored Procedures for all the various SQL Scripts already

existing.

* Created a new controlling Stored Procedure is created to call the

above created Stored Procedure containing the individual SQL

Scripts and these Store Procedures and contained in a Global

Package.

* Created shell scripts to call all these Global Created Packages.

* Converting some of the perl scripts into shell scripts.

* Created Shell script to perform NDM (Network Data Mover) which is

converted from perl to shell

* Monitored the Autosys jobs and analyzed the dependencies of the

jobs.

* Created backups for all the database objects and also compared the

volume of data .

* Exclusively worked on query optimization.

* Created FSD (Functional Design Document) SIA (System Interface

Agreement) documents for one of the interface getting data from AFS

Oracle.

* Created Snapshot on the SUIFT interface to pull data from AFS.

Environment : UNIX, Toad 9.1, Clear Case, Oracle 10g, SQL Developer,

Autosys

NATIONWIDE INSURANCE, OH (Oracle Developer)

Oct 2008 - Jul 2009

Responsibilities:

* Worked on developing and maintaining the loans system and also

upgrading various servers.

* Migrated Oracle forms and reports from 6i to 10g and also helped in

upgrading various servers.

* Developed scenarios for Unit testing to ensure that all the

components worked correctly when the applications are migrated.

* Various daily and monthly processing batch scripts are created

using Unix shell scripting to include the new enhancements,

accordingly.

* Modularized the shell scripts already existing pertaining to the

loans system flow and inturn helped in partly re-designing the

existing codes for better efficiency.

* Helped in tracking many test and production servers which support

many applications in the system.

* Gained experience migrating the jobs scheduled through cron to

Maestro the scheduler used in Nationwide for most of the

applications.

* Generated various monthly, daily and quarter-end reports for the

loans system using the SQR scripting.

* Involved in code review before dropping into QA environments and

made changes if necessary according to the suggestion of the team

lead and other team members.

* Involved in documenting users requirements, technical

specifications, testing documents and Reporting manuals.

* Involved in Oncall Production Support and troubleshooting data

quality issues and resolving the Service center tickets in a timely

manner.

Environment: UNIX server, Oracle 10g, TOAD 9.0, PL/SQL, SQR 6.2, Oracle

Forms and Reports 6i/10g, Maestro, Lotus Notes, HP Quality Center, HP

Service Center, Harvest

YALE UNIVERSITY, CT (Lead Developer)

May 2008 - Oct 2008

Responsibilities:

* Yale provides funding to all Graduate Students every semester,

involved in handling two projects one is the GSPS (Graduate Student

Payment System) Cost Transfer and GSPS Commitments.

* In GSPS Cost Transfer this tells us how Yale manages the funding

system and how the funds are being transferred from different

departments to the students account, and my role involved in

identifying which student was funded and from which department and

what is the period of their funding .

* Created SQL scripts, PL/SQL functions, procedures and packages for

user interface.

* The jobs are created to load the data into the GSPS system through

Oracle Financials being the front-end application that was majorly

used.

* Created PL/SQL procedures and functions necessary for validation of

transaction records into interface tables.

* Involved in working with the Datawarehouse team to help them load

and transform data from the GSPS system to the warehouse

environment.

* Developed many reports according the business requirement using

Oracle Reports and also using Brio and also migrated Brio reports

to a later version.

* Created PL/SQL procedures, packages for retrieval of data as per

the business rules.

* Majorly involved in tuning and extracting data from remote systems

using Materialized Views and creating DBLinks.

* Associated with the DBA's in monitoring performance related issues

using Explain Plan, TKProf and SQL Trace Utility.

* Coordinated with clients, involved in gathering requirements and

designing.

Environment: Windows NT server, Oracle 10g, TOAD 9.0, PL/SQL, Brio 7.5

The Great Atlantic and Pacific Tea co. (A&P), NJ

Nov 2007 - Apr 2008 (Application/PL/SQL Developer)

Responsibilities:

* Every week A&P gets it's data in the form of text files from

Pathmark my role here involved in loading the data from the flat

files using the shell scripts that automatically picks up the data

and control files with the assigned load(a sequence generated

number) into the staging tables.

* Gained experience in debugging the forms and fixed some bugs with

the already developed forms and changing some functionality within

the forms according to the business requirement and rules.

* Involved in writing packages and procedures, functions according to

the business requirement process flow.

* Created scripts to create tables, indexes, synonyms, grants, ddl's

as well as involved in doing Table Partitioning and Sub

partitioning on tables to improve the performance.

* Used the Version Control tools like PVCS, Visual Source safe which

helps the multiple users to make simultaneous changes to a

collection of forms and scripts.

* Worked with the team lead in setting up the control +M's for the

batch jobs that are scheduled to run every week (batch processing).

* Worked on the Oracle Forms 6i that were already developed for

fixing the bugs and also changing the functionality of the form

based on the client's requirement.

* Created triggers both at the form and the block level based on the

business requirement.

* Worked with the business and also the users to develop and

customize the Forms and Reports according to their requirement and

for user interface.

* Used PL/SQL tables to avoid mutating of tables problem in database

trigger.

* Experience in writing complex SQL queries including inline queries

and subqueries for faster data retrieval from multiple tables.

Environment: Windows Xp, AIX, Oracle 10g, PL/SQL, SQL * PLUS, PL/SQL

Developer, Toad 9.0.1, Oracle Forms 6i, Oracle Reports 6i

First Casualty Insurance Group Inc., NC (Oracle Developer)

Mar 2007 - Oct 2007

Responsibilities:

* Played a major role in understanding the agent requirements and

providing them with the complete data that was retrieved from the

Data warehouse.

* Loaded data from the flat files into the database tables using the

Toad.

* Worked with tera bytes of database and involved in doing Table

Partitioning and Sub partitioning on tables to improve the

performance

* Created indexes on the tables, for easy retrieval of the good or

the bad data to make data search and retrieval faster.

* Created various procedures and cursors for providing the agents

with the original data that was initially stored as a flat file, by

suspending the incomplete data.

* Extracted data from Flat files, Oracle and SQL sever sources and

transforming it in accordance with the Business logic mentioned by

the client

* Used the Explain Plan. Skilled at task performance evaluation and

methods. Able to create and test different methods to achieve best

possible speed.

* Experience in writing complex SQL queries including inline queries

and subqueries for faster data retrieval from multiple tables.

* Created database Triggers for the security purposes and also for

auditing purposes.

Environment: Windows Xp, Oracle 10g, PL/SQL, SQL * PLUS, PL/SQL Developer

6.0, Toad 9.1, Java, SQL Developer 1.2

UBS Investment Bank, CT (Oracle Developer)

Jan 2006 - Mar2007

Responsibilities:

* Gathered the requirement from different clients and translated user

requirements into data flows, detail technical specifications and

database requirement

* Created stored procedures, packages, generated triggers for

security purposes.

* Extensively used the PL/SQL tables for avoiding the mutation.

* Developed UNIX shell scripts with embedded SQL*Loader, calls and

PL/SQL statements to extract data from the legacy application in

the form of flat files and load the extracted data into the new

application.

* Used DBLinks and Materialized views for accessing the data in the

production system database.

* Worked in coding, debugging, testing and supporting Company's web-

based Reports and Forms.

* Enforced the Integrity using the Integrity Constraints and the

database triggers.

* Involved in Unit Testing by writing the formal procedures around

the software for convenience of the developers to test their own

individual code.

* Performed the data validation using the database triggers.

* Worked with different FTP clients for loading data from the windows

environment to the Solaris environment.

Environment : Sun Solaris 5.9, Oracle 9i, PL/SQL, Oracle Forms 9i, Reports

9i, Windows Xp.

Acquity Brands, GA (Oracle Developer)

Feb 2005 - Nov 2005.

Responsibilities:

* Responsible for requirements analysis, design and development

phases of the system.

* Created stored programs in the form of PL/SQL Packages, Procedures

and Functions returning record sets, which in turn, are used for

developing HTML reports.

* Created Stored Packages for moving the data from the staging area

tables to the Fact and the dimensional tables.

* Created some executable programs running in UNIX operation system

by using PRO*C and C languages.

* Used SQL Loader, for moving data from Flat Files (Fixed Record

Length) to staging area.

* Involved in creating database objects such as tables, views,

synonyms, indexes, sequences and database links as well as custom

packages tailored to business requirements.

* Performed data migration from the SQL server to Oracle using DTS.

* Developed and Tuned SQL, PL/SQL triggers and stored procedures.

* Involved in extensive unit testing, system testing and user

acceptance testing.

Environment: Oracle 9i, SQL, PL/SQL, SQL*PLUS, Windows 98, SQL Server 2000.

Quantros, CA (PL/SQL Developer)

Jan 2004 - Dec 2004

Responsibilities:

* Designed and developed a custom database (Tables, Views, Functions,

Procedures, and Packages).

* Involved in monitoring existing SQL code and tuned if necessary

* Extensively involved in new systems development with Oracle 9i.

* Developed complex transactional screens using developer 2000 and

fine tuned the existing/new front end screens for better

performance

* Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better

performance and also extensive usage of Indexes.

* Read data from flat files and load into Database using SQL*loader.

* Created the External Tables in order to load data from flat files

and PL/SQL scripts for monitoring

* Involved in Unit Testing of newly created PL/SQL blocks of code.

* To conserve the resources used the anonymous blocks within the IF

statements.

* Developed UNIX Shell scripts to automate repetitive database

processes.

Environment: Oracle 9i, Solaris 2.8, PL/SQL, SQL*PLUS, TOAD 8i.

IFLEX Solutions, India (PL/SQL Developer)

Feb 2003 - Dec 2003

Responsibilities:

* Involved in development and testing of oracle back-end objects like

database triggers, stored procedures.

* Used PL/SQL Wrappers for data authentication and security.

* Loaded data from the flat files into the databases using the SQL

Loader.

* Contributed to tuning the SQL queries, create database objects and

optimally set storage parameters for tables and indexes.

* Involved in taking backup and recovery using the tar, gzip and

creating a secured copy using scp

* Received online messages from the defaulters and then querying these

messages and finally generating the reports for these received

messages.

* Involved in Testing and maintenance of various application modules.

* Support from Onsite for implementation.

Environment: Oracle 8i, SQL, PL/SQL, AIX 4.1

EDUCATION

. Bachelor of Engineering- JNTU Hyderabad, India

Name: Jyotsna

Email: ***********@*****.***

Contact this candidate