Jan Patrick Juban Email & Phone Number

Auckland, NZ

Philippines

• Gathered business requirements for data analysis and reporting.
• Designed and developed interactive dashboards, reports and visualization using tools like SQL, Power BI, and Excel.
• Extracted and transformed data from various sources to create clean and reliable datasets for analysis.
• Collaborated with cross-functional teams and identified key metrics, KPIs and data visualizations.
• Performed data analysis and interpretations to identify trends, patterns and actionable insights.
• Ensured data accuracy and integrity through conducting data quality checks and validations.

Philippines

• Successfully set up project SharePoint site, including document management, access permissions, site collections, calendar and events.
• Designed and developed custom applications using Power Apps and InfoPath, automating business processes and improving productivity.
• Created automated workflows with Power Automate to streamline approval processes, resulting in a 30% reduction in processing time.
• Implemented a Power Automate workflow that reduced manual data entry by 50%, improving data accuracy and consistency.
• Managed SharePoint lists and libraries to support data storage and integration to Power Platform solutions.
• Implemented and managed Power BI reports and dashboards, providing real-time insights to stakeholders.

Philippines

• Worked with cross-functional teams to achieve project milestones and deliverables, fostering collaboration and communication.
• Created detailed project plans, including scope, schedule, and budget, and managed changes through formal change control processes.
• Coordinated and led project meetings, including kick-off meetings, status updates, and project reviews.
• Worked closely with stakeholders to gather requirements, define project scope, and ensure alignment with business objectives.
• Developed and maintained project management documentation, including project status reports.
• Spearheaded process improvements that reduced project delivery timelines by 30%, ensuring projects were completed ahead of schedule without compromising quality.