BA

Navpreet Singh

US Citizen

ad5tql@r.postjobfree.com 347-***-****

SUMMARY:

** *****’ experience as Business Analyst in Financial services, Banking, Commercial lending and Capital Markets.

Experienced in Business Analysis, Data Analysis, Business process modeling, Use Case Modeling.

Good working knowledge in SDLC methodologies, Agile, Rational Unified Process (RUP) & Waterfall

Good working experience in requirements gathering, brainstorming workshops, interviews with stakeholders/users/Subject matter experts.

Financial products Knowledge in Fixed Income, Futures, Options, Interest Rate Swaps, Mortgage Backed Securities, FX Swaps and Cross Currency Swaps.

Worked as an SME in Investment Banking Operations and lead Business Analyst in IT

Working knowledge in Credit Risk (PD, LGD, EAD), economic capital and IPV calculations.

Working knowledge in spreading financial statements, key performance indicators (KPI) for Bank, NBFI, Financial Markets and Real Sector to produce Credit Risk Rating.

Hands - on experience in Corporate Project and Financial Planning and Analysis, Budgeting and Forecasting at enterprise and business unit levels

Senior Business analyst for Trade surveillance and AML process with experience in Actimize platform models.

Hands on experience working with SailPoint IIQ workflow solution.

Working Knowledge in the price verification of mortgage backed securities.

Gather, identify, research and document Business requirements and meetings with business to determine scope

Thorough understanding of Anti Money Laundering (AML) procedures and hands on experience of working to insure AML compliance at client’s place.

Extensive experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Creating Request for Proposals (RFP), creating Requirements Traceability Matrix (RTM).

Strong subject matter expertise in Credit Card Industry, Retail/Investment Banking, Bonds, Derivatives, Risk Analysis, Mortgage Loan Origination, Processing and Loan Servicing.

Experienced in gathering business requirements, functional requirements, conducting GAP analysis, Impact analysis, current state analysis and proposed state analysis.

Produced deliverables business requirements, functional requirements, functional specs, process flows, use cases, process mockups, test plan, test cases and test summary for sign off.

Experienced in testing, working with QA teams and business users in conducting SIT, UAT, Regression testing and Stress testing including BUG triage.

Strong working knowledge of financial planning concepts, including asset allocation, goal planning, portfolio analytics, trade life cycle, clearing and settlement.

Extensive experience in working with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Ordination, Secondary Mortgage Market.

Develop high level of subject matter expertise within AML Risk Analytics.

Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Performed data analysis

Design and development of Data warehouse for Business Intelligence data marts and reporting.

Analyze Credit and Equity OTC Derivatives Trading Life Cycle to improve legacy and proprietary trading process & systems.

Coordinated with off-shore teams like business analysts, developers & testers in the development and testing activities

Worked in team environment and developed relationship with external customers and internal counterparts.

Good analytical, problem solving, organizational, communication and documentation skills with the ability to handle multiple tasks effectively and quickly master new concepts and subjects.

Proficiency in transforming business requirements into functional specifications focusing on workflow analysis and design, user interface design, and process flow modeling

Extensive knowledge in business process reengineering of Fixed Income, Investment Banking, Foreign Exchange FX, Settlement, Accounting and Clearing of Securities.

Awareness on credit risk management - Exposure at Default (EAD), default probability (PD), estimation of Loss Given Default (LGD), Capital factor and Stress testing based on regulatory scenarios.

Strong understanding in Capital Markets, Fixed Income, Equities, Risk management Over the Counter (OTC)Trading life cycle

Accomplished Senior IT professional with a background in business intelligence, reporting systems, data quality including ETL and full life-cycle development.

Experience in Anti-Money Laundering (AML), know-your-customer (KYC), customer due diligence (CDD), sanctions and payment screening, AML transaction monitoring, AML Risk assessments, and AML systems tuning and optimization

Utilized PL/SQL stored procedures, functions, packages and triggers and SQL queries programming to create business logic

Strong knowledge in Treasury, Asset Liability Management (ALM), Custodianship, Asset management, Derivatives, Futures, Swaps, Options, Alternative investment, Investment banking, Equity, bonds

