Data Analyst with Strong Microsoft Office Proficiency

Christina Mellor

Feasterville, PA

+1-215-***-**** **********@*****.*** https://www.linkedin.com/in/christina-mellor-analyst/

SUMMARY

Data analyst skilled in extracting insights for strategic decision-making. Proficient in statistical analysis, data visualization, and multiple analytical tools. Adaptable problem solver with a proactive approach to identifying trends and opportunities in complex datasets.

SKILLS

•Skills: Data Analysis, Statistical Analysis, Data Modeling, Predictive Analytics, Data Cleansing, Data Visualization, Business Intelli- gence, Data Interpretation, Data Warehousing, Quantitative Analysis, Dashboard Development, SharePoint, Big Data, AI

•SOFTWARE: R, Python, SQL Server Reporting Services, Advanced Microsoft Office Suite (Excel, Access, PowerPoint, Word, Outlook), SQL and SAS Coding, Alteryx, Tableau, HTML, Pascal, BASIC, Fortran

WORK EXPERIENCE

BUILDING INSPECTION UNDERWRITERS OF PA

ADMINISTRATIVE ASSISTANT

Schedule inspections and coordinate logistics based on inspector preferences

•Managed phone communications and filed completed inspections, improving response time and organization

•Recorded payments and maintained accurate documentation, ensuring financial accuracy and compliance

•Created a master spreadsheet to cut data retrieval time by over 90%

ALPHA CONSULTING @ NOVO NORDISK Sep 2022 - Dec 2023

DATA ANALYST (PHARMACEUTICAL) Plainsboro, NJ

Analyzed and interpreted complex datasets to support drug development and marketing strategies. Collaborated with cross-functional teams to ensure data accuracy and compliance. Developed reports and visualizations to inform decision-making and improve operational efficiencies.

•Conducted training sessions for colleagues on Alteryx after mastering the tool

•Developed and updated quantitative tracking models with documented assumptions

•Provided brand and market specific analytics to support the Commercial Insights and Analytics team

•Implemented process improvements that reduced data processing time by 40% and improved data quality

•Developed and maintained complex data models to support pharmaceutical research and development projects, facilitating more accurate and efficient data analysis

•Created and updated Tableau dashboards to assist in tracking changes over time, improving the team's ability to monitor and respond to trends effectively

LANCESOFT @ BRISTOL MYERS SQUIBB Feb 2022 - Sep 2022

DATA ANALYST Lawrenceville, NJ

Responsibilities included analyzing datasets, generating reports, and identifying trends to support decision-making. Collaborated with cross-functional teams to ensure data accuracy and provided actionable insights. Utilized tools like Excel and Access to streamline processes and enhance data-driven strategies for business growth.

•Developed an interactive decision tree using Microsoft Forms to optimize project resource allocation, improving efficiency in resource management by over 40%

•Updated Tableau dashboards and other reporting environments with the latest weekly reports, enhancing data visibility and deci- sion-making

•Employed pivot tables and filters in Excel for data extraction and analysis, leading to more efficient data processing and insights

•Analyzed large datasets to identify trends and patterns, which informed strategic business decisions and improved operational outcomes

•Prepared comprehensive reports and visualizations to communicate insights to stakeholders, facilitating informed decision-making and strategic planning

HORIZON BLUE CROSS BLUE SHIELD OF NEW JERSEY Feb 2019 - Nov 2021

ANALYTICS ANALYST I Pennington, NJ

Analyzed data to support business decision-making. Developed reports and visualizations to identify trends and provide insights. Collaborated with cross-functional teams to enhance data accuracy and drive efficiency improvements. Supported strategic initiatives by interpreting complex datasets for enhanced business performance.

•Developed SAS scripts to generate critical data extracts, which improved efficiency of the analytics department's workflows by 90%

•Analyzed financial and clinical data from multiple sources, contributing to affordability and utilization analytics that informed cost-saving strategies

