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…