Tandi is available for hire
Hire TandiTandi Dell
Verified Expert in Engineering
Data Engineer and Developer
Location
Johannesburg, Gauteng, South Africa
Toptal Member Since
December 12, 2022
Tandi is a seasoned developer who has been solving business problems for 25+ years. 她的职业生涯始于一名软件工程师，15年前转为自由职业者，成为一名数据专家. During this time, she has designed and developed relational databases, data warehouses, data visualizations, and business intelligence solutions. Tandi has also performed data migrations and integrations, created ETL pipelines, and built enhanced back-end functionality for existing systems.
Portfolio
Altron Karabina
Microsoft SQL Server, T-SQL (Transact-SQL), Business Intelligence (BI)...
EnterpriseWorx
Microsoft SQL Server, T-SQL (Transact-SQL), ETL...
Altron Karabina
Microsoft SQL Server, T-SQL (Transact-SQL), SQL Performance...
Experience
Availability
Part-time
Preferred Environment
T-SQL (Transact-SQL), Microsoft SQL Server, SQL Server Reporting Services (SSRS), Microsoft Power BI, Data Modeling, Business Intelligence (BI), Data Analysis, Data Warehousing, SQL Server Integration Services (SSIS), Data
The most amazing...
...我共同拥有和开发的产品是一个数据库监控工具，在NetIQ在休斯顿收购它后，它被称为诊断管理器, Texas.
Work Experience
Consultant
2014 - PRESENT
Altron Karabina
- Developed SQL Server staging, operational data store (ODS), and data warehouse databases in BI solutions.
- Designed and developed ETL processes and pipelines to populate the staging, ODS, and data warehouse databases. Source and target data included Azure Data Lake storage, CRM, CSV and Excel files, SQL tables, and more.
- Architected and built interfaces between systems. 这包括创建审计日志和必要的错误处理，以满足系统的需求.
- Maintained and supported Power BI dashboards, SSRS reports, SSAS cubes, tabular models, and automated interfaces between systems.
- 执行数据分析和概要分析，以评估数据质量，并确定满足业务需求所需的必要的源到目标映射和转换.
- 在记录确定的业务规则和需求时，促进需求收集研讨会和与业务用户的访谈.
- Implemented relational data modeling to design operational data stores.
- Performed dimensional data modeling to generate the bus matrix for the project, following the Kimball methodology. 开发人员使用总线矩阵在数据仓库中创建一致的维度和事实表.
- Analyzed legacy systems and environments to prepare them for upgrading or decommissioning.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), Business Intelligence (BI), Data Warehousing, Data Integration, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI, Azure, ETL, Data Modeling, Data Profiling, Data Warehouse Design, Agile Sprints, Waterfall Methodology, SQL Server BI, Reporting, Technical Design, DAX, MDX, SQL Server Analysis Services (SSAS), Requirements Analysis, Data Analysis, Data Visualization, SQL, Microsoft Excel, Data, Data Cleaning, Data Cleansing, Data Analytics
Consultant
2008 - 2013
EnterpriseWorx
- 设计流程和报告，以验证客户BI平台上数据的完整性.
- Developed a master data solution with interfaces in an SAP environment for a retail chain.
- 构建报告和仪表板，使主数据团队和数据管理员能够识别和合并不同零售链中的重复产品，从而获得每个产品的黄金记录.
- 为SAP数据迁移项目从多个不同平台上的系统创建自动数据提要.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), ETL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Migration, Master Data, Data Integration, Reporting, Data Analysis, SQL, Data, Data Cleaning, Data Cleansing, Data Analytics
Consultant
2007 - 2010
Altron Karabina
- Performed troubleshooting and stabilization on an existing business-critical SQL BI System.
- Provided user support and maintenance on an existing business intelligence solution.
- Created ETL modules for multiple sub-systems used in the manufacturing environment.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), SQL Performance, SQL Server Reporting Services (SSRS), ETL, Business Intelligence (BI), Data Warehousing, SQL Server Integration Services (SSIS), SQL Server BI, Reporting, Data Analysis, Data Modeling, Requirements Analysis, SQL Server Analysis Services (SSAS), Technical Design, SQL, Data, Data Cleaning, Data Cleansing
Consultant
2006 - 2007
Entelect
- 评估客户现有的报告解决方案，并提出改进建议，以提供更灵活和可扩展的解决方案，使公司能够发展到未来.
- Developed a reporting and BI solution for a cellular provider.
- Developed ETL processes to load data from the ERP system to an operational data store.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), Business Intelligence (BI), ETL, SQL Server Integration Services (SSIS), Reporting
Consultant
2005 - 2006
IDS Consultants
- Created the ETL processes for a business intelligence project.
- Developed exception reports used in fraud detection.
- Built vetting processes for red-flag or green-light applicants.
Technologies: Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), ETL, Reporting, SQL Server BI, Data Analysis, Data Modeling, SQL
Business Analyst and Software Development Manager
2003 - 2005
Smollan
- Developed an HR reporting module over the existing payroll system.
- Provided technical support to the salaries department for the payroll system.
- Acted as the technical consultant on strategic projects within the company.
- 调查可以为公司增加价值和提供竞争优势的技术和产品.
- Gathered and documented user requirements around a talent acquisition system.
- Managed the development of the talent acquisition system.
- Built a Visual Basic.NET (VB.NET) module for a call center application.
Technologies: VB.NET, T-SQL (Transact-SQL), RPG, Microsoft SQL Server, Requirements Analysis
Volunteer
2003 - 2003
Freeme Wildlife Rehabilitation Centre
- Built an admittance system to keep track of all the animals that came to the center.
- 开发系统报告，显示成功率，释放，伤害，疾病等.
- Collected and transported injured animals and food donations.
Technologies: Microsoft Access, Software Development, Reporting
Software Engineer
2002 - 2003
NetIQ
- Developed and maintained a SQL Server monitoring system written in VB.NET.
- 向SQL Server产品团队的其他成员提供技能和知识，分析和纠正常见的客户SQL Server问题.
- 处理一线和二线客户支持团队无法处理的客户支持问题.
技术:Microsoft SQL Server, T-SQL (Transact-SQL)，软件开发，SQL性能，VB.NET, Waterfall Methodology, SQL
Senior Software Developer
1999 - 2002
Subquery Innovations
- Developed and maintained a SQL Server monitoring system written in Visual Basic 6 (VB6).
- Assisted with product marketing and sales at international conferences.
- Maintained the company website, including HTML content updates, uploaded new releases, and upgraded software products using FTP utilities.
- Handled telephonic and email customer support issues.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), Software Development, SQL Performance, Visual Basic, SQL
Software Developer
1996 - 1999
Qmuzik
- Developed and maintained modules of an ERP system written in VB6.
- Created a Data Warehouse component for an ERP application.
- Built an executive information reporting module for the ERP application.
- Assisted with user training, including compiling the training material and presenting the training topics.
Technologies: Microsoft SQL Server, T-SQL (Transact-SQL), Visual Basic, Software Development, SQL Performance, Reporting, SQL
Developer
1990 - 1996
Investec Group
- Built an electronic system to automate the banks' monthly payroll process, which resulted in substantial time and cost savings.
- 设置数据清理和分段例程，以便在不同的系统和平台(如Sybase和AS400)之间自动传输数据.
- Developed and maintained systems written in RPG and LANSA, which integrated with the primary banking system.
- Acted as a relationship manager between IT and specific business units within the bank. 其目标是让业务部门了解任何新的IT策略，并协助业务部门获得针对任何业务挑战的IT解决方案.
- 使用MS Project协调开发请求并为任务分配适当的开发人员.
Technologies: AS400, RPG, LANSA, Software Development
Experience
Investment Fund Reporting
Created an automated reporting solution related to investment portfolios. Developed multiple sets of reports over a multi-dimensional cube and a data warehouse. Each set of reports needed to be branded dynamically (logos, colors, fonts, etc.) so that the same report could be used for different clients.
The solution included the following:
• Monthly fund performance reports generated in pdf format.
•合并季度报告，通过动态改变其某些属性来杠杆化和合并月度报告, also generated in PDF format.
• Automatically updating embedded charts and images in PowerPoint presentations using SSRS.
•可下载的分页报告，供公司内部使用，并结合Excel和PDF报告与合作伙伴共享.
我负责与欧博体育app下载，以确定每个新报告集的确切需求, developing the MDX and T-SQL queries used by the reports, and developing the reports themselves.
自动化报告解决方案取代了劳动密集型的人工流程，每月为公司节省了数千工时.
The solution included the following:
• Monthly fund performance reports generated in pdf format.
•合并季度报告，通过动态改变其某些属性来杠杆化和合并月度报告, also generated in PDF format.
• Automatically updating embedded charts and images in PowerPoint presentations using SSRS.
•可下载的分页报告，供公司内部使用，并结合Excel和PDF报告与合作伙伴共享.
我负责与欧博体育app下载，以确定每个新报告集的确切需求, developing the MDX and T-SQL queries used by the reports, and developing the reports themselves.
自动化报告解决方案取代了劳动密集型的人工流程，每月为公司节省了数千工时.
Finance System Integration
The client's ERP system was missing key functionality. In addition, the existing interface into their finance system was essentially manual, and the process to overcome the limitations was time-intensive, prone to errors, and resulted in high-level, aggregated transactions in the finance system.
During this project, I addressed the limitations by delivering the following:
• Developed a SQL module that delivered reinsurance functionality absent in the ERP system.
• Created automated integration between the ERP system, the reinsurance module, and the finance system. 业务用户还可以通过Power Flow App组件按需执行界面.
• Created an operational data store used for reporting.
•用可下载的SSRS分页报告补充现有财务报告，以供进一步分析.
During this project, I addressed the limitations by delivering the following:
• Developed a SQL module that delivered reinsurance functionality absent in the ERP system.
• Created automated integration between the ERP system, the reinsurance module, and the finance system. 业务用户还可以通过Power Flow App组件按需执行界面.
• Created an operational data store used for reporting.
•用可下载的SSRS分页报告补充现有财务报告，以供进一步分析.
CRM Data Integration
使用KingswaySoft组件创建了一组SQL集成服务(SSIS)包，将数据加载到Dynamics CRM中. 有必要具备完整的审计能力，以识别诸如源记录数量之类的东西, destination records, count of new records loaded, updated records, error records, and package execution time.
During this project, 我与CRM开发团队密切合作，以确保我开发的管道在规定的时间框架内交付预期的数据.
The audit logs that were developed exceeded the expectations of the client. 他们很高兴地看到，他们可以很容易地根据这些数据建立自己的报告，以解决审计人员提出的任何疑问.
During this project, 我与CRM开发团队密切合作，以确保我开发的管道在规定的时间框架内交付预期的数据.
The audit logs that were developed exceeded the expectations of the client. 他们很高兴地看到，他们可以很容易地根据这些数据建立自己的报告，以解决审计人员提出的任何疑问.
Report Usage Analysis
分析遗留报表平台，为停用环境做准备，转而使用Azure Databricks报表和分析环境. In this project, I was responsible for the following:
•与业务用户进行研讨会，了解他们的报告使用情况和关键报告需求.
•利用技术资源促进研讨会，以了解遗留环境和建议的新报告环境.
•在SSRS元数据上创建SQL脚本，以识别最近使用的SSRS报告及其引用的数据库和表.
•在Azure Databricks数据库上构建SQL脚本，以识别高级版和专业版Power BI报告的使用情况.
• Developing SQL scripts to identify cross-server and cross-database queries.
•与业务用户进行研讨会，了解他们的报告使用情况和关键报告需求.
•利用技术资源促进研讨会，以了解遗留环境和建议的新报告环境.
•在SSRS元数据上创建SQL脚本，以识别最近使用的SSRS报告及其引用的数据库和表.
•在Azure Databricks数据库上构建SQL脚本，以识别高级版和专业版Power BI报告的使用情况.
• Developing SQL scripts to identify cross-server and cross-database queries.
Education
1992 - 1996
Bachelor's Degree in Mathematics and Computer Science
University of South Africa (UNISA) - Pretoria, South Africa
Certifications
JUNE 2020 - PRESENT
AZ-900: Microsoft Azure Fundamentals
Microsoft
Skills
Tools
SQL Server BI, Microsoft Power BI, Microsoft Access, Microsoft Excel
Languages
T-SQL (Transact-SQL), SQL, RPG, Visual Basic, VB.NET, MDX
Paradigms
ETL, Business Intelligence (BI), Requirements Analysis
Storage
Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Integration, SQL Performance, SQL Server Analysis Services (SSAS)
Platforms
Azure
Other
Data Warehousing, Reporting, Data Migration, Data, Data Cleaning, Data Cleansing, Data Analytics, Data Analysis, Data Modeling, Data Profiling, Data Warehouse Design, Technical Design, Data Visualization, Software Development, AS400, LANSA, Master Data, Agile Sprints, Waterfall Methodology, DAX
Collaboration That Works
How to Work with Toptal
在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
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