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• Worked with department supervisor for month end reporting, balance to trial balance general ledger and published financial reports using Great Plains system• Developed Manual Entry Account coding system used by Data entry specialists within department

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 recommendations for improvements and system automation• 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, Calculated Payments, and Accrued payments to Account Balances in General Ledger • 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 by segment managers and senior management • Carried out Financial Due Diligence, competitive analysis, for Large Business deals, $1 million plus, requiring financial & managerial approval

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 system needs of department and business segment as a whole Created own user acceptance testing, regression testingCreated ad hoc reporting of important business metrics/management projects by running queries against data warehouse via SQLCarried out and presented financial ratio analysis concerning alternative calculation methodologies to senior directors within Loblaw's Finance department Conducted sales trend analysis for group of selected stores attending Loblaw's national training program "Learning Means Business" for the purpose of improving operations across their sales regions and districtsCreated own user acceptance testing, regression testing and implementation review program with 100% accuracyActed as post production support for new system usersManaged electronic data interchange program issues relating to DVD invoice auditing, invoice payment, process workflows and vendor management

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 • Assist staff with excess work load• Also learn and train on other jobs within the department

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.