Used Python, SQL (Postgres), and Jupyter Notebook to design and run ETL pipeline from production app database to data analytics schema, taking advantage of Jupyter Notebooks to visualize data during development to ensure accuracy.
•
Wrote Python script and AWS email services to automate manual metrics aggregation and distribution for client-facing team.
•
In charge of writing Python scripts that parsed and fed medical claims data into production database (OMOP schema).
•
Handled data transfer from SFTP servers into AWS S3 buckets, including data validations of medical claims data w/ Pandas.
•
Wrote Python script to aid in automation of quarterly reporting cycle by shifting calculations in Tableau to Python and generalizing the process to all clients; reducing report creation time from days to minutes by minimizing manual formatting.
•
Improved ROI methodology by comparing medical spend of clients before and after on-boarding with Rightway platform.