Simon J. Mandel Email & Phone Number

New York, Ny, Us

New York, Ny

New York City Metropolitan Area

- Evaluated the financials used to update the Shawmut ‘Project Executive Scorecard’ measuring the financial progression for each Project Manager & Project Executive- Generated a report which calculated the gross profitability for each active Business Development project – distributed this information to the executive leadership team bi-weekly.- Streamlined the New York Region corporate ‘Work in Progress’ file for the Corporate Finance Dept.- Improved the visibility of this complex… Show more - Evaluated the financials used to update the Shawmut ‘Project Executive Scorecard’ measuring the financial progression for each Project Manager & Project Executive- Generated a report which calculated the gross profitability for each active Business Development project – distributed this information to the executive leadership team bi-weekly.- Streamlined the New York Region corporate ‘Work in Progress’ file for the Corporate Finance Dept.- Improved the visibility of this complex data set incorporating all key financial elements of active projects.- Assigned a set of projects at the beginning of the summer which I tracked and monitored regularly for changes and discrepancies in financial and compliance report data.- Documented weekly; noting project cost increases, decreases or remain constant from week to week. Show less

New York City Metropolitan Area

• Honed my use of the VLOOKUP formula in Excel to complete Business Development Job reports on a weekly basis.• Utilized the VLOOKUP tool to assess Contract Values, Estimated and Non-Estimated Labor costs, and to confirm the status of, Year to Date, Job to Date and Month to Date costs.• Documented in a job report if costs; Increased, Declined or Remained constant from week to week.• Incorporated the use of Sumif formulas to make future revenue projections indicating what the company… Show more • Honed my use of the VLOOKUP formula in Excel to complete Business Development Job reports on a weekly basis.• Utilized the VLOOKUP tool to assess Contract Values, Estimated and Non-Estimated Labor costs, and to confirm the status of, Year to Date, Job to Date and Month to Date costs.• Documented in a job report if costs; Increased, Declined or Remained constant from week to week.• Incorporated the use of Sumif formulas to make future revenue projections indicating what the company can expect to earn in future years and how that compares with current revenue positions.• Developed and regularly analyzed Budgets Reports, Change Order Reports and Compliance Reports for various active projects. • Assessed the financials used to update the Shawmut PX (Project Executive Scorecard) for each project the Project Managers and Project Executives supervised.o Established the gross profitability for each project and noted if there are negative financial results.o Confirmed all formulas are correct and updated broken formulas.• Visited the Job site of the main project I worked on - Marymount College renovation. Show less

New York City Metropolitan Area

* CHELSEA PIERS ELITE HOCKEY SUMMER CAMP * * Teach and coach accelerated players 8U to 18U to enhance their hockey skills on and off the ice.* Lead on-ice skills sessions and rigorous off-ice training sessions.

Bachelor Of Business Administration - Bba, Banking, Corporate, Finance, And Securities Law

Foreign Semester Of Study, International Finance - Barcelona, Spain

Foreign Semester Of Study, International Finance - Barcelona, Spain

'20

Activities and Societies: USHS-Prep Varsity Ice Hockey, Tennis