Pl Sql Developer

ABAYOMI FESTUS DARAMOLA BSc, MIT, OCA, PLSQL

Montreal, QC

+1-514-***-**** **************@*****.*** www.linkedin.com/in/festus-daramola PROFESIONAL SUMMARY

PL/SQL Developer with over 9 years of progressive experience in Java, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

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

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SKILLS

Database: ** Oracle, SQL Server, MySQL

Database Tools: ** SQL Navigator, TOAD, SQL Developer

Programming Languages: ** Java, Restful API, UNIX Shell scripting

Versioning Tools: ** GitLab, Jira

Frameworks: ** Spring Boot

Banking Software: ** Flexcube Universal Banking Service (FCUBS), Fiserv DNA Banking

PROFESSIONAL EXPERIENCE

Banking Implementation Developer May 2023 – Till Date. BanQsi Inc., Canada

• Collaborate with clients, business analysts, and internal teams to understand requirements and customize solutions accordingly.

• Implement API integrations and middleware solutions to connect banking applications with external systems

• Utilize advanced SQL optimization techniques to enhance the performance of complex queries

• Manage the migration of data from legacy systems to new banking platforms.

• Ensure data accuracy, integrity, and completeness during the migration process.

• Optimization and tuning of existing queries and stored procedures

• Design and implement efficient cursor-based solutions for complex data processing requirements

• Develop dynamic SQL queries and statements to accommodate varying business requirements.

• Provide ongoing support to clients, addressing inquiries and troubleshooting issues promptly ABAYOMI FESTUS DARAMOLA BSc, MIT, OCA, PLSQL

Montreal, QC

+1-514-***-**** **************@*****.*** www.linkedin.com/in/festus-daramola

• Streamlined data fixes, database programming, and SQL queries tuning, raising operational efficiency in the organization by 60 %

Sr Oracle PLSQL Developer Sr Software Engineer Aug 2019 – Apr. 2023 Ecobank Transnational Incorporated, Nigeria.

• Provided RESTFUL API for the development of two mobile applications that improved customer satisfaction across 33 affiliates.

• Designed a middleware service that provided communication to 8 APIs which led to the ease of integration with in-house and third-party applications.

• Participated in the development and data modelling of a Smart Teller application that provided centralized services to Bank tellers and led to an annual cost savings of three million dollars.

• Optimized Rapid Transfer application by over 95% performance increase.

• Analyzed existing SQL queries to identify opportunities for improvements.

• Developed batch processes using shell scripting

• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic

• Coordinated with the Development team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance.

• Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving the performing.

• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

• Use of OOPs concept and other core java concepts in development.

• Using log4J and Apache Commons Logging Interface for logging. Database Developer Apr 2016- Jul 2019

Union Bank of Nigeria Plc

• Followed standard methodologies on coding to write clean and self-documenting code.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.

• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.

• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

• Collaborated with technical contributors during application development to resolve application defects.

• Optimization and tuning of existing queries and stored procedures

• Identified opportunities for Unix system automation and process improvement

• Streamlined data fixes, database programming, and SQL queries tuning, raising operational efficiency in the organization by 45%

ABAYOMI FESTUS DARAMOLA BSc, MIT, OCA, PLSQL

Montreal, QC

+1-514-***-**** **************@*****.*** www.linkedin.com/in/festus-daramola Flexcube Application Support/Junior Oracle Developer Dec 2013 - Mar 2016

Union Bank of Nigeria Plc.

• Provided functional and Technical support for Corporate & Retails Banking applications including Trade Finance modules like Bills and Collections, Funds Transfer, Loans, Deposit, Treasury and General Ledger, and Channels Interface Management.

• Develop PL/SQL packages, procedures, functions for the application, according to business requirements.

• Provided efficient 2nd Level user support for all Flexcube-related issues, specified design changes, and implemented recommended program amendments.

• Tracked escalated issues to Oracle Financial Services Systems (OFSS) for prompt resolution.

• Produced new reports and procedures while delivering on updated existing reports for End-of-Cycle and Backup to ensure the smooth operations of the Bank.

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

• Worked closely with clients to establish problem specifications and system designs. Network Administrator Nov 2012 - Oct 2013

Interra Network Ltd, Nigeria

• Performed day-to-day LAN and WAN administration, maintenance and support.

• Configured networks for smooth, reliable operation to meet business processes and objectives.

• Identified and immediately resolved issues with network devices. EDUCATION

Master of Science Information Technology

National Open University of Nigeria 2016

Bachelor of science Physics

University of Ado Ekiti, Nigeria 2007

CERTIFICATIONS

Oracle Database PL/SQL Developer Certified Professional 2023 Oracle Database SQL Certified Associate 2023

Oracle Cloud Data Management 2023 Certified Foundations Associate 2023 Oracle Cloud Infrastructure 2023 Certified Foundations Associate 2023 OCS Oracle Autonomous Database Cloud 2019 Certified Specialist 2019 OCA Oracle Database SQL Certified Expert 2016

ITIL Information Technology Infrastructure Library. 2014 PROFESSIONAL DEVELOPMENT 2014-2022

• Introduction to Kubernetes & Advanced Java masterclass.

• Enhancement/Customization on Oracle Flexcube Universal Banking V12.0.2 ABAYOMI FESTUS DARAMOLA BSc, MIT, OCA, PLSQL

Montreal, QC

+1-514-***-**** **************@*****.*** www.linkedin.com/in/festus-daramola

• Flexcube Universal Banking Management and Support

• Reporting Strategy of Flexcube Universal Banking (OBIEE)and Data Dictionary of FCUBS Modules

Contact this candidate