Application Developer - PL/SQL skills
Job description for : Application Developer, Credit&Collections Department
Department: Credit & Collections EMEA
Report to : Manager Project & Reporting & Support
Reporting from : None
The timely delivery of reports, analysis and projects requested by the Credit & Collections Management ,in accordance with the agreed standards. The creation of analysis on the current state, according to the received requests, proposal of reporting process improvement and analysis. Use programming technologies (Oracle SQL, PL/SQL, Oracle Application Express, etc.) to develop and/or enhance applications used by the Credit & Collections department for reporting or workflow management
The ideal candidate's would have:
Experience in Excel, VBA and business analysis (trending, predictions)- mandatory
Experience with SQL – mandatory
Experience with PL/SQL - is a plus
Experience with Oracle Database - Design, SQL Performance
Solid analytical skills and quality orientation
Ability to work under tight deadlines and prioritize given responsibilities
Experience with Linux based servers installation and administration, PL/SQL - is a plus
(a)Develops reports & internal applications for Credit & Collection department and knows when and how to make improvements and adjustments to ensure full achievement of goals
(b)Reporting on a daily, weekly, monthly and quarterly basis and delivery of information towards the management team for ulterior decision.
(c)Assists the management in forecasting the team’s and department’s objectives, being the first point of contact for all the requests related to new reports, analysis or project initialization.
(d)Builds reciprocal relationships with different parts of the business, partners and customers and participates in DPO conferences when asked by the direct manager and brings explanations and to the meeting agenda.
(e)Participates in the testing of different improvements or changes to the applications the department is working with and communicates the results by giving relevant information to their functionality. Uses best practices to drive efficiency and productivity within the team.
(f)Acts as a resource in the global projects that are related to the Credit & Collections department by providing the necessary information to the aspects related to EMEA and brings his own contribution through analysis and personal opinion, in accordance with the policies and procedures within the department.
(g)Knows and understands the policies, procedures and processes of the department;
(h)Performs any other tasks given by the direct manager, in accordance to what the activity implies and within the agreed deadline
Diploma of higher education institutions
·Advanced English Level
·Excellent computer skills (ex. MS Word, Access, Excel, Adobe, PowerPoint, and Oracle, SQL applications)
·Mathematical analysis proven abilities;
·Excellent verbal and written communication skills;
·Organized and detail oriented;
·Ability to work in a multitasking environment that implies project or task concomitant prioritization and change, often meeting tight deadlines
·Ability to maintain the delivery of tasks ,despite the tight deadlines and very demanding environment
·Ability to communicate efficiently and in a calm manner
·Ability to understand and apply C&C processes and procedure
Detailed Description and Job Requirements
Financial support to business areas through financial analysis, budgeting, planning & forecasting; to facilitate decision making and future business strategies.
As a member of Oracle's finance organization, you will be responsible for providing all aspects of financial support for planning and control. Assist in consolidation and reporting of financial results; preparation of annual budget. Gather, model, analyze, prepare, and summarize information for financial plans, operating forecasts, trended future specifications, etc.; on a weekly, monthly, or quarterly basis. Prepares recommendations based on analyzes. May perform revenue and expense analysis, headcount and headcount driven expense analysis at cost center level, tracking of product and product line revenue, reconciliation of accounts receivable, variance analysis and ad-hoc analysis as needed. You may participate in cross functional programs and projects.
Job duties are varied and complex utilizing independent judgment. May have project lead role. Strong spreadsheet skill and proficiency in Oracle Financials. Strong written and oral communication skill. Ability to work under tight deadlines. Self starter able to prioritize given responsibilities. 5 years relevant work experience. BS/BA in Accounting/Finance preferred. CPA/MBA desired.
As part of Oracle's employment process candidates will be required to complete a pre-employment screening process, prior to an offer being made. This will involve identity and employment verification, salaryverification, professional references, education verification and professional qualifications and memberships