MIS, excel and ms access

SARAVANAN T.V

Mobile: 893-***-**** E-Mail: *****************@*****.***

Seeking assignments in the field of Management Information System with organization of repute

Location preference: Chennai

Synopsis

Spearheaded a team of 10 members at AVON GLOBAL SOLUTIONS Private Ltd, committed to deliver with quality.

Managed to meet all deliverables on time to satisfy the client requirement.

Provide End to end solutions right from procuring data from clients, processing data, delivering the product and investigation on all queries raise by clients.

Gained complete knowledge on MIS through the exposure which I got through my experience, where I can deliver Tailor made reports and statistics as per the requirements.

Played key role in the team by providing solutions from end to end in the process.

Work Experience (11 years Overall)

10 years of Experience at AVON Global Solutions Private LTD (Chennai) from June 2006 to June 2016, where last 5 years as Team Leader (Senior MIS Executive).

1 year as Accountant in Mahadeva Ayurvedic Hospital from 2005-06.

Software Skills

Microsoft Access - Macro/Report/Form.

Microsoft Excel, Word, Power Point.

Microsoft Excel/Word – Macro, Mail Merge.

SQL Database.

Visual Basic knowledge (basic level programming).

KEY SKILLS

IT Exposure: Creating database in MS Access for all departments for dispatch process and MIS preparation.

Handling of more than 10 lakh to 15 lakh data per month used for MIS preparation, reconciliation, query handling, analyzing, tracking etc…Creation of more than 1000 tables and more than 1500 query and macros in MS Access & SQL database for future referral which helps in stabilizing the process.

MIS Executive: End to end reconciliation of MIS given by various teams, post which MIS is presented to the billing team. Process knowledge on Banking products from base level to end.

Banking Operation: Handling credit/debit cards, cheque books, deposit slip, drafts/vouchers, all the statements for both credit/debit and the entire Banking customer’s letter dispatches/tracking/reporting/mis/analyze/reconciliation/data validating, and then the query resolving and escalations handling and make sure that the issues are resolved and requirements are met. Operation gaps identification & process set up. Troubleshooting or identifying errors. Devising control measures to prevent the recurrence of the error. Tracking Employees Productivity and maintaining report (KPI) on daily basis.

Billing: Formulated Billing Invoices Validation. Prepared Billing Data triangle wise tally.

CAREER REVIEW

AVON GLOBAL SOLUTIONS May 2011 – June 2016

Team Leader (MIS-Banking)

All the below activities are performed and incorporated through MIS.

Preparing and maintaining the Dashboard periodically.

End to End tracking of the process (From Generation to Destruction).

Enhanced the process of Mail Management by responding to the emails promptly on timely manner.

Reconciliation of volume and statistics presented by dispatch and Tracking team.

Process skill sets and ability to initiate, improvise and streamline a new or existing process in an effective and timely manner.

Reconciliation of all the key data, which involves identifying the errors. It also involves identifying root cause of the errors, impact of errors, and effective way to resolve the issue.

Company Productivity ups & downs report Maintenance.

Handling all the escalations and make sure that the issues are resolved and requirements are met.

Training all the new employees about the process and allocation of work based on their skills.

Improvised Plastic artwork design validation, Supervised Plastic quality and Purchase Order., Forecast Provision preparation, Expense Liquidation preparation, Maintain plastic consumption MIS, which is used to forecast the amount of plastic required in future.

Initiating and facilitating the Payment Process, Maintenance of SF for payment.

Preparation of data for provision retrieval and allocation.

Overall billing through MIS.

Tracking team members in and out time on daily basis.

Employees Error Tracker Maintenance.

AVON GLOBAL SOLUTIONS April 2009 – April 2011

Senior Processing Executive (Banking Operation)

Resolving queries from client through email and SLS.

Tracking and analyzing the performance of the employees through the data obtained during out scan. Productivity of employee on hourly basis is obtained using this report.

Implementing Quality Checking & Quality Auditing to ensure deliverables are met as per standards.

Develop Courier Performance Report through MIS. It involves capturing the time taken by the vendor to meet his deliverables, calculating his performance. Reports are delivered to the clients for their analysis.

