Rajasree K

[pic] ***** Muirfield Dr

Odessa, FL-*3556

Email :

acdm6m@r.postjobfree.com

Phone: 813-***-****

Certification ID - SR2767848

As an ETL developer, Oracle SQL developer and Oracle 9i/10g DBA with over 6

years of IT experience. My main area of experience has been in database

administration, testing, creation of custom reports and ETL. My technological

forte is Oracle (SQL, PL/SQL), Oracle RAC, Oracle Streams, Oracle Data Guard,

Oracle Data Integrator (ODI), Informatica, SQL Server 2005/2008, SSIS/SSRS,

COZYROC, MS Access and Microsoft Office products.

Experience Summary

. Over 8 years of experience as Oracle DBA, PL/SQL and ETL developer in

development and production environments.

. Experience in maintaining Oracle 11g RAC on Linux with ASM

. Experienced in SQL Server/Oracle data migration projects

. Experienced in SSIS ETL software, SSRS and SSAS

. Experienced in COZYROC SSIS plugin software for integrating in

Microsoft CRM

. Experienced in Microsoft CRM, Microsoft CRM API's and, Experian QAS

. Ensured Oracle database systems operate efficiently and securely.

. Managed internal databases, from planning and testing stages through

implementation and support.

. In-depth understanding of security and backup procedures to ensure

database integrity.

. Background in developing backup and disaster recovery.

. Excellent Analytical and problem solving skills.

. Excellent knowledge in SQL*Plus, SQL and PL/SQL programming and

development.

. Experience with Sun/Solaris, RedHat/Fedora Linux, and Windows XP and

Windows 2000 environments.

. Experienced in Informatica PowerCenter 8.1.1, PowerCenter Designer,

PowerCenter Repository Manager, PowerCenter Workflow Manager,

PowerCenter Workflow Monitor

. Experienced in SQL Server and MS Access databases

. Experienced in Oracle Data Integrator (ODI) ETL software, Oracle Data

Quality

. Knowledge in ER Studio Data Architect software.

. Knowledge in Crystal Reports 2008 reporting software.

. Knowledge in Netezza Data Warehouse

Professional Certifications

. Oracle Certified Professional (Oracle 9i)

. Oracle Certified Associate (Oracle 9i)

. Certified Pharmacy Technician

Technical Skills

Below is a list of important hardware, software products, tools and methods

that I have worked with.

Databases:

. Oracle 9i, 10g, 11g, SQL Server 2005/2008 and Microsoft Access

Operating Systems

. Windows 2000, Windows NT/XP, UNIX, Linux

Applications/Tools

. SQL*Loader, SQL*Plus, Filezilla, Toad for Oracle, ODBC, RMAN,

Oracle Enterprise Manager, Oracle Net Configuration Assistant,

Oracle Database Configuration Assistant, Migration Tools, Oracle

Real Application Clusters (RAC), Oracle Streams, Golden Gate

Software

. SQL Server Management Studio, SQL Server configuration tools

Languages

. SQL, PL/SQL, RMAN Scripts, Windows Batch Scripts, Unix Shell

Scripts

ETL Tools

. Oracle Data Integrator 11g - ODI

. SSIS, COZYROC

. Informatica PowerCenter 8.1.1

Reporting Tools

. Crystal Reports 2008, SSRS

Job Schedulers

. Control M, Autosys, Oracle Scheduler and SQL Agent

Data Modelling Tools

. ER Studio, Toad Data Modeller, Erwin

Professional Experience

Hewlett and Packard, Enterprise Services

01/2011- Current

Data Engineer III

As an Oracle Application DBA for Con-Way/Menlo Transportation/Logistics

Project

Client: Con-Way Transportation, Menlo Logistics, Portland, Oregon

Con-way Freight is the premier provider of reliable, regional, inter-

regional and nationwide LTL service to customers large and small across our

integrated, single North American network of LTL operating locations. Menlo

Worldwide Logistics is a leading global provider of a wide range of

