Anthony Osorio

Main objectives:

Explore and understand the relationship between the different available data, ensuring its correct context and interpretation. Design and structure robust data models that support key business metrics and KPIs. Ensure the availability of reliable information for the construction of strategic visualizations and analyses.

Activities and responsibilities:

●Data exploration and analysis to identify relationships, dependencies, and business context.

●Optimized data modeling to support metrics, KPIs, and management reports.

●Development of interactive dashboards and visualizations in Power BI aligned with business needs.

●Use of DAX, Power Query, and flat file management for building analytical solutions.

●Data consistency validation to ensure visualizations reflect reliable information.

●Collaboration with business users to gather requirements and translate them into effective data models.

Technologies Used:

Power BI, DAX, Power Query, Excel, SQL

Main objectives:

Analyze trends and conduct data exploration to identify relevant patterns. Design and implement tools and processes that generate useful reports and dashboards for decision-making. Collaborate in results presentation sessions, ensuring clear communication of the team's findings. Participate in strategy definition with leaders, based on insights obtained from analyzed information.

Activities and responsibilities:

●Exploratory data analysis and identification of key business trends.

●Design and development of reports and dashboards with clear, action-oriented information.

●Creation of processes and tools that optimize reporting and information flow.

●Presentation of results in forums and meetings with stakeholders.

●Preparation of reports with strategic insights that support decision-making.

●Collaboration with leaders in data-driven strategy definition.

Technologies Used: PL-SQL, Excel, PowerBI, Tableu, Python

Main objectives:

Support cybersecurity enabler management, coordinating with responsible areas to address observations from the DWH regarding cybersecurity in the DWH architecture. Support DWH maintenance, analyzing data to detect inconsistencies or patterns for correction. Participate in migration projects, performing data modeling activities such as creating information flows.

Activities and responsibilities:

Coordination with project responsible areas for observation resolution. Tracking and control of project incidents. Data analysis for root cause detection of incidents. Information gathering for project input. Maintenance of DWH components. Optimization of ETL procedures and pipelines.

Technologies Used:

PL-SQL, ODI, Pentaho, Putty, winscp, azure repos