Mogomotsi Serumula
Business Intelligence Consultant at Cornastone Telecommunications- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Tswana Professional working proficiency
-
Zulu Limited working proficiency
Topline Score
Bio
Experience
-
Cornastone
-
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
-
-
-
TransUnion
-
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
-
-
-
FNB South Africa
-
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
-
-
-
Discovery Limited
-
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
-
-
-
WesBank
-
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