SUMMARY:

• Leveraging years of experience utilizing Unix, Oracle, and Teradata with a strong background in development, systems analysis, and production support for medical claims, product inventory, and pension applications.
• Additional acquired experiences include Oracle XML and Web Services Packages, Ab Initio, Informatica, SQL Server 2000 (with T - SQL), and Java J2EE.
• Candidate is an excellent communicator and team player.

HARDWARE/SOFTWARE

• AIX Version 7.1.0.0 Unix - Oracle 11g, Ab Initio, Teradata BTEQ, Fastload
• AIX Version 5.3.0.0 Unix/Linux - Oracle 10g, ERP Financials 11.5.10, Java, c, HTML, Apache-Tomcat-6.0.18
• Sun Ultra-Enterprise Unix - Korn Shell, awk, sed, perl, Oracle 9.2.0.6.0
• NCR 3555 Unix - Bourne Shell, awk, sed, Teradata BTEQ/Fastload/Multiload/Fastexport
• IBM 360/3090 VM CMS/XA TSO - JCL, COBOL, FOCUS, Rexx

EXPERIENCE

Sr. Developer

Durham, NC.

Responsibilities:

• Responsible for developing and maintaining Unix shell scripts, Oracle (11g) PL/SQL stored procedures and packages, and  Confidential( Confidential) compliant XML generation processes in support of a Care Management application (Care Radius).
• Authored a prototype to access Web Services from Oracle PL/SQL.
• Utilized Teradata (14.10.07.07 ) SQL Assistant, BTEQ and FastExport to extract case management data from the corporate Enterprise Data Warehouse.
• Utilized IBM RAD 7.5.4 and WebSphere (WAS 8) to implement Java J2EE enhancements to a Medical Provider maintenance (internal) application.
• Utilized Ab Initio 3.1.7.3 to implement multiple enhancements (and bug fixes) to an existing ETL claims authorization process.
• Generated project delivery, unit test, and technical specification documents as required.
• Proficient in the use of the Control-M job scheduler, and Eclipse/RTC for change tickets and source code control.

Consultant

Responsibilities:

• Authored and maintained Oracle (10g) PL/SQL packages, procedures, and functions in a Sarbanes-Oxley financial reporting application.
• Developed a Java method utilizing the JNDI API to retrieve and store Active Directory (LDAP) Group and Member attributes.
• Utilized Unix shell scripting (bash, ksh) to submit and evaluate scheduled processes utilizing TWS WebAdmin.
• Received MicroStratgy 9 training in support of a BI Dashboard application.

Consultant

Chapel Hill, NC

Responsibilities:

• Responsible for multiple roles in a Teradata (v12), Oracle 10g, AbInitio, and Unix environment.
• Automated manual processes via Unix shell scripting by reporting the status of certain batch processes, and certain aspects of the system environment. Also resolved Ab Initio batch issues around orphaned temporary work/log files.
• Utilized Teradata Manager, Admin, SQL Assistant, and BTEQ to perform support tasks and generate ad-hoc reports. Authored Teradata Stored Procedures to implement SLA Tracking automation and reporting.
• Utilized Business Objects XI-3.1 to generate and schedule reports.
• Provided client-facing communications via voice and email.

Consultant

Oxford, NC.

Responsibilities:

• Implemented the US Accounting Cost Rollup project for the 2009 budget year in the GEMMS/Oracle application environment.
• Coded Unix shell scripts and PL/SQL stored procedures in support of an Oracle Financials eBusiness Suite ERP migration (11.5.9 to 11.5.10). Modules included Accounts Payable, General Ledger, and Fixed Assets. Produced source and target database comparison reports detailing differences at the table and column level. Performed System Admin duties in the test environment.
• Modified Unix and Linux shell scripts, HTML, Java, and c programs in support of an AIX 5.3 upgrade/migration project. Utilized RCS, Make, Apache, and Tomcat-6.0.18 servlet container. Authored Java utility to validate jdbc connectivity for Oracle 9i and 10g databases. Established ssh connectivity (public/private RSA key pairs).

Consultant

Durham, NC

Responsibilities:

• Developed new outbound data feeds utilizing Microsoft SQL Server 2000 (v8.00.760) and Transact-SQL. Maintained Unix shell scripts and authored Oracle PL/SQL stored procedures. Performed testing of Teradata BTEQ and Fastload utilites as part of a system upgrade to V2R6.2.

Consultant

Responsibilities:

• Primary developer and data analyst for the Manugistics 6.1.8 Supply Chain Planning and Optimization application. Implemented batch process improvements (file versioning, disk space usage alerts, consolidation of common functions, process monitoring, and paging). Automated Sarbanes-Oxley source code change alerts. Installed and configured Manugistics front-end app (VIEWpoint) on local PCs.
• Utilized Informatica 8.1.1 to stage incoming EDI data in support of a Mainframe to Unix migration project.

Production Support Analyst/Developer

Winston-Salem NC.

Responsibilities:

• Program development and maintenance resource on a production support team using Oracle PL/SQL, Unix Korn shell, sed, awk, and perl in support of a pension payment application.
• Developed Unix shell scripts and cron entries to control execution of batch processes. Identified and implemented process improvements for data feed processes, including authoring a Kshell function library to implement environment identification, database status, report routing, error handling, and file versioning.
• Coded PL/SQL supporting a large data conversion project utilizing TOAD (Tool for Oracle Application Developers).
• Provided Crystal Reports server support (job scheduling, software upgrades).
• Received formal Sun Java training (w/JBuilder).
• Provided client-facing communications via voice and email regarding both technical and non-technical support issues for multiple applications.
• Additional work experience available upon request.