Database Administrator Resume
Chicago, IL
SUMMARY
Certified Microsoft Application Specialist (MCAS) / Analytical / Process Improvement-Oriented
Using my data management skills, saved the company $5,000 by eliminating the returned mail backlog that involved creating a process, working with the programmers to create a new screen field, and managing two employees.
ACCOMPLISHMENTS
Confidential,Chicago, IL (position was eliminated) 2008-2009
Database Administrator
- Brainstormed with our consultant, the vendor, and our team to devise five member types and 20
custom fields and preferences in our new internet-based database through YourMembership.com. - Successful reconciled 14 registrants’ payments that had been misallocated among multiple events.
- Addressed an average of six customer inquiries per day regarding passwords and event registrations.
- Discussed the results of a WebTrends (a web analytics tool) report regarding our web site.
- Managed the pre-collecting and post-collecting of registration fees to reduce account receivables
from an average of 22 to three unpaid fees per event.
Confidential,Upper Block Auction Clerk, Matteson, IL (part-time while a student) 2006-2007
Confidential,Sales Associate, Orland Park, IL (part-time) 2005-2006
Confidential,Chicago, IL (position was eliminated) 2004-2005
Sales/Marketing Database Specialist
- Became the team expert for the Applix and the Onyx CRM databases.
- Created a smooth process for and managed the event registration list using the CRM application and
SQL queries for this extended ERP solutions provider which had $800 million in annual revenue. - Saved the company $5,000 by eliminating the returned mail backlog that involved creating a process,
interfacing with the programmers for a new user interface field, and managing two employees. - Managed business leads for SSA Global and for their acquired Infinium company.
Confidential,Chicago, IL 1996-2004
IRI Service Bureau Report Analyst, 2003-2004
- Revamped our department’s intranet website using the TeamSite software and HTML so that it became helpful and more consistent with the other sites.
- For clients such as PepsiCo, translated their business required and then entered complex
geography, measure, time, and product dimension parameters accurately, ran the computer jobs,
and formatted the output in Microsoft® Excel®.
Category/Production Analyst, 2000-2003
- Meticulously maintained a product flat file and ran computer jobs to create databases.
- Analyzed the final OLAP database for data anomalies using a few measures.
- Achieved a 100% rating for on-time database delivery and accuracy for clients such as Dean Foods,
Hershey, and Johnson & Johnson.
Senior Help Desk Analyst, 1996-2000
- Improved our call tracking system’s data integrity by performing various data queries that I had
devised to locate problems. - Determined how to create Crystal Reports based on the call tracking data found in the Oracle tables
resulting in valuable manager-requested reports. - Taught groups how to use the Vantive (now owned by PeopleSoft) call tracking database.
Confidential,Evanston, IL 1988-1996
Information Systems Specialist, 1990-1996
- Maintained the division’s Microsoft Access report database and had queried it regularly to create
23 unique lists - one list for each report drop-off point. - Determined the cause of the inaccurate statements of account by researching the statement error lists.
- Improved a resource by creating a spreadsheet macro that entered the standard numbers, and then it
prompted me for each of the 56 regions’ own unique data.
Benefits Correspondent, 1988-1990
- Analyzed records showing full and partial payments, and showed 24 participants how the arrearage
total had been calculated. Resolved 38 participant inquiries regarding incorrect billing amounts that had been due to compensation changes. - Became a subject matter expert for the tax-deferred and the non tax-deferred accounts, and for the statements of account that involved shares in the diversified investment and special funds.
EDUCATION
BA Economics
