Irfaan Ebrahim
Data Analyst/Data Engineer at PBT Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Afrikaans Professional working proficiency
Topline Score
Bio
Credentials
-
Microsoft Certified: Azure Fundamentals
MicrosoftJul, 2021- Nov, 2024 -
MTA: Database Fundamentals - Certified 2016
MicrosoftNov, 2016- Nov, 2024 -
MCSD: App Builder — Certified 2016
MicrosoftSep, 2016- Nov, 2024 -
Microsoft Certified Solutions Associate: Web Applications
MicrosoftSep, 2016- Nov, 2024 -
Microsoft Certified Solutions Developer: App Builder
MicrosoftSep, 2016- Nov, 2024 -
Microsoft Certified Professional
MicrosoftJul, 2015- Nov, 2024 -
Microsoft Specialist: Programming in C#
MicrosoftJul, 2015- Nov, 2024 -
Microsoft Certified Solutions Developer: Web Applications
MicrosoftDec, 2015- Nov, 2024 -
Microsoft Certified Solutions Developer: Windows Store Apps Using C#
MicrosoftSep, 2015- Nov, 2024
Experience
-
PBT Group
-
South Africa
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Data Analyst/Data Engineer
-
Mar 2023 - Present
Client: Capitec Business BankRoles: Data Analyst Data EngineerResponsibilities• Rewrite the on Prem ODS dB generated extracts off of the AWS Aurora Postgres database.• Assist with data migration tasks from the on premises ODS solution to the AWS cloud solution.• Improve and optimize data load times.• Improve and optimize report extraction times.• Build Automated Data monitoring dashboards to ease ops support manual monitoring.• Assist with migrating data from the EDL to the AWS Aurora Database• Automate file transfers between the Aurora cluster to S3 buckets and FSX file paths.• Provide any other assistance to team members and management on miscellaneous tasks.• Engage with Stakeholders to understand current business processes and help to improve and deliver streamline data extracts, dashboards and other reporting. Show less
-
-
Data Migration Consultant
-
Jan 2023 - Mar 2023
Client: EncyclisRoles: Data Migration ConsultantResponsibilities• Work and assist the team to design and implement a migration strategy for moving data from Covanta US onto the Encyclis EU Dynamic 365 platform. • Business requirements gathering for the data migration needs.• Manage assigned risks and monitor potential impacts as part of the data migration plan.• Perform source system data analysis to manage source to target data mapping.• Perform migration and testing of static data and transaction data from one core system to another.• Perform data migration audit, reconciliation and exception reporting.• Manage cross-program data assurance for physical data items in source and target systems. Show less
-
-
Data Analyst/Data Modeler
-
Aug 2022 - Jan 2023
Client: Santam Roles: Data AnalystData ModelerResponsibilities - Data Analyst• Worked extensively on the IFRS Exploitation warehouse to help develop QlikSense reports for Business and IT.• Performed Data analysis and Data profiling using complex SQL on Cloudera.• Designed early stages of dashboards for business and IT to monitor and report the health of their data.• Used QlikSense to build Management reports to view claim and policy information.• Conducted data profiling to detect and correct inaccurate data and maintain the data quality.• Built and generated various reports using QlikSense.• Involved in writing SQL scripts for developers to use for ETL processing.Responsibilities - Data Modeler• Designed and created logical and physical data models for Facts & Dimension tables using Power Designer.• Analysed business requirements and designed Conceptual and Logical Data models.• Involved in Data flow analysis, Data modelling, Physical design, data performance analysis and tuning.• Created and maintained data modelling standards.• Re-Designed the IFRS17 Exploitation warehouse to fit proper BI standards for efficient data processing and reporting.• Provided data modelling assistance and insights to other applications and warehouses. Show less
-
-
-
Investec
-
United Kingdom
-
Financial Services
-
700 & Above Employee
-
Information Technology Lead
-
Jan 2022 - Jul 2022
RolePlatform Owner Team LeadResponsibilities - Platform Owner• Provide leadership and guidance for delivery for business teams to ensure agreed availability, supportability and operational capability.• Support key SDLC events.• Understand the existing platforms and their capabilities• Proactive identification of platform enhancements, lead business case approval process, facilitate communication of roadmaps and ensure stakeholder engagement.• Work collaboratively with business stakeholders and operational teams to lead prioritization of changes and leaf defect backlog prioritization.• Build and maintain a relationship network with key stakeholders.• Act as a point of escalation for platform related defects and major incidents.• Help to provide training within the department.Responsibilities - Team Lead• Manage IT staff by recruiting, training and coaching employees, communicating job expectations and appraising their performance.• Act in alignment with user needs and system functionality to contribute to organizational policy.• Identify problematic areas and implement strategic solutions in time.• Handle all Audit requirements.• Handle annual budget and ensure cost effectiveness. Show less
-
-
Data Engineer and Analyst
-
Mar 2021 - Jul 2022
RolesData EngineerData AnalystResponsibilities • Create and maintain Data solutions.• Identify, design, and implement internal process improvements.• Automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.• Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs• Work with different teams to integrate data between systems• Design, Build and maintain a central big data warehouse for all Risk data across in the organizationProjects Delivered• ADR (Arrears, Defaults and Recoveries) business day 1 sign-off Build a timeous and accurate solution for business stakeholders to adjust and publish month end data into the database.• EME (Exposure Management Engine) delivery Built the Power BI reports and dashboards for business stakeholders ETL data from EME to GRoW and Sonic• Database Activity Monitoring Built and Modeled all database activities into a warehouse Created Power Bi Monitoring reports and dashboards• GRC Warehouse• Triplicity Reporting Data warehouse solution to store and report on all of the banks third party vendors Show less
-
-
Business Intelligence Developer
-
Jul 2018 - Mar 2021
Roles:Data EngineerData AnalystData OperationsResponsibilities• Translate business needs to technical specifications• Design, build and deploy BI Data solutions• Design and build Data Modelling solutions• Evaluate and improve existing BI systems• Use ETL tools to Integrate data between databases• Collaborate with teams to integrate systems• Defining business requirements and reporting them back to stakeholders• Create visualizations and reports for business stakeholders• Conduct unit testing and troubleshootingProjects Delivered• Adjustment Engine using Master Data servicesThe project was initiated to address the mandatory legal and regulatory requirements to ensure that a consolidated mechanism across Capital, Balance Sheet Risk and Credit is applied when amending or creating source data records reconciled to the General Ledger. These changes are required to be fully audit-able and access controlled to improve the reliability and integrity of the data.• GRoW (Group Risk Warehouse) Phase 3 and beyondThe warehouse collects and stores all Credit Risk data used for Month end and day to day reporting• ControlM Reporting WarehouseA solution designed to store and report on the ControlM jobs for Investec Bank • CLAW (Client Attribute Warehouse)A solution built to reconcile Client data between source and target systems• Created and designed various Power Platform Solutions for CSTech IDI Show less
-
-
-
BlueMonday
-
South Africa
-
Software Development
-
1 - 100 Employee
-
Business Intelligence Consultant
-
Jan 2017 - Jun 2018
Client: Investec Bank Roles Business Intelligence consultant Responsibilities • Translate business needs to technical specifications • Design, build and deploy BI solutions • Maintain and support data analytics platforms • Conduct unit testing and troubleshooting • Evaluate and improve existing BI systems • Collaborate with teams to integrate systems • Develop and execute database queries and conduct analyses • Create visualizations and reports for requested projects • Develop and update technical documentation Projects Delivered • Adjustment Engine using Master Data services The project was initiated to address the mandatory legal and regulatory requirements to ensure that a consolidated mechanism across Capital, Balance Sheet Risk and Credit is applied when amending or creating source data records reconciled to the General Ledger. These changes are required to be fully audit-able, and access controlled to improve the reliability and integrity of the data. Show less
-
-
-
CTU Training Solutions (Pty) Ltd
-
South Africa
-
Higher Education
-
300 - 400 Employee
-
SQL Technical Trainer
-
Aug 2016 - Dec 2016
Training Corporates on how to program with SQL using SSMS 2014. Microsoft courses: 70-461 70-462 70-463 Training Corporates on how to program with SQL using SSMS 2014. Microsoft courses: 70-461 70-462 70-463
-
-
Education
-
2016 - 2016
CTU Training Solutions
MCSE BI: Database Developer, Software Development -
2015 - 2015
CTU Training Solutions
MCSD: It Solutions Development, Software Development -
2009 - 2013
Krugersdorp High School
High School, Matric (NSC) with exemption
Community
