Oracle HCM Cloud & EBS Expert 20+ Years Experience

YASER ALY

Oracle ERP Consultant – EBS Project Manager Senior Oracle HCM Functional Lead Senior Oracle Developer & Analyst Team Lead / Technical Manager

US Citizen Benicia, CA

240-***-**** ️ ********@*******.***

LinkedIn: www.linkedin.com/in/yaser-aly-82aa2a46

PROFESSIONAL SUMMARY

Oracle ERP Consultant and HCM Functional Lead with over 25 years of hands-on experience in full Oracle ERP and HCM implementations. Skilled in both technical and functional work, including payroll setup, reporting, integrations, and system upgrades.

Supported supply chain–related processes including inventory management, procurement coordination, and operational planning within Oracle E-Business Suite.

Worked closely with procurement, inventory, and operations teams to ensure accurate data flow, system integration, and reporting across supply chain functions.

Expert in Oracle E-Business Suite (GL, AP, AR, INV, HRMS, OM, FA, PO, BOM, WIP, procurement) and Oracle Cloud HCM (Payroll, Absence, Time & Labor, Benefits). Strong background in PL/SQL, Oracle Forms/Reports, APEX, OTBI, BI Publisher, and data migration (ETL, GoldenGate).

Known for leading teams, mentoring developers, and completing projects on time with practical, client-focused results.

Experience supporting enterprise systems used in public sector and infrastructure environments, including asset-related, payroll, financial, and operational platforms.

Strong coordination across business, technical, and vendor teams in large-scale, regulated environments.

CORE EXPERTISE

Strong background in Oracle E-Business Suite (GL, AP, AR, INV, HRMS, OM, FA, PO, BOM, WIP, Procurement) — full setup, testing, and implementation.

Hands-on experience with Oracle Cloud HCM (Payroll, Absence, Time & Labor, Benefits).

Expert in Oracle Forms and Reports, Apex, PL/SQL, BI Publisher, and OTBI for reporting and custom solutions.

Skilled in Payroll GL Costing, Retro-pay, and year-end payroll processing.

Solid knowledge of Integrations, OIC, HCM Extracts, REST APIs, and HDL.

Experienced in data migration, ETL, and production support.

Strong focus on financial reconciliation, payroll accounting, and system performance.

Leadership in team coordination, client advisory, and project delivery.

Experience supporting Asset Management and Work Management–aligned processes in public sector environments.

Exposure to enterprise architecture, integrations, and data governance across Oracle platforms.

Advisory support for system modernization, reporting transformation, and operational efficiency.

Familiar with WebLogic, Java, Tomcat, and tools like TOAD, SQL Developer, Informatica, Visio, JIRA.

Experience supporting supply chain–aligned business processes, including inventory, procurement coordination, manufacturing operations support, and planning-related data flows within Oracle ERP environments.

Work experience across Oracle (6i–19c).

Follow Agile/Scrum and full SDLC practices with attention to detail and performance tuning.

Reporting experience using OBIEE, Power BI, Discoverer, and Jaspersoft.

PROFESSIONAL EXPERIENCE

Oracle Consultant / Team Lead

Caltrans (Department of Transportation), Sacramento, CA Aug 2024 – Nov 2025 Supporting statewide transportation operations and asset-related business functions.

Supported Oracle Cloud HCM Payroll processes including batches, retro-pay, costing, and GL integration.

Updated and improved Absence and Time & Labor setups to meet statewide compliance needs.

Created and maintained Fast Formulas for payroll validation and earnings rules.

Handled Oracle Forms and Reports installation, setup, and development of new forms and reports.

Provided ongoing support for legacy Oracle EBS Payroll and GL modules.

Upgraded reporting by moving Discoverer reports to Power BI, delivering faster and more insightful results.

Senior Oracle Developer / Consultant / Team Lead

Department of Health & Human Services (via RivaSolutions), MD May 2022 – Jul 2024

Supported the federal payroll system (AFPS) integrated with Oracle HRMS (Oracle Forms and Reports).

Led updates and improvements for Federal HCM Payroll, cost accounting, and year-end reporting.

Created payroll adjustments, costing rules, and GL mapping to streamline processing.

Designed OTBI and BI dashboards to track payroll audits and variances.

Customized EBS GL and HRMS modules to meet federal compliance standards.

Developed advanced PL/SQL packages and payroll reports used by senior management.

Implemented Cybersecurity Single Sign-On (SSO) for existing systems, handling setup, testing, and production rollout while coordinating with the Oracle Support Team and managing multiple service requests (SRs).

Managed and optimized Oracle WebLogic servers and Oracle Forms environments.

Team Lead / EBS Project Manager

Contra Costa County (via Robert Half), Martinez, CA Apr 2017 – Mar 2022

