Systems Analyst Business

Location:

Concord, ON, Canada

Posted:

September 12, 2025

Contact this candidate

Resume:

DEEPAK SACHDEVA, PMP

1-647-***-**** (cell) **************@*****.***

lead Business systems Analyst/project Manager

Versatile Senior Business Systems Analyst leader with a proven record of Quantitive data analytics and software solution development and project delivery in dynamic financial/ Capital markets environments. Strong experience in leading all phases of Software Development and Testing Lifecycle with expertise in the Development, Implementation, Integration, Functional, User Interface and Regression testing to drive process improvement and solution development within project budgets and test timelines to achieve business objectives.

Brings a strong knowledge of various capital market products including Asset Management, derivative pricing, risk methodology systems and infrastructure, predictive modelling, statistical methods and processes, Trade life cycle, Hedge funds, Equities trading, Wealth Management, Market risk, Liquidity Risk, Counterparty Credit risk, CCAR And Credit management, Economical capital (EC),PFE,CECL(Current expected credit loss), Stress and Value at risk (VAR) calculations, derivative pricing, Capital Markets Regulatory reporting and Investment Banking. Successfully deliver high-quality solutions for large trading systems in a fast-paced environment.

Expert hands-on key technological areas/skills include working on databases SQL Server/Sybase, Oracle and NoSQL, Spark SQL,Hadoop, Hbase, Casandra, MongoDb and ElasticSearch. Strong data modeling, data management and business Intelligence report creation skills including writing and executing high performance complex SQL queries on multiple database environment.

Education:

Bachelor of Engineering, Computer Science, India – Marathwada University 1995

Executive MBA in Applied financial Management – Venkateshwara Open University 2018

PMP certification from Project Management Institute - 2012

Applied Data science and data analytics from Columbia (Emeritus) University 2019

Working on CFA level 1 certification

Key Areas:

Business/Product Skills:

Hedge Accounting, IFRS 9/17 Intraday reporting Derivatives/Investment

Project Delivery Data Modelling Valuations

Interest Rate Derivatives Market data and attributes Regulatory capital assessment

BCAR/RCAP Compliance Regulatory & Economic Capital Hadoop/Spark SQL

OTC Derivatives and collateral Team Leadership Credit Risk (CCR, EC and VAR)

Model Understanding Assist SME Model development UAT Test scripts creation & Execution

Capital Markets UAT test case Execution Regulatory reporting

Data Analytics Large Dataset Analysis Business & credit Analytical skills

Process/Data mapping Model implementation Change management (OCM)

Tools/Platforms:

EXPERIENCE

COTS products (Fidessa, Calypso, AXIOM, Openlink FINDUR, Algorithmics RisWatch),Bloomberg(TOMS), JIRA, Hedge Accounting and IFRS 9/17, Tradeweb, MMI, PXE Anvil,, Markit EDM (Cadis), RefData,Oracle EDQ (Datanomic), SimCorp (SCD), Findur (OLF),Charles River (CRD), SunGard Adaptiv, TopQuadrant, SharePoint, MS Project, MS Office, MS Visio, Confluence, wiki, Agile /Scrum Methodology, algorithmic risk watch, Websphere, PMBOK, Power BI, Power Cubes, Rational HP Quality Control, Riskwatch, Algo, IBM Rational QC, Murex, Calypso, ERWIN, Sybase, Informatica Metadata Manager, Oracle, SQL Server, NoSql, Spark SQL,Hadoop, Hbase, Mongodb, ElasticSearch, Cassandra, .SSRS, SSIS, Oracle Power designer, Kafka, Nifi, Spark, Visual Basic,Python scripting,Pyspark,Shell scripting, R, Java, C++,Unix, Linux, FPML,XML,JSON,HP Quality control, Oracle Reports, SAP Business objects, SAP Power Designer,SQL Developer, GIT/GitHub version control, Perforce, Power BI

