OBJECTIVE

To obtain a position that fully utilizes and challenges my Oracle and UNIX programming skills in a technically diverse environment

• TECHNOLOGY Platforms:Windows NT/2000/XP/7, UNIX AIX/HP/Sun Solaris/Linux
• Database: Oracle 7/8i/9i/10g/11g, Microsoft Access
• Database Tools: SQL Loader, Designer 2000, SQL Plus, Oracle Enterprise Manager,
• Oracle Import/Export, Parallel Query, ETL, Partitioned Tables, Hints, Toad, Developer 2000, Reports 2.5, Oracle 9i Reports Developer, Oracle 9i Release 2 Forms, PL/SQL Developer, SQL Navigator, Oracle Web Server, Crystal Reports, DataStage 7.5, Oracle Data Pump
• Languages: PL/SQL, SQL, Korn/Bourne/Bash/C/Perl Shell, sed, PGP, HTML, FTP, cron, wget, curl, Regular Expression, scp, Perl CGI, PHP, JavaScript
• Software: PVCS, Visual Source Save, Dimensions, Microsoft Office, Cntrl-D, Cntrl-M

EXPERIENCE

DATABASE CONVERSION DEVELOPER Confidential

• Assist project managers with setting up server database access
• Create Korn shell script for emailing of tarred and compressed files to various VA personnel
• Craft conversion SQL Plus Reports and CSV files with the use of dynamic SQL and regular expression
• Execute and compile PL/SQL subprograms and anonymous blocks in conversion effort
• Research and produce SQL scripts to correct conversion related bugs
• Prepare SQL ad hoc conversion reports for managerial review
• Mend faulty Korn shell scripts for executing Oracle Data Pump Import and stored procedures
• Created error process reports utilizing UTL FILE in PL/SQL programs
• Reprogrammed defective oracle packages and stored procedures to fit design spec

SENIOR SOLUTIONS DEVELOPER Confidential

• Created anonymous block conversion template for junior oracle developers to use in creation of conversion scripts
• Organized and documented complete conversion execution process for moving data from source to target
• Mentored and trained junior developers in writing effective SQL queries
• Performed quality assurance on junior developers anonymous blocks to insure code standard compliance
• Assisted project managers and other senior solution developers in making decisions on how additional conversion processes should be performed
• Performed database analysis on source data to retrieve record counts to aid in proper ordering of scripts
• Fashioned anonymous blocks for use in conversion effort

ORACLE DEVELOPER Devry/Apex Systems Confidential

• Created complex queries and anonymous blocks to retrieve data for conversion and perform translation to meet future system requirements
• Loaded data into new Banner application using SQL Loader and PL/SQL anonymous blocks
• Performed system analysis and research to ensure proper data mapping

ORACLE PROGRAMMER ANALYST Walgreens/Apex Systems Confidential

• Tuned over 100 production and development queries for greater efficiency
• Combined redundant Oracle PL/SQL procedures to reduce process execution time
• Examined over 600 programs to find ways to reduce overhead on production database and give suggestions on which can be moved over to less utilized resource
• Analyzed and recoded Korn shell scripts that impact external client reports
• Multitasked database support issues between various development and enhancement projects
• Tuned DataStage queries for faster retrieval of data

DATA WAREHOUSE PERL DEVELOPER - Northern Trust/Apex Systems Confidential

• Created Perl script for moving Index mappings for UAT to Production environment
• Developed PL/SQL stored procedures for loading and massaging index related mapping
• Produced adhoc queries for retrieving duration times of long running processes

DATA WAREHOUSE PERL DEVELOPER - CBOE/IBS Confidential

• Crafted Perl wrapper for coping csv and piped delimited text files to binary excel files
• Developed Perl script for updating and synchronizing oracle development schemas
• Created Korn shell scripts for loading of records into the data warehouse
• Generated design plans for new projects and medications to existing programs
• Build scheduled jobs in Cntrl-M for daily application processing
• Utilized versions of Oracle 9i for creation of PL/SQL sub-programs and stored procedures

DATABASE PERL DEVELOPER Navteq/Tek Systems Confidential

• Translated existing Korn shell script to a more dynamic Perl script for evolving schemas and software versions
• Operated Oracle 9i database for development and problem solving
• Created PL/SQL script standards for the development team to follow in future schema and software evolutions
• Found appropriate solutions for database upgrades by streamlining evolution process
• Assisted in installation of Perl 5.8.8 for new data evolution script

DATA PERL PROGRAMMER Confidential

• Developed Perl and Bash shell scripts for loading and extracting of data and images into Oracle 9i database
• Solved production support issues for failed scheduled data loads
• Utilized Oracle 9i database for development and problem solving
• Worked independently and with teams to implement PL/SQL that address complex data transformation, migration, and retrieval needs within and between Oracle 9.x database environments
• Created web based tools using Perl CGI, HTML, JavaScript and PHP

SOFTWARE ENGINEER II Confidential

• Designed, developed, and implemented Web-enabled Oracle Forms and Reports for Naval Ordinance System
• Researched and initiated solutions for exercising use of Oracle 9i cost base optimizer
• Created and modified conversion scripts for migrating of data to new database system
• Assisted in helping management and co-workers find solutions for difficult technical problems and situations
• Utilized versions of Oracle 9i/10g in creation of Forms and Reports based applications

DATABASE ANALYST Confidential

• Produced web based reports with Oracle embedded HTML
• Encrypted incoming and outgoing files with PGP
• Performed tuning of database procedures and scripts
• Utilized PL/SQL, Toad and SQL Loader in creation of database stored procedures
• Built shell scripts for automation of processes in Sun Solaris environment
• Generated reports from data warehouse and FTP to various external users

DATABASE ANALYST Confidential

• Solved development and production problems
• Created stored procedures and Korn shell scripts in HP Unix environment
• Performed tuning of database PL/SQL procedures and scripts
• Loaded data from external sources into database using SQL Loader

PROGRAMMER ANALYST Confidential

• Developed and repaired existing reports using Developer 2000 and Crystal Reports
• Created forms using Developer 2000 to increase the functionality of application
• Assisted users with problem resolution and software training

DATABASE DEVELOPER Confidential

• Provided on call production support for database environments
• Composed Bourne shell scripts in HP Unix environment
• Assisted in creating production and development databases
• Inserted data into Oracle database using SQL Loader and Oracle Export/Import
• Partitioned tables for organizing data within the tables
• Accomplished DML statement tuning on database PL/SQL subprograms

DATABASE ANALYST Confidential

• Provided production support for the database environments
• Created PL/SQL stored procedures, packages and triggers using SQL in a AIX Unix environment
• Developed test cases for stored procedures, triggers and packages
• Tracked and logged discrepancies until considered fixed