TECHNICAL SKILLS:

• Databases: SQL Server 2008 R2, MS Access 2013,2010, 2007, 2003, Microsoft
• Visio, Microsoft Project, GUI Windows Programming
• Languages: T-SQL, Access VBA 2003-2013, Excel VBA 2003-2013, VBScript, SQL, Visual Basic 6.0, Word VBA 2003-2013, Attachmate Reflections Scripting Language, PlanetPress - PressTalk language, Windows API
• Other Software: eRequester, Microsoft DYNAMICS Sage Accounting, PlanetPress,
• TIMS Inventory Management , Sharepoint, Lotus Notes
• Attachmate Reflections
• Operating Systems: Windows NT 4.0/2000, Windows 3.x/95, Windows XP
• Supporting technologies: ADO, OLEDB, HTML, XML, ODBC, and Visual Source Safe, COM
• Presstalk language

PROFESSIONAL EXPERIENCE:

Confidential

Senior Access Developer

• Create custom MS Access database applications for clients.
• Completed in MS Access 2013, an inspection reports database for ANO Arkansas Nuclear One power plant. This will house all data from plant-wide inspection reports.
• Added SQL Server stored procedures and batch processes for a construction company, and for a large concrete company added new features, forms, and reports to existing SQL Server database.
• Maintained other complex SQL Server based applications: created and modified stored procedures and views, designed new reports and functionality with SQL Server backend.

Technical Environment: MS Access 2013 VBA, SQL Server

Confidential

Developer / Business Analyst

• Leading medical equipment manufacturer. Initiated meetings with key stakeholders in three deparmtments: contracts, billing, and customer service to understand currently splintered processes surrounding the servicing of our capped contract rental customers. Worked with other BA's to formulate new business processes for this segment of the business.
• Phase I To re-calculate all neglected capped contract customer's monthly billing amounts. This enabled 14.5 million in billings that was bottlenecked.
• Phase II Develop a tool that all stakeholders can use to integrate their data updating efforts and automate the challenging re-calculation process. This process is occational and complex, and will never be included in their full ERP system.

Technical Environment: MS Access 2010 VBA, SQL. Visio, SharePoint

Confidential

Application Developer

• Modified and enhanced application for label machine, integrated through automation with MS Access and proprietary label software. Developed new label and application interface.
• Modified complex code that produces sin wave points for robotics operation file, to auto-punch holes in leather console for Rolls Royce automobiles. Used VB6 for application.
• Development of custom PO and purchasing system from requirements, for conveyor manufacturing company. Designed interface, coded, tested, and trained with finance department.

Technical Environment: MS Access 2013, Excel 2013 VBA, ADO, ODBC, VB 6.0,

SQL Server

Confidential

Systems Analyst

• Reverse-engineered numerous applications written in C and MS Access with a SQL Server back end for the purpose of determining and documenting their data sources.
• Assisted in JD Edwards ERP adoption effort in company-wide software implementation.
• Learned SQL data structure of financial applications eRequester for PO's and Microsoft Dynamics with SAGE.

Technical Environment: C , ADO, SQL Server 2008, MS Access 2010

Confidential

Application Developer

• Created application for the Risk - Vendor Audit Policy Procedure Analytics department. I collaborated with team members to create the SAR Tracker Suspicious Activity Reporting Tracking system that 50 personnel used for their primary job function in two cities. Teams tracked fraud cases, money laundering, and organized crime.
• Led and initiated numerous meetings and create database and application design with little direction. Worked iteratively with team leads to insure application met all their needs. Performed extensive tests to determine optimum data configuration, and built relationships with key personnel.
• Utilized MS Access 2010 VBA with ADO Data connections to server. Developed dynamic SQL Statements based on user chosen criteria for filtering. Trained a small team of other consultants to maintain the application.

Technical Environment: MS Access 2010/2007 VBA, MS Excel 2010/2007 VBA,

ADO Data transfer

Confidential

Application Developer Financial Analytics

• Created Billed Sales Margin comparison tool. This tool pulled data from our SQL server and presents it by segment by current day, week to date, period to date, quarter to date, and year to date. Compares previous year to current year. Developed numerous complex stored procedures, queries, and data interchange methods. System has 55 users, mostly Vice Presidents of sales and other sales executives throughout the country. Dashboard application in Access monitors use and provides reports. Extensive Excel VBA coding and advanced spreadsheet automation.
• Created Forecasting tool for supply chain operations. This tool is used by over 20 different warehouse managers for forecasting and also the analysts at headquarters who run monthly calls. This SQL and Excel based tool automates many previously manual operations, including the period to period 'advancing' of the spreadsheets. Also developed Access based dashboard application that enables reformatting or order and grouping of GL accounts. Upon opening the application, the spreadsheet re-forms to reflect the new schema if detected.
• Collaboratively worked with finance team to understand and pull data from SAP accounting system using SQL Server and ADO Connections inside MS Excel. Hired under Office Max Corporation, and was purchased by Office Depot at the time of contract end.
• Developed complex stored procedures using T-SQL, functions, triggers, and complex SQL statements with embedded queries to provide data sets to ADO calls from report. Optimized indexes for fast performance.

