Career Profile
I am a motivated and ambitious Data Engineer with a solid foundation in Data Warehousing, Data Modelling, ETL processes, and Business Intelligence and a year and a half of hands-on experience. Proficient in SQL, SSIS, SSAS, SSRS, and PowerBI and enthusiastic about everything data, I am always looking to learn more. You can download this resume here.
Experiences
Data warehousing project in the finance/healthcare area
Maintaining and adding ETL processes using SSIS and stored procedures for populating a multi-layered Data Warehouse
Creating PowerBI reports and dashboards based on business users reporting needs
Modifying SSAS cubes and SSRS reports based on business requirements or optimizations
Offering support for Production incidents related to missing or inaccurate data
Tech stack: T-SQL, SSIS, SSAS, SSRS, Kyubit, Power BI, Power Query, DAX, Azure DevOps
Stock Portfolio Management System
Working in a team of 8 on a Stock Portfolio Management System for S&P 500 companies with Agile methodology
Developing a Python script to scrape information about the companies in the S&P500 index from Yahoo Finance, using the Y! Finance API and the Pandas library
Building an ETL pipeline in Azure that runs the Python script in a Databricks notebook and sends the output into an Azure SQL Database
Writing SQL Stored Procedures and Functions for generating random portfolios & corresponding data
Designing a Power BI report to present financial information about stocks and companies
Collaborating with my colleagues to ensure the integrity of the project overall and reviewing some of their code
Tech stack: Python, Pandas, AzureDatabricks, Azure Blob Storage, Azure Data Factory, Azure SQL Database, T-SQL, Power BI, Power Query, DAX, Azure DevOps, Jira
Creating a database model based on the existing data and requirements
Developing SSIS packages for the ETL process
Creating database objects (Tables and Views) in SSMS
Creating reports in Power BI
Writing documentation for the whole project
Tech stack: T-SQL, SSIS, Power BI, Power Query, DAX, JIRA
Managing the full lifecycle of recruiting processes for technical roles, such as: Java Developer, Front-End Engineer, .NET Developer, Mobile Developer, QA Manual/Automation Engineer and other IT related roles.
Analysing data related to candidates and hires, exported from Mingle, and created reports in Power BI
Handling the end to end recruitment process for various roles, both external and internal