BILHA WETENDE

Part of my tasks include:

• Preparing risk registers which highlight various risks and challenges faced by departments.
• Working with various teams to quantify and understand initiatives designed to better manage company claims and expenses. I have garnered quality experience through communicating with teams and presenting on these initiatives to upper management.
• Building a claims tool in Microsoft Excel and Tableau that is used to analyze loss metrics by claim size to better identify and monitor changes in clientele's loss ratios and claiming history. This has enabled me to develop intensive coding in Oracle/PLSQL. This has also sharpened my data visualization skills using tableau.
• Performing in-depth actuarial analysis and presenting results to management team.
• Preparing analytics reports to help various departments understand their performances.
• Pricing of insurance policies for new schemes planning to come onboard.
• Preparing renewal invites and schedules for various schemes whose policy periods are about to lapse. This includes calculating their renewal premiums after factoring in elements such as company's expected profit, inflation rate and their loss ratios.
• Preparing claims experiences reports that help the company monitor claim performance of various schemes and highlight risk factors or areas of improvements in managing schemes to increase overall profitability.
• Product development & enhancements.

Part of my achievements include:

• I have been tasked with creating various reports for the business; amongst them the Lifestyle diseases report which has given the business an insight on the trends of claims from the lifestyle diseases. This has been helpful to the company as it encouraged the need to create the lifestyle management program by the company which aims at encouraging members to live healthier lifestyles and gives directions on how to improve the lives of members living with lifestyle diseases. This has greatly improved on customer service, reduced the number of new lifestyle disease ailments, and has significantly reduced the amounts of claims received from lifestyle diseases. This was also made possible by maintaining teamwork with members of other departments.
• Through effectively pricing the medical quotes I have been able to help the business bring in new schemes aboard and hence increase the company's clientele base and promote the overall medical insurance coverage within the country.
• I have been tasked with single-handedly preparing the renewal invites and renewal schedules for the company's SME business portfolio, a task which I have undertaken well.
• The monthly and weekly claims reports have helped in maintaining the current clientele hence improving on the company's profitability.
• I have been able to work from home effectively since March 2020 after 3 months of induction into the department. This was made possible by the great team spirit within the department and by maintaining attention to detail.
• I have developed physician groupings and facility profiling studies in support of network development. This has played a significant role in provider contracting and network development strategy.
• I am a key member of the corporate data warehouse development team.
• I represent my department as the data champion, and my role entails monitoring loopholes in our data transmission channels and ensuring the company's data protection rules and regulations are adhered to in order to protect our clients' privacy.

My roles included:

• Created daily, weekly, and monthly reports that were used for decision making by management.
• Analyzed big data using Microsoft Excel this included creating reports as requested and presenting the results in understandable formats to be used by management.
• Compiled queries in Oracle/PLSQL to create reports for different business sections in Business Intelligence as directed by management. This enabled me to develop strong programming skills.
• Made changes to already existing reports in Business Intelligence using Oracle/PLSQL queries.
• Automated scheduling requested reports to users' mails and statements to clients (using both scheduling and bursting definition).
• Availed data to users from the company's MIDB system using Oracle/PLSQL; and analyzing the data whenever there is need.
• Applied my technical knowledge of Oracle/PLSQL, Excel and Tableau to train colleagues.

Part of my achievements while in this role included:

• I created an Interactive Excel Dashboard that was a much better way of presenting comprehensive Authorizations Reports. This was also time saving since I was able to automate the report.
• I ensured the department was stable and running when my boss, the data science lead left the company. This was an opportunity to learn and grow as I developed strong leadership skills.
• I volunteered to do a presentation on one of the new products. This enabled me to learn how to speak in public. The prospected clients were taught on the details of the product, and this created awareness which promoted the sales of the product.
• I worked closely with the management to prepare several reports in BI that were specifically used by the managers for decision making. This helped reduce fraud and increase the company's profitability.