MOHD MOHSIN
New Delhi
Summary
Detail-focused Data Analyst with knowledge in data process validation and business needs analysis.
Overview
14
14
years of professional experience
Work History
Data Analyst (SHEQ Specialist)
Sarens Heavy Lift India Pvt. Ltd.
3 2015 - Current
- Making daily, weekly and Monthly KPIs
- Generating timely and accurate reports for analysis
- Creating MIS/ Dashboard and presenting it to the concerned Department
- Compiling the reports for the group (for all the Business Units of South Asia, Central Asia, Eastern & Northen Europe, Middle East, North America, Oceania, Southern Africa, Western Europe and Sarens Projects)
- Preparing Consolidated Global Accident Figures report for all Business Units on monthly basis
- Making Monthly KPIs for Workplace Inspection, Incident figures/Accident, Toolbox Talks, Internal Audit Report, Frequency & Severity Report, Manhours worked report, High Potential Incident/Near Misses report, Wellbeing, Crane Inspection, Yearly and Monthly Management Report and Year Action Plan report
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Created a dashboard in excel
- Making presentation for board meeting
- Created Macros for Business Development
- Automating, modifying and optimizing reports in excel and VBA macros.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Used statistical methods to analyze data and generate useful business reports.
Process Associate
Accenture Pvt. Ltd.
01.2014 - 03.2015
- Responsible for making MIS Reports: - Hourly/Daily/weekly/Monthly
- Making KPI report on daily and Monthly basis
- Daily Backlog Analysis and FTE’s Capacity Utilization report
- Making agent’s Productivity Report on daily basis
- Time Interval report on monthly basis
- Preparing Purchase Order vs Sales Order Report on daily basis
- Using daily SAP dump & converting the same into various MIS related formats
- Data Sorting & Data Uploading on daily basis
- Maintaining day-to-day client reporting & analysis
- Preparing the specific special purpose reports & presentations for process using advance excel
- Automating reports by designing macros
- Other day to day activities as per requirement.
MIS Executive
SERCO PVT LTD.
06.2012 - 01.2014
- Making daily, weekly and Monthly MIS reports
- Preparing Payroll (LOP, Live List, Hold List, EGES Payout, Incentives etc.) for the employees who are in V&A, Process and OJT training
- Preparing the Yield Report for monthly basis
- Preparing the Attrition report (Age wise, Consultant wise, Education Wise, Trainer Wise, Recruiter Wise) on monthly basis
- Responsible for making the BGC and DCT report
- Making Ontime report on weekly basis
- Making the performance report for recruitment
- Preparation of Dashboard for the use of senior management
- Responsible for sending mails for new joinees
- Making final Attendance for the batches.
Data Entry Operator
INTELENET GLOBAL SERVICES
07.2011 - 03.2012
- Updating the details of all joinees in HR-MIS (Salary, Personal details, E-code etc.) Batch movement in HR-MIS ( Core, Process & OJT)
- Sending mails to HR ops for generating the e-codes of new joinees
- Preparing vendor contracts
- Generating Offer letter through HR-connect
- Tracking the new joiners record in excel on daily basis Updating the Rejects and on-hold profiles into the incubation tracker.
Data Entry Operator
INTELENET GLOBAL SERVICES
06.2010 - 02.2011
- Updating the details of all joinees in HR-MIS (Salary, Personal details, E-code etc.) Batch movement in HR-MIS ( Core, Process & OJT)
- Sending mails to HR ops for generating the e-codes of new joinees
- Preparing vendor contracts
- Generating Offer letter through HR-connect
- Tracking the new joiners record in excel on daily basis Updating the Rejects and on-hold profiles into the incubation tracker.
Education
Bachelor of Arts -
Delhi University
Delhi 04.2001 -
Skills
Advance Excel: Creating Dashboards based on excel functions/Tools like Form Controls, 3D Reference, Sparkline, Pivot Table, Dynamic, Index, Match, Offset, VLOOKUP, Hookup, Count if(s), Sum if(s), (Sum-product), Cell formatting, Custom Formatting, Subtotal, Aggregate, Name Range, IF Condition, Pivot Table, Pivot Chart, Frequency, Validation, Advanced Filter, Index match, Sparkline, Charts, Dynamic Pivot Table, and Dynamic Charts
VBA: Macros, Loops (Do while, Do until, For each Loop, For next), user define function, User forms, Connectivity with MS -Access, SQL etc
PowerPoint, Outlook, Power BI, MS Access and SQL Server
Good Experience of dashboard with the help of pivot Tables, slicers & developer tools Making automation and creating dynamic charts and dashboard
Professional Snapshot
A competent professional with nearly 13 years of experience in Data Analysis, MIS, Quality Assurance, process improvement. Functional abilities in preparing & maintaining Daily Production Reports, MIS Reports, Dashboards and Monthly Business Reports for Analysis. Hands-on experience in Advance Excel, VBA and Data Analysis, deft at understanding requirements, design formats, deploy formats, following up with business development team and validating data. Coming up with innovative solutions, which can help in reduced manual work and increase automation to reduce the error probability. Co-ordinate in all business units with AM/Manager/Regional Manager/Director.
Academicqualification
- B. A. (Programme) from Delhi University.
- 12th Passed from CBSE, Delhi
- 10th Passed from CBSE, Delhi.
Personal Information
- Father's Name: Late Mohd Israfil
- Date of Birth: 07/09/1982
- Nationality: Indian
- Marital Status: Married
- Religion: Muslim
Languages
Hindi, English & Urdu
Timeline
Process Associate
Accenture Pvt. Ltd.
01.2014 - 03.2015
MIS Executive
SERCO PVT LTD.
06.2012 - 01.2014
Data Entry Operator
INTELENET GLOBAL SERVICES
07.2011 - 03.2012
Data Entry Operator
INTELENET GLOBAL SERVICES
06.2010 - 02.2011
Bachelor of Arts -
Delhi University
04.2001 -
Data Analyst (SHEQ Specialist)
Sarens Heavy Lift India Pvt. Ltd.
3 2015 - Current