KAPIL KUMAR BHARDWAJ

880-***-**** adlf9e@r.postjobfree.com V-10, Uttam Nagar, Delhi, New Delhi,

110059

CAREER OBJECTIVE

Asst. Manager with over 6+ years of experience in MIS Reporting & Analysis. Seeking an opportunity to leverage my diverse skills and experience in data mining and analysis into the open data analyst position at your company. working with Travel Triàngle as an Asst. Manager, taking care of Diagnostic Reports, MIS Reporting & Analysis department for International Suppliers. I am using Advance Excel, VBA, Macro, SAP CRM & SQL for reporting purpose.

PROFESSIONAL EXPERIENCE

Tra vel Tria ngle P vt. L td June'18 to

Dec'20

Ass t. Mana ger // MIS & Pa ymen t

• Handling the Supplier remittance (International Payment), Agent Payments

(India), and finance related activities.

• I am having 10 peoples in my team which reports to me directly.

• Agent Reconciliation, Bank reconciliation, Account Receivable, Data management, Agent recovery, Non-TT Collection from Agents, Credit control, Coordination with supplier and Agent, Auditing, Account payable.

• Invoice processing for the payment after validation, Upload in system tom final check from finance side.

• I manage entire issue which comes from Supplier & Agent side related to payment, reconciliation, Bank issue, Billing issue, Invoicing issue, payment issue, GST issue, etc.

• Payment Marking, Agent invoice creation, Document validation, Agent Profile Verification, Bank documentation for Remittance like PAN & Passport validation.

• Manage the master data of remittance and share with management with proper summary, Share profit and loss report which depend on ROE(Rate of exchange) fluctuations.

• Handle review meeting with Higher Management related to payment and MIS team.

• I have to share reports to vendors, Agents & Management. Like Cost vs Actual, PNL Reports, variance Analysis, Agent Payment Flow, Supplier PNL Report, Supplier Remittance Report, Non-TT Collection Report, Agent Recovery Report, Account receivable report, Target vs Acheivement, Incentive Reports, Contry wise Report, Manger's, AM's & TL wise report, Travel Adviser wise report, Weekly, Monthly, Quarterly & Annual reports etc. & Ad hock reports which comes from the country head, Destination wise report, Supplier Pendency report, etc.

• Prepare prsentation for Team & Vendor's for the review with management.

• I am using Advance Excel, VBA, SQL for reporting.

• I have got “TOPCHI Award for Q2 & Q3 FY2018-19 for managing and running the Finance team. This is One Man Army Award.

Livpure Pvt. Ltd., Gurgaon, HR May 2017 – June’18

Service Analyst II Livpure – RO Service

• I was handling PAN India reporting & Analytics part for RO Service Department.

• Mostly creates the reports for Senior management review only.

• I had so many reports like TAT reports, Call Reports, Pendency reports, Revenue Report, ACMC report, Leads Reports, etc.

• I had to done coordination with cross functional teams like R&D, Finance, HR, Plant team, Material team, Purchase team, TRC team, Development team.

• Analysis part – IW failure, Part Failures, TAT issue, Revenue issue, based on data I provide insight to my reporting manager (Service Head) for take corrective action to resolve issue.

• Incentive reports, Scheme reports.

• Daily Infant failure report.

• AOP (Annual Operating Planning), Manpower Planning based on call ratio like where need to appoint service partner or Service Engineers.

• Conversion report based on opportunity, planning for improve conversion, provide insights to respected Zonal Head.

• Engineer performances, Partner performances, vendor management.

• Yearly report – P&L report, Plan vs actual costing. Times Business Solution, Noida, UP May-2014 – May’2017 Off Roll- Team Lease Services Pvt. Ltd.

MIS Co-Ordinator – Department - Sales

• Getting the RAW data from the analytic tools like SAP, AVAYA, CRM, etc., and compile this data on Excel sheet then generating the reports.

• Create sales report of PAN India on Daily, Weekly, Monthly & Quarterly basis, and published this with National Sales Head & Team.

• I had created the report for multiple vertical of Times likes Times Job, Simplymarry.com, Magicbricks.com, Adds2book.com, Techgig.com.

• Prepared the review report and presentation for every regional head with analysis of sales and had to provide insight based on data.

• Distribute of sales report with different formats like City wise, function wise, RM wise, ZSM & ZM wise, Account Manager wise.

• Prepared incentive & schemes reports.

• Coordinate with cross functional team like Finance, Vendor management, HR etc.

• I was using Advance Excel, VBA, SAP CRM & SQL for reporting part. PROFESSIONAL ACHIEVEMENTS

• Awarded for Prominent Performer for the Qtr. JFM’16 in Times Business Solution.

• Awarded for Prominent Performer for the Qtr. AMJ’16 in Times Business Solution.

• Awarded for “TOPCHI” for the Qtr. JAS & OND’18 in Travel Triangle. EDUCATION

Highschool 2008 from UP Board

Intermediate 2010 from UP Board

Graduated with Computers BCA 2013 Agra University Master With International Business ! M.B.A 2015 SMU Advance Excel Certification from Infotech

TECHNICAL SKILLS

• VBA- Visual Basic Application with Excel

• Microsoft Excel- 2007,10,13 & 16.

• VBA Automation, User forms, Macro (Create, Edit, Update and Delete).

• Data Validation, Data Management, Data Analysis, Data Mining, Data Cleaning.

• Conditional Formatting.

• SQL Query (Select, Update, Delete, Joins, Insert, Where, Like, etc.).

• Database Development Query (Create, Drop, Delete, Validation, Design, etc.).

• Manpower Planning, Rostering, Leave Management,

• HR MIS (Payroll Report, Attendance Management, Appraisal Report, Employee Data Management, Vendor Management, etc.).

• Payroll, TA/DA Pay out, Finance Planning, Cost Analysis, Budget Analysis.

• BPO Reports (Shrinkage Attrition, Utilization, ACHT, Quality Reports, Agent Productivity Reports, etc).

HR Analysis ( Attendance Report, New Hire Budget/Analysis, Terminations Budget/Analysis, Paid Leave Analysis, Leave Administration, Status Change, Recruiting conversion rate, Employee Performance, Employee productivity,) Profession Training

• Advance Excel Diploma from Infotech, Sec-2, Noida-201301

(Related topics: MS Office Excel advance (SUM,COUNT, COUNTA, COUNTBLANK, AVERAGE, MAX, LARGE, MIN, ABS, SUMIF, COUNTIF, SUMIFS, COUNTIFS, LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, CONCATENATE, AND, OR, DAY, YEAR, TODAY, FIND,SEARCH, VLOOKUP, HLOOKUP, MATCH, IFERROR, IF, INDEX, OFFSET)

Contact this candidate