Learn Data Skills
Beta
Russell Trojan

Russell Trojan

Senior Data Analyst

Innovative Renal Care

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Data ninja, stealthily extracting insights from complex datasets.

My Work

Take a look at my latest work.

course

Introduction to Statistics

course

Introduction to SQL

course

Intermediate SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Innovative Renal Care | Jan 2024 - Present

Senior Data Analyst

N/A

Innovative Renal Care | Aug 2023 - Dec 2023

Senior Marketing Analyst

• Perform market research and analysis to identify and prioritize growth opportunities. • Evaluate methods for collecting and aggregating data. • Collaborate with team members across the organization to identify data- driven opportunities. • Design and build dashboards to measure performance and guide the team’s efforts towards initiatives with the largest impact.
Show More

Penn Medicine, University of Pennsylvania Health System | Jun 2021 - Jul 2023

Senior Marketing Analyst

• Developed reports and data visualization for both physician marketing and referral analytics. • Blended data from multiple sources within the department’s Data Mart. • Utilized Microsoft SQL Server and Tableau for analysis, dashboards, and workbooks. • Provide training and support for managed dashboards. • Tracked physician marketing social media and email campaign performances. • Developed strategic target lists for physician outreach and business development initiatives, aligning efforts with organizational goals and optimizing growth opportunities.

Provident Bank | Sep 2019 - Jun 2021

Marketing Data Analyst

• Successfully migrated from the department’s Marketing Customer Information File (MCIF) system to a CRM platform and managed the maintenance of the CRM Platform. • Developed reports and data visualization from multiple data sources for various internal departments and outside vendors. • Defined data requirements for data collection, integration, and validation. • Developed and manage solicitation files to support direct mail and email campaigns. • Assisted with the department’s budget analysis.

Penn Medicine, University of Pennsylvania Health System | Dec 2017 - Sep 2019

Senior Data Coordinator, Customer Engagement & Marketing Analytics

• Supported the Marketing data infrastructure (DataMart and CRM platform). • Gathered, analyzed, repaired, and integrated data from numerous data sources. • Collaborated to create an Extract-Transform-Load (ETL) workflow within Alteryx Designer that loads data from the CRM platform into a SQL Server DataMart, resulting in the ability to populate data in multiple reporting and visualization tools. • Provided support and quality assurance for multiple customer applications. • Developed comprehensive physician marketing lists to support direct mail and email campaigns.

Penn Medicine, University of Pennsylvania Health System | Jul 2014 - Dec 2017

Data Coordinator, Customer Engagement & Marketing Analytics

• Coordinated and implemented activities required for maintenance of the department’s databases. • Utilized Salesforce, Access, SQL Server, and Excel to create, edit, and run reports to support data management and quality assurance objectives. • Utilized Salesforce Data Loader to insert, update, and delete large volumes of CRM data. • Developed comprehensive physician marketing lists to support direct mail and email campaigns.

Weston Solutions, Inc. | May 2011 - Aug 2012

Information Services Intern (Summers 2011 & 2012)

• Developed SQL queries to access data from relational databases. • Utilized Oracle SQL Developer, Access, and Excel for reporting and quality assurance tasks. • Performed testing and debugging of SQL scripts.

My Education

Take a look at my formal education

Master of Science in Management (M.S.M.), Management InformationWilmington University
Bachelor of Science (B.S.), Management Information Systems, PsychologyPhiladelphia University

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free