TECHNICAL SKILLS:

Technology and Tools: ORACLEPROGRAMMINGPL/SQL (either stand alone or PRO*C) ORACLE INSTANCES: 7, 8 - 8i, 9i, 10G, and 11G ORACLE OPTIMIZATION ORACLE SCRIPTING ORACLE RECORD COLLECTION ORACLE WINDOWING FUNCTIONS QUEST TOAD TOOLS-ORACLE SQL DEVELOPER UNIX/LINUX SHELL PROGRAMMING KORN (primary) & BASHSCRIPTING C LANGUAGE PROGRAMMING EMBEDDED APPLICATION DEVELOPMENT

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Oracle Application Developer

Responsibilities:

• The enterprise is comprised of on line catalogs to provide specific data about all types of vehicles ranging from automobiles to airplanes and everything in between including agriculture equipment and marine equipment. The detail goes down to Vehicle Identification numbers (VIN) to when the next auction will take place. Every State Department of transportation, police departments, civil and military organizations alike are customers plus insurance companies and various other customer classifications.
• The data is uploaded from many sources. My primary source of data derives from Microsoft Excel Spreadsheets in Comma Separated Files (CSV) format. This requires the Oracle table organization to be external. Once the data is loaded, it goes through a number of processes to add specific data that relates to make and model plus any related data from other sources.
• I work on trouble tickets and as an admin I do optimizations where it applies. The load on these servers can reach near breaking point and requires an aggressive approach to keep up with company growth thus demand. The environment is Linux servers using Centos, Oracle 10G and 11G (depending on the product), GIT, PHP, Source Tree, SQL Developer and some are licensed for TOAD.

Confidential, St. Louis, MO

Oracle Application Developer

Responsibilities:

• Worked on projects related to claims, premiums and billing schedules some requiring heavy Oracle date function usage. Where necessary, additional insertions into default and initialization value tables were required for new business updates; result set data transformations were required on a global level meaning the same PL/SQL code used in Central Europe may not be suitable for South Korea. As a result 'on-the'fly' transformations were required as a part of the code optimization. There are three development projects for the same end-goal. Part of my responsibilities included keeping up changes to the PL/SQL productions.
• The other was Java based and not a part of my responsibility. I came close to the end of first production thus no fundamental changes were made such as the inclusion of indexes however often the usage of hints use hash and alike were used. Certain portions of my assignments required analytic functions thus windowing was used as appropriate. Usage of ‘Analyze table’, DBMS Stats and explain plan were also used in my PL/SQL development experience though I rarely mention it since it is a fairly routine event.
• The organization uses Visual Studio TFS for Version Control., Oracle 10G however recently migrated to 11G. Desktop operating system is Microsoft 7. TOAD Tools are used.

Confidential, Portland, OR

Oracle Application Developer

Responsibilities:

• This was a two month project to build all of the basic DML for two-hundred new tables for the second project which was going to replace the first as a major version upgrade. I built the Insert, Delete, Update and single-row selects for the new tables. I used Oracle scripting and Oracle internal tables such as all tables, and constraint tables to perform this phase of the project. No optimization or indexing was performed in the short time I had to accomplish my portion of the project.
• The new tax calculator required a rewrite of all of theback-end functions that interact with the PHP based internet application (Front end). A new face and Oracle 11GR2 database using Linux servers is slated to become the new Tax Calculator for Thomson Reuter's customers. With the tables established and normalized; wrote the back-end user interface including anMD5 password encryption, and all required insert, delete, and update functions for the new application.

Confidential, Portland, OR

Oracle Developer using PL/SQL Specialist

Responsibilities:

