Manager Technical
Resume:
RICHARD CROCKETT B.A., PMP, Cert.APM
**** ******* *****, *********** ******* L5L 1Z5
http://www.richard-crockett.branded.me acw8au@r.postjobfree.com
PROFILE
JDE Techno/Functional professional with proven success in a broad range of industries. Richard has in-depth experience assessing technologies, integrating and applying them to further corporate strategic goals. He has a vast experience in developing, unit testing and implementing solutions and teaching stakeholders to use them effectively. Goal-driven, detail oriented, logical thinker, effective communicator demonstrating superior technical and functional abilities. Adept to quickly understand business processes and systems application function, analyze, prioritize, organize and plan. Experienced in working with stakeholders and executive level management.
PROFESSIONAL EXPERIENCE
JDEE1Tips, Remote (Consulting)
JDE Consultant (Techno Functional &CNC) (Feb 2016 - Present)
Financial and Manufacturing Reporting and Interactive Forms Development
BI Publisher Reporting, Installation
One View Reporting, BSSV, XMLP, JDE Kernel, IoT and Mobile
Tools Release Installations, ESU/ASUs & Upgrade of EnterpriseOne environment
Package Build and deployment and troubleshoot related issues.
Creation of EnterpriseOne Path code and environment
Website maintenance and editing
Development (A/R, A/P, G/L, Inventory)
Several YouTube Video Productions listed under Educating Others section
Technical Environment: JDE E1 E910 & E920, Oracle 11g and 12c, DB2, SQL, Linux and AS400, Windows 2008 R2 and Windows 2012 R2
1897825 Ontario Ltd., Mississauga Ontario (Consulting)
JDE Techno/Functional Business Analyst (Sept 2015 - Feb 2016)
Sales Order Management, Procurement, Inventory
A/R, A/P, G/L
2hrs/day webex personal training and 5 hrs per day tutorial in the above listed modules.
Technical Environment: Oracle 11g, JDE E1 9.1 Demo on VMBox.
Scotiabank, Toronto Ontario (Banking)
Sr. Application Developer ECM(CMOD & iSeries) (Aug 2014 – June 2015)
Develop solutions in Content Manager OnDemand (CMOD) from spec to archive various input streams facilitating quick and easy retrieval from IRIS (xml based system) or the CMOD client.
iSeries development and maintenance to large volume data storage and retrieval applications.
Find solutions to difficult scenarios migrating from RDARS to CMOD storage applications.
Technical Environment: CMOD, iSeries, z/OS mainframe, FTP, SFTP, XML, MS Office, Confluence.
Baxter Corporation, Alliston Ontario (Pharmaceuticals)
JDE Business Analyst (April 2014 – July 2014)
Analyze current systems in place, document business processes and system integration points.
Prepare for implementation of JDE 9.1 Manufacturing, Supply Chain, Inventory, A/R, A/P, G/L and EAM to replace PRISM Manufacturing System in a Six Sigma environment.
Support Production System to remedy day to day issues and ID potential problems.
Technical Environment: JDE E1 9.1, Oracle, SQL, iSeries, StarLIMS, PRISM, XFP EBR, VMware, Zabbix
1897825 Ontario Ltd., Mississauga Ontario (Consulting)
JDE Developer (Oct 2013 - Apr 2014)
Strong experience on all E1 9.1 Tools like OMW, Table Design (TDA), Forms Design (FDA), ERW (Enterprise Report Writer),Business View design (BDA), Interactive Application Design, Data Dictionary (DD),Universal Table Browser (UTB), Processing Option Design Aid (PODA), Data Structure Design, Business Function Design Aid (BDA).
Power forms and sub Forms. Analyzing business processes and modifying existing applications and developing new forms with related business functions. Configure user security roles for new users.
Technical Environment: Oracle 11g, JDE E1 9.0 Demo on VMBox.
Canadian Tire Corporation, Toronto Ontario (Retail, Distribution)
Technical Lead, EIS-Infra Solutions (June 2013 – Sept 2013)
Lead Server Storage Migration moving approx 600 servers from EMC storage to SVC Storage.
Schedule and facilitate virtual meetings with Storage, Unix, Wintel, DBA's, Application Administrators, and Application Support teams to prepare for migrations. Ensure required resources are available and find alternates if required to meet schedule date.
Work with Service Level Managers and the Business to determine feasible future migration dates. Be alert to potential scheduling, resource conflicts and mitigate promptly. Be attuned to potential technical conflicts, uncertainties, and risk and mitigate promptly.
Technical Environment: EMC, SVC Storage. Unix, Wintel, Oracle. MS (OCS, Excel, Project).
1897825 Ontario Ltd., Mississauga Ontario (Consulting)
JDE BI Publisher Developer (Mar 2013 - May 2013)
Create report definitions, Associate Report with Batch Versions, Submit Report Versions from Batch, Monitor Report Definition from Batch Versions, Generate XML Data file, OneView Reporting
Technical Environment: Oracle 11g, JDE E1 9.0 Demo on VMBox, MS Word, Excel.
The PBAS Group, Toronto Ontario (Insurance TPA)
Project Leader (Jan 2009 – Feb 2013)
Lead programmers, testers to create EDI Claims Adjudication system to accept claims from Dental office through Canadian Dental Association backbone, adjudicate and return result to Dental office.
Lead team to build Web Portal accessed by Apple iPads facilitating board of director meetings. Change from paper to web meetings.
Compile business requirements with stakeholder input and lead developers, testers to create system to deposit claims payments directly to client’s bank accounts. Create BRDs reflecting requirements.
Business needs Forms Branding & Distribution method to add logos etc to reports & distribute to desired locations.
Test various COTS solutions and introduce PBAS to Symtrax group of products fulfilling a multitude of business requirements.
Manage Health & Welfare Projects (plan, execute, control, close projects. Post project support)
Assign, delegate issues to programmers with appropriate skill set.
Work with Regional Managers to identify and improve Business Processes as required.
Sr. Business Analyst/Programmer (Nov 2007 – Jan 2009)
Support all functions of Montreal Office in a French speaking environment.
Business needs quicker to market web development times. Find, evaluate and introduce PBAS to BCD products enabling rapid Web development resulting in 1000’s of hours saved per developer per year.
Negotiate 50% purchase price reduction of BCD group of products.
Purchase, install, train staff to use, lead business analysis, development of new application projects.
Technical Environment: IBM iSeries RPGIV ILE, SQL, Apache, Websmart, Nexus, iPads, Crystal Reports
Electrolux, Montreal QC (Manufacturing)
JDE Business Analyst (Apr 2007 – June 2007)
Analyze outgoing system to migrate functionality to JDE Manufacturing system.
Gather and document business requirements in clear concise BRD.
Develop functional requirements, system design specs to feed developer process. Develop test plans, test coordinate user acceptance testing (UAT).
Technical Environment: AS/400, Data3, JDE World
CertainTeed (formerly BPB, St. Gobain) Mississauga Ontario (Manufacturing)
iSeries Business Analyst/Programmer (May 2006 – Mar 2007)
Develop, unit test and debug new applications used to reduce processing time at month end.
Evaluate Web and Portal development tool serving from the i5 via Apache Web Server.
Present demo to IT Director and staff of the evaluated product. Negotiate purchase.
Train staff in development of web programs and portal with the evaluated package.
Technical Environment: RPG IV Freeformat, SQL, Websmart, Nexus, PML, CGI, HTTPS, CSS, HTML, Javascript
Cargill Minneapolis, MN USA (Food & Agriculture)
JDE Business Analyst (Jan 2006 – May 2006)
Production support for existing clients using J.D. Edwards OneWorld and World.
Analysis of current SAR status to determine what changes required
Apply SAR’s updates for two versions of JDE for (Russia) simultaneously.
Analysis of RPG programs, create specs for developers to create corresponding UBEs.
Technical Environment: JDE World 7.3.11, JDE E1 8.12, iSeries
Centaur Corporation, King City Ontario (Consulting)
JDE Analyst/Programmer (Nov 2005 – Jan 2006)
Install JDE OneWorld 8.11 on standalone server.
Study Centaur tutorials to learn JDE programming toolset, programming concepts and create programs.
Create APPLs, BSFNs, BSVWs, DSTRs, GTs, TBLEs, UBEs.
Technical Environment: Windows PC with JDE E1 8.11 Demo, AS400
Sony Music Canada, Toronto ON (Manufacturing, Distribution)
Sr. Analyst/Programmer (Apr 2005 – Aug 2005)
Consolidation of Sony (JBA) and BMG Music processing.
Analysis of both systems to determine missing & redundant data. Modification of RPG III and IV
New development in RPG IV ILE (free format, imbedded SQL) to do data migrations.
Technical Environment: AS400, Aldon Change Management, Linoma RPG Toolbox, Ezview, FTP, SFTP.
Bend All Automotive, Kitchener ON (Manufacturing)
Business Systems Analyst (Nov 2004 – Feb 2005)
Work with Business on Shop Floor to gather requirements for hand held scanner project.
Analyze needs and develop RPG programs to scan bar codes validating pallet contents.
Monitor for missing EDI transactions and determine cause of failure. Resend or Re-receive.
Technical Environment: AS/400, ERP Expert (Brain) Infor, RPG, imbedded SQL, scanners
Queen’s University & PMI, Kingston ON
Student (Sept 2003 – June 2004)
Completed B.A. at Queen’s (Sept 2003 – June 2004)
Completed PMP with PMI (June 2004)
Central Wire Industries, Perth ON (Manufacturing)
I.T. Coordinator (Apr 2003 - Sept 2003)
Steer the organization to a common platform, streamline information flow.
Oversee I.T. coordination at 5 manufacturing facilities in Canada & USA.
Evaluate systems in place at each location and the delta of information between them.
Technical Environment: NT Servers, Syteline ERP (Financials, Manufacturing).
Canadian Kawasaki Motors (Division of Kawasaki Heavy Industries), Toronto ON (Distribution)
Sr. Business Analyst, Programmer (JDE, iSeries) (Nov 1998- Feb 2003)
Assume all functions of previous I.T. Manager. Vendor Management, Status Reports to VP’s and Controller, production support of JDE and iSeries.
Lead JDE Financials implementation from conception to post implementation. Analysis of Mapics to discover gaps in JDE for customizations. Analyze and write programs to port data from legacy to JDE .
Identify need to modernize database. DDS files, rewrite OCL to CL, RPG II to RPG 400 and RPG IV ILE. Rename files without dot, change 2500 files, CL and RPG programs.
Implement electronic parts catalogue, parts ordering, unit registration, and claims processing system in 7 months with 1.5 programmers. (CGI, HTTPS, CSS, HTML, Javascript)
Evaluate JDE OneWorld replacing custom distribution for B2B web presence.
Identify need for, conceive, sell to management, supervise development of CRM system using Domino, Lotus Notes for District Managers utilizing laptops, replication.
Purchase and implement Domino and Lotus Notes. Obtain domains, ISP and ADSL.
Write parts, accessories receiving interface of custom system to JD Edwards (World).
Administer JDE System, troubleshoot problems, apply PTF’s, SAR’s, OS upgrades. End user training.
Technical Environment: AS400, Lotus Notes, Domino Designer, JDE 7.3.11, Websmart, Nexus
Prior to 1998
Kuehne + Nagel International, Etobicoke ON (Logistics, Customs Excise)
Sr. Business Analyst/Programmer
Remote Business Analysis, Gather Requirements in Portuguese speaking environment
Devise Project Plan to modify KN ORCHID system to accommodate Brazilian Law
Write on-line tracking system for Brazilian Head Office (Sao Paulo)
Analysis and modification of over 100 different reports, file layouts, entry screens.
Traveled to Sao Paulo to install modifications and train staff in Brazil.
Technical Environment: iSeries (AS400) RPG III, IV
Parmalat (formerly Beatrice Foods) Etobicoke, On (Food, CPGs, Distribution)
Sr. Programmer/Analyst (Brampton, Etobicoke)
Data Processing Manager (Kingston ON)
Programmer Analyst, Computer Operator (Kingston ON)
Technical Environment: IBM System 34, 36, AS400, iSeries, RPG II,III,400, IV.
EDUCATION
Queen’s University (Kingston) B.A. (Economics)
St. Lawrence College (Kingston) Data Processing Diploma
EDUCATING OTHERS via YouTube Videos
JDE E1 9.2 Demo Install: https://www.youtube.com/watch?v=Kp1O9GrN_gw
JDE IoT AIS Server Install https://www.youtube.com/watch?v=deHe0X4LqMk
How to Install & Config E1Page on 9.2 https://www.youtube.com/watch?v=38Mt7k91yas
How to Install OneView Reporting on 9.2 https://www.youtube.com/watch?v=cUDZdHfa0O0
How to enable BSSV on 9.2 Standalone https://www.youtube.com/watch?v=UrMgvlYiDssI
Integrate Google Maps with Cafe1 in 9.2 https://www.youtube.com/watch?v=gWh8ah1MuuA
CERTIFICATIONS AND TRAINING
Oracle Cloud: Run, Manage Infrastructure as a Service, Platform as a Service Partner Workshop (2016)
JD Edwards Functional (Procurement, Sales, Inventory Management) – JD Edwards Trainers (2016))
PMP Project Management Professional (PMI)
Cert.APM Certified Agile Project Manager – Scrum Master (Project Management Association of Canada)
JD Edwards Enterprise One 9.0 Accelerated Developer Course from Andy Klee 2014
Oracle BI Publisher Embedded, OneView Reporting, BI Publisher 2013.
PMI - Agile Certification Professional (ACP) Training, Fall 2013
Gov of Canada Security Clearance: Secret (Level II)
TOOLS and TECHNOLOGIES
Operating Systems OS400, Windows (XP, 7, 10, 2008 R2, 2012 R2), DOS, OS2, Linux
Databases IBM DB2, Oracle, SQL, Foxpro, Access
Hardware IBM AS400, Wintel & Unix Servers, PCs
Network Routers/Switches/Bridges/Hubs/VPNs/Wifi
Storage Equipment Mainframe, SAN, EMC, SVC
Development iSeries & JDE, Technical & Functional, PML, Crystal Reports, Websmart, Nexus
Utilities Sharepoint, MS OCS, Outlook, Planview, Lotus Notes, VMware, Zabbix, Confluence
ERP JD Edwards E1 8.12, 9.0, 9.1, 9.2. JD Edwards World 7.3, Syteline, Brain by Infor, Prism
High Volume Storage/Retrieval CMOD (Content Manager
PROJECT HIGHLIGHTS
Business Analysis Tools - Project, Visio, Powerpoint, Excel, Planview, Sharepoint
Methodologies: Waterfall, Agile
Project Overview
Infrastructure: 600 Server Migration from EMC to SVC storage
Development: Installed JDE 9.1 Standalone @home. Took Andy Klee Accelerated Developer Course & Oracle BI Publisher Embedded and OneView Reporting .
Development: Create Digital Health & Dental Insurance Claims Adjudication System
Development & BPR: Digital Student Insurance Claims system for mobile devices.
Development & BPR: Create Web Portal for “Board of Director Meetings” for iPads.
Data Migration: Analyze, Plan, Lead Legacy DB2 files to JDE DB2 financials
Infrastructure: Size, Negotiate, Implement IBM mainframe model 720 to replace existing
Development (ERP): JDE Financials Implementation to replace legacy system.
Development: Negotiate, purchase, install, RAD Web development tool. Train staff.
Infrastructure: Replace network in distribution centre with new routers, racks and cabling.
Development: RFx’s for forms branding and distribution system. Evaluate and select product. Negotiate, purchase, install, and train staff.
Development: Create Digital Online Parts Order Entry System to replace modem system.
Infrastructure: Spec, negotiate, purchase, install mid range system and peripherals
Development & BPR: Create CRM sys using Domino Designer to replace paper system.
Data Migration & BPR : Migrate Foxpro claims system to DB2 & iSeries
Development: Create digital direct deposit system to deposit cheques to bank accounts.
Development: Warehousing and Product Ordering system using History to Forecast.
Development: Integrate Brazilian Import/Export System to World Wide System.
Budgets Managed $50,000 - $1.5M
Team Size
Up to 15 with skill sets as follows: Wintel & Unix, Storage Team, BAs, DBAs, Developers, Testers, Vendors, Contractors, Network Administrators, App administrators, App Support
Industries (national and multi-national)
Retail, Wholesale, Pharmaceutical, Distribution, Manufacturing, Logistics, Customs & Excise, Insurance TPA, Food and Beverage
Contact this candidate