Learn Data Skills
Beta
Bryan Wells

Bryan Wells

Database Engineer

Contractor

Technologies

Unleashing the magic of data, one algorithm at a time.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

PeopleCert ITIL Foundation Certificate in IT Service Management

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Robert Half Technology | Jan 2024 - Nov 2024

Database Engineer/Developer - for Xanterra Travel Collective

- Designed, developed and documented new AP integration stream from CloudSuite ERP to the Seaware Oracle RDS database requiring multiple design meetings with accounting managers and the CIO who previously built other corporate integrations - Created new or rewrote numerous PowerBI reports using straight SQL from Oracle or T-SQL within Azure DWH due to database changes introduced in a major Seaware software upgrade - Took initiative to analyze and document high-level data flow diagram of one of the many data integrations within the first week of coming on board - Independently initiated collaboration throughout project tasks with all levels of the organization to assure timely completion of development tasks
Show More

IQ Clarity, LLC | Feb 2023 - Aug 2023

Senior Database Developer - for RevGen Partners

- Built relationships between client SMEs and RevGen team members to help facilitate requirement JAD sessions throughout the project to understand new or changing business requirements to translate into development Jira stories - Analysis of client business requirements and built queries used in Talend ETL Data Pipelines to populate newly created Enterprise Data Warehouse from disparate data sources - Continual updating of project related documents for both RevGen and the client, specifically around client Source to Table Mapping (STTM) fact and dimension tables - Independently worked with client team to refine gaps in requirements related to data warehouse design and best practices translated from developer technical sessions - Audited and presented data load results to key stakeholders to assist in identifying project needs, timelines, and goals to assure project SLAs were met - Utilize Oracle SQL and ANSI SQL to assess client grain uniqueness and transformation logic from disparate data sources

GHX | Jan 2021 - Jan 2023

Database Engineer

- Lead business analysis and design while collaborating with business unit leaders to assist in deriving key performance indicators to drive productivity and provide insights to the board of directors - Lead in the design and delivery of specific business intelligence projects for internal teams using core Oracle SQL, PL/SQL, SAP Business Objects Web Intelligence, and Information Design Tool (IDT) for extracting Salesforce data from Enterprise Data Warehouse into robust management reporting - Assisted Senior Engineer to monitor and programmatically support a proprietary Revenue Recognition process and its reporting for internal accounting team - Created monthly scheduled provider centric audit reporting stored and delivered from Amazon S3 - Began utilizing Snowflake against Enterprise Data Warehouse migrated to Amazon Redshift - Customer centric focus to understand process flow and data needs to help drive the design and development of requested solution within an Agile Scrum development model - Perform general application development activities, including unit testing, code review, code deployment and support from development through production environments as well as documentation of findings throughout the life cycle

Robert Half | Feb 2019 - Jan 2021

Database Engineer for GHX

N/A

Regis University College for Professional Studies | Aug 2014 - May 2019

Affiliate Faculty

Facilitate graduate and undergraduate curriculum for the College of Computer and Information Sciences. - Database Architecture - Database Concepts - Database Management - Ethics For IT Professional - Oracle 12c SQL - Oracle 11g/12c PL/SQL - Database Technologies and SOA

Aurora Public Schools | Oct 2017 - Feb 2019

Oracle Programmer Analyst

maintenance tasks related to HR and Payroll modules in Oracle EBS R12 for Aurora Public Schools • Shell script for programmatically connecting to vendor sites for uploading and retrieving required datasets for Oracle EBS database • Design and enhance critical Oracle Forms and Reports based on APS Business group needs • SQL tuning using Oracle Explain Plan or Toad Optimizer

EdgeLink | Jun 2017 - Sep 2017

Oracle Programmer

• Develop or enhanced core PL/SQL procedures for data integration or maintenance tasks related to HR and Payroll modules in Oracle EBS R12 for Aurora Public Schools • Shell script for programmatically connecting to vendor sites for uploading and retrieving required datasets for Oracle EBS database • Design and enhance critical Oracle Forms and Reports based on APS Business group needs • SQL tuning using Oracle Explain Plan or Toad Optimizer

Charles Schwab | Apr 2010 - Jan 2017

Database Engineer

• Developed shell script to correct client data within the production Oracle 11g database, reducing customer request turnaround time by 90% • Designed and developed shell scripts used for packaging database releases via RPM eliminating risk from a previous manual process • Developed or enhanced core PL/SQL procedures for data integration or maintenance tasks • Maintained the health and availability of 20 standalone development instances and 6 RAC QA database instances • Creation of scripts to collect SQL Tuning Sets from AWR and database cache for tuning of existing production SQL • Utilize OEM for active monitoring and troubleshooting database performance during high load activities • Tested and analyzed application regression performance against database for reporting and signoff prior to production release • Utilized RMAN scripting for maintaining Performance environment backups and restores for quicker turnaround during test cycles

Sapphire Technologies | Oct 2009 - Apr 2010

Oracle DBA

Contractor for Charles Schwab

My Education

Take a look at my formal education

MS/CIS, Database TechnologyRegis University | 2004
BS/CIS, Computer and Information Sciences, GeneralRegis University | 1997
Diploma, College prepIver C. Ranum | 1986

About Me

Bryan Wells

IT Professional with a customer first attitude collaborating with cross functional teams and key stakeholders to deliver value-add solutions to solve complex problems

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free