Roberto Regalado
Data Engineer/Analyst
Huixquilucan De Degollado, México,MEX
Summary
Accomplished Data Engineer with a proven track record at Takeda, enhancing data analysis and visualization through ETL development and data modeling. Demonstrated adaptability and communication skills, significantly improving data-driven decision-making processes. Specialized in transforming complex datasets into actionable insights, ensuring optimal data management and analysis.
Overview
9
9
years of professional experience
Work History
Data Engineer
TCS
06.2024 - Current
- Querying data from Cosmos datasets using SCOPE language for data analysis
- Pipeline maintenance from Data Factory
- Code debugging for pipelines that threw an alert (C#)
Data Analyst / Engineer
Takeda
04.2023 - 06.2024
- Python for data wrangling using Pandas, Openpyxl among others
- Creation of databases within Python to store and connect through Power BI using SQLite3 library.
- Design and develop efficient ETL processes for data ingestion, integration, and analytics
- Design and implement data models, and databases for data storage and analysis
- Design SQL queries for proper BI and data analysis
- Creation of Power BI dashboard using multiple sources, including Azure Databricks, SQL Server, Jira, and Sharepoint.
- Data cleaning using Power Query and features of the M language to clean, transform, and load data.
- Create measure using DAX for calculations and KPIs as required.
- Creation of analytical reports in applications where an APM tool has been implemented to see its history in terms of critical incidents before and after said implementation.
- Drive the design and build of visualizations and analytics.
- Understand data management processes across the pharma functions.
- Define optimal data models to support the consumption of information.
Data Visualization (Power BI) and ITSM Specialist
Linde
02.2021 - 04.2024
- Creation of Power BI dashboard using multiple sources, including Tableau Datasets, SQL Server, Sharepoint, etc.
- Data cleaning using Power Query and features of the M language to clean, transform, and load data.
- Create measure using DAX for calculations and KPIs as required.
- Co-ordinated IT Directors / Managers and Application Owners to ensure compliance in such as: CMDB, applications inventory, IT Asset Management in the American continent.
- Responsible for working development and implementation of policies, procedures (SOPs), and QA Manual in all ITSM-related processes.
- Used HPSM, Power BI and Excel reporting to analyze trends of major incidents, identify a high level of root cause for the major incidents, and to find ways to automate tasks to reduce ticket volume in Level 1 support teams.
- SOX control testing for App Change Management, Password Settings, User Access Request Management, User Access Review, Developer Prod write access, and Leavers Process for applications such as Hyperion HFM/HP.
- Creation of analytical reports regarding ITAM, Asset Management and most likely all ITIL metrics all within Power BI.
- Drive the design and build of visualizations and analytics.
- Understand data management processes across Linde functions.
- Define optimal data models to support the consumption of information.
- Organize, plan, lead and control the activities of governance, ITSM, and asset management for all America's regions.
- Maintenance and support of local applications in tasks such as data insertion, Store Procedures execution, updates on tabled for requested changes in .NET and SQL Server.
- Coordinate with IT Directors and Application Owners to develop and implement the Business Sevice Level Description (BSLD) for Cat 1 applications.
Data Visualization (Power BI) - ITSM Incident and
CompuCom
08.2019 - 02.2021
- Engage directly with escalation groups to provide incidentresponse.
- Perform a weekly and a monthly deck with the status of all incidents to high-level internal leadership and our clients.
- Work directly with Service Desk Managers and Directors of both accounts to provide initial incident response.
- Creation of Problem Records to either find a root cause analysis or to prevent a major issue to happen again.
- Monitor the performance of project team members, providing and documenting feedback.
- Prepare project status reports by collecting, analyzing, and summarizing information and trends.
- Creation of analytical reports regarding ITIL metrics.
- Drive the design and build of visualizations and analytics via Power BI.
- Define optimal data models to support the consumption of information.
FOC Operations Admin POC
CompuCom
02.2018 - 08.2019
- Support to Branch Processors, Status of servers, Advanced troubleshoot.
- PC refreshments for SunTrust bank users.
- Triage of incidents that are assigned to dispatch.
SunTrust Service Desk 1.5 Analyst
CompuCom
09.2015 - 02.2018
- Second Level support of service desk tickets.
- Printers and Branch processors advanced support.
- Training and KB’s support
- Dedicated to BlackBerry support.
- Project task of issues impacting SunTrust, engaging internal teams to get resolutions.
Education
Master of Project Management
Universidad Tecnológica De México
Mexico City10.2022
Software And Networks Engineering
Universidad Tecnológica De México
Mexico City12.2020
Skills
ETL development
Data Modeling
Databases
Data Analysis
Data Wrangling
Adaptability
Communication Skills
Languages
English
Upper intermediate (B2)
French
Intermediate (B1)
Timeline
Data Engineer
TCS
06.2024 - Current
Data Analyst / Engineer
Takeda
04.2023 - 06.2024
Data Visualization (Power BI) and ITSM Specialist
Linde
02.2021 - 04.2024
Data Visualization (Power BI) - ITSM Incident and
CompuCom
08.2019 - 02.2021
FOC Operations Admin POC
CompuCom
02.2018 - 08.2019
SunTrust Service Desk 1.5 Analyst
CompuCom
09.2015 - 02.2018
Master of Project Management
Universidad Tecnológica De México
Software And Networks Engineering
Universidad Tecnológica De México
Similar Profiles
MOHAMMAD SAJID ABBASMOHAMMAD SAJID ABBAS
System Engineer at TCSSystem Engineer at TCS
Himabindu YedlapalliHimabindu Yedlapalli
DaVita Kidney Dialysis , Release Manager at TCSDaVita Kidney Dialysis , Release Manager at TCS
ALEEM ULLAH KHANALEEM ULLAH KHAN
MIM (MAJOR INCIDENT MANAGER) at TCSMIM (MAJOR INCIDENT MANAGER) at TCS
Rajashree RamakrishnanRajashree Ramakrishnan
Technical Lead at TCSTechnical Lead at TCS
Carmen Guadalupe Mondragón HuertaCarmen Guadalupe Mondragón Huerta
Professor of Medicine at FESI Universidad Nacional Autónoma De MéxicoProfessor of Medicine at FESI Universidad Nacional Autónoma De México