Lead and organized Requirements gathering sessions and JAD sessions before groups of Subject Matter Experts as needed in order to document decisions regarding future state of business processes

Designed Business Requirement Documents (BRD’s) and modeled use-cases using UML diagrams such as Activity Diagrams, Use Case Models, Business Process Flow Charts using Lucid charts, MS VISIO.

Good Understanding of financial derivative like Futures, Options, Swaps, Foreign exchange.

Knowledge of Order management system, Brokerage, Fixed income securities and FIX Protocol.

Strong project management skills including planning, scheduling, work break-down structure, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.,

Experience in Use Case Analysis, creating Key performance indicators KPI, Enterprise Risk Management, Business Continuity Planning BCP, and Change Management

Extensive Data Warehousing experience using Informatica as ETL tool on various data bases like Oracle, SQL Server, TeraData, MS Access.

Strong understanding of user story writing, acceptance criteria definition, and sprint backlog management.

Experience in customer / client interaction, deep understanding of business systems functionality and technicality environment, and have the ability to acclimatize to new technologies and situations with ease

Perform data analysis, data mapping and data validation in support of an AML system project, Data analytics capabilities and demonstrated experience in analytics platforms Python, R) for data mining and statistical analysis

Strong analytical, problem solving, decision making and project management skills. Proven success in Business Requirement gathering, Analysis, Business Process flows As-Is and To-Be, JAD sessions, UAT, Cost Benefit Analysis and Workflow Management Tool

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Lucid Chart, Telelogic System Architect

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD, ETL, Informatica 7.1.1/6.5

Testing Tools: LoadRunner, Test Director, Mercury Quality Centre, JIRA

Operating Systems: MS Windows NT/98/95/2000, UNIX

Languages: SQL, UML, JAVA HTML

Database: SQL Server 2000, MS Access

Utility: MS Office Suite [Word, Project, Excel, Visio, Lucid Chart,PowerPoint], Adobe Acrobat Suite, AWS

PROFESSIONAL EXPERIENCE:

Hilton Capital Management, Garden City, NY May 2020 - Present

Business Analyst

Assisted in creation of Business Requirements, conducted JAD and one to one sessions with SMEs and Business Users

Analyzed the user/business requirements (BRD), functional specs (FSD) and Use Case System documents

Applied RUP methodology to achieve Application Development

Served as a liaison between Clients and Technical Staff to resolve conflicts

Conducted the FRS and URS reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study

Involved in preparing Test Plans based on User Requirements Document (URD/ BRD) and prepared the Test Cases and Procedures

Perform Data analysis, Data mapping and data validation for DQ Rules for AML system

Generate business requirements, and built Business Requirements Document (BRD/FRD/ICD) that inclusive of business case, scope, LOB requirements

Collaborated with product owners, developers, and QA engineers to define acceptance criteria and ensure alignment with business objectives.

Performed data analysis on all the data sources, data dimensions and data elements in Trade Surveillance and settlement platform migration.

Collected & sourced compliance data requirements for AML and KYC data, as it moves through from source to surveillance, mapped the data to Mantas for alert generation and detection of illicit transfer of funds.

Actively involved in User Acceptance testing (UAT) and Training to the end users

Assisted with change, issue, quality and risk management activities. Generated management reports on weekly and monthly basis.

Conduct detailed analysis of equity swap transactions, including pricing, valuation, and risk assessment.

Collaborate with trading desks to develop and implement strategies for optimizing equity swap portfolios.

Expertise in SailPoint lifecycle Manager, Compliance Manager and Access Governance modules.

Categorized, prioritized and scrubbed requirements to manage project scope. Used customizable attributes such as priority, status and difficulty for each requirement in order to organize and prioritize

Performed GAP analysis during the conversion process

Provided the best practices for SailPoint functionalities and implementation.

Investigated the use of data flow-based testing to identify the presence of faults in active rules written in SQL

Facilitated Bug and Defect report meeting

Provided direct technical evaluation of third-party products for inclusion in IAM solutions and define software development processes.

