Joel Embry
Bentonville, AR
Summary:
· Full software development life cycle (SDLC) – Gathering user requirements through ongoing application support
· VBA Programming – Access, Excel, Word, Outlook
· SQL Server
· C# - learning
· ASP 2
· Visual Basic 6
Education / Training / Certification:
Learning Tree
• C#, 2016
New Horizons Troy, MI 9/2000
• Crystal Reports - Advanced
Productivity Point International Troy, MI 11/98
• Microsoft Certified Solutions Developer certification training
• Visual Basic 6, SQL Server 7, Enterprise development
Productivity Point International Troy, MI 4/98
• Microsoft Certified Systems Engineer certification training (NT 4.0)
Davenport College of Business Grand Rapids, MI 8/83 – 6/86
• Associates of Business Administration
Professional Experience:
Leidos Oak Ridge, TN
8/2012 – 08/2016
VBA Programmer/Analyst
· Access 2007/2010, SQL Server 2008/2012
· 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
Community Partnership of Southern Arizona (CPSA), Tucson, AZ
4/2012 – 5/2012
Data analyst/Report writer
· SQL Server 2008, Excel 2007
· Data analysis
· Creating reports and stored procedures in SQL Server
Cott Beverages Bentonville, AR
1/2009 – 4/2012
Demand Planner
· VBA, Access 2003, Excel 2003, SQL Server 2000, Wal-Mart Retail Link system
· Data analysis, programmer/analyst
· Enhancing and maintaining current Access/Excel application which forecasts the demand for Cotts products in Wal-Mart 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
Wal-Mart/Sam’s Club Bentonville, AR
5/2008 – 1/2009
Programmer/Analyst
· VBA, Access 2003, Excel 2003, Word 2003
· 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