Data Crystal Reports

Career Objective: I am an innovative individual with the ability to

rapidly learn new technologies and adapt to changing business environments

and possess the ability to locate the proverbial "needle in the haystack".

I seek employment in an IT or reporting position with growth potential

where immediate contribution is required.

Computer Skills: MS Office Professional, Crystal Reports, Lotus Notes,

Visual Basic for Applications (VBA), Quickbooks, MicroEdge Gifts for

Windows modules: Administrator, Matching/Volunteer Gifts, Budget, A/P,

Customizer, IGAM, Reviewer Connect, Documents Manager, and Plus Pack

Professional Experience

Ajilon and Robert Half Technology - for Chrysler LLC - 5/2002 - 9/2009

Technical and Financial Coordinator - The Chrysler Foundation

Liaison for the Foundation staff in technical matters, assist in

implementation of new systems, administer various education programs,

financial reporting, and payments. Depth of responsibilities include:

> Technical Coordinator and Database Administrator - Troubleshot software

problems, placed support requests, and coordinated software upgrades and

installation; created and revised report and letter templates in Word,

Excel, and Crystal Reports; created and automated reports; trained staff

in technical procedures; updated obsolete coding and created new coding

as needed; created and deactivated users; set permissions and settings;

purged and backed up documents; corrected coding to ensure data

integrity; created and administered reviews with Reviewer Connect

software; created and ran queries and reports, manipulated data manually

and with update queries in Access link to Oracle back-end.

> Matching Gifts and Educational Programs Administrator - Performed data

entry of all matching gift requests, created and sent correspondence for

matches with problems; batched and created correspondence for gifts;

enforced restrictions of the Matching Gift Program; served as liaison

between schools or educational organizations and corporate personnel for

Aid to Higher Education, Aid to Pre-College Education, and College

Automotive Programs; created and sent correspondence as determined by

Program; created Access database and updated daily to aid with HR's

reporting needs.

> IGAM (Internet Grants Application Module) Administrator - Retrieved grant

applications and status reports submitted over the internet; completed

coding, printed attachments, and assigned files to staff members;

troubleshot with those experiencing difficulty with the electronic

application process; monitored and responded to Foundation's e-mail box.

> Financial Coordinator - Scheduled and executed payments, including

printing checks and executing wire transfers; reconciled monthly bank

statements with corporate accounting personnel; performed bookkeeping and

financial reporting for auditing and accounting personnel; maintained

budget.

> Miscellaneous Duties - Researched organizations for benchmarking and

grant-making opportunities; recommended procedural changes, solutions,

and tools to increase workplace efficiency; volunteered for various

Foundation-supported events.

Iconma, LLC. - for Guardian Industries - 11/2000 - 2/2002

Report Writer/Programmer - Corporate Finance

Instrumental in the company's changeover from Lotus and R&R products to

Microsoft Office and Seagate Crystal Reports. Completed numerous projects

that involved manipulation of data and heavy VBA and SQL programming in

Access, Excel, and Crystal Reports. Performed monthly load of Sales and

Profitability data into Essbase database. Projects included:

> Morning Report - R&R rewrite into Access application that included heavy

manipulation of data, light VBA programming, and exports into MS Word

.rtf files for implementation in plants worldwide.

> Cost by Driver/Price Cost Comparison/3rd Stage Driver Reports -

Interactive Access application that standardized three different R&R

reports with continually changing fields and merged them into one

database. Cost by Driver included exports into different templates in

Excel and heavy VBA programming and data calculations. For use by

Activity Based Costing consultants in North and South America

> Segment Report/Plant Close Report/QBDA - Wrote Excel macros in VBA code

to update reports for current month and location. In use at corporate

headquarters and in plants worldwide.

> Expense Reports - Wrote 15+ complex standardized reports with Crystal

Reports for use with company's new Necho NavigatER Expense Reporting

software. Every report required manipulation of SQL and data and

complicated formulas comparable to VBA.

Kelly Services - for General Motors - 12/1999 - 10/2000

Data Analyst - Powertrain Change Management - Truck Engine Sector

Created and implemented Access databases for product change management

reporting. Traveled to Ypsilanti, Pontiac, Warren, and Windsor for

presentations of databases. Accomplishments:

> Solved five-month long reporting problem in one day by creating Access

database with macros and downloads to Excel.

> Collaborated with Access Programmer in Windsor on database for

implementation over three sectors.

Kmart Corporation - troy, mi - 07/1998-12/1999

Finance/Accounting Specialist - Facility Services Division

Created weekly and monthly reports by extracting data from Oracle Financial

Analyzer and Focus datasets in a TSO environment for use in Access, Excel,

and Crystal Reports. Created and maintained Access databases for most

reporting needs, as well as special projects and research from full audits

to 10-minute "snap-shot" reports. Trained new and temporary employees.

Accomplishments:

> Developed and implemented innovative business solution for SuperK

quarterly variance reports using Crystal Reports and Access database;

received recognition from Divisional Vice President for quarterly reports

> Created and implemented Excel and Access solutions for weekly and monthly

reports that greatly improved time efficiency and reliability of data.

> Provided business leadership on departmental development team working

with Information Systems

Education and Professional Training

Gustavus Adolphus College, St. Peter, MN

Bachelor of Arts, French, GPA: 3.7 (Magna Cum Laude)

Professional training courses: MS Excel, Access, Word, PowerPoint, and

Crystal Reports, MicroEdge Gifts for Windows

11753 Chattman Dr.

Sterling Heights, MI 48313

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

E-mail: abic4e@r.postjobfree.com

Contact this candidate