Googan Singh
Purchasing & Sales Analyst
Doha
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Data Analyst with over 7+ years of experience supporting business solution software and analyzing business operations. Have proficient experience in creating and building the dashboards in Power BI and very good in Advanced Excel and SQL. Proficient in SAP(Hana).
Overview
4
4
years of professional experience
3
3
years of post-secondary education
Work History
Purchasing & Sales Analyst
Gourmet Fresh Trading (Abu Khalifa)
DOHA
12.2021 - Current
- Daily Stock in and Stock Out Analysis with Sales and Availability stock in warehouse.
- Daily Al Meera Items wise sales and stock transfer Analysis with Targets & Achievement %
- Standardized inventory quarterly reporting and analysis and instituted corrective action for close-outs and out-of-stock items to keep inventory records current.
- Weekly Items stock order and deliver stock analysis & sales margin report for management from Al Meera outlets.
- Instituted advanced level of data reporting using SAP,Advanced Excel & Power Bi to develop purchasing & sales strategies and identify sales vs purchasing trends.
- Performed monthly reconciliation Inventory Adjustment process in SAP(Hana) including warehouse stock and Al Meera branches stock.
- Employed expert inventory management and oversight skills to formulate business metrics and meet corporate goals.
- Recommended metrics for product availability, costs and delivery to advance business objectives.
- Maintained focus and organization to regularly complete tasks with precision, timeliness and flexibility to accommodate fluctuating assignments and emerging business trends.
- Tracked inventory shipments and prepared spreadsheets detailing item information.
- Weekly and Monthly sales performance analysis with sales Margin & Targets vs Actual analysis share to GM.
Data Administrator
Sports Corner
DOHA
01.2019 - 12.2021
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Set up and controlled user access levels across databases to protect important data.
- Designed and developed analytical data structures.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Handling Data Integration, Data Manipulation and Data Cleaning help of Power Query.
- Requirement Analysis and modelling of data in Excel & Power BI for real time dashboards and other reports. Involved in developing reports and dashboards in Power BI.
Education
Bachelor of Arts - Art
IGNOU
DELHI 07.2014 - 12.2017
Skills
Advanced Excel
Timeline
Purchasing & Sales Analyst
Gourmet Fresh Trading (Abu Khalifa)
12.2021 - Current
Data Administrator
Sports Corner
01.2019 - 12.2021
Bachelor of Arts - Art
IGNOU
07.2014 - 12.2017
Similar Profiles
Malyn CrutoMalyn Cruto
Assistant Teacher at The International School of Choueifat Khalifa City Abu Dhabi UAEAssistant Teacher at The International School of Choueifat Khalifa City Abu Dhabi UAE
Jerlyn AnadonJerlyn Anadon
NA at Abu Dhab Golf Garden A69 Khalifa CityNA at Abu Dhab Golf Garden A69 Khalifa City
SABIHA SABIHA null
Medical Scribe and Medical Transcriptionist at NMC Royal Hospital, Khalifa City, ABU DHABIMedical Scribe and Medical Transcriptionist at NMC Royal Hospital, Khalifa City, ABU DHABI