- Constructed advanced SQL queries to pull data, group data, and extract actionable insights- Created reports with multiple sheets in excel using pivot tables and charts and advanced excel functions- Reduced the report update time by automating report updates with writing VB Macros in excel- Created and updated different entities such as contracts and work orders in both emaint and Metrix- Created reports in and extracted data from emaint and updated the database using… Show more - Constructed advanced SQL queries to pull data, group data, and extract actionable insights- Created reports with multiple sheets in excel using pivot tables and charts and advanced excel functions- Reduced the report update time by automating report updates with writing VB Macros in excel- Created and updated different entities such as contracts and work orders in both emaint and Metrix- Created reports in and extracted data from emaint and updated the database using emaint- Created standard forms for data entry requests that reduced the number of emails sent between the departments- Worked jointly with groups in operations, and IT and others within and outside of the company to implement best practices and share knowledge- Identified data quality issues and work with the operations team to clean and correct the data Show less

- Gathered data from different data sources such as Compustat, Datastream, and Boardex. Also, hand collected data for Patent and Citation using Canadian Intellectual Property Office database and google patent search and the Lens database.- Using R to clean the data and match the records from different database- Hypothesis development and modeling using different statistical methods- Tested significant hypothesis on the relation between board diversity and the firm innovation using… Show more - Gathered data from different data sources such as Compustat, Datastream, and Boardex. Also, hand collected data for Patent and Citation using Canadian Intellectual Property Office database and google patent search and the Lens database.- Using R to clean the data and match the records from different database- Hypothesis development and modeling using different statistical methods- Tested significant hypothesis on the relation between board diversity and the firm innovation using regression analysis Show less

Instruction and problem-solving sessions for Application of Statistical Methods in Business, Business Forecasting Analytics, and Finance Theory courses registrants, helping them to grasp the technical concepts more thoroughly and prepare them to tackle the material throughout the semester.

- Developing valuation models to estimate the intrinsic values for 10+ large corporations and preparing Master Budget Plans for Steel companies- Preparing Business plan for two active firms in Tourism Industry and conducting feasibility study for them- Oral and written presentation of the results of valuations, BPs, Budget Plans, etc. to the managements and other relevant parties- Building and coaching focus groups and strategic planning work groups to develop strategic plans and… Show more - Developing valuation models to estimate the intrinsic values for 10+ large corporations and preparing Master Budget Plans for Steel companies- Preparing Business plan for two active firms in Tourism Industry and conducting feasibility study for them- Oral and written presentation of the results of valuations, BPs, Budget Plans, etc. to the managements and other relevant parties- Building and coaching focus groups and strategic planning work groups to develop strategic plans and perform M&A projects- Conducting financial analysis using financial statements and financial ratios and reporting the results in BI (Qlickview, Power BI) and word- Managing the production, marketing, sales, and customer service of a financial product called "data for students", which was providing students with the data required for their research- Retrieved data from a relational database using SQL programming for analytical purposes- Cleaned and manipulated big industry level and firm level financial data and economical data using R, or Excel based on the data size for analytical purposes Show less

- Developing a portfolio evaluation algorithm leveraging MCDM methods (e.g., TOPSIS) based on financial ratios to report the ranking of the investment portfolios disclosed in Tehran Stock Exchange- Portfolio optimization using Bi-Criteria models as well as Multi-Criteria methods- Conducting financial analysis using financial statements and financial ratios and reporting the results in BI (Qlickview, Power BI) and word- Developing valuation models to estimate the intrinsic values