Sayed Farhan Amjad, Developer in Sialkot, Punjab, Pakistan
Sayed is available for hire
Hire Sayed

Sayed Farhan Amjad

Verified Expert  in Engineering

Data Engineer and Developer

Location
Sialkot, Punjab, Pakistan
Toptal Member Since
November 17, 2022

Sayed is a senior data engineer with five years of experience developing extract, transform, and load (ETL) pipelines and managing data warehouses, business intelligence (BI) reports, and interactive dashboards. Specializing in SQL, Python programming, and data visualization, Sayed has a wide range of interests, including machine learning (ML), automation, and the internet of Things (IoT), and he is eager to take on new challenges.

Portfolio

Tropicana Brands - Main
Microsoft Power BI, SQL, Azure, Azure DevOps, SharePoint, Jira...
Techlogix
Pentaho, SQL Server Integration Services (SSIS), Microsoft SQL Server...
Techlogix
Pentaho, SQL Server Management Studio (SSMS), Microsoft Power BI, SQL, C#...

Experience

Availability

Full-time

Preferred Environment

Python 3, MySQL, MacOS, PyCharm, MySQL Workbench, Slack, Microsoft Power BI, Tableau

The most amazing...

...project I've delivered is automating data and feature extraction and a multi-class classification pipeline for ranking publicly traded Japanese companies.

Work Experience

Power BI Developer

2023 - 2024
Tropicana Brands - Main
  • Loaded large datasets into PowerBI, optimizing and aggregating historical data and enabling incremental load for efficient dashboard refreshes.
  • Integrated PowerBI with Azure DevOps to enable source control for PowerBI dashboard development using Power BI Desktop projects file format .pbix.
  • Implemented data modeling in Azure Databricks and connected PowerBI directly to the gold layer of medallion architecture with optimized data that can fulfill data visualization needs.
Technologies: Microsoft Power BI, SQL, Azure, Azure DevOps, SharePoint, Jira, Azure Data Studio, Azure Databricks

Senior Software Engineer

2020 - 2022
Techlogix
  • Developed and maintained data warehouse and ETL pipelines for multiple large-scale businesses. Managed multitenant databases and Microsoft Power Bi dashboards with row-level security (RLS) and embedded them into websites and mobile applications.
  • Delivered data analytics and machine learning projects, including balance prediction and bank statement processing using computer vision techniques.
  • Trained junior developers and helped resolve everyday technical issues faced by the data team.
  • Worked for a sales and distribution company where we received near-real-time data from hundreds of trucks and delivery vans. We designed a Power BI dashboard to monitor the business flow and identify real-time choke points.
  • Analyzed historical data for a streaming giant, STARZ, to understand user segmentation and deeper analysis of churned customers. I presented the results in an interactive visual form using Power BI with options to dissect results using handy filters.
Technologies: Pentaho, SQL Server Integration Services (SSIS), Microsoft SQL Server, Microsoft Power BI, Python 3, C#, Azure Blobs, Azure Databricks, Azure Functions, Amazon Redshift, Database Development

Software Engineer

2018 - 2020
Techlogix
  • Created ETL pipelines for a campus management system and sales and distribution system.
  • Developed a data extraction module for seasonal data extraction automation for a campus management system to extract the data related to admission cycles with options to select filters before extracting the data.
  • Worked on a sales and distribution network solution with sophisticated route planning and optimization capabilities and a near real-time dashboard to track anomalies in the distribution of goods.
  • Participated in a churn prediction project for the STARZ PLAY streaming service by analyzing customer viewing habits, payment methods, and content consumption patterns.
  • Designed and optimized a Power BI dashboard for a hospital management system company (vicenna.com) with a multi-tenant reporting database, row-level security, optimized screens for portable devices, and the ability to drill down to lower data dimensions.
  • Implemented hierarchical data access inside the Power BI dashboards based on the position of the user in their organization.
Technologies: Pentaho, SQL Server Management Studio (SSMS), Microsoft Power BI, SQL, C#, Python 3, Database Development

Intern

2017 - 2017
Emerging Technology Lab
  • Participated in a research project to detect behavioral anomalies in employees caused by stress and mental health issues using internal communication in a corporate enterprise.
  • Worked as a research intern with PhD scholars on an NLP project aimed at the early detection of problems with employees' mental and physical health, focusing on implementing preventative measures to maintain a work and life balance.
  • Performed literature review, data cleaning and preparations, and documentation of results.
Technologies: MATLAB, Natural Language Processing (NLP), Generative Pre-trained Transformers (GPT), GPT

