NorthEast Ohio Oracle Users Group Great Lakes Oracle Conference

2017 Great Lakes Oracle Conference (GLOC)

May 17 & 18, 2017
Cleveland Public Auditorium
Cleveland, OH

View the 2017 Conference Schedule at a Glance.

Click here to register.

Selected Presentations

Developer    DBA    Data Warehousing/BI    Oracle Applications    Other

APEX

Connecting APEX to Alternative Data Sources
Doug Gault, Gluent Inc.
APEX / Intermediate
APEX was built to run on Oracle Relational Data, but did you know there are ways to create APEX applications on non-Oracle data? If you need to access data from data sources outside the Oracle database with your APEX application, here's a quick presentation on how to do it. From ODBC/JDBC connections, Flat Files (read-only AND updatable, and even Hadoop) - each will be examined, explained and the pros and cons of each discussed.

Doug Gault has been working with Oracle since 1987 and with APEX since HTMLDB 1.5 and is an Oracle ACE Director Alumni. He has worked for large consulting companies, Oracle Software development, been self-employed and  is currently the Technical Director at Gluent Inc.

GET POST ORDS JSON: Web Services for APEX Decoded
Scott Spendolini, Sumner Technologies
APEX / All
Web Services in the APEX world are becoming more and more popular; however, there is still a lot of confusion as to what they are and how they could benefit the APEX developer.  After a review of the syntax and jargon associated with web services, this session will review and boil down web services to their basic components.  It will then demonstrate how APEX developers can start to use these powerful components - both to send and receive data from other sites. 

Scott Spendolini is president and founder at Sumner Technologies, a world-class Oracle services, education and solutions firm.  Scott is a regular presenter at many Oracle-related conferences, including Oracle OpenWorld, KScope, and RMOUG.  He is an Oracle ACE Director, an Oracle Certified Oracle Application Express developer, author of Expert Oracle Application Express Security and co-author of Pro Oracle Application Express.  Prior to reigniting Sumner Technologies in 2015, Scott was an APEX Practice director at Accenture and Enkitec from June 2012 through April 2015. He holds a dual bachelors degree from Syracuse University in Management Information Systems and Telecommunications Management.

jQuery & APEX Primer
Scott Spendolini, Sumner Technologies
APEX / All
As APEX continues to evolve, so does its integration with jQuery. For those few not in the know, jQuery is an open source JavaScript library that APEX makes heavy use of. This session will lay out the basics of jQuery and then explore how it is used within an APEX environment. It will use practical examples to illustrate how just a few lines of jQuery can make a good application great.

Scott Spendolini is president and founder at Sumner Technologies, a world-class Oracle services, education and solutions firm.  Scott is a regular presenter at many Oracle-related conferences, including Oracle OpenWorld, KScope, and RMOUG.  He is an Oracle ACE Director, an Oracle Certified Oracle Application Express developer, author of Expert Oracle Application Express Security and co-author of Pro Oracle Application Express.  Prior to reigniting Sumner Technologies in 2015, Scott was an APEX Practice director at Accenture and Enkitec from June 2012 through April 2015. He holds a dual bachelors degree from Syracuse University in Management Information Systems and Telecommunications Management.

Oracle Application Express and Oracle Multitenant
Jason Straub, Oracle Corporation
APEX / All
Oracle Mutlitenant is almost three years old now, and there are two ways Oracle Application Express can be installed in this architecture. The recommended installation option has changed since the release of Oracle Multitenant based on experience with internal implementations. This session will cover the installation choices, advantages of each, and the current recommended option. This session will also briefly introduce a new feature in Oracle Database 12.2 with respect to multitenant.

Jason Straub has been working for Oracle since 2000 and is a developer on the Application Express team. He has primarily worked on Application Express since the days when it was an internal tool used to build a calendaring system and most recently worked on the Oracle Exadata Express Cloud Service. Jason’s primary development responsibilities include installation and upgrade as well as integration features such as support for consuming Web services.

Dynamic Actions: Spice Up Your APEX Applications!
Jason Lyle, Sumner Technologies
APEX / All
Application Express (APEX) is awesome. That is all I need to say here, right? No? Okay, let me explain. Whether you have been coding for half your life or you just started yesterday, APEX provides an intuitive interface to let you quickly develop web applications. While your current application is functional, it could be better with dynamic elements: you can provide better contextual content and more visually appealing pages. You can do this by using dynamic actions, and you can learn about dynamic actions here! In this presentation, I will explain what a dynamic action is, what you need to understand to use them, and how (sometimes without any coding) you can use them to really take your application to the next level!

Jason Lyle has been developing APEX applications for most of his 10+ year IT career.  He is currently employed by Sumner Technologies, where he is a Principal APEX Developer, assisting clients across multiple industries to implement their APEX solutions.  His last few projects include integrating APEX with a single sign-on solution, designing and implementing an APEX solution integrated with a credit card payment processor, and integrating APEX with salesforce.com and IFS. He has experience as both a consultant and end user of APEX.  Before working at Sumner, Jason was an APEX consultant at Accenture and Enkitec and also work for OARNet, which is the research arm of the Ohio State University.  He was also a contributor on the wildly-popular APEX plug-in SuperLOV.

DATA WAREHOUSING/BI

Understanding Advanced Charts and Data Visualizations
Rick Hight, Polaris Associates
Data Warehousing/BI / All
Which data visualization should I use and why? This live presentation will cover how users using a myriad of data, can analyze and display the information in a meaningful chart format, from understanding pivot-based charts, to the more advanced outputs such as bubble, tree-map, box-plots and geospatial chart outputs that are being used by large corporations around the world. Additionally, it will explain the benefit of and business use cases of using advanced data visualizations.

