Uploaded File
James
jschwar@sbcglobal.net
jschwar@gmail.com
630-759-2513
Downers Grove, IL 60515
847-648-1320
Data Engineer
15 years experience W2
2
Recommendations
Average rating
87
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
Data Engineer
Insurance
Aug 2013 - Jan 2020
Chicago, IL
  • Developed WBM (claims) consumption application using Pig, Hive, Zena, and Bash shell scripting using Scrum, Hadoop and ETL
  • Helped WBM team archive files in HDFS for the WBM project.
  • Wrote and executed DB2 queries against Bluechip claims.
  • Moved mainframe DB2 data from one environment to another for testing purposes.
  • Updated DB2 DAL programs to access DB2 Bluechip claims using XML functions
BaSH Data Engineering DB2 ETL Hadoop HDFS Hive Pig Scripting Scrum XML
Remove Skill
References
Average Rating

1 recommendation
Developer
Healthcare
Apr 2012 - May 2012
Naperville, IL
  • Wrote 5 SQL Server 2012 table-valued functions for a data mining project using ETL
  • Wrote 2 SQL Server stored procedures to import bill holding indicators into SQL Server 2012 using ETL.
  • Set up import of a new hospital into SQL Server 2012 using proprietary tools, Visual Fox Pro 8 and SQL Server 2012.
Data Mining ETL SQL SQL Server Stored Procedure
Remove Skill
Developer
Banking/Financial
Nov 2010 - Feb 2012
Chicago, IL
  • Supported Hyland Onbase 7.2.3 application using SQL Server 2005 and 2008, SQL, Citrix, Sharepoint
  • Learned, used and documented most of a 200-page document of workarounds to defects in production.
MS SharePoint SQL SQL Server
Remove Skill
Developer
Information Technology
Jan 2006 - May 2010

Enhanced and maintained marketing systems client/server application. Supported marketing systems and worked to reduce abends.

No skills were added
Remove Skill
References
Average Rating

0 recommendations
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
Hadoop
2020
14
Hive
2020
14
Pig
2020
14
XML
2020
14
DB2
2020
11
BaSH
2020
7
Big Data
2020
7
Data Engineering
2020
7
ETL
2020
7
HDFS
2020
7
Python
2020
7
Scripting
2020
7
Scrum
2020
7
Spark
2020
7
Systems Engineering
2010
4
MS SharePoint
2012
2
SQL
2012
2
SQL Server
2012
2
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
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
Stored Procedure
2012
1
UNIX
0
1
VBA
0
1
Windows
0
1