MISMACK GIRMA

Email: ad0lsr@r.postjobfree.com

Phone:202-***-****

*** ********* **** *****, ************ MD 20879

PROFESSIONAL SUMMARY

Senior Business Analyst with 8 years of experience in Business System Analysis in financial, Mortgage, banking, home equity sector with Business requirements gathering, Database Design and development of Web Based, and Client/Server applications.

Experience in COSO controls for regulatory and risk reporting purposes.

Experience in OFSAA Basel III Advanced Approach Implementation for Credit Risk.

Writing skills in preparing Business Requirement Documents (BRD), System Requirement Specifications (SRS), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and Technical Design Document (TDD).

Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).

Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.

Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.

Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD).

Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, Load Runner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL.

Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.

Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.

TECHNICAL SUMMARY

ETL Tools: Ab Initio DQE, Talend Open Studio, Informatica Power Center […]

Tools: LoanSphere Empower, Enterprise Architect, Microsoft Visio, Rational Rose, Requisite Pro

Operating System: Windows UNIX, Linux

SAS Tools: PC SAS, SAS V8, V9, SAS/BASE, SAS/ACCESS, SAS/SQL

Programming Languages: R programming, SQL, XML, Java, C++, C#, Visual Basic, HTML, VB Script, J2EE, CSS, AJAX, Python, Shell, Perl, C, ASP.Net, and VB.Net

Databases: Oracle, MS Access, Microsoft SQL Server, Sybase, DB2, Hadoop

BI Tools: Tableau, QlikView, Business Objects, Crystal Reports, OBIEE, COGNOS

Testing Tools: Test Director Quality Center (QC), QTP, Win Runner, Load Runner, Clear Quest, JIRA

Tools: HELOC loans, MS Visio, Rational Rose, MS SharePoint, Management Studio, TOAD, MS Office, MS Project, UML, PL/SQL, Confluence, ILOG, Doors, Tivoli, AutoSys, Wiki, SPSS, JMP, IBM DOORS

PROFESSIONAL EXPERIENCE

Wells Fargo - Remote (March 2021 - Current)

Advanced Finance Risk Analytics Consultant

Project- Capital Markets Finance Analysis and Controls (CMFACA): Enterprise Finance drives financial management for the company and maintains and enhance risk and financial controls. Key functions within Enterprise Finance include finance and accounting; Treasury; corporate development, mergers, and acquisitions; Data Management and insights, the Customer Remediation Center of Excellence, Enterprise Shared Services, Business Process Management, and Corporate Strategy. Enterprise Finance informs shareholders, regulators, taxing authorities, employees, and leaders of the company’s financial performance through earning release, investor meetings and conferences, and meetings with regulators and credit rating agencies, following appropriate reporting headlines. They also maintains and enhance risk and financial controls and leans many of the company’s shared services functions including corporate properties, security, and global services.

Responsibilities:

Responsible for performing and supporting activities related to creation, implementation, documentation of all SDLC compliant artifacts require by project governance model.

Supports implementation of moderate to complex project/initiatives and lead the change management process.

Managing and prioritize Business Requirements in SharePoint. Conduct monthly priority meetings with deferent Business groups stakeholders and PO’s to review business request priorities and business values of the change requested.

Partner with SMEc and respective stakeholders to review and understand business requirement priorities to establish constant flow of intake for Agile teams.

Determine operational objectives by studying business functions, gathering information, evaluating output requirements and formats.

Construct workflow, process flow charts and diagrams; studying system capabilities; writing specifications.

Identify and provide recommendations to improve systems by studying current business practices/processes; designing modifications.

Monitor project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.

Produce high quality Monthly Financial reporting for higher management on statuses on implemented/productionalize, ongoing projects and future business requested to be implemented.

Responsible for creating and tracking of work efforts in Sharepoint for developers to track the work delivery path so that they can be tracked accurately thru the implementation phases(BRD/Sizing/Development/Testing/implementation) and also manage the release dates.

Wells Fargo - Charlotte, NC (October 2017 - March 2021)

Data Analytics Consultant

