VBA Programmer & Access Db Designer

8/2007 - 4/2009

Liberty Mutual

Individual Contributor

• · Proven excellence in developing automation tools in VBA, for example in under 30 minutes, coded a solution that saved our Business Systems Analyst over 275 hours a year: Remittance Processing QA Project · Expertise in Access databases, operating outside the box, creatively exported millions of previously inaccessible records for management to make well-informed business decisions: Payment Database · Sought out cross functional project with Sales, Legal, Security, and Operations that saved $14,000+ per year in user effort, secured 25% higher rate of return, reduced "bad debt” by 20% for agents in arrears, and dropped outstanding monthly totals by 35%: Agent Commission Tracking · Chosen by Kaizen Team to streamline large scale Lean Six Sigma Black Belt project which succeeded in greatly reducing work load (75%), increased data integrity and retention, and contributed to annualized savings of $41,000 of an FTE: Manual Exceptions Check Writing Tool · Responsible for design, maintenance, and security of department Sharepoint Site—MOSS 2007

4/2006 - 8/2007

The Museum of Flight

Individual Contributor

• · Examined manual processes and devised automated solutions as part of the executive staff by creatively using PowerPoint's VBA coding modules to expedite production of monthly Board presentations, addressing online versus printed versions, allowing for single source editing, and expedited last minute changes · Met reaccreditation deadline by engineering a system to organize and track digital photos · Established clearer interoffice, phone, and general communications through studying and charting workflow, and successfully converting multiple and cumbersome spreadsheets into a searchable, single source database with user-friendly interfaces · Effectively harnessed Outlook coding modules to extract text from thousands of emails into Word files to promote organized tracking of correspondence, and data retrieval for CEO appearances

5/2005 - 4/2006

PEMCO

Contractor / Freelance

• · Efficiently designed and maintained Microsoft Access databases to thoroughly automate a system for tracking the impact of an action on the department and the business, with custom form for complex query criteria entry by the average user: Impact Analysis Database · Provided team with solutions to technical or application problems; trained employees · Combined capabilities of MS Project, Excel, and Access to build a method whereby managers could determine FTE's before, during and after a new release crunch period: Capacity Planning

1979

High School/GED Degree

Concordia Academy

• College Prep