Endy Kalu, Developer in Abuja, FCT, Nigeria

Endy Kalu

Software Developer

Abuja, FCT, Nigeria
Toptal Member Since
November 9, 2020

Endy helps companies use their data to drive decision-making. He has over 15 years of experience with the Microsoft BI platform, including working extensively with SSRS, T-SQL, SSIS, PowerBI, and various SQL Server versions. Endy has worked with over a dozen companies from startups to Fortune 500s and multiple industries such as retail, healthcare, digital marketing, and financial, implementing and supporting BI solutions.

Endy is available for hire
Hire Endy


Sage Intacct
QuickBooks API, Microsoft Excel, APIs
Super Dispatch
SQL, Data Analysis, Redshift, GitHub, Analytics, ETL, Python, Fivetran
The Business of Fashion Limited
Data Engineering, Snowflake, SQL, Snowplow Analytics, ETL, Data Pipelines...


Abuja, FCT, Nigeria



Preferred Environment

PostgreSQL, pgAdmin, SQL Server Integration Services (SSIS), Microsoft Power BI, SQL Server Reporting Services (SSRS), TFS, Microsoft SQL Server, SQL Server Management Studio (SSMS), Data Build Tool (dbt)

The most amazing...

...solution I've developed is a dashboard and reporting suite using IoT data from trains and railroad devices.

Work Experience

2022 - PRESENT

Data Processing Expert with QuickBooks API Knowledge

Sage Intacct
  • Worked to architect and build a solution that eases new user onboarding.
  • Extensively worked with QuickBook API data objects.
  • Developed an automated data extract from QuickBooks API, transformed it to match the required format, and provided the transformed data extract in excel format.
Technologies: QuickBooks API, Microsoft Excel, APIs
2022 - 2022

Data and Analytics Engineer

Super Dispatch
  • Worked with the data analytics group to build DBT analytical pipelines and Census Reverse ETL syncs in an Amazon Redshift SQL environment.
  • Collaborated with the head of analytics to determine requirements for every sprint.
  • Developed complex queries to sync data warehouse data to Salesforce and Customer.io.
  • Built ad-hoc queries as needed and performed light Redshift administration tasks such as provisioning client-specific schemas or tables and providing permission to user roles.
Technologies: SQL, Data Analysis, Redshift, GitHub, Analytics, ETL, Python, Fivetran
2022 - 2022

Snowflake Data Engineer

The Business of Fashion Limited
  • Worked with the data analytics group to build and maintain DBT analytical pipelines in a Snowflake SQL environment.
  • Built and maintained DBT models that power the company's Looker dashboards and reports using DBT Cloud, Visual Studio Code, and GitHub.
  • Researched data and fixed data issues, adding testing to models to ensure data reliability.
Technologies: Data Engineering, Snowflake, SQL, Snowplow Analytics, ETL, Data Pipelines, Data Build Tool (dbt), GitHub, Recurly, Salesforce, Looker, Machine Learning, Pipelines
2021 - 2021

Database Developer

Pillar Risk
  • Worked with the client to understand requirements and develop a framework to receive review requests, store data, and get insights into the overall process.
  • Helped the client create a PostgreSQL database to house commercial real estate insurance review data.
  • Created forms using Paperform and integrated with PostgreSQL using Zapier.
  • Built functions and processes to save, retrieve, and manage data. These functions were consumed by an API that powered their workflow applications.
Technologies: SQL, PostgreSQL, Databases
2021 - 2021

Analytics Engineer

AAA Life Insurance
  • Worked with company data analytics group to build and maintain pipelines in a Redshift database using DBT, SQL, and Python.
  • Developed new data transformations with testing and documentation using DBT, CLI, and Gitlab.
  • Ensured queries were developed according to organization standards.
  • Worked with business users to determine requirements and document data models and fields using DBT.
  • Used Gitlab to manage code deployments, peer reviews, and deployments.
Technologies: Data Build Tool (dbt), Redshift, GitLab, PyCharm
2021 - 2021

Senior Integrations Developer

Toptal Client
  • Worked with the client to automate data integration between Salesforce and Quickbooks desktop.
  • Developed data integrations using SSIS and KingswaySoft custom components, Git for versioning, Visual Studio for development, and SSMS for querying SQL Server database.
  • Created a bidirectional account, invoice, and products data sync between Salesforce API and QuickBooks Desktop API.
  • Staged data in a SQL Server and performed transformations using T-SQL prior to loading into end systems.
Technologies: SQL Server Integration Services (SSIS), Salesforce API, QuickBooks API
2020 - 2021

Database and Backend Developer

