SKILLS:

• Full software development life cycle (SDLC)
• VBA programming - Access, Excel, Word, Outlook
• SQL Server
• C#
• ASP 2
• Visual Basic 6

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

VBA Programmer/Analyst

Environment: Access 2013, Excel 2013

Responsibilities:

• Full SDLC gathering user requirements through installation and support of production application
• VBA created Excel reports, import data routines from Excel into Access

Confidential, Oak Ridge, TN

VBA Programmer/Analyst

Environment: Access 2007/2010, SQL Server 2008/2012

Responsibilities:

• Work with users and management to gather requirements
• Design database schemas in Access and SQL Server
• Create stored procedures and views
• Code and test application

Confidential, Tucson, AZ

Data analyst/Report writer

Environment: SQL Server 2008, Excel 2007

Responsibilities:

• Data analysis
• Creating reports and stored procedures in SQL Server

Confidential, Bentonville, AR

Demand Planner

Environment: VBA, Access 2003, Excel 2003, SQL Server 2000, Confidential Retail Link system

Responsibilities:

• Data analysis, programmer/analyst
• Enhancing and maintaining current Access/Excel application which forecasts the demand for Cotts products in Confidential using VBA programming
• Analyzing current system and process in order to convert it to a SQL Server application. Access will be used for minimal front end
• Data analysis
• Converted 2003 Access and Excel applications to 2007 version

Confidential, Bentonville, AR

Programmer/Analyst

Environment: VBA, Access 2003, Excel 2003, Word 2003

Responsibilities:

• Design queries using Oracle's Business Intelligence tool
• Create reports, graphs and pivot tables to be presented in Excel and PowerPoint
• Rewrote and enhanced an Access application which dynamically creates a Word document according to a template.
• The document included graphs, tables and text that changed based on the underlying data