Movies
Aviram Samanta
Data Analyst
Kolkata
Summary
Motivated and analytical professional with 4 years of total experience and 3.3 years of experience as a Data Analyst in evaluating dashboards and developing Business reports. Proficient in Advanced Excel, Python, SQL, and VIZ tools like Tableau, IBM Cognos, etc. Also, A Management grad in ITSM from NMIMS along with experience in team management in career path.
Overview
5
5
years of professional experience
10
10
years of post-secondary education
5
5
Certificates
3
3
Languages
Work History
MIS Executive
Wipro
Chennai
05.2023 - Current
- Extract HC Report from SAP and prepare the report of overall Account Head Count. Identifying Short/Over HC as per actual and the approved HC.
- Preparing monthly financial Accruals and Invoices for billing to the clients
- Tracked departmental team database, attrition and roll out the report to management.
- Designed internal Production dashboard for overall status of the Performance of the process queue. Tracking and analyzing various metrics of the 93 production agents like Quality, Productivity, CPH, Attendance etc and send the reports daily/weekly/monthly to the management.
- Analyze the raw data from various teams and process it as per the requirements from the management to showcase the insights in the report.
- Created automated birthday emails to the team members by using power automate.
- Created MS forms to simply the process to collect the data from the team members in the process.
- Responsible for preparing data, making charts for WBR/QBR calls to clients.
- Exploring Tableau to download and analyze the metrics of the production from onshore team.
Data Analyst
Amazon
11.2019 - 09.2022
- Worked for Critical Customer Data for maintaining 99% data quality in locale.
- Identify, evaluate and implement external services and tools to support data validation and cleansing using Excel and Python
- Generate and track key performance indicators with help of Tableau which supports 10 teams
- Extract, Manipulate, analyze and interpret complex data sets relating to business using tools like SQL, Python, and Excel
- Create reports weekly/monthly for internal stakeholders using business analytics tools like Tableau
- Built Performance report and Shrinkage tracker of 2 teams.
Associate
Netscribes India (Pvt) Limited
Kolkata
02.2019 - 10.2019
- Did Proofreading of product descriptions on e‑commerce websites like Nike, Noon, Adidas, Flipkart, etc
- Did research on authenticity of brands listed on Flipkart Website and worked on content review moderation of feedback on Flipkart website
- Analysis of Search Data of Customers on Flipkart Website and improved SEO of Flipkart
- Daily Client Interaction for Quality Improvement Plan, Follow up for New Updates
- Conducted Training, Evaluation for Graduation of 50 new hires
- Led 10+ pilot projects, among them 2 projects were launched successfully
Education
Postgraduate Degree - INFORMATION TECHNOLOGY AND SERVICE MANAGEMENT
Narsee Monjee Institute of Management Studies
Kolkata, WB 01.2021 - 04.2023
Bachelor of Technology - Electrical Engineering
Maulana Abul Kalam Azad University of Technology
Bengal, West 01.2013 - 04.2019
Higher Secondary - Science Education
Kendriya Vidyalaya
New Delhi 06.2012 - 03.2013
Secondary School - Science Education
Kendriya Vidyalaya
New Delhi 03.2010 - 04.2011
Skills
Data Analysisundefined
Certification
DATA VISUALIZATION AND DASHBORDS WITH EXCEL AND COGNOS - Coursera
Accomplishments
- Rising star-Awarded for achieving 95+% quality consistently for three months.
- The client "Flipkart" had selected me as a Team Leader for the new project and led 50 team members
- Created automated birthday emails to the team members in Wipro for my process.
Interests
Bike Riding
Timeline
MIS Executive
Wipro
05.2023 - Current
Postgraduate Degree - INFORMATION TECHNOLOGY AND SERVICE MANAGEMENT
Narsee Monjee Institute of Management Studies
01.2021 - 04.2023
Data Analyst
Amazon
11.2019 - 09.2022
Associate
Netscribes India (Pvt) Limited
02.2019 - 10.2019
Bachelor of Technology - Electrical Engineering
Maulana Abul Kalam Azad University of Technology
01.2013 - 04.2019
Higher Secondary - Science Education
Kendriya Vidyalaya
06.2012 - 03.2013
Secondary School - Science Education
Kendriya Vidyalaya
03.2010 - 04.2011
Projects
- Nutrition analysis of starbucks beverages using Python,Excel and tableau : https://public.tableau.com/app/profile/aviram.samanta/viz/Starbucks_16754192563360/Dashboard1?publish=yes
- Data analysis of T-20 World cup 2022 using Python - https://github.com/aviram27/t20-world-cup-2022.git and
- Tableau - https://public.tableau.com/views/ProjectPortfolio_16729364159190/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link
- Impact of Covid-19 on digital payments in India.
Projects
- Nutrition analysis of starbucks beverages using Python,Excel and tableau : https://public.tableau.com/app/profile/aviram.samanta/viz/Starbucks_16754192563360/Dashboard1?publish=yes
- Data analysis of T-20 World cup 2022 using Python - https://github.com/aviram27/t20-world-cup-2022.git and
- Tableau - https://public.tableau.com/views/ProjectPortfolio_16729364159190/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link
- Impact of Covid-19 on digital payments in India.
Similar Profiles
Mohil Pushpraj DhadgeMohil Pushpraj Dhadge
Senior DevOps Engineer at WiproSenior DevOps Engineer at Wipro
Harshit MishraHarshit Mishra
Associate analyst at WiproAssociate analyst at Wipro
RICHA KAPURRICHA KAPUR
Principal Consultant at WiproPrincipal Consultant at Wipro