Performed market analysis of Seattle and the state of Washington using Python and US Bureau Census data to determine a market ceiling given the product’s parametersPerformed research into Bureau of Labor Form 5500 datasets as a potential source by cleaning up the data and filtering out the appropriate companiesAutomated code to calculate the percentage of combination applications between Life and Disability claims within a 9-month period

Worked in a team of 4 to develop a Benefits and Protection Power BI dashboard that consolidates the results for all claimant customers satisfaction survey from multiple data sources by applying Linguistic analytics via Large Language Model (LLM)Worked with team and created a Power BI template for web dashboards with pre-defined metrics and data structure that allows data analysts quickly build out dashboards for business partners. Designed overall layout of visualizations and ease for analysts to copy over dataScoped out potential aspects and functions of future projects pertaining to data consolidation and text analytics. Created documentations through JIRA and Confluence

Parsed text and html data files of subsidiary companies using regex and Python through Jupyter NotebookLearned process planning, task & time management, quality check on coding and results; Achieved efficiency with optimized coding; Impressed supervisors that they are willing to offer me a job for the summer 2023