Experienced Implementation Consultant at Tyler Technologies, Inc., skilled in MS SQL Server, and workflow automation. Proven track record in enhancing client relationships through assessing business requirements, data mapping and UAT testing. Adept at delivering results under tight deadlines while ensuring seamless software transitions and user training. Committed to driving operational efficiency and client satisfaction.
Assist with business process reviews and gap analyses
Assist client in configuring and setting up EP&L software (Application workflows, Custom Fields, Fees, Fee Templates, GIS, and Automations)
Ensure Tyler Product integrations are configured and tested
Perform QA of client process questionnaires to what has been configured in their EP&L application
Complete client user acceptance training corrections
Ensure that the transition to EP&L software is completed according to predetermined timelines and establish a positive baseline for the new relationship between the client site and Tyler Technologies
Identify the proper data mapping process for the product conversion
Use MS SQL Server to back-up and refresh application databases
Use MS SQL Server to write queries for application automations
Provide go-live assistance to client on-site or virtually
Communicating with clients with updates through SharePoint and conference calls
Participate in area User Group sessions (Leading EP&L module training for current software users)
Business Analyst – ASCC
Kaiser Permanente – K-Force Contractor
Duluth
05.2018 - 09.2019
Translated department appointment scheduling guideline matrix to SharePoint list
Created Visio charts based on department mappings by available visit types, services, and facilities
Assisted with the development of the ASCC scheduling application (created in office 365 PowerApps) called COMPASS
Created entity-relationship diagram (ERD) based on the SharePoint list used as data sources for COMPASS application
Created UAT documentation for trainers and supervisors to test COMPASS application
Created MS Flows to upload excel guidelines to SharePoint lists
Created COMPASS user's manual
Assist with creating Excel reports (pivot tables & charts) on COMPASS usage
Used macros, VBA script, and v-lookups to clean-up data in Excel before creating reports
Maintained back-end SharePoint list that are the data source for the COMPASS application
Business Analyst – Membership Administration
Kaiser Permanente
Duluth
10.2017 - 03.2018
Used MS SQL Server in conjunction with Access and Excel for on-going management of member PCP and facility relationship
Maintained or update existing queries (in MS SQL Server & MS Access) used for managing member PCP relationship
Provided system updates for all Primary Care Physician auto assignment for members who do not select a PCP upon enrollment
Provided system update for all Primary Care Physician reassignment
Provided member level data to Print Vendor in specified format for member notification of PCP and facility movement
Maintained relationship with Print Vendor for mailing of member notification of PCP and facility movement
Provided Manager with Daily Excel reports (from previous days data from Epic and Salesforce applications)
Used macros and VBA script to clean-up data in Excel before creating reports
Provided analytical reporting by creating Excel reports (pivot tables) to support TSPMG and Health Plan business owners as needed to manage PCP and facilities
Created MS SSIS package to update Provider table with monthly PCP Assignment csv file from HR
Administrative Support
One 2 One Educational Support Inc
Peachtree Corners
11.2016 - 10.2017
Automated Child and Adult Care Food Program (CACFP) and Summer Food Service Program Forms (SFSP)
Automated Excel spreadsheets using macros and VBA script for monthly claim process for Bright From The Start food programs
Processed monthly claims for the Bright From The Start food program
Technical support for CACFP users on Minute Menu application
Created monthly summary reports of meals served
Trained SFSP Sites on new forms.
Production Support Engineer
SPH Analytics
Duluth
01.2016 - 11.2016
Develop CATI programming for telephone surveys for national healthcare providers using Noble Systems Application
Use ETL via MS SQL Server to modify & import client data
Performed data sampling with imported data using SQL queries and stored procedures
Create call list using imported data using Noble Systems Application
Create email blast with imported data using Sendblaster Pro Application