Afif Azhar, Developer in South Tangerang, South Tangerang City, Banten, Indonesia
Afif is available for hire
Hire Afif

Afif Azhar

Verified Expert  in Engineering

Data Engineer and Developer

South Tangerang, South Tangerang City, Banten, Indonesia

Toptal member since November 11, 2020

Expertise
Back-end DevelopersData EngineeringVisual Studio DevelopmentSQLC#DatabaseSSISETLPython
Bio

Afif is a software engineer with more than eight years of experience in web development and five years in data engineering. With deep expertise, he now specializes in data warehousing, business intelligence, and ETL. As a technical lead and data engineer, he played a key role in developing an educational platform that has recorded 12 million page views per day. Afif is also experienced in back-end development, including APIs.

Portfolio

Sekolah.mu
Data Lakes, SQLAlchemy, ELT, Stored Procedure, Indexing, Data Visualization...
Online Freelance Agency
T-SQL (Transact-SQL), Microsoft SQL Server, Databases, C#, React, SharePoint...
Self-employed
SharePoint, PostgreSQL 10, T-SQL (Transact-SQL), Microsoft SQL Server...

Experience

  • .NET - 7 years
  • Back-end - 6 years
  • SQL Server 2012 - 5 years
  • SQL - 5 years
  • Data Warehousing - 4 years
  • ETL - 4 years
  • SQL Server Integration Services (SSIS) - 4 years
  • Python - 3 years

Availability

Part-time

Preferred Environment

Back-end, Business Intelligence (BI), Visual Studio, ETL, Data Warehouse Design, Data Warehousing, Microsoft Power BI, SQL, SQL Server Integration Services (SSIS), .NET, Python

The most amazing...

...thing I've developed is Sekolah.mu, an education platform that has recorded 12 million page views per day and been in the top-five free apps in Google Play.

Work Experience

Technical Lead

2019 - PRESENT
Sekolah.mu
  • Designed and developed a platform that distributes educational activities in order to expand equal access to high-quality education.
  • Refactored and improved the platform to handle millions of concurrent requests.
  • Developed ETL (using Python) and a data warehouse (using MySQL and Amazon Redshift) as a feeder to the dashboard and reporting system.
  • Managed, tracked, and reported on development tasks, using Jira.
  • Set up and managed source code and CI/CD implementation on GitLab.
  • Designed the relational database from scratch and implemented performance tuning when the system needed to be scaled up.
Technologies: Data Lakes, SQLAlchemy, ELT, Stored Procedure, Indexing, Data Visualization, Redshift, Data Modeling, Amazon Web Services (AWS), Dimensional Modeling, Data Warehouse Design, ETL Tools, ETL Implementation & Design, ETL Development, Data Engineering, Databases, Code Architecture, Database Architecture, Data Architecture, Snowflake, Data Warehousing, Redis, Apache Kafka, Elasticsearch, Docker, MySQL, Flask, Django, Python, Kafka Streams, Go, Data Reporting, Metabase, Data Queries, Dashboards, APIs, Data Analytics, Data Fetching

Software Engineer

2018 - 2019
Online Freelance Agency
  • Played a key role in four projects, consistently achieving 95% of the weekly target for solving bugs.
  • Tracked and fixed bugs, using Jira as the ticket tracker and GitHub as the source code repository.
  • Assisted with fixing 95% of the backlog bugs for a key project.
  • Developed and maintained various company products, using ASP .NET, ASP.NET MVC, React, Next.js, SQL Server, and SharePoint.
Technologies: T-SQL (Transact-SQL), Microsoft SQL Server, Databases, C#, React, SharePoint, SQL Server Integration Services (SSIS), Confluence, Jira, GitHub, SQL Server 2012, ASP.NET MVC, ASP.NET, .NET, APIs

Full-stack Developer

2016 - 2018
Self-employed
  • Delivered a customer identification system (data matching) to identify duplicate records for customers who have multiple accounts, using SQL Server, SSIS, and a .NET console application.
  • Developed a system that reduced data processing time from seven working days in the existing system to several hours in the new system.
  • Delivered a back-office, web-based system in SharePoint for an oil and mining company.
  • Created a business intelligence tool (ASP.NET MVC), enabling a manufacturing company to monitor its CSR activities.
  • Hired software developers to assist in the development phase of several complex projects.
Technologies: SharePoint, PostgreSQL 10, T-SQL (Transact-SQL), Microsoft SQL Server, PostgreSQL, Databases, Data Architecture, Snowflake, Star Schema, Microsoft Power BI, Data Analysis, ASP.NET MVC, ASP.NET, Business Intelligence (BI), Data Warehouse Design, Data Warehousing, SQL Server Integration Services (SSIS), C#, .NET, SQL Server 2012, APIs

