Senai Tesfagiorgis
I
Summary
Results-oriented senior business/data analyst and certified Scrum Master with 9 years of experience in IT and business sectors. Successfully created search engine capabilities, analytics, and reporting solutions within the hospitality, secondary mortgage, and financial industries. Expert in data analysis, bridging IT and business needs, and project development lifecycle management. Currently seeking a challenging role to leverage strong analytical skills, collaborative nature, and comprehensive expertise to drive successful outcomes and contribute to organizational growth.
Overview
9
9
years of professional experience
Work History
Senior Business Analyst
Fannie Mae
03.2023 - Current
- Joined the UWT Project to support re-engineering of Desktop Underwriter into a cloud-based platform, aiming to expand and enhance underwriting capabilities and improve operational efficiency
- Planned and Collaborated with cross-functional teams to gather and document detailed data requirements for a EarlyCheck project, ensuring alignment with business objectives
- Created user stories with clear acceptance criterias ensuring alignment with business goals and collaborated with testers and developers to plan and groom the details
- Developed and maintained comprehensive traceability matrices to ensure all project requirements were consistently aligned with design, testing, and implementation processes
- Developed and distributed daily and weekly reports on UWT production data to track engagement and usage trends among onboarded lenders, ensuring active submission of casefiles
- Produced a weekly rollout report for leadership, utilizing charts, Vlookup, Index/Match and pivot tables in Excel to clearly communicate progress on lender enrollment and system adoption metrics
- Facilitated daily check-in meetings with production support teams at various levels to address lender transition challenges, ensuring a seamless experience with the cloud-based UWT system
- Executed multiple ad hoc Tableau reports to capture and analyze the progression and impact of the re-engineered Desktop Underwriter system, highlighting key areas of growth in underwriting capabilities
- Designed advanced Excel tutorials to enhance team efficiency, empowering colleagues with best practices for data manipulation and reporting within the project
Senior Business / Data Analyst
Navy Federal Credit Union
09.2021 - 03.2023
- Created separate data mapping documents for Personal, Mortgage, Credit Card, Auto, and Commercial Loans to support a third-party Current Expected Credit Loss (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 to target mapping
- Designed frameworks for data validation, cleansing, and standardization to maintain high data quality across organizational systems
- Coordinated comprehensive data mapping documentation with stakeholders done in Excel with joins, inclusion/exclusion logic, and output file formats for data developers to ensure data integrity and facilitate testing
Senior Data/Systems Analyst
Freddie Mac
06.2020 - 09.2021
- Led user story writing, grooming, planning, and sizing in two-week sprints, ensuring timely completion and project progression within Single Family business
- Conducted systems and data analysis to standardize Freddie Mac's corporate data warehouse, benefiting upstream and downstream data users
- Proficient in data governance tools like Collibra, Informatica, or Alation to enable efficient data management and reporting
- Finalized the Business Requirements Document (BRD) and reviewed stakeholder documents for approval in the Credit Risk Transfer data mapping and 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 in Excel and SQL with 220k records for UAT and Production environment on end-user service projects, ensuring thorough testing and capturing defects
Senior Systems Analyst
Hilton Worldwide
08.2018 - 06.2020
- 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 the load on DC2 clusters
- Collaborated with cross-functional teams to define data ownership, accountability, and stewardship roles
- 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, Confluence and SharePoint as the lead Business/Systems Analyst, conducting UAT on a 2-week sprint/iteration cycle
- Led the RFP process with the third-party vendor Blend360 and the internal procurement team to acquire 34 million U.S
- Demographics data with over 100 columns enabling data enrichment for marketing and promotions across departments
Systems / Data Analyst - Professional
Freddie Mac
08.2016 - 08.2018
- Worked on the Loan Coverage Advisor project within Single Family, writing SQL statements for search engines and ad hoc/on-demand reports in Excel, 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
- 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
Education
B.B.A. - Computer Information Systems
James Madison University
Harrisonburg, VA01.2015
Skills
- Database Design / Modeling
- SQL Server
- DB2
- MongoDB
- Service Now
- Informatica
- Requirements Management
- Jira / Confluence
- VersionOne
- IBM Rational DOORS
- HTML5
- JavaScript
- AngularJS
- Visual Basics 2010
- Microsoft Office Suite
- Visio
- SharePoint 2013/16
- CSS
Timeline
Senior Business Analyst
Fannie Mae
03.2023 - Current
Senior Business / Data Analyst
Navy Federal Credit Union
09.2021 - 03.2023
Senior Data/Systems Analyst
Freddie Mac
06.2020 - 09.2021
Senior Systems Analyst
Hilton Worldwide
08.2018 - 06.2020
Systems / Data Analyst - Professional
Freddie Mac
08.2016 - 08.2018
B.B.A. - Computer Information Systems
James Madison University
Similar Profiles
Moses Judson Edward Sundaram Ananthajothi BalanMoses Judson Edward Sundaram Ananthajothi Balan
Senior Technical Architect at Fannie MaeSenior Technical Architect at Fannie Mae
Renaldi FalwellRenaldi Falwell
Cybersecurity Intern at Fannie MaeCybersecurity Intern at Fannie Mae
Yumika HughesYumika Hughes
Community Manager at Sodexo/Fannie MaeCommunity Manager at Sodexo/Fannie Mae