Post Job Free

Resume

Sign in

Data Analyst Assistant

Location:
Hyderabad, Telangana, India
Posted:
February 16, 2021

Contact this candidate

Resume:

M VENKATESWARA RAO

Phone: +91-949******* 953-***-****) / E-Mail: adj7kk@r.postjobfree.com

PROFILE SUMMARY

A focused professional with nearly 7.5 years of experience in Branch Management and Business Operations and Sales support (MIS).

Excellence in coordinating and interacting with Top level management for aligning strategic vision, driving change, infusing new ideas and taking performance and productivity to the next level

Expertise in business operations; ensuring effective management to accomplish overall corporate objectives; proficiency in making presentations as well as submitting business offers as per product needs of clients.

Solutions-driven, customer centric professional with significant experience in managing all aspects of service functions and preventing escalations

Handling Cash, Proper Checking of KYC, Sending Daily, Weekly, Monthly Reports to the Corporate Office and branch gold checking and estimated purity percentage of gold. Verified internal account, loan sanction forms and settled forms, branch kyc forms, cash handling process, maintained monthly data and scrutinize the data.

A quick learner who can absorb new ideas and can communicate clearly and effectively.

ORGANIZATIONAL EXPERIENCE

MIS/Data Analyst – Kfin Technologies Pvt Ltd. – May 2017 – Feb 2021

Role, Position: Team Member (MIS Executive)

Company Profile: Mutual Fund sales support. Insurance Repository captures KYC data, converts the policies into electronic mode, protects them and takes care of your ongoing servicing needs of policy holders, Mutual Fund Operations

Roles and Responsibilities:

Receiving and downloading data from different sources and formatting data using by EXCEL

Maintaining and monitoring Mutual Fund investments, including inflows, outflows, valuations, risk ratings and performance analysis.

Manipulating, cleansing and processing data using Advance Excel functions for preparing internal, external & regulatory reports, ad-hoc analysis as required.

Creating Visually impactful weekly and monthly fund review documents and dynamic dashboards

Designing and building presentations in power point using graphs, tables and innovative Info graphics for CEO and Client Meetings

Responsible for developing New Reports and delegating tasks to Team Members

Removing duplicate numbers from Data through Excel (Tools and formula).

Handling multiple reports, working with formulas, pivot tables & pivot charts, and various other excel sheet components for accurate data.

Can deal with formulas in Excel, Numbering Formats.

I am good at Pivot Table, Vlookup, Hlookup, and Index & Match, etc.

I am good knowledge at logical in Sum If,Sum IFS, Count If,Count IFS,Average If, and Text functions like upper,Lower, Concatenate and Paste Special Options.

Ensure deliverables (Daily, Weekly & Monthly MIS Reports) are prepared to satisfy the project requirements cost and schedule.

Prepared Proactive checklist for database & important work to avoid future downtime.

Interacting with client directly through scheduled daily / weekly Business Conversation (Email).

We receive various data from client like BJBD, CRPF, Salary Invoice, Salary Deduction, DD, CC, IDR, and ECS and will scrutiny the data, Met all the customized and adhoc requirements on timely basis

Jul’2011 – Aar’2017: Manappuram Finance Ltd.

Growth Path

Jul’2011 – Feb’2013: Junior Officer

Mar’2013 – Oct’2013: Assistant Branch Head

Nov’2013 –Mar’2017: Internal Auditor

Role: Junior Officer

Gold Appraisal

Gold packing

Cashier

Maintain good relationship with customers

Update information to customers through SMS and Phone.

Role: Assistant Branch Head and Internal Auditor

Give warm welcome to prospective customers. Share the information about company schemes and provide the clarification for customer queries.

Assists the prospective customers in applying for Gold loans.

Explain to customers Terms and Conditions of the Company.

Maintain a healthy relation with bank and customers.

We maintain the joint custodian keys the 1st joint custodian key maintained by Operations manager and the 2nd joint custodian key maintained by G.L.O.

G.L.O maintains all the operation rules in the branch.

Implementation and adherence to the credit policy

To execute eligibility check, Credit Appraisals, Credit Deaccessioning, Document screening and loan Approval processing.

Portfolio Monitoring and Performance analysis of sourcing channels.

Maintaining of quality Login and Disbursement.

Delinquency Analysis to highlight out the stressed sourcing Channels.

TAT monitoring, Maintaining in reduction of Processing Cost, Non-discrepancy check for all disbursement files & dockets and ensuring all documents collected coincide with policy requirements and hence avoiding a hind sighting error in the disbursal process and maintain accuracy.

Ensuring Quality on Gold Valuation, Gold Packet reconciliation and Gold Audit.

Handling Usage Monitoring of High Exposure customer.

Bill Generation and Dispatch.

Preparing and maintaining reports- MIS.

Checking of gold and estimated purity percentage of gold.

Verified every transaction of Cash and sanction loan forms and customer KYC forms.

Gold Appraisal and assessment of eligible loan amount basing on the quality of gold ornaments pledges.

Educating the customer on various schemes of the company and guiding him in selecting suitable scheme.

Verifying the gold and cash as per company software(Dot net)

Received the Best irregularity finder (internal Auditor) Award in recognition of Manapuram Finance Ltd.

EDUCATION

Business Administration M.B.A in Finance & Marketing from KONERU LAKSHMAIAH COLLEGE OF ENGINEERING (K.L.C.E) affiliated to Acharya Nagarjuna University, during 2006-2008 in first class.

Bachelor of Arts Degree in B.A (H.E.P), from Govt. DEGREE College, PAMARRU, during 2003-2006 in second class.

IT SKILLS

MS Office, Advanced MS Excel, Internet Applications.

PERSONAL DETAILS

Name : M VENKATESWARA RAO

Father’s name : GOPALARAO

Date of birth : 31-05-1986

Gender : Male

Nationality : Indian

Languages known :Telugu, English, Hindi

Strengths : Sincere, Hard Working and Result oriented

Marital Status : Single.

Hobbies : Chatting with friends, Listening music.

I request you to be kind enough to consider my candidature and give me an opportunity to serve in your esteemed organization in the capacity mentioned above for which act of kindness I shall be very thankful to you.

PLACE :

DATE : (M.VEKATESWARA RAO)



Contact this candidate