Trishen Naidoo

2021-12 - Present

Department: Group Compliance IT

Senior Data Engineer

• Analyze complex data and identify anomalies, trends, and risks to provide useful insights to improve internal controls and service needs of different business lines.
• Modernize refactor and rebuild entire data estate, from ETL, Database and reporting leg.
• This Role is focused on Data Engineering, using Azure Cloud including but not limited to, Azure Data Factory, Azure Managed Instance, Power BI, Data Lake, Azure Dev Ops

2020-03 - 2021-11

Department: Data, Analytics and AI

Senior Data Engineer

• Some of responsibilities include but no limited to Develop, implement, and maintained data analytics protocols, standards, and documentation.
• Utilizing ADF to ingest data across different business segments.
• Create data products across different domains.

2018-02 - 2020-02

Department: Client Engagement Solutions (CES)

Technical Lead

Led a team engaged in BI development across various departments within CES.

Focusing on replacing QlikView and excel reporting to Power BI platform.

Converting manual processes/reporting to modern automated solutions. Modernize Semantic layer, create modern data warehouse and cubes that support solid reporting layer. Manage all aspects of data sourcing, migration, implementation and identify new initiatives for database growth, integration, and ETL processes. Ingestion, maintenance, and Optimization of entire ETL process Data Modelling

Department: Human Capital

Data Architect

Retention Project: Oversaw a Data science project that looked at several factors to determine if a person would leave the organization, flag them and alert management. Using python

ETL: Fix the stability of the process and increase the accuracy and reliability through various data governance endeavors.

Achievements

MMI Way Quarterly award 31/07/2018

MMI Way Quarterly team award 19/11/2018

MMI Way Quarterly award 18/02/2019

MMI Way Quarterly team award 18/02/2019

Highly regarded multi-skilled developer that had the opportunity to work in a greenfield environment, where reporting previously existed in Excel files. Built several streamlined, high performing datamarts and relational databases that serviced 8 countries, Manco, Exco and various business units, ranging from Project Management, HR, Retail and Business Banking and Wesbank. This, enabled me to be exposed to many different data sets and automating from acquisition of source to data cleansing, structuring of data, modelling, aggregations to consumption.

Resolved problems, improved operations, and provided exceptional service. Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.

Responsibilities

• Multi-faceted role focused on ETL development, cleansing of data, structuring data, automation, data architecture, data design

• SQL Development, the creation of complex stored procedures and queries

• DBA function provided optimization, enhancements, monitoring, design to the SQL infrastructure

• Defining the design strategy of database structure, design standards, taxonomy, implementation of best practices

• Manage Month end runs

• Coach and provide support to other team members

• Index creation and query optimization

Major Projects

• Team foundation server – Version control system for ETL and SQL Queries

• Logical Documentation – Documentation of Database structure and ETL processes with Visio

• Attrition – Track the performance and quality of accounts over a 6 and 12-month period

• Business VSI – Vertical sales integration of business banking products, to identify more cross-selling opportunities and the most valued clients.

• Project Management – Sourcing information from SharePoint lists, tracking Project Managers current/deployed/ pending projects their timelines, risk indicators across the 8 countries.

• Volumes – Monthly account volumes, that depict several indicators, such as active customers per country, types of products.

• Channels – Monthly transactional volumes from different “channels” such as, ATM, digital, branch etc. A large amount records 400 million + were stored, index creation and optimization was critical in maintaining performance.

• IT - Sourcing 8 files from various sources, to bring availability, incidents, branch stats, such that the IT department has oversight of infrastructure across the countries.

• VSI Cube Converting the Business VSI Project in an operational cube, that was consumed for deeper analysis in Botswana.

Respected Database Administrator with numerous years of experience, leading the design, installation, and administration of database solutions to optimally support business needs. Combined strategic planning and team development expertise with strong technical qualifications. Experienced in configuring, optimising and administering all features of MS SQL Server 2005, 2008, 2014 including logical and physical database design and migration, performance tuning, capacity planning, back-up/recovery and data redundancy. Recognized for receiving the Telkom Team Award for Maintaining 100% Uptime and was promoted to Specialist Database Administrator (Specialist Manager Level).

Responsibilities

• Assisting DBA teams in Database performance analysis, diagnosis and tuning (SQL Query Optimization, Storage and Network performance, CPU and Memory tuning). Participate in trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.

