AddThis Social Bookmark Button
Michael Dalton ( Available )
Avon, IN - 46123 USA
Expertise :Oracle/Unix/technical/functional, Oracle Applications, PL/SQL/Forms/Reports
Status :Citizen
Job Type :
All -
Position :

Best Oracle Guy in the USA. Email Michael at daltonmjd@yahoo.com - Oracle 11.5.10, conversions, interfaces, pl/sq, forms, reports, soa/bpel, dba, etc, best in the USA

.. See More
Resume
About Me
 
Employment

2008 -  Present

Indianapolis , IN

Oracle Consultant : eBusiness Suite implementation, extensive ETL, conversions, interfaces, PL/SQL, TOAD, SOA/BPEL, XML, Oracle 8/9i/10g/11g, Forms and Reports, iStore, iReceivables, Portal, Extensive Interface and Conversions experience, Project Management, design and documentation md50, md60, md70, md120 etc SQL Server, VB6, Web Development, Java/JSP, etc. Oracle Applications 11i and R12 experience in : Inventory, Shipping, WMS, Financials, EDI Integration, iStore and iReceivables, AR/AP/GL SAP, JD Edwards, Hyperion, Stellant, Siebel, Peoplesoft, OBIEE, BI, iSupplier, SOA, JAVA, Microsoft. NET


2006 -  2008

Indianapolis , IN

Technical Manager, North American Consulting : responsible for : Direction, architecture, design, implementation, programming, automation, data modeling, stored procedures, pl/sql development, test plans, test scenarios, test scripting and support of all Oracle Applications 11i for the organization Inventory, Shipping, WMS, Financials, EDI Integration, Retek, iStore and iReceivables. Travel across the USA implementing and supporting Oracle products and services, with emphasis on AppsTech and eBusiness Suite. Advitium, Harvest, Sharepoint, Mercury TestDirector. Recent training in Java/J2EE, JSP and SOA/BPEL, work on a large Retail project using BPEL and JSP in the past 3 months.


2004 -  2006

Indianapolis , IN

Manager Oracle 11i Applications and Portal Web Development : responsible for : architecture, design, implementation, programming, automation, data modeling, stored procedures, pl/sql development, test plans, test scenarios, test scripting and support of all Oracle Applications 11i for the organization Inventory, Shipping, WMS, Financials, EDI Integration, iStore and iReceivables, etc

Primary roles and responsibilities : requirements analysis and documentation ; Conceptual design and storyboards ; Functional and technical design conducted with user community ; Development of Design documentation ; PL/SQL Package and Procedure development and maintenance ; Oracle Web Forms Development and Maintenance ; Oracle Reports Development and Maintenance ; SQL*Forms ; Discoverer Tool implementation and coding ; Working with Oracle on TARs ; EDI integration processes and procedures ; Upgrade Oracle 8.1.7 to Oracle 9i Database ; Development of the 850 940 945 EDI transaction interfaces ; Manufacturing and Distribution support and enhancements ; Work with Vendors to setup EDI interfacing ; BPEL ; Financials support and enhancements ; migration and change control ; iStore design, development and support ; iReceivables suppoer and enhancements ; Warehouse Builder ; Discoverer Tool ; Lead Testing efforts ; Design Test Plans and Scenarios ; conduct Test Cycles ; TCP/IP ; FTP ; Korn Shell ; VI ; SED ; AWK ; UNIX ; LINUX ; Shell Scripting ; Apache Server ; Tomcat ; Java, JSP ; ASP ; XML ; Visual Basic 6 ; Visual. Net ; Visual Studio ; Oracle 10g training and installation ; Sharepoint ; Harvest ; Documentum ; Putty ; Ariba ; Gentran ; Glovia ; Business Objects ; Crystal ; etc.


1988 -  2004

IT2000 LLC Indianapolis , IN

Director Consulting Services/Project Manager/Systems Architect/Co-Owner : responsible for sales, concept, architecture, design, programming, automation, staff building, project management, data modeling, database design, Testing, RTI, implementation, training and support of Client Information Systems throughout the United States.