CIBC (Canadian Imperial bank of commerce) MAY 2025 to TILL DATE

Lead Business Systems Analyst /Project Manager

Project: Operational Resilience program E21 OSFI guidelines implementation following Operational risk Management principles.

Conduct functional business reviews with business stakeholders to document business requirements and analyze issues. Elicit and document system specifications along with the business requirements to implement the additional required data points as per the E21 guidelines for Operational Resilience

Analyze, recommend and implement the required updates for critical Operational resilience and Operational risk management reporting to key business stakeholders. Analyze and investigate large dataset, derive findings and map process and data for end-to-end requirements flowing through the CIBC operational systems.

Understand and deliver critical operational resilience components: Scope, Critical operations (CO) inventory, end to end process maps, Asset registry, tolerance for disruption statements and establish thresholds, scenario testing and action plans and reassessments for products including Corporate Lending, Trading systems and Capital Markets etc.

Display proficiency in analyzing trends and patterns within existing process, statistics and data sets to derive meaningful insights and adding value to resilience development of business operations.

Conduct data mining and identify the key performance metrics. Identify, support, and track key performance indicators (KPIs) to measure operational effectiveness. Enhance the capability in designing dashboards that provide real-time insights into operational performance and resilience metrics.

Display technical expertise in utilizing data visualization tools such as Power BI, SQL and advance Excel pivot tables, Power Query etc. to create effective visual representations of data and asset registry.

Perform complex joins to retrieve data sets from Excel and SQL for reporting, findings and analysis.

Competently developing clear and comprehensive process documentation to support operational procedures and methodologies. Display ability to create user-friendly guides and standard operating procedures that facilitate understanding and adherence to operational resilience methodologies. Review and provide effective feedback on process and user documentation to improve standards.

Develop clear and comprehensive process documentation to support operational procedures and methodologies. Create user-friendly guides and standard operating procedures to facilitate the understanding and adherence to the operational resilience methodologies. Review and provide effective feedback on process and user documentation to improve standards.

Create clear, concise reports, process maps, and presentations to communicate insights, technical debt resolutions, and recommendations to stakeholders at all levels.

Display effective communication skills with strong written and verbal communication to prepare materials, deliver presentations, and interact effectively with the business partners. Demonstrate the ability to meet deliverable timelines independently and proactively.

Present continuous Improvement mindset by commitment to ongoing learning and adaptation of best practices to enhance operational resilience. Proactively display the ability to pilot the approaches, learning and shifting based on the feedback from business users and Operational resilience team as required.

Good understanding and experience on credit risk management, RWA and trade lifecycle for all the financial capital market products including Fixed Income (Bonds), Credit (Derivatives, swaps), Rates (Loans, Interest rate derivatives, swaps),Foreign exchange, Equity,REPO (Repurchase agreements and security processing lending and borrowing), and Commodity.

BANK OF MONTREAL AUGUST 2024 to APR 2025

Lead Business Systems Analyst /Project Manager

Project: Financial Consolidation replacement and Build STAR ETL Datawarehouse Capital Markets and GL Accounting

Gather business requirement documents, and track business requirements through the Work Request or project processes adding value, as needed, to the design/analysis for ETL and testing phases

Perform data analysis and data mapping for the ETL project for STAR rebuild doing across source and target systems feeding into new Datawarehouse built for reporting financial data into credit monitoring systems.

Work closely with business stakeholders to understand business needs and enhancements and translate them into requirements with traceability of requirements from initiation to execution.

Produce documentation for FIM Interface jobs and workflows within the complicated SAP business objects BODS Application loading data through FIM interface into financial consolidation FC layer.

Understand Analyze and document validations, Transformations and Mapping tables extractions of the financial General ledger (GL) and Standard Industrial Classification (SIC) reclassification analysis implementation data within the ETL layer BODS for FC replacement and creation of new ETL Datawarehouse build process. Analyze and engage data stewards, business units, and compliance to ensure consistent SIC mapping across systems.

