Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sima Ramin

London

Summary

Experienced Business Data Analyst with a strong analytical background and a track record of driving data-driven decision-making. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seeking a Data Analyst position to leverage my expertise in analyzing big datasets, implementing metrics, and improving data quality to inform growth and marketing strategies.


Overview

13
13
years of professional experience

Work History

Business Data Analyst

Carfax
09.2020 - Current
  • Analyzing big datasets (millions of records) to determine quality, accuracy, completeness, and usability of products as a Business Data Analyst
  • Getting data providers ready for integration with CARFAX
  • Conducted data analysis, research, and report creation using SQL, R, and Excel
  • Implemented multiple monthly metrics in Excel, R, and proficient in query and report writing for the company dashboard
  • Identified data discrepancies, errors, root causes, troubleshot solutions, and modified data by handling tickets in ServiceNOW
  • Implemented multiple monthly metrics in Excel and R for the company dashboard
  • Established new data provider relationships through Salesforce and Secret Server in collaboration with internal stakeholders
  • Maintained strong relationships with external clients and data providers, effectively resolving issues through communication
  • Coordinated with Finance to set up Purchase Orders and invoices via SAP Concur
  • Utilized job management tools such as JIRA in an Agile environment within the Scrum Framework
  • Mentored and assisted new hires in using internal tools and applications
  • Contributed to and coordinated multiple cross‑functional projects, consistently meeting and exceeding project deadlines
  • Improved data quality, data integrity, and enhanced decoding rates and accuracy within Vehicle
  • History Reports by meticulously sorting and mapping raw data to various services' target displays
  • Reviewed and mapped 140k lines of raw language during my internship, resulting in the addition of oil change‑related records and 10.5M tire rotation‑related records to the database with 99% accuracy.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Collaborated with stakeholders to identify business needs and data sources.

Customer Representative

Scotiabank
11.2019 - 09.2020
  • Processed various transactions with accuracy and according to bank standards and legal requirements.
  • Collected customer information and input data into the CRM and Excel files, ensuring constant database updates and providing visual reports to managers while maintaining confidentiality
  • Assisted customers with various banking transactions, including transfers, check cashing, deposits, withdrawals, and account openings, offering tailored solutions as needed
  • Assessed credit risk for 1,700 accounts based on credit data and financial statements
  • Received recognition for outstanding branch performance.
  • Educated customers about available services, products and bank resources.
  • Arranged monies received in cash boxes and coin dispensers according to denomination.
  • Trained new hires on customer service policies and procedures.

Business Supervisor and Coordinator (Export Dept.)

Pasargad Steel Complex
03.2018 - 12.2018
  • Authorized and supervised the export of Steel Billets to the Middle East and Europe, managing the entire export process from supplier selection to cargo delivery
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Conducted internal audit for export compliance.
  • Resolved financial discrepancies and customer billing issues with timely attention.
  • Coordinated with vendors and suppliers to facilitate timely payments.
  • Implemented project management techniques to overcome obstacles and increase team productivity.

Business Supervisor and Coordinator (Import Dept.)

Tablofaz Co
08.2010 - 03.2018
  • Managed the importation of goods from various countries.
  • Supervised and directed a team of 4, overseeing multiple projects simultaneously, and effectively communicated with internal and external business partners, contractors, and vendors.
  • Executed all aspects of imports, from shipment approval and tracking to customs clearance, inventory management, and routing to the warehouse.
  • Managed orders, organized product shipments, and delegated tasks according to employee strengths and order sizes.
  • Maintained customer satisfaction ratings of over 95 percent for seven years.
  • Coordinated shipments of product from country of origin to final destination by both air and land transport.
  • Confirmed accurate freight duties and bills of lading for shipments by collaborating with customs brokers.

Education

Post Graduate Certificate - Business Analysis

Fanshwe College
London, Ontario
12.2020

Post Graduate Certificate - Professional Financial Planning

Fanshawe College
London, Ontario
12.2019

MBA - Business Administration And Management

Tehran Azad Univerity
Tehran, Iran
09.2018

Skills

  • Microsoft Excel (Pivot Tables, vlookup)
  • SQL
  • R, Python
  • Tableau
  • Salesforce
  • Jira
  • SAP Concur
  • Postman
  • Confluence
  • Visio
  • PowerPoint
  • Power BI

Timeline

Business Data Analyst

Carfax
09.2020 - Current

Customer Representative

Scotiabank
11.2019 - 09.2020

Business Supervisor and Coordinator (Export Dept.)

Pasargad Steel Complex
03.2018 - 12.2018

Business Supervisor and Coordinator (Import Dept.)

Tablofaz Co
08.2010 - 03.2018

Post Graduate Certificate - Business Analysis

Fanshwe College

Post Graduate Certificate - Professional Financial Planning

Fanshawe College

MBA - Business Administration And Management

Tehran Azad Univerity
Sima Ramin