SUMMARY:

• 10 years of IT experience in the finance and banking industry as a Business Analyst/Project Manager
• Currently working with Confidential /BNPP on CCAR & Informatica Master Data Management (MDM) using Informatica
• Experience in business automation, business process engineering, compliance implementation and enterprise modeling.
• Well versed working on front office, middle office and back office systems.
• Experience in Credit/Market Risk, Derivatives, FX, Fixed Income and Equity Products.
• Familiar with Dodd Frank Act, CCAR Regulatory Reporting - FR Y-14 Monthly, Quarterly, Annual, FR Y 9-C and others required for banks for compliance reporting to various regulatory agencies.
• Experience working with Credit Risk - Counterparty Limits, Exposure, Settlement Risk, Category Risk, CSA, ISDA etc.
• Created project plans/schedules and pertinent documents at various stages of the project life cycle for reporting to stakeholders, senior managers and operation committees
• Experience creating documents for all phases of the project from inception to production release.
• Created Scope/Proposal Documents, Business Requirement Documents, Functional Requirements Specifications, Test Plans, Test Cases, Traceability Matrix and ad-hoc documents as required.
• Developed and executed test cases and scripts for regression testing, integration testing, functional and system testing.
• Extensive experience doing GAP Analysis and complex systems migrations.
• Used to working in a high-pressure / high-stress environment with minimal supervision. Ability to multitask and learn new languages and applications on the fly.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Tools: MS (Project, Office, Visio, Outlook) Sharepoint, Mercury QualityCenter, Rational ClearQuest, Rational ClearCase, Collibra, Denodo Virtualization

Methodology: RUP, Agile, Waterfall

Languages: XML, SQL, Java

Platforms: Windows, UNIX

Databases: MS Access, MS SQL Server, Oracle, Sybase, SQuirrel

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Lead Business Analyst/ PM

Responsibilities:

