Learn Data Skills
Beta
Bryan Wells

Bryan Wells

Database Developer / Business Analyst

Contractor

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Project

Introduction to DataCamp Projects

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

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.

My Work Experience

Where I've interned and worked during my career.

IQ Clarity for RevGen Partners | Feb 2023 - Aug 2023

Senior Database Developer / Business Analyst

Business Analysis, SQL, SDLC, Agile, Scrum, Jira, Data Warehouse, ETL Data Pipelines, Toad, SQL Tuning, PL/SQL, Oracle 19c • 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 • Analysis of client business requirements related to ETL Data Pipelines used to populate Enterprise Data Warehouse working jointly with client SMEs and RevGen team prior to translating into Jira stories • 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
Show More

Global Healthcare eXchange | Jan 2021 - Jan 2023

Database Engineer

Skills: Business Analysis, Agile, Scrum, Jira, Git, SDLC, Oracle 19c, SQL, PL/SQL, ANSI SQL, Toad, SQL Tuning, SAP BusinessObjects 42, SAP Information Design Tool, Salesforce, Apttus, Taskray, PostgreSQL, MySQL • Utilize SDLC across multiple business unit projects using Agile methodology within Jira to lead the design and delivery of tasks assigned to me with little supervision • Collaborated with Service Delivery Director and Manager in analyzing and refining requirements to design and develop reporting out of data warehouse instrumental to providing KPI reporting used for managing personnel across projects and providing monthly quantitative reporting to the Board of Directors • Assisted Senior Engineer to monitor and programmatically support a proprietary Revenue Recognition process and its reporting for internal accounting team • Mentor junior level developer in the understanding of the database design and SQL coding related to GHX Global Data Warehouse

Robert Half | Feb 2019 - Dec 2020

Contractor for Global Healthcare Exchange

• Perform business analysis and design while collaborating with business unit leaders to assist in deriving key performance indicators to drive productivity and provide insight to the board of directors • Lead and contribute to the delivery of business intelligence solutions for internal Global Healthcare eXchange (GHX) teams using core Oracle SQL, PL/SQL, SAP Business Objects WebIntelligence, and Information Design Tool (IDT) • Collaborate in the understanding, support and troubleshooting of internally designed and built Revenue Recognition application and its reporting to programmatically resolve business process needs where appropriate • 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

Aurora Public Schools | Oct 2017 - Feb 2019

Analyst/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 (APS) • 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 - Oct 2017

Contractor for Aurora Public Schools

• 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 (APS) • 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 & Co, Inc. | Apr 2010 - Jan 2017

Database Developer

• 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

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, contributing to the success of business needs by delivering value-add solutions to solve complex problems

Powered by

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