At Paylocity, I own SQL data models and business logic that turn processed payroll data into general ledger output for 100+ enterprise clients. I work directly with client finance teams to translate account mappings and business rules into documented data mappings and GL configurations.
I build about 10 custom client reports per week, combining T-SQL data logic, SSRS layouts, and XSL transformations. I also add validation and reconciliation checks to catch breaks between GL output and payroll source reports.
When a client's accounting team flags a number, I trace the variance through source data, transformation logic, and GL mappings, then fix the root cause. I maintain and optimize stored procedures that automate recurring financial processing and manual reconciliations, cutting manual processing time by 30%+.
In my GL Reconciliation Pipeline project, I built layered dbt models that reconcile synthetic GL detail to real control totals from Baker Hughes earnings releases. The project includes an exceptions model, data tests, and GitHub Actions CI, and runs on both DuckDB and Snowflake.
