ANKUR MAHAJAN, PMP®, SaFE Agilist®, CSM®, PSM-*®, ITIL®

ad1le1@r.postjobfree.com 647-***-**** Toronto, ON linkedin.com/in/ankurmahajan99/

EXECUTIVE SUMMARY

An accomplished and value-focused PMP and Agile Practitioner (10+ years) with progressive experience in Banking & Insurance industry, committed to delivering medium to large scale initiatives by partnering with clients across the globe. Areas of specialization include Digital Technology (Bigdata / Hadoop / ETL), Regulatory (IFRS17, IFRS9, FATCA, AML, CRS, CCA), Data Analytics, Data Transformation / ETL, Data Governance, Merger & Acquisition based initiatives.

Self-starter with consistent and demonstrated track record of delivering end-to-end project lifecycle within Agile & Traditional initiatives with clear and defined outcomes.

Scrum Master and Agile experience in organizing and guiding multiple teams on how to use Agile and Scrum best practices to consistently deliver on product deliverables adhering to best practices on how to self-organize.

Cross-Functional collaboration with members across disciplines including Product Management, Technology & Business to align and clarify open asks on behalf of the team.

Guiding and Coaching the Scrum team and organizing the use of Agile / Scrum practices and values, acting as servant leader and supporting / educating the Development Team & Product Owner with backlog refinement.

Adept in facilitating the Scrum ceremonies, including daily scrum, sprint planning, sprint review & sprint retrospective and regular snapshots of burndown and project velocity.

Facilitated and participated in the Sprint Demo, along-with Product Owner and Stakeholders, fostering transparency and building trust.

Lead and facilitate regular Release Plan along-with Product Owner to align on milestones prioritized as per Product Roadmaps.

Excellent communication techniques (verbal & written) while keeping stakeholders informed on the progress by sharing Scrum notes, Sprint review reports, Project retrospectives and regular snapshots of burndown and project velocity.

Enriched experience of leading & executing multiple mid to large-scale initiatives, with experience on Change Management and all aspects of software project lifecycle (SDLC / PMLC) with different methodologies like iterative-Waterfall & Scrum.

Active participation and status review with OPCO / Steer Co and presenting dashboard on Schedule & Cost (actuals, forecast & variance) to senior leadership and business sponsors, a genuine team player committed to delivering projects with emphasis on building strong and high performing team.

Encourage the team to foster collaboration among cross-functional and virtual teams, so that the team feels motivated and achieves their objectives with enthusiasm, coaching on how to work through ambiguity and derive working assumptions.

Enriched expertise with all PM / Agile-specific methodologies and frameworks (SDLC, PMLC, Waterfall, iterative-Waterfall, Agile Management Framework / Kanban) and applying Best Practices towards the project success.

Extensive hands-on with tools like Jira, Confluence, Wrike, Clarity, MS Project, Primavera, Planview.

Technology stacks delivered – Big Data (Hive, HDFS, Spark, Podium, Syncsort), ETL (SAS DI, Informatica, DataStage), Oracle Fusion.

Executed small to large-scale budget ($1-6mn) with varied complexity and risk, while effectively managing PM triple constraints in a matrix environment and virtual teams. Solid experience with Global Top Banks – RBC, Scotiabank, CIBC, Intact Insurance, Nationwide and highly adaptable to changing priorities and to the organization culture.

TECHNICAL SKILLS & COMPETENCIES

Regulatory (IFRS17, IFRS9, FATCA, AML, CRS, CCA)

Bigdata, Hadoop, Datalake, ETL Implementation

Data Governance / Data Transformation

Stakeholder / Vendor Management

Agile-based Initiatives

PROFESSIONAL SKILLS

Customer Centric

Problem Solver

Team Player

Innovation Management

Excellent Communicator

Conflict Management & Resolution

Servant Leader

Dealing with Ambiguity

Coaching & Motivation

PROFESSIONAL EXPERIENCE:

Royal Bank of Canada

Sr. Agile Project Manager for Regulatory & Compliance Dec, 2021 to Present

Leading Agile transformation initiatives (Scrum ceremonies, PI Planning, Backlog grooming, Release Planning, Demo, etc) for IFRS17 Implementation and Bigdata Ingestion from source systems like Policy Admin Systems, Claims Admin, Compensation and Reinsurance to convert their native dataset from EBCDIC / XML data to ASCII for the Hadoop ingestion.

Developed project plans including scope, timeline, resource plans for the IFRS17 initiative in Sprints to manage projects in an iterative and incremental way.

Facilitated communication between various stakeholders, including external vendors, Scrum teams, Business teams, legal and DNA (Data & Analytics team). Ensured that all parties are informed about the project's progress status in a heatmap / dashboard

Lead cross-functional teams consisting of developers, business analysts, testers, and Data Governance teams. Ensured that the team follows Agile practices and principles, such as daily stand-up meetings and sprint planning

Handling CR’s / PCR’s, undergoing thorough impact & risk assessment and taking further to the leadership for necessary approvals, eventually adding into future Sprints. Ensured that changes are properly assessed and integrated into the project plan. Performing Inspect & Adapt methods for the evolving regulatory requirements.

Fostering collaboration between Hadoop Engineering Teams / DNA and Scrum teams, toward maintaining Product Backlogs & helping them understand each other's needs and constraints to find optimal solutions that are both compliant and efficient.

Defect Management and Logging, identifying Defect variances, defect aging and resolving the defects during the Sprint cycles and fixes directly at the source of data origination.

Establishing & following best practices as per AMF (Agile Management Framework)

Intact Insurance

Agile Product Manager for IFRS17 Implementation Aug, 2020 to Sep, 2021

Orchestrated the Release Train for multiple Sprints / PI’s (Program Increment) towards building SAS capability within the IFRS 17 calculations, including PI Planning and delivery for SAS workstream along-with business to understand requirements and with the solution and data architecture team, managing triple constraints (budget, schedule and scope). Functional changes in the IFRS-17 impacts the include Contractual Service Margin, Best Estimate Cashflows, Risk Adjustments, Capital Management, Performance Metrics, Presentation and Disclosures and ensuring the SOX/52-109 compliance / IT controls. Led the entire workstream in-line with IFRS-17 program milestones.

Worked closely with the FinSys team, 52-109, PMO team to manage expectations, and dependencies on data delivery. Executed within the 8-weeks Sprint from scoping of Sprint, refining backlogs and delivering to the Business expectations.

Accountable for data quality of SAS code during the Integration Test & UAT/BAT phases, resolving the Sev1/2 defects in a timely manner and adjusting the code/configuration towards successful future Sprints.

Led the Valuation model development workstream as part of Iteration1, where in the data will feed from the Data Foundation for all the feeds going to GGY, while the Finance data will feed directly to the SAS IRM (CSM tool) and eventually to Oracle Fusion, which was the vendor selected for subledger calculations.

Presented weekly status report on milestone dashboard to the Project Governance / VP team, actively engaged in Steering Committee meetings, and obtained key decisions in a timely manner.

The Cooperators

Scrum Master / Agile Project Manager for ETL Implementation Nov, 2019 to May, 2020

Spearheaded the Agile initiative towards Implementing the ETL features and functions for Data Readiness originating from Policy Admin Systems (Ingenium, Edge, TAI), AXIS Models and Finance GL posting. These new features were required for calculation of the IFRS17 results along-with a cross-functional team.

Led ETL development framework for Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and Oracle tables to the target Life & Creditor Datawarehouse.

Conducted Daily Scrums, worked with product owner to groom the backlog and plan sprints. Continuously tracked, obtained decisions and removed impediments.

Coached team members on Agile processes and facilitated planning meetings and retrospectives. Maintained JIRA task board and produced daily burndown charts.

Defect Management using JIRA on the defects identified during the Sprints, resolving issues with inputs from the Development or the Business Team / Product Owner.

Worked in collaboration with Product Owner towards backlog refinement and estimation of story points along-with key team members from development team, fostering transparency and trust.

Facilitated and participated in Scrum Ceremonies like Sprint planning, Sprint review and Sprint retrospective meetings.

Communicated the progress to senior management thru 'Burndown Charts'. Monitored the Quality thru metrics and mentored team thru the project management processes.

Scotiabank

Scrum Master / Agile Project Manager for IFRS9 ETL Implementation Jun, 2019 to Nov, 2019

