Mogomotsi Serumula

Business Intelligence Consultant at Cornastone Telecommunications
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
City of Johannesburg, Gauteng, South Africa, ZA
Languages
  • English Full professional proficiency
  • Tswana Professional working proficiency
  • Zulu Limited working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • South Africa
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Business Intelligence Consultant
      • Sep 2014 - Present

      :Using Pentaho Data Intergration, Metadata Editor,Report Designer : Analyse and validate data and advise management of any exception trends, problem areas that may put risk on the business : Log any problems to Huawei System : Develop and maintaining management monthly Reports : Pro-actively identify billing data gaps and find relevant solutions to problems : Active base management reporting and insights : Compile daily, weekly and monthly reporting Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Senior Data Analyst
      • Sep 2012 - Aug 2014

      :Using SAS Base,Enterprise Guide,Visual Analytics, SAS Management Console : Extract data from warehouse and convert into SAS to update Marketing/Analytics Database : Analyse and validate data and advise management of any trends, problem areas, opportunities and anomalies that may emerge to enable business owners to make key decisions : Liaison, consultancy and relationship building with managers, ensuring their information requirements are satisfied : Produce, maintain and make available monthly management and customer reports in Visual Analytics : Ensure all BCC’s(Bureau Credit Characteristics) are updated correctly : Develop Reports using Visual Analytics : Provide technical support for both internal and external users : Identification of trends in Marketing Database using a mixture of forecasting methods and other predictive analytic tool Show less

    • South Africa
    • Banking
    • 700 & Above Employee
    • Business Intelligence Analyst
      • Sep 2010 - Aug 2012

      :Using SQL, BASE SAS,ENTERPRISE GUIDE,SYBASE,EXCEL :Building Fraud Credit Card Database : Extract data from various sources and convert it into meaningful information that can enhance the effectiveness of business decisions : Load Data into the designated data storage facility via SAS process : Develop strategic, tactical or operational reports :Automate Monthly/Weekly/Daily Reports issues and current business needs : On-going production of MIS outputs and reports to ensure consistent information supply in the required format/frequency : Liaison, consultancy and relationship building with clients, ensuring their information requirements are satisfied : Liason and provide Fraud reports to SABRIC in monthly bases :Involvement in new projects, design and develop Business Intelligence solutions in line with business requirements Show less

    • South Africa
    • Financial Services
    • 700 & Above Employee
    • Data Analyst
      • Sep 2008 - Aug 2010

      Using SQL,ORACLE,,EXCEL,COGNOS :Extract Data from PL/SQL database :Responsible for Developing/Maintaining SQL Scripts :Developing Exception Reports :Design/Developing Dashboards Show less

    • South Africa
    • Financial Services
    • 700 & Above Employee
    • Data Analyst
      • Dec 2005 - Oct 2008

      Using SQL,SAS,ORACLE,DB2,,EXCEL :Analyse/Investigate,deal with queries related to data :Responsible for Balancing Monthly Statistics :Building Detailed Data Selection,Clients history :Monitoring quality of Information on our Database :Extract & Analyse Data :Costomise(e.g converting excel file to sas file,txt file and vice versa) :Loading data from warehouse to Local server :Producing Demographic Clients Profiles,Reports for Market Analysis :Make recommendations for Scoring System based on anlysis findings Show less

Education

  • Tshwane University of Technology
    Financial Information Systems, Information Technology
  • Tshwane University of Technology
    Financial Information Systems, Financial information Systems

Community

You need to have a working account to view this content. Click here to join now