logistics, transportation management, freight brokerage and supply chain

services with operations in North America and 20 countries on five

continents.

. Responsible for Maintaining Oracle 11g, Oracle 10g/9i Production, UAT

and DEV data bases.

. Responsible for resolving Service Desk tickets, Work Orders and Change

requests related to PROD, UAT and DEV databases using HP Service

Manager 7 software.

. Creating and maintaining Oracle Database objects and Data Security

. Creating and maintaining Oracle users/roles

. Creating and maintaining Oracle Cron jobs for back up, restore,

gathering statistics, rebuilding indexes and checking invalid Oracle

objects.

. Responsible for Tuning SQL queries

. Responsible for monitoring total of around 350 Oracle PROD/TEST/UAT

databases as a part of Oracle DBA group

. Responsible for Oracle DB migrations, Oracle DB version upgrades,

applying patches data refreshing between PROD and UAT environments,

creating AWR/ADDM reports before and after migrations, compiling

invalid objects, Migration SQL tuning issues, troubleshooting user

grant issues. The bigger database migrated successfully is 8TB,

which is very business critical database for client.

Technologies:

Oracle 11g/10g/9i, Toad for Oracle, HP Service Manager 7, Oracle Enter

Manager (OEM) Grid Control, SQL, PL/SQL, UNIX Shell Scripts.

Hewlett and Packard, Enterprise Services

08/2010 - 12/2010

Data Engineer III

As an Oracle DBA and Talend ETL Developer for NJ-CASS Data Conversion

Project,

. Responsible for Maintaining Oracle 11g Mapping and Conversion

databases

. Responsible for Mapping/Data Conversion database backups and restores

. Creating and maintaining Oracle Database objects and Data Security

. Creating and maintaining Oracle users/roles

. Loading and Refreshing Mapping database structures to make in sync

with Source and Target databases

. Responsible for data mapping between NJ Benefits legacy database and

Curam NJ-CASS database

. Responsible for Tuning data loading queries

. Proactively monitoring Oracle databases and provide solutions in

timely manner for any issues arising

Technologies:

Oracle 11g, Toad for Oracle, SQL Developer, Talend Integration Suit

Enterprise Edition, SVN, Curam Version 6.0 Social Enterprise Management,

SQL, PL/SQL, UNIX Shell Scripts.

Hewlett and Packard, Enterprise Services

04/2009 - 07/2010

Svc Info Developer III

As an ODI and SSIS ETL Senior Developer for Florida ELIS Data Conversion

Project,

. Responsible for data mapping between EFS database and ELIS CRM

database

. Responsible for development of Oracle Data Integrator (ODI)

interfaces, Packages, creating and maintaining data sources using ODI

Topology manager.

. Responsible for creating and maintaining Oracle ODI Repositories for

various environments.

. Responsible for writing Oracle Functions and Packages for supporting

conversion process

. Responsible for performance improvements and trouble shooting for

Oracle Conversion process.

. Responsible for developing SSIS Data Flows, Control Flows and Creating

Packages

. Responsible for creating script components using Microsoft CRM API's

for inserting records into CRM Entities. Worked on COZYROC SSIS

plugin software for integrating Microsoft CRM.

. Responsible for creating script components for invoking Experian QAS

address validation API's to validate various source addresses and

contact information.

. Responsible for creating error and control reports for data conversion

process using Microsoft SSRS.

. Responsible for creating data cleansing SQL scenarios

. Created custom Java Code for comparing data cleansing scenario reports

between two different source data loads.

Responsibilities are creating mapping documents for mapping source and

target databases using custom mapping Excel macros. This project is for

converting VPK program legacy data. It's about converting around 8 years

of data to new ELIS Microsoft CRM system from 40 coalition databases.

Responsibilities also include work with DBA's to creating table structures,

column constraints, Oracle functions and PL/SQL routines. Also responsible

for creating ODI models, interfaces and packages for loading target ELIS

