Aditya Aduri

Data Engineer @Blue Cross Blue Shield of Michigan

Analyzed SQL scripts and designed solutions using Pandas and PySpark.• Built web pages using HTML, CSS, JavaScript, and jQuery for QC reports on data.• Developed a Python package to connect to Teradata from Spark and generate QC reports.• Developed a web application using Python.• Analyzed and resolved data load issues by collaborating with business and technical teams.• Established new connections to databases such as Snowflake, Redshift, and Teradata from Spark and Python.• Rewrote legacy Teradata SQL queries to Amazon Snowflake as part of a database migration.• Analyzed requirements in business meetings and assessed the impact of requirements on different applications.• Analyzed, designed, and migrated systems using Python, Spark, and cloud infrastructure, particularly Amazon Web Services (AWS), to ensure long-term supportability and sustainability.• Designed and implemented rules for processing workflows based on new or updated business requirements using the latest versions of Python and Spark frameworks.• Participated in business requirements, data analysis, and system design meetings.• Extracted data from multiple sources, integrated it into a common data model, and loaded it into a target database, application, or file using efficient programming processes.• Designed and developed a data management system using SQL and optimized database queries for improved performance.• Added support for hosting static/media files and the database in Amazon AWS S3 and RDS (Relational Database Service).• Developed both frontend and backend modules using Python and a framework.