Alejandro Pinto Email & Phone Number

Bogotá, Capital District, Colombia

Monitoring KPI'sCreating and updating reports in PowerBIUsing advanced excel to report metrics to the clientUpload database in SQL provided by the client in WinSCPCreating scripts in python to reduce time in tasks

Colombia

I leverage data to drive efficiency, boost sales, and optimize inventory. Utilizing tools like Azure, Siigo, and Power BI, I focus on demand forecasting, supplier performance, and process improvement. I analyze customer segments and purchasing behavior to tailor marketing strategies and identify upselling opportunities.I create interactive dashboards for real-time insights and automate reporting to streamline processes. I evaluate product performance, manage product lifecycles, and optimize pricing strategies. Through competitor benchmarking and market trend analysis, I identify growth opportunities. Key KPIs I manage include inventory turnover, profit margins, customer retention rate, order cycle time, marketing ROI, and sales conversion rate.By transforming data into actionable insights, I support informed decision-making and sustainable business growth.

Bogotá, Capital District, Colombia

Implemented notebooks to extract and clean data from Microsoft Dynamics 365 CRM in the Azure cloud environment.Designed and optimized database structures in Azure to enable efficient queries and analysis of large datasets.Connected Azure with PowerBI to create dynamic visualizations and interactive reports, facilitating data-driven decision-making based on solid and up-to-date information.

Duitama, Colombia

Provided personalized feedback to students on their performance using data analysis collected during the scholar year. Then, implemented strategies to support struggling students and challenge high-achievers.Stayed current with advancements and applets in physics education, and incorporated them into classroom practices and curriculum development.Prepared to students of eleventh grade to Colombian scholastic aptitude test in the fields of electromagnetism, thermodynamics, waves and mechanics.

Bucaramanga, Santander, Colombia

Physics tutor in MIDAS program

Bucaramanga, Santander, Colombia

DFT calculations of like-perovskite Ruddelsen-Popper material Sr2(Ta, Nb)O3N, implemented in VASP. Research group (FICOMACO)Performed post-processing of data with the codes VASPkit and Phonopy to analyze the electronic and phononic structure of materials.Analyzed structural energy with Python libraries such as Pandas,NumPy,Seaborn, and Matplotlib, as well as the PyProcar library. Used software such as Grace and PyProcar for electronic and phononic structure analysis.Developed and optimized computer codes in Python to perform simulations on supercomputers, achieving significant improvements in computational efficiency and data analysis.Created reports using the markup language LaTeX.Presented research findings at the Materials Research Society (MRS) and contributed to the dissemination of research results through scientific outreach activities.Consolidated databases of bibliographic reviews.Prepared research projects for internal calls from UIS and MinCiencias Colombia.Facilitated effective communication among team members by leading research group meetings

Master'S Degree, Statistics

Bachelor Of Science - Bs, Physics, Physicist

Theoretical and Computational Condensed Matter Physics