Joseph Cognard

**-** ***** ******

Flushing, New York 11358

718-***-****

ac1p0h@r.postjobfree.com

Financial, Inventory and Marketing Analyst with many years of experience

Highly Proficient in analyzing and reporting for many divisions within a corporation

Created and designed dynamic reporting and analysis covering many business areas such as: budget, sales, campaign analysis, labor performance and compensation

Designed and automated financial and distribution center dashboards

Have developed numerous companywide cost saving VBA/excel applications

Managed various projects that include redesign of commission process and goal setting, implementation of online sales tracking, and payroll re-forecasting

Experience:

Vitamin Shoppe North Bergen, New Jersey (08/2015 – 06/2017)

Senior Supply Chain and Financial Analyst

Created a distribution center dashboard using Excel pivot tables and pivot charts, which allows dynamic analysis, and charting of key statistics over multiple distribution centers

Lead person for all Distribution Center financial reporting, P&Ls, expense tracking and accruing during monthly closes

Developed and maintained fiscal budgets and re-forecasting for New Jersey DC

Instituted a new tracking system to adjust future vendor billing, as well as inform them of credits taken for damaged or incorrect shipments

Accurately project and optimize temp to permanent distribution center labor mix for New Jersey distribution center based on expected store sales and incoming purchases

Maintained performance database and recalculated acceptable performance levels used for awarding outstanding workers as well as identifying poor performance

Incorporated strong working knowledge of Excal, VBA, SQL, pivot table, vlookups and ACCESS to develop and maintain system-driven reports for upper management

Oxford University Press New York, New York (10/2005 – 05/2015)

Senior Financial Analyst

Created dashboard reporting of sales, allowing dynamic but consistent analysis and charting with adjustable viewing by a range of customers, dates and other variables

Developed and implemented new budget application using automated pivot tables and Vlookups adding the ability to view multiple investment, risk and performance scenarios

Worked with HR to create proper analysis and reporting of headcounts, salaries, benefits, taxes as well as the tracking of replacement and new positions

Enhanced reporting for Cost Centers throughout company to aid in both tracking and analyzing of expenses including advertising, marketing, T&E

Lead for many projects including, restructuring of all sales goaled incentives including bonuses and commissions, and led testing environment for Tableu software

Created databases and dynamic spreadsheets used in analyzing sales force performance and proper payment of commissions, and bonuses

First Data Corporation Melville, New York (02/2004 – 10/2005)

Senior Financial Analyst

Maintained and enhanced weekly dashboard tracking key sales stats and projections

Created monthly roll up of forecasts for all Business Units

Worked and analyzed monthly and quarterly close reports,

Created automated journal-entry consolidation program in VBA saving Portfolio department over 20 hours of work per close

Bookspan Inc. Garden City, New York (06/2000 to 02/2004)

Senior Inventory Chain Analyst (05/2003 to 02/2004)

Developed and adjusted as needed thousands of analytical curves for inventory and business forecasting engine

Created automated statistical reports in Excel using VBA and other applications, for various departments including marketing, and inventory

Analyzed and enhanced the monthly risk reporting for inventory department

Analyst (06/2000 – 05/2003)

Created and maintained Title Usage Planning Report using VBA to interact with Excel, Access in SAP environment before finalizing in excel dashboard environment

Redesigned and enhanced company-wide used cash flow projection model

Analyzed book club sales; tracked performance of current offerings, projected sales of new books and advised editorial staff of results for future product development

Automated the data-entry processes for marketing and editorial departments saving hundreds of hours of manual labor

York Research Corporation, New York, New York (03/1999 – 06/2000)

Project Analyst

Planned, analyzed and maintained budgets for energy projects; created expense coding structure for Microsoft Dynamics ledger system

Created budget and purchase order tracking systems using Crystal, Atlas and Frx saving cost and time from older method

Interacted with senior level executives and Vice President on bond-related issues such as managing expense requisitions, creating cash flow analysis and other financial reports vital to the company

GEC-Marconi Hazeltine Corporation, Greenlawn, New York (01/1997 – 03/1999)

Project Manager

Prepared, analyzed, and negotiated high-priced defense and aviation computer systems and parts with Boeing, U.S. and foreign governments

Managed all phases of various defense contracts including financials in an ISO 9000 Environment

Analyzed and reported on man-power reporting for entire division

Jacob K. Javits Convention Center New York, New York (02/1993 – 01/1997)

Event Coordinator / Analyst (02/1996 - 01/ 1997)

Introduced and supervised customer satisfaction surveys for all trade shows

Supervised incoming events and building staff for and show management companies

Manager, Exhibitor Service Department (02/1993- 02/1996)

Managed a staff of eight customer service representatives

Education: St John’s University

Jamaica, New York

MBA Quantitative Analysis/Computer Information Systems Sept/94

St John’s University

Jamaica, New York

BS Finance Aug/90

Skills: SAP, EXCEL, ACCESS, VBA, BW, R3, Hyperion, Crystal, SQL, FoxPro, Project, Frx, SAS, ATLAS, Salesforce.com, Power Point, Dynamics, Tableu, Python, Pivot Tables, and ADO

Contact this candidate