● Leading a team of analysts and developers to design, build, and maintain business intelligence solutions. ● They collaborate with stakeholders across various departments to identify business requirements, develop data models, and create reports and dashboards that provide actionable insights. ● Also ensures data accuracy, integrity, and security while staying updated on emerging technologies and best practices in the field of business intelligence. Strategic Planning: ● Develop and execute a strategic roadmap for BI initiatives aligned with organizational goals. ● Identify opportunities to leverage BI tools and technologies to drive business growth and efficiency. Team Leadership: ● Lead and mentor a team of BI analysts, developers, and data engineers. ● Provide guidance on data analysis methodologies, tools, and best practices. Requirements Gathering and Analysis: ● Work closely with stakeholders to understand their business needs and requirements. ● Translate business requirements into technical specifications for BI solutions. ● Conduct feasibility studies and recommend appropriate BI tools and technologies. Data Modeling and Architecture: ● Design and develop data models, data warehouses, and ETL processes. ● Ensure data integrity, consistency, and accuracy across BI platforms. ● Optimize data architecture for performance, scalability, and reliability. Report and Dashboard Development: ● Design and create interactive reports, dashboards, and data visualizations. ● Customize reports to meet the specific needs of different user groups and departments. ● Implement self-service BI capabilities to empower end-users to explore and analyze data. Data Governance and Security: ● Establish and enforce data governance policies, standards, and procedures. ● Implement security measures to protect sensitive data and ensure compliance with regulations. Performance Monitoring and Optimization: ● Monitor the performance and usage of BI solutions. ● Identify bottlenecks and inefficiencies and implement optimizations as needed. Vendor Management: ● Evaluate and select third-party BI tools and technologies. ● Manage vendor relationships and contracts, ensuring service level agreements are met.

Be a key leader responsible for overseeing the development and implementation of effective Business Intelligence (BI) strategies and solutions to drive data-driven decision-making within the organization. With special responsibilities: ● BI Strategy Development: Develop and execute a comprehensive BI strategy aligned with the organization's goals and objectives. ● Data Management: Oversee the collection, integration, and cleansing of data from multiple sources to ensure data accuracy, consistency, and reliability. ● BI Solution Development: Lead the design and development of BI solutions, including data models, dashboards, reports, and analytical tools. ● Team Leadership: Manage a team of BI and DS team. Foster a collaborative and innovative work environment, providing guidance and support to optimize team performance. ● Technology and Tools Evaluation: Stay abreast of the latest Power BI technologies. ● Stakeholder Engagement: Collaborate with business stakeholders to understand their requirements and translate them into BI initiatives. Projects Involved: 1. CHC Scorecard. Role: BI Delivery Lead. ● Description: Development of a customized Power BI Dashboard. The dashboard provided real-time insights into key metrics, enhancing decision-making processes and operational efficiency for cinnamon sourcing. 2. MGIL Scorecard. Role: BI Delivery Lead. ● Description: Development of a customized Power BI Dashboard. The dashboard provided KPI Achievement for the client. 3. CHC Sourcing Performance. Role: BI Delivery Lead. ● Description: Development of a customized Power BI Dashboard. The dashboard provided real-time calculation into key metrics, detail description, supplier performance. 4. Commercial Sourcing Performance. Role: BI Delivery Lead. ● Description: Development of a customized Power BI Dashboard. The dashboard provided real-time insights into key metrics, enhancing decision-making processes and operational efficiency for cinnamon sourcing. 5. FSA Dashboard. Role: BI Delivery Lead. ● Description: Development of a customized Power BI Dashboard. The dashboard provided real-time insights into key metrics, GIS imaging analysis, and Drone tracking.

