Sr SAS Developer & Analyst

Email: t2vsi5@r.postjobfree.com

PROFILE/POSITION DESIRED

------------------------

Over fifteen years of IT experience with the systems development life cycle as a developer, database administrator, technical support analyst, and business analyst. Looking for a business analyst, developer

or Oracle DBA position.

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

ACTIVE TOP SECRET CLEARANCE ADJUDICATED 9/12/07

CERTIFICATIONS: Security+ Certification, Oracle Certified Professional (OCP) including 11g

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

IT SKILLS:

----------

Languages: PL/SQL, Stored Procedures, Oracle Forms, Java, C,

UNIX shell scripts, Natural, Easytrieve, EXECs, CLISTs

COBOL/ISPF, COBOL/CICS

DBMS: Oracle, DB2, XDB, IMS, IDMS, ADABAS

Toolkits/Utilities: SQL, SQL*Plus, SQL Developer, Data Modeler, Subversion CM,

JDK, J2EE, XML, QMF, TSO/ISPF, OS/MVS/JCL utilities

Operating Systems: UNIX (Solaris, HP), Linux, MS Windows, MVS, VM

Technical Support: Oracle Application Server, Apache, Glassfish, Oracle Forms,

Oracle database, HTML DB (Application Express)

WORK EXPERIENCE

---------------

Senior Systems Analyst / Oracle DBA (Consultant)

Colorado Professional Resources / SPARTA, Inc / Colorado Springs, CO (6/07-5/20/11)

-----------------------------------------------------------------------------------

Performed development work (for first two years) on space weather effect system for Air Force Space Command (AFSPC) which encompassed space weather models for decision analysis. System was multi-tiered, 24x7 system using Java, Oracle database, PL/SQL procedures, UNIX shell scripts.

Served last two years on project as the full-time DBA (Oracle 10g on Unix) responsible for development, test, and deployed instances of the database. Performed maintenance, testing, loading of data for developers, installs, upgrades, some table design, and implementation of information assurance controls.

Managed the packaging and installation of software releases from integration testing to production releases. Wrote installation manual for installing the application and 3rd party software. Taught developers and system administrator how to install the application, and taught testers how to run live simulation tests.

Technical Team Lead / Senior Technical Analyst / Senior Oracle DBA

Oracle Corporation / Colorado Springs, CO (5/98-6/07)

-------------------------------------------------------------------

Served as team lead and analyst in technical support role for the Oracle database customers for three years. Worked issues such as database crash analysis, database recoveries, and helped customers in diagnosing problems with database administration, utilities, SQL, etc.

Worked as production internal DBA for four years responsible for two large 24x7 worldwide databases. Installed application software releases, performed database upgrades, investigated application issues, general maintenance and administration.

Provided technical support of the Oracle Forms product (client server and web based) for two years. Required knowledge in the Developer tool kit, PL/SQL, Java Plug-ins, HTTP server and database.

Senior Programmer Analyst

Shepard's (now Lexis Nexis) / Colorado Springs, CO (8/96-5/98)

--------------------------------------------------------------

Performed development and maintenance work on client/server application that captures case law text for publishing. Involved analysis, design, coding using Oracle Developer 2000 (Forms 4.5)

with Oracle 7.3 database on UNIX. Coded Pro*COBOL, Pro*C, UNIX scripts, PL/SQL packages.

Designed and developed modules for the front end piece of a large reengineering project using UNIX, Pro*COBOL and PL/SQL packages. Coordinated coding efforts with team of consultants and managed integration testing.

Senior Consultant / Senior Systems Analyst

MCI Telecommunications (now Verizon Business) / Colorado Springs, CO (4/94-7/96)

--------------------------------------------------------------------------------

Coordinated a complete end-to-end test for systems sold to Stentor, MCI's Canadian alliance. Involved working with MCI managers, Stentor managers, Perot Systems team leads. Facilitated JAD sessions to develop a master test plan.

Led a technical test team to split MCI's order processing system into business and residential customers. Responsible for verifying the splitting of data residing in ADABAS, VSAM, and sequential files. Taught myself and team to code Easytrieve and Natural programs to verify results.

Worked on reengineering project to ship orders out to the local exchange companies via messaging. Involved analysis, database design, writing of specifications, coding using COBOL II/DB2 and background CICS within a three tiered data warehouse architecture. To relieve mainframe load, used MicroFocus COBOL and XDB during development.

Senior Systems Analyst

Federal Reserve Bank of New York / New York City, NY (4/87-7/89, 11/90-4/94)

----------------------------------------------------------------------------

Led a long-term project to purchase an imaging system to automate huge file room. Researched the market, evaluated vendors, developed business requirements, gave presentations to management, coordinated contract negotiations. Managed project through system implementation. Involved managing a budget, coordination and approval of several departments, and work with the system integrators to create customized specifications and database design. System selected was client server architecture using Gupta SQLWindows, Oracle 7.0 NLM database running on Novell 3.11.

Designed and implemented a report tracking system written in Oracle Forms using Oracle database. Included initial analysis, set up of test and production environments, database design, prototyping and implementation. Provided user guide and user training sessions.

Performed development work on a DB2 on-line system using CLISTs, ISPF Dialogue Manager, COBOL/DB2 programs.

Miscellaneous: Worked on various business analysis projects interviewing all levels of users, worked on help desk hotline for one year, developed a programming standards guide, performed systems testing, provided technical guidance and managed a small team of junior level programmers.

EDUCATION

--------

M.S. Computer Science with Database Systems Concentration (4.0/4.0)

Colorado Technical University, CO

Graduate of EDS (Electronic Data Systems) System Engineer Development Program

Three month full time programming training program followed by a few years on the job experience.

B.A. English (Magna Cum Laude)

Slippery Rock University, Slippery Rock, PA

A.S. Computer Science (Summa Cum Laude)

Community College of Allegheny County, Monroeville, PA

Contact this candidate