Alejandro Colón Email & Phone Number

• Assemble workpapers to be reviewed by the Chief Financial Officer (CFO), independent auditors, and stakeholders. Assigned portfolio includes over $100 million in mixed-use and luxury residential properties generating $30 million in annual revenue• Administration of tenant lease security deposits totaling over $12.2 million for 24 New York City buildings with over 3,200 tenants• Prepare tax returns for assigned individuals and various entities including, corporations, partnerships, and trusts• Prepare rent rolls for residential and commercial properties • Examine General Ledger for accuracy and record journal entries not limited to: revenue recognition, accruals, prepaids, and reclassifying• Ad hoc financial analyses as needed and directed by the CFO

• Monthly bank reconciliation of tenants’ security deposit statements for all buildings• Analysis of Senior Citizen and Disability Rent Increase Exemptions (SCRIE & DRIE)• Verify and post details of business transactions, such as funds received and disbursed, and totals accounts to ledgers, Excel spreadsheets, or databases• Assist with Accounts Payable and Accounts Receivable• Developed VBA macros to be used in bank reconciliations reducing processing time

• Prepare IRS referred clients’ tax returns• Manage Accounting department's website and updated events, scholarship, and class information. Work closely with the IT department to ensure all website updates and changes adhere to university policy and 508 compliance.• Develop tax preparation software training videos and materials to be used by VITA/TCE volunteer tax preparers and managers• Design event marketing materials such as flyers and posters using Microsoft Publisher

New York, New York, Us

• Federal procurement data extraction, organization, and analysis• Lead ongoing market research to identify opportunities in key markets• Collaborated with CEO and CAO in the development of an internship program• Supervised a team of interns• Contributed in the development of RFI's, RFP's, and RFQ's• Collaborated with HR Manager in the development of training presentations, materials, and manuals• Prepared results summaries and reports in Microsoft Excel and PowerPoint

St. Louis, Mo, Us

•Assist remarketing supervisor with overall vehicle control. •Vehicle damage assessment.•Lot organization.