Sql Developer

SWATHI VUPPALA

SUMMARY

Over ** years of experience in Analysis, Design, Development and

implementation of Relational Database (OLTP) and Data Warehousing Systems

(OLAP).

. Proficient in understanding business processes / requirements and

translating them into technical requirements. Communicating with business

customers and End Users in understanding and gathering requirements.

. Extensively worked on relational databases like ORACLE

11.x/10.x/9.x/8.x/7.x, SQL Server 2000/7.0/6.5.

. Experience in developing Conceptual/logical & physical Database design

using Sybase Power Designer and Erwin.

. Expertise in developing ETL Strategies and Data Migration using PL/SQL

. Extensive experience in developing PL/SQL Packages, Procedures Functions,

Cursors and Triggers.

. Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan,

Indexing and Hints.

. Extensively worked on Materialized Views, Table Partitioning, IOT's, and

various oracle built-in packages like UTL_FILE and UTl_SMTP.

. Strong in Database and Data Warehousing concepts.

. Experience in UNIX Shell (Korn, C, BASH) Scripting.

. Extensive experience using Import / Export utilities, SQL Loader and

External tables.

. Designing and executing test plans and performing gap analysis to ensure

that business requirements and functional specifications are tested and

fulfilled.

. Experience working with Business Objects, Microstrategy, Oracle Apex,

Oracle Forms and Reports and Informatica.

. Experience preparing project plans and providing project estimates.

. Experience with DBA activities.

. Providing 24/7 Production Support.

TECHNICAL SKILLS

Operating Systems Windows 95/ NT/ 98 / 2000, DOS, LINUX, UNIX,

HP-UX.

Languages C, C++, VB, SQL, PL/ SQL, Java, J2EE. UNIX shell

scripting, HTML, XML VB Script, Java script.

Databases Oracle 11.x/10.x/9.x/8.x/7.x, SQL Server

2000/7.0/6.5, MS Access 2000/97, DB2 8.0/7.0

Reporting Tools Crystal Reports, Business Objects XI R2,

Microstrategy, Oracle Apex 3.2, Oracle Forms 10g,

9i, 6i, 6.0, Reports 10g, 9i, 6i, 6.0.

Database Tools / SQL*Plus, TOAD, SQL Developer, SQL Navigator,

Utilities Oracle Enterprise Manager, SQL*Loader, import /

Export utilities

ETL Tools Informatica Power Center 7.1/6.2/5.1/4.7, Power

Mart 7.1/6.2/5.1/4.7 (Source Analyzer, Data

warehousing designer, Mapping Designer, Mapplets,

Transformations),

Data Modeling tools Sybase Power Designer 7.1.3, Erwin, Designer 2000.

Version Control VSS 8.0, Clearcase 3.2, PVCS/CVS

EDUCATION

. Masters in Computer Science.

. Bachelors in Computer Applications.

PRODESSIONAL EXPERIENCE

Client : Multiplan, Inc, new York, NY

Jun 12 - Present

Position : Sr. Oracle / ETL Developer

Environment : Oracle 10g/11g, TOAD, SQL*Plus, ERWIN,

Multiplan, Inc is the oldest and the largest supplier of independent

network base healthcare cost management solutions. Multiplan contracts with

doctors, hospitals and outpatient facilities who agree to accept pre-

negotiated rates for their services. These healthcare facilities and

professionals makeup a network. Multiplan sells access to its networks and

the discounted rates for the services to its clients such as insurance

companies and other healthcare entities.

Responsibilities:

. Responsible for automating the data masking process to encrypt

important information that could be used by any system.

. Responsible for creating logical/Physical design using ERWIN.

. Developed Stored Procedures using Oracle PL/SQL packages, procedures,

functions and triggers.

. Responsible for preparing Technical Design documents.

PRODESSIONAL EXPERIENCE

Client : United States Postal Service, Wilkes Barre, PA

Mar 09 - Jun 12

Position : Sr. Oracle / ETL Developer

Environment : Oracle 9i/10g/11g, TOAD, SQL Developer, SQL*Plus, UNIX,

LINUX,

Windows NT, Microstrategy, Oracle Forms 10g, 9i, 6i, 6.0,

Oracle Reports 10g,

9i, 6i, 6.0, Control-M,

Corporate Customer Contact (CCC) maintains and manages customer requests

like pickups, redeliveries, mail holds and facility data across United

States. Various applications write to this system and are accessed by call

center agents to respond to customer inquiries. Case management that was

once a part of CCC has been redesigned and is now serviced by a new

application called eCC that has its own database. RPM is a reporting module

that reports on data in CCC and eCC and is accessed by higher management

for analysis.

Responsibilities:

. Responsible for maintaining and development of new work on three of

the databases at USPS.

. Involved in LINUX migrations for a number of systems, migrating data,

converting jobs from DBMS to contromM, Modifying/changing existing

interfaces to point to the new system.

. Responsible for architecting and developing the interface from the

case management system into the reporting module.

. Responsible for new development efforts on the Transactional and

Reporting databases.

. Responsible for reconciling/Synchronizing data between 4 different

