Travis Tester 📊 Email & Phone Number

Oklahoma City, Ok, Us

Oklahoma City, Us

Principal of Vivify Datacraft, a boutique Visual Analytics & Solutions company specializing in information design, including: data visualizations, interactive infographics, Business Intelligence dashboard design and development, and user-interfaces for software applications.

Oklahoma City, Oklahoma, Us

Designed, developed, and deployed:- a CapX dashboard that aggregates, tracks, and monitors all all ongoing Construction in Progress and CapX projects.- a Hours Worked by Signage report that aggregates hours worked across all projects and stand-alone work orders by our Signage team, where those hours were allocated too (company), who worked them, and what activity type allowing management to make hiring decisions and allocate resources.- a Cost Code report that aggregates invoices across all Cost codes and shows how much $ has been spent vs. the FY Approved Budget, and what remains allowing management to track spending and control budgets.- a Supplier dashboard report that aggregates invoices across all projects, ARF's or departments, showing how much $ has been approved per Supplier, remaining balances-to-finish, and % Billed, allowing management to facilitate reconciling supplier invoices, and improving the bidding/budgeting process.- an Aging Invoice dashboard report that aggregates invoices across all departments, shows how long they have been open, allowing management to facilitate approving and paying invoices in a more efficient and timely manner. Improved supply chain and reduced time to process invoice by over 1 business week.- a system that collects shift/time worked data and generates automated invoices for billing of guest service ambassador labor at Stephenson Cancer Center, greatly reducing time to create invoice and human error.- a system that data mines monthly invoices to generate reports and insights over active employee headcounts, new hires, terminations, turnover rates, overtime vs. regular pay analysis, and FYTD actual spend vs. FYTD forecasted vs. FY budgeted amounts.- a system that collects data and generates automated reports/notifications on the operational statuses of elevators on campus, including uptime % and incident history, greatly reducing the frequency and length of elevator outages across campus.

Healthcare Data Analyst highly skilled in all aspects of data analytics, including mining, generation, and visualization. Committed to transforming data into readable, goal-driven reports for continued innovation and growth, and creating best practice standards for data mining, analysis and visualization. Additionally, responsible for the evaluation of internal systems for efficiency, problems or inaccuracies, developing and maintaining protocols for handling, processing and cleaning data.Created multiple highly customized and interactive BI dashboards for internal operations monitoring as well as producing various dashboards that aim to improve public safety and health outcomes for state agencies.Tasks include BI dashboard creation within Tableau Desktop, administrating Tableau Server, conducting user UX reserach, designing the UI for websites, BI dashboards, and software applications within Adobe XD and Figma, facilitate UI hand-offs to devs using Zeplin, engineering ETL pipelines using Tableau Prep, data munging, wrangling, and cleaning using various tools, creation of dashboard operation manuals, project proposals, and scope statements in Adobe InDesign and Affinity Publisher, agile project management within Jira, creation of databases, schemas, and tables within Snowflake and loading data into our cloud environment, monitoring BitBucket for pull request and establishing version control best practices, create of knowledge base articles using Confluence, front-end web development in Webflow for our data applications, prompt engineering for ChatGPT, Firefly, and Midjourney, and assisted in facilitation of weekly internal BI meetings.

Oklahoma City, Ok, Us

Instructor of Web Design & Development, Publication Design, Graphic Design 1 and Graphic Design 2 in the Studio Arts & Design Department at Oklahoma City University

Edmond, Ok, Us

Taught 400+ UCO students business management and the art of creating digital media assets for online marketing to further their careers in the College of Fine Arts and Design department.

Helped research and complete over 750+ commercial real estate appraisal reports. Duties included gathering data, data entry, database management, researching comparable sales, pulling zoning info, analyzing potential flood hazard threats, demographic research, tax valuation, aerial mapping, market area and traffic analysis, and frequent work with many counties assessors, clerks, and treasurers.Also oversaw and supported all administrative duties in the office, including managing office supplies and inventory, performing receptionist duties, identifying process improvement, and providing any other necessary office administrative support before moving to remote work (WFH) due to the COVID-19 pandemic.

Oklahoma City, Ok, Us

Completed my contract as the Audio & Video Technician and IT Specialist during the regular session of Oklahoma State Senate's 54th Legislature.

Skilled in IT Server Rack layout, cable organization, multiple wire terminations, and the installation, operation, testing, and troubleshooting of audio and video equipment.Oversaw all shipping and receiving activities, as well as supervised inventory management and control processes including stocking, re-ordering, order fulfillment. Maintained warehouse workflow, skilled in inventory control, process improvement, logistics, and operations management.

Bachelor Of Science (Honors), Technology Application Studies

Associate Of Applied Science, Contemporary Music Business