Write Interface and data requirements and baseline with the business and technology users for building the ETL Process for the FC replacement. Analyze, improve and automate current business processes by modelling notation techniques using the Business process Engineering BPMN /DMN.

Work to document design, API and perform system analysis with development team review and baseline for the ETL system build.

Work with multiple upstream and downstream systems defining the mapping requirements for implementation for the STAR reload. Ensure that requirement-related dependencies and constraints are identified & documented by bridging the communication between business and technology stakeholders.

Develop SQL on large datasets (Oracle/Sybase /SQL Server) /Spark SQL/Hive SQL/SAS/SAP Business Objects and use Business Object Oriented Modeling, UML tools and technique. Optimize performance and tune Spark SQL statements. Write Query scripts and Unix shell scripts specifically for SIT/UAT testing draw conclusion, interpret and validating of the data required for calculating exposure numbers. Wrote and executed various NoSQL queries, Spark SQL ON Hadoop big data. Performed data modelling on Cassandra and Elastic search using Python-MySQL connector and MySQL dB package on Unix/Linux environment.

Use Visual Studio for SQL Server (SQL Integration Services) to analyze SSIS packages.

Analyze data lineage processes to identify vulnerable data points, control gaps, data quality issues and overall lack of data governance.

Perform dependency analysis (by identifying any breaks in data lineage), root cause analysis and remediation as part of data lineage effort.

Conduct data profiling, validation and prepare data extraction, cleansing to support reclassification analysis and documentation.

As a part of data governance and control assist with monthly business review process and reporting including customer profitability and pricing processes, as well as any general ad hoc business requests.

Help senior management make risk-based decisions by report creation using data visualization tool Power BI, Tableau along with other tools i.e., Power BI, SSRS, Excel, PowerPoint, Alteryx.

Display Good understanding of the financial products including modelling and RWA for Futures, Options, Swaps, Forwards, ETD, Money Market, FX; TARFs, Asian Barriers, Accumulators, FX Linear, FX Options, Equity futures, Bond futures, CDS-C, DEPO, REPO, Equity OTC options from trade booking of all derivative products and external regulatory reporting

Manulife Global derivative service and solutions (IFR9/IFRS17 Implementation) Jan 2022 to august 2024

Lead Business Systems Analyst / Project Manager

Projects: 1. IFRS Regulation Implementation and Capital Markets Regulations Reporting / 2. LIBOR transition decommissioning and reporting

Perform complex research and analysis of major derivatives and collateral initiatives to identify, document and analyze complex processing, service and/or technical improvement opportunities. Conduct solutions system design and analysis, Business processes, acceptance and user testing, training and product improvement. Business initiatives may also include implementations of new technologies and new product implementations.

Build client-focused solutions that meet business requirements. Prepare and validate solution design documents around areas such as scope clarification, solution requirements, API, Design and quality assurance.

Gather business requirement documents, and track business requirements through the Work Request or project processes adding value, as needed, to the design/analysis and testing phases.

Display In-depth understanding and implementation of Hedge Accounting and IFRS 9/17 accounting standards and FINDUR derivatives and application knowledge. Create fair value hedges and cash flow hedges in FINDUR application. Build hedging relationships and manage collateral workflow processes within COTS Openlink FINDUR derivative application.

Worked on model development including defining/validating/completing model documentation, reconciling and approving OTC trade data sets, reviewing XML codes, and more investment products.

Used Financial products Markup Language FpML for business information exchange standard for electronic trading/dealing and processing of derivatives or structured investment products.

Gain valuable experience supporting a Big-4 client in OTC products and FpML. contributed to impactful financial modeling and validation projects in a collaborative and high-profile setting

Display Good understanding of ISDA CDM (International Swaps and Derivatives Association Common Domain Model) for the financial derivative products including modelling for Futures, Options, Swaps.

