Mark Mota Email & Phone Number

• Responsible for process design and operational analysis for IT Customer Support & Quality Assurance departments
• Created form and templates utilizing macro for resource management purposes
• Managed trouble ticket reporting process, designed report templates for daily, weekly, and monthly reports for Senior Management and Project Managers
• Developed report from imported XML’s for Daily Reconciliation of outstanding Credit Card Transactions for numerous clients
• Created report user manuals, process & dataflow diagram as part of Business Intelligence reporting requirements

• Job responsibilities include:
• Responsible for Data Analysis, Business Analysis for Commissions Department
• Create SQL scripts for retrieving data from data warehouse for reporting and analysis purposes
• Created Access Databases, queries, and macros for housing data for querying purposes by management, and building reports from scratch
• Handle ad-hoc reporting for department, conduct variance analysis to planned forecast, used in management discussion and analysis
• Create Process Flow diagrams, and Data Flow diagrams for internal departmental reporting, business processes and procedures

• Job responsibilities include:
• Carried out Quantitative Data Analysis, mathematical data analysis creation of Access Databases & necessary Macros to enable management to query Business Metrics and reports
• Reported & Processed, Commission Pay-outs for over 200 Sales Representatives Nation-wide by adapting principles of corporate governed Compensation Plan into compensation processes with HR and Pay-roll departments, made.
• Created first Headcount tracking Report for Canadian Consumer Business Segment, monitoring Operational Expenses, Personnel transfers, and Cost Centre Management, as well as Employee Productivity Analysis
• Drove Customer Account Rebate program, ensure details of Corporate Rebate Contracts with customer were properly measured and built reports to capture profitability of programs in order to make cost recommendations.
• Conducting Market intelligence gathering and Business Segment Support with Pricing Strategy Development, Proforma P&L Management, and the creation of necessary Business Specific Financial Models used in decision making.

Successfully completed numerous systems changes to Mainframe P/L Ledger and issued system and database maintenance supportLiaised with both IT & Accounting departments for mainframe P/L system changes, worked with contacts within national framework, anchoring requirements gathering sessions for both parties, conducted process map documentation and assessed.

• December 2004 to May 2006, Same Day Trade Specialist Officer. Job responsibilities include:
• Settling Canadian market trades within T+3 business days for numerous clients
• Servicing Client needs and Investment Advisor needs to settle trade disputes by investigating any errors and resolve discrepancies as quickly as possible
• Communicating numerous trade issues to Client Advisory Services Group daily in effective and efficient manner
• Compile daily and monthly trade reports for management
• Carry-out multiple projects at the request of department managers

Education record

Bachelor Of Commerce Degree; Master'S Certificate, Specialist In Commerce And Finance; Economics

• Bachelor of Commerce degree, specialist in Commerce and Finance, major in Economics, 2004 • Completed the Canadian Securities Course.