Information Technology Data Analyst

Vamsi

Krishna

Reddy

Bytinti

Education

+1-469-***-**** *******.*****@*****.*** www.linkedin.com/in/bytintivamsikrishna/

University of Texas at Dallas Aug. 2022 - May 2024

MS in Information Technology - Major in Data Science GPA: 3.71/4

Jawaharlal Nehru Technological University July. 2015 – June 2019

Bachelor of Technology Engineering GPA: 7.8/10

Technical Skills

Languages:R, Scala,Pandas, NumPy, Scikit-learn, Matplotlib, Python, Shell Scripting, VBA, SAS,Pyspark

Databases:MySQL, PostgreSQL, MongoDB, Redis, Snowflake,SAP HANA

Framework and Tools: Hadoop, HDFS, Hive, Sqoop, Databricks, Kafka, Apache Airflow, Azure Data Factory,NLTK, ETL

Cloud technologies: AWS(EMR,S3,EC2,RedShift,Kinesis), AZURE

Other Tools:Tableau, Power BI, SSRS, Spacy, Microsoft Excel(VLOOKUP,VBA,Pivot Table) Git, Agile, JIRA

Certifications: Generative AI Fundamentals, AZ-900, AWS Certified Developer Associate, Alteryx Core Certified

Experience

Shell May 2023 - Aug 2023

Data Engineer Dallas, USA

•Implementation of MSAL for authentication purpose so that authentication to Azure services from Databricks possible without interruptions like expiration of Secrets and keys.Transformed data using azure Databricks with help of Pyspark.

•Migrated the Storage accounts from V1 to V2, without any interruption in on going dataflow.

•Utilized Delta Live Tables to efficiently load data into corresponding Delta tables, ensuring automated management of data lineage and dependencies.

•Developed Databricks Delta tables for efficient data ingestion from multiple sources, implementing Medallion architecture principles to enhance data cleaning and transformation processes.

•Implemented row level security for few delta tables using Unity catalog in Azure Databricks.

Accenture June 2019 - Aug 2022

Senior Data Analyst Bengaluru, India

Utilized SSIS to develop ETL packages that validated, extracted, transformed, and loaded data into Data Warehouses and Data Marts.

Developed and maintained complex SQL queries, stored procedures, views, functions, and reports using Microsoft SQL Server to meet specific customer requirements.Worked with structured and unstructured data, built pipelines, and collaborated with data scientists to build statistical models.

Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized tables, established joins and created index.

Visualized data using Tableau for BI client presentations and demos which helped the Solution Center team to acquire 3 new clients.

Utilized HANA DB using SAP HANA Studio which resulted in maintaining an error-free system and resolving errors by the support team.

Collaboratively worked with business analysts to translate business insights into decisions and actions.

Data Analyst

Designed Tableau Dashboards for the Channel Rep Project to be utilized by the Marketing, Sales Teams, and the Executives for tracking and quick decision-making.

Conducted extensive data cleaning and preparation using Tableau Prep and visualized data related to various marketing strategies, sales pitches, and the progress of encountered opportunities, which improved the functioning of the departments.

Designed, developed, tested, and maintained Tableau functional reports, also wrote queries in Snowflake/Netezza based on user requirements.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.Capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.

Completed Ad-hoc requests by pulling data from Aginity(Netezza) and Snowflake prod and sub-prod Server

Project

Healthcare Chatbot System Python, NLTK, TensorFlow, Keras Feb 2024 - April 2024

Achieved a 25% reduction in patient wait times by delivering accurate and timely medical consultations via the chatbot.

Implemented and refined NLP algorithms to parse and interpret user inquiries, achieving a 30% enhancement in the chatbot’s diagnostic accuracy.

Integrated the chatbot with existing healthcare management systems to provide seamless access to medical records and patient data.

Regression Modelling for Prediction of Housing Sales R Studio, Tableau Aug 2023 – Dec 2023

Conducted data wrangling and exploratory analysis using R, with visual insights via Tableau.

Enhanced model accuracy through hyperparameter tuning of Elastic Net and Random Forest methods.

Finalized Random Forest model predicting housing sales with a MAPE of 14%.

Heart Disease Prediction System Python, scikit-learn, Numpy, Pandas Aug 2022 - Dec 2022

Developed a predictive model to diagnose heart disease using Logistic Regression, achieving an initial accuracy of 85%.

Enhanced model performance by implementing Neural Networks with TensorFlow, improving accuracy to 92%.

Explored feature importance and model interpretability using Decision Trees and Random Forest, leading to a robust model with improved precision for varying patient profiles.

Achievements and Activities

•Won ‘Accenture Celebrates Excellence’ award in 2021, which was awarded for only 2 among thousands of employees.

•Won the Title of Gender Champion of Gprec for 2017 for promoting gender equality and women upliftment.

Contact this candidate