Keith Shumate Email & Phone Number

INDEPENDENT CONSULTANT, October 2010 to PresentPROVIDE - Technical Management, Analytical, Design and Technical Consulting forOracle Application Server, Discoverer and Oracle PortalOracle SQL and PLSQL, Stored Procedure, Functions, Packages and TriggersJDE Application and UBE DevelopmentData Warehouse Design, Creation and ManagementEmail bshumate@cinci.rr.comCell 513-250-6081 Oracle 10R2, 11R2, PL/SQL, Stored Functions,Procedures,Triggers,PackagesOracle PortalOracle DiscovererVisual Studio 2010Create Web Services through Visual Studio and / or OracleJDE CNCJDE Application and UBE Analyze Design and Code. Data Warehouse Analisis and Design for JDE Enterprise One, Vers 8.0 - 9.0Data Marts - Sales, Operations, MarketingTools:Oracle 10R2, 11R2Oracle Application Server, Portal, Discoverer.Oracle PL/SQL, Functions, Procedures, Triggers, PackagesTechnical Proficiencies:Oracle 10R2, 11R2, PL/SQL, Stored Functions,Procedures,Triggers,PackagesOracle PortalOracle DiscovererVisual Studio 2010Create Web Services through Visual Studio and / or OracleJDE CNCJDE Application and UBE Analyze Design and Code. Data Warehouse Analisis and Design for JDE Enterprise One, Vers 8.0 - 9.0Data Marts - Sales, Operations, MarketingTools:Oracle 10R2, 11R2Oracle Application Server, Portal, Discoverer.Oracle PL/SQL, Functions, Procedures, Triggers, PackagesOneWorld Oracle 7.3.4 through 11g -- MS SQL ServerOracl Portal -- PL/SQL Programming -- ASP -- Data Warehouse Development

Analyze and Design Process for Data WarehouseDefine Data MartsDefine Star SchemasCreate PL/SQL Routines to extract data to WarehouseDirect Internal and External Resources for Design Processes Analyze and Evaluate Manual Business Processes for Conversion to Automated Processes. Analyze and Design Automated Processes.:Processes Designed. Online expense reporting to interface with JDE accounts payable. All actions are paperless and loads directly to JDE by executing a post. ASP interface to OneWorld for Emailing COA's to customersASP interface for generation of VOC and HAPS reports and ability to Email to customersASP interface to Email invoicesCustomer service web site allowing customers to check order status, invoices, stocking levels as well as custom reports based on customersAnalyze, Design and Modify OneWorld applications and UBE's.Numerous application and UBE modifications.Primary FocusAR/AP, Sales Order Process, LogisticsCustom ApplicationsEnhanced Track and TraceBusiness Unit Cross Reference A/R notes - Track late payment callsProforma Work orderSales history update for price and costYield PercentCustom Physical Inventory SystemPerform OneWorld CNC FunctionsSoftware InstallationPackage BuildsPackage DeploymentObject ConfigurationSecurityMaintain Oracle 9i and 10g Databases.InstallMaintain Users, RolesTuningBackup and recoveryAnalyze, Design Procedures and Triggers PL/SQL

Independent Consultant, Email bshumate@cinci.rr.comCell 513-250-6081Reasonable rates: 90 days or less $150.00 an hour, flat rate $6,500.00 week.91 to 182 days $135.00 an hour, flat rate $5,800.00 week.Over 182 days $125.00 an hour, flat rate $5,400.00 week.Client covers all transportation and lodging Costs.Client covers meals not to exceed $55.00 per day.Currently under contract, First availability Feb 21st unless current client requests an extension.Skills: All skills 10+ years Experience:Oracle 10R2, 11R2, PL/SQL, stored functions and procedures. Triggers.Oracle PortalOracle DiscovererVisual Studio 2010Create Web Service through Visual studio and / or OracleJDE CNCJDE Application and UBE Analyze Design and Code.Create Data Warehouse for JDETools:Oracle 10R2Oracle Application Server, Portal, Discoverer.Oracle PL/SQL, Functions, Procedures, Triggers, PackagesAnalyze and Evaluate Manual Business Processes for Conversion to Automated Processes. Analyze, Design and Modify OneWorld Applications and UBE's.Analyze Define and Maintain Customer Service WebsitePerform OneWorld CNC FunctionsAdminister Oracle 9i and 10g Databases.PL/SQL Programming.Responsible for Business Continuity Processes Disaster Recovery, Oracle DatabasesDevelop and Maintain ASP and ASP.NET Web Programs to Supplement OneWorldExperience OneWorld 10 + yearsOracle 10+ years 7.3.4 through 10gPL/SQL 10+ yearsVisual Basic 12+ yearsASP 7+ yearsData Warehouse Development 3+yearsASP.net with Visual Basic.net 3+ yearsOracle Discoverer 3+ years

Duties: Consultant, various Design and programming assignmentsCOBOLVisual BasicCMRP Systems

Instructor, BASIC, COBOL, C, FORTRAN, RPG II, PASCAL