Sharon Tiepelt

Working on MANEB EMS project, Tendaji internal projects, Malawi NRWB project. Working on MANEB EMS project (May 2023 till current) as the project manager/ project co-ordinator, working on the Tendaji internal projects for the timesheet application and the Teams, SharePoint upgrade and migration as the project manager; working as the Project Manager and BI Business analyst on the Malawi NRWB project. (May2023 till current). Worked on the Hollard HGR Data Warehouse project. (Aug 2021 to Dec 2022) Source to Target mapping, data dictionary and data mapping documentation. Functional Report Requirement Specification- with field mapping, report scripts and mock-ups of reports. Interacting with the customer to find out what they require in scoping sessions. Running workshops to get the requirements and to follow up on details of the fields, formulas required and the layout of the reports required. Following up on user queries and support tasks. Business analysis of user requirements and doing the related data analysis. Documenting the data model fields and doing a comparison between databases to ensure that the fields are in the views and in the development database and that the data types are the same for the related fields. Checking the scripts in the views to see how the views have been created. Creating scripts for the report writer and testing the data against the customers current reports that they get from the source. Testing the reports that are generated from SSRS. Doing data analysis from the source data to ensure that the correct fields are being used in the views. Documenting the source to target fields and the calculations required for the reports. Working on CoreSuite and mapping the fields and tables. Creating the reports from the source tables and testing the data against the user interface of CoreSuite. Project management entails interacting with the stakeholders, risk management, issue management, setting tasks for the team, communicating at all levels.

Working on MANEB EMS project (May 2023 till current) as the project manager/ project co-ordinator.
Working on the Tendaji internal projects for the timesheet application and the Teams, SharePoint upgrade and migration as the project manager.
Working as the Project Manager and BI Business analyst on the Malawi NRWB project (May 2023 till current).
Worked on the Hollard HGR Data Warehouse project (Aug 2021 to Dec 2022).
Source to Target mapping, data dictionary and data mapping documentation.
Functional Report Requirement Specification with field mapping, report scripts and mock-ups of reports.
Interacting with the customer to find out what they require in scoping sessions.
Running workshops to get the requirements and to follow up on details of the fields, formulas required and the layout of the reports required.
Following up on user queries and support tasks.
Business analysis of user requirements and doing the related data analysis.
Documenting the data model fields and doing a comparison between databases to ensure that the fields are in the views and in the development database and that the data types are the same for the related fields.
Checking the scripts in the views to see how the views have been created.
Creating scripts for the report writer and testing the data against the customers current reports that they get from the source.
Testing the reports that are generated from SSRS.
Doing data analysis from the source data to ensure that the correct fields are being used in the views.
Documenting the source to target fields and the calculations required for the reports.
Working on CoreSuite and mapping the fields and tables.
Creating the reports from the source tables and testing the data against the user interface of CoreSuite.
Project management entails interacting with the stakeholders, risk management, issue management, setting tasks for the team, communicating at all levels.
Following up on deliverables, ensuring that times are stuck to, as far as possible.
Liasing with the client to get deliverables, source systems, user input about the data and fields, training and coaching.
Testing of the reports.
Analysis of the source systems, the fields and what tables they come from.
Map source to target, gap analysis, data dictionary, report requirements specifications, workshops with the client and find out the business requirements, follow up with where the data is stored and map the data.

Creating SSIS etl packages, SSRS reports, Power BI reports.
Following up on support calls.
Managing the reports and the user security.
Creating surveys for internal departments to see how effective their audits have been.
Following up on user queries and support tasks.
Rerunning failed report schedules and sql packages.
Creating tables in the database.
Analysis of user requirements.
Troubleshooting of any errors in the reports or etl jobs.
Project manager responsible for defining project objectives.
Following up with the project team on the open tasks.
Holding weekly status meetings.
Setting up and maintaining the project plan.
Escalating risks to the project sponsor and to the relevant managers.
Weekly feedback to the project sponsor.
Monthly steerco meetings.
Interaction with project team.
Team feedback.
Managing the risk register and issue register.
Interacting with the change control team.
Maintaining the task schedule plan.
Leading the project team to achieve the project objectives.
Working with resources and doing resource planning.

