[pic]

SUMA VALLURI

Voice: +805-***-****.

acn5k4@r.postjobfree.com

SUMMARY:

8+ years of experience in the development of client/server and multi tired

applications using Oracle Database, SQL, and PL/SQL on different platforms

like Windows NT/2000/98/95./XP, UNIX.

. Extensive experience in the database analysis, development and

maintenance of business applications using Oracle 11g,10g, 9i, 8i,

PL/SQL Developer.

. Excellent understanding of the software development lifecycle (SDLC).

. Expertise in developing SQL, PL/SQL scripts in oracle distributed

environment.

. Experience in Database design using Normalization and E/R diagrams.

. Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections,

Autonomous transaction, Compound triggers, Materialized Views and

Table Partitioning.

. Worked with data transformations and loading using Export/Import file

packages and SQL* Loader and also created external tables to manage

data which is stored at the operating system.

. Created Instead of triggers for updating join views with DML

operations.

. Created Global temporary tables to maintain session data and improved

the performance of data retrieval and created views, indexes, triggers

on them.

. Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors,

Cursor Variables, Collections, Triggers, Native Dynamic SQL.

. Experience in Data Extraction, Migration Transformation and Error

handling.

. Extensively used oracle tools like TOAD and SQL Navigator.

. Knowledge in Data modeling for Data Warehouse/Data Mart development,

Data Analysis for Online Transaction Processing (OLTP) and Data

Warehousing (OLAP)/Business Intelligence (BI) applications created.

. Experience in Data Migration processing including data loading from

flat files to the database tables using SQL*Loader.

. Experience in OLTP like Oracle, SQL server.

. Expertise in RDBMS development including Oracle SQL, PL/SQL database

backend programming with stored procedures, Functions and packages.

. Experience in writing complex SQL Queries, created materialized views.

. Expert in Export, Import and SQL*Loader Utilities.

. Extensively worked with Informatica - Source Analyzer, Warehouse

Designer, Transformation developer, Mapplet Designer, Mapping

Designer, Workflow Manager, and Workflow Monitor to develop various

complex mappings, Mapplet, reusable transformations, session tasks and

Workflows.

. Experience in data extraction, data migration and Data loading.

. Excellent communication and interpersonal skills, with the ability to

manage responsibilities individually or as part of a team environment.

EDUCATION

Bachelor in Computer Sciences, Osmania University, India.

Masters in Computer Sciences, Osmania University, India.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL*PLUS, Export/Import,

SQL*Loader, Erwin, Epic ER modeler, MySQL.

Languages: SQL, PL/SQL, C, C++, Java, HTML, XML,.net

Tools: TOAD, SQL Navigator, SQL*Plus, SQL Loader, SQL

developer, PL/SQL enterprise edition, SSIS,

Informatica.

Operating systems: Windows XP/NT/2000/98/95,Windows vista, MS DOS,

UNIX, Oracle Enterprise

Office Tools MS Word, Excel, Power Point, Visio, MS dos

Others: Object Oriented Designing Methodology, RDBMS

Concepts

PROFESSIONAL EXPERIENCE

Orange County Social Services Agency, Santa Ana, California

March 2014 - Till Date Sr.Oracle Developer / Sr.PL/SQL Developer.

The Orange County Social Services Agency (SSA) operates under the policy

direction of the Orange County Board of Supervisors and the California

Departments of Social Services and Health Services. SSA is responsible for

planning, implementing, and operating many of the social services programs

provided by the County of Orange. Funding for programs comes from state,

federal, and county sources. Please use this website to learn more about us

and how we may be of service to you.

Responsibilities:

. Developed and Managed Orange County's Social Services Agency's Oracle

11g/10g databases in Development environments, Production and QA.

. Experience in creating new database objects like Procedures,

Functions, Triggers, Indexes and Views in Development and Production

environment in PL/SQL and SQL*Plus database integrity checks and

statistics update through maintenance plans for Orange County's Social

Services Agency's Change Control management System, In-Home Support

Services System and, Differential Response Tracking System.

. Extensively worked on supporting the Orange County's Social Services

Agency's DRTS (Differential Response Tracking System) and SCMS

(Services Communication Management System) databases like developing

the data loading jobs.

