At Epic Systems, I analyze how billing configuration shapes accounting outcomes, including posting rules, adjustment mappings, and the transaction data finance teams reconcile against the general ledger.
I investigated reconciliation breaks by identifying affected transactions with missing payer information, correcting the data, and verifying the fix with finance stakeholders. I also reworked remittance code mappings so non-covered codes could be written off without creating unrecoverable denials.
I document system behavior as testable rules, including edge cases, and file enhancement specifications when the platform cannot comply. Before changes ship, I quantify their impact; one payer-setup correction affected about 6,000 transactions.
Previously, at Hangzhou Tianhe Coal Co., Ltd., I used SQL, Stata, R, and Excel to analyze market trends and support business planning. I built Tableau dashboards and forecasting analyses with 90% reported accuracy, enabling 20% faster business decisions.