• Most if not every medical charting scheme uses some form of storage and retrieval system. They range from a paper folder containing all records, notes and laboratory pages to highly sophisticated database record capture and retrieval systems. My project is to move very large quantities of Computer Electronic Medical Records (CEMR) known commercially as Centricity to a General Electric system called EPIC. The export from one system to another uses two different methodologies, HL7 and Oracle UTL FILE, a built-in set of functions. Once the result set is established, specific fields in the query are put in a variable character array data type and using UTL FILE functions, an HL7 formatted text file is created and later using FTP is sent to a share file computer for distribution.
• This extraction required a seven union select statement and took hours to process even on IBM RISC 6000s running AIX. The best way to have delt with optimizing this environment would include a partition based on ICD-9 coding. In addition using a partition index would have been a good start, but my effort was not to support the old, but to move Confidential t data to a whole new off-site system so no rudimentary changes were employed.
• The backend of the system is an IBM Risc 6000 using AIX, but all of the clients are Windows 7 Enterprise PCs. Our Oracle instances are all 10GR2 but one 11G on a Windows Server. I am running on TOAD 11 and have been a long time user of TOAD.

Confidential, Lake Oswego, OR

Oracle Developer using PL/SQL

Responsibilities:

• Every medical encounter in America requires the usage of some form of the 837 claim system mandated by the United States Federal Government. Kaiser Permanente is the largest HMO in the United States and hosts an amazing multi-support system to remain in compliance with said government standards. The backbone of the system is based on Oracle. New claims are received around the clock and are extracted and mapped for table distribution. New claims come from varying resources; the system operates in both directions by paying providers and billing to a multitude of sources and cost-centers including institutions such as insurance carriers, Medicare and Medicaid.

Confidential, Fort Rucker, AL

Oracleapplication Development

Responsibilities:

• The results of each of these physicals either originate on a computer anywhere in the world or are mailed to Fort Rucker for processing. AERO, an Oracle application written in PL/SQL not only accepts data for processing but analyzes the data to determine the fitness of each person who may serve in the air or be piloting an airborne vehicle such as Unmanned Vehicle. Currently the Coast Guard, an essential unit of Homeland Security, the US Navy, and other military services are trying Confidential out to test is suitability their needs. Integrated the Confidential Civil Support Team (ARG WMD CST) into Confidential at this time.
• Confidential is an Internet browser application using the built-in packages from Oracle such as HTTP plus the full Web services with Oracle Application Servers. Part of the job description included a portion of installation of Oracle, and OS patches, but aside from that Korn shell work, execution of Oracle scripts were often accomplished by launching Korn shell scripts, that would open the Oracle instance to complete DML requests some which were to handle light DBA activities in DDL areas.

Confidential, Longview, WA

Oracleapplication Development using PL/SQL, Data Architecture

Responsibilities:

• Projects include Rapid Development Tools in the form of Oracle scripts, Stored Procedures and Functions embedded in Packages designed to inventory existing tables and relationships to create objects by type, custom indexes to arrays, associative arrays and piped functions to access rudimentary functionality serving higher level applications.
• Designed programming to build automatic Dynamic Manipulation (DML) functionality by table. Built-in libraries include Native Dynamic SQL (NDS) for cursor applications secondary to drive tables. Overall results offer a strong contrast therefore producing a reduction in production costs in development. Formatting output to present data in a controlled manner remains as a discipline and some features have been canned for the repetitive essence. Most of the report effort ellipses specific description due to the specific nature of the effort.
• Currently working toward application development on dedicated low-cost micro-kernel notebookswith solid state memory drives with embedded Linux. Exploring opportunities with Linux, Apache, MySQL, and PHP (LAMP) technologies for product development specializing in automated telecommunication promoting a specific menu of information as requested by clients.

Confidential, Kelso, WA

OracleApplication Developer and Data Architect

Responsibilities:

• Major duties included converting proprietary scripting languagecode to 10gand11gOracle using PL/SQLstructured programming modules to speed up an un-scalable client product.
• Normalization and indexes were but a couple of issues that made the tune up and transition of business logic difficult. Tools used included QUESTTOAD Data Modeler, andTOAD forOracle.
• Client used Microsoft XP in a .NET environment to Citrix. Major s included breaking the barrier of returning result sets from theOracle10g (Development),11g (Production)Instance to Client application which according to the manufacture was not possible. Provided innovative data collection systems through associative arrays and piping methodologies as well as other features. Implementation methodology varied from group and person, but I preferred the discipline of running Korn shell scripts to invoke much of what I did simply to keep an immediate record of my activities without having to look through logs. It saved time and let me know what I had done and what needed to be done.

