Systems/Business Analyst – Reporting Specialist 
10508 Bishops Gate Drive
Glen Allen, VA 23509 
15+ Years Business/Systems Analysis
12+ Years MS Access, Excel development experience with VBA.
6+ Years SQL Development experience
6+ Years MS SSRS Report Development
4+ Years SharePoint experience

August 2011 – Current (Contract)
Confidential
Richmond, VA
Business & Reporting Services Specialist
General Responsibilities: 
Provide advanced office automation and reporting services. Develop complex reports in MS Access and SSRS utilizing multiple data sources.
Dashboard development.
Database design and development.
SharePoint development.
Development tools: 
MS Office 2007 – Access, Excel and PowerPoint
MS SSRS
MS SQL

May 2011 – August 2011 (Contract)
Confidential
Richmond, VA 
BI Analyst
General Responsibilities:
SSIS Interface Development, SSRS Report Development, stored procedures and SQL queries. Responsible for scripts required to extract, transform, and move data and metadata to load into enterprise data warehouse, data marts, or operational data stores.
Development tools: 
MS SSRS
MS SSIS
MS SQL

Sept 2010 - April 2011 (Contract)
Performance Food Group (PFG)
Richmond, VA
Senior Reporting Analyst
General Responsibilities: 
SSRS Report design and development.
SharePoint Development
Development tools: 
MSAccess.
MS SSRS
MS SharePoint Services
SQL stored procedures, views and functions.
Experience using MS Excel for data analysis/validation and pivot tables.
Microsoft Visual Studio 2003/05.

May 2005 – June 2010
Confidential
Midlothian, VA
Business Analyst/Business Reporting Specialist 
General Responsibilities: 
Assess, plan, implement and evaluate information system support needs for business operations.
Perform Analysis Monitoring ensuring that the planned activities are performed well and the agreed deliverables are produced in line with the agreed schedule. 
Monitor and report on work performed to ensure that the business analysis effort produces the outcomes which meet stakeholder expectations and needs.
Responsible for system assessment and process analysis.
Identification of system requirements and process mapping.
Responsible for identifying and implementing information system solutions that support more efficient and effective work performance based on inherent knowledge of business functions and processes.
Application Development:
Development of numerous business applications including;
Financial Forecast Modeling,
Sales/ Purchasing/ and Inventory systems
Multiple Client Service applications and utilities.
Development tools: 
MSAccess experience. (10+ years)
SQL experience developing stored procedures, views and functions. (4+ years)
Experience using MS Excel for data analysis/validation and pivot tables. (10+ years)
Microsoft Visual Studio 2003/05. (4+ years)
MS Viso 2003 (schema development and process flow diagrams). (6+ Years)
Microsoft Reporting Services 2000/2005 (development of over 150 SSRS reports). (4+Years)
SQL Server Business Intelligence Development Studio. (1+ years)

March 2003 – March 2005 (Contract)
Confidential
Richmond, VA
Ciber - (Assignment: Capital One), Richmond, VA
Business Systems Analyst/Project Manager 
General Responsibilities: 
Account Management: Following SDM business methodologies, document/develop Business, Data, and Systems requirements for specific applications utilized by the Account Management LOB. Additionally, identify reporting requirements and develop needed detailed business requirements, business and processes, system interface, database logical modeling, and application design process through working with business and development teams.
DMC: MVS Budget Review project team. Responsibilities include the analysis of the DMC MVS chargeback model and the correlation to associated Solicitation Processing business functions. This included the documentation of the DMC 2003 chargeback process, exploring opportunities to reduce the MVS platform utilization, making recommendations to the chargeback process through Q4 2003 and developing SLA’s for various MVS processes. Phase one of the project completed successfully with our team accounting for a departmental savings of $14MM. Phase two of this project, “DMC Third Party Compliance”, included analysis and recommendations of existing file transfer processes to ensure compliance with CapOne regulatory and security standards. Significant saving have been realized through recommendation concerning; efficiencies in data encryption methods, enhancements to existing high-speed data networks, and reduction of tape utilization.

