Ja

Data & analytics engineer with 12+ years across BI, data engineering, and AI-driven analytics. Builds end-to-end pipelines, production BI and AI-powered tooling. Track record leading cross-functional and international teams across e-commerce, retail, and enterprise software. I think of myself as a modern storyteller, the data-driven kind.

Senior Data & Analytics Engineer at Fashion E-Commerce Company (2024-04 – Present)

• Lead data engineering, BI, and AI-driven analytics for international team spanning all global markets outside the US; partner directly with international Marketing, Logistics, and Sales teams.
• Manage and mentor a junior data developer based in China, owning task delegation, code review, and technical growth since early 2025.
• Built and maintain 10+ production Airflow pipelines integrating Google APIs (Keyword, Ads, GMC), SerpAPI, and internal sources, with outputs delivered to AWS S3.
• Developed AI-powered tools using OpenAI GPT-4 and Gemini to convert natural language to SQL, reducing ad-hoc query requests by ~60%.
• Reduced recurring data prep work from ~1h 30min manual effort to 15–20 minutes through Python automation and pipeline orchestration.
• Replaced paid HTS Code classification service (SimplyDuty) with a Gemini Pro-based prediction workflow, generating recurring cost savings on tariff/duty classification.
• Built competitor pricing intelligence using Octoparse, enabling pricing teams to react to market positioning across international markets.
• Explore and evaluate emerging marketing and data APIs (SimilarWeb, Adjust, etc) for new business intelligence opportunities.
• Created brand and product demand analytics through Google Keyword and Merchant APIs, supporting marketing and merchandising decisions.

Business Intelligence Consultant at Retail Company (2023-06 – 2024-04)

• Managed 50+ enterprise dashboards end-to-end — data modeling, analysis, implementation, testing, and maintenance.
• Led the migration of SSAS data models to Power BI, preserving calculation precision and improving BI delivery efficiency.
• Replicated SSRS reports in Power BI as part of a strategic transition away from SSRS.
• Implemented Power BI REST API and PowerShell modules to programmatically manage Power BI service objects.
• Introduced Power Automate to streamline monthly dataflow and dataset updates.

Business Intelligence Lead at Sophos (Computer Security) (2018-09 – 2023-02)

• Led a Scrum team of 6 developers, 1 QA engineer, and 1 architect through 3 major BI programs, primarily for Finance — data modeling, Power BI dashboards, and cross-functional reporting.
• Rebuilt 2 core Finance SSAS cubes into Power BI data models and recreated Excel-based reports (P&L, Billing, Revenue, Expenses, New & Lost Customers) as native Power BI reports.
• Migrated 80% of legacy reports from IBM Cognos to Power BI during the On-Prem migration, preserving calculations via DAX measures or Power Query.
• Introduced report subscription via Power Automate (Microsoft Flow) across 20% of utility reports for proactive monitoring.
• Provided deep technical investigation for complex backend issues across SQL Server, Snowflake, and Matillion.
• Led quarterly Power BI housekeeping and governance to enforce standards across the organization.
• Streamlined release and backup processes; implemented an end-to-end BI workflow as part of broader team efficiency improvements.
• Delivered a self-service BI workshop to 500+ business users, enabling organization-wide data literacy.
• Supported BI developer recruitment across multiple departments.

Senior Software Engineer at Accenture Inc. (2013-07 – 2018-09)

• Led Agile teams in Manila and Cebu to automate Infrastructure Services and DBA tasks, consistently delivering on time.
• Authored SQL scripts integrated with PowerShell for Microsoft System Center Orchestrator.
• Reduced technical debt and blockers by ~50% through effective risk management in TFS.
• Conducted POCs and resolved critical issues in SSIS packages.
• Collaborated with data architects to refine POCs prior to production rollout.
• Managed a Kanban team of 9 software engineers handling database incidents for 5 BPO applications, consistently meeting SLA.
• Automated Active Directory configurations, generating significant cost savings.
• Built a self-service portal for database changes, reducing costs by ~$17K.
• Partnered with T1–T2 support to resolve data issues via SQL. Converted an Excel-based report to SSRS, saving 0.5 FTE.

BS Information Technology in Information Technology (2009 – 2013)