SGS Gulf
SGS Gulf Limited
Total des années d'expérience :9 years, 5 Mois
Automated expense claim posting using SQL ( Microsoft SQL Server), saving posting team time and minimizing errors
Built excel-based financial statements (balance sheet and Income statement) from system generated text files using Microsoft Power Query, VBA and other formulas (xlookup, sumifs, IFs etc) for Eastern Europe entities.
Set up company Power BI services (workspaces and gateways) and controlled access using Row Level Security.
Automated generation of income statements and bad debt monitoring dashboards for 18 Gulf entities using Microsoft Power BI.
Assisting with end-of-month financial reporting.
Assisting in project management activities.
Offering technical support to users of the company ERP systems
Formulating data driven KPIs and monitoring performance
using Statistical Process Control
Using Tableau to build visualizations and dashboards
Using Market basket analysis to optimize product offerings
Presenting and reporting insights to management
Used Looker Studio and Excel to build and maintain executive and operational level reports and dashboards
Crafted Process behavior charts to help technical team monitor daily electricity and water consumption
Built a forecasting model to predict electricity, water and chilled water consumption and expenses for clients
Built a regression model to estimate electricity consumption based on temperature and occupancy rate for the company’s hotel
clients
Formulating data driven KPIs and monitoring performance.
Used Power BI and Excel to build and maintain reports and dashboards
Sales and revenue analysis and forecasting
Spearheaded the adoption of company CRM
Book keeping, invoicing and VAT filing.
Monthly presentations to update the team on the state of the business
Collecting data from different sources and updating the database
Data validation, cleaning and wrangling on spreadsheets
Trend and statistical analysis
Writing SQL queries, data visualization and reporting
Collecting quality related data and analyzing it
• Statistical Process Control - using process behavior charts
• Taking part in company Six Sigma projects
Fundamentals of Statistics • Machine Learning and Deep Learning using Python • Probability – The Science of Uncertainty and Data
(