MIS Analsyt
Al Laith Group
Total years of experience :11 years, 5 Months
o Providing regular reporting on Sales, profitability, business insider materials
o Providing support for the sales team to include coordination or analysis of sales planning and administration activities
o Compiling and analyzing reports in compliance with daily, weekly, and monthly reporting requirements. Reports included margin, pending orders, vendor payment inquiries, sales revenue to cost, profit and loss, weekly sales report, and tracking key performance indicators
o Creating concise reports and trend line analyzing from raw data by collecting and analyzing sales related information in an ongoing effort to increase sales productivity
o Preparing status reports and updates the same to the Management team.
o Assisting Managers in handling daily activities.
o Making monthly Budget vs Actual sales analysis and sending these reports to top management.
o Planning and developing performance KPI on the functional levels for the business functions.
o Gathering Data and Consolidating MIS financial information for the preparation of management reports
o Ensuring all scheduled reports is being shared with across region.
o Developing methods and strategies for assessing large amounts of data to cater ad-hoc reporting requirements.
o Sending monthly statement for Client.
o Maintaining Individual Process Dashboard Weekly & Monthly.
o Converted raw data into useful reports to reveal sales and operational insights.
o Worked with vendors and sales associates to extract the needs and provide analytical support.
o Produced regular, periodic & ad hoc reports used by Vendors, Sales Team and Senior Management.
o Performed various information data gathering, sales performance, and forecasting and product availability for the management.
o Performed sales trend analysis on weekly basis using Microsoft Excel.
o Maintained SKUs focused on all Top brands; Nestle, Pepsi, Unilever, Delsey, Kiplings, Mondeleez International, P&G, Coca-cola.
o Provided analysis on product category, vertical market, distribution channels and price points.
o Audited and reconciled cost &quantity as per SOP.
o Reviewed inventory records coordinate stock count in line and investigate discrepancies.
o Designed SKU analysis in Microsoft Excel to increase the efficiency and capture accuracy to reconcile the items in minimum time.
o Audited and analyzed revenue, units, gross margin and gross margin percentage.
o Supported in-Stock optimization through weekly evaluation of inventory versus sales trend.
o Provided recommendations using Microsoft Excel Dashboard & Power point Presentations.
o Working on Audit Operations project of Mobilink Franchises & Mobilink Sales Points
o Performing Data entry, Data auditing, creating data reports & monitoring all data for accuracy
o Analyzing raw data, drawing conclusions & developing recommendations
o Collect data from various collectors
o Calculate commission of collectors as per their performance
o Writing T-SQL scripts to manipulate data for data loads and extracts.
o Manipulating & processing data using SQL and Excel.
o Preparing different reports on MS Excel like Ageing Analysis, Segment Analysis, Trend analysis
o Preparing graphical presentation using MS Powerpoint
o Worked on multiple Prepaid & Postpaid projects
o Exceeded company’s sales goals by up-selling value added services offered by the company
o Resolved customers complaints by identifying problems - Resulted 30% increase in Contact Center efficiency
o Improved the efficiency of customer service department by training new hires
o Performed Audit function of various data using Siebel CRM & MS Excel
o Analyze and report performance of the team on daily, weekly and monthly basis