Enterprise Insight
  • Architected a database and back-end infrastructure for a technology solutions company to allow it to provide a data backbone for client applications and analytics.
  • Set up a multicloud infrastructure consisting of PostgreSQL servers, an API server using PostgREST, an API Gateway using KrakenD, a Docker-based platform using CapRover, and BI using Metabase and n8n.
  • Designed database systems for new applications (web and mobile) and created an API for front-end developers using PostgREST, a PostgreSQL extension that enables authoring APIs from database table objects (table, views, and functions).
  • Created multiple PostgreSQL functions and views with embedded business logic and RLS to support APIs for front-end developers.
  • Set up an integrated KrakenD API gateway for additional API security, execution logic, CORS support, and external application integrations (S3, Plausible, and Typesense APIs), vendor integrations (Paystack API and Flutterwave API), and versioning.
  • Set up a Plausible server on Docker for web analytics and exposed APIs in Gateway for display in client applications.
  • Set up ETL and dashboards. The data is extracted from operational databases and APIs and loaded into a PostgreSQL database server using n8n automation. Transformations are done using SQL with Metabase for visualizations and scheduled reports.
Technologies: PostgreSQL, APIs, Metabase, Analytics
2019 - 2020

Senior ETL Developer

Inspire Brands
  • Developed and maintained data integrations from multiple data sources, including relational databases, vendor APIs, and flat files to the company data warehouse, supporting multiple departments and executives in decision making and analytics.
  • Fixed two integration processes that have been in development and on/off production for almost a year costing the company at least $150,000 in development cost and loss of productivity.
  • Created new data integration from APIs using SSIS, Python Pandas, and C#.
  • Designed database models for fact and dimension tables for the data warehouse.
  • Developed transformations in TSQL, loaded into dimension and fact tables,. and created validations scripts in TSQL to test ingested data.
Technologies: SQL Server 2016, Pandas, TFS, C#, T-SQL (Transact-SQL), SQL Server Integration Services (SSIS)
2018 - 2019

Senior SQL Developer

Home Depot
  • Helped the company's supply chain department move their analytics SQL code base from Teradata to Google BigQuery.
  • Converted several Tableau, Excel, and SSRS report queries involving thousands of lines of queries from Teradata SQL syntax to Google Big Query.
  • Validated converted reports to ensure that the numbers matched perfectly or with a comfortable variance.
  • Worked with the analytics team to review problematic queries, remediate missing data sets, and ensure that the transition proceeds with minimal disruption.
  • Scheduled queries to generate data on established intervals using the company’s scheduling tool.
Technologies: Data Reporting, Google BigQuery, SQL
2017 - 2018

MS BI Developer

Norfolk Southern
  • Developed and maintain several complex SSRS reports for operation and executive managers.
  • Developed T-SQL stored procedures, views, and user-defined functions for SSRS reports.
  • Created reports from multiple data sources including SQL Server, DB2, Oracle, and Teradata.
  • Provided support to department's developers as the go-to resource for complex database performance or reporting scenarios.
Technologies: XML, Databases, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS)
2015 - 2017

MS BI Developer

Northside Hospital
  • Developed and maintain several complex SSRS reports for financial analyst teams and business managers. This included creating T-SQL stored procedures, views, and user-defined functions to power the reports.
  • Created and scheduled new SSIS packages for the data import from various SFTP sites, network locations, and database sources.
  • Converted several TSQL scripts to Netezza SQL for use in SSRS reports.
  • Provided support to the department's Senior BI developer as the go-to resource for complex reporting scenarios.
  • Supported company data warehouse including data integration with SSIS including daily ETL log reviews and troubleshooting integration issues.
  • Developed SFTP PowerShell scripts for file transfers.
  • Updated company Asp.Net/C# based portal with new features as needed.
Technologies: SQL Server 2014, C#, Netezza, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL Server Integration Services (SSIS)
2014 - 2015

Multi-Channel Management and Reporting Solution

  • Automated company eCommerce store processes, including design and development of a multi-channel reporting platform.
  • Developed an Excel-based product information management process, a product import process, and a cloud-based product image management using Azure cloud.
  • Developed various SQL scripts and set up triggers for database pricing updates and exceptions reporting.
  • Worked with the company’s POS vendor to set up a two-way inventory data flow and one-way sales data flow between in-house MySQL database and e-commerce MySQL database.
  • Deployed reporting services and created SSRS reports giving company single view insights across in-store and digital store sales, inventory, and shipping.
  • Automated order pickup notification by integrating with the logistics company system.
Technologies: Excel 2010, MySQL, SSRS Reports, Azure, T-SQL (Transact-SQL)
2014 - 2015

