Saltzer - Business Analyst - New Cumberland, PA, USA

Matt Saltzer

New Cumberland, PA, USA


Business Analyst

Work History

Business Analyst

PA Dept of Education

November 2013 - June 2014

• Interview staff, review, edit and redesign inefficient business processes using a combination of methods and available technologies
• Document business rules, processes and procedures
• Manage projects, recommend system changes and technological solutions to business problems that fit within imposed rules, regulations and requirements
• Analyze, review and manipulate data via queries, reports, program and processes
• Develop user acceptance test scenarios, troubleshoot system problems

VP of Operations

Rolka Loube Saltzer Associates

April 2007 - May 2013

• Designed and managed Microsoft Access databases and cutting-edge Microsoft Excel forms and instructions for company revenue data collection and remittance for 6 state subsidy programs that collect and redistribute over $100M per year
• Analyzed data and designed complex monthly, quarterly and annual reports
• Managed the computer systems, including servers, software and hardware, logged and resolved first level issues
• Designed and managed IT strategic plans, system security, disaster recovery preparedness, contingency planning and semi-annual testing
• Trained and managed staff, conducted meetings and provided guidance and oversight to staff, interacted with state and federal government clients
• Reviewed government orders, consent decrees and statutes as they related to our business and implemented required changes to our systems and procedures
• Reviewed and managed the timely disbursement processing of ~$70 million/month
• Projected monthly, quarterly and annual revenues based on considerations from historical information, attrition and uncollectible accounts with a consideration of impacts of rule alterations and political climate changes
• Provided quality control review and supervision over external and internal operations
• Assisted in writing 20 to 90 page proposals for new business
• Analyzed data and created maps using X-Map and MapInfo geospacial software.

Data Manager

Rhoads & Sinon Group, LLC

July 2001 - April 2007

• Developed, maintained and managed data manipulation systems according to the program rules of federal and state subsidy programs, mostly in MS Access
• Designed & implemented complex Excel workbooks to gather and control data inputs
• Designed and managed security, backups and data access, controls and functionality
• Created complex graphs and flow charts to depict program rules and explain data, processes and time lines

Assistant Network Admin

Rhoads & Sinon LLP

October 1997 - July 2001

• Developed several Access databases
• Developed and published training and educational materials
• Provided technical computer related support to users for software and hardware issues
• Headed migration project for conversion from SoftSolutions document management and WordPerfect 5.1 to PcDocs/DocsOpen and Word 97
• Managed users on Banyan Vines and Windows 2000 network including security and other networking concerns/issues
• Trained new employees how to use computer system and various software packages
• Programmed extensive custom development of Microsoft office applications functionality to improve productivity and consistency
• Installed and tested new hardware and software

Computer Systems Specialist

Buchanan Ingersoll, P.C

April 1994 - September 1997

• Provided technical support, training, and troubleshooting to computer users
• Trained new employees to use telephone, voice mail, and computer software.
• Administered Novell Network
• Configured and installed new computers
• Developed time-saving macros and efficiency practices to benefit users
• Produced periodic Tips and Tricks sheets
• Coordinated two major and separate software upgrades and training programs
• Maintained computer network and telephone system
• Produced advanced projects as needed including drawings, figures, diagrams, and spreadsheets
• Infortext accounting system maintenance and reporting responsibilities

Qualifications & Certifications

Project Management Professional

Harrisburg Area Community College

Red Land High School

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Supported Countries
Choose your country