Swethothpala (Swetha) Chennuru

.Wells Fargo: RCSA

• As an Analyst, worked across multiple workstreams, including claims, bankruptcy, default loans, foreclosure.
• Performed a thorough analysis of key-control reports to identify and address any discrepancies or gaps to reduce inherent risk.
• Collaborated with multiple LOBs to analyze and categorize critical reports across claims and retail credit lifecycle.
• Leveraged analytical skills to analyze and interpret complex home lending mortgage default servicing business requirements (i.e
• Data sets, business logic, identify trends, business process) translating them into functional and technical documentation utilizing SQL, MS Excel.
• Continuously monitor and review the process documents as it associates with the risk profile, ensuring compliance with enterprise standards.

CITIBANK:

• Working with Finance and Risk Shared Service- Global Securitization Team to review and Update all End-Users' Computing- Standard operating procedures using SOP guidelines and Topside Methodologies in the latest version.
• Working with the manila team hand to hand to ensure Wide Area Disruption -Corrective Action Plan milestones are delivered on time
• Working on Finance and Risk Shared Service -Risk Weight Assets -PCT (Process Control Tool) Mapping all necessary information from SOP, Blue work FRSS process tree into PCT tool
• Collaborate with key Finance Reporting group manager Elicits, analyzes, specifies, and validates business needs of stakeholders, be they customers or end users.
• Used Excel functions like Pivot table and other functions to summarize the FRSS RWA WAD Milestones, based on FRSS Global Process, Sub Process, and center-wise.
• Partner with Finance and other key stakeholders to define and align solutions for Finance Transformation/ Consent Order and Business simplification opportunities and link those efforts to operational processes within FRSS Reporting teams.
• Tracked and Reported Team/Individual progress to complete deliverables on time.
• Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
• Played a pivotal role in successfully completing high-stakes projects by providing crucial analytical support and insights.

• Act as the liaison between Line of Businesses (LOBs), Technology Partners (Source Applications), and implementation Team.
• Collaborate closely with the Data management team to collect sample data for the implementation within the bounds of policy and regulation.
• Facilitate the scrum call; working on the team often helps the scrum master groom the product backlog and prioritize the stories.
• Working with the team and Enterprise Data masking team to have an enterprise-wide solution to protect restricted and confidential PII information in non -prod environment.
• Working closely with the ETL team to create ETL design documents for loading the data for the persistent layer (data quality and validation rules synchronization with API) using SSIS for the ETL process and Tableau.
• Involved in defining data models, creation of data mapping document between CLM/ Insight attributes to ECLM physical model with data mapping rules for ETL developers, Create SQL scripts to insert contract data into physical tables.
• Using SQL server used to connect Tableau in direct query mode for thecreation of reports and dashboards as per the business requirements.

• .Participated in Daily Scrum meetings to resolve various project-related issues and tasks.
• Coordinated with the Scrum Master in defining Product and Sprint Backlog, creating Burndown charts, etc.
• Worked with the technical team and helped design a solution that helped users to automate their fund accounting, settlement, and corporate action processing via SWIFT messages.
• Communicated and worked with various members of the project team and the client to develop a timeline, create schedules, and oversee progress to ensure goals were met on time. Created and used multiple spreadsheets to track budgets, dates, and other information.
• Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer Systems (EFT) such as ACH.
• Used GAP Analysis to bridge the gap between business processes using both descriptive and diagrammatical methods.
• Performed data validation of thedatabase to get historical data from large data sets andwrote SQL queries to ensure that data was updated to various tables in the database.
• Used SQL queries to filter data.

• Worked closely with product Owner defining / designing various Loan Origination system business processes.
• Gathered and analyzed business requirements from requirement sessions and Worked with Scrum master to create user stories and acceptance criteria using JIRA as per agile methodology.
• Worked with clients and business stakeholders to clearly define client needs.
• Combined all business requirements into a clear, detailed, managed Blueprint tool.
• Used MS Excel to create various analytical reports around the loan criteria requirements and then to perform analysis on various loan products used by the bank.
• Identified data issues in the legacy system and worked with the business team to develop resolutions to those issues.
• Wrote SQL queries for data validation and reporting purposes.
• Worked closely with the QA Team and tested and validated the DU and LPA request and response files in a lower Environment.
• Worked on Creating LPA and DU Testing Certification Preparation in the UAT environment.

• Organized and facilitated meeting with business and development team, conducting requirement gathering session with the purpose of defining functional business and system requirement.
• Used UML models to design Use Case, Swimlane, Activity diagram, and Sequence Diagrams Using Visio.
• Assisted the data integration teams during data migration and performing sanity check on the data loads.
• Assisted the data integration teams during data migration and performing sanity check on the data loads.
• Extensively executed various SQL queries to validate and verify data across the systems to maintain data integrity, validate the data elements in the application, and make sure no missing and duplicate data.
• Used Power BI to create various analytical reports around the loan criteria requirements and then to analyze various loan products used by the bank.

• Coordinated with Product Owner and other business users to document, prioritize, and organize User Stories and translate them into Product Backlogs and sprint backlogs.
• Hosted daily standup, sprint planning, grooming, completed stories and retrospective.
• Hold meeting with Business operations team to understand the current process of ACH payments using NACHA rules and their settlement.
• Acted as the primary liaison between the business stakeholders and the technical team.
• Designed use-case diagrams to present a better understanding of business transactions in a system.
• Used data mapping, modeling, and analysis to extract useful information and helped the business make decisions
• Tracked defects in HP ALM and worked with QA team to resolve defects.

• .Assisted in initial requirement gathering meetings with the stakeholders
• Acted as liaison between the senior management and different teams with effective presentations to achieve the best results.
• Responsible for the elicitation and document of business system requirements for salesforce application.
• Developed Use Cases and Use Case Scenarios and visualized those using UML diagrams in MS Visio.
• Involved in data profiling and data cleansing to eliminate data redundancy using SQL.
• Documented business and user requirements after thorough fact-finding with the project management team and analysis of business workflows and system requirements.
• Documentation of business cases, test cases, system requirements, UAT documentation, and liaison with developers in translating business requirements into functional specifications.
• Collaborated with the QA team to develop the test plan, test scenarios,and test cases based on business requirements and technical specifications.