Skip to content
View Trey-Array's full-sized avatar

Block or report Trey-Array

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Trey-Array/README.md

πŸ‘‹ Hi, I'm Trey-Array

πŸ’Ό Business Analyst | πŸ—„οΈ Oracle SQL | πŸ§ͺ BAT/UAT | 🐍 Python | πŸ“Š Power BI | πŸ€– AI

Welcome to my GitHub profile!

I'm a Business Analyst with experience working with business processes, data, systems, Oracle SQL and Business Acceptance Testing.

I'm expanding my technical skill set by developing my capabilities in Python, Power BI, AI, automation and software development.

My goal is to bridge the gap between business requirements, data and technology and build practical solutions that solve real-world business problems.


πŸ§‘β€πŸ’» About Me

  • πŸ’Ό Business Analyst
  • πŸ—„οΈ Experienced with Oracle SQL
  • πŸ§ͺ Experienced with Business Acceptance Testing (BAT)
  • πŸ” Experienced in requirements analysis and data validation
  • πŸ“Š Interested in data analysis and business intelligence
  • 🐍 Developing my Python programming skills
  • πŸ“ˆ Developing Power BI and data visualisation skills
  • πŸ€– Exploring Artificial Intelligence and Generative AI
  • βš™οΈ Interested in automation and process improvement
  • πŸš€ Building practical projects to strengthen my technical skills

πŸ› οΈ Skills & Technologies

πŸ’Ό Business Analysis

  • Requirements Analysis
  • Business Acceptance Testing (BAT)
  • User Acceptance Testing (UAT)
  • Test Case Design
  • Acceptance Criteria
  • Requirements Traceability
  • Defect Management
  • Process Analysis
  • Data Validation
  • Agile / Scrum

πŸ—„οΈ Data & Databases

  • Oracle SQL
  • Data Validation
  • Data Analysis
  • Data Quality
  • Complex Queries
  • Joins
  • Aggregations
  • Microsoft Excel

🐍 Python & Automation

Currently developing:

  • Python
  • Pandas
  • Data Analysis
  • Data Visualisation
  • Automation
  • API Integration
  • Software Development

πŸ“Š Business Intelligence

Currently developing:

  • Microsoft Power BI
  • Power Query
  • DAX
  • Data Modelling
  • Interactive Dashboards
  • Business Intelligence
  • Data Storytelling

πŸ€– Artificial Intelligence

Currently developing:

  • Generative AI
  • Prompt Engineering
  • LLM Fundamentals
  • AI-Assisted Development
  • AI APIs
  • AI Automation
  • RAG
  • AI Agents
  • Evaluating AI-generated results

πŸ”§ Development Tools

  • Git
  • GitHub
  • SQL Developer
  • Microsoft Excel
  • Version Control
  • Documentation

πŸš€ Featured Projects

🏒 Insurance Policy BAT & Data Validation System

A fictional insurance system designed to demonstrate the combination of Business Analysis, Business Acceptance Testing, Oracle SQL and Python.

Project Goals

  • Define business requirements
  • Create acceptance criteria
  • Design BAT test cases
  • Build a requirements traceability matrix
  • Create and validate database data
  • Use SQL for data validation
  • Develop Python business logic
  • Automate test validation
  • Track and document defects
  • Produce Business Acceptance Test reports
  • Visualise testing results using Power BI
  • Explore AI-assisted testing and analysis

Technologies

Oracle SQL Python Power BI GitHub BAT UAT AI

πŸ”— Project coming soon


πŸ’° Python Expense Tracker

A Python application designed to track income, expenses and financial activity.

Planned Features

  • Record income and expenses
  • Categorise transactions
  • Calculate spending totals
  • Track monthly finances
  • Store financial data
  • Generate financial summaries
  • Analyse spending patterns

Technologies

Python Pandas CSV

πŸ”— Project coming soon


πŸ“Š Business Data Analyzer

A project focused on transforming raw business data into useful insights.

