Judy M Pin

BSc, CPA, CGA, MBA, MISt

170 Roehampton Avenue Toronto, ON M4P 1R2

416-856-2414

[email protected]

http://www.linkedin.com/in/judympin

Senior Business Analyst (Contract)

Process driven finance professional with more than 15 yrs. of business analysis, financial
analysis, management reporting, and management experience able to immediately add value
with assiduous analytical talents, adaptability and integrity
Creative problem solver: with practiced analytical depth in corporate accounting/finance: a
skilled interpreter of financial results: consultant to internal managers; ambassador to
business partners, liaison to technical and operational functions.
Articulate communicator: both written and verbal; honed through performing corporate
training, presentations to senior management and championing initiatives such as change
management, process improvements, as well as system documentation, business cases
Credentials: Accounting (CGA) Financial Services (MBA) Information Systems (MISt)
Business Analysis in Financial Services(Certificate)
RELEVANT INDEPENDENT CONTRACTING - CONSULTING EXPERIENCE
Complete chronological list can be found at the end of the resume
Propinquity Consulting Inc.
Financial business consultant

2006 PRESENT

RBC Insurance Finance

Jun13 Dec13
PROJECT: EPM Implement Cognos Management & Financial Reporting
Contracted to transition Statutory & Regulatory reports (OSFI PC1 & Life1) from INEA to
Cognos TM1, including G/L hierarchy build (financial business analyst)
Simplified process and increased reliability in statutory and regulatory (OSFI) reporting
by implementing Cognos TM1 - including promoting the original business case for the
new reporting process, re-designing and configuring the Cognos hierarchy, scrubbing
conversion data, ensuring data integrity during transition, designing reports, standardizing
report formats, training the users, documenting procedures, and finally handing off to
users.
Introduced, then designed and built Cognos hierarchies to facilitate regulatory reporting
Audited, researched and analyzed all existing financial reports for conversion to the new
reporting regime, eliminating redundancies, establishing internal controls and
standardized report structure.
RBC Finance
Nov12 Jun13
PROJECT: EPM Implement Cognos Financial and Management Reporting
Contracted to write BRDs for financial/management reporting transition from INEA to Cognos
TM1, including G/L hierarchy build (financial business analyst)
Wrote 50 BRDs for management reports

Audited and updated more than 100 report specification

Designed and built G/L Cognos hierarchies to facilitate management reporting
Reviewed and catalogued 1500 reports, to determine conversion effort
Managed Reporting Project SharePoint site
Researched/analyzed existing financial reports to maximize efficiency in the new
reporting regime

TD (Finance Shared Service Dept.) (Contract)

Aug07-Sep08
PROJECT: FDW - Single Data Repository (chart of accounts) Management reporting and
Planning & Forecasting
Contracted to Research and document detailed user impact analysis, Execute communication
plan to ground level users and Conduct training (financial business analysis)
Prepared conducted documented and validated elicitation. Analyzed reporting
requirements, including using models, organized requirements and documented
requirements.
Increased utility of management reporting after implementation of new reporting
tools(Hyperion ) by redesigning rollout strategy to business units based on feedback from
information sessions, by learning the individual needs of each of the business unit
managers could easily demonstrate the value usefulness flexibility of the reports and
prove the responsiveness of the department thus building trust for future implementations
Prepared a Planning & Forecasting gap analysis report (as is vs. to be) highlighting
budgeting concerns to be addressed prior to a successful implementation of Hyperion
9.3- Planning.
Designed strategies to facilitate organizational change management through research
and analysis; elicitation, end user attitude surveys, increased communication through
relationship building, and audience specific presentations.
CST Consultants (Investment Finance Group)
Dec06-July07
Employed to audit and evaluate processes and recommend financial processes and
procedures, ensure financial controls are operating and leverage ORACLE financials
functionality (financial business analysis)
Business lead on Oracle E-Business upgrade including developing test cases, performing
testing defining end user procedures and workflows, developing conversion and
implementation strategies verifying conversion, writing user documentation, delivering
user training, and providing post-implementation support
Audited, and evaluated processes and capabilities, then developed user requirements,
confirmed conformity by testing operational enhancements ensuring complete and
accurate recording and reporting
Conducted cross functional operational audit, research and analysis of policies processes
and systems to expose risks and crafted a strategy in collaboration with operations and IT
to mitigate exposure.

Judy Pin

416.856.2414

[email protected]

Page 2 of 10

 Developed reports including continuity schedules used by investment managers to

predict RESP cash requirements.
Leveraged Oracle financials in AP GL to enhance the both reporting and transactions