Primary roles and responsibilities : requirements analysis and documentation ; Conceptual design ; Functional and Technical design and documentation ; PL/SQL ; Oracle ; COBOL ; SQL Server ; JAVA ; JSP ; ASP ; Visual Basic 6 ; Interdev ; Microsoft Products ; SQL ; SQR ; PowerBuilder ; Visual Studio ; Web Caf ; Test Plans and Scenarios ; Conduct Test Cycles ; etc.


1974 -  1988
Distrubution and Financial systems support and development

General Motors Corp., Anderson , IN

Ball State University, Muncie, IN BS Computer Science Honors Program
USMC Computer Science School, Quantico, VA AS Computer Science - Valedictorian

Justin Coble, CSC Consultant, 3 years
Mannish Shrinivastiva, Dell Manager, 2 years
Ed McMahon, Project Manager, 1 year

ISGROUP and
IT2000 Clients/Projects
ISGROUP- Senior Developer and Project Manager of Oracle Applications 11i and Portal Web Development March, 2004 to 2006 began consulting became an Employee : UNIX/LINUX Administrator and shell scripting using korn and c shells awk, sed, vi ; Apache Web server ; Tomcat ; IIS web server ; JSP/JAVA ; Oracle Apps 11i ; ORACLE PL/SQL, Oracle Designer, Discoverer, Warehouse Builder, Oracle Forms/Reports ; desktop automation ; Project Management for Oracle 11i and Database 9i Inventory, Shipping, WMS, Financials, EDI Integration, iStore, iReceivables, etc.


March, 2003 -  March, 2004
Eli Lilly Senior Consultant/Lead Analyst

:
UNIX Administrator and shell scripting using korn and c shells awk, sed, vi ; Apache Web server ; IIS web server ; Cold Fusion Web Server ; ORACLE PL/SQL, Oracle Designer, Oracle Forms ; Er-Win ; ANSI-X12 format and conversion ; Tier Resync Oracle-DB2 ; IMS Web Automation ; Automate Trouble Tickets and Sales Alignments - Skillsets : IBM, COBOL, DB2, TSO/ISPF, JCL, Visual Basic, Remedy, Remedy Automation, SAP, Cold-Fusion, JAVA/J2EE, SQL Server, CSS, HTML, ASP, JSP, SAS Enterprise, Documentum, Informatica, Powerbuilder. Project Mgt, QA Documentation, Validation, Data Modeling, Database Design, RTI, Testing.


2002 -  2003
Purdue University Project Manager/Technical Lead

:

Coordinating projects throughout the University : Upgrades to NT Servers ; Install Service packs and new packaged software on NT servers ; Documentum Document Management System ; Apache web server and Administrator ; IIS web servers and Administrator ; Training on ThinQ Web based server, Websphere and CA UniCenter Service Desk v5.1 ; Install Service Pack 1 for CA Service Desk v5.1 ; Visual Studio and Visual Basic Desktop Automation ; ORACLE/UNIX and Unix Shell scripting ; QA Documentation, Validation, Test Plans and Testing, JAVA/J2EE, SQL, SQL Server, Access, SAS, Cold Fusion Web development, CSS, XML, Configuration Management, EDI via in-house software for ANSI X12 data transfers to University Vendors ; MQ-Series and MX-Series, Data Modeling, Database Design, RTI, BEA Weblogic, Crystal Reports and ASP/JSP Web Development


2000 -  2002
Heritage Environmental Services Project Manager/Technical Lead

:
Barcode System Automation Nationwide Offices integrated via C program executing a network call to each FoxPro table in order to populate our central Oracle Database ;

