TOM HOFFMAN MBA ** Chelsea Way

Bridgewater, NJ **807

Phone (Cell) 908-***-****

Summary

Proven hands-on leader and team player with expertise in managing large-scale, complex projects. Financial and Business Project Planning Manager/ Coordinator/ Analyst, who thrives on challenges and excels under pressure versatile, flexible, creative, analytical professional with strong communication facility and the ability to influence/ impact others to obtain business objectives.

SYSTEMS EXPERIENCE: Hyperion (Sanofi-Aventis), EPPM (Merck) ARIBA (Merck JNJ), SAP (J&J, Sanofi-Aventis, Tyco, Lucent Merck), Oracle (ADP, IEEE), Lawson system (L’Oreal, Pathmark/A&P), Microsoft Word, Excel (Pivots,V- Lookups), Powerpoint, Project, Visio, Outlook, Lotus Notes, ARIS, as well as strong verbal and written skills.

WORK EXPERIENCE:

12/2017-Present – Merck – IT Project Financial Coordinator – Oversee IT Project financials – PM Coordinate decommission rebuild of 27,000 Merck websites. $50M to $150M annual savings. Ensure EU-USA standards - Cookie Panel compliance, copyright, etc.

1/17/2017 – 11/2017– BMS –Bristol Meyer Squibb - Project Management - Analytics (Supply Chain SRM, Procurement segmentation, Product Risk Assessment). Business Continuity Risk. Analyze existing agreements, summarization of contracts. Develop PRAM algorithms models . Financial Analysis/ and Forecast.

8/2015-12/2016 – Roche Molecular-Financial Analyst– Manufacturing Analysis and monthly Financial closing, Inventory and risk, absorption packages. KPI’s, inventory/ product costing & forecasting. Annual auditing & posting results. SAP drivin.

9/2011-7/2015 – Merck – IT Project Financial Coordinator – Oversee IT Project financials ($80M) for EICC & Consumer Divisions (Supply Chain, R&D, Marketing, Sales, Compliance) Generate IT PO/contracts, Prepare Budget/forecast, actual variance (SAP/Ariba/MSPS). Coordinate with Audit PM’s & IT Leadership Team focusing on transparency program Compliance and Service delivery. Documentation of results. Obtain approvals, coordinate PM / manpower forecast/actual/accruals, Software and Lab maintenance, executive milestones and monthly scorecard presentation. P2P focus (Procurement Ariba and SAP/Comet systems ). COE Team.

9/2009-9/2011 – Johnson & Johnson – Financial Project Coordinator – Corp Governance team – Develop Business Case for 10 year plan, summarize global financial workshop survey results & metrics for world-wide Finance/ systems consolidation project.

Track project issues, provide recommendations, streamline initiatives for LT & ‘Quick-win’ projects & report to Sr. Mgmt. (GL/FA/ER/IC), (Bal. sheet recon Greenbelt project, Inter Co.)

Interface with outside consulting group (Hackett) analyzing current Vs future world-wide organization based upon Best Practice guidelines for ‘best in class’ company. Bus. Case preparation. Workflows. Documentation of strategic plan for Sr Managemnt.

Provide meeting minutes, analysis, scorecards, charts, & BOP’s. Process Mapping for IA.

Manager of Fin Analysis II (SAP) - AP system mapping & conversion in support of IT/ SAP rollout to 5 J&J global companies (from ARIBA system to SAP)

8/2009- 9/2009 – Bristol-Myers Squibb – Prepare Documentation & workflow procedure for $7 Billion business divestiture. FMV of assets.

5/2007-4/2009 - Johnson & Johnson SAP Project functional Analyst – Implementation of global pre-approval inter-company system (WINGS), in avoidance of out-of-balances. (impact $4B). Coordinate SAP functional requirements, specs, templates, testing, webcasts, data-conversion, issues, & training with IT (for over 400 companies over 2 years).

Dev. SAP Functional specs based upon Financial Mgmt interviews- write BPRs./ interface with IT. Capture business partner requirements, prioritize and review with Functional Lead and IT Consulting Team.

Write test scripts & participate in SAP system testing, training, launch, & develop level 2 Help Desk. Prepare BOPs documentation for historical reference – maintain audit trail.

Analyze user feedback, prepare SAP system enhancements BPRs, Test system dynamics, (SAP modules: SD/MM/FICO). Manage controls for new co codes/LE’s Participate in training of end users.

Develop/ test worldwide SAP e-mail system, with attachments & subject line information. Challenge IT production team via system tests and level II recommendations.

3/2007-5/07 Tyco Inc. Consultant - For divestiture and separation operation

5/2006 – 1/07 IEEE (6 Mos) (Institute of Electrical and Electronics Engineers, Inc.) Financial Consultant, 400,000 member (billion dollar) conference business

