Data Analyst Executive

Rajesh kumar Email: *********@**********.***

Mobile: 750-***-**** / 987*******

Professional Synopsis

More than 8 Year’ experience in Finance, Database Management and Team Management.

Sound knowledge of Excel & analysis along with the process optimization, cost control and revenue maximization.

Expertise in managing day to day operations with rich experience in handling teams and designing new strategies to win in the market.

Knowledge Preview

Understanding business needs, its strategic direction and identifying initiatives that will allow a business to meet those strategic goals.

Explaining requirements to the development group and providing functional understanding, participated in arriving at solutions with the development team for any implementation problems.

Analyzing business processes, trend analysis and using various business tools to assist the critical decision making process.

Collating and interpreting financial data for determining the financial performance of the companies.

Organizational Experience

Tsi Yatra Pvt Ltd

Designation: Sr Credit Controller

Tenure: Jun’14 –Present

Key Responsibility:

Submission of Outstanding statements and approvals to corporate.

Payment follow-up with Clients and Age debt collections.

Knocking-off payment in the system.

Focus on collection of old outstanding, Minimize Bad debt.

Prepare the estimation collection & Mis Report and weekly collection report to management.

Resolve Query regarding billing dispute, deals, commission & payment dispute of agent through email or phone.

Handling all Gst payment (keep in mind duplicate invoices payment should not be done twice and Sort out all Query raised regarding Gst payment as well as cash account by agents through mail and telephonic

Identifying accounts that will require special attention or investigation.

Ensure payments are made on time.

Prepare the cheque bouncing report.

Reconcile upload Amt,Temp credit amt and cc to check whether we received in bank or not.

Reconcile DI amount which is given by Upload team to check is correct or not.

Followed up on final warnings sent to customers after suspension of services.

Ecos(I) Mobility & Hospitality

Designation: Executive Billing & Collection

Tenure: Dec’13 –To –Jun-2014

Key Accountabilities:

Handling the all bill of International, Foreign delegation of Ministry of External Affairs,Embassy and Gts.

Make adjustments, handles queries and resolve problem within company guideline and policy.

Maintain the outstanding Dues render services by our client and send the outstanding invoices to client.

chasing debt by telephone and email and reducing debtor days.

Allocating payment according customer remittances.

Investigating and resolving queries relating to non payment of invoices.

Monitor overdue payments by use of a spread sheet.

receives incoming cash either by cheque or NEFT, and processes cash onto the account sheet.

Knowledge of Karishma Software & Rent Net

Deneb & Pollux Pvt Ltd.

Designation: Billing Executive

Tenure: May’09–To - Dec’13

Key Responsibility

COLLATE AND ANALYZED COMPANY QUARTERLY AND HALF YEARLY PERFORMANCE DETAILS

Prepare itemized statements, bills, Raised the invoices for client; and maintain the amounts due for services rendered.

Handling Billing dispute duties and Query made by our client(Royal Bank of Scotland)

To checking up the fuel cost on each every cars comparing with covering kilometers.

Collection of outstand dues and follow up for payments.

Prepare MIS report and Creating the bill for Rbs client

Invoice Control Solution Pvt Ltd

Designation : Data Analyst

Tenure: Mar-08 to Feb-09

Key Responsibility

Downloading of Invoices from Avaya Site and SAP.

Digitization of all relevant documents and invoices.Identification of errors.

Preparation of summary reports based on the errors identified.

Potential savings opportunity through error resolution

Perform a rigorous line level analysis by matching invoices to PO no

and contracts to identify possible errors.

Prepare the Report in Excel on daily basis (By using Vlookp,

Pivot tables, Sorting, Conditional formatting).

Sent report to Account payable Dept

Hutch Agency (KSWD & Associates Pvt. Ltd.

Destignation: Executive

Tenure: Sep 04 to Mar-07

:Handling Hutch pre-paid and post –paid verification allocation of 4500- 5000 cases per month & sending

reports back to the head-office as accordance with the TAT decided earlier.

: Judging the credit limit of Post-paid connection –subscribers.

: Preparing MIS-Sheets, Quality –Sheets TAT and Status-Reports after getting written feed-back by field-

verifiers of Hutch

: Deciding case status according to verification done & give coding on every Bank-case.

Accounting Package Mid office,Navision,Krishma Software, Rentnate

MS-Office-2003 to 2010 (Word, Excel, PowerPoint,).

Good knowledge of Microsoft Excel (2010), V lookup, H lookup, Pivot Table, Conditional Formatting, Count If, Sum if, Multiple If Conditions, Index Match.

Experience Personal

Good team player, Able to work under pressure and to meet deadlines.

Appreciations from management, customers & agent are as well.

Supervising and monitoring the work of junior staff in a credit team.

Able to undertake complex reconciliations.

Experience of high volume collections.

Scholastics

Graduation in Office Management & Secretarial Practice from College of Vocational studies(Delhi Universities) .

12th from CBSE Delhi

10th from CBSE Delhi

Personal Profile

Date of Birth : 08th January’1979

Interests and Hobbies : Watching news and discovery/Historical channel, reading books, playing cricket.

Address : H.No 350 Gali No -5 Bijwasan New Delhi-61

Place:

Date: __/__/ [Rajesh Kumar]

Contact this candidate