Sunny Kumar Benbanshi
Data Analyst
Ghansoli
Summary
13+ years of Diversified experience of Data Analytics & MIS reporting in sectors like insurance, asset management, Technology, Manufacturing. Good knowledge of MS-Office especially working with excels. Excel automation with reporting and data analytics. Strong knowledge of excel formulae's like V-LOOKUP, H-LOOKUP, Conditional formatting, Pivot table, IF-Else Condition and other formulae's of excel. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Analytics Manager
Reliance Industries Limited
11.2016 - Current
- Prepare, publish and track KPI's & SLA's around recruitment on monthly, quarterly and yearly basis
- Accomplished multiple tasks within established timeframes.
- Prepare and conduct business reviews on Weekly and Monthly basis with TAG leads & Stakeholders
- Forecasting of resource hiring for upcoming financial year based on historic data available
- Publishing hiring updates to recruiters across PAN India on daily basis
- Delivering Ad-Hoc reports within minimum possible timeline
- Providing analysis and insights on recruitment to CHRO and TAG leads as and when required
- Manage, track and report on various hiring projects for manufacturing sites across India including medical hiring for COVID-19 pandemic
- Successfully managed the end-to-end hiring cycle on project hiring from sourcing until vendor invoicing.
- Maximized performance by monitoring daily activities and mentoring team members.
- Managing RPO hiring model through Quess Corp. Ltd.
•Presently 20+ resources from Quess are directly reporting to me.
•Overlook the entire lifecycle from Joining till Exit for Quess resources.
•Review performance of resources through KPI’s and action accordingly. - Vendor Payment Management:
•Vendor payment processing through SAP.
•Candidate joining confirmations to vendors.
•Invoice processing using SAP model.
•Vendor ARC & PO coordination with P&C.
Senior MIS Executive
Samsung India Electronics Limited
08.2015 - 11.2016
- Preparing HR Master Database on weekly basis and reconciling the same with Resource Management Team
- Preparing Resource MDB, Hiring Report, Quality MDB and Organization Chart on weekly basis and sharing the same with Korean counterparts
- Consolidating the resource data from PAN India of Samsung regional HR's and communicating with them for any change in Master Database
- Coordinating with Circle Head & Deputy Circle Head across 26 circles across India for any activity based data
- Preparation of any Ad-Hoc reports asked by reporting manager and Director (HR).
- Contributed to strategic planning sessions by providing critical business intelligence derived from detailed data analysis.
- Streamlined report generation for improved decision-making with efficient data extraction and analysis techniques.
- Planned and led administration of management information system for achieving threshold-level performance.
- Collaborated with IT teams to ensure seamless integration of MIS tools and applications into existing company-wide systems.
MIS Executive Asset Management
Deutsche Bank
03.2013 - 07.2015
- Assign and deploy IT & Non IT assets requested by users using DB Symphony tool
- Post asset deployment, assign request to IT team for further installation
- Pull out the raw data from organizations system software to prepare reports
- Preparing MIS reports from raw data on daily, weekly and monthly basis and share it with client directly
- Responsible to collate the data from PAN India branches of organization to prepare a central MIS report and share it with client
- Preparing Daily Deployment tracker, IT Asset Tracker, Weekly report, Reconciliation file
- To prepare any ad-hoc reports as and when demanded by client within the timeline
- Physical verification of IT and Non IT assets for all Mumbai & Navi Mumbai locations twice a year
- Allocation, Management, Procurement and tracking of IT & Non IT assets
- Barcode printing through Barcode Tender software and assigning barcode to new and old assets
- Assisting clients in annual Audit of asset allocation and tracking.
- Produced tables, pivot reports and charts for use in key decision-making processes.
- Generated reports each month covering asset data.
Sales MIS-Executive
Andromeda BPO Pvt. Ltd.
- 12.2012
- Managing sales data of insurance policies sold on daily basis
- Maintaining various MIS reports like Agent wise, Process wise, TL wise, Verifier Dashboard on daily basis
- Preparing incentive report, agent roaster, sales report, monthly review, Total sales report, agent attendance and attrition etc
- Cleaning raw data of insurance policies and uploading it in system database for calling
- Processing of insurance policy cheques and MIS report related to cheques.
Education
B.COM - Commerce
Mumbai University
Mumbai, India10.2012
H.S.C. -
Gurukul Junior College of Commerce (Maharashtra Board)
06.2006
S.S.C. -
Shivam Vidya Mandir (Maharashtra Board)
06.2004
Skills
MIS
Business intelligence tools
Information Security
Network Administration
Advanced Data Analysis
Microsoft Power BI
Advance Excel & Automation
Microsoft SQL Server
Additional Qualification
- Microsoft Power BI
- Basic knowledge of Microsoft SQL Server
- SAP End User knowledge
- Success Factor
- DB Symphony for Asset Management
- Tableau End User knowledge
Awardsrecognitions
- HR Achievers award for explicitly supporting on managing and coordinating for hiring data of medical personnel's during COVID pandemic.
- 2 Performance Recognitions by reporting manager in 2023.
- 1 Recognition received by Stakeholder for extended support on data in E&P business.
Personal Information
- Location Preference: Anywhere in India
- Date of Birth: 03/15/88
Languages
Hindi, English, Marathi
Upper intermediate (B2)
Accomplishments
- Supervised team of 20 staff members.
Additional Information
Persuing Post Graduation in HR Database Management from Welingkar Institute.
Software
SAP End User knowledge Success Factor DB Symphony for Asset Management Tableau End User knowledge
Certification
Microsoft Power BI
Timeline
Microsoft Power BI
02-2024
Data Analytics Manager
Reliance Industries Limited
11.2016 - Current
Senior MIS Executive
Samsung India Electronics Limited
08.2015 - 11.2016
MIS Executive Asset Management
Deutsche Bank
03.2013 - 07.2015
Sales MIS-Executive
Andromeda BPO Pvt. Ltd.
- 12.2012
B.COM - Commerce
Mumbai University
H.S.C. -
Gurukul Junior College of Commerce (Maharashtra Board)
S.S.C. -
Shivam Vidya Mandir (Maharashtra Board)