Technical Environment: SQL Server 2008 R2 Advanced stored procedures, functions, SQL query writing, MS Excel 2010/2007 VBA, MS Access 2010/2007 VBA, ADO Data transfer from SQL server to Excel and other advanced ADO data operations

Confidential

Database Developer at BP

• Worked with the contracts and procurement department, in cooperation with over 20 vendors, to develop a rental equipment management system. This system receives data weekly from contractors, consolidates the data, and reports on the data. I assisted the commercial manager and several contract managers in the coordination of many departments and personnel. Led meetings and conducted end user training for groups of contractors.
• For the central Project Cost Controls department, collaboratively designed and developed a cost management and accounting tool that integrated with SAP. Also developed several large Excel VBA Based dynamic reports for cost analysis. Tool was used by team to manage budgets, cost accounts, change management logs, and to produce monthly cost reports used by lead management team on the project. Trained personnel on use of system.
• Developed a data integration tool from COINS construction software, forecast numbers, and manually entered milestones to produce five key weekly mission-critical reports. Trained personnel on use of system.
• Developed daily manpower force reporting system for 12 contractors reporting in to major area of project. Automates excel spreadsheet tabulation for site-wide report of headcount. Implemented training of contractors.
• For the Project Information Management group PIM , performed Excel 2010 VBA scripting and automation for the Pillar Leads and for the BP Business Unit that requested metrics on progress of document handover project.
• Developed dynamic SQL Statements based on user-selected criteria for financial reporting form SAP SQL Server database. Utilized Excel 2010 VBA for spreadsheet automation.

Technical Environment: MS Access 2010/2007 VBA, MS Excel 2010/2007 VBA, SAP Accounting, Advanced windows ActiveX controls programming

Confidential

Application Programmer / Analyst

• Developed process automation applications for efficient processing of medical claim analysis within MS Access 2007, integrated with Attachmate Reflections scripting. This application saved the company hundreds of hours of manual processing
• Automated access of government medicare system and scraped results back into custom built application, processed results, and posted final data calculations.
• Automated the process of retrieving, reactivating, and scanning for medicare payments on all claims that were analyzed by Vaughan Holland Consulting.
• Setup and installed MS SQL Server 2008 from newly purchased server.
• Moved Managed Care database application from MS Access 2003 to SQL Server 2008 back end using migration tools, and SQL Scripts.
• Modified the Managed Care database to normalize table and field names and changed references throughout the entire system to reflect changes.
• Assisted owners and other Vaughan Holland personnel with various MS Access projects.

Technical Environment: MS Access 2010/2007/2003, VBA, API, SQL Server 2008, Attachmate Reflections Scripting

Confidential

Advanced Systems Analyst

• Three part role to perform feasibility, develop, and support applications for customers. Applications are all used for data transformation and processing to be used to populate variable data on forms printed through Pitney Bowes printer for use in commercial folder/inserter machines.
• Worked closely with Solutions Consultants from across the country to insure project feasibility, scope, and proper development of Statement of Work document.
• Worked to stay within scope of work all projects defined, and communicate with customers and internal sales partners when work became out of scope.
• Performed complex development using MS Access VBA, PressTalk, and VBScripts.
• Support and troubleshooting on complex customer problems across the nation.
• Traveled nationally to receive training, as well as to give training and support to customers. Was second level support and solved complex problems field System Engineers were unable to solve.

Technical Environment: MS Access 2003/2007, VBA, VBScript, API, PressTalk, PostScript

Confidential

VBA Programmer / Analyst

• Prospected, quoted, sold, and implemented numerous independent consulting projects.
• Created music lesson tracking database for instructors and students. It also tracked venues and created invoices and reports.
• Created commercial rental property application for major real estate corporation.
• Used both Access 2003 and Access 2007

Technical Environment: MS Access 2003/2007, VBA, API

Confidential

Application Programmer

• Gave leadership of the IT role in entire organization performed employee analysis and reviews, and salary discussion with staff employees.
• Provided project management for company-wide software implementation project called 'TIMS'. Worked directly with accounting, customer services, sales, management, operations and human resources for preparation and planning for implementation of software. Traveled to software company in Montana for proprietary training
• Designed and implemented software application for 'DSSI' third party electronic billing developed in MS Access 2003, integrated with legacy system for process automation.
• Created from scratch electronic billing application that interfaces with DSSI, a data clearing house to produce paperless invoicing.
• Oversaw network operations, processes and procedures. Managed technical staff to perform upgrades and new acquisition of equipment in organization. Aided in leveraging new technologies and products to aid in greater efficiency of various staff.

