Data Analyst Asset Management

Key Skills:

Soft Skills:

Data Analyst

Incident Management

VM Delivery Management

Operations Management

Project Coordination

SLA Management

IT Service Delivery

Customer Relationship

Asset Management

Good Analytical

Good Coordinator

Communicator

Collaborator

Intuitive

Innovator

Leader

Motivator

Analytical

Team Builder

Timelines:

`

Career Highlights:

• I have over 17 years of diverse experience in PMO, Data Analysis, Incident Management, VM Delivery Management, Asset Management, and Coordination and Reporting. My skills in managing projects, analyzing data, handling incidents, delivering VM management, and overseeing assets have been instrumental in enhancing productivity.

• Expertise in advanced MS-Excel, VBA, MS-Power-Point, MS-Word & MS-Visio.

• Knowledge of MS-PowerBI & Python & MS-Access (SQL Queries).

• Hands-on experience in Tools: ServiceNow, JIRA, RFF portal & CMS tool.

• Good verbal, written communication, and presentation skills. Dec’06-Sep’09 Sepi’09-Mar’10

Mar’10– Jan’11

Jan’11-Jul’15

Jul’15- Jun’24

Mukul Gupta

PMO Lead & Data Analyst

Performance-driven, insightful professional with over 17 years of rich & extensive experience; scaling new heights of success with hard work & dedication and leaving a mark of excellence on each step.

Phone: +91-989******* E mail: *****.*****.*****@*****.*** Jun’24 - till

Professional Experience:

From Jun’24 to Till with Capgemini as PMO Lead & Data Analyst Highlights:

Managed day-to-day operations within Information technology departments including Governance Compliance & Security (timesheet, Mandatory training, BTO & etc.), Finance and Productivity, Cost comparison & analysis, Interlock vs Forecast, FTE’s optimization, Onboarding & Offboarding, Incidents & Change KPI & dashboards, Transformation (Fun activity / kaizen / R&R/ Success stories, Kaizen, Automations, Ol’s Spotlight, Team register, Asset management, & etc.) and arrange & align PID’s and Adhoc reports.

Responsible for arranging meetings between project’s PMO & OL’s to discuss deliverables, schedules, and conflicts.

Prepare Dashboard, KPI and performance analysis with graphical presentations for daily, weekly, Bi-weekly, monthly & yearly using tool Power BI (Transform, DAX, visualization & etc.), SQL & Advanced Excel, VBA & Power-point.

Coordination with PMO’s, Ol’s, team-members and management. All the reports are developed in advanced excel, Power-Bi, VBA, SQL and Power-point, which further shows the trend of the team’s performance and deliverable. From Jul’15 to Jun’24 with Kyndryl (Spined off from IBM) as Senior Associate, Project Management

Highlights:

Working as a PMO in Infra development projects which include provisioning of servers, Incident Management, Data Analysis, and reporting, Compliance & etc. Provisioning standard & non-standard ordering of CMS servers, Installation of applications & agents, execution of Infra modification for CIs (extend, reduce, add & remove disk, storage, CPU & memory), Service Now administration (CMDB) update, DNS registration and cluster creation within SLA of deliveries, reporting using automation scripts, CMS users administration, CIBD: Executions related to Configuration Item Build and Decommission of partly build VMs, Coordination with CMS, topology(ICO & Ansible), KPN, Solution managers & platform & middleware engineers for the execution of build and decom request, Handover the deliverables within agreed time and timestamp all phases to successfully close the wave/request.

Monitoring, assigning, and reviewing Incidents to ensure closed within SLA and quality standards. Identified plans and resources availability & allocation to meet project goals and objectives. Coordinate triage activities, leading support, development, and engineering teams to a rapid restoration of service for high priority Incidents and events, escalating to leadership when appropriate and communicating to IT leadership.

Work with teams to identify improvement opportunities and ensure end-of-the-end success of the Incident Management process.

Perform regular review of active, historical incidents and root cause analysis to identify trends and opportunities for improvements across IT functions. Responsible for arranging meetings between project stakeholders to discuss deliverables, schedules, and conflicts.

Prepare Dashboard, KPI and performance analysis with tool Power BI (Transform, DAX, visualization & etc.), SQL & Advanced Excel, VBA & Power-point and using the CRM tool (ServiceNow) with graphical presentations.

Analyze and develop cost revenue, resources utilization, resources claim code, internal audit, resource tracker

& utilization etc. reports for multiple projects on daily, weekly, monthly, and quarterly basis. Identifying, defining, developing, and implementing improvements to project/financial reporting. Coordination with stakeholders, team-members, managers, and clients. All the reports are developed in advanced excel, Power-Bi, VBA and Power-point, which further shows the trend of the team performance based on the number of incidents created and closed on daily basis with respect to their SLA’s.

From Jan’11–Jul’15 with iGATE Global Solutions Pvt. Ltd. as Sr. Team Lead Highlights: -

Co-ordination with multiple projects, team-members, managers & departments as PMO. Prepared Dashboard & KPI for multiple projects using CRM tool with graphical presentations. Prepare cost revenue, utilization, claim code, internal audit, resource tracker and Adhoc etc. reports for multiple projects on daily, weekly, monthly, and quarterly basis. Created reports for various technical help desks, managing day-to-day reporting which includes data analysis, Weekly/Monthly dashboards, Adhoc requests using advance excel functions (lookups and reference, logical, Text, Date & Time, and more functions).

All the reports are developed in advanced excel and power-point which further shows the trend of the team performance based on the number of incidents created and closed daily with respect to their SLA’s. Prepared presentations to support high management to discuss with clients and to show the performance of the teams and associates.

From Mar’10-Jan’11 with Parle Agro Pvt. Ltd. as Sales Coordinator Highlights:

Coordinated all North India branches of Parle Agro Pvt. Ltd. & Distributors. Handled Warehousing & Delivery reconciliation.

Planned & Scheduled Delivery of Goods and Cargos.

Regular follow-up and status reporting regarding the deliveries to distributors. Maintained reports for primary & secondary, region wise, billing information &etc. using SAP tool. Completely required daily/weekly reports & presentation on time circulation. Maintained all documents as per quality standards. From Sep 2009 - Mar 2010 with Religare Finvest Ltd. as Executive Risk Highlights:

Co-ordination with all over India (450) branches of Religare. Handled following stock market compliance: -

Offline Trade Verification (2) Trade Matching

Managed MIS report on a regular, weekly, and monthly basis. From Dec 2006 - Sep 2009 with Indiabulls Pvt. Ltd. as Executive Highlights:

Call new and existing customers to provide them with information on the company’s mortgage loan products. Timely preparation of reports as and when required by SEBI from time to time. Co-ordination with NSE, BSE, MCX, NCDEX, HCL & BSNL and all over India branches of Indiabulls. Worked on company’s CRM tool and handled queries regarding V-Sat, Lease-Line, and terminal ids. Education & Credentials:

B.com from Delhi University, New Delhi

10+2 from C.B.S.E., New Delhi

Diploma in Computer Applications from Sterlite Foundation, New Delhi MCSA from Microsoft, New Delhi

Visual Basic Application from Morgans, New Delhi

ITIL V4 Certified from PeopleCert, New Delhi

Microsoft Certified: Azure Administrator Associate Prince 2 Foundation in Project Management

Microsoft Certified: Power BI Data Analyst Associate (PL-300) Certified PCEP-30-01 from Python Institute

Pursuing Tableau & MS- Co-Pilot

Personal Details: -

Father’s Name: Satish Kumar Gupta

Date of Birth: 07 June 1981

Nationality: Indian

Marital Status: Married

Gender: Male

Passport Number: M8734403

Languages Known: Hindi & English

Address: H. no. – 140, Ram Street, Old Gupta Colony, near North Delhi Campus, Delhi-110009 Languages Known: Hindi & English

Address: H. no. –140, Ram Street, Old Gupta Colony, North

Contact this candidate