*

Deepthi Jagadish Prabhu

Mobile: 551-***-**** Email: ad1wwk@r.postjobfree.com Piscataway, NJ Professional Summary

9+ years of overall experience in Travel and Banking domain as Business Analyst Data Analysis • SDLC • Requirement Gathering (BRD, User Stories) Technical Skills

Technologies & Tools : MS Excel, SQL, Tableau, JIRA, MS Visio, Altea Suite Git, Bitbucket, IntelliJ IDEA, Assembler, VS Code, Notepad++, Mobaxterm Databases: MS SQL Server, DB2, Dbeaver, Squirrel Client Employment History

CIBC

Business Analyst June 2022 – Nov 2023

• Drafted current/future state process flow for Credit Risk Rating using MS Visio, after detailed sessions with SMEs in the project

• Co-ordinated User Acceptance Testing for the project impacting 20+ applications

• Documented test scripts for different applications based on requirements and discussion with the end users

• Actively involved in charting the sequence of activities and dependencies for project go-live and tracking them to completion

• Supported the Business in verifying data attributes and validating the reports post go-live using Excel

• Served as a Single Point of Contact for UAT for an AML migration project involving multiple workstreams and presented status/ critical risks weekly to the higher management

• Facilitated critical conversations between Business and development team

• Used SQL queries to identify Data Quality issues and supported testing activities for AML team

Bank of America

Business Analyst

May 2020 – Sep 2021

Client Reference Data for different trading platforms

• Co-ordinated bank-wide legal entity rebranding project which involved 20+ downstream applications

• Worked with Data Operations team to understand repeatedly occurring data issues and provided solutions to streamline the existing process

• Analyzed 20 workflows of client onboarding lifecycle and worked with the users to identify new requirements and documented them in JIRA

• Assisted the testing team to build control reports using SQL queries, to resolve data 2

quality issues between Reference Data Platform and other applications

• Lead cross-functional teams to achieve their objectives and resolve issues around data management

Education & Certification

• Bachelor of Technology in Information Technology at Federal Institute of Science & Technology (FISAT), Angamaly - Jun 2007 to May 2011

• Tableau 2020 A-Z: Hands-On Tableau Training for Data Science - Udemy

• Excel Crash Course: Dashboards, Data Analysis & Heat maps - Udemy

• JLPT N4 by Japan Educational Exchanges and Services & Japan Foundation Bank of America

Business Analyst

May 2019 – Dec 2019

Data Conversion of legacy system which performs AML (Anti –Money Laundering) / KYC (Know Your Customer) for clients

• Coordinated with various stakeholders to gather requirements for decommissioning the legacy system performing AML/KYC validations

• Participated in data modeling for client reference data focusing on KYC Aspects - Customer Due Diligence (CDD), sanctions, beneficial owners etc.

• Used SQL to identify data quality issues from approx. 700K KYC records in the source system that enabled the team to layout a remediation plan before data conversion

• Recommended user interface enhancements in the new PEGA application based on analyzed data patterns to improve customer experience. Japan Airlines

Oct 2011 – Feb 2017

Technical Business Analyst

Japan Airlines (JAL) legacy Passenger Service system (PSS) migration to Global distribution system (GDS), Amadeus.

• Facilitated sessions with SMEs and analyzed multiple documents to understand requirements and drafted functional and technical requirement documents

• Consolidated the airline reservation reports from approx. 2M records and used SQL to identify edge cases and unspecified data patterns

• Managed a team to design a tool using SQL to extract reports of rejected records, which saved time by limiting manual intervention during real time migration

• Developed and ran Jobs on weekly/monthly basis for consolidating different classifications of airline bookings from huge volume of data for time-to-time analysis

• Performed and documented gap analysis, data mapping and identified risks and dependencies involved

• Initiated discussions to revise existing process ahead of migration to restrict non-standard bookings and thus scaled down records that needed special handling

Contact this candidate