Industrial Engineer, Data Analyst with extensive experience in analysis and management of all types of data in SQL, Power Bi, Excel, Python, R. As well as integrated management systems based on ISO 9001, ISO 14001, ISO 45001 standards.
Development of a store procedure in SQL server for the optimization of data processing when connecting to Power Bi, creation of dataflow and dataset for the optimization of data extraction and its standardization. Develop different boards for decision making "Dashboard" in different languages DAX and M in Power Bi, Manipulation, cleaning and analysis of data with more than 10 million records
Major achievementSystematization of real-time reports in SQL serves- Power Bi, Implementation, execution and control of dashboards in Power Bi for decision-making for Latin America and the Caribbean, Creation of KPIs for the manufacturing area and Supply chin, Creation of Doors link
Development of Scripts "queries and subqueries" in SQL server for the optimization of data processing when connecting to Power Bi Develop Different boards for decision making "Dashboard" in different in DAX and M language in Power Bi Manipulation, cleaning and analysis of data with more than a million records Creation of reports for the different areas of the company Knowledge in Language DAX and M for Power Bi in which they are developed for the dashboards
Major achievement- Systematization of real-time reports in SQL serves- Power Bi - Implementation, execution and control of dashboards in Power Bi for decision making - Migrate SQL databases Server - Database optimization in SQL Server
Development of Scripts "queries and subqueries" in SQL server for the optimization of data processing when connecting to Power Bi Develop Different boards for decision making "Dashboard" in different platforms such as Excel and Power Bi Manipulation, cleaning and analysis of data with more than a million records Creation of reports for the different areas of the company Knowledge in Language DAX for Power Bi in which the dashboards are developed
Major achievementSystematization of reports in real time for the control of personnel in SQL serves- Power Bi - Implementation, execution and control of control panels in Power Bi for decision making - Migrate Excel databases to SQL Server - Excel database optimization