Elvis Ramirez

• Collaborated with stakeholders providing information to support decision-making processes
• Create new tables with aggregated data to satisfy Business necessities.
• Worked in the BAC Credomatic project to update the Enterprise DWH
• Designed, maintained, and implemented, data pipelines and ETL processes from different data sources and ingested them into a DWH environment and troubleshot issues with ETL processes

Skills: Data Warehousing · Data Engineering · Data Integration · Data Analytics · data pipelines · Business Intelligence

Tech used: ETL Tools, Agile Methodologies, Extract, Transform, Load (ETL), GitHub, SQL Server Integration Services (SSIS) · SQL Server Management Studio · Azure DevOps · Scrum · Kanban · JIRA · Confluence · Big data · Enterprise DataLake · Visual Studio Data Tools · Python · Microsoft Azure · Microsoft SQL Server

Microsoft Azure · SQL Data Tools · Microsoft SQL Server · Business Inteligence

• Worked closely with backend and frontend teams and client to defines the goals of a migration project.
• Executed internal QA & and Manual test cases
• Updated and migrated reports using MS Reporting Services
• Worked as DataOps (monitoring and orchestration Pipelines)

Skills: DataWarehousing · Data Engineering · Data Analytics · DataOps · Business Intelligence

Tech used: SSRS, Data Tools, AWS RDS (MySQL), GitHub, Scrum, Jira, Datadog, Airflow, Docker

• Designed, build, maintained, and executed data pipelines by gathering data from different sources and fed in the datalake environments (DEV, UAT, PRD)
• Designed, Build, and maintained, analytical data structures and troubleshot ETL processes
• Worked as DataOps, Orchestration/Monitoring Data pipelines• Designed, build, maintained, and executed data pipelines by gathering data from different sources and fed in the datalake environments (DEV, UAT, PRD)

• Designed, Build, and maintained analytical data structures and troubleshot ETL processes

• Worked as DataOps, Orchestration/Monitoring Data pipelines

Skills: Team leader · Data Warehousing · Big Data Engineering · Data Integration · Data Analytics · Business intelligence, Extract, Transform, Load (ETL)

Tech used: Hadoop Ecosystem, Enterprise DataLake, HDFS · Sqoop ·Hive, Microsoft Power BI · SQL Data Tools · · Microsoft SQL Server · data pipelines, GitHub, SQL Server Integration Services (SSIS) · SQL Server Management Studio · Scrum · Kanban · JIRA · Confluence · Big data

SStudio · Scrum · Kanban · JIRA · Confluence · Big data · ··

, , ,

• Elaborated informative, and meaningful dashboards to support business decision-makers
• Worked closely with the regional team of Data Scientists, Data Engineers, and Developers to design a solution using DWH, BI, and Big Data Technologies for different Business Units
• Collaborated with the integration of different data sources (customer profile, payment, consumption, incomes, data, and web profiling, among others) to get 360 customer vision

Skills: Data Warehousing · Data Engineering · Data Visualization · Data Integration · ETL Tools · Extract, Transform, Load (ETL) · Hive · Metodologías ágiles · GitHub · Herramientas ETL · Enterprise DataLake · Hadoop Ecosystem · HDFS · Sqoop · Apache NiFi · Microsoft Power

BI · Apache Spark · Tableau · Big Data Engineer · Business Inteligence

• Analyze data to identify changes and respond to questions for trends, patterns, and outliers with it.
• Elaborated reports and dashboards for different business units and industries. (Sales, marketing, Operations, Financial, Logistics, among others).
• Present information generated from data to clients and managers that helps in making decisions
• Worked with business units to gather requirements in order to design DWH architectures
• Trained technical users on tableau server and strategic users on tableau desktop for data visualization

Skills: Team leader · Data Warehousing · Data Visualization · Data Integration · ETL Tools · Extract, Transform, Load (ETL) · Data Analytics · Herramientas ETL · SQL Server Integration Services (SSIS) · SQL Server Management Studio · Visual Studio Data Tools · Tableau · Microsoft Azure · SQL Data Tools · Microsoft SQL Server · Business Inteligence

-Support and data engineer, Datum (Oracle Partner)
El Salvador — Jan 2016 - Dec 2016

• Designed a Proof-of-Concept project on Microsoft Technologies (Azure, SQL Server)
• Provided technical support to oracle databases and Microsoft Projects.

SysAdmin & Business Intelligence Engineer, Dizucar
El Salvador — Oct 2009 - Dec 2015

• SQL Server Admin, Analysis, Design, Deploy, and troubleshooting OLAP cubes in MSAS | Reports in MSRS | ETL packages in MSIS
• Sys admin (VM and physical) DNS, DHCP, AD, FS, Security