Federico Paci

• Designed and deployed network infrastructure for a medical clinic (LAN, Wi‑Fi, VLANs, VPN, firewall) ensuring secure, reliable connectivity.
• Collaborated on the implementation of core systems (EHR/EMR, scheduling, billing), coordinating vendors, data migration, and user onboarding.
• Configured identity and access management, backups, monitoring, and incident response procedures with clear documentation.
• Trained staff and provided ongoing support, tracking issues and iterating on improvements.

• Design and develop ETL/ELT pipelines with PySpark.
• Migrate legacy jobs to AWS-based stack, improving scalability, reliability, and maintainability.
• Orchestrate and schedule workflows with Airflow, enforcing SLAs, retries, and alerting.
• Model datasets and define clear data structures and documentation.
• Implement monitoring, logging, and data quality checks; proactively investigate incidents and resolve root causes.
• Optimize Spark performance and storage costs by tuning partitions, caching, and job configurations.
• Collaborate with product, analytics, and business stakeholders to prioritize roadmaps and deliverables.
• Apply engineering best practices: code reviews, CI/CD, IaC, security, and governance.

Stack

• Project to build a new data architecture, considering the different options and strategies such as lakehouse, warehouse, evaluating different technologies to achieve the goal.
• Design ETL(Extract,Transform,Load) tasks data models and for analytics (dimensional models, SCDs), 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 data warehouse and data lake performance
• Keep track of customers’ tickets and issues.

Stack

• Part-time job as SQL Professor at CoderHouse, teaching practical and theoretical classes.
• Strong interpersonal and communication skills, resulting in clear subject matter discussion with students.
• Meet with team 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 technologies to engage students in achieving learning outcomes.
• Researched and selected course texts and supplemental learning materials.

Stack

• 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, Google 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 user connections and permissions on Metabase, Superset, Redash, and Redshift
• Monitor and control data warehouse and data lake performance, keep track of Redshift queue, help clients with query tuning
• Keep track of customers’ tickets and issues.

Stack

• 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 changes made by developers.
  • Suggest changes on data warehouse model, to reduce impact on extraction step.

Stack

• 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 coaching 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 emails integrating different sources, reducing wasted email attempts by 38%
  • Developed a process to fix problems on client’s products activation, improving client satisfaction, reducing complaints by 99% for 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.

Stack

• T-SQL Development, stored procedure, views, functions, and maintenance plans.
• Administration of user profiles and security parameters.
• Document new processes, create user manuals, flow charts.

Stack

• Gather user requirements, write use cases and other documentation.
• Development in Progress 4GL ABL, VB .Net.
• SQL Server administration, maintenance plans, backups and performance tuning.
• Data migration between different systems using SSIS.
• T-SQL development, stored procedures, views, functions.
• Create reports, dashboards in SSRS and Crystal Reports.
• Collaboration with other teams to ensure process development can be certified in ISO 9001: 2008, ISO 14001: 2004 and OHSAS 18001: 2007.
• QA of developed solutions.

Stack