Wojciech Trzeciak
Chicago,IL
Summary
Collaborative and technical financial accounting data consultant with a Mathematics / Statistics background and strong experience in SQL, data automation, and process optimization. Skilled in resolving complex data issues, supporting high-impact systems, and improving data reliability for business and technical teams. Looking to move into a role where I can apply my SQL expertise, focus on performance and stability, and contribute to the design, maintenance, and optimization of large-scale database environments.
Overview
8
8
years of professional experience
Work History
Consultant
Northern Trust
01.2022 - Current
- Consult, troubleshoot, optimize, and implement Snowflake solutions by working with the data engineering team and business partners.
- Develop ETL workflows in Alteryx improve accuracy, automate accounting processes, deliver data products, and design/prototype solutions.
- $2 million in savings annually by contributing to a project that migrated a legacy data quality tool to Snowflake, enhancing efficiency and cost-effectiveness.
- Single-handedly built a transactional lotted accounting data product, enabling the tactical implementation of lotted account rules.
- Enhanced management's oversight of account timeliness by building data products and Alteryx workflows that collect account timeliness metrics and user feedback from SharePoint.
- 90% reduction in fund accounting reconciliation time through automation in Alteryx.
- Migrated client-specific accounting checks from VBA to Alteryx, increasing speed and accuracy for a portfolio exceeding $100B in market value.
- Worked closely with business teams to gather requirements to develop data quality rules and Alteryx workflows that align with their expectations.
Sr. Analyst
Northern Trust
06.2019 - 01.2022
- Audited daily financial reporting statements for a high-profile wealth client with over $100 billion in market value, preparing a daily report on accounting updates and pending resolutions.
- Manage the team and consulted with the client in the Team Lead’s absence.
- Coordinated with other teams to ensure accurate and timely accounting entries.
- Improved audit efficiency by consolidating multiple downloadable reports into one, and used VBA to write reconciliation checks.
- 90% reduction in time for 5500s reporting audit by leading a small team to create a reconciliation macro in VBA.
- Utilized SQL and internal software queries to reconcile account setup details during client onboarding processes at scale.
- Collaborated with the Data Quality team to develop data quality rules.
Analyst
Northern Trust
04.2018 - 06.2019
- Performed monthly audit of portfolio statements and 5500s reporting for Large Corporate and Insurance clients.
- Review, research, and resolve accounting discrepancies and erroneous postings.
- 50% time reduction in audit by creating a macro to reconcile accounting and fund allocation statements.
Education
B.S. Mathematics
Pennsylvania State University
12-2015
Skills
- Alteryx
- SQL
- Snowflake
- VBA
- Python (Exposure)
- R (Exposure)
Timeline
Consultant
Northern Trust
01.2022 - Current
Sr. Analyst
Northern Trust
06.2019 - 01.2022
Analyst
Northern Trust
04.2018 - 06.2019
B.S. Mathematics
Pennsylvania State University