iT Tigran Petrosyan

Tigran
Petrosyan

POWER BI · AUTOMATION · AI · CFA Level I candidate

Building Power BI systems, automation pipelines, and AI-augmented workflows for finance and operations teams. Twenty years of domain expertise behind every dashboard — because the hardest part of BI is knowing what the numbers actually mean.

See services Discuss your project
Tigran Petrosyan
60–70%
manual work automated
2.5×
volume growth via analytics-driven routing
$500M
reporting scope, prior group
20+
years of finance domain depth
01

About

I build BI systems, automation pipelines, and AI-augmented workflows for finance and operations teams — with twenty years of domain experience behind every dashboard.

I combine Power BI, Power Query, Python, and modern AI tools (Claude, ChatGPT, Copilot) with the perspective of someone who has actually closed the books, run treasury operations, and reported to boards. That means the models I build ask the right questions — and the automation actually replaces work people do.

Based in Yerevan, Armenia. Working remotely with founders, operations leads, and finance teams across Europe on Power BI implementations, data automation projects, and AI workflow design.

Top skills

  • Power BI / DAX
  • Power Query / M
  • Data Modeling
  • Python for Finance
  • AI / LLM Integration
  • Business Intelligence
  • ETL & Automation
  • Financial Modeling
  • Reconciliation Automation
  • IFRS
  • Treasury & Liquidity
  • Multi-currency Accounting

Languages

  • EnglishProfessional working
  • RussianNative / bilingual
  • ArmenianNative / bilingual
  • SpanishLimited working

Certifications

  • Microsoft Certified: Power BI Data Analyst (PL-300)
  • Data Modeling in Power BI
  • Extract, Transform and Load Data in Power BI
  • Microsoft Certified: Excel Expert (MO-211)
  • Anthropic Claude 101
  • CFA Level I — candidate
02

Services

Six focused offerings - Power BI implementations, data automation, AI workflow design, and Excel-to-BI migrations for finance and operations teams.

Power BI Systems

End-to-end Power BI implementation - from data model to board-grade dashboards that survive scaling.

  • *Data model & DAX architecture
  • *Board & operational dashboards
  • *Row-level security & governance
  • *Multi-source integration (SQL, CSV, API)

Data Automation

Replacing manual Excel work with automated pipelines — Power Query, Python, and scheduled refreshes.

  • *Power Query / M automation
  • *Python scripts & scheduled jobs
  • *60–70% reduction in manual work
  • *Reliable daily & weekly data delivery

AI-Augmented Workflows

Using modern LLMs (Claude, ChatGPT, Copilot) to accelerate analytics, automate reporting narratives, and extract structure from documents.

  • *AI-generated variance commentary & report narratives
  • *Document & invoice extraction pipelines
  • *LLM-assisted DAX / Power Query authoring
  • *RAG systems for internal knowledge Q&A

Excel → Power BI Migration

Rebuilding legacy Excel monsters as maintainable, refreshable Power BI models — same numbers, no manual work.

  • *Audit of existing Excel reports & logic
  • *Data source integration & single source of truth
  • *DAX-based reimplementation of calculations
  • *Handover with documentation & training

Reconciliation Engines

Automated matching systems for transaction data — internal vs provider, GL vs subledger, cross-currency.

  • *Fuzzy matching & duplicate detection
  • *Cross-provider balance validation
  • *Daily transaction-level reconciliation
  • *Audit-ready documentation

Financial Modeling

Decision-ready models — unit economics, pricing, cash flow, scenarios — built with the BI & AI toolchain, not just Excel.

  • *Unit economics & profitability calculators
  • *Pricing & costing frameworks
  • *Cash-flow forecasting & scenario analysis
  • *Investment case & deal support

Not sure which fits?

Most engagements start with a 30-minute call to scope the problem and outline the shortest path to the outcome.

Book a call
03

