Kun Yu Poon Email & Phone Number

Baldwin Park, Ca, Us

Responsible for designing and implementing data-driven solutions to ensure integrity, scalability, and accessibility across client systems, building end-to-end systems from scratch to drive company growth and meet diverse client needs. Developed and deployed a client-facing web portal tailored to multiple healthcare clients, enabling streamlined data access and editing through a dynamic and secure React-based interface.Integrated client-specific features such as mapping configurations, custom metrics, and reporting functionalities, empowering users to manage data intuitively.Scaled portal functionality to support diverse client requirements, handling data from multiple databases efficiently with role-based access control.Enhanced user engagement by implementing real-time data visualization, editable grids, and CSV export functionality for actionable insights.Optimized system architecture by leveraging Azure Functions and APIs, ensuring seamless backend integration for data retrieval and updates across all clients.Achieved a 40% reduction in ETL processing costs through code optimization and system improvements.Developed and managed automated ETL processes using Azure Functions and APIs to ingest and transform healthcare data.Designed and implemented scalable databases and data pipelines, ensuring data integrity and consistency across multiple systems.Built and optimized analytical tables to support business reporting and decision-making.Delivered data solutions to 4 large clients, managing databases with over 1000+ beds across the country.Created impactful KPI dashboards using Power BI, providing actionable insights for stakeholders.Led all testing, version control, and documentation efforts independently, ensuring code quality and reliability across versions despite limited resources.

Costa Mesa, California, Us

Responsible for data, ETL and reporting architecture. Worked mainly with CFO, marketing department and billing team to gather requirement, design and build long-term reporting metrics from scratch. • Develop, refine, and scale data management and analytics procedures, systems, workflows, and best practices • Ability to translate technical aspects of analysis and metrics into actionable insights• Proficient in MySQL programming, PostgreSQL programming and Advanced Excel Knowledge• Automated ETL process across millions of rows of data to generate daily/weekly reports and metrics•Propose data/IT solutions focused on Interoperability• Work with CFO to create 3 to 5-year information management road map (technical aspects of current business requirements and strategy)• Identify current data integrity issues and propose workarounds• AdHoc ReportingKey Achievement:• Build scalable databases capable of ETL processes using PostgreSQL and Python• Ingested data from data sources using combination of HTTP API, Azure Functions into our analytical database (PostgreSQL)• Create data pipelines including extracting data from different sources (MySQL, PostgreSQL, Salesforces, Local files, Online resource), data modeling and data cleaning, validate and Integrate data into database. • Design and implemented impactful KPI dashboards (Power BI) for data reporting. Interpreted and analyzed data to identify key metrics and transform data into meaningful, actionable information (industry insights, performance tracking, assisting daily operation etc.)

Philadelphia, Pennsylvania, Us

• Troubleshot technical problems with the network and for individual users• Organized and structured new technical/electronic devices coming into the office (Set up new printers, all required software, system and firewall for new computers)• Maintained proper status of all the computers, networks/systems and IT information• Cold-called software companies to gain repair knowledge of various product line support systems • Trained in the use of Sendouts, a recruiting software • Researched buyers to purchase company’s outdated electronic devices • Researched and recommended an upgrade for company’s email system to increase efficiency• Upgraded 14 computers and software systems for 20 staff to reduce crashes and outages

Master Of Science - Ms, Information Systems

Bachelor Of Science In Business Administration, Management Information Systems Major