Led a team to design and build facilities maintenance applications from the ground up, supporting work order tracking, operational workflows, and asset-related data.

Managed the full Oracle E-Business Suite (GL, AP, AR, INV, HRMS) implementation as project lead.

Developed and reviewed Oracle Forms and Reports for GL and PO modules.

Set up and supported Absence, Time & Labor, and Payroll GL Costing workflows.

Strengthened Payroll data controls and automated batch scheduling to improve accuracy.

Supported inventory, purchasing, and operational workflows aligned with supply chain and maintenance processes, working closely with business users and technical teams.

Assisted with planning data accuracy and integration between inventory, procurement, and operational systems to support reliable execution.

Guided teams on HCM reporting using OTBI and BI Publisher.

Designed ETL pipelines for large datasets (up to 7 TB).

Tuned PL/SQL code and improved database performance as the technical lead.

Developed lightweight Oracle APEX applications to support internal operational workflows, facilities maintenance tracking, and reporting needs.

Created interactive APEX reports and dashboards integrated with Oracle E-Business Suite data using PL/SQL to improve data visibility and user access.

Senior Oracle Developer

NOAA (via Caelum Research Corp), Silver Spring, MD Apr 2016 – Mar 2017

Developed PL/SQL packages and reporting pipelines to support analytics and data insights.

Designed data models and created reports using XML and CSV data sources.

Improved HR system security and overall performance.

Delivered clean, reusable code while working in Agile Scrum teams.

Oracle Database Developer

Bank of America (via TCS), Newark, DE Oct 2015 – Mar 2016

Supported Oracle GoldenGate replication for high-volume financial transactions.

Developed PL/SQL packages and SQL*Loader scripts to streamline data integration and processing.

Worked with front-end teams to align data models with application logic and reporting needs.

Performed financial analysis and reporting for the Visa customer system, helping improve accuracy and decision-making.

Senior Oracle Developer / DBA / Technical Manager / EBS Project Lead

Naif Arab University, Riyadh, KSA 2002 – Jun 2015

Supported enterprise systems across HR, Finance, Supply Chain, and operational functions in a large institutional environment with asset-intensive operations.

Led several Oracle E-Business Suite implementations, integrating multiple custom modules across HR, Finance, and Supply Chain.

Managed Payroll and HRMS enhancements, including country-specific business and compliance rules.

Oversaw database administration, performance tuning, and backup strategies to ensure system reliability.

Mentored DBAs and developers across multi-site environments, promoting best practices and technical excellence.

Designed and built custom Oracle Forms and Reports applications from scratch to support HR, Finance, and Operations.

Supported supply chain–related processes including inventory management, procurement coordination, Manufacturing (MES), and operational planning within Oracle E-Business Suite.

Worked closely with procurement, inventory, and operations teams to ensure accurate data flow, system integration, and reporting across supply chain functions.

Conducted financial analysis for payroll, budgeting, and accounting systems to improve reporting and decision-making.

Supported retail and inventory systems integrated with Accounts Payable, Accounts Receivable, and General Ledger, ensuring accurate transaction flow and reconciliation.

Designed and implemented Oracle APEX applications to support HR, administrative, and financial processes, providing secure browser-based access for internal users.

Built APEX pages, forms, and reports integrated with Oracle E-Business Suite tables using PL/SQL, reducing reliance on legacy Oracle Forms.

Systems Analyst Programmer / DBA / Team Lead

Jeraisy Computer & Communication Services, Riyadh, KSA 1997 – 2002

Managed a software development department for six years, leading a variety of Oracle-based projects.

Customized and enhanced Oracle ERP modules, and led several system migration and upgrade projects.

Designed and built a complete in-house ERP solution for small and medium-sized organizations, covering GL, HRMS, AP, AR, and Inventory, with a full security system for roles, privileges, and screen-level access.

Developed PL/SQL packages, Oracle Forms, and Reports tailored for finance, HR, and operations.

Created and maintained the Chart of Accounts for the General Ledger system, improving financial structure and reporting.

Designed item cards for inventory management and automated invoice generation for purchasing and sales systems.

Produced detailed system documentation, performance reports, and user guides for smooth implementation.

Conducted financial analysis and reporting to support accounting accuracy and business decisions.

EDUCATION & CERTIFICATIONS

Master of Information Technology – American University of London, UK (2005) - Online

Bachelor of Commerce (Accounting) – Menofia University, Egypt (1995) – 4 years (Full time)

Oracle Certified Professional (OCP) – Oracle Developer 9i (Forms, Reports, PL/SQL, SQL)

Oracle Certified Associate (OCA) – Oracle Database 9i

AVAILABILITY

Remote (USA) or Onsite in Bay Area, CA

Contact this candidate