Project - eONE: Seeks to establish “one number” instrument data foundation that is complete, reliable and aligned to the general ledger. eONE establishes the authoritative data source for risk and regulatory reporting and insures compliance with BCB239, G&O and the Wells Fargo Enterprise Data Governance Policies and Standards. I am a part of Data Exchange team(DEX), an efficient data provisioning utility that efficiently and accurately delivers data between approved sources and target systems securely.

Responsibilities:

Involve in all phases of Software Development Life Cycle from analysis to testing and production support in Agiel methodology.

Act as a lead for Data Exchange production support team. Perform Data Motion Controls activities and control duplicate records coming from data source during production.

Lead the WIFP team in COSO data motion control activities. Perform requirement gathering and data analysis activities for data source, integration processes and Universal Extract.

Work with business partners to better understand their needs and present solutions using structured SDLC approach.

Work closely with Business BA team on integration, ensuring the business flow, process flow, data flow as per the requirement. Work closely with Project Owners and Senior Management to determine release goals and to define scope of the project.

Responsible for on boarding new SORs into eONE. Perform data profiling and analysis on new SORs before handing over the data to DEX developers and QAs.

Create data model requests, DDL and mapping documents that serve as the basis for all ETL.

Create, profile, validate and verify mapping documents. Perform in depth data profiling and data validation activities.

Verify and analyze QA test results and unit testing. Collaborate with QA teams to identify test scenarios and build detailed test cases queries.

Develop and execute SQL queries for validating and testing large volumes of data.

Collaborate with DEX developers team to develop service oriented architecture, and data warehouse system to utilize data mining for data analysis.

Supply knowledge transition and support DEX developers and QA team.

Work with the business partners mapping team and source teams to deliver data effectively into eONE.

Coordinate with sources teams and consumers to establish OLAs/SLAs.

Partner with indicative, balance and universal Extract mapping team in the implementation of new ETL functionality or the enhancement of existing ETL.

Provide functional SME-level support of ETL process for eONE - IFT/UAT/Prod validation.

Act as a liaison amongst scrum teams, source team, business team and supporting functions like data governance, data lake and compliance.

Document, analyze and prioritize user requirements and converted them as functional requirements that must be included in the development process.

Involve in requirement gathering including interviews, brainstorms and organize meetings with the business team and created requirement specification.

Responsible for implementing and configuring business rules in DEX, ensure that SDLC and TPM processes are followed and create business flow documents accordingly.

Maintain and update mapping documents, FSDs and BRDs.

Create, groom, assign tasks to resources and prioritize user stories.

Capital One - Richmond, VA (August 2015 to September 2017)

Business System Consultant

Responsibilities:

In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.

Responsible for managing data for the new Empower Originations System in an AGILE environment.

Evaluate acceptability of loans to corporations that bought loans on secondary mortgage markets, where existing mortgages were bought and sold by investors.

Work closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

Maintain existing Basel Pillar 3 reporting and developing new guidance as needed for BCBS 239.

Create Business data flow/data model diagrams and Use Cases for Reconciliation Process application Empower for loan documents.

Analyze simple to complex data usage using Ab Initio Data Quality Environment (DQE) or Data profiler.

Improve existing process, lowered "Time to Delivery" by helping create and transition legacy reports to self-service tool (OBIEE) and Business Relationship Custom Language (BRCL).

Assist in implementing the Liquidity Module of OFSAA (Oracle Financial Services Analytical Applications) for LCR / Federal reporting. Develop the data lineage diagram reports.

Enhance skills and overall Primary Mortgage lending knowledge by participating in cross training programs as recommended/required by manager. Create Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Technical Design Document (TDD).

Users, document any issues or defects and eventually got sign off from the right parties.

Use Shared Containers and create reusable components for local and shared use in the ETL process.

Work on Forecast total loss allowance for Loan Lease Losses, weigh potential risks, evaluate collateral, revoke privileges, reduce credit limits, close accounts, propose accounts for charge-off.

Help with data modeling and defining the conceptual and logical model of the data warehouse.

Generate sample data to test Ab Initio graphs and execute graphs through shell script.

Create job schedules to automate the ETL process.

Create Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.

Analyze the test results from QA teams using Performance Studio Analysis to create various scenarios.

Develop strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing (UAT).

EDUCATION

Master’s of Science - Cyber Security

Mercy College, Dobbs Ferry, NY

GPA 3.39

Contact this candidate