General Ledger Programmer
Paylocity
Total years of experience :2 years, 0 Months
○ Interfaced with customer payroll data using SQL and Reporting tools.
○ Tested calculations, reports, and system configurations while troubleshooting problems.
○ Validated the functionality of the end product according to requirement specifications.
○ Partnered with internal teams to refine customer requirements and identify alternative solutions.
○ Set client expectations for dates concerning different milestones in the process.
○ Explained rules, interfaces, reports, and calculations to customers to ensure that customizations met their needs.
○ Developed optimized T-SQL migration scripts, leveraging advanced functionalities such as pivot, cross-apply, loops, and recursive CTEs.
○ Conducted thorough data analysis, identifying entity relationships and attributes without requiring documentation.
○ Led successful data migrations, ensuring seamless system transitions.
○ Executed ad hoc data updates using SQL and API tools.
○ Translated clients' technical specifications into robust database solutions,
collaborating with project and sales teams throughout the project's lifecycle.
○ Crafted tailored ad-hoc reports and dashboards through IBM Cognos and SSRS Report Builder to unlock data potential and optimize processes
○ Created internal and client-facing user-friendly documentation accommodating various technical levels
○ Utilized Ruby to create custom data exports from a time/expense system to various payroll systems, ensuring accuracy.