MS Access/SQL Developer/Technical Writer Resume

SUMMARY

I am multi - talented, creative and enjoy working with users to create small-medium relational database solutions to meet their needs. My area of expertise is building MS Access interfaces with SQL Server back ends. This includes writing scripts, T-SQL database objects and SSRS Reports. I have experience working in an Agile environment utilitizing Visual Source Safe, Team Foundation Server, Sharepoint and Version One software. I have excellent Microsoft Office and written communication skills.

TECHNICAL SKILLS

MS Access-SQL Server 2008 Integration (ODBC linked tables/views, security and ADO stored procedure calls)
T-SQL Scripting (tables, views, tiggers, functions, stored procedures, etc)
MS Access VBA Programming
MS Excel data integration and advanced data manipulation (Vlookup, Pivot Tables, Functions)
Multi level security implementation (SQL Active Directory security groups, MS Access front end security)
Technical Writing for MS Access based systems

PROFESSIONAL EXPERIENCE

Confidential

MS Access/SQL Developer/Technical Writer

Responsibilities:

Created a series of MS Access databases with SQL Server back ends for the largest K-12 e-school in the nation (14,000+ students).
This required a high level of independence and the ability to function as a business analyst/systems analyst, technical writer, subject matter expert and programmer:
Records Management
Marketing/Application Request Management (including complex data cleansing and duplication identification)
State Funding Management
Deparment of Exceptional Children Mangement (IEP/ ETR documents, State Reporting/EMIS data)
State Achievement Testing Management

Confidential

SSRS Report Writer

Responsibilities:

Created grade cards, transcripts, academic reports and miscellaneous reports
Wrote complex stored procedures, including school-wide GPA calculation, and attendance reports for statewide reporting agencies

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship