Summary
Overview
Work History
Education
Skills
Certification
Timeline
ResearchAssistant
Reggie Jardin Comendador

Reggie Jardin Comendador

BI Developer
Dubai

Summary

A tech-savvy professional with over20 years of experience in IT, supply chain, retail, and finance domain. I hold certifications as a Microsoft Power BI Data Analyst, Microsoft Excel Expert, and ITIL4 Foundation in IT Service Management. Committed to innovation and excellence, I leverage my deep analytics expertise to enhance organizational growth and stakeholder satisfaction. Currently serving as a Business Intelligence Developer at Jashanmal National Co., I specialize in utilizing advanced analytical tools and IT technology to drive business value and innovation. My skill set includes proficiency in Microsoft Power BI, SQL, SSRS, SSIS, ETL, advance excel, power query, Microsoft fabric, data flow gen2, VBA, python and applying AI techniques to solve complex problems, demonstrating a proven track record in contributing to the strategic goals of the organization.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Business Intelligence Developer

Jashanmal National Co
09.2023 - Current
  • Primarily responsible for providing reports and dashboard solutions using Microsoft SSRS and Power BI on SQL Server and Oracle Database
  • Responsible for designing backend solutions to map the online data in reporting tables at different granularity levels
  • Support the Integration layer of the organization connecting disparate systems using Microsoft SSIS
  • This work is performed along with DevOps team that owns this layer
  • Follow waterfall and Agile methodology while performing various development activities such as requirements gathering, analysis & solution design, program development/coding, unit and integrated testing, user training and documentation
  • Interact with business departments to gather user requirements and understand business processes involved
  • Review/Analyze requirements documentation with Team Lead/Functional Consultants to finalize requirements, determine business case and finalize scope of work
  • Perform in-depth analysis to determine the impact on existing business processes and software applications
  • Develop software programs using languages (SQL/PL-SQL/T-SQL) and Reporting tools (Power BI, SSRS) as per the program specifications and ensure compliance with organization’s policies & standard practices
  • Develop Data Model/ETL Programs for data-warehouse systems used by analytical tools such as Business Objects & Power B.I
  • Prepare detailed documentation covering all areas of software development cycle involving requirements, analysis & design, program development, & testing
  • Develop appropriate training programs and user guides to assist business departments in adopting new or enhanced software programs/modules
  • Ensure service requests are resolved on time and users are appropriately kept informed about the progress

Supply Chain Analyst

Jashanmal National Co
11.2021 - 09.2023
  • Completes category, item, and distribution analysis along with scorecard reporting to communicate opportunities and risks to the sales forecast
  • Developed new ad-hoc and dashboard tools to show results and create insights to sales and inventory trends for the overall forecast and also the item/customer detail forecast
  • Collaborate with IT and WMS improvement initiative and utilize business intelligence tool to support ongoing business requirements
  • Identify root causes based on data analysis and transform data into information to improve service
  • Develop and publish the monthly supply chain metrics package reporting on key performance indicators (KPIs) in the areas of inventory management, forecast accuracy, on-time delivery, logistics costs, and others
  • Ensure accuracy of all metrics data and be able to explain the underlying performance drivers
  • Perform ad-hoc analysis and data modeling as required to solve problems, illustrate trends, identify root causes, support supply chain related projects
  • Coordinate with warehouse, Inventory & audit team to ensure the process are carried to maintenance inventory accuracy at all times including cycle count
  • Design, develop and interpret suite of reports that provide accurate quantitative analysis and insights that drive fact-based decision-making by stakeholders to support growth and profitability
  • Ensure weekly /monthly reports, metrics and analysis are completed to support brand and supply chain partners to meet business objectives
  • Develop and deploy SOP practices across the group and optimize the efficiency as necessary
  • Projects: SCM Control Tower B.I Dashboard, OCS B.I Dashboard, SCM Auto Daily Pendency Report, Agnes, Freight Dashboard

Retail Operations Executive

