Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

Lianni Pretorius

Data Analyst (Business Intelligence And Analytics)
Benoni

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

15
15
years of professional experience
2
2
Languages

Work History

Data Analyst (Business Intelligence and Analytics)

Transnet Freight Rail
03.2018 - Current
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Used statistical methods to analyze data and generate useful business reports.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Utilized data visualization tools to effectively communicate business insights.
  • Participated in requirements meetings to understand business needs.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Trained junior analysts on best practices, improving overall team performance and productivity.
  • Tested data prediction algorithms based on historical data.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Designed custom tracking systems to monitor KPIs, ensuring alignment with organizational goals and objectives.
  • Optimized company resources allocation with detailed forecasting models based on historical data analysis.
  • Presented findings to executive leadership teams through concise presentations, influencing future strategy development.
  • Resolved complex business challenges by leveraging statistical modeling techniques and machine learning algorithms.
  • Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
  • Established a culture of continuous improvement by fostering open communication channels and encouraging feedback on data analysis methodologies.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Created dashboards to monitor and track key performance indicators.
  • Created data models to support decision-making processes.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Generated standard and custom reports to provide insights into business performance.
  • Optimized data access and storage to improve performance of analytics systems.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Generated ad-hoc reports to evaluate specific business requirements.

Internal Controls Specialist / Data Analyst

Transnet Freight Rail
03.2009 - 02.2018

· Servicing GMs on the follow items: Audit issues, Control Self Assessments, and PFMA.

· Payment Exception reporting

· Continuous Control Monitoring

· GM Ratings

· Creation of MIS reports from inception to implementation

· Engaging stakeholders on reporting requirements

· Extracting, processing and distribution of information

· Creating dashboards for Management and Executive Management

· Presenting at various forums

· Creating dashboards on SAP Lumira

Education

GCE Talent Nurturing Programme - GCETNP

WITS
Johannesburg
04.2001 -

Bachelor of Commerce - Quantitative Management

University of South Africa
Johannesburg
04.2001 -

Postgraduate Certificate - Financial Management

University of Johannesburg
Johannesburg
04.2001 -

Bachelor of Science - Mathematics And Economics With Financial Orientati

University of Johannesburg
Johannesburg
04.2001 -

Skills

Data Modeling

Software

C

R

R Studio

SAP HANA

Qlikview

BOBJ

Advanced Excel

SAP Lumira

Timeline

Data Analyst (Business Intelligence and Analytics)

Transnet Freight Rail
03.2018 - Current

Internal Controls Specialist / Data Analyst

Transnet Freight Rail
03.2009 - 02.2018

GCE Talent Nurturing Programme - GCETNP

WITS
04.2001 -

Bachelor of Commerce - Quantitative Management

University of South Africa
04.2001 -

Postgraduate Certificate - Financial Management

University of Johannesburg
04.2001 -

Bachelor of Science - Mathematics And Economics With Financial Orientati

University of Johannesburg
04.2001 -
Lianni PretoriusData Analyst (Business Intelligence And Analytics)