PROFESSIONAL EXPERIENCE:

Confidential, Austin, Tx

Access/SQL/VBA

Responsibilities:

• I was called to come in and fix a bug that I found and resolved. I also removed orphan records from one table and archived off records from two tables on to sql server. This is an old client that I have worked for several times.

Confidential, Springfield, IL

Access/VBA/SQL

Responsibilities:

• This project required the conversion of 6 Access 2003 database to Access 2016 and move the data to SQL server. Created ODBC connections in Access to connect to SQL server. Created new Access db to manage new security for all dbs. Created user log to monitor QA progress, and wrote program to insert error trapping and error logging into all code modules.

Confidential, Austin, Tx

Excel/VBA

Responsibilities:

• This project required the automating Excel workbooks with vba for the procurement department. The projects required pulling data from Sharepoint, Peoplesoft, and other Excel workbooks. I had to create lots of formulas and security on worksheets.

Confidential, San Antonio, TX

Access/Excel/VBA

Responsibilities:

• This project was to help the Service Desk Back Office group create reports in Access and Excel. My first project was to automate the weekly reporting process that uses four Access dbs. I also have created several excel dashboards, one had 30 graphs all pulling from Access db. Worked on automating the daily reporting process.
• After acquiring access to a sql server I have converted most of the access queries to stored procedures.

Confidential, San Antonio, TX

Access/Excel/VBA

Responsibilities:

• This project was to help the Chief Risk Office track Risk Models. I created an Access database from scratch and imported several excel files. I created many forms and reports for input and output. I used VBA to scrub the importing excel data. I also created Excel reports that loaded data from the database with vba code.

Confidential, Austin, Tx

Access/SQL/VBA

Responsibilities:

• This project started about three years ago and I am still on call to fix and maintain this Access database. The original issue was performance and broken reports. I talked to IT manager and we agreed to split the db and store the data in a SQL server to increase performance.
• I also created automated processes to shorten down time of the migration. Recently I have created a VBscript to copy the thin client to their C drive each time they open the db, This make the db run even faster and has other advantages

Confidential, San Antonio, TX

Access/Excel/VBA

Responsibilities:

• This project was to help the bank oversite group improve and automate their data collection for monthly reporting.
• I created an Access Database to manage contracts. Created several automated Excel dashboards to pull data from database for monthly and quarterly reporting. I also help other analyst automate their excel dashboards.

Confidential (Contract - Confidential ) San Antonio, Tx

Access/SQL/Excel/VBA

Responsibilities:

• This project was for an insurance processing company they had data coming in from all over. I had to set up many Access and Excel filtering and scrubbing processes to collect the data. I created stored procedures to support my access and Excel applications. The application used VBA, odbc, adodb and windows dll calls.

Confidential, Austin, Tx

Access/SQL/VBA

Responsibilities:

• This project was for the code enforcement group, the person maintaining the Access db that collected all the code complaints retired and they needed someone to maintain it until they hired a permanent replacement.
• I updated the Access databases and converted Access database to Access frontend and Oracle backend with the use of ODBC. I created automated processes to shorten down time of the migration.
• Used Mailmerge with MSWord to Access to send out form letters.

Confidential, San Antonio, Tx

Excel/VBA

Responsibilities:

• This project was to help the reporting analyst automate their Excel reporting dashboards
• I automate excel spreadsheets using VBA and Macros. Pushed and pulled data from Excel, and SQL server using ADO. Created views and stored procedures for SQL servers to improve reporting.

Confidential, San Antonio, Tx

Excel/VBA

Responsibilities:

• Used VBA to consolidate hundreds of worksheets in one sheet for upload to database. Project two was to consolidate data from multiple workbooks to one sheet using VBA and Macros for monthly reporting.

Confidential, Austin, Tx

Access/Outlook

Responsibilities:

• Created an email reservation system for tennis and golf groups. I created Access database to send and receive emails, process players by sorts, groups and assigns placements. The program has a scheduler and emails all in unattended server mode. Used heavy VBA and Macros in Access and Outlook

Confidential, Austin, Tx

Access

Responsibilities:

• Created Access database to merge data from access into government forms, heavy use of VBA to open Word documents and insert data from Access

Confidential, Austin, Tx

Access

Responsibilities:

