Peter Silon, CPA

**** ********** **.

Columbus, OH 43221

(h) 614-***-****

Email:

ad1dc7@r.postjobfree.com

Career Summary

Experienced Oracle SQL senior data analyst and also skilled IT Data Base Management Systems (DBMS) Department professional with some graduate school level education and who for over 5 years wrote query software programs, generated business requirements with users and has utilized data sets with more than 1 million transactions, Oracle SQL queries/reports, data validation, relational data bases, business intelligence, JavaScript, HTML quantitative and qualitative analysis, monitored metric performance, some visualization, ensured data integrity, ETL, several times identified cost savings of over $50,000, generated analytical general and statistical reports, debugged, tested, modified, documented systems with large data sets. Completed 3 college statistical classes including at the graduate level SAS. Experienced at financially identifying, data analyzing, ROI and streamlining more cost/benefit solutions as it applies to various departments. Utilized Oracle SQL queries with an employer, SAP, some cases Access, Excel VLOOKUPs and pivot tables for analysis of pharmaceutical products at Cardinal Health. Recorded Medicaid, Medicare, Molina, Aetna income and expense journal entries into accounting software’s. As a manager strategically, scheduled audits for over 6 different auditors. Google Data Analytics Certification.

Professional Experience

Peter has participated in a variety of IT software, finance and research assignments. They include but are not limited to:

Generated data bases with medical data that identified provider markup activities of sale and distribution by pharmacies of pharmaceutical drugs;

Written a variety of mainframe DBMS programs that generated original and modified normalized files for a claims system, some of the reports SQL oriented;

Based on thresholds and statistics, generated a data base that queried ‘red flag’ suspicious activities of providers;

Utilized data analysis to monitor, analyze and improve costs/effectiveness;

Generated SAP sales reports and statistics of fulfillment targets of pharmaceutical customers;

Performed data base data accuracy, data integrity, quality assurance testing and user acceptance testing;

PC inventory of equipment, software, passwords, password controls and changes;

Calculated ROI and statistics on fixed rate securities;

Electronic account setup, authorization, timeliness, appropriateness, accuracy of payment reviews;

Confirmation of expense disbursement and receipt of provider electronic payments plans;

Assisted with a Fraud Departments acquisition of workable data files from state agencies to match and identify suspicions financial activity and illustrate red flag activities in a variety of reports;

Improved a Provider Relations file backlog through a mainframe IT software routine to process 54,000 transactions in two computer weekend runs saving a huge number of man-hours when previously the department personnel processed 2,000 transactions annually.

In addition to these assignments, the 5 years of data base experience is with a normalized DB in a DB Department.

Education

Kent State University, Kent, OH

BBa Dual Major(s): Computer Science and also Accounting

One third thru Google Data Analytics Certification

Columbus State, Columbus, OH

Associates: Engineering

Data Analysis class: One-Sample t-test, two-sample t-test, chi-squared testing and correlation analysis

The Ohio State University, Columbus, OH

Graduate Public Health: Completed a graduate level class, SAS (i.e. Statistical Analysis System) 9.3 for Windows, Software Data Management and Analysis, a analytics, research and statistics class (PROC FREQ, PROC MEANS, PROC UNIVARIATE, histograms and PROC REG). Preparing for the SAS Base Certification Exam.

The Ohio State University, Columbus, OH

Certificate in Practice of Data Analytics (CPDA): Completed a class Foundation of Statistics class, enrolled and in the early chapters of a Data Mining class (Cross Industry Standard Process for Data Mining or CRISP-DM methodology).

Attended ITIL Foundations training 2013

Columbus State, Columbus, OH

IT Continuing Education Coursework:

Visual Basic.NET (i.e. ASP, DBMS), Statistics 1 & 2

C#.NET (i.e. OOP, GUI, LINQ)

Microsoft SQL Server, T-SQL, Python, MySQL

Adobe Dreamweaver CS3

Java, Data Mining and Warehousing, Decision Science

Oracle SQL, Excel

PHP/MySQL, HTML, Photoshop, Marketing, Cisco Networking

Access (i.e. also with VBA code)

Amazon Web Services (AWS) Academy – Completed the Academy Cloud Foundations (ACF) course which deals with cloud concepts, security, architecture, AWS core services, pricing and support.

This class was in part preparation for the AWS Certified Practitioner exam.

Employers

ESC of Central Ohio, Columbus, OH

Administrative/Technology/Special Reports/Media Center 2023-present

Department of Education, Columbus, OH

Sr. Data Analyst- SQL Oracle Development, Data Analysis, Special Reports 2022-2023

ESC of Central Ohio, Columbus, OH

Administrative/Technology/Special Reports/Media Center 2018-2022

JPMorgan Chase, Columbus, OH-(Hewlett Packard-UserReady) contractor

IT Desktop Support Technician – Troubleshooting VDI, laptop/deploy/IMAC/decom 2021

Franklin County Children Services, Columbus-contractor

Accountant-Fiscal, Purchasing, Payroll, A/P 2017-2018

ESC of Central Ohio, Columbus, OH

Administrative/Technology/Special Reports/Media Center 2016-2017

HWS CPA firm, Columbus, OH-contractor

Accountant – Public Accounting and Client Analysis and Research 2015

Cardinal Health, Dublin, OH-contractor

Senior Analyst, Financial Planning and Analysis – Finance GPO Specialty Solutions 2014

Analyst Consultant – Acute Care Pharmaceuticals, Data Analysis 2013-2014

JPMorgan Chase, Columbus, OH-contractor

Financial Analyst Consultant – Retail Financial Services SCRA Department (loans)

Loan Data Analysis 2011

Contact this candidate