MD

Mandeep Dhaliwal

available

Last update: 19.12.2022

Dipole Contractor, Splunk Contractor, Sr Technical Manager

Graduation: BTech CSE
Hourly-/Daily rates: show
Languages: English (Full Professional)

Keywords

Splunk

Attachments

Resume_181222.pdf

Skills

SPLUNK 

Project history

12/2022 - 12/2022
Test Team Lead (Team of 8 members)
Royal Bank of Scotland

* SA UAT Interactive for American Express (Dec 2013- January 2014)

Client American Express

Work Location Chandigarh (Offshore)

Project Description Interactive portfolio caters to the online acquisition channels that Amex deploys to
convert bank card prospects into customers. This is accomplished by developing new




online applications for various card products. In addition, online applications are
developed to provide card management services to Amex card holders.

Tools Used QC

Role Test Team Lead (Team of 8 members)

Responsibilities * Project level Planning, Effort Estimation, and Task delegation

* Handling Multiple Projects and Leading multiple teams at time.

* Onsite - Offshore coordination

* Daily status report and weekly status report preparation.

* Requirement Gathering and analysis through Client meetings.

* Test plan and Test Strategy Preparation for UAT
* System Test Readiness Report
* Creation and review of automation test scripts for Regression.
* Review of test data preparation, Test Scenarios and Test Script




* MYCA eStatements for American Express (May 2012- Nov 2012)

Client American Express

Work Location Chandigarh (Offshore)

Project Description The Project focuses on for validating the UI and functional enhancements planned
for eStatement application which caters to various card holders i.e., corporate card
members, Basic Card members, Basic with Supp card members etc.

Tools Used Test Director and QTP

Role Test Team Lead (Team of 6 members)

Responsibilities * Project level Planning, Effort Estimation, and Task delegation

* Estimation of Resources and Budget of Project

* Onsite - Offshore coordination

* Daily status report and weekly status report preparation.

* Requirement Gathering and analysis through Client meetings.

* Test plan and Test Strategy Preparation.

* Rainbow DBBA for RBS (Duration 1.5 year)

Client Royal Bank of Scotland

Work Location Chandigarh (Offshore)

Project Description The Project focuses on providing 1-day processing facility to the Cross Brand
transactions within NWB and RBS branches thus avoiding the normal 3-day
processing. The cross-brand transactions within NWB and RBS follow truncation
processing. The transaction processing system interacts with multiple systems
including third party systems in order to implement rules to provide settlement before
money is finally transferred to the customer's account.

Tools Used Test Director


Role Test Team Lead (Team of 5 members)




* Project level Planning, Estimation, and Task allocation.

* Estimation of Resources and Budget of Project

* Onsite - Offshore coordination

* Daily status report and weekly status report preparation.

* Requirement Gathering and analysis through Client meetings.

* Test plan and Test Strategy Preparation
* System Test Readiness Report
* Review of test data preparation, Test Scenarios and Test Scripts




* Empower.Net - Mortgage Home Loans Application for Citizens USA (Duration 7 month)




Client Citizens

Work Location Rhode Island USA (Onsite)

Project Description The Project focuses on up gradation of the Empower.net application to .Net Platform.
Testing includes the system validations to ensure the Loan application successfully moves
through all mortgage workflows and finally the loan is closed successfully.

Tools Used Quality Center

Role Test Analyst and Onsite-Offshore Coordination

Responsibilities * Project level Planning, Task review and tracking of the project team.

* Onsite Coordinator: Communication and change management of scope,
Onshore Team management.

* Onsite Coordinator: Periodic status reporting, Coordination between
onsite/offshore and Review deliverables.

* Excellent Business Analysis experience esp. in gathering high
quality requirement specifications and data modeling.

* Extensive experience in Data modeling, maintaining model repository and
generating DDL to create database schema.

* SFDC Testing for validating the application data updated in the SFDC.

12/2022 - 12/2022
Test Engineer

* Sales Express - Home Equity Application for Wells Fargo (Duration 3 years)


Client Wells Fargo

Work Location Chandigarh (Offshore)

Project Description Enhancement and Maintenance Project, which targets to merge all channels for
application submission on one platform i.e., Sales Express.

Tools Used QC and QTP

Role Test Engineer

Responsibilities * Preparation and Review of test Scenarios and test scripts

* End to End System Testing, SFDC Testing

* Supported UAT testing

* Preparing and Modifying the Datasheets accordingly for the Regression Testing.

* Involved in Review Meetings and Knowledge Transfer.

* Responsible for Planning Automation Testing to execute Regression Suite for
each release and Periodic Reporting.

* KM anchor for project. Responsible for maintaining the knowledge among the
team at optimal level, maintaining efficient documentation and organizing
quizzes.

* Delivery of Test scripts, Test data and defect reports

12/2022 - 12/2022
Dipole Contractor

Company Client Duration Country
Dipole Contractor - Splunk 6 months In Progress Remote - Australia/India
Group

04/2021 - 11/2021
Sr Technical Manager
Capgemini; Splunk Managed Services -Capgemini

Client Splunk Managed Services -Capgemini

Work Location Noida - (At present WFH)

Project Description Has been handling the requirement gathering activities for scaling and maintaining
Splunk Infrastructure and Cluster along with data ingestion activities. Creating Alert
suppression used cases by enabling ITSI features - Services, Entities, Episodes, using
correlation searches and integrating with SNOW for various customers.

Tools Used Splunk, Splunk ITSI

Role Sr Technical Manager (Team 10 members)
Responsibilities * Configured Splunk ITSI and maintained existing functionalities.

* Uploaded Entities data and defined KPIs to be used for for Service analyzer of
ITSI




* Configured Episode Review to automated logic of Alert Suppression and Ticket
creation with SNOW.

* Reviewed queries to enhance the performance and to perform query
optimization using Base queries, Saved searches and accurate field
extractions in Splunk using regex.

* Have successfully deployed code for Splunk Distributed environment using
GIT.
* Maintaining the health of Splunk Cluster and guiding the team to resolve
issues to keep Cluster Stable.

12/2018 - 12/2020
Splunk Consultant
Splunk ES/ITSI; BHP

Client BHP

Work Location Australia - Cognizant

Project Description Have worked on data ingestion tasks using Splunk and Nifi-Kafka. Have maintained
and scaled Splunk cluster, installed and configured HFs, UFs across domains within
the network. Have managed data volumes for Splunk Index for these logs.
Implemented Splunk SIEM use cases using correlation and Slunk ES.

Tools Used Splunk, Splunk Splunk ITSI, Ansible and GIT

Role Splunk Consultant

Responsibilities * Data on-boarding and Maintaining data source availability and quality
(syslog, ODBC, SNMP, REST, Add-on, log files et c.).
* Splunk-ES to identify security violations and anomalies.

* Implemented uses cases for - threat detection, white listing false
positives, identify notable events using Splunk ES .
* Integrated Splunk ES and SNOW to create incidents once the alert is
generated for identified notable events.
* Deployment of apps and add-ons within a clustered environment
using Deployment Servers and Cluster Masters .

* Setting up new Heavy Forwarders across multiple domains and zones.

* Component failures and incident management using Splunk ITSI .

* Platform performance degradation workarounds.

* Identifying badly written queries and to improve performance.

* Normalize data, Knowledge objects and as per CIM model standards.

* Dashboard development, adding dynamic drilldowns and generate reports

01/2018 - 07/2018
Splunk Team Lead
ANZ

Client ANZ

Work Location Offshore Chandigarh

Project Description Has ingested Windows and Linux sys logs to Splunk and routed data towards Fireeye
. Have made required changes in Splunk config file - Inputs, output, props and
Transform files. Have managed data volumes for Splunk Index for these logs

Tools Used Splunk

Role Splunk Team Lead




Responsibilities * Defining User stories and tasks for Splunk Requirement in JIRA as per
Agile process for the team

* Data ingestion using through Universal forwarder via Heavy
Forwarders and then routing data to third party system - Fireeye

