Sql Server Developer
Resume:
Brian Quinn
Avenue
Las Vegas, NV
89145
Mobile Phone: +1-518-***-****
Email: **********@*****.***
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