databases.

. Extensively used Materialized Views, Table Partitioning and

Import/Export Utilities.

. Tuning SQL and PL/SQL using Explain plans, Indexes and Hints.

. Developed UNIX shell scripts to run oracle stored procedures via

Control-M.

. Loading flat files using SQL Loader and External tables into the

database.

. Developing various interfaces to the transactional and Reporting

databases.

. Involved in DBA activities.

. Developed Stored Procedures using Oracle PL/SQL packages, procedures,

functions and triggers.

. Responsible for writing test cases for Unit testing the application.

. Wrote shell scripts to schedule tasks for automation via controlM and

for scheduling various data cleansing scripts and loading processes.

. Responsible for preparing Technical Design documents.

. Responsible for preparing project plans and providing estimates.

. Providing production support.

. Responsible for ad-hoc reports on a daily basis for higher management.

Client : Avon Products, Inc. Stamford CT

June 08 - Jan 09

Position : Sr. PL/SQL Developer

Environment : Oracle 9i/10g, TOAD, SQL * Loader, UNIX, Windows NT,

Microstrategy.

Central Master is the central repository for Avon that maintains product

data and provides information to all upstream and downstream systems. All

the product development and maintenance takes place here.

PLS attributing is currently being done manually in excel by the Marketing

Data Cleansing (MDC) in Argentina and respective Marketing groups. The

purpose of this project is to add PLS attributes into Central Master where

the attributes can be maintained and sent to upstream and downstream

systems that reference the product data.

Responsibilities:

. Responsible for analyzing the requirements.

. Responsible for preparing Technical System Design document.

. Developed Stored Procedures using Oracle PL/SQL packages, procedures,

functions and triggers.

. Responsible for writing test cases for Unit testing the application

. Extensively used dynamic SQL and External tables.

. Migrating code from one schema to another.

. Wrote shell scripts to schedule tasks for automation.

. Providing production support for the application.

. Responsible for other ad-hoc reports.

Client : Media Contacts, Boston, MA

Feb 08 - April 08

Position : Sr. Oracle / PL/SQL Developer

Environment : Oracle 9i, TOAD, Business Objects XI Release 2, ERWIN.

Artemis is a proprietary marketing decision support system - a secure

warehouse for all marketing data, plus reporting tool which will help

understand the following

Which creative is most effective at reaching - and converting - desired

audience?

How many impressions are ideally needed to generate a visit to the site?

What are the cross-effects between search and ad campaigns?

How much of the traffic generated by the ads is from returning customers

vs. a new audience?

What string of keywords consumers click on before eventually converting on

your site?

Responsibilities:

. Responsible for modifying existing PL/SQL Procedures, Functions,

triggers and Packages and developing new ones.

. Extensively used various data transformation functions of PL/ SQL.

. Responsible for making decisions on coding standards and

documentation.

. Developed Error Logging and Message Logging to better understand the

performance of the procedures and to associate the errors to the

procedures.

. Migrating Code from one schema to another.

. Creating new reports in Business Objects.

. Documenting the procedures.

. Responsible for writing test cases for Unit testing the procedures.

. Optimized the performance of the SQL queries in procedures with the

help of Explain Plan, Indexes and Hints.

.

Client : Fidelity Investments, Boston, MA

May 07 - Jan 08

Position : PL/SQL Developer

Environment : Oracle 9i, TOAD, Microsoft Visio, Informatica Power Center

7.1.3.

Control-M Enterprise Manager 6.2.01, Power Designer 12.0,

Microsoft Visual

Source Safe 8.0, Clear Quest, UNIX.

OnLine Reference (OLR) provides critical on-the-job information about

Fidelity policies, procedures, products, and services. It is the central

policy repository for FBC. Representatives in FPI, OSG, and FFOS use OLR

every day to answer questions during customer interactions and to guide

their work in key processing tasks. The Goal of this project is to find out

what links are being used the most by the representatives in answering the

customer queries.

Responsibilities

. Involved in complete software development life cycle.

. Involved in Database designing using Sybase Power Designer 12.0.

. Involved in understanding the SRA (System Requirements Analysis)

document for designing the Database.

. Responsible for preparing System Delivery Specifications / Technical

System Design (SDS/TSD) document.

. Extensively used tools like TOAD 9.0, Microsoft Visio 2003, and

Informatica Power Center 7.1.3.

. Successfully ran the batch cycle in Development and QA using

Informatica for loading the fact tables.

. Developed mappings and transformations in Informatica PowerCenter

Designer 7.1.3.

. Scheduled Informatica workflows to run on a daily basis.

. Involved in writing test cases for Unit testing the application.

. Involved in scheduling jobs through UNIX Cron job.

. Wrote shell scripts to run batch jobs and to invoke pl/sql procedures.

. Responsible for writing Install Scripts for migrating the code through

various environments.

. Involved in preparing OpDocs to schedule daily, weekly and monthly

cycles using control-M.

. Developed various PL/SQL Procedures, Functions, triggers and Packages.

. Extensively used Microsoft Visual Source Safe for maintaining the