database and reporting tables. Apart from ODI responsibilities, I am also

responsible for mentoring ODI to other team members.

After technology stack changes, started using Microsoft SSIS instead of

Oracle ODI. My responsibilities include writing SSIS Data Flows, Control

Flows, Script components and Control packages.

DataZoomers Consulting Inc, Tampa

01/2008 - 03/2009

ETL Developer and Oracle DBA for development environment

. Responsible for maintaining Oracle 9i, Oracle 10g, 11g development

database.

. Responsible for development of Oracle Data Integrator (ODI)

interfaces, Packages, creating and maintaining data sources using ODI

Topology manager.

. Responsible for creating and maintaining Oracle ODI Repositories for

various environments.

. Responsible for development of SQL Query, PL/SQL package, procedure,

function on Oracle 9i database

. Responsible for performance improvements and trouble shooting for

Oracle 9i development database.

. Responsible for creating Oracle database users.

. Responsible for backup and restore of Oracle database using Oracle 9i

DBCA

. Maintaining Oracle backup and restore RMAN scripts

. Maintaining Oracle Security procedures and methods.

. Implemented 3 node Oracle 11gR2 RAC setup on Linux Servers with ASM &

TAF.

Responsibilities are creating ODI models, interfaces and packages for

loading reporting data warehouse from various data sources, which includes

SQL server and flat files. Implementing data quality operations (ODQ) like

cleansing, formatting and checking various constraints before loading into

final reporting warehouse, loading SCD tables.

Apart from ODI responsibilities, I am also responsible for regular Oracle

DBA activities like maintaining Oracle databases, backup, security, user

administration and restore.

Jewelry4us Inc, Tampa, FL

03/2006 - 12/2007

Oracle Database Administrator

. Responsible for Oracle 9i logical and physical database design,

implementation and maintenance on Windows XP for Inventory Management

and Customer Service applications.

. Responsible for migrating data from SQL Server 2005 to Oracle 9i.

. Created new databases and users: set up backups, export, and other

monitoring scripts using RMAN and user managed.

. Implemented database refresh using full export for table level and

full database de fragmentation, resulting in improved performance and

effective space management.

. Managing database security. Design, develop, and implement automated

data backup and restoration procedures. Provide technical support for

database maintenance and disaster recovery

. Identify, recommend, and implement all new database technologies and

Oracle license management.

MedWin Technologies Inc. Jacksonville, FL

02/2005 to 02/2006

Oracle DBA

The Clinical Correspondence project involves the management of patients

information as per the clinicians requirement and to view their basic

information captured using other products like iPM, iCM etc. Patient List

is used to organize patients based on some criteria, which will be decided

by the clinician who uses the application. Patient Search will retrieve

patients based on the search criteria given. Patient Details is a View,

which shows the demographic information, Care Provider and GP associations

of the patient, and other sensitive information based on the user rights

associated with a particular patient.

. Responsible for writing Oracle 9i SQL's and PL/SQL for Patient List,

Patient Search, Patient Details application. Also responsible for

testing the application.

. Responsible for creating new Oracle databases and maintaining them

. Responsible for RMAN Full/Incremental backup and recovery procedures.

. Responsible for Tuning the Oracle databases.

Education

. Bachelor of Science, Kakatiya University, 1997

. Post Graduate Diploma in Computer Applications, 1998

Work Authorization

. US Citizen

Training

. Oracle 9i, Introduction to SQL's

. Oracle 9i, Oracle Fundamentals I (Architecture)

. Oracle 9i, Backup, Recovery & Networking

. Oracle 9i, Performance & Tuning

. Crystal Reports 2008

. Oracle Data Integrator 10g/11g, Oracle Data Quality ETL software

. DataStage 7.5.2 Designer, Director, Administrator

. Informatica PowerCenter 8.1.1, PowerCenter Designer, PowerCenter

Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow

Monitor

. Netezza Data Warehouse Appliance Usage

Contact this candidate