TECHNICAL SKILLS:

Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft SQL Server 2005, Microsoft SQL Server 2008/2014, Database Design and Implementation, C#, PostScript, FileMaker, DialConnection Dialer Environment (IVR experience), and L atitude account system

RELATED WORK EXPERIENCE:

Confidential, Scranton, PA

Database Analyst/ Programmer

Responsibilities:

• Managed ticket queue (resolving and closing trouble tickets)
• Involved in the training of new employees
• Designed and implemented SSIS packages for ETL purposes in a Data Warehouse environment
• Created ad - hoc and automated reports, utilizing SSRS, SSIS, Excel, and SQL
• Analyzed stored procedure and queries for optimization and recommended enhancements.
• Created procedures, functions, and constraints to maintain data integrity. Applied indexes to improve performance.

Environment: Used Microsoft Word/Excel, SQL Server 2000/2005/2008 R2/2014, SSIS, SSRS, Tidal (Job Management System)

Confidential, Lancaster, PA

Software Consultant/SQL Developer

Responsibilities:

• Created ad-hoc PostScript files for printing production
• Created simple and complex queries/tables/views/procedures for reporting purposes, integrating multiple databases and utilizing SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2
• Worked on four new projects for the company:
• Created and administered an Attendance Database (including design, implementation, user access, and ODBC setup on remote PCs), utilizing FileMaker 12 as a front-end and SQL Server 2005 / 2008R2 as a back-end
• This encompasses all aspects of vacation selection (annual hierarchal vacation selection, automated approval and denial based on vacation rules, and the design of a dynamic calendar for final approval). Also within the scope of this project was: vacation reporting, a transaction-based occurrence tracking system, and an in-depth employee information database.
• This was deployed on Windows Server 2003 in October of 2014 and is currently in use by Support, HR, and Management
• Created digital Assignment Boards, utilizing FileMaker 12 as a front-end and SQL Server 2005 / 2008R2 as a back-end
• These are two 50” LCD televisions that display an up-to-date visualization of which machines floor employees are currently assigned to
• This was deployed on Windows Server 2003 in November of 2013 and is currently in use by Floor employees and Management
• Created an Electronic Time Entry database, utilizing FileMaker 12 as a front-end and SQL Server 2005 / 2008R2 as a back-end
• This involved the creation of a security system in FileMaker that allows the employees to scan their employee badge (to forego repeated logging in and out), creating a dynamic time entry and printing system (based on the type of work they are doing and department they are in), and installing keystroke scripts that will close the layouts, in case they walk away or do not enter any information within a set period of time.
• This also involved the setup of 35+ PCs with new software and the training of 100+ employees on the new system.
• This was deployed on Windows Server 2003 in November of 2013 and is currently in use by Floor employees and Management
• (Moved on before fully completed) - Creating a database for labor-unit tracking and reporting, utilizing FileMaker 12 as a front-end and SQL Server 2005 / 2008R2 as a back-end
• This system consolidates data entry points into one hub, for ease of entry
• The system will automatically draw data from electronic time sheets and a paperless ticketing system that is currently in design by another department.

Environment: Used Microsoft Word/Excel, Microsoft TFS, SQL Server 2005/2008 R2, PostScript, Adobe Distiller, and FileMaker 12

Confidential, Wilmington, DE

Software Consultant/SQL Developer

Responsibilities:

• Design supply chain reports, using proprietary Confidential software
• Create simple and complex queries for reporting purposes, integrating multiple databases and utilizing SQL Server 2008 R2
• Utilize SSIS to integrate new data from clients
• Document all changes and creations
• Work with our clients for requirements gathering
• Create automated SQL jobs to manipulate data and cache reports

Environment: Used Microsoft Word, Microsoft Excel, SQL Server 2005, SQL Server 2008 R2, and some C#

Confidential, Carlisle, PA

Operations Coordinator/Manager

Responsibilities:

• 75% SQL Server 2008 database management.
• Collaborate with the Director of Operations to develop new (and recreate current) T-SQL queries for the improvement of a dialer environment
• Utilize SSIS to integrate new data from clients
• Create simple and complex queries for reporting purposes, utilizing multiple databases and reporting in MS Excel
• Manage 40+ Collections and Customer Service Representatives in a call center environment
• Train all new employees on all aspects of collections, including legal and contractual requirements
• Prepare invoicing and journal reconciliation

Environment: Used Microsoft Office, Microsoft Excel, SQL Server 2000/2005/2008 R2, DialConnection Dialer Environment (IVR experience), and Latitude account system