Oracle Integration Cloud (OIC) Engineer   |   Enterprise Systems Architect: SCM/FIN/HCM

Oracle Integration Cloud Engineer and Enterprise Systems Architect (SCM/FIN/HCM) with over nine years of professional software integration and development experience. Currently serving UC Health (Full-Time Remote, September 2022 to Present) as an OIC SME responsible for building, testing, and maintaining integrations and custom applications supporting Oracle Fusion Cloud ERP (SCM/FIN/HCM) under Kanban AGILE methodology, with post-go-live stabilization and optimization as a primary mandate.

Graduate Class of 2023, Eastern Kentucky University Master of Science in Computer Science with a Concentration in Cybersecurity and Digital Forensics (M.S.) and Graduate Certificate in Cybersecurity and Digital Forensics: EKU GPA 3.57. EKU’s online M.S. Computer Science program was ranked #8 of the 12 best online programs by Fortune Education in 2023. Graduate Class of 2016, Northern Illinois University Bachelor of Science in Mathematical Sciences with Emphasis in Applied Mathematics, with Minor Concentrations in Computer Science and Anthropology: NIU GPA 3.0.

Completed 70 CPE credits with Oracle University Training earning PeopleSoft PeopleTools rel. 8.55 Certificates I and II. Currently pursuing Oracle Integration Cloud certification via Oracle University Learning Subscription as part of ongoing Continuing Professional Education (CPE) requirements mandated by employer policy, with annual renewal required to maintain role eligibility. Taught courses in Computer Information Systems at the collegiate level. Designed the XLeads LLM Integration: automated empathetic SMS/email responses for real estate with integrated Gemini Flash and Z.AI GLM-Flash models, output constraints, and auto-reply loop suppression. Deployed OpenWebUI on a private network with multi-agent integration (local and cloud-based) within a unified LangChain architecture including MCP servers engineered for structured tool calling, a Role-Pseudonymous Prompting (RPP) protocol designed as a de-identification layer, and token optimization strategies through deterministic injection pipeline bypassing the LLM entirely for retrieval reducing context window consumption. Demonstrated that open-access LLMs enhanced with optimized RAG/Embedding pipelines can achieve A+ parity with flagship models at 94.4% cost reduction.

UC Health integration delivery operates under a disciplined change-control management governed change-control model requiring each change to document business purpose, affected users, master data and configuration impact, assumptions, environment-specific testing results, training and communication needs, approvals, and post-production follow-up. Depending on severity level, changes require formal cross-module impact review, reinforcing expertise with cross-functional Oracle business process dependencies, production readiness, and environment-based release discipline. This governance model encompasses the full delivery lifecycle: building, testing, troubleshooting, documenting, and deploying integrations, reports, workflows, and technical extensions in a controlled enterprise environment using OIC, REST/SOAP APIs, BI Publisher, ATP, FBDI, and Oracle Fusion Cloud ERP platform tooling partnering closely with functional analysts and business stakeholders to translate requirements into production-ready solutions.

Post-Go-Live Stabilization Legacy ERP to Oracle Fusion Cloud ERP Migration:
• Gap Remediation: Performed comparative analysis of legacy SCM transaction semantics versus Oracle Fusion Receiving interface constraints, identifying undocumented dependencies in supplier site attribution, item-org UOM compatibility, and PO lifecycle synchronization.
• Middleware Enhancements: Refactored inbound OIC integrations to introduce ATP-based canonical staging and BI Publisher-driven enrichment prior to FBDI/REST submission, resolving supplier site, UOM, and item-org mismatches.
• RCA Methodology: Established root cause analysis processes leveraging OIC instance logs, ESS request history, and ATP staging table queries to deterministically differentiate Oracle configuration defects from upstream data-quality violations.
• Operational Support: Authored production support playbooks enabling operations teams to locate, re-stage, and reprocess failed SCM transactions without manual ERP intervention.
• Outcomes: Reduced monthly SCM receipt middleware errors from a peak of 5,672 (January 2023) to 7 (July 2025) a >99% reduction and monthly Oracle cloud receiving errors from a peak of 24,383 (September 2022) to 385 (July 2025), a ~98% reduction.

