Data Analyst C#

SAURAB GUPTA

Valparaiso, IN, ***** *********@*****.*** 219-***-****

EDUCATION

Valparaiso University Valparaiso, IN

Master of Science Information Technology Jan2021-May 2023

Softwarica College of IT & E-Commerce Kathmandu, Nepal

Bachelor of Science (Hons.) in Computing (Coventry) 2018-2021

WORK EXPERIENCE

Office of International, Valparaiso University Valparaiso, IN, USA . Intern Feb 2022 – July 2022

Performed comprehensive data file analysis, ensuring data integrity, accuracy, and compliance with quality standards

Removing duplicates, handling missing values, standardizing data formats, and resolving inconsistencies using Excel, Python.

Performing research at supervisor’s request and updating social media platforms and writing post, creating images for social media posts.

Designed flyers and updating students for upcoming helpful and interesting events.

Designed and updated Valparaiso University OIP page on website with WordPress.

Save Mountain Treks & Expedition Pvt. Ltd Kathmandu, Nepal

Data Scientist April 2021- Dec 2021

Developed predictive models to forecast sales trends, optimizing inventory management and reducing costs by 20%.

Implemented machine learning algorithms to analyze customer behavior patterns, resulting in a 15% increase in customer retention.

Collaborated with cross-functional teams to identify business requirements and deliver data-driven solutions.

Conducted exploratory data analysis to identify data trends, outliers, and insights.

Developed and executed data validation procedures to identify errors, anomalies, and inconsistencies in large datasets

Created automated scripts and macros using SQL and Excel to streamline data processing tasks

Softwarica College of IT & E-Commerce Kathmandu, Nepal

Data Analyst and Reporting March 2020- March 2021

Conducted complex data analysis and developed analytical models to assess the business impact of various initiatives within the revenue cycle.

Utilized SQL, Excel, and Tableau to extract, manipulate, and visualize data for reporting purposes.

Collaborated with leaders across multiple teams and external vendors/insurance companies to drive strategic improvements and facilitate change.

Led project initiatives, including creating project plans, managing resources, and delivering project updates to key stakeholders.

Contributed to the development of automated reporting tools to monitor key business drivers and identify areas for improvement.

Identified and implemented process improvements, resulting in increased efficiency and cost savings.

Cloud Factory Kathmandu, Nepal

Mid-level- Data Analyst Jan 2019- Feb 2020

Gathered and analyzed data from various sources to identify trends and patterns for business optimization.

Developed and maintained SQL queries and scripts for data extraction and manipulation.

Conducted statistical analysis on large datasets to derive actionable insights.

Collaborated with stakeholders to define data requirements and deliver reports and dashboards.

Assisted in the development of data-driven decision-making processes and strategies.

PROJECTS

Autism Spectrum Disorder Analysis (SQL, Python)

Performed Extract, Transform and Load operation for the autism spectrum disorder data frame.

Performed several manipulation and data transformation to process and classify the data through several neural network techniques like Naive Bayes, k Nearest Neighbor, Random Forest etc.

Built and trained deep learning network using TensorFlow, Kera’s package to predict the likelihood of autism diagnosis.

Performed final analysis of the data and visualized the given data using several machine learning and statistical packages.

Sentiment Analysis of Web Scraped Data (REST APIs, Python)

Built an ETL pipeline migrating data from API on specific parameters obtained from web scraping.

Transformed and merged the obtained json files converting them into pandas’ data frame to further process the data.

Performed NLP tokenization, and text mining operations to obtain sentiments based on the comments on the articles filtered through queries.

Worked with data visualization, machine learning and statistical packages to analyze the obtained results.

Gupta Sutra: Covert Communication using Image Steganography (Visual Studio, .Net, C#)

Designed and developed an image steganography project using .Net and C# using a Visual Studio.

Encrypted files (text, video, images, etc.) into image file using 16-Bit encryption model by modifying the pixel in binary level without visually altering the pixels in the picture.

Decrypted the encrypted information using the 16-Bit decryption model for secure communication.

Creating the data access layer, business logic layer classes using C# and .Net 4.0/4.

LEADERSHIP AND INVOLVEMENT

Kathmandu, Nepal

March 2019 – Sept 2021

Softwarica IT, Youth and Extracurriculars Club, Softwarica College of IT & E-Commerce

Vice-President

Set goals for the organization, which are result-oriented, clear, and attainable

Transformed the regular annual in-person events into socially distanced events and virtual seminars, arranging the dates, time, location, and transportation for organizational events

Trained- officers, board, and committee chairpersons and helped them understand their responsibilities

SKILLS

Languages/ Frameworks: SQL, Python, R, Excel, Tableau, Power BI, SAS, JavaScript, Java, C#, PHP, ETL, HTML/CSS, React, VBA, OLTP, OLAP or MPP

Tools/ Libs: GitHub, Anaconda, NumPy, Pandas, SciPy, Android Studio, SciKit, ETL, R, Jira, Oracle

Contact this candidate