My Projects
I'm thrilled to present a curated collection of projects that reflect my journey and enthusiasm for Analytics and Finance. Each project illustrates that I've utilized my skills to address challenges and pursue innovative solutions. I encourage you to delve into the details and hope they inspire you while showcasing the value I can contribute to any team.
​
Thank you for visiting my portfolio, and I look forward to your feedback and potential collaboration!
This project used creative problem-solving to build predictive models in SAS Enterprise Miner, aiming to understand student academic performance in two Portuguese schools. Based on data from school reports and questionnaires (including grades, demographics, social, and school factors), the goal was to predict which students would achieve above-average final grades in Portuguese. Various models, including decision trees, regressions, and neural networks, were developed following data preprocessing steps like imputation and skewness reduction. Finally, models were compared using the ROC index and Average Squared Error (ASE) to identify the most effective predictive model and key variables.
This project showcased Python machine learning skills by building a Variational Autoencoder (VAE) with Keras/TensorFlow to classify anomalies in computer network data. Initially, the data was imported and split into Benign and Attack datasets. The Benign data was further divided into training and testing sets and scaled using MinMaxScaler. Key steps included setting hyperparameters, defining the VAE's Encoder, Sampling, and Decoder layers, and specifying the loss function (reconstruction + KL Divergence) with an Adam optimizer before training.
​
Following training, the loss curve was graphed, and predictions were made on both Benign and Attack test data. An appropriate anomaly detection threshold was identified through trial and error, guided by graphical observation. This threshold was then formally validated using a suite of metrics including TPR, TNR, FPR, FNR, Precision, F1-Score, and an ROC curve with AUC, aiming to ensure the model accurately classified anomalies.
This project demonstrates SQL skills focused on database optimization and data analysis. It involved writing SQL code to create views, analyze query execution costs, and implement indexes to reduce those costs. Sequential views were also developed using window functions (OVER, PARTITION BY, ROWS BETWEEN) to analyze product-specific data trends over time. The work utilized CREATE OR REPLACE VIEW statements and functions like LAG, SUM, along with standard clauses like WHERE and ORDER BY. Finally, the generated information was analyzed to provide actionable insights.
This project aimed to predict the price of a specific NYSE stock by developing an LSTM (Long Short-Term Memory) model using TensorFlow, leveraging LSTM's strength in sequential data analysis. Stock data was sourced from Yahoo Finance and initially plotted to visualize historical movements. Data preparation involved extracting closing prices, splitting the data into training and validation sets, normalizing it with MinMaxScaler, and reshaping it appropriately for the LSTM model.
​
The LSTM model was built with 100 neurons per layer, compiled using the Adam optimizer, and trained over 50 epochs. Following training, the predicted scaled values were reverted to their actual price scale using the inverse MinMaxScaler. Finally, the model's predictions were evaluated against the real stock prices to assess accuracy, and the results were graphically presented by plotting the predicted prices alongside the historical stock data.
My Certifications
This section highlights key certifications demonstrating expertise in specific domains. A Microsoft Excel certification validates fundamental Excel skills and the ability to handle tasks autonomously. The Canadian Securities Course (CSC) credential confirms proficiency in advising on and executing transactions for securities, mutual funds, and alternative funds within Canada. Furthermore, a Google Analytics 4 certification demonstrates expertise in leveraging data analytics to optimize online strategies, boost conversions, and enhance overall market impact for businesses.​
​
Take a look at my certifications by clicking the title!
Earning the Microsoft Excel certification signifies my foundational understanding of Excel and my capacity to tackle tasks independently. With this certification, I've proven my ability to craft and edit workbooks with multiple sheets, while adeptly using graphic elements to visually depict data, including crafting professional budgets, financial statements, performance charts, and data-entry logs. As a certified Excel user, I join a diverse cohort of individuals, from students to business professionals, clerical workers, and bookkeepers, showcasing my versatility and proficiency across various roles and industries.
The attainment of the Canadian Securities Course (CSC®) credential signifies a mastery in advising on and executing securities, mutual funds, and alternative funds transactions within Canada. This certificate that I possess a profound comprehension of the Canadian financial services arena, including a nuanced understanding of diverse financial instruments. With this credential I am equipped to navigate the complexities of the financial industry in Canada with confidence and expertise, facilitating informed decision-making and fostering client trust.
As a Google Analytics 4 certified professional, I bring a comprehensive skill set to the workplace from seamlessly setting up properties for websites to precisely collecting and interpreting data for actionable insights. I can navigate through reporting tools with ease to extract comprehensive analytics, performance metrics, and trends. With a dedication to data-driven excellence, I can empower businesses to optimize their online presence, drive conversions, and elevate their market impact.