ALEXANDER HIRNIAK
Hoboken,NJ
Summary
Data Analyst with 4+ years of experience designing SQL Server databases, Power BI reporting solutions, ETL workflows, and automation tools for financial services and professional services environments. Sole data professional at Nisivoccia, owning projects from requirements gathering and data modeling through deployment, documentation, and support.
Overview
5
5
years of professional experience
Work History
Data Analyst
Nisivoccia LLP
Mount Arlington, NJ
05.2022 - 06.2026
- Developed and deployed Power BI dashboards analyzing revenue by client, representative, advisor, and historical period for leadership reporting.
- Built SQL and Power BI ETL processes from the firm's practice management software through an on-premises data gateway.
- Designed and built a Microsoft SQL Server database to centralize financial services commission data and support scalable revenue reporting.
- Created daily operational reports for Billings, Collections, AR Aging, Utilization, Staff Time, WIP, Realization, and Workflow status with dynamic filters to enhance decision-making by staff and leadership.
- Built an integrated SQL and Excel VBA automation process for commission distribution recalculations, reducing split revenue and split income processing time from 20+ hours to approximately 3 hours while creating repeatable procedures for the Finance department.
- Developed Python scripts using Regex to update audit language in Word documents and modify Excel workpapers based on variable engagement data.
- Served as the firm's advanced Excel resource and one of its internal AI experts, advising colleagues on automation, analytics, and productivity workflows.
- Led analytics, database, reporting, automation, documentation, deployment, and support initiatives independently, establishing foundational practices in absence of a dedicated data team.
Data Analytics Intern
Nisivoccia LLP
Mount Arlington, NJ
06.2021 - 05.2022
- Automated a public entity audit workflow using VBA macros and Python, reducing a manual, data-entry intensive process from 6–8 hours to under 2 hours from initial report to final schedule.
- Developed repeatable procedures and written documentation to standardize the automated audit process for department-wide use.
- Led a training session for the Public Entity department, explaining the new workflow and teaching staff how to perform the process independently.
- Provided ongoing support to audit department users, troubleshooting issues and helping colleagues adopt the automated process.
Education
Bachelor of Science - Biomedical Engineering
Rutgers University-New Brunswick
New Brunswick, NJ05-2020
Skills
- SQL (T-SQL and Microsoft SQL Server)
- ETL
- Power BI
- DAX tools
- AI LLMs
- Python
- VBA
- Excel
- Regex
- Data visualization
- Dashboard design
- Automation solutions
Languages
English
Native or Bilingual
Spanish
Professional Working
Ukrainian
Professional Working
Timeline
Data Analyst
Nisivoccia LLP
05.2022 - 06.2026
Data Analytics Intern
Nisivoccia LLP
06.2021 - 05.2022
Bachelor of Science - Biomedical Engineering
Rutgers University-New Brunswick