Business Intelligence Consultant : Creating SSIS etl packages, SSRS reports, Power BI reports. Following up on support calls. Managing the reports and the user security. Creating surveys for internal departments to see how effective their audits have been. Following up on user queries and support tasks. Rerunning failed report schedules and sql packages. Creating tables in the database. Analysis of user requirements. Troubleshooting of any errors in the reports or etl jobs. (From 1 September 2018 to 31 May 2020)
Project manager responsible for defining project objectives, following up with the project team on the open tasks, holding weekly status meetings, setting up and maintaining the project plan, escalating risks to the project sponsor and to the relevant managers, weekly feedback to the project sponsor, and monthly steerco meetings, interaction with project team, team feedback, managing the risk register and issue register, interacting with the change control team, maintaining the task schedule plan, leading the project team to achieve the project objectives. Working with resources and doing resource planning. (From June 2020 to July2021)

Creating training manuals and training Santam and PEP users on XI3.1, Designer, Webi, Administrator.
Worked on the Ubora project at STD Bank (October 2013 to 30 November 2015).
Creating reports using Webi XI4.0 and Designer and CMC (Administrator), SAP Business Objects.
Worked on the Asset and Config (CMDB) reports.
Learnt the basics of BMC Remedy.
Created SAP Business Objects reports off a database created from the Remedy tables.
Creating report specs, giving users training, supporting users, doing the administration function of SAP Business Objects, scheduling reports, creating and updating the universe (Designer and IDT).
Balancing figures to Remedy, so understand the basics of Remedy.
Mentoring internal staff and client staff.
Mentored an internal staff member.
Worked on Lumira for a demo.
Migrating reports from 1 environment to another.
OBIEE report development and back end.
Basic freehand SQL.
Working on MTN BIB Project- Ghana IT Helpdesk reports, Ghana Datamart reports, working on OBIEE report migration for Iran Datamart4 project.
OBIEE IS Flash Reports project for MTN Nigeria.
OBIEE CEO Dashboard for MTN Nigeria, OBIEE Platform Revenue for MTN Nigeria, OBIEE VAS & Data for MTN Nigeria, OBIEE Voucher Report for MTN Nigeria, OBIEE COO Dashboard for MTN Nigeria, OBIEE CS6 reports, MTN Nigeria 95 Reports, Iran Helpdesk Reports conversion from “old” server to a new server, MTN Ghana IT Helpdesk reports.
Creating the Repository using OBIEE administrator.
BI Publisher, Fusion Middleware, Agents and alerts.
Working on Qlikview reports at Bryte Insurance.
Moving the system from I90 to TIA and need to update the reports with the TIA fields data.
Creating new insurance reports using Qlikview.
Working on an internal project using T-SQL to create the queries, SSMS to manage the server, SSIS to do the etl- creating projects and packages, SSAS to create the OLAP denormalised database and SSRS to do the querying off the normalised data and Power BI to do the dashboards or visualisations.
Using Power Pivot to do Data Modelling.
Accessing data from websites, Sequel database and excel spreadsheets.
Using Visual Studio as the tool to allow the tools to work.
Working on M7 report at SITA Centurion.
Data and business analysis to see how the data fits into the report.
Field mapping and reverse engineering the solution.
Meeting with users to find out how they have created their current report.
Finding the source data and mapping it to the data that is in the M7.
Data integrity checking and making certain fields compulsory for input into the system, to ensure correct joining of the tables.
Working on SSRS, MSMS (Microsoft Sequel Server Management Studio), T SQL.
Tracking the issues and questions in an “issues log”.
Interacting with the business users to assist in getting the solution to meet what they require.
Data mapping from source to target tables.
Assisting in managing the project to ensure that the resources meet their deadlines.

SLA’s, customer liaison, monthly reports, internal and external training, customer liaison, Managing a team of support consultants, Proposals, RFP’s, product research.
Track, achieve and maintain client support service level agreements and turnaround times at the defined and approved quality standards.
Identify opportunities to improve the teams' core operational internal processes.

Working on business analysis, Business Objects reporting and Business Objects administrator and Designer and Application Foundation for numerous clients such as Land Bank, TDS/ Trudon/ Yellow Pages, Momentum, Mutual and Federal (Phoenix project), and Investec (XI Rel 3.1).
Work on Rich Client, Webi, Desktop Intelligence, Designer, Administrator.
Mentoring team members and new staff.
Working on Pilot project at Transnet.
Working on Business Objects migration at Fleet Africa and Momentum to the latest release (XI).
Working on reporting, training, administrator, designer, application foundation, business analysis and support at TDS/ Trudon/ Yellow Pages (XI rel 2 and XI rel 3).
Business Analysis, Business Objects Reporting at Investec (XI Rel3.1).
Business Analysis, Data Services and Reporting at Media 24 (XI rel4, Excel).

Working on reporting solution for DeBeers.
Working on SAP Business Objects Webi and full client, Designer, Supervisor.
Setting up user accounts and rights on SAP Business Objects Administrator.
Documenting all the reports.
Testing the figures versus source systems.

Logging and assisting customers with any queries and issues with the complete product range of Business Objects.
Customer support and internal support- checking to see whether it is a product problem or a data problem and resolving the issue or referring it to the relevant person.
Following up to ensure that the customer is satisfied with the resolution supplied.
Stress testing and reviewing new product releases.
Replicating issues customer experiences and finding solution or logging overseas for patch or hotfix.
Working on projects at customers like MTN, Santam, DeBeers, SITA, Investec, RMB, Medscheme, Anglogold, Ellerines etc.- creating standard reports on Business Objects for end users to continue daily operations.
Leasing with the users on a regular basis and training them how to use the product.
Business analysis- creating the report specifications.
Source where the fields are from, what data sources are used, formulae’s and calculations and to check that all fields are available or to source the field.
Raising issues and gaps in the business.
Creating functional specifications.
Analysing the data returned to ensure that the correct figures are being returned.
Understanding the business rules to ensure the results are returned correctly.
Analysis of the data pulled in the queries, drilling to get more information on the affected areas.
Giving the results to the relevant people to action.
Setting up graphs to represent the data graphically.
Looking at the results to see whether there are any trends or potential problems.
If a problem area is found the relevant person is informed and the situation can be rectified.
Installing the middleware on the client machines and Business Objects, setting up the connection to the databases.
Placing metadata in the universe so that the users understand all the fields and know what the formulae’s are.
Running queries to retrieve and understand the customers data.
Hiding objects in the universe which are not necessary at present.
Universe creation- to join the relevant tables and put the relationships between the tables.
Setting up queries in Business Objects which have alerters to indicate problem areas- these can then be actioned and steps taken to prevent this from happening again.
Worked on Broadcast agent, installed it and setup the administrator, scheduled reports and monitored them on the console.
Presentations of the product and new products.
Proof of concepts include: installation, generic driver connection to database, universe design, report creation and basic overview of the product.
Develop and enhance queries- standard and adhoc reports.
Resource Planning- assigning staff to certain roles and responsibilities and placing them at a customer site on projects or assignments.
Training and mentoring- training and mentoring the internal staff and customers on all the Business Objects products.
Migrating Business Objects from older version to a newer version, for TDS, MTN, Medscheme, Momentum.
Moving all the reports and universes from 1 environment to another one.
Train the end user communities.
Testing profusely to ensure that all the reports still balance.
Responding to RFQ’s, RFI’s & RFT’s- to explain the functionality of the product and the architecture.
Documenting all the solutions.
Installation and working on application foundation, analytics- installing the application server and configuring it and creating dashboards and dials, consisting of metrics and kpis.
Worked a little bit on Excelsius.

Development of the business requirements and the functional specifications.
Analysis of the data pulled in the queries, drilling to get more information on the affected areas.
Giving the results to the relevant people to action.
Setting up queries which have alerters to indicate problem areas.
User support.
Train new users on the data within the database.
Training all the business users on OSA.
Analysis of data in database.
Organising the Birthday Club.
Tasked to get team spirit going in our area.

Maintain team cohesion and departmental functioning.
Co-ordinate & delegate business queries.
Maintain and identify standard reports.
Run adhoc queries.
Maintain & enhance the universes.
Maintain good customer service.
Market the department to new & potential customers.
Train new users on the data within the database.
Assist with customer segmentation.
Analysis of the data pulled in the queries, drilling to get more information on the effected areas.
Giving the results to the relevant people to action.
Setting up queries which have alerters to indicate problem areas.
Assist with the migration of all the data to the group data warehouse.
Manage a team of 3 people.