We provide IT Staff Augmentation Services!

Oracle Consultant Resume Profile

Professional Summary:

  • More than 8 years of analysis, design and development experience in the IT/Finance industry.
  • Developed Interface programs to import data from legacy systems and excellent skills in writing PL/SQL Stored procedures, Functions, Packages and Triggers.
  • Experience in design of Web based Applications, Forms and Reports using Oracle APEX 3.2/4.0/4.2
  • Excellent skills in Application Development using Oracle 8i/9i, 10g, Forms 4.5/6i/9i and Reports 2.5/6i and 10g.
  • Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
  • Strong knowledge in Oracle Cursor management, Exception Handling and also Experience in performance tuning PL/SQL using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the oralcle reports
  • Expertise skills in using the tools TOAD 9.0.1, Sql Loader, Oracle Sql Developer and Oracle utilities like UTL FILE and FNDLOAD.
  • Experience in Perl and UNIX Shell Scripting.
  • Experience in Control-M, Gas Client and DBMS Scheduler to schedule jobs.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Handled Production issues with high pace and efficiency.
  • Extensively used advanced queuing to process the on line jobs.
  • Optimized existing queries for better performance and less impact on database.
  • Used Materialized views in places where the data does not change very frequently.
  • Implemented the business rules in writing Oracle PL/SQL functions and procedures and written Queries to retrieve data in XML format from the tables.
  • Involved in the design of the front end applications forms 6i/9i, Reports 6i/10g and Database objects.
  • Worked On Database Migration from MySQL to Oracle
  • Used REF cursors and Collections, Bulk Collect and Bulk Binding for accessing huge volume of data.
  • Worked with the users to identify the business requirements and integrated them into the front end Applications.
  • A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
  • Technical Skills:
  • Data Base : Oracle 10g/11g, 9i, 8i, 7.x, MS Access ,SQL Server and MySQL.
  • Operating Systems : UNIX, Solaris 10, Perl, Windows 95/98/2000/NT,Mac
  • Data Base Tools : iSQL Plus, Toad 8.5, Oracle Sql Developer, Sql loader
  • Utilities : UTL FILE, exp, imp and data pump.
  • GUI Tools : Oracle Forms 9i, 6i, 4.5 and Reports 10g, 6i, 2.5
  • Languages : SQL, PL/SQL, C, C , JAVA and Shell Scripting
  • Internet Technologies : Java Script, HTML and XML,APEX 3.2,4.0
  • Version Control Tools : IBM Rational Clear Case, Microsoft Visual Studio,Subversion.

Professional Experience:

Confidential

Sr. Oracle Consultant

Responsibilities:

  • Application design and development, System Design, Normalization using Star Schema, Preparing Design Specifications, Development and Database administration.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts, Forced Views/Materialized Views.
  • Developed PL/SQL procedures that extracted data from a data Mart for policy reporting.
  • Used Control M to schedule the daily jobs to be run.
  • Used Essbase Admin to Derive P L for different LOB
  • Used Oracle Apex to design Web pages, Forms and Reports
  • Created BI reports using Oracle APEX
  • Conversion of data from SAS to Oracle to generate Reports.
  • Used APEX to create internal data maintanence tool.
  • Used Sub version for code version control
  • Used Oracle SSO/LDAP Browser to verify the user account information.
  • Used Oracle SOA BPEL for data validation and rules Creation
  • Modify the process control files in Unix to populate the missing data.
  • Involved in developing data conversion programs using SQL Loader, PL/SQL and UNIX shell scripts
  • Developed PL/SQL stored procedures functions using Arrays,REF cursors collections.
  • Extensively used Data Pump Import utility to import objects.
  • Data Transformations using Informatica.
  • Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
  • Involved in writing CTL files control files for SQL Loader to load the policy data from Flat files/SAS in to oracle tables.
  • Performed performance tuning using Auto Trace, Explain Plan, Hints and indexes.
  • Involved in Importing and exporting the Tables, Users and Schemas.
  • Involved in migrating from mainframes to oracle 10g to 11g
  • Worked with CTS/Chase offshore team to monitor Daily project Tasks and project Status

Environment : Oracle 10g/11g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Unix Scripts, HTML and Linux, Control M and LDAP Browser, IBM Rational Clear Case, Essbase Admin, Oracle APEX 3.2, 4.0,4.2.

Confidential

Sr. Oracle Consultant.

Responsibilities:

  • Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design Specifications, Development and Database administration.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
  • Used Gas client to schedule the daily jobs to be run.
  • Created dashboard Reports using Oracle APEX
  • Used LDAP Browser to verify the user account information.
  • Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
  • Modify the process control files in Unix to populate the missing data.
  • Involved in developing data conversion programs using SQL Loader, PL/SQL and UNIX shell scripts
  • Developed PL/SQL stored procedures functions using REF cursors collections.
  • Extensively used Data Pump Import utility to import objects.
  • Used APEX to migrate reports from Oracle Reports to APEX Reports.
  • Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
  • Involved in writing CTL files control files for SQL Loader to load the policy data from Flat files in to oracle tables.
  • Used Informatica to move data from db2 to oracle
  • Performed performance tuning using Auto Trace Explain Plan.
  • Involved in Importing and exporting the Tables, Users and Schemas.
  • Involved in migrating from mainframes to oracle 9i.
  • Interacted with Accenture offshore team for Daily basis to analyze project Tasks and Status

