We provide IT Staff Augmentation Services!

Oracle Sql Resume

Irvine, CA


  • Around 7 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports.
  • Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
  • Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
  • Experience in Database design using Normalization and E/R Diagrams.
  • Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
  • Experience in developing External Tables, Joins, Indexes and sequences.
  • Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
  • Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
  • Extreme Use of exception handling methods along with Pragma Exception_init in order to associate our own created exception names.
  • Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, UTL_FILE, and DBMS_SQL to name a few.
  • Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Good knowledge in front end development using oracle forms/reports6i/9i/10g.
  • Experience in creating master detail forms and adding alerts.
  • Experience in deploying forms and reports on the web.
  • Experience in developing forms based on views, tables and procedures in tabular and form layouts.
  • Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
  • Extensively worked with third party database tools like TOAD & PL/SQL Developer.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Good in creating users and maintaining their roles and responsibilities.
  • Experience in writing Technical design documents and developing unit test documents.
  • Experience with coding in Core Java, JSP & Servlets and HTML.
  • Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.


Databases : Oracle 8i/9i/10g/11g, SQL Server, MS Access.
Scripting : SQL, UNIX Shell Scripting and JavaScript.
GUI : Oracle Forms 6i/9i/10g and Reports 6i/9i/10g
Languages : C, C++, PLSQL, HTML, CORE JAVA, UNIX Shell scripting.
Tools : SQL Developer, SQL Navigator, TOAD, SQL plus, PUTTY, WINSCP, TOAD
Applications : MS Office and MS Visio.
Operating Systems : Windows 7, Windows Vista, XP, UNIX, Linux.


  • Bachelors of Technology in Computer Science
  • OCA – Oracle Certified Associate in PL/SQL


Confidential,Irvine, CA Nov 2011- Present
Role: Production Support


  • Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
  • Involved in data modeling team for identifying tables and relations between them.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL
  • Involved in development of interface programs to import parts information to inventory base tables.
  • Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
  • Developed interface for item data conversion to load items from flat file to Oracle

Inventory using SQL* Loader, PL/SQL and import items program.

  • Involved in development of shell scripts to send invoices to customer through mailing.
  • Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report.
  • Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
  • Designed and developed various custom packages triggers and forms.
  • Involved in implementing Order to Cash (O2C) cycle and P2P cycle.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
  • Performed performance tuning using the DBMS_PROFILER package, this checks the run time behavior.
  • Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.
  • Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
  • Involved in integration testing.
  • Debugging and Fixing Production Data.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL, SQL*Loader, Reports, TOAD

Confidential,Pittsburgh, PA Dec 2010 - Sep 2011
Role: Oracle Developer

Description: Confidential,headquartered in Pittsburgh, Pa., is an integrated steel producer with major production operations in the United States, Canada and Central Europe. The system controls the manufacturing process of the company as per defined routes. It generates work orders and maintains its work status. It defines manufacturing plans, product routes and monitors the production for customer orders by generating work orders and shop orders. It provides for modification of existing work orders.


  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in logical modeling and physical modeling of application.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Involved in creation of Conceptual Modeling covering all the business requirements.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Queries, SQL Query tuning process and Schemas.
  • Created SQL*plus reports as per client\'s various needs, and developed business objects.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
  • Developed Master Detail, Detail reports using tabular and Group above reports.
  • Developed Procedures for efficient error handling process by capturing errors into user managed tables.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Created some oracle objects for OLAP.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 10g, Oracle Forms 10g, reports 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), XML, SQL*loader, Stored Procedures/Triggers, Windows NT.

Confidential,East Hanover, NJ Mar 2010 - Nov 2010
Oracle Developer

Project Description: Confidential, is leading pharmaceutical company in the world. Currently they have product portfolio Management includes more than 45 key marketed products in their respective areas,
Novartis Pharmaceuticals Corporation researches, develops manufactures and markets leading innovative prescription drugs used to treat a number of diseases and conditions, including those in the cardiovascular, metabolic, cancer, organ transplantation, central nervous system, respiratory, dermatology and infectious disease areas.


  • Involved in analysis, Design, Development phases of the project.
  • Designed ER diagram using Visio, to set the logical and physical relationships of database.
  • Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Writing SQL reports and scheduling these reports from UNIX scripts.
  • Created SQL*Loader control files for moving the data from flat files to staging area tables.
  • Worked on performance issues and used EXPLAIN PLAN for tuning the queries.
  • Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
  • Involved in the migration project to load data from mainframe systems into oracle database.
  • Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms_output and explain plan.
  • Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.
  • Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
  • Developed data entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
  • Used various LOVS (List of Values) and record groups at various points in runtime.
  • Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL*PLUS, Data Stage (ETL Tool).

Confidential,Atlanta, GA Jun 2009-Feb 2010
Role: Oracle Developer.

Description: Program Cost Application is developed to host the Daily Cable Package purchases. Users will be able to view the daily volume and correct or adjust the records as needed. The validated Data will be exported to a tool for payment calculations.


  • Involved into updating procedures, functions, triggers, and packages based on the change request.
  • Involved in moving the data from flat files to staging area tables using SQL * Loader.
  • Implemented Complex business Logic as per the client requirement.
  • Prepared daily reports from the invoice data received for different department like sales, marketing.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
  • Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Developed Reports to extract the monthly sales information.
  • Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.
  • Performed performance tuning using the DBMS_PROFILER package, this checks the run time behavior.
  • Worked closely with Production Support team to Troubleshoot and fix any production issues.
  • Responsible for code migration of existing application from SQL Database to Oracle Database.
  • 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) program asynchronously.
  • Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
  • Developed Master Detail, Detail reports using tabular and Group above reports.
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL, SQL*Loader, Reports, TOAD.

Confidential,Charlotte, NC JUL 2008- MAY 2009
Oracle Developer

Description: Confidential,data pertaining to the services, customer and locations rendered by Time Warner Cable. Services are categorized based on different Divisions, Regions, Systems, and Channel Lineup Areas. The objective of the Project was to collect data from different customers and replicated the data and the pooled data was modified and used for Reporting.


  • Actively involved in interacting with front end Java developers, and gathered User Requirement and Specifications
  • Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
  • Normalized to 3NF to acquire least data repetition required by business.
  • Migrated old data from Flat Files, Excel File and legacy System into the new database using SSIS.
  • Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
  • Filtered bad data from legacy system using various T-SQL, and implemented constraints and triggers into new system for data consistency.
  • Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
  • Created stored procedures and functions to support efficient data storage and manipulation.
  • Created/ reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
  • Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
  • Used UTL_JOB to automate the plsql procedures and packages.
  • Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
  • Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9i, SQL Server 2000, Windows 2003, UNIX, SQL, PL/SQL, T-SQL, SQL Loader, Visio and SQL Navigator.

Confidential,Hyderabad, India Aug 2006 – May 2008
Oracle Developer

Project Description: Development of Revenue Application. This application supported by the business team to track the business activities including Invoice generation and Payments. This system was developed using Reports, SQL and PL/SQL.


  • Involved in Database Design and Analysis.
  • Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
  • Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.
  • Created Control Files and used SQL* Loader to upload bulk data into database from external files.
  • Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
  • Involved in Code Standardization and Documentation.
  • Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
  • Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
  • Involved in database Performance Tuning and monitoring.
  • Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
  • Developed complex triggers in reports before/after for validation of user input.
  • Coordinated between management, users and technical teams for Requirement Gathering
  • Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Oracle 9i, Oracle 9i, SQL*Plus, SQL, PL/SQL, MS Office, Ms Access, UNIX, Windows XP.

Hire Now