Project Manager Manage projects to ensure cross-functional participation, proper communication, timelines followed and successful implementation. Identifying, tracking, managing, and resolving project issues as they arise. Communication with key stakeholders on initiative launches, progress, status reviews and post reviews of key projects

User Interface Liase directly with customers to collect information when further investigation is required. Ability to communicate issues clearly to both business and technology professionals. Interact with data warehouse and operations group to retrieve information from Oracle and SQL databases.

Requirements Analysis Work in collaboration with the department heads to gather requirements as needed.  Analyze information requirements and access databases to develop custom reports Review current processes and methodologies to determine opportunities to implement improvement initiatives

Design & Architecture Develop infrastructure to support reports created. Configure and deploy complex output reports created in Crystal Reports and other application toolsets. Develop reports as per technical and functional requirements, design SQL queries and stored procedures to meet report design requirements and other duties as required.

Documentation & Maintenance Provide day-to-day technical support, troubleshooting and bug fixes to existing Crystal reports with tight turnaround time. Remote support across North America from Home Based office. Preparing the project necessary approval and sign off documentation.

  Financial Data Transfer from GL to Hyperion Enterprise This project involves perfecting the data download from two current general ledgers (CIS and RENCS) into Hyperion. The objective of this project was to better utilize the capabilities of Hyperion in the context of the detailed structure that was created. Creation of new processes was required for the Budget data upload (from Excel) and subsequent download of the consolidated information into the general ledger. Involves training senior management and creating reports to meet senior management needs.
 

 Fixed Asset Processing and Control The objective of this project was to gain efficiencies in processing and reporting fixed asset information using the software Worth IT Capital Suite.  This includes analysis of the problem, analysis of different software solutions and reporting recommendations to senior management, creation of a database structure, pilot project and subsequent rollout and finally support and training of individuals who will continue with maintenance.

 Monthly Headcount Reporting Integration with Peoplesoft
The objective of this project is integrate and then transfer responsibility of reporting to HR using the PeopleSoft application in order to have consistent, accurate and timely information using the power of the computer system. The process will include restructuring the departments, creating a duplicate static database which will compare results to the active database used by Human Resources. A few minor modifications to the application have been recommended and report specifications will be written to accommodate the new structure.
 

Balance Sheet Review
The objective of the balance sheet review is to analyze the accounts with respect to validity, valuation, classification and presentation. A new process was created to ensure that all accounts are included in our balance sheet review using Excel. Processes have also been initiated to assign account responsibility, train clerks in various levels of account analysis procedures and set up procedure manual for a senior person who will be accountable for the quarterly process as well as act as liaison with external auditors.
 

 Control Self Assessment Coordination
As required by our Internal Audit department, BP practices Control Self Assessment which must be completed for all three manufacturing plants as well as the administration departments. The coordination of these reports involves analysis of reported issues, co-creating action plans to correct control breach, monitoring any follow-up activities and reporting any issues to the appropriate management personnel where deemed necessary.
 

Capital Post Completion Reviews
The principal objective of the Capital Post Completion Review is to improve the capital investment and implementation process. In order to improve the planning process, a comparison is done of the expected accomplishments with the results obtained considering the resources used and the savings realized. Every variance found indicates where there is place for improvement. An analysis of the process used to complete the project and to control its costs is also done. Finally, recommendations are made to improve the next capital investment and implementation process.
 

Provided consolidated financial statements, data and information to both senior and branch management. Emco had 26 divisions across North America and Europe which manufactured and distributed plumbing supplies and related products. Prepared the Emco Limited Monthly Operating Statements for senior management. This 40 page report included consolidations and analysis of financial information. Analysed and interpreted financial results through discussions with Financial Managers and computer report generation.

Prepared Corporate monthly statements. Gathered electronically transmitted data from various sources for automatic entry into the general ledger. Reconciled inter-company account differences

System conversion of new divisions systems to Emco’s financial systems – from analysis of original software and hardware to final implementation of new systems (Hyperion and communication data).

Prepared and interpreted the Annual Profit Plan (using Hyperion software) and Block Cost Report detailing expenses reported by the divisions.

Installed remote (home) access to Corporate LAN for Corporate Accounting users. Responsible for accuracy of financial information on Internet. Alternate PC support for Corporate Office.

Provided assistance to auditors, examiners and regulators as necessary; and managed special projects and dealt with ad hoc requests as instructed.
 

Performed operational and financial reviews of divisions (Audit Exchange Program) Reviewed and analyzed large amounts of information. Identified key issues and opportunities for improvement and drew informative conclusions. Prepared practical recommendations to improve controls, cash flow, quality, effectiveness, efficiency, and profitability. Presented conclusions and recommendations to management at all levels. Member of a due diligence team for an international acquisition.
 

Reengineering Pricing Maximization Team  A multi-disciplined team was brought together to reengineer the Pricing Process used in the Distribution division. Our objectives included developing clear and consistent pricing strategies with a standard process to ensure margin improvements, to establish a method to leverage regional market opportunities, to manage the variability component in terms of sales force pricing, to improve the information available to make intelligent market pricing decisions (e.g. competitive bench marking, customer histories and sensitivities) and set the stage to define customer profitability from an activity based costing perspective.

Performed all aspects of Accounts Receivable and Accounts Payable for eight Home Care branches across Ontario. Prepared financial statements. Reconciled of sub-ledgers verifying accuracy of expense allocation and inter-company balances. Designed policies and procedures for the newly created position of Credit Clerk. Designed computerised system for collecting delinquent accounts. Reduced the outstanding Accounts Receivable over 90 days from over 20% of sales to 1% of sales. Extensive written and oral communication with both senior and branch management regarding accounting procedure, overdue receivable and expenditures.