Project Financial Analyst
Resume:
J. Darin Pizzato
Farmington Hills, MI 48335-4502
*********@***.***
PROFESSIONAL SUMMARY:
Mr. J. Darin Pizzato is a Project Financial Analyst with 22+ years of experience within the Telecommunications, Automotive and Manufacturing Industries. He has extensive experience managing, developing, implementing and tracking Financial and Cost related projects in a Mainframe/Legacy/Client-Server/Web based/MS Office environment(s). Mr. Pizzato has had great success enhancing system(s) functionality. Relevant technical skills include- Microsoft Office products (Excel, Access, Outlook, SharePoint, Word, Power Point), ASAP Utilities, Mainframe Financial Platforms (JD Edwards GL, Rumba, DBS GL, AS 400), SAP(User Mods- FI-AR, FI-AP, FI-GL, Business Intelligence (BI), Business Warehouse, (BW)), SalesForce.com (SFDC), Oracle and Hyperion. Additionally, he has experience in managing extremely large amounts of data in a very meticulous manner. He is well versed in creating Financial Planning and Analysis (FP&A) modeling templates via Excel.
PROFESSIONAL EXPERIENCE:
WorldLink Consulting / Sub Vendor TelNet Inc. – (07/2013-05/2016)
Client- Samsung Electronics America
Project Financial Analyst – 07/2013-05/2016)
Provided NV Project financial support including EF submission(s) & milestone site acquisition & construction analysis for 4,000 sites in regional markets- R2W (East MI, West MI, Toledo, Cleveland, Columbus, Cincinnati), R11 (Pacific Northwest), R14 (Colorado, Idaho), R12 (California)
Create, record, audit and maintain regional site project cost databases and worksheets using MS Tools- Access, Excel (VBA Macros, VLookUps, IF Statements, Pivot Tables, ASAP Utilities), Word, Power Point, SharePoint
Provide accurate and timely Tier1 Vendor cost reporting and ad hoc reporting to Senior Leadership Team and ensure information is consistent and reconciled
Track and verify deliverables using appropriate Client-Server/Web Based tools such as Samsung’s Primervera and Sprint’s Siterra platforms
Provide timely payment information to Accounts Payable to ensure on time payments to the General Contractor(s)
Resolve issues relating to Tier1 purchase order(s) and excluded fee requests
Manage the development and implementation of key business methods and procedures aimed at driving efficiency within the department
Level 3 Communications formerly Global Crossing Telecommunications – (07/1997-03/2013)
Sales Compensation Analyst I – (10/2011-03/2013)
Manage the ongoing maintenance of a web-based tool (SalesForce.com) allowing the sales plan participants to view and acknowledge key documents online
Responsible for calculating and commissioning new hires Management By Objective (MBO) payments, 3rd Party (Agent) payments and Salesforce payments using Excel (VBA Macros, VLookUps, IF Statements, Pivot Tables, ASAP Utilities) commission modeled templates
Manage the development and implementation of key business methods and procedures aimed at driving efficiency within the department
Created adhoc sales metrics and analysis by title and region through the use of SalesForce.com (SFDC)
Sr. Financial Analyst– (07/1997-09/2011)
Developed Operating Expenses (OPEX) budget and budget revisions FP&A modeling template(s) using Excel (VBA Macros, VLookUps, HLookUps, IF Statements, Pivot Tables, ASAP Utilities)
Developed monthly OPEX reporting package for sales force management team and other finance groups
Coordinated with accounting teams to drive better understanding of OPEX results (Month over Month, Sequential, and Year over Year)
Perform monthly OPEX forecasting exercises and periodic improvements to forecast models and processes
Ad hoc project analysis and reporting
Co-ordinated all headcount assignments and cost centers within the North American Customer Facing Unit (CFU). CFU included Sales force, Service Delivery, Access Management, and Offer Management
Robert Half International Inc. / AccounTemps (09/1994-06/1997)
Contract Staff Account /Financial Analyst– (09/1994-06/1997)
Contracted Companies through AccounTemps- Toyota Tsusho America, Inc.; Lear Corporation; Siemens Energy and Automation; Borg-Warner Automotive. Essential duties performed within these companies:
Posting Journal Entries to General Ledger, Cash Management, Accounts Payable, Accounts Receivable, Job Costing, month-end and year-end closings
Reconciliations included tooling, bank, payroll, and physical inventory
Financial system platforms used: JD Edwards GL; Rumba; DBS GL; AS 400 Mainframe; PeachTree; Hyperion
EDUCATION / TRAINING:
Completed two-thirds of the B. A. Program in Accounting 1985-1990, University of Toledo, Toledo Ohio
OTHER RELEVANT SKILLS:
Strong analytical skills
Strong written and oral communications skills
Detail oriented with proven accuracy
Attention to detail with good organizational capabilities
Ability to prioritize with good time management skills
Team player with ability to self – manage
Demonstrated ability to work in a fast-paced and dynamic environment
Contact this candidate