Ram

Ram

Mumbai, IN • Joined Jul 2023

Followed by Kana Thakur


About

Organized and detail-oriented Data Analyst with proficiency and strong academic record in Mathematics, Statistics, Python, SQL, Tableau, and Excel. Hands on experience of creating 5+ major projects that included data modeling, data schema development, data scraping etc., independently and in collaboration. Thoroughly examined raw data for inconsistencies, missing values, duplicates, and formatting issues that may affect analysis. Resulted in the creation of a dynamic dashboard for effective data analysis and interpretation. Additional skills used - such as Power Query, data cleaning techniques, data validation, and advanced excel to resolve issues.

Work experience

2 years 10 months

Org Logo

Reliance Retail

10 month

Sales Associate

October 2021 - July 2022

Full-time

Utilized customer data to drive maximum sales, developed targeted KPIs for improved sales performance. Increased sales by 20% and retained 27+ customers through competitive pricing. Achieved monthly sales of 2.5 lakhs by effectively managing client relationships.

Org Logo

Mswipe Technologies Pvt

2 years

Customer Relationship Manager

August 2019 - July 2021

Full-time

- Successfully achieved the transaction target of 4 crore within a month, resulting in a substantial bonus of double salary - Demonstrated exceptional performance by increasing the transaction amount by 40% within a short timeframe - Successfully converted over 300 non-active users into active users, contributing to the growth and success of the company - Implemented effective strategies to improve key performance indicators (KPIs) and ensure maximum customer satisfaction - Utilized proactive approaches to optimize customer experience and enhance overall business performance.

Education

Org Logo

Masai School

2022 - 2023

Data Analytics

August 2022 - May 2023

- Attained comprehensive expertise in data analytics through intensive training at Masai School. - Cultivated proficiency in SQL, Python, Excel, Machine Learning, and Power BI to streamline data visualization. - Strengthened presentation, critical thinking, and creative thinking abilities, elevating soft skills throughout the program. - Accomplished over 10 projects with success, gaining valuable hands-on experience and showcasing proficiency in applying technical and soft skills.

Prahaladrai Dalmia Lions Collage Of Commerce and Economics

2016 - 2019

Bachelors of Commerce in Commerce

July 2016 - March 2019

In 2019, I successfully attained a degree in commerce, a transformative educational journey that equipped me with invaluable skills and knowledge. Throughout the curriculum, I actively engaged in an array of impactful courses that significantly enhanced my proficiency in various areas. By delving into the intricacies of economic functions, I gained a comprehensive understanding of the fundamental principles driving the financial landscape. This in-depth exploration allowed me to grasp the interplay between supply and demand, market trends, and the intricate mechanisms that drive economic growth. Simultaneously, my coursework in business communication honed my ability to effectively convey complex ideas and strategies. These skills not only empowered me to articulate my thoughts cogently but also equipped me with the capacity to engage with diverse stakeholders in a professional manner. A pivotal aspect of my education was centered around accounts and taxes, where I mastered the intricate processes involved in financial recording, analysis, and taxation. By actively participating in practical scenarios and case studies, I gained hands-on experience in managing financial transactions, reconciling accounts, and adhering to tax regulations. Furthermore, my profound comprehension of business law allowed me to navigate the legal landscape governing commerce seamlessly. This expertise safeguarded me against potential legal pitfalls and equipped me with the ability to make informed decisions while adhering to ethical guidelines. Lastly, my education in statistics amplified my analytical acumen, enabling me to extract meaningful insights from data and make informed business decisions. Through rigorous coursework and practical applications, I honed my ability to interpret statistical information, conduct hypothesis testing, and utilize statistical software proficiently. Overall, my educational endeavors in commerce have fostered a well-rounded skill set, encompassing economic functions, business communication, accounts, taxes, business law, and statistics. These comprehensive experiences have not only equipped me with the necessary knowledge for success in the field but have also nurtured a proactive mindset, enabling me to thrive in dynamic and challenging environments.

Projects

Superstore Sales Analysis

May 2023 - Jun 2023

Masai School

- Extracted and cleaned data from diverse sources, including Kaggle, to ensure its suitability for analysis - Employed Python, Pandas, SQL, and Power BI to process and prepare data for examination - Developed an interactive and dynamic dashboard to showcase significant insights derived from the data - Utilized a dataset obtained from Kaggle.com to fulfill project requirements

E-Commerce Sales Analysis

May 2023 - May 2023

Masai School

- Extracted required data from a big data set, ensuring relevant and accurate information was obtained for analysis - Implemented data cleaning processes to transform raw data into a well-structured and analyzable format - Utilized Power Query, data cleaning techniques, data validation, and advanced Excel functions to resolve any data discrepancies or issues - Developed a dynamic dashboard with key performance indicators (KPIs) to visually track and monitor project progress - Demonstrated proficiency in data manipulation and analysis skills, specifically in the areas of data extraction, cleaning, and visualization

HR Analysis

May 2023 - May 2023

Masai School

- Identified the business problem to focus analysis and ensure collection of relevant data - Collected data on employee performance, satisfaction, turnover, etc. from various sources - Cleaned data by removing errors, inconsistencies, null values, outliers, and duplicate entries - Analyzed data using statistical methods like regression analysis, clustering, and hypothesis testing to identify trends and patterns - Created a dashboard to provide insights into employee performance and satisfaction, tracking progress and identifying areas for improvement - Communicated results to stakeholders through presentations, reports, and infographics - Utilized skills in SQL, Excel, handling null and noise, and pivot tables.

Awards & achievements

Reliance Retail

Destroyer

Nov 2021

Mswipe Technologies Pvt

Employees of the month

Oct 2019