Access Programmer Resume Profile
KEY QUALIFICATIONS
- 22 Years of Programming and Analyst skills
- Expert at designing and maintaining multifunctional databases
- Highly skilled in VBA, DAO, ADO, API, etc.
- Task Goal Oriented
- Self Motivated Disciplined
- Excellent Communication Skills
- Detail Oriented
- Proven abilities to develop and implement solutions
- Productive Self-Starter
KEY SKILLS
- Microsoft Access Versions 1 to 2010
- Microsoft Visual Basic for Applications VBA
- Microsoft Visual Basic
- Microsoft SQL
- SSIS
- Data Modeling
- Business Process Automation
- Project Management
- Gathering User Requirement
PROFESSIONAL EXPERIENCE
Confidential
Sr. Access Programmer /Analyst
- Create an Access 2010 Database to import various Excel files
- Create Access and Excel Pivot Tables and Charts
- Create Documentation for users
Confidential
Sr. Access Programmer /Analyst
- Rebuild old FoxPro Database in Access 2010.
- Import dbf data into the new system
- Create user friendly interface
Confidential
Sr. Access Programmer /Analyst
- Created Access Reports utilizing AccPac SQL Server tables
- Create and Edit AccPac VBA Macros
- Run Pricing Updates against AccPac utilizing Access 2010 and AccPac Macros
Confidential
Sr. Access Programmer /Analyst
- Corrected Issues in Access 2003 Database
- Created Reports
- Enhanced Form design
Confidential
Sr. Access Programmer /Analyst
- Worked on a team of 6 to convert 60 Access 2003 Databases into SQL Server 2008 backend.
- Implemented security on Access front end and secured data via SQL Server schemas as well as Access Workgroups.
- Utilized SSIS packages via a Landing Zone to manipulate and import flat files into SQL Server
- Integrated databases with Lotus Notes Mail
- Update Sharepoint connections
- Created testing scripts and tested utilizing Quality Center ALM
Confidential
Sr. Access Programmer /Analyst and Data Analyst
- Converted an Access 97 database to Access 2007 to assist in the scrubbing and conversion of legacy system data to SAP. Modified most of the record sources, forms and reports to suit the new business requirements
- Created an Access Database to assist in EMITs Downstream conversion to SAP
- Imported and Exported data via automation
- Data management, scrubbing and maintenance for conversion from legacy systems into SAP
- Compiled and Analyzed Data
Confidential
Sr. Access/SQL Programmer /Analyst
- Added new forms, reports and web services to an Access 2003 Event Management Database
- Corrected existing errors
- Upgraded Access backend to SQL Server.
- Integrated Access/SQL with web data
Confidential
- Sr. Access Programmer/Analyst Yahoo Merchant Store Creator
- Create custom drop-shipping database to handle the automation of orders via Access 2010 SQL 2008 back-end and Yahoo Merchant
- Created a Yahoo Merchant Store selling house-ware products
- Automated data feeds from various sources FTP, txt, csv, xls, etc. utilizing Access VBA and/or Outlook to download of web crawl for the data.
- Integrated Twebst for web automation.
- Integrated Web Services into VBA
- Utilized VBA to work with XML data.
- Implemented code to handle manipulation of distributor data to then upload to Yahoo Merchant store utilizing VBA.
- Created automation of incoming and outgoing orders using ODBC from Access VBA to Outlook.
- Utilized VBA in automation of various supplier websites.
Confidential
Access Programmer/Analyst. Yahoo Merchant Store Creator
- Created an OSCommerce Store
- Create custom drop-shipping database to handle the automation of orders via Access 2007 SQL 2008 back-end as well as Connector to MYSQL for OS Commerce Data and OSCommerce
- Automated data feeds from various sources FTP, txt, csv, xls, etc. utilizing Access VBA and/or Outlook to download of web crawl for the data.
- Implemented code to handle manipulation of distributor data to then upload to OSCommerce modules utilizing VBA.
- Created automation of incoming and outgoing orders using ODBC from Access VBA to Outlook.
Confidential
Access/SQL Programmer /Analyst
- Converted Case Management Software in Access mdb 97 to Access 2003 adp utilizing SQL 2005.
- Converted all dao code to ado.
- Linked MS Outlook to Access emails and calendars
- Troubleshot and corrected all issues of the upsizing.
- Automated integration with Microsoft Outlook 2007.
- Created new reports and various forms to assist in productivity.
- Found and corrected prior errors in code, as well as logic.
- Created new stored procedures and views in SQL 2005
- Utilized DTS packages to update SQL 2005
- Enhanced File Folder system through Access.
- Created Technical Documentation and User Manuals
Confidential
Access/SQL Programmer /Analyst Telecommuting Contractor
- Converted numerous Access 97 mdb to Access 2003 adp utilizing SQL 2005.
- Converted all dao code to ado.
- Enhanced the look and ease of use of forms.
- Found and corrected prior errors in code, as well as logic.
- Implemented conversion of reports to PDF and automated emailing utilizing Outlook.
- Troubleshot and corrected all issues of the upsizing.
- Created new stored procedures and views in SQL 2005
Confidential
Access/SQL Programmer /Analyst
- Created an automated system to file Bankruptcy claims to various United States Bankruptcy Courts utilizing xml through Access 2007 adp through Pacer.org and CM/ECF programs.
- Automated Document Management system
- Implemented Bar Code technology for document tracking.
Confidential
Access Programmer /Analyst Telecommuting Contractor
- Analyzed productivity issues and corrected coding errors
- Enhancements made to an existing Access 2000 Database
Confidential
Access Programmer/Analyst
Analyzed and corrected issues with PawCom interface of Peachtree to Access 2000