Jason McLees
Data Analyst at Virtual Business Office Associates- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Analyzing and Visualizing Data with Microsoft Power BI
Training ConceptsJul, 2021- Oct, 2024 -
SQL Server: Reporting Services
LinkedInOct, 2019- Oct, 2024 -
Data Analytics for Business Professionals
LinkedInAug, 2019- Oct, 2024 -
Learning SQL Programming
LinkedInAug, 2019- Oct, 2024 -
Programming Foundations: Databases
LinkedInAug, 2019- Oct, 2024 -
Microsoft SQL Server 2016 Essential Training
LinkedInJul, 2019- Oct, 2024 -
SQL Server: Triggers Stored Procedures and Functions
LinkedInJul, 2019- Oct, 2024 -
Project Management Certification
University of South Carolina - Continuing Education and ConferencesDec, 2013- Oct, 2024 -
Associate Insurance Services (AIS-25)
Insurance Institute of AmericaFeb, 2009- Oct, 2024 -
General Insurance - AINS
Insurance Institute of AmericaDec, 2008- Oct, 2024 -
SC Adjuster's License
-Aug, 2007- Oct, 2024
Experience
-
Virtual Business Office Associates
-
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.
-
-
-
n/a
-
Wellness and Fitness Services
-
1 - 100 Employee
-
DBA
-
Feb 2018 - Oct 2018
-
-
-
SYSTEMTEC
-
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
-
-
-
CSC
-
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 -
Drexel University
Master of Science (M.S.), Project Management -
Columbia International University
Master of Arts (M.A.), Theology/Theological Studies -
Horry-Georgetown Technical College
Associate of Science, Associate of Science -
Mary Brewer School of Insurance
South Carolina Adjuster's License, Insurance -
Insurance Institute of America Inc.
Certificate in General Insurance, Insurance -
Insurance Institute of America Inc.
Associate in Insurance Services, Insurance -
Midlands Technical College
Full Stack Web Developer (continuing education), Web Development