Vikas Bhatia, Cpa, Cma Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Established the North American Business Intelligence and data governance practice, creating data standards, implementing robust data management processes, and driving strategic data-driven decision-making initiatives.
• Led the successful creation of a centralized data warehouse across 15+ production systems, resulting in significant cost savings and improved data governance.
• Implemented a self-service analytics system, achieving over $1M in savings and 90% user adoption of BI tools through data cataloging, user training, and high-value project execution.
• Advised senior management by delivering actionable insights and ensuring accountability in revenue through revenue growth analysis, monthly financial analysis, collection targets, employee analytics, procurement.
• Designed and delivered data models, empowering over 250 users to identify growth opportunities and operational drivers.
• Improved project delivery timelines by 20% through the implementation of a hybrid Kanban and Scrum methodology.

Greater Toronto Area Metropolitan Area

• Recognized as a recipient of the "TOP 50 Contributors" award in 2020 by Bureau Veritas for exceptional contributions in reengineering FP&A data models, resulting in a remarkable 50% improvement in ETL load processes.
• Streamlined dimension loads and implemented efficient cube rules, enhancing automation and reporting capabilities.
• Managed IBM Planning Analytics for over 150 users, overseeing budgeting, forecasting, monthly reporting, sales and revenue analysis, revenue/expense allocation, and KPI tracking with detailed commentary.
• Designed and implemented robust ETL processes, integrating data seamlessly from Oracle, SAGE, and Deltek ERP systems into IBM PA, ensuring accurate and up-to-date reporting and analysis.
• Developed advanced sales analytics models that provided valuable insights into current trends, enabling strategic sales direction and effective territory planning.
• Spearheaded initiatives to improve data quality and transparency in reporting processes for actuals, planning/budgeting, and analysis, facilitating informed decision-making across the organization.

Toronto, Canada Area

• Developed and maintained IBM Cognos TM1/Planning Analytics (PA) models throughout the project lifecycle, applying best practices to ensure system performance and scalability.
• Designed and constructed effective technical solutions by utilizing IBM PA cubes, dimensions, TI processes, rules, and completing the TM1 architecture for each project. Integrated data into SQL tables and other sources.
• Ensured application performance, usability, and data security by implementing AD for Single Sign-On (SSO) and Multi-Factor Authentication (MFA). Established policies for disaster recovery processes.
• Created dynamic reports and templates for end-user consumption and input. Implemented internal controls and data checks for accuracy using Perspectives/PAx and Planning Analytics Workspace.
• Analyzed client business processes, documented requirements, made recommendations, and assisted in developing test plans to improve efficiency and performance.
• Provided comprehensive training to end-users on the designed and implemented solution, highlighting the benefits of the new system compared to the previous process.

Toronto, Canada Area

• Promoted to manage and deliver various projects ranging in size from $50K to $2M USD in the Financial Services, manufacturing, insurance, asset management, and certification industries.
• Planned and managed engagement activities for IBM COGNOS/SaaS offering (LimeLight), ensuring timely delivery of high-quality work products throughout the project life cycle and post-implementation support.
• Maintained client relationships, facilitated service and software sales expansion, and exceeded services targets by 130% ($1M of yearly services sales targets) through effective expectation management and pre-sales.
• Identified process gaps, implemented solutions to generate additional business, and contributed to proposal pricing strategies by developing strong working relationships with clients and project managers.
• Managed a team of professional consultants, setting performance management targets for revenue, business development, client satisfaction, and team utilization, resulting in a 20% increase in employment performance.
• Generated RFP/RFQ/RFI responses and managed SOW writing, receiving required approvals based on client requirements, and invoice management.

Toronto, Canada Area

• Joint Application Design: Lead and participate in interactive design sessions with clients to discuss implementation objectives, evaluate current business process, gather requirements and further define project scope
• Solution Document: Oversee creation of Technical Requirements documents, Business Requirements documents and System Design documents with focus on Process improvement and internal control
• Planning / Management Documents: Develop and maintain all project planning and management artifacts - Project/Work Plans, Communication Plans, Staffing Plans, Supplementary Plans, Test Plans, Release Management Plans.
• Lead Daily Project Activities: Liaise with clients and internal resources to maintain communications, act as point of escalation for all technical and business requirement related items
• Manage Multiple Implementations: Simultaneously lead multiple new projects in addition to new phases of existing implementations
• Design and build various financial models (Disclosures, Budgeting, planning, forecasting, Revenue, Expense, ASC606, CAPEX and HR Models)

Toronto, Canada Area

• Configuring the company Hierarchy, % Ownership, Consolidation Methods to be used. Configured them using Dynamic Hierarchy Editor
• Built the Legal, Ownership and Rate applications and configured the required dimensions
• Developed the reports for the Income Statement, Balance Sheet, Cash Flow Statement, & Trial Balance. Also helped to identify security and Audit requirements
• Assisted in building and working with business rules using standard SAP-provided script logic for Automatic Elimination, IC Consolidation Business Rules, Carry Forward, and Currency Conversion
• Built a Journal entry module for the LEGAL application to do manual adjustments for data reconciliation
• Developed User Acceptance Test plans for testing the financial statements, Running consolidation process and currency translations

Toronto, Canada Area

• Project Management:
• Evaluated each client’s XBRL financial reporting requirement to provide innovative and efficient solutions based on business and reporting needs
• Providing potential clients with proposed service offerings quote based on the client needs
• Managed and executed various project deliverables within strict deadlines ensuring quality and regulatory compliance.
• Built strong client relationships and gaining credibility and trustFinancial Statement Reporting and XBRL Consulting:
• Acquired in-depth understanding of each client’s financial statements, complex accounting policies, and transformed existing financial information to XBRL compliant filing (including building XBRL complaint taxonomies)

Mississauga

• Prepared bank reconciliation, asset reconciliation and record-keeping reconciliation and investigating any differences on a timely basis
• Prepared monthly and annual financial information reports, including Fund-of-Fund reinvestment, financial statements, working paper files and audit files
• Communicated daily information and any discrepancies that arise with external clients, custody and trust accounting department
• Prepared daily valuations of assigned funds, including net working capital check and final NAV
• Maintained full sets of accounting records and sub – ledgers for several investment funds together with accruing of dividends and interest income, entering security trades and capital stock entries.

Oakville

Bcomm, Accounting

Honours Diploma, Accounting