• Spearheading the establishment of protocols and standards for data architecture, data model crafting, data warehousing, data amalgamation, and data safeguarding across industries, including FMCG, Beverages, and Brewing• Championing and marketing the importance of BI, analytics, and robust data governance to BI program's executive sponsors, from business users to IT managers, illustrating its value• Guiding the entire lifecycle of development - from planning, analyzing, and designing to developing, testing, and deploying - leveraging data mining and analysis tools• Identifying and addressing gaps in current procedures by implementing innovative processes, engaging in design assessments, and aiding in the distribution of tasks across specific system components• Facilitating corporate expansion efforts by transitioning data into uniform platforms like Power BI, Excel, and Analysis for Office, thereby supporting organizational growth• Employing ETL tools such as ADF and SSIS to seamlessly integrate data across diverse platforms, ensuring the delivery of tailored solutions• Offering expert advice on the application of re-engineering strategies to enhance operational efficiency and product standards, potentially including the provision of workshops and training sessions on measurement, analysis, improvement, and control• Analyzing data to create intricate visual representations with tools like DAX, MQuery, and Table function, aimed at aiding managerial decision-making processes• Pioneering the development of incremental reporting standards, managing data maintenance in alignment with the data architect’s strategic plan• Implementing Agile methodologies to promote strict adherence to iterative development practices and foster continuous collaboration with multidisciplinary teams• Crafting and delivering specialized Power BI reports designed to meet the analytical demands and goals of commercial units within the enterprise

• Navigating the delineation of a BI roadmap to establish specific goals for various business sectors while allocating budgets, resources, and operations to facilitate these objectives across industries such as FMCG, Beverages, and Brewing• Diligently documenting user support activities, pinpointing application issues, corrective measures, and the status of resolutions with accuracy• Collecting and specifying customer requirements to craft precise specifications, thereby orchestrating structured project plans• Leading a dedicated team of six professionals in executing solutions and updates efficiently• Establishing and administering a Data Mart catering to diverse reporting sectors• Innovating, deploying, and managing Microsoft SQL Server Integration Services (SSIS) and Reporting Services (SSRS) projects• Developing T-SQL queries, intricate stored procedures, user-defined functions (UDF), and database triggers to enhance database functionality• Engaging in DBA tasks to resolve issues such as deadlocks and optimize database performance• Launching, deploying, and overseeing pipelines within Azure Data Factory to assimilate data from varied sources like Oracle, MS SQL, Salesforce, and Azure Data Lake• Constructing and sustaining Data Lake structures to ensure data integrity and accessibility• Transitioning Data Warehouse objects from on-premise servers to cloud environments via ADF, enhancing operational flexibility• Initiating logic apps on Azure for seamless integration with SharePoint objects, facilitating collaborative and efficient data management• Meticulously designing and documenting the architectural framework of Power BI proofs of concept to guide future developments• Crafting complex DAX functions within Power BI and Power Pivot to extract actionable insights from data.• Automating Power Query refresh processes utilizing PowerShell scripts and Windows Task Scheduler to streamline data management tasks

Industries: Automotive.• Produced metrics, filters, reports, and dashboards, incorporating advanced chart types and complex calculations for data manipulation. Served as a liaison for Data Interoperability, Analytics, BI, and Production Support.• Responsible to translate business requirements into appropriate data queries using SQL Server, Azure Synapses• Reengineering ABAP script from SAP ECC to reporting solution• Developed Performance Dashboards, Scorecards, Metrics, What-if analyses, and more for functional areas such as Finance, Order Management, and Supply Chain, utilizing Power Pivot.• Analyzed business data, addressing issues like Billing and Freight charges, using BI tools.• Documented procedures and business processes, ensuring stakeholders were informed.• Engineered an automation tool with MS Access and VBA macros, saving 3 man-hours daily.• Transitioned reports from Excel to Tableau.

Industries: Automotive.• Addressed PO Reconciliation, unconfirmed and overdue orders, and managed backlog.• Generated MIS reports requiring daily, weekly, and monthly distribution to sales team