Delivered IFRS9 ETL Design & Development initiative using tools like SAS DI, Datastage, identifying high value product deliverables to deliver for the BCAR and ALGO Development along-with backlog refinement in collaboration with Product Owner.

Measured Agile KPI metrics – Velocity, Burndown Charts, Burnup charts, Cycle time, Lead time, Sprint Closure Report, and Business Value Delivered & Defect Resolution Time

Identified and eliminated impediments, facilitated conflict resolution and continuous improvement, delivery forecast. Coached teams to get action plan aligned to Backlog Refinement, Sprint Techniques & Retrospective.

Continuously evolving & improving the product with sprints and thereby improving team’s velocity.

Assisted product owner in backlog grooming (prioritization, estimation), establishing acceptance Criteria

Status and Schedule Monitoring against Product roadmap / milestones & Reporting to VP / OPCO, discussing resolutions and corrective actions for the blockers & obtaining key decisions and direction.

Royal Bank of Canada

Scrum Master / Agile Project Manager for Hadoop Datalake Implementation Dec, 2017 to Jun, 2019

Lead Finance GL / ERP Setup including building (Primary Ledger, Legal Entity & Business Unit) for IFRS4 and IFRS17, and the Aptitude (sub-ledger) output configuration to GL, working through challenge of going from 15 segments to 18 with 3 new segments required for IFRS17.

Orchestrated build, test and delivery of EODC feeds (aligned with the sub-ledger Aptitude data model) for all source systems, manual feeds in alignment with the Finance Technology, who finally sends processed data to EGL

Meticulous involvement with Requirements workshops, Architecture blueprints (including Solution Architecture, Data Privacy, Data Classification, Data Architecture and Enterprise Architecture).

Engaged with Vendor Management & Proof of Concept for the selected products and monitored / tracked to completion along-with Accounting & Actuarial validation results with their SMEs for the high value products using GMM model.

Proactively escalation of project issues and risks that require Sponsor, Program Management or executive attention. Effectively and consistently managed project status reporting updates on project accomplishments against milestones

Managed the Data Governance workstream to decompose using data lineage for CDE (critical data elements), technical metadata, business metadata and operational metadata using Collibra tool for all data elements end to end until the feeds go to Valuation models, identification of all the EUCs and Data Quality to be remediated for the project. This involved coordination with CDO/IDO team in terms of Data Governance, Data Quality, and Data Retention Standards.

CIBC

Scrum Master / Agile Project Manager for Hadoop Datalake Transformation Sep, 2016 to Oct, 2017

Implemented the Consumer Analytics zone over 4 Sprints for business and working with Product Owner towards identifying the Release Cycles and deployment, technologies used – SAS & Tableau.

Successfully Delivered the Cloudera Hadoop Datalake ingestion project using a hybrid model of Agile and Traditional model and ensured the Ingestion framework is built for ingestion and acquisition from all external data source (structured, semi-structured XML, Mainframe, DBMS) into Hive tables using Podium, Scoop & Syncsort, followed by Operations handover.

Delivered ETL (Extract/Transform/Load) and Dimensional Models using Star schema and Snowflake schema techniques in relational, dimensional and multidimensional modeling for the source feeds from Cards & Mortgages line of business.

Led the optimization of the mappings by creating re-usable transformations and Mapplets with Development team, including performance tuning of sources, targets, mappings, transformations and sessions.

Nationwide

Technical Lead Sep, 2013 to Aug, 2016

Successfully delivered the Consumer Analytics zone to serve as SaaS model for the business units (AML, HR Management and External Reporting / HMRC) using the tools – Tableau, Power BI.

Lead the Design & Development for the FATCA implementation project. Leveraged existing systems (legacy Mainframe, AS400), customer data (MDM) for developing FATCA release implementation road map. Headed FATCA regulatory reporting, based on workflows for aggregation of account balances, scanning for US Indicia and internal reporting requirements.

Mobilized third party tool (AXIOM / HYPERION) to generate reports to the Regulator in a compliant format and delivery as part of CRS standards, facilitating the end-to-end development and testing (QA, UAT, BAT) activities and sign-off.

EDUCATION

Bachelor of Engineering (Electronics)

Contact this candidate