UNIX shell scripting using Korn shell ; Work with DBA on conversion of Oracle 7.3.4 to Oracle 8.1.5 C++ coding for FoxPro and Oracle repository replication scripts
Conversion of Oracle Forms 3.0 to Oracle Web Forms 6i Conversion of all Oracle forms from Oracle 7.3.4 Forms 3.0 to Oracle 9i Web Forms 6i for the Laboratory systems ;
Involved with OQ for instrumentation calibrations and PQ for Lab sampling process and procedures under new Damaged Materials Web Development project
Intranet Communication Website Developed standard Web pages for Focus teams, discussion group thread and centralized posting of information and events ;
GEAC Conversion of GEAC Millennium HR/Payroll to Peoplesoft DB2, VSAM, COBOL, JCL, PDL, Screen changes, Rexx, Clist, ISPF, TSO, Payroll and Benefits
Software Evaluations Compared IBM Websphere/MQSeries, Cold Fusion, Visual-Caf, BEA Weblogic, Java, JSP, Oracle E-commerce and Discoverer, Visual Studio and Versata Business Rules engine in order to determine the Corporate Development Workbench
GENTRAN EDI software changes and XML transaction design and coding
Oracle, UNIX, J2EE, PL-SQL, Korn Shell, Visual Studio, Visual Basic, Cold Fusion, JSP, ASP, Oracle Designer 2000, Data Modeling, Database Design, RTI


1999 -  2000
State of Indiana-Senior Consultant and Software Architect

:
Design and develop a Web enabled DB2 Data Warehouse for FSSA division ;
Convert IBM COBOL/CICS/DB2 and SAS programs and provide Inventory reports with Crystal Reports tool
Coolgen, Access, SQL Server 7, IBM, DB2, COBOL, CICS, IDMS, Telnet, FTP, ASP, JSP, VBScript Visual Basic, Java, JCL, SAS, GEAC, PDL, Oracle 8, PL/SQL, NT Admin/scripting


1997 -  1999
Eli-Lilly-Project Leader/Technical Consultant

:
Develop web forms to replace existing legacy forms ;
Coordinate the Y2K efforts for the CRIS department ;
IBM, SAS, COBOL, CICS, DB2, Rexx, Clist, Oracle 7 and 8, PL/SQL, Access, SQL, SAS, Telnet, FTP, Lotus Notes, Domino, Project, FrontPage, Dreamweaver, Cold Fusion, Java, JSP, ASP


1997 -  1999
ForInstance.com-Senior Web Developer/Team Leader

: :
Develop Access Database catalog for pricing and e-commerce ;
Develop a web site for software sales ;
Develop Intranet based Worldwide sales partners site for Eli-Lilly
Cold Fusion, Java, Access, HTML, JSP, ASP, PHP, IDMS, ADSO, Project, Jscript

BrightPoint-Systems Architect and Team Leader 1998 : Develop feasibility report and sales proposal for Web integration of Customer support


1996 -  1997
RiteAid-Project Manager/Senior Technical Consultant

:
Conversion of IBM HR/Payroll/Benefits application using GEAC/D and B Software
IBM, COBOL, SAS, CICS, DB2, JCL, Clist, Rexx, PDL, Millennium, SDT, TSO


1995 -  1997
Quantum Health Resources-Project Manager/Technical Lead

:

Staff Builders-Project Leader/Systems Architect 1995 : Design and code Client-Server solution for Billing and Accounts Receivables


1988 -  1995
International Search Consultant

Other Clients/Projects : State of Ohio GEAC PDL DB2 CICS JCL TOTAL ORACLE UNIX State of Texas GEAC/PDL/DB2/CICS/JCL/ORACLE/UNIX Belks Stores GEAC/PDL/DB2/CICS/JCL Reynolds and Reynolds GEAC PDL CICS DB2 JCL ORACLE UNIX Meade Re-Engineering GEAC/PDL/CICS/DB2/JCL Clark Oil GEAC IDMS ADSO Thomson Consumer Electronics GEAC/ORACLE/FORMS/UNIX/DB2 MCI IBM/DB2 Spring Air Mattress FoxPro/Dbase/Paradox Timken Mellon Bank BP Oil Alcan Aluminum Andersen Consulting MercyCare HealthCare Systems Arnett Clinic ebizscape.com doggongood.com gazoom.com Dish Network

GM/EDS Projects

Computer Operations, Technical Support, Programming and Project Leadership

