Summary
Overview
Work History
Education
Skills
Projects
Accomplishments
Languages
Timeline
Generic

ANISHA SINHA

Pune,MH

Summary

My objective is to be a part of the organization with professional work driven environment where I Can utilize & apply knowledge and skills to grow while fulfilling organizational goal. Strengths include, good communication, team handling an ability to focus on detail.

Overview

4
4
years of professional experience

Work History

Operations Consultant

Xpressbees Courier Office
10.2022 - 02.2024
  • Demonstrated strong organizational and time management skills while managing multiple projects
  • Applied effective time management techniques to meet tight deadlines
  • Resolved problems, improved operations and provided exceptional service
  • Demonstrated leadership skills in managing projects from concept to completion
  • Demonstrated a high level of initiative and creativity while tackling difficult tasks
  • Handling reverse shipment process ,investigating cases and finding out disputes.
  • Communicating with clients to resolve case issue and File Compilation.
  • Collaborated with clients to target issues and uncover methods that would increase operational efficiency
  • Implemented processes and procedures to improve overall efficiency in operations
  • Adapted quickly to changing project priorities and job specifications with analytical thinking and task prioritization skills

Support Associate

PLS Lawyers
10.2019 - 11.2021
  • Created, prepared, and delivered reports to various departments
  • Demonstrated computer skills for data entry and answered broad variety of inquiries
  • Reviewed deposits documents for accuracy and completion
  • ·Preparing and sending reports to clients.
  • Requesting documents from clients and raising queries with team as per requirements of work.
  • Supported team with knowledgeable administrative assistance
  • Evaluated client progress toward established annual and quarterly goals
  • Provided sellers with accurate information concerning platform policies for sales, database issues, and listing inaccuracies
  • Answered questions regarding seller inventory, shipping, payments and buyer complaints
  • Initiated follow-up phone calls to sellers concerning resolved issues to enhance platform experience
  • Monitored employee and customer interactions to assess quality of service

Education

Master of Arts - Counseling Psychology

Amity University
Gurgaon, HR
01.2019

Master of Arts -

Presidency University
Kolkata, WB
01.2016

Bachelor of Arts -

Presidency University
Kolkata, WB
01.2014

Skills

  • GoogleSheets- Vlookup, Hlookup, Xlookup, if, nested if, Countif, countifs, sumif, sumifs, Pivot Table, Charts
  • SQL- Aggregate functions(sum, average, count, max, min), windows function(row, rank, dense rank, lead, lag, nth value), Filtering & sorting (where, having, groupby, orderby), Date & Time Functions, String Functions(Concat, Substr, Ucase, Lcase, Replace), Joins(inner, outer, left, right), Subqueries(Select in Select, Select in From, Select in Where, Self Join), Case when, if, nested if
  • PowerBi- Data Cleansing with power query editor, Data Modeling and Optimization, Data Customization, Interactions, DAX functions, Managing Relationships, Charts and Visuals
  • Python- Identation, Loops(For While), List Comprehension, Dictionary Comprehension, List Functions, Dictionary Functions, Build in functions and User Defined Functions, Lambda Functions, numpy array, Pandas, Labeling and Indexing, Dataframe

Projects

1. Googlesheets online retail store purchase analysis

Goal- To analyse the key performance indicators of LES retail store brand.

Solution- i) On the basis of countries, the RFM analysis of USA & UK is 22.5% and Australia, China and India is 18.4%.

ii) On the basis of Customer classification, Champions have the maximum RFM score of 544 and Hibernating has the minimum score of 222.


2. Power Bi Finance Department of ABC Company Analysis

Goal- To build a dashboard with some key metrics, that can be one source of truth for all regions.

Solutions- i) EMEA region has the highest amount by 12.87 million.

ii) On the basis of report, the highest amount is 248.89 M and the sum of payslips generated by month is 5.25 M.


3. SQL distribution of duration of trending videos analysis

Goal- To analyse the distribution of duration of videos on the basis of various categories.

Solutions- i) On the basis of country, Great Britain has the highest no of videos trended for 36 daysand Canada has the lowest no of videos trended for 1 day.

ii) On the basis of category, music has the highest average trending period for 13 days.


4. Power Bi invoice details of all vendors in Accounts Department analysis

Goal- To create a dashboard that can help procurement department make better supply chain strategic decisions.

Solutions-i) The highest RM grade is GI by 5.2k and the lowest RM grade is SG BY 3.9k.

ii) The strategic status of Go is 60% and NoGo is 40%.

iii) The highest casting source is AMA BY 5.4k and lowest casting source is FLO Enterprise by 1.9k

iv) In Part Family Tonnage, the Feed Pump Housing has the highest percentage of 22.67%

Accomplishments

  • Received Star Performer Award in PLS Lawyers
  • Ranked 1st in 3rd and 4th semester in Masters of Arts (Philosophy)
  • Ranked 1st Class 2nd in Post Graduate University Result
  • Awarded certificate for singing – 4th year – by Pracheen Kala Kendra, Chandigar

Languages

English
Hindi
Bengali

Timeline

Operations Consultant

Xpressbees Courier Office
10.2022 - 02.2024

Support Associate

PLS Lawyers
10.2019 - 11.2021

Master of Arts - Counseling Psychology

Amity University

Master of Arts -

Presidency University

Bachelor of Arts -

Presidency University
ANISHA SINHA