Confidential, St. Louis, MO

Responsibilities:

• Projects include property management systems for multi-facility self storage management companies requiring the integration of MS Access with proprietary ISAM databases that store client access codes, hours of operation and gate controller technologies which involved computer hardware to peripheral monitoring and access. Billing systems that included both POS Credit card payments and automatic timed event scheduling payments such as for storage rent.
• Oraclepackage development for library enhancement. Instances includeOracle9i through 10g. Continual adaptation of new usages of DML now available that increase optimization such as the move from traditional hints to Cost Based Optimization or encouraging Method R problem solving methodology.

Confidential, St. Louis, MO

OracleApplication Development Engineer

Responsibilities:

• Supporting telephone service sales and business plans for landline and cellular customers; this department implemented a software solution to combine multiple phone bills into one. The software application is a network based, multi-platform, multi-computer language solution designed to aide customer service and sales personnel. The UNIX Server application is built around ORACLE 8.06 on an IBM RISC 6000/AIX Korn shell system. Personnel use NT clients passing coded messages by Remote Procedure Calls (RPC) to the OraclePro C embedded backend.
• The work effort included portingOraclePro C applications between Pyramid and IBM RISC 6000 servers, maintained data integrity by means of Korn andOraclescripts calling Packages containingPL/SQL, functions and stored procedures. Using Oracle SQL*Plus, Monthly reports were generated to show tabular and graphs displaying network traffic data. The effort was complicated by virtue of extraction from a mainframe, extracted by Korn Shell programming methods (AWK, Head, Tail, SED, Grep, VI Editor, Regular Expressions, Perl, etc) imported to Oracle and extracted to a format suitable for use of Microsoft Presentation program for a management overview which included graphical analysis.

Confidential, Palo Alto, CA

OracleApplication Development Engineer

Responsibilities:

• Responsible for a phase of a Global Web User InterfaceOracleApplication using anOracleWeb Server. Activities include back endPL/SQLOracle, table driven Embedded Dynamic HTML menu and input screen generation. The software application is designed to classify manufactured products sold overseas and is specifically intended for The United States Customs and other countries import/export tariff collection agencies. HP 9000 series servers with HPUX UNIX. Clients NT workstations. SQL Navigator,Oracle8.0.4 andOracle8.0.5. Confidential Global Intranet network.

Confidential, Melville, NY

OracleApplication Development Engineer

Responsibilities:

• Teaming and collaborating with an internal engineering group responds to Requests for Service (RFS) to NEIS, a commercial in house software Application that administrates employee and partner human resource requirements to handle compensation and expenses.
• Currently, this group is involved in migrating to Peoplesoft and handle the day-to-daydatabaseand Embedded C Language application that drives theOracleDatabase. Confidential servers with network support andOracleDatabasewith Pro C.

Confidential

OracleApplication Development Engineer

Responsibilities:

• Consulting with an engineering group responsible for a newOracle8 based Trouble Ticket and Tracking System. The project required RELTEC, the test equipment supplier to create a Y2K compliant RelationalDatabasethat will interface with existing technology while replacing the whole of current tracking methodologies. My responsibility was to supply needed interfaces consisting ofOraclepackages including Functions, Stored Procedures andPL/SQLreport activity to be used for metrics and to the Java application currently under development. Equipment used includes development workstations, network access and an IBM RISC 6000 with AIX.

Confidential, Overland Park, KS

OracleApplication Development Engineer

Responsibilities:

• Supported ad hoc efforts to correct logic flow, SQL and scripts to be effective in a fast moving marketing group in the Cellular communications business.
• Issues related to Y2K, and common SQL library routines replaced ineffective and inaccurate Data Manipulation Language (DML). Due to growing, Data Warehousing techniques and procedures were employed. Sun Solaris and HP UNIX networked servers, transitioned existing applications based inOracleversion 7 to version 8,OraclePro C embedded applications development,OracleSQL*PLUS, and Korn shell and other scripting applications for overall performance reporting and billing related issues such as client updates and their like.

