Data Analyst Sales
Resume:
Sakthi Kumar
**************@*****.*********:*********@*****.***
Operation Analyst
Disys Jan 2019 – Present
Responsible person for Data & Operation for one of Business Unit. As a data person was responsible for give reports to BU Head and other team as well. All the data capturing & reporting are automated with VBA. KPI, Daily, Weekly dashboard using power query was key objective. Also, was a part of Power BI project taking as a challenge using excel power pivot and data modeling created all dashboard which was used to build Power BI. Along with this follow my daily activities
Preparation of daily activity report
Preparation of weekly, monthly report
Responsible for all the management revenue reports
Responsible for recruiter wise dashboard
Data maintainer for Power BI
Operational support related reports
Team lead & Manager performance
Client partner performance (Daily, Weekly, Monthly)
KPI scorecard for IRC dept
Quarterly review reports for each team
Vertical & Geographical reports based on USA office
Run rate by revenue report
Maintainer of Bullhorn data base
Report automation
Headcount tracking for each team based on budget
Adhoc Reports on request
Hotel Management
Diploma in Hotel Management (2007-2010
VBA
Chennai 2015
EDUCATION
Data Analysis
Power BI
Power Query
Advance Excel
SQL, VBA
Data Modeling
Automation in Dashboards
SKILLS
EXPERIENCE
Data Analyst with 6+ years of experience organizing presentations, data driven business solutions, preparing management reports, and maintaining the utmost confidentiality and expertise in Microsoft Excel, Power Bi. Looking to leverage my knowledge and experience into a role as Data Analyst.
RESUME OBJECTIVE
Data Analyst
80/94 Kalathiyappa St Choolai Chennai-600112
Tamilnadu
BCA/Computer
Dr. C.V Raman University (2015-18)
Project
Disys -2019
Power Bi – Was part of data team
Go Colors -2015
Data Base person for SAP team for implementation
Interests
Data Science
Artificial Intelligence
Develop Tool
Operation Analyst
Sitel Dec 2017 – Dec-2018
As part of daily activities was involved in various operations related numbers which can drive the business. Gave a breakthrough with automation of Billable hours which meets to client’s requirement. Have done VBA automation for WFM team. Re-designed KPI dashboard and scorecards. Using power query connected SQL to fetch data and created simple Avaya dashboard
Preparation of daily Inbound and Outbound reports
Daily target vs achieved billable hours report
Preparation of agent wise ATH & Chats report
Responsible for weekly/monthly business review report
Agent scheduled reports along with WFM reports
Agent wise pre-sales chats out -come analysis
Time management report of all process
Client KPI tracking on weekly basis team lead wise
Agents incentive working based on KPI
Sales analysis based on requirements
Language
English
Tamil
Hindi
Hobbies
Cricket
Shuttle
Music
MIS Analyst
SPR May 2017 – Dec-2017
Very much a new industry to work on with CRM data. Reporting with salesforce and various dashboard related to CRM. Automation in CRM process for payments and invoice managements
Key achievement was re-designed incentives structure which intend helped management to achieve their targets
Preparation of daily sale report, Inbound and Outbound reports
Preparation of weekly, monthly sales report
Responsible for all the management reports
Setting up targets based on projection for CRM team
Agent wise pre-sales performance for COE team
Base management for CRM support
Full filling sales force requirements
Marketing campaign reports
MIS Analyst
Go Colors Mar 2014 – Mar-2016
A new start to manufacturing and retail sector data to work with. Automation in Inventory management, Stock, Replacement of stock, Order management, Cash & Credit management using VBA and advance excel query. Upload data to SAP to rectify stock. Data analysis by product for EOSS. Business ppt for investors, huge data of bar codes to handle with
Preparation of daily sale report
Preparation of weekly, monthly sales report
Responsible for all the management reports
Responsible for sales persons' reports and preparation of incentives
Analyzing the product sales of branches
Preparation of projection report for every quarter
Setting up targets based on projection
Preparation of sale order report for retail sales
Maintaining dispatch and pending report of production end
Inventory maintaining and dispatch of stock as required
Operational support for new store setup
Projection and PPT for board meeting for the company
MIS Analyst
Scope Pharma Mar 2013 – Mar-2014
As this was the first in the carrier a very good learning of business involved into lots data actives and reports. HR related report, Import and exports data entry
Preparation of daily sale report
Preparation of weekly, monthly sales report
Preparation of receivables on all account
Analyzing the product sales of branches
Preparation of projection report for every quarter
Setting up targets based on projection
Inventory maintaining and dispatch of stock as required
Contact this candidate