Microsoft Power Bi
Hi, I’m
Sumit Kumar
Lead Data Scientist
Bengaluru
Judge a man by his questions rather than his answers.
Voltaire
Summary
Data Scientist familiar with gathering, cleaning and organizing data for use by technical and non-technical personnel. Advanced understanding of statistical, algebraic and other analytical techniques. Highly organized, motivated and diligent with significant background in Data Analysis.
Overview
15
years of professional experience
10
years of post-secondary education
1
Certification
2
Languages
Work History
Eastvantage Private LimitedBengaluru
Lead Data Scientist
09.2022 - Current
Job overview
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
- Worked with stakeholders to develop quarterly roadmaps based on impact, effort and test coordinations.
- Coached and mentored junior data scientists on techniques.
- Extracted and assessed data from databases to drive improvement of product development and business strategies and processes.
- Identified, measured and recommended improvement strategies for KPIs across business areas.
- Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
- Discovered stories told by data to present information to scientists and business managers.
- Developed polished visualizations to share results of data analyses.
RBL Bank LimitedMumbai
Manager
08.2021 - 10.2022
Job overview
- Managing & tracking on-time resolutions of complaints & request PAN Bank
- Work closely with Services Management to prepare reports, decks, data, trends for effective meetings/ discussions with stakeholders & senior management
- Drive the achievement of service metric targets: Requests & Complaints - TATs, FTRs, Cancellations, Tickets approved within defined period, problem incidence - to the satisfaction of clients
- Involved in preparing and cleansing of the data
- Interacting with Client to get their requirements
- Managing Costs within Budgets for Client Services (7 Units) and support Client services management in planning & tracking the expenses vs budgets
- Ensuring successful delivery of key performance indicators (KPIs) and objectives
- Monthly Inventory reports / dealing with statutory & Internal
- Controlled costs and optimized spending via restructuring of budgets for labor, capital assets, inventory purchasing and technology upgrades.
- Liaised with human resource department to resolve employee conflicts and concerns in need of escalation.
- Coordinated team schedules to keep shifts properly staffed during busy periods.
- Held meetings to communicate new policies and procedures to appropriate personnel.
- Rendered on-demand support to senior leadership, connecting executives with appropriate management personnel to address concerns.
Reliance Retail LimitedMumbai
Deputy Manager
04.2021 - 08.2021
Job overview
- Created visually impactful dashboard for Digital segment
- Delivery of Client and Internal reports with 100% accuracy and Quality within the timeline
- Taking care of all data requirement send by operations team
- Managing vendors reporting regards to agent performance
- Analysis on complaints received to CEO desk (email/post)
Concentrix Services India Private LimitedThane
Assistant Manager
08.2018 - 04.2021
Job overview
- Sharing findings and data to team to improve strategies and operations
- Reasons sharing with operations for not met Basic KPI for operation support and delivery
- Identified opportunities for improvement, recommended as applicable with identified departments
- Assisted in organizing and overseeing assignments to drive operational excellence.
- Conducted weekly staff meetings to motivate staff members, address concerns and questions, plan improvements and evaluate progress toward goals.
- Preparing reports for executive leadership that effectively communicate trends & patterns using relevant data
- Taking care of all Type of dashboards related to Ops & Management
- Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
- Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily read by either human
- Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions
- Facilitated the monthly opportunities for improvement meeting with CQA, R&D & Brand team
- Maintained direct, timely and appropriate communication with clients
- Created visually impactful dashboard for South Asia countries (India, Bangladesh, Pakistan & Sri Lanka)
- Provide Adhoc client and operations requirement reports
- Preparation and presentation of WBR (Weekly Business Review), MBR (Monthly Business Review) and YBR (Yearly Business Review)
- Excellent written and verbal communication skills, with the ability to convey Policies & procedures of the company in an accessible and compelling manner
- Ability to organize, motivates, & establishes positive relations with fellow professionals.
- Collaborated with key personnel to verify data integrity and compliance with related regulatory guidelines and legal requirements.
Hinduja Global Solutions Ltd
Assistant Manager
08.2017 - 08.2018
Job overview
- Dashboards: Created impactful dashboards in Excel, PowerPoint and Tableau for data reporting by using pivot tables and VLOOKUP
- Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
- Presented findings and data to team to improve strategies and operations
- Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions
- Designed, built and implemented relational databases
- Facilitated the monthly opportunities for improvement meeting with CQA, R&D & Brand team
- Identified opportunities for improvement, recommended as applicable with identified departments
Concentrix Daksh Services India Pvt LtdKolkata
Lead Data Analyst
01.2015 - 08.2017
Job overview
- Help the line manager in various works like: 1X1, maintaining MOM of team meetings and publish the same etc.
- Need to Interact with client for various product related clarifications.
- Escalate various issues to the client and maintain proper database of same to follow-up.
- Client interaction on various escalations related to call handling and update dissemination across the process
- Need to help the line manager to supervise the team to ensure timely closer of all escalation and technical related cases.
- Maintain proper database of team members with details information of login adherence, productivity hrs., productivity percentage, time loss details and stack performance on daily as well as monthly basis.
- Manage the floor on real time basis with proper co-ordination with OPS.
- Manage the Service Level of the process with co-ordination with OPS.
- Analyzed data based on various parameters in line with the business requirements and providing reports to higher management for business strategy.
- Created a Centralized Database for reporting which became the base for all Adhoc requirements.
- Successfully set up reporting structure for various LOBs in the shortest time period
- Preparing daily, weekly and Monthly reports and same sent to client & Operations Team.
- Sending Hourly Performance SMS to HOD’s.
- Providing suggestion to operations as SL, C-SAT, Tagging and call disconnection after analysis.
- Daily publishing non- adherence Report.
- Business Dashboards preparation every week showcasing agent productivity, Occupancy, utilization.
- Reported on updates to project specifications and progress.
- Minimized resource and time losses by addressing employee or production issue directly and implementing timely solutions.
- Managed schedules, accepted time off requests and found coverage for short shifts.
- Tracked receipts, employee hours and inventory movements.
- Participated in cross-functional team-building activities.
- Mentored newly hired employees on operating WFM tools and developed training manual to use for reference.
- Evaluated employee skills and knowledge regularly, training and mentoring individuals with lagging skills.
- Developed monthly, Forthrightly and daily process reports / output plans to deliver on customer service metrics.
Concentrix Daksh Services India Pvt LtdNew Delhi
Senior Practitioner
01.2010 - 01.2015
Job overview
- Leading Front Office Non billing and technical Operations team
- Handled multiple project - (Accounting software, Tax Software & telecom).
- Handled customer’s enquiries on invoice & charges
- Resolved their technical issues related to software (accounting & Tax) and Telecom (network, recharge etc).
- Mentoring new representatives in understanding and delivering the productivity targets set forward by the client while maintaining the desired quality levels.
- Providing technical assistance to customers related to issues on Blackberry and I-Phone (Telecom) & Quick Books/QuickTax (accounting & tax). Raising trouble ticket and assigning it to the relevant department for unresolved issues.
- Provisioning support for Blackberry services
Infosys BPO LimitedBengaluru
Business Process Associate
12.2007 - 07.2009
Job overview
- Helpdesk Support
- Working for E-Docket process.
- Visa Extn (H1X, H4X), Passport Related
- Performed data entry operations to update database with customer responses.
- Collected, arranged and input information into database system.
- Generated reports detailing.
- Updated tracking spreadsheets for process monitoring and reporting.
- Gathered, organized and input information into digital database.
NIIT LimitedBelagavi
Sales Executive
04.2006 - 12.2006
Job overview
- Sales of Computer Courses (GNIIT) of NIIT
- Delivering the relevant information regarding courses.
- Increased revenue by implementing effective sales strategies in sales cycle process from prospecting leads through close.
- Achieved sales goals and service targets by cultivating and securing new customer relationships.
- Held meetings with director to identify techniques to overcome sales obstacles.
- Maintained detailed records of sales progress, inventories and marketing success to better align goals with company priorities.
Education
NIITBelagavi
GNIIT from Computer And Information Sciences
01.2004 - 07.2007
University Overview
- Completed GNIIT from NIIT Belgaum with grade “B” in July 2007
V S Prasana Bharti UniversityGurgaon, Haryana, India
from Computer And Information Sciences
08.2003 - 08.2006
University Overview
- Completed Bachelor of Computer Application
Rashtriya Computer Saksharta MissionAra, Bihar, India
No Degree from Computer And Information Sciences
04.2001 - 08.2002
University Overview
- Basics of computer applications
Maharshi Vishwamitra MahavidyalyaBuxar, Bihar, India
High School Diploma
05.1999 - 06.2001
University Overview
- Completed +2 in Science stream
Skills
Microsoft Power BI
Sales Force Analytics
Tableau
Advance MS Excel
MS Word
MS PowerPoint
Microsoft Visio
Additional Information
Achievements:
- Appreciated by the Heads of respective team for Managing Budgeting activities for Client Services in RBL Bank
- Performance Award (STAR Global Award) from IBM / Concentrix & its Client.
- Performance Award (Gem Award) for going extra mile.
- Performance Award (RAMP Award) from INFOSYS.
- Participated as Trainee/instructor in the Student Internet world 2005
Accomplishments
- Used Microsoft Excel to develop inventory tracking spreadsheets.
- Used Microsoft Excel to create headcount automated spreadsheet
Software
Microsoft Office
Tableau
Sales Force
Certification
Getting Started with Power BI Desktop
Interests
Playing Computer Games
Learning new technologies
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Lead Data Scientist
Eastvantage Private Limited
09.2022 - Current
Getting Started with Power BI Desktop
05-2022
Manager
RBL Bank Limited
08.2021 - 10.2022
Deputy Manager
Reliance Retail Limited
04.2021 - 08.2021
Assistant Manager
Concentrix Services India Private Limited
08.2018 - 04.2021
Assistant Manager
Hinduja Global Solutions Ltd
08.2017 - 08.2018
Lead Data Analyst
Concentrix Daksh Services India Pvt Ltd
01.2015 - 08.2017
Senior Practitioner
Concentrix Daksh Services India Pvt Ltd
01.2010 - 01.2015
Business Process Associate
Infosys BPO Limited
12.2007 - 07.2009
Sales Executive
NIIT Limited
04.2006 - 12.2006
NIIT
GNIIT from Computer And Information Sciences
01.2004 - 07.2007
V S Prasana Bharti University
from Computer And Information Sciences
08.2003 - 08.2006
Rashtriya Computer Saksharta Mission
No Degree from Computer And Information Sciences
04.2001 - 08.2002
Maharshi Vishwamitra Mahavidyalya
High School Diploma
05.1999 - 06.2001