MS Access / VBA / SQL Developer Resume San Diego, CA - Hire IT People

CAREER SUMMARY:

A results driven MS Access / VBA / SQL Developer with over 20 years experience designing, developing and implementing databases primarily based on relational model of SQL.
Expert in client/server development, complex SQL database design, user interface design, analytical reporting, performance tuning, database maintenance, data analysis and troubleshooting.
Goal - oriented team member, eager to contribute to a company’s objectives, with proven abilities to multitask, prioritize effectively and make decisions quickly to complete projects within deadlines.

TECHNICAL PROFILE:

Databases: MS Access, MS SQL Server

Languages: VBA, SQL, T-SQL, ADO, DAO, ODBC

Tools: / Other MS Excel, MS Office, SharePoint, SAP, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

MS Access / VBA / SQL Developer

Responsibilities:

Created and maintained an Access database for a customized case manufacturing business to track sales and inventory, providing detailed reporting and financial analysis.

Confidential, San Francisco, CA

VBA Developer / Reporting Analyst

Responsibilities:

Automated a multiple level metric reporting process using MS Access and Excel, which saved 8 hours per week of error prone manual steps in Excel.
Incorporated extensive VBA and SQL code, metric ranking functionality, currency rate conversion details, Excel template exporting and VBA based report formatting.

Confidential, Englewood, CO

MS Access / VBA / SQL Developer

Responsibilities:

Consolidated over 60 Access metrics programs into 5 programs.
Redesigned Access metrics programs to improve calculations of employee performance relative to company goals. Decreased the processing time of a program from 7 hours to 30 minutes.

Confidential, Irvine, CA

MS Access Developer / SQL Server Developer

Responsibilities:

Created an employee status program to provide weekly evaluations of time spent on projects, the degree of completion of projects, achievements and the relationship of projects to company goals.
Expanded a program to track installations of radio frequency devices for the Edison SmartConnect Operations Center, which handles the communications for 5 million deployed Smart Meters.
Streamlined process change requests by developing a change management and inventory impact assessment programs, achieving enhanced priority scoring, status tracking and report analysis.

Confidential, Denver, CO

MS Access Developer / Data Analyst

Responsibilities:

Transformed an Excel batch master process into an automated Access process for the Independent Foreclosure Review, resulting in more reliable sampling rates used for case review selection.
Developed automated analytical reports and sampling rate editing screens, improving data analysis.

Confidential, Denver, CO

VBA Developer / Data Analyst

Responsibilities:

Formulated VBA programs in Access and Excel to validate HR conversion data.
Set up reports to analyze HR conversion data, comparing source files to converted SAP data.
Designed an Access database to establish employee links from business roles to security roles.

Confidential, Del Mar, CA

MS Access Developer / SQL Server Developer

Responsibilities:

Modified an FDIC loan program to track loan activity by creating a process to import Excel data into the database, improving the accuracy of financial forecasting, data analysis and analytical reporting.
Fixed major stability issues by resolving problems with saving data and unreliable reports.
Redesigned user interfaces, analytical financial reporting, record locking, login security and other performance functions.

Confidential, San Diego, CA

MS Access Developer / SQL Server Developer

Responsibilities:

Processed the billing of $2 million in monthly dues for over 60,000 union members while working on-site for 2 years and remotely for 5 years.
Provided daily management assistance on requested reports that required complex queries, ranging from cross-tab reporting to T-SQL programming in stored procedures.
Created a billing program in compliance with the State Controller’s Office specifications that calculated union member dues based on hours worked, medical plans selected and initiation fees.
Increased employee efficiency and data validation by creating data interaction between a billing database and a worker activity database.
Programmed a user database functionality to import data, run the billing process, create reports, run customized list requests, track member activity and view historical data.