Trade Surveillance transaction monitoring - segmentation and scenario analysis.

Evaluate AML transactional monitoring system models, includes tuning & testing of scenarios and thresholds

Knowledge in IAM-related standards such as SAML, SOAP, LDAP, Open-ID, and OAuth.

Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.

Created PowerPoint on Trade life cycle process (including Equity, Fixed Income, Derivatives workflow) for new users within technology group.

Participation in the Credit Risk Adjust Analysis like Estimation of PD, LGD and EAD.

Worked with the Enterprise Datawarehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process

Carried out Financial planning and Investment analysis for a series of construction projects

Defined information architecture for websites, including wireframes and navigation

Thorough understanding of IFRS, FINRA, FinCEN, Dodd-Frank, MiFID, Basel III

Facilitated the project meetings, maintained issues log, coordinated with users, technical and operations personnel as part of Joint Application Development (JAD)

Provide AML guidance, advice and risk-based solutions to complex regional business issues/initiatives for LOB's products range

Work with AML Compliance Officers to review audit findings, evaluate the business corrective action plans CAP to deal with issues

Understood the AML trade surveillance compliance requirements by interacting with compliance department and SME experts in the laws/act of compliances.

Outstanding data analysis skills including data extraction from MS - SQL database, data mapping from source to target schemas, and data cleansing and preparation

Manage ServiceNow projects, including scoping, estimating, resource planning, and delivery management

Strengthen OTC derivative reporting process by highlighting reporting inconsistencies.

Assisted with application setup issues and contributed through the troubleshooting process

Excellent understanding and knowledge of Identity and Access Management (IAM) and Role Based Access Control (RBAC)

Monitored data conversions and potential impact on the systems & processes

Good exposure in trade life cycle and trading compliance.

Worked with UAT team to come up with tests to validate accuracy of financial data imported in the global repository

Successfully completed the User training sessions, deployment, production testing and deployments

MasterCard, Harrison, NY Nov 2018 – Mar 2020

Business Analyst

Participated in the creation of Business Process Workflow Diagrams with Stakeholders

Involved throughout the business solution Development Life Cycle

Conducted meetings with business users and SMEs to identify and gather various functional and non-functional requirements; gained extensive experience in requirement elicitation and creating Business and Functional Specification Documents

Assisted in strategically identifying and developing goals and objectives according to business needs aligned with Loan Services and organizational goals

Developed good understanding of Mortgage loan in Origination process

Helped in creating Use cases from an end user perspective by understanding loan processing and claim approval

Conducted GAP analysis of different reports being presented to clients to accommodate their requirements for new enhancements

Good knowledge on Basel standards set forth for managing credit risk and operational risk for Capital

Applied Rational Unified Process (RUP) to the solution life cycle

Used Azure integration Service - SQL Server Stretch Database to migrate transactional database with cold data securely to Azure Cloud.

Analyzed equity swap transactions, including trade lifecycle events such as resets, terminations, and novations.

Worked on Data modeling, Advanced SQL with Columnar Databases using AWS.

Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

Applied processes, standards, and procedures to create a Business requirement Document (BRD) of Mortgage application

Created artifacts such as Use Cases, Activity Diagrams, and Sequence Diagrams using MS Visio

Participated in team meetings to improve overall implementation process

Played a key role in planning, testing, and implementing system enhancement requests

Involved in using bug tracking tools like bug-zilla, and Rational Quality Manager combining a clean, fast interface for capturing and organizing issues with customizable workflows

Designed and developed use case diagrams and activity diagrams using UML diagrams in Visio.

Jointly worked with the testing team in validating the EAD, LGD, PD and regulatory capital calculations reported by the system developed by the technical team.

Involved in implementing strategies to enable data flow from the loan servicing system to various downstream system including regulatory systems.

Involved in the development of risk management strategies to mitigate market and credit risks associated with equity swaps.

Create comprehensive user stories with thorough acceptance criteria for development work.

Analyze business requirements and document them appropriately in the form of user stories in Jira and/or Azure DevOps.

Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.

