Lukas Halim Email & Phone Number

Maryland, United States

Trained sales team on Cigna’s Value of Integration study. The evaluation, executed by Aon, demonstrated Cigna's integrated employer clients saved $148 per member per year.Filled high-priority gap in client reporting for 2% of customers with a benefit type not handled by existing reporting. Critical to conversations with clients at risk of termination.Helped teammates develop understanding of business context and ideate analytic plans.Edited analytics results to remove database terminology and statistical jargon, simplifying verbiage, and applying visualization best practices.Automated process for executing causal inference analysis, replacing previous error-prone and repetitive copy-and-paste SAS process with a Python notebook running on Databricks that reads an input file with parameters, executes based on the parameters, and preserves the results in the database. Simpler, faster, and more reliable process for running 50+ causal inference evaluations.Partnered with scrum team to test and troubleshoot migration of utilization management savings process from on-prem Hadoop to cloud.Forecasted impact of proposed product launch on affordability impact, member disruption, and geographic access.

Created interactive dashboard to allow product time to determine optimal pricing for performance guarantees. Related to this work, performed review of methodology and finding fix areas where the legacy methodology could be modified to better capture performance. One of these changes showed a projected 300% increase in measured savings.Contributed to the development of reporting layer to integrated specialty medications from the pharmacy and medical benefit with value-added fields. This facilitates both internal trend analysis client reporting. Specialty medications account for more than 50% of all pharmacy spend, so having visibility across both pharmacy and medical benefits is critical to managing affordability.Served as subject matter expert to for development of utilization management savings results and opportunity for client reporting.

Everything you need to land your first data analyst position. No connections, degree or prior technical experience required.

I've developed and maintained two well-reviewed Tableau courses on Udemy. One course covers the Tableau Specialist certification and the other covers the Tableau Data Analyst certification. More that 80,000 students have signed up to date, and courses receive ratings in the 4.5 to 4.6 range. I also offer stand-alone practice tests on my website, LearningTableau.com. Numerous students have told me that my course helped become more proficient and pass the exam, and some have also mentioned it helped them to get a better position.

• Built predictive models used to prioritize outreach to customers at high risk of opioid overdose. Partnered with Data Engineering to move models to production and provided support for behavioral team using the model for telephonic customer engagement.• Developed methodology to measure cost savings created by pharmacy and medical drug utilization management activities including drug prior authorizations, letters to notify customers of lower cost therapeutic alternatives, and drug quantity limits. Prototyped SQL to implement savings, oversaw implementation, compared results to legacy savings methodologies, assisted with development of Tableau dashboard, and presented results to clinical experts, medical directors, and finance, and documented methodology.• Using Teradata SQL, combined claims data with data on member benefits and state-level legislative restrictions to forecast impact of proposed benefit changes.• Using R, created tool for forecasting pharmacy utilization for anomaly discovery.• Provided feedback on feature set of various analytics tools such as Databricks, DataHaiku and Domino.• Delivered and presented match case control retrospective analysis comparing outcomes for patients filling specialty medication from Cigna’s home delivery pharmacy versus those using retail pharmacy.

• Scoped and implemented approximately 15 recurring reports for executives using PowerPoint, Excel and SharePoint, including Visual Basic macros and automated consistency checks.• Managed local and off-site team members in the preparation of reports for executives on two federal government accounts.• Implemented process improvement to accelerate forecasting process. As a result, month-end portfolio forecasts available days earlier.• Developed best practices and automation for proposal submission process, from request for proposal through document review and contract award. Reduced time required to track 200-300 yearly proposal submissions. Adapted process improvements for use on a second account.• Combined data from multiple sources to improve visibility into employee billable hours.• Authored training documentation, ensuring continuity of knowledge.• Fixed project management tool by correcting code defects and extended functionality, allowing team to identify issues impacting project progress.

Washington D.C. Metro Area

• Gathered requirements, designed, built, tested, and implemented migration from Excel to a web-based database system. Benefits of migration included improved data accuracy, version control, security, and ability to easily create multiple views of a shared data set. • Created workflow to improve coordination between contracts and invoicing teams, reducing the redundancy in data entry.• Delivered a presentation explaining the advantages and disadvantages of data management tools. Compared and contrasted Excel, SharePoint, file repositories, and SQL databases.• Taught colleagues to use Excel more effectively, frequently helping them write formulas and macros.• Extended standard SharePoint security settings using custom JavaScript code, allowing contract and finance teams to share data without compromising accuracy. • Prepared documentation in response to audit.

Washington D.C. Metro Area

Provided testing, deployment, and application support for projects with USPS and the Census Bureau.

New Haven, Ct

• Supervised team of developers designing and building components of company website receiving 20 million hits a day.• Developed flexible web-based tool that allows users to create custom multi-level dashboards based on data entered via website or Excel upload. Over three hundred dashboards created using the tool.• Managed the process of enhancing website module, including clarifying client requirements, judging project feasibility and timeline, and implementation.• Quickly learned website development technologies.

Master Of Science, Analytics, Analytics

• Projects includes predicting winning bids for a construction company; clustering survey data for an online travel site; mining web data.

Intro To Machine Learning With Pytorch, Machine Learning

Bachelor Of Arts (B.A.), History

Intro To Machine Learning With Pytorch, Data Science

Completed Python supervised learning, deep learning, and cluster analysis projects