Alfred Orcajo
Senior System Engineer / Senior Oracle Developer / Application Development Analyst
Hire this person
Send a job offer directly to this candidate
About
I am confident that my employment history can compensate with other bachelor's degree and in industrial arena.I am able to prove with my character that I can be flexible in handling whatever task that I am assigned in.I can perform strategic ways and can find fast solution to unexpected situations.Above all, I maintain integrity and discipline upon aspiring my vision and objectives in life.
Experience
Part-time job (WFH – Work from home) at CloudReady Group Inc. (2022-06 – 2022-09)
Programming: Python, Flask, restful API, Postgres, pgadmin, psycopg2, Kubernetes, Docker, postman.
- Login Authentication, Reset password.
Part-time job (WFH – Work from home) at MAS Technologies LLC (2022-06 – 2022-08)
Programming: Powerbuilder 2022
- Powerbuilder Development in Enterprise Business System.
Senior Oracle Developer, Part-time job (Hybrid) (2025-03 – 2025-12)
Programming: Oracle
- Investigate and resolve RETEK, RSIM, POS, inventory, transfer, shipment,RMJ and interface-related issues.
- Validate inventory transactions, stock adjustments, transfers, receipts, returns, and sales postings.
- Coordinate with IT Store Support, CTS, Warehouse, and Regional IT teams for issue resolution and escalation.
- Document incident findings and maintain accurate dashboard logs for management reporting.
- Develop, enhance, and maintain Oracle database applications, PL/SQL programs, packages, procedures, functions, and triggers to support business operations.
- Support critical business systems, including Oracle Retail (RETEK), RSIM, and related enterprise applications.
- Perform root cause analysis for system incidents and provide permanent corrective actions to prevent recurrence.
- Design, optimize, and maintain SQL queries, database objects, and batch processes to improve system performance.
- Collaborate with business users, project managers, and cross-functional teams to gather requirements and deliver technical solutions.
- Create and maintain dashboards, reports, and data extracts to support business decision-making.
Senior IT Specialist at CJ Feed&Care (2025-06 – 2025-11)
Programming: Powerbuilder, Oracle – PL/SQL, React, Python, Node.js
- Take ownership of the company system - HR Management System.
- Creates another security level(AUDIT TRAIL) in Database pertaining to payroll.
- Enhance user information (LOGIN USER PASSWORD).
- Proposes a Web Application similar to current HR Management System of the company.
- Administer user access management for SAP, VPN, and CJWise systems, ensuring proper documentation, approval flow, and compliance with corporate IT policies.
- Coordinate with the global Information Security team in Korea for account creation, modification, and deactivation, including login history verification for resigned employees.
- Manage the IT Asset Accountability System, assignment, return, and audit logging, aligned with CJWise approval workflows and asset control policies.
- Provide Level 1 and Level 2 IT support for local employees, covering hardware, software, and network troubleshooting, minimizing downtime and ensuring smooth daily operations.
- Implement and monitor account lifecycle management, including timely disabling of accounts for resigned staff to ensure data security and compliance.
- Document and standardize IT processes (e.g., access request procedures, account deactivation workflows) to improve efficiency and audit readiness.
- Support and maintain company communication tools such as Zoom, Microsoft Teams, Zalo, and email systems to ensure seamless collaboration across teams.
Senior System Engineer T3 at INDRA COMPANY (2021-12 – 2025-06)
Programming: Powerbuilder, Java and Oracle – PL/SQL
- Introduces the creation of PL/SQL in the whole team.
- Optimized scripts, using PL/SQL in generating thousands/million of records.
- Application Management (L2 Support) for CMSv10.
- Perform Service Requests and Incident Management.
- Perform Problem Management.
- Provide technical expertise on CMS.
- Lead/mentor junior members in the accomplishment of operational deliverables.
- Analyze and design system and operational improvements.
- Perform duties before regular schedule as needed by the teams.
Application Development Analyst at STRADCOM CORPORATION (2013-07 – 2021-07)
Programming: PowerBuilder 7 and 12, Sybase
- Creates and edit stored procedure in Sybase (T-SQL) including triggers and sequence.
- Creates script for data validation, verification and updating records.
- Creates table in database.
- Creates/Enhance the Revenue Collection System of Land Transportation Office (LTO) in processing ePayment Fees (Process and Operation).
- Maintain and Enhance existing Core Application for Land Transportation Office (LTO).
- Participates in production validation and verification activities;
- Develops and support new tools and programs; and,
- Performs other job related tasks that may be assigned from time to time.
- Maintain Application Server/Database(Sybase) and Application(Powerbuilder 7) that generates the computer fee of all LTO offices.
- Responsible for giving support in LTO-IT System for MVRS Module
- Responsible for giving support in LTO-IT System for RCS Module
- Responsible for giving support for Daily, Monhtly and Yearly Report for Finance Department.
- Revise system codes and reports as desired for MVRS and RCS Module
- Responsible for customizing and enhancing major codes and reports for new sets of business rules
- Edit stored procedure as required by new enhancements and revisions
- Analytically test scenarios
- Retrieve data from tables as required using sql query
- Responsible for development of Change Request Forms as requested by LTO
- Responsible for giving support to MVRS and RCS Module for contineous operation and providing analytical investigation of erroneous transaction and providing solution
- Responsible for creating scripts of Service Requests for update of data in the database.
- Resposible for giving support to our finance department, kept the record of operation and processing fee in all LTO site.
Junior Programmer at HONDA CARS PANGASINAN. (2011-02 – 2013-02)
Programming: PowerBuilder 10.5, MySQL
- Development of necessary programs essentials in generating of reports.
- Any other duties that the Management may assign from time to time.
- Assist other employee for Software, Hardware and Network Concerns.
- Identify and encourage areas for growth and improvement within the team.
- Collaborate with other software developers, design, develop, test, and maintain desktop based business applications.
- Setup MySql Replication process.
- Responsible for monitoring of Internet connection from head office and its branches.
- Develops and support new tools and programs.
Education
Bachelor of Science in Information Technology – STI College- (System Technology Institute), Dagupan City (2007 – 2010)
Diploma in Information Technology – STI College- (System Technology Institute), Urdaneta City (2006 – 2007)
Bachelor of Science in Nursing – PCST - Pangasinan Colleges of Science and Technology known as PUNP, Urdaneta City (2004 – 2006)
Secondary – EVELAND CHRISTIAN COLLEGE (1999 – 2003)
Primary – SAN MATEO EAST CENTRAL SCHOOL (1992 – 1998)



