Post Job Free

Resume

Sign in

Business Analyst Power Corporation

Location:
Pickering, ON, Canada
Posted:
June 27, 2021

Contact this candidate

Resume:

Mukesh Jani Functional ERP

416-***-**** adnd3k@r.postjobfree.com 1911 Parkside Dr. Pickering, ON, L1V 3N6

LinkedIn URL: ca.linkedin.com/in/mukeshjani

Entrepreneurial, innovative executive with extensive business development experience within highly competitive markets as a senior business analyst. Analytical professional skilled in successfully guiding corporations large and small through periods of accelerated growth. Collaborative communicator continually focused on building relationships and promoting synergy across business lines and global units to drive positive change, cohesive, comprehensive business approaches and enhanced profitability. Areas of Expertise include:

Consulting Expertise

Accounts Payable & Expenses

Requirements gathering

Fit/Gap Analysis

Project Costing & Fixed Assets

General Ledger & Purchasing

Lead the User Acceptance Testing

Project Management

Problem Resolution

process mapping to identify AS IS and TO BE information, procedure, and decision flows

ETL specifications

RFP / Vendor selection

legacy data conversion

Re-engineering

ERP Implementations –

Oracle, Primavera Unifier,

P6 EPPM,

EAM / Infor, PeopleSoft

EPICOR

MS Dynamics AX and 365

Power BI, Analyze with Excel

Lead configuration and design reviews within a project team.

Data Tools – More4Apps

Dataload,

Data Management Tool (DMT)

Jira / Confluence

HPALM (HP Application Life cycle Management)

MS Office 365

ServiceNow

Experience & Notable Contributions

PRESTO Toronto, ON. November 2020 - April 2021

Senior Business Analyst

PRESTO is part of Metrolinx a Crown agency that manages and integrates road and public transport in the Golden Horseshoe region, which includes the cities of Toronto and Hamilton and suburbs, in the province of Ontario in Canada. PRESTO is an electronic fare collections system that allows transit users in the GTHA and Ottawa to use a Smart Card to move between and within transit systems. PRESTO makes transit travel easier and more

Convenient.

Senior Financial Systems Business Analyst:

As part of the Finance Operations Team within PRESTO worked on several new initiatives related to contactless fare payments systems such as Open payments using credit cards and electronic fares such as e-tickets using bar codes and QR codes. PRESTO collects fares on behalf of the transit agencies and settles with them daily. The ERP for Finance is MS dynamics DAX2012 and D365.

Review design documents to ensure Finance requirements are met.

Liaise and test external vendor interfaces such as e-ticket solution provider and payments acquirer

Support the Finance Operations for the Pilot programs and testing for Open Payments and e-tickets

Design reports for use with Power BI and Analyze with Excel.

Support the reconciliation and settlements teams during the Pilots for Bank to Acquirer and bank to Transit agencies

Provide monthly reports from ServiceNow for Finance Incidents and Problem tickets

Verify field tests of new fare gate and other devices for taps and ensure recognized in the central systems and the settlement reports.

Key Accomplishments

Picked up new skills in MS Dynamics and MS Dynamics 365.

Power BI, Analyze with Excel

Completed all assignments on time and on budget.

Metrolinx Toronto, ON. February 2019-December 2019

Senior Business Analyst

Metrolinx is a Crown agency that manages and integrates road and public transport in the Golden Horseshoe region, which includes the cities of Toronto and Hamilton and suburbs, in the province of Ontario in Canada.

Business Analyst Conversion:

Gather data conversion requirements from Oracle ERP to Primavera Unifier and write Functional documents with ETL specifications. Work with developers and perform product testing.

Business Analysts EAM / Infor – for Asset maintenance item master.

Document all configuration and setups required for Oracle EAM/Infor in Oracle EBS. Conduct configurations and setups in lower test environments. Define and set up Concurrent Requests and schedules.

Gather and create test scripts for EAM / EBS interfaces. Conduct and assist users with testing.

