Clifford Dela Cruz

Senior System Engineer (January 2023 - Present)

• Collaborate with stakeholders to gather requirements and conduct system analysis to understand business needs, ensuring alignment with project objectives and technical feasibility.
• Employed project management methodologies to oversee end-to-end data engineering as well as ERP and CRM projects, resulting in on-time delivery and adherence to quality standards.
• Conducted thorough data profiling and data quality assessments to identify data issues and implement data cleansing strategies, improving overall data accuracy.
• Knowledgeable in Data Warehousing, with experience in enhancing and troubleshooting ETL process. Knowledgeable in the following: SAP BODS Data Services Designer, SAP Data Services Designer.
• In charge of data ingestion of CRM system, creates stored procedures and automation scripts to upload data and PDF files.
• Uses SQL (Microsoft SQL, MySQL, Oracle SQL Developer) to support different systems in Canon.
• Knowledgeable in using Microsoft PowerBI. Supported Data Analysts to connect through different data sources using Microsoft PowerBI.
• Knowledgeable in Microsoft Azure as currently managing the project in E-Business portal system migration from on-prem to cloud.

Handled different projects from initiation to closing and landing which includes: communication with stakeholders, gathering requirements, creation of requirement specifications to developers, testing and documentation.

Several projects include:

1. Implementation of Data Auto replication across the region. This provides a more up-to-date data to Business Users.

2. E-Business portal data sending to Google Analytics 4

3. Enhancements in SSRS reports

4. Enhancements in Service Data Warehouse.

System Engineer (July 2017 – December 2022)

• Collaborate with stakeholders to gather requirements and conduct system analysis to understand business needs, ensuring alignment with project objectives and technical feasibility.
• Employed project management methodologies to oversee end-to-end data engineering as well as ERP and CRM projects, resulting in on-time delivery and adherence to quality standards.
• Conducted thorough data profiling and data quality assessments to identify data issues and implement data cleansing strategies, improving overall data accuracy.
• Knowledgeable in Data Warehousing, with experience in enhancing and troubleshooting ETL process. Knowledgeable in the following: SAP BODS Data Services Designer, SAP Data Services Designer.
• In charge of data ingestion of CRM system, creates stored procedures and automation scripts to upload data and PDF files.
• Uses SQL (Microsoft SQL, MySQL, Oracle SQL Developer) to support different systems in Canon.

Handled different projects from initiation to closing and landing which includes: communication with stakeholders, gathering requirements, creation of requirement specifications to developers, testing and documentation.

Several projects include:

1. Revamp of Universal Gateway data processing from SOAP to REST API.

2. Enhancement of E-Business portal

3. Development of API for Web application service to connect to service system.

4. Revamp of Taiwan invoice generation to be government compliant. 5. Data migration projects.

System Analyst (August 2012 - June 2017)

Supports, monitors and handles different systems such as Canon Retail system (Customer Delight Services System), as well as Canon iOS applications (Mobile Field Service, Mobile Meter Reading) utilized by 6 countries under Canon Marketing Asia (Singapore, Malaysia, Philippines, Thailand, Hong Kong and Taiwan Supported Retail system previously used by Canon (RAMBO). This involves:

· Performing system enhancement and new development requested by Business users

· Handled support for issues related to EDI and troubleshoots issues related to data sending/receiving to 3rd party logistics.

· Used AS/400, RPG III, RPG ILE, SQL RPGLE, CL/CLLE, SQL DB2 for system support and program development.

Writes technical specifications based from received business requirements. Ensures all raised system enhancements are tested and ready to be deployed within given timeline.

Analyst Programmer (Sep 2011 - July 2012)

Supported Retail system previously used by Canon (RAMBO). This involves:

· Performing system enhancement and new development requested by Business users.

· Handled support for issues related to EDI and troubleshoots issues related to data sending/receiving to 3rd party logistics.

· Used AS/400, RPG III, RPG ILE, SQL RPGLE, CL/CLLE, SQL DB2 for system support and program development.

Writes technical specifications based from received business requirements. Ensures all raised system enhancements are tested and ready to be deployed within given timeline. Implemented legacy system (RAMBO) to Canon Marketing Vietnam which required data analysis, operation analysis, user training, user support and modification to suit their current practice.

Managed in-house Computer Integrated Manufacturing system throughout SDLC and collaborated with team members for system development and enhancement. This involves:

• Providing immediate support to prevent operation downtime.
• Tuned system features to meet business user demands and hardware limitations; Tested coded program routines and made revisions to eliminate errors. Conducted user acceptance test with floor supervisors to ensure requirements are met.
• Performed software system testing and validation procedures, programming and documentation; Produced clean, error-free code to meet aggressive timeline.
• Used AS/400, RPG III, RPG ILE, SQL RPGLE, CL/CLLE, SQL DB2 for system support and program development.

Worked under US Client Regis Corporation to perform the following tasks:

• Enhance programs according to requirement specifications set by Business Analyst
• Prepared documentation for programs enhanced
• Assisted in system testing with System Analyst
• Used AS/400, RPG III, RPG ILE, SQL RPGLE, CL/CLLE, SQL DB2 for system support and program development.

Deployed in AMKOR Philippines, A semiconductor company to perform the following tasks:

• Involved in AS400 to SAP implementation and contributed to system go live.
• Wrote programs according to requirement specifications set by Business Analyst.
• Wrote programs in RPG, RPGLE, CL, CLLE.