Data Analyst Modeling

J. MCKINNON

Phone:(***)-***-Data **** Email: Analyst *****************@*****.***

LinkedIn: www.linkedin.com/in/julia-m-266612b5 GitHub: GitHub: McKinnonJulia Legal Status: [US Citizen]

Summary

Results-driven Data Analyst with 3+ years of experience in data modeling, mining, and segmentation. Advanced skills in Oracle, SQL, PL/SQL, and statistical analysis. Proven ability to translate complex data into actionable business insights, communicate findings to technical and non-technical audiences, and deliver high-quality results across multiple concurrent projects.

Technical Skills

● Databases: Oracle, SQL, PL/SQL

● Programming: XML, JavaScript

● Data Modeling: Star schemas, dimensional modeling

● Data Analysis: Data mining, segmentation, statistical analysis

● Statistical Packages: R, Python (pandas, NumPy), SAS (as applicable)

● Reporting: Report writing, data visualization, dashboard creation

● Other Tools: Microsoft Excel (advanced), Power BI, Tableau (if applicable)

● Soft Skills: Analytical thinking, attention to detail, strong communication, project coordination

Relevant Experience

Data Analyst

Mona May 2023 – Present

● Designed and maintained data models and star schemas to optimize reporting and analytics for business stakeholders.

● Conducted data mining and segmentation to uncover trends, patterns, and actionable insights for multiple business units.

● Wrote and optimized complex PL/SQL queries for data extraction, transformation, and reporting.

● Utilized statistical packages (e.g., R, Python, SAS) to analyze large datasets and support data-driven decision-making.

● Presented findings and recommendations to both technical and business audiences, ensuring clarity and actionable outcomes.

● Managed multiple projects simultaneously, collaborating with business groups and vendor partners to ensure timely delivery.

Junior Data Analyst

Athnea Healthcare Jan 2021 – Apr 2023

● Supported the development and maintenance of data models and ETL processes for enterprise data warehouses.

● Assisted in data quality assurance, validation, and cleansing to ensure accuracy and integrity across shared data sources.

● Developed dashboards and ad hoc reports to support business operations and project needs.

● Collaborated with cross-functional teams to gather requirements and deliver data solutions.

Billing Support Analyst I

SimpliSafe Jun 2020 – Dec 2020

● Provided billing and claims support for Rural Health Clinics and FQHCs, applying knowledge of unique regulatory requirements.

● Assisted with anesthesia and hospital billing processes, ensuring compliance with payer guidelines.

● Delivered high-quality customer service to internal and external stakeholders, earning recognition for responsiveness and professionalism.. Education

Certified Business Data Analysis Professional University of Richmond Tableau Desktop Specialist, Tableau

Microsoft Excel (Intermediate/Advanced) Assessment Bachelor of Science in Computer Science

Virginia Commonwealth University, Richmond, VA

Graduated: 2019

Contact this candidate