November 2000 – January 2003
Confidential
Richmond, VA
Systems Analyst Specialist 
General Responsibilities: 
This position provided technical consulting, project management and analytical expertise. Primary responsibilities included Systems Analysis and design for new Web based application development and maintenance of existing production applications. Formulated and defined system scope and objectives. Conducted system architecture and business information flow studies. Recommended best technologies to enhance current systems and appropriate computer platforms, workstations and communication information flow. Managed multiple projects.
Development tools: 
MS Project
MS Visio
Erwin
MS Access
SQL
Oracle
VB6
VB.Net
PowerBuilder

March 1999 – October 2000
Confidential
Minneapolis, MN
Senior Project Manager /Project Analyst 
General Responsibilities: 
As a senior PM Analyst, my responsibilities included the identification and management of business process improvement through re-engineering studies. Specifically, process modeling through workflow and use-case analysis. Managed discovery team responsible for Oracle Data Warehouse analysis and design. Additionally managed multiple Access/VB/PowerBuilder development, integration and conversion projects, and assisted with application design and implementation of Web/Browser based application development. I brought standardization to the project development team by helping to define and develop application development methodologies.
Development tools: 
MS Project,
ERwin,
Provision Workbench
Rational Rose

June 1997 - February 1999
Confidential
Minneapolis, MN
Project Manager (Principal Consultant) 
General Responsibilities: 
Senior Project Manager and Senior Business/Systems Analyst. Specific client engagements included:
GE Capital: Senior Business/Programmer Analyst, defining system requirements for a complex metrics gathering system that included interfaces to AS/400 and Mainframe. I was subsequently responsible for the design and development of the multi-user applications.
Land O’Lakes: Defined business user requirements for large scale feed mill plant processing system. This entailed the creation of detailed business use documents and business process profiles. The completion of this project produced documentation used to assist in final selection and preparation for the new application software.
3M: Project Manager to the GSDB (Good and Services Database) team. The GSDB project involved the design, development, conversion and deployment of a database that contained detailed information on more than 60,000 3M products. My direct responsibilities included the management of the application conversion and deployment. This also included the design and development of custom data conversion tools used during migration to the new system. (MS Access development)
Development tools: 
MS Access
Visual Basic 6.0
Erwin
MS Project (Keane PM methodologie)

January 1997 - June 1997
Confidential
Richmond, VA
Senior Systems Programmer Analyst 
General Responsibilities: 
Management of inter-agency application development staff with responsibilities including business process modeling, systems analysis and design and application development.
Development tools: 
MSAccess
Visual Basic

November 1995 - December 1996
Confidential
Restaurant Systems Division
Bethesda, MA
Project Manager - New Product Development 
General Responsibilities: 
Led product development teams; managed internal and external contract programmers. Responsible for new product development of Restaurant POS system; including business/systems analysis and design, process and data modeling, management of systems development, QA testing, documentation and systems conversion and interfaces.
Development tools: 
Windows NT
SQL Server 6.0
Powerbuilder
Basic
MS Access
MS Project
ERwin

January 1995 - November 1995
Confidential
Richmond, VA
Information Systems Manager 
General Responsibilities: 
Responsible for Information Systems management and development. Responsibilities included management of development team, system technicians and computer systems training department. The Business Systems management process included exploring existing and emerging technologies and finding ways to utilize or include these technologies into existing business systems. I was also responsible for the design, development and implementation of several automated systems used by our 32 remote locations. These systems significantly reduced response time and were able to provide valuable metrics used to dramatically increase service levels.

September 1991 - January 1995
Confidential
Richmond, VA 
Information Systems Manager 
General Responsibilities: 
Responsible for all business information systems. Managed all application development including CBT and communication network design. Major accomplishments included the design and development of an application used by corporate and franchise stores to manage all areas of restaurant business. This included the design and development of data retrieval interface with proprietary POS systems.
Development tools: 
MS Access

Details of prior professional experience available upon request

Confidential – Business Administration
Confidential – Systems Analyst Certification
Microsoft MOS Certification – MS Access
PMI Active member – (PMP Certification In progress)