• Created Access database to manage company and employee phones, created complete database from scratch with tables, queries, forms, reports imports and exports, security, with VBA code.

Confidential, Shertz, Tx

Access/SQL Programmer

Responsibilities:

• Worked on Access ADP connected to SQL2000. Created and modified Tables, Views, Stored Procedures on SQL and created and modified all objects in Access.

Confidential, Austin, Tx

Excel Programmer

Responsibilities:

• Worked in contracts group to automate excel spreadsheets using VBA and Macros. Pulled data from Excel, SalesForce.com using ADO. Created Access databases to test Excel select statements and joins.

Confidential, Austin, Tx

MS Access/Excel Programmer

Responsibilities:

• Worked in reporting group to automate excel spreadsheets using VBA and Macros. Pushed and pulled data from Excel, Access, and SQL server using ADO, DAO, ODBC. Created Access databases to automate reporting processes. Created views and stored procedures for SQL servers to improve reporting.

Confidential, San Jose, CA

MS Access Programmer

Responsibilities:

• Create Hazardous Materials and BOM databases from scratch in support of building military
• Vehicles. Heavy use of VBA code was used in the designs. The designs were setup for multi-users in a client/data configuration. Also many types of imports and exports were used.

Confidential, San Jose, CA

MS Access Programmer

Responsibilities:

• This project requires merging two large and complex Access applications together. The two applications designed by several programmers at different times and have different programming styles. One of the designs is uses macros and the other use vba code. The designs are spread out to ten Access mdbs. Currently I am working to create one database on Oracle with one Access Client and one Access data load application.

Confidential, Seattle, WA

SQL Programmer

Responsibilities:

• Create SQL database and programming to drive Excel reporting.
• I first created the tables and indexes for the database then I created DTS packages for importing the data from an online system (LMS). Used stored procedures to clean and normalize data. I created views for the local data analyst to use for reporting. I also created user and administration documentation. Stored Procedures, views, DTS, Tables, SQL2000, SQL2005

Confidential

MS Access, SQL Programmer, VB, Excel

Responsibilities:

• Developed Databases for MS Access and SQL2K Databases in a Client/Server configuration, VBA, reports, analyze data, Imports, Exports, Conversions and Excel reports.
• This was an existing Access database with 10 users for tracking invoices. This was written by an entry-level person, needed to clean and normalized and I did. The performance was not fast enough for the users so I converted the Access database to a client/server application. Sql2000 was used as the database and Access as the client front-end using ODBC as the connection. I also had four data feeds each month and I created an application just to handle the monthly data imports. I also created user and administration documentation.

Confidential, Reno, NV

MS Access / SQL Programmer

Responsibilities:

• Developed new features for MS Access and SQL7/SQL2K Databases in a Client/Server configuration, heavy VBA, reports, analyze data. All records returned with pass-through or stored procedures.
• This was an existing player tracking system with an Access Client and a SQL server database. My main function was to create new features and modify old ones on the main application. I also created four promotion applications and six import applications and one kiosk application. These applications are production applications and are in use in 50+ casinos today. I also created application installs with Installshield for the department to install the applications.

Confidential, Dallas, TX

MS Access Programmer

Responsibilities:

• The job consisted of importing and converting data from their AS400 payroll system and creating transactions for their SAP/Oracle accounting system. Using Access I created the interface between the two systems. I created many queries to transform the data from the input side and ODBC link to the SAP/Oracle system to send the transactions. I also created forms to process the payroll records. This application was used on a weekly basis to process payroll records.

Confidential, Carrolton, TX

SQL DEV / MS Access /VB / Manager

Responsibilities:

• Working development manager, Design/Maintain MS Access databases in a Client/Server configuration. The job consisted of creating SQL and Access applications for the IT Dept. Recent work implementing Solomon on SQL server, Crystal Reports. Webmaster, created intranet for CSI using ASP, HTML, IIS, FrontPage, and administered web site. Created company CD using VB, Installshield, HTML, Acrobat.

Confidential, RICHARDSON, TX

MS Access Programmer

Responsibilities:

• Design/Maintain MS Access databases in a Client/Server configuration. The job consisted of creating a forecasting application for the Business Planning Dept. The application included mostly new design of tables, forms, reports, some redesign, and the creation of an installation program for the user application. Extensive use of VBA.