James
jschwar@sbcglobal.net
jschwar@gmail.com
630-759-2513
Downers Grove, IL 60515
847-648-1320
Data Engineer
19 years experience W2
2
Recommendations
Average rating
225
Profile views
Summary

  • A Big Data Engineer with a wide range of experience working in Data Analytics, Big Data and Business intelligence in Healthcare, Insurance and financial industries.
  • 4 years of experience in Hadoop, Pig, Hive and Python
  • 8 years in ETL and Data Warehousing with SSIS, Zena, Bash shell scripting and 1 year in Spark, pyspark and Kafka.
  • Highly proficient in MySQL, DB2 Worked in Unix, Windows and mainframe environments.
  • Accustomed to working in an Agile environment.

KEY ACCOMPLISHMENTS

  • Developed WBM 2.0 (claims) using Pig, Hive, Python, Zena and Bash shell scripting, Hadoop, and Scrum. Helped load three years or 720,000,000 BCBS claims.

  • Developed PMAR using Spark/pyspark (python), Kafka, Bash shell scripting, Hadoop, and Scrum. Real-time/Batch Ingestion and Processing pipelines built using Apache Spark

  • Used Python for pyspark and other uses (formatting json, xml files, etc) for 3 to 4 years.

  • Developed Nice consumption application using Pig, Hive, Python, Zena, Bash shell scripting, ETL, Hadoop and Scrum

  • Developed Nice application that generated python scripts from hive data, using these scripts in the consumption transformation in Pig using Bash shell Scripting and scrum.

  • Designed and led a two-person team that ran a Pig consumption process to store two years or 480,000,000 BCBS claims for the WBM 1.0 project using Bash shell scripting and ETL, Pig and Hive.

  • Coached and Mentored two people on the WBM project using agile methodology

  • Developing and coached one person for the PMAR application using pyspark, Kafka.

  • Acted as SME on NICE and WBM ETL projects using Python.

  • Saved $4.5 million in one quarter on gross margin by serving as team subject matter expert assisting the business and technical staff to price point merchandise.

Experience
Education
Bachelor's in Science, Math and Computer Science
University of Illinois
Associate's in Science
Wisconsin Lutheran College
Skills
Shell Scripts
2020
7
Big Data
2020
1
Python
2020
1
Spark
2020
1
BaSH
2020
6
Business Intelligence
2020
6
Data Engineering
2020
6
DB2
2020
6
ETL
2020
6
Hadoop
2020
6
HDFS
2020
6
Hive
2020
6
Pig
2020
6
Scripting
2020
6
Scrum
2020
6
XML
2020
6
Systems Engineering
2010
1
MS SharePoint
2012
1
SQL
2012
1
SQL Server
2012
1
Agile Methodology
0
1
Analysis
0
1
Apache
0
1
Business Analysis
0
1
Data Mining
2012
1
Data Warehousing
0
1
Enterprise Architecture
0
1
Git
0
1
HTML
0
1
IBM Mainframe
0
1
in-memory databases
0
1
Jenkins
0
1
JIRA
0
1
JSON
0
1
Kafka
0
1
Linux
0
1
Microsoft SMS Server
0
1
mSQL
0
1
MySQL
0
1
Pipeline
0
1
Problem Solving
0
1
Process Improvement
0
1
Project Management
0
1
PySpark
0
1
Requirement Analysis
0
1
SCOBOL
0
1
SDLC
0
1
SSIS
0
1
Stored Procedure
2012
1
UNIX
0
1
VBA
0
1
Windows
0
1