Mark Emmerson Balingit

One curious mind seeking problems to analyze and solve by bringing raw data to life.

Fixer of inefficiencies.

Intrigued by anything data, patterns, puzzles, and ideas.

Love to help those in need.

Always asking (mostly the right) questions.

“I would rather have questions that can’t be answered than answers that can’t be questioned.”

– Richard Feynman

Experience

Penn National Gaming

Las Vegas, NV

Business Intelligence Analyst

Aug 2020 – Present
Sept 2019 – Apr 2020 (Covid Shutdown)

Tools Used:
  • Tableau
  • Oracle Fusion Cloud OTBI (Financial)
  • Oracle Fusion Cloud BI Publisher (Financial)
  • Oracle Financial Reporting Web Studio
  • SQL / T-SQL
  • SQL Server Management Studio
  • SQL Server Reporting Services
  • Microsoft Excel
  • Microsoft Word
  • EasyVista
Experience:
  • Reworked Tableau dashboards to SSRS variant to create more user-friendly Excel / CSV exports for finance department, at the same time saving on Tableau licenses
  • Recreated legacy financial reports into Oracle equivalents after ERP conversion using OTBI, BI Publisher, and FRS

Western Veterinary Conference (WVC)

Las Vegas, NV

Discovered, improved, and established procedures, which empowered staff to work more efficiently and autonomously. Through the implementation and utilization of SSRS, maintained business intelligence project, which filled a reporting void of 3 years. Resolved challenges and provided support for internal staff and customers dealing with a platform of multiple systems.

Database and Systems Specialist

Sept 2017 – Apr 2018

Tools Used:
  • Aptify
  • cadmiumCD Event Management
  • SQL / T-SQL
  • SQL Server Management Studio
  • SQL Server Reporting Services
  • Microsoft PowerBI
  • Crystal Reports
  • Microsoft Excel
  • Microsoft Word
  • Freshdesk
  • JIRA
Experience:
  • Provided one-on-one and group training to increase staff efficiency with using Aptify
  • Wrote documentation for users on processes frequently needing help with
  • Collaborated with 3rd-party developer, PerByte, Inc., allowing for the creation of customizable registration pages usable over multiple product lines
  • Provided data pulls and enriched data to Bear Analytics, who were tasked with creating interactive dashboards via Tableau
  • Noticed inconsistencies with legacy data and worked closely with Education department to clean data for accuracy in future reporting
  • Created views showing only data necessary for the task at hand for various departments allowing staff to make their jobs easier and become more efficient
  • Actively monitored sync errors between two systems to ensure correct data flowed through to database
  • Fixed and optimized Crystal Report used to run 450 speaker and moderator presentation schedules, resulting in time-savings of 120 hours and the need to edit in Microsoft Word
SSRS:
  • Provided time-savings of 100 hours for processing speaker payment information
  • Developed reports for various departments which were able to be scheduled and/or run on-demand
  • Created process and invoice template used to process ~$3 million
Systems Analyst

Jun 2017 – Sept 2017

Tools Used:
  • Aptify
  • cadmiumCD Event Management
  • SQL / T-SQL
  • SQL Server Management Studio
  • Crystal Reports
  • Microsoft Excel
  • Microsoft Word
Projects:
myCadmium Speaker Portal:
  • Configured Annual Conference Speaker Portal used by 450 speakers and moderators to take advantage of previously unutilized functions
  • Improved email communication to Annual Conference speakers by increasing customization of emails to provide more personalization
CE Certificate Delivery:
  • Together with PerByte, developed an automated process for CE certificate delivery, reducing time spent on post-course preparation and allowing participants to download and print certificates on-demand through the web
  • Used Crystal Reports to create a template for CE Certificates
Participant Persona:
  • Initiated persona project for Education department to aid with development of future educational courses
  • Utilized Excel VBA scripts to combine multiple survey results into one file for ease of analysis

Desert IT Solutions

Las Vegas, NV

IT Technician

Apr 2016 – May 2017

Hired on as second employee and provided superior customer service in a timely fashion allowing owner to concentrate on growing this startup managed service provider. Served as the highly requested technician for support requests.

Tools Used:
  • ConnectWise Help desk
  • Kaseya Remote Management
  • Atlassian Confluence
  • Acronis
  • vmWare vSphere
Experience:
  • Performed troubleshooting for clients around the Las Vegas area
  • Used ConnectWise as a help desk platform to monitor and track issues
  • Provided technical support remotely over the phone and Kaseya
  • Assisted clients on-site for issues unable to be fixed remotely
  • Responsible for managing third-party vendors for clients
  • Setup server / domain controller utilizing vmWare ESXi
  • Administered Active Directory
  • Configured and restored backups using Acronis
IT Technician (Contract)

Mar 4 – 10, 2016

Setup client’s internal staff with workstations and network. Staffed IT help desk providing technical support for a non-technical, international, annual conference with over 15,000 attendees.

Contact Me

Interested in learning more?
I would love to hear from you!