Genti is currently unavailable
Genti Perja
Verified Expert in Engineering
Software Developer
London, United Kingdom
Toptal member since June 19, 2020
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
Transact-SQL (T-SQL), SQL Server Reporting Services (SSRS)...
Transport for London
Transact-SQL (T-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
- Transact-SQL (T-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
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: Transact-SQL (T-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: Transact-SQL (T-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), Transact-SQL (T-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), Transact-SQL (T-SQL), ETL, jQuery, SQL Server Integration Services (SSIS), SQL, Microsoft SQL Server
Experience
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).
Skills
Libraries/APIs
jQuery
Tools
Microsoft Excel, Microsoft Power BI, Tableau
Languages
Transact-SQL (T-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