eric krausz

eric krausz

Mentor
Rising Codementor
US$8.00
For every 15 mins
free badge
First 15 mins free for your first session
ABOUT ME
C# and SQL developer over 25 years experience
C# and SQL developer over 25 years experience

I want to spend my time mentoring, coding, modeling, and optimizing. I want task-based work. I will work remote only with minimal meetings. No full time. No permanent.

English
Eastern Time (US & Canada) (-05:00)
Joined January 2024
EXPERTISE
10 years experience
Modeled large scale databases in insurance and health care.
Modeled large scale databases in insurance and health care.
15 years experience
15 years experience
Data manipulation. File manipulation. SQL CLR.
Data manipulation. File manipulation. SQL CLR.
10 years experience
Modeled large scale databases in insurance and health care.
Modeled large scale databases in insurance and health care.
15 years experience
Highly advanced queries, SSIS, query optimization, data structures, database design, database optimization
Highly advanced queries, SSIS, query optimization, data structures, database design, database optimization
15 years experience
Complex queries. Query optimization.
Complex queries. Query optimization.
15 years experience

REVIEWS FROM CLIENTS

eric's profile has been carefully vetted and approved as a Codementor. Connect with eric now, and leave a review for them once you're done!
EMPLOYMENTS
Senior Integration Analyst
Avalon Healthcare Solutions
2020-07-01-2022-01-01

Avalon Health Care Solutions, Tampa, FL
Responsible for integrating flat file data (health care data including claims, enrollment,...

Avalon Health Care Solutions, Tampa, FL
Responsible for integrating flat file data (health care data including claims, enrollment, provider) into to various systems using SSIS. Used C# for special processing in SSIS. Ensure data quality and integrity. Design processes and model data objects (tables, stored procedures, triggers, views, indexes) to incorporate new data. Work closely with application development to ensure proper database usage for online prior authorization and claim editing software. Implemented claim editing and other business rules in SQL Server. Miscellaneous production support, query optimization, and ad hoc reports. Follow strict agile software development methodology.

SSIS
Microsoft SQL Server
.NET
View more
SSIS
Microsoft SQL Server
.NET
View more
Senior Developer
Community Health Network of CT
2014-03-01-2020-05-01

Developed and maintained database applications for managing Medicaid data for the State of Connecticut in a SQL Server environment. Da...

Developed and maintained database applications for managing Medicaid data for the State of Connecticut in a SQL Server environment. Data included claims, physician directory, insurance coverage, diagnosis codes, laboratory results data, and drug data (NDC). Implemented complex business rules using T-SQL. Designed an entire data warehouse for query performance optimization. Extensive work in ETL (extract, transform, load), database design, query optimization, data validation, reporting, data extracts, and data cleansing for large scale databases (i.e. tables with over a billion rows). Used SSIS and C# to load data into very large tables. Used GIT for source control in a continuous delivery/continuous integration environment. Exposure to Rabbit MQ and Mongo DB. Wrote a variety of utilities in C# to support application monitoring and ETL operations. Worked on API’s in ASP.NET.

MongoDB
SSIS
T-SQL
View more
MongoDB
SSIS
T-SQL
.NET
Data modeling
ASP.NET
View more
Systems/Data Analyst
AIX Group
2013-12-01-2014-02-01

Worked with Coverall database (both MIC and data warehouse) for data validation and report writing. Wrote parameterized Reporting Serv...

Worked with Coverall database (both MIC and data warehouse) for data validation and report writing. Wrote parameterized Reporting Services queries using SQL Server 2012. Deployed a SQL CLR routine to enable use of regular expressions in the database. Wrote a .NET multi-threaded console application for BI cube cache warming. Performed root cause analysis of data anomalies. Performance tuning for SQL queries. Wrote balancing reports. Involved in data cleansing. Wrote SQL user defined functions for data extraction.

T-SQL
SSRS
.NET
View more
T-SQL
SSRS
.NET
View more