ERMAR EDHRIC H. EDER

Data Migration, ETL, and Deployment (Oracle HCM Cloud)
Client: German State-owned Railway Company

• Migrated and transformed test user data into structured datasets for training environments using SQL, Python, and Oracle Integration.
• Automated the deployment of BI Publisher reports and objects across environments, optimizing data pipeline efficiency.
• Worked directly with clients to assess, troubleshoot, and implement changes in data integration and transformation workflows.

Data Reporting and Analytics (Oracle HCM Cloud)
Client: US Public Research University

• Designed and developed 30+ SQL-based reports (medium-to-complex) using BI Publisher and OTBI, extracting insights from HR, Talent, Absence, Benefits, Time & Labor, and Payroll datasets.
• Customized and optimized three enterprise reports (Pay Slip, Pay Cheque, Workflow Approvals) using RTF template customization, XML data, and XPath, enhancing report accuracy and readability.
• Conducted data modeling, query optimization, and data validation, ensuring high data quality across reporting modules.
• Created detailed technical documentation and test cases to streamline data validation and report development processes.
• Managed and resolved data-related tickets in JIRA, collaborating with cross-functional teams to optimize reporting workflows.

Client: US-Based Healthcare Systems Company

• Developed four advanced SQL-based reports (two medium-complex, two complex) for Core HR and Recruiting modules.
• Translated business requirements into data models, reports, and dashboards, ensuring actionable insights for stakeholders.
• Authored functional and technical design documents, outlining data structures, reporting logic, and query optimizations.

Data Engineering and Conversion
Client: US-Based Healthcare Systems Company

• Supported three data migration cycles (mock conversions, dress rehearsals) by analyzing and transforming structured datasets for seamless integration.
• Developed SQL scripts for automated data transformation, ETL processes, and discrepancy detection, improving data quality and consistency.
• Performed data validation and integrity checks using Oracle SQL Developer and Excel, ensuring compliance with migration requirements.
• Provided stakeholders with data-driven insights and reports to track conversion accuracy and success metrics.
• Contributed to the successful go-live of the migration project, ensuring smooth deployment and data consistency.

• Conducted market research and data analysis to develop feasibility studies for non-toll business projects, including transport terminals, smart cities, and traffic enforcement systems
• Assisted in financial modeling and forecasting, leveraging Excel and data visualization tools to assess revenue potential and business viability
• Supported senior management with data-driven reports, presentations, and dashboards, enhancing decision-making processes
• Managed document control and administrative workflows, ensuring efficient data tracking and retrieval