Endy Kalu, Developer in Sheffield, United Kingdom
Endy is available for hire
Hire Endy

Endy Kalu

Verified Expert  in Engineering

Software Developer

Location
Sheffield, United Kingdom
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 retail, healthcare, digital marketing, and finance industries, implementing and supporting BI solutions.

Data ReportingData ModelingData WarehousingDatabase DevelopmentMicrosoft SQL ServerT-SQL (Transact-SQL)SQLDatabasesSQL Stored ProceduresETLDynamic SQLREST APIsData EngineeringBig DataData MigrationMicrosoft SCCMRecurlyNetezza

Portfolio

Sage Intacct
QuickBooks API, Microsoft Excel, APIs, Database Modeling, QuickBooks Online...
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...

Experience

Microsoft SQL Server - 16 yearsT-SQL (Transact-SQL) - 16 yearsSQL Server Reporting Services (SSRS) - 15 yearsSQL Server Integration Services (SSIS) - 12 yearsVB.NET - 10 yearsPostgreSQL - 5 yearsJSON - 5 yearsMicrosoft Power BI - 4 years

Availability

Full-time

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

Data Processing Expert

2022 - PRESENT
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, Database Modeling, QuickBooks Online, REST APIs

Data and Analytics Engineer

2022 - 2022
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, Database Development, Database Modeling, Data Migration, Performance Tuning, Dynamic SQL, Amazon Web Services (AWS), Entity Relationships, Data Engineering, Data Modeling, Data Analytics, Data Warehousing, Teamwork

Snowflake Data Engineer

2022 - 2022
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, Database Development, Database Modeling, Data Migration, Performance Tuning, Dynamic SQL, Big Data, Entity Relationships, Data Modeling, Data Analytics, Data Warehousing, Teamwork

Database Developer

2021 - 2021
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, Database Development, Database Modeling, Amazon Web Services (AWS), Entity Relationships, Data Engineering, Data Modeling, REST APIs

Analytics Engineer

2021 - 2021
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, Database Development, Database Modeling, Performance Tuning, Dynamic SQL, Big Data, Entity Relationships, Data Engineering, ETL, Data Modeling, Data Analytics, Data Warehousing, Teamwork

Senior Integrations Developer

2021 - 2021
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, Database Development, Database Modeling, SQL Stored Procedures, Performance Tuning, Dynamic SQL, ETL Tools, Data Engineering, ETL, Data Modeling

Database and Back-end Developer

2020 - 2021
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 multi-cloud 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, Database Development, Database Modeling, Performance Tuning, Dynamic SQL, Amazon Web Services (AWS), Entity Relationships, Data Engineering, Data Modeling, REST APIs

Senior ETL Developer

2019 - 2020
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), Database Development, Database Modeling, Microsoft SQL Server, Dynamic SQL, ETL Tools, Big Data, Entity Relationships, Data Engineering, ETL, Data Modeling, Data Analytics, REST APIs, Data Warehousing, Teamwork

Senior SQL Developer

2018 - 2019
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, Database Development, SQL Stored Procedures, Dynamic SQL, Big Data, Entity Relationships, Google Cloud, Data Analytics, Data Warehousing

MS BI Developer

2017 - 2018
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), Database Development, Microsoft SQL Server, SQL Stored Procedures, .NET, Dynamic SQL, Big Data

MS BI Developer

2015 - 2017
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), Microsoft SQL Server, SQL Server 2015, SQL Stored Procedures, .NET, Big Data, ETL, Data Warehousing, Teamwork

Multi-channel Management and Reporting Solution Expert

2014 - 2015
Freelance
  • 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), Microsoft SQL Server, SQL Server 2015, .NET

Inventory Management Application Developer

2014 - 2015
Freelance
  • 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, SQL Server 2015, .NET

SSRS and SQL Server Developer

2013 - 2014
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), Microsoft SQL Server, SQL Server 2015, SQL Stored Procedures

Lead MS BI Developer

2012 - 2013
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, SQL Stored Procedures, ETL Tools

MS BI Developer

2012 - 2012
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, Microsoft SQL Server, SQL Stored Procedures, ETL Tools

SSRS and SQL Server Developer

2012 - 2012
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, Microsoft SQL Server, SQL Stored Procedures

Lead MS BI Developer

2011 - 2011
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, Microsoft SQL Server, SQL Stored Procedures, ETL Tools

SharePoint and SQL Server Developer

2010 - 2010
Freelance
  • 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, Microsoft SQL Server, SQL Stored Procedures

SSRS Reports Developer

2010 - 2010
CARE
  • 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), SQL Stored Procedures

MS BI Developer

2010 - 2010
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, SQL Stored Procedures

Database Application Developer

2009 - 2010
Freelance
  • 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, Microsoft SQL Server, SQL Stored Procedures

MS BI Developer

2008 - 2009
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 (SSMS), T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), SQL Stored Procedures

Crystal Report Developer

2007 - 2008
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, SQL Stored Procedures

SQL Report Developer

2007 - 2007
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, SQL Stored Procedures

BI Developer

2004 - 2007
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, Active Server Pages (ASP), T-SQL (Transact-SQL), Crystal Reports, SQL Stored Procedures

eCommerce Retail Dashboard

https://www.dropbox.com/s/40py1efbfggwiux/Retail_Dashboard.pdf?dl=0
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

https://www.dropbox.com/s/4s089eyfg219jo1/API_Utilization_Dashboard.pdf?dl=0
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.

Languages

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

Libraries/APIs

REST APIs, Pandas, Salesforce API, QuickBooks API

Paradigms

ETL, Database Development

Storage

Microsoft SQL Server, Databases, Database Modeling, SQL Stored Procedures, Dynamic SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PostgreSQL, SQL Server 2016, JSON, Google Cloud, PSQL, Netezza, SQL Server 2014, MySQL, SSAS Tabular, SQL Server 2005, SQL Server 2008, SQL Server Management Studio (SSMS), Redshift, Data Pipelines

Other

Data Reporting, SQL Server 2015, Data Modeling, Data Warehousing, Teamwork, Software Development Lifecycle (SDLC), Data Build Tool (dbt), Data Engineering, Data Migration, Performance Tuning, ETL Tools, Big Data, Entity Relationships, QuickBooks Online, Google BigQuery, SSRS Reports, APIs, Metabase, Analytics, Machine Learning, Pipelines, Data Analysis, Fivetran, Data Analytics

Frameworks

.NET, ASP.NET, VB.NET WinForms

Tools

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

Platforms

Azure, SharePoint 2013, SharePoint, Salesforce, Amazon Web Services (AWS)

2000 - 2004

Bachelor's Degree in Computer Information System

Kennesaw State University - Kennesaw, GA

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