Notable Integration Builds:
• Surgical Case Management & Clinical Procurement Integration: Engineered a bidirectional clinical procurement data exchange between an external EMR platform and Oracle Fusion ERP delivering two outbound BI Publisher interfaces (Item Master and PO lifecycle extracts) published via SFTP to the EMR, and one inbound OIC Gen3 orchestration ingesting purchase requisitions via SFTP, staged in ATP, enriched with ERP reference data via BI Publisher lookups, and submitted to Oracle ERP through FBDI and ESS job orchestration with SOC 2-compliant fault handling, record-level ATP status tracking (NEW/SUCCESS/ERROR), and automated scheduling.
• Capital Budget Integration: Built an OIC Gen3 scheduled orchestration ingesting daily capital project and budget extracts from an external EPM platform via SFTP, parsing pipe-delimited data into ATP staging tables (project headers, task details, budget records), enriching records with Oracle reference data via BI Publisher reports (Project Manager EIN and Department Code lookups), constructing Oracle-standard FBDI control files (PjfProjectsAllXface.zip and PjoBudgetsXface.zip), and submitting them to Oracle Fusion Project Control via ESS job orchestration (Load Interface File for Import → Import Projects → Import Project Budgets) with de-duplication, version-aware budget update logic, partial-success fallout handling, batch-level email notifications, and SFTP-based FBDI archiving for audit.
• Invoice Order Attachment Integration: Developed an OIC Gen3 orchestration ingesting daily zipped invoice image containers (~500 invoices/day) from an external healthcare supply chain provider via SFTP, parsing the index file to stage invoice metadata in ATP, resolving Oracle invoice IDs via BI Publisher (GetInvoice_Id report), dynamically constructing REST POST payloads with base64-encoded PDFs, and invoking the Oracle Fusion Cloud Payables attachments endpoint with orphan PDF detection, record-level SUCCESS/ERROR status tracking, CSV error reporting, and SFTP archiving per batch run.
• SFTP Migration SCM OIC Refactor: Refactored OIC file-polling orchestrations for SCM integrations to redirect inbound file acquisition from a decommissioned on-premises SFTP server to a vendor-hosted endpoint by inserting an OIC FTP/SFTP invoke step at the boundary layer preserving all downstream ATP staging, FBDI construction, and ESS orchestration logic without rewriting existing integration flows. Migrated seven outbound BI Publisher-scheduled SCM interfaces into OIC-managed schedulers to resolve a non-standard port incompatibility preventing direct BI Publisher SFTP delivery, maintaining identical file contracts with the external system and adding ad hoc BI Publisher output pickup logic for business continuity.
• SCM Middleware Error Notification Remediation: During SFTP migration analysis, identified a silent-failure defect in OIC Shipping and Receipt import integrations where middleware errors produced no email notifications due to missing email body mappings in the shared error-handler switch condition. Escalated during stand-up, received team approval to expand scope within the same delivery window, and implemented the targeted fix restoring full operational alerting for production middleware failures without redesigning the shared error framework.
• OCI PaaS Optimization Project: Reduced infrastructure costs by automating OIC and ATP instance shutdown/startup schedules for off-hours, reducing active OIC Connectivity Agents in test environments, and maintaining DR environments in standby mode significantly lowering compute costs while preserving operational readiness.

Key Strengths Demonstrated in This Role:
• Supporting day-to-day Oracle Cloud Fusion FIN, HCM, and SCM business processes through resilient integrations, scheduled interfaces, production issue resolution, and end-user support.
• Delivering hands-on Oracle Fusion and OIC technical development using REST, SOAP, file-based integrations (FBDI), ATP staging, BI Publisher, ESS job orchestration, and structured Oracle interface patterns.
• Performing root cause analysis, controlled reprocessing, and environment-based troubleshooting with OIC logging, reproducible run parameters, and change-control management governed migration practices across DEV, TEST, and PROD environments.
• Maintaining formal technical documentation, lean specifications, UML diagrams, test artifacts, and implementation details across the full Oracle delivery lifecycle consistent with UC Health’s Oracle development standards, QA controls, and change-control framework.

