IMRAN AHMED
South West Delhi
Summary
Dynamic MIS Executive with a proven track record at Agilent Technologies Pvt Ltd., specializing in VBA programming and data analysis. Excelled in automating reporting processes and enhancing data accuracy, significantly improving management decision-making. Skilled in Excel, Power BI, and SQL Server, with a remarkable typing speed of 75 w.p.m., demonstrating both technical proficiency and efficiency.
Overview
18
18
years of professional experience
Work History
MIS Executive (ICB Associate)
Agilent Technologies Pvt Ltd.
09.2019 - Current
- Develop and maintain automated reporting solutions using VBA to streamline data processing and improve accuracy
- Creating efficiency and scorecard reports for entire GCFS team encompassing approximately 200 employees, aimed at enhancing people management
- Manage and oversee information systems, ensuring data integrity and accessibility
- Create and distribute comprehensive reports on key performance indicators (KPIs) for various departments
- Analyze data to identify trends, insights, and areas for improvement, providing actionable recommendations to management
- Publishing TAT for major GCFS processes, currently covering On-Demand Quotes, PM Parts, Repair Parts, Install Admin, Schedule Services, CSD, FSE Support, with plans to expand to over 40 processes
- Provide timely data to supervisors and managers as needed for their monthly meetings with partners
- Utilize Qlik Sense to ensure comprehensive work distribution to the Schedule Services team for PM, ensuring no services are missed
- Currently serving as backup and formerly responsible for this duty
- Publish weekly Service Order aging report to SBM, Installer, and Optimizer for entire Barcelona Hub
MIS Executive
Nippon Data Sys Ltd
11.2017 - 09.2019
- MIS reporting by using MS Excel & VBA (Macro) at Operational level
- Creating Excel Dashboards as per requirement
- Assigning work, reporting & monitoring turn-around time on weekly basis for GCFS team currently owing 84 team-members also report-out AIDA & OSBR reports at each month ends
- Implementing and delivering analytical data to create daily, weekly, monthly and quarterly reports
- Maintaining and sharing Attendance Tracker and team availability calendar with managers for the upcoming month by notifying planned leaves in advance
- Sharing production data, process, region or country-wise for quality & compliance purpose
- Preparing team's production cum occupancy report including scorecard in month-end closing
- Supporting as a backup team-member for European Repair Center for more than a year now
- Recently, got involved in a new Process India Auto SO (Preventive Maintenance) for schedule services in SAP CRM
Sr. Customer Representative Executive
Serco
07.2006 - 08.2010
- Company Overview: www.serco.com
- Making of Weekly, Monthly, Quarterly MIS report sheets for Operation Team
- Handling monthly budget sheets and revenue sheets, compilation and collation of all department related sheets
- Assisting my team in handling customer escalations in the system, error reducing, resolving queries and helping the team in providing relevant information to the customers
- Handling Escalations and queries via web Locate and monitor overdue accounts, via web and a variety of automated systems
- Perform various administrative functions for assigned accounts, such as recording address changes and purging the records of deceased clients/debtors
- Matched invoices to purchase orders for posting payment information, compared invoices to purchase orders to identify problems regarding terms, quantity/price discrepancies or special handling
- Reviewed processed invoices and credit memos for correctness, sorted invoices and credit memos into batches for computer entries
- Calculating control totals and recording batch information on control sheet
- Highlighted relevant payment data on invoice for entry into computer system and distributed invoice copies according to departmental procedures
- Reviewed computer-generated invoice batch edit sheets for errors, resolved errors, entered corrections into computer system
- Www.serco.com
Education
Graduate - B.A (Pass)
Delhi University
PG Hon’s Diploma - Computer Software Engineering
Information Technology Center (Telecommunication Consultant India Ltd.)
New Delhi, IndiaComputer Desktop & Laptop Chip level course -
Multitech Institute of Advance Technologies Pvt. ltd.
Skills
- VBA Programming for Automation
- Data Analysis and Reporting
- Excel (Advanced Functions, Pivot Tables, Macros)
- Power BI
- Tableau software
- SQL Server
- Typing Speed of 75 wpm
- Microsoft Access
- Dashboard creation
- Data mapping
- VBA programming
- Report generation
- Advanced Excel
Languages
- English
- Hindi
Hobbies and Interests
- Playing Chess
- Carrom
- Cricket
Disclaimer
I hereby declare that the above details are true and correct to the best of my knowledge. Nothing has been concealed or suppressed for which I own full responsibility.
Academicqualification
- Sec. School Examination from C.B.S.E.
- Sr. Sec. School Examination from C.B.S.E.
- Graduate in B.A (Pass) from Delhi University
Personal Information
- Expected Salary: As per company norms
- Father's Name: Sh. Maqbool Ahmed
- Date of Birth: 08/20/79
- Nationality: Indian
- Marital Status: Married
Timeline
MIS Executive (ICB Associate)
Agilent Technologies Pvt Ltd.
09.2019 - Current
MIS Executive
Nippon Data Sys Ltd
11.2017 - 09.2019
Sr. Customer Representative Executive
Serco
07.2006 - 08.2010
Graduate - B.A (Pass)
Delhi University
PG Hon’s Diploma - Computer Software Engineering
Information Technology Center (Telecommunication Consultant India Ltd.)
Computer Desktop & Laptop Chip level course -
Multitech Institute of Advance Technologies Pvt. ltd.
Similar Profiles
Subah PahujaSubah Pahuja
English Essay Writing Tutor - K-12 and College at Trivium Education Services Pvt. Ltd.English Essay Writing Tutor - K-12 and College at Trivium Education Services Pvt. Ltd.
Nikhil PillaiNikhil Pillai
Global BPA, Commercial Ops - Schedule Service at Agilent Technologies International Pvt. Ltd.Global BPA, Commercial Ops - Schedule Service at Agilent Technologies International Pvt. Ltd.
Gaurav Kumar AnandGaurav Kumar Anand
Customer Service Admin Specialist at Agilent Technologies India Pvt. Ltd.Customer Service Admin Specialist at Agilent Technologies India Pvt. Ltd.
Aditya SharmaAditya Sharma
Field Service Engineer at Sciex India Pvt. Ltd.Field Service Engineer at Sciex India Pvt. Ltd.
Abhishek DharAbhishek Dhar
Manager-Customer Relations & Complaint Managment at Vikram Solar LimitedManager-Customer Relations & Complaint Managment at Vikram Solar Limited