Saltar al contenido principal
Alberto de Armas

Alberto de Armas

Data Analyst | Python, SQL, Tableau, MS Office

Talento
Monterrey, MonterreyMiembro desde 11 de agosto de 2023
·

Contratar a esta persona

Envía una oferta de trabajo directamente a este candidato

Sobre mí

I am a versatile Data Analyst with exceptional analytical and technical expertise. Proficient in MS Office programs, Tableau, Sequel, and Python, I possess a strong foundation in data analysis and visualization. Building upon my degree in mechanical engineering, I bring a unique problem-solving approach to every project.

With great attention to detail, I have developed the ability to use data to uncover valuable patterns to drive informed ideas or decisions. I have great experience pricing and quoting for large-scale projects while keeping myself updated to different market trends. With passion for transforming raw data into tangible outcomes, I am excited to take on new challenges.

Experiencia

DATA ANALYTICS PROJECTS

Real Estate Investment Property Assessment

March 2023 - Present

● Scraped the Zillow webpage using api calls in order to classify investment opportunities in the Miami area

● Assembled data frames using Pandas library with Python to organize the Zillow data ready for communication

● Used machine learning sk-learn library to use linear regression models in order to identify future potential market trends

● Visualized the data using Tableau to showcase ndings in the clearest and most appealing form possible

Kickstarter Success Initiative

● Created a metric for projects to be successful on kickstarter for every category

● Analyzed all kickstarter categories separately to identify plausible goals for crowdfunding that are not a stretch

● Compared successful and unsuccessful projects with project duration to identify a realistic time to have a successful project in each category

Iowa Liquor Store Marketing Strategy

● Explored Iowa Liquor Store database with PostgreSQL to clean and identify the right data for a christmas holiday marketing campaign

● Used the markup of the top products in each category to analyze cost vs prot using SQL aggregate functions and creating a buy 1 get 1

free deal

● Used data visualization to deliver the marketing campaign to higher leadership in a clean and concise manner

PROFESSIONAL EXPERIENCE

Protec Inc, Mechanical / Applications Engineer | Miami, FL July 2022 - December 2022

● Analyzed HVAC commercial opportunities, including 100% outside air rooftop units, VRF systems, pumps, and cooling towers, to increase upsell eorts

● Selected semi-customizable HVAC equipment while assuring key calculations were met for example, tonnage, leaving air temperatures,

relative humidity, and MCA/MOP

● Developed an Excel VBA based quoting algorithm for semi-customizable HVAC equipment to reduce actual quoting time by 80%

● Prepared quotes making sure to use the adequate markup as well as including educated estimate of all costs through the distribution process

Neoris, SoftwareDeveloperIntern|Monterrey,NL May2021-July2021

● Learned and participated in agile working teams, learning in an environment of co-creation, test, and execute

● Prepared a POC (Proof of Concept) for a PayPal pop up window to allow customers to pay without any redirection

● Constructed a path for backend information to reach frontend screens from databases and vise-versa, all through C# API endpoints.

Educación

Certificate in Data Analytics -

  • Skills: PostgreSQL · Tableau · Python (Programming Language) · Microsoft Excel · Microsoft Power BI
University of Miami - Bachelors Degree in Mechanical Engineering

Valoraciones