Alan Palayil
Data Engineer · Ph.D. Student

Data Engineer specializing in automation, modernization, and cloud migration of high-volume financial data systems, with deep expertise in Python, SQL, and Azure/AWS cloud architectures. Designed and delivered a production JSON message-generation platform now processing 1,500+ active commercial mortgage loans daily. Cybersecurity-trained, Zero Trust–certified, and an actively publishing researcher (ten technical monographs, 2026) pursuing a Ph.D. in Information Technology focused on secure, explainable AI systems.

Experience

Data Engineer Genworth Financial
July 2026 – Present Richmond, VA · Hybrid

Own the full technical lifecycle of CML and Derivatives investment-accounting systems — architecture, data engineering, Azure cloud modernization, and production stability for enterprise financial platforms.

  • Own end-to-end data engineering for CML and Derivatives accounting in PAM: architecture decisions, enhancement roadmap, production support, data validation, and vendor coordination.
  • Operate and extend the JSON message-generation platform (V1–V7) running daily against active commercial mortgage loans across DEV/UAT/PROD with versioned releases and built-in reconciliation.
  • Design and deploy cloud-native data pipelines on Azure Synapse Analytics and Azure Data Lake Storage as part of ongoing migration of legacy investment-accounting infrastructure.
  • Engineer production automation covering file-transfer, monitoring, retry, dependency management, and notification — systematically reducing manual intervention across Investments Operations workflows.
  • Serve as primary engineering interface to Accounting, Controllership, Infrastructure, QA, and third-party vendors, aligning data engineering deliverables with financial reporting requirements.
Application Development Analyst Genworth Financial
December 2025 – July 2026 Richmond, VA · Hybrid

Led engineering and modernization of investment-accounting systems — initiating the CML-to-PAM migration, launching the Derivatives-to-Azure rehosting project, and expanding platform ownership into enterprise data engineering scope.

  • Owns CML engineering within PAM, managing technical roadmaps and production stability for active commercial mortgage loans.
  • Led Derivatives processing migration to Azure Synapse; Fixed Income and CML platforms on track for migration by end of 2026.
  • Engineers and maintains production pipelines and automated jobs, reducing recurring manual effort across accounting operations.
  • Drives measurable reliability improvements across production systems, with fewer known failures, fewer error tickets, and improved data representation.
  • Partners with cross-functional operations, accounting, platform-support, and technology teams to align engineering with financial reporting requirements.
Associate Application Development Analyst Genworth Financial
July 2023 - December 2025 Richmond, VA · Hybrid

Built Python and SQL automation for investment accounting workflows across Fixed Income, Derivatives, and CML, replacing manual processes with production-grade pipelines and interfaces.

  • Automated financial reporting and data extraction pipelines in Python and SQL, reducing manual workloads and data entry errors across accounting workflows.
  • Maintained Investments Trading & Accounting platforms (PAM Accounting, Markit EDM, and AppWorx), ensuring system uptime and performance.
  • Resolved application and data failures through root cause analysis, developing permanent fixes to eliminate recurring production issues.
  • Developed system interfaces with Accounting and Operations teams to ensure reliable data flow across Fixed Income, Derivatives, and CML.
  • Supported core accounting workflows across multiple asset classes, providing technical assistance and troubleshooting for daily production tasks.
Software Engineer Intern ITHENA
June 2020 - August 2020 Richmond, VA

Engineered custom TCP/IP protocols and IoT control systems to replace restricted third-party platforms, and built real-time data pipelines with web-based monitoring interfaces.

  • Developed custom TCP communication layers without external automation software, increasing system control and reducing platform dependency.
  • Built an IoT street lamp prototype using C# and MQTT to enable low-latency communication between hardware and the cloud.
  • Created a web-based dashboard using HTML, CSS, and JavaScript for direct real-time monitoring of backend system data.
  • Collaborated with senior engineers to design, test, and document system requirements and user guidelines.
  • Integrated frontend interfaces directly with backend communication services to ensure immediate data synchronization.

Education

Executive PhD in Information Technology University of Cumberlands
August 2025 – Present Williamsburg, KY · Online
  • Focus areas: data science, big data analytics, AI governance, enterprise IT leadership, and risk management.
  • Advanced coursework in statistical methods, qualitative/quantitative research methodologies, and information governance.
  • Developing dissertation on applied AI, data-driven systems, and enterprise automation.
