Serving as a member of the iMedia High Availability Break/Fix Team.
	Trouble shoot Job Flow Abends and high priority events for the Nationwide Financial Data Warehouse meeting strict SLA’s.
	Perform maintenance and enhancements to ETL Architecture as needed.
	Work Tickets in Queue to Customer satisfaction.
	Technologies used include:  Oracle, UNIX, SQL/Loader, SQL Assistant, Teradata, BTEQ, Korn shell scripting, Maestro Job Scheduler, Hummingbird/Exceed, Mercury/Test Director, SQL Server 2005, Stored Procedure Scripting and Analysis.
	24 Hour On Call support.

	Maintain and support the Advantage Service Line "baseline" processes that convert and migrate client data from Advantage 2.x mainframe ERP applications and/or their Legacy systems  to Advantage 3.x Oracle databases.
	Consult on site CGI-AMS Consultants and Client Programmer/Analysts on the above process.
	Refine legacy code for the Idaho Transportation Department by reducing over 5000 lines of code down to less than 10 lines.
	Specialized Interface development.
	Technologies used include:  Pervasive Data Integrator (Data Junction), Java,  Versata, XML, Oracle, use of ETL for data conversion, Websphere, AIX, Solaris, XML, COBOL, FTP, UNIX, SQL/Loader.
	Worked remotely from my home office.
	Routinely succeed in my assignments despite lack of training and less than minimal direction from immediate supervisor.

	Oracle Import/Export utilities.
	SQL / Loader
	Data Junction, djCosmos, code Analysis.
	Validate newly created in-house software.
	Troubleshoot ETL load of a major clients data.

	Document procedures to deploy DJ Project Specification Files across Development, Quality Assurance and Production environments.
	Create ADO Connection to SQL Server to execute static SQL.
	Create DJ Process to dynamically move Look Up table data from one environment’s database to another.
	Prototype use of external code library and Global/Public stored functions to be used from Process Designer and Map Designer.
	SQL Server 2000, Enterprise Manager, Query Analyzer, DTS.

Contract Developer  Mar. 2004 – April 2004
 

	Load Student Test data and Demographic data for the State of Virginia using Data Junction 7.5.5 and Integration Engine.
	Create Maps to Process Multiple Files at once using FileList verb.
	Educate and Demonstrate to FTE’s features of Data Junction Products.
	Use TLookup verb to filter records based on values in external tables.
	External Code Modules. Oracle 9i Multimode Maps.
	System Analysis and Design of data load job flow.
	Code to insure smooth transition when company upgrades to Pervasive djCosmos 8.0
	XML File Creation, Metadata Expressions.

Accomplishments: Organize and accomplish the company’s goals ahead of schedule.

Contact Developer  Nov. 2003- Mar. 2004
 

	Install djCosmos, Install Maintenance releases.
	Migrate DataJunction 7.5.5 Maps to djCosmos.
	Convert legacy COBOL code to djCosmos Conversion mapping.
	Advanced usage of Global Variables and RIFL file programming
	Alter *.BAS files to new RIFL specifications
	Execute Oracle Procedures and SQL statements from djCosmos.
	Coding to search ACCESS database to convert values from Client data to MVBA values utilizing ILClear, ILBuild and ILookup verbs
	Create Functions that interpret Name / Address / City and State Source data and correctly place that data in proper Target fields.
	Consolidate over 130 COBOL Programs down to 28 djCosmos Maps.
	Self-Documenting coding.
	Educate and Turn over project

Accomplishments: Salvage the data load project for this company.

Contract Developer  Mar: 2001- Nov: 2001

	Extract, Transform and Load, ETL, Healthcare Provider data "backend" to an Oracle8i database for the Perot Systems Healthcare DIAMOND® Solutions  Payor enterprise software application.
	Install Data Junction 7.5.  Create a development environment and provide training.
	Data Cleansing / Scrubbing.
	Significant System and Data Analysis.  End User Interviews.
	Advanced PL/SQL Programming.
	Comprehensive use of Data Junction products.
	Train replacement and turn over project.

Accomplishments: Using Data Junction products and advanced PL/SQL programming I was able to create a process that loaded hundreds of thousand Provider records, significantly reducing the manpower and time needed to load the data through the Diamond GUI.

Senior Developer  Mar: 2000-Mar: 2001
 

	Report to the Director, Information Services. Directed to create or modify computer programs to meet the needs of end users of OhioHealth Group.
	Evaluate user requests and determine feasibility.   Consult with users to identify current operating procedures and clarify program objectives.  Train users to use programs and provide technical assistance.
	Management of HCFA and UB92 Claims processing data flow.
	Data Junction 7.0 - 7.5:  including Project Manager, Cambio.
	Created Process to load scanned claims to Oracle database.
	Advanced Oracle Procedure scripting.  SQL Explain Plan using PLAN_TABLE.
	Data Junction 7.5:  including Project Manager, Cambio.
	Visual Basic maintenance programming.
	Ingenix, Claims Edit System, (CES):  Environment Setup, Batch Claims Processing, Data Management.

Accomplishments: Programming to recover overpayments to Providers resulting in finding overpayments in the hundreds of thousands dollars.  Upgrade Data Junction 7.0 to 7.5.  Correctly implement Ingenix software. 

Programmer Mar. 1999 - Mar. 2000
 

	Support and development of GUI interface to Oracle8i database using JAM / Panther Development tool
	Extensive knowledge of SQL Plus as well as PL/SQL, SQL Loader etc. UTL_FILE, DBMS_OUTPUT Packages.
	Comprehensive use of Data Junction and DJEngine data transformation tools; Converting/Transforming data from source data types to target data types and manipulating using Data Junction's Expression Language which is based on a subset of Visual Basic
	Panther Product Installations, Maintenance releases, Configuration of Client PC's.
	Feasibility analysis of end user requests
	USPS Address Standardization.
	Advanced DOS batch programming
	Y2K Remediation programming
	Product Installations, Maintenance releases, Configuration of Client PC's
	Practiced in Technical Writing, User Manuals and Documentation
	Skilled in Technical Research.

Accomplishments: Completely revamp process of loading new homeowner data to Oracle database, including upgrade of Data Junction product and rewrite of ETL programming for 20 different source data formats.  Programming to restore corrupt database resulting in reloading of over 1 million records. 

Programmer Jan. 1998 - Feb. 1999
 

	Supporting SMS, the primary patient entry/tracking and demographic software at Grant / Riverside Methodist Hospitals. Including, Ad hoc report writing, batch and online production support.
	COBOL maintenance programming.
	Coordinate Third Party Access to Hospital Mainframe.
	Utilizing FTP to coordinate data exchange between business partners via the IBM/Advantis Global Network.
	Familiar with IBM Information Exchange using IBM Expedite / MVS, IBM Passport for Data exchange.
	Knowledge of standard IBM MVS utilities, as well as Compuware's FILEAID
	Experienced with MVS/ESA, RSD, SYSVIEW, TSO, CA-7, FILEAID & JCL
	Corporate Intranet Web Page Development.
	Accomplished with problem analysis, determination to successful resolution.

Accomplishments: Design a process and consolidate data exchange methods with Riverside Hospital’s business partners into a standard format. Coordinate activities of Hospital’s Security Officer, Database Administrator and Business units with business partner’s liaisons and Operations staff to realize these goals.

 

Grant/Riverside Methodist Hospitals
Columbus, Ohio

	Monitor HBOC, HP9000
	Intranet Web Page Development