Ms Access Sql Server Developer
Resume:
Carl F. Yos
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
Summary:
I am a Professional MS Access / SQL Server developer who offers his clients superior customer service. I use innovative development methods to rapidly produce secure, error free, user friendly, configurable applications that are designed to last well beyond the length of the contract and feature functionality not available from other developers. I guarantee that their data will be imported without errors including configurable business rules, that it will be stored securely and without corruption, that the data in all exports will be accurate, and that all calculations will be mathematically correct. If it is determined that there are errors in my code or the application does not meet or exceed the specifications of the contract, I will return at my own expense to correct those issues.
Recent Projects:
Tuesday Morning – An MS Access / SQL Server warehouse reporting tool prototype that proved to be so successful that I was converted from contract to permanent employee to support it. Introduced the use of a timer form providing warehouse managers with hourly data updates not available to them before.
Nesco – An MS Access application with an interface in 4 languages using Metric and Standard American weights and measures providing a universal reports across the company’s domestic and international locations for the first time.
CEI Group – An MS Access tool to export and import Access objects as text files for use with third party file archiving software. Considered impossible by the rest of the Agile team.
G6 Hospitality– An MS Access bonus calculator and bonus report distribution tool for use in the back and forth process of bonus determination. It reduced a manual 4 day process to 10 minutes.
Insource Group – A configurable MS Access / SQL Server solution bringing all aspects of the management for offsite construction contracts under one roof.
Goodman Networks – VB.Net application to convert engineering documents from one format to another in Excel at the rate of 350 per hour. The client used the application for 5 years after it went into production.
Technologies:
Microsoft Office Suite (Access, Word, Excel, Power Point, Outlook) all versions Visio Windows 98 through Windows 10 SQL Server 7.0 through 2014 SQL T-SQL VB.NET 2003 through Visual Studio 2017 SQL Server Management Studio - SSMS SQL Plus Toad SharePoint PHP HTML MS Project Visual Source Safe – VSS
Professional Experience:
Tuesday Morning July 2016 – 2017
Programmer Analyst
Tuesday Morning converted my contract position to a permanent position with their company
Continue the development of SCOA an MS Access / SQL Server application reporting on the movement of product and related metrics.
oAdditional reports to allow managers to monitor the production of processed goods and product allocation to the stores. The data is updated on an hourly and the updates are monitored by a timer form in the frontend.
Support and additional development for the DC Portal an in house legacy intranet website utilizing Windows 7, an Apache webserver, PHP, and MS Access for the management of the warehouses and vendor activity.
Support for CGI a third party application utilizing several Excel workbooks containing extensive macros that interface with a SQL Server backend. It is used in the forecasting process.
Other projects as assigned.
Technologies: Access, SQL Server 2012,VBA, Visio, Excel, Apache, PHP, HTML, CSS, JAVA
SDI Logic: client Tuesday Morning, May 2016 – July 2016
Senior MS Access Developer
Design a SQL Server database and design and build an Access reporting engine to consume the SQL Server data. The reporting engine houses 5 reports tracking product movement from warehouse to store sales.
oDesign the two systems.
oProvide forms for
Data entry
Report criteria selection
Report preview
oThe ability to export formatted Excel reports
oSecurity to manage user access
Other projects as assigned.
Technologies: Access, SQL Server 2012,VBA, Visio, Excel
Carl F. Yos Page 2 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
Nesco Resources: client Sachem Inc., October 2015 – January 2016
Senior MS Access Developer
Update a data entry and reporting Access application used to track production in a chemical plant.
oClean up and debug current version
oAdd multilingual functionality
oRefine time capture
oImplement security
oConfigure to use as a universal reporting tool to assist in standardizing reporting across locations in the USA, Netherlands, Japan, and China
Other projects as assigned.
Technologies: Access, VBA, Visio, Excel
The CEI Group: client Intelligent Medical Objects, Inc., March 2015 – August 2015
Senior MS Access Developer
14 Access tools connected to an Oracle backend database.
oDebug the tools
oAddress a number of help desk tickets and requested enhancements for the tools
oDevelop a set of standard modules and forms to use across the tools and implement them
oDevelop a tool to export database objects as text files, update databases with the text files, and build databases from the text files for use in their Perforce source code library.
Other projects as assigned.
Technologies: Access, VBA, Visio, Excel
G6 Hospitality, November 2014 – February 2015
Access Excel Developer
Building an Access application to automate the generation of the annual bonus reports. These are Excel based reports. The application will collect the required, calculate the bonuses, and generate a series of canned reports. An interface for Ad-Hoc reports will also be provided.
Technologies: Access, VBA, Visio, Excel
LTS Solutions: client Hudson-Advisors, November2013 – July2014
SQL Server/Access Developer
Worked with the IT department to research, evaluate, and implement user and database management requests to rectify issues and add new functionality to their Asset Management System or AMS application which they use to manage their multi-billion dollar real estate section of their US division.
oThe application is a complied copy of an Access database running on a terminal server in Woking, Ireland used as a frontend for an instance of SQL Server running on server in Frankfurt, Germany currently containing 24 databases in the production version.
The production frontend contained 450+ forms, 2650+ queries, and 450,000+ lines of VBA code.
My development work was done on a virtual machine running on a server first in Frankfurt and then Woking.
oI did most of my work in SQL Server using SSMS. I wrote scripts to create and alter tables, views, stored procedures, functions, SQL agent jobs, the permissions on those objects, and the data they contained.
oIn Access I reviewed and corrected the functionality of forms, queries, and VBA code. I added additional forms, queries, and VBA code. I was asked to troubleshoot and correct some features of the administrative database they had developed.
Technologies: Access, VBA, SQL Server, Visio, Excel, Power Point, Word, Microsoft Enterprise Manager for SQL Server, Visual Source Safe, SharePoint.
Carl F. Yos Page 3 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
InSource Group: client NEC, August 2012 – September 2013
Access /SQL Server Developer and dba
Developed and maintained an Access / SQL Server application to replace the numerous spreadsheets used to manage and track the installation and upgrade projects of electronic equipment in 7/11 stores across the country. The application generated canned and ad hoc reports that were exported to Excel and Power Point that were unavailable from the previous spreadsheet system.
oTo insure the requested level of security, the Access frontend was divided into 5 separate databases. A 2007 and 2010 versions of each database were maintained. The Access databases did not hold local data. They were used solely as containers for forms and VBA code. The access to the SQL Server database was through ADO and limited to stored procedures, views, and user defined functions. Users were added to SQL Server security roles to control their access.
oThe SQL Server database system consisted of a development, testing, and backup databases. Separate production databases were added for each field contract. Each database contained tables, views, stored procedures, user defined functions, and security roles.
A series of scripts run through Microsoft Enterprise Manager were used to facilitate maintenance of the databases and moving structures and data between the SQL Server databases.
An Access / SQL Server application to track and record all changes in data and application structure on an external hard drive was designed but development was not completed and it was never implemented.
A universal application that could be configured by non-developers for similar anticipated contracts in the future was discussed but never developed or implemented.
Technologies: Access, VBA, SQL Server, Visio, Excel, Power Point, Word, SSMS
TechniSource: client MedAssets, April 2012 – August 2012
Access Developer with strong T-SQL
Working with a team refactoring a series of 12 Access databases used in the management of client accounts to use a new SQL Server data source.
Wrote numerous Access and SQL Server objects.
Wrote Access database to read, display, and parse random access text files of more than 2 Gig in size so the data could be repackaged and imported into SQL Server.
Technologies: Access, VBA, VB.Net, SQL Server, SSMS, VB 6.0, VB Script
The Veredus Corp: client PKM/FIS/FDIC, February 2012 – March 2012
Access/Excel/VBA/SQL Server/Adobe Developer
I ran complex reporting system utilizing SQL Server, Access, Excel, and extensive use of the SQL Server Management Studio.
Technologies: Access, Excel, VBA, SQL Server, Adobe, and a custom frontend for a DB2 database
The Robert Half Technologies: client Compass Well Services, January 2012 – January 2012
Excel/Word/VBA Developer
Developed a VBA macro in an Excel workbook to generate a complex formatted Word document based on data in the Excel workbook and other predefined criteria.
Technologies: Excel 2010, VBA, Word
The InSource Group: client Pioneer Well Services, November 2011 – December 2011
VB.net / Access /Excel/VBA Developer
Developed several versions of an application in Access, VB.net, and Excel to aid in planning activities of a well service company on an annual basis
Technologies: Access2010, VB.net, Excel, VBA, SQL
Carl F. Yos Page 4 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
Robert Half Technologies: client Rotobrush, November 2011 – November 2011
Access Database Developer
The project was to expand a simple Access 2010 database to include a custom export function to provide a dataset to import into SQL Server using code that was as basic as possible.
Technologies: Access2010, Excel, VBA, SQL
Goodman networks, March 2010 – October2011
Operations Support Specialist
Project Management Operations North Texas Area
oDeveloped a suite of VB.Net tools to read and transfer data between Access, Excel, SQL Server, SQL Server Compact, and XML.
oADI Interface VB.Net – A Visual Basic 2010 Dot Net application to read BOM (Bill of Materials) documents and generate reports for customers. The application used a modified version of Click Once to allow for installation and updating from the company SharePoint.
oRFDS Converter – A Visual Basic 2010 Dot Net application to convert RFDS design documents to an AT&T format to comply with customer requirements.
Project Management Operations Department
oMBR Report Generator - An Access 2007 application to gather and report on the progress of construction projects based on units of work called milestones.
o WIB (Wizard in a Box) - Temporarily assumed leadership of a group of young developers to assist them in migrating an Access 2007 database already in use nationwide to SQL Server.
Accounting Department
oAgeAndHold Report Generator – An Access 2007 application to report accounts receivable metrics gathered from Oracle Discover and other data sources for national and area management. The reports were read by the CEO and managers nationwide.
oBonus Metric Report - An Access 2007 application to report on managers performance and calculate managerial bonuses. It gathered data from a variety of sources and generate a complex, multi-tab Excel report.
oMonthly Operating Results VB.NET – A Visual Basic 2010 application to report on actual production compared to the annual estimates. It combined the Bonus Metric Report data with 18 other imports to generate an 11 tab workbook displaying actual work progress compared to the annual budget projections.
Project Controls Department
oProject Control Tracker Dataset - An Access 2007 application to extract the data from the 411 Excel workbooks in 140 formats and merge the data into a single comprehensive Excel report, Access tables for web data, and for use in migrating to SQL Server 2008.
Technologies: Access2007/2010, Word, Excel, VBA, SQL, Outlook, SQL Server 2008, SQL Server Compact, Transact – SQL, Visual Studio 2010, Visual Basic 2010, SharePoint
Comforce: client Crump Insurance, September 2009 – December 2009
Access Database/Word/Outlook Developer
The project was to design and build an application to allow the users to create a multipage Word document in 23 sections for use in defining insurance coverage for large business. The application provided a real time view of the document as it was created. The application collected and verified information for all sections. Documents could be saved, recovered, and edited. The output was a Word document or alternatively as an attachment to an email.
Access 2003 later upgraded to 2007 was chosen as the platform.
Technologies: Access2003/2007, Word, Excel, VBA, SQL, Outlook
Buchanan: client Bell Helicopter, July 2009 – September 2009
Access Database Developer
The project was to reverse engineer three related Access databases and rewrite them as a single Oracle database with a .Net wrapper
Developed an Access database to read the metadata from 380 selected tables and queries in the access tables and write SQL scripts for generating the corresponding Oracle objects and populating them with data.
Technologies: Access2003, Word, Excel, VBA, SQL, ODBC, Outlook, SQL Plus, Oracle 9.0
Carl F. Yos Page 5 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
TekSystems: client LaQuinta Headquarters Irving, TX, September, 2008 – May, 2009
VBA Developer
Develop VBA engine using Excel and User Forms to automate the generation of update Excel workbooks sent to Pegasus. The workbook generator automates 42 data service tasks in 10 workbooks containing 32 worksheets.
Application was designed and tested in Mercury Test and Enterprise Architect.
Technologies: Access2003, Word, Excel, VBA, SQL, Outlook, and Visio 2002
PSI-ProTech Solutions, Inc: client Thomson – Reuter Fort Worth TX, June, 2008 – September, 2008
Access Database Developer
Worked help desk tickets
Repaired and improved invoice and packing slip printing applications.
Created two Access applications to run separate Oracle pass through queries based on user criteria and export the results as formatted Excel spreadsheets.
Repaired and enhanced a VB6 application to generate PLD files for billing.
Worked a number of other help desk tickets requiring major and minor repairs to Access and VB6 applications.
Assisted help desk personnel and other IT personnel in understanding and manipulating ODBC and linked Access tables in a network environment
Technologies: Access2003, Word, Excel, VBA, SQL, ODBC, Outlook, and VB6
Cap Gemini: client TXU Revenue Management, January 2007 – June 2008
Revenue Management Specialist
Access Database Developer, Analyst, Reporting.
Designed and developed a series of databases to improve productivity and accuracy in the billing process.
Assisted co-workers with their query building and coding projects
Contributed to the development of a SQL Server project to calculate the most complex bills for the 50 largest accounts
Developed several database applications to read and generate Excel workbooks on demand.
Technologies: Access2003, Word, Excel, Visio, VBA, SQL, ODBC, Outlook, and Lotus Notes
Resulte’: client: Texas Pacific Securities, August 2006 – January 2007
Consultant, Access Developer
The project was to create an Access application to calculate and store management salaries and bonuses.
Security concerns prevented me from using the actual data or data structure. Instead I was asked to create a database where the users could create their own data objects, the relationships between them, and define complex reports based on the data. Based on a large and complex set of criteria
The database in a database model and the requirement of a 3rd degree normalized data structure resulted in the largest single database that I have created before or since. It contained more than 25,000 lines of VBA code and numerous other objects.
Technologies: Access2003, Word, Excel, Visio, VBA, SQL, ODBC, and Outlook
CY Databases, client: J-Quad, January 2005 – July 2006
Consultant, Access Senior Developer
Expanded and improved the functionality of HUD CFF 2.6.mdb an Access 2003 application used in the determination of capitol funding for public housing authorities across the country to include more functionality as part of an extended development contract with HUD, the department of Housing and Urban Development, Capitol fund division.
CY_DBdocument2K.mdb an Access 2003 database utilizing Access documenter files to document any database and provide enhanced display and search functions. Used to speed development.
CompareDatabases.mdb a database used to compare any two tables in any two Access databases in a variety of ways
Technologies: Access2003, Word, Excel, Power Point, Visio, VBA, Visual Source Safe, SQL, ODBC, and Outlook
Carl F. Yos Page 6 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
YOH IT, client: Michaels, September 2005 – December 2005
Consultant, Access Lead Developer
Developed an automated secure multi-user reporting Access 97 database reporting system. Windows scheduler was used to call the database and it generated a series of canned reports in Access, Word, and Adobe.
Providing Sales and Inventory daily statistics on products (SKUs) sold in their stores for sales reports and sales campaign reporting and planning.
Including auto email and AS/400 updates to the reporting system.
Technologies: Access97, Word, Excel, Power Point, Visio, VBA, VB.NET. SQL, ODBC, and Outlook
CY Databases, December 2004 – August 2005
Independent Consultant - Access Lead Developer
Wrote CYDatabases.com the company website for CY Databases using FrontPage.
Installed and configured a client/server network for the development and testing of multi-user networked applications using Windows 2000 Server and Active Directory.
Password Vault a simple secure database to create and store passwords.
Released as shareware on CD or downloaded from CYDatabases.com
PID Generator a stand alone version of the password generator from Password Vault.
Technologies: FrontPage 2003, Windows 2000, XP, Windows 2000 Server, Access XP, VB. NET
Pace Consulting, client: Atlas -Copco Drilling Solutions Garland, August 2003-November 2004
Database Developer/Programmer
Database to remotely monitor, manage, and manipulate the 280 active Access databases on their network.
Introduced automation to leverage existing monthly processes to provide daily real time data. The data was used by all departments.
Introduced “Transparent Security” a security method that does not require the user to enter a password.
Developed a daily log adopted by IT and several other departments.
Rewrote and improved existing Help Desk software. Evaluated new Help Desk software. Ran help desk tickets on all technical levels
Developed automation to produce monthly accounting reports, to email 154 managers their respective reports, and to post the reports in a secure network database. The 40 minute automated process replaced a 12 hour manual process.
Developed a secure database to record and manage engineering change requests and the response to those requests. Developed Power Point training presentation and conducted training classes. Production down time was reduced and departmental accountability increased.
Automated and improved existing processes to rate parts for re-ordering and to rate vendor performance. Saved 4 million dollars through better inventory control and vendor management the first year of use.
Application to print barcode bin and part labels on demand or from a list.
Application to replace paper process for exceptional part requisition requests. Developed Power Point training presentation and conducted training classes.
Upgraded production problem reporting database system to true multi-user functionality. And other improvements as requested.
Updated employee performance database system. Added an archiving function and the ability to transfer employee records from one departmental database to another as well as other minor improvements.
Technologies: Access97, Word, Excel, Power Point, Visio, VBA, VB. NET. SQL, ODBC, and Lotus Notes
Carl F. Yos Page 7 of 7
Email: ****@***********.*** Cell: 972-***-****
Grand Prairie, TX 75052
MS Access - SQL Server - Office Automation
Argus Group, June 2000-July 2003
Database Developer/Programmer
NRD/SunTec
Life Cycle Asset Management System© A copyrighted system modeling the complete business flow for a computer refurbishing and disposal warehouse.
Set up a Windows 2000 server and installed SQL Server 7.0. Ported the Life Cycle Asset Management System© to SQL Server 7.0 with a several task specific VB.net front ends. Developed a middle tier utilizing views and stored procedures to control access. Used cursors, triggers, and transaction processing to increase the efficiency of the system.
Developed a series of secure interactive databases for customers to access their data over the internet and to make service requests. Utilized Access XP for the data and ASP.net to display the data.
Technologies: Access97/2000/XP, SQL Server, Visual Source Safe, Word, Excel, Power Point, Visio, VBA, VB. NET. SQL, ODBC, Windows 2000, XP, Windows 2000 Server
Guaranty Bank Dallas
Access 2000, Visio, ASP
Developed an ad hoc reporting application for the internal help desk that allowed the users to define reports and save criteria for later use.
Used to provide data for employee incentive program.
Used to define requested improvements to the main Oracle call tracking system
Argus Group Headquarters
Access 2000
Improved and debugged Argus Group’s own HR database. Coached staff on query building and other basic database operations.
IBM/ Frito-Lay Headquarters
Pendragon Forms, Access 97
Senior member of the Back Office Team.
Senior member of the DAAS Import team.
Senior member of the Security team.
Member of the SQL transition team.
Expanded and improved Access database for tracking leased IT assets, lease contracts, and technician service and installation work orders nationwide.
Developed an online work order form for IT techs nationwide utilizing the Symbol 1700 PDA. Reduced the response time from 3 days to one. Reduced management requirements by 8 staff members.
Technologies: Access97/2000/XP, Word, Excel, Power Point, Visio, VBA, SQL, ODBC, Windows 2000, XP
Contact this candidate