Pavithra K
Coimbatore
Summary
A motivated and skilled professional with six years of comprehensive experience, seeking a dynamic role where I can leverage my expertise in Excel macros to drive process efficiency and data automation. Adept at creating innovative solutions to streamline workflows, my goal is to contribute to a forward-thinking team, utilizing my advanced skills in macro development to enhance operational excellence and deliver impactful results.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Associate
Ford Credit Europe (Banking)
10.2022 - Current
- Managed customer information throughout the contract lifecycle, adhering to banking and financial service regulations
- Demonstrated proficiency in customer response, addressing inquiries and concerns with professionalism
- Maintained confidentiality and compliance with data protection policies while handling sensitive customer information.
Operations Analyst
Ford Credit Global Business Center
01.2017 - 09.2022
- Efficiently managed the cancellation of add-ons for customer vehicles, ensuring a seamless process
- Expertly tracked dealer reserve statements and customer accounts, identifying and resolving discrepancies promptly
- Employed various reconciliation methods to address dealer discrepancies, maintaining financial accuracy
- Collaborated with Ford car dealers in the US to resolve queries and address cost discrepancies, demonstrating problem-solving skills
- Responsible for managing the insurance claim process and canceling services contracts, showcasing a comprehensive understanding of insurance procedures.
- Conducted thorough credit bureau reviews, ensuring compliance with financial regulations
- Facilitated the smooth transfer of vehicle ownership, demonstrating meticulous attention to detail
- Rewrote contract details for customers opting to extend credit terms and reduce monthly installments, showcasing flexibility and customer-centric service.
Education
MBA -
Bharathiyar university
12.2018
B.Com CA -
Sri Krishna Arts and Science College
12.2016
Skills
- Excel Formula and Macro's
- Sharepoint list
- Power Apps
- Problem solving
- Email handling
- Customer service response
- HTML
- CSS
Accomplishments
- Asia Pacific Award 1. Asia Pacific Recognition Award for Excellent Productivity and Quality in TOE LA Process. 2. Asia Pacific Recognition Award for Seamless transition of additional states in AOC & SLA delivered with 100% increase in volume with quality.
Languages
Tamil
Advanced (C1)
English
Upper intermediate (B2)
Hobbies and Interests
- Movies
- Drawing
- Art and crafts
- Songs
Projects
NSC Projects:
Developed a macro file to automate the extraction of data from diverse text files into the NSC template. This innovative solution streamlined the process of comparing funding and manufacturing amounts, enhancing efficiency and accuracy in financial analysis. Total time saved 30 mins for a day SARNS Letter:
Designed and implemented a system wherein a Word file dynamically pulls information from Excel, generating customized letters based on intricate details stored in the Excel database. Total time saved 2mins for a letter.
Metrics File:
Created a metrics file for the team to track the daily productivity Working File and comment sheet Template, Developed a Excel file for the team, enabling seamless extraction of data such as account numbers, business center details, and customer names from copied values within the application. Rejection sheet:
From Ondemand cmod text file, prepared a macro file to pull only the rejected items from Credit report. Total time saved 10 mins for each location
Certification
Workshop on Power BI developer
Timeline
Associate
Ford Credit Europe (Banking)
10.2022 - Current
Operations Analyst
Ford Credit Global Business Center
01.2017 - 09.2022
MBA -
Bharathiyar university
B.Com CA -
Sri Krishna Arts and Science College
Similar Profiles
Jack AbbottJack Abbott
Senior Finance Analyst at Ford Credit EuropeSenior Finance Analyst at Ford Credit Europe
Mohd ArbabMohd Arbab
I Am Accountant at BankingI Am Accountant at Banking
Ram GowthamRam Gowtham
Team Leader, Compliance Operations at Ford Motor Credit Company (Ford Motor Pvt Limited)Team Leader, Compliance Operations at Ford Motor Credit Company (Ford Motor Pvt Limited)