Responsible for managing all departmental data requests, including customer and material
master data, ensuring the extraction, transformation, integration, validation, and security of
data from multiple systems (SAP BW, S4HANA, SharePoint, legacy systems) for accurate
reporting.
• Prepare and optimize data for Power BI dashboards by performing SQL queries to extract
relevant fields, ensuring data integrity and compliance with internal security protocols.
• Designed dashboards focused on sales performance, order fulfillment, data quality, stock
monitoring, and customer care SLAs, ensuring cross-functional teams have actionable insights.
• Managed to use Microsoft tools (Power Automate, Power Apps, and Power BI) to develop and
enhance department’s business processes.
• Perform daily data governance tasks, including data validation, to ensure all extracted data
meets quality standards before it is used in reporting or analysis.
• Automate workflows using Power Automate to handle repeatable tasks like daily reporting,
form submissions, and user-specific data extractions, improving efficiency.
• Utilize DAX for complex calculations in Power BI, ensuring accurate, real-time analytics and
reporting.
• Developed web landing pages using Python to simplify dashboard access for users across
departments.
• Lead training for dashboard users, including creating video tutorials and automating request
handling for access or troubleshooting via Microsoft Forms with an SLA for response times.
• Constantly involved in R&D to enhance processes, update dashboard designs, optimize data
models, and improve performance and responsiveness for end users.
• Collaborate with IT to ensure smooth ETL processes, guaranteeing seamless data integration
and automation.
• Collaborate daily with Supply Chain, Master Data, and Sales teams in solving issues arising
with master, both customer and material, and transactional data.
• Collaborated with all company departments to manage securing data and dashboard access to
users across all organizational levels
- Company industry:
- FMCG
- Job role:
-
Information Technology