Environment : Oracle 10g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Unix Scripts, HTML and Linux, informatica,Gas client and LDAP Browser, IBM Rational Clear Case.

Confidential

Sr. Oracle Consultant.

Responsibilities:

  • Design and development of APEX application using PL/SQL packages , HTML and JavaScript .
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts
  • Developed PL/SQL stored procedures functions using REF cursors collections.
  • Involved in creating Pseudo code documents for writing stored procedures.
  • Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
  • Involved in writing CTL files control files for SQL Loader to load the policy data from Flat files in to oracle tables.
  • Used Informatica to load data from legacy systems
  • Performed SQL tuning using Explain Plan, Hints and indexes.
  • Involved in Importing and exporting the Tables, Users and Schemas.
  • Used PL/SQL cartridge to select documents from database using htp hypertext procedures and htf hypertext functions
  • Developed web based interface Which supports both reporting and updating functions using Oracle Apex
  • Worked with Accenture offshore team to monitor Daily project Tasks and Status

Environment : Oracle 10g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Perl Scripts, HTML and Linux.

Confidential

Oracle PL/SQL Developer.

Responsibilities:

  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
  • Used Materialized View and refresh Process to Provide data to down stream Application.
  • Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
  • Developed PL/SQL stored procedures functions using REF cursors collections.
  • Involved in creating Pseudo code documents for writing stored procedures.
  • Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
  • Involved in implementing database design by Using ERWIN 7.2
  • Involved in writing CTL files control files for SQL Loader to load the policy data from Flat files in to oracle tables.
  • Performed SQL tuning using Auto Trace,Explain Plan, Hints.
  • Involved in Importing and exporting the Tables, Users and Schemas.
  • Involved in migrating from mainframes to oracle 9i.
  • Designed the queues and their underlying queue table using an object type implementation in order to pass XML messages

Environment : Oracle 10g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Perl Scripts, HTML and Linux.

Confidential

Oracle Consultant.

Responsibilities:

  • Worked within the BA team on existing project modules to identify where improvements need to be made in order to support new requirements and/or more efficiently support existing functionality.
  • Worked On Database Migration from MySQL to Oracle
  • Design the database tables and establish the relationship using Erwin 7.2
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
  • Developed SQL Loader scripts to load data in the Staging tables.
  • Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into stored package that could be invoked from the Forms triggers.
  • Prepared Data Flow Diagrams for existing PL/SQL code.
  • Extensively work with UNIX shell scripting to check financial data, move files to respective revules directories and remove old files and create input touch files and stfp to LGD server and Worked on optimizing existing procedures and functions using PL/SQL.
  • Wrote Procedures and database triggers for the validation of input data and to implement business rules Developed several reports for the Business Users to check the post processing rules.
  • Performed performance tuning using Explain Plan, Hints and indexes.
  • Testing all PL/SQL code for logic correction.
  • Performed Unit testing on queries and reports.
  • Run on the UNIX by writing UNIX shell scripting.
  • Worked with Accenture offshore team for Daily project Tasks and Status

Environment : Oracle 10g SQL, PL/SQL , SQL loader, Toad 9.0.1, Erwin 7.2,MySQL

UNIX, IBM Rational Clear Case.

Confidential

Role : Oracle consultant.

Responsibilities: -

  • Involved in Data Analysis and Requirements gathering.
  • Developed Design Documents.
  • Actively participated through the whole life cycle of the project.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Involved in Database Design. Developed Stored Procedures and Functions.
  • Involved in problem analysis and resolution, troubleshooting, performance tuning and code fixes of various Stored Procedures running in development and production environment.
  • Developed and managed Standard customer reports.
  • Interacted with Business users and developed ad hoc reports in excel using TOAD.
  • Involved in Re-engineering of the interface process.
  • Used Informatica to load data from legacy systems
  • Involved in developing data conversion programs using SQL Loader, PLSQL and UNIX shell scripts.
  • Worked with testing team, analyzed data. Created and formatted ad hoc queries to help testers to test various reports.
  • Developed Perl Shell Scripting for batch process.

Environment : Oracle 9i, SQL, PL/SQL, Sql loader, TOAD and UNIX.

Confidential

Role : Oracle Developer

Responsibilities:

  • Involved in analysis, Design, Development phases of the project.
  • Involved in walkthrough sessions with business users during Analysis and Designing phase Writing PL/SQL Stored Procedures, Functions, Packages to meet the business requirements.
  • Writing SQL Process and scheduling these process from UNIX scripts.
  • Worked on performance issues and used EXPLAIN PLAN for tuning the queries
  • Worked with SQL Loader 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 developing data conversion programs using SQL Loader, PL/SQL and UNIX shell scripts.
  • Developed Master Detail reports in Oracle Reports 6i to meet the requirements of end users within the system.
  • Developed data entry forms, complex and template forms in Oracle Forms 6i.
  • Creation of Pop-up Menus and maintaining Master Detail relation-ship.

Environment : Oracle 9i, Sql Loader, Forms 6i, Reports 6i and Linux

Hire Now