Data Engineer

Project description: Maintenance and development of Oracle database systems through ETL processes for debit and credit card transactions/authorizations. Managed multiple teams comprising over 20 people, following the Scrum methodology.

Responsibilities:

• Developing Oracle databases;

• Implementing ETL processes in Oracle Data Integrator (ODI);

• Performance tuning of SQL statements;

• Preparing production deployments and implementation plans;

• Assisting other team members and onboarding new employees;

• Assisting the Scrum master and leading some Scrum meetings.

Technologies used: Oracle 19, GIT, Gerrit, Jenkins Flyway, Oracle Data Integrator, Snowflake, JIRA, Confluence, Microsoft Teams.

Project description: Provided support for the Impairment system as part of a scrum team of 9 people. Followed the Scrum methodology.

Responsibilities:

• Developing Oracle databases;

• Acting as Scrum master from 2021-02-01;

• Implementing ETL processes in Informatica Power Center based on SAS processes;

• Collaborating with the business to fulfill task requirements;

• Documenting system functionalities;

• Conducting unit testing of database objects (packages, procedures);

• Creating code reviews for applied changes;

• Reviewing other developers' changes;

• Managing and using Git repository;

• Optimizing Oracle procedures.

Technologies used: Oracle 12, GIT, Bitbucket, Informatica Power Center, JIRA, Wiki, Microsoft Teams.

Migration from Sybase to Oracle 12c. Led a database team in a project involving 30 people across 3 development teams. Applied the Scrum methodology.

Responsibilities:

• Acting as Scrum Master and Team Leader for the database team;

• Providing technical leadership to all developers in the database area;

• Supporting the Product Owner in Sprint planning and monitoring progress;

• Analyzing differences between Sybase T-SQL and Oracle 12c PL/SQL and implementing necessary changes;

• Converting triggers to compound triggers Conducting unit testing of database objects (views, triggers, procedures);

• Creating code reviews for applied changes Reviewing other developers' changes;

• Managing the SQL team;

• Managing and using SVN repository.

• Optimizing Oracle procedures;

Technologies used: Oracle 12c, Sybase, SVN, Crucible, Unix, Agile Kanban, Azure Boards, Azure Queries and Charts, Microsoft Teams.

• Implemented new business logic in MS/SQL 2008 database as part of a fixed-price project.

Responsibilities:

• Analyzing project requirements and specifications Implementing database changes, including designing the database structure and developing tables and stored procedures;

• Conducting unit testing of developed changes Using Git repository.

• Responsible for the maintenance of debit and credit card systems in an Oracle 11 database.

Responsibilities:

• Analyzing business and fix change requests (Jira requests);

• Implementing changes in Oracle views, packages, triggers, and database links Using SVN repository.

• Developed PostgreSQL databases and XML scripts for Novo-Property applications.

Responsibilities:

• Developed new functionalities in the system, including creating a purchase invoice acceptance process and implementing it in PostgreSQL 8.4.17 database and XML files;

• Extended SQL reports and corrected XML views based on client requirements;

• Developed the Facility Management project, including creating tables, functions, triggers, views, rules, and indexes;

• Developed Linux shell scripts Used SVN repository.

• Responsible for MS SQL 2008 database programming, including creating and correcting procedures and scripts.

Responsibilities:

• Addressed problems, orders, and incidents raised in the Jira system;

• Corrected data using proper MS SQL queries;

• Analyzed and corrected stored procedures;

• Coordinated with other departments when necessary;

• Communicated with internal customers to understand task requirements.

• Developed a project in PL/SQL, including implementing sequences, triggers, tables, packages, and functions;

• Created an Oracle Forms form based on given requirements. Wrote UNIX scripts for scheduled processes.