Technical Environment: MS Access 2003/2007, VBA, API, TIMS system

Confidential

Credit Development Team Lead

• Was appointed to leadership of new credit development team during transition of operations from Los Angeles to Chicago. Identified and initiated team training, coordinated with other managers, coordinated team activities.
• Aided in creating and forming new credit team. Determined and set task priorities and managed expectations of management.
• Assisted in orchestrating and completing complex month-end SQL Server DTS Package transaction processing procedure, for generation of critical corporate reports
• Modified and created new MS Access VBA code and functionality for several systems.
• Developed complex on-demand SQL queries to satisfy requirement of internal audits and SOX compliance on all databases.
• Learned 15 different Access database applications, with T-SQL transactions against SQL Server. Learned numerous complex business processes in niche Credit Insurance industry.
• Met with managers and business customers to identify and clarify problems and system needs and translated those needs into functional requirements and work orders.
• Using T-SQL, Developed and maintained complex SQL Server stored procedures and functions, and ran highly complex DTS Jobs in SQL Server 2005.

Technical Environment: SQL Server 2005, MS Access 2003, Visual Basic, VBA, API, ADO

Confidential

Database Application Developer / Analyst

• Created three MS Access applications two for finance department, one for marketing department. Integrated several data sources into database for reporting
• Assisted managers and staff in process engineering and determining scope and structure of system to suit their needs full life cycle development.
• Created systems and standards to organize data and information flow, as none existed previously. Trained all relevant personnel.

Technical Environment: MS Access 2003, VBA, MS Office Integration

Confidential

Database Application Developer / Analyst

• Modified existing quotes, sales orders, and invoice database. Created complex purchase order system for part and part assembly system

Technical Environment: MS Access 2002, VBA, SQL

Confidential

Independent Application Developer

• Created customer and route tracking system for ice cream vending company with over 35 VBA Coded forms for use in machine problem tracking, vending and account sales historical accounting information.
• Created initial contact database for start-up single product company, VBA Coding
• Small database projects for various small to medium sized companies

Technical Environment: MS Access 2003, VBA, SQL

Confidential

Programmer / Analyst

• Utilized SQL Server to create, modify and run assorted stored procedures.
• Created reporting application for tracking efficiency of deliveries using MS Access 2002
• Interfaced with AS400 data source through downloaded data, manipulated data in system
• Data scrubbing utilities and dynamic reports used by Customer Service Managers

Technical Environment: MS Access 2002, AS400, Various 3rd Party Utilities, SQL Server, Crystal Reports

Confidential

Web Developer / Data Analyst

• Maintained and altered front end web interface for Apply Yourself registration database for National University used in 14 cities, using XML code and supplied interface
• Handled data analysis requests, form modification requests, and communicated with national representatives and internal IT staff on progress
• Created Access 2002 database for data manipulation and scrubbing. Cleaned 60,000 records and normalized data structure, re-imported back into on-line database
• Utilized SQL Server to create, modify and run assorted stored procedures.

Technical Environment: XML, HTML, Access 2002, SQL Server

Confidential

Programmer / Analyst

Returned to work site to complete additional reports using Access 2000 report writer

• Added new features to insurance arbitration and claims database application

Technical Environment: Access 2000/2002 VBA, SQL, Windows 98 API

Confidential

Programmer / Analyst

• Developed data access utilities using Visual Basic 6.0 into a SQL Server 7.0 Database.
• Created routine to FTP data from mainframe, parse then insert into database tables on automated schedule then email users upon completion. Used VBScript and COM tools.
• Created commission reports on data using Crystal Reports 8.0 for commission calculations
• Utilized SQL Server to create, modify and run assorted stored procedures.

Technical Environment: VB 6.0, VBScript, AS400, COM, SQL Server 7, Crystal Reports 8.0, SQL Server

Confidential

Programmer / Analyst

Developed core database repository that stores many types of information on all insurance companies in the state of Kentucky. Used Access 2000 to create dynamic application. Used as mission-critical application by numerous employees for front line customer service. Developed 103 VBA forms and 56 dynamic, changeable reports for multiple departments.

Developed application for Kentucky Insurance Arbitration Association application to track an arbitration case through all phases of resolution, integrated in with reminder system.

Developed application for Kentucky Assigned Claims Plan. For handling specialized and complex insurance cases, tied with Lawyers and financials database using Access 2002.

