Endy is currently unavailable
Endy Kalu
Verified Expert in Engineering
Software Developer
Sheffield, United Kingdom
Toptal member since November 9, 2020
Bio
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.
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 years
- Transact-SQL (T-SQL) - 16 years
- SQL Server Reporting Services (SSRS) - 15 years
- SQL Server Integration Services (SSIS) - 12 years
- VB.NET - 10 years
- PostgreSQL - 5 years
- JSON - 5 years
- Microsoft Power BI - 4 years
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, Dashboard Development, Clio API, API Integration, Looker Studio, Database Design, Database Schema Design, Automation
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, Clio API, API Integration, Looker Studio, Database Design, Database Schema Design, Automation
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, Machine Learning, Looker, Pipelines, Database Development, Database Modeling, Data Migration, Performance Tuning, Dynamic SQL, Big Data, Entity Relationships, Data Modeling, Data Analytics, Data Warehousing, Teamwork, Business Intelligence (BI), Clio API, API Integration, Looker Studio, Database Design, Database Schema Design
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, Clio API, API Integration, Looker Studio, Database Design, Database Schema Design, Automation, 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, Business Intelligence (BI), Looker Studio, Database Design, Database Schema Design
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, Dashboard Development, Database Schema Design, Pipedrive, QuickBooks Online, Automation
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, Looker Studio, Database Schema Design, Pipedrive, Automation
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#, Transact-SQL (T-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, Business Intelligence (BI), Looker Studio, Database Schema Design, Automation
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, Looker Studio, Database Schema Design
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), Transact-SQL (T-SQL), SQL Server Reporting Services (SSRS), Database Development, Microsoft SQL Server, SQL Stored Procedures, .NET, Dynamic SQL, Big Data, Business Intelligence (BI)
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), Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server 2015, SQL Stored Procedures, .NET, Big Data, ETL, Data Warehousing, Teamwork, Dashboard Development
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, Transact-SQL (T-SQL), Microsoft SQL Server, SQL Server 2015, .NET, Dashboard Development
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, Transact-SQL (T-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, Clio API
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: Transact-SQL (T-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: Transact-SQL (T-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: Transact-SQL (T-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, Transact-SQL (T-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: Transact-SQL (T-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), Transact-SQL (T-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: Transact-SQL (T-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, Transact-SQL (T-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), Transact-SQL (T-SQL), Crystal Reports, SQL Stored Procedures
Experience
eCommerce Retail Dashboard
https://www.dropbox.com/s/40py1efbfggwiux/Retail_Dashboard.pdf?dl=0A 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=0I 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.
Education
2000 - 2004
Bachelor's Degree in Computer Information System
Kennesaw State University - Kennesaw, GA
Skills
Libraries/APIs
REST APIs, Pandas, Salesforce API, QuickBooks API, Clio API
Tools
pgAdmin, TFS, Microsoft Power BI, Excel 2010, System Center Configuration Manager (SCCM), Crystal Reports, GitLab, PyCharm, Microsoft Excel, Snowplow Analytics, GitHub, Recurly, Looker
Languages
Transact-SQL (T-SQL), SQL, Snowflake, C#, VB.NET, XML, Active Server Pages (ASP), VBScript, Python
Paradigms
ETL, Database Development, Business Intelligence (BI), Database Design, Automation
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, Cloud Firestore, PSQL, Netezza, SQL Server 2014, MySQL, SSAS Tabular, SQL Server 2005, SQL Server 2008, SQL Server Management Studio (SSMS), Redshift, Data Pipelines
Frameworks
.NET, ASP.NET, VB.NET WinForms
Platforms
Azure, SharePoint 2013, SharePoint, Salesforce, Amazon Web Services (AWS)
Other
Data Reporting, APIs, Data Engineering, SQL Server 2015, QuickBooks Online, Data Modeling, Data Warehousing, Teamwork, API Integration, Database Schema Design, Software Development Lifecycle (SDLC), Data Build Tool (dbt), Data Migration, Performance Tuning, ETL Tools, Big Data, Entity Relationships, Dashboard Development, Looker Studio, Pipedrive, Large Language Models (LLMs), Optical Character Recognition (OCR), Google BigQuery, SSRS Reports, Metabase, Analytics, Machine Learning, Pipelines, Data Analysis, Fivetran, Data Analytics, PDF
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