Arturs Arajs
Oracle Database Developer at Autentica- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Latvian Native or bilingual proficiency
Topline Score
Bio
Credentials
-
SAS Certified Data Integration Developer for SAS 9
SASApr, 2019- Nov, 2024 -
SAS Certified Base Programmer for SAS 9 (CBP)
SASFeb, 2019- Nov, 2024 -
Oracle Database SQL Expert
OracleApr, 2014- Nov, 2024
Experience
-
Autentica
-
Latvia
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Oracle Database Developer
-
Feb 2021 - Present
Main job as Oracle PL/SQL developer in Oracle’s EBS environment. Custom Oracle Forms support and maintanance; also Java. Developing new functionalities and supporting existing ones. Main job as Oracle PL/SQL developer in Oracle’s EBS environment. Custom Oracle Forms support and maintanance; also Java. Developing new functionalities and supporting existing ones.
-
-
-
Tet.lv
-
Latvia
-
IT Services and IT Consulting
-
300 - 400 Employee
-
SQL Programmer
-
Sep 2020 - Feb 2021
Doing code changes and developing new functionalities in Oracle Database (PL/SQL). Preparing test data (XML and/or Json files) using Oracle SQL and/or PostgreSQL and performing bulk loads into a custom system using SOAP. Custom application’s configuration (PostgreSQL) and testing. Doing code changes and developing new functionalities in Oracle Database (PL/SQL). Preparing test data (XML and/or Json files) using Oracle SQL and/or PostgreSQL and performing bulk loads into a custom system using SOAP. Custom application’s configuration (PostgreSQL) and testing.
-
-
-
Emergn
-
United Kingdom
-
Business Consulting and Services
-
300 - 400 Employee
-
Senior Database Specialist
-
Aug 2019 - Sep 2020
Working as a Oracle PL/SQL developer in government's project using Oracle Database and Oracle PL/SQL, and Oracle Application Express (Oracle APEX). Participation in development planning, estimations, support; collaboration with process leads and product owners; working together with Test Specialists and Business Analysts on daily basis. Agile/Scrum environment. Working as a Oracle PL/SQL developer in government's project using Oracle Database and Oracle PL/SQL, and Oracle Application Express (Oracle APEX). Participation in development planning, estimations, support; collaboration with process leads and product owners; working together with Test Specialists and Business Analysts on daily basis. Agile/Scrum environment.
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Data Engineer
-
Feb 2019 - Aug 2019
Went through SAS solution certification (acquired “SAS Base Programmer” and “SAS Data Integration Developer” certificates) and SAS demo environment setups. Went through SAS solution certification (acquired “SAS Base Programmer” and “SAS Data Integration Developer” certificates) and SAS demo environment setups.
-
-
-
Tieto
-
Finland
-
Information Technology & Services
-
700 & Above Employee
-
Technical Consultant, Oracle EBS (PL/SQL) developer
-
Apr 2015 - Feb 2019
Collaboration with process leads and product owners in order to consult them about Oracle EBS modules and/or custom procedures. Acquire needed information and data in order to develop requested changes.Cooperation with Functional Consultants about Oracle EBS standard and custom procedures in order to release new functionalities and/or fix or customize existing ones, bug fixing and other problem solving. Oracle Service Request creation and monitoring. Main development in Oracle PL/SQL.
-
-
Functional Consultant, Oracle EBS
-
Jun 2013 - Apr 2015
Collaboration with process leads and product owners in order to consult them about Oracle EBS modules and/or custom procedures. Delegate request/problem to Technical Consultants for development. Datafix creation and report writing using Oracle SQL and PL/SQL. Internal testing of change/problem requests. Oracle Service Request creation and monitoring.
-
-
-
PINS.co
-
Latvia
-
Advertising Services
-
1 - 100 Employee
-
Database administrator
-
Jul 2012 - Jun 2013
Monitoring daily activities and transactions. Work with different departments and internal teams and service providers in order to successfully deliver projects and products. Work with offshore development team to ensure fulfillments of system requirements. Tracking and resolving different issues. Writing different report scripts using SQL and preparing reports for analysis. Monitoring daily activities and transactions. Work with different departments and internal teams and service providers in order to successfully deliver projects and products. Work with offshore development team to ensure fulfillments of system requirements. Tracking and resolving different issues. Writing different report scripts using SQL and preparing reports for analysis.
-
-
-
Tieto
-
Finland
-
Information Technology & Services
-
700 & Above Employee
-
Senior Master Data Maintenance specialist
-
Apr 2012 - Jul 2012
Handle complicated tasks and requests from clients, support colleagues in their daily work. New request registration. Different report creation uning SQL. Maintaining Oracle EBS system and doing setups and other changes.Performing functions related to master data maintenance in Oracle-based ERP system (Employee accounts and Supplier entity creation/update/merge/inactivation) ensuring entered data quality and accuracy.Solving complicated tasks from internal customers through BMC Remedy AR System’s requests sent to our queue (if it was not possible to solve particular case, proper support level and team to whom it can be forwarded was found as part of responsibility).Respond immediately to assigned master data related requests in any of the internal systems that are maintained by MDM unit. Check and validate content and quality of submitted requests, consult requestors in case of incorrect details or missing information. Analyze the nature of received customer requests to avoid processing of unnecessary master data entries or updates. Operate master data loading tools when processing updates in multiple instances of master data.Team’s monthly quality check preparation for data quality and SLA’s using BMC Remedy AR System’s available scripts (was able to modify them if needed).Order Change process lead. Show less
-
-
Master Data Maintenance specialist
-
Sep 2008 - May 2012
Handle complicated tasks and requests from clients, support colleagues in their daily work. New request registration. Different report creation uning SQL. Maintaining Oracle EBS system and doing setups and other changes.Performing functions related to master data maintenance in Oracle-based ERP system (Employee accounts and Supplier entity creation/update/merge/inactivation) ensuring entered data quality and accuracy.Solving complicated tasks from internal customers through BMC Remedy AR System’s requests sent to our queue (if it was not possible to solve particular case, proper support level and team to whom it can be forwarded was found as part of responsibility).Respond immediately to assigned master data related requests in any of the internal systems that are maintained by MDM unit. Check and validate content and quality of submitted requests, consult requestors in case of incorrect details or missing information. Analyze the nature of received customer requests to avoid processing of unnecessary master data entries or updates. Operate master data loading tools when processing updates in multiple instances of master data. Show less
-
-
-
HansaWorld
-
United Kingdom
-
Software Development
-
1 - 100 Employee
-
Application Service Provider, IT assistant
-
Jun 2008 - Aug 2008
Helping others with daily computer problems (maintenance, installations); server monitoring, Helping others with daily computer problems (maintenance, installations); server monitoring,
-
-