Summary
Twenty-plus years in IT spanning software development, database engineering, business analysis and technical project management, built on a strong foundation in SQL, PL/SQL and database systems. Currently supporting AWS-based data platforms and pipelines — Amazon S3, AWS Glue, Redshift, DynamoDB, EventBridge and EC2 — for one of Japan's largest airlines. Deep airline-domain expertise spans Passenger Service Systems, NDC, revenue accounting, revenue management and operational data stores.
Experience
-
2025 — present
Onsite Technical Project Manager, BlueLake Data Platform
IBS Software Japan, onsite at All Nippon Airways
- Support ANA's next-generation AWS data lake and warehouse, replacing the legacy Brain platform — roughly 30 TB across Open and Private environments.
- Own the L2 and Data Mart layers: transformation, validation and downstream delivery across 200+ L2 tables and 50+ interface files.
- Work with S3, Glue, Redshift, DynamoDB and EC2 across pipelines integrating around 10 upstream and 10–15 downstream systems.
- Troubleshoot production data and pipeline issues using SQL, JP1, Glue, S3, Redshift, CloudWatch and CloudTrail.
- Analyze Redshift EXPLAIN PLAN output and drive SQL performance improvements, validating fixes through system testing.
- Review technical designs and code, coordinating Japanese stakeholders with offshore engineering teams.
-
2021 — 2024
Onsite Technical Project Manager, APaSS-PLUS
IBS Software Japan, onsite at All Nippon Airways
- Managed onsite and offshore delivery for an enterprise operational data store and integration platform connecting 70+ airline systems.
- Coordinated requirements, technical issues, dependencies and releases across business, architecture, database and engineering teams.
- Supported offshore teams in understanding complex interfaces, data flows and business rules.
-
2019 — 2021
Business Analyst / Consultant, NDC Implementation
IBS Software Japan, onsite at All Nippon Airways
- Supported ANA's NDC implementation with partners including Skyscanner, Google Flights and Travelfusion.
- Led requirements and gap analysis, change management and issue analysis.
- Supported system and integration testing through cutover.
-
2014 — 2019
Lead Business Analyst, RA Infra
IBS Software Limited, India — for All Nippon Airways
- Led requirements and data/interface analysis for a revenue accounting integration platform connecting ANA systems with Lufthansa Systems Sirax.
- Authored requirements, interface and data-mapping specifications, supporting offshore development, QA and acceptance testing.
- Managed customer changes and a team of three business analysts.
-
2006 — 2014
Database Architect / DBA / PL-SQL Developer
IBS Software Limited, India
- Designed databases and ER models; handled Oracle administration, replication, backup, performance monitoring and tuning.
- Built Oracle Forms and PL/SQL applications, including testing, maintenance and production support.
- Also served as product owner / lead business analyst for an enterprise IoT platform, managing a team of five business analysts.
Projects
-
Diagfy
diagfy.comA web tool for building technical and data-flow diagrams, made to speed up documenting systems and pipelines.
-
dfgen
A Go command-line tool that renders data-flow diagrams as PNGs straight from a pipeline's YAML lineage manifest, using Sugiyama-style layout to minimize edge crossings.
-
PLAN/SCOPE
A browser-based Redshift EXPLAIN plan analyzer with SVG plan visualization, heuristic issue detection and SQL cross-referencing, built for day-to-day production troubleshooting.
Skills
Data engineering
Data pipelines, ETL/ELT, data integration and transformation, data validation, data warehousing, data marts.
AWS
S3, Glue, Redshift, DynamoDB, EventBridge, EC2, CloudWatch, CloudTrail, IAM.
Programming & databases
SQL, PL/SQL, Python, Oracle, PostgreSQL, MySQL, Amazon Redshift, DynamoDB.
Engineering practices
Data modeling, SQL performance analysis, EXPLAIN PLAN, production troubleshooting, Git, AWS CodeCommit, CI/CD, JP1.
Leadership
Requirements analysis, solution design, technical reviews, incident management, release management, offshore coordination.
Airline domain
Reservation/PSS, NDC, operational data stores, data warehousing, revenue accounting, revenue management.
Languages
English (professional), Japanese (JLPT N3).
Certifications
- Aug 2026 AWS Certified Data Engineer – Associate (DEA-C01) — 799/1000
- Sep 2024 AWS Certified AI Practitioner (AIF-C01)
- Sep 2024 IIT Madras, Foundational Level — Programming and Data Science
- Jun 2024 AWS Certified Cloud Practitioner (CLF-C02)
- Dec 2021 Japanese Language Proficiency Test (JLPT) N3
- Dec 2020 Japanese Language Proficiency Test (JLPT) N4
- Dec 2019 Japanese Language Proficiency Test (JLPT) N5
- Dec 2014 Certified Business Analysis Professional (CBAP)
- May 2008 Oracle Forms Developer Certified Professional
- Apr 2008 Oracle PL/SQL Developer Certified Associate
Education
B.Tech, Electronics & Communications Engineering
Cochin University of Science and Technology (CUSAT), India
Contact
Phone
GitHub
Credly
Location
Tokyo, Japan