Rattandeep Singh

An Agile based project for Capital Markets database management and transition. The work involved development of a Central Data Systems, data migration and integration layer setup. The input of the data is from Broadridge and Bloomberg under Capital Markets including equities, stocks, derivatives, options, swaps, and foreign exchange to the latest Data Lake environment developed on the Cloud (Azure). Java on Oracle, Big Data / Hadoop, and Artificial Intelligence (AI). The near live data mining, analysis, enrichment, and transfer is done using Kafka and Talend, log monitoring using Splunk and reported using Tableau.

Responsibilities:

• Gather requirements from business regarding near live data inputs and Business Intelligence report development for Valuations, Calculation of Risk, Credit Valuation Adjustment (CVA), Funding Valuation Adjustment and Profit and Loss Attribution for trading using automation through Kafka connectors and Swift Messaging.
• Employed Agile methodology namely Scrum and SAFe and coordinating daily scrum, sprint planning and iteration reviews.
• Worked as a SME to clarify complex terminologies to technical teams regarding Equities, Derivatives, Repo, Options, Mutual Funds, Fixed Income Investments, Foreign Exchange (FX) and Fund Wrap Systems.
• Organize for consistent data streaming, storage, processing and publish using Kafka APIs.
• Presented the business case for cloud computing covering the project financials, budget, value additions and other aspects.
• AS-IS and TO-BE process analysis to estimate the existing GAP analysis in process flows and requirements.
• Represent the clients, created, and elaborated on User Stories and confirmed all requirements are covered.
• Utilized Kafka APIs for streaming, subscribing, swift messaging and publishing in real time from multiple micro sites and legacy systems.
• Produced multiple near live business intelligence reports using Kafka.
• Utilized System Monitoring Tools to identify bugs and defects and take corrective action.
• Build data systems and integrations layers to support various Electronic Data Interchange (EDI) Systems, ERP systems, Digital Products and Applications using Rest APIs and SOA (Service Oriented Architecture).
• Provided data inputs for Precise adjustment of Valuations of Equities and Derivatives as per current market movement.
• Designed and created Source to Target mapping documents and Interface Agreement documents.
• Conducted Walk-through sessions with stakeholders to explain reports.
• Supported front to back Extract, Transfer and Load (ETL), Electronic Data Interchange (EDI), Digital Products and Applications using SOA (Service Oriented Architecture) and RESTAPI.
• Used Elastic Search for search words optimization requirements.
• Created data mapping dictionary and transmission channels to transition and support Electronic Data Interchange (EDI), Digital Products, ERP systems and Applications.
• Conducted JAD and workshops for requirement and risk analysis with various stakeholders.
• Prepared the SRS Document using Use Case diagrams and Activity Diagrams to depict system functionality and user interaction.
• Prepared the business testing strategy and successfully performed the User Accept Testing, (UAT).
• Extensively utilized SQL queries for data analysis and data mining to verify data quality.

Bigdata systems development and data migration project for integration of data from different legacy systems (Windows) to the latest Data Lake environment developed on the Cloud using Big Data / Hadoop. Live and interactive reports were developed using Artificial Intelligence (AI) are presented on Tableau Application utilizing Kafka streams from Instance for streaming data. Development of complex reports from the new systems was a critical part of the project.

Responsibilities

• Gather and finalize business requirements to deliver accurate, live and interactive reports using Tableau Application from Data Lake environment created on Big Data / Hadoop and transmitted using Kafka API streams from AWS Cloud.
• Conducting analysis of the business processes, data models, schema, meta data and finalizing project scope.
• AS-IS and TO-BE process analysis to determine project feasibility.
• Developed Data Mapping, Integration, Consolidation, Manipulation and Staging documents.
• Kafka streaming was utilized to create Producer and Consumer Topics and Connectors.
• Performed GAP analysis of business rules, business and system process flows and requirements.
• Ensured that the stakeholder / client needs were addressed.
• Practiced Agile (Scrum) methodology and coordinated daily scrum and iteration reviews.
• Conducted Walk-through and training sessions to justify User stories.
• Created data transmission pipelines to support Extract, Transfer and Load(ETL) front to back Electronic Data Interchange (EDI), Digital Products, Applications and ERP systems using Restapis and SOA (Service Oriented Architecture).
• SailPoint Platform was configured for control of access and identity governance.
• Compliance issues were handled using SailPoint Controls.
• The log information was recorded using Splunk.
• Integrated ingenium for streamlining data and file management systems.
• Conducted and participated in JAD sessions for requirement and risk analysis with various stakeholders.
• Prepared the SRS Document using Use Case diagrams and Activity Diagrams to depict system functionality and user interaction.
• Worked with Guidewire Policy Center systems(Version 7&8) and Electronic Data Interchange (EDI).
• Used Elastic Search for search words optimization requirements.
• Worked as a Subject matter expert (SME) for both functional and technical components.
• Worked with the Legal and compliance teams to create Anti Money Laundering (AML) reports for FINTRAC under Proceeds of Crime (Money Laundering) and Terrorist Financing Act (PCMLTFA) and associated Regulations.
• Acted as an interface between management, stakeholders and execution team f
• Finalized Test Plan, Test Cases and Test Specification Document for the application under test (AUT) in Quality center (HPQC).
• Conducted the UAT and reviewed testing in HPALM and Selenium before final submissions.
• Extensively utilized SQL queries for data analysis and data mining to verify data quality.

Project is to develop loan eligibility assessment tool to better assess credit risk and serve the existing as well as the prospective clients for Credit Products like Credit Cards, Auto Financing, Mortgages/Home Loans. Personnel Loans, Line of Credit etc.

Responsibilities

• Interviewed users, primarily Advisors / Brokers and Planners (group and one-on-one) and other stakeholders to understand the domain, gathered customer requirements through surveys, along with JAD sessions.
• Creation of requirements, business use cases, and functional specifications (FRS).
• Conducted a SWOT analysis to understand the premise “where we are now” to plan moving forward.
• Incorporated BABOK Practices for requirement gathering and facilitating walk through meetings and generated various reports which were used by senior members in the organization.
• Proactively managed systems development, implementation, and risk via the use of SDLC.
• Led the creation of prototype for risk-based scoring system to assess risk tolerance of individual clients. This resulted in additional benefit of advisory compliance.
• Responsible for communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
• Worked with HP QC Tool for defect tracking and SQL queries to generate random data reports.
• Trained field application support Team on various application roll outs.
• Utilized involved in all stages of testing process–Development of Test Plans, Test procedures and Test cases based upon requirements for Functional, Regression, Integration and User Acceptance Testing.
• Worked with Visio to create use case diagrams and used SharePoint to facilitate Communication.
• Verifying and validating the application to ensure that it meets all defined business requirements and associated functionality.

Project was about development of an automatic system which conducts analysis of the clients’ requirements and creates a customized product. It was a Multi Browser application on the internet, Android and IOS mobile application for mobile users.

Responsibilities

• Interviewed (group, one-on-one, surveys and JAD sessions) Advisors, Planners, and stakeholders to understand the domain and gather customer requirements.
• Conducted SWOT analysis to understand the premise “where we are now” to plan moving forward.
• Conceptualized and created requirements, business use cases, and functional specifications (FRS).
• Incorporated BABOK Practices for requirement gathering and facilitating walk through meetings and generated various reports which were used by senior members in the organization.
• Utilized Salesforce for understand and reengineer client onboarding and sales processes.
• Provided clarification for financial terminologies - Equities, Derivatives, Repo, Options, Mutual Funds, Fixed Income Investments, Foreign Exchange (FX) and Fund Wrap Systems as an SME.
• Proactively managed systems development, implementation, and risk using SDLC methodologies and ensured defect tracking with HPQC.
• Led the creation of prototype for risk-based scoring system to assess risk tolerance of individual clients resulting in additional benefit of advisory compliance.
• Ensured flow of communication with stakeholders to provide accurate reporting and information regarding ongoing projects and initiatives.
• Involved in all stages of testing process–Development of Test Plans, Test procedures and Test cases based upon requirements for Functional, Regression, Integration and User Acceptance Testing.
• Worked with Visio to create use case diagrams and used SharePoint to facilitate Communication between the team.
• Verified and validated the application to ensure that it meets all defined business requirements and associated functionality.

Day to day banking, Retirement planning, Tax saving fixed deposits, home loans and Credit cards

Responsibilites

• Handling calls, dealing with clients Day to day banking, Retirement planning, Tax saving fixed deposits, home loans and Credit cards by serving as a basic point of contact for customers with complaints, queries, requests, feedback's and ensured that all the requests, queries and complaints of customer are responded in a timely and professional manner
• Follow up and track on customer queries
• Conducted business requirement definition, business process documentation, and organization wide training
• Coordinated with Business analysts in designing various welcome programs to encourage customers to open more additional accounts.
• Plan and coordinated the development of primary and secondary market research
• Contributed to written and verbal communication specific to the project