Sima Ramin Email & Phone Number

London, Ontario, Canada

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.Some of the tasks:• 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… Show more 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.Some of the tasks:• 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 decodeing 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 99M oil change-related records and 10.5M tire rotation-related records to the database with 99% accuracy. Show less

London, Ontario, Canada

• Map vehicle trim & options data accurately to increase data integrity along with consumer and dealer confidence.• Map service data to improve decoder rates for increased accuracy on the VHR (vehicle history report).• Investigate and resolve unmatched or ignored source data.• Audit and approve mappings. Provide and update new mapping taxonomy when needed.• Explain findings at an executive or granular level depending on the stakeholder.• Adhere to the documented best… Show more • Map vehicle trim & options data accurately to increase data integrity along with consumer and dealer confidence.• Map service data to improve decoder rates for increased accuracy on the VHR (vehicle history report).• Investigate and resolve unmatched or ignored source data.• Audit and approve mappings. Provide and update new mapping taxonomy when needed.• Explain findings at an executive or granular level depending on the stakeholder.• Adhere to the documented best practices and identify opportunities for improvement. Show less

London, Canada Area

• Collected customer information and input data into the CRM and Excel files and updated the database constantly and provided visual reports for managers while always ensuring confidentiality.• Assisted customers with transfers, check cashing, deposits, withdrawals, etc.• Provided banking information to the customers for opening checking or savings accounts and offering proper solutions.• Assessed the risk associated with extending credit lines for 1,700 accounts based on credit… Show more • Collected customer information and input data into the CRM and Excel files and updated the database constantly and provided visual reports for managers while always ensuring confidentiality.• Assisted customers with transfers, check cashing, deposits, withdrawals, etc.• Provided banking information to the customers for opening checking or savings accounts and offering proper solutions.• Assessed the risk associated with extending credit lines for 1,700 accounts based on credit data and financial statements.• Recognized for high performance through performance evaluation chart of the branch. Show less

Tehran Province, Iran

• Arranged sales operations and supply chain processes for exporting Steel Billets to Middle East and Europe.• Coordinated all export processes with involved parties such as customers, freight forwarders and logistics and warehouses.• Produced all necessary analytical reports and documentations regularly.• Provided ad hoc reports and analysis to answer specific questions by using visual formats.• Performed all organizational duties such as creating process documents, reporting… Show more • Arranged sales operations and supply chain processes for exporting Steel Billets to Middle East and Europe.• Coordinated all export processes with involved parties such as customers, freight forwarders and logistics and warehouses.• Produced all necessary analytical reports and documentations regularly.• Provided ad hoc reports and analysis to answer specific questions by using visual formats.• Performed all organizational duties such as creating process documents, reporting, customer service supports and follow-ups and ensured timelines were met.• Prepared financial and sales reports and identified trends and all the issues and opportunities in the market for better assessment of business performance. Show less

Tehran Province, Iran

• Coordinated and executed the import processes such as finding vendors or suppliers, handling frequent meetings, negotiating for best prices, signing contracts, finding most reliable freight forwarders and transportation companies, and delivering the goods to the warehouse of the factory.• Cooperated with many strong vendors in Germany as their exclusive or official distributor.• Provided analytical regular reports and dashboards to show meaningful trends and finding threats and… Show more • Coordinated and executed the import processes such as finding vendors or suppliers, handling frequent meetings, negotiating for best prices, signing contracts, finding most reliable freight forwarders and transportation companies, and delivering the goods to the warehouse of the factory.• Cooperated with many strong vendors in Germany as their exclusive or official distributor.• Provided analytical regular reports and dashboards to show meaningful trends and finding threats and opportunities internally and externally.• Provided training for customers through marketing and sales meetings presenting strong knowledge and reliable information about the technical details of all products.• Coordinated multiple projects effectively, influenced, negotiated, and communicated with internal and external business partners, contractors and vendors effectively and efficiently.• Prepared PowerPoint presentations and presented products to the customers in the sales meetings.• Coordinated marketing and sales activities such as in-person meetings, arranging regular seminars and events for the clients, which helped foster long-term client relationships. Show less

Graduate Certificate, Business Analysis

Relevant Courses completed: • Project Management • Business Analysis in the Agile Organizations • Business Architecture • Solution.

Graduate Certificate, Professional Financial Services, Banking And Finance

Relevant Courses completed: • Canadian Securities • Financial Planning • Strategic Clients Engagement • Insurance Planning • Retirement.

Master'S Degree, Business Administration, International Business