Summary
Overview
Work History
Skills
It Skill Sets
Education
Timeline
Generic

Manojsen Gupta

Sydney,Australia

Summary

A seasoned Business Analyst bringing along 18 plus years of Banking Domain experience, where functional knowledge is gained through continuous work in various areas of capital markets, investment banking and regulatory reporting. Worked in the capacity of Senior Business Analyst and Project coordinator roles for International Banks including ICICI, Reliance Commonwealth Bank and ANZ Bank. Expert in trading and back-office applications, change management, release management, requirement gathering, gap analysis, data quality improvement and QA projects.

Overview

13
13
years of professional experience

Work History

Business Analyst

Infosys - Telstra Corporation Limited
Sydney, AUS
03.2022 - 10.2023
  • Building and populating templates for current State of Data and Splunk Logging and Monitoring
  • Identification of PI and PII data as per client security guidelines
  • Interaction with stakeholders and technical teams to uplift the security to meet defined standards
  • Workshops and sessions for technical team and BAs for Domain knowledge Workshops with different IT teams to understand current state processes
  • Developing and communicating when new tasks are identified, task duration or dependencies change
  • Actively participated in processing application log files in splunk for Dashboard monitoring
  • Liaising between business and technical teams to ensure a mutual understanding of processes and applications
  • Facilitate weekly/fortnightly meetings with relevant teams to document requirements and explore solutions
  • Worked with the Security team in the development and maintenance of a security awareness program across all aspects of Data Security (In transit, Rest, Retention and Logging and Monitoring)
  • Identifying Gaps and issues between the current and future system from Data security aspects
  • Test case creation based on Gaps identified
  • Worked with the team to define Epics, Features, User Stories, and tasks per business initiative
  • Creating Use cases and Story Documents for Customer Statements
  • Products – Mainframe application for Telephone and Internet services.

Technical Business Analyst

Anz Bank
Sydney, AUS
11.2020 - 03.2022
  • Actively participated / arranged with several iterations between teams and customers on domain related tasks
  • Liaising with Product owners for requirements and providing updates on the progress of the project
  • Developed confluence pages for requirements gathering for Trade Surveillance and Conflict Management Automation rollout
  • Supervised and co-created testing and defect-tracking documentation with 90% closure rate
  • Interacted closely with stakeholders and Business owners to develop a deep understanding of the challenges, pain points and areas of opportunity
  • Developing data models, flows, datasets, and views that are efficient and meaningful representations of data
  • Identified gaps for risk data in between old and new versions (Murex) of Trade Capture systems and suggested improvement initiatives on approach and data related activities
  • Responsible for capturing & logging business requirements on confluence and JIRA with various stakeholders
  • Worked on different tools for analyzing data for the clients including Murex, TSS, Splunk, Customized dashboards
  • Solved software configuration issues and collaborated with various stakeholder groups and other technical teams to ensure continuous support for the development teams
  • Experience of testing within an Agile environment, adapting quickly to changing situations
  • Experience working with Jira or similar scrum, bug, and project tracking tools
  • Products – Forex, Interest Rates Derivatives, Bonds and Commodities.

Technical Business Analyst

Anz Bank
Sydney, AUS
11.2020 - 03.2022
  • Actively participated / arranged with several iterations between teams and customers on domain related tasks
  • Liaising with Product owners for requirements and providing updates on the progress of the project
  • Developed confluence pages for requirements gathering for Trade Surveillance and Conflict Management Automation rollout
  • Supervised and co-created testing and defect-tracking documentation with 90% closure rate
  • Interacted closely with stakeholders and Business owners to develop a deep understanding of the challenges, pain points and areas of opportunity
  • Developing data models, flows, datasets, and views that are efficient and meaningful representations of data
  • Identified gaps for risk data in between old and new versions (Murex) of Trade Capture systems and suggested improvement initiatives on approach and data related activities
  • Responsible for capturing & logging business requirements on confluence and JIRA with various stakeholders
  • Worked on different tools for analyzing data for the clients including Murex, TSS, Splunk, Customized dashboards
  • Solved software configuration issues and collaborated with various stakeholder groups and other technical teams to ensure continuous support for the development teams
  • Experience of testing within an Agile environment, adapting quickly to changing situations
  • Experience working with Jira or similar scrum, bug, and project tracking tools
  • Products – Forex, Interest Rates Derivatives, Bonds and Commodities.