Confidential, Nashville, TN

OraclePL/SQL Programmer

Responsibilities:

• Designed, developed or maintained software tools capable of controlling and monitoring computer applications capable of sending and receiving customer data for financial processing and reconciliation to client accounts. Strong usage of Inter-Process Communication, shared memory, software interrupts (UNIX signal handling),ORACLESQL SQL*PLUS and EmbeddedORACLEPreprocessor Application Development. IBM RS6000/AIX,ORACLE, PRO C/ANSI C Language using UNIX Standard Curses Windowing Package. Since the customer does financial processing (ATM) such as their subsidiary Western Union, reporting in real time is essential which the main product of this effort.

Confidential, Memphis, TN

Application Development Software Engineer

Responsibilities:

• Software applications to support advertising activities provide client information and verbal instructions to telemarketing staff as needed to aid sales activities.
• Current applications are written in Java, and Sage, a rapid development tool, and some auxiliary communication applications are written in C language. SEQUEL (SQL)databaseroutines are used to support telemarketing activities. Application system support is provided by KORN shell and PERL scripts that reported telecommunication operators performance based on accuracy of answering scripted questions and their ability to execute the expected quantity of calling events within the given period of work. UNIX scheduling, TCP/IP and LU 6.2 communication applications functionality aided in this event. HP UNIX, KORN Shell scripts PERL 5.002, SAGE script procedure language by Brock, and SYBASE 11.x SQLDatabaseServices.
• Extensive 10-year character background and criminal investigation required.

Confidential, Memphis, TN

System Analyst/Programmer/System Test Engineer

Responsibilities:

• Working toward the completion of the first phase of a multiple property client services application; duties included repairing known problems in logic, and application syntax. This effort required a sophisticated understanding of the information flow and processing systems. In addition, assignments to test new fixes required comparisons to baseline in a pseudo "production" environment employing multiple scenarios file processing typical to actual usage. The product was the tracking system for gamblers to receive credits for usage of gambling machines and table games that were tracked manually by "Pit bosses."
• Once the entry was made reports was created offering usage/load on system reports designed to offer management the needed information to make adjustments to the gambler's experience thereby enhancing their gambling experience. UNIX/C, Informix 7.14Databasesystem, NCR computer, TOPEND Application Manager.

Confidential, Cedar Rapids, IA

Application Development Software Engineer

Responsibilities:

• Activities include new TCP/IP Client Product Development, MCI Application Platform designed to operate on AIX 3.2.5 with CTREE ISAM Database platform 6.0 for UNIX, SNA, Token Ring, TCP/IP, IPX, and X25 to AIX 4.2 (IBM's latest release for RISC 6000 Servers). XL C Compiler for RS 6000.

Confidential, Fairport, NY

Application Software Integrator

Responsibilities:

• Responsible for the Scheduling and integration of upgrades, insure the quality of the server capable of print, scan and fax support, with spooling and queuing.
• This product line supports AppleTalk, LAN Manager, and Banyan VINES. Protocols include TCP/IP, LPR/LPD, Novell Pserver, Boise Serial XON-XOFF, SLIP, SNMP agent & MIB-2 Automatic Multi-Protocol Switching. Print Services and image frame store facility supports PostScript Level 2 plus Fonts (Adobe or Phoenix), PCL5e plus fonts, Automatic Emulation switch, Compressed-page Banding Technology. PCMCIA Type II Network Cards provide Token Ring, 3270, Local Talk, fax/Modem-14.4kb capability. GNU C compiler, Shlaer/Mellor methodology Object oriented Data Store, Sun system IV host, Sparc Microkernel development, Lynx Real Time UNIX for production unit.
• Often, the requirement was to create Databases, Tables, Indexes, Roles, Users, Triggers, Sequences, and other related objects to support the primary development environment. Not always, but often aDBAwas either hired or assigned to take over, but on the rare occasion, I did everything required for the immediate and futureDBA needs of the project.