Arezoo Afrouzeh Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

• Determining best methods to gather, model, manipulate, automate and present data to internal teams and external clients
• Looking for opportunities to streamline and/or automate various reporting processes to help support internal teams (mostly use Excel and Tableau Prep) and continuously looking for ways to improve accuracy
• Developed database objects, including tables, views and materialized views using SQL and writing SQL scripts to query and report data from databases
• Extracting, manipulating and cleaning raw data from various data sources (offline and online) using advanced Excel spreadsheet functions
• Design and publish dashboards using Tableau and Datorama
• Provided client reporting and analysis including client's onboarding (Media Ocean, Datorama, TVSquared), dashboard development and maintenance for media and digital campaigns

Montreal, Canada Area

• Fully managed retail client's sales and merchandising data from different data systems
• Responsible for sales performance reports and doing analysis to reveal customer segmentations and revenue win/loss in excel
• Monitored sales KPIs and present areas of opportunities to management for operational adjustment and provide analytical support to the Sales and Revenue Management teams
• Developed & Managed daily, month-end, quarterly reports and ad-hoc reports for financial, sales and management reporting
• Design and Build Tableau dashboards for productivity performance monitoring and Feeding back all suggestions for improvement
• Solving data-related issues for our partner and collaborate with the collection and organization of data from various data sources

Tehran Province, Iran

• Perform duties such as collecting, analyzing, managing, mapping, and visualizing large data sets
• Queried database for relevant information
• Develop and schedule reports in SSRS, EXCEL, and PowerPoint
• Filter data, and review performance indicators to correct any ambiguities
• Suggested and discussed methods to improve performance and solve problems
• Generating company management reports and documents based on each department’s request

Tehran Province, Iran

• Analyze business requirements documentation to design test cases
• Work with developers to identify the source of software issues
• Writing bug reports and presenting findings to software development
• Identify project risks and recommend actions to minimize risk