Vamsi Krishna
Omaha,NE
Summary
Data Analyst with 4+ years of experience in Data Analysis, Machine Learning, Data mining with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive Modeling, Data Visualization Proficiently utilize Python and R packages, including NumPy, Pandas, Matplotlib, SciPy, Seaborn, PyTorch, TensorFlow, Scikit-learn, Keras, and ggplot2 for data analysis and visualization. Apply practical expertise in data modeling, encompassing concepts like Star-Schema Modeling, Snowflake Schema Modeling, and the creation of Fact and Dimension tables. Demonstrate the ability to perform Text Analytics, craft data visualizations in Python, and construct interactive dashboards using tools such as Tableau, Power BI, and MS Excel. Possess extensive knowledge and hands-on experience in optimizing processes, implementing normalization and de-normalization, conducting data extraction, executing data cleansing, and proficiently manipulating data.
Overview
6
6
years of professional experience
Work History
Data Analyst
Eastern Nebraska Human Services Agency - Duet
NE
11.2023 - Current
- Employ NumPy, Pandas, Matplotlib, Scikit-Learn, and TensorFlow in Python to perform data cleaning, feature scaling, and feature engineering
- Optimize and automate data cleansing, extraction, and analysis processes, resulting in a 40% reduction in data processing time and improved data accuracy
- Collaborate with business stakeholders to analyze data requirements and implement a scalable data model, leading to a 30% increase in data processing efficiency, supporting the company's rapid growth
- Utilize AWS Cloud platform components, including EC2, VPC, RDS, EBS, S3, CloudWatch, CloudTrail, CloudFormation, and Autoscaling to manage and process data effectively
- Designing SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model
- Creating action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau
- Employ SQL and Excel for data cleaning and data preparation, including the slicing and dicing of data to achieve project objectives.
Data Analyst
My Classboard
Hyd
08.2018 - 12.2021
- Formulated SQL Queries to extract complex data from various remote databases through proficient utilization of joins, database links, and Bulk collects
- Monitored the performance of the Snowflake platform and implemented performance tuning strategies, optimizing SQL queries and troubleshooting performance issues, resulting in a 30% improvement in query performance and enhanced user experience
- Performed Data Analysis on the analytical data present in AWS S3, Redshift, Snowflake, and Teradata using SQL, Python, and Databricks
- Leveraged the ggplot2 library in R for data analysis, creating data visualizations that provided valuable insights into customer behaviors
- Utilized Power BI to craft a range of analytical dashboards that swiftly delivered crucial data insights to business users
- Engineered and automated data pipelines to extract and transform customer data, resulting in a 50% reduction in data processing time and an 18% enhancement in data accuracy
- Conducted data profiling and validation to ensure data accuracy between the warehouse and source systems
- Addressed data issues, including missing values, outliers, and discrepancies, effectively resolving them by 95%
- Implemented an ETL process in Alteryx, enabling data extraction from diverse sources (SQL Server, XML, Excel, CSV) and the scheduling of workflows for efficient data management.
Education
Masters in Computer Science -
University of Missouri
05.2023
Bachelor in Computer Science -
Sathyabama Institute of Science and Technology
05.2021
Skills
- Data Modeling
- Data Validation
- Data Warehousing
- Report Writing
- Database Maintenance
- Statistical Analysis
- NoSQL Databases
- Business Needs Analysis
- Data Analysis
- Python Programming
- Machine Learning
- Tableau
- Reporting Tools
- Git
- Software Development Life Cycle (SDLC)
- Database Management
- Data quality
- Data Mapping
- UNIX System
- Data Exports
- SQL
- Product Development
- Data Mining
- Microsoft Visio
- Data screening
- Data Visualization and Presentations
- Excel Functions
- R Programming
- Tableau Software
Personal Information
Title: DATA ANALYST
Projects
Movie Recommendation System Using Movie Lens 20M Dataset
Timeline
Data Analyst
Eastern Nebraska Human Services Agency - Duet
11.2023 - Current
Data Analyst
My Classboard
08.2018 - 12.2021
Masters in Computer Science -
University of Missouri
Bachelor in Computer Science -
Sathyabama Institute of Science and Technology
Similar Profiles
Charriyah PhillipsCharriyah Phillips
Volunteer at Eastern Carolina Human Services Agency Inc.Volunteer at Eastern Carolina Human Services Agency Inc.
Alexandra RistowAlexandra Ristow
Child & Family Services Specialist at Nebraska Department of Health and Human ServicesChild & Family Services Specialist at Nebraska Department of Health and Human Services
DAWN MALYDAWN MALY
DSP at DUETDSP at DUET
Tyson SummersTyson Summers
Operations Manager at Worley Investments LLCOperations Manager at Worley Investments LLC
Daniel UtterDaniel Utter
Assistant Program Director at CEDARS Youth ServicesAssistant Program Director at CEDARS Youth Services