Maintaining of no due certificate post payment.

Formulating TAT Preparation. It involves the tracking of turnaround time taken by the courier to procure the product, delivering the product and acknowledging the delivery, TAT preparation for generation level, dispatch level, delivery level, RTO level, Re-dispatch level and files received from vendor on data and time level.

Percentage level TAT/MIS preparation.

Maintenance of dispatch and delivery tracker of all products through DB and excel macro.

Preparation of notepad manually by using formula for entire Banking products.

Maintained the data of all customers on products basis.

One View Tracking used for extracting the data of all clients serves as single point of data extraction, which can be utilized for query handling.

Performing QC and QA before dispatch of letters.

Creating process notes for entire projects and submit to the management.

Implemented Data validation. This is performed to check data duplication, incorrect data etc.

Validating the MIS prepared by other departments based on the data available.

Maintaining MSB scrubbing report for ICG, RBI, and NBFC.

Pioneered the Queue Management System, Preparation of QMS Report Branch level, date wise, service and teller wise. This report is used to analyze the performance of the branch.

AVON GLOBAL SOLUTIONS June 2006 – March 2009

Processing Executive (Banking Operation)

Handling Banking operations/dispatches which involves credit cards, cheque books, debit cards, all Bank statements.

Handling GF/ELC (corporate account) cheque books dispatch and query handling.

Receiving customer data and performing mail merge to perform printing.

Company dispatch volume Maintenance.

Generate and maintaining Daily process report tracker.

Call Center Campaign facilitation through MIS. It involves spotting the undeliverable product to the customers and facilitating the calls to the customers to redeliver the product and Agent’s MIS is prepared.

Time taken for satisfying the customers through calls is recorded and reports are generated.

Coordinating Base allocation for calling.

Generate and maintain Stock Maintenance Report/MIS.

Improvised Client Interaction, mail coordination and follow-ups.

Mahadeva Ayurvedic Hospital May 2005 – April 2006

Junior Accountant

Buying medicine through Emails.

Staffs salary allocation and leave records maintain.

Handling and process cheuqe deposit in Bank.

Handling patient’s inventory and type of decease.

Academia

BSC Computer Science (Manonmaniam Sundaranar University) from S.T. HINDU COLLEGE, Nagercoil, Kanyakumari (Accredited by NAAC with B +) in April 2005 obtaining 60%.

Higher Secondary Examination from Higher Secondary School Bhuthapandy, KanyaKumari in May 2002 securing 63% in core-subjects (Computer Science group).

Secondary School Leaving Certificate from Govt High School Arumanallor, KanyaKumari in June 2000 securing 70%.

Accomplishments

Best Performance Award in AVON for extraordinary performance done on MIS in the year 2009.

Appreciation from senior manager AVON for following up on an issue for 3 months and resolving it with great satisfaction from client.

Received appreciation from VP of CITI BANK for presenting MIS and confidentiality report for audit purpose.

Received appreciation and award from Managing Director of the Organization for extraordinary performance in Client Calls.

Attended four to five meetings with CITI Bankers for preparing the complicated MIS report completed successful and got appreciation for the same.

Received NATIONAL SERVICE SCHEME Certificate, participated in the Ten Day Special Camp on Water Resources & Human Resources.

Received NATIONAL SERVICE SCHEME Certificate, participated in the Ten Day Special Camp on Environment and Rural Development.

Achieved Tamil First Class Certificates in Tamil.

Achieved many Social Service certificates.

Participated in inter school speech competitions.

Donating Blood more than 10 times and I got Certificate from INDIAN RED CROSS SOCIETY (Kanyakumari District Unit)

Personal Dossier

Father Name : S. Theivanayagam Pillai

Sex : Male

Nationality : Indian

Languages Known : Tamil, English& Malayalam (Verbal & Written)

Point of reference

Name : S. Bala

Designation : Senior Manager (AVON Management Staff)

Contact No : 984*******

Declaration

I hereby declare that the information furnished above is true to the best of my knowledge.

Place : Chennai Yours Sincerely

Date : Saravanan T.V

Contact this candidate