Friday, October 11, 2013

...and They're Off!

Well, it should not come as a great surprise to anyone that I've decided to pursue another stint on the ODTUG Board of Directors. If successful, this will be my third and final term. It's been a fantastic journey thus far.

Here's my campaign Statement

Campaign Statement

In January of 2010, the membership of ODTUG saw fit to place me on the board of directors. It was, and continues to be, a tremendous honor to serve with the other members of the board in charting the future course of the organization. True, it involves considerable sacrifice, but ODTUG is worth it—you’re worth it.

I’ve had the privilege of serving as your president since June of 2012. Since that time, the organization has rolled out a new website, a new logo, an online job board, and increased our influence by purchasing APEXblogs. At the same time, our Kscope conference continues to grow in size and stature. For me, it’s always felt as much like a family reunion as it does a world-class technical conference.

I ask you for the opportunity to continue to fill the seat I’ve occupied these last four years. I have the desire, the dedication, and the experience to best represent you and your interests. If you believe, as I do, that the organization is moving in the right direction and our best years are ahead of us, I would appreciate your support.

My name is Monty Latiolais and I approve this message.

Biographical Statement

Monty Latiolais has more than twenty-five years of experience in information technology and more than a dozen years of experience with Oracle.

He has been a member of ODTUG since 2003 and has volunteered in many areas, including the ODTUG executive conference committee, the ODTUG abstract review committee, the ODTUG Technical Journal Editor’s Choice Awards panel, ODTUG Oracle OpenWorld content chair, and was recognized as the ODTUG 2009 Volunteer of the Year. Monty has been on the ODTUG Board of Directors for four years, with the last year and a half serving as president.

He is currently serving as the senior programmer analyst with SC Global Tubular Solutions, a Sumitomo Corporation subsidiary specializing in OCTG supply chain management. He spends his days working with Application Express, Oracle Forms, and Oracle Reports, writing complex analytics, and counting the days until the next Kscope conference.

Additionally, ODTUG asked the candidates to answer the following questions. If you could describe ODTUG in ten words or less, what would they be?

A community of Oracle professionals sharing their knowledge and experiences.

What is your motivation for joining the board?

I'm a big believer in paying things forward. Early in my career, I benefitted greatly from the technical journal and from participating in the list servs. While the technical journal has gone digital and tweets have in large part replaced list servs, I'd like to believe I'm providing that same benefit to a new generation of ODTUGers.

What attributes do you feel you would provide to this position?

I'm a people person. If you've attended a Kscope conference, it's likely we've met. It's just as likely we're on a first-name basis. It's that interaction with the membership I enjoy most and it's what keeps me coming back time and again.

Do you have a principal goal you would like to achieve as a board member?

What has made ODTUG special through the years is a real sense of community and a sense of belonging. Our challenge is to continue to grow the organization without losing those qualities that attracted us in the first place.

I look forward to once again serving the membership as a Director.

Our journey continues...

You Gotta Be Kidding!

Where-o where are my Android 4.3 developer options?

I'm developing a mobile app for my company. Rather than using an Android emulator with Eclipse, I thought this time I'd use my actual phone to develop against. I looked high and I looked low, but couldn't find a way to turn on USB Debugging. A quick swim through Google and I have my answer. It was not what I expected. Turns out the Developer Options menu is hidden in Jelly Bean. To access the Developer Options you must do the following:
  1. Goto Settings -> About Phone.
  2. Goto “Build Number” at the end of the Scroll list.
  3. Tap on “Build Number” repeatedly (7 times). On your third tap you should see message indicating that you only have 4 more taps to go to ‘become a developer’.
  4. Continue: 4 more taps.
  5. Hooray, you are now a ‘Developer’, go back to the Setting page.
  6. You should see Developer Option menu item in your setting list now.
  7. Open Developer Options and check USB debugging > Ok
Are You Kidding Me?

Our journey continues...

Thursday, December 13, 2012

Top 10 Things To Do In New Orleans...besides KScope13

National Geographic, of all places, put out a Top Ten list of things to do while in New Orleans...excluding Mardi Gras and KScope13. I've experienced several of those items included, but definitely agree with the list. New Orleans is so much more than Mardi Gras.

I'd encourage each of you to visit the link for the full rundown, but here's a quick synopsis:
  • Streetcars
  • Magazine Street
  • Garden District
  • Insectarium
  • Live Music
  • Drinks
  • PO-Boys
  • City Park
  • Ogden Museum of Southern Art
  • Jackson Square

Wednesday, December 5, 2012