Rick Hight is Reporting Solutions Specialist at Polaris Associates. He has presented papers at numerous Oracle conferences on strategies to achieve better results through efficient reporting. Polaris Associates offers an Operational Reporting solution for Oracle E-Business Suite called Reporting Workbench (http://www.polarisassociates.com) and self-service business intelligence solution for ERP/Cloud applications called ORBIT Analytics (http://www.orbitanalytics.com).

Next Generation Workforce Analytics with Oracle Business Intelligence Cloud Services (BICS) and DVD
Navneet Gupta, Deloitte Consulting LLP
Data Warehousing/BI / All
Workforce Analytics over cloud which is built using Deloitte industry domain knowledge and Oracle BI Cloud platform offerings can sources data from multiple systems like EBS, Sales Force, and csv files. It has rich data integration and uses single layer architecture for RPD modeling which takes less time than on premise OBIEE. Its security is delivered via Oracle's Identity Management platform; there are options to use snapshots for migration and backup and is easily scalable. This solution will help in understanding how cloud technologies can be leveraged by next generation organizations for insights into their workforce.

Navneet Gupta is a Specialist Master in the Analytical Information Management practice (AIM). He has work experience in On-premise/Cloud BIDW, Enterprise Data Hub, Data Lake, Data Governance, Data Quality, Data Modelling and Integration Services.

Cloud Transition and Lift and Shift for Oracle BI Applications
Prithvi Krishnappa & Richard Solari, Deloitte Consulting LLP
Data Warehousing/BI / All
Oracle has taken significant strides into its transformation as a “cloud first” company, resulting in a number of Oracle customers evaluating their cloud strategies. With the popularization of cloud platforms, organizations have a need to understand how to maximize benefits and minimize risks in moving to the cloud. This session is designed to address the methodologies that should be adopted for Oracle BI Applications for a successful cloud transition and some of the considerations organizational leaders should take into account for transitioning to the cloud.

Prithvi Krishnappa is a member of Deloitte’s Information Management Practice. He has over 14 years of BI / Data Warehousing consulting experience with a strong focus on Oracle BI solutions and has also delivered multiple projects on the Hyperion Platform for Financial Planning and Budgeting solutions as well as custom data warehouse solutions. Prithvi has in-depth experience as a BI architect in the Oracle BI Applications (OBIA) space with a focus on Cloud Enablement and Big Data Solutions

Richard Solari is a Director in the Deloitte Analytics and Information Management Practice and currently serves as the Oracle Business Intelligence and Analytics National Practice Lead.  His primary area of focus and expertise is Oracle Data Warehousing, Business Intelligence and Analytics for both On Premise and Cloud technologies and applications.  For more than 26 years Richard has led or contributed to dozens of large Enterprise Global Transformational Business Intelligence, Data Warehousing, Big Data and Advanced Analytics projects worldwide in a wide range of industries for many fortune 500 and 100 clients. He is a current board member of the Oracle Business Intelligence, Warehousing and Analytics Association (BIWA), was named by Oracle in 2009, 2010 and 2011 as one of Oracle’s Deputy CTOs for Business Intelligence and Analytics and was named to the program’s executive level in 2012.   Richard was the former Oracle Senior Practice Director responsible for Oracle's Business Intelligence and Data Warehousing National Practice. 

The Secret Sauce of ODI 11g Repository
Ankit Jain, Snap-On Business Solutions
Data Warehousing/BI / Intermediate
Now that you have been using ODI for some time, have you ever wondered what plumbing goes inside the ODI 11g repository structure? How can you liberate yourself from the ODI GUI to pull out information from the Master and Work Repositories by using your SQL skills? How can you automate some of your tasks, build reports from operator logs, do some random fact finding with minimal effort by accessing the metadata stored inside the repository? ODI SDK supports quite a few use cases but for that you need to know how to script using groovy or java. This presentation will let you do a lot with basic SQL, covering the important subject areas of the Work repository and how you can query the ODI meta-data using SQL. It will also cover some techniques of source code management using the data extracted from work repository.

A Cleveland resident, Ankit Jain has been working with Oracle technologies for over 14 years and over 7 years with the ODI suite. He currently works for Snap-on Business Solutions as a Project Manager.

Data Visualization for Oracle BI 12c and Visual Analyzer
Tim Vlamis, Vlamis Software Solutions, Inc.
Data Warehousing/BI / Intermediate
Oracle's Visual Analyzer tool is especially designed for data exploration, whereas traditional OBIEE dashboards tend to be designed for data explanation. What training and guidance beyond the built-in suggestion engine should you employ? How do and when should you include Visual Analyzer insights on existing OBIEE dashboards? How does Visual Analyzer change the way we visualize data and develop analyses and dashboards? Join the conversation as we explore these topics in an engaging presentation.

An expert in the visualization of data and the design of business intelligence dashboards, Tim Vlamis combines a strong background in the application of business intelligence (BI), analytics, and data mining with extensive experience in business modeling and valuation analysis, new product forecasting, and new business development processes and scenario analyses. As an Oracle ACE, Tim is an active speaker on BI and data visualization topics as well as marketing and business development. Tim earned an MBA from Northwestern University’s Kellogg School of Management and a BA in Economics from Yale University.

Forecasting and Time Series Analysis in Oracle Business Intelligence
Tim Vlamis, Vlamis Software Solutions, Inc.
Data Warehousing/BI / Intermediate
Forecasting is one of the most universally required (and reviled) business functions in analytics. OBIEE and Data Visualization now have the ability to automatically generate sophisticated forecasts with the click of a mouse. We'll explain how OBI uses R to construct both exponential smoothing and ARIMA models. We'll contrast the model choices and review when to use each and go into both how the automated models work as well as more configurable scripts. We'll also cover some of the most common *gotchas* that we've encountered in generating forecasts in real-world implementations.

An expert in the visualization of data and the design of business intelligence dashboards, Tim Vlamis combines a strong background in the application of business intelligence (BI), analytics, and data mining with extensive experience in business modeling and valuation analysis, new product forecasting, and new business development processes and scenario analyses. As an Oracle ACE, Tim is an active speaker on BI and data visualization topics as well as marketing and business development. Tim earned an MBA from Northwestern University’s Kellogg School of Management and a BA in Economics from Yale University.

To Build a Strong Data Integration Layer, Use ODI, DRM, and FDM!
Neil C. O’Donovan, Thirdware Solutions Inc.
Data Warehousing & BI / Intermediate
Are you putting in a lot of effort to collect data from disparate transaction systems or enabling business to analyze and make critical decisions? We enabled a leading Automotive OEM to rapidly measure and react to variances of product/volume mix, rate and pricing, resulting in a major impact on profitability. Handling massive data in manual spreadsheets or through a complex web of disparate transaction systems is a big challenge, but with ODI, DRM and FDM we successfully eliminated these challenges. Join us in this session to learn more about how we leveraged ODI, DRM and FDM to build a strong data integration layer. 

Neil O'Donovan is a dynamic consulting professional with over 20 years of experience in the Enterprise Performance Management field. Currently he is Associate Director - Project Solutions, with significant expertise in project management and designing and developing business intelligence applications. His project work includes experience with Hyperion Essbase, with over 20 Hyperion Planning project engagements, most recently in Hyperion Planning solution architect design and project management.

Data Visualization: The New BI Is Analytics
Sarah Zumbrum, Oracle Corporation
Data Warehousing/BI / All
BI has traditionally burdened IT. The business required complicated data models that made BI slower to implement and more rigid. While not necessarily wrong, the trade-off has been agility and integration with local data sources such as Excel files. While waiting for data models to be created, the need for actionable data insights has not stopped. This session will discuss traditional versus modern BI and analytics as well as a live demonstration of Oracle’s Data Visualization as a complement to modern BI and analytics.

Sarah Craynon Zumbrum is an Oracle ACE Alumni (Director) and an Oracle Hyperion Certified Implementation Specialist. She is currently a Senior Sales Consultant for Oracle on the Public Sector Business Intelligence Cloud Services team. She has previously worked in-house as a business intelligence architect and as an EPM consultant, specializing in the Hyperion suite of tools. She has spoken at ODTUG’s Kscope, OAUG’s Connection Point, ECO Conference, Chicago OUG, and RMOUG’s Training Days. As a previous member of ODTUG’s Board of Directors and Hyperion SIG Board of Directors, she took her graduation from the inaugural ODTUG Leadership Program to heart and loves to serve and help Oracle user groups.

Big Data - You Don’t Need No Stinking Use Case
Kerry Osborne, Accenture Enkitec Group
Data Warehousing/BI / Intermediate
One of the biggest impediments to adopting “Big Data”  has been finding a use case that justifies the expense of building out a new platform. It’s especially hard to justify moving an existing system, even if the existing platform is not meeting the needs of the business. This is due to the high exit cost, both in terms of cash outlay and risk. There are ways to move to new distributed platforms without re-writing existing applications, but what if I told you that you can get the speed and scalability of modern big data platforms without having to rewrite all your apps? This technical presentation will show several approaches to moving your data to Hadoop without breaking your existing applications. Several real-life examples will be discussed.

Kerry Osborne is an Oracle performance specialist. He is the founder of Enkitec; an Oracle-focused consulting company that was acquired by Accenture in 2014. Kerry has co-authored two Oracle books, Pro Oracle SQL (with Karen Morton) and Expert Oracle Exadata (with Tanel Poder).

Multi-Data Source Reporting & Self-Service Analytics
Rick Hight, Polaris Associates
Data Warehousing/BI / All
Is your company utilizing multiple data sources and applications? This presentation will show how you can combine information from any/multiple data sources to build meaningful reports, dashboards, and visualizations in minutes. Learn how using real-time operational intelligence can empower your users to ask questions, spot trends, identify opportunities, and make data-guided decisions with confidence.

Rick Hight is Reporting Solutions Specialist at Polaris Associates. He has presented papers at numerous Oracle conferences on strategies to achieve better results through efficient reporting. Polaris Associates offers an Operational Reporting solution for Oracle E-Business Suite called Reporting Workbench (http://www.polarisassociates.com) and self-service business intelligence solution for ERP/Cloud applications called ORBIT Analytics (http://www.orbitanalytics.com).

DBA

Oracle Performance Troubleshooting with ASH, Snapper and Other Cool Scripts
Tanel Poder, Gluent Inc.
DBA/All
In this session I'll show you the scripts and tools I (still) use regularly when troubleshooting Oracle performance or just checking what's going on in a database. We'll look into Snapper, ashtop, asqlmon, ash_wait_chains and some OS level tools too!
Tanel Poder is a co-founder and CEO of Gluent, a stealth-mode startup connecting the traditional enterprise world with the brave new world of Hadoop and Cloud. Interesting times ahead! 

Extending Oracle Data Warehouses with Hadoop
Tanel Poder, Gluent Inc.
DBA/All
In this session we will look into various different tools and techniques for moving data between an Oracle data warehouse database and Hadoop. The tools include various connectors and open source tools for data movement. This prepares you for the modern hybrid data management world, where all your Hadoop-based data is seamlessly blended together with traditional enterprise data.
Tanel Poder is a co-founder and CEO of Gluent, a stealth-mode startup connecting the traditional enterprise world with the brave new world of Hadoop and Cloud. Interesting times ahead! 

RMAN in Oracle Database 12c - Top New Features
Andy Colvin, Accenture Enkitec Group
DBA / Intermediate
Every DBA should know how to back up and recover a database - their job may depend on it one day.  In order to make backup and recovery easier, Oracle gives DBAs RMAN.  In Oracle 12c, RMAN includes many new features to make backup and recovery simpler and more robust.  This session will cover five of the top new features introduced in RMAN for Oracle 12c, coming from more than four years of experience with the product.  Discussion of each new feature will explain how it can be used by normal DBAs in their everyday work life - not just abstract discussions on features that will never actually be used in the real world.

Andy Colvin is an Infrastructure Principal Director with Accenture Enkitec Group, based in Dallas, Texas. He is responsible for the Infrastructure Team within AEG, primarily working on Oracle Engineered Systems with a primary role in configuration, patching, and systems stabilization. Andy began working for Enkitec in 2006 and has been focused on Oracle Engineered Systems since 2010. His background includes network, system, and database administration on a variety of platforms.

Track-a-Watt: Modify a Power Usage Tracker to Log Your Power Usage in a Database
Blaine Carter, Oracle Corporation
Developer / All
If you're like me, you use way too much power and you're not quite sure where. Tracking your power usage is a great start, but analyzing the data is often easiest when it's in a database. Having to type it in by hand would be a pain; let's void a warranty instead! Building on the 'Watch me make a Watt-watcher' tutorial, we'll have an overview of the steps and components used to assemble the hardware. Next, we'll discuss what to do with the data; we can save it to a file on our computer, upload it to a database, tweet it or whatever you'd like. Of course, I want my data in a database, so I'll simplify the data ingestion by taking advantage of a REST interface to a cloud database. I will walk through creating a table for the data and enabling a RESTful service on it, then modify the project to post data to our new service.  Once we get some data in the table, I'll display the data in a graph. You'll leave this session with the tools to track the data in your own projects and hopefully some new ideas.  (But no electrical burns!)

Blaine Carter started programming in 1995, using Oracle PL/SQL. He now tries to use a lot of languages and is a firm believer in open source technologies. His combined experience with Oracle Database and open source led him to a brand-new position at Oracle Corporation: Oracle Developer Advocate for Open Source. He promotes the use of open source inside and outside of Oracle.

Insiders Guide to Getting the Most Out of Database Compression and ILM
Gregg Christman, Oracle Corporation
DBA / Intermediate
Oracle Product Management will discuss Oracle compression best practices, tips and insights gathered from compression users across the globe, regarding data, index, LOB and RMAN backup compression. If you already use, or are evaluating, Advanced Compression or Hybrid Columnar Compression, come gain some new insights about Oracle compression. We will also explore how real-world organizations are using database compression tiering and storage tiering to automate Information Lifecycle Management, enabling them to meet their regulatory/business rules for data retention through the use of lower cost, high capacity Tier 2 storage. This session is the perfect opportunity to get your compression/ILM questions answered.

Gregg Christman is a Senior Manager in Database Performance Product Management at Oracle responsible for Advanced Compression, Hybrid Columnar Compression and Information Lifecycle Management. Gregg has been with Oracle for 10 years, having previously held the position of Director of Competitive Intelligence for Database and Data Warehousing. Before Oracle, Gregg was a Senior Product Manager for Enterprise Database Servers and the Director of Product Management and Marketing for Cloudscape at Informix Software. He is also a contributing author to the Oracle Database Storage Optimization blog https://blogs.oracle.com/ DBStorage.

DBAs Can Use Oracle Application Express? Is This Fake News?
Joel Kallman, Oracle America, Inc.
DBA / Intermediate
DBAs aren't Developers. They only setup and manage and monitor systems. They aren't Web developers. Right???? Wrong! Oracle Application is an easy-to-use framework for those people who are comfortable with SQL. And who uses more SQL than a DBA? This session will be a live demonstration of the numerous ways a DBA can exploit Oracle Application Express to their benefit - from simple database management tasks to monitoring the performance and activity of an Oracle Database. The Oracle Database contains a wealth of information, and you will see how easy it is to graphically visualize this in a modern Web application. No CSS or HTML experience required!

Joel R. Kallman is Senior Director of Software Development for Oracle's Server Technologies division at Oracle America, Inc.  He is responsible for the development and product management of Oracle Application Express,  has been at Oracle since 1996 and is the co-creator of Oracle Application Express.  He is a contributing author of several books on Oracle technology, including Expert One on One Oracle, Beginning Oracle Programming, and Mastering Oracle PL/SQL: Practical Solutions.   Joel holds a Bachelor of Science degree in Computer and Information Science from the College of Engineering, Ohio State University.

Provisioning Your First DBaaS Instance with Oracle Database Cloud Service
Ahmed Aboulnaga, Raastech
DBA / Novice
Moving to the cloud is inevitable, yet many haven’t started getting their hands dirty yet. This presentation will walk you through key Oracle Cloud concepts for those who have never seen or used it before, and walk through provisioning a cloud database, which includes storage and infrastructure. We explain how to access it and discuss various administration concepts. This presentation is perfect for the Oracle DBA who wants to understand how to get started administering an Oracle DBaaS environment, from a technical perspective.

Ahmed Aboulnaga is a Technical Director at Raastech, a systems integrator headquartered in Herndon, Virginia. Ahmed's professional focus is in technical management, architecture, and consulting within the Oracle Fusion Middleware stack, having implemented enterprise solutions for commercial, government, and global customers throughout the years. Ahmed is an Oracle ACE, OCE, and OCA, and has presented at OpenWorld, Collaborate, UKOUG, and various Oracle users groups in the past.

Do You Lack Stability in Your Life? Especially When it Comes to Oracle Execution Plans?
Janis Griffin, SolarWinds
DBA / Intermediate
Unexpected changes in execution plans can have disastrous effects on your database performance. Changes such as optimizer versions and statistics, schema/metadata definitions, and system settings can cause a plan to change, which often times is not for the better.  In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will explore the history of plan management and deep dive into the several features that can improve plan stability.   The participant will learn what causes plans to change and how to view the optimizer reasons for those changes. Janis will demonstrate how adaptive plans, cursor sharing and statistic feedback can impact plan changes. Finally, several case studies will be shown on how to use features such as baselines, patches, and profiles, to help improve plan stability.

Janis Griffin has over 25 years of Oracle DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds, Janis held DBA positions primarily in the Telecom / Network Industries, working with both real-time network routing databases and OLTP business to business applications.  As an Oracle ACE, Janis has mentored other DBAs and developers on best practices in database performance tuning.

Oracle Tables for DBAs and Developers
Daniel Morgan, Meta 7
DBA /All
Everyone who has written SQL for more than a few weeks thinks they have mastered creating tables: Unfortunately, this is not true. Almost every table created is a heap table and it is a heap table not because careful thought was given to all of the options but rather because most table types and optimizations are unknown to DBAs and Developers with 10+ years of experience. This presentation will demonstrate live in SQL*Plus creation of many optimized Oracle table types and explain when they should be considered to enhance performance and scalability. If you have never built a Sorted Hash Cluster or performed Attribute Clustering then this presentation is for you.

Oracle ACE Director Daniel Morgan has more than 25 years of experience working with Oracle products. He wrote the Oracle curriculum for the University of Washington, was the program’s primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is currently the Principal Adviser at the Meta7 division of Forsythe.

Masking and Obfuscation:  Methods and Pitfalls
Tm Gorman, Delphix
DBA / Intermediate
Data obfuscation, also known as data masking, is a responsibility and a requirement in an increasingly security-conscious world. In 25 years as an Oracle DBA up to 3 years ago, it was not a big part of my job. Now, it is becoming so very quickly. Data masking should not be confused with encryption, and it should not be conflated with scrambling. When done well, a masked database is not noticeably obfuscated until you check closely. Masking data well should still leave it usable for many types of analysis, yet utterly useless for identifying confidential data. Masking is important enough that several sophisticated software packages are available, and these should be considered instead of re-inventing the wheel using custom programs. We should also be aware that each of these masking packages cannot overcome the data recovery capabilities built into most database systems like Oracle, so there is more to securing data than simply running masking. Come learn about masking, how it is used, where it is used, and where the gotchas lie. Encryption does not equal data security, and many security breaches nowadays occur in spite of encryption.

Tim Gorman is a technical consultant for Delphix who enable data virtualization to increase the agility of IT development and testing. Tim has co-authored six books on data warehousing and Oracle database administration, has performed technical review on eight more books, and has an author page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).  He is an Oracle ACE Director and a member of the OakTable.

Can You Imagine Your Oracle Database in the Cloud?
Biju Thomas, OneNeck IT Solutions
DBA / Novice
This session will introduce you to the various database cloud services available, real-world use cases and a live demo. You will also learn how to connect to a database in the cloud using SQL Developer, logging into the host machine running the database, migrating data to the cloud and a few best practices. Even if you do not move your database to the cloud, moving the database backups to the cloud may be an attractive option!

Biju Thomas is an Oracle ACE Director, Oracle Certified Professional and Certified Oracle Database SQL Expert. He is Principal Solutions Architect at OneNeck IT Solutions and has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He is a frequent presenter at Oracle conferences and writes articles for Oracle technical journals. He has authored Oracle certification books published by Sybex since Oracle8i, all versions including Oracle Database 12c OCA. Biju blogs at http://www.bijoos.com/oraclenotes and you can follow him on twitter (@biju_thomas) or Facebook (@oraclenotes) for daily Oracle Tidbits.

What's New in Oracle Database 12c Release 2
Willie Hardie, Oracle Corporation
DBA / All
Oracle Database 12c has been the most rapidly adopted release in over a decade. In this session we'll provide a technical introduction to what's new in Oracle Database 12c Release 2 (12.2), by focus area (e.g., performance, database development, etc.)

Originally from Edinburgh in Scotland and now based at Oracle's Redwood Shores HQ in California, Willie Hardie is Vice President of Oracle Database Product Management. Willie has been in IT for more than 30 years, specialized in relational database technologies for more than 25 years, and has worked with Oracle Database since version 5.

Adopting Agile Development Methodology and DevOps in Oracle Projects
Shay Shmeltzer, Oracle Corporation
DBA / All
Agile development methodology in combination with DevOps automation carry the promise of delivering applications faster and responding to customer demand more accurately. How do you adopt this approach when developing projects that revolve around the Oracle database? How do you increase code version control and developer collaboration for PL/SQL & SQL developers? How do you automate and control code to deploy cycles? How can you manage development teams and their tasks efficiently conducting development sprints? In this session we'll demonstrate unique capabilities offered by Oracle Developer Cloud Service for project management and devops automation of database-focused projects.

Shay Shmeltzer is Director of Product Management for Oracle Development Tools and Frameworks. He is focused on helping developers understand and leverage Oracle products to simplify and streamline their application development efforts. Shay frequently presents at industry events, publishes articles, and blogs regularly. He is on Twitter at @JDevShay.

On SQL Statement Parsing and its Performance Implications
Charlie Callaway, DaVita, Inc.
DBA / Intermediate
This presentation is about SQL statement parsing, what it is, how it affects database performance, and how to detect and correct parsing problems. We'll define what parsing is, and then walk through it in detail. This includes the initial checks (syntax, semantics, permissions), SQL_ID generation, and pointer creation from client process to private SQL area. We define what parent and child cursors are and why Oracle may be compelled to create multiple child cursors for the same SQL statement. We'll explain the concept of an execution environment, the definitions of soft and hard parsing, and why soft parsing is desired, and demonstrate how excessive hard parsing can negatively affect performance. We finish by discussing some ways to mitigate parsing problems: Use bind variables; consider using CURSOR_SHARING = FORCE; and less common causes such as bugs.

Charlie Callaway has been a full time Oracle DBA since 2000, using every release of Oracle since 8.0.4.  His career focus is performance tuning, troubleshooting, product evaluation, and coaching.  He enjoys finding how to make the most of the Oracle database platform, both through experimentation and learning from others. He has previously presented at the East Coast Oracle Users conference, The Rocky Mountain Oracle Users Group Training Days, and the Hotsos Symposium.

Database Security:  How Do I Get There?
Shawn McElhinney, Deloitte Consulting, LLP
DBA / Novice
Data drives business decisions, this is common knowledge.  Protecting this data is paramount, but how do you do it effectively?  Check out this session to get some ideas on how to approach this daunting task. It is not intended to focus on the implementation of specific technologies; rather it will help attendees move from theory to practice, answering questions such as what do I need to know; who should I work with; what questions should I be asking; and how do I translate my findings into an actionable plan?

Shawn McElhinney is a CISSP, CCSP and OCP technical consultant with nearly 20 years of implementation life cycle experience.  More than half of this experience has been spent providing technical expertise for several implementations of Oracle-centric technologies for Federal Government clients.  His skills primarily focus on Oracle AppsDBA work, but he continues to expand his skills in the areas of security and EBS supplemental technologies, such as Delphix and other third-party integrations.

Run Mixed Workloads on Exadata with Oracle 12cR2 New Features
Anuj Mohan, Data Intensity
DBA / Intermediate
It is a well-known fact that Oracle Exadata is one of the best platforms for consolidating database workloads as it offers a very efficient compression, software aware storage and resource management features . Oracle continues to add new features in 12cR2 which will be very helpful in running mixed workload. In this session you will walk through some of the key Exadata features which support consolidation and mix workloads like EHCC, Resource management, smart storage and flash cache along with Oracle multitenant and Oracle in-Memory. Highlights on 12cR2 new features like Memory I/O resource prioritization, lockdown profiles, SGA/PGA for PDBs, In-Memory with Active Data guard, and flash cache, fast start and ADO will be included.

Anuj Mohan is an Oracle ACE and frequent speaker at various Oracle conferences and local user groups, and a regular speaker at Northern Kentucky University (NKU). He is founder of Oracle12cSIG (IOUG) and has over 16 years of experience as an Oracle DBA. Anuj is an Oracle Certified Exadata implementation expert and Oracle Certified Professional (OCP) for Oracle 11g and 12c.

Virtualization in the Cloud Is Not Vaporware
Kellyn Pot'Vin-Gorman, Delphix
DBA / Intermediate
Cloud is everywhere and the database administrator is caught in the middle.  How do you decide what to move first, how much and doing it without losing your mind?  How do you ensure your company doesn't get charged for more than they should and what does the future hold for virtualization and the cloud?  This session answers those questions and more!

Kellyn Pot Vin-Gorman is a member of the OakTable Network and an Oracle ACE Director alumnus. She is the Technical Intelligence Manager for Product and Market at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with Enterprise Manager, virtualization, the command line interface, environment optimization tuning, automation and architecture design. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content.

Don't Worry, Be Happy - Automate Your Environment with Ease
Noelle Stimely, University of California - Berkeley
DBA / All
How many times do you wish there were more hours in the day?  What happens when a ticket comes to you for a “quick” refresh of a dev/test system while you are in the middle of an issue or a large project?  This presentation hopes to introduce methods to automate your environment.  What to look at and what to do so there will hopefully be more time in your day.  Automation is the key to a happy DBA.

Noelle Stimely is presently a Senior Performance Test Engineer at the University of California-Berleley.  Noelle has been an Oracle Database Administrator and holds certifications in Oracle 8/8i/9i/10g and HP LoadRunner.  She has held various positions including Lead Database Administrator, Senior Database Administrator and Oracle Instructor during her 20-year career.

Oracle RMAN Backups - Benchmarked and Best Practices
George Winter, Veritas, LLC
DBA / Intermediate
Oracle's RMAN technology has proven to offer reliable Oracle protection with powerful backup and restore capabilities. But do you really understand how RMAN is impacting your Oracle databases? And do you know the best RMAN method that will quickly backup your databases? We had the same questions so we performed detailed benchmark testing to determine how fast and scalable RMAN can be. The ultimate goal was to provide real-world backup and restore performance numbers on large, multi-terabyte databases. In this session we will discuss the results of this RMAN performance testing. Bring your technical Oracle data protection questions and join us to learn about benchmark tested strategies for protecting and restoring your valuable Oracle data.

George Winter's current focus is as a product manager in the area of Oracle database protection with Veritas NetBackup.  He enjoys focusing on performance topics related to data protection and has performed a number of performance benchmark tests including testing focused on Oracle protection.  Prior to joining Veritas, George was with Sun Microsystems as a System Support Engineer assigned to Oracle's corporate datacenter and spent a number of years as a UNIX Systems Administrator.  George has presented at numerous user conferences including Oracle Open World, Veritas Vision and VMworld.

DEVELOPER

Error Management Features of Oracle PL/SQL
Steven Feuerstein, Oracle Corporation
Developer / All
Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling and logging of errors, to standardize the way in which those tasks are performed. This session takes you beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more.  After attending this session, you will be able to fully leverage PL/SQL error management features, making it easier to identify the sources of problems and fix them more rapidly.

Steven Feuerstein is an architect for Oracle, specializing in PL/SQL. He also leads a team of Oracle developer advocates. Steven’s books, such as Oracle PL/SQL Programming, and more than a thousand PL/SQL quizzes at PL/SQL Challenge (plsqlchallenge.com) provide in-depth resources for PL/SQL developers.

Change Impact Analysis with 12.2 PL/Scope
Steven Feuerstein, Oracle Corporation
Developer / All
PL/Scope, first introduced in 11.1, offers a powerful code analysis tool, baked right into PL/SQL. With it, you can answer questions like 'Where is this variable modified in my code?' 'Which packages invoke a specific overloading of a function?' and 'Show me all my unused declarations.' Cool stuff. But prior to 12.2, SQL statements were not a part of that analysis. Now in 12.2, PL/Scope also gathers information about static SQL statements and where dynamic SQL is executed in your code. As a result, you can now use PL/Scope to perform comprehensive, detailed analysis of the impact of planned changes to your code base. In this session, Steven introduces attendees to PL/Scope, explores 12.2 enhancements, and provides scripts everyone can use to leverage PL/Scope in their dev environment.

Steven Feuerstein has been obsessed with PL/SQL since 1991. He wrote some books, taught some classes, rejoined Oracle in 2014. Steven is currently running a team of Oracle Database Developer Advocates.

Beat All Types of Deadlocks
Arup Nanda, Marriott International
Developer/All
You must have seen “ORA-60 Deadlock Detected”. It's purely an application design issue, right? Wrong. There are several causes of deadlocks; not just two sessions waiting on each other to commit. This session will explain other causes of deadlocks such as FK violations, bitmap indexes, direct path writes and so on. It starts with the explanations of deadlocks and why they occur; then goes into advanced topics such as how to read the seemingly cryptic deadlock trace files, how to generate more diagnostic information using specialized events and finally how to write your code to avoid or reduce the occurrence of deadlocks. Finally, we will close with some unconventional deadlock issues and how to handle them.

Arup Nanda has been working as an Oracle DBA for the last 20 years touching all aspects of the database from modeling to performance tuning to security and disaster recovery. He has presented 400+ sessions, written 500+ articles, co-authored 6 books and delivered training in 22 countries. He is an Oracle ACE Director, a member of OakTable Network, a member of Board of Directors of Exadata SIG and an editor for SELECT journal. He was the recipient of two prestigious awards from Oracle: DBA of the Year in 2003 and Architect of the Year in 2012.

Big Data for the Oracle Professional
Arup Nanda, Marriott International
Developer/All
Big Data is big news, with terms like Hadoop, spark, mahout, oozy ruling the roost. But what do they actually mean? In this session, we will explain the concept in a way most Oracle professionals will find easy to understand and associate with. For instance, how is a Hadoop cluster different from an Oracle RAC cluster, or, how is the term eventually consistent different from a normal SQL-based databases? If you wanted to enter the realm of Big Data and Data Science but didn't know where to start or were intimidated by the plethora of terms, this session is for you. At the end, attendees will understand what Big Data is, how Hadoop developed, how machine learning is used and so on, all examples sprinkled with the familiar Oracle concepts.

Arup Nanda has been working as an Oracle DBA for the last 20 years touching all aspects of the database from modeling to performance tuning to security and disaster recovery. He has presented 400+ sessions, written 500+ articles, co-authored 6 books and delivered training in 22 countries. He is an Oracle ACE Director, a member of OakTable Network, a member of Board of Directors of Exadata SIG and an editor for SELECT journal. He was the recipient of two prestigious awards from Oracle: DBA of the Year in 2003 and Architect of the Year in 2012.

Test Data Management at Light Speed
Kellyn Pot'Vin-Gorman, Delphix
Developer / Advanced
As technology finds faster and more efficient ways to deliver test environments in support of Agile initiatives, automation is only half the story. Test Data Management incorporates and fills the gaps left by test automation solutions and also offers self-service user interfaces, test coverage analysis and collaboration, test data lifecycle management, including branching, ability to deliver code and data issues to development for quick resolution, and sensitive data protection. As companies strive to build efficient and agile test data management, it's important to know, not just how to build environments quickly, but how to ensure that test data is complete, able to 'branch' and how to easily share test cases when issues arise. This session will discuss the requirements vs. the myths of Test Data Management and what it takes to compete in today's challenging Agile market.

Kellyn Pot Vin-Gorman is a member of the OakTable Network and an Oracle ACE Director alumnus. She is the Technical Intelligence Manager for Product and Market at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with Enterprise Manager, virtualization, the command line interface, environment optimization tuning, automation and architecture design. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content.

PRINTLN: A Dynamic Troubleshooting Tool for the Java Virtual Machine
Akiva Lichtner, Federal Reserve Bank of Cleveland
Developer / Advanced
Java applications break in production all the time and we do not have a good way to troubleshoot them. This presentation gives a thorough discussion of this problem and presents PRINTLN, a home-grown tool for troubleshooting running Java applications. The presentation will interest production support staff as well as Java developers grappling with legacy code.

Akiva Lichtner has 20 years of experience in information technology, covering various roles. He implemented an open source library for in-memory replication which became the foundation of Oracle Complex Event Processing. He is employed by the Federal Reserve Bank of Cleveland where he supports Treasury applications, both on the Java side and the Oracle database side. He spends a great deal of time troubleshooting Oracle performance problems and wants better visibility into running Java applications. He has a masters degree in physics from Cambridge University.

How to Read Oracle SQL Plans
Ric Van Dyke, Hotsos, Ltd.
Developer/All
When you look at a SQL plan in Oracle, do you know what it means?  Why are the steps indented the way they are?  Is “Inside out, bottom to top” really the way to read a plan? In this presentation you’ll learn the basics of reading a plan.  Be it an explain plan or an execution plan, you’ll learn how the steps interact and which step is first. Come sit in on this session where we will lay out what’s what when reading a plan.

Ric Van Dyke is an Oracle ACE with over 25 years of experience in the IT industry. He worked as a developer and database administrator with Oracle starting with Version 6 and worked for Oracle Corporation for 10 years, primarily as a core database instructor where he taught and developed several courses. Ric also served in the Advanced Technologies Services consulting group as a technical manager where he worked with several clients doing RAC installs and performance engagements. He has been with Hotsos for over 10 years.  His main role is an instructor, but he also does performance consulting engagements and frequently speaks at local user group meetings.

Flashback
Connor McDonald, Oracle Corporation
Developer/All
There is a remarkable human condition where you can be both cold AND sweaty at the same time.  It comes about 3 seconds after you press the Commit button and you realise that you probably needed to have a WHERE clause on that "delete all rows from the SALES table" SQL statement.  Or it might come just after you run "drop table" on the Production database, when you were just so sure that you were logged onto the Test system.  This session will discuss how you can use the FLASHBACK features in 10g, 11g and 12c to overcome this uniquely human condition.

Connor McDonald is a former Oracle ACE Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award by the UK Oracle User Group in 2009 and 2011.

SQL Developer - Command Line, GUI, or Browser? You Pick!
Jeff Smith, Oracle Corporation
Developer / All
This session will be an overview of our current development tools. How to get started, basic features for the developer, and how they work - lots, and lots of demo. This will also showcase our brand new web implementation of SQL Developer.

Jeff Smith has 17 years experience in the software industry, specializing in support, testing, documentation, product management and marketing, pre- and post-sales support. He is always interested in working directly with customers and developing content that empowers users to make the most of their technology investments. His specialties include Oracle Database, technical writing, software product demonstrations, online community development, 1st & 2nd level software support, public speaking, Social Media advocate, product marketing and evangelizing, product and technology course design and training delivery, software asset discovery and management.

Oracle REST Data Services, Flexible Deployments and RESTful Services
Jeff Smith, Oracle Corporation
Developer / Intermediate
An overview of Oracle REST Data Services, we will discuss install/deployment options of the product, and then also discuss the different way developers can develop and deploy RESTful Services - pl/sql APIs, REST dev panel, or directly in the SQL Developer connection tree. We'll also discuss the different KINDS of RESTful services one can deploy - AUTO Rest points for tables, view, and stored procedures, custom RESTful services based on sql/plsql scripts and statements, and more.

Jeff Smith has 17 years experience in the software industry, specializing in support, testing, documentation, product management and marketing, pre- and post-sales support. He is always interested in working directly with customers and developing content that empowers users to make the most of their technology investments. His specialties include Oracle Database, technical writing, software product demonstrations, online community development, 1st & 2nd level software support, public speaking, Social Media advocate, product marketing and evangelizing, product and technology course design and training delivery, software asset discovery and management. 17 years experience in the software industry, specializing in support, testing, documentation, product management and marketing, pre and post sales support.

ORACLE APPLICATIONS

Grants That Provide Secured Data Access AND Enhance System Administration
Karen Brownfield, Infosemantics, Inc.
Oracle Applications / All
Grants secure access to data and/or actions on data. Without creating grants, 12.1 no longer permits access to any reports except those you ran; and in 12.2.4 and higher stops all access to flexfield value sets. This presentation will explain what a grant is and give several examples of using grants to selectively enable access/actions. This knowledge will enable organizations to increase controls yet increase the ability of appropriate individuals to perform their jobs.

Karen Brownfield is a workflow developer, functional specialist, project manager, Oracle ACE, certified EBS and Cloud Specialist, co-author of 5 EBS administration books including The ABCs of Workflow for E-Business Suite Release 11i and Release 12 and has presented papers at various user group conferences regionally and internationally. Karen serves on the OAUG board, the Oracle EBS Applications Technology Customer Advisory Board, Workflow SIG board, and is OAUG board liaison to the User Management SIG.

Demystifying Oracle Cloud SaaS in 60 Minutes
Gustavo Gonzalez, IT Convergence
Oracle Applications / Novice
The rapid growth and constant innovation of Oracle Cloud is generating uncertainty and a few misbeliefs. Most Oracle users share doubts on security, and some wonder if Cloud products are mature enough. This session aims to cover different options to move applications to the Cloud and their cost. Topics include reliability, performance, standards, compatibility, security and the myths behind them; International subsidiary support & the future of customizations; and requirements to understand your journey to the Cloud.

Gustavo Gonzalez is an Oracle ACE Director and Chief Technology Officer at IT Convergence, leading the decision of technology strategy for technology platforms, partnerships, and external relationships. He specialized in E-Business Suite, Oracle Business Intelligence and Fusion Applications, with more than 15 years implementing and upgrading Oracle Applications for worldwide organizations and has led early adopter programs for Oracle E-Business Suite and Oracle Fusion Applications.

Implementing Optimal Internal Controls in the Procure to Pay process
Jeffrey Hare, ERP Risk Advisors
Oracle Applications / All
Internal controls related to the procure to pay process are among the most critical controls for an organization. Poor internal control design can lead to issues with SOX compliance and leave an organization susceptible to fraud risk by internal and external threats. In this session we will review critical configurations, discuss security design, and present various considerations in internal controls design.

Jeffrey Hare, CPA CIA CISA, is the founder and CEO of ERP Risk Advisors. His extensive background includes public accounting (including Big 4 experience), industry, and Oracle Applications consulting experience.  Jeffrey has been working in the Oracle Applications space since 1998 with implementation, upgrade, and support for both national and international clients. He is a Certified Public Accountant (CPA), a Certified Information Systems Auditor (CISA), and a Certified Internal Auditor (CIA). He is a graduate of Arizona State University.

How to Perform a EBS Database Health Check before Going to the Cloud
Dimas Chbane, Accenture Enkitec Group
Oracle Applications / All
Many customers are moving databases and applications to 'the cloud' and that trend seems to be inevitable in the future. However, the cloud is not a solution for solving problems that you currently have in your database. If the system is performing poorly or has instability problems, chances are that it will continue in the cloud. Therefore, you should perform a complete assessment of the system, identify problems and take corrective actions before making any move. In this presentation, we will describe how you can make a health check in your EBS database using free tools and quickly pinpoint the main issues that need to be addressed. We will discuss a holistic approach to collect information and execute an unbiased investigation of your database. Even if you are not aware of any complaints, I can guarantee that you will find something that should be fixed or improved. Attendees will learn how to gather the information necessary, analyze the top metrics and develop an action plan to achieve a successful move to the cloud.

Dimas Chbane is currently an IT Consultant with Accenture Enkitec Group, with more than 18 years of experience in Oracle Databases and E-Business Suite applications. He is specialized in Performance, both in the database and middleware. He has presented in several OUG events and public webcasts for Oracle customers.

Best Practices in Application Security Design for Oracle E-Business Suite
Jeffrey Hare, ERP Risk Advisors
Oracle Applications / All
Proper application security and role design forms the foundation of your internal controls environment.  Pool role design during the implementation of ERP applications leads to excessive risk, Segregation of Duties issues, and audit findings.  In this session we will share the foundational principles of good role design and give you the top tips for staying out of trouble with your auditors.

Jeffrey Hare, CPA CIA CISA, is the founder and CEO of ERP Risk Advisors. His extensive background includes public accounting (including Big 4 experience), industry, and Oracle Applications consulting experience.  Jeffrey has been working in the Oracle Applications space since 1998 with implementation, upgrade, and support for both national and international clients. He is a Certified Public Accountant (CPA), a Certified Information Systems Auditor (CISA), and a Certified Internal Auditor (CIA). He is a graduate of Arizona State University.

Getting Started with Oracle BPM Suite Development
Harold Dost, Raastech
Oracle Applications / Novice
Let’s face it. There’s a shortage of Oracle BPM development skills out there and developing SOA-based integrations is not quite the same as modeling business processes. This presentation is self-explanatory and is geared towards Oracle SOA Suite developers who want to understand key concepts surrounding BPM and how to get started developing your first business process.

Harold Dost III is a Principal Consultant at Raastech with experience architecting and implementing solutions leveraging Oracle Fusion Middleware, mostly revolving around products and technologies that include SOA Suite, OSB, BAM, AIA, Java, big data, docker, and mobile. He an OCE in both SOA and Java, and has presented at various user groups and conferences such as OpenWorld, Collaborate, UKOUG, GaOUG, WMOUG, and MOUS. Harold is an Oracle ACE Associate and co-author of Oracle SOA Suite 12c Administrator’s Guide.

Automating Functional Testing of Oracle Applications Using Oracle ATS and Oracle Flow Builder
Anil Minocha, Fujitsu America, Inc.
Oracle Applications / All
Learn how to cope with the testing challenges after patches and updates by automating your functional Testing using Oracle Application Testing Suite (OATS), and Oracle Flow Builder.  Learn the overview of OATS including how to architect, install different components whether on premise / in AWS / other cloud, and create testing framework for enterprise packaged applications.  Also learn how we implemented and leveraged the keyword-driven testing framework and the pre-built testing components of Flow Builder.

With more than 18 years' experience, Anil Minocha has shouldered a wide range of responsibilities in Oracle and IT program and project management, training, functional and technical Oracle Applications, database, technology and cloud and hybrid IT services. He has strong experience working through full life cycle of system development including methodology, planning, documentation, training and enablement, train-the-trainer, knowledge management, hands-on-installation, configuration, implementation/upgrade, roll out and support of Oracle products and services including Oracle Applications Testing Suite (OATS).

Cybersecurity—Protecting High Priority Data
Dan Dorfman, CardConnect
Oracle Applications/All
Not all data is created equal—some data, if exposed, is much more damaging. Exposure of high priority data like credit card numbers, social security numbers, bank account numbers, and health information has resulted in multiple million dollar losses and executive level firings. How do you protect this data? How do you protect your company from both the external hacker and potential bad actors within your company? We will discuss both methods and solutions to protect this High Priority data within Oracle.

Dan Dorfman is Director, Oracle Solutions, at CardConnect where he started as an Oracle PL/SQL Developer before transitioning into a Business Development and Solutions Architecture role. Dan has 5 years of Oracle Payments and Security experience.

Top University Moves from iRecruitment to Oracle HCM Cloud Talent Acquisition
Austin Reason, EiS Technologies
Oracle Applications/All
Many Universities see the value in expanded system capabilities in HCM Cloud vs EBS iRecruitment. They are always looking for lower costs and more flexible ways to improve processes and operational efficiencies. Students and Staff expect to access services quickly and continually, both important components that drive their Cloud Approach. In this presentation, we will look at the project completed with our client, as well as discuss the Business Drivers and IT Drivers for this phased implementation of Oracle HCM Cloud

Austin Reason is the Director of Cloud Services for Atlanta-based EiS Technologies, a leader in Oracle Reporting, Dashboards, Implementations, and Integrations. He has more than 18 years’ Human Resource experience specializing in Talent Acquisition, Talent Management, and Human Capital Management in HR / Payroll.  Prior to joining EiS, Austin was Director of Human Resources at Wellington Consulting in West Palm Beach, Florida, which specialized in Oracle EBS Implementations. He has been actively involved in Oracle User Groups for more than 15 years, was a Founding Leader of the Oracle HCM Users Group (OHUG) and held several positions there. Austin has been serving as President of the Gulf Region Oracle Application Users Group / FLOAUG since October 2015.

It’s Raining Reports: Current Choices for Oracle Transactional Reporting
Tom Williams, Excel4apps
Oracle Applications/All
Whether you’re struggling with de-supported Oracle Discoverer, using or considering OBIEE, or looking at Cloud options, join Excel4apps to explore ad-hoc reporting alternatives. We’ll discuss real-time next generation reporting with Microsoft Excel add-ins, along with the various Oracle reporting options.
You’ll discover how to empower users with an ad hoc query and analysis tool for all E-Business Suite modules, customize reports in Excel and refresh real-time data, and drill to live data details.

Tom Williams is a Territory Manager with Excel4apps, a provider of best-in-class Excel-based reporting for Oracle and SAP users worldwide. With a passion for connecting customers to world-class solutions, Tom has worked with global manufacturing, finance, and retail companies to empower their users to provide accurate, insightful operational reporting.  At Excel4apps he manages new prospects, existing customers and sales for users of Oracle EBS in his territory. Tom has been in the technology space for 8 years, resides in Baltimore and can be reached at tom.williams@excel4apps.com

Fusion Accounting Hub Reporting Cloud with E-Business Suite R12
Anil Patil, Fujitsu America, Inc.
Oracle Applications / All
If your organization is still on Oracle E-Business Suite Release 12 but wants to use the Reporting capabilities available in Fusion, look no further. You can now deploy the Fusion Accounting Hub Reporting Cloud Service as an extended reporting platform. Discover how your organization can now get the benefits of powerful Fusion reporting and analytics with optional drilldown to the source transaction details. In this session, you will see the approach for deploying the Accounting Hub Reporting Cloud Service and its key features. This session will take you one step closer to the Cloud.

Anil Patil heads the North America Oracle Financials Center of Excellence for Fujitsu. In this role, he supports customers across all industries implement Oracle Financials solutions.  Anil also leads the Cloud Financials solutions for customers. Prior to joining Fujitsu, he worked for Oracle where he managed the Asia-Pacific Oracle Financials Implementation and Support teams. Anil was one of the key members involved in rolling out the Global Single Instance for Oracle and setting up the Shared Service centers. He is an Alumni speaker at Oracle Open World and OAUG conferences.

What's New in 12.2.6 for Manufacturing and Supply Chain?
Bill Pick, Fujitsu America, Inc.
Oracle Applications / All
Wonder what's new in the latest release of Oracle E-Business Suite for Supply Chain and Manufacturing? What benefits could be part of your ROI to justify the investment in your upgrade or implementation? Come hear an experienced GEO SIG leader with 12.2 upgrade experience review the key enhancements (in both 12.2.5 and 12.2.6) to core functionality in the 'Order-to-Manufacture-to-Ship' process, with detailed screen shots and examples, as well as key considerations and lessons learned for your project.

Bill Pick is a PMP-certified consultant and Certified Purchasing Specialist in the Oracle Practice of Fujitsu America, Inc. in Minneapolis, Minnesota.  He has 35 years of experience in Supply Chain Management, including 22 years of project management, manufacturing, and supply chain lead experience with Oracle Applications.  Bill is the President of the Twin Cities Manufacturing OAUG GEO, has presented multiple papers at previous OAUG conferences, and has also been a panel member or panel moderator for Project Management, Manufacturing, and Upgrade panels for past conferences.

Workflow Setups That Make a Difference
Karen Brownfield, Infosemantics, Inc.
Oracle Applications / All
Worklist Flexfields and custom notification views, exporting notifications to Excel, assistant administrators, using grants instead of worklist access to see SYSADMIN's emails, controlling the LOV for the recipient for vacation rules and worklist access (12.2 only) are a few of the advanced and mostly undocumented setups that can increase your organization's use and administration of workflow. Listen to an Oracle ACE and author explain how to install and use these setups. Many of these setups are available in R12.1.3, but the presentation will cover new setups available only in R12.2.

Karen Brownfield is a workflow developer, functional specialist, project manager, Oracle ACE, certified EBS and Cloud Specialist, co-author of 5 EBS administration books including The ABCs of Workflow for E-Business Suite Release 11i and Release 12 and has presented papers at various user group conferences regionally and internationally. Karen serves on the OAUG board, the Oracle EBS Applications Technology Customer Advisory Board, Workflow SIG board, and is OAUG board liaison to the User Management SIG.

Patch Now or Pay Later (Don't Let Your Apps DBA Say They Told You So)
Bob Schreiber, IOA.DBA Inc.
Oracle Applications / All
No EBS environment is ever patched up enough. From 11.5.10.2 to R12.2.6 there is always a patch or patchset required to fix or prevent a problem. The Oracle Support Mantra is always to stay current on patchsets. Two things usually prevent this from happening: Time and Money. Companies will budget to add a 3rd party product or start a project to implement a new product to replace a legacy system but fail to maintain the actual EBS environment hosting these new projects. When implementing a 3rd party product or new EBS product issues often arise that require a patch and often this requires upgrading the base patch level of the EBS environment. Production issues can also occur that changes the production environment baseline and coordination needs to occur in project instances. Proper planning and communication is required between Project Teams, Production Support Teams and Project sponsors so that patching requirements don't become planning nightmares.

Bob Schreiber has been an Oracle EBS DBA since 2000.  He started as an APPS DBA with Oracle Consulting's North Central Performance Architecture group and has been an Independent EBS DBA since 2002.  Bob has been part of EBS implementations and upgrades throughout the country starting with 11.5.1 through 12.2.5.

Five Signs You Are Ready For Digital Transformation
Mia Urman, AuraPlayer
Oracle Applications / Novice
Do you feel like your teenager’s apps are more technologically advanced than your EBS system? In this session we will walk you through the steps of how to begin a mobile revolution. We will discuss how to identify mobile needs within your organization and how a digital transformation can increase efficiency, productivity, and revenue. We will hear from customers on how they revolutionized their organizations in a matter of months. We will also look at Oracle’s mobile tools and get an overview of what’s available to help us do it. This session will include live demos.

Mia Urman is an Oracle ACE Director and a world-renowned expert in Oracle technologies, with over 17 years experience presenting, supporting, training and consulting. Mia is the founder/CEO of AuraPlayer a cutting-edge technology company offering solutions to mobilize and modernize Oracle Forms/EBS. Mia is a sought-after presenter at various conferences including OOW, Collaborate, Kscope, and others. She has also served as a director on the board of ODTUG and is active in user groups.

Digital Transformation: Strategy for Moving from Oracle Forms Legacy to Mobility
Mia Urman, AuraPlayer
Oracle Applications / Novice
As mobility becomes the primary means for accessing information, enterprises must find a way to accelerate mobilization. But how can we do that when our core business process are stuck in a back-office application that is over 10 years old? How can you leverage your existing business logic while transforming the user experience to the digital world? In this session we will discuss how to begin your mobile journey, including real life examples of customers who have been successful at it! We will show you how we can leverage your existing forms investment to go mobile in record time using Oracle's PAAS products. The Oracle Mobile Cloud is the missing ingredient for creating mobile apps at the speed of your business by empowering the front lines of your business with back office data. Oracle Mobile Cloud Service is Oracle's new offering that provides built-ins for push notifications, object storage, user management, analytics & an API designer & catalog. This session will also include demos of how Oracle Mobile Cloud Service makes it possible for customers to mobile-enable their Forms systems.

Mia Urman is an Oracle ACE Director and a world-renowned expert in Oracle technologies, with over 17 years experience presenting, supporting, training and consulting. Mia is the founder/CEO of AuraPlayer a cutting-edge technology company offering solutions to mobilize and modernize Oracle Forms/EBS. Mia is a sought-after presenter at various conferences including OOW, Collaborate, Kscope, and others. She has also served as a director on the board of ODTUG and is active in user groups.

Strategies for Maintenance and Online Patching for Oracle E-Business Suite 12.2
Elke Phelps, Oracle Corporation
Oracle Applications / All
Join this Oracle Development session to hear about the operational and system management implications for minimizing maintenance downtimes when applying Oracle E-Business Suite patches using Online Patching. Learn tips and techniques that applications DBAs can use to efficiently perform maintenance tasks. Leave with an understanding of how to define a maintenance strategy using the best tools for creating a plan to keep your environment healthy and up-to-date.

Elke Phelps is a Product Manager in the Oracle E-Business Suite Applications Technology Group. She specializes in Oracle E-Business Suite database integration, upgrades, minimizing downtime, security and advanced architecture. Elke is the lead author of the Oracle Applications DBA Field Guide (2006) and Oracle R12 Applications DBA Field Guide (2010). Elke was designated an Oracle ACE (2007) and Oracle ACE Director (2009).  She received the OAUG Oracle Ambassador of the Year award in 2015.

Oracle WebLogic Server Administration and Management with Oracle E-Business Suite 12.2
Elke Phelps, Oracle Corporation
Oracle Applications / All
Oracle E-Business Suite 12.2 introduces the use of WebLogic Server (WLS) in the Application Tier Technology Stack. Join this Oracle Development session to learn about the WLS Domain and managed servers deployed for Oracle E-Business Suite 12.2. Leave with an understanding of how to configure, patch, upgrade and administer WLS for Oracle E-Business Suite 12.2. This session will also cover log file location and basic monitoring and troubleshooting tips.

Elke Phelps is a Product Manager in the Oracle E-Business Suite Applications Technology Group. She specializes in Oracle E-Business Suite database integration, upgrades, minimizing downtime, security and advanced architecture. Elke is the lead author of the Oracle Applications DBA Field Guide (2006) and Oracle R12 Applications DBA Field Guide (2010). Elke was designated an Oracle ACE (2007) and Oracle ACE Director (2009).  She received the OAUG Oracle Ambassador of the Year award in 2015.

Multi-Data Source Reporting & Self-Service Analytics
Rick Hight, Polaris Associates
Oracle Applications/All
Is your company utilizing multiple data sources and applications? This live presentation will show how you can combine information from any/multiple data sources to build meaningful reports, dashboards, and visualizations in minutes. Learn how using real-time operational intelligence can empower your users to ask questions, spot trends, identify opportunities, and make data-guided decisions with confidence. ​

Rick Hight is Reporting Solutions Specialist at Polaris Associates. He has presented papers at numerous Oracle conferences on strategies to achieve better results through efficient reporting. Polaris Associates offers an Operational Reporting solution for Oracle E-Business Suite called Reporting Workbench and self-service business intelligence solution for ERP/Cloud applications called ORBIT Analytics.


OTHER

Cross Cultural Communication
April Wells, Sherwin-Williams
Other / All
Communicating effectively and efficiently is critical in business, today, perhaps, more than ever before. Culture is far more than simply U.S. English versus other languages and countries. Gender, age and other demographics are also included in communication differences. Slang and humor can be often misinterpreted and stilted communication can be considered off-putting as well. Being able to communicate well in writing and in meetings can be the polish that sets you apart. Remembering what to say, what not to say, and when to stop can make the difference between reading and understanding on your audience's part and could be the difference between an okay review and a very good review at annual review.

April Wells is a Lead Oracle eBusiness DBA with 16 years experience with Oracle and 16 years experience with EBS.  She is a published author and has been a database administrator and programmer in many varied venues.

4 Ways ECM Can Upgrade-Proof Your Invoice Automation
Rob Krause, OnBase by Hyland
Other/All
Upgrading your ERP is often a necessary and beneficial initiative for your organization and the critical processes – like AP invoice management - that your ERP supports. But we all know that upgrading is time-consuming and sometimes even a little scary. Customization, add-ons, user training, and integration with other applications can add headaches to an already complex project. When invoice management is tightly integrated with your ERP, upgrades can be disruptive to both invoice processing and the AP team. But there is another way. Join our session to learn how automating invoice processing with ECM can ensure your AP documentation stays secure, your invoices are approved, and your vendors keep getting paid throughout your ERP upgrade.

Practical Writing Tips for Technical Communicators
Josh Bernoff, WOBS LLC
Other/All
This talk explains the specifics of how to write effectively for the 21st century. Tips include how to organize content, how to purge toxic prose that distracts readers, and how to build skimmable content that works for busy readers. We'll also go over effective planning and review processes that keep writers from going insane. Content is based on the new book "Writing Without Bullshit" and the blog post "10 Top Writing Tips and The Psychology Behind Them" -- which has now been viewed over half a million times.

In 35 years as a writer, Josh Bernoff has written just about everything but fiction – software documentation, online help files, press releases, newsletters, magazine articles, Web copy, over a hundred research reports, and four books. His blog, withoutbullshit.com, generated 1 million page views in its first six months. For 20 years he was a principal analyst and senior vice president, idea development, at Forrester Research where he wrote reports, gave speeches all over the world, and worked with Fortune 500 clients on business strategy. At Forrester he invented Technographics, the segmentation on which the company’s consumer survey business is based. Before Forrester he worked for startup companies including Software Arts, the company that invented the spreadsheet. He also spent three years as a Ph.D. candidate and National Science Foundation Fellow in mathematics at MIT. His bachelor’s degree is from Penn State. He lives in the Boston area and is the CEO of a non-profit, wellnesscampaign.org, dedicated to the pursuit of wellness through changing habits.

OEM 13c Agent Management with Ease
Alfredo Krieg Villa, The Sherwin-Williams Company
Other / Intermediate
The Oracle agent is the most basic piece of software that enables you to monitor a host in Enterprise Manager and in conjunction with plug-ins to monitor and manage targets running in that host. As your monitoring asset grows it becomes more challenging to keep all your agents up-to-date. Oracle Enterprise Manager 13c provides a new feature called Agent Gold Image providing administrators an easy way to, in a certain way, clone the configuration from one agent to others. This provides consistency and saves tons of time so administrators can focus in other areas.

Alfredo Krieg Villa is an Oracle ACE and Database Administrator with an 11+ year track record in Oracle Database, Oracle Enterprise Manager, Database tune and optimization. Alfredo likes to share his experiences about Oracle Database performance and Oracle Enterprise Manager on his blog and by speaking in public conferences.

Domain Partitions and Multitenancy in Oracle WebLogic Server 12c: Why It's Useful
Ahmed Aboulnaga, Raastech
Other / Intermediate
Do we really need virtualization within Oracle WebLogic Server? Last year, I said no. This year, my opinion has changed. I will explain domain partitions, how to set it up, and when you'd want to have multiple partitions in a single WebLogic domain. We'll also discuss the App2Cloud utility from Oracle which simplifies the migration of your on-premise WebLogic domain to the Oracle Java Cloud Service (JCS). Attend this presentation and find out what changed my mind.

Ahmed Aboulnaga is a Technical Director at Raastech, a systems integrator headquartered in Herndon, Virginia. Ahmed's professional focus is in technical management, architecture, and consulting within the Oracle Fusion Middleware stack, having implemented enterprise solutions for commercial, government, and global customers throughout the years. Ahmed is an Oracle ACE, OCE, and OCA, and has presented at OpenWorld, Collaborate, UKOUG, and various Oracle users groups in the past.