|
|
|
|
Senior Financial Business Analyst Resume
|
| Desired Industry: Finance/Investment |
SpiderID: 28807 |
| Desired Job Location: Toronto, Ontario |
Date Posted: 9/23/2009 |
| Type of Position: Full-Time Temporary |
Availability Date: ASAP |
| Desired Wage: 80k + or - |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: Yes, More Than 75% |
| Highest Degree Attained: CPA |
Willing to Relocate: No |
Objective:
With about 12 years of financial business consulting experience from a wide range of industries and as a result, having had a wide exposure to various financial systems. Significant hands-on experience with Hyperion (5 years), Cognos (2 years) and Clarity products (2 months). Conversant with relational/OLAP technology. Versatile enough to be part of any stage of the project implementation cycle.
Prior to consulting, significant experiences in the public accounting and finance sectors.
By profession, a fellow member of the Chartered Institute of Management Accountants of London, England.
Experience:
Jan09/current GMAC Residential Funding
Senior Financial Business Consultant
ƒÞ Building Product Quality Assurance MS Access Database
ƒÞ Creating financial models for the risk management group for residential mortgages and auto loans.
ƒÞ Designing and developing Quality Control monthly reports using advanced Excel functionality especially using Vlookups and Pivot tables.
Sep08/Dec08 Toronto Hydro
Senior Financial Business Consultant
ƒÞ Designing, developing and deploying reports using Hyperion Web Analyzer.
ƒÞ Performing user-acceptance-testing before pushing the reports into production.
ƒÞ Making recommendations and effecting changes in the Hyperion Essbase environment to augment the efficiency and effectiveness of the financial reporting process.
Aug08/Aug08 Guayaca Financial Services Inc.
Senior Financial Business Consultant
ƒÞ Reconciling transactional data to summarized data in Access database.
ƒÞ Creating Access queries and creating reports in the Access environment.
ƒÞ Uploading data in Access to Great Plains Ledger System.
Jul08/Jul08 Osram Sylvania Inc.
Senior Financial Business Consultant
ƒÞ Streamlining current reporting processes to augment efficiencies and effectiveness of the reporting process.
ƒÞ Creation of mapping tables, designing of financial and non-financial reports using Hyperion Reporting for Windows Client/Hyperion Excel Retrieve and conducting data validation thereon.
ƒÞ Resolving mapping issues resulting from client¡¦s upgrade to higher version of the Hyperion product.
Apr08/June08 GMAC Residential Funding
Senior Financial Business Consultant
ƒÞ Loan portfolio analysis and reporting
ƒÞ Producing loan portfolio reports using advanced Excel functionality especially using Vlookups and Pivot Tables.
Jan08/Mar08 Clarity Systems
Senior Consultant
ƒÞ Attending 2 Joint Application Design (JAD) sessions with Centerra Gold and Carbot Corporation and performing all pre and post JAD work.
ƒÞ Presenting the client with an overview of the product strengths of the Clarity product and ironing out issues to customize the product to client¡¦s requirements without comprising on the efficiency of the Clarity product.
ƒÞ Developing a Business Requirement Document for client
ƒÞ Developing a Statement of Work for the implementation
ƒÞ Developing the Project Charter for the client
Sep07/Dec07 Deloitte & Touche
Senior Consultant
ƒÞ Revamping the client¡¦s standard costing model and making recommendations to further augment the effectiveness and efficiencies of the model going forward.
ƒÞ Doing a ¡§fit gap¡¨ analysis for the client¡¦s current SAP system and how client could maximize functionality of the system to further augment efficiency and effectiveness of the system.
ƒÞ Highlighting the ¡§Growing pains¡¨ client will experience from transitioning from an ¡§As is¡¨ to ¡§To be¡¨ environment.
ƒÞ Training and being conversant with the Hyperion Essbase System 9.3 especially hands-on training with Essbase Cube building technology.
ƒÞ Training and being conversant with the Cognos 8 BI Report Authoring.
Aug07/Aug07 Ontario Air Ambulance Services (now known as ORNGE)
Senior Financial Business Analyst
ƒÞ Working on ORNGE budget for fiscal year 2008/2009.
ƒÞ Comparing budget to forecast and reporting on significant variance for management attention and action.
July07/July 07 CarlsonWagonlit Travel
Senior Financial Business Analyst
ƒÞ Developing reports on Hyperion Essbase 9.2 and validating these reports to Hyperion Planning System 9.0.
ƒÞ Resolving mapping issues where discrepancies were detected during data transitioning by ensuring that Essbase Cube outlines was capturing all the data points from the legacy system to the new platform..
Dec06/April07 Xstrata Copper Canada (Formerly Falconbridge)
Senior Financial Business Analyst
ƒÞ Streamlining current reporting processes to augment efficiencies and effectiveness of the reporting process.
ƒÞ Creation of mapping tables, designing of financial and non-financial reports using Hyperion Reporting for Windows Client/Hyperion Excel Retrieve and conducting data validation thereon.
ƒÞ Resolving mapping issues resulting from client¡¦s upgrade to higher version of the Hyperion product.
ƒÞ Working extensively with Hyperion consolidation.
Sep06/Nov06 Maple Leaf Global Foods
Senior Financial Business Analyst
ƒÞ Revamping of Hyperion Enterprise Reporting structure.
ƒÞ Creation of re-mapping tables, redesigning of management reports and conducting data validation thereon.
ƒÞ Participating in monthly and quarterly reporting cycles i.e. Setting up month-end accruals and thereon
ƒÞ Working extensively with Hyperion consolidation.
Mar06/Aug06 RBC Dexia Investor Services Limited
Senior Financial Analyst
ƒÞ Preparation of Capital Adequacy Ratios for Regulatory Reporting for OSFI quarterly filings and calculations of Debt Ratios for Quarterly Interim Quebec Regulatory Reporting.
ƒÞ Designing and preparation of management reporting package for Risk-based Capital Ratios and Risk-adjusted assets analysis.
ƒÞ Reviewing balance sheet reconciliations for completeness and accuracy for internal audit purposes.
ƒÞ Assisting in their month end and quarterly reporting cycles.
ƒÞ Augmenting the efficiency and effectiveness of the financial reporting process.
ƒÞ Performing multi-system financial system reconciliations.
Jan06/Feb06 Rogers Communications Inc.
Senior Financial Analyst
ƒÞ Preparation of yearend continuity deferred financing and amortization schedules.
ƒÞ Preparation of yearend continuity subordinated/debenture schedules.
ƒÞ Investigating data irregularities between Oracle Financial Reports and legacy system.
Jul05/Nov05 The Canadian Depository of Securities (CDS) Limited
Senior Financial Business Analyst
ƒÞ Documenting current CDS Excel-driven budgeting/planning/forecasting processes.
ƒÞ Preparation of Request for Information (RFI) document for budgeting / planning / forecasting application software to replace the Excel-driven process.
ƒÞ Reviewing, evaluating and scoring the completed RFIs for the Corporate Performance Management toolkit (Budgeting Application Software).
ƒÞ Preparation of Request for Proposal (RFP) document for a Corporate Performance Management (CPM) toolkit.
ƒÞ Reviewing, evaluating and scoring the completed RFPs for the CPM toolkit.
ƒÞ Arranging ¡§Focused¡¨ demo presentations on short listed potential vendors and scoring on these presentations.
ƒÞ Making final recommendations on Vendor of Choice and arranging for ¡§Proof of Concept (POC)¡¨ demo and effecting the contracting process
ƒÞ The CPM applications for which the detailed evaluation and analysis of the abovementioned included Cognos, Hyperion Financial Management (HFM) and OutlookSoft.
Education:
The Chartered Institute of Management Accountants, London, England
Affiliations:
The Chartered Institute of Management Accountants, London, England
Skills:
ƒÞ Microsoft Excel, Access, PowerPoint and Word
ƒÞ INEA and eGL programs
ƒÞ Hyperion Essbase 9.2 and Hyperion Planning System 9.0
ƒÞ Hyperion Essbase, Hyperion Reports, Hyperion Analyzer & Hyperion Enterprise 6.4
ƒÞ Cognos Impromtu & Cognos PowerPlay
ƒÞ PeopleSoft General Ledger System, Querying Tools & nVision Reports
ƒÞ Oracle Financial Analyzer Version 6.4 and Oracle Discoverer 4i Viewer
ƒÞ Great Plains General Ledger System & FRx Reporting Tool
ƒÞ SAP Business Warehouse
ƒÞ SQL/Oracle PL/SQL
ƒÞ Passport System
ƒÞ Visual Basic 6.0
ƒÞ Various Electronic General Ledger Mainframe Systems and Accounts Receivable and Accounts Payable Subsystems
Reference:
Available upon request.
Candidate Contact Information:
TheJobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|