Alban Kalemi
Ridgewood, NY 11385
Cell: 347-***-****
********@*****.***
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