Barbara L. Foley
 

 

793 13th Avenue Montreal, Quebec H8S 3K4 (514) 364-7573 bfoley@emcobp.com


OBJECTIVE 

To obtain a position in a progressive firm that will challenge me and utilize my technical experience, my passion for developing human resources to their fullest potential and educational background.

(+)    SKILLS SUMMARY  

 

Systems conversion specialist recognized for having an aptitude for implementing and designing new computer systems to increase processing efficiencies. Certified General Accountant with senior accounting.   Resourceful, responsible, tenacious, independent, energized, with strong analytical skills, creative, and the ability to communicate effectively with executive management. Strong in project oriented work style. 
 
 
(+)    CAREER HISTORY
Business Intelligence Team Leader                                                                                                          September 2002 to Present  

BP, a division of Emco, Montreal, Quebec 

Lead a team of programmers and support staff through the Project Management Lifecycle.  We developed a Business Intelligence system in an Oracle shop sourcing data from 2 integrated transactional systems and outside sources.  Developed over 20 applications from Sales to Cell Phone invoicing.  Primary software Crystal Enterprise with both Crystal Reports and OLAP cube creation.

(+)  Click for more details

 

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.

senior financial accounting analyst                                                                                      march 1999 to September 2002

BP, a division of Emco, Montreal, Quebec

I was transferred from Corporate Office to the BP division (manufacturer of shingles and fibre board) to aid in the implementation of new procedures required for increasing processing efficiencies and to reduce risk by improving controls.  The need for new procedures was initiated by a system conversion from CIS (Customer Information System) to MRPII (Renaissance Client Server - Ross World).  Along with assisting in the senior duties of the month-end reporting process, I have been responsible for implementing the projects below from conception to successful completion, I performed needs analysis, designed, developed and am in the process of implementing the optimal solution to the challenge.

(+) Click for more details 

  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.
 

Supervisor, Corporate Accounting                                                                                      November 1997 to March 1999

Senior Financial Analyst                                                                                                         February 1997 to October 1997

Financial Analyst                                                                                                                          April 1994 to February 1997

Emco Corporate Office, London, Ontario

(+) Click for more details

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 Emcos 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.

Accounting Clerk                                                                                    December 1989 to April 1994

                                                                                                             

Emco Corporate Office, London, Ontario

(+) Click for more details

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.
(+)    EDUCATION
Certified General Accountant             Certified General Accountants Association

February 1997
                            TORONTO, ONTARIO, CANADA

Bachelors of Arts in Psychology           University of Western Ontario

October 1997
LONDON, ONTARIO, CANADA

Conversationally bilingual - French   Concordia University

MARCH 2000
MONTREAL, QUEBEC, CANADA
 

(+)    PROFESSIONAL DEVELOPMENT
TEAM ACTIVITIES
Information Technology Committee
Base Pay/Job Evaluation Committee
Primary Exam Evaluation Committee for CGA Ontario
CGA marker for various courses CGA London
Pricing Maximization Team
Board of Directors, Emco Building Products Pension Committee
CGA Board of Directors Education Committee
CGA London Chapter Board of Directors
Dale Carnegie Leadership Training

 

COMPUTER APPLICATIONS
Renaissance Client Server
CIS GL (Oracle Database, VMS Operating System)
WorthIt Fixed Asset Management System 3.5
Windows 95
Accpac for Windows, Accpac Plus
PeopleSoft
Front Line Editor (Web Page Editor) Internet Explorer 5.0
Microsoft Outlook 98 PC Anywhere
Netscape Navigator
Novell Netware 3.12

 

Microsoft Office 7.0
Hyperion Enterprise 1.81 to 4.3
WinZip 6.2
ACL for Windows
Lotus Smart Suite

References available upon request