Data Warehouse for Hospital Management System

http://www.vicenna.com
Worked as a data engineer for a hospital management system and designed and maintained reporting databases and power BI dashboards for hospital management. Multi-tenant databases with row and column level security both in reporting databases and interactive embedded dashboards provided our customers access to the data and the statistics that were critical to monitoring and improving the business.

Reporting Database and Dashboards for CMS Project

https://almusnet.com/campus-on-cloud/
Campus on Cloud is a product by Almusnet that provides a student information system for universities and colleges using the power of the Microsoft Azure Cloud platform.

I created admission data extraction modules that let the system clients request an extract of data based on a number of parameters such as admission cycle, application status, fee payment status, and more. The module was based on SQL and C# and deployed in queue-triggered Azure Function, and the status of extraction requests was maintained in a database table.

I worked on the design of the reporting database and the development of ETL pipelines in SSIS that were deployed in Azure VMs with email notification system for critical alerts.

I also worked on developing Power BI dashboards for different modules of the products, such as code, admissions, academics, and financials. We designed and embedded RLS-based multi-tenant interactive dashboards to add value for our clients.

Businesses Classification Based on Financial Transparency

I worked on a project to automate data extraction, feature extraction, reporting, and classification of Japanese publicly traded companies based on their yearly financial reporting and executive compensation methods.

To achieve end-to-end automation of the whole process, I first downloaded bundled reports as a ZIP file and extracted financial files with relevant data. Then, I ran feature extraction and financial information extraction for HTML files, processed and stored the information, and finally trained and tested an ensemble model to classify companies into five classes.

Previously, the client did all these steps manually, spending days processing and extracting the information. After the project was complete, the whole process took less than 10 minutes to run end-to-end and produce classification results.

Churn Prediction for Video Streaming Platform

Starzplay is a video streaming company with viewers based in middle-east, north Africa, and south Asia. The project was focused on understanding user behavior that leads to churn. We extracted features from the historical data of users viewing history, payment methods, language, and location data to train machine learning models based on the extracted features to identify user behavior that leads to churn from the platform. The goal was to target those users with specialized marketing campaigns to increase customer retention.
2020 - 2023

Master's Degree in Data Science in Computer Science

Aalto University - Espoo, Finland

2014 - 2018

Bachelor's Degree in Computer Engineering

National University of Sciences and Technology - Islamabad, Pakistan

JANUARY 2022 - PRESENT

Introduction to Cybersecurity Tools & Cyber Attacks

IBM

OCTOBER 2021 - PRESENT

Advanced Database Queries

New York University

JUNE 2021 - PRESENT

Starting up

MinnaLearn

SEPTEMBER 2020 - PRESENT

Neural Networks and Deep Learning

DeepLearning.AI

AUGUST 2020 - PRESENT

R Programming

Johns Hopkins University

AUGUST 2020 - SEPTEMBER 2022

Microsoft Certified: Azure Data Scientist Associate

Microsoft

JULY 2019 - PRESENT

Machine Learning for Data Science and Analytics

Columbia University

Libraries/APIs

Pandas, PyTorch

Tools

Microsoft Power BI, Power Query, Rundeck, PyCharm, MySQL Workbench, Slack, MATLAB, Tableau, Jira

Languages

SQL, Python 3, Stored Procedure, C#, Python

Storage

Relational Databases, MySQL, Microsoft SQL Server, DB, Data Pipelines, Databases, RDBMS, SQL Server Management Studio (SSMS), SQL Stored Procedures, SQL Server DBA, Database Architecture, PostgreSQL, SQL Server Integration Services (SSIS), Azure Blobs

Industry Expertise

Cybersecurity

Paradigms

ETL, Business Intelligence (BI), Database Development, Automation, Azure DevOps

Platforms

Azure Functions, Azure, Pentaho, MacOS, Amazon Web Services (AWS), Databricks, SharePoint

Other

BI Reports, Microsoft Data Transformation Services (now SSIS), Machine Learning, Azure Databricks, Task Scheduling, Data Engineering, Data Architecture, DAX, APIs, Dashboards, Software Engineering, Artificial Intelligence (AI), Deep Learning, Entrepreneurship, Natural Language Processing (NLP), Computer Vision, Machine Learning Automation, Cloud, R Programming, Data Analysis, Metabase, Tableau Server, Data Warehouse Design, Amazon Redshift, Virtual Machines, Data Visualization, GPT, Generative Pre-trained Transformers (GPT), Azure Data Studio

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring