Business Analyst

Overview

Responsible for data mapping and migration activities related to Loan IQ enhancement requirements, data quality improvements, and regulatory reporting support. Collaborates with application development and software development teams to ensure testing readiness and successful deployments.

• Responsible for data mapping for Loan IQ enhancement requirements.
• Performed testing within SIT/QA/UAT environments.
• Responsible for all lender and borrower loans in LOAN IQ 7.5 to migrate to UBS Platform (EROS/Stealth/IBiS).
• Created scripts for migration in Oracle DB with file ingestion.
• Worked with Loan API and ran Control-M jobs.
• Developed and maintained Java APIs (RESTful) for core banking services, including account management, payments, and reconciliation, ensuring consistent schema evolution and backward compatibility.
• Migration data mapping and gathering requirements.
• Analyzed all data and wrote SQL queries against enterprise database using Oracle SQL Developer; exported results to Excel for business user proofs of concept (POC).
• Analyzed and fixed stored procedures for SNC database.
• Liaised with Credit Loan/L/C domain groups to build new data analytical dashboards.
• Migrated legacy Java monolith to containerized microservices with API gateway orchestration, improving deployment velocity and fault isolation in production.
• Responsible for all data lineage with all data movement.
• Wrote business/functional and data mapping specifications.
• Interacted with application developers and software development teams in weekly standups regarding environmental and upgrade requests that could affect testing regions.
• Identified irregularities in data and flagged data points that could deviate from standards.
• Wrote BRD and FRD for new enhancements and used Visio to perform current and future state architecture designs.
• Worked on data quality enhancements that impact regulatory reporting to Axiom 2052A and call reports from Loan IQ.
• Responsible for testing the Loan IQ application and impacted downstream applications.
• Performed root cause analysis on Jira items assigned.
• Provided daily standup updates in Agile platform from Jira to upper management.

• Experience with data mapping, data migration, and data quality initiatives in a banking/financial services environment.
• Strong SQL skills (Oracle SQL Developer), ability to write complex queries and export results to Excel for stakeholder reviews.
• Experience with Loan IQ and migration projects (LOAN IQ 7.5) to UBS Platform (EROS/Stealth/IBiS).
• Proficiency in Java, RESTful APIs, and development of microservices; experience with containerization and API gateway orchestration.
• Experience with stored procedures and SNC database.
• Familiarity with Jira, Agile processes, BRD/FRD documentation, and Visio for architecture design.
• Ability to analyze data irregularities, perform root cause analysis, and communicate findings to stakeholders.
• Strong collaboration across cross-functional teams and effective participation in weekly standups and communications with upper management.