Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

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, NJ
05-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