Gopinath S
Data Analyst
BANGALORE
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Data Analysis.
Overview
4
4
years of post-secondary education
Work History
Customer Solutions - 4
PayPal India Private Limited
Bangalore
11.2019 - Current
- Monitored and analyzed customer feedback to track patterns in feedback and report areas for improvement to management.
- Identified and reported trends in customer complaints to improve products and prevent future complaints.
- Kept accurate records of customer interactions to be used for training, quality assurance and future reference.
- Identified miss in productivity reporting tool and worked with the teammates to improve their productivity by approximately 20%.
Executive
24/7.ai
Bangalore
11.2017 - 10.2019
- Oversaw troubleshooting, technical issue resolution and consulting services to upgrade technology infrastructure.
- Diagnosed and troubleshot hardware, software and network issues.
- Responded to support requests from end-users and patiently walked individuals through basic troubleshooting tasks.
- Managed over 50 contacts over chat per day and consistently maintaining customer resolution rate of over 60%.
Education
Bachelor of Engineering - Automobile Engineering
PES College of Engineering
Mandya, Karnataka, India 09.2011 - 07.2015
Skills
Excel: Data analysis using Pivot Tables and Pivot Charts and controlling the same using Slicers Statistical analysis using Add-in for Excel to get various descriptive statistics Strong hold on Excel formulas and data formatting for calculation, data analysis and report generation Knowledge about MIS reporting Creating dashboards and visualizing the data for presentations Knowledge about different types of look up like VLOOKUP, HLOOKUP, FUZZYLOOKUP etc
Power BI : Analyze and present data to help the company make important decisions Perform DAX queries using Power BI tools Finding correlations in data to discover meaningful insights Collaborating with teams and managers to help businesses develop Creating interactive visual reports using BI tools Identifying key performance indicators (KPI) to help companies adjust and fulfil objectives
SQL: Understanding of DBMS Architecture Knowledge of different type of database languages like DDL, DML, DCL, TCL Knowledge of all different types of keywords used in all the above mentioned DBMS languages Have good understanding of different types of SQL joins Good command on using subqueries, set operators Good knowledge about aggregate functions used in SQL and different types of clauses used with the aggregate functions in order to meet the business requirements Good understanding about constraints at column level or table level Knowledge about different keywords used to handle NULL values Knowledge about Indexes, Views, Stored Procedures, Data Partitioning, etc
Python: Have hands on knowledge on Python in terms of data analysis, loops, user-defined functions and lambda Sound understanding of different libraries that are used in Data Analysis like Pandas, Numpy Sound understanding of visualization libraries in Python like matplotlib, seaborn Hands on knowledge about different functions in Pandas which helps a lot in data analysis like pivot, groupby, concat, merge, etc
Timeline
Customer Solutions - 4
PayPal India Private Limited
11.2019 - Current
Executive
24/7.ai
11.2017 - 10.2019
Bachelor of Engineering - Automobile Engineering
PES College of Engineering
09.2011 - 07.2015