Nisha Alager
Sydney,Australia
Summary
Accomplished Senior Business Analyst with a proven track record at Telstra, adept in stakeholder management and SQL/Oracle PL/SQL. Excelled in leading cross-functional teams to surpass project goals, leveraging expertise in data risk & governance and communication to drive business and technical analysis, resulting in impactful process improvements.
Overview
21
21
years of professional experience
1
1
Certificate
Work History
Business Analyst
BT Superannuation
01.2019 - 07.2019
- In Superannuation space, GDPR & PMIF/PYS Risk and Compliance changes
- Primarily into requirement gathering and stakeholders management in order to implement the legislation changes on GDPR (Privacy Policy changes on EU/EEA) & PMIF/PYS-Insurance code of practice under regulatory rules RG 97/99 (Charges applies into all the brushers/PDS [Post disclosure statements]) from APRA/Royal commissions recommendations in Insurance and Superannuation products from BT Superannuation (Westpac Group)
- Taken complete ownership in implementing GDPR compliance changes (on collecting personal data from EU/EEA nations) in order to update all PDS (Post Disclosure Statements)/privacy statements in various collateral from BT Superannuation products (online/Manual collaterals)
- Reviewed a checklist on various test scenarios in order to meet all LSEP (Lifetime Super for Employer Pension)/BTBS (BT business for super) changes on letter distribution
- Proposed various financial advices in order to get a better plan/products in Insurance and Superannuation space
- Took complete ownership on quality delivery using Agile methodologies
Technical Business Analyst
Westpac
North Sydney, Australia
01.2019 - 07.2019
- New Payment Platform (AML/Sanctions - Payment screening/monitoring platform)
- NPP is leading platform in Australia for Domestic payments
- Westpac introduced Payid option to enable the payments by using customer's PAYid such as mobile, Gmail and other pay to pay options without using BSB
- Played both business and technical BA role in NPP Payments, Customer Screening (on AML/CTF and Sanctions alerts) for NPP/SWIFT (Domestic/International) Payment messages using PayID and Osko payments using Dertica and Net-reveal for Westpac
- SPOC (Single point of contact) - Onshore/Offshore project manager taken complete ownership on Testing and Development team deliverables
- Having good knowledge on suspicious activity reports SMR/TTR (Suspicious Matter Report)
- Expertise into ISO NPP 20022 Payment message especially into AML & Sanctions alert monitoring using WLM QA workflow actions in Net reveal (Dertica)
- High Exposure to Alert/Case management process on generating alerts for AML/sanction alerts including validation of alerts for all the stages using WLM alert monitoring tool connected with NetReveal
- SPOC for all the requirements - Elicitation, Gap Analysis, FSD/BRD Preparation, Requirement Gathering and Analysis including Stakeholder management
- Data Mapping - have done end to end data mapping for Inbound/Outbound (300+ 485 fields manually) for SWIFT/NPP messages without using tool XML Spy
- Having high exposure to XMLSpy (Automation tool - XML & HTML tags)
- Normalisation techniques applied on OFAC_ALIAS WLM and World check monitoring specific to customer screening
- Expert knowledge in Domestic NPP payments and International SWIFT & Global payments monitoring process
- NPP implementation done from the scratch along with production support monitoring, Also actively involved in business UAT sign-off
Business Analyst
Bank of America
India, United States of America
02.2013 - 02.2014
- GWIM - Governance Risk and Compliance (GRC) - Trade Surveillance for Leading Bank in United States of America
- Led a team of 6 (SQL DB Team) to conduct an end-to-end review of the Trade Surveillance alert comparison on false positive alerts
- This was as part of a regulatory audit conducted by FSA (America)
- The objective of the audit was to test the operating effectiveness of controls within the bank's Trade Finance and AML processes
- This included verifying that the bank's AML Trade operating model roll out meet design objectives and testing the effectiveness of process of financial crime red flags investigation
- Review of the bank's AML and Trade data and generating alerts based on prediction/detection of various ranges from given baseline value to expected value
- Data analysis done using AIS (Actimize Intelligence Server, RCM & RCMD-Risk case Manager)
- Actively involved in Threshold Transaction Report (TTR) report monitoring task, to identify the suspicious transaction on the trade transactions
Business Analyst
Bank of America
India, United States of America
02.2013 - 02.2014
- CRAMR (Community Reinvestment Act Monitoring and Reporting) for large transformation program at BOFA
- CRAMR - Generates points and ratings across all the banks in united states of America
- Offshore SPOC and took the complete ownership on end to end delivery of all the projects on time with quality
- Reviewing customer's Trade account activity across Commercial lines of business to assess whether or not there are reasonable grounds to suspect that a transaction is related to Money Laundering or Terrorist Financing
- Taken complete ownership on data analytics on arriving % and interest calculations across the large volume of data (Teradata) using SQL server
- Based on customer income category - High, Low & Medium - the points and ratings get generated across all the nodes of CRAMR system which is connected with Lending, Investments and Services
- This also included filing of STR's [Suspicious Activity Transaction Reports] and providing recommendations on reduction of false positives
- SQL analysis, comparison and root cause analysis from DB vs real time data
Customer Service Engineer
SE-CO-VA e-Services
Chennai, India
01.2004 - 12.2004
- Trainee 'Plan design analyst' role on various plans of OE elections happens during November in US (to opt their Dental, Vision and other plans) 401k plans
- Played L1 support engineer role (PRODUCTION)
- Customer service done through production tickets L1, L2 & L3 support
- Analyzed various scripts to resolve P1 issues on PROD environment
- Used SQL Server Management Studio 12 to perform all those SSIS & SSAS activities
- Received high ratings on attending customer calls on production issues and addressed successfully with 100% customer satisfaction
Trainee Software Developer
Shriram Value Services
Chennai, India
01.2004 - 12.2004
- Worked as a Trainee programmer and developed few scripts to reduce the duplication of transaction data in Payment systems (Non-Banking financial services)
- SQL DBA: Normalized and Denormalized various database tables and provided various user access and permissions to different levels of user profiles
- Data modeling done - For an entire schema, To validate few in house requirements on the internal database system - By creating heaps of tables and keys in order to test various testing scenarios using local dummy data
- Data Migrations done successfully for couple of applications - Java web up-gradations
Senior Business Analyst
Telstra
Sydney, Australia
11.2023 - Current
- Mobile application Development
Business Analyst
Westpac Group
12.2020 - 12.2022
- Data Management Controls and Capabilities
- Westpac Group aimed to deliver one of the APRA requirement to trace the critical data elements (CDEs) from all Treasury related reports APS 120, APS 220 & APS 180
- Data Lineage & Data Governance - Requirement Gathering/Requirement Analysis and formalizing Data Risk controls for an APRA requirement on APS 120, APS 220 & APS 180
- Primarily into stakeholders management in order to capture a particular Westpac system Inflow and Out-flow details (Example: Account number-each table and field level details) in order to prepare Business data flow (BDFs) diagram for the business sign-off
- Identifying the technical/Business gaps and to conduct regular workshops, system walkthrough for sprint Demo in order to get the endorsement from 'Working Group' (Risk Team+Business Owners+ Directors)
- Customer Oriented - Interacted with bank customers/branch staffs in order to explain the process behind
- Also handled tough/Challenging stakeholders
- Prepared various process flow diagrams in areas of improvement in various projects in Westpac-via Infosys
Technical Business Analyst
Commonwealth Bank of Australia
04.2020 - 12.2020
- CSR(Customer Remediation Program from FSI Unit)-Advisor remediation cheque payment processing through Colonial First State Insight Tool
- CBA charged service charges from the customer account
- In order to repay back to the customer account, SAS automation process implemented at bank to complete this one off activity
- Managed critical stakeholders in order to obtain sign-off for various technical and business requirements
- Took complete ownership on Agile process end-to-end scrum
- Identified and interacted with customer on production tickets
- Customer services done thru IT Help desk team CBA for few customers
- Data analysis and data profiling using SQL Server management studio (2019) with huge amount of data
- Written Complex SQLs to retrieve huge data from multiple tables using JOINS
- Taken complete ownership on maintaining RTM (Requirement Traceability Matrix) up to date till successful delivery in AGILE
Technical Business Analyst
Westpac Institutional Bank
Sydney, Australia
02.2014 - 01.2018
- Credit score calculated using CDMS, the system connected with loan origination systems and it relates with S&P and Modi's rating along with Westpac own risk rating calculations
- Data Lead - Managed a team of 7 on Data modeling - helped to prepare Data definition tables and data interface specifications
- As a Scrum Master + BA - responsible for daily stand up, Sprint planning, Refinement and Retrospective sessions across onshore/offshore team including Sprint Demo and Sprint Review using JIRA board and Confluence
- Data Analytics done using SQL server, MS-Excel and PL/SQL developer GUI
- Actively involved in APRA regulatory changes on APS115, APS 120 and other CPL (Consumer Property Lending) in order to include property details into various source systems (Loan origination systems - Optimist/Murex/Credit Connect) in the credit risk system (CDMS)
- Requirement analysis conducted using various brainstorming sessions with onshore
- Also proposed various business solutions and financial advices in various streams like Asset management, bonds, equities and Mutual funds
- Responsible for daily update on RTM (Requirement Traceability Matrix) & RAID (Risk, Assumptions, Issues & Dependencies) to have FSD [Functional Specification Document] up to date
Technical Business Analyst
AMP Australia
India, Australia
01.2010 - 01.2012
- Worked as a Business Analyst on AML investigation and monitoring Alerts for a leading bank in Australia - AMP (Offshore)
- Led a team of 4 to perform a detailed review Data Migration from Talisman converges
- (Data transfer - using Oracle 12g Data migration)
- Involved in Data Migration activities for talisman conversion, Service converges & funding advice space on developing unix shell scripting in order to fine tune an existing process and flow
- More on UNIX Shell scripting Coding and development along with Techno Functional Document preparation
- Owned Data migration activity - Written Complex Documentation procedures, cursors, triggers to verify the data base tables and rows count after successful data migration
- Data validation done after successful data movement and the total table/rows counts verified
Module Lead
Verizon Data Service Private Limited
Chennai, India
01.2007 - 01.2008
- Completely into Coding and Development on Oracle PL SQL Server, Erwin & TOAD
- Worked on PL/SQL, SQL server including UNIX shell scripting, Created various Data Masking scripts to not show an actual customer production data
- Developed various scheduler jobs and shell scripting programs to execute the daily Jobs in DBMS_Scheduler and control M jobs using UNIX
- Oversaw each project's technical requirements and completed every milestone on time
- Implemented new payment API for company-wide deployment and integration with third parties including supply chain management using advanced tools
- POC done for couple projects using ETL / Data warehousing tool - Informatica BI Server
- Data Migration done successfully and web logic upgrade done from versions 3.0-4.0
- Table counts and Rows verified using SQL queries and procedures
Senior Software Developer
ARICENT Technologies
, India
09.2004 - 09.2007
- Written Complex SQLs to match the records count and data from DB vs Real time
- Played vital role in Sony Ericsson Research and Development unit - On Identifying the post/pre paid plans and Tariff plans
- Test Lead - Reviewed all the test case scenarios in QTP Server
- Created Automation scripts for couple of requirements using Mercury QTP
- Data Modeling - Created/designed a complete DB tables and columns along with primary keys and other dependent keys
Education
High School Diploma - Computer Science and Engineering
E.G.S Pillay Engineering College (AUTONOMOUS)
TN, India12.2004
Skills
- Stakeholder Management
- Communication
- Team & Project Management
- Customer-oriented
- Requirement Gathering
- Business / Technical analysis
- Process Improvement
- Lead Generations
- Impact Analysis[As is, To be]
- Workshops/Brainstorming
- Team building Activities
- Microsoft Visio
- SQL Proficiency
- TOAD and Erwin
- Oracle PL/SQL Developer
- SQL /Oracle PL/SQL expert
- Data Risk & Governance
- SAP Business Objects
- Python
- Power BI
- APIs
- SQL Server
- UNIX/Shell scripting
- Shell scripting
- HTML/XML
- Data analysis
Certification
- Oracle Certified Associate (OCA) - PL/SQL
- Microsoft Certified Professional - SQL & C# Dot
- CSM Certified Scrum Master - Scrum Alliance
- Six Sigma Yellow belt - Data Analytics
- Generative AI - Artificial Intelligence(AI) & Machine Learning(ML)-TBC
Accomplishments
- Automated Bank of America employees onboarding work to ease the access to new joiners pack, reduced the timeline from 40 days to 7 days.
- Conducted larger presentations such as 'Employee Health & Safety Packs' to a larger audience across the floor during Westpac internal Town-hall meet.
- Suggested various process improvement steps in auditing process at Bank of America.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Senior Business Analyst
Telstra
11.2023 - Current
Business Analyst
Westpac Group
12.2020 - 12.2022
Technical Business Analyst
Commonwealth Bank of Australia
04.2020 - 12.2020
Business Analyst
BT Superannuation
01.2019 - 07.2019
Technical Business Analyst
Westpac
01.2019 - 07.2019
Technical Business Analyst
Westpac Institutional Bank
02.2014 - 01.2018
Business Analyst
Bank of America
02.2013 - 02.2014
Business Analyst
Bank of America
02.2013 - 02.2014
Technical Business Analyst
AMP Australia
01.2010 - 01.2012
Module Lead
Verizon Data Service Private Limited
01.2007 - 01.2008
Senior Software Developer
ARICENT Technologies
09.2004 - 09.2007
Customer Service Engineer
SE-CO-VA e-Services
01.2004 - 12.2004
Trainee Software Developer
Shriram Value Services
01.2004 - 12.2004
High School Diploma - Computer Science and Engineering
E.G.S Pillay Engineering College (AUTONOMOUS)
Hobbies and Interests
- Books
- Dance
- Event Management
- Badminton player
- YOGA instructor
Summary
18, 10, 5, Risk and Compliance, Banking, Trade Finance, Insurance, Superannuation, Non-Banking IT (Telecom & ADTIs)
Activities
- Played Domain and Technical Trainer role in Trade Surveillance, Anti-Money Laundering(AML/CTF-Counter Terrorism Financing), AML/SANCTIONS & FATCA/CRS for ACTIMIZE Technology for various Development centers across India.
- Twice received 'Exceeded the Expectations' band at Infosys.
- Received 'Game Changer' spot Award in Westpac - Sydney for delivering complex requirements within given timeframe.
Personal Information
Work Permit: Australian Citizen
Hobbies and Interests
- Books
- Dance
- Event Management
- Badminton player
- YOGA instructor
Summary
18, 10, 5, Risk and Compliance, Banking, Trade Finance, Insurance, Superannuation, Non-Banking IT (Telecom & ADTIs)
Activities
- Played Domain and Technical Trainer role in Trade Surveillance, Anti-Money Laundering(AML/CTF-Counter Terrorism Financing), AML/SANCTIONS & FATCA/CRS for ACTIMIZE Technology for various Development centers across India.
- Twice received 'Exceeded the Expectations' band at Infosys.
- Received 'Game Changer' spot Award in Westpac - Sydney for delivering complex requirements within given timeframe.
Similar Profiles
Sojad HydariSojad Hydari
Assistant Store Manager at TelstraAssistant Store Manager at Telstra
James NaumovskiJames Naumovski
Telecommunications Technician at TelstraTelecommunications Technician at Telstra
Madhumita ChoudhuryMadhumita Choudhury
Technical Business Analyst at TelstraTechnical Business Analyst at Telstra