JAY SEPHUS
Frisco,TX
Summary
Currently Serving as Sr. Business Systems Analyst & Sr. Product Manager. Logical Business Analyst Skilled at delivering customized solutions to boost business operations. Expert at translating plans for business growth and specific needs into improved system designs. Highly Focused on process efficiency. Highly Proficient with Excel and Data modeling and Reporting Automation.
Overview
11
11
years of professional experience
Work History
Sr. Product Manger
CBRE
Richardson, TX
03.2022 - Current
- Led technical implementation of Sustainability dashboards to give deep ESG insights.
- Led technical implementation of Capital Markets dashboard to gain better insight to our project capitalization
- Led effort of Data exploration to gain detailed cost data allowing us to see detailed project spending at vendor and material level. (first in industry to accomplish this accurately)
- Currently Leading effort to migrate our proprietary software from Kendo to Angular platform.
- Currently leading effort to globalize our platform allowing for our European business segments to use platform.
- Currently Managing Backlog and leading Backlog refinement, Sprint Planning, Sprint Review.
- Currently Leading efforts to build better reporting insights as well as automating reoccurring reports to save time for business executives.
Sr. Business Systems Analyst
CBRE
Richardson, TX
11.2021 - Current
- Nominated to Board to manage Budget Builder (Complex Excel Financial Model) and help implement changes and make more efficient.
- Singlehandedly completed project to globalize excel financial model adding capability to model deals for European Business segment.
- Managed projects and served as primary liaison between client and multiple internal groups to clarify goals and meet standards and deadlines.
- Manipulated data using pivot tables, pivot charts and macros in Excel.
- Created Streamlined Tables for IC Package reporting within Budget Builder Document.
- Computed, recorded and proofread data in preparation of records and reports.
- Reviewed company software and business programs to determine value and assess viability in live environment.
- Created and Mapped outlines to streamline and automate Corporate Quarterly reporting, LEED data reports.
REAL ESTATE INVESTMENT ANALYST
JOSH DESHONG REAL ESTATE ADDISON
, TEXAS
06.2021 - 07.2021
- Served as a finance representative to Acquisitions and Development besides directly supporting senior management with financial needs and projects.
- Successfully Analyzed business systems and improved task time by 95 %.
- Greatly improved system reporting tools by adding and changing Excel functions and algorithms to make data entry and processing more efficient.
- Prepare detailed analysis of properties by compiling financial data into an Excel spreadsheet for investment evaluation by senior management.
- Analyzed applicants and their insurance history to ensure financial stability; work directly with accounting to audit potential tenants.
Workflow Analyst
NOBLE WRX HOME RENOVATIONS
DALLAS, TEXAS
06.2020 - 11.2020
- Created Fully robust and customizable CRM software built specifically for their needs that greatly reduced the amount of systems overhead and manual input required from field workers.
- Improved workflow so greatly that it became possible to hire more contractors based on my efforts with workflow systems development.
- Organized /conducted weekly staff meetings, discussed new projects, objectives, and career development strategies.
- Reviewed established procedures to assess areas in need of improvement.
REMOTE TECHNICIAN
ASTECH
PLANO, TEXAS
01.2017 - 12.2018
- Provided answers for general usage and operation questions as well as problem determination/problem source Identification.
- Provided technical support, diagnosing and troubleshooting hardware and software problems, including desktop, laptop.
PROJECT MANAGER
ASTECH
PLANO, TEXAS
01.2018 - 08.2018
- Coordinated the inspection and testing of work performed and materials used with outside quality assurance personnel as required by the inspection and test plan and contract requirements.
- Solicited and reviewed competitive bids from sub-contractors, ensuring the proper scope of work was included in the proposal and that it met or fell below the allotted budget amount.
REAL ESTATE ANALYST
GREENWOOD TENACITY REAL ESTATE INVESTMENTS
DALLAS, TEXAS
10.2016 - 04.2017
- Successfully built financial forecast models that allowed for company to acquire land and develop build strategies that helped make project far more profitable.
- Analyzed and Assessed entire Zip codes to provide top notch financial data that allowed for the successful acquisition of a strategic partner.
- Built financial models so accurate and convincing that led to the successful raise of investment capital allowing for investment strategies to be implemented.
- Assisting in preparing business case proposals summarizing the financial impact to the company to aid in business decisions with the least cost structure to the company.
REAL ESTATE AGENT
SCOTTIE SMITH & ASSOCIATES
DALLAS, TEXAS
03.2016 - 12.2016
- Demonstrated exceptional prospecting skills by generating an extensive client base through aggressive marketing and personal referrals from satisfied buyers and sellers.
- Advised and informed prospective clients on current market activities/conditions and the negotiation process of real estate transactions.
Certified Master Technician
Classic BMW of Plano
Plano, Texas
09.2013 - 08.2015
- Performed maintenance and repair of engines, transmissions, brakes, suspension systems, and other automotive components.
- Diagnosed vehicle issues utilizing diagnostic equipment such as computerized scan tools.
- Repaired vehicles according to manufacturer specifications and standards.
- Provided technical advice to service advisors and customers regarding repairs and services needed.
- Researched updated information on parts, labor costs, warranty information and technical bulletins.
- Attended training seminars related to automotive technology advancements and updates.
Education
BBA - Finance/Data Analytics
The Colorado Technical University
Colorado Springs, CO12-2024
Completion of BMW STEP program -
03.2014
Associate of Applied Science - Automotive Technology
Lincoln College of Technology - Grand Prairie
Grand Prairie, TX08-2013
ASSOCIATE - APPLIED SCIENCE
Lincoln College of Technology
01.2013
Skills
- Heavy Excel Experience
- 25 years Jira - Agile experience
- Analytical Thinking
- Client Advisory
- Problem Solving
- Financial Modeling
- Data Interpretation
- Performance Analysis
- Business systems, Problem Solving
- Specification formulation
- Technology implementation
- Solution development
- User Acceptance Testing
- Data Migration
- Project Management
Relevant Professional Development
- Automotive Technology Degree (top 2% of class)
- BMW STEP Graduate
- 2+ Years as ASE Certified BMW Master Technician
- Excel Essentials
Timeline
Sr. Product Manger
CBRE
03.2022 - Current
Sr. Business Systems Analyst
CBRE
11.2021 - Current
REAL ESTATE INVESTMENT ANALYST
JOSH DESHONG REAL ESTATE ADDISON
06.2021 - 07.2021
Workflow Analyst
NOBLE WRX HOME RENOVATIONS
06.2020 - 11.2020
PROJECT MANAGER
ASTECH
01.2018 - 08.2018
REMOTE TECHNICIAN
ASTECH
01.2017 - 12.2018
REAL ESTATE ANALYST
GREENWOOD TENACITY REAL ESTATE INVESTMENTS
10.2016 - 04.2017
REAL ESTATE AGENT
SCOTTIE SMITH & ASSOCIATES
03.2016 - 12.2016
Certified Master Technician
Classic BMW of Plano
09.2013 - 08.2015
BBA - Finance/Data Analytics
The Colorado Technical University
Completion of BMW STEP program -
Associate of Applied Science - Automotive Technology
Lincoln College of Technology - Grand Prairie
ASSOCIATE - APPLIED SCIENCE
Lincoln College of Technology