different versions of the code.

Client : National City, Cleveland, OH

Oct 05 -May 07

Position : PL/SQL Developer

Environment : Oracle 9i, 10g (SQL, PL/SQL), Forms 6i, Reports 6i, TOAD,

Discoverer,

Microsoft Visio 2003, PVCS.

They specialize in originating residential mortgage loans through there

retail, wholesale and telemarketing channels. They are a full-service

mortgage company that originates, acquires, markets and services those

loans. Worked on existing data marts for Current loan information, Tax and

Insurance payment, Transaction History, Updating personal contact

information.

Responsibilities:

. Involved in complete software development life cycle.

. Gathered the business requirements by interacting with users.

. Responsible for making decisions on coding standards and

documentation.

. Extensively developed pl/sql packages with procedures, functions.

. Developed various test cases including stress tests to test the

efficiency and speed of the application.

. Developed procedures to run the SQL*Loader to load data from flat

files into the target database tables.

. Optimized the performance of the application with the help of Explain

Plan for SQL queries.

. Wrote SQL, PL/SQL, stored procedures, views and cursors for

implementing business rules and data transformations.

. Extensively used various data transformation functions of PL/ SQL.

. Widely used the parameters facility in UNIX and PL/ SQL to facilitate

automation of the processes.

. Used Stored Procedures for accessing and retrieving the data from

database to Crystal Reports 9

. Used parameters for filtering data in Crystal Reports 9.

. Exported reports into various formats like XML, PDF, HTML, EXCEL, and

WORD by using Crystal Reports 9

. Used Crystal Repository for reusability of objects.

. Optimizing, and fine-tuning the Crystal Reports for efficiency.

. Participated in the DBA activities like creating users, granting and

revoking privileges on database objects and taking backups.

. Involved in unit testing & user support.

. Involved in integration of the application.

. Involved in 24/7 on call production support.

Client : Plymouth Rock Insurance, Boston, MA

Apr 04 - Sep 05

Position : PL/SQL Developer

Environment : Oracle PL/SQL, SQL Loader, TOAD, UNIX, CVS.

Involved in the backend development of the FNOL (First Notice of Loss),

which is a J2EE/Web/Java based insurance system. It processes auto claims

for glass and other auto related claims. The system is interfaced with the

Policy System for pulling policy information for all auto claims.

Responsibilities:

. Involved in the Data modeling process to create the technical blue

print of the data base.

. Created new tables in the database and associated Shell scripts to

schedule and execute them.

. Wrote SQL scripts including SQL LOADER, SQL procedures, packages,

functions and cursors for special data loads.

. Wrote shell scripts to invoke PL/SQL Scripts.

. Creation of users, roles, indexes etc.

. Wrote database triggers and created log tables for debugging.

. Generation of procedures, which return REF cursors as result sets.

. Scheduled the shell scripts in various environments through the

crontab.

. Performed thorough UNIT and UAT testing with SQL queries to check the

correctness of the code and business rules.

. Performed Data base Code Optimization using Explain Plans.

. Worked with the Java development team for creating class and sequence

diagrams with Rational Rose.

Client : American Originals Corporation, NY

Jun 02 - Mar 04

Project : AOC - SMS

Position : PL/SQL Developer

Environment : Oracle 9i, UNIX, TOAD, SQL*Loader.

AOC - SMS is a support system of IJMS software of AOC, which enables the

sales persons to handle their day-to-day activities in an easier and faster

way. The system loads the software in laptop machines, which are connected

offline to the server. The software allows the authorized sales persons to

enter new customer information, sales transaction details like purchase

orders, invoices, receipts, sp memo out/returns etc., in the local database

and the entered data will be uploaded to central database server by

process. The sales persons can get details of latest modals, stock; price

lists etc., by connecting to central sever. Various reports such as sales

analysis, open order info, commission reconciliation etc., are generated

with various selection criteria.

Responsibilities:

. Extraction of data from different flat files into Oracle Database

using SQL*Loader.

. Developed Stored Procedures using Oracle PL/SQL packages, procedures,

fucntions.

. Gather Business rules from the end users that are to be incorporated

into the system.

. Changed existing logic within the packages for optimum Performance.

. Tested the original and optimized codes thoroughly for failures before

exporting to other environments.

. Created Test Specification & Test Servers to simulate voluminous

transactions.

. Generate scripts for testing the output and making available data for

testing using Unix.

. Used Korn Shell scripts to automate Oracle script execution.

. Involved in regular User Managed Hot and Cold physical database

backups.

. Created Shell Scripts for Regular backup, instance start, shutdown

. Involved in successfully upgrading from Oracle 8i to 9i.

. Used ADO, ODBC for accessing and retrieving the data from database to

Crystal Reports 8

. Used parameters for filtering data in Crystal Reports 8

. Optimizing, and fine-tuning the Crystal Reports for efficiency.

. Creating and Maintaining of different levels of users with different

levels of securities by creating User Roles and Privileges.

. Tuned SQL by using Explain Plan, Indexing and Hints.

References available upon request.

Contact this candidate