Professional Experience 

Performance Reporting Analyst – Business Intelligence and Reporting                                                          2013 – 2014
Bank of Montreal, Headquarters, Toronto

  • Designed and developed performance measurement reports, metrics and analytics (using SQL/ SAS tools) to measure performance of Personal Banking Segment customer objectives of the Bank of Montreal
  • Focused on implementing weekly reporting to measure short term and long term performance of the customer sales of bank products, i.e. MasterCards, Mortgages, of personal banking customers. These reports supported the customer segment team of the bank in taking business decisions.
  • Launched the Student Campaign spotlight report in a very short period of time, leveraging the knowledge built up through the customer segmentation team and working collaboratively with various stakeholders. This report ensured that the sales force has visibility into their performance throughout the campaign.
  • Developed and delivered the Customer Dashboard online report using SSRS which gave a detailed view of various metrics of personal banking customers.
  • Worked on Ad-hoc data requests, specializing mainly in the three customer segments, students, the Canadian defense and new immigrants.

Statistical Officer (EC-03 Level Contract) - Research and Evaluation Branch                                                   2012 - 2013
Citizenship and Immigration Canada, Government of Canada

  • Produce data tables in response to ad-hoc requests originated from both within and outside the department, ranging from the Minister's Office, Senior Management, internal branches, domestic and foreign media, other federal government departments, foreign governments, private industries and academics.
  • Correspond with the clients and stakeholders (internal and external) through a general mailbox and help answer questions by providing data on immigration, citizenship and population effectively and efficiently.
  • Experience in validating, analyzing, reviewing data and responding to urgent requests (mainly from Minister’s and Deputy Ministers Offices and the media) with tight deadlines and a high level of accuracy.
  • Use Data Cubes (Pivot tables/ Excel formulas) to run detail oriented queries to complete data tables.
  • Follow guidelines on formatting tables, releasing data and rounding data due to privacy considerations, in order to prevent releasing personal information on an identifiable individuals.

Report Development Officer - Performance Management Unit                                                                        2010 – 2011
Citizenship and Immigration Canada, Government of Canada

  • Collected, analyzed, and processed data to create and update a ‘Short-Term Monitoring Tool’ for forecasting Permanent Resident admissions.
  • Redesigned tables and provided calculations and projections to forecast 2012 Levels Planning and calculate processing times for temporary and permanent residents’ applications.
  • Updated and modified power point slides of the monthly Operational Dashboard.
  • Modified and updated the dashboard for ‘Haiti Special Measures’ which gave priority processing for Haitians affected by the earthquake in 2010.
  • Took minutes and completed the Record of Decisions for the Director General Steering Committee meetings.

Web Metrics Analyst (Co-op) – Web Marketing Team                                                                                          2009 – 2010

Halogen Software, Ottawa, ON

  • Created analytical reports and submitted summaries on performance for pay-per-click advertising for Google, Yahoo, and MSN search engine advertising performance (SEO/SEM) in a web marketing environment.
  • Manage account budgets for Yahoo Marketing and MSN Adcentre search engine advertising programs.
  • Help dig new keywords to bid on, create ad campaigns and find data patterns that help with business decisions.
  • Manage and monitor the performance of keywords, weekly and adjust the bids accordingly.

Nishika Kanchani Mampitiya