Freelancer profile translated to English.
Back to original languageAbout Adrian
I am 𝗔𝗱𝗿𝗶𝗮𝗻 𝗖𝗼𝘀𝘁𝗮𝘀 𝗔𝗿𝘁𝗮𝗺𝗲𝗻𝗱𝗶, 𝗙𝗿𝗲𝗲𝗹𝗮𝗻𝗰𝗲 𝗣𝗟/𝗦𝗤𝗟 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗮𝗻𝘁 & 𝗗𝗮𝘁𝗮 𝗔𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁.
For over a decade, I have been optimizing, supporting, and reverse-engineering massive business logic to run in a fraction of the original time.
I act as the ultimate technical bridge to efficiently transpose relational systems to Snowflake.
🛠️ 𝗦𝗧𝗥𝗔𝗧𝗘𝗚𝗜𝗖 𝗜𝗡𝗧𝗘𝗥𝗩𝗘𝗡𝗧𝗜𝗢𝗡 𝗔𝗥𝗘𝗔𝗦:
𝗢𝗥𝗔𝗖𝗟𝗘 𝗣𝗘𝗥𝗙𝗢𝗥𝗠𝗔𝗡𝗖𝗘 𝗧𝗨𝗡𝗜𝗡𝗚: Query optimization, indexing, and refactoring of legacy code to reduce Batch execution windows.
𝗟𝗘𝗚𝗔𝗖𝗬 𝗦𝗨𝗣𝗣𝗢𝗥𝗧 & 𝗘𝗩𝗢𝗟𝗨𝗧𝗜𝗢𝗡: Corrective maintenance of critical processes in high-pressure environments such as Banking and Logistics (SGA/WMS).
𝗠𝗔𝗦𝗦𝗜𝗩𝗘 𝗣𝗥𝗢𝗖𝗘𝗦𝗦𝗜𝗡𝗚: Expert use of BULK COLLECT and FORALL to maximize performance.
𝗖𝗟𝗢𝗨𝗗 & 𝗕𝗜 𝗠𝗜𝗚𝗥𝗔𝗧𝗜𝗢𝗡: Transposition of transactional logic to Snowflake through Dimensional Modeling and Star Schema.
💼 𝗙𝗥𝗘𝗘𝗟𝗔𝗡𝗖𝗘 𝗦𝗘𝗥𝗩𝗜𝗖𝗘 𝗠𝗢𝗗𝗔𝗟𝗜𝗧𝗜𝗘𝗦 (𝗕𝟮𝗕 𝗶𝗻 𝗦𝗽𝗮𝗶𝗻):
Agile, remote, and independent onboarding, without corporate bureaucracy:
𝗣𝗘𝗥𝗙𝗢𝗥𝗠𝗔𝗡𝗖𝗘 𝗔𝗨𝗗𝗜𝗧𝗦: Diagnosis and urgent resolution of system failures.
𝗣𝗟/𝗦𝗤𝗟 𝗦𝗨𝗣𝗣𝗢𝗥𝗧, 𝗗𝗘𝗩𝗘𝗟𝗢𝗣𝗠𝗘𝗡𝗧 & 𝗘𝗩𝗢𝗟𝗨𝗧𝗜𝗢𝗡: Independent technical coverage in complex Packages, Stored Procedures, and Triggers.
𝗟𝗘𝗚𝗔𝗖𝗬 𝗠𝗜𝗚𝗥𝗔𝗧𝗜𝗢𝗡 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗦 𝘁𝗼 𝗦𝗡𝗢𝗪𝗙𝗟𝗔𝗞𝗘: Turnkey transposition of transactional logic and ETL flows.
𝗗𝗜𝗠𝗘𝗡𝗦𝗜𝗢𝗡𝗔𝗟 𝗠𝗢𝗗𝗘𝗟𝗜𝗡𝗚 𝗳𝗼𝗿 𝗕𝗜: Design of optimized structures to accelerate analytical reporting speed.
Spanish
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- Accenture EspañaFreelance Data Consultant | PL/SQL & Cloud Migrations SpecialistBANKING AND INSURANCEFebruary 2026 - Today (6 months)Migration of a legacy data architecture based on Oracle and Host systems to a modern analytical platform in Snowflake, with a complete redesign of the data model to adapt it to a layered architecture and dimensional modeling.• Definition of layered data architecture (Staging, Base, Business)• Data migration and integration from Host and Oracle (PL/SQL) systems to Snowflake• Data transformation and standardization: naming conventions, typing, and optimized structures• Construction of dimensional models (Star Schema) for analytics and reporting• Performance and cost optimization in Snowflake (FinOps, query tuning, warehouses)• Collaboration with business for functional definition of data models
- AccentureSenior Oracle PL/SQL Developer AnalystBANKING AND INSURANCEFebruary 2024 - February 2026 (2 years)Oviedo, SpainFINREP financial regulation project for a banking client, focusing on the maintenance, evolution, and support of regulatory reporting processes.· Technical leadership of the Oracle part: coordination of a team of 5 people, task distribution, and quality control of deliverables· Active participation in client meetings: presentation of solutions, expectation management, and resolution of high-impact incidents· Preparation of estimates and sprint planning in collaboration with the management team· Development and optimization of PL/SQL procedures in critical Oracle environments with strict regulatory requirements· Analysis of regulatory requirements (EBA/FINREP) and translation into technical solutions within the existing data model
- FreelanceFreelance Data Consultant | PL/SQL & Cloud Migrations SpecialistBANKING AND INSURANCEJanuary 2023 - Today (3 years and 7 months)Specialization in data engineering, analytical performance optimization, and transition of legacy data infrastructures to modern Cloud environments.Key milestones and responsibilities:• Data Migration and Re-architecture: Analysis and reverse engineering of complex business logic encapsulated in legacy Oracle systems (Packages, Stored Procedures, Functions, and Triggers) for subsequent technical transposition and optimization in modern Cloud platforms (Snowflake Data Platform).• Dimensional Modeling and Storage: Design and construction of data structures oriented towards business analytics (Data Warehouses and Data Marts), applying dimensional modeling methodologies, Star Schemas, and Snowflake schemas, and managing fact and dimension tables (SCD).• Database Performance Tuning: Advanced diagnosis, execution plan analysis, and rewriting of highly complex SQL queries and PL/SQL scripts, optimizing massive Batch processes and drastically reducing processing times.• Efficient ETL/ELT Processing: Development of bulk data loading flows using advanced database techniques (batch processing, BULK COLLECT / FORALL collections) ensuring the integrity, consistency, and validation of migrated data.• Comprehensive Data Project Management: Technical leadership from requirements gathering and source system analysis to the deployment of final analytical solutions ready for exploitation in Business Intelligence tools.
Recommendations
Be the first to recommend Adrian
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Professional Certificate Level 3 Web Application ProgrammerCFO OVIEDO2018
- SSCE0110 Teaching of vocational training for employmentCARAC SIGLO XX, SL2025Durante esta formación he participado en actividades prácticas de diseño de acciones formativas, simulación de clases, uso de plataformas de formación online y dinámicas de grupo. También he colaborado con compañeros en la creación de recursos didácticos y en la aplicación de técnicas de evaluación. Ha sido una experiencia muy enriquecedora que me ha permitido mejorar mis habilidades como futuro/a formador/a.
Certifications
- Oracle Cloud Infrastructure 2025 AI Foundations Associate (1Z0-1122-25)Oracle2025
- IFCT163PO ARTIFICIAL INTELLIGENCE APPLIED TO BUSINESS (250h)SEPE2025