Sql Oracle
Resume:
Manasa
*********@*****.***
Summary
. Over 6 years of experience in designing, developing and implementing
database applications and solutions as Oracle SQL, PL/SQL Developer.
. Experience in interacting with Business/Technology groups and analyzing
business needs.
. Worked in various levels of SDLC which involves Analysis, Design,
Development, Testing, Implementation and support with extensive exposure
in database.
. Expertise in development of database objects like tables, indexes,
sequences, views, clusters and synonyms.
. Worked extensively on PL/SQL stored procedures, packages, Functions and
Triggers using the latest features to optimize performance to retrieve,
manipulate and migrate complex data sets in Oracle Databases.
. Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD
for faster application development.
. Expert in Tuning Queries for better performance to achieve maximum speed,
minimum cost using Explain Plan.
. Experience in Performance Tuning & Optimization of SQL statements.
. Tuned complex Stored Procedures for faster execution and Developed
database structures, according to the requirements in Oracle data
warehousing.
. Good knowledge on working with DBLinks and also creating materialized
views like Read Only, Updatable, and Writeable.
. Proficient in advance features of Oracle 9i for PL/SQL programming like
using cursor variables, Ref. cursors, varrays, nested tables and Dynamic
SQL.
. Knowledge of DBMS_JOBS, DBMS_PROFILER, DBMS_STATS, DBMS_SCHEDULER,
UTL_FILE packages.
. Experience with writing SQL queries for data validation and data
integrity testing.
. Good knowledge on Exception Handling extensively for the ease of
debugging and displaying the error messages in the application.
. Hands on experience with the development and customization of Forms
6i/10g and Reports 6i/10g
. Developed PL/SQL scripts for Data cleansing
. Experience in working and scripting knowledge of UNIX shell scripts.
. Experience in Design, Creating and maintaining the Oracle Database.
. Skilled in logical and physical database design.
. Good knowledge on version control tools like VSS, PVCS, SVN which helps
multiple users to access the source code of the PL/SQL programs.
. Wrote DDL Scripts to create new database objects like tables, views,
synonyms and indexes.
. Involved in Technical Documentation, Unit test, Integration test and
writing the Test plan.
. Good Knowledge in RDBMS concepts and worked extensively on Oracle
databases like Oracle 8i/9i/10g.
. Excellent problem solving, analytical, written and communication skills
with ability to work both in team as well as an individual.
. Interest in learning new technologies.
Technical Skills:
OS Windows 95/98/NT/2000/XP, UNIX, Sun Solaris, MS-DOS
Languages SQL, PL/SQL, UNIX Shell Scripting, ABAP and HTML
Tools TOAD, SQL*Plus, Oracle Reports 6i/10g, Oracle Forms
6i/10g, SQL Loader, SQL Navigator, Oracle 10g
Designer, PL/SQL Developer
DATABASE Oracle 10g/9i/8i/8.x/7.x, PL/SQL, MS-Access
Version Control VSS, PVCS, SVN
Systems
Others MS Office
Herbalife, Torrance, CA
Mar 09 - Till Date
Oracle PL/SQL Developer
Herbalife International is one of the largest nutrition, skin care and
weight loss companies in the world with its products in 72 countries. It is
a global network marketing company that offers a range of science-based
health and wellness products including nutritional shakes and snacks,
energy and fitness supplements, and personal care products that focus on
all of your nutritional needs. As a Developer, my responsibilities include
technical designing of custom solutions based on the business requirements,
code optimization and Interface Development.
Responsibilities:
. Involved in SDLC including analyzing, designing, coding and testing.
. Created various SQL and PL/SQL scripts for data manipulation and
validation
. Created database objects like tables, views, procedures, functions,
packages using Oracle tools SQL* Plus and TOAD according to the
client's requirement.
. Created Procedures in PL/SQL to check the data validations for large
number of files that are to be loaded into the system on daily basis
to perform routine checks.
. Created Materialized Views and extensively used Varrays, PL/SQL
tables, Cursors, user defined object types and Exception handling.
. Worked on performance tuning using Explain Plan, TKprof and SQL trace
for tuning the queries.
. Created Indexes and sequences for faster retrieval of the customer
information and enhance the database performance.
. Migrated data from flat files into oracle database tables using SQL *
Loader.
. Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the
code portable to any platform.
. Extensively used TOAD for database access, PL/SQL Development and SQL
tuning.
. Created physical and logical databases instances with the team.
. Used version control PVCS which can automatically make copies of work
on a drive or machine other than your development drive.
. Worked with Bulk Collects to improve the performance of multi-row
queries by reducing the context switching.
. Involved in loading the data loads coming from flat files into staging
tables in the Oracle Data base using SQL* Loader and Korn shell
scripts.
. Used the pragma Exception_Init to name the system exceptions that are
raised by the program.
. Involved in Analysis, design and development of Forms and reports.
. Involved in customizing some standard reports with the user
specifications using Oracle Reports 6i/10g.
. Worked on forms that were already developed for fixing the bugs and
also involved in changing the functionality of the forms based on the
client's requirement.
. Provided first level responses to issues.
Environment: Oracle 10g, SQL*Plus, Oracle Reports 6i/10g, Oracle Forms
6i/10g, Sun Solaris, TOAD, SQL
Navigator, PVCS, UNIX, PUTTY, Windows XP/2000/NT.
Capital One Financials, Richmond, VA
Jan 08 - Feb09 Oracle
PL/SQL Developer
Capital One provides millions of customers with financial resources to meet
and manage the credit needs and to achieve the financial goals. This
financial services industry is one of the largest, fastest growing, most
fragmented industries in the world. I was involved in the of development of
Small Business lending (SBL) application using Configure Work Station (CWS)
tool broadly known as CAPSTONE in Capital One, changes to the existing code
or runtime problems at client site. Capstone is a credit decision engine
for customers who apply for credit card from capital one. It handles both
real time and batch credit decision. The real time decision is taken in 60
seconds which does the credit check with different credit bureaus and
address verification within 60 seconds.
Responsibilities:
. Migrated the data from Excel sheets, text files into the respective
Oracle Database tables using SQL *Loader
. Created and managed primary data base objects such as Tables, Views,
Indexes, and Synonyms.
. Involved in database development by creating Oracle PL/SQL Functions,
Procedures, Triggers, and Packages.
. Worked with different types of sub queries (Inline, correlated) for
retrieval of data from multiple tables.
. Created database links to retrieve data from multiple servers.
. Extensively used FORALL and BULK COLLECT to fetch large volumes of
data from table.
. Create and run Batch files on regular basis.
. Created and Scheduled Jobs from time to time.
. Created Records, Collections (Nested Tables and Varrays) for improving
performance by reducing context switching.
. Involved in customizing reports using Oracle Reports 6i builder as per
the user requirements.
. Development of new customizations and enhancements to existing forms.
. Extensively used Explain Plan, TKPROF for SQL query optimization.
. Used PL/SQL tables, PRAGMA AUTONOMUOS_TRANSACTION to avoid mutating
problem in database trigger.
. Worked extensively on exception handling to trouble-shoot PL/SQL code.
. Participated in code reviews of other team members.
. Involved in Technical Documentation, Unit testing, Integration testing
and writing test plans.
. Involved in documenting the specifications, bugs fixing logs & change
requests for future reference.
Environment: Oracle 10g, SQL, PL/SQL, Oracle Reports 6i/10g, Oracle Forms
6i/10g, PL/SQL Developer, SQL*Plus, TOAD, UNIX, PUTTY, VSS, Windows XP
Cisco Systems Inc, San Jose, CA
Aug 06 - Dec 07
PL/SQL Developer
Cisco enables people to make powerful connections-whether in business,
education or creativity. Cisco hardware, software, and service offerings
are used to create the Internet solutions that make networks possible-
providing easy access to information anywhere, at any time. Cisco has been
leaders in the development of Internet Protocol (IP)-based networking
technologies. Developed an expense tracking system for financial decision
making, managing budget, predicting the cost of continuing operations,
forecasting etc. The system tracks the money flow and stops overspending
for any project.
Responsibilities:
. Database Design based on user requirements.
. Developed comprehensive sizing projections, based on user
requirements, incorporated some table design changes and specified
Referential Integrity rules to be incorporated into the database
. Involved in the creation of database objects like tables, views,
stored procedures, functions, packages, DB triggers, Indexes and
Collections.
. Generated server side PL/SQL scripts for data manipulation, validation
and materialized views for remote instances.
. Fine Tuned various packages and procedures in PL/SQL for the maximum
. Created and used Table Partitions to further improve the performance
while using tables containing large number of columns and rows.
. Worked on production support, received production calls from clients.
. Involved in writing UNIX Shell scripts to schedule the jobs to move
the legacy data to the standard tables.
. Worked on SQL*LOADER to load data from flat files obtained from
various facilities every day.
. Used external tables to manipulate data obtained daily before loading
them into the tables.
. Analyzed and Optimized the SQL statements using 'Explain plan' and
'Tkprof'.
. Used Dynamic SQL for generating various stored procedures whose
queries are not known until the runtime using the REF CURSOR.
. Performed technical assessment, coding activity requests for changes
and enhancements to existing Forms and Reports.
. Involved in creation and Customization of Forms through Oracle Form
Builder 6i templates
. Involved in writing technical user documents for future enhancement of
the product.
Environment: Oracle 10g, SQL*Plus, PL/SQL, Oracle Reports 6i, Oracle forms
6i, SQL *Loader, Toad, UNIX shell scripting and Windows.
Kendle, Cincinnati, OH
Mar 05 - Jul 06
Oracle developer
Kendle is a leading global clinical research organization providing the
full range of early to late stage clinical development services for the
world's biopharmaceutical industry. The company focuses on innovative
solutions that reduce cycle times for their customers and accelerate the
delivery of life-enhancing drugs to market for the benefit of patients
worldwide. My role in this project is to develop the code for the Trial
Watch application according to the user's requirement.
Responsibilities:
. Written specification documents for new applications according to the
users requirements.
. Developed Packages, Procedures, and Functions for the front end
enhancements of Application.
. Created database objects tables, views, triggers, public Synonyms
according to the requirements.
. Created constraints on the tables for data validations and for
maintaining the clear data without any issues.
. Created Indexes on the tables for the faster data retrieval to improve
the query performance.
. Created DBlinks for connecting to remote databases located in UK,
CANADA for data exchange and accessing remote tables, views.
. Created shell scripts to run the database scripts on the server.
. Involved in writing backend validation scripts for the Application.
. Used many database Utilities like UTL_FILE, UTL_MAIL, DBMS_JOB.
. Used Dynamic sql in developing the scripts.
. Used Collections, Record types to fetch large amount of data with less
contact switching from the database.
. Used version control tool VSS to keep the latest version of the code
developed at one place, which helps multiple users to access and make
changes to the collection of source code files.
. Involved in validating the objects participating in replication of
database by writing test scripts.
. Created build scripts for deploying new objects in the database.
Environment: Oracle 9i, SQL*Plus, TOAD, UNIX, PUTTY, VSS 6.0, Windows.
UTI Bank, Mumbai, India
Jun 04 - Feb 05
Oracle Developer
UTI Bank opened its doors in 1994 after India issued licenses to private
banks. The bank offers a full range of services in retail, corporate and
international banking, treasury management, and merchant and investment
banking.
Responsibilities:
. Extensively involved in Writing PL/SQL Stored Procedures, Functions
and Packages to meet the business requirements.
. Developed PL /SQL code for updating payment terms.
. Created synonyms on the database objects for easy reuse.
. Optimized and enhanced the existing procedures and SQL statements for
the better performance.
. Developed SQL * loader scripts to validate the data before
loading data into the database tables.
. Developed UNIX shell scripts to automate and run the programs on
regular basis.
. Involved in Testing and maintenance of various application modules.
. Modified existing codes PL/SQL packages to perform Certain Specialized
functions and enhancements.
. Developed user interactive screens using Oracle Forms Builder.
. Involved in building reports using Oracle Reports Builder.
Environment: Oracle 8i, PL/SQL, Windows 2000/XP, UNIX.
Polaris Software Lab, Chennai, India
Aug 03 -
May 04
Oracle Developer
Polaris Software Ltd is one of India's leading institutions contributing to
the global financial services marketplace. The company offers state-of-the-
art, comprehensive solutions for core banking, corporate banking, wealth &
asset management and insurance. Polaris has been awarded the Leader in the
category of "Specialty Application Development" among the Top 100 global
Companies.
Responsibilities:
. Involved in getting the User Requirements, Data Modeling & Development of
the system.
. Involved in designing the Primary & Foreign Key for the objects in the
schema.
. Created Triggers, Procedures, Functions, Packages to provide
backend security and data consistency.
. Created database objects such as tables, views, synonyms, indexes,
sequences and database links
. Used Toad to Extract and test the data in the database
. Responsible to maintain the dependencies of all Procedures,
Function, Packages, Views and Triggers.
. Implemented complex business rules with the use of integrity
constraints and Database Triggers.
. Extensively used complex SQL queries ( Sub-queries and
correlated sub queries)
. Involved in writing crisp and precise technical documentation.
Environment: Oracle8i, SQL, SQL*Plus, PL/SQL, TOAD, Windows XP/NT, UNIX
Contact this candidate