Lead Reporting Business Analyst - Oracle Analytics Cloud (OAC) / P6 EPPM Reporting

Gather reporting requirements from key business champions for Unifier and P6 EPPM. Create reporting mock-ups, data mapping and functional documentation with ETL specifications for all reporting needs for Oracle Analytics (OAC).

Write test scripts for all OAC and P6 EPPM reports from Unifier and conduct and assist users with testing.

Key Accomplishments

Picked up new skills in Primavera Unifier and EPPM P6.

Completed all projects on time and on budget.

SOCAN Toronto, ON. September 2016-December 2018

Finance Business Lead / Analyst

Society of Composers, Authors and Music Publishers of Canada. Collects royalties for all Canadian publishers and writers.

SOCAN has implemented EPICOR Financial Management ERP.

Finance Business Lead on Migration projects for acquisitions and mergers.

Finance Business Lead on Joint initiatives for royalty licensing process design and implementations.

Performed current state analysis and to be processes for migration of financial data from legacy system to EPICOR.

Defined and developed business system requirements, designed, prototyped, tested, trained staff and defined support procedures and implemented them. Coordinated and completed all user acceptance testing.

Key Accomplishments

Picked up new skills in Epicor ERP and assisted in configuring Finance modules.

Completed all projects on time and on budget

Barrick Gold Corp. Toronto, ON. March 2016-June 2016

Financial Functional Analyst

One Oracle and Finance Simplification – Project to merge North and South America Oracle Finance applications and simplify finance processes.

Assessed business needs and developed technology solutions. Performed current state analysis, defined systems strategy, developed system requirements; designed /prototyped/tested/trained/defined support procedures for Project Costing, Project Manufacturing and EAM. Assessed Business requirements for OAT (Oracle Asset Tracking). Coordinated CRP Testing for North America operating units.

Rogers Communications, Inc. Toronto, ON. 2014-2015

Senior Financial Functional Analyst

Assessed business needs and developed technology solutions. Performed current state analysis, defined systems strategy, developed system requirements; designed /prototyped/tested/trained/defined support procedures and implemented them. Supervised timeliness of all testing. Served as both technical, configuration, and functional lead.

In charge of all Project related daily and monthly transactions interfaces from Procurement, Accounts Payables and Inventory Sales orders - via Project Manufacturing Warehouse (PMW) and Oracle Time and Labour (OTL) for Project costing. Ensured month-end processes completed successfully Project Costing and Fixed Assets to General Ledger. Responsible for all configurations for Project Costing Foundations and Fixed Assets modules. Trouble shoot issues using SQL / TOAD. Create adhoc reports for the business using SQL.

Key Accomplishments:

Developed, customized, integrated and deployed Acquire to Retire for the Oracle R12 upgrade project. Developed test scripts. Coordinated user acceptance testing. Employed dry run test cycles. Configured A2R modules and all of More4Apps Wizards for accounts payable/receivable, inventory, project costing, and fixed assets for quality assurance environments.

Slashed the configuration time of the upgrade project from an estimated seven hours to three by devising a better data extraction process, and eliminated time spent on configured project templates by correcting source data.

Guided the process data-gathering task during the configuration of QAT environments and completed them with little assistance by diligently working long hours and sometimes at home.

Received the business impact team award for 2015.

Rogers Communications, Inc. 2006-2013

Senior Financial Systems Analyst

Identified business needs and selected technology options to solve them. Performed analyses, defined and developed system requirements. Provided support for Oracle time and Labour, projects costing, fixed assets and Essbase. Diagnosed issues clients experienced and managed daily client relationships. Provided support for Hyperion Essbase for forecast and budget. Trained technology users. Responsible for security setups and outline updates pertaining to chart of accounts and metadata. Confirmed GL and Hyperion Essbase were in sync for all month-end reporting, which resulted in reducing month’s end close date by one day.