Strong Investment business knowledge in the derivatives trading and operations, strong hands-on experience implementing solution in Derivatives/Investment Risk Infrastructure/ IT Project Application Management / Asset Liability Management (ALM)

Write Complex SQL Queries with inner joins and outer joins to retrieve data sets use Group functions in SQL to achieve aggregation (SUM, AVG. etc.) for portfolios and retrieve sets of data rows and prepare and run complex Queries (Advanced SQL) on Oracle/MS SQL Server/Findur database. Create and execute Queries to compare all attributes related to trade transaction booking and holding instruments. Report differences within the comparison runs after executing the OPENLINK FINDUR processes to Amend and validate the derivatives trades for speculation, arbitrage, liquidity or exchange to avoid any breaks in the risk infrastructure, credit, valuations risk factor attribution, Profit and loss (PnL) and accounting reporting.

Write test-related code including SQL(Oracle/SQL ServerSybase) Hive and NOSQL Cassandra and Elasticsearch Queries, Perform Data Modelling using ERWIN, database design and test scripts on Unix/Linux, user acceptance and integration tests, and the management of testing environments. Document requirements using story boarding utilizing tools such as Azure DevOps and Jira

Strong experience in analyzing large amounts of data sets to interpret data and draw conclusions and writing spark SQL and Hive queries to Query using Hadoop Big data. Load and analyze large sets of structured, semi structured and unstructured data using pyspark for large dataset / Big Data analytics Hadoop/Hbase/Spark.

Used Spark-Streaming APIs to perform necessary transformations and actions on the fly for building the common learner data model which gets the data from Kafka in near real time and persists into Cassandra.

Use Visual Studio (SQL Integration Services) to analyze SSIS packages.

Help senior management make risk-based decisions by report creation using data visualization tool Graphs, Designer and Tableau along with other tools i.e., Power BI, SSRS, Excel, PowerPoint, Alteryx.

Display Good understanding of the financial products including modelling for Futures, Options, Swaps, Forwards, ETD, Money Market, FX; TARFs, Asian Barriers, Accumulators, FX Linear, FX Options, Equity futures, Bond futures, CDS-C, DEPO, REPO(Repurchase agreements and security processing borrowing and lending), Equity OTC options from trade booking of all derivative products to back office and hedge accounting and external regulatory reporting. Worked on solutioning and off resolution of issues related to these derivative products within the FINDUR application. Worked on BPL automation features for Equity futures ticker (contract) generation automation.

Create data governance policies, Business glossary, Data dictionary, reference data, Metadata, Data Lineage and data quality rules. Implement metadata, Business Glossary, Data lineage and data quality. Engage with data stewards, business units, and compliance to ensure consistent standard Industry classification (SIC) mapping across systems.

Document data lineage for current-state Risk and Finance data landscape (both, detailed and high-level views), Identify Authoritative Data Sources and document all data quality controls.

Responsible for acquiring and applying expert knowledge of various lines of the business, channels, and their applications and processes to include providing advice on satisfying regulatory requirements related to information data governance and data management.

Leads the assessment and coordination of information data governance training requirements and learning objectives for the enterprise.

Develop, Interpret, document, and execute test strategies, test plans, test cases on large dataset investigation and problem solving to derive expected results in consultation with clients using tools and technologies to prepare summaries and reports, for acceptance, Stress testing, data analytics and user testing, to ensure that initiatives, that are being implemented, meet expected deliverables. Generation and verification of critical external Regulatory reports including intraday reporting for Risk by leg (RBL) and IDDL reports for all derivative financial products.

Use industry experience and contacts to assist Global Derivatives Services in understanding what other similar companies are doing in terms of providing like solutions for initiatives tables (i.e., "best of breed" solutions)

Work with the ALM business users as part of derivative solutions team and be responsible for the banks Regulatory reporting for supporting multiple lines of business. Support the hedge relationship creation and accounting for the Managing Interest Rate risk and FX risk. Work with ALM team on Regulatory and intraday reports generation and support for FRTB/LCR/LTR/LOPR/NCCF regulatory reports.