Planned Features

  • Import CSV and Excel data
  • Clean and validate data
  • Analyse business metrics
  • Identify anomalies
  • Generate summary statistics
  • Create visualisations
  • Produce business insights

Technologies

Python Pandas SQL Excel

πŸ”— Project coming soon


πŸ“ˆ Business Intelligence Dashboard

A Power BI project focused on turning business data into interactive dashboards and decision-support information.

Planned Features

  • Data transformation using Power Query
  • Data modelling
  • DAX calculations
  • KPI development
  • Interactive dashboards
  • Trend analysis
  • Business performance reporting

Technologies

Power BI Power Query DAX SQL

πŸ”— Project coming soon


πŸ“š Currently Learning

🐍 Python

  • Python fundamentals
  • Variables and data types
  • Conditional logic
  • Loops
  • Functions
  • Lists and dictionaries
  • File handling
  • Object-oriented programming
  • Error handling
  • Pandas
  • Data analysis
  • Automation
  • APIs

πŸ—„οΈ Advanced Oracle SQL

  • Common Table Expressions (CTEs)
  • Window functions
  • Complex joins
  • Subqueries
  • Data validation
  • Query optimisation
  • Data modelling
  • PL/SQL

πŸ“Š Power BI

  • Power Query
  • DAX
  • Data modelling
  • Interactive dashboards
  • KPIs
  • Business intelligence
  • Data storytelling

πŸ€– AI & Generative AI

  • Prompt engineering
  • LLM fundamentals
  • AI-assisted development
  • AI APIs
  • AI automation
  • Retrieval-Augmented Generation (RAG)
  • AI agents
  • AI evaluation

πŸ”§ Software Development

  • Git
  • GitHub
  • Version control
  • Testing
  • Automated testing
  • APIs
  • Software development practices

🎯 Development Goals

My goal is to become a highly technical Business Analyst who can bridge the gap between:

Business Requirements β†’ Data β†’ Technology β†’ AI β†’ Business Solutions

Current Focus

  • 🐍 Strengthen Python
  • πŸ—„οΈ Improve advanced Oracle SQL
  • πŸ§ͺ Build stronger BAT/UAT solutions
  • πŸ“Š Develop Power BI skills
  • πŸ€– Develop practical AI skills
  • βš™οΈ Learn automation
  • πŸ”§ Improve Git/GitHub workflows
  • πŸ“ˆ Build practical data-driven applications

Future Goals

  • πŸ€– Build AI-powered business solutions
  • ☁️ Learn cloud technologies
  • πŸ”Œ Develop and integrate APIs
  • 🐳 Learn Docker
  • πŸ§ͺ Develop automated testing solutions
  • πŸ“Š Build advanced business intelligence solutions
  • πŸš€ Develop full business applications

πŸ’‘ My Development Philosophy

Understand the business β†’ Analyse the data β†’ Build the solution β†’ Test it β†’ Measure it β†’ Improve it

I believe technology is most valuable when it solves a real business problem.

My focus is not simply on learning technologies individually, but on understanding how they can work together to create useful business solutions.


πŸ”— My Technical Journey

                    BUSINESS ANALYSIS
                           β”‚
                           β–Ό
                  Requirements & BAT
                           β”‚
                           β–Ό
                    Oracle SQL
                           β”‚
                           β–Ό
                    Data Analysis
                           β”‚
              β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
              β–Ό                         β–Ό
           Python                    Power BI
              β”‚                         β”‚
              β–Ό                         β–Ό
         Automation              Business Insights
              β”‚                         β”‚
              β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
                           β–Ό
                    AI & Generative AI
                           β”‚
                           β–Ό
                Intelligent Automation
                           β”‚
                           β–Ό
              Business Technology Solutions

Popular repositories Loading

  1. Trey-Array Trey-Array Public

  2. 100_days_of_Python 100_days_of_Python Public

    Udemy Course - 100 days of Python