Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Las Vegas, NV
Salary:
83,000
Posted:
August 30, 2014

Contact this candidate

Resume:

Brian Quinn

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

Avenue

Las Vegas, NV

89145

Mobile Phone: +1-518-***-****

Email: acfoj2@r.postjobfree.com

Professional Summary:

. 7 Years of experience in the IT industry with the .NET Framework using

MVC 4, HTML5, C#.NET, VB.NET, ASP.NET, WCF, XML Web Services, ADO.NET,

LINQ, JQuery, VB6.0 and other Microsoft Technologies

. Experience in working with WCF, WPF, LINQ to SQL, ADO.Net Entity

classes Framework (ORM), Model View Controller Framework (MVC),

ASP.Net and VB6.0.

. Additional object oriented experience in designing/developing web and

console applications using JSP, Java, HTML5 and Open XML, CSS,

JavaScript, JSON, JQuery and Ajax

. 25 years of experience in designing and developing applications in

distributed environments.

. Experience of generating various reports using SQL Reporting Services

and Crystal Reports.

. Strong in Object Oriented Analysis and Design (OOAD) and UML concepts.

. Expertise in database design and programming using SQL Server

2005/2008, Oracle 11g, Microsoft Access, SQL (Stored Procedures and

Triggers) and DB2.

. Experience with building databases using SQL Server Management tools

(T-SQL, Stored Procedures) and TOAD for Oracle including developing

packages and stored procedures with SSIS/DTS.

. Used the waterfall and agile development and similar project task

development methodologies.

. Experience coding with different browsers (IE, Firefox, Chrome).

. Expertise in trouble-shooting and problem solving with proven ability

to design and develop reliable data driven applications.

. Effective in working independently and collaboratively in teams.

. Willingness to learn new concepts and ability to articulate

alternative solutions and reasoning behind the alternatives.

. Ability to work independently as well as in team. Highly organized

with excellent oral and written communication skills

Technical Summary:

Languages: C#.Net, VB.Net, ASP.Net, ADO.Net, MVC, Web Services,

Windows Services, C, T-SQL, Visual Basic, PL/SQL,,

JSP, Java classes, J2EE beans, COBOL, CICS, JCL

Databases: SQL Server 2005/2008, Oracle 11g, DB2, MS Access

BI Tools: SQL Server Integrated Services (SSIS), SQL Server Reporting

Services (SSRS), Crystal Reports

Web Technologies: HTML5, XML, Open XML, XSL, CSS, JavaScript, AJAX,

DHTML, JQuery, JSON

Middle Tier: Web Services, WCF

Web Servers: Microsoft IIS, Apache Tomcat, Glassfish,

Operating System: Windows Server 2000/2003, Windows NT/98/XP/Vista/7

Other Tools: Visual Studio, J Developer, Eclipse, TFS, Crystal Report,

MS-Project, MS Visio, MS Office Tools (Word, Excel

etc.), Data Architect, Entity Data Model.

Professional Experience:

Client: Brian Quinn- IT Contracting Business Development

07/01/2014 - Present

. Projects

o Developing a contract requirement evaluation application that

will allow customized weighted criteria for focusing on highest

ROI and professional goal to business plan. The environment

included MVC 4 using HTML5, C#.NET, LINQ, JavaScript, JSON,

Ajax, CSS 4, entity framework for data in SQL Server 2012 with T-

SQL and data from Oracle using web services by HTTP

request/response as ASYNC calls,

o Developing SOA HTTP request/response services to handle data

requests from Oracle stored procedures. The technical

environment includes ASP.NET Web Api with HTTP GET/PUT/POST

request/responses focused on JSON data handling. The database is

Oracle 11g and all in stored procedures returning data in

SYS_REFCURSOR.

Client: U-Haul - Brian Quinn - IT Contracting Business Development

03/15/2014 - 7/1/2014

. Projects

o Developed an ACH and check processing web application for an

accounting department. The environment included MVC 4 using

HTML5, C#.NET, LINQ, JavaScript, JSON, Ajax, CSS 4 and SQL

Server 2008 R2 with T-SQL and Oracle,

Client: HP - Brian Quinn - IT Contracting Business Development

10/01/2013 - 02/21/2014

. Projects

o Converting an contract job requirement tracking application from

ASP.NET web forms to MVC 4 using HTML5, C#.NET, LINQ,

