SQL

David H. LaMontagne

*** ********* *****

Longwood, FL 32779

H: 407-***-****

E-Mail: ***********@*****.***

WORK EXPERIENCE

Universal American Financial Corp May 2006 – July 2009

Senior Report Developer

• Design and develop business report solutions using SQL Server Reporting Services (SSRS), SSIS Packages.

1. Creation and Processing of:

• Data extract requests

• New reports

• Report alterations

• Import into current reporting system of new data

• Stored Procedures/Views

• Documentation

2. Resolves Problems by either fixing, pin pointing or creating a work-around for:

• Report issues

• Report/Extract Job Failures

• Extracts issues

• Data integrity issues

• Through the use of SQL Scripting, Data Analyzing, SSIS Packages, Local Batch file creation, Stored Procedure/Table Creation, Crystal Reports and Microsoft Excel & Access

• Design and maintain dept custom triggers, queries, stored procedures and views on SQL Servers.

• Create and publish reports when requested to Crystal Enterprise Server for Web access to reports.

• Schedule and maintain Crystal reports in production on Enterprise Server.

• Database Admin for department Data bases including Access & MS SQL Server & SyBase Server.

Scholastic Book Fairs August 2001 – May 2006

Supply Chain / WMS

Supply Chain-WMS Analysis

• Design and develop business report solutions using SQL Server Reporting Services (SSRS,SSIS) and Crystal Reports.

• Database Admin for department Data bases including Access & MS SQL Servers.

• Maintain Warehouse Managements System (WMS) configuration.

• Test & debug all code changes for WMS system in QA environment prior to being moved into production.

• Provide main department contact to other company departments and outside vendors.

• Provide central support to all company warehouses for IT/Users issues.

• Develop and maintain department documents for WMS & EDW systems.

Walt Disney Company January 1978 – July 2001

Resort Call Center February 1998 – July 2001

System Administration / Database Administration

• Provide all support for Desktop PC and applications (on & off-site).

• First contact for all customer support in and out side department (In person or by phone).

• Design and maintain Call Center database applications.

• Research, evaluate and install all new software applications.

• Coordinate with all outside customers and vendors.

• Track all department projects using MS Project.

• Responsible for all Network application administration.

• Responsible for department’s Network, desktop’s hardware/software and all peripherals.

• Install all new hardware.

• Responsible for all hardware & software inventory, system enhancements.

• Maintain & update department trouble tracking system.

• Responsible for all special DOS applications and IBM AS/400 Reservation systems.

• Train all department personnel on PC and Network applications.

• Responsible for department’s budget.

• System Administrator / Super Users for Meridian Max; Aspect (TCS-Workforce Mgmt); Xtend system, IBM AS/400 Reservation System.

* Analysis call volume and service level trends.

• Maintain call center statistic reporting.

• Create reports from department databases for area leaders.

• Support management with Agent Productivity inquiries and initiatives including agent monitoring.

• Introduce ways to improve support processes by automating or simplifying tasks.

Disney Worldwide Services Inc. August 1982 – February 1998

Supervisor – Computer Operations June 1985 – February 1998

• Lead, coached and developed a team of 18 computer operators.

• Assisted client and department leaders on new applications design and implementation using mainframe and desktop applications.

• Organized and set department production priorities; work with clients on any problems or changes to production schedules.

• Responsible for tracking department labor hours and charge back systems.

• Maintain client report distribution database and setup on-line viewing of reports.

• Maintain all Infopac setups.

* Maintain department PC setups (hardware/software install) and System/LAN ID’s.

• Communicate with clients and leaders on production schedules and workflow.

* Train all new department cast members and review new procedures with all operators.

* Responsible for all hardware operating systems and report processing.

* Responsible for forms design on Laser printers and Micrographs equipment.

Walt Disney World Co.

Production Control Clerk August 1982 – June 1985

• Maintained and distributed all computer production reports to clients across property.

• Managed department’s databases.

Magic Kingdom

Ride Host January 1978 – August 1982

• Provided exceptional guest service to guest visiting attractions in Fantasyland, Tomorrowland and Frontierland.

Education

Seminole Community College

• Coursework towards a degree in Business Management and Data Processing

TECHNICAL SKILLS

* Proficient in Access, Visual Basic database/application design, Business Objects, SQL, ASP, Microsoft Word, Excel, Windows 95, 97 & 2000, NT, XP Microsoft Internet Explorer, CC-Mail, Outlook, Lotus spreadsheets, Paradox, Microsoft Project, Harvard Graphics, Adobe Acrobat, Crystal 10 & 11, MS SQL Server, SyBase Sever and Facets.

• Completed the following training programs:

 A+ Certification

 Microsoft Access Advanced Database Management

 Mastering Access Development

 Mastering Visual Basic Fundamentals

 Microsoft Word, Excel, Access

 MS SQL Server & SQL (SSRS,SSIS)

 Crystal 10 & 11

 Crystal Enterprise 10

 Business Writing

HOBBIES

* Database / Web page design.

• Private pilot.

REFERENCES

Available Upon Request

Contact this candidate