Job Description

1. Key Result Areas

What does the job need to deliver? How is it measurable?

Individual performance measures (KPIs) required of the job that align with company goals and ensure accountability for the delivery of measurable results and clear linkage to the Performance Management Process (PMP)

Keys Results (KPI’s)

Result Measurement (Metric)

Delivery of timely and cost effective IT solution that meets business requirements

Variance of schedule (planned versus actual) within 5%

Meet or exceed stated business objectives in terms of system requirements, module timeline and scope of work

Variance of schedule (planned versus actual) within 5%

Manage Service Level Agreement (SLA) and Application Maintenance Service (AMS) of outsourced vendors

All reported incidents are closed and all assigned enhancements are completed as specified in the SLA

Manage and control project budget

Variance of schedule (planned versus actual) within 5%

1. Key Accountabilities/Job Duties (6 –7 items)

Asterisk (*) essential functions & assign % of time to each function listed (Job duties should be listed in order of importance with essential (most critical and largest % of time) first and marginal duties last; Total % of time to equal 100%). Minimum % of time for accountabilities/job duties is 10%.

KEY ACCOUNTABILITIES/JOB DUTIES

% OF TIME

Work with business management to align with business direction and address all escalations 20%

• Application Support
• Ensure application security, audit and process compliance for systems in managed project, support and enhancements
• Ensure Subject Matter Experts(SME) for the supported application systems are available
• Ensure 24 x 7 applications availability and applications performance

30%

• Software Development
• Performs or Assists in solution design, configuration or development and unit testing for new projects and enhancement requests
• Track and monitor enhancement and support deliverables by service providers (e.g. AMS) as specified in the SLA
• Track and monitor project deliverables by product team as per agreed timeline

50%

STATEMENT OF OTHER DUTIES

“This document represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. It should be understood, therefore, that incumbents may be asked to perform job-related duties beyond those explicitly described.”

1. Reporting relationships:

Supervisor, dotted line reporting, direct reports, indirect reports, key peers

Reporting Relationship

Title(s)

FTE’s

Immediate Manager/Supervisor

Manager, Visibility and Reporting

Dotted Line

As assigned

Direct Reports (titles and quantity)

Developers and Analysts

0

Indirect Reports

As assigned

0

Key Peers

Application teams

Technology Solutions

Internal APLL operations

Please attach (or paste below) the supporting organization chart with the job description.

1. Key Internal/External Relationships– who, why, how often

(Do not include routine supervisor/subordinate communications)

Who (Internal or External)

Why

How Often

Product Owners and Business stakeholders

(Internal)

Review requirements sign off, user acceptance testing, enhancement prioritization and status reporting

Weekly / Ad-hoc basis

Application team

(Internal

Project, enhancement or support discussion or review

Weekly / Ad-hoc basis

Outsourced Vendors

(External)

Project, enhancement or support discussion or review

Weekly / Ad-hoc basis

1. Typical problems and decisions required

What is the level of the problem solving and independent judgment?

What sorts of problems are typical for the job?

What decisions are required and what references/guidelines are used?

What decisions are required to be referred to supervisors?

Business process and application design challenges

Matters related to current business operating procedures, workflow and exceptions: - including change of business work processes, systems and ensuring successful implementation

Decisions that will have a direct or indirect positive or negative impact on the Line of business, regions for work processes and systems

Process and system gaps identified based on business goals Manage gaps and identify workaround or process change required to support operations excellence Management of project resources and timelineVendor management and identifying ways to keep project on schedule with assigned project resources

Change of scope

Delay/change in timeline

Require extra project resource

1. Descriptive Quantitative Data

Budget size/ sales targets (US$)

(please provide data specific to the position and/or Country/region/function where the position reports into)

Review

Position

Country/Region/Function

Project Cost (Expense)

Between 100K to 500K

Global

Geographic reach/span

Global

Education/Experience, skill sets, desired competencies;

Show which are ‘required’ and which are desired or nice to have.

Required Education

Degree in Computer Science or related disciplines or equivalent work experience

Experiences

Must Have

• Need to have 6+ years of Application development experience
• Strong proficiency in Oracle 12c/19c, PL/SQL
• Experience with good Programming & Development (Packages, Procedures, Functions, Triggers
• Collections, Bulk Processing, Dynamic SQL)
• Experience in Performance Tuning (SQL Tuning, Execution Plans, AWR/ASH Reports, TKPROF, Query Optimization
• Partitioning)
• Experience on Project management using Agile methodology

Good to Have

• Experience with message brokers (Kafka)
• Experience with Data Integration & ETL (Informatica PowerCenter
• ETL Design & Development
• Data Warehousing
• BI File Generation
• Flat File Processing)
• Experience in Python.

Skill Sets

• Process driven with ability to interact with business users to gather business requirements and confirm solution design
• Ability to analyze business requirement and transform into system process
• Working Knowledge in freight forwarding / consolidation and/or 3rd Party Logistics industry will be advantages, particularly in ocean freight.
• Hands-on approach to problem solving, attention to detail and creative solution design
• Team player and able to manage in diverse workforces
• Superior presentation and communication skills, both written and oral

Language Skills

• English

1. Physical Attributes and Working Conditions

Physical effort/mobility and special working conditions required;

Each line should include specificity, intensity under working conditions and, by use of the codes, frequency, and duration noted below.

Frequency Codes

R = Rarely (less than 0.5 hours per day) C = Continually (5.6 - 8.0 hours per day)

O = Occasionally (0.6 - 2.5 hours per day) N/A = Not Applicable

F = Frequently (2.6 - 5.5 hours per day)

Describe all physical requirements to be performed based on “essential” duties described in Key Accountabilities/Job Duties. (If normal physical efforts only, please note “Normal office physical efforts”)

Physical Attributes:

Frequency code:

N/A

Describe any conditions of the physical environment which an employee in this job may find adverse, unpleasant or hazardous.

Work Conditions:

Frequency code:

Travel up to 20% of the time