Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

Sujith P

Data Analyst
Bengaluru,KA

Summary

7+ years of experience for OMS-based company, with expertise in MS-office

Good at for MIS reporting and Power BI Visualization.

Handled the backend pipeline using AWS server and regular maintenance of server.

2 years of experience as Power Bi developer in creating the reports and in the power bi administration.

Gathering the business requirements, analyzing and developing reports as per the requirements.

Developed different visualizations like bar chart, pie chart , Scatter plot, heat map and tree map.

Basic knowledge on writing SQL queries

Dedicated and motivated data analyst with proven skill driving process and data integrity improvements. Over 2+ years of experience leading teams in data mining and data warehousing solutions. Exceptional skill in SQL-based environments.

Overview

9
9
years of professional experience
6
6
years of post-secondary education
4
4
Languages

Work History

Data Analyst

Whitehat.Jr
BANGALORE, KARNATAKA
08.2021 - Current
  • Making automation Dashboard via Google Sheets By using Salesforce Report and Python Code.
  • Created Management Dashboard on Course Level/SM Level/TL Level on the basis of Daily,Weekly & Monthly Review
  • Researched and resolved issues regarding integrity of data flow into databases.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Utilized data visualization tools to effectively communicate business insights
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Developed tables, views and materialized views using SQL.

Sr.MIS-Data Analyst

CASAONE INDIA
Bangalore, Karnataka
04.2019 - 07.2021
  • Timely circulation of the Daily/ Weekly/ Monthly reports to the stakeholders, Regular reporting for category, marketing, Customer success and operations.
  • Perform quantitative analysis for trend changes of the reported numbers.
  • Automate reporting of key business metrics with MySQL queries and Power BI.
  • Management team regarding progress and roadblocks to closing new customers/existing customer.
  • Published reports and dashboards using Power BI.
  • Visualizations using Power BI Manage day-to-day Operations, strong analytic and problem solving in Fulfillment orders.
  • Prepare reports and record all important transactions.
  • Preparing of MIS Reports, Creating and analyzing revenue reports, MTM trend report fetching data from My SQL and Power BI.
  • Developed optimized data collection and qualifying procedures Worked with other team members to complete projects and achieved project deadlines.
  • Extract data from My SQL data base and analyzed data to generate reports.
  • Documented business workflows for stakeholder review
  • Coordinated statistical data analysis, design and information flow
  • Developed database objects, including tables, views and materialized views using SQL

MIS-Data Analyst

IVISTA DIGITAL SOLUTIONS, BANGALORE
Bangalore, Karnataka
11.2016 - 03.2019
  • E-commerce report on a daily basis (Return & Forward) CHC report Agent Performance report Business Reports on a daily & monthly basis (Client & and Internal) Performance report based on our SLA for all Metro cities Training new OMT associate on all the required skill set.
  • R&R analysis on a weekly basis.
  • Implemented & improved the process by automating API logs, implementation of SOPs, streamlining workflow & creating team work environment to enhance productivity.
  • Daily monitoring of returns raised & Orders getting processed for DTO getting delivered within the TAT.
  • Making daily co-ordination with respective POC of concerned logistic for escalation & seeking immediate resolution within the SOP.
  • Involved in monitoring & executions of complete first mile till last mile process.
  • Involved in monitoring & executions of complete DTO process within predefined TAT by making proper co-ordination between logistic partner & concerned vendor for smoothly execution of the task.
  • Coordinating with the accounts team for faster refunds for the RTO and DTO cases.
  • Preparing reports Like Business report, Billing Data, Master E-com (Forward and Reverse), SLA report, Metro city reports and Analysis report (Forward and Reverse).

Executive Team Leader

FLIPKART PVT.LTD
Bangalore, Karnataka
11.2014 - 11.2016
  • Managing warehouses for timely shipping and coordinating with 3PL partners for arranging pickups from sellers/Warehouses, handling customer escalations and managing supply of packaging material for sellers.
  • Preparing & verifying MIS reports as per SLA with a view to apprise management of the process operations & assist in critical decision-making process for better Customer Experience.
  • Managing the performance level by monitoring & executing first mile to last mile deliveries within SOP.
  • Well versed with trade settlements with logistic platforms like E-Kart logistic, Ecom-express, Delhivery, Holisol Logistics.
  • Implemented & improved the process by automating API logs, implementation of SOPs, streamlining workflow & creating team work environment to enhance productivity.
  • Daily monitoring of returns raised & Orders getting processed for DTO getting delivered within the TAT.
  • Making daily co-ordination with respective POC of concerned logistic for escalation & seeking immediate resolution within the SOP.
  • Involved in monitoring & executions of complete first mile till last mile process.
  • Involved in monitoring & executions of complete DTO process within predefined TAT by making proper co-ordination between logistic partner & concerned vendor for smoothly execution of the task.
  • Coordinating with the accounts team for faster refunds for the RTO and DTO cases.
  • Preparing reports Like Business report, Billing Data, Master E-com (Forward and Reverse), SLA report, Metro city reports and Analysis report (Forward and Reverse)

Education

High School Diploma -

SVK
Bangalore
04.2008 - 04.2009

Associate of Science - PU,PCMC

AECS PU College
Bangalore
05.2009 - 05.2011

Bachelor of Science - BCA

Vijaya College
Bangalore
06.2011 - 06.2014

Skills

    Order management system

undefined

Software

Microsoft office

My SQL

Power bi desktop

Windows Server

Google Analytics

Timeline

Data Analyst

Whitehat.Jr
08.2021 - Current

Sr.MIS-Data Analyst

CASAONE INDIA
04.2019 - 07.2021

MIS-Data Analyst

IVISTA DIGITAL SOLUTIONS, BANGALORE
11.2016 - 03.2019

Executive Team Leader

FLIPKART PVT.LTD
11.2014 - 11.2016

Bachelor of Science - BCA

Vijaya College
06.2011 - 06.2014

Associate of Science - PU,PCMC

AECS PU College
05.2009 - 05.2011

High School Diploma -

SVK
04.2008 - 04.2009

Similar Profiles

CREATE PROFILE
Sujith PData Analyst