Data Analyst
Coca Cola Al Mana
Total years of experience :7 years, 11 Months
• Provide customer insights and recommendations with the objective of increasing subscribers.
• Generate periodic report for various internal stakeholders.
• Create VBA programs to automatically update Excel workbook and Dashboards.
• Extensively use Excel functions to speed processes and maximize accuracy.
• Maintain dashboards measuring major KPI’s.
• Worked on multiple data sources like Google analytics, Mixpanel segmentation, Google developer console, iTunes connect.
• Work with the insights Manager to generate deep analysis of customer behavior, segmentation, purchasing and content consumption habits.
on IBM Maximo software.
•Data entry to ADDC Maximo system and verify data.
•Prepared high level reports with Pivot tables, graphs for management.
•Automated manual steps by writing VBA Macro codes.
•Responsible for managing and coordinating with site engineers and data engineers.
•Supervision and allocation the work and ensuring timely deliverables by the team.
•To check the closing status of assets in Maximo and verify Legacy documents.
• Worked on SQL Server 2012.
• Writing SQL scripts to manipulate, clean & process data using SQL.
• Preparing reports (Using advanced excel) and Automate Excel by using VBA.
• Worked on BI tools like Gooddata, Tableau to create competitive dashboards.
• Reporting and perform changes as per the Client requirement.
• Analyze metrics and prepare high level analysis to be used to guide decision making, better understand market and business requirement and improve sales.
• Gap analysis done to check the discrepancies in raw data
• Communication with various project managers.
• Worked for one of the top most FMCG Company Procter and Gamble.
• Preparing reports (Using advanced excel) and do required changes in the reports (Change Management) as per the Client requirement.
• Designing of Macro code in VBA Excel, SQL, MS Access for the process.
• Working on Xcelsius (SAP Application) to design visual representation of data.
• Working on data tools such as Nielsen, Source One, Kantar.
• Quality checks of reports by various data validations.
• Configuring SharePoint sites, sub-sites, user permissions, and managing SharePoint site collections.
• Assignment of proper permission levels for all users of the site as well as configuring anonymous access if required.
• Creating and maintaining the workflows as per user requirement.
on data tools such as Nielsen, Source One, Kantar.
•Quality checks of reports by various data validations.
•Configuring SharePoint sites, sub-sites, user permissions, and managing SharePoint site collections.
•Assignment of proper permission levels for all users of the site as well as configuring anonymous access if required.
•Creating and maintaining the workflows as per user requirement.
2018 ACADEMIA
-
-