Data Analyst
Seyfarth
مجموع سنوات الخبرة :14 years, 11 أشهر
Analyzed, cleaned, mapped, and validated Amazon Applicant Flow data via SAS and SQL annually for 2019 and 2020.
Developed Affirmative Action Plans and Compensation analysis t-test (A/B test) on yearly basis for clients via Excel (Pivot, VLOOKUP, etc.) with yearly revenue over $544, 000.
Developed data tools for Analytics team via VBA, SQL, and SAS to facilitate and speed up the process of cleansing, mapping, and analyzing the data efficiently.
Key user in implementing ERP System (SAP Business one) for company’s big customers.
• Managing new sales developments project PCM (Partner Channel Management).
• Conduct sales achievements analysis monthly reports for Projects, Whole, & Export.
• Responsible about CRM system and conducting CRM analysis monthly report for Projects, Exports, and Dubai sales.
• Train and set BI (Business Intelligence) reports for Concerned Managers.
• Prepare FGCN (Finished Goods Credit note) report for top management.
• Conduct customers & employees surveys as per required and prepare results report.
• Prepare Statistical reports as per required.
• Managing New IT projects in the Trading division including:
1) Collecting and understanding business requirements.
2) Prepare blue print document for SAP consulting team.
3) Testing new developed SAP solution to make sure it is fitting business requirements.
4) Train the business employees on the new IT tool.
5) Conduct statistical reports of the new IT tool for the top management.
6) Troubleshooting technical issues.
• Key user in implementing SAP Cloud for Customer for sales and service teams.
• Key user in implementing SAP Business one ERP for company’s big customers.
• Managing company’s E-commerce website PCM (Partner Channel Management).
• Managing CRM system and conducting CRM analysis.
• Coaching, SAP BI, SAP CRM and SAP ECC (Sales & Distribution Module).
• Sales Channels reports for seek of Planning & Control.
• Conduct customers & employees surveys as per required and prepare results report.
• Prepare Statistical reports as per required.
• Collect and analyze customer’s data from SAP (ERP & BI) systems to make Proposals that improve company’s performance and efficiency.
• Updating & developing ORM (Operation Review meeting) monthly report which contains Sales Analysis regarding (Sales team productivity, Sales channels, Top customers behavior, DSO, Cities ranking, etc…)
• Analyze Wholesales CRM data and present updates on monthly basis.
• Use various software applications and graphing tools (Excel, Access and SPSS), to assemble, manipulate and format data for Business Process Improvement department’s reports.
• Provide Marketing team with Prices, Sales & Stock reports supported by charts.
• Suggest and prepare pricing Studies for all products.
• Create item card for each new product in ERP (Microsoft-Navision).
• Update prices on ERP (Microsoft-Navision) for all products.
1. Programming and Developing Sales Information System (Via PHP and MYSQL),
Which is a web based reporting and evaluation system accessed via (MTN Syria)
Intranet from all over Company's branches in Syrian cities, with limited authentication
And authorization.
2. And making statistical reports about company’s sales. (Via Excel and SPSS).
• Analyze social and economical surveys (Via Excel and SPSS) including:
1. Statistical survey about the people's priorities regarding the life circumstances in Syria, over Syrian cities level and classified by age, gender and education.
2. Statistical survey about internet usage in Syria, regarding the connection type, average hours and the most visited news sites, over Syrian cities level and classified by age, gender and education.
3. Statistical survey about the smoking in Syria to know the cigarette best seller brand, over Syrian cities level and classified by age, gender and education.
4. Daily statistical report about World Cup 2006 matches.
5. Statistical social survey about Syrian youth's values, over Syrian cities level and classified by age, gender and education.
6. Statistical survey for TOTAL Oil and Gas Company regarding the company's charity projects feedback to get a clear vision of people's opinion.
7. Statistical surveys concerning child protection for (High Institute for Demographic Studies and Research) in Syria.
• Master’s degree thesis: comparing two clustering Machine learning algorithms DBSCAN, and K-Means on convex data using (R). • Projects: 1)- Conducted a Generalized Linear Analysis using (SAS), for studying the total enrollment of postsecondary education in USA. 2)- Conducted ANOVA analysis using (SAS) on clinical trial data of PR heart. • Helped statistics instructors in teaching undergrad statistics students STAT-350.