Quarterly Education Workshops (QEW) 2010 Presentations Summaries and Papers

May 21, 2010 Presentations


Programming with Oracle Pro*C
Don Schaefer, INGENIX

Oracle Pro*C is an Oracle interface programming "precomplier" application that allows Microsoft Visual C++ programmers to embed Oracle PL/SQL statements/processing blocks into Microsoft C++ programs. Oracle Pro*C allows Microsoft programmers to Access Oracle databases in a most efficient system allowing the integration of Oracle PL/SQL Code in Microsoft programming.


De-identifying Sensitive Data
Brad Nelson, dataguise

Every day we read about sensitive data being compromised due to lost or stolen laptops and external drives. Why does this continue to happen with all the security products out there? Users download data for off-line analysis and this data should be de-identified before end-users have access to it.


Opportunities and Challenges of Application Development in the Developing World
John P. Jeunnette, Prairie Systems Group, Limited

A part-travelogue and part project management exercise describing the presenters experiences working on a major development project for the Ministry of Finance of the country of Ethiopia including pictures and descriptions of traveling and living in Africa for over a year as well as the opportunities and challenges of IT system administration and application development in Africa.


Project Governance: The 21 things every project manager needs to know about the status of their Project. (White paper)

Project Governance: The 21 things every project manager needs to know about the status of their Project. (Power-Point Presentation)

Janet Dahmen, Rolta TUSC

Most project managers establish a routine at the beginning of a project, in which they outline and deliver regular status reports. And while knowing the events of what occurred during the last week are important, this information doesn't represent the real picture about what is happening within your team or the underlying health and welfare of your project. This presentation will talk about the types of information that the every project manager should be tracking in regards to their project; from the effectiveness of monitoring processes to the readiness of your organization. These key information points will provide you a deeper insight into the progress being made; and most importantly, alert you about the areas that have the greatest ability to de-rail your project's success.

Janet Dahmen is a PMI Certified Project Management Professional (PMP) with twenty years of Information Technology experience. She has been with TUSC for over fourteen years, managing large implementation teams and key accounts. She regularly performs project audits, providing field-level Project Managers with an objective evaluation of the effectiveness of the project's controlling processes and overall project strength.


R12 Upgrades: Why, When, and How
Mike Butler, VP, Rolta TUSC

This presentation will outline a recommended approach to a successful R12 Upgrade, focusing on the reasons to start planning your upgrade now, the benefits of a thorough pre-upgrade assessment, and the various steps involved in a successful R12 upgrade. Experts from Rolta TUSC's E-Business Suite practice with significant experience with Release 12 will participate in this presentation to answer questions and provide insights into our R12 Upgrade experiences.

 

August 20, 2010 Presentations

Our thanks go to Regis University for hosting our meeting and to our

August QEW sponsor:

DBAK

Presentations

 

8:00 am - 9:15 am

GoldenGate Straight Up: Installation and Configuration of Oracle GoldenGate

Frank Bommarito, DBAK

 

Presentation walks the audience through key installation and configuration features of GoldenGate – including base replication, data transformations, operational procedures, active-active configurations, warm standby databases, and common operational procedures from monitoring to Veridata. We’ll use E-Business Suite as a sample application to demonstrate ease of implementation for complex database environments.

 

Download presentation in Adobe Acrobat PDF - 1.32Mb

 

 

9:30 am - 10:45 am

PMI Project Initiation

Robert Holland, Roxytone, LLC

  

Today's Information Systems Projects can become well defined vehicles for the creation and implementation of efficient, effective business systems or nightmares for everybody involved. The PMI Initiation Phase methodically and comprehensively determines the nature and scope of the project and creates a blueprint for a good start.

 

Download presentation abstract and outline in WordPad RTF - 38 Kb

 

11:00 am -12:15 pm

Business Analysis Fundamentals

Tiffany Dahlberg PMP, Achievement Consulting & Training, Inc

 

If I would’ve known that….” Tools to Make Your Job Easier” Every business does "analysis" internally, externally, or both. Business Analysis is a fancy term for identifying problems or opportunities, eliciting the needs and wants of stakeholders, then clarifying and validating those requirements through documentation and communication. The end result is implementing the best solution. It's common but not easy. The most common reason for project failure is lack of proper requirements.


Download presentation in Adobe Acrobat PDF - 514 Kb  

 

 

1:30 pm – 2:45 pm

