Experience Summary

Confidential

ASP.NET / Oracle - SQL Server Developer

• - Developed company's intranet application using ASP.NET 2010 VB.NET , AJAX, User Controls, Web Services, etc.
• - Creation of tables, procedures, functions, views, etc. Code developed using PL/SQL, TOAD 11.5 and SQL Developer.
• - Use Team Foundation Server TFS as source version control software.

Confidential

Senior SQL Server Developer/DBA

• - Installed, configured and implemented upgrade of SQL Server 2005 to 2008 R2 on Windows 2003 64 bit platform
• - Upgraded hundreds of SSIS packages, SSRS reports and SSAS cubes to 2008
• - Management and enhancement of data warehouse to transform data from AS400 system into SQL Server using SSIS.
• - Developed informational reports/cubes using SSRS/SSAS to meet all departmental needs.
• - Managed all phases of SQL development and administration.
• - Maintained and enhanced company website using Adobe Flash Pro CS5.
• - Application development using Visual Studio 2010.

Confidential

Executive Director of Information Technology

• - Managed IT department as it pertains to the everyday running of department.
• - Supervision and oversight of IT group consisting of network and database administrators, software developers and contractors.
• - Managed all phases of SQL development and administration.
• - Quarterly personnel reviews for upper management and HR.
• - Hands on database and software development, design and implementation
• - Procurement of new devices, computers, servers and third party vendor systems.
• - Information disbursement for various departmental data needs through SQL templates and ad-hoc reporting.

Confidential

Manager of Data Operations Aug

• - Managed team of database developers to ensure all database requests were prioritized and completed in a timely manner.
• - Installed, configured and implemented SQL Reporting Services and created reports to be sent out daily.
• - Installed, configured and implemented SQL Integration Services. Created SSIS packages to parse data from hospitals data downloads. SSIS packages were used to extract, transform and load the data into our systems. Implementation saved manual process and increased performance.
• - Administered SQL Server 2005 databases to ensure maximum up time.
• - Nightly backups, monthly maintenance, system optimization, etc.

Confidential

SQL Server DBA/Application Engineer

• - Large mail order business shipping medications and supplies to over 1 million repeat customers. Responsible for the management of a large OLTP database system running MSSQL 2000 and 2005 that provided data for real time order entry applications designed to create, process, and ship customer orders. Other responsibilities included the creation and support of data processes passing data between the companies billing system running AS400 and SQL server databases. On call duties to provide 24x7 DBA support. Performed SQL server installations and upgrades.
• - Extensive knowledge of SQL jobs, DTS transformations from multiple platforms, Stored Procedures, User Defined Functions, etc.
• - Replication of the OLTP databases to create a separate reporting environment. Performed SQL server installations and upgrades.
• - Converted over 100 DTS packages to SSIS for upgrades to SQL Server 2005
• - On call duties to provide 24x7 DBA support.

Confidential

Senior Application Engineer

• - Redesign of Customer Information System for call center support using Visual Basic 6.0. Application integrated with Genesys Call Center platform and was used to create outbound campaigns, process and ship orders to customers. Project involved architecture of current system in Microsoft Visio, designing Business Object Layer and front end applications. Implemented new system without disruption to call center support. Redesign improved application performance enabling call center to handle more call volume.
• - Designed web version on internal intranet of Customer Information System for use in looking up customer/patient/doctor information for call center management using ASP.NET.
• - Conversions of multiple applications from VB 6.0 and Access to VB.Net
• - Developed application for diabetic kit testing process through mail using VB.NET and SQL Server 2005. Bar code scanning technology used for maximized processing.

Confidential

Senior Application Engineer

• - Designed highly recognized client server application for investment tracking and contact management using Visual Basic 6.0 and SQL Server 7.0. Project involved meeting with users writing technical specification documentation, and designing application. Duties included managing bug and feature requests using CA 2E Change Management.
• - Created Institutional Workstation for the tracking of Salesmen clients for stock market Holdings and Interests as well as keeping track of Conferencing, Products, Research and Entitlements.
• - Construct, design and implementation of objects for enhancement of application
• - Developed wrapper for use of Crystal Reports 8.0 in application. Created all reports for application.
• - Development of SQL database tables, views, stored procedures, triggers and User Defined Functions.
• - Created DLLs and OCX controls to easily maintain application interface and reuse existing functionality.
• - Problem-solved hardware issues with fault-tolerant hard drives.
• - Manage all source code for department using Visual Source Safe 6.0

Confidential

Application Engineer

• - Developed custom application using VBA and Microsoft Exchange Server
• - Application allows end users to create multiple types of requests that route to the proper management, helpdesk or end-user personnel
• - Assisted in development of routing process that is sent through company network to the proper end-user, helpdesk or management personnel to accept or reject user request
• - Created NT Service to periodically read contents of Exchange public folder to load data into SQL Server database. Service was created for reporting engine.

Confidential

• - Completed intensive program consisting of 780 hours 13 weeks of programming in Visual Basic 6.0, SQL Server 6.5 and Visual InterDev 6.0.
• - Visual Basic Skills Set: Active X Controls, Active X Documents, Active X Components, Windows API, DAO, RDO, ADO, ODBC API, COM, DCOM, and MTS.
• - SQL Server Skills Set: ANSI SQL, Transact-SQL Queries, Indexes and Views Transactions, Batches, Cursors, Stored Procedures, Triggers and Replication.
• - Internet Development using Microsoft Active X Technology.
• - Web Site Development Using Visual InterDev: HTML, DHTML, ASP, VB Script and Java Script.