Work With Me Now...Really, Work With Me

At SC Global Tubular Solutions, we are looking to add a couple of Oracle professionals to our already talented staff. Trust me, these opportunities are not for everyone, but if you think you've got what it takes, contact Mary Lou Dietler. We offer relocation and a very competitive salary.

Here's a little bit about SC Global

Company Overview

Sumitomo Corporation (SC), one of the largest integrated trading groups in the world today, employs over 72,000 people in 790 companies located in 65 countries. Our business activities are diverse and are continually expanding into a varied range of products and services. We lead the way in Tubular products, sourcing and supplying a wide variety of high grade oil country tubular goods (OCTG), line pipe and specialty tubing in the oil, gas, petrochemical, automobile and boiler manufacturing industries.

SC Global Tubular Solutions (SCGTS), a subsidiary of Sumitomo Corporation, supports its parent company’s OCTG business by providing consulting services to the various SC business units globally. The focus areas for these consulting activities include the development and implementation of specific integrated OCTG supply programs, development and ongoing maintenance of information technology tools to manage these programs, and forward strategy development for SC's global tubular business.

Programmer / Analyst - SR

  • Codes applications using Oracle Forms, Reports and APEX.
  • Applies documented program standards and conventions and assists in development of same.
  • Develops and implements appropriate error handling techniques.
  • Takes basic designs and extends them within bounds of standards and approved methodology.
  • Creates test plans and executes same as part of program development.
  • Assists in performing code reviews to insure best practice and adherence to documented standards.
  • Proven knowledge in Oracle Forms, Oracle Reports, Advanced Oracle APEX (4.0 +) skills, SQL and Advanced PL/SQL.
  • Bachelor’s degree in computer science or related field and at least 3-5 years of experience using above Oracle tools with high level of proficiency.
  • Familiarity with Analytics, BI Publisher, Discover, Answers and Dashboard would be a plus.
  • Good working knowledge of packages, functions and analytics.
  • Sound understanding of relational database structures, e.g. table joins.
  • Understanding of indexing and performance tuning approaches.
  • Must understand and follow defined program development methodology.
  • Must maintain skills relative to programming tool set as those tools advance functionality.
  • Good analytical and logical thinking skills.
  • Good communications skills (verbal and written).
  • Must accept responsibility to see projects to completion meeting accuracy and efficiency goals.
  • Able to work extended hours when required.
  • Able to work cooperatively within a small team environment and with minimal direction and supervision.
  • Eligible to work in the US with no restrictions.
Programmer / Analyst - JR


  • Will debug and repair existing programs.
  • Will document previously developed code.
  • Will be responsible for supervised coding of applications using Oracle Forms, Reports and APEX.
  • Will apply documented program standards, error handlers and code conventions to existing applications.
  • Will be responsible for creation of test plans and for execution of same as part of program development.
  • Minimum Bachelor’s degree in computer science or related field.
  • Understanding of relational database systems, e.g. table joins, and the basics of indexing.
  • Understanding of programming structures, e.g. error handling, program development methodologies.
  • Will be required to become highly proficient (advancing to expert) in use of Oracle Database, Forms, Reports, APEX, SQL and PL/SQL (training will be provided).
  • Must maintain skills relative to programming tool set as those tools advance functionality.
  • Good communications skills (written and verbal).
  • Good analytical and logical thinking skills.
  • Strong attention to detail and accuracy.
  • Able to work extended hours when required.
  • Able to work cooperatively within a small team environment and with minimal direction and supervision.
  • Eligible to work in the US with no restrictions.
Quality/Data Administrator/Developer


Function - Quality/Test:
  • Will be responsible for developing and executing software quality control plans.
  • Will learn internal applications and will translate into applicable test cases.
  • Will work with developers to create test data sets which will test application functionality per design constraints.
  • Will confirm that code is compliant with documented standards and that approved program methodology is followed.
  • Will perform unit, functional, integration, system and performance tests.
  • Will assist in the development and implementation of coding standards.
  • Will assist with discovery of mal-performing code and in performance tuning options.
  • Will develop and maintain applications design and development documentation.
  • Will assist in the development of Oracle Forms, Reports, APEX and BI applications.
