Aurel G.

Data Engineer

435 dollar
Freelancer
10 years
Cluj-Napoca, ROMANIA

My experience

More

3Pillar GlobalOctober 2019 - Present

● Data development for clients (mainly Air Canada) of SessionM, a customer engagement and loyalty platform.
● ETL enhancement and performance improvement for data pipeline processes for Air Canada.
● Monitoring ETL solutions on productions servers.
● Data Quality check development and monitoring.
● Redshift database performance monitoring and improvement.
● Providing occasional database assistance for other teams on the same project.

Main projects involved:
- Redshift database performance improvement, mainly by implementing automatic workload management.
- PII data scrubbing from production environment to development environment.
- Data quality check implementation.

Tech stack: Amazon RedShift, MySQL, Elastic Search, Python, AWS Services, Jenkins, Jira, Git.

More

Betfair Romania DevelopmentAugust 2019 - October 2019

● Reporting betting data to various national jurisdictions. 
● Implementing betting reporting processes for new jurisdictions. 
● Assuring data quality for reported data. 
● Monitoring and resolving any reporting issues. 
● Oracle code migration to Aurora. 

Tech stack: Amazon Redshift, Aurora, MySQL, Oracle, Talend, GitLab, Targetprocess.

More

EndavaMarch 2018 - July 2019

● Providing Oracle database service for a major bank in Romania. 
● Design and development of custom functionalities at database level. 
● ETL development for Siebel CRM, optimizing the data feeds performance and the process as a whole. 
● Monitoring and tuning database processes or Siebel CRM triggered processes 
● Participate in planning release deployment strategy and rollback strategy. 

Main projects involved: 
- Implementation at DB level of the client notification management. - Client credit scoring calculation automatization. 

Tech stack: Oracle, Shell scripting, Tortoise SVN, Jira.

More

AccesaDecember 2017 - February 2018

● Development of Power BI reports and dashboards. 
● Ocasional database assistance to different teams. 

Tech stack: Microsoft SQL Server, SSRS, Microsoft Power BI.

More

EndavaJanuary 2016 - December 2017

● Providing Oracle database service for a major bank in Romania. 
● Design and development of custom functionalities at database level. 
● ETL development for Siebel CRM, optimizing the data feeds performance and the process as a whole. 
● Monitoring and tuning database processes or Siebel CRM triggered processes 
● Participate in planning release deployment strategy and rollback strategy. 

Main projects involved: 
- Implementation at DB level of the client notification management. 
- Client credit scoring calculation automatization. 

Tech stack: Oracle, Shell scripting, Tortoise SVN, Jira.  

More

Yardi SystemsAugust 2013 - October 2016

● Data maintenance and development (SQL Server & Oracle) for Voyager (web-based platform for Commercial and Residential Property Management). 
● Developing customized financial reports using SSRS and various in-house tools. 
● Data export into XML and Excel formats for importing to various software, also writing VBA macro code for exporting excel data into other formats. 
● Troubleshoot on reported bugs and resolve performance issues at the OS, database, and SQL code levels. 
● Finding temporary solutions/workarounds for issues planned to be resolved in next releases. 
● Stored procedures development to be used for more complex reports or run as tasks. 
● .NET code debug to identify the cause of reported bugs. 
● Maintain working knowledge of technical enhancements and new functionality. 
● Develop and maintain a working knowledge of business rules and documentation of business processes as they pertain to the business applications to ensure accuracy, consistency, legal compliance, and data integrity. 
● Communication with Account Manager/Client on specifications, development and testing of projects assigned. 
● Providing training to new employees. 

Main projects involved: 
- Serbian Invoicing - Developed Serbian Invoicing functionality as per Serbian legislation using in-house tools. Separate tables structure was designed to be used for the project, multiple custom reports were developed to offer the user a separate linear invoicing process. Custom procedures were developed to reflect the accounting in the standard Voyager functionalities.

- General Client Statement - Developed custom report to be used by UK clients as a Client Statement (Income and Expense Statements, Cash Movement). Project involved also specification design and writing documentation in close communication with different Account Managers /clients. 

- Aviva UK Data import - Wrote macros for transforming excel data exported from other applications and afterwards generating .csv or .xml files to be loaded in Voyager. 

- Functional currency - Wrote various SQL procedures to meet client specifics regarding accounting and reporting in functional currency. Worked closely with QA team on this project. 

Tech stack: Microsoft SQL Server, Oracle Database, SSRS. 

More

CybercomJune 2009 - May 2011

● Manual testing of applications submitted to Ovi store. 
● Moderation of Content submitted in English and Russian as per Nokia guidelines. 
● Executing and creating test cases. 
● Reporting errors found. 
● Black-box, Manual and Functional testing. 
● Localization testing 
● Acceptance testing. 
● Stress, Compatibility, Usability, Regression and Confirmation testing.

My stack

Computer Tools

Microsoft Excel

Software testing

Black box testing, Debugging, Usability testing, Stress testing, Regression testing, Manual testing, Localization testing, Functional testing, Compatibility testing, Acceptance testing, Test Cases

Business Intelligence

SSRS, ETL, SQL Server Reporting Services, Data Warehouse, Talend

Languages

SQL, PL/SQL, T-SQL, XML, C#, Python, Shell Scripting

Technologies

CRM, Amazon Web Services (AWS), TortoiseSVN, AWS, ElasticSearch

Databases

MySQL, Oracle, AWS Aurora, Transact-SQL, Microsoft SQL Server

Analysis methods and tools

JIRA, Agile Methodology

Environment of Development

SQL Developer, GitLab

Middleware

Jenkins

IT Infrastructure

Git, Amazon Redshift

Frameworks

.NET

Others

Database Design, Troubleshooting, Target Process, Siebel

My education and trainings

Bachelor's degree, Statistics - Babes Bolyai University, Cluj-Napoca2009 - 2012

Bachelor's degree, Computer Science - Babes Bolyai University, Cluj-Napoca2006 - 2009