Oracle Sql

R sum for Arthur Minar

Experience Summary:

For over fifteen years, developed business applications using 8i, 9i and

10g versions of Oracle RDBMS and Oracle tools (SQL, PL/SQL, SQL*Loader,

etc) on both MS Windows and UNIX/Linux platforms. For three years,

developed business reports for MAXIMO using SQRibe/Brio reporting tools

(SQR 3.0 and SQR 4.0). For 12 months, developed financial applications

using PERL scripting language.

1 TECHNICAL SKILLS

Databases: Oracle 10g, Oracle 9i, Oracle 8i - SQL*PLUS, PL/SQL,

SQL*Loader,

Oracle Forms, Oracle Reports

Operating Systems: Windows (95, 98, ME, XP, 2000), UNIX (HP/UX, SUN

SOLARIS,

SCO), RedHat Linux

Languages: "C", Pro*C, Perl 5, PL/SQL, SQL, UNIX shell scripts,

SQRibe/Brio SQR

Tools: MS Office, Visual Studio .Net, TOAD, Remedy,

Rational ClearCase

Education:

B.S. Materials Science and Engineering, Massachusetts Institute of

Technology, Cambridge, Massachusetts

Applicable Experience:

2 TEKSystems, 08/08 to present - > Employer

Eli Lilly and Company - > Client

As a systems analyst, I developed and maintained PL/SQL scripts to support

the Relsys Argus Safety application for the Lilly Safety System (LSS). I

created scripts to process change requests and resolve trouble tickets for

the Indianapolis LSS TEK-GPS application support group.

3 Diverse Staffing Services Inc., 02/07 to 07/08 - > Employer

Eli Lilly and Company - > Client

As a systems analyst, I supported the SUMS R2 data migration by developing

and maintaining PL/SQL scripts to extract the SUMS R1 data, transform the

R1 data into the R2 data format, and load the transformed data into the

SUMS R2 database. I also supported data modeling for the SUMS R1 to SUMS

R2 database transition using the TOAD database development tool on an

Oracle 10g database.

Eliassen Group, Inc., 07/05 to 01/07 - > Employer

Eli Lilly and Company - > Client

As a systems analyst, I developed and maintained PL/SQL scripts to support

the Relsys Argus Safety application for the Lilly Safety System (LSS). I

employed Unix shell scripts and Oracle PL/SQL stored procedures to install

and run interface programs for the Lilly Safety System. I created Oracle

PL/SQL stored procedures to verify data conversion tables. I modified

Oracle PL/SQL stored procedures to enforce changes to business rules. The

TOAD database development tool was used for all PL/SQL development. Remedy

was used to manage change requests and Rational ClearCase was used for

source code control. Database development was done on Oracle 9i and 10g

databases and Unix development was on SUN Solaris.

Daniels Associates, Inc., 02/98 to 03/05 - > Employer

1 Marion County Justice Agency/ISA - > Client

2 As a system analyst at the Marion County Justice Agency, provided support

for the Marion County JUSTIS system and the JTAC Court Management System

(CMS). Created test scripts for validation of JTAC Court Management

System. Interviewed court employees to understand manual court procedures

prior to automation. Created documentation for prototype of JTAC Court

Management System.

3 Eli Lilly and Company - > Client

4 As an information systems analyst, developed and maintained Brio SQR4

reports for a MAXIMO application using ORACLE 8i on a Windows NT and HP-UX

Unix network. Produced application documentation using MS Word 97.

5

6 Conseco - > Client

7 Developed PERL 5 scripts and PL/SQL scripts for financial reporting

applications on SUN SOLARIS and Windows NT platforms. Created Perl scripts

to extract data from downloaded flat files, validate the extracted

information and load the validated data into Oracle tables. Modified

reports using ORACLE REPORTS 2.5. Maintained ORACLE PRO*C programs on SUN

SOLARIS

8

9 Eli Lilly and Company - > Client

As an information systems analyst, developed and maintained SQRibe SQR3

reports for a MAXIMO application using ORACLE 7.3 on a HP-UX/Windows NT

network. Developed and maintained PL/SQL scripts on HP-UX system.

Source Consulting, 06/96 to 01/98 - > Employer

As an analyst at U.S. Army Finance and Accounting Center, Indianapolis,

responsible for development and implementation of Foreign Currency module

and Year End Processing module for Corps of Engineers Financial Management

System (CEFMS) using ORACLE SQL*FORMS v3.0, PL/SQL, PRO*COBOL and UNIX

shell scripting tools. Produced application documentation using MICROSOFT

Office on Windows NT platform. Developed and maintained stored procedures

for ORACLE 7.3 database using PL/SQL. Produced reports from ORACLE

database using PRO*COBOL and SQRibe SQR3.

Total Response, Inc. 08/94 to 05/96 - > Employer

As a Senior Programmer Analyst, provided analysis, design and coding

support for application development using Visual C++, ORACLE PRO*C, and

Gupta SQLWINDOWS. Developed ORACLE applications for DowElanco (Dow

AgroSciences) and Cincinnati Bell.

Daniels Associates, Inc. 02/93 to 08/94 - > Employer

As an IT consultant, designed, developed, tested, and implemented system

modifications using Micro Focus COBOL on an SCO UNIX system for Kentucky

Finance Corporation, Lexington, Kentucky. Modified health insurance

applications utilizing ORACLE PRO*COBOL on a DEC VAX/VMS system for Anthem

Health. Worked on Eli Lilly and Company's ADMIN/LIMS project utilizing

ORACLE PL/SQL and ORACLE SQL*FORMS v3.0 on DEC VAX/VMS.

United Engineers 06/91 to 02/93 - > Employer

As a System Analyst, designed, developed and implemented EDI transactions

sets and COBOL accounting applications on an AT&T 3B2 platform for U.S.

Army Finance and Accounting Center, Indianapolis. Developed, coded, tested

and implemented an inventory application using ORACLE PL/SQL and SQL*FORMS

v3.0 on a SUN platform for AT&T Customer Information Center, Indianapolis.

Contact this candidate