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