SUMMARY:
- Expert at MS Access database development from concept to deployment
- Expert at MS Excel, including designing complex protected government forms
- MS Powerpoint, Sharepoint, Outlook, Word advanced functionality
- VBA customizations (task automation) for Excel, Word, Access, Outlook
- Windows and Exchange server network administration
- Complex business analysis, process improvement, data analysis and report writing
- Technical writing, proposals and training documentation
- Disaster preparedness planning and recovery testing
- Windows Network administration, Barracuda Backup, content filtering
- Sales and marketing including website editing
- IT training and user support
- Staff and project management
WORK EXPERIENCE:
Confidential
Business Analyst
Responsibilities:
- 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
Confidential
VP of Operations
Responsibilities:
- 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.
Confidential
Data Manager
Responsibilities:
- 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
Confidential
Assistant Network Admin
Responsibilities:
- 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
Confidential
Computer Systems Specialist
Responsibilities:
- 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
