EDUCATION

Virginia College

Network Engineering

Associate of Applied Science

Homewood, AL 35209 June 2009 – March 2011

Shelton State Community College

General Education

Associate of Arts

Tuscaloosa, AL 34505 August 2005- Graduated August 2008

MICROSOFT TRAINING: January 2012

Course 4327: Querying and Filtering Data in Microsoft SQL Server 2008

Course 4326: An Introduction to Transact-SQL in Microsoft SQL Server 2008

Course 4329: Joining Data from Multiple Tables in Microsoft SQL Server 2008

WORK EXPERIENCE

RxBenefits October 2020 – January 2021

Data Integration Analyst (contract)

Handles the exchange of eligibility data between clients, PBM’s, and other 3rd parties

Researches data and member related issues

Receives calls from both internal and external customers regarding data file issues

Assists with operational aspects of implementing changes to existing clients

Handles terminations of data with the vendors and PBM

Use Excel to form pivot tables to research data

Chelsea Family Fitness

Family-Friendly Gym Offering Personal And Group Training With Classes and Childcare

Owner November 2015 – June 2020

Designed and managed the company’s website

Rolled out our POS system MINDBODY

Create autopay schedules for clients

Manage training clients, classes, and childcare schedule

Installed liability forms and contracts for clients to sign off on

●Created targeted Facebook and Instragram ads utilizing Facebook Business

●Integrated Click Funnels application as a landing page for my Facebook Business ads

●Integrated Acuity Scheduler application through the Click Funnels landing page for prospects to book appointments

●Integration HeyMarket application for anyone to send text messages to the business’s LAN line phone number

●Rolled out Polar Club application allowing anyone in the fitness center to use a Polar product and have their heart rate displayed in multiple areas of the fitness center

●Used multiple applications while Onboarding new training clients to the fitness center

Established Voxer app for accountability communications

Created a process to grow the followers on YouTube, Facebook,public and private, page for social media reach

Created electronic calendar of training sessions for 12 weeks in MINDBODY app

●Responsible for email campaigns to existing and/or prospect clients

Specials for training packages, bring a friend, referral-based programs

Newletters and upcoming events

PlaymakerCRM

Internet Based Software Solution for Healthcare Client Relationship Management

Senior ETL Specialist October 2013 – January 2018

●Implemented custom integrations for new contracts between PlaymakerCRM and client EMRs:

oHave worked on 100+ clients including the nation's top 5 agencies

oMigrated all existing clients from MySQL Database to PostgresSQL Database

oFamiliar with MS SQL and Sysbase Interactive SQL

●Created new integrations for EMRs: Point Click Care, HealthWyse, Homecare Homebase (SQL based), Bright Tree, Consolo, eClinical Works and ContinuLink

●Edited existing EMR integrations to streamline processing time and maximize client satisfaction for custom requests: Cerner, McKesson, Allscripts, Kinnser, Homecare Homebase and many others

●Created working implementation documents for clients for Data Validation and Quality Control

●Work with the development team on pushing out major custom releases to the largest clients: Gentiva, LHC, and Curo

●Acted as the team leader and the technical project manager for several clients

●Utilized multiple internal development boards, such as Zen Desk, JIRA, Go-Live, Trello, and WorkZone, to keep track of development statuses and implementation projects

●Acted as Subject Matter Expert to provide feedback and suggestions for implementation clients, migration clients and active clients in Support

●Loaded clients' data using a Java-based platform, Mirth Connect

●Utilized SQL and Javascript within Mirth Connect to pull over the data using custom client rules

●Used XMLwithin the BPE to write rules on how Mirth Connect is going to stage the data

●Conducted EMR connectivity calls for implementation clients

●Participated in all new implementation client calls as technical resource to the Project Manager

HomecareCRM

Internet Based Software Solution for Healthcare Client Relationship Management

Quality Assurance Duties May 2011 – September 2013

●Read through C# code on failed QA items in development bundles

●Established a new Quality Assurance Department and created the QA process

oHarvest Data QA

oClient Implementation Configuration QA

oProduct Development QA

●Participated in daily SCRUM meetings for scheduled development sprints

oProvide feedback on testing scripts, outcomes and potential resolutions

●QA various product aspects from the end user UI, SQL database calls to C# programming code language

●Received accolades for developing and preforming QA program at HCRM.

●General understanding of HL7 from testing Point Click Care’s EMR write-back feature

Data Integration Specialist - Electronic Medical Record CRM Duties

●Accessed application server via RDP to establish database connection for initial integration pull of PHI data from EMR into the CRM

●Validated data from initial pull to patient examples.

●Configured integration engine to run on a scheduled task based on design documentation in concert with multiple other utilities.

●Designed customized integration from various EMR companies such as: Cerner, McKesson, Allscripts, CPR+, Point Click Care, Carevoyant, Homecare Homebase and others.

●Loaded secondary flat file integration of data called Harvest based on Medicare and third party insurance claims data

●Conducted data integration design and mapping calls with clients on expectations of data layout specifications

●Provided a Data Quality Report demonstrating acceptable values and exception report

●Conducted Data Walk Through calls in conjunction with the Project Managers on implementations

●Imported Harvest Market Intelligence Data via SQL utility and SQL Server Management Studio 2008 R2

●Built report queries via query builder and SQL statements to produce custom data queries

●Customized SQL Integration Mapping from EMR to CRM database

●Created SQL lookup tables to create custom user mapping assignment logic for Account Ownership and Referral Credit Ownership

●Queried customer EMR via SQL script to create exception reports for data integrity for clean integration

●Wrote primary SQL, detail SQL and SQL post processes for multiple EMR integrations

Contact this candidate