Sql & Access Developer Resume
Andover, MassachusettS
PROFESSIONAL SUMMARY:
Study focused on micro - computer programming. I have worked in the fields of database and application modeling, design, development and assistant DBA. I am very skilled with all versions of Microsoft SQL Server, Microsoft BI suite (SSRS, SSIS), VBA and Microsoft Access. My most recent position was with a fast paced Appointment Sales Company supporting 200 Inside Sales reps and their management staff including C-Level users across multiple sites. Client facing projects were also included. Their primary application was written in Microsoft Access with a SQL Server back end. I was the lead programmer and support for this app. My most recent experience required expert T-SQL & SSRS work.
TECHNICAL SKILLS:
VBA: Expert (.adp, .mdb, accdb, adodb, odbc, etc.)
VB.Net: Beginner - Intermediate (Custom assembies for extending SSRS & SSIS), SQL Server* DBA: Beginner - Intermediate (2000, 2005, 2008 RD, 2012), SQL Server* Development: Advanced (2000, 2005, 2008, 2008 R2, 2012), SSRS Advanced, SSIS intermediate, SSMS Advanced, VS intermediate
MS Access Development: Expert (95, 97, 2000, 2002, 2003, 2007, 2010, 2013), Migration/Reverse Engineer of Access Databases to SQL Server, Migration/Revesre Engineer Access and Crystal Reports to SSRS
Visual Studio environment: Advanced (2005, 2008, 2010, 2012), XML, JSON (Beginner), XSLT, DTD, XSD, WSDL, RESTFUL, XQuery intermediate, Microsoft Office automation (Access, Excel, Word) intermediate - advanced, Oracle, TOAD Beginner, Windows Server OS intermediate, IIS & WPC beginner. * Enterprise & Standard
WORK EXPERIENCE:
Confidential, Andover, Massachusetts
SQL & Access Developer
Responsibilities:
- Architected and designed Access and SQL Server based applications for highly transactional sales and marketing firm
- Projects included internal & client facing SSRS reporting, automation of standard and data- driven SSRS subscriptions, administration of the Data and Reporting server
- Most SSRS development in Visual Studio environment
- Heavily involved in T-SQL and SSIS to support SSRS Reports
- Converted reports from legacy systems to SSRS
Confidential, Stuart, Florida
SQL Server, Microsoft BI Tools & Access Developer
Responsibilities:
- Head up specialized database and desktop application projects across various industries Including hands on data modeling, design, test and implementation
- SQL Server, Microsoft BI suite & MS Access (all versions)
- Database and middleware support for .NET developers
- Scale out Access databases to SQL Server and migrate reports to SSRS
- Migrated Data using SSIS and performed assistant DBA duties
Confidential, Jacksonville, Florida
SQL Server & Access Development
Responsibilities:
- Worked in the consumer loan department.
- Created financial tools in MS Access & SQL Server to integrate transactional and data warehouse data from SQL Server, Oracle and LMS systems.