Geraldine C.
Solution Engineer
Experience
May 2025 - Present
8 monthsErding, Germany
Solution Engineer
Amadeus Data Processing GmbH
- Designed and implemented integration workflows between on-premise systems and cloud platforms (Snowflake, AWS Redshift, Azure).
- Developed data mapping and transformation logic for master data synchronization across ERP and analytics systems.
- Built secure, compliant integration architectures aligned with governance and audit standards.
- Automated deployment and monitoring of integration pipelines using Python, SQL, and CI/CD tools.
- Collaborated with cross-functional teams to translate business requirements into technical specifications for scalable integration solutions.
- Volunteering project: ReDI School of Digital Integration (tech support for existing LAB framework)
Jul 2024 - Feb 2025
8 monthsPhilippines
Senior Data and Analytics Business Intelligence Developer
IQ-EQ Global Investor Services
- Gained foundational understanding of SAP integration patterns through exposure to Investran (functionally similar to SAP BW) and SAP CPI middleware—positioning for rapid onboarding into BW/4HANA and S/4HANA environments.
- Designed data models compatible with ERP-centric analytics, with architecture principles transferable to SAP Datasphere and S/4HANA embedded analytics.
- Analytics solutions directly informed sales performance tracking, pricing strategy, and customer segmentation for B2B and B2C channels.
- Integrated Investran ERP with cloud analytics platform, enabling unified views of client, contract, and revenue data.
- Designed and executed data loading and transformation processes for financial and operational datasets.
- Developed integration scripts and specifications for ERP-to-cloud data flows.
- Ensured audit-ready documentation and compliance for all integration deliverables.
Dec 2022 - Jul 2024
1 year 8 monthsPhilippines
Senior Data Analyst
Ernst and Young
- Collaborated with IT Controlling to estimate cloud infrastructure costs for analytics platform migration (Snowflake + Power BI), optimizing spend by 20% through right-sizing and archival strategies.
- Prioritized backlog items based on business impact vs. implementation cost during roadmap planning at EY.
- Led the design and rollout of a scalable analytics foundation (dbt + Snowflake) adopted by 10+ markets, enabling self-service sales reporting and reducing ad-hoc requests by 70%.
- Enabled promotion-aware targeting by connecting campaign exposure data with purchase behavior, increasing conversion efficiency and reducing wasted ad spend.
- Synthesized complex customer journey data into executive-ready insights, driving 20% higher engagement and informing global marketing strategy.
- Delivered executive-facing dashboards on campaign ROI and customer lifetime value, supporting commercial budget allocation and deal prioritization.
- Processed semi-structured customer journey data from web, email, and social channels into unified analytical models and defined conversion events—laying groundwork for attribution modeling and cohort analysis.
- Processed semi-structured web/social data (JSON, logs) into structured analytical models—experience directly applicable to unstructured data ingestion in Azure Data Lake.
- Optimized data flows to eliminate redundant processing and storage, improving system efficiency and reducing computational waste—principles directly applicable to minimizing physical waste in supply chains.
- Played a key role in the data-driven culture implementation by creating data models in the Power BI service to connect 10+ customer touchpoints across multiple channels (email marketing performance, social media metrics, web analytics, etc.).
- Championed post-implementation reviews and process refinements to institutionalize best practices.
- Acted as the bridge between technical and non-technical stakeholders—ensuring data requirements are understood, implemented, and validated across cross-functional teams (analogous to Engineering, Supply Chain, and Quality in EPC).
- Performed descriptive and diagnostic analytics to identify operational bottlenecks and revenue drivers.
Feb 2020 - Dec 2022
2 years 11 monthsPhilippines
Data Engineer
Infor
- Led end-to-end delivery of cloud analytics integration project (Infor Snowflake), managing scope, timeline, and external vendor coordination.
- Acted as primary liaison between Finance, Sales, and IT stakeholders to align KPI definitions and data architecture—reducing metric disputes by 90%.
- Built predictive model to identify high-value customers at risk of churn—directly supporting retention strategies and protecting revenue streams in competitive markets.
- Owned end-to-end data product lifecycle—from requirement gathering with Sales Ops to deployment and user training—for CRM analytics pipeline.
- Designed a certified semantic layer in Power BI (aligned with Kimball methodology) that served as the single source of truth for commercial KPIs—directly transferable to Tableau semantic modeling.
- Designed and governed enterprise-grade data architecture (logical/physical models, data flows) on cloud data warehouses (Snowflake, AWS Redshift) using star schema modeling, enabling scalable analytics and self-service reporting.
- Defined data ingestion rules, metadata standards, and lineage protocols to ensure compliance, auditability, and trust in metrics—laying groundwork for a centralized data lakehouse approach.
- Architected secure, compliant data platforms aligned with TOGAF principles, integrating on-prem and cloud systems to support master data management (e.g., financial instruments)—directly transferable to SAP Datasphere/S/4HANA integration scenarios.
- Analyzed product and customer profitability to inform pricing, retention, and cross-sell strategies—contributing to 10% revenue growth.
- Worked with Infor ERP (financial & sales modules) to extract contract, customer, and revenue data—enabling CRM-linked financial reporting.
- Designed CRM snapshot pipelines to enable trend and cohort analysis—laying groundwork for demand forecasting and customer behavior prediction in supply chain context.
- Developed and maintained dbt models in Snowflake, implementing data tests, documentation, and lineage tracking—ensuring reliability of critical business metrics.
- Owned master data governance for customer and product hierarchies, ensuring consistency and compliance across ERP and analytics systems—paralleling static data management for financial instruments.
- Designed and deployed a cloud-based data lake (S3) and warehouse (Snowflake) architecture, integrating ERP and e-commerce systems—improving data accuracy by 35%.
- Performed root-cause and trend analysis on customer and operational data to uncover fraud risks, drop-off points, and optimization opportunities—directly improving security and conversion.
- Integrated ERP and e-commerce data to build unified service views, enabling 35% higher data accuracy for customer-facing teams.
- Reduced operational effort by 50% through process automation, while improving data accuracy by 35%—directly supporting business performance and service excellence.
Jan 2019 - Jan 2020
1 year 1 monthPhilippines
Data Analyst
Ecorenew Group
- Collaborated with Logistics and Supply Chain teams to define data standards for physical asset attributes (location, status, utilization)—directly transferable to telematics and asset performance reporting.
- Integrated e-commerce platforms (Amazon, Mazuma) with analytics systems—ensuring accurate sales, returns, and product performance tracking.
- Collaborated with product, customer service, and finance teams to develop data-driven strategies, resulting in a 20% improvement in decision-making efficiency.
- Co-developed a data-driven pricing engine that optimized price points across product categories, improving gross profitability by 10%—directly supporting revenue growth management goals.
- Enabled data-backed strategies that contributed to a 15% increase in operational efficiency across departments.
- Developed time-series–informed sales forecasts using historical transaction data, improving accuracy by 25% and supporting inventory and logistics planning.
- Defined data requirements for the Mazuma Integrated eMarketplaces System, resulting in the successful reimbursement of 97 removal orders returned to the warehouse from Amazon UK, totaling £1,898 over an 8-month period.
- Streamlined the returns management process between Amazon UK Warehouse and Ecorenew Group’s global warehouses, reducing processing time by 30% through the development of the Returns Management System web application.
Languages
Tagalog
NativeEnglish
AdvancedGerman
ElementaryEducation
Mar 2025 - Aug 2026
Deggendorf University of Applied Sciences
M.Eng Applied AI for Digital Production Management · Applied AI for Digital Production Management · Deggendorf, Germany
Feb 2021 - Feb 2025
Mapua University
M.Sc. Business Analytics · Business Analytics · Philippines · 1.3
Jun 2010 - Apr 2015
Polytechnic University of the Philippines
B.Sc. Industrial Engineering · Industrial Engineering · Philippines · 1.9
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.