Jason McLees

Data Analyst at Virtual Business Office Associates
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Analyzing and Visualizing Data with Microsoft Power BI
    Training Concepts
    Jul, 2021
    - Oct, 2024
  • SQL Server: Reporting Services
    LinkedIn
    Oct, 2019
    - Oct, 2024
  • Data Analytics for Business Professionals
    LinkedIn
    Aug, 2019
    - Oct, 2024
  • Learning SQL Programming
    LinkedIn
    Aug, 2019
    - Oct, 2024
  • Programming Foundations: Databases
    LinkedIn
    Aug, 2019
    - Oct, 2024
  • Microsoft SQL Server 2016 Essential Training
    LinkedIn
    Jul, 2019
    - Oct, 2024
  • SQL Server: Triggers Stored Procedures and Functions
    LinkedIn
    Jul, 2019
    - Oct, 2024
  • Project Management Certification
    University of South Carolina - Continuing Education and Conferences
    Dec, 2013
    - Oct, 2024
  • Associate Insurance Services (AIS-25)
    Insurance Institute of America
    Feb, 2009
    - Oct, 2024
  • General Insurance - AINS
    Insurance Institute of America
    Dec, 2008
    - Oct, 2024
  • SC Adjuster's License
    -
    Aug, 2007
    - Oct, 2024

Experience

    • United States
    • Human Resources Services
    • 100 - 200 Employee
    • Data Analyst
      • Feb 2019 - Present

      As a data analyst for VBOA I am responsible for reviewing, creating and updating healthcare reports for several customers. Our team ensures our data tables have current information imported into them and that the information is clean. I work with MSSQL server, Power BI, Excel, Toad, PowerPoint, Visual Studio, Mongo 3T, Postman and Alteryx on a daily basis. We are responsible for updating, creating, and improving views and stored procedures within our databases. As a data analyst for VBOA I am responsible for reviewing, creating and updating healthcare reports for several customers. Our team ensures our data tables have current information imported into them and that the information is clean. I work with MSSQL server, Power BI, Excel, Toad, PowerPoint, Visual Studio, Mongo 3T, Postman and Alteryx on a daily basis. We are responsible for updating, creating, and improving views and stored procedures within our databases.

    • Poll Clerk
      • Jun 2014 - Jun 2020

      Open and Close the Polling precinct. Return all voting ballots to home office. Help resolve voter concerns and issues. Coordinate with Poll Managers to ensure voting goes as quickly and professionally as possible. Assign up to 14 Poll Managers their responsibilities throughout the election day. Communicate with home office any issues. Ensure no laws are being broken. Print and post polling tapes in conspicuous location. Lock down voting machines once polls close. Remove all flash drives from machines. This usually requires 2 to 4 days of my time throughout election years only.

    • Wellness and Fitness Services
    • 1 - 100 Employee
    • DBA
      • Feb 2018 - Oct 2018
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Product Developer
      • Jan 2017 - Dec 2017

      Work Experience – SYSTEMTEC (2017 – present) Senior Analyst and Programmer – Product Development (2017 – present) Blue Cross and Blue Shield Contractor • Workflow Management Systems(WMS) for Commercial and Government customer accounts • Agile, Scrum and Waterfall methodology experience • C2 Clearance from Federal Government • Oracle SQL Developer experience • Structured Query Language (SQL) experience • Team Lead experience • Gather and document requirements from customers • Create technical and business specifications • Update test and production environments with new code and defect fixes • Communicate with executives and other personnel changes to WMS system • Create schedules for testing and implementations • Create work request tickets • Provide status updates to executives and team members • Help coordinate fundraising activities for our annual fundraising event

    • Computer Networking Products
    • 1 - 100 Employee
    • Associate Professional - Product Development
      • Aug 2007 - Dec 2016

      Associate Developer – Product Development (October 2013 - Present) Business Analytics and SRE accounts, 18 months • Troubleshoot user Web Events that come through help desk • Collaborate with technical teams to resolve issues • Copy and restore databases, reports, and universes between environments • Business Objects administrator monitoring users, jobs, rights and other settings in the Central Management Console • Modify database structure to user specification manually with client or internal SQL scripts • System administrator monitoring and freeing up space on hard drives • Monitor report issues and report instances to management Business Analyst Professional (February 2008 – October 2013) HIG Innovation Community, HIG Delivery & Kemper IC accounts, 5+ years • Received ‘Keys to Success’ award March 2009 • Gathered and reviewed business requirements. Analyzed and provided feedback to customer regarding approach • Documented approach and specifications based on client business needs • Researched and provided input to client regarding system issues or modifications needed • Worked with technical staff to resolve system issues • Created and executed test plans for system modifications • Extensively regression test base system configurations to ensure new modifications did not result in new issues • Created, tracked and assigned defects in our quality center defect management center • MARS administrator – entered and tracked approvals of requirements and specifications • Delivered enhancements to customer environments • Worked as a team lead over 3 individuals to deliver customer requirements on time and within budget; duration 3 months • Assisted Human Resources train new hires in the PACE/Navigator program • Provided estimates to managers, team leads and customers for business segments of software projects • Collaborated with product and engineering team members to define and develop new product concepts requested by the customer

Education

  • The Citadel, The Military College of South Carolina
    Bachelor of Science, Business Administration
    2004 - 2007
  • Drexel University
    Master of Science (M.S.), Project Management
    2014 - 2016
  • Columbia International University
    Master of Arts (M.A.), Theology/Theological Studies
  • Horry-Georgetown Technical College
    Associate of Science, Associate of Science
    2003 - 2004
  • Mary Brewer School of Insurance
    South Carolina Adjuster's License, Insurance
    2007 - 2007
  • Insurance Institute of America Inc.
    Certificate in General Insurance, Insurance
    2008 - 2008
  • Insurance Institute of America Inc.
    Associate in Insurance Services, Insurance
    2009 - 2009
  • Midlands Technical College
    Full Stack Web Developer (continuing education), Web Development
    2019 - 2019

Community

You need to have a working account to view this content. Click here to join now