Sql Server Quality Assurance

Nikolaos Seitz

Information Technology Professional

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

Enola, PA 17025

Phone:717-***-****

Email:*******@*****.***

Technical Skills

Internet Technologies:

HTML,XHTML,JAVASCRIPT, DOM, AJAX, PHP

Database Technologies:

ANSI SQL, PL/SQL, MS SQL Server, Oracle, DB2, MySQL

JAVA Technologies:

JAVA, JSP/Servlets, Apache Struts, JSF, ICEfaces, Spring MVC Framework, JPA/Hibernate, ANT, xDoclet, LOG4J,

Junit, Seam

XML Technologies:

XML, XSL-FO, XSLT,

Scripting Languages:

ColdFusion(CFML),PERL

Integated Development Environments:

IBM Rational Application Developer, Eclipse, Oracle Jdeveloper, DreamWeaver

Application Platforms:

IBM Websphere Server, IBM Websphere Portal, Oracle Application Server, Sybase Application Server, Jboss, Jetty,

Resin, Tomcat, ColdFusion Server

Experience

Helioss

2010-2011

This postion had me managing an assisting development of projects through the Software Development Life Cycle (SDLC). I acted

as both junior software architect and senior user experience designer aligning the business needs of the customer with web based

JAVA solutions. I was in charge of quality assurance, code review, and application deployment.

Northeastern Executive Group

United Concordia Customer Facing Systems Highmark Subcontract

2010

In this position I was placed on the task of building a UI for the login screens of the public facing website to the detailed spec of the

client. I was to use Java Server Faces(JSF) on the IBM Web Sphere development platform. The middle tier used Hibernate and JPA

to expose the data to the front end. Programed logic for multi-role login screens that used modern JavaScript single page

navigation. Completed the task ahead of schedule.

Glatfelter Insurance Group

Client Facing Systems Division

2009-2010

Hiredd as a software architect to build a web based system to generate documents from an AS400 data store and a MS SQL

Server data warehouse. The system was built atop the IBM Websphere platform and uses an Oracle database backend. The user

interface is built with JSF and uses the ICEfaces component library to implement push pull AJAX. The documents are rendered

using XSLT, Apache FOP and XSL-FO templates which are stored in the Oracle database.

E&E IT Consulting

Administrative Offices of the Pennsylvania Courts (AOPC)

2007-2009

Common Pleas Court Management System (CPCMS)

J2EE development, Sybase Enterprise Application Server 5.5, Sybase Database backend

Project/Team management

Middle Tier Development using Eclipse

Refactored and optimized existing code using custom JAVA framework

Developed asynchronous logging service framework

Independently developed browser based testing suite in JSF to unit test EJB output

Created ANT scripts for all deployment tasks

Worked with the team to upgrade from Sybase Enterprise Application Server 5.2 to version 5.5

Working with team to update code to leverage JAVA 5 in the existing framework

Drafted design, installation, and usage documents for all projects mentioned

Ciber Inc

Department of Environmental Protection

2006 - 2007

Continuous Emissions Monitoring Data Processing System CEMDPS

JAVA, Oracle 10g, PL/SQL, JSP, Apache Struts, XHTML, XML, Web Services, SOAP

Development of Apache Struts web applications from concept to rollout

Used JAVA, XSQL, XML, XSL-FO, XSLT,FOP to archive sensitive legal documents

Used XML and Oracle XDK to migrate and synchronize Oracle 10g to MS-SQL Server and MS-Access Databases

Created graphic interfaces and layouts using Adobe Photoshop, CSS, Oracle JDeveloper

Nittany Link Inc

1997 - 2004

Developed data driven websites using HTML/ DHTML/JAVASCRIPT, PERL, PHP, SQL

Project Management/Business Analysis

Designed relational databases in Microsoft SQL Server and MySQL

Created graphic interfaces and layouts using Adobe Photoshop/Illustrator, Dreamweaver, Flash

Served as consultant, systems analyst and business analyst

Provided training, support and documentation to end users

Performed back office duties including drafting contracts and budgets

Worked directly with Non-profit Organizations

Pennsylvania Department of Health Bureau of Information Technology

2003 - 2004

Women Infants and Children WIC

Migrated Legacy Reporting to Crystal Reports

Migrated DB2 schema's to Microsoft SQL server

Created Stored Procedures to report data from the State’s relational Database to a Federal Legacy Mainframe

Wrote SQL analysis tools to eliminate redundancy and duplicate entry

Redesigned legacy reports to make more exacting measurements with available data

Revamped and corrected errors in reporting found in legacy reports

Eliminated reports that were no longer relevant to operations

Redesigned database topology to ensure data integrity for historical data

Federal Communications Commission Bureau of Wireless Telecommunications

2000 - 2002

Applications Developer

Developed dynamic websites using HTML/ DHTML/JAVASCRIPT, PERL, ColdFusion, SQL

Worked extensively with Sybase and Oracle databases

Created graphic interfaces and layouts using Adobe Photoshop/Illustrator, Dreamweaver, Flash

Provided training, support and documentation

Education

BS, Business Administration

Concentrations Legal Studies and Management Information Systems (MIS)

Bloomsburg University, 1999

Java 5/ J2EE

New Horizons Java 5 J2EE Training, 2007

.NET

TATA Consultancy Services Hands on training, 2003

Enterprise ColdFusion Certification

Westlake Internet Training, 2000

Contact this candidate