Jan Albert Panganiban

Responsible for designing, developing, and maintaining Jira projects to support team workflows and efficiency. Created customized workflows aligned with team processes, and implemented automations to streamline task updates and field transitions. Ensured accuracy and relevance of reports and dashboards for performance monitoring and decision-making. Managed and administered multiple Atlassian products, including Jira Software, Jira Service Management, Jira Work Management, Confluence, Compass, Atlas, and Jira Product Discovery, ensuring optimal configuration and integration across platforms.

Led the design and development of user-centric tools and process automation to support the EG Recontracting and Order Process using Jira Service Management. Built and maintained AppSheet applications for contract tracking and task automation. Developed dynamic dashboards and weekly reports for onboarded and priority customers using advanced Google Sheets formulas, charts, and scripts, including automated email notifications for contract deadlines. Created and customized Google Forms with script-based auto-responses, and designed internal playbooks using Google Sites with embedded HTML for an improved user experience. Developed animations to visualize workflows (Animaker, GoAnimate, Adobe Animate) and designed clear process flowcharts (Draw.io, MS Visio, SmartDraw) for team use. Oversaw project management within Jira—building workflows tailored to team needs and implementing automations to streamline task updates and status changes. Ensured all tools were efficient, user-friendly, and aligned with operational goals.

SAP B1 and Network Administrator Responsible for managing SAP Business One operations and IT infrastructure. I develop SQL queries and Crystal Reports for data retrieval and custom reporting, monitor inventory within SAP, and implement system improvements. I train new users, streamline processes, and provide ongoing SAP support. On the IT side, I manage firewall security (SoPhos UTM 9), troubleshoot hardware/software issues, configure LAN and network devices, and maintain the company website via WordPress. I also create Excel tools and handle software installations to support daily operations.

Accounting and Audit Assistant Acted as Systems Compliance Officer during SAP and SDK implementation, ensuring accurate system use and data integrity. Handled SAP system entries (GRPO) for raw material purchases and coordinated with Accounts Payable. Conducted inventory monitoring and in-depth analysis for Liberty Group of Companies, including mass balance reports for cost analysis and aged inventory reports to support financial planning. Led monthly physical audits, prepared yield and efficiency reports (e.g., glue consumption, fuel KPT), and analyzed man-hour data for KPI reporting. Standardized SAP procedures for material receiving, transfers, and consumption. Provided onsite auditing and training for Laguna branch staff on SAP production output and inventory encoding.