Inventory Management Application Developer

  • Developed a Windows application to manage and track customer/vendor relationship data with a single view of transactions, balances, invoices and payments, contact, and personal information.
  • Built a Windows application with VB.NET, SQL Server database, and SSRS.
  • Developed T-SQL stored procedures for CRUD and database Views to consolidate table reads.
  • Created single view reporting across installations at company warehouse and retail outlets, as well as new online channels using SSRS reports embedded in VB.NET application.
Technologies: SSRS Reports, Microsoft SQL Server, VB.NET
2013 - 2014

SSRS and SQL Server Developer

First Data Corp
  • Developed processes and reports to manage multi-billion dollar payment processing conversion project data.
  • Worked closely with key technical and non-technical users to define report requirements.
  • Develop SSIS packages for data integration, T-SQL Stored Procedures and user-defined functions for data transformations, and SSRS for reporting.
  • Embedded SSRS reports in ASP.NET web application; develop ASP.NET Webforms using C# and JavaScript. Reporting portals were accessed by over 300 users including top management.
  • Performed SQL Server database query tuning by reviewing execution plans and adding indexes.
Technologies: ASP.NET, T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
2012 - 2013

Lead MS BI Developer

Response Mine Interactive
  • Developed a BI platform using Azure Cloud hosted SQL Server 2012 Enterprise, SharePoint 2013, SQL Server Data tools for use by 100+ users.
  • Worked closely with key technical and non-technical users to define report requirements.
  • Designed a data warehouse to house organization high volume historical and on-going digital marketing data.
  • Assisted in developing C# programs to extract data from Google and Bing APIs.
  • Created and scheduled SSIS packages for the data import from various files and APIs.
  • Developed T-SQL stored procedures, views, and user-defined functions for SSRS reports.
  • Created SSRS reports and deployed to SharePoint 2013.
  • Prototyped visualizations using PowerBI and SSAS Tabular Model.
Technologies: SSAS Tabular, Microsoft Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint 2013, Azure, Microsoft SQL Server
2012 - 2012

MS BI Developer

First Data Corp
  • Developed processes to manage company conversion project data using SQL Server 2005, SSIS, T-SQL, and SSRS.
  • Developed and scheduled SSIS packages for the daily ETL process.
  • Developed T-SQL scripts and Stored Procedures for ad-hoc and SSRS reports.
  • Created several SSRS reports to provide insight on conversion data, exceptions, and project progress. Reports were consumed by over 300+ project members and top management.
Technologies: T-SQL (Transact-SQL), SQL Server 2005, SQL Server Integration Services (SSIS), SSRS Reports
2012 - 2012

SSRS and SQL Server Developer

Home Depot
  • Developed reports to enable the company to get more insight from MS System Center Configuration Manager (SCCM) using SSRS and T-SQL Stored Procedures.
  • Worked closely with key management users to define report requirements.
  • Performed query tuning on slow running dashboards by optimizing or re-writing T-SQL queries.
Technologies: T-SQL (Transact-SQL), System Center Configuration Manager (SCCM), SSRS Reports
2011 - 2011

Lead MS BI Developer

BKV, Atlanta GA
  • Developed processes and programs to manage the organization’s high volume advertising and marketing data using SQL Server 2008, SharePoint Foundation, SSIS, and SSRS.
  • Worked closely with key technical and non-technical users to define report requirements.
  • Designed and developed data flow using SSIS and T-SQL Stored Procedures.
  • Integrated loyalty and rewards data from external vendors within company data-flow.
  • Used SharePoint and SSRS for end-client reporting used by over 100+ company employees and management.
  • Provided data feeds and support to the data science team for advanced analytics.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint, SQL Server 2008
2010 - 2010

SharePoint and SQL Server Developer

  • Implemented Microsoft Office SharePoint services for the Rivers State Government Secretariat.
  • Developed a database system for their MS Excel-based employee payroll data using SQL Server 2008.
  • Integrated employee records database with SharePoint Services using the business data catalog and created an employee directory lookup within SharePoint.
Technologies: SQL Server 2008, SharePoint
2010 - 2010

SSRS Reports Developer

  • Developed core reports from the organization's operational and financial data using SSRS, SQL Server 2005, T-SQL Stored Procedures, and SharePoint.
  • Worked with management to define report requirements and met periodically throughout the project to review reports.
  • Created a data model for client ad-hoc reporting using Views and T-SQL.
  • Deployed MS Report Builder for ad-hoc report development and providing training to end-users.
Technologies: T-SQL (Transact-SQL), SQL Server 2005, SharePoint, SQL Server Reporting Services (SSRS)
2010 - 2010

MS BI Developer

