Jared Nicholas

423-***-**** adlf90@r.postjobfree.com 505 Brookhaven Circle, Fort Oglethorpe, GA 30742 Education

Bachelor of Science in Business Management, April 2019 University of Tennessee at Chattanooga (UTC)

Chattanooga, TN

Special Skills:

Quadient Designer Certified 14.0 (Master Templates and Data Masters) Quadient Interactive (building letters for Facets/CA/ACTS) Inspire automation (Householding for provider letters) SoapUI (Triggering batch letters)

Expert level Facets/CareAdvance/ACTS experience

SQL Queries (build DBAF requests, update/maintain forms database tables) Dreamweaver

Advanced Microsoft Office, especially Excel: Formulas, Macros, Statistical Tools, Pivot Tables, Graphs, Charts, VLookup

SPSS (IBM Analytics Tool) Experience

Tableau

Ability to handle multiple projects at once

Ability to read code for errors

Good Communication, Visual Presentation, and Customer Service Skills Work Experience

Blue Cross Blue Shield of Tennessee (April 2019- Present) Chattanooga, TN

Communication Application Analyst I

Lead for developing a new Care advance Omni-channel functionality (Email, print, text messages)

Lead for creating Omni-channel letter configurations for Facets

I/S support box leader when asked questions from users internally

Given high level access for running automation jobs for provider documents

Debug and create SQL for populating letters in Facets/CA in production

In control of developing letters for lines of business that have generated millions of dollars in revenue for the company

Creating variables in the master templates to make my letters highly interactive

Pulling data internally to automatically update my variables in the letters

Frequently interact with directors and high-level supervisors to create a common product for our members/providers

Run weekly SQL reports for directors in all lines of business to show how many letters have been triggered daily

Use to deploying multiple projects on a bi-weekly basis in production migrations after hours

Trained new employees how to build letters

Business Analyst Intern

Collect and analyze data from SQL queries and MS Access and Excel to create reports for the Senior Care Division

Weekly Reports Due: First Call Resolution, FACETS usage, Agent Utilization, Early Adopters, and First Pass Resolution

Proofread online help documents

Use Adobe Dreamweaver to fix broken links in the online help documents

Create anchors in Dreamweaver for new links

Managed creation of cobranding for documents in Senior Care Division

Push documents live on Teamsite when they are ready

Job Shadow customer service representative and claims processors Walmart Supercenter (Ooltewah, TN)

Meat Department Associate

January 2015-April 2019

Manage meat inventory, including ordering items using FIFO method

Greet customers and help them find items or customize orders

Longevity of employment—worked there over three years as I work on my college degree Lexus of Chattanooga (Chattanooga, TN)

Customer Service Representative

April-December 2014

Greet customers entering the store to ascertain their individual needs

Provide elevated level of customer service to generate a loyal clientele

Effectively communicate with and support sales, marketing, and administrative teams

Schedule weekly inventory pickups and deliveries with vendors Volunteer/ Unpaid Experience

Created imaginary business (Hurricane Joe’s), managing all aspects of the store, such as hiring employees, weekly net income, gross margins, inventory statements, revenue efficiency, customer satisfaction, wait-time satisfaction, and capacity utilization in class project through BizCafe

Created shoe company in class; my company was in the top 10 in the US for students using this program

Teach kids’ classes at church

Participated in Romanian mission trip, 2013

Take care of grandparents’ yards weekly

References

Available upon request

Contact this candidate