Experience

Crédit Agricole Creditor Insurance (CACI)

• Ireland
• Insurance
• 100 - 200 Employee

• Data and Intelligence Services Analyst

  • Jun 2022 - 1 year 7 months

  Dublín, Dublín, Irlanda My job as a Data and Intelligence Services Analyst consists of analyzing the entire production process of the company's database using the SAS tool (PROC SQL). The main job is to maintain the consistency of the data in the database according to the business rules that exist for each partner. The second purpose is to allow all departments in the organization to access the data necessary for the execution of their business process. This require consistency, reliability, accuracy and security in… Show more My job as a Data and Intelligence Services Analyst consists of analyzing the entire production process of the company's database using the SAS tool (PROC SQL). The main job is to maintain the consistency of the data in the database according to the business rules that exist for each partner. The second purpose is to allow all departments in the organization to access the data necessary for the execution of their business process. This require consistency, reliability, accuracy and security in the framework applied by the team. A typical set of tasks that I perform are: 1- Data Collection activity • Define and describe the data needed to be collected and the appropriate resources • Apply the data quality standards defined in the Data Policy of the company 2- Data Loading activity • Adapt the necessary business rules to implement them in the Data Warehouse • Execute the production procedures to keep the Data Warehouses up to date • Tracks and describes/formalizes all data issues according to the scope defined by the manager • Implements and improves controls on data quality metrics (accuracy, completeness, appropriateness) 3- Data Warehouse Functional Administration activity • Control, monitor, and manage the end-user access to the Data Management System • Administration of the Data Warehouses 4- Communicate updates or possible changes in business rules to the different departments of the company. • Communicate database updates • Explain the different problems that may have occurred in the weekly data loading Show less



Valiance Partners - An NNIT Group Company

• United States
• Software Development
• 1 - 100 Employee

• Migration Specialist

  • Aug 2020 - Jun 2022

  Ireland My job at Valiance Partners consists of transforming, modeling and introducing databases on a platform called Veeva Vault. To get the job done, I use the TRUConsole tool. TRUconsole is a collaborative migration management tool that provides a central user interface for organizing and collaborating on migration and consolidation jobs. As a source for data migration, I use different platforms for different projects but normally they are SQL Developer or Microsoft SQL Server. I'll explain the… Show more My job at Valiance Partners consists of transforming, modeling and introducing databases on a platform called Veeva Vault. To get the job done, I use the TRUConsole tool. TRUconsole is a collaborative migration management tool that provides a central user interface for organizing and collaborating on migration and consolidation jobs. As a source for data migration, I use different platforms for different projects but normally they are SQL Developer or Microsoft SQL Server. I'll explain the details of the job:  Study the customer database and understand the data migration requirements.  If necessary, transform and modify the customer database before migration. Normally I carry out this type of operations with Microsoft Excel or Microsoft Access and the necessary tools are used (Macros, queries, etc.).  Use one of the TRUConsole tools (TRUMigrate) to migrate the data from the source (SQL Developer, Microsoft SQL Server, etc.) to the target (Veeva Vault).  To check that all the data has been migrated correctly, I use another TRUConsole tool called TRUCompare, to check if with a different configuration all the data could have been migrated without failures. Show less



EY

• United Kingdom
• IT Services and IT Consulting
• 700 & Above Employee

• RPA Developer

  • May 2019 - Dec 2019

  Spain My job as an RPA Developer at EY was to build robots using the Blue Prism program to modify and analyze datasets. The work consisted of the following steps:  Extract the dataset from SAP.  Receive the dataset and use a python program to eliminate or modify the imperfections within the dataset.  Create a robot with the Blue Prism program to make the dataset modifications requested by client.  Design and development of the database to make queries with SQL Server. Create… Show more My job as an RPA Developer at EY was to build robots using the Blue Prism program to modify and analyze datasets. The work consisted of the following steps:  Extract the dataset from SAP.  Receive the dataset and use a python program to eliminate or modify the imperfections within the dataset.  Create a robot with the Blue Prism program to make the dataset modifications requested by client.  Design and development of the database to make queries with SQL Server. Create tables with each of the different files to relate the files to each other.  Make the different queries with SQL Server to extract relevant information for the client.  Provide maintenance and support for the created program over a specified warranty period Also completed a project with Starbucks Spain which consisted of determining with management, relevant dataset fields for the detection of employee fraud across all Spanish retail outlets. After confirming the Show less



Puertas BELU,S.L.-Spain

• Industrial Engineer

  • Feb 2018 - Sep 2018

  Málaga, Andalusia, Spain My job as an industrial engineer was to write all the necessary documentation to obtain the CE certificate on metal doors. I had to document the product production chain and make a report for the certifying company.