| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateORACLE PL SQL/ETL DEVELOPER/Data AnalystCandidate's Name
Tampa, FLEmail: EMAIL AVAILABLEProfessional SummaryHighlightsStrong 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 SummaryOracle 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 versin TFS, tortoise, ETL Informatica Tools 10.4.1, WinSCP, putty, SSMA SQL Server Assistant Migration, FME Workbench, SAP Data Service.Professional ExperienceSenior Oracle PL SQL developer/ETL/Data Analyst (Remote)Bank of AmericaDecember 2021-2023 (2 years)AchievementsContributed to development best practices to improve efficiencyCreated 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 ValidationWorked on mapping and moving data from Source to Target using Informatica ETLWrote technical documentation of existing/new applicationsPerformed unit testing by running Oracle pl sql scripts and queries.Solved Jira tickets using Agile methodologyOwned 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 neededOther requirements as neededSenior Oracle PL SQL developer/SQL Data Analyst (Remote)City National BankAugust 2021-October 2021 (3 months)AchievementsDeveloped complexed sql queries and PL SQL scriptsPrepared and maintained data mapping processes and rules.Analyzed Oracle tables data volume and provided recommendation for indexesPerformed data clean up and moved bad records to audit tablesAssisted/supported Oracle migration legacy system from 12c to 18cReconciled 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 ClearingDecember 2016-April 2021 (4 years and 3 months)AchievementsDesigned and developed Oracle applications using forms 6i and reportsInvolved 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 testingCreated master detail modules for Audit in APEX 19.1Consumed web services from PL/SQL using UTL_HTTPWorked on Data migration using export/importing, SQL*Loader, external tables and scheduled JobsDeveloped complex database objects such as stored procedures, functions and packages using SQL and PL/SQLConverted MS Access and SQL Server SQL queries to OracleOracle PL SQL developer (Remote)EyesBot, LLC, Las Vegas, NVDecember 2014 November 2016 (2 years)AchievementsCreated 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)KibernumFebruary 2012-March-2014 (2 year and 1 month)AchievementsAnalyzed, 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 tablesPerformed PL SQL coding used to develop database packages, procedures, functions, triggers, and modulesOracle Database Developer/Data Analyst (Chile)CMR FalabellaSeptember 2009-January 2012 (2 years and 4 months)AchievementsWorked 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 BANKJanuary 2007-July 2009 (2 years and 6 months)AchievementsCreated 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. |
