1 / 32

National Marine Fisheries Service

National Marine Fisheries Service. FIS Electronic Reporting Special Interest Group: West Coast Groundfish Trawl Catch Share Program - Individual Fish Quota System (IFQ). Presented by: Richard Kang Scientific Data Management, NWFSC Seattle, WA Aug. 24, 2011. Welcome to the Information Age

roanna-cox
Download Presentation

National Marine Fisheries Service

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Marine Fisheries Service FIS Electronic Reporting Special Interest Group: West Coast Groundfish Trawl Catch Share Program - Individual Fish Quota System (IFQ) Presented by: Richard Kang Scientific Data Management, NWFSC Seattle, WA Aug. 24, 2011

  2. Welcome to the Information Age and Electronic Reporting 11/29/2014

  3. What is Data Management? The development, execution and supervision of plans, policies, practices, and programs that control, protect, deliver, and enhance the value of data and information assets. Data Management Association International (DAMA) 11/29/2014

  4. 11/29/2014

  5. NMFS customers can confidently find, access, and use our data. “Deliver the right data, information, and services when and where they are needed.” "To effect a cultural change in which all NMFS data are recognized and managed as a core agency resource, on par with financial and human resources." 11/29/2014

  6. The Magnuson-Stevens Fishery Conservation and Management Act – Oct. 11, 1996 and 2007 • NMFS Catch Share Program • May 2010 - First meeting with NWR • June 2010 - Started Requirements gather process • Sept 2010 - No contractors on board til end of month • Sept – SER lockdown visit (Irene • Nov 2010 - first Prototype • Dec 17, 2010 – Requirements Completed • Dec - User reviews and changes to interface • Dec - working weekend and nights (web conference) • Jan 2011 - Testing,Testing,Testing • Jan 2011 - Multiple releases, collisions, and coordination • Jan 11, 2011 12:00 - West Coast Groundfish Catch Share Trawl Program or IFQ launched • Jan – Parties with SDM • Numerous releases and fixes • Mar - Presentation to Pacific Fisheries Council • June – Maintenance • Aug 2011 – Phase II Admin and Renewals development 11/29/2014

  7. Tools: • Oracle DB Ver. 10 • Oracle Designer 10 • Oracle ApEx 3.0 for reporting/Adhoc Query reports • Oracle SQL Developer/Toad • Subversion version control • Java (middle tier and web service) • PL/SQL • Adobe Flex 3.0 (Action Script) • Visio, Flex Designer (Visual Interface) • Oracle and Beehive Collaboration Suite • NWFSC Infrastructure – secured 11/29/2014

  8. 11/29/2014

  9. Deliver IFQ Application Database in 6 months by Jan. 1 2011 Actual Implementation Jan. 11, 2011 at 12:00 PM Functional Requirements (Use Cases) Legislation, Policy, and Business Rules Functions and Entity Analysis Review Existing Systems Discoverable Metadata In InPort 11/29/2014 IFQ Pilot Year Jan. 11, 2011 User Acceptance Review

  10. IFQ Development Portal 11/29/2014

  11. IFQ Collaboration, Document and Content Management

  12. 11/29/2014

  13. Data Flow Process 11/29/2014

  14. QA/QC Process 11/29/2014

  15. IFQ Entity Relationship Diagram 11/29/2014

  16. Data Dictionary 11/29/2014

  17. Function Hierarchy 11/29/2014

  18. IFQ Database Environment and more

  19. IFQ Release Process 11/29/2014

  20. IFQ Production 1.3.3 Training Videos IFQ Application User Help Guide Query & Search Tool

  21. 11/29/2014

  22. Next Steps • Phase II IFQ administrative requirements and enhancements – Summer/Fall 2011 • Account renewals for 2011 • Economic Data Survey database system linkage • Year 2 rollover on Jan. 1, 2012 • Complete detailed system documentation • Implement scalable redundant array cluster (RAC) • Apply lessons learned to on-going projects for further integration • Observer Program development Oracle DB Observer in Database and Apex Website Observer Client in Apex and Oracle XE DB – Dec. 31, 2011 Observer Program Logistics Database – Oct. 1 Observer with AdHoc Query in Apex/GIS - 12/2012 • Celebrate team successes 11/29/2014

  23. Economic Data Survey Collection built in 6 weeks 11/29/2014

  24. 11/29/2014

  25. Metadata Card Catalog https://inport.nmfs.noaa.gov/inport/item/11090 11/29/2014

  26. Lessons Learned • Borrow, learn, and adopt what others have done, • ASK FOR HELP!!! • Alaska Region and Center, Pacific States, Southeast Region*, NWR, OLE, NWC and potential users • Capture extensive business requirements and rules from all participants, extensive review process and the Regs • The right people, tools, methods, and budgets • User feedback, bugs, and timely responses until resolved, • Try new tools (Adobe Flex) and processes (Subversion) leverage past successful efforts (Oracle ApEx, PL/SQL/Java) and enterprise infrastructure supported by IT, • Web services/ODBC to integrate disparate DB over the web • Top Down, Agile, and Spiral (don’t get stuck on methodology). • Data QA/QC resolution issues will take significant time and resources as part of maintenance 11/29/2014

  27. Conclusions Data management and Electronic Reporting is successful when your project: • supports agency’s high priority mission, • will result in positive management support, • sufficient budgets, • the right people, tools, and methods, • meets tight timeframes • appreciative customers, • lead by successful examples, • celebrate successes, • Just Do It and Deliver and hope you survive! 11/29/2014

  28. 11/29/2014

  29. Q & A Crew for hire. Will share code and knowledge. Contact SDM Helpdesk 11/29/2014

  30. Websites NWR and NWC Websites: https://webapps.nwfsc.noaa.gov https://webapps.nwfsc.noaa.gov/ifq http://www.nwr.noaa.gov/ 11/29/2014

More Related