Genti Perja, Developer in London, United Kingdom
Genti is available for hire
Hire Genti

Genti Perja

Verified Expert  in Engineering

Bio

Genti is a senior BI engineer and reporting developer who has mastered T-SQL, Power BI, SSRS, SSIS, VBA, and Microsoft Excel. He is proficient in ETL and available to support web development (HTML/CSS, JavaScript/JQuery). He also has excellent project management skills. Genti has implemented many business tools that are still in use after several years of utilization and, in some cases, with zero maintenance.

Portfolio

Shepherds Bush Housing Association
T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS)...
Transport for London
T-SQL (Transact-SQL), Excel 365, Excel VBA, Microsoft Power BI, Axiom
General Pharmaceutical Council
Tableau, Microsoft Power BI, Visual Basic for Applications (VBA)...

Experience

  • Microsoft Excel - 12 years
  • Excel VBA - 11 years
  • T-SQL (Transact-SQL) - 10 years
  • SQL Server Reporting Services (SSRS) - 6 years
  • SQL Server Integration Services (SSIS) - 5 years
  • ETL - 5 years
  • JavaScript - 3 years
  • Microsoft Power BI - 1 year

Availability

Part-time

Preferred Environment

Windows

The most amazing...

...project I've developed was Wendron, a tool for handling ad hoc and massive communications via email, SMS, and paper.

Work Experience

BI Manager and Developer

2021 - 2024
Shepherds Bush Housing Association
  • Created a fully operational Datawarehouse from the ground up, integrating data from 17 main sources (databases, SFTPs, APIs) and a large number of flat Excel files to serve most of the business's operational needs.
  • Created an extensive suite of both operational and strategic Power BI Dashboards, meeting the requirements of the Customer Service, Health & Safety, Compliance, and Finance departments, including the 30-year financial plan dashboard.
  • Won the Company's Innovation Awards for Calendar Year 2022.
Technologies: T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Power BI, DAX

BI Report Developer

2020 - 2021
Transport for London
  • Automated and developed many projects, including applications and reports.
  • Supported stakeholders with insight by producing asset management information reports.
  • Upskilled colleagues in T-SQL, Excel, and VBA code.
Technologies: T-SQL (Transact-SQL), Excel 365, Excel VBA, Microsoft Power BI, Axiom

Data Developer and Reporting Insights Analyst

2019 - 2020
General Pharmaceutical Council
  • Started the development of the mini-framework, a tool designed to automate the exchange of data between Excel and SQL Server that can also be used for ETL without entering in competition with SSIS.
  • Introduced expertise in order to optimize the process of ETL, with a big focus on complete automation.
  • Produced quality reporting, mainly with SSRS, but also Excel, PowerBI, and Tableau.
Technologies: Tableau, Microsoft Power BI, Visual Basic for Applications (VBA), Microsoft Excel, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), ETL, SQL, Microsoft SQL Server

Senior Information Analyst

2018 - 2019
Elysium Healthcare
  • Brought SSRS to the next level, introducing functionalities (using HTML, CSS and JavaScript) not available natively, in order to enhance user experience and design of several dashboards. I also created a few web applications using SSRS/HTML/CSS/JS.
  • Created several tools for multiple departments using Excel VBA + T-SQL, rarely using sheets/ranges (main focus on Userforms/ListObjects (Excel Tables)/T-SQL).
  • Trained junior members, provided technical and analytical support to the whole business, and supported both internal stakeholders (finance, contracts, clinical teams) and external (NHS England) with information and reporting.
Technologies: Business Intelligence (BI), Microsoft Power BI, CSS, HTML, JavaScript, Visual Basic for Applications (VBA), Microsoft Excel, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), ETL, jQuery, SQL Server Integration Services (SSIS), SQL, Microsoft SQL Server

Wendron

Wendron is one of my first projects and was created in 2013. It is a tool that is still used today for ad hoc and massive communications in QVC Italy. Created using Excel + VBA (information stored and retrieved in an MS Access DB), it can import data from CSV, Excel files, and the clipboard. It uses hundreds of templates stored in the database to either quickly compose an answer to customer inquiries, send massive (e.g., marketing) emails, print massive communication letters, or create CSV files used by the IT department to send SMS messages to customers. It features an internal searching engine, fast creation of templates, and extra features dedicated to customer services (e.g., a button for auto-login to operational sites like the courier partner).

Libraries/APIs

jQuery

Tools

Microsoft Excel, Microsoft Power BI, Tableau

Languages

T-SQL (Transact-SQL), Excel VBA, JavaScript, Visual Basic for Applications (VBA), SQL, HTML, CSS

Paradigms

ETL, Business Intelligence (BI)

Storage

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server

Platforms

Windows

Other

Excel 365, Axiom, DAX

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