Landmark Group
11.2020 - 10.2021
  • Developed automated daily sales and KPI performance analysis to business users which send automatically to their mail inbox for their advance and planned business insights and decision making
  • Prepare weekly trade deck for management retail analysis
  • Innovate retail KPI reports to monitor business performance
  • Coordinate to store’s for their business requirement and retail support
  • Conduct training for new users of the retail system
  • Prepare the yearly budget and forecast of territory retail, based on the sales trends logic and algorithm
  • Maintain daily sales report, KPI report, finance report as per the management require format
  • Analyze the business retail KPI, base on UPT, ATV, ASP, Footfall, customer appetite, sales trend, finance budget and forecast, stock SOH and all other business parameters to provide the best insights as possible for converting the analyze data into productive business output

Logistics Supervisor

Landmark Group
04.2019 - 11.2020
  • Monitoring and processing of shipments Import and export documents to the Oracle WMS and the RMS logistic system; maintaining and tracking record of incoming and outgoing shipments; filling up the Dubai Chamber, export expenses, managing charges, custom charges and do on for export shipments; supervising Inventory Management of physical stock
  • Coordinating the Operations Team, Management, Vendor, IT, Accounts, Supply Department for Daily Logistics Operations
  • Ensuring data integrity against operation and system entry and preparing executive summary, incentive pay-out and shipment report to Management; innovating a new report, if required by business, to be phased in and aligned with the trendy environment in order to cope with the competitor; creating E R, OBIEE, Oracle WMS and RMS report to end user and top management; managing procurement for vendor/supplier payment using S2P2P oracle procurement system
  • Troubleshooting and maintaining I.T software and hardware and the entire logistic business operation system; analysing work related I.T issues and logistic issues, if any, to top management and to solve them as quickly as possible
  • Supporting and monitoring the existing infrastructure, supervised preventative maintenance and backup as well as performed other regular support activities to ensure effectiveness; managing data centres over a large user base and maintained data centre servers/ backup operations for integration of new systems with the existing systems
  • Streamlining the system & procedures for effective material control for ensuring a ready availability of materials
  • Evaluating and reviewing company’s logistics operations business practices, updating and developing process documentation, streamlining opportunities, and eliminating non-value added activities

MIS Executive

Landmark Group
05.2017 - 03.2019
  • Managing day to day MIS activities like file’s, data, script backup and performance tuning.
  • Installing and configuring new hardware/software, system updates, and configuration changes
  • Microsoft Outlook client e mail configuration
  • MIS Reporting (reporting tools: brio query, Oracle BI Publishers, RMS, RPM, PL/SQL, ER, Qlik, and Toad)
  • Updating shop POS for daily sales, price revision, promotions, markup & mark down POS price changes
  • Daily extracting of sale reports from back end from Oracle thru road SQL and PL/SQL, Brio Query, ER, Qlik
  • Maintaining and Creating Stock Inventory Reports, ageing, and300+ ER reports as per user requirements
  • Configuring End user desktop for required report application access
  • Troubleshooting MIS Windows’s server via remote connection
  • Developing professional visualized report thru Visual Basic Console, ER, QLIK, and Toad
  • Developing new Techniques for system automation towards smooth functioning of retail operations
  • Developed the MIS full automation top management report and retail operations analytical report

EDP Supervisor

Landmark Group
05.2008 - 04.2017
  • Installs and configures desktops based on IT department specifications
  • Managing day to day IT activities like backup and performance tuning
  • Computer hardware troubleshooting, network administration & peripheral
  • Applying operating system updates, and configuration changes
  • Installing and configuring new hardware/software
  • Lotus notes domino client e mail configuration
  • MIS Reporting (reporting tools: brio query, Oracle BI Publishers, PL/SQL)
  • Assist Store and WH people in Technical Problems, (POS & PDT barcode scanner, PC software & hardware)
  • Updating shop POS for daily sales, price revision, mark up & mark down POS price changes
  • Daily extracting of sale reports from back end from Novell Netware, SQL and PL/SQL, Brio Query
  • Daily sales report processing & generations
  • Maintaining Stock Inventory Reports
  • Configuring of PDA, Wi-Fi & AP
  • Troubleshooting POS terminal via remote connection
  • Troubleshooting of barcode printers
  • Maintaining of inventory levels
  • Developing new Techniques for system automation towards smooth functioning of warehouse operations
  • Installation, maintenance & upgrading of WMS (Warehouse Management System) on wireless networks
  • Monitoring and analyzing day to day activities with the Oracle WMS and implementing rules based on system aspects toward proper inventory management and warehouse operations

