Cruz Macias
Oracle Cloud Developer | Integration and Application | Computer Science, Master of Science with a Concentration in Cybersecurity & Digital Forensics (M.S.) | Bachelor's Degree in Mathematical Sciences with Emphasis in Applied Mathematics and Minors in Computer Science and Anthropology | Graduate Certificate in Cybersecurity and Digital Forensics | Certifications by Oracle University
Disclaimer(s):
Statement of Copyright Protection
Content Disclaimer and Limitation of Liability
Greater Lexington Area, KY USA
Listen to Audio Summary of Cruz Macias Teaching CV (Higher-Ed)
Listen to Audio Summary of the Personal Testimony and Statement of Faith of Cruz Macias
Read Personal Testimony and Statement of Faith
GitHub Repo: Coindesk Java Project
GitHub Repo: Bitcoin API Python Application
GitHub Repo: Suno AI API Gospel Music Generation Python Applications
GitHub Repo: Student Grade Management System .Net Application
Project Euler Solutions
Project Euler Profile
Papers in Cybersecurity and Digital Forensics
Listen to my New AI-Powered Podcast Series: Papers in Cybersecurity & Digital Forensics
Technical & Programming Skills
SQL
Python
C
C++
Java
JavaScript
RESTful APIs
SOAP APIs
JSON
XML
HTML5
CSS
C#
.Net
LAMP Tech-Stack (Linux, Apache, MySQL, PHP)
Oracle Tech-Stack: PeopleSoft, PL/SQL, Oracle DB 10g, 11i, 12c, Java, JDK 11+, ATP Database, SQR, SQL Developer, Primavera P6, Oracle Integration Cloud OIC, Oracle Cloud Infrastructure, Oracle Cloud ERP/Fusion Applications FIN/HCM/SCM, EDI, FBDI, EPM Automate, Oracle (Enterprise Scheduler) ESS Job, and Oracle BI Publisher
Microsoft Tech-Stack: SQL Server Management Studio, Windows NT Services, Visual Studio, Visio, and Microsoft Project
Google Tech-Stack: Google DialogFlow, and Java
Windows CMD (.bat)
BaSH (.sh)
CygWin
nano
vim
Linux Command-Line Tools (CLI)
Ubuntu Linux OS
UNIX
R and RStudio
VMWare
JDK 11+ and JRE
Postman and SoapUI
Swagger and OpenAPI
GitHub, Git, Git Bash, and Git SCM
Network Protocols (SFTP, SSH, HTTP, POP3, TCP)
FileZilla, PuTTY, and Moba XTerm
OOP
AGILE
RDBMS
UML and DFDs
Regular Expressions
On-Premise, PaaS, and SaaS models
IT Audit and Change Management Processes
Cybersecurity and Digital Forensic Software Tools: AccessData FTK Imager, Access Data Forensic Tool Kit 5.7, Exterro Password Recovery Tool Kit, Snort, Volatility, Wireshark, Redline Data Collector, Redline Data Analysis, Redline Endpoint Security Tool, DCode, DumpIt, AccessData Registry Viewer, Event Viewer, CodeMeter, and WinHex
Data Collection CLTs: systeminfo, net, ipconfig, route, arp, netstat, and tcpdump
Software Design and Project Planning: Polar Graphs, Payoff Matrix, Waterfall Process Model, Formal Requirements Gathering (BRD, FRD, and TRD), Project Scheduling (PERT and Gannt Charts), Basic and Intermediate COCOMO, Function Points Method, DFDs (Data Flow Diagrams), Schema Design and RDBMS Relational Decomposition: 1NF, 2NF, 3NF, and BCNF, Create Software Metric Procedures for Measuring Software Features, Develop Structure Charts for Architectural Design, Design Algorithms using Decision Trees and Tables to solve Computing Problems, and Create Formal Procedures for Software Configuration Management Items
SQA (Software Quality Assurance) Activities: Requirements Analysis, Test Planning, Test Case Development, Test Execution, Defect Tracking, Code Reviews, Compliance and Standards Checking, Configuration and Release Management, Performance and Security Testing, Usability Compatibility Testing, Training and Skill Development, Process Improvement, Risk Management, Documentation Management, Conducting Audits, and Confirming Development and Documentation Standards.
Languages
English
Work Experience
IT Programmer Analyst (Oracle Cloud Developer - Integration and Application) / 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 Premise | Oracle Database 19c Administration and Security | Oracle SQL Developer | Oracle Cloud ERP SaaS Model | Oracle Fusion Cloud Applications: FSCM, HCM, and SCM | Oracle Visual Builder Cloud Service (VBCS) | Oracle BI Publisher Interfaces and Data Modeling | Oracle Cloud FBDI Procurement and Financials (FSCM) | Oracle BI Intelligence Supply Chain Solutions | Oracle Integration Cloud (OIC) PaaS Model | RESTful and SOAP Webservice APIs | Oracle Process Analytics | Oracle Enterprise Scheduler (ESS) to run Java, PL/SQL, and binary process jobs | Oracle Cloud Infrastructure (OCI) Compute Instances and Virtualization IaaS Model | EPM Automate
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 | PaaS and SaaS models | RESTful and SOAP APIs | XSL and XSLT (Data Formatting and Schemas) | Cygwin POSIX Linux Distribution for CLTs (Command-Line Tools) | JRE (Java Runtime Environment) | JDK 11+ | Linux Process Scheduler | Windows Task Scheduler
Client-Side (frontend) Development:
JavaScript | JSON | XML | CSS | HTML5
Server-Side (backend) Development:
XML (Standard Format Data Transfer via SSH/SFTP and both REST/SOAP APIs) | File-Based Data Import (FBDI) | SQL | Oracle SQL Developer | Java | C | Python | JSON | JavaScript | Process Management | Service Management | Batch Scripting | Shell Scripting (BASH) | Job Management | SFTP | TCP | PGP | SSH Remote Connection via IP (Linux Virtual Machine) | RESTful API | SOAP API | XSL | XSLT
Developer Responsibilities:
Design, develop, and support Oracle Cloud architectures, focusing on data exchange, integration, and reporting for Oracle Cloud ERP, Oracle Cloud Infrastructure (OCI), Fusion Cloud EPM, EPM Automate, and Oracle Visual Builder Cloud Service (VBCS) across Finance, Supply Chain (SCM), and HR (HCM) Oracle Fusion Cloud Applications and Modules utilizing ESS Job Scheduler and FBDI.
Build and maintain integration endpoints using Oracle Integration Cloud (OIC), VBCS, and Oracle BI Publisher leveraging RESTful APIs, SOAP, and SFTP protocols working with multitenant architectures such as Oracle ATP Database and Oracle Database 19c developing source code in PL/SQL, Java, and Python utilizing CLTs for Windows Batch, Unix Bash, and SQLcl.
Develop and manage complex reports using Oracle BI Publisher, employing SQL, XML, JSON, and XSL/XSLT for template customization and data transformation.
Implement cloud security measures aligned with FedRAMP, PCI DSS, and NIST standards, participating in IT auditing, change control, and project management processes using DFDs, PERT/Gantt charts, and COCOMO.
Conduct QA and testing using JUnit, Maven, and Oracle Application Testing Suite to ensure reliability and performance across cloud platforms.
Utilize Oracle Cloud ERP in SaaS, OIC in PaaS, and OCI in IaaS models to manage and optimize business processes.
Independently design, code, and support various computer applications and systems: OIC (Oracle Integration Cloud), OCI (Oracle Cloud Infratructure), Oracle BI Publisher, Oracle ATP Database, EPM Automate, Oracle Cloud ERP Fusion FIN/HCM/SCM Applications.
Work with end-users to define information flow, reports, and data requirements.
Write and review specifications, develop and document operational procedures, test software and coordinate software installations.
Define and validate system requirements including hardware and software requirements.
Work with vendors to mitigate functional and technical requirements for various products and services to be integrated.
Design comprehensive logical and physical databases, tables, and interfaces.
Develop XSL and XSLT stylesheets and Oracle BI Publisher Extract Formatting Layouts and Templates to translate XML source data into the following formats: HTML, XML, and Text.
Develop new and modify existing data models and SQL queries for data models withing Oracle BI Publisher for various outbound interfaces and integrations.
Develop, test, and migrate various Oracle Integration Cloud integrations and Oracle BI Publisher reports and interfaces to and from DEV, TEST, and PROD instances.
Build web applications via Oracle VBCS to enable start/stop of integrations in OIC
Create and Maintain Lookup Tables for various Data Models and Implementations.
Draft, Manage, and Review Lean Specifications for a multitude of Integrations (both outbound and inbound), Reports, Fast Formulas, Jobs, and Interfaces (both outbound and inbound).
Perform unit, integrated, and functional testing and QA for various applications, integrations, implementations, and interfaces.
Investigate, troubleshoot and determine root cause for support issues in IT, Integrations, Interfaces, and Implementations.
Maintain and execute system database corrections.
Monitor, run, maintain ad hoc production jobs, report routing, and end-user access.
Monitor and maintain nightly processes and operations and nightly report logs.
Independently perform complete testing of software and validate system requirements including data and code verification.
Independently develop and perform comprehensive test plans including data reasonability and code verification.
Independently develop complete systems documentation
Develop and maintain Oracle BI Publisher extracts and interfaces
Develop both code and scripts
Develop database and table definitions and UI design and setup
Design and develop contingency plans.
Provide IT support and training documentation for technical staff.
Coordinate with team members, vendors, and end users and provide effective written and verbal communication to address various projects and issues.
Consult with Project Managers, IT Staff, End-Users, and Vendors in various Workflows and provide mentorship when needed.
Participate in Annual IT Auditing handled by a third-party firm, Deloitte, which tests for Federal Risk and Automation Management Program (FedRAMP), PCI DSS (Payment Card Industry Data Security Standard), National Institute of Standards and Technology (NIST), and International Organization for Standardization (ISO) Compliance.
Member of the Application Change Control Board (ACCB), an internal auditing group that meets weekly to help test and maintain industry standards compliance (NIST, ISO, FedRAMP, …, et cetera) for code changes, system-wide updates, and application migrations by enforcing a strict workflow of functional and technical requirements, unit and integrated testing documentation, developer to developer Quality Assurance (QA), and owner approval.
Maintain, follow, and document change control security processes and operational procedures for all changes made to system components during the development cycle as per the Cloud Security Alliance (CSA) and Security Trust Assurance Registry (STAR).
Complete QA for various projects and assignments throughout the business including data analytics/business intelligence data modeling, HCM reporting, SCM reporting, FSCM Reporting, and code changes to interfaces and integrations in both SAAS and PAAS models, Oracle Fusion ERP App and OIC, respectively, and in programming languages such as SQL, XSL, XML, Java, JavaScript, and Batch, ATP Database Modifications for Stored Procedures, Tables, and Views, Connections for SOAP and REST Webservices among other APIs, and SFTP Server Structure and Hierarchy.
Oracle Enterprise Performance Management (EPM) Cloud, EPM Automate, PaaS solution: monitor various batch scripts using Windows Task Scheduler on several cloud servers via Remote Desktop Protocol (RDP), troubleshoot and execute jobs when failed, execute scripts and setup job schedules, manage login credentials and generate and encrypt key files via EPM Automate CLTs which use TLS with SHA-256, debug and code existing batch scripts using the epmautomate CLT, develop new EPM Automate scripts for various business needs.
EPM Cloud Service Administrator and Developer: Familiar with EPM Automate command-line tools, scripting, and server management.
Update and Manage Oracle BI Publisher bursting queries for various OB interfaces, manage SFTP connections and promote AD Groups and rwx permissions for specific directories for both users and interfaces, and maintain Lookup Types and Codes for various bursting paths, manage bursting queries to submit files via sftp for various vendors and application integrations in the following file formats, JSON, XML, CSV, TSV, TXT, RTF, and more.
Manage and develop cloud integrations in OIC to consume, translate and parse file data for submission to various endpoints in both PaaS and SaaS models such as Oracle BI Publisher, Oracle Cloud ERP Fusion Applications for FSCM, HCM, and SCM, Oracle EPM Cloud, Oracle Integration Cloud, and Oracle ATP database via RESTful API, SOAP Web Service, and Database Connections.
Completed multiple Sprint initiatives to improve the business in both savings and functionality for various integrations and interfaces.
Develop UML Diagrams for various Oracle integrations and interfaces to communicate the flow of data and functional use cases to the business.
Complete Technical requirements for specification documentation and assist functional users with completing functional requirements.
Develop Gantt and PERT Charts to assist with allocating project resources and determining critical paths for project tasks.
OIC Developer (Oracle Integration Cloud): Manage, troubleshoot, and develop REST API, SOAP Web Service, and Database connections, endpoints, request methods (GET, POST, PUT, and DELETE), and SQL Statements (Update, Insert, Select) for various integrations in the SaaS and PaaS models to communicate with and send and retrieve data to and from, respectively, Oracle Fusion Cloud ERP, Oracle BI Publisher, Oracle ATP Database, Tecsys, and various other applications
Develop, test, and debug applications: Unit Testing, Integrated Testing, QA, Migration.
Prepare and present to the business development project status, trajectory, and outcomes. Prepare and present training modules.
Monitor interfaces and integrations specifically between Oracle and Tecsys. Troubleshoot errors when they occur. Correct errors when applicable. Devise works flows for addressing these issues. Share these steps with other IT staff members.
Endpoint Solutions SME (Subject Matter Expert)
Maintain relationships with vendors to resolve integration and system errors and end-user reported issues.
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:
/students.edu/public_html/~csc118site/ - Responsive Web Design with HTML5 & CSS Course Website (Apache Web Server)
/github.repos/public/~cmathgit/ - GitHub Repositories
/w3spaces/public_html/~cruzmacias-cv - W3Spaces Web Desing 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.
Computer Software Specialist / Americana Financial Group (formerly Krikie & Associates Incorporated)
Batavia, IL
Contract Position
May 2016 - Sept 2017
Develop training protocols on and instruct agents in using the software known as Wealth Building Cornerstones: on-site bi-weekly 4 hour meetings.
Tutoring Center Supervisor (Mathematics and Computer Science) / Access P.A.L. of Northern Illinois University
DeKalb, IL
Full-Time Position
Sept 2013 - Sept 2017
Provided tutoring in computer science courses, including C++, Java, and UNIX programming, along with concepts in relational database, data structures, algorithms, and network programming. Tutored students in mathematics, including all levels of calculus, differential equations, and senior-level courses such as real analysis, abstract algebra, and complex analysis. Supervised and trained staff while managing operations of the tutoring center, ensuring efficient service and support for students. Conducted application testing for PeopleSoft customizations, ensuring system functionality and performance. Assisted with data management tasks. Data management. Application testing for PeopleSoft customizations Supervise/monitor tutoring center Tutor both mathematics and computer science/programming undergraduate courses Train, evaluate, and promote staff. Resolve issues with a group of leaders. Computer Science subjects tutored: Intro. to C++, C++ (Intermediate Programming) C++ (Data Structures and Algorithms) Java I and II UNIX and Network Programming Relational Database Concepts
Mathematics Tutor / Learning Skills Center of Kishwaukee College
Malta, IL
Part-Time Position
Sept 2010 - May 2012
Provided tutoring in a wide range of mathematics subjects, including Calculus, Differential Equations, and Linear Algebra, helping students enhance their problem-solving skills. Assisted students with complex topics like Real Analysis, Abstract Algebra, and Mathematical Modeling, fostering advanced analytical thinking. Supported students in developing mathematical proofs and logical reasoning through courses such as Mathematical Proofs and Logic. Helped students apply mathematical concepts to practical problems, particularly in Statistics with Calculus and Finite Mathematics, laying a foundation for future applications in data analysis and cloud computing. Tutor students in mathematics and various general education courses. Mathematics subjects tutored: Elementary Math (K-12 & GED) Algebra (all levels) Geometry (all levels) Trigonometry Calculus (all levels) Differential Equations (Ordinary and Partial) Linear Algebra (all levels) Abstract Algebra (all levels) Statistics with Calculus Discrete Mathematics Finite Mathematics Mathematical Modeling Complex Analysis Real Analysis I and II Mathematical Proofs and Logic.
Education & Certifications
Computer Science, Master of Science with a Concentration in Cybersecurity & Digital Forensics (M.S.)
Eastern Kentucky University, Richmond, KY
Graduated Fall 2023
Graduate Certificate in Cybersecurity and Digital Forensics
EKU GPA 3.57
EKU was Ranked #8 of 12 in best online master’s degree programs in computer science by Fortune Education in 2023.
The methodology for ranking included three scoring components:
· Success
· Selectivity
· Demand
Relevant Coursework (*Transferred Credits from NIU):
CSC 835 - Project Management
*CSC 834 - Software Engineering
*CSC 831 - Databases & Algorithms
*CSC 825 - Network Applications & Security
CSC 815 - Computer Administration & Security
CSC 737 - Incident Response II
CSC 736 - Incident Response I
CSC 744 - Database Administration & Security
CSC 730 - Programming and Data Structures in Java
INF 718 - Principles of Cybersecurity
Diploma, Unofficial Graduate Transcript, and Certificate available upon request
Bachelor's Degree in Mathematical Sciences with Emphasis in Applied Mathematics
Northern Illinois University, DeKalb, IL
Graduated Spring 2016
Minor Concentration: Computer Science
Minor Concentration: Anthropology
NIU GPA 3.0
Relevant Coursework (*Transferred Credits from KISH, NCC, or SIUC):
MATH 421 - Abstract Algebra II
MATH 420 - Abstract Algebra I
MATH 431 - Advanced Calculus II
MATH 430 - Advanced Calculus I
MATH 423 - Linear & Multilinear Algebra
*MATH 442 - Elementary Partial Differential Equations
CSCI 466 - Databases
ANTH 440 - Fossil Humans
ANTH 446 - Osteology: The Human Skeleton
*MATH 336 - Ordinary Differential Equations
MATH 360 - Model Building in Applied Mathematics
*STAT 350 - Probability & Statistics with Calculus
CSCI 340 - Data Structures & Algorithm Analysis
CSCI 330 - UNIX & Network Programming
*ANTH 341 - Primatology
ANTH 363 - Globalization & Corporate Cultures
MATH 240 - Linear Algebra
*MATH 232 - Calculus III
*MATH 230 - Calculus II
*MATH 229 - Calculus I
CSCI 241 - Intermediate Programming in C++
CSCI 240 - Computer Programming in C++
*PHYS 253 – Fundamentals of Mechanical Physics w Calculus I
*ANTH 240 - Physical Anthropology
*ANTH 210 - Archaeology
*HIST 261 - American History After 1900
*PHIL 100TR - Existentialism
*PHIL 231 - Ethics: Contemporary Moral Issues
*THEA 203 - Theatre
Diploma and Unofficial Undergraduate Transcript with graduate credits available upon request
Associate of Science
Kishwaukee College, Malta, IL
Transferred to a Four-Year University, North Central College, Summer 2011
Kish GPA 4.0
Completed all requirements for the Associate of Science.
Completed General Education and Mathematics courses towards the Associate Diploma.
Graduate Certificate in Cybersecurity and Digital Forensics
Eastern Kentucky University
December 2023
Online Degree Program
Certificate available upon request
Master Tutor Certificate / College Reading & Learning Association
Northern Illinois University
April 2014
College Reading & Learning Assoc. ITTPC
Certificate available upon request
PeopleSoft People Tools I Rel. 8.55 Ed. 1 LVC / Oracle University Training Class (35 CPE Credits)
Oracle University Training Class
July 2018
Live Virtual Course: Certificate of Completion May 2018
PeopleSoft People Tools I Rel. 8.55 Ed. 1 LVC | Enrollment ID: 8727562
35 CPE Credits ($4.4K in value)
Certificates 1 and 2 available upon request
PeopleSoft People Tools II Rel. 8.55 Ed. 1 LVC / Oracle University Training Class (35 CPE Credits)
Oracle University Training Class
July 2018
Live Virtual Course: Certificate of Completion July 2018
PeopleSoft People Tools II Rel. 8.55 Ed. 1 LVC | Enrollment ID: 8795031
35 CPE Credits ($4.4K in value)
Certificates 1 and 2 available upon request
Dell Certified Systems Expert (DCSE)
Southern Illinois University
December 2020
Dell Technologies Certified Client Course 2019
Certificate available upon request
Extracurricular Programming Projects
Academic Endeavors
Applied Research Consultant & R Programmer / Southern Illinois University Carbondale - College of Business & Analytics
Carbondale, IL
Contract Position
Spring 2022
Technology and Methods:
Python | RStudio | R | Data Frames | Linear Regression | SPSS Statistical Tool | Database Management | SQL | CSV Containers
Researcher Responsibilities:
Assisted Dr. Tahia Alam with research methodology and theory development for her dissertation manuscript on Conservation of Resource and Scarcity Theory perspectives.
Formulated research and linear regression models using R programming language.
Reformatted datasets from results collected into appropriate formats, e.g., CSV.
Imported datasets into various data frames within R.
Performed Selection Queries on the datasets within R using Relational Algebra techniques.
Constructed output tables of results for review.
Confirmed hypothesis 1 using linear regression on COVID-19 triggered Psychological Distress (C19-PD) and Work Engagement (WE) variables generating a beta coefficient evidencing that C19-PD negatively impacted WE.
Developed summaries of various attributes (variables) within each dataset.
Serving the Lord & His People
*Disclaimer: Believers in Christ are called to serve the Lord and His church with all their hearts; an act of their own volition. Though I do not advocate using the term "volunteer" to describe service work in the church, servants of the Lord are instruments of God's will and not a title of nobility (1 Peter 2:16), I choose this adjective to clarify for employers that the roles I have adopted over the years and will continue to pursue are non-profit efforts without pay. These efforts do not and will not compromise my commitment as an employee to a given organization. This disclaimer is meant to eliminate any concern of moonlighting or conflict of interest.
"Take heed therefore unto yourselves, and to all the flock, over the which the Holy Ghost hath made you overseers, to feed the church of God, which he hath purchased with his own blood" [Acts 20:28]. "For, brethren, ye have been called unto liberty; only use not liberty for an occasion to the flesh, but by love serve one another" [Galatians 5:13]. "And whatsoever ye do, do it heartily, as to the Lord, and not unto men" [Colossians 3:23]. See Matthew 25:40, John 13:14-15, Galatians 5:13, Ephesians 6:6-7, Colossians 3:23, and Acts 20:28.
King James Version (KJV)
Public Domain
Small Groups Leader / Cornerstone Church
Marion, IL
Aug. 2019 - Dec. 2019
Volunteer Service: Host of the Open-Mic Worship event. Hosted an Open Mic Worship service bi-weekly for the Fall 2019 semester. Designed, hosted (server), and implemented event web-page using HTML (CSS).
Worship Team Member / Redemption Community Church
Belleville, IL
Jan. 2020 - Jun. 2021
Volunteer Service: Play bass and acoustic guitars for the Worship Team during services.
Music Ministry Team Member / Harmony Freewill Baptist Church
Johnston City, IL
June 2021 - June 2022
Volunteer Service: Play acoustic guitar and harmonica and sing in the choir for specials and during service.
Bible Study Host and Web Developer / EBS Ministries
Remote
July 2022 - September 2024
Volunteer Service: Develop and manage the EBS support site, develop bible study lesson plans, and host a weekly small group meeting on Zoom.
/w3spaces/public_html/~ebsministries/ - EBS Ministries Website