<p>This is how we do it Niels de Bruijn Business Unit Manager APEX Rotterdam, 22-MAR-2018 This is how we do it 2 Facts & Figures Independent Technology House with Cross-Industry Expertise Headquarter Ratingen (North Rhine Westphalia) 260 employed Founded 1994 Branches Dortmund, Cologne, Frankfurt am Main Top Company for Trainees & Students Privately- Owned Corporation Oracle Platinum Partner 28 Mio. Euro Revenue This is how we do it 3 About me Niels de Bruijn, Business Unit Manager APEX Born in 1977, married, three daughters, living in Ratingen Working for MT AG since DEC-2003 After working for 2 years as Oracle consultant for Oracle Nederland B.V. Track record with APEX since its inception Responsible for all APEX activity in the company Knowledge Portal: apex.mt-ag.com Presenting at Kscope, DOAG Conference, APEX Connect and APEX World amongst others ODTUG - Part of APEX Content Committee for Kscope DOAG Initiator & Conference Chair of APEX Connect 4 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways 5 Custom development of data-centric web apps Which kind of APEX projects do we have? This is how we do it Company-wide Department pragmatic strategical Java EE / .Net PC-database APEX Usage Approach About 90% About 10% 6 Migration from MS Access This is how we do it 7 Enterprise APEX: FondsProfiler @ Union Investment This is how we do it 8 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways Type 3: Fixed price In general: if the expectation differs more then 10-20%, prepare for a discussion! Type 2: T&M with time estimation for packages 9 Contract Types This is how we do it Type 1: Pure" T&M with limited responsibility 10 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways 11 Calculation: Time Estimation This is how we do it Talk with your customer to find out what REALLY is required Create (business) packages with activities Let 2 people independently estimate the effort 12 Calculation: Cost Calculation This is how we do it Create a business calculation and make your decision based on facts 13 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways 14 Keep APEX Structured This is how we do it Master Data Pages Use standard APEX components/wizards If you have loads of master data pages: consider our APEX Generator Transactional Data Pages Reduce the no of plugins Reduce the no of processes Reduce the no of validations Reduce the no of dynamic actions (also see: https://github.com/j-sieben/SCT) this all leads to maintainable pages 15 Transactional Data Pages: use custom fetch/save processes This is how we do it Page-specific View optional instead of" Trigger or Table Function APEX page Tables optional TAPI Page-specific Package View Persistence General business view General business package Business Logic APEX-specific layers See also the demo in the following webinar about moving from automatic to manual processes : https://attendee.gotowebinar.com/recording/8740432829026130689 16 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways 17 Enterprise APEX This is how we do it Selenium / Robot / Katalon Subversion / Git (PL/)SQL Developer Jira Jenkins Data Modeler APEX REST Data Services Tomcat (3th Party) Tools Skills HTML CSS jQuery APEX PL/SQL SQL Data modelling Project Management Test Management Delivery Management Database People Requirements Eng. Browserstack FOEX Plugins APEX Office Print 18 Enterprise APEX - Team This is how we do it A typical setup for APEX projects: 1 APEX Architect (8-16 hours/week) 1 Senior APEX Developer (fulltime) 1-2 APEX Developers (fulltime) 1 Project Lead (8-16 hours/week) As the project gets bigger, development tasks are divided across team members (Data Modelling, PL/SQL, APEX, UX, JavaScript) In small projects, QA is done by the developers 19 Enterprise APEX Guidelines This is how we do it Define project specific guidelines Willing to contribute? See github.com/doag Automate guidelines MT QA Plugin (available on apex.world) Advisor Tool, native in APEX Packaged App: "Standards Tracker" Security checks: APEX-SERT & ApexSec Mrz 2018 20 Enterprise APEX SW-development lifecycle (blueprint) This is how we do it MT AG 4. Development environment 8. Test environment 5. Versioning 11. Acceptance environment 13. Production environment 7. Build-process Customer 9. Diff. Tests* 2. Tickets 1. Contract 12. Diff. Tests* 6. Module tests *) Module-, Quality-, Integrations-, Performance-, Security-,, Acceptance- & Browsertests **) Release Notes, IT-concept, Installation guide Time tracking 10.1 SW-Delivery 14. Bugs/Features 3. Project plan Project lead Sponsor IT/Business Dept End user QA-specialist Developer 10.2 Docs** Dependencies Guidelines Manager Delivery Specialist Delivery Specialist 21 Enterprise APEX Automation is key to streamline development This is how we do it Automate backups Automate staging using Jenkins Automate testing using Selenium with Robot/Katalon 22 Enterprise APEX Agile Software Development Process This is how we do it Business-ready software Sprint Sprint-Backlog Product-Backlog 20-30 days 24 hrs 23 Enterprise APEX Communication This is how we do it Sprint planning Daily Scrum Meeting Sprint review Management reporting Customer reporting 24 Enterprise APEX MT Tools we use in our projects This is how we do it See: https://apex.mt-ag.com/tools QA Plugin* APEX Page Generator APEX Visualizer* APEX API Generator** LogChase for APEX* XLSX/PPTX Generator* *) Free download **) Free service on apex.mt-ag.com 25 Agenda This is how we do it Typical APEX Projects Contract Types Calculation Keep APEX Structured Enterprise APEX Takeaways 26 Takeaways This is how we do it Enterprise APEX projects takes more then a good developer APEX alone will not make a project successful Be aware of the importance of soft skills Aligning" people can be a challenge Time estimation is not for everybody Clearly outline the roles and tasks for each project before you start Keep APEX structured Use tools to automate common tasks @nielsdb http://de.linkedin.com/in/nielsdebruijn www.xing.com/profile/Niels_deBruijn http://blog.mt-ag.com/apex </p>