SUMMARY

• 6+ years of experience in Application development and Production support using Oracle SQL, PL/SQL.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER, FORMS AND REPORTS.
• Extensively worked in Client - Server application development using Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Carried out testing in test database for upgrading/migrating from Oracle 9i to Oracle 10g.
• Experience in developing logical and physical database design, data modeling using Erwin & Informatica (Power Center 6.1).
• Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
• Developed Pro*C programs as required to interface with the existing systems in place.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects.
• Developed and maintained data preparation and validation routines to support data warehousing
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, Hints in Oracle 9i.
• Experience in UNIX Shell Scripting for batch processing.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i

Oracle Tools: SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g), SQL*Plus, Discoverer

ETL Tools: Informatica Power Center 8.6.X/6.1, Data stage

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, C, C++,Java, HTML,XML

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle PL/SQL developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Working on the ETL side of the process to load data into database from different servers.
• Created partitions for parallel processing of data.
• Developed UNIX Shell scripting for job automation and daily backup.
• Involved in performance tuning using with TKPROF.
• Documentation of the business process through Designer.
• Writing backend stored procedures.
• Developed data models for adding new tables and fields to the data warehouse.
• Writing event driven triggers, functions, and packages as needed.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Implementation and end user training.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, Oracle Application Servers, UNIX Server 4.3, Windows NT, SQL*LOADER, and TOAD.

Confidential, Madison, WI

Oracle Developer

Responsibilities:

• Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company’s education system.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Analyze and understand business requirements for enhancements and additions to the datawarehouse.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created complex Stored Procedures and Views to be used for the Reports.

Environment: Oracle 11g/10g, Oracle REPORTS Developer (11g), UNIX Server 4.3, Rational Clear Quest, and TOAD, SQL NAVIGATOR.

Confidential, CA

Oracle Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic\SQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.
• Developed data warehouses to support business decisions
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 10g.
• Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.
• Designed, Developed and Tested application in UAT environment and Deployed in Production.
• Provided Productions supports and ongoing user supports for the application.
• Designed Development Documentation and Support Documentations.
• Used Informatica Data Profiling tools to maintain the quality and consistent classification and identification of the data.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, Informatica 8.6, TOAD, Oracle Application Server 9iand UNIX Scripting.

Confidential, TX

Oracle Programmer/Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions in Oracle 9i.
• Developed PL/SQL package procedures using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Incorporated bulk incremental inserts in PL/SQL procedures.
• Created Database Trigger to audit search events.
• Embedded SQL queries in PL/SQL procedures and ran them dynamically.
• Operated BLOBS, CLOBS and BFILES using PL/SQL (DBMS LOB) packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Developed Java Stored Procedures and loaded Java Classes into Oracle.
• Designed Data Model Diagram using Designer 10g.
• Designed and Developed logical and physical database using Designer 10g.
• Created views, table, sequences, indexes and synonyms database objects.
• Created partitioned tables and indexes.
• Developed UNIX Korn shell scripts to process file feeds.
• Tuned PL/SQL packages to improve performance of the application.
• Created User Interfaces for search functionality using Oracle FORMS 10g.
• Created Menus, Object Libraries, and Properties Classes and integrated in application using Oracle FORMS 10g.
• Integrated Pluggable Java Beans into Oracle FORMS 10g Applications.
• Created and developed REPORTS for financial reporting using Oracle REPORTS 10g.
• Developed Oracle JSP REPORTS and integrated in Oracle Web FORMS.
• Tuned SQL queries using tuning techniques like TKProf.
• Created Designed Documents and technical documents.

Environment: Oracle 9i/RAC, Oracle FORMS 10g, REPORTS 10g, Designer 10g, TOAD,SQL DEVELOPER, UNIX, UNIX SHELL Scripting.

Confidential

Oracle Developer

Responsibilities:

• Planning Backup/Restoration Strategy, Executing UNIX Shell Scripts using jobs, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
• Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Sizing the database for future growth.
• Coding procedures, functions, and triggers and generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Refreshing the test database with the production database.
• Created the database from full export for the Table space point in time recovery.
• Responsible for the creation and testing of hot and cold backup scripts using PL/SQL.
• Created and maintained the UNIX shell scripts to automate common tasks.
• Involved in analysis, design and development of the system.
• Created database objects tables, indexes, views, synonyms
• Created stored procedures, functions, triggers.
• Created of Roles, Users, Table spaces, database triggers, procedures etc.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity constraints on database tables.
• Created FORMS and REPORTS using Visual Basic.
• Testing and debugging
• Involved in preparing documentation and providing user training.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*LOADER/Import/Export Scripts, Erwin, TOAD, Visual Basic 5.0, Crystal Reports.

Confidential

Oracle Programmer

Responsibilities:

• Analyzed database design requests and created databases according to client needs
• Developed PL/ SQL modules such as packages, triggers, procedures and functions.
• Heavily involved in Performance Tuning at the application level.
• Developed reports using Oracle reports
• Developed UNIX Shell scripts that will interact with the PL/ SQL Objects.
• Documented and performed unit testing for all components prior to migrating them to production.
• Maintained existing applications.

Environment: Windows XP, Oracle 9i/10g, UNIX shell scripting, Toad 7.6.0.11, SQL *Plus.