Thejasri Jayaseelan

•Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team •Organized and play a part in backlog refinement, review sessions as per Agile framework, and circulated MOM •Worked in transforming business requirements into user requirement specification, Functional Requirement Specifications Document (FRD) •Gathered business requirements and data mapping elements via 1 on 1 interviews and white board sessions •Facilitate requirements gathering and design sessions with multiple stakeholders to extract requirements, and turning them into use cases, user stories, sequence diagrams, cheat sheets •Implemented Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance •Developed/implemented a KYC process whereby advisors can review client investment suitability or update KYC on-line real-time. This process streamlined the update procedure and provided ability to send a pre-formatted PDF form to their client •Created and maintained Requirements Traceability Matrix (RTM), test case mapping to requirements, Project Status reports, issue /defect matrices, UAT test plans and user training documents •Created high-level 'To Be' process models, conducting walkthroughs, and published a gap analysis document for the Preliminary Assessment and input to requirements; documented them as Visio Process Maps and Procedure Diagrams •Created Use case diagrams, Activity, Sequence and Collaboration diagrams using UML • Utilized use case diagrams and business flow diagrams to assist business and technical team in higher perception of the process •Coordinated user acceptance testing (UAT) by providing the scenarios identified and reviewed test scripts formulated •Collaborated with stakeholders to create and prioritize epics and user stories respectively using JIRA

• Ensure efficient delivery of Product through pro-actively participating with all key stakeholders for outlining scope, allocating resources, estimating user stories, and discussing with developers, testers, and end customers to make sure delivery of possible outcomes • Create and review business requirements, functional specifications, project schedules, documentation and test plans using MS Project, MS Visio, and Rational Suite software • Gather change requirements from business and analyze information using AS-IS and TO-BE techniques • Create UML use cases, sequence, activity, data flow and process flow diagrams; initiate and implement user stories and requirements throughout the project • Prepare RTM and ensure to map 100% requirements to the respective test cases • Create Screen Mock-ups and Wireframes, conducting GAP Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis • Conduct JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement • Assisted the QA team in creating Test Plans, Test Cases and performed User Acceptance Testing, Functional Testing and logged defects into Defect Tracking Report • Generate JIRA for all tasks involved in sprints, assign to respective tech agent, monitor till it gets resolved • Participated in extraction of data tables with custom queries using SQL to analyze and manipulate data for custom database analysis

•Engaged in multiple phases of the Software Development Life Cycle Management (SDLC) methodology And responsible for creating, managing, and diagnosing stories in JIRA •Delivered routine progress updates and was able to collaborate with the Product Owner and Scrum Manager to ensure effective handling of any delivery-related issues •Involved in Data mapping specifications to create and execute detailed system test plans •Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Power BI •Implement point of view security to Power BI dashboards to facilitate visibility across various levels of the Organization •Proficient in using Microsoft SQL Server, Hive to extract data using multiple types of SQL Queries including Create, Join, Conditions and constraints etc., •Possess strong logical and analytical skills in relational databases, SQL, data warehousing, ETL, data lakes, data marts, data architecture, data interpretation, data cleaning etc., •The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity •Reverse Engineered the Data Models and identified the Data Elements in the source systems and added new Data Elements to the existing data models. •Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables •Performed data mining on Claims data using very complex SQL queries and discovered Health care claims pattern •Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center •Utilized tools for customization, migrating data, geographical data analysis, data system, data dictionary, data warehouse, modeling tools and visualization

•Assisted in business process architecture, information solutions and common process flow creations to be effective and efficient manner. Develop features that align with specifications while enhancing functionality •Created multi-set tables and volatile tables using existing tables and collected statistics from tables to improve the performance. •Developed Teradata SQL scripts using RANK functions to improve the query performance while pulling the data from large tables. •Wrote technical details as a Development Team member •Clearly understood the business objectives and converted into an analytical problem Developed and managed databases that support performance improvements activities •Worked Cross functionally throughout the organization to maintain the integrity of the database •Performed data query, extraction, compilation and reporting tasks Visualized the data into various charts to understand the trend, patterns and correlations using the tools such as Power BI •Experienced in writing SQL queries for data retrieval and transformation Proficient in applying various excel function such as pivot tables, VLOOKUP to aggregate data