Roy Wilfred Reginald Mc Gregor

Roy Mc Gregor - |-| Johannesburg, South Africa PROFESSIONAL SUMMARY Highly experienced Business Intelligence and Information Technology professional with over 30 years of expertise in data warehouse development, business intelligence methodologies, and IT project management. ● Adept at converting complex business requirements into practical solutions using tools such as Business Objects, Office 365, SharePoint, SQL Server Management Studio (SSAS, SSIS, SSRS), Teradata Studio, and Visual Studio. ● Seeking remote or hybrid opportunities to leverage technical skills and leadership in delivering impactful IT solutions. ● CORE COMPETENCIES ● ● ● Business Intelligence Tools: Business Objects, Office 365, SharePoint, SQL Server Management Studio (SSAS, SSIS, SSRS), Teradata Studio, and Visual Studio. Programming Languages: C++, CAML, CSS, COBOL, Datacom/IDEAL, HTML, and SQL. Data Management: Business Intelligence, Business Process Modelling, Data Integration, Data Warehousing, and Dimensional and Relational Analysis and Design. CERTIFICATIONS & TECHNICAL TRAINING ● ● ● ● ● ● ● ● ● ● ● ● ● ● Systems Analysis and Design Extended Dimensional Analysis and Design ETL Design Masterclass Business Objects Enterprise Data Warehouse Concepts, Fundamentals, Architecture, Modelling and Project Management Implementing and Maintaining Microsoft SQL Server (SSAS, SSIS, SSRS) SharePoint Designer and Workflow Team Management and Leadership New ERA Manager Project Management Development Programme for Middle Managers (DPMM) Certificate in Practical Management Implementing and Managing Enterprise Architecture Introduction to CMMI - (Staged and Continuous) Version 1.1 1 Roy Mc Gregor - |-| Johannesburg, South Africa TECHNICAL SKILLS BY AREA Operations: ● Managed large-scale IT operations across enterprise systems, ensuring high availability and performance. ● Oversaw SharePoint environments and business intelligence platforms at FNB and De Beers. Programming: ● Developed solutions using C++, CAML, CSS, COBOL, Datacom/IDEAL, HTML, and SQL. ● Automated business processes and enhanced legacy systems with custom programming. User Training: ● Conducted hands-on user training across Microsoft BI tools, SharePoint, and reporting dashboards. ● Created comprehensive user guides and conducted workshops for end users and IT teams. Documentation: ● Produced technical specs, SOPs, business requirement documents, and user manuals. ● Documented enterprise-wide data architecture strategies at Anglo Platinum and De Beers. Requirements Analysis: ● Led workshops to gather business requirements and convert them into technical deliverables. ● Defined project goals and aligned IT strategies to business needs across various projects. Systems Analysis and Design: ● Designed robust system architectures and workflows in banking and mining environments. ● Conducted impact assessments and data analysis to support system enhancements. Report Development: ● Created dashboards, scorecards, Business Objects and SSRS reports for MIS, PIMS, and MRM systems. ETL Development: ● Built and maintained SSIS packages to automate and streamline data processes. Systems Interfaces and Integration: ● Integrated multiple platforms, including Access, Datacom/DB, SAP, SharePoint, and SQL Server. ● Managed De Beers' interface systems for procurement, finance, and mining operations. Server Management and Technical Support: ● Administered SQL Server and SharePoint environments, handling upgrades and backups. ● Provided technical support and system troubleshooting for large user bases. Legacy Systems Replacement: ● Replaced mainframe and legacy systems at Namdeb and Fedlife with modern BI and ERP solutions. ● Archived critical legacy data using Access databases. 2 Roy Mc Gregor - |-| Johannesburg, South Africa Project and Programme Management: ● Managed BI and IT projects at FNB, De Beers, and Anglo Platinum. ● Designed frameworks, health checks, and project documentation repositories. Enterprise Architecture: ● Developed enterprise data models and metadata repositories. ● Contributed to corporate architecture initiatives at De Beers and Anglo Platinum. Business Intelligence Design: ● Applied Ralph Kimball’s methodology to develop data warehouses and dimensional models. SharePoint Development and Administration: ● Built workflows, custom lists, surveys, and permissions structures. ● Led document management compliance projects including POPIA implementation. Visual Studio Development: ● Used Visual Studio for BI package development (SSIS/SSRS), reporting, and data manipulation. Records Management: ● Defined retention schedules and access policies in SharePoint to meet POPIA standards. Data Warehouse Design, Development and Maintenance: ● Led DW initiatives using SQL Server and Sybase PowerDesigner. ● Maintained data marts and implemented new subject areas based on evolving business needs. Microsoft SQL Server (T-SQL, SSIS, SSRS): ● 15+ years of SQL Server experience including advanced T-SQL scripting, SSIS development, and SSRS report design. Management Roles: ● Mentored junior staff, supervised BI teams, and led technical decision-making. EXPERIENCE Business Intelligence Analyst FNB Commercial Mar 2009 to Dec 2024 General Responsibilities: ● Handled and resolved ad-hoc queries related to SharePoint, Workflows, SQL Server, SSIS, and SSRS, ensuring timely support and improved user satisfaction. ● Managed SharePoint document libraries, custom lists, workflows, surveys, calendars, and access control. ● Developed solutions for alternative data sources using SharePoint lists, Microsoft Forms, CSV or Excel files, and SSIS packages. ● Automated and streamlined manual reporting processes using SSRS. 3 Roy Mc Gregor - |-| Johannesburg, South Africa ● ● Delivered accurate and timely monthly Management Information Systems (MIS) reports, dashboards, league tables, scorecards, and ad-hoc reports. Delivered proactive support to internal FNB Commercial customers, enhancing their use of Microsoft solutions, improving user satisfaction, and increasing solution adoption. Microsoft Solutions: ● Assisted in defining and developing an end-state functional business intelligence strategy. ● Designed and implemented appropriate Business Intelligence architectures to support solution delivery. ● Analysed source system data and designed conceptual, logical, and physical data models. ● Designed SharePoint lists for capturing business data not available in existing source systems. ● Conducted business analysis to determine client information needs based on requests. ● Documented business requirements for approval by key stakeholders. ● Performed data analysis to assess data availability for meeting deliverables. ● Created technical specifications for solution development. ● Contributed to the design of subject area data marts, front-end solutions, and information packages based on best practices. ● Conducted thorough testing of solutions before deployment. ● Provided training and coaching to ensure clients could effectively use and interpret the information. ● Presented solutions to clients, offering insights into data trends and interpretation. Records Management: ● Following the enactment of the Protection of Personal Information Act (POPIA) in 2013, directed efforts to safeguard and manage personal information stored in SharePoint environments. ● Implemented strict access control measures for SharePoint document libraries, ensuring compliance with data protection policies. ● Established information management policies to automatically hide outdated documents, remove access, notify document owners, and archive redundant records. Project Management: ● Designed a comprehensive project management framework, including process steps, templates, checklists, defined roles and responsibilities, and a health check system. ● Prioritised change requests, contributed to project planning, coordinated project resources, and provided regular status updates. ● Measured customer satisfaction using SharePoint Surveys, capturing and analysing responses for service improvement. ● Maintained continuous communication and support for ongoing work, implemented solutions, and handled production support escalations. ● Provided technical leadership and guidance to business stakeholders. ● Ensured project requirements were well-documented and stored in a SharePoint document library. ● Helped define the vision, strategy, and implementation roadmap for the Information Management team. 4 Roy Mc Gregor - |-| Johannesburg, South Africa Reason for Leaving: ● FNB Commercial Bank retires employees at the age of 60. I retired in August 2024 and was offered a three-month contract to upskill two employees who applied for my role. Information and Data Architect Anglo Platinum - Group ICT Jan 2008 to Dec 2008 General Project Activities: ● Developed an Information and Data Architecture Bible to guide project teams in establishing information requirements. ● Designed templates for capturing business metadata and defining information requirements. ● Established Technical Design Specifications and Software Test Plan documents to standardise project execution. ● Documented methodologies for determining Business Strategy to align projects with organisational goals. ● Created a detailed project plan to serve as a structured framework for Information Management for Business (IM4B) projects. ● Provided expertise to multiple project teams, assisting with their Information and Data Architecture requirements. ● Captured metadata using Microsoft Office SharePoint Services List functionality for structured information management. ● Presented a series of workshops covering both basic and advanced Information Management concepts to upskill project teams. Reason for Leaving: ● The Information Management Enterprise (IME) project was closed due to budgetary constraints for the following year. As a result, my contract was not renewed. Senior Technical Consultant GijimaAST Holdings (Pty) Ltd May 2007 to Dec 2007 De Beers’ Business Intelligence Projects: ● Joined GijimaAST as part of an outsourcing agreement, continued to support De Beers' Business Intelligence Projects and maintained their BI environment. Reason for Leaving: ● Limited opportunities for project-based work, with a primary focus on support and maintenance, which did not align with my career aspirations. 5 Roy Mc Gregor - |-| Johannesburg, South Africa Business Intelligence Software Engineer De Beers Group Services Nov 2004 to Apr 2007 Production Information Management System (PIMS) Project: ● Extracted and transformed Planned Maintenance, Ore Extraction, and Ore Processing data from existing sources and loaded it into the PIMS data warehouse. Mineral Resource Management (MRM) Group Reporting Project: ● Extracted and transformed MRM data from the MRM staging database and loaded it into the MRM data mart. General Project Activities: ● Developed data capture systems using the List functionality in Windows SharePoint Services. ● Maintained the Data Warehouse Design using Sybase PowerDesigner. ● Designed ETL processes using Business Objects Data Integrator. ● Managed users, user groups, and access levels in Business Objects InfoView for Universes and Business Objects applications. ● Provided support for Central Laboratories and the Laboratory Information Management System. Technical Support: ● Administered software upgrades, service packs, hotfixes, and new installations, ensuring system stability and performance. Reason for Leaving: ● De Beers IT was being outsourced to GijimaAST. IT Programme Office Controller De Beers Group Services Apr 2003 to Oct 2004 IT Programme Office: ● Reviewed and updated existing Projects for Information Technology (ProfIT) methodology to ensure alignment with best practices. ● Developed a project website to communicate methodology and track project progress. ● Established a project documentation repository for templates, checklists, processes, and Project Management Body of Knowledge (PMBOK) resources to promote knowledge sharing. The Victor Mine Project: ● Reviewed the feasibility study, Class I and II estimates, and supplier quotes. ● Re-evaluated estimates, specifications, and the costing model to ensure accuracy and feasibility. ● Assisted in formulating the IT Strategy, approach, and responsibility framework for project execution. 6 Roy Mc Gregor - |-| Johannesburg, South Africa The Chargeback Model: ● Analysed existing Group IT services and consolidated them into a standardised chargeback model. ● Calculated the cost of service delivery and allocated service costs and recoveries per Group Company and business unit. Reason for Leaving: ● Recruited by the Business Intelligence Project for a new opportunity. Business Solutions Architect De Beers Group Services Nov 2002 - Mar 2003 Enterprise Architecture Project: ● Tasked with establishing a Modelling Office to support enterprise architecture initiatives. ● Conducted workshops to review, analyse, and recommend improvements to existing metamodels. ● Developed a Modelling Office website to publish revised metamodels and general Enterprise Architecture documentation. Reason for Leaving: ● Transitioned to the IT Programme Office for a new role. Systems Engineer De Beers Group Services Jan 2001 to Oct 2002 Business Solutions Project: ● Contributed to two successful Proof of Concept (POC) projects using Microsoft Project Professional and Microsoft Project Server. Systems Register: ● Developed and implemented a Systems Register using SharePoint Team Services list functionality to track and manage systems. Performance Management Financial Model: ● Designed a Financial Model in Microsoft Access to allow the Director of Operations to review and analyse Key Performance Indicators (KPIs). Technical Support: ● Administered and maintained SharePoint Portal Server workspaces, SharePoint Team Services websites, and Project Server environments. ● Managed several servers, including taking daily backups and overseeing software updates. 7 Roy Mc Gregor - |-| Johannesburg, South Africa e-Reka Project: ● Investigated, tested, and piloted the e-procurement system, Quadrem, to assess its potential for improving efficiency in inbound supply chain and procurement processes. ● Launched a pilot project at a Debswana site in Botswana to evaluate the system's effectiveness. Reason for Leaving: ● The Business Solutions Project was disbanded. I transferred to the Enterprise Architecture Project. Project Leader Namdeb Diamond Corporation (Pty) Ltd Jan 1996 to Dec 2000 Depot Interface System (Electronic Data Interchange EDI): ● Stabilised, maintained, and enhanced the Depot Interface System to ensure smooth operations. ● Extracted daily procurement data from mainframe databases and transmitted it to De Beers Depots. ● Uploaded data received from Depots to the Mainframe for further processing. ● Managed interfaces related to Anglo-American Catalogue (AMCAT) stock items, contracts, suppliers, and price updates. Materials System (Mainframe): ● Maintained and enhanced the Materials System, consisting of several sub-systems: Purchasing, Inventory Control, Namdeb Stock, Consignment Stock, Credit Control, Suppliers, Distribution, and the Masterpiece General Ledger. ● Stabilised the reconditioned stock work-in-progress reconciliation to ensure accurate inventory management. ● Gained exposure to legacy systems replacement with the implementation of an integrated SAP/R3 Business Management System. ● Archived legacy data into a Microsoft Access database for long-term storage and accessibility. Reason for Leaving: ● Seconded back to Corporate Headquarters in Johannesburg for a new assignment. Project Leader Fedlife Assurance Limited Jun 1992 to Dec 1995 Claim System (Mainframe): ● Maintained the Claim System and processed claims by calculating benefits based on member contributions, claim parameters, and actuarial formulas. ● Responded to user requests, ensuring efficient system operation and addressing issues as they arose. Schedule System (Mainframe): ● Stabilised, maintained, and enhanced the Schedule System to ensure accurate data processing. 8 Roy Mc Gregor - |-| Johannesburg, South Africa ● Produced monthly schedules of member contributions per employer, ensuring timely and accurate reporting. Voluntary Group Schemes System (Mainframe): ● Maintained the Voluntary Group Schemes System and ensured its smooth operation. ● Produced magnetic tapes containing monthly debit orders for processing. External Reporting (Mainframe): ● Managed external reporting functions, including benefit lists, benefit certificates, and contribution lists. ● Phased out the use of pre-printed stationery by creating macros for the Kyocera printer, improving efficiency and reducing waste. Administration System (Mainframe): ● Investigated and managed the implementation of the Administration System for the Cape Liquor and Catering Industrial Council, ensuring the system met organisational needs. Reason for Leaving: ● After two colleagues were tragically murdered while working late, I began seeking a quieter job in the countryside for personal safety and well-being. Senior Systems Analyst Sasol Industries May 1990 to Jun 1992 Sasol Oil Contract Sales System (Mainframe): ● Performed ongoing maintenance on the Sasol Oil Contract Sales System (SOCS), addressing incidents and implementing enhancements based on logged issues. Bitumen System (Mainframe): ● Designed and implemented the Bitumen System, which involved invoicing dispatches based on Bitumen prices per magisterial district sourced from SOCS. Batch Request System (Mainframe): ● Designed and implemented the Batch Request System, enabling users to request nightly processing runs. ● Managed the release of Job Control Language (JCL) via the Scheduler for processing requested tasks. Financial System (Mainframe): ● Implemented the Financial System by revising 3-year-old programs and re-designing certain areas to improve functionality and performance. ● Involved invoicing of dispatches, using railage tariffs obtained from the APL system and dispatches captured by financial users. Other Projects (Mainframe): ● Designed and implemented Value Added Tax (VAT) requirements for both the Financial and Bitumen systems to ensure compliance. 9 Roy Mc Gregor - |-| Johannesburg, South Africa ● Implemented the interface between the Financial and Tariff Control systems, streamlining data flow and improving operational efficiency. Reason for Leaving: ● Due to significant staff retrenchments, I was faced with an overwhelming workload, prompting me to seek a new opportunity. Analyst Programmer Productivity Software Limited Sep 1988 to Apr 1990 Sasol Industries (Sep 1988 to Aug 1989): ● Programmed, implemented, maintained, and documented the Marketing and Distribution System, covering functions such as order entry, dispatching, re-routing, inquiries, integrity control, and management reports. ● Produced a comprehensive document summarising all batch processing, including run parameters, programs executed, and reports generated to ensure clarity and traceability. Fedlife Assurance Limited (Sep 1989 to Apr 1990): ● Investigated and amended annual insurance premium increase programs for the Take-On System to meet updated requirements. ● Investigated and implemented two new products for inclusion in the Take-On System, expanding the system’s capabilities. ● Successfully moved the CHEQUE system into production and performed ongoing maintenance and change control. ● Appointed as Site Manager to oversee the administration of Productivity Software Limited (PSL) Contractors, including handling increases, appraisals, training courses, and timesheets. ● Acted as a liaison between PSL and Fedlife management, ensuring smooth communication and operations. Reason for Leaving: ● Productivity Software Limited lost the distributorship rights to market Datacom\IDEAL and Datacom\DB products, leading to my decision to seek a new opportunity. Programmer Save & Prosper Group (UK) May 1988 to Aug 1988 Commission System (Mainframe): ● Programmed the Commission System to recalculate commissions under the Financial Services Act of 1988, specifically for retirement annuities and endowment policies. ● Utilised an online IDEAL application to update VSAM files by invoking COBOL and ASSEMBLER modules for data processing. ● Developed an independent Data Dictionary to replace the existing Datacom version, improving system documentation and data management. ● Programmed Text Handling programs with built-in editor functions, enabling users to capture help screens and other general information. 10 Roy Mc Gregor - |-| Johannesburg, South Africa ● Trained users to independently create their panels for prototyping, empowering them to design system interfaces. Reason for Leaving: ● Returned to South Africa for personal reasons. Operator and Programmer EMI SA (Pty) Limited Mar 1985 to Dec 1987 Operations (Mainframe): ● Performed day and night shift duties as an operator. ● Monitoring a Systems Network Architecture (SNA) network that spanned all branches countrywide. Distribution System (Mainframe): ● Programmed and maintained the Distribution System in a warehouse environment, which involved managing key functions such as Order Entry, Invoicing, Stock Control, Dispatching, Returns, and Sales Analysis. Backups (Mainframe): ● Programmed and executed backup and restore modules to ensure data integrity and facilitate recovery during major file changes. Royalty’s System (Mainframe): ● Programmed, implemented, and maintained the Royalty’s System, ensuring smooth operation. ● Conducted user training and created a comprehensive user guide, which was mailed to EMI (UK) for review and feedback. Reason for Leaving: ● Moved to the United Kingdom for personal reasons. EDUCATION 1st Year Bachelor of Science (Chemistry) Witwatersrand University Johannesburg, South Africa Jan 1983 to Dec 1984 Matriculation Certificate (Humanities) Capricorn High School Polokwane, South Africa Jan 1978 to Dec 1982 11 Roy Mc Gregor - |-| Johannesburg, South Africa AWARDS/RECOGNITIONS SERVICE CHAMPION: "For tirelessly, exceeding customers' Expectations." FNB Commercial May 2014 PERFORMANCE AWARD: "Living Innovation." FNB Commercial Mar 2013 PERFORMANCE ACHIEVEMENT: "Commitment and outstanding performance on the FLIP team." Fedlife Assurance Nov 1994 ● This was awarded for the work undertaken to re-design and program the changes required to produce the benefit lists and certificates. PERSEVERANCE: "For the dedication and long hours worked to complete this difficult project successfully." Sasol Industries Nov 1991 ● This was awarded for the work undertaken to design, program and implement the VAT changes to the FINANCIAL and BITUMEN systems. WERKSPRESTASIE: "Bydrae tot die sukses van Sasol Olie Kontrakte projek." Sasol Industries Aug 1990 ● This was awarded for the work undertaken to design, program, train and implement the financial portion of the Sasol Oil Contract Sales system. 12