ORACLE PL SQL/ETL DEVELOPER/Data Analyst

BLANCA Y. KEOGH

Tampa, FL

Email: ad41m6@r.postjobfree.com

Professional Summary

Highlights

Strong experience with Data Mapping, Data transformation, Migration scripts moving data from source to target, Oracle Data pump import/export. Bulk Collections FOR ALL, nested tables, dynamic sql, UTL_FILE, PL/SQL, Read/write .XML(clob) and JSON files using SQL and PL/SQL, writing and calling Web Services in PL/SQL using ORDS and UTL_HTTP package.

Construction of ETL workflows and data loading from flat files csv, xls, xml and JSON.

Tuning, refactoring and troubleshooting for any inconsistencies in PL/SQL programs and identifying root causes / debugging of (Packages, Procedures, Functions, etc).

Tools Summary

Oracle 8i,9i, 10g,11g,12c,18c,19c, SQL navigator, 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, Unix commands, ansible, XLR.

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

Professional Experience

Senior Oracle PL SQL developer/ETL/Data Analyst (Remote)

Bank of America

December 2021-2023 (2 years)

Achievements

Contributed to development best practices to improve efficiency

Created databases, tables, packages, procedures, functions, triggers and maintained applications working in Oracle 19c.

Developed new PL SQL functions/procedures within databases to promote convenience and ease of use.

Analyzed and debugged code in PL SQL to find issues root cause.

Implemented the Data Quality Framework, created the Database model and complex SQL queries for Data Validation

Worked on mapping and moving data from Source to Target using Informatica ETL

Wrote technical documentation of existing/new applications

Performed unit testing by running Oracle pl sql scripts and queries.

Solved Jira tickets using Agile methodology

Owned assigned projects from beginning to end.

Supported scheduled production releases.

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

Gathered Oracle table statistics and deployed objects through Ansible and XLR.

Provided technical assistance to other developers as needed.

Participated in peer code review.

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

Ran Scrum meetings as needed

Other requirements as needed

Senior Oracle PL SQL developer/SQL Data Analyst (Remote)

City National Bank

August 2021-October 2021 (3 months)

Achievements

Developed complexed sql queries and PL SQL scripts

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

Reconciled and implemented data quality / validation for the migration Project, wrote complex SQL queries with analytical functions to ensure the accuracy and quality of data.

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

Senior Oracle PL SQL developer/SQL Data Analyst (Palm Harbor FL)

NationWide Title Clearing

December 2016-April 2021 (4 years and 3 months)

Achievements

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.

Compared and verified the data quality from different sources(files) and database tables through manipulation of external tables and customized ETL procedures.

Performed thorough unit testing

Created master detail modules for Audit in APEX 19.1

Consumed web services from PL/SQL using UTL_HTTP

Worked on Data migration using export/importing, SQL*Loader, external tables 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

Oracle PL SQL developer (Remote)

EyesBot, LLC, Las Vegas, NV

December 2014 – November 2016 (2 years)

Achievements

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.

Oracle PL SQL developer/Database Analyst (Chile)

Kibernum

February 2012-March-2014 (2 year and 1 month)

Achievements

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

Oracle Database Developer/Data Analyst (Chile)

CMR Falabella

September 2009-January 2012 (2 years and 4 months)

Achievements

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.

Oracle PL SQL Developer (Colombia)

AV VILLAS BANK

January 2007-July 2009 (2 years and 6 months)

Achievements

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.

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, triggers, synonyms, indexes, partitions and data loading using SQLloader and external tables.

Contact this candidate