Data Analyst Developer

Saurav Nandi

*******@****.**.*** https://www.linkedin.com/in/sauravnandi0908/ 312-***-****

EDUCATION

The University of Cincinnati, Carl H. Lindner College of Business Cincinnati, Ohio

Master of Science in Information Systems Expected: December 2023

Relevant Coursework: Database Management, Statistical Computing with Python, Data Mining, Data Wrangling, Data Visualization using Tableau, Python for Data Analysis, Linear Regression, Probability

Narsee Monjee Institute of Management Studies – NMIMS Mumbai, India

Bachelors in Computer Science and Engineering with a minor in Data Warehousing June 2018

TECHNOLOGY SKILLS

Programming Languages and Tools: Python (Pandas, NumPy), PowerBI, MS Excel, MS PowerPoint, MS Word, R

Analytical Skills: Data Cleaning, Data Visualization, Hypothesis Testing, Exploratory Data Analysis

Database: MYSQL, PostgreSQL, Microsoft SQL Server Management Studio, Teradata

PROFESSIONAL EXPERIENCE

Diginfosoft Pvt Limited Mumbai, India

Data Analyst November 2021 – July 2022

Cleaned and analyzed 800K records using SQL to identify unstructured datasets and normalize them structurally; helping the client categorize inconsistent data to reduce cost for scale by ~2%.

Deployed complex SQL queries using complex CTEs to identify, track, and resolve Data Quality issues to maintain data governance and automated the data cleaning process, which increased the Data Quality by 20%.

Extracted KPIs from existing tools using complex SQL queries and models, to identify high-performing datasets with fewer data quality issues and displayed insights using Tableau which helped in boosting site performance by 40%

Accenture Mumbai, India

Application Developer Analyst June 2018 – October 2020

Worked on project UK royal mail, and learned about the application of Extraction of data from source to Teradata using Unix and DataStage tools respectively.

Developed the prepare-unload stage project of the project, where the responsibility was to join different datasets to gain valuable insights and businesses that solve the business needs of my client using SQL queries and models respectively.

Worked on developing the Enterprise Data Warehouse Tables, called Teradata, which can be queried using SQL and this helped my clients in improving their sales by 20%

Presented reports to clients regarding their business with the help of Tableau which improved their premium pricing by 12%

Developed different job schedules to automate the extraction of data from source to Teradata using DataStage which optimized the file ingestion process by 25%

Improved BTEQ scripts consisting of triggers that have helped in the speed of transfer of files from ODBC data source towards Teradata by 65%

ACADEMIC PROJECTS Saurav Nandi portfolio projects (sauravnandi0908.github.io)

Brand preference for most market share product categories R (October 2022)– Developed a product category analysis whereby R language and concepts of plotting were utilized to provide analysis results regarding how to improve the sales of Private Brands as opposed to National Brands.

Brand preference for meat product categories in different seasons Python (November 2022) – Developed a graphical representation of different meat product categories for different months to find sales and discounts and assess which meat products should improve their sales in different seasons respectively.

Sales analysis using MySQL and Powerbi (February 2023) - Created a sales report using Powerbi and MySQL in order to find the analysis of sales of different products, to which customers across different regions of United States Of America.

Contact this candidate