Macy’s Systems and Technology
  • Developed core executive reports from the company’s resource budgeting and planning data using SSRS and TSQL stored procedures.
  • Worked closely with key users to define report requirements and new application features.
  • Added additional modules to VB.NET application and converted complex Excel reports to SSRS reports.
  • Automated data import from other company applications using T-SQL Scripts and SQL Server agent.
Technologies: VB.NET, T-SQL (Transact-SQL), SSRS Reports
2009 - 2010

Database Application Developer

  • Developed a database management system for taxpayer registration and record management using VB.NET and SQL Server 2008. Application CRUD and core business rules were implemented in the database using T-SQL, Stored Procedures, UDFs, and Views.
  • Performed data cleanup and created multiple reports for analysis using T-SQL.
  • Provided support and end-user training throughout the contract duration.
Technologies: T-SQL (Transact-SQL), VB.NET, SQL Server 2008
2008 - 2009

MS BI Developer

Crescent Mortgage Company
  • Developed core operational reports and converted about two hundred existing reports from an old system using SQL Server 2005, SSRS, and T-SQL. Reports were integral to company operation and were used by virtually every employee (200+) companywide.
  • Constantly communicated with department heads and power end-users to determine report requirements.
  • Ported old Access applications and reports to Windows Client/Server Application using VB.NET, SQL Server 2005, and SSRS ReportViewer.
  • Automated series of client mortgage forms and letters using SSRS reports and T-SQL Stored Procedure for form and letter generating business rules.
Technologies: SQL Server 2005, VB.NET WinForms, SQL Server Management Studio, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS)
2007 - 2008

Crystal Report Developer

IQ Interactive
  • Converted client’s existing Excel-based financial reports to automated reports using Crystal Reports, SQL Server 2005, and T-SQL.
  • Communicated with company financial analysts and CFO to determine report requirements.
  • Enhanced report by applying dynamic groups filters and drill down functionalities.
Technologies: T-SQL (Transact-SQL), SQL Server 2005, Crystal Reports
2007 - 2007

SQL Report Developer

Piedmont Healthcare
  • Developed a series of reports for embedding in the hospital’s medical application using SSRS, T-SQL Stored Procedures, and SQL Server 2005.
  • Customized various application modules using the application developer toolkit.
  • Communicated with department heads to determine report requirements.
  • Developed a web application for various medical groups using ASP.NET, VB.NET, and SQL server 2005 backend and provided training end-users.
Technologies: SQL Server 2005, VB.NET, ASP.NET, T-SQL (Transact-SQL), SSRS Reports
2004 - 2007

BI Developer

Integratec Services LLC
  • Communicated with account managers to define report requirements, developed reports using Crystal Report and Stored Procedures. Reports were published in the company Enterprise System (TCAM) for external client consumption.
  • Developed ETL processes for daily imports using VBScript, T-SQL, and DTS.
  • Created web applications for data entry using Classic ASP, Visual Basic, XML, and JavaScript.
Technologies: VBScript, SQL Server 2005, ASP, T-SQL (Transact-SQL), Crystal Reports


eCommerce Retail Dashboard

A PowerBI dashboard and report created to help provide visibility into eCommerce operation. The dashboard highlights the sales, expenses, inventory purchases, and accounting. The end result is a glance dashboard with detailed highlights in an easy-to-digest layout.

API Dashboard

I created this dashboard to get insights into API call success and failures during project development. There were random errors during development and needed to provide feedback to the API owners. We also needed to track the error response details frequency as well as track the hits over time to see the decline as fixes were being made.



SQL, T-SQL (Transact-SQL), C#, VB.NET, XML, VBScript, Snowflake, Python


Databases, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PostgreSQL, SQL Server 2016, JSON, PSQL, Netezza, SQL Server 2014, MySQL, SSAS Tabular, SQL Server 2005, SQL Server 2008, SQL Server Management Studio, Redshift, Data Pipelines


Data Reporting, SQL Server Management Studio (SSMS), Software Development Lifecycle (SDLC), Google BigQuery, SSRS Reports, APIs, Metabase, Analytics, Data Build Tool (dbt), Data Engineering, Machine Learning, Pipelines, Data Analysis, Fivetran


pgAdmin, TFS, Microsoft Power BI, Excel 2010, System Center Configuration Manager (SCCM), Crystal Reports, GitLab, PyCharm, Microsoft Excel, Snowplow Analytics, GitHub, Recurly, Looker




Pandas, Salesforce API, QuickBooks API




Azure, SharePoint 2013, SharePoint, Salesforce


2000 - 2004

Bachelor's Degree in Computer Information System

Kennesaw State University - Kennesaw, GA