IT Programmer Analyst (Oracle Integration Cloud SME Enterprise Systems Architect: SCM/FIN/HCM) / UC Health

Cincinnati, OH

Full-Time Remote Position

Sept. 2022 Present

Primary Tech-Stack: Oracle
Java  |  SQL  |  SQL Plus  |  Oracle PL/SQL  |  Oracle ATP Database (On-Premises & Cloud)  |  Oracle Database 19c Administration & Security  |  Oracle SQL Developer  |  SQLcl  |  Oracle Cloud ERP (SaaS)  |  Oracle Fusion Cloud Applications: FSCM, HCM, SCM  |  Oracle Visual Builder Cloud Service (VBCS)  |  Oracle BI Publisher (Interfaces & Data Modeling)  |  Oracle Cloud FBDI (Procurement & FSCM)  |  Fusion Data Intelligence (FDI)  |  Oracle Integration Cloud (OIC) Gen3 (PaaS)  |  Oracle Integration Cloud (OIC) Connectivity Agents  |  RESTful & SOAP Web Service APIs  |  Oracle Enterprise Scheduler (ESS)  |  Oracle Cloud Infrastructure (OCI) Compute, IaaS  |  EPM Automate  |  Fusion Cloud EPM

Other Technological Stacks and (Web) Frameworks:
IBM Cognos Analytics  |  IBM Rational Modeler  |  Microsoft Visio  |  Microsoft Project  |  Microsoft Visual Studio  |  MS SQL Server Management Studio  |  HeidiSQL  |  Tecsys Supply Chain Solutions  |  Iguana Interface Engine  |  Footprints IT Service Management  |  ServiceNow IT Service Management  |  XSL & XSLT (Data Formatting & Schemas)  |  Cygwin POSIX Linux Distribution (CLTs)  |  JRE (Java Runtime Environment)  |  JDK 11+  |  Linux Process Scheduler  |  Windows Task Scheduler  |  MobaXterm  |  PuTTY  |  FileZilla  |  Postman

Client-Side (Frontend) Development:
JavaScript  |  JSON  |  XML  |  CSS  |  HTML5

Server-Side (Backend) Development:
XML (REST/SOAP/SFTP)  |  FBDI  |  SQL  |  Oracle SQL Developer  |  Java  |  Python  |  PL/SQL  |  JSON  |  JavaScript  |  Batch Scripting  |  Shell Scripting (BASH)  |  Process & Service Management  |  Job Management  |  SSH  |  SFTP  |  TCP  |  PGP  |  RESTful API  |  SOAP API  |  XSL  |  XSLT

Notable OIC Contributions & Accomplishments:

• Surgical Case Management & Clinical Procurement Integration
  • Engineered a bidirectional clinical procurement data exchange between an external EMR platform and Oracle Fusion ERP delivering two outbound BI Publisher interfaces (Item Master and PO lifecycle extracts) published via SFTP to the EMR, and one inbound OIC Gen3 orchestration ingesting purchase requisitions via SFTP.
  • Inbound requisitions staged in ATP, enriched with ERP reference data via BI Publisher lookups (item, pricing, supplier site, UOM, org context), and submitted to Oracle ERP through FBDI and ESS job orchestration.
  • Implemented SOC 2-compliant fault handling, automated hourly and nightly scheduling, record-level ATP status tracking (NEW/SUCCESS/ERROR), and batch email notifications with error reporting.
