Business Intelligence Consultant

• Jul 2023 - Present

SQL Developer

• Jun 2023 - Jul 2023

Construction of sql queries for sql server database with help of T-SQL, development of functions, views, stored procedures for development of regulatory reports for banking sector. Construction of sql queries for sql server database with help of T-SQL, development of functions, views, stored procedures for development of regulatory reports for banking sector.

SQL + R Developer

• Feb 2023 - Apr 2023

Data extraction from DWH builded in SAP HANA and Big Query to validate indicators with respect of control data of business with help of SQL queries and Python and R scripts. Data extraction from DWH builded in SAP HANA and Big Query to validate indicators with respect of control data of business with help of SQL queries and Python and R scripts.

Business Intelligence Consultant

• Oct 2021 - Feb 2023

Creation and maintenance of Microstrategy and Power BI reports consuming data from the client's DWH, as well as creation of queries validation and documentation of dashboards for their migration to production environment. Creation and consumption of dataflows for Power BI dashboards and creation of public and schema objects, datasets and smart cubes for later use in Microstrategy dashboards. Assistance to training given by ENKI in Pentaho Data Integration and Big Data with Hadoop and Spark. Creation and maintenance of Microstrategy and Power BI reports consuming data from the client's DWH, as well as creation of queries validation and documentation of dashboards for their migration to production environment. Creation and consumption of dataflows for Power BI dashboards and creation of public and schema objects, datasets and smart cubes for later use in Microstrategy dashboards. Assistance to training given by ENKI in Pentaho Data Integration and Big Data with Hadoop and Spark.

Web Developer

• Dec 2020 - Oct 2021

Self-managing company website development with PHP language, Javascipt and laravel v.8 framework, requirements survey with the different departments involved (systems, marketing and quality); project deployment on shared VPS (https://www.mtinter.com.mx) and module development custom for ERP Odoo version community v14 with language Python as well as report development, information migration of previous system developed with Visual Fox Self-managing company website development with PHP language, Javascipt and laravel v.8 framework, requirements survey with the different departments involved (systems, marketing and quality); project deployment on shared VPS (https://www.mtinter.com.mx) and module development custom for ERP Odoo version community v14 with language Python as well as report development, information migration of previous system developed with Visual Fox

Software developer JR

• Oct 2019 - Dec 2020

Development and adjust of ERP software (IMAS) and other company products (management software for pymes SIMON), programming with VB6 language, queries, migrations and database tuning with SQL Server 2008 engine, as well as report generation with Crystal Reports, integration of DIBAL scales with the ERP system and end-user training. Development and adjust of ERP software (IMAS) and other company products (management software for pymes SIMON), programming with VB6 language, queries, migrations and database tuning with SQL Server 2008 engine, as well as report generation with Crystal Reports, integration of DIBAL scales with the ERP system and end-user training.

Drawer

• Jan 2012 - Oct 2019

Fire systems drawing, pipe routes modification, plans of wiring diagrams and material quantification based on plans. Preventive and corrective maintenance of all computers, optimization of equipment communication through wLAN network, integration of printers and plotters to network by TCP/IP protocol. Fire systems drawing, pipe routes modification, plans of wiring diagrams and material quantification based on plans. Preventive and corrective maintenance of all computers, optimization of equipment communication through wLAN network, integration of printers and plotters to network by TCP/IP protocol.