M.S. Cybersecurity Engineering Illinois Institute of Technology
May 2022 – August 2023 Chicago, IL · In-Person
  • Specialized in application development, cybersecurity systems, and applied artificial intelligence and machine learning.
  • Member, Eta Kappa Nu (IEEE-HKN), April 2022 – May 2023; served as Internal Secretary. Dean's List recipient.
B.S. Computer & Cybersecurity Engineering Illinois Institute of Technology
August 2019 – August 2023 Chicago, IL · In-Person
  • Coursework in cybersecurity, data structures & algorithms, machine learning, software engineering, and systems programming.
  • Active in Eta Kappa Nu (IEEE-HKN). Dean's List recipient for academic excellence.

Technical Skills

Languages & Frameworks
Python SQL Java C# C++ JavaScript React
Databases & ETL
PostgreSQL MySQL Oracle Azure Synapse Analytics Azure Data Lake Storage (ADLS) Markit EDM Informatica AppWorx ETL/ELT Pipelines Batch Processing
Cloud & DevOps
AWS (Solutions Architect, SysOps, Developer) Microsoft Azure Azure DevOps Git/GitHub JIRA Linux CI/CD
Integration & Formats
JSON XML REST APIs Secure File Transfer Enterprise Scheduling
Security & Governance
Zero Trust Architecture (CCZT) Network Security NIST CSF Model Risk Management Data Validation
AI & Data Science
Machine Learning Anomaly Detection Time-Series Forecasting Data Mining Predictive Analytics
Automation & Hardware
PowerShell Bash Arduino/ESP32
Methodologies
Agile/Scrum SDLC Functional & Technical Test-Plan Development Root-Cause Analysis

Certifications

Neo4j Certified Professional Neo4j
2026-08 Verify →

Neo4j Certified Professional — validates proficiency in Cypher, graph data modeling, schema and indexes, Neo4j drivers, and data importing on the Neo4j graph database platform.

Neo4jCypher Query LanguageGraph Data ModelingSchema & IndexesNeo4j DriversData ImportingGraph Fundamentals
Neo4j Graph Data Science Certification Neo4j
2026-08 Verify →

Neo4j Graph Data Science Certification — validates proficiency in the Neo4j Graph Data Science library, graph algorithms, and graph data science workflows for analytics and machine learning on connected data.

Neo4j GDS LibraryGraph Data ScienceGraph AlgorithmsGraph Data WorkflowsCommunity DetectionCentralityLink Prediction
Investment Foundations® Certificate CFA Institute

CFA Institute's Investment Foundations® Certificate — demonstrating a working knowledge of finance, investment analysis, and portfolio management principles.

Investment AnalysisPortfolio ManagementFixed IncomeEquityRisk & ReturnFinancial Markets
Vulnerability Management Detection and Response (VMDR) Qualys

Qualys Certified Specialist — Vulnerability Management Detection and Response. Demonstrates ability to deploy, operate, and monitor the Qualys Cloud Platform to implement, manage, and protect IT systems, devices, and web applications.

Vulnerability ManagementDetection & ResponseQualys Cloud PlatformIT SecurityRisk AssessmentPatch Management
Meta Back-End Developer Coursera by Meta
2026-01 Verify →

Professional certificate covering server-side programming fundamentals — Python, Django, REST APIs, SQL, and cloud deployment.

PythonDjangoREST APIsSQLBack-End DevelopmentCloud Hosting
Meta Full-Stack Engineer Certificate Coursera by Meta
2026-01 Verify →

Capstone credential awarded for completing both the Meta Front-End and Back-End Developer certificate programs — covering full-stack development from React UIs to Python/SQL back ends.

HTMLCSSJavaScriptReactPythonSQLREST APIsVersion Control
Certificate of Competence in Zero Trust (CCZT) Cloud Security Alliance
2025-02 Verify →

Foundational certificate validating competence in Zero Trust principles, architecture, planning, and implementation — aligned with the CISA Zero Trust Maturity Model (v2) and NIST SP 800-207.

Zero Trust ArchitectureZero Trust PrinciplesSoftware-Defined PerimeterZT ImplementationZT Planning
Meta Front-End Developer Coursera by Meta
2023-06 Verify →

