Hendrik Greyling

Hendrik Belsazar Greyling 6 Moepel Street Dalpark Brakpan Gauteng South Africa 1541 Cell No: - E-Mail:- Employment History Senior Business Intelligence Analyst, African Bank, Midrand12/11/2013 – Current Create SSRS and Power BI reports to track opening of newly launched MyWORLD transactional account. Ongoing data analysis to identify additional data sources. Develop Power BI Reports using Dynamics CRM (Online) as source to monitor Case Management and Engagement Engine performance. Develop Power BI reports for trend analysis. Develop Power BI reports for transaction monitoring to track possible system failures. Develop daily reports on transaction volumes for each service using SSRS (SQL Server Reporting Services), and distribute to users via automated subscription. Develop and maintain new ETL processes for the Bank’s new banking platform. Extract required column data inside XML columns, and columns containing JSON strings. Creating separate tables for each service available on the platform. Includes Internet Banking, Mobile App, Branch and Call Centre information. Develop MIS for Strategic Online Channel department. Using SQL Server SSIS, T-SQL Queries and SSRS, develop reports to track and monitor performance and customer experience of new Loan Products. Develop exception reports for new Loan Products. Document new reports as well as previously developed undocumented reports Document MIS requirements for Virtual Branch, which is being developed for the Bank. Interpreting Business Requirement Documents to determine Business rules for reports. Determine data sources for new reports (No Meta Data available), which was a major challenge. Develop report to track applications, offers and disbursement of loans originating from Call Center. Develop report to track applications, offers and disbursement of loans originating from Ellerines. Supply additional sales leads to Call Center. Develop reports for deployed and implemented Virtual Branch: Identify long running processes to enable optimization by Virtual Branch developers. Identify downtimes to enable optimization by Virtual Branch developers. Identifying service function errors encountered to enable correction and optimization by Virtual Branch developers. Successful activities – Showing every activity performed on the channel. Providing newly captured contact details to Collections Department to enable Right Party Contact. Cross Channel usage – WEB, USSD, MOBI and MOBI-APP Tracking process flow – determine drop offs between flows. (Waterfalls) Tracking applications, offers, offer take-up and subsequent disbursement of loans. Create Customer lookup to show registration status, contact details, security level, last login dates, and how many times each service function was used. Provide Call Center with data to enable them to contact customers who requested “Call me for Insurance” or “Call me for Investments” via Virtual Branch. Exception reports relating to external company used for customer authentication when registering for Virtual Branch or applying for loans. Extract data from Google Analytics to report on Devices, Browsers, Countries, Landing pages, Exit pages, New vs Returning visitors, Goal funnels, etc. Exception reports for unregistered customers who interacted with Virtual Branch, to enable customer contact for encouragement to register. Investigate anomalies in process flows and unrecognized error descriptions Consultant, Nedbank Rivonia Rd, sandton01/03/1995 – 08/11/2013 Develop a Management Information System for Retail Credit Department. Investigate and gather user requirements. Design and implement mainframe extract processes and reports using IBM AS. Started with paper based mainframe reports. Progressed to MS Access based reports by extracting Mainframe DB2 Data and distributing electronically. Design and implement prototype Credit Scoring System in MS Access for use by Card Division. Progress to SQL Server. Design and implement ETL Processes, and reporting system using SQL Server and Integration services. Distribute via auto refreshing Excel Pivots. Design and implement exception reports based on Credit Risk criteria. Introduced automated Reserve Bank reporting system. Assist External Auditors by extracting data for auditing purposes. Manage team of MIS Analysts / developers responsible for maintenance of reporting systems in SQL Server. Liaise with Senior Management regarding on going enhancements / further development requirements. Create Enterprise Data Store by designing and implementing accurate, consistent and efficient ETL processes to load data from various OLTP systems with MS SQL Server and Integration Services. Tasked with developing SSIS Packages to import all data from new Unix Based data repository instead of mainframe to Business Intelligence Department’s data store. Data Analysis. Data verification Create complex T-SQL queries and apply Business Rules in ETL Processes to users specifications. MIS Analyst, ABSA Bank JohannesburgMarch 1985 – 28/02/1995 Credit Controller, collecting outstanding debt from debtors. Gather user requirements for MIS System. Develop, test and maintain MIS Reports using Mainframe IBM AS. Develop Mainframe user interface for capturing data for Servcon Housing as per Government regulations. Credit Controller, Santam Bank, GermistonJanuary 1981 – February 1985 Debt Collection Legal Collections Manage Repossession Store. Education and Qualifications Matric, Afrikaans Hoer Durban Noord1974 Key Skills Power BI MS SQL Server SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services Visual Studio 2015 VB.NET MS Access VBA MS Excel VBA Mainframe IBM AS Mainframe MVS ASP.NET References Bruce Usher: Business IT Strategist - - Simon Marland: Head – Business Intelligence Solutions - - David Woolnough: Head – Transactional and Digital - - Abdul Hendricks: Senior Ops Manager – Transactional and Digital - -