Ranjit Singh Kumar Email & Phone Number

Handling a Strong Team of Report Assistants and Associates whose primary role is creating and maintaining client and organizational reports for International Tech-Verticals having operations based in India. Skilled in training internal workforce to meet and achieve Organizational targets. I am responsible for co-ordinating with the client and client services on the status of current reports and new changes/updations, if any.Expertise in: Team Handling Report Creation & Data Processing. Successfully leading the team in handling all Inbound Call Data & Case Analysis for various projects such as Microsoft, Juniper, Yahoo, Time Warner, AT & T, BT Logica and many more. Delegating requests for adhoc reports to team members (Both call and case related). Extensive use of Excel & VBA skills in the process of report preparationTools Used: SQL Query Analyzer for pulling out data from Microsoft server. Using Dbvisualizer (Cross platform database independent editing tool) for digging into Convergys database. Using CRDB,IEX and Avaya CMS Server to mine data.Achievements:Was given incentives from the client services for good work.Having Conference calls every week with the Operations/Client services/Client regarding the reports.Successfully completed Six Sigma White belt and Yellow belt trainings.Undertook various trainings including CM Strategy training (Customer Management Strategy).Looking after all kinds of admin requirement for the team viz. Leaves, Attendance, ORS etc.

Results-driven team player worked as an MIS Executive handling International operations based in India.Expertise in:MIS Report Creation & Data Processing.Co-ordination with various departments viz. Operations, HR, Finance, Business Development, Admin and Software development to attain the Targeted Business Goals.Preparation of Weekly / Monthly Incentives as per operations requirement.Handling Client Report & Management Report Daily, Weekly & Monthly Basis.VBA projects on dialer reports and Tools to automate the system, and create new automated systems.Achievements:Was given the recognition of a developer for having developed VBA code for APR(Agent Productivity Report).

Handling of MIS reporting and analyzing independently of both inbound and outbound processes and presenting it to the senior management and to the CEO of the company. Coordinating with Production Team for any database requirement and issues.Responsible for preparing Management Information System Report (MIS).Preparation of Analysis for all Outbound and Inbound Processes.Responsible for handling the data related to Manning, Attendance, & Restoring.Preparation of Agent Productivity Reports as per Operation required.

Handling of Accounts and presenting it to the CEO of the company. Coordinating with Sales Team for Leads.Responsible for preparing their tenures and keeping up-to-date information of due dates.

Handling of On-line terminal and also back office operations with the sub-broker.Coordinating with Clients for days sauda(Trades) on the terminal.Responsible for preparing clients net transactions for the day and keeping track of their securities with the company, Transacting shares in dematerialized form with the parent broker.

Handling of back office operations with the publisher.

Persuing Mba, Project Management

Bachelor'S Degree, Arts

Post Graduate Diploma, Software Applications