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

SUMMARY:

A results driven Senior MS Access / SQL Developer and Reporting Analyst with 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, dashboard creation, ad hoc reporting, data analytics 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 on time.

TECHNICAL SKILLS:

Databases/Languages/Tools / Other: MS SQL Server T - SQL, SQL, VBA MS Excel, SharePoint MS Access ADO, DAO, Python SSRS, SSIS, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

MS Access / VBA / SQL Developer

Responsibilities:

Created and maintained an Access database to track candidate qualifications, client job requirements, employee performance, financial impact and forecasting based on job placements.
Assisted top management in strategic and business development using MS Access advanced techniques using VBA and SQL coding, along with Excel functionality for reporting purposes.

Confidential, Temecula, CA

Senior Operations Analyst

Responsibilities:

Designed SQL Server and Access databases, coding in T-SQL, SQL and VBA to support monthly dashboards, trend analysis reports and BOM explosion analysis for the data governance department.
Assisted top management in strategic and business development for critical projects, navigating transfer of products and associated materials based on bill of material analysis.
Designed and automated trend analysis reports for over 100 metrics through the implementation of SharePoint, ranging from new product launches to data validation and comparison between systems.
Combined data from various systems within the Merck company hierarchy to establish a foundation for data analysis and strategic implementation, unveiling data discrepanciesbetween systems.

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.
Developed advanced program and reporting logic using MS Access VBA and SQL coding, including Excel programming techniques for reporting such as pivot tables, functions, formulas, and VBA code.

Confidential, San Francisco, CA

Data Reporting Analyst / VBA & SQL Developer

Responsibilities:

Automated a multiple level metric reporting process using Access and Excel.
Incorporated extensive VBA and SQL code, metric ranking functionality, currency rate conversion details, Excel template exporting, VBA based report formatting and data analysis.

Confidential, Englewood, CO

Data Reporting Analyst / MS Access 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 / SQL Server Developer

Responsibilities:

Created an employee status program to provide weekly evaluations of time spent on projects, the degree of project completion, s, and the relationship of projects to company goals.
Expanded a program to track installations of radio frequency devices for the Edison Smart Connect Operations Center, which handles the communications for 5 million deployed Smart Meters

Confidential

VBA Developer / Data Analyst

Responsibilities:

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

Confidential, Del Mar, CA

MS Access / SQL Server Develop er

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.
Redesigned user interfaces, financial reporting, record locking and other performance functions.
Fixed major stability issues by resolving problems with saving data and unreliable reports.

Confidential, San Diego, CA

MS Access / SQL Server Developer

Responsibilities:

Processed the billing of $2 million in monthly dues for over 60,000 union members.
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.
Programmed a user database functionality to import data, run the billing process, create requested customized reports, run customized list requests, track member activity, and view historical data.
Increased employee efficiency validating data between billing and worker activity databases.

We provide IT Staff Augmentation Services!

Ms Access / Vba / Sql Developer Resume

San Diego, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship