BENSON KIPKEMOI LANG’AT
Houston
Summary
Dynamic and results-oriented professional with extensive experience in data analysis and underwriting, notably at Everest National Insurance Company. Excelled in leveraging advanced Excel, Power BI, and SAP to enhance data accuracy and financial forecasting, demonstrating a keen analytical mindset and problem-solving prowess. Proven track record in improving operational efficiency and fostering strong team collaboration.
Overview
13
13
years of professional experience
1
1
Certification
Work History
UNDERWRITING ASSISTANT I
EVEREST NATIONAL INSURANCE COMPANY
01.2024 - Current
- Review and analyze incoming transactions and related information for completeness, accuracy, and quality.
- Multi-line new business submissions, renewal submissions and endorsements processing including rating, policy construction and assembly in a timely and accurate manner
- Regularly reviews and adheres to department processing guidelines and procedures to ensure accuracy, including recommended changes and enhancements.
- Manage underwriting and broker relationships with timely responses regarding service inquiries.
- Maintain all correspondence activity with internal and external customers including daily diaries on pending transactions
- Compliance with ODEN state rules and regulations relative to cancellations and reinstatements
- Gathering and analyze underwriting information including experience reports, final audits, loss control reports, financial reports, loss runs, MVRs, and FEINs
- Ability to manage internal report updates based on manager discretion
- Participates in peer review and quality control for team(s) as needed
- Special projects, including participation in Home Office projects, as needed
DATA ANALYST, REPORTING
BALADNA FOOD INDUSTRIES
06.2022 - Current
- Data Analysis with Excel, Power Query, and Power BI: Utilize advanced Excel functions, including Pivot Tables and Power Query, to extract and transform data from multiple sources, improving data accuracy and accessibility
- Develop interactive dashboards and reports using Power BI, providing real-time insights to stakeholders, and enhancing data visualization
- Conduct statistical analysis on datasets, identifying trends, anomalies, and process improvement opportunities
- Collaborate with cross-functional teams to develop data-driven strategies and solutions, contributing to organizational success
- Sales Forecasting Analysis: Analyze historical sales data to identify trends and patterns, facilitating more accurate sales forecasts
- Regularly communicate with the management team to provide insights and recommendations based on sales data analysis
- Review past sales data to determine productivity trends, enabling proactive strategies to boost sales performance
- Prepare accurate reports by consolidating data from internal and external sources, aiding in data-driven decision-making
- Present actionable information and insights to team members and management, contributing to informed decision-making
- Financial Analysis and Planning: Collaborate cross-functionally to improve the organization's financial performance through in-depth financial analysis, forecasting, and trend analysis
- Assist in the capital budgeting and expenditure planning process to ensure efficient resource allocation
- Maintain up-to-date knowledge of financial instruments, market conditions, and trends to make informed financial decisions
- Create and maintain spreadsheets and dashboards to support data analysis and provide valuable insights
- Accounts Receivables Duties: Prepare journal entries, reconciliations for month-end, quarter-end, and year-end closing process
- Prepare a variety of accounting/clerical tasks relating to the documentation, recording, processing, and filing of accounting and financial information
- Provide support documents and prepare for various internal audits and support the quarter end review and year-end audit processes
- Perform company internal controls by following accounting and company policies and procedures
- Review and track customer activities in the SAP ERP system to record each customers’ cash receipts, adjustments, GL account coding and posting of cash receipts on time correctly
- Contact customers to collect overdue accounts balance and report reasons for non-collected payment
- Monitor account collections based on AR aging reports
- Participate in cross training within the team to transfer knowledge of each members’ roles and responsibilities
- Creation of Cash and Credit customers in SAP system
DATA ANALYST
NGA-MAZZRATY
08.2020 - 05.2022
- One-point contact between managers and the internal staff
- Develop MS Excel based tools using pivot tables to develop data analysis and present the data in charts and graphs
- Data Mining, tracing, and mapping
- Maintaining and providing all daily, weekly, and monthly reporting from a variety of sources to coworkers and manager
- Interpret data, analyze results using statistical techniques and provide ongoing reports
- Working alongside teams within the business or the management team to establish business needs
- Defining new data collection and analysis processes
- Responsible for developing models and reporting structures that identify production rates
- Responsible for developing standardized and custom reports
- Ensuring production data is complete and accurate
- Develop tools aimed at improving production efficiencies
BUSINESS ANALYST
PREMIUM CAPITAL CONSULTANTS
03.2020 - 08.2020
- Guide cost analysis process by establishing and enforcing policies and procedures; providing trends and forecasts; explaining processes and techniques; recommending actions
- Reconcile transactions by comparing and correcting data
- Maintain database by entering, verifying, and backing up data
- Recommend actions by analyzing and interpreting data and making comparative analyses, studying proposed changes in methods and materials
- Provide analytical, forecasting, reporting, and project support to senior management
- Produce monthly reports, which include key metrics, financial results, and variance reporting
- Spearhead the annual and quarterly budgeting and forecasting processes
- Identify opportunities for performance improvement across the organization
- Maintain knowledge and keep abreast of new investment regulations or policies
- Develop models that help with decision-making
- Identify financial status by comparing and analyzing actual results with plans and forecasts
UNDERWRITER AND CLAIMS ANALYST
JUBILEE LIFE INSURANCE COMPANY LTD
04.2016 - 01.2019
- In charge of business support, client servicing, management, and budget reporting
- Assisted in setup and re-structured the operations in underwriting
- Involved in conflict resolution, service inclusions, tariff of various partners and ensuring members attended to fall under the network
- Setting up, underwriting, and managing of membership details in medical system (MEDIS and ACTISURE)
- Provided support to profit Centre/line of business leaders as directed
- Profitability analysis/reviews
- Reviewed pricing of large accounts and communicated insights to underwriters
- Maintained and updating of pricing models
- Handled and resolved queries from walk in clients, brokers, agents, members, claims team, service provider
- Serviced accounts by presenting portfolio performance, data management, reconciliation of accounts, customer service and policy administration requirements
- Spearheaded underwriting operations using the new medical system through improving efficiency and achieving targets
- Writing customer complaint report to make sure issues are solved in a timely manner
CREDIT ANALYST AND MOBILE MONEY OPERATIONS
KENYA COMMERCIAL BANK
07.2012 - 05.2014
- Processed monthly/quarterly partner rebate manual credit notes and reviewed the Aged Debtors reports
- Logged dispute cases in SAP software, assigning to the correlating team, ensuring these are followed up and credited / rejected
- Prepared seasonal payment plans for customers, requesting for post-dated cheques/standing order
- Reconcile previous seasons for payment plan customers and send statements as requested
- Worked with Credit Controller in managing partner queries through the QMS system and SAP account cross-referencing
- Assisted Credit Controller with partner account spreadsheets to prompt partner payment preparation prior to monthly SAP account statements run
- Provided administrative support, facilitate and enforce M-PESA agent compliance with M-PESA Agents Operating Standards/Regulation/ Processes/ procedures and contract
- Provided structured customer service support in M-PESA Agent Operations including Float targets administration, float accessibility and M-PESA Agent Performance Reporting/Communication
- Working closely with the accounts receivable team to monitor and ensure the customer ledgers are correct and chase for the remittances relating to payments
Education
Bachelor of Science Degree - Actuarial Science
JOMOKENYATTAUNIVERSITY OFAGRICULTURE ANDTECHNOLOGY
01.2012
KENYA CERTIFICATE OF SECONDARY EDUCATION - KCSE
THE AGA KHAN HIGH SCHOOL
Nairobi01.2006
Skills
- Data Analysis
- Underwriting
- Insurance
- Sales
- Accounts Payable
- Finance
- Analytical Mindset
- Problem-solving
- Business Acumen
- Communication Skills
- Team Player
- Attention to Detail
- Excel
- Power Query
- Power BI
- SAP
- Qlik
- Creatio
- Microsoft Dynamics
- Mathematics
- Statistics
Certification
- Power BI Certification, https://www.linkedin.com/learning/financial-analysis-making-business-projections/welcome
- Financial Analysis: Introduction to Business Performance Analysis
- Financial Forecasting with Big Data, https://www.linkedin.com/learning/financial-forecasting-with-big-data/welcome
Accomplishments
- Sales Data Analysis, Analyze and visualize historical sales data to identify trends and seasonality, leading to a 10% increase in quarterly revenue.
- Customer Churn Analysis, Investigate customer churn factors, reducing churn rate by 15% through targeted retention strategies.
Language
English
Timeline
UNDERWRITING ASSISTANT I
EVEREST NATIONAL INSURANCE COMPANY
01.2024 - Current
DATA ANALYST, REPORTING
BALADNA FOOD INDUSTRIES
06.2022 - Current
DATA ANALYST
NGA-MAZZRATY
08.2020 - 05.2022
BUSINESS ANALYST
PREMIUM CAPITAL CONSULTANTS
03.2020 - 08.2020
UNDERWRITER AND CLAIMS ANALYST
JUBILEE LIFE INSURANCE COMPANY LTD
04.2016 - 01.2019
CREDIT ANALYST AND MOBILE MONEY OPERATIONS
KENYA COMMERCIAL BANK
07.2012 - 05.2014
- Power BI Certification, https://www.linkedin.com/learning/financial-analysis-making-business-projections/welcome
- Financial Analysis: Introduction to Business Performance Analysis
- Financial Forecasting with Big Data, https://www.linkedin.com/learning/financial-forecasting-with-big-data/welcome
Bachelor of Science Degree - Actuarial Science
JOMOKENYATTAUNIVERSITY OFAGRICULTURE ANDTECHNOLOGY
KENYA CERTIFICATE OF SECONDARY EDUCATION - KCSE
THE AGA KHAN HIGH SCHOOL
Similar Profiles
JUSTIN MOISTJUSTIN MOIST
Project Manager II - Marketing Specialist at American National Insurance CompanyProject Manager II - Marketing Specialist at American National Insurance Company
Kateri McBeanKateri McBean
PIP Claims Medical Adjuster at National General Insurance CompanyPIP Claims Medical Adjuster at National General Insurance Company
Jose HermansonJose Hermanson
Insurance Agent at National Income Life Insurance CompanyInsurance Agent at National Income Life Insurance Company