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.