Tandi Dell
Verified Expert in Engineering
Data Engineer and Developer
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
Experience
Availability
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
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.
Consultant
EnterpriseWorx
- 设计流程和报告,以验证客户BI平台上数据的完整性.
- Developed a master data solution with interfaces in an SAP environment for a retail chain.
- 构建报告和仪表板,使主数据团队和数据管理员能够识别和合并不同零售链中的重复产品,从而获得每个产品的黄金记录.
- 为SAP数据迁移项目从多个不同平台上的系统创建自动数据提要.
Consultant
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.
Consultant
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.
Consultant
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.
Business Analyst and Software Development Manager
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.
Volunteer
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.
Software Engineer
NetIQ
- Developed and maintained a SQL Server monitoring system written in VB.NET.
- 向SQL Server产品团队的其他成员提供技能和知识,分析和纠正常见的客户SQL Server问题.
- 处理一线和二线客户支持团队无法处理的客户支持问题.
Senior Software Developer
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.
Software Developer
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.
Developer
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协调开发请求并为任务分配适当的开发人员.
Experience
Investment Fund Reporting
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
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
During this project, 我与CRM开发团队密切合作,以确保我开发的管道在规定的时间框架内交付预期的数据.
The audit logs that were developed exceeded the expectations of the client. 他们很高兴地看到,他们可以很容易地根据这些数据建立自己的报告,以解决审计人员提出的任何疑问.
Report Usage Analysis
•与业务用户进行研讨会,了解他们的报告使用情况和关键报告需求.
•利用技术资源促进研讨会,以了解遗留环境和建议的新报告环境.
•在SSRS元数据上创建SQL脚本,以识别最近使用的SSRS报告及其引用的数据库和表.
•在Azure Databricks数据库上构建SQL脚本,以识别高级版和专业版Power BI报告的使用情况.
• Developing SQL scripts to identify cross-server and cross-database queries.
Education
Bachelor's Degree in Mathematics and Computer Science
University of South Africa (UNISA) - Pretoria, South Africa
Certifications
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
How to Work with Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring