Learn Data Skills
Yekaterina Kozyr

Yekaterina Kozyr

BI Developer

Self

Technologies

My Portfolio Highlights

My New Project

Analyzing Students' Mental Health

My New Track

Tableau Fundamentals

My New Course

Introduction to Python

My New Project

Analyzing Students' Mental Health

Data archaeologist, unearthing buried insights from historical records.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Introduction to Python

course

Introduction to SQL

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Intermediate Python
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Shift Paradigm | Nov 2021 - Present

Consultant, Data & Analytics

- Consult with clients on automation of manual reporting - Extract, manipulate and analyze data utilizing RedShift and SQL - Design, create and implement data sources within Tableau via Custom SQL and other data connections - Design, build and implement automated client reporting via Tableau - Identify and analyze KPIs - QA and troubleshoot existing dashboard builds - Manage and plan billable client tasks utilizing WorkFront
Show More

Fortegra | Jun 2020 - Oct 2021

Data Reporting Analyst

Accepted a full-time role as Data Reporting Analyst upon successful completion of Fortegra's Leadership Development Program. Primary Responsibilities: -Extract, transform and analyze data via SQL, Toad Data Point and OBIEE 12c. -Automate existing static company reports and dashboards utilizing Data Modeling, SQL, OBIEE 12c, XSLT, and HMTL/CSS/JavaScript. -Analyze business trends and performance and relay findings to company executives. -Generate, analyze and recommend new business leads for Sales teams through use of AI-assisted software. -Maintain data integrity via validation and troubleshooting of reports and dashboards. -Train colleagues to utilize and create their own reporting via OBIEE 12c and Toad Data Point. Technical Skills: -Advanced SQL in conjunction with a RDBMS to extract, transform and analyze Big Data. -XML and XSLT to construct Oracle BI Publisher data models and dynamic reports. -HTML/CSS/JavaScript to develop and design corporate reporting and presentations. -RPGLE -Linux/Ubuntu to test implementation of a Hadoop cluster in development.

Fortegra | Jun 2018 - Jun 2020

Leadership Development Program Associate - Data Analytics Rotation

Primary Responsibilities: -Utilize ETL, SQL, XML, XSLT and HTML to model, architect and analyze Big Data. -Analyze business trends to assess current company performance and implement recommendations. -Generate, analyze and recommend new business leads through use of AI- assisted software. Technical Skills: -ETL to model, process and utilize Big Data (Sequel Data Warehouse/IBM Rational Developer for i). -SQL in conjunction with a RDBMS to extract, transform and analyze Big Data. -XML and XSLT to construct Oracle BI Publisher data models and dynamic reports. -HTML/CSS/Javascript to develop and design corporate reporting and presentations. -Linux/Ubuntu to test implementation of a Hadoop cluster in development.

Fortegra | Nov 2019 - Feb 2020

Leadership Development Program Associate - IT Rotation

N/A

Advantage Solutions: Sales, Marketing, Technology | Oct 2017 - May 2018

Category Analyst

-Analyzed business and market trends to recommend new strategies for increased sales within the military channel for a transnational consumer goods company. -Evaluated business performance data to assist with sales and profitability of assigned categories. -Designed client reporting to maximize efficiency in evaluating sales performance and product trends. -Developed a company-wide communication bulletin and maximized outreach within the company. -Conducted post-promotion investigation to analyze the marketing impact on categories and brands. -Enhanced existing processes and maximized efficiency of category analysis for the client and internal sales team.

Advantage Solutions: Sales, Marketing, Technology | Jul 2015 - Oct 2017

Business Account Administrator

"Creating exceptional value for military clients and customers through superior sales execution, operational excellence and innovative marketing services."

TalentstreamUS | May 2015 - Jun 2015

Account Manager

-Managed a team of technology recruiters. -Developed and maintained a database of active and potential candidates. -Recruited potential candidates for C-Level positions in business and technology fields.

Center for Advanced Medical Learning and Simulation (CAMLS) | May 2014 - Apr 2015

Administrative Assistant - Continuing Professional Development

Assisted with the development and implementation of continuing medical education and industry programs that have had a 26% Year-Over-Year growth in 2014 and accumulated over $6.4 million in local revenue since 2012. Aided in the organization’s re-accreditation through the Accreditation Council for Continuing Medical Education (ACCME) and American Nurses Credentialing Center (ANCC) through analysis and realization of internal files. Managed databases, calendars and electronic files for multiple supervisors utilizing MS Office and Salesforce. Measured educational outcomes through the summarization and analysis of quantitative and qualitative data extracted from participant surveys and course post-tests. Managed a confidential electronic record database of participant data. Maintained a high client retention rate with exceptional customer service and daily correspondence.

South Florida College of Public Health | Jan 2014 - May 2014

Medical Records Abstractor

-Managed a database of 500+ confidential medical cases of mothers and infants across Florida. -Analyzed data for scientific reporting utilizing MS Office, Access 2010/2013 and SAS 9.3. -Coded maternal and congenital malformations using ICD-9 codes and performed general administrative tasks. -Abstracted over 500 maternal and infant cases throughout the state of Florida in an effort to link hazardous environmental agents to the risk and manifestation of congenital malformations. -Abstracted all assigned cases while following HIPAA guidelines to ensure confidentiality of records.

South Florida College of Public Health | Mar 2011 - Jan 2014

Research Assistant - Data Analyst

-Analyzed qualitative and quantitative data using MAXqdi, Atlas.ti and SAS 9.3 software. -Created a digital resource guide of medical and recreational services for disabled children in Florida. -Transcribed over 25 hours of audio-recorded focus group and interview sessions. -Designed and hand-distributed a statewide survey for families of children with Down syndrome to child development centers and Down syndrome organizations across Florida.

My Education

Take a look at my formal education

Certificate, Post-Crisis LeadershipUniversity of South Florida Muma College of Business | 2020
Graduate Courses, EpidemiologyUniversity of South Florida | 2014
Bachelor of Science (B.S.), Public HealthUniversity of South Florida | 2013
Paxon School/Advanced Studies | 2010

Powered by

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