Post Job Free

Resume

Sign in

Project Sql

Location:
Houston, TX
Salary:
75000
Posted:
November 18, 2014

Contact this candidate

Resume:

PATRICK GREEN

acgrr8@r.postjobfree.com

832-***-**** (phone)

* *******

Nineteen years of Programmer/System Analyst experience throughout the full

life cycle of software development: requirements analysis, project

analysis, front-end application design, relational database design,

software training, technical documentation writing, project implementation

and production support. Proven strengths include application programming,

communication of technical design aspects to supervisors, and communication

of solutions to end users in a help desk or troubleshooting situation.

2 PROFESSIONAL EXPERIENCE

Powell Industries, Inc., Houston, TX 11/2009

- 11/2013

1 Programmer II

Designed and modified .NET applications with embedded SQL which ran against

Oracle, SQL Server and Access databases. Wrote SQL scripts to import and

export data from Access database to Oracle database. Wrote SQL scripts to

create database tables and triggers, to populate tables. Wrote SQL scripts,

which generated reports and spreadsheets. Designed and modified software in

AutoLISP, PL/SQL, Visual Basic and C# and VB6 to run in conjunction with

AutoCAD which was used by electrical engineers to design and track

electronic equipment. Also designed .NET applications for other departments

such as sales and the printing department. Instructed users on new

applications.

. Four years of experience with AutoCAD, VB.NET, VB6, C#, Oracle,

