Jeferson Stiv Argueta Hernandez

Professional Experience

• Build complex data models using ELT tools such as Snowflake and dbt.
• Build macros and jobs to automate pipelines on dbt.
• Build data extraction connections on Fivetran.
• Building a data lake on AWS S3 with data pipelines with Python Scripts.
• Development of robust and scalable scripts with SQL Scripts on Snowflake for data cleaning.
• Worked with Data Science Teams and ML Engineers, finding the best solution to requests and communicating action plans to stakeholders
• Each project has been managed with Scrum.
• Data Modeling & Data Mining with big volume data sets.

• Build complex ETLs for loading large volumes of data in AWS using aws services and other tools such as spark and python.
• Process automation with Airflow and other tools.
• Development of robust and scalable scripts for data extraction and data cleaning.
• Process Migration and Construction of Data Warehouse On-Premise to AWS Cloud, implementing Python scripts in Docker containers and AWS services such as S3, ECS, EC2, Lamda, Glue, Athena, Redshift, among others.
• Building a data lake on AWS S3 with complex data pipelines with Pyspark and Python Scripts.
• Performing integrations to Redshift as Data Warehouse using ETL and ELT tools such as Athena, Python scripts and Airflow as orchestrator.
• Worked with a data streaming process with Apache Kafka and AWS Kinesis to build real time analysis.
• Data Modeling & Data Mining with big volume data sets.
• Worked with Data Science Teams and ML Engineers, finding the best solution to requests and communicating action plans to stakeholders.

• Build complex data pipelines with Python Scripts and SSIS.
• Process automation with Python Scripts.
• Developing Data Prediction Models using data mining techniques, creating Business Indicators and automating reports and processes with the help of SSRS, SSIS, SQL Server and Tableau.
• Leading projects for the creation of Business Indicators and automation of reports and processes teams to find the best solution to requests and communicate action plans to stakeholders.
• Data Modeling & Data Mining.
• Performing integrations to Data Warehouse using ETL and ELT tools such as SSIS and Python Scripts.
• Each project has been managed with Scrum.

• Build web application based on .Net Framework, which provides an internal process management system, thus speeding up delivery times and reports, allowing stakeholders to be informed how to speed up their delivery times, replacing the old methodologies allowing to align the business requirements to the technology.
• Planned and managed the phases of the development life cycle of the software.
• Analized feedback data provided from end users.
• Creating Business Indicators and automating reports and processes with the help of SSRS, Crystal Reports and PowerBi.
• Each project has been managed with Scrum.
• User assistance and support.