Technical Environment: Access 2000/2002 VBA, SQL, Windows 98

Confidential

Programmer / Analyst

• Created massive bi-monthly mortgage and escrow database application, 83 complex VBA coded forms. Used as mission-critical system for all aspects of business, including front line customer service. Using SQL, Access 2000/2002 and VBA.
• Created system to track transactions due to be withdrawn from customer bank accounts, as well as transactions that need to be paid to banks. Uplink with bank system using COM.

Technical Environment: Access 2000/2002 VBA, SQL, Windows 98

Confidential

Programmer / Analyst

• Created an expense reports management system for use by all company employees that will allow all employees to create, submit, and review progress of their expense reports through being paid using Access 2000 VBA.
• Automated e-mail routing notification system for all supervisors and accounting personnel using Access 2000 VBA and Outlook object model VBA.
• Utilized advanced windows controls for graphical user interface in expense reports using Crystal 7.0 report writer
• Worked in team environment to assist in the upgrade and overhaul of two databases used for purchasing and employee time tracking using Access 2000 VBA.

Technical Environment: Access 2000/2002 VBA, Outlook VBA, SQL, Crystal Report 7.0

Confidential

Application Developer / Analyst

• Created project scope document and project plan, also worked with Vision and Project.
• Under direction and guidance of the Cabinet for Health and Human services and the Department of Maternal Health, created the KBSR Kentucky Birth Surveillance Registry system for tracking birth defects in children across the state. System will be used to disseminate data for national report. Used Access 2000 VBA
• Created import routines for various kinds of data which then were manipulated and normalized into tables for later reporting and tracking. Access 2000 VBA, Oracle 7
• Created flexible system for de-duplicating records, checking integrity of records, and over 35 data analysis processes which cleaned up the data for reporting using John Henry Data Tool.
• Created dynamic queries and filter-screens for viewing data in a number of perspectives, and reports using Access 2000 VBA

Technical Environment: Access 2000 VBA, SQL, Oracle 7, Windows 98, John Henry Tool

Microsoft Vision, Microsoft Project

Confidential

Application Developer

• Maintained and upgraded core data analysis tool UHC sells to University Hospitals for tracking physician pay, productivity, and effectiveness using Access 2000 VBA.
• Re-wrote over 60 reports, all dynamically created. Extensive use of complex advanced cross tab queries, multi-layered queries which processed many forms of data into cohesive report using SQL and Access 2000 VBA and VB 6.0
• Worked with automating graphs and charts in reports.

Technical Environment: Access 2000 VBA, VB 6.0, SQL

Confidential

Application Developer

• In cooperation with a team of three engineers, developed a database in MS Access 97 VBA to store, track, and report on the location of cell tower sites across the nation. Create customizable queries and forms to perform desired data query results.
• System used as mission-critical application to global support department for lookup of information. Also used VB 5.0.

Technical Environment: Access 97 VBA, VB 5.0, SQL

Confidential

Programmer / Analyst

• Worked on multiple projects simultaneously using Access 97 and Access 2.0. I maintained and updated existing applications from other developers, as well as created new solutions for business requirements in team-oriented environment.
• Developed three-tiered, distributed application using a VB 5.0 component delivered to 265 branch locations, an Access 97 application given to 14 divisional managers, and corporate reporting tool delivered to headquarters also in Access 97.
• Created automation process of collecting yearly branch capital expenditure reports in VB 5.0
• Worked in Crystal Reports 6.0 to create reports for various projects
• Worked closely with business analyst to determine needs and set course of action.

Technical Environment: VB 5.0, Access 2.0/97 VBA, SQL,

Confidential

Programmer / Analyst

• Started my own business doing programming and database development. Self-marketed and attained over 15 projects of varying lengths and complexity in the larger Kansas City area. Some of the project completed are listed below:
• Association management database for Robstan Group, Ltd
• Student Registration and course tracking system for continuing education department at the University of Missouri-Kansas City
• Human Resources and time tracking database for AT T regional headquarters
• Comprehensive marketing, customer information, production scheduling, shipping, and invoicing system for small manufacturing operation Panorama Cabana
• Parts order and entry system and inspection system database for Accent Sales and Service, overhead crane company
• Accident reporting system for nationwide school-bus leasing company School Services and Leasing, Inc.
• Charity golf tournament database for hospital system
• Cellular cite construction process database for Nextel
• Product order and customer tracking database for Visual Applications software company
• Parts tracking and assembly database for foundation pier manufacturing company Atlas Systems, Inc.

Technical Environment: VB 4.0/5.0, Access 2.0/95/97 VBA, SQL, SQL Server, Goldmine, Crystal Reports 3/4/5, VB6