Business Systems Consultant - Oracle Financials

Sun Life Financial   •  

North York, ON

Industry: Accounting, Finance & Insurance


11 - 15 years

Posted 179 days ago

This job is no longer available.

Role Summary:

The Business Systems Consultant will use his/her knowledge of business objectives, processes, products, technology and quality concepts to:

  • Partner with business and technology areas to ensure the delivery of quality solutions that meet the needs of the Finance business users and stakeholders
  • Provide application support in a production environment to meet Service Level Agreements

Main Accountabilities: 

  • Participate in Project Management activities such as managing the delivery of projects through initiation, estimating, work planning, analysis, design, constructions, deployment and post-project review
  • Elicit, document, examine and manage business requirements on projects by following the current company application development methodology including managing business requirements sessions, conducting interviews, assessing existing documentation, fit/gap analysis, risk assessment and business requirements validation
  • Translate business requirements into functional requirements. Ensure traceability and understanding of the requirements by all project/support members to enable systems enhancements/projects to be constructed 
  • Consult with vendors, designers, architects, developers, and testers on business requirements to clarify and translate them
  • Prepare user/operations training manuals and conduct end user and support staff training sessions
  • Provide production support and troubleshooting, root cause analysis, and problem management
  • Participate in and/or create test strategies and test plans as a member of a project team, and execute test plans as part of the production support role; engage the Testing Centre of Excellence as appropriate.

Key Competencies:

  • Business analysis principles and industry best practices (eg. business process modeling, conceptual data modeling) and tools
  • Well developed client facing skills, customer service and results focused
  • Knowledge of systems integration management methodologies, processes and techniques.
  • Analytical thinking, highly developed analysis skills
  • Problem management, can anticipate and solve problems or reduce impact of incidents when possible
  • Relationship Management, at all levels of the organization
  • Adaptable, able to manage competing demands, deal with frequent change, ambiguity, delays or unexpected events
  • Proven Leadership skills; ability to tactfully bring opinions, comments and thoughts forward
  • Collaboration, shares information in a timely manner and uses active listening skills
  • Communication and Facilitation skills, able to interpret the meaning, purpose and importance of verbal and non-verbal messages; able to express ideas, thoughts and information clearly and concisely; able to guide and keep a group on track, recognize issues that need to be dealt with, and ensure everyone is heard
  • Documentation, able to develop and deliver artifacts that meet quality standards for accuracy and completeness, according to agreed upon delivery dates.
  • Innovative, looks for new, sometimes unconventional approaches to the way things are done
  • Teamwork, able to work as part of a team to achieve project objectives and/or team goals
  • Experience working in a multi-site matrix environment, which includes onshore/offshore IT model

Functional/Technical Skills: 

  • BSc in Computer Science, Information technology, or Business Administration
  • Minimum 10 years’ experience as a Business Systems Analyst in a large corporate environment as a member of project delivery and application support teams
  • Minimum of 5 years of Oracle ERP Financials implementation and support experience: Oracle Financials GL, Accounts Payable,  Purchasing, iProcurement and Fixed Assets, Security modules as well as Applications Desktop Integrator, Web ADI, Discoverer, Tableau
  • Must have Oracle R12 experience, including at least one end to end Oracle R12 implementation in  EBS space
  • Strong understanding of Finance processes: GL month end/quarter end, closing and reconciliation processes, fixed assets, accounts payable, purchasing to pay processes
  • Proficiency with SOX regulations and IT Change and Incident Management
  • Strong understanding of Oracle Financials security and experience designing application security schemas, following SOX segregation of duties rules
  • Strong experience with full life cycle of software development, including requirements, design, development, testing, rollout, implementation and training
  • Knowledge of underlying database tables and understanding of their relationships using Oracle Applications.
  • Able to write and execute SQL Queries to help trouble shoot support issues
  • Proficient with MS Office suite of products including MS Visio


  • CCBA or CBAP designation
  • Finance designation
  • Oracle certifications
  • Reporting and BI Tools: Tableau

Notes/Unique Requirements:

  • This role supports internal business clients in Waterloo, Toronto, and Wellesley.  Occasional travel between these locations is required.
  • Reporting Location is Toronto – Atria
  • This role requires RCMP Clearance