Francisco Misael Gallegos - Business Intelligence Consultant, IBM

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

IBMSr. BI & Advanced Analytics Engineer

Oct. 2021 - Feb. 2024Saltillo, Coahuila de Zaragoza, México · RemoteData Engineer under contract. By most recent project: • Technical leading of dashboards migration from Tableau to Power BI for client's Analytics director usage. • Chief-Officer level dashboards development in Tableau. • Data modeling and dashboards development using Tableau and GCP BigQuery in a sustainability project that will help to make better decisions in reducing CO2 emissions around client's global operations. • Dashboards development using Tableau in a HR project to track historical gender parity.

CognizantBI & Data Engineer

Mar. 2021 - Nov. 2021Saltillo, Coahuila de Zaragoza, México · RemotePart of Network Infrastructure global team to track and monitor global network devices status, find unbacked devices, etc. Being involved in data lifecycle from end to end from origin to visualization. Detailed activities: • ETL pipelines development using R programming language with data transformation/cleansing libraries (dplyr, stringr, anytime, lubridate, reshape, jsonlite) and connection-to-source libraries (readxl, odbc, httr, readr) to add new incoming data from multiple sources (databases, files, text, APIs, etc.) • Data pipelines integration to existent data warehouse. • Pipelines maintenance, scheduling and optimization. • Data visualization report development in Power BI and Tableau for multiple client departments. • Development of SQL views. • Migration of data pipelines built in Python to R. • Simple analytics as time series forecasting, etc.

Universidad Autónoma de Coahuila.Research Assistant

Apr. 2019 - Jan. 2021Saltillo y alrededores, México

AccentureBusiness Intelligence Consultant

Feb. 2018 - Mar. 2021Monterrey, Nuevo León, MéxicoBy most recent project: - SSAS and Power BI: development and administration of tabular models and data reports for an International private spirits beverage company (two times same project, different client business unit). - Responsible of administrative technical tasks over global internal dashboards such as improvement and development of new functions over them for company's partner. Developer of new dashboards for internal global use. Also responsible of design and implementation new demo dashboards for internal knowledge with new monthly updates in Power BI. - Responsible of developing data dashboards using Power BI for a multinational computer software company. Including data modeling with DAX and Power Query. - Responsible of developing data dashboards using Power BI for a company in the wine industry. Including data modeling with DAX and Power Query. - Participated as Cloud Developer in Microsoft Azure platform for a company in the wine industry by helping to develop pipelines on Azure Data Factory. I also was assigned to generate quality cases for such Azure Blob Storage, Azure Data Lake Analytics, Azure Data Lake Storage and Data Factory. Analyzing client's requirements, solution's technical design and real time processes. I was assigned to execute solutions to ensure that all requirements were met. - Assigned to code Qlik Mashups so Qlik dashboards could be displayed anywhere outside Qlik Sense (ex. web browsers) using Javascript and Qlik APIs. Also I was responsible for gather Bitcoin and Ethereum transaction data from Blockchain (using Python, Blockcypher and PyCURL). Finally collaborated on code Integration between Telegram Bot API and NLP Engine called Recast.ai, using both such Telegram and Recast.ai APIs and Javascript.

AccentureData & Analytics Intern

Sep. 2017 - Feb. 2018Monterrey Area, Mexico- Helped on a banking company project integrating and modifying R scripts that would be used on Tableau using Rstudio and Rserve. - Assigned to a retail company project to design and develop data workflows on Alteryx Designer in order to tidy up, integrate, transform and clean data over different datasets and sources.