Engineer Sql Server

J ane Gwin

H om e P ho n e: ( * **) * **- * * ** Email: abnplr@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Over twenty years of system development experience on different platforms with various

programming languages resulting in successful project implementations:

• 9 years of EDI (Electronic Data Interchange) Interface experience with SeeBeyond eGate in

both HL7 and X12

• 7 years of experience with Cerner Millennium Systems in both Interface, Cerner Command

Language (CCL), custom reports, smart templates, custom label programs (2D armband and

pharmacy)

• 8 years of combined experience with C/C++ and SQL with various databases such as SQL

Server, ORACLE, SYBASE, INFORMIX, MS Access, Internet/Web application development

experience with Cold Fusion, Java Scripts, Perl/CGI and HTML

TECHNICAL SUMMARY

Software

OpenVMS V7.3-2, e*Gate 5.0.5 SRE;

Cerner Millennium, Windows XP;

UNIX, AIX, VM/IS, AOS/VS, Windows NT, Windows 2000;

UNIX C/C++, MS Visual C++, MS Visual Basic, ColdFusion, JavaScripts, Perl/CGI, HTML;

ESQL/C, C, PL/I, COBOL, PASCAL, JCL, ASSEMBLY;

SQL Server, ORACLE, INFORMIX, SYBASE, MS Access, Paradox, SQR;

Hardware

Alpha, SUN/Solaris, SUN/OS, HP-UX, IBM RS/6000, IBM 9375, DG MV7800, IBM Mainframe,

PC.

PROFESSIONAL EXPERIENCE

Seattle Children’s Seattle, WA

Jul 2008 – May 2009

Sr. Integration Engineer

Designed, developed Cerner Interfaces, CCL (Cerner Command Language) scripts. Wrote and

implemented Java code for HL7 SeeBeyond eGate System. (Electronic Data Interchange, SRE

5.0.5) Completed training in eGate Java Introduction. Worked with environments such as IBM

AIX, EPIC, Windows XP, NT Server, Oracle database, and SQL Server.

Evergreen Healthcare Kirkland, WA

Jan 2002 - Jul 2008

Sr. Systems/Program Analyst

Designed, developed and maintained Cerner Interfaces, Smart Template, Layout Builder, CCL

(Cerner Command Language) scripts, custom reports, and custom label programs (2D armband

and pharmacy). Enhanced system performance by modifying developed Cerner programs.

Wrote and implemented Monk code for HL7 and X12, Claims, Remittances, Account Payable, and

General Ledger to PeopleSoft using SeeBeyond eGate System. Modified and Maintained XML

(Perl script) feed for JCAHO. Worked with environments such as OpenVMS, Windows XP, NT

Server, Oracle database, and SQL Server. Completed training in PeopleSoft PeopleTools I & II

Accelerated certification and Cerner Millennium basic, CCL, Open Port and Open Engine.

PhyCom Corporation Kirkland, WA

Sep 1999 - Sep 2001

Software Developer

Enhanced and implemented case management application using Visual C++/MFC, SQL, Rogue

Wave Tools.h++, DBTools and Visual Basic. Wrote and implemented store procedures, triggers in

PL/SQL. Wrote and implement Monk code (COM/DCOM) for Authorization, Provider and Case

event using SeeBeyond eGate System. Worked with environments such as Windows NT, NT

Server, SQL Server, Sybase, Oracle database and Perl. Completed training in XML, COM and

Palm.

AT&T Wireless Services Redmond, WA

Feb 1998 - Aug 1999

Developer/Analyst

Managed, enhanced and implemented an OLTP client server application using Visual C++/MFC,

SQL and stored procedures. Developed and implemented client server Intranet/Internet

applications using ColdFusion, JavaScripts, Perl, CGI and HTML. Wrote UNIX/C to develop and

implement Open Client code and to communicate with IBM MQ using API calls. Work

environment includes: Windows NT/HP-UX platform, Sybase database and MS Access jet engine.

Armature Inc. Bothell, WA

May 1996 - Feb 1998

Software Engineer

Designed, implemented and tested classes for class library using C++. Created HTML

documentation. Wrote ESQL/C programs to validate inserts, deletes, and updates of tables to the

database. Using the following environments, Rogue Wave Tools.h++, DBTools, SPAR Compiler

C++ 4.1, SUN/OS v5.5, INFORMIX Dynamic On-line v7.1. Received training in Building

Distributed Applications with Orbix and CORBA and, Series 3000 programming Environment

Course from Symbol.

Electronic Data Systems Kirkland, WA

Jun 1995 - Apr 1996

Systems Engineer

Worked on AT&T Wireless Services account. Involved with three projects: Messaging Universal

Gateway, Billing On Behalf Of, and Fraud Visibility using: UNIX C, store procedures (SQL), SQR,

MS Visual Basic and MS Visual C++ within SUN/OS v5.4, HP/UX, SYBASE v10, SQR

environment.

Sisters Of Providence Seattle, WA

Dec 1991 - May 1995

Systems Analyst

Solely responsible for the migration of entire corporate applications from IBM 9375 VM/IS

ORACLE v6 to IBM RS/6000 AIX ( UNIX ) ORACLE v7, SQL*Forms v2.3 to SQL*Forms v3, SQR

and keyboard mapping. Established communication between PC, HP printers and RS/6000.

Converted ORACLE SQL*ReportWriter programs to SQR Report Writer. Designed, created and

maintained MS Access applications. Worked with C, COBOL, Excel, Paradox, WordPerfect and

user support.

RHO Redmond, WA

May 1991 – Oct 1991

Information Programmer Analyst

Contract employment for Microsoft. Created, implemented and maintained SQL and SQR

programs to access Aspect database and generate reports for Product Support Services. (SQL

Server, MS Windows, DOS and OS/2 environment)

Philips Consumer Electronics Company Greeneville, TN

Oct 1987 - Mar 1990

Systems Programmer

Created, implemented, enhanced and maintained PL/I programs on a real time manufacturing

data collection system (The system collected data and stored it into an INFOS II hierarchical

database, displayed real time data processing information). Maintained communication between

LTX, GenRad and Data General MV7800 AOS/VS. Analyzed and fixed problems associated with

monitors, Intermec wands, bar code readers and port concentrators. Converted PL/I to C and

INFOS II to Oracle.

Jun 1986 - Aug 1986

MIS Programmer (Co-op)

Wrote, implemented and enhanced COBOL programs related to sales, purchasing and salary.

Worked with IBM 3083 and IBM 3090 (DOS/VSE environment).

EDUCATION

Java 2 programming Certificate, University of Washington, 2004

C programming Certificate, University of Washington, 1997

Bachelor of Science in Computer Science with a Mathematics minor from

East Tennessee State University, 1987 (Magna Cum Laude, 375/4.0)

HOBBIES AND INTERESTS

REFERENCES

Contact this candidate