We provide IT Staff Augmentation Services!

Sr. Access Programmer /analyst Resume

Mettawa, IL

SUMMARY:

  • 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, Mettawa, IL

Sr. Access Programmer /Analyst

Responsibilities:

  • Create an Access 2010 Database to import various Excel files
  • Create Access and Excel Pivot Tables and Charts
  • Create Documentation for users

Confidential, Baton Rouge, LA

Sr. Access Programmer /Analyst

Responsibilities:

  • Rebuild old FoxPro Database in Access 2010.
  • Import dbf data into the new system
  • Create user friendly interface

Confidential; Baton Rouge, LA

Sr. Access Programmer /Analyst

Responsibilities:

  • 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, Pinellas Park, FL

Sr. Access Programmer /Analyst

Responsibilities:

  • Corrected Issues in Access 2003 Database
  • Created Reports
  • Enhanced Form design

Confidential, Dayton, OH

Sr. Access Programmer /Analyst

Responsibilities:

  • 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, Houston, TX

Sr. Access Programmer /Analyst and Data Analyst

Responsibilities:

  • 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, CA

Sr. Access/SQL Programmer /Analyst

Responsibilities:

  • 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, Spring Hill, FL

Sr. Access Programmer/Analyst

Responsibilities:

  • Create custom drop-shipping database to handle the automation of orders via Access 2010 (SQL 2008 back-end) and Confidential
  • Created a Confidential 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 Confidential 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, Spring Hill, FL

Access Programmer/Analyst

Responsibilities:

  • 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, New City, NY

Access/SQL Programmer /Analyst

Responsibilities:

  • 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, Glendale Hts, IL

Access/SQL Programmer /Analyst

Responsibilities:

  • 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, New City, NY

Access/SQL Programmer /Analyst

Responsibilities:

  • Created an automated system to file Bankruptcy claims.
  • Automated Document Management system
  • Implemented Bar Code technology for document tracking.

Confidential, South San Francisco, CA

Access Programmer /Analyst

Responsibilities:

  • Analyzed productivity issues and corrected coding errors
  • Enhancements made to an existing Access 2000 Database

Confidential, South Elgin, IL

Access Programmer/Analyst

Responsibilities:

  • Analyzed and corrected issues with PawCom interface of Peachtree to Access 2000

Confidential, Northlake, IL

Access Programmer /Analyst

Responsibilities:

  • Create new Access 2003 database to track the flow of requests for business lines, products, vendors and markets.
  • Created forms and ad hoc reports.
  • Integrated emailing capabilities with Outlook.

Confidential, Norwalk, CT

Access/SQL Programmer

Responsibilities:

  • Analyzed and corrected various reports and forms using Access 2007 ADP project with SQL 2005 on the back-end.
  • Created new stored procedures and triggers on SQL 2005 to enhance productivity.

Confidential, Brooksville, FL

Senior Access Programmer/Analyst

Responsibilities:

  • Analyzed existing work flow and systems and recommended procedural and/or system improvements to increase efficiency and reduce costs.
  • Provided back-up to the IT Director.
  • Installation and upgrades of Oracle 10g on Linux server.
  • Developed, deployed, maintained and enhanced applications in Access, Visual Basic and Asysco Lion Developer (using SQL 2000 on the back-end for data).
  • Creation of Stored Procedures and Pass-through Queries.
  • Utilization of T-SQL for queries to SQL Server.
  • Developed and deployed new applications utilizing Asysco Lion Developer, Access 2003 and Access 2007, Visual Basic 6 accessing both SQL 2000 and Oracle 9i and 10g data.
  • Integrated Consumable Web Services.
  • Created XML files for CAMA data integration with Apex and MobileO software.
  • Assisted with the maintenance of multiple databases in SQL and Oracle.
  • Database and geodatabase design, maintenance, tuning, and support utilizing Arcmap.
  • Utilized Visual Basic to create a dll interface with ArcMap.
  • Created and edited complex Excel spreadsheets and pivot tables.
  • Troubleshot hardware, software, and peripheral issues as needed.
  • Wrote system and procedural documentation and trained users.

Confidential, Spring Hill, FL

Access/SQL Programmer/Analyst

Responsibilities:

  • Updated and corrected existing multi-user Access database.
  • Analyzed structure and corrected where necessary.
  • Created financial, ad-hoc, statistical, and auditing reports.
  • Converted DAO to ADO
  • Upgraded from Access 2000 to Access 2003, migrated to an ADP version to SQL 2000 back-end, trained users, created documentation.
  • Create stored procedures and views.

Confidential, Brewster, NY

Access/ Visual Basic/SQL Programmer/Analyst

Responsibilities:

  • Updated Access database (that I had created in 1998) to utilize SQL Server 2000 as a backend.
  • Utilized Access for static as well as dynamic reporting, created detailed documentation and trained the end-users.
  • Analyzed technical needs and created a user friendly front end to enhance productivity.
  • Created technical drawings of space, phones, network, and lighting for new office construction.
  • Ran Category 5E cables and terminated network and phone lines.
  • Installed and terminated the network hub, installed a wireless network, and configured TCP/IP settings.
  • Designed and installed an Office 2003 server running SQL 2000.
  • SQL 2000 DBA and Access 2003 DBA.
  • Developed, implemented, and tested backup and recovery plans.
  • Utilized VB.Net to create exes and dlls to assist in productivity.
  • Automated Access uploads to Quick Books Pro 2005.
  • Installed and maintained the new Panasonic Phone system.
  • Updated hardware and software as necessary.

Confidential, Danbury, CT

Visual Basic/SQL/Access Programmer/Analyst and SQL Server DBA

Responsibilities:

  • Designed and created accounting Sub-Ledger and Broker-Dealer/New Business tracking systems for the insurance industry.
  • Designed and created a Commission Calculations system utilizing VB6 and SQL 7.0 as the backend utilizing ADODC.
  • Utilization of T-SQL for queries to SQL Server
  • Built all of these modules into one unique system for ease of use and data sharing.
  • Created new and converted existing Visual Basic 6.0 applications from DAO to ADO and backend to SQL server.
  • Created Stored Procedures and Pass-through Queries.
  • Created OLAP Cubes.
  • Creation of Complex SQL Joins.
  • Created reports utilizing Crystal Reports and Access 2000.
  • Provided support to clients as needed.
  • Assisted with the maintenance of Internal Web Programs using Ultra Edit and Visual Basic.
  • Created user manuals and code documentation, provided training to users.
  • Installed and provided Database Administration of the new SQL 7.0 Server.
  • Utilization of T-SQL for queries to SQL Server
  • Designed, constructed, and implemented physical databases.
  • Developed, revised, and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environment.
  • Planned and conducted structured testing of database designs to confirm functionality and performance.
  • Developed and implemented plans to oversee the data and database administration function, and ensured smooth transition to new technology.

Hire Now