• Successfully resolving SQL server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, SSIS, backup/restore, database corruption, security, and contribute to continuous improvement.

• Perform SQL Server version upgrades, migrations, and deployment changes to production databases.

• Create and support SQL Server clustering and replication (log shipping or database mirroring) for servers in different geographies.

• Worked with vendors and developers to diagnose and resolve problems using tools such as SQL Profiler, Dynamic Management Views (DMVs), SSMS Standard Reports, SQL Server Error log file, and Performance Monitor (Perfmon) data.

• Monitoring Indexes for Performance Related issues

• Chairing the Innovation team in Gauteng, where we strive to develop better ways of doing things.

• Providing mentorship and guidance to the junior team and empowering them to develop themselves.

• SharePoint Champion for my team, delivering and maintaining several Business Intelligence solutions.

• Monitoring Indexes for Performance Related issues.

• Developing and maintaining SSIS packages and SSRS reports.

Major Projects

Service Desk External Clients: An over R10 million Project:

• Assisting with designing and implementing the SQL portion for this project. Deploying a highly robust solution, employing an active-active cluster, log shipping and transactional replication.

• Engineering and constructing a full business intelligence solution that pulls operational, health and performance information from several hundred servers. This raw data is consolidated, cleansed into several staging tables and ultimately stored in our data warehouse. In turn an OLAP layer is built on top, providing the analytics and creating subject specific cubes and data marts such as health checks, availability, performance metrics etc., which fed into our reporting layer. Building a reporting layer on top, integrated with SharePoint, and daily weekly and monthly reports are sent to the team, management and executive team. These reports range from SSRS PowerView to dashboards power map.

• Telkom Team Award for maintaining 100% uptime.

Responsibilities

• Designing and creating solutions for storing information from various source systems using tools such as SSIS. Building reporting layers on top of these.

• Continuously improving the quality, accuracy, integrity, and value of the data by giving input about the optimizing of data structures and integration of data from a variety of diverse systems that exist within the business.

• Ensuring all information is produced in an accurate, timely and professional manner.

• Assisting the business in achieving operational targets by providing relevant information, metrics, and measurements.

• Providing support for the various applications and implementing approved change requests.

Major Projects

Home Loans Customer Experience:

• The solution focuses on optimizing the HLRC data recording process which enhances data accuracy. Increasing efficiency and effectiveness of the home loan process and improving data integrity that has a cost saving element.

Vehicle Asset Finance: Error Monitoring System:

• A tool that will ensure that errors are stored and monitored. The main objective of this application is to give department heads reports that categorize errors caused. The application safeguards the accuracy and reliability of data. Reports were made available to MANCO. In addition, it will have the ability to track error impact on VAF sales.

Achievements

• Received the True Blue Award for Service Excellence Initiative or Innovation, Serving Customers, Growing Out People, Being Proactive and Working in Teams

Responsibilities

Software Developer (Jan 2009 – Apr 2010):

• Constructing software applications that conform to design specification utilizing multi-tier architecture.

• Conducting unit testing.

• Designing databases.

• Deploying SQL reports.

• Crafting staging environments.

• Handling design maintenance.

• Publishing web applications.

Major Projects

Software Developer: Matrix Zyon Mix Telematics:

• Developed a custom car tracking software for the back-end. The system tracked cars on Google maps and summarized alarms / panics in a widget-based interface utilizing Silverlight 3. The system is integrated with an ESB to coordinate all alarms / panics to the relevant recovery teams.

• Utilized TDD and agile methods and scrum.

• Assisting in the design and implementation of the database and data access layer.

• Creating automated unit testing and implementing several pieces of functionality.

Software Developer: Department of Trade and Industry:

• Developing use cases and use case diagrams for functional specifications document.

• Creating several reports utilizing SQL Server Reporting Services and implementing several stored procedures.

Intern: Ashanti Gold-Vale Side:

• Leading a junior team of 4

• Modifying and testing several stored procedures

• Re-designing and re-configuring several user reports

Achievements

• Received the BCX Professional Services Experience Award in recognition of Commitment to the PS Experience and Outstanding Performance.

Responsibilities

• Troubleshooting various computer related problems relating to hardware and software.

• Handling general PC maintenance (Defrag, formatting drives and scan disks).

• Installing software from Windows Office Microsoft products, SAP products, etc.

• Installing hardware and hard drive motherboards.

• Fixing printers' problems.

• Replacing old PCs with new ones.

• Backing up data.