MICHAEL W. CLOYD

EDUCATION

M.S., Biology, Chemistry, Physics, General Sciences, East Tennessee State University, Johnson City, TN

B.S., Biology and Chemistry, Education (Virginia teacher certification for secondary schools and undergraduate college levels), Tusculum College, Greeneville, TN

Air Force Command & Staff College

USAF Instructor School

CERTIFICATIONS

Oracle Developer

Database Administrator

Designer/Developer 2000

Designer 2000 System Analyst

Oracle Application Developer

UNIX MP-RAS System Administrator Concepts

UNIX MP-RA Administrative Tools and Utilities

UNIX Tuning for Uniprocessor and Multiprocessor Systems

PROFESSIONAL SUMMARY

Over 26 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) Strong experience in Data warehouse concepts, ETL

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Over 3 years programming / ETL experience with Ontario System’s Artiva (account receivable software)

TECHNICAL SKILLS

Languages/Utilities: SQL, PL/SQL, UNIX / AIX, XML, C++

Oracle 7.x/8i/9i/10g/11g, 12. Experience with Oracle E-Business Suite R11i and R12 primarily in the following Oracle Financials (GL, iExpense, AP, FA, Cash Management, Purchasing, iProcurement, Payments) and HCM modules.

SQL, PL/SQL, Stored Procedures, Triggers, MS SQL SERVER 2000/2005/2008, DB2/UDB, Teradata, SAP Tables and MS Access

Oracle Forms and Reports 61 and 10g

Data Modeling: Erwin 3.5.2,4.0, Cognos Analytics 10.x, Ontario System’s Artiva

PROFESSIONAL EXPERIENCE

Coast Professional, Inc Jul 2016 to Present

Ontario System Developer / IT Operation Support

Rewrote XML process of Credit Card Payments for Third Party collections to the Department of Education

oMost new data coming from Department of Education is in XML format (style sheet) – development both import and export scripts to process collection data

Primary duties include systems analysis techniques and procedures, including consulting with users to determine and test creation or modification of computer programs related to collection application

Develop Ontario System’s workflow, forms, data structures, file transfer and data cleansing as required. Using InterSystems Caché® and Microsoft SQL Server Databases developed Data Warehouse architecture, design and ELT process to meet Operations’ requirements

Using Ontario System’s Artiva development platform, redesigned third party recovery of loans for the Department of Education for the Government’s “Rehabilitation Program” of individual’s delinquent student loans

Performed user acceptance testing on letters, forms, workflows, and other processes ensuring Sarbanes Oxley compliance and business requirement are met

Cash America International, Inc Dec 2000 to Jul 2016

Senior Oracle PL/SQL Programmer, Designer and Developer

Wrote Java / XML / SOAP procedures to communicate with The Office of Foreign Assets Control (OFAC) of the US Department of the Treasury, two companies Cash America brought Cash Net (ENVOA) and Cashland in Ohio, and third party underwriters of Payday and Auto Title Loans

Led teams of two to six individuals, consisting of PL/SQL, Oracle Forms and Reports 6i/10g, C++ and .NET developers and programmers in various challenging applications using Oracle 8i/9i/10g/11g, 12.1.2 databases Developer / programmer for Ontario System Artiva (account receivable software)

MS SQL Server data warehouse ETL and Development

Senior Oracle Developer that architect, design, develop and deploy a new Payday Loan Collections Application using Oracle Forms and Reports 6i, Oracle 8 and 9i database, UNIX, Windows XP

For five years the application was the sole tool used to collect Payday Loans and Check Cashing obligations by a collection department of 60 individuals

Built, managed, and tuned processes to support application, Data Warehouse, and Business Intelligent activities

Designed and developed Customer Support Application to service Cash America customers, Payday Loans and Line of Credit using Oracle Forms and Reports 6i, Oracle 8 and 9i databases, UNIX, Window XP

Developed a reusable Common Class and Objects for C++ and .NET to Oracle 10g/11g databases, used for the new generation Pawn and Payday loan applications.

Senior Lead team of three Oracle PL/SQL programmers who wrote and developed numerous Oracle 10g/11g functions, procedures and packages to support new Pawn and Payday Loan Applications

Ontario System’s Artiva: Created new and modified existing code to accommodate specific requirements. Develop ELT (import/export) processes from Oracle database to Intersystem Cache database to populate Artiva’s database

Developed Artiva scripts, UI (user interfaces windows), menus and reports, Program Workflow processes, to user requirements

Maintained file processing, remittance, and reconciliation procedures

Developed automated task schedules using Automate, Artiva Job Scheduler, and Artiva Night Jobs

Proficient with Artiva Studio, Artiva Workstation, and CHUI

Contact this candidate