Service Analyst

Sheila M. Abbott

E-mail: **********@*******.*** ( 146 High Street, N. Billerica, MA 01862 (

Phone 978-***-****

Profile

Financial, Budgeting, Operations and Analysis professional skilled at

forecasting, scheduling, and decision support. Experienced in financial

consolidations, capital acquisition, contractor and vendor management, and

executive fiscal reporting. Excels at communicating across the broad spectrum of

acquisition stakeholders as well as operational & sustainment users and their

financial management organizations.

Core Competencies

Financial Reporting ( Cost Reduction ( Executive Decision Support ( Strategic

Analysis ( Budget Execution ( Team Building

Contractor/Vendor Management ( Microsoft Office ( Government Contract

Negotiation

Career Highlights

SECRET Clearance, sponsored by SSP, Department of the Navy, 1988 - 1998. Not

renewed due to change in job responsibility.

Calculated and compared internal infrastructure costs to standard Information

Services (IS) industry benchmarks in order to generate Total Cost of Ownership

(TCO).

Prepared and presented budget briefings for and to Chief Information Officer

(CIO) and Chief Technology Officer (CTO) and improved reporting accuracy.

Streamlined/automated engineering/budgeting/manufacturing process, minimizing

errors by integrating quoting and pricing into design document using Excel macros

and arrays. Reduce time required to price an engineering change from 1 week to 1

day, thereby creating more flexibility and more accurate and timely pricing.

Consolidated accounting for multiple service centers into a summary report for

monthly briefings. Tracked variances down to the line item for

explanations/corrective actions.

Designed and implemented the Service Center acquisition process which

standardized desktop computer equipment, negotiated volume discounts, and tracked

budgeted against actual

Created Service Center budget model in Excel using the bottoms up approach;

including labor records, fixed assets/leasing records, and expense records

starting with basic services, and denoting specific costs for each service.

Directed client and commercial accounts review for compliance documentation and

compiled audit file. Collected Customer Information Profile (CIP) data for all

grantors or parties as well as reviewing agreements for proper compliance

enforcement. Automated reporting and tracking of compliance updates.

Over 20 years of DoD weapons system and commercial financial analysis and related

support.

Professional Experience

Bank of New York Mellon 2008-present -Compliance Consultant

Analysis of compliance updates, with daily status reports back to management

categorizing issues and actions required, managing spreadsheets across multiple

projects and reporting sites.

Direct client and commercial account review for compliance documentation and

compiled audit file. Collected CIP data for all grantors or parties as well as

reviewing agreements for proper compliance enforcement.

Research all parties on the Internet to create a Source of Wealth (SOW) summary.

Verify accuracy of facts documented within the files and report on discrepancies

and compliance shortfalls.

Trained in BSA, KYC, and AML compliance through Bank of New York/Mellon.

TYCO Telecom-Lowell MA 2007-2008 - Financial Analyst II

Streamlined/automated engineering/budgeting/manufacturing process, minimizing

errors by integrating quoting and pricing into design document using Excel macros

and arrays. Reduce time required to price an engineering change from 1 week to 1

day, thereby creating more flexibility and more accurate and timely pricing.

Prepared monthly reports, invoices for customer billings, production charts, and

adherence to plans, based on manufacturing results and deliveries. Maintained

physical inventory database of Fixed Assets using Access. Tracked capital

spending against approved CERs.

EnableUs, Inc Billerica, MA, 2004-2007 - AR/Analyst/CRM Liaison

Saved company $1M by reducing Days Sales Outstanding (DSO) from over 150 days to

less than 60 days, clearing over $800K of overdue receivables, avoiding $200K of

planned write offs. Received 2 "Spot Awards" for receivables collections.

Created an audit tracking system to eliminate missed revenue from HUD billings

and reconciliations from expenditures.

Automated generation of annual software maintenance agreements based contract

specification (annual increase caps, notification requirements, and funding

limits).

Performed Ad Hoc research projects and generated presentations for CFO, SVP of

North America Operations, and SVP Client Services.

Litton, TASC, Inc., Reading, MA 1987-2001

( Six Sigma Black Belt - Billing Process Improvement Project 2000-2001

ASQ/Six Sigma Academy black belt trained in Mikel Harry's breakthrough strategy

for process improvement.

Documented/improved existing processes and reducing error opportunities.

Automated wherever possible, through use of Excel Macros, pivot tables and shared

worksheets.

Use Minitab to calculate distribution curves and statistical data.

Authored and maintained corporate web pages for policies and procedures.

( Staff MTS, Financial/ Budget Analyst, Integrator TCO Advisor to the Chief

Information Office 1998-2000

Prepared PowerPoint financial management/budget briefings on a monthly, quarterly

and annual basis for CIO and Chief Technology Officer, tracking performance

against plan, by incorporating financial status information, as well as variance

details and corrective actions.

Calculated and compared internal infrastructure costs to standard Information

Services (IS) industry benchmarks, to generate Total Cost of Ownership (TCO).

Served as Vendor Liaison on the technical side, interfacing with Purchasing, to

consolidate support contracts and set hardware and software standards to obtain

the consistent reduction of TCO. Advised on capital acquisition decisions, from

both a fiscal and technical point of view.

Designed and implemented the Service Center acquisition process - standardized

equipment, negotiated volume discounts, and tracked budgeted against actual.

Tracked large contracts and blanket purchase orders to accurately allocate costs

across programs, and put new cost vehicles in place before the existing ones ran

out.

Created service center budget model in Excel using the bottoms up approach;

including labor records, fixed assets/leasing records, and expense records

starting with basic services, and denoting specific costs for each service.

( MTS, Information Center Analyst - Office Automation (CIO) 1987-1998

Consolidated accounting for multiple service centers into a summary report for

monthly briefings, similar to reporting multiple sub contractors for a single

CLIN. Tracked variances down to the line item for explanations/corrective

actions.

Acted as Technical Interpreter between IS staff and user community. Translated

business requirements into system specs for developers to use. In reverse,

translated system issues into business implications for problem resolution and

decision-making.

Co-architect/developer for Remedy Help Desk Call Tracking Software design and

Implementation.

Represented corporation at National Conferences (Gartner Group - Symposium,

Remedy User Group, WP/Novell Annual User Group).

Architected LAN for Strategic Systems Programs (SSP - USN) for Office Automation.

Trained the staff of the SSP (Navy, contractors and users), at multiple sites on

Network and Office Automation tools.

Installed LANs at HQ in Crystal City, NOTU, and Sunnyvale (Lockheed). Trained

SSP staff to install and administer LANs at other sites.

Presented at Quarterly Briefings to SP16 and staff.

Textron Defense Systems, Wilmington, MA (1985-1987) - Information Systems Analyst

Worked on Proposal Pricing System, using Boeing's EIS tools. Represented company

at National conference, presenting our modification of their system to work

within the MVS rather than VM operating system.

Data analysis using RAMIS IV, a 4GL, precursor to the current SQL programming.

Sikorsky Aircraft, Stratford, CT (1982-1985) - Programmer Analyst, Program

Control Dept.

Automated CSSR/CPR reports using Supercalc.

Beta tester for Lotus 1-2-3 version 1.0.

Other Skills

Microsoft Office: Excel (macros, pivot tables, arrays, linked and shared

worksheets), PowerPoint (embedded documents, animated presentations), Word (mail

merges from Excel spreadsheets, labels), Visio (flowcharts, org charts).

Enterprise Software: HEAT & Remedy - 2 different customer trouble ticket tracking

systems, Hyperion Pillar software, SAP - manufacturing and financial modules,

Data warehouse mining and reporting; Siebel ServicesCRM Software - STARR

Minitab for statistical processing.

Education

Norwich University, Northfield VT - BS in Applied Mathematics

2005 - present, Norwich University Board of Fellows, Math & Sciences Division

1995 - 2000, Norwich University Alumni Association Board of Directors

Contact this candidate