Sravanthi Gudapati

Sravanthi Gudapati

Data Engineer
United States of America

نبذة عني

Over 4+ Years of professional experience working as Data Engineer, Data Analyst and Quality Assurance Engineer. Performed data analysis on healthcare for Medicare, Medicaid, and Commercial lines of business writing compl…

الخبرة

Data Engineer

Verizon Wireless Systems
Jul 2022 - حتى الآن · 4 سنوات

 Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in
documenting the business requirements.
 Worked with Hadoop architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task
Tracker, and Resource Manager.
 Used AWS data pipeline for Data Extraction, Transformation and Loading from homogeneous or heterogeneous data
sources and built various graphs for business decision-making using Python matplot library
 Developed scripts to load data to hive from HDFS and involved in ingesting data into Data Warehouse using various data
loading techniques.
 Build Cassandra queries for performing various CRUD operations like create, update, read and delete, also used
Bootstrap as a mechanism to manage and organize the html page layout
 Developed entire frontend and backend modules using Python onDjango Web Framework and created User Interface (UI)
using JavaScript, bootstrap, Cassandra with MySQL and HTML5/CSS
 Analyzed SQL scripts and designed the solutions to implement using PySpark.
 Used SparkSQL to load JSON data and create Schema RDDand loaded it into Hive Tables and handled structured data
using SparkSQL.
 Added supportfor Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
 Worked in development of applications especially in LINUX environment and familiar with all its commands and worked on
Jenkins continuous integration tool for deployment of project and deployed the project into Jenkins using GIT version
control system.

Data Engineer

Verizon Wireless Systems
Jul 2022 - حتى الآن · 4 سنوات

Developed a data platform from scratch.
Took part in requirement gathering and analysis phase of the project.
Documented the business requirements.
Worked with Hadoop architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task Tracker, and Resource Manager.
Used AWS data pipeline for data extraction, transformation and loading from homogeneous or heterogeneous data sources.
Built various graphs for business decision-making using Python matplot library.
Developed scripts to load data to Hive from HDFS.
Involved in ingesting data into Data Warehouse using various data loading techniques.
Built Cassandra queries for performing CRUD operations like create, update, read and delete.
Used Bootstrap as a mechanism to manage and organize the HTML page layout.
Developed entire frontend and backend modules using Python on Django Web Framework.
Created User Interface (UI) using JavaScript, Bootstrap, Cassandra with MySQL and HTML5/CSS.
Analyzed SQL scripts and designed the solutions to implement using PySpark.
Used SparkSQL to load JSON data and create Schema RDD and loaded it into Hive Tables.
Handled structured data using SparkSQL.
Added support for Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
Worked in development of applications especially in Linux environment.
Familiar with Linux commands.
Worked on Jenkins continuous integration tool for deployment of project.
Deployed the project into Jenkins using GIT version control system.

Data Engineer

Sundaram Finance
Sep 2019 - May 2022 · 2 سنوات 8 أشهر

Worked directly with research groups to understand their initiatives and programs in healthcare domain.
Helped in providing the data from different sources using ETL tools.
Performed end to end data analysis using SQL queries to provide quality data for research.
Made the data available on BigQuery performing ELT process to move the data from Google Cloud Storage (GCS) bucket to BigQuery tables.
Built designing and architecting solutions in Google Cloud Platform involving huge claims data mart of Medicare and commercial population to effectively execute the queries in BigQuery.
Wrote complex Big Queries on Google Cloud Platform involving joins, user-defined functions (UDF), and jobs to help the reporting team in sending reports to higher management involving bonus, HSA incentive and comparing daily step activities across UHG population.
Extracted data from Salesforce database for research and process improvement on fitness program initiatives.
Developed automation batch framework to execute stored procedure without manual intervention and generate success report after ETL completion.
Performed SQL tuning to retrieve data from large datasets joining multiple tables.
Used query optimization techniques.
Worked closely with clients from gathering requirements and priorities deliverables.
Scheduled s for clients on new software releases and changes on the file layouts.
Coded Oracle PL/SQL stored procedures, packages, and database triggers.

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) Windows Mac OS Linux Ubuntu Python C++ HTML HTML5 CSS CSS3 XML jQuery JSON Bootstrap Angular JS NumPy SciPy PySide PyTables Pandas Matplotlib Py Query Supervised Learning Linear Regression Logistic Regression Decision Tree Statistical Analysis A/B Testing Time Series Analysis Random Forest SVM Classification Unsupervised Learning Clustering KNN Factor Analysis PCA Natural Language Processing Google Analytics Fiddler Tableau Azure OpenStack Amazon EC2 Amazon S3 Amazon Simple DB Amazon ECS Amazon Lambda Amazon RDS
الإبلاغ عن هذا الملف الشخصي؟