Xai Lor Email and Phone Number
Elgin, SC, US
Xai Lor's Location
Elgin, South Carolina, United States, United States
Xai Lor's Contact Details
Xai Lor work email
- Valid
- Valid
- Valid
- Valid
Xai Lor personal email
n/a
Xai Lor phone numbers
About Xai Lor
Xai Lor is a Senior Business Intelligence Developer at Wellstar Health System. He possess expertise in business intelligence, sql server management studio, oracle sql developer, pl/sql, crystal reports and 11 more skills. He is proficient in English and Hmong.
Xai Lor's Current Company Details
Xai Lor Work Experience Details
-
Senior Business Intelligence DeveloperWellstar Health SystemElgin, Sc, Us
-
Business Intelligence DeveloperEviden Aug 2024 - Present -
Senior Business Intelligence DeveloperLifespan Jun 2022 - PresentProvidence, Rhode Island, United States -
Business Intelligence DeveloperLexington Medical Center May 2016 - PresentWest Columbia, Sc• Develop Crystal-Epic integrated reports whose SQL command objects pull directly from the Clarity database to meet end user BI reporting needs (i.e. clinical staff, practice/department managers, finance and accounting teams, etc.). These reports are configured to re-execute at different intervals (i.e. weekly, monthly), can span across multiple Epic applications (OpTime, ASAP, Beacon, Grand Central, Inpatient, Ambulatory, etc.), and are presented in both mid to high-level graphical outputs, as well as Excel data extracts.• Create ad-hoc analytical trending reports to help department VPs and our Chief Medical Officer make judicious operational decisions. For example, I combined surgery data and its associated financial data with their related readmission encounters data in order for management to see a holistic revenue impact and effectiveness of robotics surgery. Another example, I deciphered how the system flags each order as verbal, electronic, written, etc. in order to compile a network-wide view of each provider’s computerized physician order entry (CPOE) compliance rate.• Optimize numerous Epic-developed foundation reports to run at about a hundredth of the original processing time (on average) by converting in-Crystal formulas and table objects over to Command Objects, executable on the SQL server instead of the Crystal BOA server.• Obtained 2 certifications to date (Ambulatory and Professional Billing), 3 proficiencies with certification-level scores (Hospital Billing, Willow, and Anesthesia), and on track to obtaining 2 more proficiencies (OpTime and Beacon). Will continue to obtain more proficiencies as time permits.• Coach members of my current BI team in various capacities, by providing both technical coaching (i.e. SQL syntax expertise), as well as Clarity data model consultation. The team benefits from my electronic diagramming of Epic’s Clarity data models (a part of my test preparation process). -
Senior Business Intelligence DeveloperValleywise Health Oct 2020 - Jun 2022Phoenix, Arizona, United States -
Business Intelligence Analyst – Health Industries AdvisoryVboa (Pricewaterhouse Coopers Subsidiary) Jun 2015 - Oct 2016Columbia, Sc• Gather Business Intelligence (BI) reporting requirements to address the hospital network's Revenue & Expense (R&E) inquiries (i.e. R&E by provider/physician, location, department/specialty, inpatient/outpatient visit type, and technical/professional billing type); providing Business Intelligence support to PriceWaterhouse Coopers (PwC) Health Advisory consultants specializing in the charge capture / mid-revenue cycle of the patient experience/process (as opposed to the front-end Patient Access stage, or the back-end Accounts Receivable stage).• Compose SQL queries to compile all of the necessary data elements from the CLARITY database (EPIC's relational database solution) into one comprehensive extract, which can be re-executed monthly. For example, this extract pulls provider data from the CLARITY_SER table, technical billing data from the HSP_TRANSACTIONS table, department data from the CLARITY_DEP table, procedure data from the CLARITY_EAP table, etc.• Constructed an excel-based macro tool via Visual Basics for Applications (VBA) coding to dynamically automate the transformation of the SQL data extract into actionable business intelligence (i.e. month over month revenue graphs whose totals can be viewed by OP/IP, HB/PB, department, provider, etc.) in a distributable Excel format; saving hundreds of manual report-structuring hours per month.• Compiled data elements from EPIC - CLARITY via SQL for weekly Outpatient Procedure revenue & quantity reports based on service/contact date, following the flow of Universal Charge Line (UCL) records as procedures are captured, through to the charges actually being dropped (ready for billing). Other weekly volume reports include data elements that focus on Operating Room Procedure records and their associated charges; as well as Consult Notes and their associated Evaluation & Management Charges (missing charges represent missed $ opportunity).
-
Business AnalystAgfirst Farm Credit Bank Oct 2013 - Jun 2015Columbia, Sc• Led the consultation effort to gather business requirements (credit analysis criteria for loan approvals) from 19 different customers (East-coast Farm Associations of the Farm Credit System), to configure and code into SunGard Ambit Optimist (a 3rd party credit analysis software application). Logged requirements in Functional Specification documents via the Top Team tool and MS Visio; matched requirements with existing software capabilities; configured/coded these requirements into the system after customer sign-off of the mock-up versions; and worked with the project and technical teams to develop new functionality to meet remaining crucial requirements.• Assembled Data Dictionary and Database Architecture documents of the SunGard Optimist Credit Analysis application via thorough analysis of the application GUI, API, and its database using SQL Server Management Studio.• Compose numerous single-customer report templates using Optimist's Python-based Admin report building capabilities, as well as several multi-customer report templates using Optimist's Interactive Reports section (embedded with Stimulsoft Reporting technology). For aggregated business intelligence insight, I used Tableau to display interactive visualizations, enabling the management team to track key performance metrics of the portfolio's credit quality, as well as system user metrics.• Developed test plans over several plan types (sanity test, smoke test, regression test, user acceptance testing) to execute in multiple environments (Development, UAT, Production, etc.). Examples of system components that required test plans were: the chart of accounts (balance sheet and income statement), analytical graphs, single-customer reports, the debt schedule (amortization capabilities), customer and loan risk rating calculations, etc.
Xai Lor Skills
Business Intelligence
Sql Server Management Studio
Oracle Sql Developer
Pl/sql
Crystal Reports
Sql Server Reporting Services
Tableau
Visual Basic For Applications
Ms Excel Pivot Tables
Microsoft Access
Microsoft Visio
Transact Sql
Qlik Sense
Jira
Sungard Ambit Optimist
Sungard Avantgard Getpaid
Xai Lor Education Details
-
International Business
Frequently Asked Questions about Xai Lor
What company does Xai Lor work for?
Xai Lor works for Wellstar Health System
What is Xai Lor's role at the current company?
Xai Lor's current role is Senior Business Intelligence Developer.
What is Xai Lor's email address?
Xai Lor's email address is xl****@****rst.com
What is Xai Lor's direct phone number?
Xai Lor's direct phone number is +198032*****
What schools did Xai Lor attend?
Xai Lor attended University Of South Carolina-Columbia.
What skills is Xai Lor known for?
Xai Lor has skills like Business Intelligence, Sql Server Management Studio, Oracle Sql Developer, Pl/sql, Crystal Reports, Sql Server Reporting Services, Tableau, Visual Basic For Applications, Ms Excel Pivot Tables, Microsoft Access, Microsoft Visio, Transact Sql.
Not the Xai Lor you were looking for?
-
3centura.org, gmail.com, gmail.com
-
3hotmail.com, iyatkd.com, iyatkd.com
2 +191685XXXXX
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial