Harshdeep Banwait

**Project: T+1 Initiative - Securities Settlement Cycle Optimization**

• Led the T+1 Initiative in the Capital Market to comply with SEC-mandated amendments, shortening the securities settlement cycle from T+2 to T+1 for broker-dealer transactions.
• Utilized essential software tools like MPower, Broadridge ADP, and Excel for seamless System Changes.
• Implemented robust UAT testing strategies (UAT, regression, smoke testing) to ensure system functionality.
• Created securities (bonds, equities, options) emphasizing compliance and operational efficiency in alignment with Regulatory requirements.
• Identified gaps between new business requirements and existing capabilities in Capital Market systems like MPower, Broadridge, and Charles River.
• Collaborated with development and portfolio teams to integrate new Regulatory requirements into the steady state platform.
• Facilitated data mapping and cleaning sessions to ensure data accuracy and completeness.
• Produced documentation (Field Mapping Templates, High-level Requirements files) to support project goals and Regulatory compliance.
• Developed use cases and user stories to communicate requirements effectively.
• Updated branding requirements on client-facing materials with vendors like CGI.
• Designed and executed test scenarios to meet new business requirements using JIRA and Confluence.
• Conducted user regression testing to preserve existing functionality.
• Provided regular status updates to project leads, management, and stakeholders.
• Utilized analytical skills for data analysis and problem-solving, proficient in Excel, SQL, and data analysis techniques.
• Engaged stakeholders for effective implementation of same-day allocation policies, promoting transparent recordkeeping.

**Project: Data-Warehousing Enhancement for Wealth Management - Capital Market**

*Project Summary:* Enhanced data warehousing capabilities in Capital Markets for Wealth Management to expedite report generation. Replaced legacy systems with a new data warehouse for faster processing. Migrated unstructured data from external vendors such as Bloomberg and Broadridge to support quicker report generation in Tableau.

*Responsibilities:*
•Collaborated with external vendors (Bloomberg, Broadridge) to obtain unstructured data.
•Coordinated with the data team to structure and migrate diverse data types, including equities, derivatives, options, and bonds.
•Facilitated the integration of structured data into the new data warehouse.
•Documented requirements & integration process models for data migration.
•Prepared user guides and training materials for stakeholders on new data sources and reporting capabilities.
•Ensured effective stakeholder and client communication throughout the data migration process.
•Provided support to the data team in structuring and cleansing the data for accurate reporting.
•Tools such as Talend and Apache Kafka, utilized by the data team, for data transformation and real-time data streaming.
•Conducted analysis to identify and address data quality issues during migration.
•Collaborated with Data Scientist team for ETL process creation and optimization using Python and Apache Spark.
•Utilized JIRA and Confluence for project management and documentation.
•Conducted JAD sessions for requirement and risk analysis.
•Worked closely with Legal and compliance teams for regulatory reports.
•Finalized Test Plan, Test Cases, and Test Specification Document.
•Provided QA expertise & supported Development & Testing phases.
•Utilized SQL for data querying and manipulation in database operations.

**Project 2: ServiceNow Incident Response and Resolution**

*Project Summary:* Implemented ServiceNow for incident response and resolution in the Capital Market domain. Defined processes, configured automation, and conducted training sessions for effective platform utilization.

*Responsibilities:*
•Defined incident management processes and SLAs.
•Configured ServiceNow for automation for internal software.
•Conducted training sessions for IT teams and end-users.
•Implemented incident triage and assignment.
•Conducted regular process reviews for optimization.
•Collaborated with stakeholders for issue resolution.
•Provided ongoing support and maintenance.
•Analyzed incident trends for improvement.
•Facilitated UAT, created & executed test cases.
•Collaborated with service now vendors for UAT execution.
•Provided support during UAT phase.

**Data Migration Project - Capital Market**

*Project Summary:* Oversaw the migration of legacy servers to AWS Cloud, optimizing cost-efficiency and enhancing data management. Facilitated seamless coordination between data transfer teams and stakeholders, ensuring the generation of Tableau reports connected to IBM Cloud for testing and compliance documentation.

*Responsibilities:*
•Led capital market data migration initiatives, ensuring smooth transfer of critical financial data.
•Utilized SQL queries extensively for data analysis and mining.
•Implemented comprehensive testing techniques in UAT, Regression Testing, and SIT.
•Developed understanding of business-technology alignment.
•Managed risks and dependencies related to requirements.
•Handled and analyzed large datasets for data-informed decision-making.
•Oversaw Data Mapping, Integration, Consolidation, and Manipulation processes.
•Finalized Test Plans and Cases for meticulous application testing.
•Gathered and refined business requirements for accurate Tableau reports.
-•Conducted Gap analysis of business processes & data •Ensured stakeholder and client needs were addressed.
•Supported communication and change management activities.
•Leveraged relationships and networks for project success.
•Translated user needs into effective technological solutions.
•Acted as interface between management, stakeholders, and execution team.
•Practiced Agile methodology, facilitating daily scrum meetings.
•Proactively identified and resolved project challenges.

**Salesforce Implementation - Credit Card Call Center**

*Project Summary:* Implemented Salesforce for Motus Bank's credit card call center, automating processes and standardizing workflows. Transitioned from manual tracking to a streamlined system for account status monitoring.

*Responsibilities:*
•Gathered requirements from stakeholders using prototyping, JAD sessions, and interviews.
•Assisted in creating project artifacts such as BRD and FRD documents.
•Analyzed user requirements and delivered functional requirements, test plans, and test cases.
•Identified and provided solutions for underlying problems and system resolutions.
•Participated in UAT, Regression Testing, and SIT.
•Reviewed and ensured alignment of test cases with business processes.
•Developed simple queries using SQL for data analysis.
•Prepared end-user documentation and training materials.
•Facilitated the project, assisting in various tasks and using JIRA and Confluence.
•Engaged with SMEs to understand current processes and gather Salesforce requirements.
•Documented requirements in BRD to make Salesforce the primary software for the department.
•Contributed to developing data models to support Salesforce standardization.