Divi Srivastava

• Data consolidation initiative to centralize data across business units into the Data Lake (EDL 2.0), creating a reusable data model to enable business partners to streamline processes digitalise and deliver value
• The current line of business involved US Retirement, to ingest new data source for Employer and Participant investment and Contribution.
• Streamlined data processing for faster results by implementing advanced analytics tools.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Enabled accurate trend analysis through meticulous data cleansing and standardization procedures.
• Spearheaded the implementation of dashboard visualization tools, providing actionable insights for stakeholders and decisionmakers.
• Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
• Established robust security protocols to protect sensitive company information from unauthorized access or potential breaches.
• Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.

• One Source Transformation Project is aimed at eliminating the manual files and moving all LOBs to Snowflake
• The transformation process includes steps of eliminations, Cutover and Code Changes (Logic Changes, Names Changes, Rounding Differences) implemented in the Model Point Files.
• Enhanced business efficiency by identifying trends and patterns in complex datasets.
• Streamlined data processing for faster results by implementing advanced analytics tools.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.

• Working on data migration to Snowflake with backend as Azure
• Working with Data Modelers with regards to new Data Elements Analysis and Validations of different models
• Also, on the Valuation Reporting tables and reports creations
• Data Mapping and Lineage on Collibra along with Documentations.
• Streamlined data analysis workflows for increased efficiency and faster decision-making processes.
• Improved data accuracy by implementing stringent data validation processes and quality control measures.
• Enhanced business intelligence capabilities with the development of advanced analytical models and forecasting tools.
• Optimized database performance, implementing indexing strategies and partitioning techniques to reduce query times.
• Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
• Enabled accurate trend analysis through meticulous data cleansing and standardization procedures.

• Worked within the D&A IBNR team in capacity if an IT product owner/Business Analyst/Project Manager
• Looking at the various Change Requests for the IFRS 4 reporting and enhancements needed for the IFRS 17 implementation at the IBNR’s end.
• Streamlined business processes by analyzing system requirements and implementing improvements.
• Collaborated with stakeholders to define project scope, objectives, and deliverables for successful implementation.
• Optimized operations for increased efficiency, utilizing comprehensive data analysis techniques.
• Conducted thorough risk assessments, mitigating potential issues through strategic planning and problem-solving skills.
• Managed cross-functional teams, fostering strong working relationships and open communication channels among team members.

Project 1: CIBC – Regulatory projects including MIFID

CIBC Internal investment applications were to be reviewed for the various regulatory assessments. As a part of these projects, internal applications were studied. Also, the interaction of the application with different applications and external software was documented.

Project 2: CIBC – Create feed from IPREO to SALESFORCE

Design a live feed to update CIBC events data from legacy system IPREO to the new migrating application SALESFOCE. The CIBC team was forgoing the legacy system and integration with data migration was a major ask for this project. Determination of ‘Data elements’, shells and triggers, creation a real time feed design for populating SALEFORCE application.

• Improved project efficiency by analyzing business processes and identifying areas for improvement.
• Streamlined workflow for better productivity with the implementation of new software solutions.
• Developed comprehensive data models to guide decision-making, resulting in more informed strategies.
• Collaborated with cross-functional teams, ensuring a cohesive approach to business analysis.
• Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
• Facilitated requirement gathering workshops, resulting in clear project objectives and deliverables.
• Implemented Agile methodologies within project teams, increasing overall adaptability and responsiveness.
• Created detailed user stories for system enhancements, leading to improved functionality and user satisfaction.
• Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
• Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
• Worked with team leads and managing leadership, establishing robust talent pool with focus on people and continuous improvement.

Project 1: RBC Enterprise Risk IT – IFRS 9 Implementation

Implementation of IFRS 9 regulatory changes within Enterprise Risk Domain.

Project 2: RBC Enterprise Risk IT – EBR Domain

The project required integration at an application and data level. SQL was key in data mining and data transformation. SOA was followed at the reporting end of the platform. Adherence to Agile methodology

Project 3: RBC Enterprise Derivative Reporting (eDR)

Analysis, integration, requirements gathering, SOA, QA implementation of key enhancements to Enterprise Derivatives Reporting (eDR) system.

Project 4: RBC Hedge Accounting (HAMRS)

Documented and reverse engineered and integration of existing systems in liaison with technical team, developed specifications to retrofit new data feeds with existing applications.

• Improved business processes by analyzing system requirements and implementing effective solutions.
• Streamlined data management for increased efficiency by designing and implementing new database systems.
• Enhanced user experience with thorough testing and troubleshooting of software applications.
• Collaborated with stakeholders to gather essential requirements, ensuring successful project outcomes.
• Increased system reliability, optimizing performance through regular maintenance and updates.
• Reduced project completion times by effectively managing cross-functional teams in agile environments.
• Developed comprehensive documentation to support end-users and facilitate future enhancements.
• Conducted training sessions to empower users with the knowledge necessary to utilize systems effectively.
• Facilitated communication between technical and non-technical team members, ensuring project alignment across all parties involved.
• Managed multiple projects simultaneously, consistently meeting deadlines while maintaining a high standard of quality workmanship.
• Integrated disparate systems through API development and implementation for seamless data exchange between platforms.
• Analyzed user feedback to identify areas requiring improvement, prioritizing enhancements based on impact potential.
• Collected, defined and analyzed business requirements.
• Consolidated business rules for system enhancements.
• Collaborated with upper management to drive strategy and implement new processes.
• Communicated and explained business requirements to team members to understand and implement functional demands.

• Improved business processes by analyzing current practices and recommending optimization strategies.
• Reduced operational costs through thorough data analysis and implementing cost-effective solutions.
• Enhanced company-wide decision-making by developing comprehensive reports on key performance indicators.
• Streamlined project management with effective communication and collaboration across cross-functional teams.
• Supported software development projects by defining clear requirements and effectively communicating them to technical teams.
• Collaborated closely with stakeholders to identify opportunities for process improvements and drive continuous innovation in the organization.
• Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
• Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
• Interacted with internal customers to understand business needs and translate into requirements and project scope.