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
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.
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