SUMMARY:

• Programming and development. Business Analysis. Reporting and Information Automation using Microsoft (MS) Excel, MS Access, VBA, Macros and Visual Basic development., .Net, ASP, ASP.Net, VB.Net, C#, and other tools.
• Prefer areas of mission contribution. Target development areas: management, functional (marketing, production, finance), administrative, or technical.
• Focus on life - cycle development processes (or assigned components) to fit specific and global scopes.
• Effectively automate functional operations using advanced features of existing and new products.
• Apply heavy business and technical expertise to deliver concrete information tools.
• Provide full SDLC service, adaptable and tuned to varying business scenarios, sectors, and departments.
• Professional development of business software, -- MS Excel, MS Access (Includes macros and Visual Basic for Applications), ASP.net, C# and VB technologies.
• Fit all projects to organization goals, strategies, and resources. Set applications to the nature of the operating unit, organizational objectives, internal/external environmental effects, and resource limitations (including hardware).
• Effectively employ design methods for deadline completions.
• Projects typically are built with re-usable automation during delivery. New developments are documented, stabilized, and solidified.

TECHNICAL SKILLS:

Performed fast, accurate, automated and innovative tool development for various, complex business systems using modern corporate tools; MS Excel and MS Access, Visual Basic for Applications (VBA or macros) (also Visual Basic 5./6 and VB Script), .Net, ASP, ASP.Net, VB.Net, Java and C#. Integrated with a variety of back-end and associated technologies, such as SQL Server, Oracle, Python, SAP, proprietary and others - providing some development/operation within these tools. Provided conversions from prior versions and manufacturer tools. Provided start-to-finish SDLC components for projects. Managed other developers for full SDLC projects. Created integrations among MS Office tools, such as MS Access and Excel. Provided RAD and formally-delivered projects in part and entirely. Related technologies used include ADO, ADOX, ODBC, and others.

PROFESSIONAL EXPERIENCE:

Confidential, Lakewood, CO

Excel and Access Sr. Developer

Responsibilities:

• Developed and maintained a variety of tools using Excel and Access.

Confidential, Wheat Ridge, CO

Access Sr. Developer

Responsibilities:

• Added two major new components to this established software tool based on an Access front end and SQL Server back end.
• The Access portion called for expert development and integration with SQL Server utilizing Pass Through queries and calls to Stored Procedures.
• Development passed stringent testing and approval policies.
• Stored Procedures were updated for a variety of additions.

Confidential, Thornton, CO

Excel Sr. Developer

Responsibilities:

• Re-developing a configurator tool built in Excel for the company’s worldwide sales force.
• The tool utilizes Excel user forms in place of spreadsheet operations and provides a user friendly interface, replacing the need for engineering involvement for sales quoting for the company’s primary product line.

Confidential, Amarillo, TX

Sr. Developer and Administrator

Responsibilities:

• Developed a tool from ground up which converts major organization operations formerly handled by a large Excel workbook, into Access. Providing documentation, training and other implementation services.
• Majority of work is performed offsite using email, cloud and collaboration software.

Confidential, Daytona Beach, FL

Access and Excel Access Sr. Developer

Responsibilities:

• Re-created legacy tool originally built in Paradox, using Access 2013.
• The tool was built to record two major sets of data and several minor sets.
• Specific automations, reports and forms were re-created. Modern conveniences were added, including “click-out” to Web County and Confidential maps.
• Documentation is being provided in a 40-page document covering user and developer needs, as well as an operational video.
• Majority of work is performed offsite using email, cloud and collaboration software.

Confidential, Denver Area, CO

Access and Excel Access Sr. Developer and Administrator

Responsibilities:

• Repaired Sales Management tool (previously developed) issue; protecting critical data and restoring tool to normal operation.
• Consulted on potential move tool into cloud environment.
• Majority of work was performed offsite using email, cloud and collaboration software.

Confidential, Denver Area, CO

Access and Excel Access Sr. Developer and Administrator

Responsibilities:

• Administered and maintained 17 business critical automations built in VB.Net, Excel and Access including T-SQL interface for the accounts receivable division of Finance.
• Provided development modifications and upgrades as needed. Evaluated and provided recommendation for reverse engineering VB.Net into Excel/VBA, and built prototype.
• Also, consulted on utilizing other technologies to manage data and reporting requirements.

Confidential, Denver, CO

Access Sr. Developer and Administrator

Responsibilities:

• Performed migration for 8 Access databases to Office 2013 of which two were priorly developed below.
• Updated VBA code, functional objects, and performed comprehensive testing of each database.
• Interacted with functional area managers and users for overall success of the project.

Confidential, Aurora, CO

Excel and Access Sr. Developer

Responsibilities:

• Developed several expert Excel tools which included VBA coding, advanced Excel features, and advanced functions.
• Examples: An Excel tool which extracted data from Eroom, modified the data, extracted multiple metrics outputs for personnel resources, and provided decision flags.
• An automation from within MS Project (Excel VBA in Project VBA) outputting a formatted Excel report, providing task information for all workers.
• An Excel Peer Review tool modification which expanded functionality and corrected current development issues.
• Two tools which combined accounting and project data sources for managerial comparison; one in Excel and the other in Access; both utilizing advanced features and VBA.
• Prototype work on a dashboard system with multi-layer metrics outputs derived from a variety of data sources utilizing Excel/VBA.

Confidential, Denver, CO

Excel Sr. Developer

Responsibilities:

• Significantly enhanced two existing Microsoft Excel workbooks which required expert VBA developments requiring complex inter-worksheet and inter-workbook developments specific to the oil industry.
• Example enhancements included forms which contained selections affecting worksheets as well as text and graphical product configuration representations.
• Also, included was a stable transfer of data between workbooks.