Sonal Nougrahiya - Avaloq Consultant Specialist - HSBC India Pvt Ltd

Summary

IT professional with 14+ years of experience in development, implementation, and support of application software, with strong expertise in Oracle SQL/PLSQL, ETL, and Unix. Possess a deep understanding of technology with a strong focus on delivering effective business solutions, including 4 years of hands-on experience as an Avaloq Core Banking System Developer in core banking implementation and customization.
Strong expertise in Avaloq scripting (PL/SQL-based), parameterization, interfaces, and regulatory reporting. Proven track record of delivering scalable banking solutions across retail, private, and wealth management domains.
Extensive experience in requirement analysis, design, development, and testing across the full Software Development Life Cycle (SDLC), working in Scrum and LeSS Agile environments.
Good knowledge of ETL processes and Data Warehouse applications, with strong analytical and problem-solving capabilities.
Quick learner, highly adaptable, well-organized, and reliable team player with a strong commitment to quality and continuous improvement.

Overview

14

years of professional experience

3

Certifications

Work History

Avaloq Consultant Specialist

HSBC India Pvt Ltd

Pune

04.2022 - Current

Project: Global Advisory Platform (Aladdin – BlackRock Integration)

Customizing Avaloq products and enhancing features aligned to HSBC business needs.
Performed parameterization including Keys, Additions, Classifications, Workflows, Context Actions, and Order Validations.
Developed Pre-Trade Check solution integrating client portfolio data with Aladdin Wealth (BlackRock platform) for risk assessment prior to trade execution.
Facilitated integration with portfolio management systems, enhancing data flow and accessibility for investment processes.
Worked extensively on Avaloq Messaging Interface Web Services (AMIWS) and integrated investment proposals from the ART system via the Avaloq API, leveraging the investment proposal metatype to generate STEX transactions.
Implemented business rules to generate CRM alerts for significant percentage changes in asset prices across multiple asset classes, including equity, fixed income, and structured products.
Developed Internal Target Market (Internal TM) logic based on Asset Class/Subclass and MiFID complexity; built AVQ logic for Internal TM data extraction in the Security Master File (SMF).
Experienced with inbound and outbound data feed and reporting in Avaloq and batch jobs for regulatory compliance.
Collaborated closely with business stakeholders for requirement gathering, impact analysis, solution design, and validation.

Application Specialist

ATC India Tower Corporation

Gurgaon

12.2021 - 04.2022

Lead – Technology

IRIS Software (Client -Citi)

Noida

12.2019 - 12.2021

Senior Software Engineer

Optum Global Solutions (UHG)

11.2015 - 10.2018

Software Development Analyst

Dell International Pvt Ltd

Bangalore

08.2010 - 04.2014

Education

Bachelor of Engineering - Computer Science

Bansal Institute of Science And Technology

Bhopal

06.2009

Skills

Avaloq Core Banking:
Avaloq Customization (Classes, Keys, Workflows, Additions, Restrictions, Reports, Static Data), Avaloq Parameterization, Avaloq Scripting, Avaloq Questionnaire, Avaloq Interfaces, Avaloq Messaging Interface, Pre-Trade Check Solutions, Portfolio Integration
Programming & Databases:
Oracle(SQL/PLSQL),Sybase,Postgres
Scripting:
Unix Shell Scripting, Python
Data analysis

Scheduling Tools:
Control-M, AutoSys
Version Control:
GitHub, Bitbucket,TFS
Service & Project Tools:
ServiceNow,Jira,Confluence

Data & Integration Engineering

(10+ Years Experience – Prior to Avaloq Consultant)

Before transitioning into Avaloq consulting, held Senior Developer roles with a strong focus on data integration and Oracle database development (SQL/PLSQL). Contributed extensively to solution design, system integration, and application performance optimization. Built a solid technical foundation in enterprise application architecture, backend development, and database performance tuning, which now strengthens solution delivery within Avaloq engagements.

Key Responsibilities & Achievements:

· Designed, developed, and optimized complex Oracle SQL/PLSQL solutions, including stored procedures, functions, packages, triggers and collections.

· Good experience in Function, Stored Procedure, Packages, Triggers, Collections, Index, Table Partitioning, Views, Cursors, Materialized Views, Joins, Analytical functions

· Delivered and supported ETL workflows using Informatica and Talend; performed data migrations from Oracle to PostgreSQL environments.

· Executed bulk data loading using SQL*Loader for processing flat files into database tables.

· Developed Unix shell scripts to automate data loads, execute database objects, and support batch processing.

· Improved overall system performance through SQL tuning, query optimization, performance analysis and debugging.

· Worked closely with business analysts and stakeholders for requirement gathering and implementation.

Certification

ITIL Foundation Certificate in IT Service Management (Version 3)

Timeline