• Capital Budget Integration
  • Built an OIC Gen3 scheduled orchestration ingesting daily capital project and budget extracts from an external EPM platform via SFTP, parsing pipe-delimited data into ATP staging tables (project headers, task details, budget records) with file de-duplication and batch ID tracking.
  • Enriched records with Oracle reference data via BI Publisher reports (Project Manager EIN and Department Code resolution); generated Oracle-standard FBDI control files (PjfProjectsAllXface.zip and PjoBudgetsXface.zip) with version-aware budget update logic (Version1 = create, Version2+ = update).
  • Submitted FBDI packages to Oracle Fusion Project Control via ESS job orchestration (Load Interface File for Import → Import Projects → Import Project Budgets) with polling, request-ID tracking, partial-success fallout handling, and SFTP-based archiving per batch run.
• Invoice Order Attachment Integration
  • Developed an OIC Gen3 orchestration ingesting daily zipped invoice image containers (~500 invoices/day) from an external healthcare supply chain provider via SFTP; parsed the index file to stage invoice metadata in ATP (INVOICE_IMG_ZIP_TBL and INVOICE_IMG_PDF_TBL).
  • Resolved Oracle invoice IDs via BI Publisher (GetInvoice_Id report); dynamically constructed REST POST payloads with base64-encoded PDFs and invoked the Oracle Fusion Cloud Payables attachments endpoint (/fscmRestApi/resources/.../invoices/{invoicesUniqID}/child/attachments).
  • Implemented orphan PDF detection, record-level SUCCESS/ERROR status tracking, CSV error reporting per batch, and SFTP archiving eliminating manual AP attachment workflows and providing a complete audit trail per run.
• SFTP Migration SCM OIC Refactor
  • Refactored OIC file-polling orchestrations for SCM integrations to redirect inbound file acquisition from a decommissioned on-premises SFTP server to a vendor-hosted endpoint by inserting an OIC FTP/SFTP invoke step at the boundary layer preserving all downstream ATP staging, FBDI construction, and ESS orchestration logic without rewriting existing integration flows.
  • Migrated seven outbound BI Publisher-scheduled SCM interfaces into OIC-managed schedulers to resolve a non-standard port incompatibility preventing direct BI Publisher SFTP delivery, maintaining identical file contracts with the external system and adding ad hoc BI Publisher output pickup logic for business continuity.
• SCM Middleware Error Notification Remediation
  • During SFTP migration analysis, identified a silent-failure defect in OIC Shipping and Receipt import integrations: middleware errors were not generating notification emails due to missing email body mappings in the shared error-handler switch condition.
  • Raised the defect during stand-up, obtained team approval to expand scope within the same delivery window, and implemented the targeted fix restoring full operational alerting for production middleware failures without redesigning the shared error framework.
• SCM Integration RCA & Post-Go-Live Stabilization (>99% Error Reduction)
  • Served as OIC SME for post-go-live stabilization following enterprise legacy ERP to Oracle Fusion Cloud ERP migration. Performed comparative analysis of legacy SCM transaction semantics versus Oracle Fusion Receiving interface constraints, identifying undocumented dependencies in supplier site attribution, item-org UOM compatibility, and PO lifecycle synchronization.
  • Refactored inbound integrations to introduce ATP-based canonical staging and BI Publisher-driven enrichment prior to FBDI/REST submission. Established RCA methodology using OIC instance logs, ESS request history, and ATP staging table queries to deterministically differentiate Oracle configuration defects from upstream data-quality violations.
  • Reduced monthly SCM receipt middleware errors from a peak of 5,672 (January 2023) to 7 (July 2025) a >99% reduction and monthly Oracle cloud receiving errors from a peak of 24,383 (September 2022) to 385 (July 2025), a ~98% reduction. Authored production support playbooks enabling deterministic reprocessing without manual ERP intervention.
• OCI PaaS Optimization Project
  • Reduced infrastructure costs by automating OIC and ATP instance shutdown/startup schedules for off-hours, reducing active OIC Connectivity Agents in test environments, and maintaining DR environments in standby mode significantly lowering compute costs while preserving operational readiness.