• As a lead business analyst, worked closely with the business & reporting team to gather requirements and understand the tactical approach to implement a strategic solution (EDW).
• Currently working on Informatica Master Data Management (MDM) part of LANDIS Project using Informatica Data Directory (IDD). This project will gather all customer information from all SOR’s and create golden customer records with related parties associated. This will later be consumed by KYC and KYA compliance.
• Understanding current data flows and how they can be implemented in to MDM and create the architecture based on current flows.
• Defining match-merge and survivorship rules to pick a winning record.
• Designing on the data model and elements required to create the data model.
• With merging of First Hawaiian Bank (FHB), Data migration was necessary as we had to report as one. Understanding the products and functionalities and how to implement them into Confidential warehouse/marts (FARM).
• Created requirements for schedules mentioned above while also working closely with the Data Modelling & Data Governance (Collibra).
• Data masking using Delphix.
• Rewiring from FDM to EDR to create a more structured data warehouse for CCAR, ALM & 5G reporting.
• Lead a team of 6 BA’s who extract data from various source systems while identifying gaps in the current tactical solution for consumer (loan, Mortgage loans (FL, HE), Auto loans and wholesale (Corporate wholesale Risk using Moody’s (MRA), CRE(Commercial Real Estate) & C&I (Commercial & Industrial).
• Currently working on defining requirements and for Schedule B-Securities & creating a Data Dictionaries followed by Schedule-H Wholesale risk, commercial and retail products.
• This data being extracted will also be leveraged for 2052-A which bank has to start reporting January 2017.
• Coordinated QA and development teams to ensure requirements are implemented accordingly.
• Created traceability matrixes to ensure coverage of requirements.
• As a part time PM, responsible for tracking issues and defects and making sure they are being handled according to priority.

Confidential, Livingston, NJ

Sr.Business Analyst/ Project Manager

Responsibilities:

• Lead the Planning and Business Analysis of various Liquidity Reporting projects across CIT, DCC and OWB using waterfall methodologies.
• Defined and managed project requirements (Tactical and Strategic) and schedules to adhere to regulatory and internal cut-off dates using sharepoint.
• Created business and functional requirements based on FR2052a & LCR (Liquidity Coverage Ratio) as mandated by the FED.
• Monitoring reference data standards in Collibra, and creating crosswalks.
• Identified Risk profiles (HQLA assets), counterparty classifications and product/sub-product permutations at the branch level as per regulations
• Defined derivation/aggregation rules for ETL implementation and process where dependency required.
• Performed Data Integration, Data Migration and Data Reconciliation from OWB, DCC to CIT. Created technical specifications for automating these processes as per the CIT data model.
• Worked alongside Treasury and Finance/GL teams to file 2052b, FRY9C & FRY14 Schedules for Liquidity/CCAR reporting.
• Knowledge in regulatory and compliance with BASEL III & DFAST.
• Involved in design of loan & leasing hubs to standardize data across multiple source systems.
• Performed Data Integration, Data Migration and Data Reconciliation from OWB, DCC to CIT. Created technical specifications for automating these processes as per the CIT data model.
• Assisted the Data Governance team in data sourcing, gap identification & fulfillment and resolution of data quality issues as part of end to end implementation.
• Worked with development team in building logical data models and design of liquidity reporting solution.
• Coordinated with QA teams in functional validation for FR2052a & LCR reports.

Confidential, New York, NY

Business Analyst/ Project Manager

Responsibilities:

• Created detailed flows of the current state and future state to understand and communicate the requirement for enhancements. This helped obtain stake-holder buy in and secure the required funding for the project. Created the entire Project Plan for the project with schedules, roadmap, toll gates and major delivery dates.
• The major benefits included correct settlement and netting as well as correct treatment for CSA counterparties. End result was lowered and corrected exposure which resulted in lower RWA, and eventually lower capital as per Basel requirements.
• Major component for Credit Risk was CVA and Stressed CVA which was the bulk of the CCAR schedules. Main schedules were the FRY-14A.5 and FRY-14Q - Schedule L - Counterparty.
• Created detailed requirements via Business Requirements Documents, Supplementary Reference Documents, Functional Requirements Specifications and several Visio flows.
• Added requirements to add real time settlement messages which lowered intraday-risk.
• Coordinated with the Credit Risk Managers, IT leads and Stakeholders on a daily basis via group discussions to elicit and confirm requirements.
• Created a detailed issue log to track and communicate open items.
• Created a detailed end-to-end high level test plan with intraday/end-of-day flows and regression tests which was used by all stakeholders to understand the testing.
• Interacted with the Development Teams in China/Hong Kong on a daily basis to track project progress.
• Other projects included creating requirements for on-boarding and EUC application to the bank support platforms, and creating requirements for comparing and loading limits from source to destination systems.

Confidential, New York, NY

Sr. Business Analyst/ Change Manager

Responsibilities:

• Managed the project life cycle from impact analysis through UAT. Lead the project for integrating the Broker Origination Platform & the Loan Custody System to the Whole Loan Trading System.
• Performed extensive GAP Analysis for the system integrations.
• Created bi-weekly status reports to review with senior managers.
• Reports included RAG Status, Accomplishments, Deliverables, Milestones and RAID Issues.
• Interacted with SMEs’ from all business streams (traders, collateral analysts, transaction mangers, underwriters, legal, operations etc.) to gather requirements and perform change analysis. Helped elicit system changes from business requests.
• Performed regression tests on the trading, deal management and loan inventory systems to test new bids, portfolio creation, portfolio splits, portfolio accounting, trade booking and updates, synthetic assignments, mark to market functionality and whole loan sale/securitization
• Performed UAT, tested pipeline messaging and underwriting calls on the loan origination platform and the automated underwriting engine which were vendor managed products.

Confidential, McLean, VA

Sr. Business Analyst

Responsibilities:

• The tool was a highly desired application among Risk Managers and Traders who could plan in advance by understanding the credit risk as well as the loan pipeline.
• This tool also helped in measuring, monitoring and managing credit risks by providing a range of analytical capabilities and control.
• The biggest challenge was creating the requirements for interaction between the online loan processing system (Form 1003) and the underwriting engine (Loan Prospector).
• Created Integration Requirements Specification between various applications/databases in the work stream to elaborate the hand-off for data. These documents would specify the interfaces, data format and any required data transformation.
• Interacted heavily with the QA Teams to ensure testing of software while maintaining quality procedures.
• Ensured that the developed application adhered to SOX Compliance.
• Participated in Code Review Sessions to identify defects and shortcomings in the code.
• Assisted the business users in conducting UAT

Confidential, Portsmouth, VA

Business Analyst

Responsibilities:

• Major challenge was designing the application for ease of use and simplicity, while incorporating details pertaining to APR, down payment, personal and asset information etc. This was overcome by designing iterative prototypes and obtaining user feedback.
• Reviewed business rules, process workflows and competitor sites to design an aesthetic interface that encompasses all the requirements for mortgage origination.
• Modeled use-case diagrams to show end-user interaction with the personal information, loan information and property information modules.
• Performed sanity checks to ensure security and validation of online submissions. Included features to display contextual help in each section of the process.
• Created test cases for system use-cases to validate functionality.