Network Operations Center

PLDT
04.2003 - 04.2008
  • Installation of telephone landline to residential and corporate subscribers
  • Installation of ADSL - Assymetric Digital Subscriber Line for both residential & corporate subscribers
  • Installation of Broadband Wireless Internet both residential & corporate subscriberd
  • Cellsite commissioning
  • Manage network traffic and signal according to standard configurations
  • Monitor, diagnose and test any networking issues
  • Supervise the other field installer for network installation protocol

Education

Diploma - Information Technology

Philippine Technical Education and Skills Development Authority
01.2003

Skills

  • ITIL Certified
  • Data Validation
  • Dashboards
  • Microsoft Power BI
  • Microsoft PowerPoint
  • Analytical Skills
  • Microsoft Excel Advance
  • DAX
  • Pivot Tables
  • Extract, Transform, Load (ETL)
  • Data dashboard design
  • Data modeling
  • Business intelligence analysis
  • BI reporting tools
  • Problem-solving
  • Data analysis

Certification

  • Oracle Retail - Landmark Group
  • Driving Competence - Emirates Driving Institute Issued Nov2014 - Expires Nov2024
  • Wireless Installer Engineer Certification - Smart Communications, Inc.
  • Broadband Communications Technician (BCT) - PLDT
  • Creating a Dashboard with Power Query Microsoft365 - LinkedIn
  • Picking the Right Chart for Your Data - NASBA
  • Implementing Supply Chain Management - NASBA
  • Supply Chain Analytics Foundations - Nathainal Bibby
  • Lean Six Sigma Green Belt - IIBA
  • Data Science Foundation - Great Learning
  • Master Excel Power Pivot & DAX (Beginner to PRO) - XelPlus cert_nrbj3pjr
  • Microsoft Power Query & M Language - XelPlus cert_64rkr041
  • Complete SQL Mastery - Code With Mosh cert_541rh8rt
  • Microsoft Fabric - Pragmatic Works
  • Complete Python Mastery - Code With Mosh cert_clxvnss0
  • Microsoft Power BI - XelPlus cert_w1rc58hv
  • Microsoft Certified: Power BI Data Analyst Associate - Microsoft Issued Jan2024 - Expires Jan202572FDBFEC54A94679
  • Master Excel Power Query (Beginner to Pro) - XelPlus
  • Master Excel Power Pivot & DAX (Beginner to Pro) - XelPlus
  • Fast Track to Power BI - XelPlus
  • Microsoft Excel Expert - Microsoft wUySH-H9RY
  • ITIL v4 Foundation - Simplilearn4847515
  • ITIL v4 Foundation - IT Service Management - PeopleCert Issued Feb2024 - Expires Feb2027 GR671614591RJ
  • ITIL4 Foundation - AXELOS Global Best Practice Issued Feb2024 - Expires Feb2027

Timeline

Business Intelligence Developer

Jashanmal National Co
09.2023 - Current

Supply Chain Analyst

Jashanmal National Co
11.2021 - 09.2023

Retail Operations Executive

Landmark Group
11.2020 - 10.2021

Logistics Supervisor

Landmark Group
04.2019 - 11.2020

MIS Executive

Landmark Group
05.2017 - 03.2019

EDP Supervisor

Landmark Group
05.2008 - 04.2017

Network Operations Center

PLDT
04.2003 - 04.2008

Diploma - Information Technology

Philippine Technical Education and Skills Development Authority

Similar Profiles

CREATE PROFILE
Reggie Jardin ComendadorBI Developer