In charge of all project related daily transactions request sets for interfaces from Procurement, Accounts Payables and Inventory Sales orders - via Project Manufacturing Warehouse (PMW) and Oracle Time and Labour (OTL) for Project costing. Ensured daily and monthly interfaces from Project Costing to General Ledger and Fixed Assets ran successfully. Responsible for all configurations for Project Costing Foundations and Fixed Assets modules that the business needed to setup for UAT and Production environments.

Key Accomplishments:

Executed major Oracle patch releases and planned, then coordinated, user acceptance testing. Efforts resulted in delivering the major patch release on time and within budget.

Managed projects from start to finish, including helping gather requirements, then team up with IT to create interfaces from Oracle to extract GL data, and then load budgets from Hyperion Essbase to Oracle.

Launched Hyperion Essbase SmartView. Created relevant training documentation. Trained end users, which resulted in reduced support calls and issue logs to less than three per week.

Received customer first team award.

Call-Net Enterprises, Inc. Toronto, ON 2004-2005

Financial Systems Analyst

Assisted with vendor selection, negotiations, and prepared the cost benefit analyses for different projects, including the employee expense reimbursement solution packages, which resulted in the selection and implementation of the best product available. Helped troubleshoot and rectify finance user issues and challenges for those using PeopleSoft Financials in an Oracle DB environment. Supported accounts payable and procurement application modules. Configured PeopleSoft Finance security and set up users. Maintained the PeopleSoft workflow matrix.

Key Accomplishments:

Reduced costs and duplication of efforts by 50 percent and drastically improved accuracy after incorporating the best employee expense reimbursement solution package.

Helped clients select the best solution to their situations, including the electronic fund transfer solution from TD Bank for vendor payments. Prepared the cost benefit analysis and recommendations for the project, which resulted in reduced costs of 50 percent, along with improved accuracy and timely payments to vendors.

Deloitte Consulting Toronto, ON 1999-2004

Senior Consultant, PeopleSoft

Performed numerous duties as technical team lead that called for the implementation of PeopleSoft HR and Financials suite. Investigated, documented, designed, recommended and implemented processes. Created proof of concept and training documentation where applicable.

Key Accomplishments:

Fulfilled the project life cycle for a Transition Period Audit Reporting system for Toronto Dominion Bank, which would track and audit duplicate data entry in two systems, to ensure they were in sync.

Guided the project life cycle for ENMAX Power Corporation, which called for developing asset management reporting.

Fulfilled the project life cycle for Ontario Lottery and Gaming Corp. (OLGC), which involved the conversion from Legacy to PeopleSoft E&G Financials. Processes included accounts payable, vendor master, general ledger, budgets, and purchasing.

Led a technical team at Independent Electricity System Operator (IESO) - that designed and implemented conversion processes from PeopleSoft HR and Payroll to Ceridian HR & Payroll. This required reverse engineering. Completed with 100 percent accuracy. Gave clients the ability to create reports from MS Access database.

Canadian Tire Toronto, ON 1994-1999

Senior Programmer-Analyst

Conducted a fit/gap analysis with team members to discover resolutions that would close gaps. Customized the standard chart of account for PeopleSoft. Retrofitted all customizations. Successfully Implemented Essbase consolidated reporting by bringing in data from various general ledgers of the subsidiaries.

Key Accomplishments:

Successfully upgraded PeopleSoft Financials to the next release – within time and budget.

Sales and Marketing

Designed and implemented an assortment planning and pricing simulator system in a mainframe environment, which allowed buyers to negotiate with vendors and instantly see the effect of pricing on their bottom line.

Education & Training

Bachelor of Science, computer Science

CITY OF BIRMINGHAM UNIVERSITY Birmingham, UK

Oracle R12 Asset Management & Project Costing

Oracle Sub-Ledger Accounting

Oracle Essbase Boot Camp

Oracle 11i Project Foundation Fundamentals

Oracle 11i Asset Management Fundamentals

PeopleSoft delta 8

PeopleSoft Technology Certified Consultant



Contact this candidate