Management Project

RALPH K ROBINSON

**-** ** ****** ( Corona, NY ***68 ( *****.************@*****.*** (

Home/Cellular 347-***-****

SUMMARY

. A result-oriented Senior Manager with 10 years' experience in

financial analysis, planning and forecasting, modeling, budgeting,

product and business unit profitability studies, business valuations

(ROI's),Sales & Revenue calculations for Marketing Department for

Consumer Card at American Express, complex data analysis and risk

assessments.

. In charge of Accounting & Finance for four Foreign Divisions at Amex

TRS, JPA, ASPA,EMEA, Latin America.

. Supported a team of over forty Marketing Managers in developing sales

and attrition projections for one, and five year projections for ten

years.

. Excellent comprehension of accounting concepts (GAPP), financial

statements, financial valuations and/or management consulting

experience.

. Performed cost center analyses using Essbase extractions for internal

reporting.

. Extensive knowledge of governmental accounting rules and regulations

i.e. SOX

. Large scale project examples included - SAP from Oracle and PeopleSoft

of 90 Gas and Electric companies of all systems (Accounting, Treasury,

Payroll, AR, AP, inventory, fleet, and power plant). Total scope $

400 million and 400 consultants. In four states (National Grid 18

months).

. Small scale projects included New York Life managed 300 IT projects in

IBM Clarity for about a year. Total annual investment of projects

inventory was $300 million, 100 consultants tracked.

. Created models to support all budgets & forecast with valuation

analysis and due diligence of acquisition targets.

. Prepared and maintained internal management reports, and ad hoc

projects.

. MBA in Accounting

. Proficient in MS Office, Clarity, SAP, PeopleSoft, Oracle, Share

point, Visio

EDUCATION

MBA Public Accountancy 1988

St John's University, Jamaica, NY

BS Finance

1985

St John's University, Jamaica, NY

EXPERIENCE

National Grid, New York, NY 02/2014 to

Present

SAP Procurement Support, Project Management

* Consultant in support of the LIPA / PSEG Procurement Department assisting

Buyer and SAP users with the migration of LIPA to PSE&G.

RALPH K ROBINSON

33-16 99 Street ( Corona, NY 11368 ( *****.************@*****.*** (

Home/Cellular 347-***-****

BNY Mellon, New York, NY 09/2013 to

10/2013

Finance Consultant, Decision Support

*Performed reporting on collateralized accounts and client balances,

created internal monthly financial statements. Project focused on

determining the difference between client level verses account level

collateralization.

National Grid, New York, NY 10/2011

to 05/2013

Accounting/ Financial Analysis, Project Management

. Performed a Finance / Accounting SAP implementation for US

Transformation Program.

. Reconciled general ledger accounts to appropriate supporting

documentation, research variances and discrepancies and propose

correcting entries as necessary.

. Performed financial statement variance analysis on expense statements,

balance sheets and P&L's.

. Supported the preparation of quarterly and annual financial statements

by collecting, analyzing and summarizing account information and

trends.

. Daily duties included data testing, variance analysis, closings,

benchmarking, modeling, and creating various project management update

DEXs, reviewed and created FTE analysis reports.

. Validated data mappings and tables.

. Prepared detailed standard and ad hoc financial reports.

. Documented accounting policy and procedures.

. Supported the annual independent audit by preparing financial

schedules as needed.

. Performed training support and enhancement for new SAP implementations

in General Accounting.

New York Life Insurance Co - New York, NY

05/2010 to 01/2011

Financial Analysis / Accounting Consultant - Finance Director, Corporate

Technology Dept.

. Performed budget to actual variance analysis, price increases and cost

reduction reviews, planning, forecasting and financial modeling on

temporary assignment.

. Assisted the VP with the creation of the 2011 budget with cost

estimates and supporting documents.

. All projections were based off of a five-year Business Plan for

revenue, cost, FTE and operating expenses with commentary and

analysis.

. Conducted financial review of the ROI on technology investments for

insurance products.

. Prepared annual operating expense and capital budgets for 2011.

. Worked with business owners to provide individual direction to

forecast, PO's & SOW variances.

. Reviewed and analyzed all budget expense requests for approvals forms,

examined variances.

. Including working capital statements and rate of return on all 2010 IT

investments/projects.

RALPH K ROBINSON

33-16 99 Street ( Corona, NY 11368 ( *****.************@*****.*** (

Home/Cellular 347-***-****

. Analyzed and recommend ways to reallocate IT investments & expenses.

. Prepared budget & forecast schedules for presentation to Senior

Management for review.

. Created Excel models to support all budgets & forecast with valuation

analysis.

. Maintained a five-year budget in Clarity by IT project number.

. Reviewed and tracked IT contracts, Purchase Orders, SOWs, and RFIs.

. Made monthly and year end accruals for non-FTE consultants or vendors.

Ensured FASB & GAAP compliance and reviewed depreciation schedules.

WilBen Search, Jersey City, NJ 06/2008

to 01/2010

Finance/Accounting Analyst

. Performed budget to actual variance analysis, price increases and cost

reduction reviews, planning, forecasting and financial modeling on

temporary assignment.

. Daily duties included, preparing journal entries, managing fixed

assets, account analysis and reconciliation.

. Assisted in the preparation, maintenance, & distribution of internal

management reports, ad hoc projects and enhancing the budget/forecast

processes.

American Express - Consumer Cards Division 1997

to 2007

Senior Finance Manager - FP&A Decision Support

. Performed cost center analyses using Essbase extractions for internal

reporting.

. Created major parts of the annual budget ($300 million in revenue &

$100 million in PTI).Supported and created all quarterly forecasts

with 30 Marketing Managers for over 20 Card Services products.

. Entrusted with reviewing monthly results and providing management with

an assessment of risks & opportunities to the monthly forecast/budget

for over 20 Card Services insurance businesses.

. Held monthly review meetings to discuss forecast trends and major

budget risks with the department president, VP's and Directors.

. Submitted and track division monthly FTE (full time equivalent),

headcount reports to senior management and created supporting

commentary.

. Entrusted with overseeing and reviewing all preliminary and final

monthly General Ledgers & Trial Balances before distribution to

Finance and Business leaders.

. Partnered with Marketing Managers & Directors to help accommodate

requirements from Treasury, Controllership, Accounting, Compliance,

and other impacted teams.

. Created Excel models to support all budgets & forecast with valuation

analysis and due diligence of acquisition targets.

. Received corporate recognition (American Express' rings of reward) for

identifying cost reductions, and developing new financial reporting &

models that increased the accuracy of Card Services planning &

forecasting.

RALPH K ROBINSON

33-16 99 Street ( Corona, NY 11368 ( *****.************@*****.*** (

Home/Cellular 347-***-****

. Ensured GAAP compliance and Sarbanes Oxley certifications for existing

and new products in development.

. Responsible for balance sheet reviews and highlighting high-level

reserve adjustments.

. Payment Processor Product Management Related Duties (Product

Analytics).

. Responsible for reviewing Marketing's behavioral assumptions using

American Express' internal risk system (RIB) for product performance

and acquisition response rates for test groups and product metrics

reporting.

. Maintained monthly, weekly and daily metrics for senior management on

credit/charge card spend, travel usage (AIRROC), type of spend

"Everyday" to report product penetration into total card member base.

. Responsible for the monthly close package & presentation to Marketing

on all post campaign metrics actual vs. estimates.

. To determine product and industry trending for risk assessment, used

double click and RIB as well as industry published data.

. Tasked with the creation of new metrics & benchmarking for new

products in development and/or product line enhancements for financial

modeling.

. Used similarly correlated AMEX card products, external vendor or

competitor data.

. Supported new products, businesses & line enhancements in development

on an as-needed basis usually two or three a quarters.

. Prepared financial documents and other presentations to proactively

manage the resolution of risks and issues (including escalation when

appropriate).

. Supported multiple functional areas/departments in developing and

implementing project plans.

TRS HQ American Express 1992

to 1997

General Accounting Department

. Supervised a team of 4 Senior Accountants in preparing balance sheet

reconciliation's for American Express Travel Related Services.

. Supervised 4 HQ divisions and recorded all adjusting & monthly entries

for foreign investments.

. Responsible for preparing and presenting the quarterly senior

management balance sheet review package.

Contact this candidate