Current Location: Pune Email:email@example.com
5.5+ years of experience in Reconciliation, Data Research and Analysis, Auto & Property Insurance Operations, MIS Reporting and Automation.
Worked as Audit specialist at Yardi Software Solution.
Worked as Financial Analyst at Syntel India.
Strong Analytical skills, Computer knowledge, Reporting skills and excellent in interpersonal relationship and in problem solving.
1)Name of the Organization : Allstate Solution Pvt. Ltd. Pune
Duration of the Job : July 2016 – Till date
Position Held : Process Associate
Responsible for Reporting, Process transition, handling team queries with Onshore. Customer requests handling, Policy endorsements.
Working on reporting for team, daily work allocation. Worked on advanced Excel, VBA (Macro) and SQL queries to generate report. Supporting to process automation and created various excel tools/spreadsheets for process enhancement.
Worked on Research using tools like Mainframe, Alliance, Nextgen etc. also worked on Premium Increase Notice (PIN), Endorsements, and Policy premium calculations using various Excel raters (Spreadsheets).
2)Name of the Organization : Yardi Software Pvt. Ltd. Pune
Duration of the Job : June 2014 – June 2016
Position Held : Audit Specialist
Used advanced Excel functions and SQL queries to generate report, worked on Automation using Advanced excel (VBA).
Worked on Audit, Reconciliation, Data handling, Data Analysis & created spreadsheets.
Supported on system setup for new Client/Vendor/Property & Co-coordinating with Development, Implementation and testing team for product enhancement.
3)Name of the Organization : Syntel India Pvt. Ltd.
Duration of the Job : Feb 2013 – Sept 2013
Position Held : Financial Analyst
Worked on share Reconciliation. Research on financial data by using different tools like MCH, E-Horizon and Bloomberg to find cause of unsettled trade.
Achieved daily deadlines and sent reports to clients.
Worked on excel to process, maintain data. Filling MIS Report.
Master of Business Administration (Finance) from Amravati University in 2012.
Bachelor of Science (Comp. Science) from Amravati University in 2009.
HSC from Maharashtra State Board in 2006.
SSC from Maharashtra State Board in 2004.
Scripting Languages : VBA, SQL
Database : MS-SQL Server
Others : MS-Office (Advance Excel). Software Installation,
Operating system Installation, Tableau/Power BI (BI Tool), Informatica (ETL Tool), VBA Code Generator.
OTHER SKILLS AND KNOWLEDGE:
Completed Allstate Insurance Foundation Certification from Allstate Insurance Domain Academy (AIDA).
Completed Informatica (ETL) tool training and certification from Radical Technologies.
Certified AML-KYC Compliance Officer from V-Skills (Govt. of NCT, Delhi).
Completed Excel Certificate from Corporate Finance Institute (CFI).
Quick Lerner, Strong verbal communication, Self-motivated.
Good knowledge about VBA Code generator new tool.
Good in team Handling & Leadership skill.
Date of Birth : 31/01/1989
Gender : Male
Marital Status : Married
Father’s Name : Mr. Narayanrao W. Khandare.
Address : Charholi Bk. Pimpri Chinchwad, Pune, MH – 412105
Languages known : English, Hindi, Marathi.
Passport No. : J3366364.
The information provided here is true and to the best of my knowledge.
Place: Pune (TUSHAR N. KHANDARE)