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.

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.

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.

• 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.
• 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.
• 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.
• Combined data from multiple sources to improve visibility into employee billable hours.
• Authored training documentation, ensuring continuity of knowledge.

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.
• 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