We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Tulsa, OK

SUMMARY:

  • Solid technical experience of 8 + years in full software life cycle using Database tools for industries including Oracle design, development, Modeler, testing and implementation of various software projects, applications and database management systems in a variety of environments.
  • Highly experienced in Planning, Analysis, Design, Development, Testing, and Deployment in a demanding and challenging environment.
  • Experience working with relational databases Oracle, MySQL Experienced in UNIX Shell
  • Expert in Oracle backend developer includes PL/SQL, SQL, Performance Tuning Analyst and Database Administrator.
  • Experienced in creating Stored Procedures, Packages Database Triggers, Functions, Views, Synonyms, Indexes, Materialized Views, Complex queries.
  • Resolving complex performance issues, Performance monitoring and SQL Tuning.
  • Good experience in executing Database Administrator jobs like Database creation, Upgradation, Backups, Restore, Recovery and User security.
  • Experience in Data migration Projects.
  • Experience working on MySQL Server Installations, Databases, Backups, Restore, Replication and Administrative activities.
  • Worked on PostgreSQL databases administrative activities.
  • Experience on Redshift & AWS - RDS admin activities.
  • Experience using ERdiagram, Dimensional datamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and designs techniques.
  • Decisive, energetic, focused team leader / player who lead high-performing teams through execution under the pressure of fast-paced, time-sensitive environments.
  • Experience in developing new components in an AGILE environment.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, Unix shell scripting, Java Script, Core Java, HTML, Oracle Forms, Reports

Database: Oracle 8i /9i /10g /11g/12c, MS-Access, Sybase, MySQL, PostgreSQL, Redshift & AWS-RDS

Database Tools: TOAD, SQL Developer, SQL *Loader

Source Control: Clear Case, Git

Others: SQL Loader, SQL * Plus, Toad, SQL Developer, SQL DBX, eclipse

WORK EXPERIENCE:

Confidential, Tulsa, OK

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of Data Migration.
  • Developed Complex queries on Database and developed PL/SQL Procedures to extract data from multiple tables
  • Responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of New Loans.
  • Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATEMENT, REGEXP REPLACE, REGEXP SUBSTR.
  • Tuning Complex queries by converting derived tables to Common Table expressions (CTE) which will enhance query throughput.
  • Tuning sql queries to enable Database process huge set of migrated Loans into NSM.
  • Development, Testing of Java Code to meet business requirement and to resolve issues.
  • Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.
  • Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.
  • Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
  • Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.
  • Involved in the analysis, design, and development and testing phases of Software Development Lifecycle ( SDLC ).
  • Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.
  • Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions
  • Have hands on experience in Data migration, Analysis, Validations and Reconciliation.

Environment: Oracle 12c , SQL Developer tool, SUN Sparc 5.10, Java,UNIX

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

  • Written Batch Program, SQL queries, stored procedures, functions and triggers using Oracle DB
  • Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
  • Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.
  • Developed Complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
  • Have hands on experience in Data migration, Analysis, Validations and Reconciliation.
  • Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.
  • Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.
  • Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT .
  • Wrote UNIX shell scripts for automated installations, to extract logs using Bash
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Scheduled the Jobs for loading data using DBMS SCHEDULER.
  • Job monitoring and doing Reconciliation process for failed jobs.
  • Experience with Data flowdiagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • As Architect, responsible to design 20 plus aggregates using tables and migrate the corresponding logic from the present DB's stored procedures.
  • Experience in OLTP, OLAP / Data Warehouse and Data Mart. Enhance and maintain the data warehouse that powers reporting and analytics.
  • Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.
  • Primarily responsible for support and management of 400+ customized application embedded SQLreports, validation of DB schema changes and Version to Version data accuracy.
  • Involved in the analysis, design, and development and testing phases of Software Development Lifecycle ( SDLC ).
  • Experience using ERdiagram, Dimensional data modeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Environment: Oracle 11g /12c, SQL Developer tool, SUN Sparc 5.10

Confidential

Senior Application Engineer

Responsibilities:

  • Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from databases.
  • Development stored procedures, functions, packages and triggers to implement business rules into the application.
  • End to end implementation of product enhancements and fixing production defects.
  • Meetings with end customers to understand their requirements and providing solutions for their issues by user trainings.
  • Collaboration with QA teams for code fixes before moving the code to production.
  • Prepared functional and technical design documents.
  • Responsible for following up on bugs reported by users and suggested possible patches.
  • Worked on various processes of Order Management like order import, process order API, sales order UI, defaulting etc.,
  • Resolutions to customer issues in various areas of order management and order to cash cycle.

Environment: Oracle PLSQL, SQL loader, Oracle forms and reports, toad, SQL developer, Oracle applications, Unix

Confidential

Technical Consultant

Responsibilities:

  • Pulled data from multiple sources using Informatica and transformed it into consistent format before loading into Confidential ’s databases.
  • Scheduled Informatica workflows on Autosys to run mappings and move the extract files to our servers before further processing.
  • Created packages to fetch data from remote database tables using joins, sub-queries and data base links.
  • Analysed, optimized the code and fully tested the product with high volumes of data.
  • Created complex PL/SQL scripts and did extensive database tuning.
  • Filling gaps between required functionality and existing code.
  • Developed batch scripts, scheduled them in windows scheduler to automate them.
  • Prepared technical design documents, unit test cases.
  • Wrote shell scripts for data loading and DDL scripts.
  • Bug fixing and trouble shooting.
  • Developing batch scripts for silent installation of product.
  • Modified SQL and batch scripts.
  • Installation of Product suits.
  • Data setup for testing the product.
  • Preparing Unit test cases and testing the product.
  • Understanding the requirements for Confidential Transport v742
  • Preparing business requirement document and functional requirement document.
  • Involved in daily calls for more understanding.
  • Developed the SQL script and integrated with PERL.
  • Involved in end to end testing of the script.

Environment: Informatica, Oracle PLSQL, Toad, Autosys, batch scripting, SQL Loader, Unix shell scripting

Confidential

Project Engineer

Responsibilities:

  • Requirement gathering for new modules.
  • Preparing business requirement document and functional requirement document.
  • Created database objects like tables, views, sequences, stored procedures, functions, packages, cursor, ref cursor and triggers.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Developing actuate reports and testing them.
  • Preparing Unit Test Cases.
  • Analyse and discuss the business requirements with the clients.
  • Analysing issues and getting required clarification from the user.
  • Optimized and modified the triggers, complex stored procedures, function etc.
  • Responsible for the dealing with the problems, bug fixing and troubleshooting.
  • Preparing release notes for the fixed bugs
  • Doing enhancements as per the user requirement.
  • Involved in requirement gathering for some applications.
  • Monitored and provided front-line support of daily processes.
  • Enhancement and bug fixing stored procedures.
  • Developed excel reports eSpreadSheet.
  • Prepared unit test cases and tested PLSQL procedures.

Environment: Oracle SQL/PLSQL, SQL DBX, Actuate eRDPRO 9 PLSQL, Toad, Oracle 10g, Actuate eRDPRO(8,9), eSpreadSheet(8,9), Autosys JILs scheduling, Eclipse 3.2. SQL Developer, Actuate, Autosys JILs scheduling.

Hire Now