About Deutsche Post DHL: DHL is part of the world's leading postal and logistics group, Deutsche Post DHL
and encompasses various divisions: DHL Express, DHL Global Forwarding & Freight, DHL Supply Chain, Post
& Parcel, eCommerce, ITS.
i. Hired as Senior Executive , to perform various tasks for few selected customers.
ii. Internally moved to Reporting and Analysis team based on the developed skills in excel and macro
developments.
iii. Promoted as Lead Project Management Office, Reporting & Analyst and moved to Global
Infrastructure Service Management for reporting activities and project support.
iv. Internally promoted as Global Project Lead in Global Infrastructure Service Management for Project
Management and support reporting activities.
iv. - Global IT Project Lead
Tasks:
* Security Management
- Following up with the Action owners of the assigned action items after a security audit was conducted
by the Corporate Security Audit team
- Identifying and highlighting potential vulnerabilities in User accounts landscape and closing the gaps
- Redesigned the Standard Vulnerability Management tool with right Business unit bifurcations, IP
ranges, Responsible person for future monitoring and managing the accesses
- Clean-up of the assets from the Vulnerability tool
- Designing report based on KPIs by the Corporate IT Board and CISOs
* Access Management
- Monitoring the accesses to the various tools and applications
- Monitoring the Approval Matrices used for various activities
- Communicating with the Applications Owners and providing them the findings to disable/remove
obsolete account access for cost saving
* Project Management
- Analyzing the flow, outcome, vulnerabilities and obstacles of implementing as project
- Planning the project timelines and activities
- Raising Change request to Change Management and obtaining necessary approvals for
Implementation
- Providing support and guidance during and post a project
- Reviving old projects on hold and driving them through a controlled channel
- Providing regular updates where necessary to avoid and communication gap
- Arranging and conducting the User Testing (pre-feasibility/pilot run) and accepting the Risk of
unwanted results while managing a quick roll-back
- All these projects were scoped over 143 countries in six business units
* Asset Management
- Analyzing the current landscape of licensed software installation, mapping with upcoming projects
and formulating a demand of licenses that need to procured
- Movement and allocation of 2nd hand licenses to vacant 1st hand licenses to be used by non-EU
countries
- Manually analyzing the Users and Computer accounts which are potentially obsolete to save cost of
service, licenses, memberships and accesses
- Right allocation of Users and Computers to their respective Crest Codes for correct billing to the
countries
- Regularly monitoring the License Balance reports to make sure that there are no license imbalances
* Application Portfolio Management
- Analyzing the software installation landscape based on the approved packaged installation or manual
installations and driving a clean-up project
- Standardizing the latest package for ordering and hiding the old packages
- In event of OS and other system updates, it was necessary to test all the mission and business critical
applications for functional and operational compatibility before the release. To perform the automated
UAT of these applications, scripts were created using UI Path and bots performed the tests before the
release of such system updates.
* Decision making for upcoming activities
- Attending various cross Business Unit meeting to decide the flow of upcoming activities and provide
consent on behalf of DGFF
- Proposing new project implementation and requesting the needed budget
* Reporting
- Based on the various requests and rough ideas from upper management, identifying the right source
of data, right piece of information within the data, analyzing it, process it & design a report and finally
delivering it in a presentable format
- Guiding the other Business Units with report and compliance ideas
- Assisting the team mates with their project reports
- Managed a team of 4 who were trained in designing reports in Qliksense and MS Power BI. These
reports were designed and developed for global use for global, regional and country IT heads for
obtaining an overview on the ongoing projects, CITA reports, security reports, vulnerability reports
etc.
* Analysis
- Analyzing and monitoring the current spending in comparison of the allocated budget for IT services
- Analyzing various aspects of IT accounts and finding incompliance
- Analyzing the impact of past and ongoing projects on cost saving
- Analyzing the cost impact of balancing the license demand in future
* Compliance Monitoring
- Post finding the possible loop holes in various aspects of IT Account landscape, certain KPIs were set
for the countries to achieve. These actionable were tracked and reported every month of accessing the
compliance ratio
- Based on past project learnings, certain new targets were set, which were tracked every month for
compliance achievement
* Future projects planning
- Based on current situation, vulnerabilities, learnings and incidents, some projects were planned for
next 5 years. In account of being the subject matter expert, was part of the drafting team. Also,
supported the architecture team to design the flow of process, security team to meet the compliances,
legal team to adhere to each country's specific local law, central reporting team to design the report
based on the drafted KPIs and possible various source of data that might form the base of the report.
Initiatives & Implementations:
a) Analyzed the Account activity & status of entire year and concluded few gaps and overcharging. On
presenting the finding the respective Business Unit had to issue a Credit note. Such similar projects of
Clean-up resulted in huge Cost Avoidance for the division.
b) Upfront initiated many compliance reports to be fulfilled by the countries
c) Took over the responsibility of re-designing the Standard Vulnerability Management tool for saving third
party support cost to the company
d) Upfront derived multiple KPIs based on experience to be implemented in DGFF, which later were adapted
by the global team for implementation group wide.
iii. - Lead PMO Reporting & Analyst
Tasks:
* Tracking status of project/programme deliverables and milestones
* Supporting the adoption of the project lifecycle and deliverables
* Project/programme level risk and issue co-ordination/reporting
* Monitoring and reporting the status of projects
* Coordination of regular project and programme level reporting cycles
* KPI reporting
* Cost reporting
* Vulnerability reporting
* Additional responsibilities include assisting the PMO Manager with defining and updating the project
management processes, standards and governance, assisting Project Managers on large projects,
contributing to Quality Reviews, and coordinating activities in support of quality objectives
* Liaise with staff in other DHL PMOs so that standards are implemented consistently across DHL
Initiatives & Implementations:
a) Re-designed existing reports to make them more presentable and graphical for better understanding
b) Co-ordinated projects with stakeholders in absence of Project Manager
c) Formed a good rapport and relationship with stakeholders and counterparts from other verticals and
divisions for ease of transiting the projects
d) Proactively assisted counterparts and stakeholders in various activities when approached for help,
guidance or planning
ii. - Reporting and Analysis
Tasks:
* Creation of reports based on the pre-defined templates
* Onboarding new reporting activities
* Identifying new reporting activities that can on boarded
* Automating existing and new reports which were prepared manually
* Identifying and automating the manual tasks performed by users in various processes
Initiatives & Implementations:
a) Assisted various team for creating Excel files for monitoring Daily, Weekly and Monthly productivity -
Dashboards and Cubes - Shortcut links to access various file locations used for daily processing
b) Amending the old macro automations based on the upgrades and new process changes
i. - Senior Executive
Tasks:
* Shipment monitoring
* Invoice entry and auditing
* Shipment data management
* Exception management and follow up
* Daily, weekly and monthly reporting
* Help desk system
* Sending notifications for pre-alerts to required contacts once all documents are received and approved by
front office
* Follow-up and collect all required shipment documents as per the checklist and upload them on designated
common port for all associated personnel to view
Initiatives & Implementations:
a) Have assisted different teams during project migration.
b) Have made many Excel macros:
1) Register shipment milestones in dedicated tool
2) Update shipment status and comments in dedicated tool
3) Extract shipment milestones from database
4) Extract emails into Excel for task allocation
5) Enter shipment details in dedicated tool - 2 different applications for different processes
6) Auto close old jobs using macro to save time
7) Extract milestones and locations from public tracking websites for Ocean Shipments.
8) Extract excel reports from Email, filter them, process and save them in their respective folders
9) Take print screen of current task and save them on local drive.
10) Process an excel report with numerous conditions and filter
11) To open shipment status screens (50 at a time), to manually check for any discrepancies
c) Have made a Dashboard collating data of entire department showcasing productivity and positions.
d) Assisted in Ad-hoc activity of analyzing yearly data for optimization.
e) Assisted in introducing new application with an important role to play