Sql Data
Resume:
[pic]
SUMA VALLURI
Voice: +805-***-****.
****.*********@*****.***
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