Edwin Mahanci

Experienced Business Intelligence Developer with a strong track record in Business Intelligence and Data Analytics. Consistently drive positive business outcomes through strategic data acquisition, processing, manipulation, and presentation for decision making. Automate data sourcing processes and implement accessible data storage solutions. Collaborate with cross-functional teams to solve complex challenges and gather requirements. Implement robust data-driven solutions to double business efficiency, enabling executives to make informed decisions for increased profitability. Seeking a role in Business Intelligence/Data Engineering/Architecture to contribute to a strategic approach to data, focusing on process improvement, data-driven solutions, and data democratization. Committed to continuous improvement and dedicated to team success.

• Covered on 2018/2019 Annual Report - Public Investment Corporation
• Beyond Award - Discovery Insure
• Named BI Business Partner for Claim, Retention and Legal Department - Discovery Insure
• Delegate for Data Mart Project Lead - ABSA Bank Limited

• Data and System Engineer, Sanofi Aventis - Business Operation and Support, 11/01/23, Current, Building Power BI Dashboard to track product promotions and campaign by integrating data from 3rd party channel., Introducing Power BI Landing page for a one-stop-shop integrated report ecosystem., Data Quality interrogation for existing ETL process Source to Destination., Testing and Validating Power BI model that have been decommissioned from Qlik Sense., Contributing in the construction of the model that is going paying incentives to the Field Rep by defining critical data points.
• MI and BI Technical Consultant, Absa Bank Limited - Transformation and MI team, 11/01/22, 10/31/23, Defining the Data Strategy for the data flow and accurate MI processes., Enabling the SQL capability amongst the team by building Data Mart structures in SQL server as the main data repository/storage layer for that is used as a central data source., Creating the historical data using Slow Changing Dimension (SCD) model in SSIS for the purpose of data auditing, tracking changes that occurred over the period., Collaborating with team members to enable the automation capability for the manual processes such as data sourcing from internal and external systems and other data sources., Participating within the process improvement team to establish ways to Improve business processes with automation being the key focus., Building the Microsoft Power BI report and contributing with skills sharing within the team., Designing ETL processes to source data using the SSIS to automate finance data pipeline sources used for servicing stakeholders form different business unit., Data Extraction from SAP, Coupa for Account Operation and Account Payable as per the stakeholder requirement.
• BI Developer, Momentum IX - Data Engineering Team, 01/01/22, 10/31/22, Engaging with the stake holder to understand their requirement, problems and need for BI Solutions that we then structure in a way that they can be able to engage with for self-service., Working with data from Google Analytics (GA) to track the customer activities and customer experience with the organization products., Implementing the BI Management Solution Process that include creating testing environment and production environment for the BI solutions. Documenting the structures, Processes, and templates for the BI environment., Building the integrated dashboard for the Momentum IX department that is used to track the customer experience when engaging with the products from different product houses., Collaborating with different Product Houses to help integrate customer activity flow within the product house., Extracting data from the warehouse using SQL to build the customer view that then integrate customer details with the customer data coming from Google Analytic., Exposure to the Data Architect Solution for the ongoing process of building Data Reservoir in the cloud infrastructure using some of the Amazon Web Service (AWS) products.
• BI Data Analyst, Discovery Insure - Actuarial Science Department, 04/01/21, 12/31/21, Working on MS SQL data extraction and SSRS report as per request for both Personal Line (PL Policies) and Discovery Business Insurance (DBI Commercial Policies)., Building a reporting dashboard for different business unit including Retentions Team, Claim Team, Legal Team for the use of making informed business decision and reporting on the team's performance stats, turnaround times (TAT), last contact made to client, recoveries amounts, liabilities amount, savings, ROI, acknowledgment of dept (AOD), tracking competitors., Making enhancement to the existing dashboards to add more information required for the business to make more informed decision., Monitoring reporting dashboard to ensure that there is timeously update as schedule for each day and monitor the accuracy of the data on daily bases., Requirement gathering for the new apps defined by the stakeholders in request., Delivering extract distribution to brokers and internally as per request mostly for Personal Line (PL Policies) and sometimes for Discovery Business Insurance (DBI Commercial Policies) - Ad hoc.
• RAMS Data Analyst - CONTRACT, Gibela Rail Transport Consortium - RAMS Team, 09/01/20, 03/31/21, Analyze the reliability and safety data of the rolling stock and maintenance of the trains., Monitoring the train's Reliability, Availability, Maintainability, and Safety., Optimization of spreadsheet file using VBA macros programming., Evaluating the train system., Data fleet analysis.
• Quantitative Data Analyst - CONTRACT, Public Investment Corporation - Research Quants Team, 03/01/18, 03/31/22, Creating and maintaining reporting dashboards in Power BI using advanced analytics programming in DAX., Defining data structures in MS Access using SQL for data extracted from various sources (for example, Bloomberg, Hiport), cleaning data, and transforming it to meaningful information to meet business needs and requirements., Retrieve data and manipulate it to create quantitative solutions and translate data into meaningful information that can be used to make business decisions., Database Management and Maintenance (Clean, Define, Update, Model and Administrate) data using SQL in MS Access., In charge of the overall investment portfolio dashboard, which includes an overview of asset classes, sector splits, and client mandated compliance., Analyzing asset classes behavior, their drivers and how they are affected micro-economic indicators., Perform research for ad hoc project and build up an understanding around new concept.