♦ Lead in the implementation of the Hyperion Essbase and Planning applications for FP&A team to support planning and business line profitability reporting♦ Worked with business users to define the system and reporting requirements, worked with system administrators to implement the data model into Hyperion Essbase♦ Created metadata and core data extracts using SQL from the FMIS data warehouse and datamart for the Hyperion Essbase application♦ Wrote and submitted Design Document Requirements to IT for the Hyperion Essbase metadata and core data files and code♦ Worked in collaboration with IT to setup the FTP process to the Oracle servers♦ Created documentation for the Hyperion Essbase application. The documentation consists of a detailed User Guide, Activity Guide, Data Dictionary, Power Point, Participation Guide, and Quick Reference Cards for end users to reference during rollout and production cycles♦ Created UAT participant scripts and presentations. Conducted Core and End User UAT for the Hyperion Essbase application and reported findings back to senior management♦ Created governance for system security and maintained end user access profiles♦ Developed and facilitated training for end users on the Hyperion Essbase Application; including, Smart View, Workspace, and the Data Model♦ Implement system enhancements based on business user requests and requirements for board and business line reporting

♦ Lead financial systems enhancement projects and represent finance on company-wide technology projects. Facilitated the definition of project scope, goals, and track project deliverables♦ Conduct financial analysis, interpret results, and bring inconsistencies and issues to the attention of management, and suggests possible solutions♦ Coordinated the validation of incidents and change requests impacting the FMIS application and established and maintained a working relationship with all levels of IT support♦ Supported the Business Objects/FMIS migration project in parallel testing cycles to confirm the application meets business requirements♦ Created contract level profitability reporting via sql in the FMIS Application to support business line profitability and incentive reporting. Reconciled reports back to FMIS to ensure accuracy of the reports. ♦ Created new business and runoff reporting using Business Objects for senior management♦ Created validation process for Funds Transfer Pricing to ensure the accuracy of the OFSA FTP engine. Validations were created for Loans, Deposits, and Unfunded Commitments based on the methodologies assigned to the various products.♦ Assisted the QRM Data team with migrating visual basic transformations from TDM into SQL transformations in the Management Repository application for SBNA sources♦ Completed monthly data mapping assignments to ensure the accuracy of the FMIS system

♦ Managed the monthly process in the TDM/QRM data warehouse applications, completed monthly process of data loads into the data warehouse, balanced the application back to general ledger, maintained transformations for data normalization using VB and SQL, and setup ETL from TDM into QRM♦ Lead data integration of new sources into the TDM/QRM applications. Ensure data is complete and accurate during parallel cycles. Worked with operational, accounting, and treasury teams to ensure data mappings were accurate in QRM and reconcile source information back to general ledger♦ Define and document data mapping requirements for legacy sources and define dimensions required to map data to the appropriate general ledger account♦ Work in collaboration with IT on system upgrades. Developed test plans to assess the quality and completeness of system upgrades and work with IT support to understand and address system issues♦ Validated New Business and Runoff methodologies between the QRM and FMIS application to ensure accuracy of the data and reporting during migration from QRM to FMIS♦ Write and maintain visual basic transformations to normalize data

♦ Setup fixed assets within the Lawson system to begin depreciation♦ Create Crystal Reports for management to track Fixed Assets♦ Submit journal vouchers to accounting to book to ledger