Summary
Overview
Work History
Education
Skills
Timeline
Generic

Himanshu Sehgal

Toronto,ON

Summary

8+ years of business analysis experience in different phases of Software Development Life Cycle(SDLC): gathering requirements, analysis, testing and implementation of projects.5+ years of expertise in equities, derivatives(futures and options) and capital markets domain with Financial risk management(FRM) certification from GARP, US managing trade flow from front to back office.

Overview

16
16
years of professional experience

Work History

Lead Business Analyst

CGI INC.
01.2021 - Current
  • Create existing mapping of fields/columns received for2 upstream systems by reverse engineering jobs and packages build in ETL tools- SSIS and DMC
  • Gather requirements from Genesys stakeholders to understand new fields being captured post transition and ensure new packages are built accordingly
  • Build new Webfocus reports managing equity/FX/Futures data for business teams basis new data mapping and provide maintenance support to ensure data is captured seamlessly
  • Support migration of Webfocus to Power BI by helping project team in building infrastructure using VMs and VDI as transition takes place from on-prem services to cloud
  • Help in User Acceptance Testing post new packages have been build in ADF(ETL tool) and before all reports are finally deployed in Power BI

CORA(AML/KYC) Application

CIBC, TORONTO
01.2024 - 10.2024
  • Work cross-functionally to identify process pain points and streamline release management process and its documentation across the Client Data Services team
  • Set up regular interactions with stakeholders to understand the project requirements to enhance AML/KYC application for users
  • This application will provide all the information available during onboarding and assess the risks associated with an entity and its associated product/services
  • Manage the role of scrum master by leading daily stand ups and guide the team to follow/implement AGILE best practices leading to better timely tracking of issues and fewer pushbacks from business
  • Prepare workplan to discuss features and user stories to be implemented in near future(3 to6 months) for better estimation of enhancements in pipeline and plan for more resources if needed
  • Conduct thorough User Acceptance Testing which includes Regression, Functional and Post Implementation testing
  • Handle end-to-end process of leading business refinement sessions, preparing ACs and refinement notes, performing UAT and creating mockups for UI change using Figma
  • Enhance output of Cognos reports by implementing user stories for correcting historical information and modifying comments captured therein
  • Manage the process for Production and UAT release by co-ordinating with ARC PCO and RM teams

Webfocus Application

BANK OF NOVA SCOTIA, TORONTO
03.2023 - 11.2023
  • Categorize the data into sub-categories to prepare a targeted approach for completion of cases
  • Document steps for each scenario for better clarity of process
  • Learn navigation and usage of multiple systems involved for gathering information and updating necessary details
  • Suggest process improvements to help reduce resolution time per case and reduce overall timeline of the project
  • Ensure best quality standards are met for completion of cases by doing random sampling check at day end

DB, RAMP APPLICATION
04.2022 - 02.2023
  • Gather requirements and manage work allocation for application to support generation of periodic reports pertaining to equities and derivatives exposure for a client
  • Enhanced application features to manage trade life cycle of equities and derivatives as well as support generation of5 new reports for senior management to review on a periodic basis
  • Upskill new resources on the existing features and new enhancements planned
  • Manage JIRA dashboard along with technical expert, perform regression testing etc
  • As part of each sprint

DB, RUNBOOK APPLICATION
03.2021 - 03.2022
  • Gather requirements from clients to make improvements to Runbook application for capturing detailed process steps and manage issues/risks within the application
  • Make presentation to the client at the end of each sprint
  • Responsible for managing scrum calls(scrum master) as well and highlighting critical issues to project manager
  • Create dashboard for optimizing daily activities and dependencies being faced in their completion

Process Improvement Specialist/Business Analyst

BANK OF MONTREAL
01.2020
  • Reduced inbound call complaint volumes by15% by rolling out process improvement plans
  • Optimized debit card related processes to generate25% better cost performance
  • Suggested feature enhancements to application receiving inbound calls and led implementation over2 months using Waterfall methodology
  • Co-ordinated with downstream systems to help them better understand data mapping of fields captured
  • Developed and used quality metrics to drive change and deliver measured improvements
  • Lead training for new team members on key processes
  • Standardized processes and documented process maps

Risk and Market Analyst/Business Analyst

TRAFIGURA GLOBAL SERVICES PVT. LTD.
01.2016 - 01.2018
  • Company Overview: (One of the world’s leading independent commodity trading and logistics houses)
  • Built an application capturing their PnL, equities, futures and options’ exposure for hedging purpose, their MTM values and storage units highlighting profits across months and quarters
  • Managed operational and risk management projects in accordance with corporate goals and initiatives to collate all trades and hedges in one application for the traders
  • Recruited to provide crude oil traders with market risk assessment using VaR/CVaR and analyze hedge effectiveness reports for equities, futures and other derivatives on book to highlight their exposure
  • Reduced cargo operations’ costs and associated risk for physical trades
  • Reduced storage costs by devising a plan for securing additional storage facilities in Singapore and Malaysia
  • Ensured timely reporting of any breaches and oversee changes to be implemented as per revised Risk policy
  • Prepared reports/dashboards for CEO, CFO and traders explaining reasons for changes in trading profit/loss along with periodically reporting financial performance

