Arghavan Emami

Senior software engineer and system analyst with 12+ years of experience building enterprise financial and operational systems, with production depth in SQL Server, relational data modeling, backend business logic, reporting accuracy, production troubleshooting, and translating business needs into reliable software. Current independent work includes Python backend and data-platform development using FastAPI, SQLAlchemy, Snowflake, dbt, Airflow, AWS/S3, Terraform, PySpark, CI validation, data quality checks, product APIs, and analytics-ready financial and market modeling.

Independent Backend & Data Platform Engineer at Self-employed (2024-06 – Present)

• Built a product-style financial data platform for market intelligence, regime detection, signal validation, backtesting, and explainable analytics.
• Implemented configurable market data ingestion with a provider layer, normalized market price records, append-only raw landing, partitioned raw paths, metadata files, checksums, and traceable ingestion audit events.
• Built Snowflake raw-load flows using local NDJSON files, internal stages, PUT, COPY INTO, schema scripts, and verification queries for loaded market price data.
• Designed dbt source definitions, staging models, intermediate models, mart models, and fact models for normalized market prices, returns, technical features, market regimes, signal labels, historical signal outputs, and forward-return backtest results.
• Added dbt tests for key assumptions, accepted values, required fields, and unique model grain, plus documentation and lineage support for model responsibilities.
• Added Airflow DAG foundation for scheduled market ingestion while keeping orchestration thin and business logic inside reusable Python ingestion entry points.
• Implemented streaming/event-ingestion foundations with PriceEvent contracts, Kinesis producer abstraction, Kinesis-to-S3 consumer abstraction, S3 event writer, and Terraform foundations for storage, IAM, Kinesis, and Lambda modules.
• Implemented PySpark feature processing over staged Parquet market data, including daily returns, moving averages, volatility features, and lineage fields linking features back to raw ingestion runs.
• Built a read-only FastAPI product layer over Snowflake marts, including asset snapshot, regime, signal, and explanation endpoints grounded in modeled evidence.
• Added unit tests and GitHub Actions CI for ingestion, Snowflake loading, dbt contracts, streaming abstractions, Terraform module contracts, linting, and repeatable validation.

Independent Backend & Data Platform Engineer at Self-employed (2024-06 – Present)

FinSignal Data Platform Project

• Developed a backend API for accounting entities including customers, invoices, invoice line items, computed totals, and explicit invoice lifecycle states.
• Implemented clean layered architecture separating API routes, service-layer business logic, repository-based persistence, Pydantic schemas, and infrastructure concerns.
• Designed request-scoped transaction handling, API-key protected write operations, centralized exception handling, request IDs, logging, Docker support, and repeatable API-level tests.
• Modeled financial entities with explicit relational structures and validation logic to support reliable accounting workflows.

System Analyst & Senior Software Engineer at NOSA Co. (2014-01 – 2024-12)

• Built and maintained enterprise financial and operational systems covering accounting, sales, inventory, payroll, and long-lived business workflows.
• Designed and implemented flexible analytical sales reports that helped users analyze sales data by product, sales type, sales center, delivery terms, payment terms, representative, time period, and region.
• Designed backend workflows, reusable business logic, validation rules, relational data structures, and SQL-based reporting logic with a strong focus on correctness, consistency, maintainability, and production reliability.
• Implemented cumulative balance calculations, aggregation logic, reporting workflows, and financial data transformations across normalized master-detail datasets.
• Improved application and database performance through execution plan analysis, SQL Server Profiler, indexing strategies, query redesign, and production debugging across application and data layers.
• Investigated and resolved production issues affecting data correctness, reporting discrepancies, query performance, and system reliability.
• Contributed to the design and deployment of Python support within the existing Delphi-based NOSA framework, enabling selected server-side reporting workflows to use Python libraries such as NumPy and scikit-learn for anomaly detection in financial and operational reports.
• Collaborated with other teams to translate requirements into reliable software, reporting behavior, validation logic, and structured data models.

Software Developer at NOSA Co. (2012-01 – 2014-12)

• Developed backend modules and database-backed workflows for accounting, sales, and inventory subsystems within a distributed enterprise architecture.
• Built reusable SQL objects and service components supporting transactional business processes.
• Implemented a reminders and notifications subsystem later integrated into the company's core framework as a reusable capability.

Master of Science in Information Technology - E-Commerce

Bachelor of Engineering in Computer Software Engineering