Delivering IT Project On Time and Within Budget

Jennifer McNeil, Unify-CipherSoft

 

IT projects fail regularly with costs and timelines being difficult to manage. Although companies regularly blame software for the problems incurred with delivery of projects, the real reason they fail is usually due to poor project planning. Due to the economic slowdown, companies are encountering significant problems in obtaining resources and funding for mission critical projects that require delivery in a cost and time efficient manner.  In order to meet the challenges of projects, there are specific strategies that can be applied for success


Download presentation in PowerPoint - 610 Kb

 

3:00 pm - 4:15pm

"IT Investment Management: Projects vs Products and the Secret of Innovation"

Bill Wimsatt, 1783 Productions

 

Investment is about applying resources to return value higher than the initial resource outlay. Investment in corporate information systems has been a hot topic for the past decade; however, measurement techniques have confused, eluded, and frustrated many IT organizations. One reason is that IT is not a separate business, it is one integral part of a larger business. IT project management needs to take a page from the practice of product management to open the often myopic approach applied. Also, technology delivery teams do not deliver value at just one point in a project. Value is created along the way and this is often not realized and often ignored. This presentation will explore a new way of viewing IT investments, creating business value, and bringing innovation into the fold. 


Download presentation in Adobe Acrobat PDF - 2,796 Kb  


November 19, 2010 Presentations

 

Presentations

8:00 am - 9:00 am

Top Down Performance Management with OEM Grid Control (Or how I learned to stop worrying and love OEM Grid Control)

John Darrah, Technology Director, DBAK

 

This presentation will cover ways to identify faults and warning conditions within the enterprise and quickly identify root cause. Presentation addresses aspects of OEM including creating groups, systems, and services as well as Diagnostics and Tuning for the database and application server. Today's DBAs are being asked to manage larger environments while maintaining (or increasing) service level agreements. Oracle Enterprise Manager can help meet both goals by allowing DBAs to quickly discover and correct various problems within the enterprise. Participants will learn strategies for configuring OEM Grid Control to efficiently monitor their environments.

Download presentation in Adobe Acrobat PDF - 2.65 Mb

 

9:10 am -10:10 pm

Optimize your Oracle Licensing

Esley Gustafson

 

Oracle licensing and maintenance can sometimes be hard to understand. As Oracle has grown and acquired new products, more and more organizations are using a range of Oracle products. Understanding the various products, product versions, virtualization, hardware implications and maintenance costs associated with these products is very important to many organizations. We explore how to optimize your licensing when buying Oracle products by explaining the different product versions, license types, options, terms and developing an understanding of Oracle licensing and maintenance policies.

Download presentation in Adobe Acrobat PDF - 729 Kb

 

10:20 am - 11:20 am

Introduction to Cloud Computing - 101

Jordan Braunstein, Oracle ACE Director - Visual Integrator, Inc.

 

An Introduction to Cloud Computing, fundamental concepts, principles, benefits, and challenges. The session will start with an overview of Cloud and helping to define what Cloud is, and what it consists of -- a "101" so to speak, so that participants have a firm understanding of Cloud Computing, Software As A Service, and the concepts that make up this new paradigm. We will cover what makes cloud computing unique from its predecessor paradigms and why the industry is so excited about moving companies and data centers into the cloud.

The session will also cover practical approaches to implementing a cloud project, both as a cloud provider or a cloud consumer -- in other words a methodology for "entering the cloud". We will also cover approaches for overcoming challenges, dispelling myths, and how to take incremental steps for getting started with a cloud implementation.

Please contact the author for a copy of the presentation.

 

11:30 am - 12:30 pm

Oracle Database Cross Platform Migration - Combine Incrementally Updated Image copies with RMAN Convert/Transportable Tablespaces

Lucy Feng, Senior Consultant, DBAK

 

This presentation introduces a solution developed while helping a client migrating 30+ databases from Sun Solaris to IBM Mainframe based Linux. It briefly outlines the business requirements; provides an overview of the two main technologies: Transportable Tablespaces for cross-platform conversion and RMAN incrementally updated image copies for reducing downtime; and steps through the solution. It also addresses the method variation for same Endian format conversion vs. cross-Endian format conversion, and provides recommendations and ideas for minimizing downtime when the databases are large and/or the distance between source and target data center is great.

Download presentation in Adobe Acrobat PDF - 211 Kb