Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Personal Information
Timeline
Generic
Sandeep Kunhambu Nambiar

Sandeep Kunhambu Nambiar

Pune

Summary

With a proven track record at CAPITA, I excel in creating advanced reporting tools and dashboards using Power BI, Tableau, and SQL, enhancing decision-making and operational efficiency. My leadership in automating processes and keen ability to liaise with senior management underscore my adeptness in both technical and executive-level soft skills.

Overview

21
21
years of professional experience

Work History

Assistant Manager

CAPITA
Pune
01.2013 - Current
  • Lead a team of 10 members who reported for different clients.
  • Successfully led the team to develop 20 to 25 projects in the Power BI tool.
  • I prepared an internal website using Power Apps, Power Automate, and Dataverse.
  • Provided insights to the HR department and telecom processes by analyzing their data using Python.
  • Designed and developed many dashboards, reports, and guided quality projects for the HR group. Tools used: Power BI, Azure, and other databases, Excel.
  • Designed, developed, and managed different dashboards for a Travel Management Process. Managed a team of two members. Tools used: Tableau, SSRS, SSMS, Excel.
  • Developed logic for forecasting, scheduling, and planning in VBA, and passed it to the IT team to develop the tool. Tools used: - VBA, Excel.
  • Worked on VSM (Value Symmetric Mapping) for one of the insurance clients to analyze the time required for different subprocesses within the process. It also ensured the process is mapped with each of its sub-processes in a sequence, so that all the pending issues are tracked. We further enhanced the process reporting using the data set prepared. The tools used are VBA, Excel, and Tableau.
  • Automating and developing the dashboards with Oracle PL/SQL coding.
  • I prepared an automated dashboard for an insurance client to identify the backlogs of claims based on their age in the process. We segregated the whole dataset into different categories according to its criticality, and tracked the progress. Created different dashboards to analyze the issues, and gave qualitative inputs. Tools used: SQL, VBA, and Excel.
  • I prepared an automation tool to analyze the FTEs required for a process, and I worked on its optimization. Tools used: - VBA, Excel.
  • Prepared dashboards to analyze the repeats created for a telecom client, and showed the repeat data based on different teams, sections, etc. Tools used: VBA, Excel.
  • Prepared a transfer report for analyzing the transfers that happened for a telecom client. Tools used: - VBA, Excel.
  • Preparing presentations for the business as per requirements.
  • Giving support to VBA projects offline.
  • Interviewing and recruiting new team members.
  • Preparing different automated test papers.
  • Developing new ways to automate reports.
  • Continuously interact with UK analysts and managers for different projects.
  • Helping different teams to automate and design reports within deadlines.
  • Giving training to them on their operations.
  • Practical experience with Business Objects.
  • Designing new queries as per requirements.
  • Work experience with reports using Oracle SQL.
  • Giving training to new recruits.

Sr.Officer

MphasiS an HP Company
03.2009 - 01.2013
  • Automating the reports as per the requirements and to save the process time line’s
  • Developing new tools in VBA to automate reports
  • Prepared around 15 automations, where all appreciated
  • To generate reports that provides timely inputs to the Management, on call center performance
  • To identify and list the internal reports that tracks the call center performance
  • The responsibility of identification, compilation, analysis, and control of the Internal Reports lies with Centralized MIS
  • Generating MI Reports (excel based) for technical/non-technical UK/US processes across MphasiS BPO using Nortel, AVAYA Centre & various tools that capture agent-wise/unit-wise performance
  • These performance reports involve SLA’s (Service Level Agreement) put forth by the clients with Targets set for the same, for which various calculations are used to arrive at the actual SLA’s for the day this data is presented to the process owners & managers in formats required by them on a daily/weekly/monthly basis
  • Preparation of daily/monthly Dashboards which comprise of performance matrix of the process for analyzing the overall performance of the process against the targets & the achieved figures
  • Creating a graphical view of the performance monthly & comparing them with the previous month’s as well as ytd (year to date) figures using excel graphs
  • This helps the process to understand where they stand at the end of the month
  • Roster making is a weekly/fortnightly/monthly operation which varies from process to process
  • But there are certain inputs which are provided by the process such as planned leaves, Comp offs, etc
  • These inputs have to be incorporated in the rosters carefully keeping in mind the number of agents required & so on

Technical Support Executive

e-Dictate IT solutions PVT Ltd.
06.2006 - 03.2009
  • Preparing real time reports (daily, monthly) as per the process requirements to analyze the performance of HBT’s/QA’s
  • Successfully Automate the monitoring reports & generate consolidate report
  • This report can be viewed by anyone who has the access to Shared drive’s
  • Support HBA’s/HBT’s to get their technical issues resolved
  • Co-ordinate the work as a chat/voice support to troubleshoot their issues and to check if the TAT is maintained for the work given
  • Worked as a mediator between the senior and low-level managements

Hardware Engineer

Mbytes ITFM Services
02.2004 - 06.2006
  • Worked as a hardware engineer for the client Suzlon Energy Ltd

Education

Bachelor of Computer Applications -

Sikkim Manipal Deemed University
08-2020

DIPLOMA IN COMPUTER HARDWARE MAINTANENCE -

E K Nayanar Polytechnic College
04-2003

PREE DEGREE -

Payyanur College
06-2000

S.S.L.C. -

Pappinisseri Panchayath High School
01.1998

Skills

  • Creation of Reporting Tools
  • Dashboards
  • MS Tools
  • Power BI
  • Tableau
  • SQL
  • Azure
  • VBA
  • MS Access
  • Power Queries
  • Business Objects
  • Python
  • Multiple executive-level soft skills
  • Interacting with senior management

Accomplishments

  • Awarded with Performer of the year for my work on VSM (Value Stream Mapping) for one of the insurance processes.
  • Awarded two times with star of the Quarter (Capita) for my works on PIM project & for repeat dashboard I prepared for repeat analysis in one of telecom client.
  • Awarded with star of the month (Many times – Capita, for some exceptional automations).
  • Excellent Performance scores throughout tenure (Both Mphasis and Capita).
  • Certified with APEX Award (Mphasis).
  • Certified with monthly Summit Award (Mphasis).
  • Successfully implemented new reports with when the database changed from Nortel to Exony and trained everyone in the team.

Languages

  • English
  • Hindi
  • Malayalam

Personal Information

  • Total Experience: 21.0 years
  • Date of Birth: 03/17/83
  • Marital Status: Married

Timeline

Assistant Manager

CAPITA
01.2013 - Current

Sr.Officer

MphasiS an HP Company
03.2009 - 01.2013

Technical Support Executive

e-Dictate IT solutions PVT Ltd.
06.2006 - 03.2009

Hardware Engineer

Mbytes ITFM Services
02.2004 - 06.2006

Bachelor of Computer Applications -

Sikkim Manipal Deemed University

DIPLOMA IN COMPUTER HARDWARE MAINTANENCE -

E K Nayanar Polytechnic College

PREE DEGREE -

Payyanur College

S.S.L.C. -

Pappinisseri Panchayath High School

Similar Profiles

CREATE PROFILE
Sandeep Kunhambu Nambiar