Tyler Berthelson
Senior Database Administrator at Criterion Systems- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Criterion Systems
-
United States
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Senior Database Administrator
-
Aug 2020 - Present
-
-
-
GES - Global Experience Specialists
-
United States
-
Events Services
-
700 & Above Employee
-
Oracle Application Database Administrator
-
May 2014 - Mar 2020
• Served in a 3 DBA team as a tier 2 DBA with two Senior DBAs with over 40 years of combined experience. This offered an invaluable opportunity for growth and learning. • Provided support for 4 Oracle production database servers running 11g and 12c and 2 production apps servers running Oracle E-Business Suite 12.2. • Proven ability to provide on-call support and resolve production issues independently. • Supported 8 pairs of development databases and App servers to facilitate timely development and QA testing to a large international development team. • Extensive time spent utilizing RMAN for backup and recovery as part of disaster recovery and cloning process keeping development environments updated. • Has a customer centric support philosophy that works very well with teams of business owners and other IT professionals.
-
-
-
Wyndham Consumer Finance, Inc.
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Business Analyst
-
2006 - Feb 2014
Creates presentations of financial and operational information for executive leadership. Provides decision making support for the service of approximately $5Billion in active loans. Builds forecasts and predictive models that use leading indicators to support workforce planning and budgeting decisions. Performs ad-hoc analysis of financial portfolio used in support of multiple business units in finance and operations. • Certified as Lean / Six Sigma Green Belt by successfully completing project that created over $500,000 in annualized efficiency gain by analyzing customer behavior to identify financial patterns. • Certified as Lean / Six Sigma Yellow Belt by building predictive model that utilizes pattern analysis and statistical probability to realize $400,000 in annualized efficiency gain from right sizing inbound contact center operations. • Designed, developed and then lead team responsible for workforce management applications that are currently used by all Wyndham Consumer Finance departments. These tools have generated vast soft and financial benefits reaching well over $1,000,000.
-
-
-
Nextel Partners
-
Telecommunications
-
100 - 200 Employee
-
Business Analyst
-
Jan 2002 - Aug 2006
Responsible for business intelligence and decision making support for Consumer Finance department and nationwide markets, using self-created data mart and data extraction methods from a variety of sources. Forecast and trend analysis of delinquency, bad debt write offs, revenue and associated employee performance metrics. Worked directly with corporate accounting to manage bad debt financial operations and cost center budget reviews. • Managed project implementation and automation of manual fee process that saved Nextel Partners over $1,000,000 in lost revenue annualized by Identification of lost fee opportunities. • Designed and developed data mart on Microsoft SQL Server platform that created vast gains in financial and operational reporting. • Expert in data management and SQL query development for full Consumer finance portfolio. • Provided business Intelligence support for Marketing, Sales, Consumer Finance and Customer Care departments with outstanding reputation for timeliness and accuracy. • Designed and implemented data upload system from CACS to Mosaix predictive dialer. This facilitated focused dialing efforts based on customer behavior and allowed for customizable collections activity. Predictive dialer involvement required detailed process knowledge of dialer operation, campaign design and customer collections behavior.
-
-
-
First National Bank of Marin
-
Las Vegas
-
Oracle Jr. Database Administrator
-
May 1999 - Sep 2001
Provided maintenance and development for Oracle data warehouse used to store data critical to corporate operations. Supported Oracle client end users and maintained Oracle financials application server. Was instrumental in finding cause of database errors and researched methods to fix and optimize database performance. • Developed strong understanding of relational database operation and support of clients in high stakes financial environment. • Provided round the clock support in a 24 hour operation and more importantly learned the value of careful planning, research and testing before taking action in production environments. • Duties include restart of Oracle servers and restarting services in required order. Maintaining Oracle server health by monitoring and available space and projected size demands. Working with application developers to gather requirements and create properly sized table-spaces. Managing user credentials and account permissions.
-
-
Education
-
Colorado State University
Master of Business Administration (MBA), Finance, General -
University of Phoenix
BSBA, Business Administration