. Involved in debugging and Tuning the PL/SQL code, tuning queries,

optimization for the Oracle database for the Orange County's Social

Services Agency's AIM (Assessment Intervention Management), MIDS

(Multi-agency Intervention Data System) and FYI (Foster Youth

Information System) databases.

. Created Database Triggers, bypassing the mutating table errors, use of

row and statement level triggers for advanced auditing of changes made

to a table and Oracle Functions and Procedures to centralize the

business logic in the database.

. Used Hints, Explain Plan, and Indexes for query tuning and

optimizations.

. Pro-actively participated in SQL tuning, Used ANALYZE, DBMS_STATS,

EXPLAIN PLAN, SQL TRACE and TKPROF.

. Created B-tree and Bitmap indexes.

. Wrote packages to fetch complex data from different tables in remote

databases using joins, sub queries

. Used SQL Developer to Load / Extract data into and from Excel files.

Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

. Written cursors and REF Cursors for transaction processing.

. Designed and created appropriate Indexes on tables and materialized

views.

. Involved in the database administration and creating objects such as

database, users, and schema and table spaces.

. Used direct path loading via SQL*Loader/ SQL INSERT statement, create

table as select statements, table spaces, parallelized SQL statement

execution where appropriate tables.

Environment: UNIX, Oracle 11/10g, PL/SQL, SQL* Plus, Oracle SQL Developer,

VI Editor, MS SQL 2008, HTML, Toad, Windows 2000, MS Outlook 2007,MS

Office 2007..

Molina Healthcare, Long Beach, CA

Jan 2013- Feb 2014

Sr.Oracle Developer / Sr.PL/SQL Developer

Molina Healthcare's mission is to provide quality health services to

financially vulnerable families and individuals covered by government

programs. Worked on an application that took care of online account

services which included member enrollment, account summary, billing

history, online payments, updating customer profile, ordering health

insurance ID cards, claims, and subscriber billing. Project was involved in

developing more efficient and quick-time response system for a higher

performance at the users end.

Responsibilities:

. Gathered and analyzed requirements from business analyst.

. Created database objects like tables, synonyms, sequences, triggers, and

views.

. Created, edited procedures and functions for improved business

requirements.

. Used SQL Developer to Load / Extract data into and from Excel files.

. Conducted impact analysis and designed structures to enhance performance.

. Involved in data cleaning, merging and conversion.

. Modified tables, synonyms, sequences, views, stored procedures and

triggers.

. Generated SQL and PL/SQL scripts to create and drop database objects.

. Enforced constraints for data validation.

. Fixed performance issues and bugs with packages and stored procedures

using explain plan.

. Created ETL mechanism to transform the data from OLTP source to the newly

created OLAP model.

. Loaded flat file using as SQL *LOADER into database.

. Used TOAD & SQL Developer for debugging application.

. Written cursors and REF Cursors for transaction processing.

. Designed and Created Database objects and Written PL/SQL PROGRAMMING for

data extraction and transformation.

. Extensively worked with Informatica - Source Analyzer, Warehouse

Designer, Transformation developer, Mapplet Designer, Mapping Designer,

Workflow Manager, and Workflow Monitor to develop various complex

mappings, mapplets, reusable transformations, session tasks and

Workflows.

. Used workflow monitor to monitor the jobs, reviewed session/workflow logs

that were generated for each session to resolve issues, used Informatica

debugger to identify issues in mapping execution.

. Developed RDBMS including PL/SQL database backend programming with stored

procedures, Functions and packages

. Implemented database triggers based on the business rules and

requirements.

. Assisted in Functional Requirement Specification & Use Case Diagrams to

streamlining the business flow.

Environment: UNIX, Oracle 10g/11g, PL/SQL, Sun Solaris 5.8, Toad,

Informatica 8, VI Editor, MS SQL 2005, HTML, MS Visio 2005.

Citi Bank, Houston, Texas

July 2011 -Nov 2012

Oracle PL/SQL Developer

Involved with Mortgage Data Technology. The purpose of the work is to

support their Financing and Accounting application named CLEAR (Corporate

Loan Economics Accounting and Reporting). This software application is used

for the Line of Business, users to record Home Loan related data, all

transactions, daily/monthly basis and also various transactions made on a

