Hamed Sarshoghi

Analyze, validate, and reconcile large regulatory datasets to support reporting accuracy, compliance, and data quality. Perform data extraction, cleaning, cross-database analysis, issue investigation, and reporting automation using SQL, Python, Microsoft Access, Excel, Power BI, VBA, and Microsoft Dynamics 365 CRM. Communicate findings and process updates to internal stakeholders and support continuous improvement in reporting workflows.

-Ethics for Design, AI, and Robotics - DTI5310 -Applications of Information Technology for Business - ADM1370

Managed marketing and commercial analytics activities for FMCG beverage and food products, supporting business planning, sales strategy, campaign evaluation, and performance improvement. Analyzed sales, revenue, promotion, customer, channel, and market data to identify trends, risks, opportunities, and business recommendations. Prepared dashboards, recurring reports, and presentations for senior managers and cross-functional stakeholders using Excel, Power BI, SQL, and VBA. -Evaluated trade marketing activities, promotional campaigns, advertising initiatives, revenue impact, cost efficiency, and profitability. -Supported marketing and sales strategy development through analysis of market trends, pricing, product performance, and channel results. -Tracked national campaign performance and provided insights that contributed to improved sales results, including a reported 40% sales increase.

Supervised strategic planning and commercial analytics activities for an FMCG business, supporting sales performance analysis, market trend evaluation, KPI reporting, and business planning. Analyzed sales, market, product, and operational data using SAP, Excel, Power BI, SQL, and VBA to identify trends, performance gaps, and business opportunities. Prepared dashboards, recurring reports, and strategic presentations for senior managers and cross-functional stakeholders. -Developed business roadmaps covering marketing, sales, cost estimation, action plans, and performance improvement opportunities. -Conducted market trend and KPI analysis to support product promotion decisions, campaign planning, and strategic business reviews. -Automated recurring KPI reporting processes, reducing reporting turnaround time from one day to less than one hour.

Supported feasibility analysis, planning, budgeting, contractor coordination, and cross-functional project execution for investment and development projects, including a 60-hectare recreational and tourism complex in the Khalij-e Fars region. Coordinated with consultants, architects, designers, contractors, and senior leadership to support project planning from feasibility assessment through design approval. -Conducted feasibility studies for entertainment and recreational components of a large-scale tourism complex. -Supported contractor evaluation, negotiation, and selection for domestic and international vendors. -Coordinated project workstreams involving consultants, architects, designers, graphics teams, and external stakeholders. -Supported team selection, consultant coordination, budget monitoring, and progress reporting to the CEO. -Contributed to project documentation and planning that supported approval by the relevant state office. Key achievement: Coordinated feasibility, team selection, design planning, and stakeholder documentation for a major tourism development project that received approval from the relevant state office.

The actual date of doing projects was between 2010-2015 1. A survey on assessing the impact of design variables on the concept data model outcome efficiency by using an Artificial Neural Network (ANN) 2. Survey on Maturity models in Project Management and selecting the best model with Analytical Network Process (ANP) methodology and solving with Super Decision software), 3. Recycling Business Plan. 4. Responsible for the marketing research team of Tolypers Co. 5. Member of the marketing research team of Sony Co 6. Maintenance of Lole va Mashin Sazie Co. 7. Feasibility study of Yataghan

-Digital Marketing -Intelligent Health Informatics: LLMs in Healthcare, Project: RAG Chatbot+LIMA3 for Clinical Trails -Application of Data Science: using Python for Machine Learning/ NLP/ ChatBot Project: Symptom-disease chatbot: using Dialogflow chatbot, NLP and Clustering techniques -Fundamental of Data Science: using R for Data Cleaning /Data Visualization/ Classification/ Clustering -Cybersecurity: Risk assessment /Threat mitigation/ security frameworks such as NIST, ISO 27001, and CIS Controls. -Ethics for Design, Robotics and Artificial Intelligence

Thesis: Positioning and layout of products in a cross-docking system and solving it with Meta-Heuristics Algorithms (Advisor: Prof. R. Tavakkoli Moghadam., Industrial Engineering Department, University of Tehran) - Statistical Analysis/ Advanced MIS/ Decision Theory in Management /Management Accounting (all A+) -Meta Heuristics Algorithms -Mathematical Modeling -ANN (Artificial Neural Network) -Simulation (ED, Vensim, ..) -Decision Making (AHP, ANN using Super Decision software) -Project Management Maturity models -Cross Docking (Warehouse Designing)