Ferenc Korei-Szabo
Sr. Database Developer, Software Engineer
Dublin
Summary
Experienced SQL and PL/SQL developer with a solid foundation in Oracle databases and application programming. Dedicated to crafting customized technical solutions that align with operational requirements and goals. Acknowledged for critical thinking, analytical prowess, and problem-solving capabilities, consistently delivering top-notch products in a range of business settings.
Actively broadening skill set by acquiring knowledge in GoLang through online courses, with future plans to elevate expertise in Python utilizing machine learning techniques.
Overview
17
17
years of professional experience
5
5
years of post-secondary education
Work History
Oracle Database Developer
Bank Of America – Merril Lynch Branch (Ireland)
05.2023 - Current
- Working on Bank of America's financial regulatory reporting solution tool (called GRIFFIN): to fulfill requirements and changes using PL/SQL.
- Develop scripts and processes for data integration and maintenance using PL/SQL.
- Identify issues within databases, performed troubleshooting and implemented effective solutions.
- Performance tuning.
- Creating APIs, unit testing, bug fixing.
- Using Git.
- Working together with BAs to implement solutions.
- Following the Agile methodology.
Senior PL/SQL Developer
Allianz Technology
03.2022 - 05.2023
- Working on Allianz fraud detection software's country-specific requirements and changes using PL/SQL.
- Support clients (through Business Analysts): data investigations, error searching, performance tuning.
- Work closely with team members and with the business to find proper solutions for new requests or problems.
- Preparing, deploying, and managing new product versions (operational tasks):
- Changing setups/parameters in the database or in shell scripts.
- Managing SVN.
- Using CI/CD: Jenkins for deploying (but in some cases manually).
- Hybrid Cloud deployments using ServiceNow.
- Manage logs and documentation.
- Following the Agile methodology.
Senior IT Expert
Nextent Informatika Zrt. (Generali project)
11.2021 - 02.2022
- Ensured accurate reporting results with thorough validation of ETL processes, data transformations, and aggregations.
- Insurance-related ledger/accounting developments (PL/SQL).
- Develop, change, and migrate different types of closing reports using PL/SQL.
- Agile environment
Senior Programmer Analyst
NI Hungary ltd. (National Instruments, US)
03.2019 - 10.2021
- Oracle EBS developments (PL/SQL, Oracle Forms).
- Oracle Apex application development
- Oracle Agile PLM development (Java).
- SpringBoot web service development.
- Support the integration of disparate systems using APIs, simplifying data exchange between applications.
- Grails web application development (Groovy).
- Project management (managing Apex and Agile PLM version upgrades).
- Managing CI/CD (using Azure DevOps pipelines, Rancher).
- GIT, Artifactory, Jira.
- Working together with a Business Analyst to find proper solutions for new requirements.
- Following the Agile methodology.
Database Analyst
IQVIA (earlier: IMS Health / Quintiles)
03.2012 - 02.2019
- Develop scripts and processes for data integration and maintenance using PL/SQL.
- Design and create new databases (implement new countries into our system) and develop ETL processes for them using PL/SQL.
- Create relational and OLAP processing with own-developed programs (tools), and create automation jobs.
- Publish monthly and weekly databases in different countries.
- Develop recurrent and ad-hoc reports - automation, if necessary.
- Support colleagues: reports, error checks, validations, bug fixing.
PL/SQL developer – consultant
Medisim Consulting Zrt.
12.2009 - 02.2012
- Database developments using PL/SQL.
- Creating and controlling OLAP processing (with own-developed software, script writing).
- Implement new developments and analyze databases to optimize them (Oracle).
- Database support for the foreign staff (reporting, error searching, modification, controlling, using TOAD, SQL developer).
PL/SQL developer
Hungarian State Treasury
08.2007 - 11.2008
- Develop the Treasury's software (mainly the accounting part) under Oracle.
- Creating and maintenance of cumulative reports. (Oracle Repors Builder)
- Develop and maintain Oracle Forms applications (accounting module).
- Error searching and fixing in different county databases.
Education
Bachelor of Science - Computer Programer Mathematician
Karoly Eszterhazy College
Hungary 04.2002 - 01.2007
Skills
Advanced SQL Queries
ETL development
Stored Procedures
Analytical Skills
Oracle, PL/SQL
Oracle Froms
Oracle Reports
Oracle Agile PLM
Springboot
Grails
Java
GoLang
Oracle Apex
Locationparsed - City
Drynam Dr, Drinan, Swords, Co. Dublin
Placeofbirth
Nyiregyhaza, Hungary
Personal Information
- Date of Birth: 06/01/84
- Marital Status: Married
Languages
Hungarian
Native language
English
Advanced
C1
Dateparsed
05/10/24
Timeline
Oracle Database Developer
Bank Of America – Merril Lynch Branch (Ireland)
05.2023 - Current
Senior PL/SQL Developer
Allianz Technology
03.2022 - 05.2023
Senior IT Expert
Nextent Informatika Zrt. (Generali project)
11.2021 - 02.2022
Senior Programmer Analyst
NI Hungary ltd. (National Instruments, US)
03.2019 - 10.2021
Database Analyst
IQVIA (earlier: IMS Health / Quintiles)
03.2012 - 02.2019
PL/SQL developer – consultant
Medisim Consulting Zrt.
12.2009 - 02.2012
PL/SQL developer
Hungarian State Treasury
08.2007 - 11.2008
Bachelor of Science - Computer Programer Mathematician
Karoly Eszterhazy College
04.2002 - 01.2007