Guide the staff through design and implementation of various projects, Technical Support department ;
Designed and Developed the change control system ;
Involved in the merger of 7 plants via the Integrated Financial system ;

Timeline Project Management, ORACLE, UNIX, Oracle Forms, IBM, COBOL, CICS, DB2, IDMS, ADSO, VSAM, CLIST, REXX, JCL, TSO, UNIX Shell Scripting, IMS, SQL, SAS, RLOGON, REXEC, RSH, TELNET, FTP, SQL-Server, NOVELL, Word, Project Management, Cold Fusion, HTML, Java, JSP, ASP, Maximo, SQR, Peoplesoft, Crosstalk, GEAC : Accounts Receivables, QuickTest, Accounts Payables, General Ledger, HR, Payroll, PDL, Screen Development, Design

Monthly Oracle training courses/certificates : PL-SQL, Stored Procedures, Designer Techniques, Forms Developer, Advanced Forms Development, Reports Developer 2001 - 2002, Heritage, Indianapolis, IN


2000 -  2001
Various seminars : Web Developer

HTML WML CSS Java JavaScript DOM XML ASP Web Project Management Web Architecting Heritage Indianapolis , IN


2000 -  2001

CBT s : Sun Java Courseware Oracle Courses Heritage Environmental Indianapolis , IN


1988 -  2000

Various seminars and CBT s : Web Enabling Visual Basic Powerbuilder Access Project Management IT2000 Indianapolis , IN




Education

Ball State University , Muncie , IN BS Computer Science Honors Program

USMC Computer Science School , Quantico , VA AS Computer Science - Valedictorian



Skills


Various seminars and CBT s : Leadership Skills, Project Management, Hire/Fire When to Know, Advanced COBOL Programming, JCL Techniques 1973 - 1988, EDS, Anderson, IN

Software : Microsoft : Visio, Visual Studio, Visual InterDev, Word, Excel, PowerPoint, Outlook, Project, Access, Backoffice, SourceSafe, FrontPage Image Composer, GIF Animator ; Oracle : Developer, Designer, Discoverer, Forms, Reports, Conversion Utilities, PL-SQL, Korn Shell, Pro*C ; Lotus : Lotus Notes, Domino, Web Client ; Allaire/Macromedia : Cold Fusion, Flash, Shockwave, Fireworks, Dreamweaver, Jrun, MX-Series, Fusebox ; Others : Crystal Reports, Ulead, Intersolv PVCS Version Manager, Visual Caf, Perl, Weblogic Server, Websphere/MQSeries, Versata, UNIX Shell, Manage-1, Design-1, Case Tools, Artificial Intelligence, Level-5, Focus, PDL, GEAC, D and B, DBS, Flashpoint, Intertest, Expiditer, Crosstalk, Reflections, TOAD, Peoplesoft, Crystal Reports, Peopletools, Peoplecode, SQR, ThinQ, Cyberdocs, FusionDocs, Hyena, LanDesk, NT Administrator, UNIX Administrator Languages : PL-SQL, SQL, VBScript, Visual Basic, C/C++, FORTRAN, PASCAL, TOTAL, PDL, Assembler, Java, JavaScript, PowerScript, Powerbuilder, COBOL, Korn Shell Scripting, Dbase, REXX, CLIST, PHP, XML, HTML, WML, HDML, JSP, ASP, IDMS, ADSO, CICS, SAS DataBases : ORACLE versions 6 through 9i, Access version 1 through 2000, Sybase/SQL Anywhere versions 1 through 7, Sql Server versions 4 through 2000, DB2 releases 1 through 6, Clarion, Informix, Clipper, Dbase, RDB, Mysql, Paradox, Foxpro MultiMedia : Fireworks, Freehand, MS Image Composer, Quest OS : Windows 3.11/95/98/Me/NT/2K/XP, HP-UNIX releases 9 through 11, DOS, SUN, AS400 LINUX Applications : Environmental, Banking, Pharmaceutical, Manufacturing, Telecommunications, Financial Services, Medical, Technical Support, Customer Service Michael J. Dalton Michael J. Dalton Contact : Page 1