Leading the Trade Surveillance activities for fixed income and equities: BRD, Implementation of incident methodology, monitoring threshold. Liaise between the users and the development team. Act as the focal point for QA and production problems

Aided the QA team in understanding the system and developing effective test plans, by conducting sessions

Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.

Applying PROC LOGISTIC to create a logistic regression for identifying which characteristics can influence on probability of default (PD).

Create and maintain product backlog items, bugs, features, etc. in JIRA and TFS / Azure DevOps for story tracking and documentation.

Utilizing automatic stepwise procedure to develop the logistic regression analysis from the strongest candidate predictor to weakest predictor.

Worked closely with the development team to provide clarification and guidance on user stories and acceptance criteria during sprint execution.

Conducted user acceptance testing (UAT) to validate that the implemented features meet the defined acceptance criteria and user expectations.

Analyzing Akaike information criteria (AIC) and Schwarz criterion (SC) to determine which variable can influence the probability of default (PD) most.

Involved in technical and multiple lines of business resources for AFS Commercial Loan System, Data Warehouses and Client digital website.

Worked with the business group to document functional requirements for Order management system, trade lifecycle process enhancements, including new functionality, version upgrades, and reporting requirements.

The Detailed Business requirement document contains the Business requirements, system requirements and the data requirements required to be available in the Data warehouse.

Manage and deliver projects, conduct analysis to determine requirements for effective AML system implementations

Work with AML Program to identify relevant KRIs, Typologies and appropriate regulations for monitoring rules for all products and customers

Develop creative solutions to complex problems, validate requirements with stakeholders, and provide the optimal IT solution using JIRA.

Conducted risk adjust assessment of the project and trade surveillance for regulatory purposes.

Performed Surveillance of Employees accounts to detect potential insider trading, market abuse, and/or violations of the Trading Policies for Trade Surveillance/Compliance.

Supported operations & maintenance of SailPoint and LDAP connectivity

Responsible for current IAM tools to Framework mapping

Conducted training sessions for the users and also prepared user manuals for better understanding of the designed system for the users.

Performed Gap analysis for upcoming Payments data warehouse project by working with different department teams in Capital one, to see how much of the Payments data is already available in the different Data warehouses and documented the gap analysis results in a efficient manner.

Performed additional tasks as assigned, improving the effective administration of the AML and KYC Policies.

Identify and document detailed current major IAM Service Gaps (Gap Analysis) or deficiencies for processes, products and tools

Worked with SME’s to develop Maturity Model for improving IAM maturity over time

Worked with the SME’s and key stakeholders to assess current and target state maturity for each IAM capability in the Framework

Engage the firm’s combined Investigations unit, including ensuring the continued integration of legacy functions such as AML Investigations

Conducted JAD sessions during various stages of upgrading the existing system to discuss the current system requirements

Helped identifying reports for decision support system and interacted with database designers and architect for gathering the requirements for reporting

Extensive data cleansing and analysis, using pivot tables, formulas (V-lookup and others), data validation, conditional formatting, and graph and chart manipulation using excel

Worked closely with the Lead Business Analyst to monitor progress, and the deliverables for the project

Involved in GUI Testing, Unit Testing, System Testing, Integration Testing, Regression Testing.

Involved in Preparation and execution of Test Plans, Test cases, writing Test scripts using Test Director

Reviewed System Test Plans, wrote test scripts and worked with business stakeholders to validate and execute the test scripts.

Citizens Bank, Cranston, RI May 2017 – Oct 2018

Business Analyst

Engaged with the pricing & price verification business users to understand the price verification business process

Involved in the root cause analysis and proposed new business requirements related price verification of Securities, Loans and Derivatives.

Performed business analysis to gather business requirements for the price verification of various mortgage backed securities (Single Family, ARM and Multifamily).

Involved with IPV users and developers to discuss the price verification functions and solutioning the business requirements.

Performed data analysis and data mapping from the source systems to price verification systems to ensure data is captured for calculating the expected market prices and variances.

Lead the User acceptance testing and Regression testing in testing the calculation of prices and their variances.

