Liudmila V — System Analyst Portfolio

Senior System Analyst / Business Analyst (20+ years in IT)
Requirements · User Stories & Acceptance Criteria · BPMN/UML · SQL/Data Analysis · Remote

Senior System Analyst / Business Analyst with 20 years of IT experience.
Expert in requirements formalization, BPMN/UML process modeling, and data/SQL investigations.
Remote IT services for foreign clients | Individual Entrepreneur (IE) in Georgia since March 2024.

Core Expertise

• Requirements elicitation & documentation (BRD/SRS, use cases, specifications)
• User stories & acceptance criteria (1000+ delivered)
• BPMN/UML modeling (as-is / to-be)
• Data analysis & SQL investigations, reconciliations, calculations
• Relational database logic validation (ERD review, data integrity)
• Sprint support, demos, final BA acceptance, UAT

How I Can Help

• Clarify vague requirements and turn them into structured user stories & acceptance criteria
• Model complex business processes (as-is / to-be) using BPMN/UML
• Investigate data issues, calculations, and inconsistencies using SQL
• Support product teams during implementation, UAT, and release

Project Types

Digital Transformation • Product Management • Software Implementation •
Business Process Redesign • Process Improvement • Data & Business Analytics

Industries

Technology • Energy & Utilities • Public Sector • Professional Services

Selected Case Highlights

1) Investment Platform Modernization (Oil & Gas)

Role: System Analyst / Product Owner
Work: requirements → user stories & AC → BPMN workflows → SQL validation → UAT support.
Result: improved reliability of calculations and data; fewer manual corrections.

2) Public Sector Registries Modernization

Role: Senior BA
Work: as-is/to-be modeling, BPMN, specifications, data integrity checks.
Result: transparent automatable workflows and reduced processing errors.

3) Data Quality & Calculation Investigations (SQL)

Role: System Analyst
Work: SQL checks, reconciliation logic, root-cause analysis, fix recommendations.
Result: stable reporting/calculations; reduced support requests by ~30%.

---

Example Diagrams

Well Status Lifecycle (Oil & Gas)

System-level lifecycle mapping of well statuses, including transitions between permitted, drilling, producing, inactive, and abandoned states.

My Role / What I Did

• Defined system-level well status model and transitions.
• Mapped external OTC statuses to internal system statuses.
• Validated lifecycle logic with business stakeholders and data teams.

---

Report Generation Workflow

BPMN-style workflow describing group report generation, validation, approval, and publication logic.

My Role / What I Did

• Analyzed and modeled the report generation and approval process.
• Defined system behavior for edge cases (no data, regeneration, cancellation scenarios).
• Aligned workflow with business rules and user actions.

---

Database Design Example

Relational database design example with entities, relationships, and key constraints.

My Role / What I Did

• Designed relational data model with clear entity relationships.
• Defined primary/foreign keys and data integrity constraints.
• Validated data structure against reporting and business requirements.

Tools

SQL Server / SSMS • DBeaver • IBExpert • Jira • Confluence •
BPMN/UML (Visio / Draw.io / Lucid) • Miro • Figma • Excel/Sheets • GPT tools

Contacts

• LinkedIn: www.linkedin.com/in/liudmyla-vynnychuk
• Upwork: https://www.upwork.com/freelancers/~0147df057e3236d70b
• Email: vinnil76@gmail.com
• Location: Tbilisi, Georgia
• Open to remote contract work and consulting engagements.