Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

ROHITH KEESARA

Tampa,FL

Summary

IT Professional with 13+ years of overall experience in Design, Development, Testing and Automation of ETL applications of different scales. 8+ years of experience on Health care domain claims, provider, and membership data to generate regulatory and Compliance reports and IBNR analytical reports. Expertise in Python, SAS, R and SQL programming languages. Experienced in working with various Python Packages such as Pandas, NumPy, PySpark, matplotlib, Scikit-learn etc. Extensively worked on various source systems like Oracle, SQL Server, Tera data, Greenplum, AWS S3, AWS RDS, Apache Spark and experienced in Snowflake, GCP, Big Query, AWS Glue and RedShift. Designed and developed ETL Integration patterns using Python on Spark and Python on Snowflake. Worked and coordinated on Agile development models.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr. Data Engineer

Centene Corporation
Tampa, FL
05.2020 - Current
  • IBNR (Incurred but not reported) is an application that helps the organization maintain reserves
  • This project involves different deliverables such as analytical reports and data staging and loading
  • Analytical reports involve historical quantitative Membership, claim adjustments, providers, and authorizations data to produce the dollar summaries or projections needed for the reserve account.

Sr. Data Engineer

WellCare Health Plans
Tampa, FL
12.2015 - 04.2020
  • All Payers All claims (APAC) is a SAS based regulatory/compliance reporting application to 20+ different states across the USA
  • Each state requires that every insurance payer to submit the data occurred for a certain time period and the data submission follows each individual state guidelines
  • All data submissions include monthly/Weekly/Quarterly reporting on different subject areas such as Membership, Pharmacy and Medical claims
  • This project also involves developing different macros to track the increase/decrease thresholds of all the elements in the reports to maintain the consistency and report internally for data governance projects.

Business Analyst

PerfexionIT Technologies
Hyderabad, India
03.2011 - 05.2014
  • PerfexionIT is an organization that offers end to end solutions including SAS based sales, expenditure reports or projections and marketing campaigning to individual businesses

Education

Bachelor of Technology -

Kakatiya University

Masters -

University of Central Missouri

Skills

  • PyCharm, Jupyter, SAS EG, R Studio, Apache Airflow, PowerBI, SAS DI studio
  • Oracle, SQL Server, GCP, Greenplum, AWS S3, AWS RDS, Apache Spark and Snowflake
  • Python, SAS, SQL, R, PL SQL, Shell scripting

Certification

  • SAS Certified Professional: Advanced Programming, DPD901B12MBEQ4KB
  • Data Analysis with Python, AVR2WKD6KTQQ
  • Snowflake Data Warehousing, 99421244
  • Python for Data Science, AI & Development, 9SUWXG45CF4C
  • SAS Certified Specialist: Base Programming Using SAS 9.4, XDG75RV2CNV11VC7
  • Data Visualization with Python, C4H7UYQXXUL6

Timeline

Sr. Data Engineer

Centene Corporation
05.2020 - Current

Sr. Data Engineer

WellCare Health Plans
12.2015 - 04.2020

Business Analyst

PerfexionIT Technologies
03.2011 - 05.2014

Bachelor of Technology -

Kakatiya University

Masters -

University of Central Missouri

Similar Profiles

CREATE PROFILE
ROHITH KEESARA