Pitsoane - SAS Programmer - Halfway House, Midrand, South Africa

Moshabi Pitsoane

Halfway House, Midrand, South Africa


SAS Programmer


I have more than 15 years of experience using SAS Toolset in development, ETL, analysis and reporting within the Management Consulting, Financial Services, Telecommunications and Energy sectors.

Work History

Principal Business Intelligence Consultant

Muffin Consulting

From June 2013

Organisation: Muffin Consulting
Main Duties:
Gather and document requirements.
Data analysis.
Impact Analysis.
System analysis and design.
Development and Testing.
Deployment and Automation.

Main Projects: • MTN SP Commissions

Senior SAS Developer


September 2012 - June 2013

Organisation: In4Group
Main Duties:
Analyse requirements, Design and Build SAS ETL jobs to read in source data and load into Oracle Operational Data Store (ODS), Operational Data Mart (ODM) and Reporting Data Mart (RDM).
Test SAS ETL jobs.
Run deployed and automated SAS ETL jobs.
Migration of SAS ETLs from Oracle to Netezza targets.

Main Projects:
• Eskom BICC: Project Management System (PMS)
• Eskom BICC: Oracle-to-Netezza Migration
• Eskom BICC: Unicenter Service Desk (USVD)
• Eskom BICC: Transmission Dashboard
• Eskom BICC: Online Vending System (OVS)

Senior Business Intelligence Developer


April 2011 - August 2012

Organisation: Nedbank
Main Duties:
Gather requirements, analyze design, build, test and automate SAS ETL jobs.
Run Oracle ETLs to load the Generic Business Model (GBM) in Oracle.
Run SA Banks Act (BA) Returns from GBM.
Refresh Return cubes.
Handle user queries.
Administrator for GBM User Tool (GUT) user access.

Main Projects: • Process optimization and automation

MIS Analyst

FNB Payroll Innovations

August 2009 - February 2011

Organisation: FNB Payroll Innovations | FNB HR Shared Services
Main Duties:
Mass Input File processing into the Payroll Systems.
Tactical Reporting of Payroll Run.
Process Optimization.
Query Resolution.
Analysis, Design, Coding, Testing, QA and Implementation of new requirements.

Main Projects: • Process optimization

Senior SAS Developer

Atos Origin

January 2009 - July 2009

Organisation: Atos Origin
Main Duties: Data analysis. System analysis and design. Development and Testing.
Main Projects: • MTN PowerBill Project

Senior Business Intelligence Consultant

Ulwazi Integrated Solutions

August 2006 - January 2009

Organisation: Ulwazi Integrated Solutions
Main Duties:
Gather and document requirements.
Data analysis.
Impact Analysis.
System analysis and design.
Development and Testing.
Deployment and Automation.
First-line support for production processes.
Administration of the MIS process, data and reports environments.
Optimisation/Enhancement of existing processes.

Main Projects:
• MTN: Mobile Number Portability project
• MTN: Project One
• MTN: MIS Support
• MTN: Billing PC project
• MTN: High Value Postpaid Price Plans project
• FNB Payroll Innovations: MIS Optimisation
• FNB Payroll Innovations: Data Warehouse

Independent Contractor

Eskom Distribution, Old Mutual, Mayibuye Group

January 2005 - July 2006

Organisation: Eskom Distribution, Old Mutual, Mayibuye Group
Main Duties:
Client liaison to gather and document requirements.
Data analysis.
System analysis and design.
Development and Testing.
Deployment and Automation.
First-line support for production processes.

Main Projects:
• Mayibuye Group: Marketing Automation Data Mart
• Mayibuye Group: Call Centre Agent Remuneration Report
• Mayibuye Group: Telkom Reporting
• Mayibuye Group: Foschini Take-on
• Mayibuye Group: HomeChoice Customer Account Settlement
• Mayibuye Group: Billing process optimisation & automation
• Old Mutual: Client Movement (Attrition) report
• Eskom Distribution: Ukukala Project

Analyst Programmer


September 2002 - December 2004

Organisation: Arivia.kom
Main Duties: Systems Analysis and Design. EDW Development (backend [ETL] and frontend [Balanced Scorecard]) . EDW Maintenance.
Main Projects:
• Eskom Distribution: 726 project
• Eskom Distribution: Initial build of the Enterprise Data Warehouse

Analyst Programmer

Enterprise Data Warehouse

October 1999 - September 2002

Organisation: Standard Bank (Enterprise Data Warehouse)
Main Duties:
End-to-end MIS solution development and deployment.
Ad hoc queries, investigations and analysis.
Load data marts.
Campaign Management.

Main Projects:
• Commercial Bank MIS
• Retail Bank MIS
• Private Bank MIS
• Consent Clauses

Junior Consultant

ISAAS Data Engineering Services

December 1998 - September 1999

Organisation: Ernst & Young (ISAAS Data Engineering Services)
Main Duties:
Collect and analyse payroll data of audit client (Computer-Assisted Audit Techniques CAATs).
CAATs report creation and analysis, and
Share findings with Ernst & Young audit team

Main Projects:
• Transnet (PX, Group)
• Johannesburg Metropolitan Council

Trainee Analytical Chemist


December 1995 - April 1998

Organisation: AECI (Research & Development Department)
Main Duties: Chemical and biological sample analysis. Chemical Process optimisation experiments.
Main Projects:
• Chemical Analysis: Naproxen project
• Chemical Process Optimisation

Qualifications & Certifications

Johannesburg Centre for Software Engineering

SAS Institute

SAS Institute

SAS Institute


University of the Witwatersrand

Chemistry, Biochemistry

University of Durban

Tsogo High School

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?