Customer Service Sql Server

Daniel Dillon

***** * *** **********, ****** AZ *5749, ***.******@*******.*** 520-***-****

Background Summary

• Over 25 years of experience in application analysis, design, coding, testing and

implementation.

• Dedicated and self-motivated. Delivers quality results independently or in teams.

• Intimate knowledge of how systems work and what types of solutions work best

for different requirements and environments. Verified veracity of functional

requirements, processes, and designs.

• Provided outstanding service for business clients. Understands end-to-end

business processes and business needs. Worked closely with users to plan

projects and gather requirements.

• Instrumental in creating standards for the IT department including naming

conventions, field/file attribute recommendations, and code reviews and

recommendations.

• Experienced in all aspects of testing with both the user groups and IT QA groups

including writing test plans and creating test environments.

Specialties

• Database Analysis • C#

• Conversion Analysis, Design and Programming • Linux

• Microsoft Visual Studio • Java, Eclipse

• SQL Server Integrated Services (SSIS) • Code/400, Designer

• Microsoft SQL Server 2008 R2 • FTP, TCPIP

• Microsoft SQL Server Management Studio • Turnover, Aldon, Hawkeye

• Customer Service • DB2, OS400, Oracle

• Consultation • Word, Excel, Visio

• Business and Business Systems Analysis • Team Foundation Server (TFS)

• Sharepoint • Microsoft Windows

• RPG ILE on IBM iSeries, Interactive and Batch

Programming, Embedded SQL, Subfiles, ILE

Procedures, Modules and Service Programs.

Experience

Oct 2011 – Conversion Analyst – 3M – Tucson, AZ

Apr 2014

Worked as Conversion Lead for the Connecticut conversion effort related

to Licensed Drivers. Responsibilities included communications with the

client, leading meetings with the client that related to data mapping,

mapping data from the CT legacy systems to the 3M MVS product

(CIVLS) with the representative documentation and writing the programs

to transfer the data to CIVLS. Programs were developed using SSIS,

leaning heavily on SQL and C#. Traveled to CT to meet with client when

necessary.

Before the Connecticut project worked with Idaho DMV and a third party

vendor from 10/2011 to 2/2013 to map data from the vendor's data

staging area to our MVS system tables. The focus was on the first two

phases of the Idaho conversion effort as the lead conversion analyst.

Responsibilities included creating mapping and design documents from

which the vendor wrote the conversion code, validation of converted data

for integrity and accuracy, holding meetings and traveling to the Idaho

site to meet with client and vendors.

Mar 2011 – Programmer Analyst – Station Casinos – Las Vegas, NV

Jul 2011 Contracted at Station Casinos in Las Vegas as an iSeries expert. Worked

problem solving and maintenance in CMS (Casino Management

System). Mentored staff in strategies to increase application performance

related to IBM Midrange ILE strategies.

Feb1990 – Senior Programmer Analyst – Arizona Mail Order – Tucson, AZ

Nov 2010 Arizona Mail Order, a division of Orchard Brands, Inc.

(Formerly Crosstown Traders, a division of Charming Shoppes, Inc.)

• Main resource for all things related to direct-to-consumer Order

Management Systems.

• Data conversion analyst, designer, and coder in the conversion of more

than 6 business acquisitions.

• Performed design and programming work on all major systems of this

multi-channel business (websites, catalog, and retail stores), including

History, Distribution, Credit, Credit Authorization, Customer

Correspondence, Marketing, Merchandising, and Inventory Forecasting.

• Executed ongoing improvements for Order Management System,

including project management, program design, coding, testing and

implementation.

• One of six developers for Order Processing Rewrite (1994-1996).

• Analysis, design and coding for a complex interface from existing retail

systems to Crosstown iSeries back-end for four industry-leading websites

for Charming Shoppes, Inc. (2006).

Contact this candidate