/
Fishing for Success in the Wild with SAS and Oracle Fishing for Success in the Wild with SAS and Oracle

Fishing for Success in the Wild with SAS and Oracle - PowerPoint Presentation

danika-pritchard
danika-pritchard . @danika-pritchard
Follow
380 views
Uploaded On 2017-10-18

Fishing for Success in the Wild with SAS and Oracle - PPT Presentation

Alejandro Farias Texas Parks amp Wildlife Maureen Chew Oracle http bitly 1NgGcUU Fishing for Success in the Wild with SAS and Oracle Alejandro Farias alejandrofariastpwdtexasgov ID: 597062

sas oracle resources texas oracle sas texas resources fishing provide conserve natural manage mission hunting outdoor recreation opportunities enjoyment

Share:

Link:

Embed:

Download Presentation from below link

Download Presentation The PPT/PDF document "Fishing for Success in the Wild with SAS..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.


Presentation Transcript

Slide1

Fishing for Success in the Wild with SAS and Oracle

Alejandro

Farias

, Texas Parks & Wildlife

Maureen Chew, Oracle

http://

bit.ly

/1NgGcUUSlide2

Fishing for Success in the Wild with SAS and Oracle

Alejandro Farias

alejandro.farias@tpwd.texas.govSlide3

The Idea & Reality

The Story

The Vision

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide4

Cloud Proven Database as a Service (

DBaaS

)

Benefits from TX Cloud

DBaaS

Provides Valuable Services to Constituents

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide5

Our Role as Analysts Have Changed

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.

Technological advances are reshaping Analyst’s role into that of a Data Scientist.

Multi-disciplinary

backgrounds

influence

our perspective.

Our

knowledge bridges the gap between the Information Technology aspect and the Business Units.

Stress strategic problem solving by understanding and applying a broader knowledge base.Slide6

LURES: License

Utilization and Revenue Enhancement

System

LURES Goal: A comprehensive analytics application that provides a 360-degree view of TPWD customers.

Business Goal: Understand how customer relationships impact revenue to help reduce costs and better deploy resources to improve the customer experience. Technology Goal:

Integrate, cleanse and secure all databases that track customer interactions, especially revenue.

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide7

Award Winning Innovation Using SAS and Oracle Database

From Days to Minutes

….

Automated complex accounting reconciliation between Oracle Financials and State Accounting SystemHighly optimized Oracle SQL via SAS PROC SQL Pass-ThruResult: Advanced reconciliation reporting AutomatedDays to minutesJournal and accounting smart matchingIncorporated validation and integrity checkpoints

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide8

SAS Business Intelligence (BI) Server and Oracle Supercluster

SAS Business Intelligence Server 9.4

3-Tiers: Metadata, Mid-Tier, Compute

Oracle SuperCluster T5-8 DBaaSDB for Oracle E-BIZ Financials 11.5.10-2

Two node RAC  DEV&TEST/PROD: Each 2 cores/24GBSolaris Zones provide fine grained virtualization DB user response times improvedPerformance leveled as additional agencies came on-lineResource management prioritization

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide9

Technical/Practical Takeaways

Optimization Techniques

SID

rename technique for SAS migration to new Oracle instance.Further improve the speed of data retrieval through optimized SQL queries.Review legacy reporting scripts to tune and improve. Utilize Oracle SQL Developer to run explain plans to tune and optimize SQL used for SAS data warehouse jobs.

Maximize in-database processing to leverage the compute power of Supercluster and free up SAS compute resources. Initiate logging at each level to track and improve latency from sender to receiver and back again. Client logging via SAS Add-In for Microsoft OfficeSAS Server loggingOracle

SuperCluster

logging

Mission

: To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.Slide10

Presenter Biography

Alejandro Farias is a Financial Analyst in the Planning, Analysis, and Reporting section in the Administrative Resources Division at Texas Parks and Wildlife Department (TPWD). He has a B.S. in Agricultural Economics from Texas A&M University.

Over the last 5 years, Mr. Farias was instrumental in the design, architecture and implementation of SAS Business Intelligence (BI) tools and is experienced with data techniques for extracting, cleaning, conforming and delivering data to end-users. He is proficient in SQL and is versed in SQL tuning.

Mr. Farias was awarded the 2013 Employee Recognition Award for Innovation at TPWD for his work on developing new methods for financial analytics, reporting, reconciliation and training. Mr. Farias also serves as a team member on the License Utilization and Revenue Enhancement System project at TPWD.Slide11

SID Rename Template //TNSNAMES

SASSIDE

=

(DESCRIPTION= (LOAD_BALANCE=YES)

(FAILOVER=YES) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=ABC)(HOST=SERVER_NAME_1

)(PORT=

1111

))

(ADDRESS=(

PROTOCOL=

ABC)(HOST=SERVER_NAME_2

)(PORT=1111)) ) (CONNECT_DATA= (SERVICE_NAME=ORACLE)

(INSTANCE_NAME=ORACLE1))

)Slide12

For More Information

Texas Delivers Citizen Services in Secure Cloud

Customer Viewpoint: Cloud-enabled State Services – Texas relies on Oracle Fishing for Success in the Wild with SAS and Oracle (video, presentation

)Oracle & SAS: oracle.com/sasmaureen.chew@oracle.comgary.granito@oracle.com