Senior Business Analyst

Created separate data mapping documents for Personal, Mortgage, Credit Card, Auto, and Commercial Loans to support a third-party CECL forecasting model in both an in-house desktop and external Impairment Studio tool.
Developed an Interface Control Design document, providing an overview of each Loan model, including file standards, extract details and timing, and business/system dependencies with source systems and target applications.
Provided comprehensive mapping documentation with joins, inclusion/exclusion logic, and output file formats for data developers to ensure data integrity and facilitate testing.
Coordinated updates between the core team and Enterprise Data Team, sharing design and mapping documents to build production tables for data sourcing in each model.
Created and maintained metrics for each model, tracking updates for simplified assumptions, derivation logic, and testing completion status. Managed Jira user stories for defect tracking and provided regular
updates to the team on the status of each model.

Led user story writing, grooming, planning, and sizing in two-week sprints, ensuring timely completion and project progression.
Conducted systems and data analysis to standardize Freddie Mac’s corporate data warehouse, benefiting upstream and downstream data users.
Finalized the Business Requirements Document (BRD) and reviewed stakeholder documents for approval in the Credit Risk Transfer data migration project.
Captured business information management details for over 60 data elements, including transformation rules, delta driver joins, and enumeration value sets for AWS migration data-lake mapping.
Created sample test data with 220k records for UAT testing on end user service projects, ensuring thorough testing and capturing defects

Collaborated a team effort to migrate a petabyte-scale customer database from IBM Netezza to AWS Redshift using AWS Snowball.
Extracted and loaded over 150 compressed files (tables) to AWS S3, enabling business-side access to Hilton’s legacy data while minimizing load on DC2 clusters.
Created separate projects within Jira and confluence to handle data maintenance requests and new requirements, ensuring smooth post- migration business processes and handling future needs.
Led the writing, grooming, planning, and sizing of user stories using Jira as the lead Systems Analyst, conducting UAT on a 2-week sprint/iteration cycle.
Led the RFP process with third-party vendor Blend360 and internal procurement team to acquire 34 million U.S. demographics data with over 100 columns enabling data enrichment for marketing and promotions across departments.

Worked on the Loan Coverage Advisor project, writing SQL statements for search engines and ad hoc/on-demand reports, and managed technical design documents for user stories.
Analyzed system requirements, both technical and business, and wrote user stories using VersionOne on an Agile project.
Documented product backlogs and user stories, incorporating acceptance criteria changes and obtaining product owner approvals.
Led user story prioritization efforts before each release and maintained changes during iterations/sprints.
Analyzed query performance using JMeter and improved queries to meet Service Level Agreements (SLAs).
Collaborated with data modelers in creating new columns and tables in the application database.
Provided production support post-deployment, performing data validation and GUI smoke testing.
Led effort in making sure the system integration from VersionOne to Jira and confluence was successful and alleviate the reason to track progress in multiple platforms