Samantha Flanigan

Bachelor Degree: Actuarial Science

2015 - 2019

University of The West Indies, Kingston, Jamaica

• Relevant coursework: Calculus, Linear Algebra, Differential Equations, Time Series, Probability, Statistics, Economics, Financial Mathematics, Financial Management, Accounting, R, Python and Java
• Clubs and Society: UWI Actuarial Society, active club member and advocate, assisting with major events

Software Development Engineer

2022 - Present

CVS Health, NYC

Aetna - Data Engineer Team

• Create and maintain complex R Shiny applications based on internal stakeholder's need, serving as the primary owner of all associated projects
• Great relationship with POSIT(RStudio) group, leading meeting with questions and strategies to improve overall user experience
• Introducing meaningful initiatives and rewriting current R Shiny projects in React JS and Tailwind CSS, all while having detailed documentation for code readability and simplification purpose across the team
• Assists in the development of large-scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs using GCP and Airflow DAGs
• Worked on high level projects that involved building out the APIs using Python, FastAPI, SQLAlchemy and GCP BigQuery and Spanner, with excellent documentation

Marketing Data Analyst

2022

SelectQuote Insurance Services, KS - Remote

• Work with complex database queries in Microsoft SQL Server Management Studio, doing a mixure of data engineering, architecture, ETL, cleaning and wrangling using CASE statements, JOINS, APPLY, CLUSTERED & NON-CLUSTERED INDEX, GROUP BY, WINDOW FUNCTIONS, PIVOT, PATINDEX, etc.
• Daily function include using tools such as R (including R Shiny Dashboard), SQL, Excel to perform daily analysis and engineering to produce results for the team
• Collaborate closely with internal marketing team members to develop ad hoc reporting as needed to ensure each team has the data needed to hit KPI targets
• Collaborate with members of Sales, Finance, Operations and Accounting departments

Quality Assurance Analyst

2020 - 2021

Centene Corporation, NC - Remote

• Worked with complex database queries in Microsoft SQL Server Management Studio and PL/SQL Developer
• Worked closely with Business Analysts, formulated test plans, prepared test cases, executed tests, and fully documented and reported the results. Test cases were developed and documented based on business requirements, functional and technical requirements, user stories and business use cases
• Provided defects reports, test status updates and QA UAT signoffs to assigned managers
• Collaborated with cross functional teams and provided QA support for scheduled deployments/releases, using test management applications/tools such as Jira and Q-Test. Later introduced to TOSCA application

Reporting Analyst

2018 - 2019

Sagicor Bank - Kingston, Jamaica

• Extracted and aggregated data from large dataset using SQL
• Created reports to interpret customer behavior, utilization, trends and presented data in a graphical format using MS Excel and Power BI to assist managers and vice presidents with decision making
• Created data dashboards that visually tracked, analyzed and displayed key performance indicators (KPI), metrics and key data points that monitored the health of the business
• Liaised with IT Reporting Team, developed and automated reports, which improved the understanding of client behavior

Junior Analyst Intern

Summer 2018

Sagicor Bank - Kingston, Jamaica

• Collaborated with other team members and examined vast dataset, provided insights, predictions and reports to supervisor; ensuring that data integrity was upheld
• Assisted in the segmentation of the credit card consumer portfolio
• Successfully validated various revenue lines for Payments (Acquiring and Issuing)