Analyst Data

MARK JAROCHA

***** ******* **., ******, ** ****9

Phone: 586-***-****

Email: ****.*******@*****.***

_______________________________________________________________________

_____________________________

CAREER OBJECTIVE

Seeking a challenging position where my skills and abilities in organizing,

coordinating, planning and managing will be utilized to contribute to the

overall satisfaction of the customer while using my skills in Access and

Excel.

PROFESSIONAL EXPERIENCE

Motor City Electric Co. - Detroit, MI

05/2007 - 04/2009

Contracts Administrator

. Verified and set up new project work orders on the eCMS system.

. Processed change order to work order requests to contracts.

. Generated various monthly reports for project managers.

. Prepared all OCIP reporting and corresponding documentation.

. Down loaded data from the eCMS system into Excel for report

processing.

. Wrote macros in Excel to automate the reporting process.

. Set up new cost codes for reporting purposes.

. Loaded RFC's into the eCMS system and Tracking Log Spreadsheets.

Ford Motor Co. (contract assignment through 4-Serv) - Dearborn, MI

04/2007 - 05/2007

Finance Analyst

. Reviewed Commodity Excel spreadsheets and compared them against

what was reported on the system.

. Conducted one-on-one meetings with the Commodity Analysts to help

them understand the results of the comparison of the Excel

spreadsheet and the system.

. Generated comparison reports for the Commodity Analysts.

MSX International - Warren, MI

06/2006 - 02/2007

Data Analyst

. Supported the Jaguar / Land Rover and International Truck Websites

by answering calls on the Help Desk phone line and responding to

email messages left in the website mailboxes.

. Wrote detailed business specs for our offshore IT provider.

. Verified data by doing deep-dive analysis and testing.

. Generated ad hoc and weekly reports by using Access and Excel.

. Wrote macros in Access to automate the reporting process.

Carhartt, Inc. (contract assignment through Kelly Services) -

Dearborn, MI 03/2006 - 06/2006

Demand Planning Coordinator

. Generated weekly and monthly reports using AS400, Access and Excel.

. Wrote macros in Access and Excel to automate the reporting process.

. Wrote detailed procedures to generate weekly and monthly reports.

. Created complex spreadsheets in Excel using the VLOOKUP function

for Estimate Accuracy Tracking.

. Created Product Life Cycle Graphs in Excel.

General Motors Corp. (contract assignment through TEK Systems) -

Warren, MI 12/2005 - 02/2006

Cost Analyst

. Prepared monthly forecast metrics.

. Created and analyzed the monthly Total Cost Reduction Report.

. Investigated and corrected erroneous charges on invoices.

. Designed and created an Access database to track cell phones.

ACN - Farmington Hills, MI

03/2004 - 10/2005

Business Analyst

. Designed and created Access databases to track monthly invoice

records and department time studies.

. Provided technical support for the Finance Area (Cost Management,

Revenue Management and Accounts Receivable).

. Back-end testing for new products and services.

. Wrote and modified SQL queries.

. Wrote Access and Excel macros to generate month-end financial

reports.

. Analyzed data trends for weekly and monthly reports.

. Created month-end reports using Access and Excel.

General Motors Corp. (contract assignment through PDC) - Warren, MI

03/2003 - 12/2003

Data Analyst

. Wrote and supported Excel macros to generate weekly box/walk chart

reports.

. Created weekly PowerPoint presentation slides.

. Designed and created an Access database to track (20 In 3

Initiative) Value Chain class workshops.

. Automated the Troubled Suppliers By Program Report.

. Resolved customer problems with box/walk chart reports.

. Created ad hoc reporting (using complex queries) in Access.

Ford Motor Co. (contract assignment through MSX International) -

Dearborn, MI 02/2000 - 02/2003

Software Planning Analyst

. Responsible for administration of the Isogon (Software Asset

Management) database: importing data into the database, insuring

data accuracy, creating standardized and ad hoc reports.

. Created Access databases to produce specialized reports.

. Followed up on vendor order problems.

. Loaded software database updates.

EDUCATION

Masters of Science in Business Administration -

Central Michigan University

Bachelors of Arts in Sociology -

Wayne State University

Associate of Applied Science in General Business -

Macomb Community College

SKILLS / CERTIFICATES

Access - OutLook - Consumer Driven 6-

Sigma Green Belt Training Certificate

Excel - PowerPoint - Dale Carnegie Public

Speaking Certificate

Lotus Notes - Word - Intermediate Workplace

Computing Certificate

Contact this candidate