Lead Business Analyst with Techno-Functional (with knowledge of SQL and PL/SQL queries/procedures/packages/functions).

Overview

Job Description

• Data Discovery And Data Sources Identification

• Analyzing data for data quality and data integrity issues
• Support in data cleansing and data Enrichment
• Suggest and coordinate for improvements in data
• Document processes / suggest improvements to systems
• Supporting Vendor for documenting Business Rules /Validation of Rules
• Internal Team Coordination / Validating Recon process
• Functional Specification document finalization (Business Rules, Data Mapping Business Logic, Reconciliation /Exception Rules, Completeness)
• Present findings to senior stakeholders on the data challenges
• Support integration activities with FIS Balance-sheet manager solution
• Define entry/ exit criteria for SIT and UAT.
• Participate in creation of Test scenarios covering exceptions, DQ, recon, completeness, reports validation, business rules validation, data flow, adjustments and others
• Participate in creation of Test Scripts (iterative cycle)
• Validation of Test Results (iterative cycle)
• Support for Go Live / Support post go live
• Identify post live issues and support in resolution
• Developing and supporting report development processes
• Participate in data workshops to align data structures of key subsidiaries and international entities
• Liaison with subsidiary data, Risk, Finance and IT teams.
• Understanding subsidiary business rules and automation of business rules.
• Data discovery, Data cleaning activities related to subsidiaries.
• Data Testing related to subsidiaries.
• Validating Recon process
• Proficiency in SQL, including complex queries, joins, subqueries, views, and performance tuning.
• Hands-on experience with PL/SQL procedures, functions, packages, cursors, triggers, and exception handling.
• Ability to analyze large datasets and troubleshoot data-related issues.