Post Job Free
Sign in

Excel Expert

Location:
United States
Salary:
Open
Posted:
September 22, 2011

Contact this candidate

Resume:

Steve Yun

***** ****** ****, #** *******, CA ****4

Phone: 510-***-**** ********@**********.***

Professional Profile

Financial Analyst / Excel Developer / Commercial Property Management

SUMMARY

12 of years Facilities Management experience with superior proficiency in Microsoft Office (Words and Powerpoint), developer level proficiency in Microsoft Excel, and advance proficiency in computers. Self-motivated, deadline driven and team focused. Bachelor’s Degree in Business Management.

Core Competencies

• Thorough understanding of budget development and conformity.

• Highly analytical .

• Solid understanding of accounting procedures and practices.

• Excellent interpersonal and communication skills.

• Strong leadership and analytical skills.

• Building systems proficiency.

• Rreef Property Management Training.

• BOMA/SFFD Emergency Response Team Training.

• Microsoft Word, and PowerPoint Training/Certification.

• Expert in Microsoft Excel

• Intuit QuickBooks training.

• Computer Technician Training/Certification.

Professional Experience

Volt Workforce Solutions – Apple, Financial Analyst – (06/2011 – Present)

Forecast iPod, iPad, and Mac for CER (Consumer Electronic Reseller) Division, iPod for US Resellers, and all products for the Enterprise Division. Update formulas, conditional formatting, and Macro Codes for existing 2004 Microsoft Excel templates to 2011 compatibility.

Volt Workforce Solutions – Apple, Excel Guru – (02/2011 – 06/2011)

Develop Filemaker Reporting Database, construct commission modeling tool, and assist in the development of the QBR and the Management Package. Develop Excel File Splitter Macro for WW Sales Operations Division.

Nelson Staffing – Expeditors, Inc., Excel Developer – (09/2010 – 02/2011)

Using array formulas, vlookups, dynamic ranges, conditional sum, conditional formatting, mega formulas, Macros, VBA programming, and other Excel functions, to develop, design, produce, and code: performance metrics, excel tools, account profitability worksheets, automation tools, interactive forms, labor modeling tools, project quoting tools, labor tracking and reporting workbook, P&L dashboard and workbooks.

Whiteside Management Company, Consultant – Part Time (07/2010 – 9/2010)

o Make improvements to company’s bid sheet and create template in Microsoft Excel.

o Review job tracking sheet, revise, and make improvements.

o Assist in the contractor bid development and analysis process.

o Develop charts and graphs for analysis and presentation.

o Enter contractor bid data into spreadsheets.

Scion Staffing – Contemporary Jewish Museum, Facilities Manager – Part Time (07/2010 – 9/2010)

o Fill in for Engineer/Facilities Manager in his absence.

o Monitor and modify programming for mission critical and non-mission critical HVAC systems.

o Troubleshoot and resolve electrical issues.

o Ensure building policy compliance and correct setups during events.

o Monitor and ensure all building systems are functioning properly during events.

o Inspect and address building safety concerns.

Bay West Showplace Investors, A.K.A. San Francisco Design Center- Operations Assistant - Facilities Manager (10/1996 – 06/2008)

o Reviewed, analyzed, and critiqued monthly and annual financial statements.

o Interacted with administration, marketing, leasing, and accounting departments on projects.

o Provided support to Senior Vice President of Operations in maintaining the daily operations of two main properties comprised of 500k square feet properties with approximately 100 business tenants.

o Delegated maintenance task and special projects to maintenance engineers.

o Reviewed and approved contracts, expenditures, and purchase orders.

o Troubleshoot, along with maintenance engineers, various electrical, mechanical, and HVAC issues.

o Monitored, supervised, and managed building personnel.

o Supervised and coordinated construction projects.

o Monitored and ensured that maintenance engineers remain current with general maintenance programs.

o Monitored and ensured that all vendor insurance certificates are valid and in compliance with Rreef Property Management’s requirements.

o Assist in the development, installation, implementation, monitoring of interactive touch-screen kiosk, and 40” Liquid Crystal Display screens.

o Managed Inet Energy Management system.

o Managed capital expenditures amortization schedules and reconciled report with the Chief Financial Officer.

o Managed the purchasing of moving supplies during a major seismic renovation project which involved temporarily relocating tenant from their suites.

o Reduced the cost of moving supplies by more than 50 percent from negotiating with vendors to receive near wholesale prices for supplies.

o Managed Dataease Purchase Order System.

o Provided regular reports on operating, tenant improvement, and capital expenses.

o Negotiated with service providers and vendors for best rates.

o Interacted with vendors to maintain company accounts.

o Interacted constructively with tenants to resolve problems.

o Assist Vice President with department projects.

Education

University of Phoenix - Bachelor of Science in Business Management

City College of San Francisco - Associate Degree in Arts

Certifications

Microsoft Certifications: Word, Excel, and Expert Excel. (MCP)

HAS: Computer Technician Certification

NATSEM Certifications: Word, Excel, PowerPoint.



Contact this candidate