Federico Martín Paci

Self-motivated Data Engineer with +5 years of experience in warehouse data management an development. 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.

Currently studying best practices of DAMA organization to get better performance of data models, also data governance and metadata management.

• Frubana, Data Engineer, 01/01/22, Present, Develop ETL SQL process, data modeling, in redshift., Create data pipelines (ETL/ELT) with Airflow, AWS Glue, and Python, Develop Python dags and lambda to gather information from different sources, such as S3, API, goggle sheets., 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.
• Eldar, Data Engineer, 05/01/21, 10/01/21, 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., Suggest changes on datawarehouse model, to reduce impact on extraction step.
• BBVA, Data Engineer / ETL Developer, 05/01/18, 05/01/21, 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 clients' product activation, improving client satisfaction, reducing to 0 the complaints with these problems., Developed a CRM-like application in excel, 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.
• Centro Construcciones S.A., Functional administrator of Softland ERP, 05/01/17, 05/01/18, 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.
• ICSA (Ingeniería y Computación S.A.), Functional Analyst of Epicor ERP, 10/01/12, 07/01/17, Gather user requirements and write use case or 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.