SQL
For ad-hoc reports and dashboards, use views and CTEs for custom queries.
About
I have a track record of creating high-value dashboards and reports using tools like MSSQL, Tableau, Power BI, Python, and Excel. In my role, I have monitored crucial KPIs, with a financial approach that helps the company make the best decisions from this perspective, contributing to operational excellence. In my previous roles, I have leveraged various tools to produce top-quality panels and reports for operational and financial KPIs, emphasizing process automation to drive insights and improve productivity.
Skills:
Power BI & Tableau
For the development of dashboards to monitor key KPIs.
Python
ETL and data cleaning, using Pandas, NumPy, and libraries like scikit-learn and StatsModels for data analysis and predictive modeling
Excel
Experienced in creating ad-hoc reports and automating processes using Macros
Contact:
Phone:+57 3153239201 Mail:johnsebas2@gmail.com
Experience:
Business Intelligence Analyst - Teleperformance
- Developed and applied linear and logistic regression models using Python to predict key business metrics and customer behaviors, improving strategic decision-making and operational efficiency.
2022-2024
Reporting Analyst - Logfor
- Utilized tools like Excel to create high-impact reports, enabling the monitoring of critical KPIs.
- Assist in the implementation of Strategic systems, driving organizational growth.
2021-2022
Education:
2017-2022
- Business Administration with an emphasis on International Business
Certificates:
2022
2022
2023