Kapila Ranaweera, Executive-MIS

Kapila Ranaweera

Executive-MIS

Hemas Holdings PLC

Location
Sri Lanka - Kandy
Education
Diploma,
Experience
5 years, 7 Months

Share My Profile

Block User


Work Experience

Total years of experience :5 years, 7 Months

Executive-MIS at Hemas Holdings PLC
  • Sri Lanka - Colombo 1
  • April 2011 to April 2013

Currently I am working at Hemas Holdings PLC as Executive-MIS since April 2011.

I analyze the Hemas group (FMCG, PHARMACEUTICALS, HOSPITAL, POWER & LESIURE) performances & report to Group Operations Committee & to the main Board of Directors.

Responsibilities
• Helps business users and business to increase productivity through MIS (Management Information) solutions, automations.
• Assist business analyst on group management reporting for Hemas Holdings (All the sector Businesses)
• Hemas Group & SBU performance reports to Group Operations Committee & to the Main Board of Directors.
• Deliver MIS (Management Information Analysis reports) for group SBU's as per the agreed deadlines, accurately.
• Analysis Hemas group sectors sales & prepare monthly incentive reports for sectors.
• Analysis on customer/patient/consultants feedbacks for Hemas Hospitals.
• Ad-Hoc analysis as when requested by Business Analyst/internal customers
• Daily analyzing Hemas Pharmaceuticals sales & report for relevant agencies & managers of Hemas group.
• Weekly analyzing the performances & sales of Hemas Marketing (FMCG) and report to CEO and relevant directors & managers.
• Analysis & deliver MIS reports for group sectors as per the agreed deadlines accurately.
• Analyzing the weekly Turnover & Gross profit of Hemas group & report the performances to CEO
• Analyzing the FMCG Brand performances & report to CEO, Directors & Senior managers.
• Studied the businesses of the Sectors/SBUs of the Hemas Group, mainly to identify the needs and requirements and to give & implement solutions by using SAP R/3 & BW
• Coordinating with IT with regard to validation and enquires of data accuracy

• Coordination and work with all the sectors members.

Documentation & Systems on MIS processes
o ERP systems - SAP R/3 & R/7
o Other relevant Legacy systems implemented at SBUs
o Microsoft Office Packages
• I am a member of Hemas group Fire Prevention & Fire Fighting team & I have participated for the training programs conducted by COLOMBO FIRE BRIGADE.
• I am the captain of Hemas Holdings Mercantile cricket team.

Volunteer at Kandy Buddhist Association
  • Sri Lanka - Kandy
  • January 2010 to January 2013

• I have a great passion to contribute myself in social work & currently I am a member of the Kandy Buddhist Association in Sri Lanka & rendering my voluntary services since 2010 to the SARANA SEVANA Elder’s Home in Kandy by looking after elders in their care.

Supply Chain management being as a Purchasing Executive at Watawala Plantations PLC
  • Sri Lanka - Colombo 1
  • December 2009 to April 2011

• I gained experience in Supply Chain management being as a Purchasing Executive from December 2009 to April 2011 under job rotation policy at Watawala Plantations PLC.

Job Duties & Responsibilities
o Avoided loss sales due to stock out & loss sales analysis.
o Negotiated with suppliers to cut down or maintain the same prices of the goods.
o Introduced new suppliers to gain competitive advantages by increasing the bargaining power with current suppliers & minimize the supplier's dependability for packaging materials & other products.
o Coordinated with staff members & by effective planning, make sure all materials are available at any given time.
o Prepared the monthly Sales Variance Analysis reports for Managing Director & CEO of the company.
o Prepared Product Cost Analysis for all brands Zesta, Kahata, Ran tea & Oliate. (Company products)
o Prepared the sales forecast/Production plan and the tea requirement for the company in monthly basis with coordination of group senior managers & Directors.
o Coordinated & maintained a strong relationship with the company supply chain.
o Coordinated company brand & promotion activities with group members, supply chain & media.
(3) HEMAS HOLDINGS PLC IN SRI LANKA

Finance Executive at Watawala Plantations Plc
  • Sri Lanka - Colombo 1
  • May 2008 to April 2011

• I worked as Finance Executive at Watawala Plantations Plc (Consumer Marketing) for the period of 3 years May 2008 to April 2011.

Job Duties & Responsibilities
o Maintained the company Receipt Book. ( Corporate Cheques & Cash)
o Daily Recorded of Sales Invoices.
o Daily Recorded of all bank entries as per the bank statements.
o Computation of Stamp Duty.
o Prepared the Monthly Maximum Order Value Statement.
o Prepared the Transport Cost Effectiveness Statement.
o Prepared the Monthly Fuel Cost Statement
o Prepared the Returned Cheques Statement.
o Analyzed the summary of dishonored cheques & reporting to the Marketing Director.
o Prepared the Turnover Tax.
o Handled Company Tea Brokers payments. (Online Banking)
o Handled Company Transporters payments.. (Online Banking)
o Handled Company Directors, Managers, Office Staff & Sales Representatives expenses payments (Online Banking)
o Handled Company Sales Representatives Sales Incentives Payments
o Handled Bank Reconciliations (Commercial Bank Accounts & H.N.B Accounts)
o Coordinated with Bank on Company Fund Transfers (Current A/C & Foreign A/C) Handled
o Foreign currency transfers & company treasury activities. Analyzed the foreign currency movements in the market and gained profit through forward bookings in foreign currencies converting to local currencies (USD, AUD, NZD)

Trainee Accounts Executive at Microcells Limited
  • Sri Lanka - Colombo 1
  • October 2007 to May 2008

• I worked as a Trainee Accounts Executive at Microcells Limited for the period of October 2007 to May 2008.

General Accounting work

Education

Diploma,
  • at Charted Institute of Management Accountancy
  • August 2009

I have completed CIMA foundation level & managerial level 1 & currently following other levels in Sri Lanka.

Diploma,
  • at Institution of Personnel Management (HRM)
  • April 2008

I have completed foundation & certificate levels in HRM to have a idea about the business human resources & change mangement..

High school or equivalent, Mathematics, Physics and Chemistry
  • at Dharmaraja College
  • January 2005

• Passed G.C.E. Advance level with three "Simple" passes in 2005 from Dharmaraja College, Kandy which included Combined Mathematics, Physics and Chemistry. Obtained a "Credit" pass for General English.

High school or equivalent, Mathematics,Science,English
  • at Dharmaraja College
  • January 2000

• Passed G.C.E. Ordinary level with Six "Distinctions" in 2000 from Dharmaraja College, Kandy which included Mathematics (1), Mathematics (2), Science (1), Science (2), Buddhism & Social Studies. Obtained Four "Credit Passes" for English, Sinhala, Agriculture & Western Music.

Specialties & Skills

Analysis
Business Reporting
Management Analysis
Reporting Skills
Communications Management
Microsoft office packages
BANK RECONCILIATIONS
BANKING
COMPANY SALES
CONSUMER MARKETING
MARKETING

Languages

English
Expert

Memberships

CIMA
  • Member
  • April 2007
I was a committee member of the Dharmaraja College Interact Club
  • member
  • January 2000

Training and Certifications

Information Technology (Training)
Training Institute:
Ministry of Education,Sri Lanka.
Date Attended:
January 2000
Microsoft Office Packages (Training)
Training Institute:
Hemas Holdings PLC
Date Attended:
April 2011
Fire Prevention & Fire Fighting Training Program (Training)
Training Institute:
Colombo Fire Brigade, Sri Lanka.
Date Attended:
June 2012