Manager

ROYAL BANK OF SCOTLAND
01.2013 - 01.2016
  • Company Overview: (Part of RBS Group, the company provides a diverse range of services for customer-facing operations including data analytics, risk management, and others)
  • Drove discussions and run-throughs on categories analysed for onshore stakeholders explaining key outcomes of the analysis and ideas to address process loopholes
  • Undertook deep dive analysis of debit cards category and suggested key areas of improvement to onshore clients
  • Analyzed complaints from equity and derivatives’ traders for the in-house application and settlement process internally and improved process efficiency by20% saving approx.20 mn
  • USD
  • Worked closely with process teams to improve processes and customer experiences
  • Successfully migrated voice of customer process from UK to India
  • Led and mentored a team of8 people for performing root cause analyses for complaints lodged by retail customers across UK
  • Minimised operational risks by reducing volume of complaints, which in turn, helped reduce losses owing to compensation provided in form of complaints’ redressal
  • Reduced complaints through trend analysis to identify emerging/recurring issues
  • Performed time and motion studies on sample cases to highlight trends and key issues, prepare final pack (presentation and MS Excel-based data report), and determine reasonable expectancy (time taken for each case)

Summer Intern

SABMILLER INDIA LTD.
01.2012
  • Company Overview: (Ab-Inbev is world's largest brewer and one of the largest FMCG companies in the world which acquired SABMiller in the year2016)
  • Profit-Pool Analysis: Performed quantitative and qualitative analyses of volumes and profit for SABMiller India and its competitors
  • Recommended reasons for change in gross margins in different states and possible changes in supply due to setup of new breweries in the year2013

Sales Engineer

BELDEN INDIA PVT. LTD.
01.2009 - 01.2011
  • Company Overview: (Leader in signal transmission and security solutions for mission-critical applications in enterprise and industrial markets)
  • Managed pre-sales and sales activities across hospitality, enterprise, and life sciences sectors – secured business from reputed clients such as SI Global and Hexaware
  • Project managed implementation of passive network (cable networking) for client, TCS

Education

MBA: Master of Business Administration - Finance

Management Development Institute
Gurugram, Haryana
01.2013

Professional Certification - Financial Risk Manager

GARP
01.2013

B.E.: Bachelor of Engineering - Electronics and Communications

Delhi Technological University
New Delhi, India
01.2010

Skills

  • Data analysis and Reporting: SQL, R, Advanced Excel, Webfocus, Tableau, Power BI, Microsoft SSIS, Azure Data Factory and Elasticsearch
  • BA tools: ADO, Figma, JIRA, MS Office, Confluence
  • Regulatory Compliance: Dodd-Frank, Basel III, MiFID, FRTB, AML/KYC procedures[Proceeds of Crime (Money Laundering) and Terrorist Financing Act]
  • Functional specifications
  • User acceptance testing
  • Software development life cycle
  • SQL proficiency
  • Requirements gathering
  • Stakeholder management
  • Team collaboration
  • Product development
  • Process optimization
  • Agile methodologies
  • Tableau
  • R programming
  • Machine learning
  • ETL processes
  • Trend analysis
  • Workflow optimization
  • Business process reengineering
  • Lean six sigma
  • Cross-functional team leadership
  • Team building
  • Root-cause analysis
  • Risk reporting
  • Hedging techniques
  • Commodity risk analysis
  • Equity analysis
  • Financial analysis
  • Regulatory compliance

Timeline

CORA(AML/KYC) Application

CIBC, TORONTO
01.2024 - 10.2024

Webfocus Application

BANK OF NOVA SCOTIA, TORONTO
03.2023 - 11.2023

DB, RAMP APPLICATION
04.2022 - 02.2023

DB, RUNBOOK APPLICATION
03.2021 - 03.2022

Lead Business Analyst

CGI INC.
01.2021 - Current

Process Improvement Specialist/Business Analyst

BANK OF MONTREAL
01.2020

Risk and Market Analyst/Business Analyst

TRAFIGURA GLOBAL SERVICES PVT. LTD.
01.2016 - 01.2018

Manager

ROYAL BANK OF SCOTLAND
01.2013 - 01.2016

Summer Intern

SABMILLER INDIA LTD.
01.2012

Sales Engineer

BELDEN INDIA PVT. LTD.
01.2009 - 01.2011

Professional Certification - Financial Risk Manager

GARP

B.E.: Bachelor of Engineering - Electronics and Communications

Delhi Technological University

MBA: Master of Business Administration - Finance

Management Development Institute

Similar Profiles

CREATE PROFILE
Himanshu Sehgal