PEDRO CASTANO
Pompano Beach, FL 33069
*************@****.***
www.linkedin.com/pub/pedro-castano/19/52b/449
SKILLS:
. Able to build models in Excel for forecasting and data analysis.
. Excellent use of Hyperion, Excel and Power Point.
. Good knowledge of Lawson, Oracle and QuickBooks.
. Mathematical and problem solving savvy.
. Capable of improving processes that save money to a company.
. Enjoys advancement, innovation and creativity.
. Fast learner; always willing to take on new and more complicated
projects.
. Always open to suggestions and constructive criticism for better
results.
. Bilingual: oral, reading and writing skills in Spanish and English.
SUMMARY:
. I have strong logical, analytical and mathematical skills, which
combined with my creativity, allow me to handle more complex
scenarios and complete my responsibilities efficiently. My work has
always relied in two principles: give my best and perform more than
expected.
EXPERIENCE:
Altadis U.S.A.
Ft Lauderdale, FL
October 2008-December 2010
Marketing Analyst II
. Completed the Dominican Premium Cigars Sales Plans and forecasts
for Fiscal 2010 and 2011. (+1,500 SKUs)
. Created the Mass Market model Excel file used for forecasting for
Fiscal 2010 and 2011. (+500 SKUs)
. Created the Selling, General and Administrative Expenses model
Excel File used for tracking and budgeting Domestic and Export
Marketing Expenses.
. Calculated the new base prices for the National Premium Cigars
after Federal Excise Tax regulations.
. Produced the Excel reports used to revise the 2010 Fiscal Year
margins.
. Generated the reports used to rationalize underperforming items
from the Mass Market portfolio.
. Analyzed and reported Premium Cigars' monthly sales to management.
. Maintained the National Premium Cigars Price List.
. Extracted sales data, designed and formatted Power Point
presentations, for regional and chain account managers, used in
meetings and national conventions (I.e. ABX Show).
. Organized third party market sales data (I.e.MSAi, MPulse, Nielsen)
to show company and product market share and performance.
. Retrieved information from Hyperion into Excel for a fast and
accurate response to questions and projects.
Taitron Components
Valencia, CA
February 2007-August 2008
Accounts Payable/Receivable Specialist
. Supervised and trained staff on all transactions and procedures
for the accounts payable and receivable
department.
. Reviewed and analyzed the aging of local and international accounts
payable and receivable.
. Followed up with customers and vendors regarding questions about
their invoices.
. Processed daily invoices for payment and compared against the aging
report to prevent setbacks.
. Created journal entries for all AP transactions and posted to the
general ledger.
. Reviewed and reimbursed employees' business expenses.
. Managed and processed credit card purchases with corporate VISA AMEX
and Master card.
. Reconciled prepayment, bad-dept, cash and clearing accounts.
. Processed and monitored billing, cash receipts, and collection calls
of overdue invoices.
. Ran customers backgrounds by D&B, ERAI and Credit.net for credit
approval.
. Created Credit Memos and Debit Memos for suppliers and customers.
. Managed company's Petty Cash.
. Processed Payments by wires, Corporate and manual checks.
EDUCATION:
Currently Attending Full
Sail University
Orlando, FL
MBA: Internet Marketing
Graduated May, 2008 California State
University, Northridge Northridge, CA
Bachelors of Science: Business Administration, Marketing
Graduated May, 2006 College
of the Canyons
Valencia, CA
Associates Degree, Accounting
References provided upon your request
PEDRO CASTANO
*************@****.***
www.linkedin.com/pub/pedro-castano/19/52b/449