JavaScript, JSON, Ajax, CSS 4 and SQL Server 2008 R2 with T-SQL,

TDD and MOQ,

o Developed an e-Commerce store web application in MVC4 with

HTML5, LINQ, injection, CSS 4, SQL Server 2008 R2 through a data

repository, TDD and MOQ.

o Developed Java applications in Eclipse

. Java web application features using HTML5

. GUI games such as Breakout with interactive graphics on a

canvas

. GUI interactive social site application with forms and

pictures on a canvas

Client: Clark County Assessor - IT Strategies/Q Squared IT - Appeal

Processing - Web App .NET

03/21/2011 - 09/01/2013

. Developed and enhanced an appeal processing web application for

appraising and assessing parcel and personal property within the

county.

. Project tasks included requirements gathering, relational database

design in Oracle, data analysis, business analysis, OO design and

class construction, ASP.NET and HTML5 form interface design and

coding, C#.NET class method, .NET/Oracle interfaces and data adapter

usage, web service usage, .NET reporting, JavaScript, archiving to SQL

Server using stored procedures with T-SQL and more.

. All project work was managed using an informal approach as the client

did not have a formal methodology currently in use. Initial publish of

the .NET web app was done in December with follow up published version

since.

. All development and testing was done in Visual Studio 2008 using

Oracle TOAD to create Oracle database tables, load data and track

updates. All documentation was provided including a design document,

data administration documents and test documents.

Client: BCBS - UPP Technology/Q Squared IT - Healthcare Code Processing -

Legacy

09/21/2010 - 03/02/2011

. Participated in the enhancement of a healthcare application.

. Project participation included researching of medical code processing,

documentation and coding in COBOL with SQL for DB2 tables.

. All project work was managed using AGILE methodology including a daily

SCRUM and STORY/TASK deliverables.

. In addition I worked on my contracting business accounting web

applications written in Java JSP using Oracle JDeveloper with PL/SQL

to add stored procedures and registered web services while consuming

those services in .NET web applications through Crystal Reports and

XML document objects.

Client: ACS - TRG/Net2Source/Q Squared IT - Virginia DMAS Medicaid Web

Portal

01/15/2010 - 07/02/2010

. Participated in the development of a Medicaid Web Portal for the

Virginia DMAS.

. Project participation included researching of Medicaid processing,

documentation, coding in SQL for DB2 tables, Java, COBOL/CICS MMIS

code.

. Heavy use of service category procedure/modifier in claims processing,

eligibility and plan limits. Data requests from DB2 converted to XML

via COBOL modules moved to the server.

. Developed a contracting business accounting web applications written

in Java JSP using Oracle JDeveloper, PL/SQL, XML and AQ Messaging.

Client: Q Squared-IT Contract Services

02/02/2009 - 12/30/2009

. Accounting, Training & Administration for Consulting Firm, Sr.

Analyst/Developer