Developed test cases to test pricing & price verification functions for securities, Loans and Derivatives.

Responsible to ensure that User acceptance testing and Regression testing complies with Software Development Life Cycle (SDLC) and Sarbanes and Oxley Act (SOX) guidelines.

Involved with the business users to develop the revaluation process for General and Specific loss reserve accounts that are reported in the balance sheet in the local currency instead of USD for the Investment Portfolio reporting.

Performed data mapping for the chart of accounts from Moody’s Financial Analytics to the financial templates that was developed for Bank. Financial Markets and Real Sector.

Provided direct technical evaluation of third-party products for inclusion in IAM solutions and define software development processes.

Developed the Business Requirement Documents (BRD's), Designed Functional Requirement Documents (FRD's).

Used AWS command line client and management console to interact with AWS resources and APIs.

Conducted market research and analysis of trends in the Foreign Exchange market to provide insights for decision-making

Worked on design and documentation of Workgroups, roles and policies in Sailpoint.

Set up an automated application user certification campaign for approval of the access and privileges for certification.

Generated reports for each application for audit purpose.

Identified IAM functional areas in scope and involve in Trusted Third Party market analysis for IAM

Worked with the SME’s to define the future state of an IAM solution to adequately prepare for the build, test and implementation stages

Responsible to develop IAM term glossary

Worked with the IAM team to develop IAM Roadmap and Release Plan by identifying gaps between the current and future state and identifying initiatives for proposed future state solutions not available in current systems

Exemplary knowledge and experience in the Financial Investment Banking industry with clear conceptual understanding of various financial instruments such as equities, bonds, fixed income securities and derivatives, and asset/portfolio management.

Experience in writing, testing, and implementation of the triggers, stored procedures, functions at Database level using PL/SQL with SQL queries.

Extensive use of JIRA to create user stories.

Worked with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in Regulatory Reporting regulatory reporting application Axiom.

Worked on Capital Market data analysis(Future, Options, Fixed Income, Cash, Currencies etc)

Experienced in acquisitions and mergers, asset utilization, internal controls, financial strategies, financial modeling and forecasting, financial planning, budgeting and fiscal controls as well as cost analysis with emphasis on high level financial reporting.

Lead the User acceptance testing and regression testing life cycle.

Developed test cases to test the credit risk rating modules and spreading the financial templates to ensure the calculations by the financial templates and the PD and LGD ratings that is produced by the system are accurate.

Reviewed the UAT test cases and test results with the business users before UAT test sign off to ensure test results are as expected.

Worked closely with loan officers to implement functionalities in Cassiopae related to long term loans (fixed and variable), Libor loans, ABR loans, Syndicated loans,

Reviewed the test cases and test results with the business users before UAT test sign off to ensure test results are as expected.

BMO Harris Bank - Peoria, IL Feb 2014 – Apr 2017

Business Analyst

Worked with the business Stakeholders and SME’s to define business requirements and analyze the functional requirements

Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management

Facilitated JAD sessions with management, users and other stakeholders to define the project and also to reduce the turn-around time of deliverables

Prepared and presented Business Requirement Document (BRD) and Functional Requirement Document (FRD)

Managed day-to-day project activities and coordinated tasks with other teams

Worked closely with the UI team to model the screens

Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements

Reviewed prototypes, solution blueprints, and project scope to ensure that the needs of the business are being met

Used a combination of Waterfall and Agile(SCRUM) Methodology on the project

Translated the requirements to the IT and web production teams to facilitate their HTML builds for the projects

Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using Rational Rose following the UML methodology

Created Screen mock ups to illustrate new requirements and alignment around project scope using MS Visio

Defined testing objectives and verified the requirements to be testable

Responsible for managing the documented System Requirements and Requirements Traceability Matrix using Rational Requisite Pro

Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.

Utilized Toad for Oracle for running appropriate SQL queries for data validation.

Responsibilities also included QA Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing

Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test

Provided support for User Acceptance Testing with UAT cases and resolved issues with the users.

EDUCATION

Bachelor of Arts from The City University of New York, NY

Contact this candidate