•Created data visualizations using Excel charts and Tableau dashboards, which facilitated timely project completion and informed decision-making

HORIZON BCBS OF NEW JERSEY

MARKET RETENTION SPECIALIST II

Sep 2017 - Feb 2019

Mt Laurel, NJ

Developed and managed client retention strategies, analyzed customer data, and implemented personalized communication plans to improve loyalty. Collaborated with sales and marketing teams to address feedback and resolve issues, enhancing customer satisfaction and reducing churn. Monitored retention metrics to inform strategic decisions and support business growth.

•Developed Excel tools to efficiently track outreach progress and disenrollment trends, leading to improved data accuracy and timely decision-making

•Constructed reports evaluating enrollment fluctuations using Tableau, SQL Server Reporting Services, and Excel, which facilitated better understanding of customer behavior and informed strategic planning

RANGAM CONSULTANTS INC @ HORIZON BCBS OF NJ May 2016 - Jun 2017

BUSINESS ANALYST Ewing, NJ

Evaluated data trends, developing reports, and assisting in strategic planning. Collaborated with cross-functional teams, identified business needs, and implemented solutions to enhance efficiency.

•Utilized Access and external Excel queries to produce weekly and biweekly reports, improving data accessibility for decision-making

•Evaluated data trends using statistical analysis to support strategic planning and improve business forecasting accuracy

•Managed communication through mail merge and improved successful contract amendments tracking by 60%

APEX SYSTEMS @ COVANCE Feb 2016 - May 2016

RECORDS MANAGEMENT ASSOCIATE Princeton, NJ

Organized and maintained records efficiently. Ensured compliance with regulations and facilitated data accuracy. Collaborated with teams to implement digital filing systems, reducing paper clutter. Assisted in safeguarding sensitive information and supported efforts to streamline document access for enhanced productivity.

•Enhanced document recording systems improving paper retrieval rates by 60% and maintained primary logs in SharePoint

•Ensured compliance with legal and regulatory requirements by auditing and updating records management practices

•Collaborated with departments to facilitate timely archival and disposal of outdated or unnecessary documents

INNOVATIVE DEVELOPMENT, LLC @ COVANCE Nov 2014 - Mar 2015

DATA ANALYST Princeton, NJ

Collected, cleaned, and interpreted complex datasets to drive business decisions.

•Provided training and mentoring, ensuring team cohesion and project clarity, which led to improved team performance and project outcomes

•Contributed to the development of a proprietary database to house all necessary documentation for each clinical trial, ensuring completeness and regulatory compliance

•Completed the project 50% sooner than anticipated through effective collaboration and streamlined processes, enhancing project efficiency

•Validated database accuracy and collaborated with project leaders to acquire missing data

OTHER EXPERIENCE

•Bench Chemist working with adhesive development and testing

•Lab Tech Intern involoved in microbiological testing of liposomal cancer treatments for efficacy

•Various jobs involving sales calls, polls, surveys, census taking, or following up with current customers

EDUCATION

Capella University

Jul 2019 - May 2022

Master of Science, Analytics

•GPA: 4.0

•Coursework: SAS, SQL, Tableau

Minneapolis, MN (online)

Messiah College

Bachelor, Biology (Minor: Computer Science)

Mechanicsburg, PA

CERTIFICATIONS/TRAINING

•MICROSOFT DATABASE TECHNOLOGY SPECIALIST:2025 Springhouse Education and Consulting Services: Excel 2, Excel

3, Excel Power Pivot, Excel VBA Programming, Access 1,2,3, Querying Microsoft SQL Server

•ALTERYX CORE CERTIFICATION:2023 Alteryx

•DATA ANALYTICS w/ R & PYTHON:2025 Upright Education (Elizabethtown College) Topics included SQL, Tableau, R, and Python

Aug 2025 – Nov 2025

Feasterville, PA

Contact this candidate