Oracle pl sql

SR ORACLE PL/SQL DEVELOPER/Data Analyst

BLANCA Y. KEOGH

Tampa,FL, 33626

Email: ******.***********@*****.***

Professional Summary:

Over 16+ years of IT experience working as an Oracle database Developer/PL SQL Developer/Data Analyst. I know different versions of Oracle database such as 8i, 9i, 10g, 11g, 12c,18c, 19c, with a strong background in design, development and implementation of software applications.

Extensive development experience in writing SQL, creating database objects such as tables, views, stored procedures, functions, packages, database triggers, data loading using SQLLoader and external tables.

A team player with the ability to learn quickly and handle large projects.

Strong experience with Data Mapping, Data transformation, Migration scripts moving data from source to target, Oracle Data pum import/export. Bulk Collections, nested tables, dynamic sql, UTL_FILE, PL/SQL, SQL*Plus, construction of ETL, Performance Tuning of Database ref cursors and job scheduler.

Tuning and troubleshooting of Oracle PL/SQL code (Packages, Procedures, Functions, etc)

Performing troubleshooting for any inconsistencies in PL/SQL program and identify root causes/debugging of problems

Read/write .XML(clob) and JSON files using SQL and PL/SQL

Knowdege and use of Oracle Apex 19.1.

Data loading form flat files csv,xls,xml and JSON.

Good understanding of Data modeling concepts ER Diagrams, Use Cases, Normalization and De-normalization of Tables.

Involved in all phases of the SDLC(Software Development Life Cycle) from analysis, design, development, testing, implementation and maintanance with timely delivery againsts agressive deadlines.

Experience in handling large-scale applications and complex software development projects.

Ability to understand the existing complex PL/SQL objects and Strong in debugging.

Working experience with stake holders to identify and gather business requirements for new applications and reports.

Quick learner and possesses ability to attain a high degree of accuracy in work.

Skills Summary:

Oracle 10g,11g,12c,18c,19c, Toad, PL/SQL Developer, Jira, Ansible, Oracle Apex, Oracle Forms 6i, Oracle Reports, Enterprise Manager Console, Business Intelligence, Dev-Ops tools like Bitbucket, Jenkins, GIT, ansible, XLR.

BMC Remedy, Bizaggi BPM, Visio, Microsoft teams, TFS, tortoise, ETL Informatica Tools 10.4.1, SSMA SQL Server Assistant Migration, FME Workbench, SAP Data Service.

Professional Experience:

December 2021-current

PL SQL developer/SQL Data Analyst at Bank of America

Contribute to development best practices to improve efficiency

Create databases, tables, packages, procedures and maintain applications working in Oracle 19c.

Develop new functions/procedures within databases to promote convenience and ease of use.

Analyze and debug code to find issues root cause.

Write technical documentation of existing/new applications

Solve Jira tickets in Agile methodology

Own assigned projects from beginning to end.

Support one time production reléase.

Provide technical and functional support to the team throughout the project lifecycle.

Gather statistics and deploy objects through ansible and XLR.

Provide technical assistance to other developers as needed.

Participate in peer code review.

Involved in the continuos enhancements and fixing of production problems including future code releases or patches.

Other requirements as needed

August 2021-October 2021

PL SQL developer/SQL Data Analyst at City National Bank

Responsibilities

Developed complexed sql queries and PL SQL

Prepared and maintained data mapping processes and rules.

Analyzed Oracle tables data volume and provided recommendation for indexes

Performed data clean up and moved bad records to audit tables

Assisted/supported Oracle migration legacy system from 12c to 18c

Worked on data validation to ensure the accuracy and quality of data.

Produced required reports and dashboards to internal users in required formats(Oracle APEX 19.1)

December 2016-April 2021

Oracle PLSQL Developer at Nation Wide Title Clearing

Responsibilities:

Designed and developed Oracle applications using forms 6i and reports

Involved in data loading using PL/SQL, SQL*Loader and external tables to manipulate files.

Used bulk collections for better performance and easy retrieval of data. Created PL/SQL scripts to extract the data from the database into simple flat text files using UTL_FILE package.

Involved in the continuos enhancements and fixing of production problems including future code releases or patches.

Participated in change and code review to understand the testing needs of the change components.

Identified high-level system impacts

Provided technical estimates

Performed thorough unit testing

Created master detail modules for Audit in APEX 19.1

Consuming web services from PL/SQL using UTL_HTTP

Migrated code by exporting and importing data using SQL*Loader, and scheduled Jobs

Developed complex database objects such as stored procedures, functions and packages using SQL and PL/SQL

Converted MS Access and SQL Server SQL queries to Oracle

December 2015 – November 2016

PLSQL Developer at EyesBot, LLC, Las Vegas, NV

Responsibilities:

Created database model and tables, views, procedures, triggers, functions using Oracle tools like TOAD, plsql DEVELOPER and sql *plus.

Wrote packages to fetch complex data from different tables using joins, sub queries and database links.

Created customized ETL procedures for migrating data as new models were developed.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created indexes on tables to improve the performance by eliminating the full table scans and to eliminate the complexity of large queries.

Worked closely with users to establish problem specifications and system designs.

February 2014-October-2015 Oracle PLSQL Developer at Kibernum

Responsibilities:

Analyzed, designed and implemented information systems involved with the extraction, transformation, and loading of data from Oracle databases.

Developed of Oracle ETL scripts, modeled of databases as well as process using BPM.

PLSQL programming and code optimization, supported and maintanence of internal applications.

Utilized SQL to create and modify tables, views, indices, constraints and database objects.

Utilized SQL and PL SQL inside TOAD to develop database code, insert/modify/delete data into tables

Performed PL SQL coding used to develop database packages, procedures, functions, triggers, and modules

September 2009-January 2014

Oracle Database Analyst at CMR Falabella

Responsibilities:

Worked on Data migration projects using XML as the data transfer format, analysis and development at the database level, development of processes for logistics, storage and retail using PLSQL and forms.

Used SQL*Plus to create and modify tables and data, create ad-hoc reports for users, create and alter permissions, roles, and users.

Designed and developed Billing Management system from third-party legacy system into Oracle.

Designed and developed of PL/SQL stored procedures, generation and loading of archives, construction of stored procedures for data maintenance, tools used include Oracle Forms, Modules and Reports.

Responsible for designing the Data Model of the project using Microsoft Visio.

Developed Available Inventory reports using Oracle Reports 6i.

January 2007-July 2009

Oracle PLSQL Developer at AV VILLAS BANK

Responsibilities:

Created Enterprise applications in PLSQL for Bank departments, stored procedures for the human resources department as well as for nominal cost for the finance department and integrated them with Oracle Forms.

Designed and migrated data between schemas and Generated reports, in JSP and JASPER reports in Java.

Contact this candidate