Ashish Raturi
data Analyst Excel Automation VBA Power BI dashboard SQL Python EDA
Competenze
Consulta i miei servizi


Portfolio
Esperienza lavorativa
data Analyst
MetLife • Full time
Apr 2022 - Present • 4 yrs 3 mos
Automated repetitive Excel tasks using VBA Macros, reducing manual effort and saving time. Designed and developed interactive Power BI dashboards for Insurance Claim, Production data and HR Analysis Used DAX functions to build calculated columns and measures Transformed raw data using Power Query (ETL process) Performed Exploratory Data Analysis (EDA) using Python libraries like Pandas,Numpy,Matplotlib and Seaborn. Cleaned and preprocessed raw data by handling missing values and outliners Generated meaningful insights through data visualization and statistical analysis Worked with large datasets to identify trends and support business decision Achievements Developed VBA bases automated tools, reducing manual work by up to 50% Designed and managed relational databases for structured data analysis create complex joins, subqueries and aggregations for business insights Optimize SQL queries, improving data retrieval speed by up to 40%