際際滷

際際滷Share a Scribd company logo

Lean Transactional

Dave Nave
Dave Nave

This document contains information about improving productivity from 13 reports per person per week to 290 reports per person per week through implementing lean processes like reducing product flow time and improving information access. It includes diagrams of current and proposed file and data flows, as well as definitions of skill levels for different roles from novice to expert.

1 of 7
Download to read offline
LEAN In The Of-ice 13 Reports/Person/Week To 290 Reports/Person/Week
Product Flow Access TBSTailored Business Stream TNCNet Change DBQ Demand By Quantity NCD Net Change Date DBDT Demand By Date (Text) DBDD Demand By Date (Date) SUMMARY T - Files (Quantity Data) DAT - Files (Date Data) TBS and Net Raw Data Cool Tool SCMO/TBS Report Flow Large Files DAD - Files (Date Data) AP TBS Access Database A A SROA (CAS) Flat File FOS Main Frame Data Path Location to Save Legend SHARE
Process Flow Customer Request Architect Outside Group Legacy Systems Mainframe Customer Time Measurement Segments DM Informa6on Flow Currently Tracked Currently Tracked: 1. Time for DM Extract People 2. Customer Need versus Actual completion Need: 1. Track Outside Group times 2. Architect Processing times 3. Customer request to Architect times DM (Specials) DM (Repeaters) Data Bases PED 253 PICSLOAD(2) BLISS CoolTool Customer Request Architect Debbie Outside Group Legacy Systems Mainframe Customer Time Measurement Segments DM non-specials Currently Tracked DM Data Bases PED 253 PICSLOAD(2) BLISS CoolTool Customer Request RDO Pat DMR Production Scheduling Kim DMR Manual Extract DMR Production Scheduling Kim RDO Pat Customer No6鍖ca6on Reports DMR non-specials Automation Architect Judy
De-ine Skill Levels SMM Systems Skill Levels 5/20/16 Novice Experienced Expert DM Usually works with guidance of Data- Architect/higher experienced team memeber Basic somputer skills Completed work verified by Data-Architect/higher Up to 3 data sources No calculations required Works independently Completed work reviewed by Expert/Data-Architect Up to 5 data sources Chart results (simple) Basic calculations Works independently Assists novice and experienced team memebers as required Completed Work is sent directly to customer Identifies skills requirements Up to 7 data sources Chart results (Complex) Advanced display techniques DMR Production Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements Management Visibility Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements VBA/Formulas Requires close guidance Basic Computer Skills Completed work verified by Expert Works with No Guidance Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements MAIDS (Job) DMR Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements Access Database Development Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements MMO Web Development Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements
Assess Skill Levels MMO Business Systems Sustaining Skills Identification Management Visibility SROA DMR Production DM VBA/Formula Programming Future Product MAIDS (Job) DMR Access Database Development MMO Web Develoment Melissa Bury Expert Experienced Novice Tricia Carlisle Experienced Natalya Datskiv Experienced Expert Experienced Novice (VBA) Novice (Formulas) Novice Babara Gramann Experienced Expert Experienced Novice John Kelly Expert Experienced (VBA) Experienced (Formula) Experienced Kim Kilgore Novice Novice Lee Lana Experienced Novice Experienced Novice Manuel Mariano Expert Experienced Novice (VBA) Expert (Formula) Novice Novice Clark Carboneau Experienced Expert Experienced Novice Casey Nelson Expert Expert Novice Don Phillips Expert Expert (VBA) Experienced (Formula) Novice Johnnie Trull Experienced Experienced Rob Sheverbush Expert Experienced Novice (VBA) Experienced (Formula) Novice Experienced
Map Load Board Management Visibility SORA DMR Production DM Formulas VBA Software Development (MACRO'S) Future Product MAIDS (Job) DMR DMRAutomation Visibility WebSite NewRequests JobDmr CrossTraining Macro Metrics Documentation Safety 5S Lean?POU Melissa Bury X X Natalya Datskiv X X X Babara Gramann X X X John Kelly X X X X Kim Kilgore X Debbie Kosko X Lee Lana X X X Manuel Mariano X X Ali Naimi X X X X Clark Carboneau X X X X Casey Nelson X X Don Phillips X X X X X Jill Prichard Rob Sheverbush X X X Today Tomorrow 2nd 3rd Not Scheduled CQI Teams JudyMatsumoto/RichLefrandt JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER Customer Name:________________ Job Order Number:______________ ECD:_______ Flow Time:________
Load Board

More Related Content

Lean Transactional

  • 2. Product Flow Access TBSTailored Business Stream TNCNet Change DBQ Demand By Quantity NCD Net Change Date DBDT Demand By Date (Text) DBDD Demand By Date (Date) SUMMARY T - Files (Quantity Data) DAT - Files (Date Data) TBS and Net Raw Data Cool Tool SCMO/TBS Report Flow Large Files DAD - Files (Date Data) AP TBS Access Database A A SROA (CAS) Flat File FOS Main Frame Data Path Location to Save Legend SHARE
  • 3. Process Flow Customer Request Architect Outside Group Legacy Systems Mainframe Customer Time Measurement Segments DM Informa6on Flow Currently Tracked Currently Tracked: 1. Time for DM Extract People 2. Customer Need versus Actual completion Need: 1. Track Outside Group times 2. Architect Processing times 3. Customer request to Architect times DM (Specials) DM (Repeaters) Data Bases PED 253 PICSLOAD(2) BLISS CoolTool Customer Request Architect Debbie Outside Group Legacy Systems Mainframe Customer Time Measurement Segments DM non-specials Currently Tracked DM Data Bases PED 253 PICSLOAD(2) BLISS CoolTool Customer Request RDO Pat DMR Production Scheduling Kim DMR Manual Extract DMR Production Scheduling Kim RDO Pat Customer No6鍖ca6on Reports DMR non-specials Automation Architect Judy
  • 4. De-ine Skill Levels SMM Systems Skill Levels 5/20/16 Novice Experienced Expert DM Usually works with guidance of Data- Architect/higher experienced team memeber Basic somputer skills Completed work verified by Data-Architect/higher Up to 3 data sources No calculations required Works independently Completed work reviewed by Expert/Data-Architect Up to 5 data sources Chart results (simple) Basic calculations Works independently Assists novice and experienced team memebers as required Completed Work is sent directly to customer Identifies skills requirements Up to 7 data sources Chart results (Complex) Advanced display techniques DMR Production Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements Management Visibility Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements VBA/Formulas Requires close guidance Basic Computer Skills Completed work verified by Expert Works with No Guidance Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements MAIDS (Job) DMR Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements Access Database Development Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements MMO Web Development Works Independently with Guidance Basic Computer Skills Completed work verified by Expert Works Independently Completed work Reviewed by Expert Works with Customer for clarification Defines and Guides Work of Novice/Experienced Completed Work is sent directly to Customer Identifies Learning Experiences & Requirements
  • 5. Assess Skill Levels MMO Business Systems Sustaining Skills Identification Management Visibility SROA DMR Production DM VBA/Formula Programming Future Product MAIDS (Job) DMR Access Database Development MMO Web Develoment Melissa Bury Expert Experienced Novice Tricia Carlisle Experienced Natalya Datskiv Experienced Expert Experienced Novice (VBA) Novice (Formulas) Novice Babara Gramann Experienced Expert Experienced Novice John Kelly Expert Experienced (VBA) Experienced (Formula) Experienced Kim Kilgore Novice Novice Lee Lana Experienced Novice Experienced Novice Manuel Mariano Expert Experienced Novice (VBA) Expert (Formula) Novice Novice Clark Carboneau Experienced Expert Experienced Novice Casey Nelson Expert Expert Novice Don Phillips Expert Expert (VBA) Experienced (Formula) Novice Johnnie Trull Experienced Experienced Rob Sheverbush Expert Experienced Novice (VBA) Experienced (Formula) Novice Experienced
  • 6. Map Load Board Management Visibility SORA DMR Production DM Formulas VBA Software Development (MACRO'S) Future Product MAIDS (Job) DMR DMRAutomation Visibility WebSite NewRequests JobDmr CrossTraining Macro Metrics Documentation Safety 5S Lean?POU Melissa Bury X X Natalya Datskiv X X X Babara Gramann X X X John Kelly X X X X Kim Kilgore X Debbie Kosko X Lee Lana X X X Manuel Mariano X X Ali Naimi X X X X Clark Carboneau X X X X Casey Nelson X X Don Phillips X X X X X Jill Prichard Rob Sheverbush X X X Today Tomorrow 2nd 3rd Not Scheduled CQI Teams JudyMatsumoto/RichLefrandt JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER JOB ORDER Customer Name:________________ Job Order Number:______________ ECD:_______ Flow Time:________