Lokraj Magar
Lokraj Magar

Automating Intelligence.
Visualizing Value.

Data Analyst & Automation Specialist bridging the gap between
Deep Technical Engineering and Executive Strategy.

Dual Expertise

Where Deep Hard-Tech capability meets Corporate-Level Strategic foresight.

BSc. CSIT

Tribhuvan University
  • JavaScript / React

    Building scalable frontend logic

  • SQL & Databases

    Data modeling and complex querying

MBA

Pokhara University
  • Data Strategy

    Translating data into business insights

  • ROI & Efficiency

    Optimizing operations with automation

TECHNICAL ARSENAL

Tech Stack

Excel

Advanced

Complex formulas, VBA, Pivot Tables

Power BI

Proficient

DAX, Data Modeling, Dashboards

n8n

Expert

Self-hosted, Complex Workflows

SQL

Advanced

Queries, Optimization, ETL

JavaScript

Proficient

Node.js, Automation Scripts

AWS Textract

Proficient

OCR, Document Intelligence

Workflow Automation

Saving time and eliminating errors using self-hosted n8n and AWS Textract.

Input Docs
n8n Workflow
AWS Textract

High-Scale Automation

Engineered complex, event-driven architectures capable of parsing unstructured data exactly when needed. By connecting n8n directly to AWS Textract, manual data entry on thousands of documents is entirely bypassed.

  • Eliminates manual input errors
  • Self-hosted n8n for robust security
  • Processing 10k+ rows automatically
CASE STUDIES

Automation in Action

Real-world workflows demonstrating end-to-end data automation.

Document Processing

Automated Invoice Data Extraction

End-to-end pipeline: Source documents flow through n8n orchestration to AWS Textract for OCR, then structured data is stored in the database — eliminating manual data entry.

DATA FLOW
Source Data
n8n
AWS Textract
Database
Sustainability

Carbon & Fuel Emissions Analytics

Built comprehensive sustainability dashboards tracking fuel consumption and carbon emissions across operations, enabling data-driven environmental reporting.

DATA FLOW
Fuel Data
ETL Pipeline
Power BI
ESG Reports
Inventory Automation

Hierarchical Inventory Categorization

Automated the classification and hierarchical categorization of 10,000+ rows of inventory data, replacing days of manual work with intelligent automation workflows.

DATA FLOW
Raw Inventory
n8n Logic
Categorize
Structured DB

Sustainability & Data Analytics

Transforming raw metrics into actionable strategies.

0k+

Rows Categorized Automatically

0%

Efficiency in Fuel Tracking

0 yrs

Analytics Operations Experience

Core Tools

Microsoft Excel (Advanced)Power BISQL DatabasesData Modeling

Experience & Education

The journey from Hard Tech fundamentals to advanced Business Strategy.

Oct/2023 - Present

Data Analyst & Automation Specialist

Various Projects

Spearheaded workflow automation using n8n and AWS Textract. Handled large-scale inventory categorization (10k+ rows) and established comprehensive sustainability analytics (Fuel/Carbon tracking).

Present

Master of Business Administration

Pokhara University

Final trimester candidate focusing on Corporate Strategy, ROI optimization, and Operations Management.

Graduated

BSc. Computer Science & IT

Tribhuvan University

Strong foundation in hard tech, JavaScript, software engineering principles, and complex database management.