Experience

  1. Jan 2023 – Present Remote · Yerevan, Armenia 3 yr 7 mo

    Power BI · Automation · AI Consultant

    iTigran.com — Independent Practice

    Building Power BI systems, automation pipelines, and AI-augmented workflows. Deep understanding of finance and operations informs every model — so dashboards ask the right questions and automation actually replaces work.

    • Leading Power BI implementations — data model, DAX, and analytics pipelines that enable real-time decisions.
    • Power Query automation of routine work: 60–70% reduction in manual Excel across engagements.
    • AI-augmented workflows: Claude / GPT / Copilot for accelerating DAX & M authoring, generating variance narratives, and extracting structure from documents.
    • Reconciliation engines with fuzzy matching, cross-provider balance validation, and audit-ready output.
    • Financial modeling — unit economics, pricing frameworks, cash-flow forecasting, profitability calculators.
    • Excel-to-Power BI migrations — rebuilding legacy manual reporting as maintainable, refreshable models with the same numbers.
    60–70%
    Manual Excel work eliminated via end-to-end finance automation.
    2.5×
    Processing volume growth in 9 months — treasury flows, settlement timing, routing logic redesign.
    15–20%
    Blended cost reduction via fee benchmarking, rate negotiation and smart routing recommendations.
    5 tabs
    Power BI analytics framework for a transaction-heavy business — Overview, Portfolio, Flow, Deep Dive, Unit Economics.
  2. Oct 2013 – Oct 2022 Moscow 9 yr 1 mo

    Head of Finance

    Central Distribution Company

    Led the full finance function of a high-volume distribution group (3,000 employees, $500M revenue). Multi-entity budgeting, treasury and cash-flow management, financial control, and reporting across jurisdictions.

    • Scalable accounting, KPI systems, management dashboards, automated reporting across dozens of business units.
    • Internal audit, M&A support, investor reporting; multi-jurisdictional structures.
    • Zero-based budgeting implementation across two companies.
    • Private banking across Switzerland, UAE, Singapore, Hong Kong.
    $24M
    Safeguarded by prompt account openings during banking restrictions.
    −24%
    Tax burden reduction via new entity in a different jurisdiction (as-is / to-be analysis).
    $10M
    Investment loss averted — identified a critical error in an approved financial model.
    −29%
    Acquisition-cost reduction negotiated in an M&A transaction.
    +16%
    Project profitability uplift through strategic resolution of a corporate dispute.
    4 hubs
    Private banking accounts established across Switzerland, UAE, Singapore, Hong Kong.
  3. Nov 2007 – Apr 2011 Moscow 3 yr 6 mo

    Head of Financial Department · CFO

    KOLMAR Coal Mining Holding

    Built the finance department from the ground up; operational finance across production, logistics, and international sales.

    • Data-driven budgeting and performance models, working-capital optimization, external financing negotiation.
    • Automated controls and reporting; supervised due diligence across the group.
  4. Jan 2005 – May 2006 Moscow 1 yr 5 mo

    Financial Controller

    Fabris Investment Company
    • Management accounting system; budgeting from scratch (CFB, IEB, forecast balance sheet for the group).
    • Consolidated reporting for Russian and foreign companies across projects.
    • Project economic-efficiency evaluation; tax-optimized financial schemes.
  5. Sep 2002 – Dec 2004 Moscow 2 yr 4 mo

    Senior Financial Controller

    Mango Telecom
    • Management accounting methodology; integration with billing-system data.
    • Management-accounting automation on 1C; CFB, IEB and forecast balances.
    • Cash-flow management; profitability assessment of completed investment projects.

Education

  • Moscow State University Postgraduate · Accounting and Business / Management · 2002–2004
  • Moscow State University Master's · Accounting and Business / Management · 2000–2002
  • Moscow State University Bachelor's · Economics · 1997–2000
  • Yerevan State University Bachelor's (unfinished) · Economics · 1995–1997
04

Let's talk.

Power BI implementations, data automation projects, AI workflow design, and Excel-to-BI migrations. Reach out with a short note about what you're working on — I usually reply within one business day.

Email [email protected] LinkedIn Tigran Petrosyan