● Works collaboratively with end users to develop BI reporting systems that provide accessible information for decision-making. ● Uses warehouse data to solve organizational problems through reports, analysis and data visualization. ● Provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security and quality of information assets. ● Support of all managers and users requiring data for decision support and in particular with the C-Level people. Job Description: ● Responsible for a range of critical tasks and activities, ensuring seamless deployment, implementation, database migration, installation, and admin configuration of SQL Server. My expertise extends to both on-premises servers and Azure and AWS cloud environments, encompassing Data Modeling BI and Data Warehousing solutions. ● A key aspect of my role involves performing technical troubleshooting, code debugging, and problem-solving for custom-built data warehousing solutions. ● In collaboration with nontechnical business users, I adeptly gather specific business requirements for reports and business intelligence solutions. Projects Involved: 1. Plantation Operational Highlight Dashboard at Wilmar International Limited on May 2020. Role: Business Intelligence Delivery Lead. ● Description: Development of a customized Tableau Dashboard. The dashboard provided real-time insights into key metrics, enhancing decision-making processes and operational efficiency. Technologies used: T-SQL, SAP HanaDB, Tableau, Talend, and Python to gather, transform, and visualize data. 2. CPG Dashboard at Pt. Sari Agrotama Persada on Sep 2019. Role: Business Intelligence Technical Team. ● Description: Developed customized Tableau Dashboard and Report Project to support management and organization includes Sales Analysis, Inventory Monitoring, Promotion Analytics, Self Service Analytics and Data Preparation. Technologies used: T-SQL, SAP HanaDB, Tableau, Talend, Python. 3. OSM Analytics Solution Center at Wilmar International Limited Singapore on May 2019. Role: Business Intelligence Technical Team. ● Description: Support all needs to OSM Plantation Analytics of Wilmar Group in the worlds and resolve all ticket and requisitions. Technologies used: T-SQL, SAP HanaDB, Tableau, Power BI, SAP BODS, Talend, SQL Server Integration Services, Azure Data Factory, Python, Innowera, Macro VBA, ArcGIS, Redshift. 4. South Africa Dashboard at Wilmar Continental Edible Oil and Fats (Pty) Limited on Nov 2019. Role: Business Intelligence Consultant Technical Team. ● Description: Developed customized Power BI Dashboard and Report Project to support Wilmar Group companies in the world based on department needed, such as Finance, Debtors, Executive Commission, Engineering, Sales, Production, Supply chain, Forecast Dashboards. Technologies used: T-SQL, SAP HanaDB, Microsoft Power BI, Azure Data Factory, Innowera, Python. 5. POM Dashboard at Wilmar International Plantation & Palm Oil Mill on Feb 2019. Role: Business Intelligence Technical Team. ● Description: Developed customized Tableau Dashboard and Report Project to support Wilmar Group company in the world based on Palm Oil Mill Plantation Dashboard include FFB Processed, CPO & PK Production, Losses, Stock, Shell EFB record, consumable utility. Technologies used: T-SQL, SAP HanaDB, Tableau, Talend, Python. 6. Group Plantation Report Dashboard phase 2 at Wilmar International Plantation & Palm Oil Mill on Jan 2019. Role: BI Technical Team. ● Description: Develop customized Tableau Dashboard and Report Project to support Wilmar Group plantation in Indonesia to monitor BCC activities. Technologies used: T-SQL, SAP HanaDB, Tableau, Talend, Python.

● Managing ERP system – Microsoft Dynamic Navision operational. ● Provide technical solutions Dynamic Navision. ● Managing Deployment, Implementation, Database Migration, Installation, and Admin Configuration for of Microsoft Dynamic Navision. ● Managing and responsible Business Intelligence Projects using Microsoft Power BI. ● Managing setup and implementation of ERP. ● Managing and responsible in Datawarehouse use SQL Server Databases on-prem servers, ETL Development use SQL Server Integration Services (SSIS), SQL Server Analytics Services (SSAS), and SQL Server Reporting Services (SSRS). ● Setup and improvement Data Analyst with breakthrough method and technologies. ● Managing and responsible in data/report automation.

● Deployment, Implementation, Database Migration, Installation, and Admin Configuration for of SQL Server for on-premises servers. ● Managing IT environment; Responsible and accountable for the smooth running of our computer systems within the limits of requirements, specifications, costs and timelines. ● Managing SAP Business One Development and Implementation. Support C-level management in the selection, implementation, and support of specific SAP modules. Using consulting skills, business knowledge, and SAP solution expertise to effectively integrate SAP technology into the company environment in order to achieve management expected business results. ● Managing Business Intelligence project development. ● Sales Analysis (ETL deployment & BI Project) use SQL Server Integration Services (SSIS) and SQL Server Reporting System (SSRS). ● SAP Report development use SAP Crystal Reports. ● Deployment, Implementation, Database Migration, Installation, and Admin Configuration for of SQL Server for on-premises servers. ● Managing IT infrastructures needs; Supervise the implementation and maintenance of our company’s computing needs.