OTHER EXPERIENCE
Insurance Bureau of Canada
SENIOR ACCOUNTANT FINANCIAL SYSTEM BUSINESS ANALYST
2005
Project Manager on Oracle Financial Implementation; Finance lead on all projects
Controller function for three insurance associations CSIO, ICLR, GIO;
Oracle Financials Administrator: Security Officer

2002

CURRENT/RECENT EDUCATION AND QUALIFICATIONS

CPA, CGA Certified General Accountant
MISt Master of Information - Information Systems, University of Toronto
MBA Master of Business Administration, Schulich School of Business, York University
Certificate in Lean Six Sigma, University of Toronto (33% complete)
Certificate in Business Analysis for Financial Services, University of Toronto
Canadian Securitas Course

2011
2007
2015
2014
2013

OTHER
CBAP Pending
CFA
level 1
Project Management Executive Management Program University of Toronto
Operational Management Centre for Higher Education Research University of Manitoba
System Administration Fundamentals, G/L Management Fundamentals, Oracle University
BSc
Bachelor of Science (Physics) McMaster University
AREAS OF KNOWLEDGE
Industries
Govt Agencies,
Financial Services,
Universities.

Tools
CognosTM1, Hyperion ESSBASE,
Oracle Financials 11i e business suite
-configured (AP, AR, GL, Projects, FA),
PeopleSoft EPM,
SAP Budgeting Module

Consulting
Business Analysis
Financial Analysis
Process Improvement
Financial Management
Documentation

Judy Pin

Excel (pivots/VBA); Word, PowerPoint

Access (queries/forms/reports), MS Project;
MS Visio Pro

416.856.2414

[email protected]

Page 3 of 10

Crystal reports (queries and ad-hoc

reporting),

Judy Pin

416.856.2414

Hyperion 9.3 suite (web analysis, planning)

[email protected]

Page 4 of 10

COMPLETE CHRONOLOGICAL LIST

INDEPENDENT CONTRACTING - CONSULTING EXPERIENCE
Berkley Canada (Commercial Insurer) (Contract)
May14 Jul14
Contracted to analyze, coordinate and prepare various financial statements and management
reports (interim controller)
Streamlined new employee on-boarding through training and insight into financial
information systems and processes
Reconciled B/S (including bank) for audits, ensuring accounting & actuarial records
generated the same decisions
Prepared monthly journal entries for premiums, losses INBR ULAE and commissions
PRESTO Finance (division of Metrolinx) (Contract)
Dec13 Apr14
Contracted to develop and deliver management reports, improve finance processes and set up
a project cost system (financial business analysis)
Reduced month end management reporting turnaround time by 25% by analyzing the
current business processes, defining the business requirements, identifying the gap
between current and future reporting, designing, testing, implementing the new
procedure, training the users of the new process and provided them with succinct
documentation
Streamlined the initial stages of implementing a project costing system by establishing a
concise document template and effortless procedure acceptable to all stakeholders,
including senior managers, sponsors, project managers, project accountants and the
asset management system owners.
Technical & system SME assisted in the development of new finance processes, and
modifications to existing processes, improve efficiency of expense reporting to senior
management including commentary (original budget, revised budget, forecasts/latest
estimates)
RBC Finance EPM Project (Contract)
Nov12 Jan14
Contracted to write BRDs transition Statutory & Regulatory reports (OSFI PC1 & Life1) from
INEA to Cognos TM1, including G/L hierarchy build (financial business analyst)
Simplified process and increased reliability in statutory and regulatory (OSFI) reporting
by implementing Cognos TM1 - including promoting the original business case for the
new reporting process, re-designing and configuring the Cognos hierarchy, scrubbing
conversion data, ensuring data integrity during transition, designing reports, standardizing
report formats, training the users, documenting procedures, and finally handing off to
users.
Introduced, then designed and built Cognos hierarchies to facilitate regulatory reporting
Audited, researched and analyzed all existing financial reports for conversion to the new
reporting regime, eliminating redundancies, establishing internal controls and
standardized report structure.

Judy Pin

416.856.2414

[email protected]

Page 5 of 10

TD (Finance Enterprise Technology Solutions) (Contract)