Adjunct Instructor (Computer Information Systems) / Kishwaukee College

Malta, IL

Remote Faculty

Fall 2021

Primary Tech-Stack: LAMP
Linux Virtual Machine via SSH Remote Connection | Apache Web Server via HTTP | Manage Ubuntu System Configurations (Config Files) | MySQL Database | PHP | Python

Other Technological Stacks and (Web) Frameworks:
D2L (formerly Desire2Learn) | .DAT file import and export | FileZilla SFTP Server and Client | PuTTY (SSH Remote Connection - Secure SHell Login) | HTTPS | SFTP | Ubuntu OS (Linux VM SSH Remote Connection) | GitHub | GitBash CLTs | W3Spaces Web Desing and Hosting | JRE (Java Runtime Environment) | JDK 11+ (javac, jar, java) compile and run java programs from the command-line including third party distributables | Visual Studio Code Integrated with Cygwin for Developing C++ Programs | Cygwin POSIX Linux Distribution for CLTs (Command-Line Tools)

Client-Side (frontend) Development:
JavaScript | JSON | XML | CSS | HTML5

Server-Side (backend) Development:
MySQL | Batch Scripting | Shell Scripting (BASH) | Linux Process Scheduler | Java | PHP | C++ | Python | JSON | JavaScript | Linux Firewall Management - iptables | Linux Uncomplicated Firewall (UFW Commands) | SSH | SFTP

Faculty Responsibilities:
Adjunct faculty member for the CIS program at Kishwaukee College.
Proficient with the D2L, formerly Desire2Learn, Learning Management System (LMS):
Prepare Learning Modules
Prepare and Grade Assignments
Prepare and Grade Quizzes
Prepare and Grade Exams
Prepare and Grade Projects
Prepare Course Outlines
Prepare Lectures
Teach various online synchronous and asynchronous CIS courses:
C++ Programming: From Control Structures through Objects
Website Development in HTML5 and CSS
Familiar with Cengage and Pearson publishing and assessment services, e.g., importing Data Files for quiz question pools that can be randomly selected for exams.
Experience with designing, managing, and hosting an external course website on a server which includes detailed examples for the students via HTTPS, FileZilla (SFTP), JavaScript, HTML5, and CSS including the recently released W3Spaces.

Faculty Sites:
cmathgit.github.io/examples/cis-118-labs/ - Responsive Web Design with HTML5 & CSS Course Website (Apache Web Server)
/github.com/cmathgit/ - GitHub Repositories
cmathgit.github.io - GitHub Web Design and Hosting

Product Support Engineer (NICE CXone Cloud Developer - Integration) / Textel CX Inc.

St. Louis, MO

Full-Time Remote Position

Jan 2021 - June 2021

Primary Tech-Stack: .NET
C# | XML | SQL | CSS | Python | PHP | JavaScript | DevOps | AGILE Development Methodologies

