Vikas Gangrade

Business and Technology professional with 17+ years of experience leading strategic transformation initiatives across data, analytics, and enterprise platforms. Proven expertise delivering Finance Data Lake, Data Warehouse, and Trade/AML reporting solutions, covering ETL, data governance, trade lifecycle (Orders, Executions, Allocations), middle-office processing, financial products (Equities, Listed Derivatives, Fixed Income, OTC Derivatives), data modeling, data mapping, and data quality. Strong background in data strategy, business requirements, process design, and gap analysis, with hands-on delivery using Agile, Scrum, and Waterfall methodologies. Highly proficient in SQL, Python, Snowflake, Azure Databricks, Alteryx, Tableau, and Power BI for analytics, reporting, and automation. Certified Lean Six Sigma Green Belt and Black Belt, with a focus on process simplification, scalability, operational excellence, and regulatory compliance. 

Work History

TD Canada – Senior Business & Data Analyst
Jul 2023 – Present

• Acted as a Senior Business/Data Analyst within Financial Services, partnering with business stakeholders and domain pillars to gather, document, and validate requirements for data warehousing, data lake, governance, and regulatory reporting initiatives.
• Led end-to-end data curation and metadata management across Data Catalogs, Business Glossaries, Data Dictionaries, and Data Lineage, enabling standardized and governed datasets within enterprise Data Lake and Data Warehouse environments.
• Performed data profiling, quality validation, reconciliation, and standardization using SQL, PL/SQL, and Python across Databricks and enterprise data platforms, ensuring data accuracy, completeness, and readiness for downstream analytics and reporting.
• Onboarded and integrated multiple source systems into centralized data platforms, documenting source-to-target mappings, transformation rules, and data curation logic to support scalable data pipelines.
• Developed complex PL/SQL procedures, functions, and queries for data extraction, transformation, reconciliation, and performance optimization across large financial datasets.
• Built interactive dashboards and governance reporting solutions using Tableau to visualize data quality metrics, metadata coverage, lineage tracking, and regulatory KPIs for business and compliance stakeholders.
• Collaborated with engineering and data platform teams to design, test, and deploy enhancements to metadata tools and data pipelines within Data Lake/Data Warehouse ecosystems.
• Managed enhancement requests, defects, and production incidents using JIRA within Agile delivery cycles, prioritizing data issues and coordinating releases with cross-functional teams.
• Translated complex technical metadata, data lineage, and transformation logic into business-friendly documentation, supporting audits, governance frameworks, and regulatory reporting requirements across banking and capital markets domains.

RBC, SENIOR BUSINESS & DATA ANALYST

Apr 2023- Jun 2023  

• Delivered data-driven solutions to streamline discrepancy tracking and operational reporting for RBC employees.
• Translated complex business processes into actionable insights through logic-based field analysis and data mapping.
• Built and optimized data pipelines using Python (Pandas, NumPy), improving data accuracy and consistency by ~30%.
• Authored user stories and technical documentation in Jira and Confluence, bridging business and engineering teams.
• Automated data consolidation, archival, and validation using Python to support scalable data operations.

Developed testing plans, validation rules, and SOPs to ensure audit readiness and regulatory compliance.

• Managed project milestones, success metrics, and resource planning, ensuring timely and high-quality delivery.

CIBC, DATA SOLUTION EXPERT - SENIOR BUSINESS SYSTEM ANALYST  

09/2021 – Mar 2023   - TMSA Implementation

• Led delivery of an AML investigation, trade surveillance, and regulatory reporting platform supporting Finance, Compliance, and Middle-Office users across multiple Capital Markets products, enabling governed data access, investigation workflows, and regulatory oversight.
• Mapped, modeled, and curated metadata across 35+ source systems including trading platforms, risk systems, and Salesforce CRM datasets, producing source-to-target mappings, business glossaries, data lineage, and data catalog documentation for trade, client, and regulatory reporting domains.
• Designed and maintained reporting across the Trade Lifecycle (Orders, Executions, Allocations, Settlements) and Middle Office trade processing, covering financial instruments including Equities, Listed Derivatives, Fixed Income, FX, and OTC Derivatives.
• Integrated Salesforce client and relationship management data with Capital Markets trading and compliance datasets to improve client transparency, trade monitoring, and regulatory reporting alignment.
• Enabled accurate and auditable regulatory and suspicious transaction reporting by establishing traceable data lineage, standardized definitions, governed datasets, and reconciliation controls across trade, client, and operational data.
• Partnered with Risk, Compliance, Capital Markets trading desks, and CRM teams to translate regulatory, governance, and Salesforce-driven client lifecycle requirements into functional specifications, data models, and controlled workflows.
• Developed advanced SQL and Python validation frameworks for data profiling, reconciliation, metadata quality checks, and transformation verification across trade, AML, Salesforce, and operational datasets.
• Executed SIT/UAT testing cycles, coordinated stakeholder sign-offs across trading, compliance, and CRM teams, supported audit and regulatory readiness, and collaborated with technology teams to implement governance controls and remediate production data issues.

GE CANADA, GENPACT CANADA - SENIOR BUSINESS SYSTEM ANALYST AND DATA ANALYST

10/2018 - 08/2021

• Defined and executed a strategic enterprise data architecture roadmap aligned with business and regulatory goals across 7 GE business units, establishing scalable, governed reporting frameworks and standardized data models.
• Led a global cross-functional team of 15+ members across India, Canada, UK, and Budapest to deliver enterprise data integration and reporting solutions across multiple ERP platforms (Oracle, SAP, PeopleSoft) and CRM systems including Salesforce.
• Designed and supported reporting across Trade Lifecycle processes (Orders, Executions, Allocations, Settlements) and Middle Office trade processing workflows, ensuring accurate capture, enrichment, and reconciliation of trading activities.
• Worked with Capital Markets financial product data including Equities, Listed Derivatives, Fixed Income, FX, and OTC Derivatives, supporting trade validation, reconciliation, and regulatory reporting readiness.
• Built executive KPI dashboards and operational analytics using Power BI (DAX, SQL) to monitor Cash & Collections, operational performance, client activity, and trade metrics, enabling data-driven decision making.
• Developed a centralized enterprise data backbone using Talend ETL, integrating data from ERP systems, Salesforce CRM, and trading platforms, enabling unified reporting and analytics through Power BI and Amazon QuickSight.
• Partnered with Product Owners, Capital Markets stakeholders, and CRM teams to define user stories, execute SIT/UAT testing cycles, and optimize operational processes using data analytics models, governance frameworks, and Six Sigma methodologies.

BNY Mellon India, Investment Bank - IT Manager & business system analyst

05/2017 - 09/2018

• Led development of data platform using Python (Django), JavaScript, and SQL Server for reporting and analytics.
• Architected and optimized Finance Data Lake and Data Warehouse to support operational and client reporting.
• Built Power BI dashboards, ETL pipelines (Talend), and automated reporting solutions.
• Delivered custody and asset valuation data solutions for BNY clients.
• Managed project scope, budget, milestones, and created audit-ready BRD/FRD documentation.
• Mentored cross-functional teams, aligning with analytics platform goals and performance objectives.

TATA CONSULTANCY SERVICES, IT Consulting Firm - Senior Manager and Data

10/2006 - 05/2017

• Led end-to-end development of AML platforms and enterprise data architecture, managing data mapping, modeling from 35+ sources, and driving compliance and remediation activities across finance and audit teams.
• Designed and implemented complex SQL queries, dashboards, and Excel-based reports to validate data integrity, monitor controls, and support internal/external audit readiness.
• Collaborated with product owners and cross-functional teams using Agile methodologies to gather requirements, create user stories, and deliver scalable technical solutions aligned with business goals.
• Managed large-scale integration projects including data governance, transformation, and master data management, coordinating with ETL, BI, DBA, and production support teams to ensure seamless data operations.
• Spearheaded process improvements, normalization/de-normalization, and system simplification initiatives, achieving significant operational efficiencies and cost savings through strategic data analysis and stakeholder engagement.

Accomplishments

• Designed data warehouses and finance data lakes with ERP integration and reporting models.
• Built ETL pipelines using Talend/Informatica; developed dashboards with Power BI, Quick Sight, and OBIEE.
• Experienced in banking, finance, order and cash management, and stock/commodity markets.
• Managed data governance, security, and compliance with business process analysis and reporting solutions.
• 15+ years in data modeling, process improvement, and Lean Six Sigma methodologies for quality and cost optimization.

Additional Information

•  Professional Recognitions: Consistently appraised in Top 5%; Account Pride; Idolator of the Month, BNY Ovation Award for delivering audit Control mechanism Learning: Six Sigma Green Belt (TCS-GE), Digital Transformation, Machine Learning, AZURE Fundamental, Design Thinking, 

Holding Canada Permanent Residency, Indian citizenship, and US business Visa.

Domain: NCFM beginner level, Customized Programs on credit reporting - Six Sigma certified: Green Belt certificates, Working on Black Belt Project Language – English and Hindi

2006 

Bachelor of Engineering : electronics and communication

GPA: 76.33