Objective:

A challenging programming position with a progressive organization that provides opportunities to utilize my extensive experience in VBA, MS Access, Excel, PowerPoint, SQL Server 2008 and C .

Technical Skills:

• MS Access 97 / 2010 10 years
• VBA 10 years
• MS Excel 2003 / 2010 10 years
• filePro Plus Programming 18 years
• SQL 10 years
• T-SQL 3 years
• SQL Server 2008 3 years
• Visual Studio 3 years
• C LINQ and Lambda 0.75 years
• VB.NET 2 years
• Salesforce.com Manage tasks/cases, client communication and billing hours
• PL/SQL experience 0.5 years
• Toad Tool for Oracle Application Developers 0.5 years
• ETL Extract, Transform and Load 20 years
• SCO UNIX 18 years
• HP-UNIX 3 years
• UNIX Shell Scripting 18 years
• Windows XP / NT 10 years

Operating Systems:

• UNIX: HP-UX and SCO-UNIX
• Windows: '95 thru Windows 7 and NT.

Networking:

TCP-IP, Ethernet hubs, NFS, BW-NFS, FTP, Telnet, Network Terminal Servers, modems and routers wired and wireless

Employment History

Featured Work Experience:

Confidential

Position: MS Access / MS Excel / MS PowerPoint / VBA / SQL Developer

• Assurant Quality Control had many manual processes which are very time consuming to their staff. I documented these manual processes and created automated processes to replace these tedious tasks. Specifically, they had PowerPoint presentations that they updated manually each month.
• Created a push-button MS Access application, utilizing VBA code. This application mines the MS Access data, creates multiple Excel files with Excel Charts and exports these charts into a PowerPoint presentation. It also inserts a raw data Excel file into the PowerPoint presentation as an object. These presentations can be created for an unlimited number of clients Banks and Mortgage Companies .
• Project Management: I was the only software developer working on this project. My Assurant Manager gave me task of producing the Excel files and PowerPoint Presentation on a monthly basis. It was up to me to figure out how to automate the manual process. Therefore, I basically managed the project myself.
• Results: Assurant management and staff are extremely happy with my work ethic and attention to detail. I saved them an enormous amount of time and money.

Confidential

Position: Report Developer SQL Server 2008 / MS Excel / VBA / C / LINQ / Lambda

• Create reports for new Affordable Care Act Exchange clients. Convert existing reports from Excel 2003 to 2010 format. Convert VBA SQL and Opal scripts into C scripts using LINQ and Lambda expressions.
• Project Management: There was one senior software developer above me. He trained me and I trained the junior software developer below me. Therefore, Peter and I shared project management duties.
• Results: TRX/Concur is now compliant with ACA reporting regulations and guidelines. They can now market their data analysis and reporting services to other Health Insurance Plan Providers.

Confidential

Position: MS Access / MS Excel / VBA / MS Word documents Word Forms

• ETL Projects Extract data from CDC Awardee word forms. Transform that data into Excel worksheets. Load the Excel data into MS Access database Tables. Create MS Access Forms, Query and Reports to display this data in meaningful ways to Deloitte and the CDC.
• Project Management: I was the only software developer working on this project. My Deloitte supervisor gave me her net results verbally and I had to figure out how to get from point A to point B, without any assistance from anyone else. Therefore, I basically managed the project myself.
• Results: Create two MS Access database one for DPIP Awardee data and one for EHDI Awardee data.

Confidential

Position: MS Access / MS Excel / VBA / XML / SQL Developer

• Convert a 2003 Access database to a 2010 Access database. Modify VBA processing where necessary.
• Convert 2003 Excel files to 2010 Excel files. Modify VBA processing where necessary. Create SQL Server 2008 Views. Enhance Excel processing by adding a Customized Ribbon using XML code.
• Results: Upgraded MS Office user applications and reporting tools from 2003 to 2010.

Confidential

Position: MS Access / MS Excel / VBA / SQL Developer

• Developed and maintained several Access databases using an ODBC link to the main CMS Oracle database using VBA Visual Basic for Applications . Analyzed and identified data and metadata for data mining in Oracle database using Toad Tool for Oracle Application Developers . Document database designs, relationships and objects. Created ETL scripts in Oracle PL/SQL for various report outputs CSV, Excel, MS Access .
• Results: Team SpecPro has many manual procedures / processes for creating and maintaining ETL Report Outputs . I am tasked with streamlining and automating these manual processes along with revamping and improving VBA code and SQL queries.

Confidential

Position: MS Access / MS Excel / VBA / SQL Developer

• The Airport Customer Service department Finance wishes to automate their data preparation. Currently, they manually process this data in Excel spreadsheets prior to uploading it to SAP / Clarity. We're creating an MS Access database to streamline this process and improve data consistency and accuracy.
• Project Management: I was the only software developer working on this project. My Delta General Manager gave me his net results verbally and on a whiteboard and I had to figure out how to get from point A to point B, without any assistance from anyone else. Therefore, I basically managed the project myself.
• Results: Consistency of data manipulation and accuracy is the main benefit. A significant decrease in preparation time is a secondary benefit.

Confidential

Position: MS Access / VB.NET / SQL Server 2005 / filePro Developer

• Supported, maintained, rewrote and created new MS Access, VBA, VB.NET and filePro applications on both UNIX and Windows environments for The Georgia Department of Revenue's Compliance Division.
• Results: DOR was able maintain their Compliance Systems which generated revenue for the while they transitioned to two new systems: ITS Integrated Tax System by FAST Enterprises and Data Warehouse by RSI.
• Created 3100 Report Database in MS Access 2003
• Results: Vastly reduced the time necessary to research and assign unallocated payments.
• Created Private Collection Agencies PCA Database in VB.NET
• Results: Saved DOR thousands of dollars in interest payments to PCA's.
• Created E-Services Production Database in VB.NET
• Results: Allowed Management to monitor production of E-Services Department
• Created Use Tax Database in MS Access 2003
• Results: The application was used to collect over 1 million.
• Maintained and rewrote parts of Compliance Delinquent Report CDR processing Sales Tax and the Individual Income Tax System IITS in filePro.
• Results: Allowed Agents and call center personnel to research and compare Federal and State Income Tax Returns for ALL taxpayers.

Confidential

Position: filePro / MS Access / MS Excel / VBA Developer

• Designed the Automated Calling System for The Colography Group in a SCO-UNIX environment using filePro. ACS allowed our call center to ask complex surveys and retrieve the answers in real-time. The survey questions are displayed on the same screen where the caller enters the respondent data. Prior to my arrival at CGI these surveys were done on paper and then manually entered. The ACS system has greatly increased the productivity of the call center and accuracy of the respondent data.
• Created new MS Access 2003 databases for client-driven applications, as well as in-house applications at CGI. Proficient at creating switchboards, tables, queries, forms, reports, macros and modules in either Access 97 or Access 2003.
• Maintained, upgraded, reprogrammed and debugged other older MS Access 97 databases at CGI.
• Project Management: I was the only software developer working on this project. My Colography Manager gave me task automating the manual phone calling process. It was my job to figure out how to go about automating the process. Therefore, I basically managed the project myself.
• Results: CGI has been able to attract some high-profile clientele and have greatly increased their ability to create revenue.