regular interval of time, loan repurchase related transactions,

foreclosures, REO, ISeries/AS400 loan records, and various other accounting

and investment transactions.

Responsibilities:

. Analyzed data to check for Data Integrity and Referential Integrity

when loaded to source-staging tables.

. Created tables to capture errors and data that failed Validation

Checks.

. Developed tables with partitions and created indexes, constraints,

triggers, synonyms, database links, table spaces, roles etc in Staging

and Destination schemas.

. Used direct path loading via SQL*Loader/ SQL INSERT statement, create

table as select statements, table spaces, parallelized SQL statement

execution where appropriate tables.

. Developed a package with stored procedures, functions and database

triggers for transferring the date from Source to warehouse.

. Developed dynamic SQL used in procedures and function for the data

extraction and loading process.

. Developed Informatica Mappings using various Transformations and

PL/SQL Packages to extract, transformation and loading of data.

. Created dynamic procedures to drop and create Index for the Staging

environment to facilitate faster loading of data.

. Developed RDBMS including PL/SQL database backend programming with

stored procedures, Functions and packages

. Used Toad Modeler to create the architected

. Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

. Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

. Worked with DBA's in setting up and refreshing the various Test

Environments like DEV, IST and UAT.

. Collected all impacted modules from all developers and prepare the

deployment script for production release.

. Developed Shell scripts to automate execution of SQL scripts to check

incoming data with master tables, insert the valid and invalid data

into error tables.

. Involved in the database administration and creating objects such as

database, users, and schema and table spaces.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell

script, TOAD, UNIX, Windows XP/2000.owb 10g.

Roche Pharmaceuticals Florence, SC

Nov 2010 - June 2011

Oracle PL/SQL Developer

Roche discovers, develops and provides innovative diagnostic and

therapeutic products and services that deliver significant benefits to

patients and healthcare professionals from early detection and prevention

of diseases to diagnosis, treatment and treatment monitoring. Operations

include research and development centers that conduct leading-edge work in

advancing disease detection and treatment. The task of the project was to

maintain historic data warehouse that could support the company's various

reporting and information needs.

Responsibilities:

. Analyzed all business functionality related to back-end database

interfaces and utilized PL/SQL developer tool in developing all back-end

database interfaces.

. Designed the conceptual, logical and physical model according to the

requirements using Erwin.

. Worked on Logical and Physical Data Modeling to gather the business

requirements and convert them into models and design the databases.

. Created new database objects like Procedures, Functions, Triggers,

Indexes and Views in Development and Production environment in PL/SQL and

SQL*Plus.

. Involved in debugging and Tuning the PL/SQL code, tuning queries,

optimization for the Oracle database.

. Review data transformation rules and provide technical suggestions in

data transformation logic and pseudo code (PL/SQL).

. Used UTL file in packages to read/write the data from/to a flat file and

SQL*Loader for migrating flat file data into target.

. Involved in OLTP Process.

. Written various Triggers, Stored Procedures to perform or automate many

of the tasks.

. Optimized SQL queries used in Reports and Stored Programs (Procedures,

Functions and Packages) to improve performance drastically.

. Created Database Triggers, bypassing the mutating table errors, use of

row and statement level triggers for advanced auditing of changes made to

a table and Oracle Functions and Procedures to centralize the business

logic in the database.

. Improved the performance of the application by rewriting the SQL queries.

. Wrote packages to fetch complex data from different tables in remote

databases using joins, sub queries

. Develop the supply chain management application go-live support

environment, construct the transition plan from the project team to the

support team, and support and maintain the client applications and

technology infrastructure

. Monitored the Performance during Beta - Testing phase of the application.

. Performed integrated testing for various mappings. Tested the data and

data integrity among various sources and targets.

Tools and Technologies:

Oracle 10g (PL/SQL),11g, SQL*Loader, MySQL, UNIX, Toad 8, Crystal Reports

XI/8.5 Designer 2000, Windows 2000, Erwin 4.1,MS Excel 2007, Windows 2008

Server.

Owens and Minor, Hyderabad, India

Oct 2007- Sep 2010

Oracle Developer / PL/SQL Developer.

Description: Contract Manage Systems (CMS) is a product to the Health care