Technical Lead

2013 - 2016
Ebiz
  • Shipped a successful deliverable after taking on a project that was in "red" status at its midpoint.
  • Tracked and fixed bugs, using TFS as a tracking and reporting tool.
  • Created and delivered training sessions for junior developers on topics such as .NET, C#, SQL Server, and SharePoint.
  • Led and mentored developers on technical development issues.
  • Developed an investment dashboard, including a data warehouse and business intelligence for an oil and mining company, using SQL Server, SSIS, Power BI, and SSRS.
Technologies: Stored Procedure, Indexing, Data Visualization, Data Modeling, T-SQL (Transact-SQL), Microsoft SQL Server, Databases, Snowflake, Star Schema, Data Analysis, Microsoft Power BI, TFS, ASP.NET, jQuery, JavaScript, C#, .NET, SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint, ASP.NET MVC

Programmer

2011 - 2013
Mitrais
  • Developed an ERP and business intelligence module for a contract management platform, using ASP MVC .NET, SQL Server, and SSRS.
  • Built an order management system that's used to track the whole chain of retail stores, using .NET, SQL Server, DB2, SQLite, WPF, and Windows Mobile.
  • Tracked bugs using Jira and managed a source code repository using TFS.
Technologies: SQLite, IBM Db2, Windows Presentation Foundation (WPF), Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ASP.NET, ASP.NET MVC, C#, .NET

Experience

Sekolah.mu | Education App on Web and Mobile

https://www.sekolah.mu/
An education platform (web and Android) that distributes educational activities and integrates with learning systems. The system has recorded 12 million page views per day and been in the top-five free apps in Google Play.

As a technical lead for web development and data engineering, I designed and developed the back end and data-related aspects of the platform. In collaboration with the product team, I gathered the requirements, recommended ways to revamp the product, interpreted them into the technical design, and coded parts of the system.

ERP System for Total Contract Management

An ERP system bundled with a business intelligence system that's used to track a company's performance and to track and monitor the allocated resources, actual resources, project efficiencies, and productivity. As a developer, I played a key role in the data and business intelligence aspects of the system. The project was successfully shipped to the client and we received positive feedback from them.

Investment Management System for Pertamina

https://www.youtube.com/watch?v=tsBvAUn7Aho
A SharePoint-based system used to monitor the investments of a national oil and mining company in Indonesia. After joining the team in the middle of the project as a technical leader, I played a key role in the successful delivery of the project to the customer. This involved working with all the developers to redesign and revamp the system so that it's connected, end-to-end, from the initial process to the reporting side.

Education

2017 - 2019

Master's Degree in Information Technology

University of Indonesia - Jakarta, Indonesia

2006 - 2011

Bachelor's Degree in Telecommunications

Telkom University - Bandung, Indonesia

Certifications

NOVEMBER 2016 - PRESENT

MCPS: Microsoft Certified Professional

Microsoft

Skills

Libraries/APIs

jQuery, SQLAlchemy, React

Tools

Visual Studio, Microsoft Power BI, GitHub, Jira, Confluence, TFS, AWS Fargate, Amazon Elastic Container Service (ECS), Kafka Streams

Languages

Python, SQL, C#, T-SQL (Transact-SQL), Stored Procedure, JavaScript, HTML, Snowflake, Go

Frameworks

.NET, Django, Flask, ASP.NET, ASP.NET MVC, Windows Presentation Foundation (WPF)

Paradigms

ETL, Database Development, Business Intelligence (BI), ETL Implementation & Design, Dimensional Modeling, Agile Software Development

Storage

SQL Server Integration Services (SSIS), SQL Server 2012, SQL Server Reporting Services (SSRS), Databases, Microsoft SQL Server, MySQL, Elasticsearch, Redis, PostgreSQL, IBM Db2, PostgreSQL 10, Redshift, Database Architecture, SQLite, Data Lakes

Platforms

Linux, SharePoint, Docker, Apache Kafka, Amazon EC2, Amazon Web Services (AWS)

Other

Back-end, Data Engineering, ETL Development, CSV File Processing, Data Warehousing, Star Schema, ETL Tools, Data Warehouse Design, Data Modeling, Data Visualization, Indexing, ELT, Data Marts, APIs, Data Analytics, Data Fetching, Software Design, Software Architecture, Data Management, Machine Learning, Text Mining, Data Mining, Data Analysis, Data Architecture, Code Architecture, Data Reporting, Metabase, Data Queries, Dashboards

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