Function - Data Administration/Reports Support:
  • Will be responsible for interfacing with end-user community for purposes of supporting data query tool access to data.
  • Will be required to create and maintain joins between applications tables in support of end-user queries.
  • Will be responsible to understand the applications data structures, data definitions and relationships.
  • Will be responsible to setup and manage user access permissions.
  • Will be required to assist in debug of end-user reports code.
  • Bachelor’s degree in computer science or related field.
  • Will learn and maintain familiarity with basic functionality of Oracle BI Answers, Dashboard and Oracle Discoverer.
  • Will be required to learn and understand Oracle SQL, PL/SQL, Oracle APEX and others as required.
  • Understanding of relational data structures, indexing, data partitioning, functions and packages.
  • Good verbal and writing skills and ability to communicate clearly and effectively ideas and concepts.
  • Good analytical skills and propensity for detail with strict adherence to standards and process.
  • Able to work efficiently with minimal direction and deliver in accordance with demanding delivery schedules.
  • Looking for people who find satisfaction in and appreciate the challenge of proving and/or disproving software quality.
  • Able to work extended hours when required.
  • Eligible to work in the US with no restrictions.

Monday, February 6, 2012

Make Room For One More!

Got some unexpected good news today. My company is sending a couple of developers to KScope12. I think what really put them over the edge was taking a look at the Schedule at a Glance

One other thing, ODTUG knows times are tough, so to ease the pain of registration, get a code from one of the vendors like Applied OLAP or the San Antonio Texas Oracle Users Group

C'mon, who doesn't want to save money??

Our journey continues...

Friday, February 3, 2012


Had an issue the other day where we needed to display counts per year range. The output needed to be something like:

[0-1] x dollars
[1-2] y dollars
[2-3] z dollars

The existing logic made redundant SQL calls to determine the min and max year vals. Very inefficient. Very unneccessary.

I immediately thought of using WIDTH_BUCKET. WIDTH_BUCKET is a numeric function that first appeared in Oracle 9i over ten years ago.

By definition, the Oracle WIDTH_BUCKET function is used to construct equiwidth histograms, in which the histogram range is divided into intervals that have identical size. For a given expression, the WIDTH_BUCKET function returns the bucket number into which the value of this expression would fall after being evaluated.

It's actually quite simple. Here's the syntax:

WIDTH_BUCKET(value, min_value, max_value, number_of_buckets);

I know what you're thinking, what if you have values that are below min_value or above max_value ?? Well, there's a convenient underflow and overflow bucket created automatically referenced by 0 and number_of_buckets +1, respectively.

Our journey continues...

Thursday, December 22, 2011

...and the Winner is…YOU

The Holiday season is upon us and most of us are hard at work wrapping up year-end projects, or at least wrapping up our presents. Kscope 11 is but a memory and while it seems Kscope 12 will never arrive, trust me, it will be here in the blink of an eye. In fact, there is much to report.

Let’s talk for a minute about the content. First, we received more abstract submissions this year than ever before – over 750 in total. While it’s great to see such interest and enthusiasm for Kscope, it also means that the choice of who gets accepted just got a whole lot tougher. We made some changes to the process this year. The biggest change was implementing a blind review – meaning that the speaker and the abstract were peer reviewed separately. This really forces the speaker and the subject matter to stand on its own merit. It definitely adds more work for the content teams, but if the result is a stronger lineup of speakers and sessions, then the effort has been worthwhile. Much credit goes to David Schleis and Natalie Delemar, who chaired the non-EPM and EPM content respectively, as well as the content team leads and content teams. WELL DONE!

The recommendations from the content teams were received at the beginning of December. The Kscope Conference Committee then gave its approval. Looking at the final lineup of speakers and sessions, all I can say is WOW! You guys continue to amaze. The content is by far the strongest of any Kscope I’ve been a part of. Attendees will be faced with the impossible task of deciding between Tom Kyte, Jonathan Lewis, Edward Roske, Steven Feuerstein, Tracy McMullen, Mark Rittman, Cary Millsap, Duncan Mills, Kevin McGinley, Dr. Paul Dorsey and dozens of other must-see speakers. How you do that is up to you. My job is to make that decision as tough as possible and I assure, we succeeded.

Now that the content is in place, the Conference Committee turns its focus to the Community Service Day, the General Session, the Wednesday night Special Event, and the various receptions to be held throughout the week. Kscope11 did set the bar pretty high, but know that we are on the job, hard at work to not just meet expectations, but to shatter them.

When it comes to Kscope, there are many winners. San Antonio was announced as a winner last June. Just last week, hundreds of speakers were notified that they, too, were winners. However, the real winner at Kscope is…YOU, the attendee. If you’ve never attended a Kscope conference before, let me say, there’s nowhere else you can get this content, from these speakers, at this fabulous venue. It’s a win, win….win situation.

We’ll see you in San Antonio!

Our journey continues...