Department of Bodh tree Consulting Limited. Analyze the received data as

specified by the O&M and the Data is loaded into client specific work

tables. This data is updated into three different entity contracts,

contract tier and contract item price which are normalized structures

aligning as per client database structures. The Data Acquisition Process in

CMS undergoes in three phases: Extraction, Transformation and loading into

client specified work tables and as per the required format.

Responsibilities:

. Intrinsic Cleansing (Basic Data Cleansing, Removal of Duplicate Items

in Master Data, New Items Appending, Inactive Item Exclusions, Vendor

Name Standardization).

. Data Enrichment (Item Details Enrichment, Modular Item Descriptions,

Item Attributes, Vendor Information Update Vendor Parent/Child

Hierarchy) through PL/SQL stored Procedures, functions, packages, and

triggers.

. Generation of Price Parity Reports for the Hospitals and writing

stored Procedures, functions for the same according to the Client

requirement.

Worked on intermediate and oracle text, calling external Procedures.

. Creation of Database and location of initial data files, redo log

files, control files and multiplexing them editing database

initialization parameter files.

. Creating users, roles, profiles, assigning roles and profiles to

users. Creating table spaces, Data files, Log files and control files.

. Used direct path loading via SQL*Loader/ SQL INSERT statement, CREATE

TABLE AS SELECT statements, table spaces, parallelized SQL statement

execution where appropriate tables.

. Involved in ETL process and evaluated different strategies and

approaches for optimal performance of the process. Automated ETL

loads, Back-up, Recovery

. Involved in development, enhancement and maintenance of PL/SQL

interfaces.

. Have knowledge in supply chain management.

. Provided complete operations services for Supply chain application

management, custom development, and business process outsourcing for

clients.

. Performed SQL and Procedures tuning to maximize performance

. Prepared test data, test cases. Developed and executed test cases

using SQL queries.

. Expertise in deriving test requirements from UML analysis such as use

cases.

. Have performance testing experience and be able to devise strategies

for test automation.

. Involved and interacted with clients for requirements gathering,

tracking requirement changes and building functional test scenarios.

Environment: Oracle 9i, SQL *Plus, Golden, HTML, Windows XP, Benthic

Software, SQL Query Analyzer, SQL*Loader, Microsoft Excel, J2EE, Java,

JavaScript, Manual test process.

Tech Bronx Inc., Hyderabad, India

Aug 2006- Sep 2007

Oracle Developer

Tech Bronx Inc. has the expertise to successfully deliver custom solutions

to address your specific business demands in a timely manner. We offer a

results-based approach to solving problems and maintain a strong commitment

to quality throughout every stage of the development process. It's proven

approach that delivers both mission-critical business and technology

solutions in short time periods.

Responsibilities:

. Developing control files, SQL*Loader scripts, Oracle import and export

scripts for data loading and backup of Oracle data

. Responsible for developing PL/SQL Functions, Procedures, Packages,

Cursors and Triggers

. Worked on tickets to fix the issues reported by the end users

. Optimized the performance using PL/SQL table types and record types

. Involved in designing the data model (logical/physical) by creating

new objects and by using existing objects of the data mart as per the

business requirements

. Developed SQL scripts for Extraction, transformation and Loading of

Data and designed source Entities for Oracle

. Generating software upgrade scripts for cross functional teams

. Heavily involved in writing Test Cases and Unit Analysis and Testing

(UAT) to test each and every logical branch of the stored Procedure.

. Developed Discoverer workbooks and work sheets for reports.

. Involved in trouble shoots Discoverer tool related issues and

limitations in Desktop Version.

. Wrote SQL queries to developed test data for use during test execution

. Worked on complete SDLC(Software Development Life Cycle) including

system analysis, high level design, detailed design, coding and

testing.

. Participated in meetings to gather functional and non-functional

requirements with experts and end-users

. Generated various reports using Reports 6i like loan reports, savings

report, fixed deposits etc

. Analyzed the performance of the SQL queries and created the scripts

for indexes

Environment: Oracle 9i, SQL, Reports 10g, Discoverer 9.i,WINDOWS XP,

SQL,PL/SQL, SQL *Loader, Toad, PL/SQL Developer, Oracle d2k forms and

reports.

Contact this candidate