We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql Developer Resume

Dallas, TX

SUMMARY:

  • Over 7+ years of experience in analysis, design, development, and testing of business applications in OLTP, web based Client/Server architectures.
  • Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
  • Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance.
  • Strong Knowledge on oracle architecture and database design.
  • Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.
  • Experience in Database design using Normalization and E/R Diagrams.
  • Extensive experience in database programming using SQL and PL/SQL following industry best practices.
  • Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Strong knowledge in front end development using oracle forms/reports6i/9i/10g.
  • Experience in developing forms based on views, tables and procedures in tabular and form layouts.
  • Experienced in deploying Customizations, Extensions and Personalization's in Standard and Custom Built Oracle Forms, Self Service Pages (OA Pages), workflows, AME, etc.
  • Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Experience in Database modeling and database object definitions using tools like Oracle Designer.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Strong knowledge on OLAP components development.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Experience in writing Technical design documents and developing unit test documents.
  • Supported integration and end user testing with efficient defect management process.
  • Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Strong Analytical, Problem solving and communication skills.
  • Extensively involved in communicating with the onsite users in resolving the issues and contributing my part of technical support to the team.

TECHNICAL SKILLS:

RDBMS/Application Sever: Oracle 11g/10g/9i/8i/, Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager

Languages: SQL, PL/SQL, Unix shell scripting (Bourne shells)

Operating System: Oracle Enterprise Linux, Red hat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows - 2000/NT/98/95, MS-DOS

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACKLanguages and Web Technologies: SQL, PL/SQL, Java, J2EE, Shell Scripting, XML, HTML/XHTML.

Hardware: SUN SPARC E5500, HP9000, IBM RS/6000, Dell Power Edge 6400, Intel x86, P-II/P-III/P-IV

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr Oracle PL/SQL Developer

Responsibilities:

  • Collaborated with the Business analysts and DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in Compass Decommission project to migrate from Sybase to Oracle.
  • Involved in migrating Learning Management data from Sum Total to CornerStone.
  • Developed Stored Procedures, Functions, Triggers, Packages and SQL Scripts using PL/SQL.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed SMTP MAIL procedures for automated email system.
  • 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 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 Procedures for efficient error handling process by capturing errors into user managed tables.
  • Developed reports for error reporting and send the error messages to legacy system owners.
  • Developed batch scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Badging System and invalid data into error tables.
  • Worked on production issues and modify code through code optimizations and indexes.
  • Used SQL Developer and SQL*Plus for creating PL/SQL (trigger, sequence, stored procedure etc).
  • Developed requirement and knowledge Documentation.

Environment: Oracle 9i, 11g, PL/SQL, SQL Developer, SQL*loader, Batch Scripting

Confidential, Columbus, OH

PL/SQL Developer

Responsibilities:

  • Collaborated 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.
  • Maintain the Oracle 11g RAC environment and troubleshoot performance problems.
  • Install & Manage Oracle Application server 11g cluster for Oracle forms & reports for high volume reporting applications.
  • 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 custom forms and reports to correct interface errors and send the error messages to legacy system owners.
  • Converted custom forms using Forms 6i in Installed base for global update of instance.
  • 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 java 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, AUTOTRACE and DBMS SQLTUNE.
  • 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 11g,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML, Sun Solaris 5.6.

Confidential, Lawrence, KS

Oracle Developer

Responsibilities:

  • Involved in the Analysis, Design, Coding and Testing of the application.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created SQL*Loader control files for loading the data from flat files to staging area tables.
  • Developed SQL scripts to create database objects like tables, views and sequences.
  • Used SQL*Loader to load bulk data from various flat files.
  • Developed SQL and PL/ SQL scripts for migration of data between databases.
  • Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
  • Tune SQL statements using hints for maximum efficiency and performance, create 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.
  • Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.
  • Developed complex triggers in reports before/after for validation of user input.
  • Designed and developed user interfaces using Oracle Forms 10g.
  • Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
  • Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
  • Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
  • Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
  • Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
  • Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential, Rochester, MN

Oracle Developer

Responsibilities:

  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
  • Performed exception handling for data that did not conform to the required format.
  • Responsible for making the merged data in turn available to other clients.
  • Wrote UNIX scripts to automate loading files into database using error handling and notification.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Involved in developing packages for implementing business logic through procedures and functions.
  • Developed and modified procedures, functions, triggers, forms, reports and deployed the changes in the system.
  • Developed user interfaces using Oracle Forms.
  • Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
  • Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
  • Responsible for creation of new users and setting up privileges and policies for protection of data.
  • Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential, Baltimore, MD

Oracle PL/SQL Developer

Responsibilities:

  • Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
  • Designed database structures for effective data extraction, validation, run detail notification and error logging.
  • Used and PL/SQL stored procedure for data conversion and interfaces processes.
  • Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
  • Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment. SQL* Loader
  • Used Perl to implement reports and new features in the Web GUI.
  • Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
  • Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
  • Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
  • Involved in fine tuning and optimization of different SQL queries to insure faster response time.
  • Assisted in designing End User Layouts (EUL’s) for Oracle Discoverer Reports based on the user/client requirements.
  • Involved in Unit Testing and Performance Testing for reports.
  • Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
  • Worked as Production Support Developer to solve real time issues.
  • Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 7, Perl, UNIX, shell script, SQL*LOADER, TOAD, SQL*Loader, Toad.

Hire Now