SQL\VBA Developer Resume Phoenix, AZ - Hire IT People

SUMMARY

Creative, versatile, multilingual Database/Software Developer with extensive experience developing data storage, analysis and migration solutions for the business professional. Solid understanding of the software development lifecycle with proven track record of providing well designed, tested and documented custom software. Excellent interpersonal skills with demonstrated ability to work independently and in team.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SQL\VBA Developer

Responsibilities:

Troubleshoot database maintenance script and resolve data loss issues due to faulty logic in code. Migrate maintenance code into easily maintainable, yet elegant and robust solution using stored procedures and scheduled SSIS packages.
Continue development of existing Microsoft Access front - end / SQL Server back-end database applications. Coordinate testing with other team members, package for release and release upgrades to end-users.
Various ETL projects using Alteryx, SSIS and VBA coding. Protect sensitive data.
Create documentation for applications and processes.

Confidential, Phoenix, AZ

SQL Developer / Programmer Analyst

Responsibilities:

Completed data migrations using various ETL tools: SQL scripting, Stored procedures, SSIS and front-end data import functionality. Implemented medical ICD9 to ICD10 data conversion scripts.
Decreased cost of software maintenance by using a deep understanding of database structure to reverse-engineer, troubleshoot and address issues that would have been costly to repair by a third party.
Created barcode scanner driven Asset Management Application, which interfaced to the company’s Sharepoint site and allowed staff to perform inventory checks and updates.
Provided application support to front-end users on database related issues.
Created reports using SSRS and implemented automation using SSIS to allow front-end users to trigger report/extract execution and distribution from within application.
Performed Database Administrator role to provide support to Senior DBA as a knowledgeable resource (front-end expertise) and as a backup DBA.
Documented procedures and trained end-users

Confidential

Database Developer

Responsibilities:

Completed data conversions for clients migrating from QuickBooks to REALedger - a specialized accounting solution for real estate offices.
Performed maintenance and support of VB.Net Application. Also assisted with deployment on clients computers.
Developed prototype database applications according to client specifications.
Acted as a resource/subject matter expert for other consultants and help with programming challenges (VBA, SQL, Crystal Reports).
Fixed bugs and implemented changes in design.
Modified complex MSAccess application (60,000 lines of code) to use SQL Server back-end. Enhanced user interface to be more intuitive and look more professional.
Created customized reports for clients.

Confidential

Programmer / Analyst

Responsibilities:

Performed database modeling, administration and development tasks related to projects.
Make changes to the security model of applications to use integrated authentication
Implemented new requirements and changes to existing functionality, including migration of data from multiple MS Access 2002 databases to SQL Server.
Maintained, improve documentation and clean up existing code (VBA).
Provided user support (combined user of approximately 460 users).