Edrian Jake Oclarit

Results-driven Data Engineer and Django Developer specialized in building scalable backend systems, automated ETL workflows, and data-driven web applications. Expert in transforming complex manual processes into centralized automation platforms using Python, PostgreSQL, and Django. Proven track record in designing star schema data models and interactive analytics dashboards to drive pricing optimization and business intelligence.

Data Analyst / Junior Software Developer at Team Medical Supplies (2025-06 – Present)

• Internal Automation Architect: Engineered a modular internal automation platform ("TeamMed Tools") using Django to centralize complex data workflows. Hosted the platform on AWS EC2, utilized S3 for scalable storage handling, and integrated AWS SES for OTP verification to ensure robust security.
• Product Code Matching & Data Automation Django App: Developed an end-to-end automation system to convert unstructured supplier PDFs into clean, structured datasets. Integrated Datalab's Chandra API to enhance the accuracy of product code matching logic across product codes, ensuring high data consistency. The system features a custom Django/JavaScript interface for real-time validation and a PostgreSQL-backed ETL workflow for scalable data transformation.
• Pricing & Benchmarking Engine Django App: Designed a data-driven system utilizing a star schema model and backend APIs to optimize customer pricing, customer product group benchmarking, and customer churn detection. Collaborated directly with a Quoting & Pricing Specialist to translate complex business logic into automated benchmarking models and margin performance tracking.
• Advanced Data Validation: Implemented outlier filtering (top 2%/bottom 20%) and churn detection models to ensure data integrity and identify behavioral discrepancies.
• API and Platform Integration: Integrated Python-based backend services with Salesforce and Phocas to support real-time operational decisions.

Master Data Specialist / SAP TM Support at Radiant BPO Services Inc. (2024-08 – 2025-06)

• Process Automation: Developed Python (Flask) and VBA automation tools that scrubbed and validated master data from SAP TM and Cargo Wise, significantly reducing manual effort.
• Technical Troubleshooting: Provided high-level support for SAP TM issues and created comprehensive technical documentation for internal users.

Associate Engineer at Toyoflex Cebu Corporation (Asahi Intecc) (2022-11 – 2024-08)

• Analytics & Optimization: Built Power BI dashboards to analyze machine repair history and maintenance trends, leading KAIZEN initiatives to maximize production efficiency.
• Root Cause Analysis: Performed systematic corrective actions on machine performance data to optimize industrial workflows.

Bachelor of Science in Computer Engineering – Bohol Island State University (2018 – 2022)