Regan Selvaraj

• Collaborated closely with business stakeholders to define and refine functional data requirements, ensuring alignment with strategic objectives and operational needs.
• Acted as a pivotal liaison between business units and technical teams, translating complex data requirements into actionable engineering tasks.
• Spearheaded the prioritization and maintenance of the engineering backlog, facilitating agile development processes and ensuring timely delivery of data solutions.
• Developed and implemented robust backlog management practices, including the use of project management tools and methodologies to streamline workflows and enhance team productivity.
• Fostered a culture of continuous improvement by regularly reviewing and adjusting the engineering backlog based on stakeholder feedback and evolving business requirements.
• Initiated and led cross-functional meetings to discuss and refine data requirements, ensuring a shared understanding and commitment to project goals across teams.
• Developed and maintained data mapping documents.
• Conducted detailed gap analyses between actual performance versus expected performance metrics.
• Identified trends and insights from large datasets through exploratory analysis and statistical modeling techniques.
• Reviewed existing systems for areas of improvement or optimization opportunities.
• Acted as subject matter expert on system analysis, design and development for product teams and other specialists.
• Collaborated with program and product managers, architects and data scientists to understand data needs and represent insights in visually appealing ways.
• Supervised existing programming processes from concept through production, optimizing source code for responsible data management and analysis.
• Assessed programs to identify risks or problems to determine appropriate responses.

Central Credit Registry – Enquiry

• Analysis of enquiries from response XMLS.
• Analyze and design Parsing rules to extract data from XML.
• Gather Business name, business definition, data type, data length, data size for all columns and business definition for tables, data stewards and business owners for all new database objects.
• Estimate space required to setup new tables and environments for development, system testing, BAT testing and performance testing.
• Validation of XML parsed data using Python libraries.
• Creation of Automated test suite using Python libraries.

CMA – FCA Metrics-Open Banking/PSD2

• Understanding the end to end API data flow from Kafka to EDW.
• Define data process and rules for acquiring data from various Tier 1 and Tier 2 tables to transform and load into the Tier 3 data mart.
• Interact with business to identify the gaps in the underlying source systems and design end to end flow for acquiring new data elements and design data flow to Warehouse.
• Design new Tier 2 and Tier 3 tables for acquiring the new data elements and enabling end to end traceability of data flow and applications.
• End user report based on Oracle-Jason output.
  Created Business requirement documents and plans for creating dashboards.
• As the delivery lead of the project, communicate with business owners and update the progress of each of the development, discuss design decisions and provide required documentation to substantiate choice of technology and tools, implementation process, reference data management and metadata management.
• Update project stakeholders with the progress of the project deliverables and milestones

Annual Financial Reporting

• Design Data Mapping to illustrate the lineage of data flow from Tier 1 to Tier 2 and from Tier 2 to Data Mart.
• Interact with Finance and Risk business teams to understand the current reporting model and identify metrics that needs to be sourced from the new ECL models.
• Work along with the business to understand the rules for deriving each metrics and align the new design accordingly.
• Interact with business to define Metadata information for tables and columns. Update this information in the Enterprise Metadata Hub and ensure compatibility and uniqueness of definition across the Enterprise.
• Enable System Testing and support User Acceptance testing.
• Design Data Quality rules and DQ Reports to be published in the event of DQ rules violation.

Large scale Group Data warehouse implementation for an LBG Bank

• DSSL is a construction of new data mart for end users to have analysis on party, product and customers information.
• · We have source as DB2 log file and fed the same into Teradata environment staging layer using Bteq scripts, logical business transformations are applied and loaded into atomic layer using Teradata Fast/Multiload utilities.
• After that the data from atomic layer is populated to delivery layer their extracts are taken for Data analysis purpose.
• Setting up Data Lake and Environment for testing.
• Validation of High-volume Extracts using UNIX.
• Data Reconciliation using Pivots for Financial column Validation.
• Creates new virtual environments for automation, performance, test data management and functional testing

Setting up a Location based Reporting Service for a major Insurance giant in US.

• The Terrorism Data Accumulation and Reporting program provides a process which delivers information to maximize concentration of risk to minimize adverse selection and to manage the aggregation of values and limits exposed by a location.
• The process is supported by Workers Compensation information, Property Information and by accumulation process bringing the Location, Workers Compensation and Property exposures together.
• The data is used to support aggregation reporting.
• Create and deliver the big data architecture for QA.
• Create and deliver the de-normalized data mode for personal and commercial line customer storage in hive.
• Sqoop the data to HDFS.
• Load HDFS data to Hive – External table.
• Load the de-normalization data in hive streaming table for Analytics and BI purpose.
• Data Ingestion Testing
• Meta data testing in landing layer
• Testing - Staging layer Hive External table.
• Data Processing Testing,Requirement analysis, Data design, Data Analysis

Senior QA – Data Migration from Opics to Calypso.

• Data Migration Calypso Validations for Treasury Products.
• Calypso binary validation.
• Sending downstream feeds and marks for other system.
• Reconciliation and Integrity Tests
• Works with IT to define best data management approaches for QA

Test Consultant for Customer Decisioning system for RBS

• Customer Decisioning Strategic Programme is a platform which involves creation of an enterprise wide data warehouse (EDW) in Teradata.
• This will help in customer centric decision making with regards to credit and fraud risk management capability
• Delivered through automated credit risk decision system, helping the business to make the best value decision each time they interact with the customers.
• Test Design [Script preparation and Scenario Development]
• CIT, ST and UAT Support.
• Developing Informatica code to automate the data validations.

SEPA Payments Tester for Electronic Data Captured Services for RBS.

• RBS UK has low levels of automation and many dependencies on manual intervention resulting in inefficient and expensive processes as a result of high movement of paper, numerous hand-offs, high numbers of defects, high error rate, extensive rework, poor data capture and fragmented systems.
• This also contributes to a high level of queries and complaints.
• There is an opportunity for the Enhanced Data Capture work stream to reduce costs
• Involved in Device Testing.
• Ran existing automation scripts using selenium web driver.
• Conduct Functionality and Regression testing during the various phases of the Bank application.
• Defect Tracking.
• IBAN, BIC Validation
• SEPA payment Validation
• ROI Payment Validation
• Relay Payment Validation
• Intra/Inter Bank Validations
• Environment Setup for building the project.
• Co-ordinate with the development team for fixing bugs.
• Reporting bugs with severity and priority according to customer requirement.