Skip to main content
Alfred Orcajo

Alfred Orcajo

Senior System Engineer / Senior Oracle Developer / Application Development Analyst

Talent
PasigMember since November 13, 2026
Microsoft SQL ServerMySQLSybase ASEOracle 11gOracle 8Macromedia Flash MX(AS2.0)Visual Basic 6.0HTMLCSSJAVA/JavascriptTurbo CLinuxWindows Server 2003 R2 IISC#Powerbuilder 12.0 Web Service DatawindowODBCSOAPPythonFlaskrestful APIPostgrespgadminpsycopg2KubernetesDockerpostmanOracle – PL/SQLReactNode.jsJava
·

Hire this person

Send a job offer directly to this candidate

Microsoft SQL ServerMySQLSybase ASEOracle 11gOracle 8

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)

Reviews

Related