. Developed and maintained accounting web applications using Java (JSP,

Java Beans and EJB (Diagram JPA, Entities, Web Services) Oracle (SQL,

PL/SQL Procedures), XML and more. Occasional light ADF Swing

application built.

. Projects include job tracking, employee time entry (XML data exchange

between Java web app and .NET web app), web application enhancements,

a training web app that utilizes database components through stored

procedures. Software for this project includes ASP.NET with C#.NET,

XML, XPATH and XSLT. Database tool is SQL Server 2008 with T-SQL and

stored procedures.

. Developed applications using Visual Studio 2008 and JDeveloper. Create

and maintain test plans with loaded or edited test data. Execute tests

using JDeveloper IDE debug and Visual Studio 2008 IDE debug tools.

Middleware server for Java run time is WEBLOGIC and/or Glass Fish.

Server software for .NET deployment is MS IIS.

. Some experience with deployment to a server on a single machine with a

virtual directory. Some experience with server environments settings

for nodes and managed servers.

. Some experience with security via administrative tools and relational

database security database stores.

. Some light experience using Oracle AQ Messaging and as part of the

time entry application will utilize XML Java API Transforms

serializing/de-serializing XML to AQ Messages and calling data

requests methods to update Oracle table data from AQ messages.

Client: Q Squared-AFLAC

12/01-2008 - 02/01/2009

. Supported an insurance application as a Sr. Analyst/Developer

. Converted and staged IBM JCL and PROCS as part of the groundwork for a

legacy system test environment for insurance application systems

supported by AFLAC.

Client: Q Squared-NY State-DMV-Albany, NY

05/01/2008 - 11/31/2008

. Participated in a Govt/Educ-Administration project as a Sr.

Analyst/Developer

. As part of a team using an SOA approach performed analysis of current

DMV licensing applications

. Designed and coded data request modules in COBOL, CICS and DB2/SQL to

maintain client name and addresses.

. Assisted in a data conversion from VSAM to DB2 and address validation

software procurement in compliance with US Postal Services standards.

. Set up batch testing using JCL, PROCS, VSAM, CICS and DB2 tables.

. Enhanced a training web based intranet application using ASP.NET,

C#.NET, XML, XSLT, SQL Server 2008 and Visual Studio 2008.

. Created and maintained test plans and loaded test data. . Created and

maintained test plans and loaded test data Executed tests using

XPEDITER mainframe debug and Visual Studio 2008 IDE debug tools.

Q Squared-Clearwater, FL

01/02/2008 - 04/30/2008

. Participated in the support of a Retail-Invoicing application as a Sr.

Analyst/Developer

. Developed a customer website application for a drinking water company.

. Developed a contract job tracking website application.

. Technology used included Visual Studio 2005, SQL Server databases and

remote device (Pocket PC, Smart Phone) tools.

. Software languages include C#.NET, ASP.NET, VB.NET, XML, UNIX-AIX,

Java (JSP, Java Classes), XML and COBOL. Created and maintained test

plans and loaded test data. Executed tests using Visual Studio 2008

IDE debug tools.

Client: Q Squared-Health Plan Services-Tampa, FL

01/02/2007 - 12/20/2007

. Supported a healthcare-administration application as a Sr.

Analyst/Developer

. Developed and enhanced Accounts Receivable transactions for a health

care related business. Maintained billing processes and separated

carrier specific batch processing.

. Modified criteria to cancel health care policies for companies based

on outstanding past due versus acceptable minimum payment.

. Tools used included COBOL, SQL (DB2), CICS, JCL/PROCS and utilities,

Endeavor and VSAM. Some work was done on a server included MICROFOCUS

COBOL for HP UNIX-AIX, RM/COBOL for Windows, Interactive Forms/Panels,

TOAD for Oracle and script execution.

. Soft skills included data design and mapping, module specification,

script specification, schedules, plans and more. An off-site in-house

project included web development in ASP.NET, VB.NET, XML, SQL Server

2005 and Visual Studio 2005.

. Created and maintained test plans and loaded test data Created and

maintained test plans and loaded test data Executed tests using

XPEDITER mainframe debug and Visual Studio 2008 IDE debug tools

Client: Q Squared-Grocers Supply-Houston, TX

11/01/2005 - 11/01/2006

. Supported a Retail-Accounts Receivable application as a Sr.

Analyst/Developer

. Developed various Finance and Accounting systems using COBOL2, DB2,

VSAM, CICS, IBM JCL utilities, File-Aid, XPEDITER, MS Visio, MS

Project Manager and more for a Wholesale Distribution company.

Applications included Accounts Receivable automated payment posting,

account settlement and reporting.

. Enhanced Bank Note payments applying interest and updating balances

for payments.

. Trained in web development in Java, JSP, HTML, XML, Java Servlets, SQL

Server 2000, MS Access and MS VB6.0.

. Created and maintained test plans and loaded test data Created and

maintained test plans and loaded test data Executed tests using

XPEDITER mainframe debug and VB6.0 IDE debug tools.

Client: Q Squared-Legacy Subcontracts Various locations, USA

11/01/1988 - 04/01/2005

. Starting as a Jr. Developer thru the years up to a Sr.

Analyst/Developer travelled and aided clients in business application

development of legacy systems.

. Supported and enhanced various applications including public

sector/government, healthcare, billing, payroll, employee benefits,

general accounting, risk management, order entry, purchasing, payroll,

401K loans, vendor ledger and more using software such as COBOL, DB2,

VSAM, JCL, CICS and VB6.0.

. Gathered requirements, designed, coded, created and tested.

. Code migration tools included XPEDITER/INTERTEST, MICROFOCUS COBOL and

more



Contact this candidate