Database Engineer Trainee
CurrentGain skills and experience in database engineering through earning certifications and completing projects.Certifications:● DP-900 - Azure Data Fundamentals ● Databricks Associate Developer for Apache Spark – Python ● DP-203 – Azure Data Engineer AssociateProjects:• Investment Portfolio Analysiso Extracted and aggregated data from online investment APIs into data frames where initial data cleaning and analysis was doneo Implemented a mean reversion strategy on the portfolio that achieved overall returns of 32% over a year and a halfo Created a data pipeline from Python to SQL to Tableauo Designed dashboards to clearly illustrate trends and insights• World Development Analyticso Created pipeline in Azure Synapse to use Databricks to ingest, clean, and store API data into Data Lake Storageo Personally handled all exploratory geospatial dashboards in MicroStrategy o Designed and created Data Dictionaries, Data Catalogs, and ERD diagrams• Realtime Financial Analytics Dashboardo Loaded 15 years of historical stock market data from Polygon.io into an ADLS gen 2 and then a Data Warehouse in Azure Synapseo Created interactive dashboard in Microsoft PowerBI that covered company information/financial ratios, ticker trends, and price projectionso Maintained the PowerBI online workspace, linked everything through synapse, and handled all underlying permissions regarding PowerBI