Ensure that all processes and systems work within the mandated regulatory and compliance requirements for the industry

Ensure stakeholders have a common understanding of project deliverables and parameters (e.g., Time, cost, quality and benefits)

Exercise judgment in identifying issues, modifying plans as business conditions change, assessing courses of action and developing recommendations

Bank of Nova scotia (BCAR REPORTING FOR OSFI/ BASEL 3 – COTS AXIOM IMPLN.) JUNE 2021 TO DEC 2021

Lead Business Analyst / Project Manager

Project: COTS Axiom implementation for BCAR /CCAR(OSFI) Capital Market regulation Reporting

Responsibilities:

Be accountable for project deliverables, including data mappings for ER_MAIN(ON and OFF_BALANCE_SHEET, INEA,OTHER_OFF_BALANCE_SHEET, ER_DERIVATIVES, ER_SECURITIZATION and SFTs(Security processing Borrowing and lending) / REPO flowing from ETL to Axiom staging, product release management and documentations, development and testing of Axiom Controller View workflows for both product release and BCAR/ Pillar III reports, Define business rules and workflows for assigning SIC codes, aligned with industry best practices and per the regulatory standards,Business rules implementation,support user level validation and implementation of Capital market Regulatory reports including OSFI BCAR/CCAR/NCR/Pillar III /LRR/LCR/NCCF/FRTB reports. The Project scope included large projects/programs, multiple stakeholders, vendor management utilizing multiple technologies and/or 3rd parties. Knowledge of Capital Markets regulatory initiatives under Basel 3/4 guidelines provided for reporting.

Work within the ECMS Team and be responsible for the banks BCAR reporting, regulatory capital engine, Credit Modelling and calculations (CECL,PD,LGD), PFE/VAR and reporting. Support the applications that calculate regulatory and economic capital and applications that generates BCAR and intraday reports.

Strong experience in analyzing large amounts of data sets writing spark SQL and Hive queries to Query data on Hadoop database. Load and analyze large sets of structured, semi structured data using pyspark for Big Data analytics Hadoop/HBase/Spark. Optimize performance and tune Spark SQL statements.

Conduct functional business reviews with business and IT stakeholders, document business requirements, analyze issues as an Expert Business Analyst Lead. Present and recommend business solutions that meet sponsor/stakeholder requirements for capital adequacy functional BCAR/CCAR Reporting. Display Significant independent judgment throughout the project with little or no management direction provided. Lead and coach proficient level business analysts in the business team. Good understanding and experience on credit risk management and trade lifecycle for all the financial products including Fixed Income (Bonds), Credit (Derivatives, swaps), Rates (Loans, Interest rate derivatives, swaps), Foreign exchange, Equity,, REPO(Repurchase agreements and security processing lending and borrowing), Security lending (SBL) and Commodity.

Collaborate with Axiom Development and Product teams to create and test functionality and reports from the Axiom rule-based calculation Engine, OSFI Cubes, Bridge BCAR and Summary Schedules across all asset classes, products and other bank assets. Run Axiom workflows with Previous/current quarters’ data and compare these results with the Algo output and session content tables within the SQL Server, populated with required calculated attributes from ALGO

Lead and coach Business Analyst team, change management and stakeholder training related to new SIC classification and display independent judgement, Recommend and present business solutions that meet sponsor requirements for capital adequacy reporting. Provide leadership and guidance to team members participating in the ECMS projects

Document data lineage for current-state Risk and Finance data landscape (both, detailed and high-level views), Identify Authoritative Data Sources and document all data quality controls.

Conduct functional business reviews with business stakeholders to document business requirements and analyze issues. Elicit and document system specifications along with business requirements to implement the additional required data points to the revised Basel III and IV reform requirements with respect to credit risk, market risk and stress testing scenarios. Analyze, recommend and implement the required updates for critical BCAR reporting to the business stakeholders. Analyze and investigate large dataset derive findings and Map data requirements flowing through the ETL logic, to the corresponding files.

Work on creation of data sources and data models within Axiom to stage data to be used for preprocessing layer. Document and create mappings and use SQL to Query data, analyze data and load data from the sources for generation, comparison and validation of reports and schedules for risk weighted assets (RWA) and other counterparty credit risk attributes. Perform and write simple SQL statements, prepare and run detailed unit test cases to test axiom code in controller view, complex Queries (Advanced SQL) on MS SQL Server/ Axiom to create Aggregation and portfolios for reporting generation purposes. Review and enhance PL/SQL code for performance tuning for databases.

Facilitate enterprise data governance priorities and assess internal data management maturity practices.

Support the Data Management team to embed information governance in approaches, tools and offerings.

Document data lineage for current-state Risk and Finance data landscape (both, detailed and high-level views), Identify Authoritative Data Sources and document all data quality controls.

Ensure a holistic approach to Enterprise Data Governance is employed in projects that addresses the people and process components of Data Quality, Data Stewardship, Data Privacy & Protection, Data Policy & Standards, and Metadata Management

Creation of Data Sources, Data Models, Shorthand’s, Portfolios, Aggregations, Free Form and Tabular Report and workflows using AXIOM Controller View tool based on Regulatory Report Requirements in the BAT Environment for users. Migration of Axiom components from Development/QA environment to DEV/IST/BAT environment. Applying data mappings across different environments and versions Create technical specification and design for implementation of functionality.

Make axiom configurations from the created Data source, Data Model, portfolio aggregations. Develop and support readable Axiom code for the performance of credit risk related report generation and business rules functionality.

Creation of new projects and branches for specified testing of regulatory reports by business users and running workflows with specific data ingestion required. Seek input from the business by facilitating sessions. Participate in post implementation review to provide post implementation support and act as the escalation point for any process related issue. Design and develop strategic training plan associated with introduction of new or enhanced business processes.

Benchmark processes and assess the required complement to manage workload. Monitor and resolve emerging issues at the implementation stage of the project. Act as a SME for the IT team during development of system specifications

RBC CORPORATE TREASURY - FOR (bcar Reporting for OSFI/ Basel 3 – COTS Axiom Impln.) May 2019 to JUNE 2021

Lead Business Analyst / Project Manager

Project: Axiom implementation for BCAR /CCAR(OSFI) Reporting

Responsibilities:

Development of the Axiom workflows, risk matrices and Business use cases validation and testing within Axiom of datasources. Creation and validation of data models and comparing the output with the Enterprise warehouse within axiom project and branches involve business integration testing of business rules build within axiom controller view. The onboarded new product was tested for credit risk Modelling infrastructure and calculations (CECL/PD/LGD/PFE/VAR) and monitor the impact for the Market risk and stress testing scenarios.

Provide leadership and guidance to team members participating in the AXIOM-FRO projects. Manage and produce project documentation (implementation plan, issues log, process aps, reports, FTE analysis, etc.) and monitor results of process design deliverables and project completion

Benchmark processes and assess the required complement to handle / manage workload. Monitor and resolve emerging issues at the implementation stage of the project. Act as a SME for the IT team during development of system specifications

Strong understanding of packaged trades vs. vanilla options and the affirmation/confirmation/settlement lifecycle.

Document data lineage for current-state Risk and Finance data landscape (both, detailed and high-level views), Identify Authoritative Data Sources and document all data quality controls.

Creation of Data Sources, Data Models, Shorthand’s, Portfolios, Aggregations, Free Form and Tabular Report and workflows using AXIOM Controller View tool based on Regulatory Report Requirements in the BAT Environment for users. Migration of Axiom components from Development/QA environment to BAT environment. Applying data mappings across different environments

Contact this candidate