Jan Le Roux Email & Phone Number

• Created tabular models in Azure Analysis Services.• Developed financial dashboards and reports (Income Statements, Balance Sheets, Expense Reports, KPIs) in Power BI and Paginated Reports.• Creating Power BI Semantic Models.• Implementing advanced DAX measures and visuals in Power BI to provide business insights. • Developed tables, stored procedures, and Power BI reports for various clients.• Collaborating on building and optimizing Power BI reports using Databricks as the primary data source.

• Conducted data analysis using SQL and Power BI.• Liaised with business and SMEs regarding reporting details and data sources.• Created scripts for data transformation and loading in SQL.• Developed Power BI dashboards on customer usage.

Centurion, Gauteng, South Africa

Developed Financial and KPI Dashboards in Power BI. Developed ETL process in Azure by setting up the following: Data Factory, Storage Locations, SQL Server, Database and Tables.

South Africa

NetSuite Training. (ERP, Administrator, Essentials, SRP, Workflow).Consultant on Implementation. Configuration of NetSuite. Setup of Subsidiaries, Business Units, Classes, Taxes, COA, Accounting Lists, Customized Forms, User Roles, PDF Templates, Project Management, Timesheets, Fixed Assets, Expense Reports, various Custom Reports and Saved Searches.Worked on three international implementations. Data cleansing and importing data into NetSuite. Custom Roles, Forms and PDF Templates.

Midrand

During my time as a Senior Software Develop, I have worked on a number of projects both internally as well as for notable organisations including• Eskom• Sasol• South African Airways• BCX • Anglo American• Consul• Arivia• Old MutualKey deliverables include• Establishing, developing and maintaining scoreboard programmes and routines, allowing for automatic scoreboard updates and status reflection• Creating and loading routines from Pilog (material system) and obtaining Pilog reports and comparing against SAP data• Formulating, producing and implementing a variety of procurement and bursary reports through coding an extract routine to obtain data from SAP systems and SQL databases• Effectively coding load routines, allowing for extracted data file to updated into a separate data warehouse• Updating application configuration database with new and revised extraction routines and loaded reports and routines• Configuring extraction and loading routines to operate on predefined timeframes, resulting in production of appropriate reports• Updating user profiles, roles and definitions on the various applications• Installing, configuring and maintaining software for WebFOCUS, Apache Tomcat, Java-run environment and CEC reporting generation application • Establishing configuration of system integration port/adaptors to obtain data collection from various client systems, predominately SAP, and uploading relevant data into company data analysis tool and conducting data validation testing

Pretoria

This role was primarily focussed on systems analysis and financial management. Developed my skillset through gaining a comprehensive understanding of procurement, human resources and accounting processes as well as functionality, system requirements and internal control mechanisms.Developed and implemented the following reports• Procurement• Financial management• Human resource management• Bursary• Training• Service level agreements• Budget and forecast systems• Accounts receivable• Assets • Capital reportsThese reports and ETL processes were coded in WebFocus and loaded into a data warehouse.

Pretoria

I was accountable for generating and interpreting monthly and annual financial statements cash flow, cost centre control, account journal entries, account accruals and asset control.Compiled individual and consolidated business units monthly financial statements, variance reports and presented findings to key stakeholders.

Pretoria Area, South Africa

Responsible for invoicing, month-end procedures, general ledger link, general ledger accounts reconciliation, handling of enquiries and problems.Conducted the implementation of a new accounts receivable system which involved determining system requirements, testing the system and implementing once requirements and tests were satisfied.

Pretoria

Salaries