|
Home Phone: (903) 839-2678 Cell Phone: (903) 520-1332 Fax: (903) 839-2841 E-mail: mrbpolk@suddenlink.net |
|
|
Byron Polk
|
Objective Skills |
Seeking a position where I may continue to utilize my ever expanding computer knowledge of software usage for database application development, office process automation and integration using the Microsoft Office Suite, including Excel, MS Word, and MS Access, along with using SQL, VBA, Forms, Reports and the Access Security Model. I also want to continue to use my experience with using DB2, SQL Server and other RDBMS as a backend for client/server type application using MS Access. I would also like to continue to use and expand my experience with Crystal Reports, AutoCAD and Visual Basic.net programming abilities. Microsoft Access (full life-cycle development) 10+ years Database Design and Development 10+ years Microsoft Word 10+ years Microsoft Excel 10+ years Microsoft Office Suite Development and Automation 10+ years AutoCAD 10+ years Crystal Reports, version 5.0 8 years VBA 8 years Visual Basic, Version 5.0, VB.net 2
years |
|
Experience |
April, 2007 to July 08 MS Access Developer §
Worked on developing multiple database
applications to assist in the management, rendering and payment of Advelorum taxes for a major oil production company. The development of these applications is
unique in the sense that there are multiple states involved, along with
multiple owners and multiple properties in multiple jurisdictions. The databases are required to track the
rendered values and tax amounts paid on each property to each jurisdiction
for each owner. The development of
these applications is now complete.
(This project started out as a part time project and after January
2008 became a full time position. August, 2007 to January 2008 MS Access Developer §
Worked on a contract assignment with Dobson
Communications. This February, 2007 to August, 2007 MS Access Developer §
Worked on a contract assignment with Verizon. This June, 2006 to November, 2006 MS Access Developer §
Worked on a contract assignment for Ryan and
Co. This September, 2005 to May, 2006 MS Access Developer §
Worked on a contract assignment for Haggar
Clothing Co. of Dallas. The project
included the automating of existing data extraction and report processes as
well as the development of new, automated process for Accounts Receivable
Forecasting, Monthly Ending Balance Information for Accounting. Also performed data extraction and
manipulation on demand from multiple data sources, including SQL Server, Oracle,
and other ODBC data sources. August, 2004 to September, 2005 Instructor – §
Instructor for Windows XP and all levels of
the Microsoft Office February to March, 2005 MS Access Developer §
Worked on a repeat contract assignment for
Unitrin Insurance Company of December, 2004 to January, 2005 Carreker Corporation, Dallas MS Access Developer §
Worked on a contract assignment for Carreker Corporation in August, 2004 to October, 2004 Unitrin Insurance Company of MS Access Developer §
Worked on a contract assignment for Unitrin
Insurance Company of July, 2001 to June,2003 Fort
Worth Technologies, Inc. MS Access Developer § Worked on a contract assignment from Ft. Worth Technologies with the Burlington Northern Santa Fe Railroad. Managed the development of projects which included maintenance and expansion of existing MS Access applications and the development of new applications to support the activities of the railroad. All applications were required to be accessible through the Windows interface. § Improved the performance of an existing database by utilizing the “client/server” methods for development in Access. This application also required extensive use of complex forms for acquisition of data which required the use of VBA and SQL. Reports were developed to deliver information from the database in printed format as well as exporting data to Excel format for delivery to others via an automated email process. The Access Security model was successfully used with this application, validating user login and requiring user name and passwords. While the original database application was developed using an Access front-end linked to another Access database for the back-end, near the end of the contract, the back-end database was designed in DB2. The front-end application was then modified to read and write the data to the new DB2 back-end using an ODBC connection. § Managed and worked on the creation applications and functions that integrated software programs from the MS Office Suite to eliminate redundant activities by employees. These included connections to ODBC and other data for information, along with the monitoring, sending, receiving and processing of emails. 1997–2001 AppliTech Project Manager and MS Access Developer § Project Manager for a firm which provides Application Specific Database development using Microsoft® Access 97 and the Microsoft® Office Developers Addition for multiple clients. Extensive integration development using MS Office, Excel, Crystal Reports and Visual Basic. § Managed and participated in the development of an MS Access database and application front-end for Nortel. The database was then used for delivering information over the Internet. The application front-end was used as a data entry and management program for the data that was being accessed by managers from across the country via the Internet. It was also used as the prototype for the web site and ASP pages. §
Managed and participated in the development of
an MS Access database for tracking the rollout of a new POS system by
Southland Corporation. This
application was used by the "War Room" for tracking and reporting
on the installation of these POS systems in many of their stores all over the
§
Worked on a project for KPMG that included an
MS Access database for GTE. §
Managed and participated in the development of
an MS Access database and an application front-end for a manufacturing
company in § Managed and participated in the development of an MS Access database and application front-end for a mortgage banker that is being used to provide a method for reviewing and updating selected data from an existing Windows application before preparing this data for export to a DOS application which is required by government regulations. This was a significant application, in that it required a manipulation of data both on the receiving and delivery end of the process. §
Developed an intensive course on the use of
Access for linking data to
AutoCAD® drawings for use in Facility Management. I
taught this course at various state wide seminars and at § Managed and participated in the development of a complete life-cycle database application using Microsoft Access 97®, , VBA, Crystal Reports and Visual Basic 5.0. Utilizing the Microsoft® Office 97 Developers Addition for distributing this application state wide. § Provide consulting service to The University of Texas Southwestern Medical School and other local Medical Facilities, Engineering firms and other clients for the improvement and organization of their Database operations and CADD Systems integration, including the development and production of Operations Manuals. § Provide Bata testing for AutoDesk®, Inc. (makers of AutoCAD®) |
|
|
1988–1997 Children’s Medical Center of Dallas Dallas, TX CADD System’s Manager § Managed the Initiation and development of a master plan for using Microsoft® Access 95 and AutoCAD® as an information delivery tool in Facility Management. § Managed and participated in the developed an integrated system for the delivery of calculations and data, needed for Medicare/Medicaid reimbursement reports using a combination of Microsoft® Access 95, Excel and AutoCAD. |
|
|
1989–1992 Mid
America Mortgage, Inc. Information System Manager (Part time) § Planed and initiated their first Novel Network § Designed, developed and programmed a “Automated Document Preparation” system, which would prompt the user to provide the required pieces of data and then merge that data with the users choice(s) of over 65 documents. |
|
Education |
1962 1992 – 1996 Mountain
View Community College |
|
Salary |
Negotiable |
References: Available upon request