Yashwanth Mamidi
Senior Data Analyst @OneMagnify
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Analyst @OneMagnify
Experienced in designing, building and optimizing Alteryx workflows to solve complex data problems.• Expertise in using Alteryx tools such as Input data, Formula, Filer, Join, Output data to manipulate and analyze data.• Ability to troubleshoot and debug Alteryx workflows to analyze huge datasets and create weekly recurring reports for business stakeholders.• Identifying data quality/data load issues and working with appropriate teams to resolve them.• Developed data visualization and presentation materials (PPTs) to communicate insights and recommendations to non-technical stakeholders.• Experienced in writing complex SQL queries to extract huge datasets and optimize them for better performance.• Performed complex joins on tables in Hive and proficient in SQL syntax with various optimization techniques.• Good working knowledge with Google Cloud Platform tools such as BigQuery and Cloud SQL.• Experience with python libraries such as Pandas, NumPy, Matplotlib, seaborn, PyCaret, and Scikit-learn for data manipulation, analysis and visualization.• Strong understanding of statistical concepts such as hypothesis testing, regression analysis, and time series analysis.• Ability to clean and preprocess data using techniques such as data imputation, normalization, and feature engineering.• Ability to work with big data technologies such as Hadoop, Spark, and Hive to process and analyze large datasets.• Involved in discussions to gather source information for different source systems.• Ability to collaborate with cross-functional teams including data scientists, business analysts, and data engineers.• Experienced with data warehousing concepts and technologies such as ETL and data modeling.• Knowledge of using data visualization tools such as Tableau, Qliksense.• Experienced in analyzing huge datasets to identify patterns, relationships, and anomalies in the data. Performed multiple ML models to check the trends.
EDUCATION
GITAM Deemed University
Bachelor's degree, Electrical, Electronics and Communications Engineering
University of New Orleans
Master's degree, Computer Science
ABOUT YASHWANTH MAMIDI
Experienced in Data Analysis, Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications and acquired excellent analytical, coordination, and interpersonal skills for leadership. • Understanding of project life cycle and (SDLC) methodologies including Waterfall and Agile. • Industry analytics experience using statistical analysis and predictive modeling. • Well-Versed in using various packages in R and python-like NumPy, Pandas, Matplotlib, SciPy, and ggplot2. • Proficient in Text Analytics, generating data visualizations using R, and Python, and creating dashboards using tools like Tableau. • Well-Versed in data mining and machine learning with Python including Linear Regression, Logistic Regression, SVM, Decision Tree, Random Forest, PCA and K-NN. • Experienced working with Excel Pivot and VBA Macros for various business scenarios. • Excellent verbal and communication skills, ability to communicate technical topics to non-technical individuals. • Strong experience in business and Data analysis, Data profiling, Data Migration, Data conversion, Data quality, Data integration and metadata management services and configuration management. • Demonstrated strong analytical skills and problem-solving skills with superior attention to detail. • Excellent knowledge of Machine Learning, Mathematical Modelling and Operations Research, Comfortable with Python, R, SAS and Weka, MATLAB, and Relational Databases. • Knowledge of Familiar with Data Cleaning, Data Wrangling, and Critical Thinking to examine the existing database and remove inaccurate records from the tables. • Excellent experience in analysis huge volumes of data in industries such as Finance, Healthcare, and retail. • Competent in loading data from multiple data sources into Excel Reports using VBA. • Extensive experience in preparation of reports, tables, listings, and graphs. • Very solid data analysis skills including application of analytical techniques such as statistical and machine learning. • Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau. • Knowledge of creating modules with Excel VBA in different environments. • Ability to manage own time and work effectively with others on multiple projects. • Little experience on adding surface information and geostatistical analysis on ArcMap. • Solid understanding and proficient use of various SAS procedures.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.