Jaymar Catapang

Power BI developer with 2+ years delivering enterprise business intelligence for a multi-concept retail group. Hands-on across the Microsoft BI stack — star-schema modeling, DAX, Power Query (M), paginated reports, and row-level security — including provisioning and administering a self-hosted Power BI Report Server on an internal VM.

Builds reporting end to end: from source SQL through to secured, Power Automate-driven delivery for seven departments and executive leadership.

Associate Software Developer — Business Intelligence & Application Development at Digits Trading Corporation (2024-05 – Present)

Business Intelligence & Reporting

• Provisioned, configured, and administered a self-hosted Power BI Report Server on an internal VM — owning installation, service configuration, and ongoing maintenance — establishing on-premises report delivery without per-user cloud licensing costs.
• Managed Report Server folder structure, item-level permissions, and refresh schedules; deployed.pbix and paginated (RDL) reports as the organization’s standard distribution channel.
• Automated report distribution with Power Automate, building scheduled flows that email Power BI reports to stakeholders on a recurring basis — eliminating manual send-outs and ensuring on-time delivery.
• Implemented row-level security roles, both static and dynamic (USERPRINCIPALNAME() resolved against a security dimension), restricting visibility by department, store, and business unit so each user sees only authorized data.
• Designed star-schema data models with conformed dimensions and dedicated date tables, and built Power Query (M) transformation layers over SQL and application databases — replacing flat wide-table imports to improve refresh performance and measure maintainability.
• Authored advanced DAX measures — time intelligence (YTD, MTD, YoY), target-vs-actual variance, ranking, and dynamic segmentation — powering sales, margin, and profitability analysis.
• Delivered reporting across seven departments (IT, Admin, Warehouse, Purchasing, Accounting, Marketing, Finance, HR) covering sales, operations, compliance, inventory, and resource utilization.
• Built sales and distribution reporting spanning all retail concepts — digital, lifestyle, food halls, and Apple — tracking performance, quote outcomes, and targets vs. actuals, then consolidated these into executive reporting giving leadership a single unified view for strategic planning.
• Trained and mentored OJT personnel on Power BI report development; authored supporting documentation and provided ongoing user support.
• Developed and maintained web applications using PHP (Laravel), MySQL, HTML5, CSS, and Bootstrap; conducted unit and integration testing against defined performance benchmarks.
• Designed and integrated RESTful APIs for the Apple Device Enrollment Program (DEP), and authored the system’s technical documentation covering architecture, folder structure, and API usage.

Associate Software Engineer at Accenture (2023-11 – 2024-03)

• Completed instructor-led training in ASP.NET, C#, Azure, and Azure DevOps — API development, MVC, and cloud fundamentals.

Bachelor of Science in Computer Science – Batangas State University — Gov. Pablo Borbon Campus II