Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pranesh Chitrakar

Queens

Summary

Dynamic sales assistant with proven expertise in sales analysis and inventory management at Produce Experience. Adept at fostering customer relationships and generating leads, I effectively utilized data visualization to drive informed decision-making. Recognized for optimizing stock levels and enhancing sales performance through strategic reporting and collaboration.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Sales Assistant

Produce Experience
The Bronx
04.2024 - Current
  • Maintained and analyzed sales master lists to track key performance indicators (KPIs), such as frequent order patterns, identifying and resolving missing order issues, and calculating total revenue generated.
  • Developed and presented weekly sales analysis reports to the Sales Director and sales representatives, tracking KPIs, and identifying sales trends.
  • Utilized the inventory management system to track incoming shipments and monitor stock levels, proactively identifying sold-out items to minimize backorders, and optimize product availability.
  • Utilized email, text messaging, and phone calls to maintain consistent communication with clients regarding past orders, order tracking, and upcoming deliveries, fostering strong customer relationships. Traveled to various states to attend industry shows and engage with potential clients, generating new business leads.
  • Traveled to various states to attend industry shows and engage with potential clients, generating new business leads.

Big Data Technology Project

CUNY Baruch College
Manhattan
08.2022 - 12.2022
  • Design, develop, and optimize Spark applications for efficient and scalable data processing, including data transformation, aggregation, and machine learning models.
  • Collaborate with cross-functional teams to identify and implement solutions for data processing and analytics needs.
  • This includes designing and implementing data models, working with big data technologies such as Spark and Hadoop, and optimizing the performance and scalability of Spark applications.
  • Develop and maintain distributed data processing pipelines using Apache Spark, including data ingestion, processing, and storage.
  • Collaborated as a Data Analyst to understand the business value of the data, and worked towards making that data available in Tableau.
  • Designed and created a pipeline using Python to transform and persist data in Parquet format, and enable Hive.
  • Performed data transformation with file formats like Parquet and text.
  • Worked on managing EMR clusters that ran controllers with different queries by updating master and core nodes to run optimally and reduce the runtime.
  • Created IAM role and policy and enabled access to multiple S3 buckets
  • Worked on adding IAM roles and adding the roles to the s3 bucket to access buckets across different LOBs

Data Warehousing and ETL Project

CUNY Baruch College
Manhattan
01.2022 - 07.2022
  • Developed various dimensional models for the project using LucidCharts to verify the relationship between the occurrences.
  • Loaded and worked on the Google BigQuery platform to explore, analyze, and work with NYC Open Data.
  • Develop reports and dashboards in Google Data Studio.
  • Utilized Pentaho for data extraction, transformation, and load.
  • Performed data cleaning, feature scaling, and feature engineering using the Pandas and NumPy packages in Python.
  • Used Pandas DataFrame for working with data and manipulating data.
  • Used Pandas DataFrame for working with data, manipulating data, and handling anomalies such as removing duplicates and imputing missing values.
  • Communicated results to clients using different visualization techniques, including MS Excel, Tableau, and Google Data Studio.
  • Implemented the functions to find null values, and utilized the Join function to sort and merge the data.

Transfer Peer Mentor

CUNY Baruch College
Manhattan
08.2021 - 06.2022
  • Advocated for and mentored transfer students, addressing their unique needs and concerns.
  • Developed and delivered workshops on topics relevant to transfer students, such as academic success strategies and navigating campus resources.
  • Assist with programs and resource materials to help transfer students transition to the CUNY system.
  • Collaborated with faculty, staff, and other mentors to provide comprehensive support and personalized guidance.

Student Peer Advisor

Laguardia Community College
Long Island City
09.2019 - 02.2021
  • Assisted the Pre-Enrollment department with the registration process for new and transfer students.
  • Created a database of students’ information and their enrollment progress using tools like MS Excel.
  • Communicate with new students over the phone and via email regarding the admission process.
  • Keep track of the logistics for new and transfer students.
  • Assist Enrollment Coaches from all departments in virtual and in-person sessions.

Education

BBA - Data Analytics

Baruch College CUNY
Manhattan, NY
12-2023

Associate of Science - Business Administration

LaGuardia Community College
Long Island City, NY
12-2020

Skills

  • Sales analysis
  • Inventory management
  • Customer relationship management
  • Data visualization
  • Market research
  • Lead generation
  • Data reporting
  • Team collaboration
  • Time management
  • Inventory tracking
  • Sales expertise
  • Decision-making
  • Team support and assistance
  • Computer proficiency and Microsoft office

Certification

  • Big Data Fundamentals in PySpark
  • Marketing Analytics in Spreadsheet

Timeline

Sales Assistant

Produce Experience
04.2024 - Current

Big Data Technology Project

CUNY Baruch College
08.2022 - 12.2022

Data Warehousing and ETL Project

CUNY Baruch College
01.2022 - 07.2022

Transfer Peer Mentor

CUNY Baruch College
08.2021 - 06.2022

Student Peer Advisor

Laguardia Community College
09.2019 - 02.2021

BBA - Data Analytics

Baruch College CUNY

Associate of Science - Business Administration

LaGuardia Community College

Similar Profiles

CREATE PROFILE