Learn Data Skills
Beta
Paul Kopyto

Paul Kopyto

Student

Runwise

Technologies

My Portfolio Highlights

My New Track

SQL Fundamentals

My New Course

Introduction to SQL

My New Track

SQL Fundamentals

Insights curator, carefully selecting and presenting the most valuable knowledge.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

course

Introduction to SQL

course

Intermediate SQL

course

Data Manipulation in SQL

DataCamp Course Completion

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

Courses

Introduction to SQL
Intermediate SQL
Data Manipulation in SQL
PostgreSQL Summary Stats and Window Functions

My Work Experience

Where I've interned and worked during my career.

Runwise | May 2021 - Present

Sales Operations Analyst

N/A

bioMérieux | Sep 2020 - May 2021

Sales Tax Analyst

• In charge of setup and maintenance of customer’s sales tax exemption classification data (OITS (OnDemand Indirect Tax Service) / Certificate Manager, SAP, Excel (Pivot Tables, vlookups)) • Drove continuous communication and updated tax documentation for thousands of present and new customers. • • Updated and improved customer databases on a continuous basis between the software providers and IT for new business requirements and customer needs. • Managed and updated data for multiple state sales tax audits, bringing to management’s attention any potential areas of contention with the taxing jurisdictions, and clearing up any data inconsistencies (SQL, SharePoint, Salesforce tools). • Prepared state/federal returns in all states, along with property tax compliance, assessment, and valuation, and tax accrual calculations. • Managed dozens of weekly customer tax dispute reports, researched, and determined taxability issues concerning the disputes between customers and Biomérieux. • Supported the A/R and Credit Analyst teams with clearing up questions regarding customer taxation (weekly SCRUM meetings).
Show More

PwC | Jan 2020 - Mar 2020

Tax Clerk at Pwc

• Administered the necessary support to internal teams with a strong working knowledge of excel • Tracked and quality reviewed a high quantity of tax documents for inconsistencies • Maintained and updated PwC client Accounts • Experience with a high-volume workload while also knowing when to ask for support • Provided services in a manner that demonstrates the highest levels of quality, accountability, and teamwork

Agata & Valentina | Jun 2017 - Oct 2018

Inventory Analyst

• Used Excel knowledge to continuously plan over a set time horizon (pivot, lookups) • Reconciled T&E expenses and full-cycle Accounts Payable with SAP • Managed database and conducted inventory analysis using SQL • Maintained and updated chart of accounts, various bank accounts and bank reconciliations using QuickBooks • Reviewed invoices and ensured accurate GL account coding • Responsible for over 40 vendor accounts by matching purchase orders to invoices and data entry • Projected and analyzed product costing and value-added models • Analyzed inventory with WMS and predicted future trends in the growing specialty food market • Worked with food suppliers to manage the best deals for customers • Ensured a high quantity of payments are processed in a timely manner • Cross-referenced high volume of bills with agreed-upon pricing • Prepared and placed purchase orders with vendors

Hunter College | Jan 2016 - Apr 2017

Volunteer Income Tax Assistant (2016 - 2017 tax seasons)

The Volunteer Income Tax Assistance (VITA) program offers free tax help to people who generally make $54,000 or less, persons with disabilities and limited English speaking taxpayers who need assistance in preparing their own tax returns. IRS-certified volunteers provide free basic income tax return preparation with electronic filing to qualified individuals.

My Education

Take a look at my formal education

Bachelor's degree, AccountingHunter College | 2020

About Me

Paul Kopyto

A data and accounting professional looking to excel and invest in new skills

Powered by

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