Alban Kalemi

**-** ******* ******, *** fl,

Ridgewood, NY 11385

Cell: 347-***-****

acdn4g@r.postjobfree.com

OBJECTIVE

Applying for the position as Demand Planner where I can use my experience and skills to help the

organization to achieve its objectives.

EDUCATION

Bachelor of Science in Business, Management and Finance, February 1st, 2008

City University of New York (Brooklyn College), Brooklyn, NY, USA

SKILLS

•Computer skills: Advanced level of MS Excel (IF Statements, Vlookup, Index and Matching, Sorting

and Filtering, Macros, Pivot Tables, What if Analysis, Data validations, Charts and Graphs, various

functions and formulas).

•Others Computer skills: OLAP cubes, MS Word, Power Point, MS Access, QuickBooks, Outlook,

Windows XP/Vista/7/8

•Excellent statistical analysis and mathematical calculations

•Languages: English, Italian, Albanian - (spoken and written)

EXPERIENCE

Studio Moderna d.o.o. September 2011 - Present

Demand Planner/Inventory Manager

•Responsible for developing demand forecasts at multiple levels of aggregation for multiple time

horizons as part of a demand planning function

•Responsible for reviewing historical sales and purchasing trends, customer requested demand and

prepare forecast data

•Responsible for coordinating cross-functional research activities to reconcile significant variances and

refine the forecast model to reflect updated sales assumptions

•Responsible for using and maintaining the Demand Planning software as the primary forecasting

system tool

•Responsible for closely coordinating and maintaining assortment deadlines, purchase orders, ship dates

with customer, sales, product development and purchasing

•Ordering products from the suppliers and central warehouse

•Maintain records of goods ordered and received

•Working with Sales channel Managers to forecast future demands for products

•Ensuring all damage/defective goods are claimed within corporate guidelines

•Communicate with appropriate personnel regarding shipment errors and/or delays

•Review and analyze stock levels on a day to day basis

•Working with other planners to understand root causes for excess inventory and devise appropriate

countermeasures

•Developed Excel based tools to monitor and forecast inventory levels by product line

•Supplying documents to custom agencies, and paying the custom duties for receiving goods

•Analyzing the sales and stock data through OLAP and intranet systems

•Scheduling meetings with all key Managers regarding new company’s products and ordering them

United Albanian Breweries September 2010 – September 2011

Sales and Distribution Analyst

•Responsible for sales analysis for the entire sales force of the company

•Produced daily, weekly, and other periodically reports of products’ sales status

•Analyzed segments and channels sales of the company’s customers

•Worked closely with the Sales Director and preparing regular reports about Sales Reps. performance

•Successfully created Excel based data systems able to calculate large amount of data faster and more

accurately

•Produced various presentations and reports for the company CEO and the parent company located

abroad

•Calculated and prepared the payroll of all the Sales Force

•Analyzed trends and various forecasting

•Prepared the sales budget

•Interacted regularly with other departments in the company

•Managed miscellaneous projects and product promotional activities

Coca-Cola Bottling Sh.A Tirana, Albania January 2010 – September 2010

Sales Analyst.

•Produced daily, weekly and monthly activity reports.

•Successfully created four new Excel based systems for calculation, automation of data, and

implementation of new Sales Report format.

•Responsible for sales analysis of 87 Sales Reps. of the entire sales area of Albania

•Responsible for analyzing prior year's sales to estimate future sales and targets

•Compared prior year’s sales with the current year.

•Monitored and analyzed sales performance for various channels

•Worked closely with the compensation management team to calculate bonuses for the performance of

Sales Reps.

•Participated in various management meetings to evaluate and report sales activity.

Virginia Dare. Brooklyn, NY September 2007 - April 2008

Sales Analyst/Marketing Assistant (internship)

•Analyzed internal and external business data for statistical purposes.

•Used marketing and business research resources aimed to increase the company’s Sales.

•Interacted with all levels of management regarding various issues.

•Performed Internet research for business related information involving company’s products.

•Prepared presentation materials about business and new business opportunities.

•Assisted in cataloging research materials.

•Prepared reports for new and changed product’s prices.

EXTRACURRICULAR ACTIVITIES

Member of Business League Club of Brooklyn College

Contact this candidate