Business Analyst

Bar360 Pty Ltd
Sydney, AUS
01.2020 - 11.2020
  • Implementing changes to existing BI systems
  • Making sure that reports are delivered accurately and on time
  • Participating in team planning sessions
  • Providing data and analysis in support of the company’s initiatives and projects
  • Building strong working relationships with cross functional teams
  • Coming up with an analysis that is cogent and timely
  • Managing the timely flow of business intelligence information to senior managers and users
  • Liaising with business analysts to develop BI solutions
  • Optimizing data for scale and performance
  • Products – Business Intelligence Reporting.

Business Analyst

Commonwealth Bank
Sydney, AUS
07.2019 - 12.2019
  • As part of Data Quality analysis: Traced Data Lineage of data elements to be used in the CRLS
  • Identified and proposed resolution of recurring Data Quality problems
  • Responsible for identification, assessment & mitigate technical, commercial and market risks
  • Analysis of EOD files for Trading source systems e.g
  • Murex, WSS, LoanIQ etc
  • Responsible for identifying & capturing the critical data elements for risk management metrics and downstream reports
  • Requirements analysis: Collaborate with stakeholders and product teams to decompose large epic stories into small viable features and user stories that can be understood and accepted by members of the scrum team
  • Translating business needs into a data model, providing expertise on data modeling tools and techniques for designing data models for applications and related systems
  • Gather data management requirements from multiple systems
  • Responsible for building, pruning and maintaining the program backlog with input from the Product Manager, EPIC Owner and other stakeholders
  • Data mapping between Murex & WSS products and Global Reference data sets for traded products
  • Champion Agile methodologies throughout the development process
  • This includes running daily standup meetings, iteration planning, and releasing planning meetings
  • Experience with meta-data management including full data lineage, source to target mappings, business rules and definitions
  • Products – Trading platforms (Murex, WallStreet, BBG etc.)

Technical Business Analyst (Murex SME)

Commonwealth Bank
Sydney, AUS
03.2016 - 12.2018
  • Stakeholder meetings
  • Change and Release prioritization as per business priority
  • Requirement gathering on issues from Business owners
  • Business Requirement documentation to translate them to the Vendor
  • Quality assurance for vendor delivered Patches / writing test cases and Use cases
  • Design test cycle in accordance with Release cycle
  • Support operation activities for business functionality related issues
  • Problem solving for MIFID transaction reporting for FX Forwards
  • Business Issue reporting
  • Vendor and other (SWIFT) system coordination
  • Stakeholder meetings
  • Reconciliation support for the business Nostro reporting to regulators
  • Documented code in accordance with company policies, company standards and industry best practices
  • Interacted with business units regarding deployment strategy and system functionality, system configuration and associated processes
  • Requirement management through various stages of project life cycle
  • Experience in Agile delivery, including supporting tools, e.g., Jira / Confluence
  • Experience in creating documents like Business Requirements Documents (BRD), Functional Requirements Document (FRD) and Requirements Traceability Matrix (RTM)
  • Products – FX and Money Market trades Front office, Back Office settlement operations, Middle office operations – Confirmations, Intellimatch Reconciliation system.

Tech Business Analyst

Carrington Associates
Sydney, AUS
11.2015 - 03.2016
  • Collaborated with client to ensure all data mappings and business requirements were accurately defined and documented
  • Assisted in architecting integration from billing systems to other corporate systems by defining data mappings
  • Created Test Plans to facilitate and coordinate UAT - user acceptance testing of ad hoc fixes and system enhancements
  • Developed and maintained SQL/PL SQL scripts and stored procedures to maintain data integrity check and fix data issues
  • Monitored the Reports Performance in production and tuning the SQL’s and Report designs
  • Products – Business Intelligence Reporting.

Tech Business Analyst (Murex SME)

