Developer Sql

Swathi Beeravolu

***** ***** ***** ***, *** # ***, Maple Grove, MN 55369

Ph: 408-***-****

************@*****.***

Objective

A career with an organization offering challenge within a team oriented

environment.Seeking a developer position that gives me an opportunity to

learn and grow. An organization with a strong strategic and business plan

offering a variety of products to their customers.

Summary

2 years of experience as an Oracle Developer

Expertise in Oracle database architecture and design including few

development DBA duties (export, import, data pump, SQL performance and

tuning).

Proficient in developing stored procedures, packages, functions, triggers,

views, materialized views, synonyms, indexes.

Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C,

C++, and UNIX shell scripting.

Extensively worked with third party database tools like TOAD & PL/SQL

Developer.

Extensively worked on course related projects on DBMS and Software

Engineering.

Skills

Operating Systems Windows, UNIX

Languages\Scripting C,C++, PL/SQL, SQL, Shell Programming (Korn and

Bash), HTML

Databases Oracle 7.x, 8, 8i, 9i, 10g,SIEBEL,

MS SQL server, SQL Server7.0,

MS ACCESS, MY SQL

SQL Utilities TKPROF, SQL*Loader, Export, Import, data

pump

Data Modeling Tool Erwin 4.1, Visio2000

SAS Tools SAS Base,SAS SQL

Additional Skills Adobe Acrobat, Microsoft FrontPage,

Microsoft Office, Microsoft

Excel, Microsoft Visual Studio

6.0.

Education

Master of Science, Computer Science, Fairleigh Dickinson University, NJ

Aug 05-May 07

Bachelor of Technology, Computer Science and Information Technology,

Jawaharlal Nehru Technological University, India

Nov 01-May 05

Professional Experience

Clinnovo Research Labs

Jan09-Feb10

Developer(SAS)

. Worked closely with Statisticians and Data Managers

Extensive use of PROC SQL to perform queries and join tables etc.

Created data sets for data storage.

Performed validation on derived data sets following standard operating

procedures during

validation.

Conducted analysis and generated tables, listings and graphs using SAS.

Calculated the statistics of data for different groups of white blood cell

population etc.

Created tabular reports for the statistical analysis.

Client: AT&T

Apr 08-Dec 08

Team: Jackcache

Role: Oracle Developer (Contractor)

Jackcache is a database repository for billing account and subscriber

information. The main objective of Jackcache is to reduce load of high-

volume inquiries from billing systems. A cache that is to be maintained

very close to the biller system so that the inquiries can be solved from

Jackcache and not from biller system there by reducing load on the biller.

Roles and Responsibilities:

Run Audit Reports to check data stale on Jackcache.

Resolve issues when many records are stale on Jackcache.

Communicated with other teams when necessary for getting required data and

information.

Worked with procedures, functions and packages.

Created procedures for moving data into respective history tables once the

process gets done.

Created tables, views on different schema.

Created indexes, hints for tuning SQL statements.

Worked on Analyze and DBMS_STATS for gathering statistics. Also worked on

existing tables for gathering statistics.

Used Database links to work on data on different environments.

Worked with DBMS_SCHEDULER for scheduling jobs.

Worked with Explain plan, SQL Trace.

Worked on UNIX shell scripts.

Scheduled jobs on UNIX using CRON TAB.

Also loaded data from flat files using SQL LOADER.

Tested the code that is written, performed functional and performance

testing.

Environment: Oracle 10g, SQL*Loader, SQL PLUS, PLSQL DEVELOPER, UNIX

Client: BDNA

Nov 07-Mar 08

Project: DVD rewrite

Role: Oracle Developer (Contractor)

The main objective of the project is to rewrite the existing DVD project

which gets data from different modules like customer accounts, e-mails,

offers, orders, shipment and finalizes the process to port the environment

from Informix to oracle.

Roles and Responsibilities:

Communicated effectively with the business analysts to understand the logic

and work accordingly.

Worked effectively with team in comparing the design structures in Informix

and Oracle.

Mapped all the tables in Informix with Oracle and replaced some data fields

from other tables.

Analyzed the Informix code by recompiling it from the respective

directories.

Converted all SQL statements, stored procedures and packages from Informix

to Oracle.

Worked with tables, views and synonyms.

Loaded data from flat files to tables using SQL LOADER

Involved in tuning of SQL statements.

Worked with Explain plan, SQL Trace and TKprof.

Worked extensively with batch processes in finding the embedded Informix

code in them.

Converted the code in batch jobs from Informix to Oracle and provided them

for execution.

Involved in testing. Conducted unit testing on the procedures and packages.

Environment: Oracle 10.2.0.1, 10g, SQL & PL/SQL, SQL Loader, UNIX K-Shell,

Solaris10, Toad, Java.

Course Work

Database Management Systems,Computer Architecture, Computer Networks,

Operating Systems, Software Engineering, UNIX,C,C++,Java, Systems

Programming,Theory of Computation, Design and Analysis of Algorithms,

Programming for Internet, Management Information Systems, Digital Image

Processing.

Contact this candidate