Carlos Andres Alvarez
Rincon De La Victoria
Summary
Experienced professional with a strong background in data-related roles including development, administration, and technical support. Skilled in problem-solving and optimizing performance. Capable of managing projects and collaborating effectively with teams. Committed to continuous learning and staying current with industry trends to contribute to organizational success.
Overview
20
20
years of professional experience
Work History
Data Engineer
Ciklum
Malaga
2019 - Current
- Developed and implemented data models, database designs, data access and table maintenance codes.
- Developed Python scripts for extracting data from web services API's, raw external data from financial vendors and loading into Data Lake.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Lake and Data Warehouse.
- Collaborated with data scientists and analysts to understand data needs and implement appropriate data models and structures.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL (Custom APIs and Airflow for orchestation)
- Implemented and optimized big data storage solutions, including Apache Hadoop and Hive databases, to improve data accessibility and efficiency.
- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
- Streamlined data flows from diverse sources using ETL tools, such as Airflow and Apache NiFi.
- Trained non-technical users and answered technical support questions.
SQL BI Developer
Telecom Personal
Cordoba
2007 - 04.2018
- Created SSIS packages to extract, transform and load data from multiple sources into the Data Warehouse.
- Optimized existing ETL processes using SSIS best practices to reduce run times of jobs.
- Identified areas where automation can be implemented and designed automated solutions using scripting languages like Powershell or Python.
- Analyzed existing T-SQL scripts used in ETL processes and identified opportunities for improvement or optimization.
- Deployed reports created in SSRS onto SharePoint sites for easy accessibility by stakeholders across the organization.
- Collaborated with team members in developing logical and physical database designs based on functional requirements provided by business analysts.
- Maintained documentation related to all aspects of Database Design and Development activities like ER diagrams, DDL scripts.
- Designed, developed and maintained complex stored procedures, functions, views, tables and other database objects in T-SQL.
- Developed ad-hoc queries as per user requests providing them with required insights from underlying data structures.
- Automated routine database tasks through scripting, reducing manual intervention and improving productivity.
- Implemented ETL processes using SQL and additional tools to migrate data across different systems.
- Provided technical support and training to end-users on database querying and reporting tools.
Junior Software Developer
Goldis SA
Cordoba
01.2005 - 05.2007
- Designed databases using SQL Server Management Studio.
- Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
- Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
- Developed software for embedded systems, coding solutions for both new installations and in-situ hardware.
Education
System Analyst - Computer And Information Sciences
Universidad Tecnologica Nacional
Cordoba11-2007
Skills
- API Development
- Data Modeling
- Data Migration
- Data Warehousing
- Business Intelligence
- Database Administration
- SQL and Databases
- Database Design
- Relational databases
- Team Collaboration
- Database structures
- Problem-Solving
Languages
Spanish
First Language
English
Advanced (C1)
C1
Technologies and tools
- Python, SQL
- Haddop, Hive, SQLServer, PostgreSql
- Apache Nifi, Airflow, DBT, PySpark, Docker
- GitHub, Octopus for CI/CD.
- Camunda
Timeline
Junior Software Developer
Goldis SA
01.2005 - 05.2007
Data Engineer
Ciklum
2019 - Current
SQL BI Developer
Telecom Personal
2007 - 04.2018
System Analyst - Computer And Information Sciences
Universidad Tecnologica Nacional
Similar Profiles
Ramakanta DasRamakanta Das
Senior Automation QA Engineer at CiklumSenior Automation QA Engineer at Ciklum
Valeria ParkhomenkoValeria Parkhomenko
MARKETING INTELLIGENCE ASSISTANT at CIKLUMMARKETING INTELLIGENCE ASSISTANT at CIKLUM
Anastasiia PomogovaAnastasiia Pomogova
Talent Deployment Partner/HR Specialist at CiklumTalent Deployment Partner/HR Specialist at Ciklum