Reliance Industries
Mumbai, IND
04.2013 - 10.2015
  • Stakeholder meetings
  • Change and Release prioritization forums
  • Requirement gathering on issues from Business owners
  • Business Requirement documentation to translate them to the Vendor Creating and maintaining delivery track sheets with functional dependency and traceability matrices
  • Quality assurance for vendor delivered Patches / writing test cases and Use cases
  • Design test cycle in accordance with Release
  • Deployment functional support and post deployment business support
  • Support operation activities for business functionality related issues
  • Team lead for a team of three (technical and functional)
  • Played important role in solution Designing for Reporting Requirements as part of Murex 2.11 to 3.1 Migration
  • Configuration of MxML tasks, writing data dictionary formulas using XSLT and other Murex proprietary coding languages in Pre trade and Post trade workflows
  • Conversion of xml into fpml messages for OTC products
  • Changes in Contract and Events workflow based on Requirements
  • Analysis and development of Import workflows
  • Development of Confirmation Templates for Bonds, Mutual funds and Forex products
  • Creation redesign of Technical Design Documents and Test Cases for the mentioned reports
  • Writing release notes, impact analysis and test cases and executing it
  • Products – FX and Money Market trades Front office, Back Office settlement operations, Middle office operations – Confirmations.

Tech Business Analyst (Murex SME)

Anz Bank
Melbourne, AUS
08.2012 - 02.2013
  • Involved in creation of Datamart Objects
  • Migration of Flash and Market operation mreports into DataMart
  • Configuration of Extraction, Batches of Extraction, Feeders & Batches of Feeders, EOD Reporting Batches using Processing Scripts
  • Handled development of Backdated, Total Trades, Market Operation, and Off Market trades, EQD Flash and Cancel and Amend Report
  • Products – FX and Money Market trades Front office, Back Office settlement operations, Middle office operations – Confirmations.

Tech Business Analyst (Murex SME)

Icici Bank
Mumbai, IND
03.2011 - 07.2012
  • Identifying Gaps and issues between the current and future migration systems through test phases
  • Test case creation based on Gaps identified
  • Using Migration tools for Business Objects
  • Spearheaded team of 5 consultants involved in Murex 2.11 to Murex 3.1 migration on External Interfaces and Deal migration
  • Assisted in design and development of “AS IS” and “To Be” map and workflows in Murex, which involved gathering business requirements from the users and analyzing feasibility with the project team
  • Involved in various activities of the project like information gathering, analyzing the information gathered, documenting the functional, business requirements, auditing etc
  • Designed, developed and tested workflows in Murex interfacing with external systems
  • Configure the Access Control Matrix with Chinese wall templates
  • Configured and exported/imported UDFs using Export/Import wizard for transferring configuration between different environments
  • Analyzed existing systems and databases and recommended enhancements to solve business needs
  • Created test cases, test scenarios, test specification documents including change request (CR) documents
  • Products – FX and Money Market trades Front office, Back Office settlement operations, Middle office operations – Confirmations.

Skills

  • Capital Markets
  • Telcom Software solution Design, Development & Support
  • Requirements Gathering & Analysis
  • Agile/Scrum Methodologies
  • Business Analysis
  • SDLC methods (Agile, Waterfall)

It Skill Sets

C, C++, Java, UNIX, Windows, Oracle 10g/11i, DB2, MS-SQL Server, MS Office, Access, Teradata, Tableau, Actuate, BIRT, PowerBI, QlikView, Business Intelligence, Reporting, Data Warehousing, Cyber security, Murex 3.1, Mx2.11

Education

Master’s in business administration, Post Graduate Diploma in Computer Applications, Bachelor of Science

Timeline

Business Analyst

Infosys - Telstra Corporation Limited
03.2022 - 10.2023

Technical Business Analyst

Anz Bank
11.2020 - 03.2022

Technical Business Analyst

Anz Bank
11.2020 - 03.2022

Business Analyst

Bar360 Pty Ltd
01.2020 - 11.2020

Business Analyst

Commonwealth Bank
07.2019 - 12.2019

Technical Business Analyst (Murex SME)

Commonwealth Bank
03.2016 - 12.2018

Tech Business Analyst

Carrington Associates
11.2015 - 03.2016

Tech Business Analyst (Murex SME)

Reliance Industries
04.2013 - 10.2015

Tech Business Analyst (Murex SME)

Anz Bank
08.2012 - 02.2013

Tech Business Analyst (Murex SME)

Icici Bank
03.2011 - 07.2012
Manojsen Gupta