Apr12 Sep12
Contracted to support Corporate Finance IT cost recovery allocations and simplification project
Contracted to improve monthly reporting
Contracted to update external benchmarking
Supported CSF-Allocations & ABC Costing with senior analytic depth during annual rate
setting and Simplification Initiatives
Recommended a 60% reduction of price points in a cost recovery scheme (>$750MM) to
simplify reporting and allocations, after analyzing the cost and benefit of 3 scenarios over
a 3 year period of activity based costing data
Reduced process time to assemble actionable documents and authorizations by 30% yet
ensuring the integrity of the resulting actions; by eliminating unnecessary steps after
analyzing process flow and eliciting requirements form all stakeholders
Reported enterprise wide technology spend for an external benchmarking agency
(Gartner) Complying with senior management changing priorities data collection
methodology was revised and end report was re configured to reflect the recent divisional
restructuring
Legal Aid Ontario (Finance Dept.) (Contract)
Nov11 Apr12
Engaged to prepare a business case (position paper) to analyze the impact of the change in
financial accounting standards, and gain stakeholder (Senior Management, Audit & Finance
Committee and External Auditors) acceptance before implementing.
Wrote business case recommending to Audit and Finance Committee implementation of
new financial accounting standards framework based on external benchmarking, a cost
benefit analysis, risk assessment and the organizations readiness
Prepared briefing notes/position papers with detail impact analysis of the framework
change, and full implementation plan achieving compliance with minimal disruption/cost
to current practices
Automated consolidation of annual budget submission reducing cycle time by 50%
Metrolinx (PRESTO Project Finance Dept.) (Contract)
Sep11 Nov11
Assigned to data analysis and reporting project, prepare monthly performance scorecards, and
reports to interpret results
Project lead providing direction to team activities & facilitates information audit and
validation
Analyzed monthly results and provide value add analysis and advice reducing month end
cycle by , giving senior management more time to respond to results
Used various technologies to classify, organize audit and analyze complex accounting
transactions, then audited for compliance and completeness. Within 2 months developed
a database reporting tool for extracting and analyzing financial information and ensuring
the timely and accurate distribution of monthly results
Sunlife Financial (Financial Planning and Analysis) (Contract)

Judy Pin

416.856.2414

[email protected]

Jul11 Sep11

Page 6 of 10

Contracted for the annual budgeting & planning process, during an implementation of Hyperion
ESSBASE
Designed and presented various financial performance reports emphasizing variances to
forecasts and plan, with insightful commentary simplifying and supporting senior
management decisions
Mined and analyzed data wrote reports and delivered relevant information efficiently and
effectively. While coordinating and maintaining budget templates (>120 cost centres,
>100 activity cost pools) audited and followed-up on budget issues with business unit
managers ensuring a complete and accurate budget
Skyservice BAS (Corporate Accounting Group) (Contract)
Mar11 May11
Engaged to assess the accounting process and impact of A/R. Develop requirements,
specifications, AS IS TO BE impact, and recommendations (financial business analyst)
Revealed process inefficiencies in Accounts Receivable collection cycle resulting in
process redesign initiatives through presentation to senior management easily
comprehensible business process diagrams which clearly documented unproductive and
redundant cross functional practices, policies and procedures
Assessed, researched, analyzed & documented sponsor/stakeholder needs; Mapped
business processes and created process flow diagrams(VISIO) as the initial steps in
analyzing process improvements to senior management
Documented instructions and procedures; Recommended solutions to satisfy the needs
& narrow identified gaps; thus senior management was provided with a road map to more
efficient cash cycle.
Canadian Tire (Financial Planning and Analysis Dept.) (Contract)
Feb11-Mar11
Contracted for month end and year end reporting in preparation for reporting conversion to
ESSBASE
Assisted in monthly/quarterly variance analysis and performance analysis (dashboards)
provided for a quick view for senior management
Created ad-hoc reports using recently upgraded Smartview ESSBASE
York University (LA&PS Division Finance Office) (Contract)
Dec09 Oct10
Employed to re-establish the finance department after a divisional merger creating the largest
division in the organizations history (interim financial officer)
Subject matter expert for all financial information and the point of contact within the
division for audit and reporting, for both financial and non-financial managers
Provided leadership in finance administration through formulating budgets, building
forecasts and advising on financial matters including audits, resulting in a successful
construction and forecast of the $140MM budget.

Judy Pin

416.856.2414

[email protected]

Page 7 of 10

 Reduced process time to assemble actionable documents and authorizations by 30% yet
