We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

3.00/5 (Submit Your Rating)

Monroeville, PA

SUMMARY

  • Oracle Certified Associate (OCA) with 10+ Years of IT experience as an Oracle Developer on a variety of UNIX (Solaris, Linux), Windows platforms with Oracle 8i/9i/10g/11g/12c.
  • Strong noledge in all phases of Software Development Life Cycle (SDLC).
  • Strong noledge of Relational Database Management System (RDBMS).
  • Strong noledge on Database Lifecycle (DBLC).
  • Good Expertise in Oracle Server Architecture and basic DBA functionalities.
  • Strong expertise in agile software development methodology.
  • Strong noledge in exporting and importing data to and from a database using the Expdp/Impdp utilityin Oracle 10g/11g/12c and Exp/Imp utility in Oracle 9i.
  • Data loading from heterogeneous databases and flat files into Oracle database using SQL*LOADER, External tables.
  • Strong noledge in writing PL/SQL Scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes, function - based index and sequences.
  • Experience in trapping, raising and handling errors using Exceptions.
  • Knowledge of using sql utility to connect and extract data from SQL server 2005 database.
  • Knowledge on writing Transact SQL scripts to query the SQL Server 2005 database, implementing Transact SQL Procedures to enforce business logic.
  • Knowledge of creating and using Cursors and REF Cursors.
  • Knowledgeon Performance Tuning by creating Indexes, executing EXPLAIN PLAN on SQL Scripts.
  • Strong noledge in creating and using Public Synonyms, DB Links and Global Temporary tables.
  • Expertise in creating Materialized Views in data warehousing environment, working noledge of Nested tables, PL/SQL tables.
  • Involved in designing numerousOracle Formswhich include master detail forms, customizedformsand Reports by interacting directly with End Users and Business Analyst.
  • Proficient in SQL, PL/SQL, Query/application tuning using Optimizer hints, Explain plan, SQL trace, TKPROF and dbms profiler.
  • Oracledesign/coding/integration in SQL, PL/SQL.
  • Good Knowledge on Electronic data interchange.
  • Good Knowledge in applications in PL/SQL, developing applications inOracle FormsandOracle reports.
  • Experience in working with different databases like Postgre, Teradata, MSSQL Server 2008 R2, Oracle 11g/12c/10g/9i/8i and tools like Toad, SQL Navigator.
  • Working experience in Creating Formsbased on tables, views and procedures in tabular andFormlayouts.
  • Expertise in using GITHUB, for code check in, check out and maintenance of the repository.
  • Experience in using SVN, Version One for project tracking, teams planning and reviewing and commenting the code base.
  • Involved in reviewof Functional Requirement documents and creation of Technical Design documents and related Test Case documents.

TECHNICAL SKILLS

Operating Systems: DOS, Windows XP/NT, UNIX, OS X.

Languages: SQL, PLSQL, C.

Scripting Languages: jQuery,UNIX,Shell Scripting.

GUI’s Technologies: Oracle Forms/ Reports DS10g/DS9i/6i, Crystal Reports 9/10.

Databases: Oracle8i/9i/10g/11g/12c, SQL server 2005, Oracle XML DB, MS Access.

Products/Packages: MS Office Products.

Utilities: SQL* Plus, SQL* Loader, Toad, Postgre, SQL Navigator.

PROFESSIONAL EXPERIENCE:

Oracle PL/SQL Developer

Confidential

Environment: UNIX, Oracle11g/12c, SQL*Plus, SQL*Loader, Microsoft Excel,TOAD, PL/SQL, SQL*Loader, SQL SERVER,JIRA, Subversion (SVN), GitHub.

Responsibilities:

  • Worked on the bulk uploading of huge amounts of statistical data to the database.
  • Wrote Loader scripts using SQL Loader/External tables to load large tables.
  • Worked on IDR (RIO) Application and use to create tables, views and worked on loaders.
  • RIO (Reinventing Investment Operations) use to get data from BNYM daily for core tables and landing tables and if we get any defects, we use to work on those and resolve them.
  • Use tosupport for IDR application (Investment Data Repository) in developing PL/SQL Procedures, Functions, Cursors, Package views and Materialized views.
  • Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
  • Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
  • Documents all technical and system specifications documents for all ETL processes,Postgre and perform unit tests on all processes and prepare required programs and scripts.
  • Worked ontool produced byOracledat offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
  • Integrate XML and other types of programming into databases and applications.
  • Proficient in writing stored Procedures in and converting cursor-based PL/SQL procs into set based sql procs.
  • Worked on EDI while troubleshooting file transfer protocol (FTP) networking systems, monitoring ongoing projects for effectiveness and efficiency, and ensuring adherence to industry security standards.
  • Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.
  • Worked extensively with Composite data types, Cursors and Dynamic SQL.
  • Worked with Dynamic SQL, Global Temporary Tables.
  • Worked on IT Workload Automation and Job Scheduling.
  • Experience on Tableau for reporting and dashboarding.
  • Hands on experience SQL Server and SSRS administration.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Used standard packages like UTL FILE, DBMS SQL, PL/SQL Collections and used BULK Binding.
  • Worked in Oracle reports and forms version 6i and 10g.
  • Worked on SQL Server Reporting Services (SSRS) report development.
  • Worked on SQL Server Integration Services (SSIS) development.
  • Worked on Pro*C programs and SQL Scripts to generate full extracts of large tables.
  • Had good Knowledge on Tableau, Informatica and ETL.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.

Oracle PL/SQL Developer

Confidential, Monroeville, PA

