About Me
(Last Updated: 05th OCT 2024)
- I’m Federico Paci and I’m living in Mendoza, Argentina.
-
My interests are around the world of Data such as Data Engineering, Data Modeling, Data Orchestration
-
My CVs:
– CV English
– CV Spanish - I’m a self-motivated Data Engineer with +5 years of experience in data warehouse, ETL Development, data management. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing comprehensive understanding of warehouse operations and documentation needs.
Skills
Cloud Infrastructure
_Amazon_Web_Services-%2B3-blue?style=flat-square&logo=amazonaws&logoColor=%23232F3E&labelColor=%23E6E6E6){kind=icon}
Scripting
Data Bases
Orchestration
_SQL_Server_Integration_Services-%2B4-blue?style=flat-square&logo=microsoftsqlserver&logoColor=%23CC2927&labelColor=E6E6E6){kind=icon}
Informatica_Power_Center-%2B1-blue?style=flat-square&logo=informatica&logoColor=%23FF4D00&labelColor=%23E6E6E6){kind=icon}
Data Processing
Documentation
Version Control System
Containers
Experience
- Project to build a new data architecture, considering the different options and strategies such as lakehouse, warehouse, evaluating different technologies to achieve the goal.
- ETL(Extract,Transform,Load) tasks development, maintaining data integrity and verifying pipeline stability. Stack: Snowflake, Redshift, Matillion, AWS Glue, Python, SQL, Dremio, Coalesce
- Develop Python scripts to get data from different sources, such as S3, API, Parquet files, etc
- Monitor and control datawarehouse and datalake performance
- Collaborated on ETL(Extract,Transform,Load) tasks development,maintaining data integrity and verifying pipeline stability. Techs: Airflow, AWS Glue, SQL, Python
- Develop Python dags and lambda functions to gather information from different sources, such as S3, API, goggle sheets
- Evaluated various tools,technologies,and best practices for potential adoption in company’s data engineering processes.
- Generate insights and dashboards with Metabase, Superset, Redash and Looker
- Administer users connections and permissions on Metabase, Superset, Redash, and redshift
- Monitor and control datawarehouse and datalake performance, keep track of redshift queue, help clients with query tuning
- Keep track of customers’ tickets and issues.
- Strong interpersonal and communication skills, resulting in clear subject matter discussion with students.
- Meet with teams members to discuss different approaches, lessons and future learning objectives.
- Encouraged class discussions by building discussions into lessons, actively soliciting input, asking open-ended questions and using techniques to track student participation.
- Used different technology to engage students in achieving learning outcomes.
- Researched and selected course texts and supplemental learning materials.
- Database Migration project, from DB2 to MySQL.
- Design MySQL DDL based on current DB2 database
- Generate ETL process for development stage, in order to test cases and change made by developers.
- Suggest changes on datawarehouse model, to reduce impact on extraction step.
- Develop ETL process, data modeling, and data pipelines in different tools such as SSIS SQL Server Integration Services, Teradata SQL, IPC PowerCenter.
- Develop end-to-end process or solutions, from gathering user requirements, creating documents and developing SQL codes and couch final users.
- Query tuning and database performance analysis.
- Python development with Google Apis.
- Coach coworkers in data warehouse model, SQL queries, and help them to solve performance issues.
- Project and improvements proposed:
- Scoring of email integrating different sources, reducing wasted emails attempts in 38%
- Developed a process to fix problems on client’s products activation, improving client satisfaction, reducing 99% the complaints with these problems.
- Developed a CRM-like application, with connection to different data sources to reduce time consuming tasks.
- Developed a process to pay different gifts to clients and avoid conflicts between commercial campaigns and budgets.
- T-SQL Development, stored procedure, views, functions, and maintenance plans.
- Administrations of user profiles and security parameters.
- Document new process, create user manuals, flow charts.
Functional Analyst
Developer of Epicor ERP
October 2012 - July 2017
- Gather user requirements and write use case and other documentations.
- Development in Progress 4GL ABL, VB .Net.
- SQL Server administration, maintenance plans, backups and performance tuning.
- Data migration between different system using SSIS.
- TSQL development, stored procedures, views, functions.
- Create reports and dashboards on SSRS and Crystal Reports.
- Collaboration with other teams to assure process development can be certified in ISO 9001: 2008, ISO 14001: 2004 and OHSAS 18001: 2007.
- QA of developed solutions.
Education
B.Sc. System Engineering
Mar. 2017 - 2021
Studying System Engineering with focus on databases
Related courses
Data structures and algorithms, modern information retrieval, design of algorithms, probability and statistics, discrete structures.
Under Degree Industrial computing technician
Sep 2017 - Sep 2022
High School
High school diploma on electric technician