Uploaded File
James
jschwar@sbcglobal.net
jschwar@gmail.com
630-759-2513
Downers Grove, IL 60515
847-648-1320
Data Engineer
17 years experience W2
2
Recommendations
Average rating
157
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
Edit Skills
Non-cloudteam Skill
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