Professional certificate covering client-side web development — HTML, CSS, JavaScript, React, version control, and UX/UI design, culminating in a portfolio capstone.

HTMLCSSJavaScriptReactVersion ControlResponsive DesignUX/UI Design
Palo Alto Networks Cybersecurity Coursera by Palo Alto Networks
2023-03 Verify →

Four-course specialization covering enterprise cybersecurity fundamentals — the threat landscape, network and cloud security, and security operations using Palo Alto Networks technologies.

CybersecurityNetwork SecurityCloud SecurityFirewallSecurity OperationsEndpoint Detection and Response
Fundamentals of Network Security Udemy
2023-01 Verify →

Foundational course on network security principles — securing network infrastructure with firewalls, VPNs, and intrusion detection, and defending against common network attacks.

Network SecurityFirewallsTCP/IPVPNIDS/IPSNetwork Protocols
Build Responsive Real-World Websites with HTML and CSS Udemy by Jonas Schmedtmann
2022-12 Verify →

Hands-on front-end course on building responsive websites from scratch with semantic HTML and modern CSS — including Flexbox, CSS Grid, and web design principles.

HTMLCSSResponsive DesignFlexboxCSS GridWeb Design
The Complete Cyber Security Course : Anonymous Browsing! Udemy by Nathan House
2022-11 Verify →

Volume 3 of the Complete Cyber Security series focused on online anonymity and privacy — using Tor, VPNs, proxies, and operational security to browse anonymously.

AnonymityTorVPNProxiesOPSECPrivacy & Anonymity
The Complete Cyber Security Course : End Point Protection! Udemy by Nathan House
2022-11 Verify →

Volume 4 of the Complete Cyber Security series focused on endpoint protection — securing devices with encryption, anti-malware, application control, and threat detection.

Endpoint SecurityDisk EncryptionAntivirus & EDRMalware DetectionApplication ControlThreat Removal
The Complete Cyber Security Course : Hackers Exposed! Udemy by Nathan House
2022-11 Verify →

Volume 1 of the Complete Cyber Security series covering threat and vulnerability landscapes — hackers, malware, encryption, and operational security fundamentals.

Network SecurityThreat ModelingEncryptionMalware AnalysisOPSECPrivacy & Anonymity
Git & GitHub Ultimate Bootcamp: Beginner to Git Expert Udemy by Bibhash Roy
2022-11 Verify →

In-depth Git and GitHub bootcamp from fundamentals to expert workflows — covering version control internals, branching, merging, rebasing, and team collaboration on GitHub.

GitGitHubVersion ControlBranching & MergingRebasingCollaboration
The Complete Android N Developer Course Udemy by Rob Percival
2021-11 Verify →

Comprehensive course on building Android apps with Java and Android Studio — covering the Android N SDK, UI layouts, data persistence, and app publishing.

JavaAndroidAndroid StudioMobile App DevelopmentFirebaseREST APIs
The Complete Cyber Security Course : Network Security! Udemy by Nathan House
2021-11 Verify →

Volume 2 of the Complete Cyber Security series focused on network security — firewalls, network monitoring, Wi-Fi hardening, and defending against network attacks.

Network SecurityFirewallsWiresharkWi-Fi SecurityIDS/IPSNetwork Monitoring
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert Udemy by Colt Steele
2021-11 Verify →

Comprehensive MySQL bootcamp taking SQL from beginner to expert — querying, database design, joins, aggregate functions, and stored routines through hands-on projects.

MySQLSQLDatabase DesignJoinsAggregate FunctionsStored Procedures
The Ultimate Windows PowerShell Scripting Course: A to Z Udemy by Jason Vanburen
2021-11 Verify →

End-to-end Windows PowerShell scripting course — automating administrative tasks with cmdlets, scripts, functions, and the pipeline for Windows system management.

PowerShellScriptingAutomationWindows AdministrationCommand LineScheduled Tasks
Beginning C++ Programming - From Beginner to Beyond Udemy by Tim Buchalka
2020-11 Verify →

Comprehensive 46-hour C++ course from fundamentals to advanced topics — covering object-oriented programming, pointers, the STL, and modern C++ best practices.

C++Object-Oriented ProgrammingPointersSTLData StructuresProgramming Fundamentals