Case Management Sql Database
Resume:
Dharmveer Kandari
E-mail: ****************@*****.** DOB: 01st March1987 Mob:+917*********
PERSONAL SUMMARY
Looking for a switch from Retiree Payroll to Active Payroll and has taken number of initiatives from getting training on SQL application to completing the Advanced Excel certification.
A polite, friendly and sociable person who can coordinate the flow of work around an office, and provide support of the highest caliber. Dharmveer can keep a cool head in busy, complex circumstances and is the kind of person who inspires others to work to their optimum.
Achievements:
•Overview and basic use of RPA tool
•Earn the badge of Microsoft Access basic training
•Certified Green Belt in Quality.
•Bagged star of the month award.
•Certification in SQL database.
Equity Derivatives Certified
Commodity Market Certified
CAREER HISTORY
Company Name: CONDUENT
PAYROLL ANALYST
Tenure: From – July 2022 till Now
Profile: Key responsibilities perform are as follows:
Validate member records and process payroll
Manage Case Management que of member complex request
Run calculation and validate through automated excel sheet
Support compliance and audit requirements, completion of mandatory/recommended trainings
Update Internal trackers i.e. query, exceptions, processing calendars, etc.
Effective communication through email and adherence to calendar for client calls.
Meeting all the process SLAs external & internal(Accuracy as per Process target & TAT 100.00%)
Active participation in client & transition calls and Update SOP\documents as & when required.
Skill/Domain knowledge enhancement by learning new processes/clients- Cross Training.
Company Name: MERCER/ Life Works (Morneaushepell INDIA Pvt. Ltd.)
Process Developer
Tenure: From – August 2021 till February 2022
Profile: Key responsibilities perform are as follows:
Validate member records and process payroll
Manage Case Management que of member complex request
Run calculation and validate through automated excel sheet
Support compliance and audit requirements, completion of mandatory/recommended trainings
Update Internal trackers i.e. query, exceptions, processing calendars, etc.
Effective communication through email and adherence to calendar for client calls.
Meeting all the process SLAs external & internal(Accuracy as per Process target & TAT 100.00%)
Active participation in client & transition calls and Update SOP\documents as & when required.
Skill/Domain knowledge enhancement by learning new processes/clients- Cross Training.
Senior Analyst
Tenure: From – May 2019 till July 2021
Profile: Key responsibilities perform are as follows:
Managing the work que of member complex request through Case Management application
Do processing of the request in tandem of SLA of clients.
Doing end to end follow through of the service request with the Customer/Clients
Allocation of the work within the team and escalate the request.
Managing the weekly inventory and sharing the dump data with management
Maintains & update the Standard operating procedure of the clients.
Automate the Excel for Interest and Empcom calculation.
Started Own Medical Care Company from June 2016 till December 2018
Company Name: MERCER INDIA Pvt. Ltd. Senior Analyst
Tenure: From – October 2015 Till May 2016
Profile: In the capacity of Sr. Analyst I perform the following responsibilities:
Processing Benefits transactions of the participant within the stipulated time.
Processing demographic changes of the participants.
Validate incoming documentation and complete processing participant request or send back to them if the documentation is incorrect or incomplete.
Process workflow from client specific query received via Siebel in request for further re-search.
Preparing pending and on-hold reports.
Company Name: Aon Corporation. Process Advance (SME)
Tenure: From – February 2013 Till January 2015
Duties;
Process Management:
100% adherence to turnaround time & service level agreements as prescribed for each defined process
Working on health management domain and expertise of handling edits
Providing domain sessions to new hires and allocating work and maintaining equal work distribution
Submitting several process improvement ideas which helped saving time in a given process& meeting month productivity target as required.
Client Handling:
Handling critical clients like Bank of America, AT&T and U.S Bank
Managing client escalations/reverts on an ongoing basis
Updating and auditing SOPs as per client requirements
Initiating to improve the process which helps to reduce time of processing
Conducting internal audits to help associates to improve their performance
Initiative:
Trained on ETRM/CTRM application Such as Endur
Sound knowledge on risk management practices such as Delegation of Authority, Deal Monitoring, PnL reports etc.
Knowledge on cMotion i.e. creating Nominations, moving volume to Actualization
Aware of Physical & Paper Deal Life Cycle in ETRM software
Good knowledge on common Oil and Gas Industry practices
Automated variance report of associate productivity through VBA
Developed the layout of the ‘Month Till Date Dashboard’ in Power BI
Created the Quality management tool for error analysis on access platform which was implemented cross Line of Businesses.
ACADEMIC QUALIFICATIONS
University name
Degree details
Study Dates
IHM Gwalior
Bsc. In hospitality
2006-2009
Adarsh Public School
Commerce
2004-2005
Mewar University
MBA International Business Mgt.
20015-2016
Professional Certifications:
Certified in LEAD (Leadership and Ability Development Certification) Program
Certified in Disaster Management and Fire Safety by Safety Circle, USA
Training:
6 months industrial training from Centaur Hotel, New Delhi in the core hotel departments, in 2008 Workshops:
Interactive session on “Corporate Expectation and Orientation “by Sandeep Sharma- Vice President of Earth Infrastructure
Interactive session on “Banking Industry and the Changing Dynamics” by Mukul Mahajan- Associate Vice President of Kotak Mahindra Bank
Personal Strength
Organized Problem Solving Skills
Good Listener Multi-Tasking
Positive Attitude Proactive Personal Information
Marital Status : Married
Nationality : Indian
Language Proficiency : English &Hindi
Computer Skills : MS Excel, MS. Power Point, MS. Word, Microsoft Access, Outlook and Siebel
Contact this candidate