Business Systems Analyst V - Oracle Enterprise OAC Platform Support at M&T Bank | Buffalo, NY, US | Rezi

Business Systems Analyst V - Oracle Enterprise OAC Platform Support at M&T Bank

Business Systems Analyst V - Oracle Enterprise OAC Platform Support

M&T Bank · Buffalo, NY, US

Yesterday

Business Systems Analyst V - Oracle Enterprise OAC Platform Support

M&T Bank · Buffalo, NY, US

a day ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Business Systems Analyst V - Oracle Enterprise OAC Platform Support role.

Rezi rewrites your resume against M&T Bank's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Business Systems Analyst V - Oracle Enterprise OAC Platform Support posting at M&T Bank — free, in seconds.

About the Role

Responsible for facilitating complex projects from proposal through post implementation, serving as project lead to ensure timely completion and adherence to milestones. Considered a Subject Matter Expert in assigned systems within 18 months.

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.
  • Prepare well-documented functional specifications, test plans, and test cases; execute test cases.
  • Conduct research and analysis of complex data to ensure functional design accuracy.
  • Serve as a 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, documenting and distributing minutes.
  • Meet with business clients to discuss requested application changes, ensuring thorough understanding of specifications.
  • Participate in design discussions and document/deliver required functional specifications.
  • Participate in meetings with lines of business to identify application requirements and provide feedback.
  • Review business requirements with the technology team to ensure project requirements are understood.
  • Coordinate and provide estimates for large projects and assigned components, including timelines and phases.
  • Serve as subject matter expert to consult and advise on application impacts from enterprise-wide initiatives.
  • Work with vendors and technical teams to understand project functionality and provide implementation insights.
  • May serve as Test Coordinator for large project initiatives involving multiple applications.
  • Participate in and document data mapping for system integration, conversion, and acquisition projects.
  • Work with other testing teams to prepare test plans and scripts, and manage/execute test cases.
  • Serve as functional lead with other project team members on systems impacting the project.
  • Monitor functional specifications and change requests to ensure projects stay within scope and meet regulatory requirements.
  • Ensure adherence to business requirements and Corporate Technology standards.
  • Ensure change requests are consistently documented, reviewed, and resolved.
  • Ensure efficient and timely resolution of issues arising from testing or implementation.
  • Ensure issues, incidences, and questions are documented, reported, and resolved as required.
  • Coordinate and manage post-implementation activities, including feedback, issue resolution, and debriefing.
  • Understand and adhere to the Company’s risk and regulatory standards, policies, and controls.
  • 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 audit points and regulatory issues.
  • Complete other related duties as assigned.

Requirements

  • 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.

Skills

  • Oracle FDI
  • Oracle Analytics Cloud (OAC)
  • OAC reporting content
  • OAC datasets
  • OAC semantic models
  • OAC dashboards
  • OAC analyses
  • UCL data structures
  • UCL extracts
  • Workiva extracts
  • Axiom extracts
  • SQL
  • Oracle tools
  • System testing
  • Integration testing
  • Regression testing
  • User acceptance testing
  • Data validation
  • Exception analysis
  • Reconciliation
  • Issue resolution
  • Month-end reporting
  • Quarter-end reporting
  • Year-end reporting
  • Technical documentation
  • Data mappings
  • Testing evidence
  • Operating procedures
  • Production support documentation
  • Functional specifications
  • Test plans
  • Test cases
  • Project management applications
  • Word processing applications
  • Spreadsheet applications

Location

  • Buffalo, New York, United States of America

Work Type

  • Full-time

Experience Level

  • Minimum of 6 years combined higher education and/or operational/business analytics experience
  • 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

Education Level

  • Bachelor's degree

Salary/Compensations

  • $85,800.00 - $143,000.00 Annual (USD)

About the Company

  • M&T Bank is committed to fair, competitive, and market-informed pay for our employees.