Tarun Singh

An MBA & Commerce Grad. working as a Data Analyst with 4+ years of hands-on experience interpreting and analyzing data in order to drive successful business solutions using Advanced Excel. Excellent understanding of business operations and analytic tools for effective analysis of data. Proficient in logical thinking and various data modeling techniques.Excellent client management and engagement skills.

Effective presence & communication skills- both interpersonal & written and the ability and willingness to take a hands-on execution role where required to support client needs and team development.

Data Analyst

SBI Card · Full-time 

Dec 2021 - Jul 2022

Gurugram, Haryana, India

1. Design, Evaluate, Standardize Modify VIC models as per business requirements across functions and geographies.

• Study performance trends to identify issues /model enhancement opportunities and share recommendations for change with the management.
• Evaluate impact and Final roll out of changed models post-approval from authorities
• Evaluate new processes for VIC Onboarding basis meeting the necessary criteria of VIC onboarding and benefits to the organization.
• Coordination with respective functions stakeholders (Monitoring team, CB team, etc.) for all data requirements for processing and Headcount management for FTEs /NFTEs for VIC eligibility, VIC / Bonus mapping.
• Monthly VIC processing for aligned functions within defined timelines with 100% accuracy and submission of final VIC payout post requisite validation approvals.
• Ensure adherence to the maker and checker approach and approval matrix in processing all VIC and contest payouts in a timely and accurate manner.
• Responsible for preparing VIC input data like productivity reports, Roster Attendance related inputs for VIC processing.
• Liaise with respective function to gather contest construct proposals in the structured format ensuring submission of final payout in the defined format post matching the output with the other team member.
• Ensure adherence to the standard checklist to evaluate the Contest.
• Analysis of data based on last 3-6 months' trend across teams, roles, etc, and simulations to be done for decision making.

MIS (Management Information System) Executive

Satguru Travel and Tourism Services

Full-time Oct 2019 - Oct 2021 · 2 yrs 1 mo

Ajmer, Rajasthan, India

• Analyzing data using statistical techniques and providing reports

• Developing and implementing databases and data collection systems
• Acquiring data from primary and secondary sources and maintaining data systems
• Identifying, analyzing, and interpreting trends or patterns in complex data sets
• Filtering and cleaning data
• Working with management to prioritize business and information needs
• Locating and defining new process improvement opportunities
• Preparing various reports using, Pivot Table, Pivot Chart, Filters, Formulas, Data Tools, Conditional Formatting, Data Validation, and Graphical Representation.
• Setting up employee sales targets on the basis of month-on-month analysis.
• Responsible for maintaining accurate database and reports in excel to support and drive the performance of the Customer Services function.
• Prepare automated excel sheets with Power Query linked directly from the database.
• Preparing Ad-hoc reports catering to the requirements of the operations team.
• Liaison within and outside the organization for data pertaining to Employees targets, Employees Scores
• Preparing Incentives for employees on monthly basis.
• Preparing Monthly Performance Dashboard of employees.