From oracle-l-bounce@freelists.org Wed Jun 9 09:22:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i59EM6j12131 for ; Wed, 9 Jun 2004 09:22:16 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i59ELu612094 for ; Wed, 9 Jun 2004 09:22:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34A9672C0F9; Wed, 9 Jun 2004 09:07:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29208-41; Wed, 9 Jun 2004 09:07:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8221E72C02E; Wed, 9 Jun 2004 09:07:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 09 Jun 2004 09:06:12 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E20B72C483 for ; Wed, 9 Jun 2004 09:06:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28992-44 for ; Wed, 9 Jun 2004 09:06:12 -0500 (EST) Received: from troll.tpk.net (mail.tpk.net [216.107.198.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA2DF72C02B for ; Wed, 9 Jun 2004 09:06:11 -0500 (EST) Received: from MWF600XL (host216-107-212-43.tpk.net [216.107.212.43]) by troll.tpk.net (Postfix) with SMTP id 5EE20100C79 for ; Wed, 9 Jun 2004 10:25:31 -0400 (EDT) From: "Mark W. Farnham" To: Subject: RE: DBA not bottleneck Date: Wed, 9 Jun 2004 10:19:41 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <80D4A99A2715674EB2D256DAD89219F6044E86A4@dohsmail02.doh.ad.state.fl.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2336 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Construct a PERT (Program Evaluation and Review Technique)chart with loops for the business analysts. In the loop structure, show a task for you "handled identified rules," followed by a business analyst task "review improved results for additional ideas." This feeds back to their task "identify business rules to be enforced." The business analyst loops only break out when they take the path "business analyst swears that is all, business analyst documents all requirements in hard copy (of which you get a signed copy.) Show final your cleansing/testing task downstream from the completion of all the loops. Print out the CPM, and it will show that you cannot even begin your final task until the loops end, and that you cannot put a finite time span on the loops. This has the advantage of being a pretty picture AND accurately protrays the situation you have explained. If your management is good, this will help them understand the situation. I hope I didn't sound too snotty. In fairness to the business analysts, it really does help to see things when you're looking at a less fuzzy picture. So at the start it is as if they are too close to a Renoir and they need you to back them up from the points to see the picture. Only then do they realize they want you to fix color of the apparently purple cat. At that point, management will have to consider whether they should put a time limit on the iterations. Good luck. -- oh -- and make sure to count your time to construct the PERT (generally available in project management tools) -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula_Stankus@doh.state.fl.us Sent: Wednesday, June 09, 2004 9:04 AM To: oracle-l@freelists.org Subject: RE:DBA not bottleneck Guys, I am heading up a data cleansing effort. The process goes like this: -analysis done on current data -users define business requirements for data transformation if necessary -I ask questions because they often leave things out and this is what a good DBA would do -I write the process to clean-up data then ask users to test before we do in production -We do in production I have been leading the meetings each day (30 min) and documenting resolutions, next actions, responsible parties, yadayada. However, the user has come up with a number of business rules after going back and doing some analysis and saying "Well, I guess we didn't do that right the first time - and as much as I could I have been learning all the business rules and asking lots of pertinent questions" - all good everybody happy. However, managers say "Hey, this should be done by now - not realizing the detailed analysis and testing this requires and multiple people" - so I want to provide something back like how long it might take me to do - however, to be frank much of what I find when coding is more issues that need to be answered with a business rule that I cannot make up!!!!! So I do go the extra mile - not just fix the one thing - but also bring up pertinent and relevant issues and keep this train on track. If they do good analysis and it takes them X number of hours to do that it doesn't take me long to turn around the fix. If they miss something or in fixing that one thing I uncover yet something else on the system or need clarification it takes longer. So, what do I say to these managers???? I am more help on this in all areas but since once the issues are identified (which I am one of the persons who finds and is able to generalize into a more concrete problem and find patterns across the database ), analysis is done (which I often help with), business requirements specified (which I often ask pertinent questions for to get clarification), I am the last guy holding the bag writing the clean-up process - which is actually done speedy quick - but since it is the last thing in the overall process it looks like I have had lots of time to do this. Very frustrating. How do I help managers to understand this???? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------