Soha Simafar

Manage the collection, cleaning, and analysis of data using Excel, Power Query, and NetSuite tools to enable data-driven decision-making across multiple business units.
Utilized Power BI with advanced DAX calculations and Power Query transformations to create interactive dashboards and comprehensive reports, integrating data from diverse sources to support cross-functional analytics.
Designed and executed SQL queries for targeted data extraction, enhancing reporting accuracy and enabling high-level business insights.
Performed data cleaning and wrangling on large datasets to prepare for exploratory data analysis (EDA).
Managed data imports and exports between NetSuite and other integrated systems, ensuring data quality, consistency, and secure data flow across platforms.
Developed and maintained custom saved searches in NetSuite for efficient data retrieval and streamlined reporting, tailoring results to meet specific department requirements.
Administered user roles and permissions within NetSuite, upholding data security protocols and compliance standards across the organization.
Coordinated the integration of NetSuite with subsidiaries, including Lion and Sandbox, to support consolidated data analysis and reporting.
Provided first-line IT support for system requests and maintained over 20 customer-specific portals, enhancing user accessibility and meeting tailored customer needs.
Implemented API integrations and conducted web scraping to automate data workflows, reducing manual workload and ensuring timely data updates across platforms.
Conduct ad-hoc data analysis to support specific business initiatives and projects.

• Manage the collection, cleaning, and analysis of data using Excel, Power Query, and NetSuite tools to enable data-driven decision-making across multiple business units.
• Utilized Power BI with advanced DAX calculations and Power Query transformations to create interactive dashboards and comprehensive reports, integrating data from diverse sources to support cross-functional analytics.
• Designed and executed SQL queries for targeted data extraction, enhancing reporting accuracy and enabling high-level business insights.
• Performed data cleaning and wrangling on large datasets to prepare for exploratory data analysis (EDA).
• Managed data imports and exports between NetSuite and other integrated systems, ensuring data quality, consistency, and secure data flow across platforms.
• Developed and maintained custom saved searches in NetSuite for efficient data retrieval and streamlined reporting, tailoring results to meet specific department requirements.
• Administered user roles and permissions within NetSuite, upholding data security protocols and compliance standards across the organization.
• Coordinated the integration of NetSuite with subsidiaries, including Lion and Sandbox, to support consolidated data analysis and reporting.
• Provided first-line IT support for system requests and maintained over 20 customer-specific portals, enhancing user accessibility and meeting tailored customer needs.
• Implemented API integrations and conducted web scraping to automate data workflows, reducing manual workload and ensuring timely data updates across platforms.
• Conduct ad-hoc data analysis to support specific business initiatives and projects.

Delivered comprehensive store support, including cashier duties, product assistance, and customer care.
Drafted reports on customer accounts, improving service efficiency and customer satisfaction.
Prepared regular reports on sales trends and customer feedback to support management in strategic decision-making and service improvements.

Collected, cleaned, and integrated sales data from CRM, ERP, and multiple portals, ensuring data accuracy and reliability for in-depth analysis and reporting across sales and operations teams.
Created interactive Power BI dashboards, reducing manual reporting time by 50% and enabling teams to access real-time data insights for strategic decision-making.
Established monthly and seasonal sales targets using historical data and market trends to guide inventory planning and optimize stock levels, reducing overstock by 30%.
Regularly analyzed the sales pipeline to identify drop-off points and recommended data-driven adjustments to enhance conversion rates and optimize the sales funnel.
Developed and maintained predictive models for sales forecasting, supporting inventory and resource planning by providing insights into sales trends and demand patterns.
Delivered data-driven reports and dynamic dashboards, providing actionable insights to management for performance tracking and strategic planning.
Monitored key sales performance metrics, refining sales processes to improve accuracy, efficiency, and data transparency across the organization.
Collaborated with cross-functional teams to enhance data integrations within CRM and ERP systems, expanding reporting capabilities and ensuring data consistency.
Conducted targeted analyses to evaluate the impact of sales promotions and customer purchasing behavior, assisting management in adjusting strategies based on findings.

Developed an automated reporting application using SQL, Access, and ASP.net, streamlining reporting processes and reducing manual work to improve overall efficiency.
Designed and implemented database solutions using Access and SQL to ensure data accuracy and integrity, supporting reliable data management and manipulation.
Collaborated with stakeholders to gather requirements, provide progress updates, and ensure successful implementation of the application, enhancing reporting capabilities.