● Lead ETL Datawarehouse Development using SQL Server Integration Services (SSIS) for efficient data integration processes. ● Serve as a proficient Business Intelligence Developer, leveraging Microsoft Power BI to create sophisticated and data-driven solutions. ● Collaborate with Microsoft as a consulting partner, implementing cutting-edge solutions with PowerApps, Power Query, and PowerPivot. ● Work within collaborative project environments, utilizing Microsoft 365 suite tools, including SharePoint, PowerApps, Power BI, Flow, and Dynamics. ● Utilize extensive experience and proficiency in Microsoft Azure, DAX, and Power Query, providing valuable contributions to technology-driven teams.

Job Description: ● Lead the system/software support team and manage MIS needs. ● Integrate data from various applications across platforms and database instances. ● Develop Business Intelligence projects, including reports, dashboards, automation alerts, scheduled tasks, and forecast analysis. ● Ensure seamless operation and success of critical initiatives. Projects Involved: ● Business Intelligence Projects; for Biz-dev dept, CS dept, Acct & Tax dept, Fin dept, Adm Div. Such as: - Sales Analysis and market share monitor. - Modena Dashboard. - Branches monitor analysis. - Document flow analysis. - PKP analysis. - Trial Balances monitor. - Shipment costing monitor. - Customer Service management system. - Inventory stock monitoring analysis. - MIS Billing monitoring Tools/Skills: MicroStrategy, SQL Server, SQL Server Integration Services (SSIS), MySQL, Pentaho, Tomcat, PHP, SAP Crystal Report, Sage AccPac. ● Manufacturer Execution System (MES); Software and Platform that used: IIS, ASP, SQL Server, FrontPage, AJAX, MVC. Other Skillset used: ASP, SQL, VB.net. ● Setup of a web-based manufacturing system catered to internal users, along with an add-on site for manufacturing and sales order functionalities. ● I took charge of requirement gathering, specification, and system design using the MVC methodology and OOP principles. ● I played a hands-on role in the implementation, collaborating with a talented team of 2 junior staff members. ● Part Inventory Management System (PIMS); Software and Platform Used: Apache, SQL Server, Ajax, HTML5, CSS3, JS, Mail Engine Established a real-time part transactional activities and part management system. ● My responsibilities encompassed the development of web applications tailored for both users and managers, ensuring a seamless and efficient user experience.

Working web application projects, including but not limited to: ● Part Inventory Management System (PIMS). ● Customer Service Management System (CSMS). ● Asset Management System. ● Purchase and Shipment Information System. ● PKP Monitoring System. ● Document Flow Management. To successfully deliver these projects, I have honed my skills in the following technologies: ● Proficient in PHP, JS, HTML, and CSS for developing robust and responsive web applications. ● Advanced expertise in Microsoft SQL Server, encompassing T-SQL, Stored Procedures, functions, and triggers, ensuring efficient and secure data management. ● Skilled in utilizing frameworks such as Yii and TinyMVC to expedite development processes and enhance application performance. ● Competent in Android Studio, empowering me to create impactful mobile applications. ● Familiarity with Hybrid development using PhoneGap and ionic, enabling me to deliver versatile and cross-platform solutions.

● Team Leadership: Lead a team (5 members) of Spare part supply chain to achieve departmental KPI’s. ● Supply Chain Strategy: Develop and implement comprehensive supply chain strategies for parts and components. Identify opportunities for process improvement and implement to enhance efficiency and effectiveness. ● Procurement and Sourcing: Monitor supplier performance and address any issues related to quality, delivery, or cost. ● Inventory Management: Develop inventory optimization strategies to ensure adequate stock levels for 20,000++ item part. Monitor inventory turnover rates, aging, and stock accuracy to maintain optimal inventory levels. ● Logistics and Distribution: Coordinate the efficient movement of parts from suppliers to internal facilities or distribution warehouse (20 branches). Optimize distribution processes to ensure timely delivery and cost-effectiveness. ● Quality and Compliance: Ensure that all parts and components meet quality standards and comply with relevant regulations. Work with suppliers to address quality issues and implement corrective actions. ● Data Analysis and Reporting: Utilize data analytics tools to monitor key supply chain metrics and KPI’s. Generate regular reports to management for informed decision-making.

● Skilled Database and Analytics professional, actively contributing as a part of the expert consultant team from the University of Lampung. ● In this capacity, my primary roles are coaching, training, and spearheading the development of the JSEP Project funded by the IMF for the Ministry of Education.