Freelancer profile translated to English.
Back to original languageAbout Hans
Data Architect with strategic vision to align data architecture with business objectives and deep technical knowledge in various data platforms, proactive and committed to the projects entrusted to me, with over 20 years of professional experience in systems, leading a software factory and also working as a Solutions and Infrastructure Architect. My experience covers the design and implementation of robust and scalable data architectures, in addition to my expertise as an ORACLE Senior administrator and developer and other databases such as Sybase ASE, Microsoft SQL, MongoDB Atlas, etc. I implement on-premise and on-cloud solutions and infrastructures in AWS, Azure, and Google Cloud. I am an expert in DevOps and continuous integration (CI/CD) and act as a Tech Leader in Java, .NET, Python languages with their respective frameworks. I can work 24x7x365 for projects that require it.
Spanish
Native or bilingual
English
Conversational
Can work on-site
Madrid (up to 50km)
Experience
- Capgemini Invent SpainSubject Matter ExpertSOFTWARE PUBLISHINGSeptember 2023 - December 2024 (1 year and 4 months)Madrid, SpainCapgemini hired me through MALT, assigning me to their client Allfunds Bank as a software and database specialist for the FLASH system (Java, Linux SH, Sybase ASE), in various projects such as:- Migration of FLASH banking data (Sybase ASE) to IBM Host- Review and tuning of critical database processes: achieving an average reduction of 80% in time and resource consumption- Review of obsolete components of the FLASH system: Identifying unused web system options for deactivation, deprecating Sybase ASE procedures and Java objects (back and front)- FLASH ICCREA - UCITS Agent Banking Project: Designing and creating the data model for new Agent Banking UCITS, which receive information from distribution banks and SGR UCITS regarding financial transactions made by their investors
- BitMinds Consultors SACData Architect (automotive sector experience)TECHJune 2012 - January 2022 (9 years and 7 months)Lima, PeruAs a Data Architect, I led the improvement of the Workshop Load and Service Control System for a consultancy serving major automotive chains in Latin America. I analyzed data from over 1000 vehicles/month for a year to optimize operations.I used Power BI to extract, transform, and model data, creating interactive dashboards that visualized service frequency, inventory turnover, service times, and customer satisfaction. These dashboards were integrated into the web system for continuous monitoring.With Python (pandas, scipy.stats), I performed advanced statistical analyses: hypothesis testing (failures by supplier) and A/B testing (reminder strategy significantly reduced no-shows, improving appointment scheduling).I also analyzed:Inventory optimization by demand (model/year).Improvement of efficiency by comparing repair times (reducing express service times).Evaluation of marketing campaigns with A/B testing (optimizing response).Customer satisfaction analysis (identifying key factors for improvements).My experience in data science (Power BI for visualization, Python for analysis) enabled operational optimization, efficiency improvement, marketing evaluation, and enhancement of the customer experience in the automotive sector, positively impacting profitability and growth.
- BitMinds Consultors SACSenior Python ETL Developer (Retail / Automotive experiences)TECHJune 2012 - January 2022 (9 years and 7 months)Lima, PeruETL for Data Warehouse in Home Appliance Retail (Python)As a senior ETL developer, I designed and led the implementation of a robust and scalable data pipeline architecture using Python and Apache Airflow for our home appliance retail client. I integrated data from online and offline sales, POS systems, and CRM, using pandas for efficient manipulation, sqlalchemy to connect to PostgreSQL and MySQL databases, requests for external APIs (e.g., geolocation), and boto3 for AWS S3. I optimized performance for large volumes through partitioning and parallelization, implemented complex transformations to calculate key KPIs (margin, turnover), ensured quality with validations (cerberus), and configured monitoring with Python logging. I ensured integration with BI tools (Tableau, Power BI) and mentored the junior team.ETL for Customer Data Platform in Automotive (Python)As an ETL technical lead in an automotive company, I designed a flexible and scalable pipeline for a Customer Data Platform (CDP) using Python, Apache NiFi, and Python scripts. I ingested data from dealership management systems (DMS), digital marketing platforms (Adobe, Salesforce), customer service, and various sources (CSV/JSON, REST APIs). I managed privacy (of personal data) through anonymization, implemented record deduplication and reconciliation with petl and dask for large volumes, and built the data model in the CDP. I integrated the CDP with marketing and CRM systems, resolved complex technical issues, and led the team's technical decisions.
Recommendations
Be the first to recommend Hans
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
- Systems TechnicianLima - PERU1989Analista Programador para Mainframe y AS400
- Systems and Computer EngineeringLima - PERU2000Ingeniero profesional en Sistemas Computacionales