Talk to sales Try for Free
Hao Le

Hao Le

Field Interviewer

Followers of Hao Le590 followers
location of Hao LeSpring, Texas, United States

Connect with Hao Le to Send Message

Connect

Connect with Hao Le to Send Message

Connect

  • Timeline

  • About me

    Insurance Analyst IV at (Claims & Legal Analytics)

  • Education

    • Training at KNIME Summit

      2017 - 2017
      Data Analytics and Big Data

      Coursework focused on processing and mining databases with Hadoop and Spark through KNIME by using the KNIME Big Data Extensions and relevant hands-on practice

    • The Johns Hopkins University - Bloomberg School Of Public Health (via Coursera)

      2012 - 2012
      Community Change in Public Health Healthcare/Public Health

      This course examines the community context of the changes needed to promote the public’s health. We examine the concept of participation in an effort to see how different levels of involvement may affect sustainability of community change efforts.

    • Springboard

      2018 - 2019
      Data Science Using Python

      Coursework includes:• Python Programming • Python Data Wrangling• Data Storytelling• Inferential Statistics• Machine Learning: - Supervised Learning: linear & logistic regression, SVM, decision trees, random forests, Bayesian method and text analysis - Unsupervised Learning: K-Means clustering

    • UC Berkeley Extension

      2015 - 2016
      Big Data and Cloud Computing

      Coursework includes:• Introduction to Big Data Concepts, Technologies & Deployment: in-depth understanding of the Big Data & Cloud Technology: grid and cluster computing in cloud infrastructure; data management in the warehouse and in Big Data; SMAQ (Storage, MapReduce and Query) stack, Hadoop, Cloudera, NoSQL; Big Data deployment in Retail, Healthcare, Financial sectors.• Business & Technical Models of Cloud Computing: understanding how cloud computing technologies deliver economies of… Show more Coursework includes:• Introduction to Big Data Concepts, Technologies & Deployment: in-depth understanding of the Big Data & Cloud Technology: grid and cluster computing in cloud infrastructure; data management in the warehouse and in Big Data; SMAQ (Storage, MapReduce and Query) stack, Hadoop, Cloudera, NoSQL; Big Data deployment in Retail, Healthcare, Financial sectors.• Business & Technical Models of Cloud Computing: understanding how cloud computing technologies deliver economies of scale using virtualization, including how they incorporate and expand upon the proven business elements of IaaS, PaaS, and SaaS; learning the technical intricacies of building a scalable, low-cost cloud environment.• Building Your Private Cloud With Linux : discovering the practical side of cloud computing using the Linux operating system; acquiring hands-on experience to install, configure, test and troubleshoot cloud system platforms, the tools and techniques to manage and monitor these platforms. Show less

    • UC Berkeley Extension

      2012 - 2014
      Business Intelligence and SAS Analytics Software Certificate

      Activities and Societies: Data Mining/Modeling/Database Marketing Coursework includes Data Mining Using SAS/Enterprise Miner, Data Analysis Using the SAS System, Advanced Programming Using the SAS System, Database Marketing and Data Driven Customer Relationship Management• Developed a logistic model to predict payment behavior for credit risk data with 1,000 records and 20 drivers, resulting in a high-performance 12-driver model to aid lending for high-risk creditees.• Programmed SAS macros to extract and output required information from 8-year time… Show more Coursework includes Data Mining Using SAS/Enterprise Miner, Data Analysis Using the SAS System, Advanced Programming Using the SAS System, Database Marketing and Data Driven Customer Relationship Management• Developed a logistic model to predict payment behavior for credit risk data with 1,000 records and 20 drivers, resulting in a high-performance 12-driver model to aid lending for high-risk creditees.• Programmed SAS macros to extract and output required information from 8-year time series data, using a rolling time window.• Built the statistically best model in a database marketing simulation, lifting response rate by 73%, using regression, decision trees, neural networks, and exports to XML codes. Show less

    • California State University - East Bay

      2010 - 2012
      M.S. Statistics (Statistical Programming, Data Analytics, Social Behavioral Research) 3.7

      Activities and Societies: Member of the American Statistical Association and the Bay Area SAS User Group; Advanced SAS Courses at Western Users SAS Software Conference 2011: Advanced Reporting and Analysis Techniques for the SAS, Maximizing Productivity and Efficiency using Proc SQL • Analyzed 4,177 observations using linear regression in SAS to identify the key measurements of sea snails and to build two comparative models to forecast their ages• Tested hypotheses and performed logistic regression in SAS to determine the relationship between risk and return among 3 insurance industries, including 104 companies, for a hypothetical hedge fund investment• Conducted a survey analysis in SPSS, including constructing the questionnaire, testing reliability and… Show more • Analyzed 4,177 observations using linear regression in SAS to identify the key measurements of sea snails and to build two comparative models to forecast their ages• Tested hypotheses and performed logistic regression in SAS to determine the relationship between risk and return among 3 insurance industries, including 104 companies, for a hypothetical hedge fund investment• Conducted a survey analysis in SPSS, including constructing the questionnaire, testing reliability and consistency, and performing item analysis, resulting in a consistent, scientifically-rigorous 14-item survey• Performed ANOVA in SPSS to determine actual contrasts in fuel efficiency across cars manufactured in the U.S., Europe, and Japan• Programmed 7 academic projects in R, Minitab, and ggobi for ANOVA, hypothesis testing, descriptive and multivariate analysis, visualization, and data sampling Show less

    • UC Irvine

      2019 - 2020
      Business Intelligence & Data Warehousing

      • Descriptive Analytics - Business Intelligence & Data Warehousing:Principles of Dimensional Modeling; DW Development Approaches; DW Implementation Concerns; E-R Modeling; Data Schemas; Maintaining Dimension Tables; Supporting Business Value; Data Extraction; Transformation, & Loading (ETL); Data Quality Concepts• Predictive Analytics - Data Mining Process, Methods & Algorithms:Data Mining Concepts, Applications, Process; Methods & Tools; Text Mining, Web Mining & Social Analytics;… Show more • Descriptive Analytics - Business Intelligence & Data Warehousing:Principles of Dimensional Modeling; DW Development Approaches; DW Implementation Concerns; E-R Modeling; Data Schemas; Maintaining Dimension Tables; Supporting Business Value; Data Extraction; Transformation, & Loading (ETL); Data Quality Concepts• Predictive Analytics - Data Mining Process, Methods & Algorithms:Data Mining Concepts, Applications, Process; Methods & Tools; Text Mining, Web Mining & Social Analytics; Apply text, web, and social media analysis to predictive analytics concepts; Perform sentiment analysis with R & Tableau Desktop• Prescriptive Analytics - Optimization & Simulation: Analytical Decision Modeling; Simulation Modeling; Optimization Techniques; What-if Analysis• Emerging Trends: Real-time Data Warehousing; Parallel Processing; Location-based Analytics; DW Appliances; Data Fusion; Syndicated Data; Emergence of Standards; Web-enable DW; Data-as-a-Service (DaaS); Analytics-as-a-Service (AaaS) Show less

    • Hochschule Karlsruhe (HKA) / University of Applied Sciences

      2004 - 2008
      B.Eng. Industrial Engineering Business Admin & Engineering/Sales Engineering “A” grade for thesis on Strategic Marketing

      Focus on: Market Research for Technical Products & Services

  • Experience

    • Taylor Nelson Sofres

      Apr 2000 - Apr 2003
      Field Interviewer

      • Interviewed retail consumers in the field for 17 market research projects, including for Nestlé and Pepsi

    • PRO.FILE by Revalize

      Jun 2005 - Sept 2005
      Marketing Intern

      • Assisted company-wide rebranding, including the creation of new, design-rich documents and the management of client relationships at 4 industry trade shows• Tracked over 200 customer contacts in the firm CRM system• Edited and generated sales materials according to specific needs, under demanding deadlines

    • Bosch

      Oct 2006 - Sept 2007
      Data Analyst Intern

      • Determined key factors leading to financial losses, through estimation of cost changes and reconciliation of expenditures against budgets• Communicated, cross-departmentally and cross-functionally with 11 managers, to prepare project reports• Delivered ad-hoc business reports in a timely manner, using internal financial software, SAP, and SQL

    • Self-Employed Contractor

      Aug 2008 - Aug 2011
      Project Consultant

      • Advised a Vietnamese client in upgrading bill acceptors for 503 vending machines, creating a purchasing plan, identifying the best upgrade option, ordering, and inspecting the delivery• Informed a German vending machine wholesaler of the strategic opportunities and risks of entering the developing Vietnamese beverage market, saving the company from losing a $675,000 investment• Analyzed secondary market research data to define market niches, reported market positioning, and outlined a financial plan for the initial business proposal• Created a vetting procedure for a commodity trading company to quickly flag fraudulent commodity trading partners, thereby selecting 9 capable ones out of nearly 4,900 contacts• Managed the first phone-order bookstore and office product delivery service in Ho Chi Minh City, using local connections to supply 6 schools and 4 educational organizations, repaying my investors in 2 months Show less

    • California State University - East Bay

      Sept 2011 - Dec 2012
      Research Assistant/Program Data Analyst

      Led a group of 5 research assistants to support Statistics Department Chair to analyze data for research projects using SAS and JPM, writing SAS macros and creating data entry templates to reduce processing time by 35%• Monitored the progress of more than 1,000 students in a 6-year cohort study, justifying funding • Created datasets with 146 variables per student from varied sources: scantron, Excel, paper tests, and SAS• Manipulated and cleaned data, using SAS Data Step, character and numeric functions, and procedures including PROC IMPORT/EXPORT, MERGE• Managed 49 datasets, using MEANS, FREQ, CONTENTS, and SQL procedures• Analyzed and interpreted pre- and post-exam score data• Evaluated survey data and conducted item analysis across 35 questions to determine the correlation of item difficulty and students’ performance, defining item difficulty levels and item discrimination indexes • Prepared analytical reports, using SAS/ODS, as well as PROC TABULATE and REPORT• Visualized all analysis results with various charts; edit and write 3 statistical reports Show less

    • Holy Names University

      Dec 2012 - Nov 2015
      Research Analyst

      Responsible for statistical programming (SAS Base, SAS Enterprise Miner, SPSS, R, SQL) supporting the Institutional Research Office and generating mandatory reports (PowerBI, SQL, SSRS, Excel, VBA) to federal, state, and accreditation organizations (IPEDS, CSAC, WASC, Commission for Collegiate Nursing Education, NCAA, etc.) • Leveraged insights from 5-year historical data to drive forecasting, innovating a new cost allocation structure among instructional, housing, and auxiliary businesses, identifying underfunded programs.• Developed and automated reports and dashboards; generate codebooks, using SPSS, Excel, and VBA.• Aided HNU’s Nursing Chair to conduct analytical research and present student learning outcomes in 127 classes over the last decade, successfully renewing accreditation for the BSN and MSN programs.• Built predictive models to support enrollment operations management, using SAS Enterprise Miner.• Improved data quality and integrity, establishing convenient access to 90% of historical IR’s statistics.• Compiled annual Fact Book, 41 reports on program effectiveness, and other internal ad-hoc analyses. Show less

    • Life Chiropractic College West

      Nov 2015 - Feb 2019
      Manager of Data Analytics

      Responsible for managing data analytics projects including data mining, statistical analysis, developing BI dashboards, survey administration/research, and automating reports and implementing data relevant software/systems, using SQL, SSMS, SPSS, Python, Tableau, SalesForce, KNIME, Qualtrics, MS Office (Access, advanced Excel with macros & VBA, PPT), MindManager, Canvas, LiveText, CAMS Enterprise• Served as a primary role in assuring data quality and integrity to create a centralized data center from multiple sources (ERP, EMR/EHR, SIS systems)• Led project teams to develop and implement new tools/frameworks to collect and report data, including testing Oracle data warehouse, Informatica Data Management tools and ERP/EHR solutions• Provided expertise in data management and promoting actionable data use in collaboration with department heads and the college‘s technical staff• Conduct benchmarking and gap analysis, hypothesis testing and research on healthcare, operational data, and student learning outcomes Primary Software: SQL, SSMS, SPSS, Python, Tableau, SalesForce, KNIME, Qualtrics, MS Office (Access, advanced Excel with macros & VBA, PPT), MindManager, Canvas, LiveText Show less

    • HL Analytics & Consulting, Inc.

      Jul 2017 - Jan 2019
      Analytics Consultant

      • Advised Nursing Practitioners at John Muir Medical Center on departmental research projects; performed analyses, interpreted results & created a presentation that was easily translatable for client delivery for a research project on a new measurement tool• Compiled, visualized data and advised on presenting the results of research project treatment effectiveness

    • HealthHelp

      Mar 2019 - Jun 2020
      Sr. Client Informatics Analyst

      Lead Client Service Analyst team to handle healthcare analytics projects for HealthHelp’s long-standing and primary client. Responsible for building and automating BI dashboards, performing analyses, developing new analytical tools and documentation, supporting data warehouse projects, providing insight to Client Service Department, using SQL, SSMS, Visual Studio, MDX/DAX, Tableau, advanced Excel, KNIME, MindManager and R ● Write, debug and optimize SQL scripts and develop BI dashboards to reduce 30% of processing time● Create a new layout for Quarterly Business Reviews, leveraging insight while maintaining sleek design● Re-design more than 20 reports for 54 Humana’s Medicare regions and Commercial markets from end to end, including claims-, consuls-based KPIs, quality and safety metrics● Assess and analyze external customer requirements and needs related to healthcare quality, cost and provider performance through conference calls with clients and meetings with other departments● Complete more than 26 reoccurring and/or ad-hoc reports and analyses per month consistently● Identify data quality and integrity issues from databases for escalation and resolution with BI/IT● Initiate and write Standard Operations Procedures (SOP)● Reconcile various data sources to increase quality and consistency of BI dashboards across departments ● Help with recruiting, training and supervising Client Service Analytics analysts Show less

    • CSAA Insurance Group, a AAA Insurer

      Jun 2020 - now
      Insurance Analyst IV

  • Licenses & Certifications

    • Qualtrics Research Core Certification

      Qualtrics
      Apr 2017

    • Business Intelligence and SAS Analytics Software Certificate

      UC Berkeley Extension
      Aug 2014

  • Volunteer Experience

    • Volunteer Data/Clinical Research Analyst

      Issued by Statistics Without Borders
      Statistics Without BordersAssociated with Hao Le

    • Statistical Reviewer

      Issued by The Journal of Chiropractic Education on Nov 2014
      The Journal of Chiropractic EducationAssociated with Hao Le

    • Teacher/Mentor

      Issued by KAVN on Jan 2004
      KAVNAssociated with Hao Le