Coordinate change to accrual reporting for 900 intl conferences, (net billion dollars). Developed Net based budgeting/tracking system with IT integration for GAAP compliance. Mapping of process/procedures and roll out/presentation to over 1200 Treasures world-wide.

5/ 2005 – 9/05 Sanofi-Aventis Pharmaceutical Corporate ConsolidationConsolidated annual corporate forecast for Sanofi and Aventis merger by business group and division using SAP & Hyperion. Analyzed/ consolidated inventory with variance analysis. Developed process for monthly reporting. (Full time student - Masters program at this time).

1/2001-4/2004 L’Oreal USA Corporate Manager, Planning and Forecasting – Internal Consultant

Responsible for Planning, Forecasting, Business Analysis for Consumer Luxury Products. ($360M).

Marketing financial for (36 brands), including P&Ls, Gross Margin-COG analysis, royalties, returns, advertising, promotions, fixed Costs, monthly reporting to Marketing/Sales management. (Including Armani & Ralph Lauren brands).

Reported/analyzed Revenue from Gross to Net (Allowances/Returns/Discounts) to Financial Management, Sales, and Marketing.

Partner with Corporate IT department in development of Capital Request system, product Marketing decision tracking and Legal Council trademark tracking systems.

Also Responsible for Corporate wide projects to evaluate business issues, efficiencies, and opportunities for improvement. Manage direct and team intervention for the following projects:

Speed to Market Study – Hair Products Corporate study for all Divisions $142M impact

Inventory Process Evaluation (for high speed lines-Franklin NJ plant) $ 10M impact

Capital Expenditure DCF ROI Evaluation & documentation $120M impact

Subcontracted Vendor Inventory Review (plant analysis) $ 13M impact

Marketing Department turnover Evaluation (Lancôme Division) $ 8M impact

6/1999–11/2000 Lucent Technologies Manager, Outlooks & Business Case Analysis

Monthly Outlook process consolidation for $8B Annual Plan in Business Communications Systems & coordination of Business Case team.

Creation & management of Outlook Team, reports & evaluation of results for Revenue, Expense, and Units, (By business channel, and business segment). Reporting variances & improving production performance.

Development of Business indicators, & systems review and upgrades, including partnership with IT to develop Funnel system implementation with SAP. Systems audits.

Team leader in financial model upgrade for Customer Special Bids, ($200M impact). P&L R to E product analysis & modeling.

Planning team manager for US Sales Revenue & Expense ($7.6Billion & $1B). Coordinated with Business field management & acquisitions.

3/1998–4/1999 Electronic Data Services Corporation (EDS)

Manager, Financial Analysis

Reporting to the Controller, responsible for managing financial analysis and reporting, acquisition and divestiture modeling and financial reporting for a division of a $12 billion financial service provider of over 100 thousand employees.

Coordinated and maintained a $250M expense budget .

Assisted in product line divestiture with net savings of $2M.

Participated with IT in Demand Capacity Planning system analysis and Business Measurement Tracking and Reporting evaluation/new product planning & analysis to Steering Committee.

Responsible for supervising the Finance and Billing departments servicing 3,500 clients and $60M daily bank balance funds transfer.

6/1986–3/1998 Automatic Data Processing Corporation (ADP)

Sr. Financial Analyst – Capital Planning

Reporting to the Corporate Treasurer and Corporate Vice President of Real Estate, responsible for managing the financial analysis, capital procurements, Construction and financial reporting for a $4 billion financial service provider of over 100,000 employees worldwide. FMV – Buy Lease Analysis

Managed the Strategic Plan for capital acquisitions totaling $100M, Assisted in development of Business Case procedures across the corporation as well as P2P process & documentation.

Controlled Capital Appropriations Requests for all capital projects in excess of $100K.

Responsible for Real Estate Buy VS Lease analysis, Lease escalation reviews, and all Construction estimates, contracts, and payments ($60M), FMV All Construction projects!

Directed financial portfolio of over 150 projects, (annual) representing 2 million square feet.

Designed Corporate Cost Estimating System with Corp. IT .Provided $2M in annual savings.

4/1981–6/1986 Exxon Corporation

Financial Audit / Internal Control

Reporting to the Director of Corporate Audit, responsible for auditing the Corporate A/P and Treasury systems for a $200 billion oil manufacturer of over 120,000 employees worldwide.

Created and insured compliance with Corporate Internal Control policies, provided sample-testing procedures.

Tanker Division HQ relocation project Fin Analyst / P2P/forecast from NYC to N.J.

EDUCATION:

Chubb Computer Services, Top Gun School, Diploma, SAP Functional Program, May 1999

MBA, – Fairleigh Dickinson University 1986

MFA – NY Academy 2006

BA, – Syracuse University in Communications

Contact this candidate