Financial Systems Specialist
Seasoned financial/technology professional with broad experience in accounting, financial application development and delivery, and project management. Passionate about understanding current processes, business needs and maximizing the potential of ERP, EPM & BI applications. Learning new possibilities in the area of advanced financial system management and is looking for the accountability functions as a Financial Systems Specialist, where I can prove my excellence in the development of effective management control systems that ensures healthy business growth and development.
Highlights
Oracle EPM 11
Essbase
HFM
FDMEE
DRM
Smart View
Financial Reporting Studio
Shared Services
ODI
Data Mart
UNIX
SQL Server
OBIEE 11g
Interactive Reporting
Web Analysis
Business Objects
Consolidated Financial Reporting
Cognos
Pervasive Data Integration
Windows Server 2003 / 2008
Microsoft Office Suite - Word, Excel and PowerPoint
Technical Expertise
Oracle EPM 11
Essbase
HFM
FDMEE
DRM
Smart View
Financial Reporting Studio
Shared Services
ODI
Data Mart
UNIX
SQL Server
OBIEE 11g
Interactive Reporting
Web Analysis
Business Objects
Consolidated Financial Reporting
Cognos
Pervasive Data Integration
Windows Server 2003 / 2008
Microsoft Office Suite - Word, Excel and PowerPoint
Accomplishments
Experience
Senior Financial Systems Analyst, 09/2014 - Present Highmark Inc. – Kittanning, PA,
Overseeing the daily and monthly close operations of the financial systems, providing customer support to over 98 global users.
Serve as liaison/point of contact with IT and Business Units to ensure all user needs are identified and included into system requirement and all technical aspects are properly documented, tested and addressed.
Developed and implemented JD Edwards GL Security model, HFM and Essbase User Security Model.
Implemented new SOX compliance Oracle Financial Systems User Security Request approval workflow process.
Developed and implemented new Data Governance and Metadata Change Management Process over account structures, organization hierarchies, key data elements and related configurations.
Wrote many standard work documentations, as well as developing HFM and Essbase user guide training materials, Hyperion class training curriculum and SharePoint class registration site.
Delivered payroll data flow process diagram to identify causes and effects of current payroll issues impacting the overall company's Finance which resulted in implementation of standard new hire workflow process documentation.
Received spot awards and president's award on Team Work.
Senior Financial Systems Analyst, 03/2013 - 08/2014 Highmark Inc. – Lancaster, MN,
Worked in the Financial Systems Department in maintaining and development of its mission critical financial systems, Hyperion Financial Management (HFM), Oracle Financial Data Quality Manager (FDQM), legacy systems, and custom built Finance database.
Perform maintenance of application metadata and data.
Hierarchy changes and updates business rules.
Interface with user community for training needs and trouble shooting.
Provide data insight, extraction, and analysis as required to meet the needs of internal customers.
Functioned as the Essbase Administrator for the Essbase profitability model; this role entailed overseeing application, performance and working closely with the business to resolve all issues.
Delivered and recognized for the Company's new reporting tool (Essbase) to include new detailed margin data at the customer, region and LOB.
This reporting tool was critical to track margin and revenue at the customer and region level which has enabled the group to perform deeper dives on the drivers of margin performance at the LOB, region and customer level.
It also helped the FP&A and reporting groups to improve providing financial data.
Developed the Governance and Communication Tools for Essbase Financial Report Tools and developed Essbase Financial Reporting Run Documentation Book.
Developed the company's new customized Cash Forecast OBIEE Dashboard for the Treasury Department to keep track of forecasted total net cash flow over the next 10 days, plus deliver detailed reports to determine expected timing for receipt of receivables.
Senior Programmer Analyst, 01/2009 - 01/2011 City University Of Seattle – San Diego, CA,
Assisted design of system architecture to anticipate future growth of financial applications; this entailed organizing multiple projects while leading all customer-facing activities as well as departmental and project budgets.
Performed Hyperion System 9 maintenance, support, capacity planning, resource management, evaluations, performance tuning, security maintenance, and upgrade implementations as the team leader.
Established a consolidated financial reporting system across five business units, unifying reporting across the company to a single view, increasing time efficiency and performance improvement.
Engineered a program for Web-based financial reporting, which was adopted company-wide, eradicating costs for publishing and deployment of monthly financial statements.
Decreased data collection time by 27%, enabling more time for financial analyses.
Designed and implemented an actual and budget expense financial data tracking dashboard for the IT Department, increasing visibility for management to overlook data and drill down detail reports.
Database and Applications Specialist, 01/2006 - 01/2009 Columbia College Chicago – City, STATE,
Brought on board to develop a robust Data Warehouse Business Intelligence to standardize the reporting solution system across all school departments.
Optimized and tuned data processes and ETL programs to decrease processing time while increasing data availability.
Investigated and recommended changes to improve efficiency of the college's census reporting through data warehouse reporting.
Developed a model to demonstrate the superior capabilities of the system.
Coordinated unified reporting across the entire college providing complete reporting of each student's lifecycle through the development of a data warehouse supporting 5 data marts which assisted initiatives for admissions, enrollment, financial aid, faculty, and financial services.
Actualized and automated a seasonal student census reporting application to obtain data from the data warehouse, reducing manual processing time to two hours from three days, with 100% data accuracy.
Education
Bachelor of Science: Information Technology (Client / Server), Expected in - DeVry University - Addison, IL GPA: Information Technology (Client / Server)
Bachelor of Arts: Finance, Expected in - North Central College - Naperville, IL GPA: Finance
Skills
Analyst, Application Development, Book, budgets, budget, Business Intelligence, Business Objects, Business Process Improvement, capacity planning, cash flow, Change Management, Cognos, customer support, Data Analysis, data collection, Data Integration, Data Modeling, data warehouse, database, Database Management, Data Warehousing, Documentation, drivers, Essbase, ETL, Finance, Financial, financial analyses, Financial Analysis, Financial Management, FP&A, Financial Reporting, Financial Report, financial statements, GL, Hyperion, IT Project Management, JD Edwards, Team leader, Excel, Microsoft Office Suite, PowerPoint, SharePoint, 98, Word, next, Oracle, Developer, Oracle Financial, organizing, payroll, processes, Quality, reporting, requirement, sales, SOX compliance, SQL Server, strategist, system architecture, Team Work, training materials, Treasury, trouble shooting, UNIX, upgrade, View, Windows Server, workflow
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
