✦Software & Data Engineer — Enterprise Systems✦
Yusriyah Isnaini Mufidah - Software & Data Engineer
Software & Data Engineer (Google Cloud Certified PDE) specializing in high-throughput database engineering, financial reconciliation systems, and applied AI automation. Proven track record optimizing PostgreSQL execution from 30s to <1s and engineering financial workflows governing over Rp 1.2 Triliun in enterprise logistics transactions.
Bridging Deep Technical Engineering with Strategic Business Impact
I specialize in transforming intricate, data-heavy operational processes into high-speed, scalable software systems and crystal-clear business intelligence.
As a Google Cloud Certified Professional Data Engineer and Software Engineer, I specialize in mission-critical intersections where high data volume meets stringent business rules: Enterprise Financial Systems, Logistics Platforms, and Automated Operational Pipelines.
My work focuses on eliminating operational friction and calculation drift. From architecting full-stack TypeScript applications and refactoring mission-critical PostgreSQL query plans from 30s down to <1s, to enforcing zero-threshold financial arithmetic governing Rp 1.2 Triliun in freight cash flow, I build software that stakeholders can trust completely.
Whether optimizing relational OLTP schemas, designing ClickHouse analytical data marts, or orchestrating applied AI agents with Gemini and n8n, my standard is clear: systems must be mathematically defensible, blazingly fast, and directly tied to operational ROI.
- Defensive Data IntegrityZero-tolerance for financial calculation anomalies, strict |n| < 1 thresholds, and complete audit logging.
- Sub-Second ScalabilityOptimizing B-tree indexes, eliminating unindexed OR joins, and decoupling OLAP analytical loads from OLTP clusters.
- Event-Driven & AI AutomationCombining deterministic state machines with Google Gemini AI multimodal extraction to eliminate repetitive clerical operational overhead.
Database & Performance Engineering
Specialized in high-throughput PostgreSQL stored procedures (PL/pgSQL RPCs), query plan optimization (from 30+s to <1s), CTEs, LATERAL joins, and ClickHouse OLAP denormalization.
Financial & Logistics Reconciliation
Automated Account Receivable engines, DJP Coretax compliance (DPP, PPN 11%/12%, PPh 2%), logistics claims liability burden-splitting, and multi-entity debt ledger state machines.
AI & Workflow Automation
Engineering 24/7 operational WhatsApp bots integrated with Google Gemini AI, n8n workflow webhooks, and PostgreSQL logging, saving 40+ hours of manual administrative overhead per month.
Product Analytics & UI/UX Design
Translating complex logistics workflows into intuitive Figma design systems, authoring TMS Product Requirement Documents (PRDs), and executing comprehensive UAT testing (150+ test cases).
Professional Work Experience
Explore my engineering impact across enterprise logistics, high-throughput financial architectures, data platforms, and product systems.
Business Intelligence Analyst
Spearheading enterprise logistics software modernization, PostgreSQL query execution plan tuning, PL/pgSQL RPC financial data services, and event-driven automation.
Quantifiable Impact & Production Milestones:
Engineered Architecture & Key Responsibilities:
- Architected and engineered FATrack, a high-performance enterprise financial clearing and reconciliation platform (Vanilla TypeScript 5.9, Vite 6, Supabase PostgreSQL, ClickHouse OLAP), modernizing an unmaintainable Google Apps Script monolith into a sub-second SPA.
- Engineered an N:M Smart Payment Multi-Allocation Clearing Engine, enabling cashier disbursements to be split across multiple driver/vendor dispute claims and debt installments with automated candidate discovery and soft-delete-safe partial unique indexes.
- Built Executive Net Financial Cockpits (Overview Driver & Overview Vendor) calculating real-time net exposure [(Total Claim + Debt) - Deductions] with state machines (Lunas, Kurang Potong, Lebih Potong) and sub-100ms on-demand drill-downs, cutting dispute cycles by 85%.
- Engineered a zero-dependency SCSS dual-axis sticky data grid (40+ columns, frozen IDs and action buttons) delivering 60 FPS table rendering with zero Virtual DOM overhead, paired with 13 live KPI filter cards.
- Optimized PostgreSQL execution plans across multi-million-row logistics datasets using composite indexing, CTE refactoring, and stored procedures (PL/pgSQL RPCs), reducing critical query latency from 30+ seconds to <1 second.
- Established end-to-end reliability & observability: created an in-memory TTL cache (cutting REST calls by >65%), authoring 36 Vitest/Playwright test suites (300+ tests, 100% pass rate), and integrating Sentry APM via a custom Vite reverse-proxy tunnel.
- Built event-driven operational automation using Node.js, PostgreSQL, n8n, and Google Gemini AI, reducing issue-classification lead time by 40% and eliminating 40+ hours of repetitive operational work per month.
Core Production Tech Stack:
Software Engineer (QA & Product Analytics)
Drove platform performance, business process optimization, and comprehensive software testing across global e-commerce and logistics services.
Quantifiable Impact & Production Milestones:
Engineered Architecture & Key Responsibilities:
- Analyzed e-commerce platform performance and user behavior across SAP FI (Finance), SD (Sales & Distribution), Purchasing, Warehouse Management, and web/mobile apps, identifying and resolving UI/system bottlenecks to increase daily paid product orders by +200 units.
- Led business process design and user flow architecture for the 'Titipay' e-wallet project integrated with the Xendit payment gateway, significantly reducing administrative costs, automating manual refund workflows, and mitigating transaction fraud risks.
- Managed comprehensive testing and quality assurance workflows, designing 153 UAT test cases, and identifying, tracking, and resolving 420 system defects in close collaboration with core engineering teams to ensure seamless production releases.
- Designed intuitive user flows, UI mockups, design systems, and interactive prototypes for Titipbeliin.com and Titipkirimin.com web and mobile platforms using Figma, accelerating frontend development handoffs.
Core Production Tech Stack:
Product & UI/UX Designer (Consultant)
Designing scalable design systems, responsive web applications, and enterprise dashboards with high fidelity in Figma.
Engineered Architecture & Key Responsibilities:
- Crafted intuitive wireframes, interactive prototypes, and design systems for web and mobile platforms.
- Conducted user research, usability evaluations, and accessibility testing (WCAG 2.1) to elevate conversion rates.
Core Production Tech Stack:
Machine Learning Cohort Graduate
Selected into Google-led tech talent accelerator (63,000+ applicants); engineered computer vision deep learning pipelines and GCP cloud microservices for pediatric stunting monitoring (Project Anya).
Quantifiable Impact & Production Milestones:
Engineered Architecture & Key Responsibilities:
- Architected dual-tier computer vision pipeline: built VGG16 binary food filter and fine-tuned InceptionV3 11-class nutritional classifier on TKPI datasets (98% accuracy at 50 epochs).
- Engineered optical infant height dimensioning module using OpenCV and ArUco fiducial markers on smartphone cameras, replacing $150+ mechanical infantometers.
- Built containerized backend microservices on GCP Compute Engine (e2-medium, 31% cost savings vs N1) using Express.js (TypeScript), Flask ML service, PostgreSQL, Docker, and NGINX.
- Led cross-functional capstone engineering alongside Android and Cloud cohorts, earning national distinction as Top 53 Capstone Project out of 463 teams.
Core Production Tech Stack:
UI/UX Design Scholar
Completed intensive UI/UX specialization with industry mentor reviews and human-centered design sprints.
Engineered Architecture & Key Responsibilities:
- Applied Design Thinking methodology to solve user drop-offs in financial and educational mobile apps.
- Constructed interactive Figma prototypes, component libraries, and conducted usability benchmark sessions.
Core Production Tech Stack:
Cloud & DevOps Scholar
Engineered scalable cloud infrastructure on Google Cloud Platform, Docker container deployments, and automated CI/CD pipelines.
Engineered Architecture & Key Responsibilities:
- Architected secure GCP VPC networks, Compute Engine virtual machines, Cloud SQL, and containerized backend services.
- Graduated with Honors distinction (94.76/100 final composite grade).
Core Production Tech Stack:
Enterprise Systems & Data Engineering
Deep-dive into production-grade enterprise platforms, sub-second query engines, event-driven automation, and analytical data warehouses.
FATrack Apps — Enterprise Financial Clearing, Tax & Multi-Allocation System
Architected and engineered FATrack, a high-throughput enterprise financial clearing, reconciliation, and logistics operations platform (Vanilla TypeScript 5.9, Vite 6, Supabase PostgreSQL 15+, ClickHouse OLAP) modernizing a fragile Google Apps Script monolith into a sub-second digital command center.
JHT ClickHouse Analytical Warehouse & Metabase OLAP
Architected denormalized OLAP analytical schemas and ClickHouse Materialized Views to decouple heavy analytical loads from production OLTP databases, powering executive dashboards across 4 divisions.
Automated Bulky Data Importer & Validation Engine
Engineered an automated bulk-upload data pipeline and pre-validation SQL engine handling >1,000 logistical rows per week for transporter quotation tiering and additional cost operations.
Hybrid AI Operational WhatsApp Bot & n8n Automation
Built an event-driven operational WhatsApp bot integrated with n8n workflow webhooks, PostgreSQL, and Google Gemini AI to automate field operational requests, ticket classification, and data lookups.
Titipay E-Wallet & E-Commerce Platform Optimization
Led business process design, UI/UX architecture, and quality assurance for the cross-border e-commerce platform Titipbeliin and its integrated digital wallet 'Titipay'.
UmMeals — Social Impact Nutrition Analytics
Spearheaded data modeling, DAX measure creation, and interactive reporting on Microsoft Azure and Power BI for the 'UmMeals' healthcare initiative, winning Top 6 nationally in the Microsoft Innovation Challenge.
Skills & Production Technologies
Structured across high-performance databases, enterprise backend systems, workflow automation, financial BI, and cloud architecture.
Data & Performance Engineering
High-throughput PostgreSQL stored procedures, sub-second query plan tuning, dimensional modeling, and ClickHouse/BigQuery OLAP pipelines.
Software & Enterprise Architecture
Resilient full-stack TypeScript applications, transactional data services, PostgREST APIs, RBAC security, and automated testing.
Operational Automation & Applied AI
Event-driven WhatsApp bots, n8n webhook orchestration, Google Gemini AI multimodal extraction, and Python document pipelines.
Domain Strategy & System Delivery
Google Cloud Certified PDE, enterprise financial governance (Rp 1.2T), DJP Coretax compliance, technical PRDs, and end-to-end UAT.
Key Achievements & Recognition
Demonstrated milestones...
Top 6 Best Group — Microsoft Innovation Challenge
Led end-to-end data modeling, DAX measure creation, and interactive reporting for 'UmMeals' (healthcare analytics to address maternal stunting), presenting insights directly to executive judges.
Top 53 Product-Based Capstone — Bangkit Academy
Developed 'Project Anya', an AI-powered computer vision healthcare monitoring application for stunting detection, competing among 463 multidisciplinary teams across Indonesia.
Sub-Second Database Execution Plan Optimization
Refactored heavy PostgreSQL execution plans on multi-million row logistics tables (trips, invoices, points) by eliminating unindexed OR conditions, deploying B-tree composite indexes, and optimizing CTEs.
E-Commerce Workflow Optimization & Fraud Mitigation
Identified and resolved critical system bottlenecks across SAP FI/SD and e-commerce web/mobile platforms, lifting daily completed product orders by +200 units across 153 UAT test cases.
Graduated with Honors (Cum Laude) & Published Thesis
Graduated with highest honors in Informatics (Computer Science). Authored and published peer-reviewed research on COVID-19 Case Prediction System in Teknomatika: Jurnal Informatika dan Komputer.
Education & Academic Leadership
Computer science degree...
Degrees & Formal Tech Academies
Universitas Jenderal Achmad Yani Yogyakarta
Bachelor of Computer Science (S.Kom / S1 Informatika) — Informatics (Computer Science)
GPA: 3.88 / 4.00 (Cum Laude (Graduated with Honors))
“COVID-19 Case Prediction System in Indonesia Using Linear Regression Algorithm”
Key Coursework & Focus Areas:
- Graduated with highest academic honors (Cum Laude, GPA 3.88/4.00) with a curriculum focus on Data Engineering, Machine Learning, Database Architecture, and Software Engineering.
- Authored published machine learning research predicting COVID-19 transmission trends in Indonesia using linear regression algorithms, published in Teknomatika: Jurnal Informatika dan Komputer.
- Balanced academic excellence with extensive campus service as elected Head of Informatics Student Association (HMIF) and multi-semester Laboratory Teaching Assistant.
Bangkit Academy led by Google, GoTo, Traveloka
Ministry of Education & Culture (Kemendikbud-Ristek) SIB Tech Scholarship — Cloud Computing & Machine Learning Specialization
Graduated with 94.76 Score & Top 53 Capstone
Key Coursework & Focus Areas:
- Selected from over 63,000+ applicants nationwide for Google's prestigious tech talent development program across two intensive learning tracks.
- Cloud Computing Cohort (Feb 2021 – Jun 2021): Mastered Google Cloud Platform (GCP) Compute Engine architecture, Linux server operations, backend development, and IT Automation with Python, graduating with an outstanding average score of 94.76.
- Machine Learning Cohort (Feb 2022 – Jun 2022): Engineered TensorFlow models for computer vision, CNN, and NLP; built Capstone 'Project Anya' (AI Stunting Monitoring App) and ranked Top 53 out of 463 national teams.
Kementerian Pendidikan & Kebudayaan x Digitalent Scholarship
Microcredential & Professional Tech Acceleration Programs — Data Science, Cloud AI & Network Infrastructure
Key Coursework & Focus Areas:
- Associate Data Scientist Microcredential (Kemendikbud-Ristek, 2021): Intensive training in Python statistical modeling, EDA, data cleansing, and machine learning algorithm deployment.
- Power BI Data Analyst (Microsoft & FGA, 2024): Relational and NoSQL cloud data management on Azure, data lake architecture, DAX modeling, and automated executive reporting.
- Network Security (Cisco & ProA, 2024): Completed 45+ hands-on technical labs with Cisco hardware and Packet Tracer on firewall hardening, intrusion prevention systems, and secure VPN architectures.
Academic Leadership & Campus Governance
Head of Informatics Student Association (Ketua HMIF)
Universitas Jenderal Achmad Yani Yogyakarta
Elected leader of the Informatics department student body, presiding over executive boards, departmental strategy, and student advocacy.
- Led the executive management board, orchestrating departmental academic programs, coding clinics, technical workshops, and soft-skills training.
- Fostered strategic partnerships and joint academic programs across faculties, university leadership, and regional student associations.
- Spearheaded tech seminars, competitive programming sessions, and department-wide orientation programs for incoming computer science undergraduates.
Assistant Lecturer (Asisten Dosen Laboratorium)
Informatics Computing Laboratory, UNJAYA
Appointed laboratory assistant to support faculty professors in conducting technical practicums and evaluating student implementations.
- Assisted faculty in leading hands-on laboratory practicums for Basic Programming (Python/C++) and Data Engineering courses.
- Mentored 20–25 undergraduate students per session in Python programming, algorithmic thinking, and lab implementation challenges.
- Evaluated weekly student lab implementations, reviewed code submissions, and conducted final semester practical assessments.
Data Mining Bootcamp Mentor
Informatics Faculty Bootcamp, UNJAYA
Technical mentor facilitating hands-on data analytics and cloud warehousing bootcamps for student analysts.
- Mentored 25+ students through exploratory data analysis (EDA), data cleansing, and statistical modeling with Python (Pandas, NumPy).
- Taught practical SQL querying, analytical modeling, and big data warehousing workflows using Google Cloud BigQuery.
- Conducted 1-on-1 code reviews and guided students in formulating actionable business insights for their final capstone presentations.
Core Team Member & Event Organizer — GDSC
Google Developers Community Chapter, UNJAYA
Core organizer building and nurturing a vibrant Google developer student community on campus.
- Planned and executed developer tech talks, Google Cloud Study Jams, and machine learning hands-on workshops.
- Built a collaborative campus developer ecosystem connecting students with industry tech mentors and real-world project challenges.
Secretary — DSC Jogja Festival 2020
DSC Jogja Regional Festival (Google Developer Student Clubs)
Executive organizing committee member for one of the largest regional developer student conferences in Yogyakarta.
- Managed official documentation, event proceedings, participant data, and schedule coordination for hundreds of regional participants.
- Coordinated cross-campus GDSC communications, speaker logistics, and multi-track technical presentation sessions.
Global Certifications & Credentials
Internationally recognized certifications spanning Google Cloud Data Engineering, Microsoft Power BI, Generative AI, and Project Management.
Google Cloud Certified: Professional Data Engineer
Issuer: Google Cloud
Credential ID:: c8d6f602-20bd-474e-9446-417235a39633
Google Cloud Certified: Generative AI Leader
Issuer: Google Cloud
Credential ID:: 7030c8dd-d4c3-4757-8b43-737eebcccd92
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Issuer: Microsoft
Credential ID:: 3844C8EF4649B838
Network Security Certification
Issuer: Cisco Networking Academy
Credential ID:: bc07fc68-9abd-4052-acc6-e190a3f38756
TensorFlow Developer Professional Certificate
Issuer: Google
Credential ID:: 57023151
AWS Academy Graduate — Machine Learning Foundations
Issuer: Amazon Web Services (AWS)
Credential ID:: 6ea22835-c6b6-41bb-82c1-670652377223
Google UX Design Specialization
Issuer: Coursera / Google
Credential ID:: 11072b7c-1138-4a31-9fc5-d7d55d179b93
ACA Big Data Certification
Issuer: Alibaba Cloud
Credential ID:: IACA03240900148745LID
UI/UX Design Mastery (Gold Award)
Issuer: Skilvul
TensorFlow: Data and Deployment Specialization
Issuer: DeepLearning.AI
Credential ID:: C9JJJXX39U9B
DeepLearning.AI TensorFlow Developer Specialization
Issuer: DeepLearning.AI
Credential ID:: EYT89MV8XGVN
Mathematics for Machine Learning Specialization
Issuer: Imperial College London
Credential ID:: G57X7ZAJDFTJ
Google IT Automation with Python Specialization
Issuer: Google
Credential ID:: NGYLNJXXZ4TU
Google IT Support Specialization
Issuer: Google
Credential ID:: BWHF8YQXPKMY
Get In Touch
Interested in discussing technical collaborations...
Direct Communication Channels
Prompt responses via Email and LinkedIn
Direct Email
yusriyahisna24@gmail.com
Location Base
Jakarta & East Java, Indonesia (Open to Hybrid & Remote Worldwide)
Send Transmission
Fill out the fields below to launch your default mail client with a pre-populated message draft.