Other Technological Stacks and (Web) Frameworks:
RESTful APIs | Azure NET and Cloud Services (SaaS) | MS SQL Server Management Studio (SSMS) | Visual Studio Code | Cygwin POSIX Linux Distribution for CLTs (Command-Line Tools) | Nice CXOne (Nice InContact) Call Center Solutions | CXOne Studio (C# Based) | GitHub Repository Management | GitBash CLTs | Windows Task Scheduler | Microservices

Client-Side (frontend) Development:
XML | CXOne Studio IDE (C# based) | CSS | JavaScript | JSON | UI Development

Server-Side (backend) Development:
C# | SQL | SQL Stored Procedures | Batch Scripting | Job Scheduling | Automation | JSON payload parsing | cURL commands | RESTful API (GET/PUT/POST/DELETE Methods) | Webhook and GUID/UID generation | Microservices – cross platform application integration

Developer Responsibilities:
Developed and maintained C# applications within NICE CXone and Textel’s infrastructure, integrating cross-platform services using RESTful APIs for call center solutions.
Automated data processes using Python scripts, cURL commands, and SQL, handling API responses to generate reports in TSV/CSV formats.
Managed microservices to ensure seamless integration of applications, utilizing C#, XML, and JSON for cloud-based systems in Azure and NICE CXone.
Designed and executed SQL Stored Procedures and optimized database management for backend services, enhancing operational efficiency in cloud environments.
Provided technical support and troubleshooting for clients, using DevOps and AGILE methodologies to ensure smooth implementation of custom features.
Test, resolve errors, and provide technical troubleshooting solutions for software products during development lifecycle and implementation.
Fulfill technical requests for customizations filed by end-users and clients such as Pearson and Wal-Mart.
Assist engineering team with Textel's GeneSys and InContact implementations.
Manage RESTful API calls and endpoints using C# (Visual Studio Code).
Manage call center modules within Nice InContact’s CXOne Studio IDE based in C# and formatted in XML which has RESTful API Request functionality.
Maintain Database and SQL Stored Procedures.
Develop Microservices to integrate applications such as Textel’s core infrastructure with Nice InContact, e.g., develop C# programs to execute system commands that trigger RESTful API requests to generate webhooks using cURL and execute SQL Stored Procedures to update the database accordingly.
Automate processes programmatically (scripting) to output tabular datasets for analysis: Design Python scripts to send API calls, cURL webhooks, parse JSON arrays and payloads, and generate TSVs or CSVs, SQL scripts, and Batch files from API responses.

IT Programmer Analyst I (Oracle Application Developer) / Ameren Services

St. Louis, MO

Full-Time Remote Position

Nov 2019 - Nov 2020

Primary Tech-Stack: .NET
C# | SQL | CSS | Python | PHP | JavaScript | DevOps | AGILE Development Methodologies

Other Technological Stacks and (Web) Frameworks:
SYBASE/DB2 | SQL Builder | PL/SQL | MKS Project Management Suite | GitHub Repos | Oracle SQL Developer | Oracle DB (11i) | Windows NT Services | Windows Task Scheduler | Ameren PAUM Project Management (In-House) | Ameren EMPRV (In-House)

Client-Side (frontend) Development:
CSS | JavaScript | JSON

Server-Side (backend) Development:
Python | PHP | SQL | PL/SQL | C# | Visual Studio | Automation | JavaScript | RegEx (Regular Expressions) | Batch Scripting | Process Management | Service Management | Job Management

Developer Responsibilities:
Conducted analysis and design for new software using AGILE methodologies.
Developed and modified applications using Visual Studio and C#.
Implemented database solutions using SQL, PL/SQL, and Oracle databases.
Developed and maintained cloud-based solutions using .NET, C#, and various web technologies.
Implemented RESTful APIs and microservices for application integration.
Collaborated with engineering teams to resolve technical issues and implement customizations.
Utilize AGILE development methodologies.
Conduct analysis and design for new software.
Test and modify existing applications such as Primavera P6 Project Management Suite using Visual Studio.
Implement Solutions to Mitigate Security Risks, e.g., design a C# class to prevent SQL Injection Attacks.
Develop search algorithms withing JavaScript for data interchange to prevent data corruption, e.g., manage and design Regular Expressions to remove special characters from text input via user form submission.
Conduct Disaster Recovery drills with team for various systems by following step by step protocols, e.g., starting and stopping application services within Windows NT Services.
Maintain Database instances and tuples in DB2 and Oracle DB (11g) using SQL Builder and PL/SQL, respectively.

Application Programmer (Oracle/PeopleSoft Developer) / Pepsi MidAmerica

Marion, IL

Full-Time Position

Sept 2017 - Nov 2019

Primary Tech-Stack: Oracle
Oracle DB (10g) | Oracle SQL Developer | SQR | PeopleCode | PeopleSoft PeopleTools rel. 8.55 | PeopleSoft Application Developer | PeopleSoft EDI Manager (HCM/SCM) | PeopleSoft Process Scheduler | PeopleSoft ERP (FBDI) | Oracle VM VirtualBox

Other Technological Stacks and (Web) Frameworks:
FileZilla Server and Client | Crystal Reports | Zebra brand (formerly Motorola) Handhelds (MC9300 Models) | HP Series 1000-4000 (HandPunch Biometric Hand Scanner Time Clock) | Biometric Data Management | Time Keeping System Administration | TimeAdvantage Time Keeping Software | Integrating Time Clocks with Time Advantage | PING Time Keeping Software by PeopleGuru | EZOffice Inventory IT Asset Management | SpiceWorks IT Helpdesk | Windows Task Scheduler | Windows NT Services

Client-Side (frontend) Development:
PeopleCode | PeopleSoft Application Developer | JavaScript | SQR | Crystal Reports

Server-Side (backend) Development:
Java | SQL | PL/SQL | Automation | Batch Scripting | SFTP

Developer Responsibilities:
Developed and managed Oracle databases, ensuring secure and efficient data handling using PL/SQL, SQL Plus, and Oracle SQL Developer.
Designed and customized PeopleSoft ERP applications and automated processes using PeopleSoft PeopleTools, PeopleCode, and SQR, enhancing operational efficiency.
Administered PeopleSoft Process Scheduler and EDI Manager to streamline job management and data exchange for HCM/SCM systems.
Leveraged Oracle VM VirtualBox and SFTP for server-side development and virtualization, supporting cloud-based infrastructure needs.
Designed automated reports using SQL queries, SQR, and Crystal Reports, with task scheduling through Windows Task Scheduler.
Served as Administrator for the Time Keeping System (TMS), managing employee hours using HandPunch 4000 Biometric Time Clocks and integrating time punch data into PeopleSoft HCM via SFTP.
Facilitated secure timekeeping system administration, overseeing employee profiles, biometric data, and clock-in/out setup while adhering to cybersecurity and data privacy regulations.
Played a pivotal role in data recovery and compliance efforts during a legal settlement involving Illinois 740 ILCS 14 (BIPA), ensuring secure handling and destruction of biometric data stored in Time Advantage, Ping, and HandPunch 4000 Biometric Time Clocks.
Project Manager of the IT Asset Inventory Management System
Manage Database and IT Assests
Administrator of the Time Keeping System (TMS)
Tracking employee’s hours worked.
Database and application management
Employee hours and time punch information tracked using Time Advantage and HandPunch 4000 Biometric Time Clocks
Hours were imported using PeopleSoft EDI Manager via SFTP and stored in Oracle Database for the PeopleSoft ERP HCM
Each distribution center had a HandPunch 4000 Time Clock, and these timeclocks could be updated remotely through a daisy-chain network structure using TCP/IP via a polling process when new hires started, or current employees were terminated.
These Time Clocks record a geometric image of a person's hand and converts that into a UID or Unique Identifier which is stored as Biometric Data on the reader or internal memory of the HandPunch 4000 unit. That information is not stored on the server, vendor application, nor any database.
Manage the Hand Reader Timeclocks (HP 4000 series), employee database, and time keeping software Time Advantage and Ping, e.g., assigning perimeters for mobile clock in or setup of both new hires and terminated employee profiles including biometric data.
Mediate business, functional, and technical requirements and meet with executive staff to discuss business solutions within the Oracle tech-stack: SQL Developer, PeopleSoft Application Designer, Oracle DB, e.g., played a major role in data recovery pertaining to a legal settlement regarding the Illinois 740 ILCS 14 or BIPA (Biometric Information Privacy Act).
Database management
PeopleSoft Application design and testing for configuration and customizations.
Record and extract transaction data and create business documents via PeopleSoft EDI Manager
Manage processes and jobs via PeopleSoft Process Scheduler.
Design new and modify existing reports using SQL queries, SQR, and Crystal Reports.
Develop batch files to run reports on a schedule with Windows Task Scheduler. These scripts contained commands to run the SQR reports with the appropriate flags.