ensuring the integrity of the resulting actions; by eliminating unnecessary steps after
analyzing process flow and eliciting requirements form all stakeholders
Effectively managed the day-to-day management of the finance function, including
coaching 5 direct reports
Aviva Insurance (Finance Dept.) (Contract)
Aug09 Dec09
Contracted to assist in an Oracle upgrade and subsequent finance dept. restructuring
Supported preparation of monthly and quarterly reporting packages for Corporate and
Insurance Division management and Reinsurance affiliate treaties. Packages included
analytical commentary explaining material changes in period over period results
Initiated process improvement in month end procedures/reporting during Tier 1 ERP
upgrade project, then trained staff ensuring knowledge transfer after the subsequent
corporate finance restructuring.
Reconciled G/L account lead-sheets, created exception reports then recommended
control improvements.
RBC Capital Market (Global Finance Dept.) (Contract)
Nov08-Mar09
Engaged to assist Global finance controller on financial matters during implementation of
trading sub-ledger
Monthly and quarterly financial reporting with accountability for specific financial
statement lines. This involves variance analysis on key reporting lines impacting financial
results
Supported quality assurance activities, by reporting monthly GL attestation by business
managers, complying with policy, increasing response by 15% in 4 months.
Supported balance sheet control certification and ensured the integrity of internal
controls by reconciling, monitoring and analyzing accounting information
System integration tester for GL posting rules in capital markets sub ledger project;
Reviewed test plans and test cases; Consultant role with respect to testing, defect
reporting, retesting resolution; Assessed business impact of defects and issues.
TD (Finance Shared Service Dept.) (Contract)
Aug07-Sep08
Contracted to Research and document detailed user impact analysis, Execute communication
plan to ground level users and Conduct training (financial business analysis)
Prepared conducted documented and validated elicitation. Analyzed requirements,
including using models, organized requirements and documented requirements.
Increased utility of management reporting after implementation of new reporting
tools(Hyperion ) by redesigning rollout strategy to business units based on feedback from
information sessions, by learning the individual needs of each of the business unit
managers could easily demonstrate the value usefulness flexibility of the reports and
prove the responsiveness of the department thus building trust for future implementations

Judy Pin

416.856.2414

[email protected]

Page 8 of 10

 Prepared a forecasting gap analysis report (as is vs. to be) highlighting budgeting
concerns to be addressed prior to a successful implementation of Hyperion 9.3- Planning.
Designed strategies to facilitate organizational change management through research
and analysis; elicitation, end user attitude surveys, increased communication through
relationship building, and audience specific presentations.
CST Consultants (Investment Finance Group)
Dec06-July07
Employed to audit and evaluate processes and recommend financial processes and
procedures, ensure financial controls are operating and leverage ORACLE financials
functionality (financial business analysis)
Business lead on Oracle E-Business upgrade including developing test cases, performing
testing defining end user procedures and workflows, developing conversion and
implementation strategies verifying conversion, writing user documentation, delivering
user training, and providing post-implementation support
Audited, and evaluated processes and capabilities, then developed user requirements,
confirmed conformity by testing operational enhancements ensuring complete and
accurate recording and reporting
Conducted cross functional operational audit, research and analysis of policies processes
and systems to expose risks and crafted a strategy in collaboration with operations and IT
to mitigate exposure.
Developed reports including continuity schedules used by investment managers to
predict RESP cash requirements.
Leveraged Oracle financials in AP GL to enhance the both reporting and transactions
CIBC (Project Finance Group) (Contract)
Oct06 Dec06
Contracted to advise project executives on financial management processes, tools and
reporting structure for assigned projects (senior project financial analysis)
Analyzed project financials result against business case for policy compliance, and
providing business advice based on sound analysis simplifying the project managers &
stakeholders decisions
Tracked and analyzed internal resources, vendor resources, capital expenditures, and
other project expenditures, software maintenance & depreciation
Prepared and distributed monthly financial reports ensuring stakeholders understood the
consequences of the variances, latest estimates and other performance measures as
well as the repercussions to successful project completion
Collaborated with project sponsors to co-ordinate financial management processes and
reporting on projects - including analyzing and advising managers on financial results
such as monthly actual and latest estimate and monitoring project costs against the
business case
Fidelity Investments (Finance Division) (Contract)
Aug06 Oct06
Engaged to build a detailed compensation budget including monthly cash disbursements for
Canadian operations (financial business analysis)

Judy Pin

416.856.2414

[email protected]

Page 9 of 10

 Modeled, then implemented a comprehensive monthly cash budget for total

remuneration, in half the time as the previous year at Fidelity Investments (800 + FTE, 36
month, 59 Cost Centres).
Automated assemblage of information from financial and non-financial sources for month
end dashboard
Infrastructure Ontario (Corporate Finance) (Contract)
Feb06 Jun06
Contracted to manage day to day financial management of a startup Provincial Crown Agency
(finance manager)
Researched and established policies and procedures for flexible yet sufficient accounting
controls by implementing the operational recommendations made to senior managers
Managed the day to day accounting functions (AP/PO/GL/GST/ credit cards/payroll)
including the initial year end external audit (working files, controls review, policy and
procedures) ($32MM)
Coached 2 direct reports

Judy Pin

416.856.2414

[email protected]

Page 10 of 10