SQLDeveloper, SQL Server, TOAD, Visual Studio (C#, VB.NET, VB6),

Microsoft Office Suite (Word, Excel, Access, PowerPoint, Project).

Various Contractors, Houston, TX 3/2008 -

10/2009

Working for different temporary agencies.

ChaseCom, Inc., Houston, TX 3/2007-

12/2007

2 TECH SUPPORT ANALYST

Assist customers with installation and registration of DSL service as well

as troubleshoot connectivity issues.

. Experience using proprietary software to install and register users as

well as diagnose customer problems with DSL service over the phone.

. Provided technical support for applications to customers, answered

questions on function and usage of product.

. Handled client calls and issues involving moderately complex technical

issues.

. Helped maintain MS Access database and Excel spreadsheets used to

generate reports on system metrics.

CACI, Inc., New Orleans, LA 10/2000 -

12/2005

3 APPLICATION SYSTEMS ANALYST PROGRAMMER, Lead

Designed, developed, and modified reports and application programs as part

of a Department of Defense contract, primarily for the U.S. Navy and Naval

Reserves. Designed interface between RHS and RSTARS (HP) systems. Created

SQL scripts to import and export data. Wrote PL/SQL programs to create

database tables, indexes, views and triggers, to populate tables and to

transmit data to other systems. Converted mainframe applications to both

.NET and Java client server configurations. Worked in role of Production

Support, providing users with instructions on applications and

troubleshooting problems with end users.

. Five years of experience with VAX Basic, Microsoft Office Suite (Word,

Excel, Access, PowerPoint, Project).

. Four years of experience with VAX and ALPHA mainframes programming JCL

scripts.

. Five years of experience with Oracle, PL/SQL, TOAD, embedded SQL and

interactive scripts files run against database (SQL Plus).

. Four years of experience with SQLServer (2000 and 2005) maintaining

legacy database, designing new database, creating and modifying tables

and indexes, creating script files, triggers, views on tables and

roles on database, setting up security restrictions on database.

. Five years of experience Team Win and Team Developer (used to develop

embedded SQL applications).

. Three years of experience with Java and web based technologies (XML,

HTML, JDeveloper, JCreator, NetBeans, Ant, WinCVS, Sun Java

Application Server, Oracle Application Server).

. Two years of experience with Microsoft Visual Studio (C#, C++, Visual

Basic, SQLServer, .NET framework).

CDSI/ACS, New Orleans, LA 2/1998 -

10/2000

4 PROGRAMMER/ANALYST

Designed, developed, and modified reports and applications for the United

States Navy Reserve Personnel and Manpower systems. Produced reports using

SQL scripts and PL/SQL. Designed conversion programs to translate client's

existing data files to conform to new record layouts. Developed SQL

queries, Access applications, and Excel macros to automate manual reports.

Worked on Y2K-compliancy issues. Worked in role of Production Support,

providing users with instructions on applications and troubleshooting

problems with end users.

. Two years of experience with VAX and ALPHA mainframes programming

interactive scripts.

. Two years of experience with VAX Basic, Microsoft Office Suite (Word,

Excel, Access, PowerPoint, Project).

. Two years of experience with Oracle, PL/SQL, TOAD, embedded SQL and

interactive scripts files run against database (SQL Plus).

AMERICAN MANAGEMENT SYSTEMS, New Orleans, LA 7/1996 - 2/1998

5 PROGRAMMER/ANALYST

Developed and modified reports and application programs for the USDA.

Developed and modified COBOL programs to provide enhancements and

customizations per client specifications. Wrote SQL scripts and Access

applications to import and export data. Researched and performed

project design, analysis and development for Visual BASIC, Access and

Oracle databases. Worked in role of Production Support, providing

users with instructions on applications and troubleshooting problems

with end users.

. Two years of experience with COBOL programming and JCL scripting.

. Two years of experience with Oracle, PL/SQL, embedded SQL and

interactive scripts files run against database (SQL Plus).

. Two years of experience with Microsoft Office Suite (Word, Excel,

Access, PowerPoint, and Project).

SYSTEMS ENGINEERING & MANAGEMENT ASSOCIATES, New Orleans, LA 5/1994 -

7/1996

PROGRAMMER/ANALYST

Developed, maintained and tested application software, reports and user

interfaces for the Reserve Headquarters Support System, one of the United

States Navy Reserve Personnel and Manpower systems, using SmartStar and VAX

BASIC as a host language for SQL on a VAX/VMS operating system. Developed

application software to interface with other systems and perform data

transfer, including logging any attempts to access each system, which also

served as feedback to other processes. Worked in role of Production

Support, providing users with instructions on applications and

troubleshooting problems with end users.

. Two years of experience with SmartStar, ShareBase and VAX BASIC.

. Two years of experience with Oracle, PL/SQL, embedded SQL and

interactive scripts files run against database (SQL Plus).

. Two years of experience with JCL scripting.

. Two years of experience writing scripts on VAX mainframe to automate

data processing.

. Two years of experience with Microsoft Office Suite (Word, Excel,

Access, PowerPoint, and Project).

USL ACIM CENTER, Lafayette, LA 12/1992 -

5/1994

RESEARCH CONSULTANT

Researched, designed and implemented graphical presentation packages mainly

for use in secondary educational settings. Developed presentation packages

to show how elements of virtual reality could enhance presentations.

Developed and implemented flight simulator software. Developed a virtual

reality model of the solar system. Developed CAD simulation of factory,

including interfaces to study OSCHA related data. Developed a 3D fly-

through of the university campus. Developed routines to dissect virtual

reality applications for storage and retrieval from relational databases.

. Two years of experience with CAD software.

. Two years of experience with Showcase and ALIAS (3D modeling and

rendering applications).

. Two years of experience with Oracle, PL/SQL, TOAD, and interactive

scripts files run against database (SQL Plus).

USL COMPUTING CENTER, Lafayette, LA 9/1989 -

12/1992

COMPUTER OPERATOR

Performed mainframe system backups. Printed secure forms (tests, financial

reports, grades, etc). Advised computer users in computer lab.

. Four years of experience with Honeywell 68/80 (Multics and Level 6)

and the IBM 3090 (MVSXA and VMXASP) running Jes2 Operating System.

. Four years of experience working on Pyramid 90X running UNIX OSx

Release 4.1 and Sun Sparc 490 running SunOS Release 4.1.1.

. Four years of experience printing forms on XEROX 4050 Laser and IBM

4245.

EDUCATION

Bachelor of Science Degree in Computer Science, Minor in Business

University of Southwestern Louisiana

EMPLOYER SPONSERED EDUCATION

Oracle Developer, SQLForms, PL/SQL, Technical development courses

3 TECHNICAL SKILLS

4

5 Hardware

Client Server: Personal Computers, Silicon Graphics workstations

(Onyx, Indigo and Extreme2)

Mainframe/VAX: UNIX, IBM 9370, DEC ALPHA Cluster, PC 3270 Workstation,

IBM printer 4370, DEC VAX Cluster 8530/8700,

Honeywell 68/80 (Multics and Level 6), IBM 3090 (MVSXA and VMXASP)

6 Operating Systems

Client Server: Microsoft Windows 7, Microsoft Windows XP, Microsoft

Windows-2000, 98 and 95, Microsoft Windows-NT, MS/DOS, Minix

Mainframe/VAX: IBM MVX/XASP, CICS, Pyramid, VM/SP, VM/CMS, VAX/VMS,

ALPHA OPEN, Jes2

7 Software

Client Server: Microsoft Visual Studio, .NET Framework 3.0, 3.5, 4.0,

4.5, Microsoft Word, Excel, Access, PowerPoint, Outlook, Project,

LINDO, SAS, NROFF, TROFF,

VISIO, SQLWin, TeamWin, TeamDeveloper, Netbeans, JCreator, JDeveloper,

Ant, GroupWise, WinCVS, Sun Java Application Server, Showcase, ALIAS,

POV-Ray for Windows, Oracle Application Server, Sun Java Application

Server

Mainframe/VAX: Oracle Developer Forms, Oracle Developer Reports,

SmartStar, MS/CMS, XEDIT, DCF Script

Programming Languages

Client Server: Visual Basic, Access, SQL, JCL, DCL, Oracle Developer

Forms, C++, Pascal, LISP, Scheme, Java, XML, C#, VB6, VB.NET, HTML

Mainframe/VAX: COBOL, VAX BASIC, JCL, DCL, SAS, C++, PL/SQL

8 Database

Client Server: ORACLE (11i, 10g, 9i, 8 and 7), TOAD, SQLServer,

Microsoft SQL Enterprise Manager, Microsoft Query Analyzer, Access

9 Mainframe/VAX: ORACLE, Sharebase, Superbase



Contact this candidate