Charles Dzacka Data Engineer

Jobs 0% verified

I

Lead Data Engineer

Illumifin Corporation

Jun 2022 - Current (4 years 2 months)
Senior Data Engineer

Blue Health Intelligence

Jun 2020 - Aug 2022 (2 years 3 months)
C

Lead Data Scientist/BI Architect

Center for Medicare and Medicaid Services

Mar 2015 - Jun 2020 (5 years 4 months)
Data Analyst II / BI Developer

CareFirst BlueCross BlueShield

• Pulled data from Facets and Nasco claims systems to create operational reports for applications • Created ad hoc queries, stored procedures, and programming scripts with SQL • Utilized SISS for ETL data modeling, data migration, integration, and analysis • Prepared high level analysis reports with SSRS, Cognos and Excel • Supported data profiling activities • Created Business Objects and SSRS reports for monthly inventory analysis • Supported logical data designs/models by reviewing with Business stewards • Worked with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from Carefirst data warehouse and generating day-to-day reports in support of the Actuarial Finance departm
C

Data Analyst/ETL Developer/ Subject

Commonwealth of Massachusetts | CHIA

• Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data. • Performed daily integration and ETL tasks by extracting, transforming and loading data to and from diferent SQL Server databases. • Utilized SISS for ETL data modeling, data migration, and analysis. • Prepared high level analysis reports with Excel. • Provided detailed data analysis in SAS to aggregate and compare the currency fields. • Provided feedback on the quality of data including identification of billing patterns and outliers. • Analyzed and assessed invalid and missing data in the All Payer Claims Data. • Imported Data from SQL Server into SAS files per detailed specifications. • Identified and document limitation

Education 0% verified

Charles Dzacka

About

Detail

Timeline

Résumé