Project Manager Vice President

SUSAN M. CLARKE

** ********** ****

Stamford, Connecticut 06905

Home: 203-***-****

SUMMARY

Customer oriented personable, with extensive years of experience. Excellent

at anticipating the needs of business users. Good interpersonal skills with

the ability to understand and translate business needs into workable

solutions. High level expertise in Microsoft Excel pivot tables and

Microsoft Access table extractions. Capable of helping organizations

identify application solutions. Recent office manager experience using

Peachtree. Looking for responsible job using all my skills.

PROFESSIONAL EXPERIENCE

ZIEMAN ENGINEERING, LLC Stamford, Ct

2007-2009

Office Manager

Responsible for all aspects of the office including Payroll, Taxes,

Accounts Payable, Accounts Receivable, Purchasing,, Shipping, Facilities.

Uses MS Office including Word, Excel, and Access.

GENERAL REINSURANCE SERVICES CORPORATION, Stamford, CT 1989-

2006

Senior Information Analyst, Assistant Vice President (2004-2006)

. Assumed responsibility for Underwriting group, a user base of 65, in

addition to continuing as lead ad-hoc reports person for Corporate

Actuarial, a user base of 15.

. Produced 65 MS Access requests per month to help users in making

intelligent business decisions.

. Maintained on-site work log and produced reports for new IT Information

group in order to demonstrate productivity levels of the group.

. Produced new standards for Actuarial procedures during transition to an

Oracle based system.

Senior Systems Developer, Assistant Vice President (2001-2004)

. Revised Actuarial procedures to insure compliance with new Sarbanes Oxley

standards. Became pivot table expert for Underwriting. These

spreadsheets helped management anticipate new business needs and assess

line problems quickly.

. Produced 32 pivot tables for each line of business segment each quarter.

Produced all monthly actuarial data extractions in half the time of

previous procedures by restructuring process.

. Became Claims Experience expert for extractions of loss data.

Senior Systems Analyst, Assistant Vice President (1999-2001)

. Selected by Actuarial Management to be part of Corporate Actuarial for on-

site work.

. Extracted all data needed for monthly and quarterly processing,

balancing, security, and data back-up.

. Worked with Auditors to gather actuarial data for yearly corporate audit.

. Interviewed all new actuarial applicants to assess technical skills.

. Successfully led off site simulated run of all actuarial systems.

Senior Systems Analyst (1995-1999)

. Became first on-site IT person in Corporate Underwriting.

. In-charge of all hardware and software roll-outs while doing all needed

ad-hoc reporting using mainframe data, SQL and DB2.

. Worked with Underwriting to automate manual procedures.

. Introduced MS Excel use of pivot tables to the underwriters for

portability.

. Worked with records retention department on all their internal systems

for data collection and retrieval.

. Trained to be a Facilitator. Was selected for many projects that helped

users change manual processes to automated processes with proper

balancing and accountability,

SUSAN M. CLARKE, CCP

Home: 203-***-****

Page 2

Project Manager (1991-1995)

. Responsible for a group of six people.

. Negotiated purchase of all hardware and software for Corporate

Underwriting and Actuarial.

. Developed Loss Triangle Systems.

. Supported a user base of 85 people, budget was $75,000.

. Interviewed and hired all new programmers for the group.

Project Leader (1989-1991)

. Supported a user base of 65 people with a team of 2.

. Maintained Actuarial Legacy systems.

. Created Lag Load reports and Actuarial reports, the first reports that

combined Losses and Premiums from all internal systems. These reports

were used to make responsible decisions by senior management. (Still in

use!)

WALDENBOOKS, Stamford, CT 1978-

1989

Information Center Specialist

. Created the Information Center at Waldenbooks Home Office. Helped

everyone from the mailroom personnel to the President of the company get

data.

. Bought the first company PC, and negotiated for everyone to have one.

. Bought DB2 for the mainframe in 1983, based on my recommendation.

. Created the beginning systems to run the business by computer instead of

manually - Title file, store sales, flash sales report to management.

. Bought Lotus 1-2-3, upgrading from VisiCalc. Taught many different

database languages, both on the mainframe and on the PC.

. The Information center grew to five people.

. Tested new Cash Register transactions that were used in 1000 stores.

EDUCATION and CERTIFICATION

M.S, Computer Science 1975, Rensselaer Polytechnic Institute, Troy, NY,

B.A., Mathematics with minor in Computer Science 1973, Queens College,

Flushing, NY,

President of Mathematics Club at Queens College

Earned CCP (Certified Computer Professional) designation from the ICCP,

Chicago, Illinois 1985

SOFTWARE

Microsoft Office Suite including Access, Excel with VBA, Word, Pivot tables

in Excel. QMF, SQL for DB2, ODBC data sources.. Created DB2 database (all

losses for GRC since 1921). Linkedin and Facebook user. Background in LISP,

Snoball, Cobol, Algol, Mark IV, Lotus Notes proficiency and a course in

Crystal reporting.

Contact this candidate