Mohsen Farrokhrouz

Mohsen Farrokhrouz PROFESSIONAL PROFILE Various experiences in the field of data analyst role including data modelling, data pipeline and workflow design, dashboards preparation in Power BI and Tableau for in-depth analysis and visualisations for the stakeholders and machine learning models for the training and prediction of the general trends of the business. At the same time, good experience as a field engineer, office simulation engineer, laboratory technical/research fellow and teaching experiences. Engagement with these different activities, equipped me with excellent communication and stakeholder engagement capabilities as well as exceptional problem-solving and decision-making skills. Innovative and collaborative professional ready to utilise technical skills and subject matter expertise to support the growth and sustainability of the organisation. In addition, working with the youngsters in the role of lecturing, tutoring and mentoring blessed me more effective communication with this generation and involvement with their requirements. EDUCATION & QUALIFICATIONS Graduate Certificate in Data Analysis University of Western Australia // 2022 – 2023 Master’s degree in engineering (Chemical Engineering) Adelaide University // 2019 – 2022 Master of Engineering Science (Petroleum Well Engineering) Curtin University of Technology (Dual Degree) // 2006 – 2007 Bachelor of Science in Mining Engineering School of Mining Engineering, Tehran University, Iran // 2001 – 2005 PROFESSIONAL SKILLS Data Modelling and Data Pipeline Preparation Research Conducting and Data Management Marketing Optimisation Technical Reporting Teamwork Capabilities and High Adaptability Data Collection & Analysis CORE COMPETENCIES • Demonstrated ability to effectively communicate ideas, concepts, and outcomes to varying audiences in varying formats, including oral communication, presentation and written communication. • Strong analytical aptitude with the ability to collect, analyse and disseminate significant amounts of information with exceptional attention to detail and accuracy. • Strong computer skills with proficiency in Microsoft Office suite and specialised systems and programs including: • General: AutoCAD, Photoshop, FreeHand, MS Project, MINITAB • Energy: OFM, CMG, Drilling Office, Eclipse (E100, E300), Surfer, Pipesim, PanSystem, Prosper, PHREEQC • Data Analysis: Python, Pandas, MongoDB, SQL, NoSQL, Tableau, Power BI, JavaScript, AWS, Flask, Google Analytics • Logging: Emeraude, Kappa, LogPlot, Metrowin • In-depth understanding of best practice on engineering of integrity for the field operations. • Demonstrated experience integrating various technical and business activities on multi-discipline projects, which include supervision of technical activities. • High degree of organisational and time management skills with the ability to independently follow through to successful completion of projects within a deadline. • Proven leadership ability with a focused determination in fostering teamwork and addressing challenges. EMPLOYMENT HISTORY Financial Data Analysis Fleetcare, Wangara // June 2024 – Present • Data streamline preparation and new database modelling, transferring from Microsoft Access to SQL Server management system for better access to the information and ensuring integrity and accuracy • Ad hoc reports preparation extracting from SQL Server for the stakeholders, applying filtering, joining and function definitions in SQL scripts • Building and maintaining dashboards in Power Bi, Tableau; enabling the end users for decision making and in-depth financial analysis • Proposition for data-driven business strategies based on the ML models (Supervised and Unsupervised) along with the company marketing and client satisfaction strategies • Data pipeline and ETL preparation in Azure, Python, JSON data preparation (NoSQL) and statistical analysis in R • Advertisements managements using Google Analytics and Google Ads by dataflow importing into Power BI and other financial analysis software • Monitor weekly and monthly performance to foster compliance to plan Clinical Data Analysis Perth Children’s Hospital, Perth // February 2024 – May 2024 • Data pipeline preparation through importing data from different resources including SQL Server, spreadsheets, REDCAP and JSON data types • Planning and strategy selection through pattern identification and anomalies in big data and present their findings and recommendations to colleagues, researchers and leaders in healthcare. • Developing interactive dashboards in Power BI tailored to client and stakeholder requirements using SQL queries. • Applying Machine Learning (ML) models to predict the projected future of cancer data in Paediatrics environment focusing on two scenarios of demand and capacity in Perth Children’s Hospital (PCH). Production Data Analysis BHP/ WAIO/SF, Newman // August 2023 – January 2024 • Support the development of data models and ETL processes to ensure high-quality and accuracy of data ingestion into Snowflake. • Collaborate with senior developers to design and implement effective data workflows and transformations. • Loading data from Snowflake into Power BI and/or Python environment for creation of different tables and visualisations based on the business requirements for better monitoring, development, and improvement of data management • Using Snowflake to join multidimensional databases around fact tables and export data into dashboards for the stakeholders while enhancing storytelling and data interpretation • Benchmark, monitor and analysis the performance of the production processes and outcomes to enable improvement opportunities, • Monitor weekly and monthly performance to foster compliance to plan (C2P), • Work with the execution team to generate practical, safe, sustainable solutions to drive stability and improve overall mining capability, • Support implementation of solutions by facilitating the management of change process for frequent and ad hoc projects, driving accountability for the plan and validating the delivered value, Key Achievements: • Successful accomplishment of more than 20 compliance reports. • Production enhancement by around 10% for the three-month period. • Schedule and design of short-term, mid-term and long-term plan using actual data Laboratory Data Analysis Edith Cowan University // Nov 2022 – June 2023 • Creation of database on core flooding measurements and analysis of pressure drop across the core and saturation profile determination through python, VBA and mathematical modelling. • Analytical study on US YouTube data and extraction of effective parameters on the number of views and recommendations for the freelancers using python, pandas and Matplotlib. • Build mapping data on weather forecast of Australian states using Leaflet, JavaScript and JSON data from Weather Open Map data center. • Extraction of data from csv and excel files using pandas and making data frames, arrangement of the columns, data modelling and exporting data into SQL server and mongo DB file. • Extracting data from webpages using ETL, API, Flask, Alchemy, Beautiful Soup and JSON files and visualization of the results through different tools of graph plotting in Matplotlib, Leaflet, Pandas and Tableau. Laboratory Technical Assistant Edith Cowan University // May 2021 – Present • Conducting a range of laboratory experiments to measure oil/ live brine / Sc CO2 PVT properties. • Measurement and laboratory study of rock-fluid interaction properties (relative permeability curves, contact angle, interfacial tension, brine permeability, fracture conductivity). • Geochemical study of supercritical CO2 in porous medium and reservoir simulation using PHREEQC/CMG • Full coverage over fundamental mineral property measurement in the laboratory • Assessment on engineering geology experimental results and desk study reviews • Working on high-tech setup for conductivity measurement of the fractures • Full knowledge of core flooding tests and two-phase fluid flow models Reservoir Engineer South Zagros Oil & Gas Production Co // October 2019 – April 2020 • Performed well tests on oil and gas wells in the field, including setting up equipment for testing and database preparation based on data collected from the test. • PFD/P&ID development using different techniques like isolation, tie-in, process simulation, relief system evaluation and equipment sizing/specification for oil and gas upstream. • Perforation and PLT, well completion cleanup as client representative. • Monitor and history match production parameters to understand the behavior of well and reservoir. • Size relief valve for controlling overpressure scenario and perform inlet and outlet line pressure drop calculations. • Calculations on pressure drop across the chokes and two-phase formation across that. • Simulation of well/flowline system of producing gas field during production/shut down scenarios, short-term gas production forecasting and flow assurance using Prosper. • Participated in technical meetings (design and P&ID reviews, MOC, HAZOP, Vendor/Client meeting, etc.) • Hydraulic study including, pumps and control valves for single circuit or entire unit. Key Achievements: • Successful accomplishment of 10+ different projects in less than a year working experience. • Effectively reduced the costs of the company by €100k. • Bonus stock and monetary compensation for two successive projects. Research Fellow Australian School of Petroleum // July 2018 – September 2019 • Defined new research pathway using previous field experience as well as software knowledge. • Carried out a specified research program under the direction of the project investigator. • Conducted own and original research and high-tech experimental design. • Performed simulation and modelling of reservoir data. • Calibrated laboratory and field data with numerical models. Key Achievements: • Accurate planning of the experimental setup. • Perfect matching of reservoir simulation model with experimental data. • Preparation of comprehensive database on reservoir optimization data available in the literature. REFERENCES Available on request