Software Qulaity Analyst Intern

SIMRAN NAYAK

484-***-**** ************@*****.***

PROFILE

Detail-oriented Data Analyst with experience in transforming raw data into actionable insights. Proficient in data visualization tools and techniques, with a track record of driving informed decision-making and business growth. Skilled in analyzing large datasets and identifying opportunities for optimization. Passionate about leveraging analytical skills to extract meaningful insights and contribute to organizational success. Seeking a challenging role where I can apply my expertise to drive innovation and business results.

EDUCATION

M.S., Data Science & Analytics Grand Valley State University, Grand Rapids, MI Dec 2024 (Expected)

Coursework: Knowledge Discovery and Data Mining, Information Visualization, Machine Learning, Statistical Computing and Graphics with R, Statistical Programming, Statistical Modeling and Regression, Multivariate Data Analysis, Ethics and Professionalism in Applied Science, Health & Bioinformatics

Bachelor of Technology, Electronics & Communications Engineering National Institute of Science & Technology India Aug 2018

EXPERIENCE

SOFTWARE QUALITY ANALYST INTERN L SOFT CORP SEPTEMBER 2024 – DECEMBER 2024

● Extracting and analyzing source data through SQL queries using SQL Server Management Studio

● Performing data cleansing, deduplication, and preprocessing using Excel and Python

● Working with the business users to review the quality of the data and advising them on effective ways to keep clean data in the systems

● Working with Business Analysts and stakeholders to map source fields to target SAP-related fields needed for data migration and documenting the transformation rules in a Functional Mapping Document

ACADEMIC PROJECTS

Retail Sales Analysis and Forecasting:

● Analyzed retail sales data using Power BI, identifying trends and patterns while cleaning and preprocessing historical data for accuracy

● Engineered features to generate metrics for product performance and customer insights, building interactive dashboards for visualization

● Developed sales forecasting models to predict future sales and optimize inventory management

BOSTON CRIME ANALYSIS:

● Analyzed crime severity distribution in Boston City using R Studio and Tableau

● Designed and developed interactive Tableau dashboards to identify patterns and trends of crimes occurring

PERIODIC ANALYSIS OF MEDICAL DATA:

● Preprocessed the employee medical data and analyzed it using different classification techniques like decision trees, K-nearest neighbor, and Artificial Neural Networks and predicted if the employees have been affected by a specific virus based on various parameters/variables

NDVI PREDICTION IN SOUTHERN MICHIGAN AND NORTHERN INDIANA DRIFT PLAINS:

● Collected satellite data spanning 2014-2024, focusing on NDVI, drought index, humidity, and temperature

● Developed prediction models in Python using machine learning techniques using libraries and frameworks such as sci-kit-learn, TensorFlow, or Keras, incorporating environmental factors to forecast NDVI

HOUSE PRICE ESTIMATE:

● Performed exploratory data analysis (EDA) and creative feature engineering using Python and SAS on the Ames dataset to enhance predictive accuracy

● Developed and optimized machine learning models, including linear regression, random forest, and XGBoost, with hyperparameter tuning using Python

● Applied statistical techniques such as t-tests, regression, and ANOVA in SAS to validate models and improve predictions

SKILLS:

Technical Skills: R Programming, SAS, Python, SQL (MySQL), Tableau, MS Office, Power BI

Analytical Skills: T-test, ANOVA, MANOVA, Simple Linear & Multiple Linear Regression, Factor & Cluster Analysis, Data Mining, Predictive Modeling

CERTIFICATION

SAS Certified Associate: Programming Fundamentals Using SAS 9.4

Contact this candidate