Pak Kwan, Pmp, Acp Email & Phone Number

Burlingame, California, United States

- Oversee a team of 25 employees within the Data Operations department, demonstrating strong leadership and management skills essential for building and scaling high-quality BI and Data Warehousing teams.- Lead cross-functional collaboration with product managers and research teams to understand data needs and deliver on those needs. - Manage a diverse team of managers, engineers, coordinators, and technical writers, fostering collaboration and innovation to drive data initiatives and deliverables.- Assist with strategic planning, including resource allocation and setting KPIs for the teams, aligning with the responsibility to define and execute plans to achieve the vision for BI and Data Warehousing.- Create dashboards and regularly report to executives on team performance and strategic initiatives, showcasing effective communication and stakeholder management skills.- Design an agile project management framework, promoting agility and flexibility in project execution, essential for driving operational excellence and system reliability.- Design and maintain ETL processes for over 20+ data sources, including relational databases and flat files, demonstrating expertise in data architecture and data pipeline development crucial for managing data warehouse plans across product verticals.

Burlingame, California, United States

- Manages 2 teams of 10 analysts in total to deliver 20+ FWA recurring analyses, maintain ETL processfor 5+ data sources, perform ad-hoc data analysis and generate reports to the management.- Serves as a subject matter expert to provide analytical consultation on Medicare provider enrollment data to the Center for Program Integrity- Manages the day-to-day operation of the team. To provide technical directions for FWA analysis and to process improvement ideas for data owner projects using SAS, SQL, and Python- Leads efforts to adapt to a relational database redesign for external and internal stakeholders including forecasting impacts, risk management, and working with internal and external stakeholders todevelop transition plans.- Leads efforts to create and maintain a state licensure database for physicians- Motivates the team and sets up short-term and long-term goals for team members for continuous improvement

San Francisco Bay Area

- Managed a team of 6 analysts to ETL large relational databases and flat files, deliver regular FWArequests, and ad-hoc data analysis- Initiated data owner projects to centralize Medicare provider enrollment data knowledge, and utilizedsix sigma for ETL process for data sources.- Developed ETL logic for large relational databases (PECOS, NPPES) and flat files (MED, PUFNPPES) using Python, SAS and SQL.- Worked with HRSA to identify eligible providers to receive phase 1 COVID-19 Provider Relief Refundto distribute over $40 billion to 300,000+ providers in 6 months.

Burlingame, California

- Managed a team of 3 analysts to deliver 15+ Fraud, Waste, and Abuse (FWA) recurring analyses andad-hoc data analysis.- Developed fraud detection logic to identify almost 100,000 providers with potential integrity issues from50+ categories in Medicare and designed monthly dashboards to display descriptive analysis and datavisualization.- Developed a standardized statistical program using SAS to summarize a given Medicare provider'senrollment activities and standings.- Prepared and presented statistical results to clients without a technical background

San Francisco Bay Area

- Developed the logic to create a master revocation file that identifies 50,000+ providers with negativebehaviors in Medicare using SAS and SQL- Utilized data management and data mining skills to develop 10+ research files from large relationaldatabases using SAS and SQL.- Assisted with publishing multiple publicly available data on www.cms.data.gov including PublicProvider Enrollment Files, and Opt-out Affidavits.- Assisted with interpreting study specifications, research findings, and quantitative analyses for relevantaudiences

Greater Los Angeles Area

- Collaborated with the technology coach to explain software adoption statistics of financial representatives monthly to the leadership team.- Analyzed technology metrics that identified key areas of opportunity for technology adoption.- Modeled the usage of technical tools to predict potential growth of financial representatives.

Los Angeles

Developed tact and diplomacy in dealing with 1800+ customers per shift at various stations in a popular high end dining hall which fostered adaptability and customer service skills Customer Service - satisfy customers' desires in a high-ending dinning hallMulti-Tasking - Maintain the quality of service and food throughout the serving periodTime Management - Report duty on time in order to maintain each station works smoothly Adaptable - be able to work at different stations independently

South San Francisco

- One of the leading Asian music production companies in Bay Area which organized over 100 Chinese concerts.- Communicated with concert provider, performer, and local workers.- Advertised concerts through social media, newspaper and radio. - Predicted a more suitable performance date based on sales and labor cost from previous events.

San Francisco

- Handled issues that international students had regarding VISA or school enrollment status.- Comprehended all the rights of international student in order to explain and help other international students effectively - Worked at the front desk in international student office and answered questions patiently.- Analyzed students' profiles based on different regulations which could be used to help clearly show their status. - Helped plan student orientation, talks and student events throughout the semesters- Worked closely with the office manger to report students' status

San Francisco Bay Area

assisted students with their homework

Master Of Analytics, Ai / Data Science / Data Engineering

Bachelor Of Science (B.S.), Statistics, 3.869

Participated in two data analysis competitions which are American Statistic Association Data Fest and Kaggle Data analysis. Participated.

Statistic

Activities and Societies: F-1 Club, International Peer Mentor program, Math Club, Chinese Student Association, international student.