Mikhail Jan Legaspo

Data Analyst and BI Developer with 4+ years of experience transforming raw data into actionable insights across e-commerce, nonprofit, and enterprise environments. Expert in Power BI, SQL, and automation, with a proven track record of reducing reporting time by 70%+ and enabling data-driven decisions. Currently serving as a Business Analyst at Xerox, supporting D365 Sales and Services Analytics and Access Management.

Skilled in requirements gathering, dashboard development, test execution, and cross-functional collaboration.

Business Analyst - Xerox

(2025-08)

D365 Sales and Services Analytics (Front Office) - Delivery of Projects and Continuous Improvement Initiatives

• Understand and document business requirements and solutions for D365 Analytics reporting
• Propose and review solution designs with business stakeholders for sign-off
• Perform knowledge transfer to IT Application Management Services (AMS)
• Provide training to business key-users and super-users
• Develop and execute test plans for unit, functional, and regression testing
• Provide Level 3 production support for critical incidents when required
• Approve, provision, reset, or terminate user access to D365 and related systems
• Initiate and manage D365 access revalidation processes
• Resolve D365 Security tickets and User Security setup requests through root cause analysis
• Generate and analyze reports for SOD analysis, access revalidation, access monitoring, error tracking, and audit compliance
• Prepare BDO Walkthroughs and respond to audit requests
• Lead continuous improvement (CI) efforts related to D365 User setup per workstream
• Participate in testing activities and maintain process documentation

Data Officer - Ramon Aboitiz Foundation Inc. (RAFI)

(2023-03 - 2025-08)

• Engineered two internal applications (TDI HC Dashboard and Attendance App) utilized by 50+ staff, cutting manual tracking by 12+ hours per month
• Orchestrated and maintained 5+ interactive Power BI dashboards for HR, Programs, and Strategy teams, reducing decision turnaround time by 40%
• Led data consolidation efforts using Excel and Power BI to ensure data integrity and timely reporting

Data Analyst - Channel Precision Inc.

(2021-02 - 2023-03)

• Managed and optimized 200+ Amazon and Shopify product listings, boosting visibility and sales
• Implemented automated reporting tools, reducing manual work by 10+ hours per week
• Collaborated with stakeholders to troubleshoot platform issues and enhance data flow accuracy

Bachelor of Science - Information Technology - Capitol University (2020-03)