Ralph Wang
Calgary,Alberta
Summary
Highly skilled in UNIX, scripting, and database administration with extensive experience managing mission-critical payroll systems. Expertise in optimizing SQL performance and ensuring data integrity within PeopleSoft and Oracle E-Business Suite environments. Seeking a lead position in application and database administration to drive operational efficiency.
Overview
2027
2027
years of professional experience
1
1
Certification
Work History
Estate Management & Career Break
Freelancer
Calgary, Canada
2023 - Current
- Coordinated cross-border estate and relocation logistics between Taiwan and Canada while supporting a parent’s medical needs during structured career break.
- Directed healthcare coordination and administrative planning alongside international logistics, maintaining disciplined technical self-study.
- AI & Automation Projects: Deployed and configured OpenClaw AI Gateway on Linux, integrating WhatsApp for real-time AI-driven communications.
- Designed chatbot workflows to execute tasks, generate reports, and send analytics via email automatically.
- Resolved gateway authentication, session management, and service orchestration challenges.
- Leveraged ChatGPT and Gemini to design intelligent workflows, automate prompt engineering, and enhance reporting processes.
- Data Science & PeopleSoft Analytics: Completed intensive self-directed curriculum in R Programming for Data Science.
- Built automated data cleaning and visualization pipelines with RStudio.
- Integrated PeopleSoft Query with external analytical tools to automate HR and audit workflows.
Senior PeopleSoft Consultant
Government of Canada
Ottawa, Canada
2019 - 2023
- Delivered 24/7 administration and operational support for PSPC Government of Canada Payroll System (HR / HCM 9.2), ensuring application availability and optimal performance across development, test, production environments.
- Ensured integrity and availability of critical payroll data, optimized complex SQL queries and Application Engine processes, and performed proactive performance tuning, enhancing processing time for payroll cycles.
- System Administration & Maintenance: Managed PeopleSoft Internet Architecture (PIA) installations, environment configurations, patching, upgrades, and DMS/SQL/Linux scripts for seamless system operation. Utilized PeopleSoft Update Manager (PUM) for system updates and environment migrations.
- Cross-Functional Collaboration: Partnered with infrastructure architects, functional teams, and vendors to deploy patches, troubleshoot issues, and support migrations, enhancements, and production releases.
- Monitored systems, resolved incidents, and managed after-hours activities to maintain uninterrupted ERP operations and meet service-level objectives.
- Led the successful migration of Oracle User Productivity Kit (UPK) from version 11.1 to 12.1, including post-migration support and documentation.
- Provided senior-level administration for one of Canada’s largest mission-critical payroll environments, supporting federal employees nationwide.
PeopleSoft Technical Consultant
Trans Canada Energy
Calgary, Canada
2018 - 2019
- Data Migration & Validation: Executed large-scale PeopleSoft database migrations to the Calgary Data Center, ensuring 100% data reconciliation between source and target environments.
- Data Extraction & Reporting: Executed complex SQL and Application Engine processes for year-end reporting, ensuring accurate extraction and validation of financial and HR data for business stakeholders.
- Legacy System Configuration & Administration: Provided technical consulting and environment maintenance for offline legacy PeopleSoft environments, ensuring system stability and accessibility for audit and compliance purposes.
- Stakeholder Support & Collaboration: Collaborated with functional users and technical teams to troubleshoot data access issues and support ad-hoc reporting, facilitating seamless production operations.
PeopleSoft Consultant
Alberta Health Services
Edmonton, Canada
2017 - 2017
- Led PeopleTools 8.5x and HCM 9.2 upgrade environment builds, including full-stack configuration of PIA, application servers, process schedulers, and databases.
- Deployed HCM 9.2 DPK upgrade images and configured upgrade environments.
- Validated HCM upgrade path from 8.8 to 9.2, ensuring compliance with upgrade requirements.
- Administered PHIRE change management system, configuring PIA domain, security, email notifications, and migration workflow to streamline change processes.
- Applied PeopleSoft Update Manager (PUM) to manage delivered application updates.
- Tracked incidents and service requests using JIRA, facilitating effective communication and resolution.
PeopleSoft Administrator
Tervita Corporation
Calgary, Canada
2015 - 2016
- PeopleSoft Systems Administration: Managed PeopleSoft environments (PT 8.54, FSCM/HRMS 9.1), performing system maintenance, monitoring, and ensuring application availability across development, test, and production tiers.
- Security & Compliance Administration: Directed PeopleSoft security remediation, designing and testing roles, permission lists, and row-level security to maintain data privacy and regulatory compliance.
- Automated Data Workflows: Developed and maintained shell scripts to automate daily environment refreshes, providing development and testing teams with accurate, up-to-date production data subsets.
- Technical Problem Solving & Collaboration: Partnered with Technical Analysts, Developers, and infrastructure teams to troubleshoot complex application issues, performing root-cause analysis on data discrepancies and system bugs.
- Knowledge Leadership & Support: Facilitated knowledge transfer of PeopleSoft technical architecture and data processes to offshore support team (Infosys), ensuring continuity of service.
- Performance Engineering & Optimization: Identified and resolved performance bottlenecks within Integration Broker; developed automated scripts to purge redundant data, enhancing system response times and data reliability.
PeopleSoft DBA
University of Calgary
Calgary, Canada
2013 - 2015
- Administered 24/7 PeopleSoft ERP environments (PT 8.5x, FSCM/HCM/CS 9.1) across 100+ Oracle databases, ensuring system availability, performance, and reliability.
- Led implementation of PeopleSoft portal, upgraded PeopleTools to 8.53, executed HCM/Campus Solutions database splits, and managed ELM implementation projects.
- Performed database administration and system maintenance tasks, including RMAN backups, cloning, upgrades (Oracle 11g), and environment refreshes using shell and PL/SQL scripts.
- Automated database and system monitoring, space management, and performance tuning processes, enhancing operational support for production and testing environments.
- Applied best practices in PeopleSoft system administration, patching, and database management to support enterprise-scale ERP operations.
- Developed scripts and monitoring routines for optimal database and application performance, integrating seamlessly with Linux/Unix environments.
- Managed application change requests and incident tracking using PHIRE, performing migrations, version control, rollback, and user security administration.
- Collaborated with technical teams and functional stakeholders on performance testing using HP LoadRunner, Oracle VM setup, and Oracle Secure Enterprise Search (SES) configurations.
Oracle E-Business Suite R12 Applications DBA
SMART Technologies
Calgary, Canada
2010 - 2012
- Acted as the sole system administrator for Oracle EBS R12 production and project environments, coordinating closely with Oracle On Demand (OOD) at the Austin, TX Data Center.
- Managed system installation, patching, upgrades, and environment refreshes (UAT, TEST, DEV), ensuring availability and performance across multiple tiers.
- Performed SQL and PL/SQL performance tuning and application troubleshooting, optimizing system and report performance to enhance user experience.
- Supported application staff and consultants on ASCP and i-Recruitment projects, providing technical guidance and troubleshooting to ensure project success.
- Completed Oracle E-Business Suite R12 System Administrator certification, demonstrating rapid learning and technical mastery of a new ERP platform.
- Developed and maintained change-control processes for production modifications, managing user access and security to safeguard system integrity.
- Worked with offshore support teams (India) to transfer system knowledge and ensure continuity of service.
- Utilized ServiceNow for issue tracking, change requests, and incident management.
Education
M.S. - Computer Science
Baylor University
Waco, Texas01-1994
B.S. - Mathematics
University of Mary Hardin-Baylor
Belton, Texas01-1990
Skills
- Enterprise ERP Systems
- PeopleSoft HCM
- PeopleSoft FSCM
- PeopleTools
- Application Engine
- SQR
- PeopleSoft Query
- PeopleSoft Security
- Role design
- Row-Level Security
- Query Security Trees
- Security models
- Workflow Approvals
- Database & Analytics
- SQL
- PL/SQL Optimization
- Data Warehousing
- Reporting frameworks
- Automation
- Performance Reporting
- Dashboard Reporting
- System Coordination
- Operational Efficiency
- Financial Oversight
- Compliance
- Regulatory Policy Adherence
- Staffing Analysis
- Property Management
- Digital Communication
- Methodology
- Platform Coordination
- Platform Coordination
Certification
- Oracle E-Business Suite R12 Applications Database Administrator Certified Professional (OCP)
- Oracle Database 11g Administrator Certified Professional (OCP)
- Oracle Database 10g Administrator Certified Professional (OCP)
- Oracle Database 10g Administrator Certified Associated (OCA)
- ITIL v3 Foundation by Loyalist
- ITIL v2 Foundation by itSMF
Personal Information
Title: Senior PeopleSoft / ERP Technical Consultant | AI-Enabled Automation Specialist
References
Available upon request
Education Certifications
- M.S., Computer Science, Baylor University, Waco, Texas
- B.S., Mathematics, University of Mary Hardin-Baylor, Belton, Texas
Core Expertise
PeopleSoft HCM & FSCM (Advanced), PeopleTools, Application Engine, SQR, PeopleSoft Query (Expert), Role & Permission List Design, Row-Level Security, Query Security Trees, Dynamic Security Models, Workflow Approvals (AWE), Oracle 8i–12c, SQL / PL-SQL Optimization, Data Warehousing, Automated Reporting Frameworks, R Programming, Statistical Computing, Data Cleaning & Visualization (R4DS), AI Workflow Orchestration (OpenClaw), Chatbot Integration, WhatsApp Messaging Automation, API-based Task Execution, Automated Report Delivery, WebSocket Services, Workforce Forecasting, Business Process Automation, Audit & Compliance, System Integration
Accomplishments
- Achievement Open Text Outstanding Team Bell Sigma Award
President of Taiwan Graduated Student Association - Baylor University
Timeline
Estate Management & Career Break
Freelancer
2023 - Current
Senior PeopleSoft Consultant
Government of Canada
2019 - 2023
PeopleSoft Technical Consultant
Trans Canada Energy
2018 - 2019
PeopleSoft Consultant
Alberta Health Services
2017 - 2017
PeopleSoft Administrator
Tervita Corporation
2015 - 2016
PeopleSoft DBA
University of Calgary
2013 - 2015
Oracle E-Business Suite R12 Applications DBA
SMART Technologies
2010 - 2012
M.S. - Computer Science
Baylor University
B.S. - Mathematics
University of Mary Hardin-Baylor