Report Analyst

KELLY KLIMARCHUK

*** ******* **** **********, **** 01719 ▪ ***********@*****.*** ▪ 617-***-****

REPORT ANALYST ▪ DATA ANALYST

Objective: Accomplished professional with over 10 years’ experience creating reports, gathering and assessing data, and streamlining information processes seeks to obtain Analyst position with established firm.

Profile: Self-motivated professional with demonstrated ability to collaborate and drive large-scale projects to completion with accuracy, diligence and timeliness. Cultivates and maintains positive relationships across all business hierarchies with an emphasis on team building and teamwork. An independent thinker noted for capacity to analyze problems and create viable solutions for implementation.

Summary of Strengths & Qualifications

▪ Report Writing ▪ Data & Report Analysis ▪ High Technical Aptitude ▪ Team Player

▪ Analytic Problem Solver ▪ Train & Mentor ▪ Time Management ▪ Winning Attitude

COMPUTER SKILLS

Raisers Edge ▪ Visual Source Safe 6.0 ▪ Crystal Reports 11 ▪ MS Office Suite ▪ Lotus Notes

PROFESSIONAL EXPERIENCE

PARTNERS HEALTHCARE, Boston, MA 2006-Present

Partner Healthcares is among the largest healthcare providers in New England.

Report Analyst

Provide Crystal Reports to all users, desktop support to over 150 employees in person and by Ticket System for Raisers Edge.

• Conduct formal and informal staff training related to reports, queries and exports inside Raisers Edge.

• Provide spec writing for all reports.

Selected Achievements:

• Integral part of 8-member project team performing multi-million dollar database conversion over 2-year cycle. Worked directly with project managers from 12 hospitals. Issued all reports; managed consultants’ reportage, wrote and approved all report specifications documents; trained all users no new system. Delivered 40 go-live reports within proscribed deadline.

• Planned, developed and led interactive skill-building software training on an individual and small group basis within classroom setting.

PROJECT BREAD, East Boston, MA 2005-2006

Project Bread is the state's leading hunger prevention organization, dedicated to alleviating, preventing, and ultimately ending hunger in Massachusetts.

Development Data Manager

Managed and maintained the integrity of data, including the upholding of data correctness; reconciled all donations and provided monthly reconciliation reports to CFO. Managed data office.

• Formulated queries and generated reports, including the creation of mailing lists, event reporting, donor lists and status reports.

• Trained new and exiting users with respect to data use, coding, understanding of the database structure, and developing and running of reports and queries.

Selected Achievements:

• Implemented Convio Fundraising software to better track donors and donations.

• Developed a new method for closing out the month; effort resulted in consistent balancing of budgets.

• Initiated and implemented “hand key” entry process by hired temporary employees to eliminate duplications and errors.

Page 1 of 2

KELLY KILMARCHUK ▪ 617-***-**** ▪ PAGE TWO

SUPREME COUNCIL, Lexington, MA 2003-2005

The Supreme Council is a fraternal organization dedicated to charitable works.

Database Management

Managed active database, created tracking system for current and past donors including foundations, groups and individuals.

• Designed, developed, implemented procedures and standards for donor database to ensure that data entry is consistent among users. Created custom queries to make sure integrity of information stored in database was accurate.

• Imported new donors, updated donor addresses, globally changed and updated donor information when needed. Managed and monitored the resolution of duplicate or incomplete records.

• Analyzed background information on individuals, foundations, corporations and constituencies for wealth analysis using information from Equifax.

• Carried out the migration of existing reports from Crystal Reports 8.5 to Crystal Reports 10. Developed new reports stored procedures, enhanced the existing reports stored procedures to improve speed and accuracy in Crystal Reports 10. Delivered reports via Internet using ASP, and Crystal Reports

• Provided outside company with all data on donors for annual appeals for mass mailings.

Selected Achievements:

• Eliminated entire data entry process by scanning all checks into system, prevented duplications and errors.

• Created and ran queries to produce donor and gift reports as required by the Director of Development.

• Created and managed donor and prospect list in Raiser’s Edge. Performed research and analysis of statewide donor prospects using research resources available through the Internet, databases and public records.

• Maintained two website using Java, HTLM, and ASP.

ROWENTA INC., Medford, MA 1999-2003

Rowenta designs upscale household and beauty appliances such as steam irons, vacuum cleaners and hair dryers.

Inventory Analyst

Managed ongoing inventory program, ensured security and accountability of inventory through documentation, process and procedure verification and system review. Conducted physical inventories and lead cycle counts. Analyzed and corrected cycle discrepancies.

• Audited container/air freight documents for all shipments from China, France, Italy, Germany and Mexico to assure quality and accuracy.

• Evaluated, developed, and enhanced credit policies related to the unsecured loan product line, including portfolio monitoring, policy recommendations and presentation to senior management.

• Analyzed, evaluated and established commercial customer credit worthiness.

Selected Achievements:

• Worked closely with entire sales team and developed successful strategies to maximize revenue and sales of inventory while protecting existing channels.

• Designed system enhancements that drive product performance and competitiveness. Conferred with in-house systems specialists and financial analysis to improve computer systems as they relate to credit processes.

EDUCATION

Worcester Polytechnic Institution, Worcester, MA

Client/Server Database Technology Certificate Program, 2000

University of Massachusetts at Lowell, Lowell, MA

Candidate for Bachelor of Science, Computer Science, projected graduation date, 2010

COMMUNITY INVOLVEMENT

Boy Scouts of America, Boston, MA

Create and design forms, flyers, and awards

References Available Upon Request

Contact this candidate