Business Analyst Resume

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