Bassem Messiha
** ******** **., **** ********* NJ 08816 E-mail: *************@*******.***
Tel 732-***-****
Objective
Seeking a F/T position in reporting & analytics / Budgeting & forecasting
Summary
12 years working experience in marketing, analytics, reporting, planning & customer service positions in a leading multinational company in telecommunications industry
Advanced Financial Modeling Experience; Pricing and Financial Analysis Expertise; Budgeting, Financial Reporting and great Communication skills
Excellent use of Microsoft Excel and Power Point, professional in MS word & access
Experience in reporting tools usage (Business object, Brio, total view,IEX)
Basic knowledge in SQL & VB
Proficient in using the Internet, web resources
Organized and object-oriented; hardworking and a quick learner
Capable of multitasking with good time management
Team player with good people skills
Fluent in English, Italian, French & Arabic; written & spoken
Work Experience
Rious Food Services LLC (989 Amboy Ave, Edison 08837) November 2016 & till now
Financial & HRIS analyst
Responsible for preparation and analysis of quarterly forecast, Budget and Forecast of Operating Expenses and Headcount
Complete monthly spending reports and assist managers with development of the monthly forecasts
Assist with the forecasting, strategic planning, and budget processes both annually and throughout the year
Study, and interpret financial, headcount and project data that will provide an in depth understanding for department and/or management.
Control of Operating Expenses, including Headcount, review parked invoices and complete necessary accruals
Pull, analyze, and report on various data sets
Develop repeatable processes for department through data mining and report generation
Data Management - entry, auditing, reporting, and monitoring data systems
Track and analyze financial results in order to identify trends that will assist business decisions.
Advanced excel skills (Vlookups, Pivot Tables and advanced formulas).
Responsible for creating employees database, monitoring leave balance, career history and other related HR matters through advanced tables & formulas
General system administration and maintenance of Workday's HCM, Onboarding, Absence, Time Tracking, Benefits, Advanced Compensation, Recruiting, Talent and Performance modules and outbound integrations
Create ad hoc reports and metrics. Also provide data summaries or statistical analysis for strategic planning or decision-making
Work with Payroll department to insure the timely and accurate processing of information through the outbound integration to Lawson Payroll
Maintain the Human Resources Management System (HRMS) in addition to other systems supported by the HRIS team
Vodafone Egypt Telecommunications
Roaming Wholesale supervisor October 2011 to November 2016
Negotiated Inter operator tariff deals with roaming partners and managed to increase department revenues by 15%, by changing contracts’ commitments from amount based to market share
Conduct monthly performance assessment and address promising opportunities and imminent threats
Drive Contract negotiations and drafting (with legal support) all the way up to signature
Ensure good archiving of renewable contracts and responsible for updating database with their details for ease of access
Responsible for revenue reporting, and follow up on settlement of payment with partners
Commercial strategies preparation for roaming discount agreements
Responsible for financial settlement reporting and analysis after each deal expiry
Report all pending payments in & out and keep track with payment history with all operators worldwide
Manage revenue vs. budget which exceeds 80 Million $ annually
Provide management with quarterly budgets and revenue forecasts
Assist in resolving problems risen by roaming partners, which might affect the roaming quality of service
Monitor closely the inter operator tariff for roaming partners and competitors
Conduct quarterly market share analysis
Lead negotiations of the international interconnect cost with international gateway service provider (Telecom Egypt)
Vodafone Egypt Telecommunications
International & Roaming Reporting Sr. Specialist October 2010-September 2011
Prepare, drive and communicate the department’s plans& performance.
Aligning with the different units and monitoring their quarterly progress against the department plan
Monitor day to day performance and handle department’s reporting.
Prepare daily and monthly management reports about the international and roaming business performance highlighting the main KPI’s.
Prepare all executive management presentations related to the business unit performance and its strategy execution.
Benchmark current business against customer and competitor performances; identify new growth opportunities and external deal opportunities in terms of new markets / alliances etc.
Develop long-term business plans, anticipate and manage the impact on profit of the new strategic initiatives.
Keep an eye on tourism progress locally and internationally, from different sources highlighting potential impacts and/or opportunities to management and stakeholders
Create clear and effective customer insight service requests to ensure covering all analysis requirements.
Vodafone Egypt Telecommunications
MIS Reporting budgeting & planning Sr Analyst October 2008-September 2010
a.Reporting
Responsible for Customer Operations reporting and analysis. Working closely with Customer care Supers and mangers in providing the department with appropriate analysis on KPI’s together with improvement and recommendations in order to support the decision-making process.
Gather and discuss functional areas reporting requirements and ensure delivery of accurate and timely reports.
Develop reports in coordination with functional areas that support Customer care management to understand and analyze customers calling and payment behavior.
Preparation of periodic and ad-hoc reports and ensure data quality and accuracy
Develop, monitor and analyze KPI’s throughout the Customer care functions to enable informed decisions and provide prompt feedback of risk and exposure issues as hotline Analysis,bad debt distribution and analysis,retail target pointing reporting
Coordinate with Data warehouse department to automate reports generation
Ability to work in cross-functional projects, and sometimes to lead projects
b.Planning & Budgeting
Work closely with Customer Operations Management to develop an accurate annual and quarterly headcount forecast and ensure its alignment and integrity with strategic directions of the department and Vodafone Egypt.
Discuss and review Customer Operations headcount requirements, study operational implications and provide feedback and recommendations to forecast owners.
Assess key risks and opportunities that may arise during the forecasted period.
Proactively address potential future headcount budget deviations and/or savings opportunities.
Provide monthly headcount budget variance analysis report and communicate significant issues and opportunities and incorporate needed improvements into forecasting process.
Own and report major customer care KPI's to VF Group
Own and develop seating plans to ensure maximum utilization of VF resources
Preparation of quarterly hiring plan in coordination with COPS functional areas, Workforce Management, and HR to ensure resources availability.
Conduct monthly headcount reconciliation against HR & Payroll.
Ensure that all COPS operating expenses requirements are incorporated in the annual and quarterly budget forecast and ensure its alignment and integrity with strategic directions of the department and Vodafone Egypt.
Address potential future budget deviations and recommend corrective actions.
Conduct monthly budget, cost center statement analysis and coach cost center managers in this respect.
Identify and report trends and anticipated developments.
Develop and maintain financial and operational models required by COPS functional divisions.
Identify financial gaps & opportunities through monthly financial analysis
Handling operational reporting & analysis tasks, supporting Management information system team.
Vodafone Egypt Telecommunications
Call center Workforce Analyst (Scheduling and Forecasting) November 2007-October 2008
Involve the analysis and forecast of work demands, and advanced scheduling of customer operations staff to meet weekly and daily business requirements.
Prepare a basic rotation pattern schedule.
Adjust the software for weekly exceptions and current workload factors; produce a Final schedule 4 days before the Operational Week.
Analyze historical call volumes.
Prepare graphical and tabular analysis, and maintain historical files and reports.
Utilize WFM software or statistical formulas to determine the forecasting factors.
Generate scenarios of forecasts and model the schedules to select the “best fit” patterns.
Analyze the weekly traffic pattern.
Design scheduling processes and facilitate Customer Operations
Define business rules that reflect the operational requirements for staff resources, comply with local labor or HR principles, and minimize staff surplus.
Lead efforts to develop annual leave, shift trades, shift bids and days off assignments.
Make shifts presentation for the new classes.
Create different shifts patterns for the abnormal days or month.
Monthly projection of inbound calls and other customer operations activities, demonstrating workflow analysis and consideration of externalities.
Continuous analysis and comparisons between the actual historical data and the forecasted data.
Conduct presentations to operations management.
Maximize the utilization of the WFM software.
Vodafone Egypt Telecommunications
SBU (Strategic business unit) Account Manager-Italy August,2006-November 2007
Act as the single point of contact for the embassy for all operational issues and handling all the special requests from the Embassy in a timely manner even on week ends and after working hours.
Negotiate & add new services to the appointments reservation.
Own and manage the client relationship by resolving calls effectively and efficiently.
Mentor and support new employees.
Deliver trainings to new comers and ongoing refreshment sessions to assure delivery of all the updates in policies, procedures and regulations from the Embassy to the SBU team.
Prepare training materials after alignment with the consulate and the foreign ministry sources of information.
Ensure that training materials are kept current, accurate and completely relevant to employees and consulate’s needs.
Responsible for the SBU complaints.
Responsible for auditing all the reserved appointments.
Generate all italian reports efficiently and send them to the consulates.
Making frequent visits to both consulates to assure the right performance trend.
Hold monthly meeting with the Embassy along with the SBU management for Business Updates and regular feedback.
Being responsible of extracting all area members scores prepare their PD evaluation sheets and analyse their performance.
Conduct calls and revenue analysis for both Italian consulates.
Analyzing new services and calls forecasting.
Making monthly analysis for service level and headcount.
Act as a team leader, being responsible for 6 agents, handling their performance & issues.
Vodafone Egypt Telecommunications
VAS US (Visa Appointment system USA)Representative: February, 2005-August, 2006
Act as a frontline interface with customers acquiring appointment reservations with the US Embassy in Egypt & Sudan. The main purpose is to facilitate and provide high level of customer service to the satisfaction of our clients’ expectations and to meet department and corporate goals
Handling the italian consulate in Cairo and Alexandria as account manager. Handling problems and ensure high quality level to the consulate as main customer and cascade information to colleagues
Being responsible of extracting all area members scores, prepare their PD evaluation sheets and analyse their performance
Conduct calls and revenue analysis for US embassy and both Italian consulates in Cairo & Alexandria
Liaise with the US Embassy to resolve client reservations & Queries
Provide internal and external customers with accurate information
Mentor and support new employees
Deliver trainings to colleagues in all immigrant and non immigrant visa cases and ensure delivering all updates
Providing clear and instant feedback on the Immigration policies and procedures, updating immigration applicants with new law issues
Handling immigration applicant complaints throughout the immigration process
Accuracy in handling all assigned tasks
Attitude and teamwork spirit
Best tours Travel
Italian Tour Leader September 2004- February 2005
Responsible for arranging tour programs
Responsible for accompanying tourists groups during their stay in Egypt since their arrival at the airport till their departure
Responsible for Hotel reservation, ensuring quality of the accommodation, confirming booking, and domestic travel.
Responsible for handling tourists' complaints
Handling correspondences with Travel Agents
Honors & prizes
Saving award winner, for creating an initiative that increased revenue by 2 M $, Apr 2013
Innovative award winner, for developing reporting tools, Jan 2011
Innovative award winner, for creating an initiative that saved 800 K $, Sep 2008
Winning an award trip to Sweden, by being one of the best 64 employees (among 6500), for creating initiative that increased revenue by 3 M $, Jul 2007
Education
-Bachelor of foreign languages, Italian department Ain shams University, 2000-2004, Cairo, Egypt.
Soft Skills
Business courses Time management - Finance for non-financials - Statistics course - Negotiation skills - Communication skills - Communicating for impact
Advanced analytical skills