Current Location: Pune Mobile:+91-744*******
5.8 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 : Senior Process Associate
Working on daily work allocation. created various spreadsheets & multiple macros using advanced Excel, VBA (Macro) and SQL queries.
Submitted & implemented 5+ bright ideas for process enhancement.
supporting to process automation and created various excel tools for process enhancement.
Worked on various reports, Process transition, Policy endorsements.
Data analysis & Research using tools like Mainframe, Alliance, Nextgen etc. also worked on Premium Increase Notice (PIN), Endorsements, and Policy premium calculations using various Excel raters.
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 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, Power BI.
OTHER SKILLS AND KNOWLEDGE:
Completed Business Analyst using Power BI from Ederuka.
Completed Allstate Insurance Foundation Certification from Allstate Insurance Domain Academy (AIDA).
Completed Excel Certificate from Corporate Finance Institute (CFI).
Good in team Handling & Leadership skill.
Quick Lerner, Strong verbal communication, Self-motivated.
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)