* Have configured Universal Forwarder on Source systems and routed data
ingestion towards Heavy Forwarders.

* Have made required changes in Splunk config file - Inputs, output,
props and Transform files.
* Have successfully deployed code for Splunk Distributed environment using
GIT and GoCD pipelines .
* Ensuring UAT is performed successfully.



* NBN - Splunk Reporting Dashboard Development (Apr 2017 - Nov 2017)

Client NBN

Work Location Melbourne- Australia Onsite

Project Description Has been handling the requirement gathering activities for Splunk Dashboard
Development. Ensuring the reports and dashboards are created as per the
expected requirements. Also ensure data ingestion has happened correctly in as
per Agile processes using Jira. Have configured Splunk Add on for Okta on Heavy
Forwarders and routed data towards Indexer and Search Head. Have installed SH
App for okta for required Dashboards.

Tools Used Splunk

Role Lead Splunk Development (Team 3 members)

Responsibilities * Defining User stories and tasks for Splunk Requirement in JIRA as per
Agile process for the team.

* Data ingestion using Okta Add-on on Heavy Forwarder by integrating
Splunk with source systems viz. Okta Authentication systems.

* Worked on Splunk ES and co-related events to implement SIEM
requirements.
* Has reviewed Team work and developed dashboards using features like
Panel Grouping, Contextual Drilldown & Dynamic Drilldown. Have
used the Built in App for Okta as well for Search Head.
* Reviewed queries to enhance the performance and to perform query
optimization using Base queries, saved searches and accurate field
extractions in Splunk using regex.
* Have successfully deployed code for Splunk Distributed environment using
GIT and GoCD pipelines .

12/2014 - 03/2017
Technical Project Manager
Amex

include working closely with Business users to deliver dashboards for
reporting purposes and also ensure the logs are ingested successfully from
source systems using Agile processes within Rally . Completed tasks related to
Billing and confirmations, Resource allocation and Deal Pricing .




Tools Used Splunk and Rally

Role Technical Project Manager (Team 10 members)

Responsibilities * Have performed Project Management activities, Allocation, Billing
and confirmations, followed process for project code creation,
Deal pricing and Resource Management.

* Ensured AMEX Compliance related process is followed correctly with
project by team.

* Has led a team who developed Dashboards, drilldown panels using
Panel Grouping, Contextual Drilldown & Dynamic Drilldown .
* Have guided the team to ingest the XML logs successfully and used
KV_MODE=xml in props.conf and extracted Key values from XML and
JSON logs using SPATH and regex on search head.
* Have performed correlation using TRANSACTION command to analyze
groups of events within logs.

* Perform query optimization using Base queries, Saved searches and
accurate field extractions in Splunk using regex .

02/2014 - 11/2014
Business Analyst for Energy Australia
EAIP; Energy Australia (EA)

Client Energy Australia (EA)

Work Location Melbourne Australia - Onsite

Project Description The project focuses on validations of post-merger integration across various
platforms which interact with Oracle CCB application of EA. The purpose is to validate
the new work packages along with IRs introduced as part of this project. The purpose
is to build new and existing dashboards for BI reporting of applications which are
integrating with other multiple systems including 3rdparty systems for making
payments and validating market regulations and validations of functionality for
MDMS, Type 5 and Type 6 meters.

Tools Used Tableau and Oracle CCB

Role Business Analyst and Onshore/offshore coordinator

Responsibilities * Onsite - Offshore coordination

* Daily status report and weekly status report preparation.

* Excellent Business Analysis experience esp. in gathering high quality
requirement specifications and data modeling.

* Extensive experience in Data modeling, maintaining model repository and
generating DDL to create database schema.

* Experience in complex BI Reports, Dashboards, created advanced chart
types, visualizations and complex calculations to manipulate the data using
Tableau.

Local Availability

Only available in these countries: India
Profileimage by Mandeep Dhaliwal Dipole Contractor, Splunk Contractor, Sr Technical Manager from Dipole Contractor, Splunk Contractor, Sr Technical Manager
Register