Business Systems Analyst V - Oracle Enterprise OAC Platform Support

Overview

Responsible for facilitating complex projects from proposal through post implementation. Participates in meetings with lines of business to identify their requirements in how an application looks and feels to the end user; provides feedback on them. Serves as project lead to ensure test plans and specifications are completed in a timely basis and project meets established milestones. Considered Subject Matter Expert in assigned systems within 18 months of being assigned.

Primary Responsibilities

• Develop, test, deploy, and maintain Oracle FDI, UCL, and OAC reporting solutions supporting Finance reporting and data consumption.
• Develop and maintain OAC datasets, semantic models, analyses, dashboards, and reporting content.
• Build and maintain UCL data structures and extracts supporting Workiva, Axiom, Profitability, and other downstream Finance consumers.
• Support GL-to-instrument processing, including data validation, exception analysis, reconciliation, and issue resolution.
• Develop and maintain Workiva and Axiom extracts and implement changes driven by reporting requirements.
• Execute adjustment-related data changes, testing, validation, and production implementation.
• Perform data analysis using SQL and available Oracle tools to research data and reporting issues.
• Execute system, integration, regression, and user acceptance testing for enhancements and production fixes.
• Troubleshoot production issues and identify root causes across FDI, UCL, OAC, source data, and downstream reporting.
• Support month-end, quarter-end, and year-end reporting activities.
• Maintain technical documentation, data mappings, testing evidence, operating procedures, and production support documentation.
• Work with Finance, Data, and Technology teams to resolve issues and deliver enhancements within established priorities and architecture.
• Responsible for preparing well documented functional specifications for assigned projects, test plans, test cases and execution of test cases. Responsible for research analysis of complex data ensuring functional design of assigned projects is accurate. Serve as mentor to less experienced staff by assisting in application training, research analysis and project methodology consultation.
• Serve as functional lead on complex projects for assigned applications. Schedule and facilitate project team meetings, document and distribute meeting minutes as applicable.
• Meet with business client to discuss requested application changes related to an enterprise-wide or business initiative, compliance/regulatory requirement, required system change due to contractual agreement or system maintenance (business as usual [BAU]) ensuring a thorough understanding of specifications for assigned applications. Participate in design discussions and document/deliver required functional specifications.
• Participate in meetings with lines of business to identify their requirements in how an application looks and feels to the end user and provide feedback to clients regarding business requirements to ensure technology applications support internal/external customer needs and products/services as provided by lines of business. Review business requirements with technology team to ensure understanding of project requirements.
• Coordinate and provide estimates for large projects and complete estimates for assigned component on assigned projects, inclusive of timelines and project phases.
• Serve as subject matter expert to consult and advise on how applications may be impacted by enterprise-wide initiatives, like an acquisition or major change in products/services provided to customers.
• Work with vendor and technical team to gain a thorough understanding of project functionality and provide insight on implementation.
• May serve as Test Coordinator for large project initiatives involving multiple applications.
• Participate in and document data mapping for integration of systems, conversion, and acquisition-related projects to understand how applications may need to change or be impacted by enterprise-wide initiatives, like regulatory requirements, other system enhancements or business initiatives.
• Work with other testing teams, when applicable, to prepare test plans and scripts based on functional specifications, and manage and/or execute test cases verifying that changes and enhancements work and perform as required. Serve as functional lead with other project team members on other systems that impact the project.
• Monitor functional specifications and change requests to ensure project stays within scope and meets regulatory requirements, while ensuring adherence to business requirements and Corporate Technology standards. Ensure the Bank process and documentation is followed to ensure adherence to Corporate Technology standards and regulatory requirements.
• Ensure change requests are consistently documented, reviewed and resolved to ensure application is working to support products/services required by line of business.
• Ensure efficient and timely resolution of issues arising from testing or implementation to ensure expected performance. Ensure issues, incidences and questions are documented, reported and resolved as required.
• Coordinate and manage post implementation by getting feedback, resolving any issues and completing a debrief including actual to plan for timeline and financials.
• Understand and adhere to the Company's risk and regulatory standards, policies and controls in accordance with the Company's Risk Appetite. Identify risk-related issues needing escalation to management.
• Promote an environment that supports belonging and reflects the M&T Bank brand.
• Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
• Complete other related duties as assigned.

Education and Experience Required

Minimum of 6 years combined higher education and/or operational/business analytics experience

• Strong verbal and written communication skills
• Strong organizational skills
• Strong time management skills
• Strong lateral thinking skills
• Strong problem-solving skills

• Proficiency with personal computers as well as pertinent software packages.
• Excellent problem solving skills to assist in issue resolution.

Education and Experience Strongly Preferred

• Bachelor's degree
• Hands-on experience with Oracle FDI and/or Oracle Analytics Cloud (OAC) or comparable Oracle analytics technologies.
• Experience developing OAC reporting content, datasets, semantic models, dashboards, or analyses.
• Strong SQL and financial data analysis skills.
• Experience developing and supporting data extracts and downstream integrations.
• Understanding of General Ledger data and financial reporting processes.
• Experience with data validation, reconciliation, testing, and production support.
• Ability to independently troubleshoot data and reporting issues across multiple systems.
• Understanding of incident, problem, change, and release management processes.
• Strong documentation and communication skills.
• Experience with Workiva, Axiom, Oracle EPM, or Profitability reporting is preferred.
• Subject matter expert in business with knowledge or experience utilizing application/system being supported.
• Capable of working on multiple projects of a complex nature.
• Advanced understanding of applications supported with a sound knowledge of interfacing/integrated applications.
• Advanced knowledge and focus of the entire system to work on projects outside of normal BAU.
• Ability to effectively use project management, word processing and spreadsheet applications.
• Excellent understanding of the Bank's application framework.
• Familiarity with application development software and hardware platforms.
• Ability to understand business(es) being supported and its' terminology.
• Ability to effectively present to all levels of management
• Ability to multitask for various components of complex projects.
• Ability to coordinate between applications and business units.
• Ability to work in a team environment as well as autonomously.
• Ability to recognize project milestones and delivery dates.
• Ability to recommend and implement solutions.
• Proactive
• Detail-oriented.
• Strong understanding of Bank acquisition methodology or relevant conversion experience

Pay and benefits

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $85,800.00 - $143,000.00 Annual (USD). The successful candidate's particular combination of knowledge, skills, and experience will inform their specific compensation.

Location

Buffalo, New York, United States of America