Environment: UNIX, Oracle 11g/12c, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, PL/SQL, SQL*Loader, Reports6i, SQL SERVER, Subversion (SVN).

Responsibilities:

  • Worked on SPARCS for the existing tables and added functions in existing packages.
  • Worked on Coram CNS, Branding and Anthem projects to develop and modify PL/SQL functions, views, sequences and triggers using PL/SQL.
  • Worked on invoice payments, billing and patient enrollments in Per Diems and worked on Per Diem Maintenance screen.
  • EDI interact with business transactions with other companies using electronic channels. They are also responsible of analyzing the company requirements and develop and design a system accordingly.
  • Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
  • Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
  • IntegratedXML and other types of programming into databases and applications.
  • Involved In developing PL/SQL Procedures, Functions, Cursors, Package views and Materialized views.
  • Where me worked on claims and settlements opt in and opt out emails from customers and feedbacks.
  • Experience on Tableau for reporting and dashboarding.
  • Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
  • Created materialized views, Inline Views & normal views where business requirements needed.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Developed stored procedures and packages. Extensive work in PL/SQL.
  • Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.

Oracle PL/SQL Developer

Confidential, Atlanta, GA

Environment: Oracle 11g/12c, SQL Server, PL/SQL, SQL Server 2005, Data Modeling, Data migration, SQL Navigator, Toad, UNIX, Shell Scripting, Subversion (SVN).

Responsibilities:

  • Interacted witharchitects and business analyststo understandbusiness requirements.
  • Involved with project development teams to convert themodel into technical specificationsand provide noledge transfer to quality assurance analysts.
  • Worked on Postgre database and sql developer.
  • Integrate XML and other types of programming into databases and applications.
  • Performednormalizationof the OLTP database to eliminate redundant data.
  • Used to pull up all the Medicare and Medicaid insurance policies from the system and run in the application.
  • Analysis and Design for new system using Oracle Designer, and then creating basic Forms with wizards, and complex designs manually.
  • Developed Activity Diagrams, State Chart diagrams, Class Diagrams, Use Case Diagrams and Sequence Diagrams using Rational Rose.
  • Experience in working with different databases like Postgre, Oracle 11g/12c/10g/9i/8i.
  • Created the sql queires using the medicare applications to generatre who are eligible and not eligilble for the insurance policy.
  • Implemented data mappings, flows and report dissemination mechanisms by architectingData Marts.
  • DevelopedPL/SQL Procedures, Functions, Cursors, Packages, views andMaterialized views.
  • Createddynamic sqlqueries usingExecute Immediatestatements.
  • Worked on Postgre, IT Workload Automation and Job Scheduling.
  • Worked withdata dictionary viewsto query the required information.
  • Worked ondebuggingthe code and creating theexceptionsto handle bad data and send them to error log files.

Oracle PL/SQL Developer M

Confidential, Rockville, MD

Environment: Oracle 11g/12c, SQL Server, PL/SQL, SQL Server 2005, Data Modeling, Data migration, SQL Navigator, Toad, UNIX, Shell Scripting, Subversion (SVN).

Responsibilities:

  • Worked on visual tool for ETL created by Microsoft and worked on SSRS for SQL Server as a source.
  • Worked ontool produced byOracledat offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
  • Where me worked on claims and settlements opt in and opt out emails from customers and feedbacks.
  • They will also be asked to perform risk assessments and add needed controls to close any control gaps.
  • Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
  • Integrate XML and other types of programming into databases and applications.
  • Extensively used bulk collection in PL/SQL objects for improving the performing
  • Worked onSQL and PL/SQL code tuning to improve database response time and performance for several applications.

Oracle PL/SQL Developer

Confidential

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer, UNIX, TOAD, Shell scripting, Subversion (SVN).

Responsibilities:

  • Understanding the existing business processes and interacting with End user to finalize their requirement.
  • Created PL/SQL Packages, Procedures, Functions and Triggers.
  • Wrote PL/SQL code for data Conversion in store level pricing categories and web services.
  • Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.
  • Used FOR UPDATE clause to lock the records in the cursor and used WHERE CURRENT OF statement to update the records dat have been referenced by a for update statement.
  • Custom Interface for EDI Supplier and modification on base Retekforms for order system using PL/SQL.
  • Wrote high performance queries/programs using Collections, Nested tables, REF Cursors, pipeline functions.
  • Used a wide variety of exception handlers in the procedures to handle the exceptions.
  • Created Test Plan for QA and implementation plan for Production, upon completion of unit testing.
  • Used records, type, cursors, %TYPE and ref cursors in the procedures created.
  • Created and worked with Global Temporary Tables and use to write web service in Oracle environment.
  • Tweaked hints like parallel, append, index, etc. to hint the oracle optimizer for better performance.
  • Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
  • Used composite data types like %ROWTYPE and %TYPE.
  • Written shell scripts to automate loading files into database using Crontab.

Oracle PL/SQL Developer

Confidential

Environment: Oracle 11g, MOD PL/SQL, TOAD, MS-Visio, Aptana studio3, Windows XP.

Responsibilities:

  • Involved in analyzing and seggregating sql queries from legacy PLSQL code.
  • Involved In developing PL/SQL Procedures, Functions, Cursore, Package views and Materialized views.
  • Used CSS files for maintaining user interface standards and use to write web service in Oracle environment
  • Implemented the code for designing screens using PLSQL.
  • Implemented Performance Tuning by creating Indexes, executing EXPLAIN PLAN on SQL Scripts.
  • Designed UMLmodels (Visio) and Relational datamodels for applications.

We'd love your feedback!