NEETA

PROFESSIONAL SUMMARY

 A high performing Techno- Functional leader with expertise in data analysis, data quality, data management and program management.
 Seventeen years of Business Analysis, Data Management and Program Management experience in Health care and Finance industry.
 Expert in integrating systems acquired through mergers and acquisitions, re-engineering systems applications and business processes
and migrating applications.
 Managed a team of 10+ BA’s, BSA’s and QA resources.
 Experience managing multiple complex, high profile projects across functional and technical teams.
 Experience in managing change management of requirements throughout the Software Development Life Cycle (SDLC).
 Excellent written and oral communication skills with a results-oriented attitude.
 Extensive experience in conducting Joint Application Development (JAD) sessions with committee of Subject Matter Experts (SME’s),
senior management and IT groups.
 Hands on experience in CCAR FRY-14M (First Lien, Home Equity, Address Matching and Credit Cards) and 14Q (Commercial Real
Estate (CRE), Corporate Loan (CORP) and Supplemental) Reports. Possess good understanding on the Reconciliation process of FRY
14 M/Q Reports to FRY 9C.

PROFESSIONAL EXPERIENCE

Wells Fargo Bank

Sr Lead Data Management Analyst Feb 2019- Current Data
Management Lead responsible for data ingestion and provisioning of Wells Fargo’s largest wholesale loan portfolio (~$550 Billion) in AFS
(Automated Financials system), LOANIQ, and Strategy by leveraging the iHUB APP (Integration Hub App). Responsible for ensuring IHUB is
able to provision wholesale indicative and financial data that is ‘fit for purpose’ for various downstream Risk, Finance, Regulatory systems
such as eONE, Profitability systems, Market risk calculators, ALM (Asset liability Management) etc. Managed the LIBOR to SOFR transition
project for IHUB commercial lending POD. Lead the AFS to LOANIQ multiyear conversion for IHUB App.

Responsibilities:
 Co-ordinate with SOR (system of record) SMEs and ingest data related to any new requirements/enhancements.
 Lead the IHUB commercial lending BA team and assign work based on priority.
 Work with tech team to manage pipeline and work on release schedule.
 Production support for any critical month end, quarter end and year end issues.
 Onboard new IHUB consumers
 Constantly provide support to all downstream consumers and ensure data is delivered according to SLAs.
 Gather requirements from consumers and deliver them based on priority.
 Work with data quality and governance team to align with wholesale data strategy.

Silicon Valley Bank, CA

Senior CCAR Reporting SME Jan 2018 –Jan 2019
Senior Reporting SME responsible for executing standardized regulatory reporting processes and procedures in compliance with FRB
regulatory requirements for Silicon Valley Bank’s Comprehensive Capital Analysis and Review (CCAR). Currently responsible for the
following schedules: Retail (A- First Lien, C – Address Matching), Securities, Operational Risk and Regulatory Capital (RCI and RCT)
schedules. Responsible for end-to-end process of data aggregation, report execution in Axiom SL, reconciliation to FRY-9C, review and
approval process with the management.

Responsibilities:
 Co-ordinate with Lines of Business to obtain data required for CCAR Monthly and Quarterly Reports.
 Execute workflow in Axiom SL and generate Monthly and Quarterly FRY 14 M/Q reports in Axiom.
 Perform period over period data analysis and resolve any data quality and edit check issues.
 Perform reconciliation of the FRY 14M and 14Q Reports to FRY 9C and GL data.
 Review the FRY 14M and FRY 14Q reports with the business owners to obtain business approval.
 Gather 3 levels of approvals before submitting to the reports to Federal Reserve Bank.
Environment: Axiom SL, CCAR, Retail A, Retail C, Securities B, RCI C, RCT D, Ops Risk E, FRY 9C

Bank of the West, CA

Senior Business Analyst- CCAR May 2016 – Dec 2017
Senior Business Analyst on the CCAR project for Bank of the West (BOW) tasked to formulate CCAR data sourcing requirements for multiple
loan schedules (Credit Card, Mortgage, wholesale) and automate through the creation of business and functional requirements for IT
development, following the FR-Y 14M and FR-Y 14Q documentation. Perform reconciliation of the schedules balances to the call report
(FFIEC 031). Lead the analysis for a strategic initiative ‘FARM’ (Finance and Risk Data Mart) which will be a consolidated database used for
all regulatory reporting.

Responsibilities:
 Conducted requirement gathering sessions for the FARM initiative with Risk, Treasury, Finance and Enterprise Data Management
groups.
 Conducted requirement gathering sessions to understand source data for consumer, commercial and small business credit cards and
how they map to the CCAR credit card monthly (M) schedule.
 Performed source to target data mapping for credit cards from multiple sources (APPRO - Loan origination system, FDR and TSYS –
loan servicing system) to CCAR credit card schedule. Includes CCAR mapping documents, metadata, reference tables etc.
 Performed source to target data mapping for Mortgages (Unifi – Loan origination system, Loanserv and SBO – Loan servicing system)
and commercial loans (AFS – Loan servicing system) to CCAR Mortgage schedules (First Lien(FL) and Home Equity(HE) and Address
Matching) and CCAR wholesale schedules (Commercial Real Estate (CRE), Corporate Loan(CORP) and Supplemental).
 Reviewed the requirements with development, test teams. Closely worked with lines of business and SME‘s to obtain requirement sign-
off.
 Gathered requirements for Tactical data acquisition (TDA) for schedule data elements which cannot be automated. Authored and
executed sql scripts to obtain the TDA (tactical data acquisition) data elements and handed off to Operations team for upload to CCAR
credit card schedule.
 Supported the business and SME’s during UAT phase.
 Liaised with cross-functional teams (business groups, IT and PMO organizations) to drive data remediation efforts.

Environment: MS Office Suite, MS Visio, UML, Tableau, SQL, TSYS, FDR, APPRO, Unifi, Loanserv, SBO, AFS, CCAR Credit Cards, FL, HE,
AM, CRE, CORP, Supplemental Schedules

Fresenius Medical Care North America, MA

Senior Business Systems Analyst July 2010 – Apr 2016

FMC is the largest dialysis provider in the world, treating around 140,000 dialysis patients annually at more than 2000 treatment clinics in
USA. Worked on various cross functional projects to migrate Fresenius clinics from Fresenius legacy clinical (Proton) and financial systems
(Medical Manager) to Soarian clinics and Soarian financials. Involved in integrating RCG clinics acquired by Fresenius from AMI (clinical
system) and QMS (financial system) to Soarian Clinics and Soarian Financials. Analyzed requirements to incorporate data from new financial
and clinical system to the existing enterprise data warehouse (Knowledge center) without effecting downstream corporate reporting. Analyzed
the new Bundling regulation for ESRD (End stage renal disease) and assessed impact on existing systems and interfaces. Deployed a new
charge interface from Fresenius pharmacy to Soarian financials to incorporate pharmacy charges on the claim as required by the new CMS
regulation. Lead the ICD9-ICD10 conversion project for the integrations department. Analyzed the changes required to all existing interfaces
and presented to the business stakeholders to get approvals to provide services and process claims with the ICD10 codes to Medicare,
Medicaid and private insurances. Performed a thorough as-is and to-be analysis for all interfaces presented high level architecture. Worked
with 6 business analysts and 18 developers to complete the requirements documentation and development cycle of the ICD9-ICD10
conversion project.

Responsibilities:
 Support business leads, project managers and technical leads through design and implementation by identifying, analysing, redesigning
and documenting all phases of SDLC.
 Lead inter-departmental meetings to review and elaborate requirements and business process redesign.
 Lead the ICD9-ICD10 conversion project.
 Documented Functional requirement documents and conducted formal reviews to get business approval.
 Documented detailed ADT and DFT HL7 messages (P03, A08, A05, A04 etc) data mapping requirements.
 Documented detailed EDI 835 and 837 data mapping requirements.
 Conducted walkthroughs of the business and functional requirements with the development and testing teams.
 Envisioned a Test Strategy and documented the SIT test plan and test cases.
 Performed system integration testing (SIT) before migrating code to QA team.
 Extensively worked on writing SQL queries to test data in the financial oracle database.
 Contributed knowledge and supported the UAT teams throughout testing and obtained business signoff for deployment.
 Performed checkout activities to ensure successful deployment of projects.
Environment: MS Office Suite, MS Visio, UML, SQL, Soarian Financials, Soarian Clinicals, Proton, Medical Manager, AMI, QMS.

State Street Corporation, MA

Business/Data Analyst – Exp Mar 2008 – Jan 2010
Enhanced Custody Model - The goal of the project was to offer AIV’s (aka 130/30, 120/20 funds) a new securities lending service. State
Street would facilitate the AIV’s access to securities through Securities Finance, with Securities Finance acting as a Principal Lender.
Enhanced Custody Model has been developed to enable the tracking and monitoring of loan transactions, borrow transactions, and collateral,
and to address asset servicing needs. My role in the project was to design a database to retrieve entity and transaction information from
Global One (Books and Records for Securities Finance) and perform Basel I and Basel II Credit and Risk calculations.

Responsibilities:
 Conducted requirement gathering sessions with the Credit and Risk teams within securities finance to understand Basel I and Basel II
requirements.
 Gathered requirements from key stakeholders and documented business requirement and functional requirement documents.
 Documented detailed data mapping requirements from Global One GOSOS file to the new SFP database.
 Conducted walkthroughs of the requirements with the technology teams.
 Developed queries to perform the RBC (Risk Based Capital) and VaR (Value at Risk) calculations.
 Worked with the development team to ensure testing issues were resolved successfully.
 I was involved in User Acceptance testing (UAT). Assisted the business team by writing SQL queries to test the loan, borrow and
collateral transactions.
 Assisted to develop training materials and process guide to run manual credit and risk calculations
Environment: MS Office Suite, MS Visio, UML, SQL and PLSQL, Global One, DML

Cross Border Execution and Custody - The initiative offered US broker dealers a fully integrated straight through US dollar based trade
execution capability for foreign stocks. A US retail investor would be able to place an order for a foreign market security at any time in the US
trading day. The order is communicated to State Street via a FIX connection from the retail investors US broker-dealer and is received by
equities order management system (FIDESSA). A pricing algorithm employed (specified by State Street equity traders) determines the
appropriate security price if the foreign market is closed. Once priced an execution report (FIX message) is sent back to the US retail broker-
dealer confirming the trade and appending the security price in USD and the FX rate used to determine the USD equivalent.

Responsibilities:
 Gained an understanding of the envisioned business workflow and did feasibility analysis.
 Gathered requirements from key stakeholders and documented use cases.
 Conducted walkthroughs with the developers to review the requirements.
 Worked closely with the QA team to analyse the defects and identity the broken links.
 Involved actively in defining the user interface for the equity trade blotter.
 Participated in compliance review sessions to make sure the product is compliant.
 Worked on mapping FIX messages ( Message Type: ‘D’, ‘8’,’9’,’F’)
 After successful development and testing of the product, participated in UAT.
Environment: MS Office Suite, MS Visio, UML, SQL and PLSQL, Fidessa (Equity OMS), Apama (event processor).

Bank of America, MA Oct 2007 – Jan 2008

Sr. Business Analyst
Bank of America offers a wide range of services for its wealthy clients by its Unified Managed Account (UMA) program which is a
comprehensive solution tailored to their clients investment needs. The UMA Program is a fee based program which provides clients with
more customization through multiple, institutional-level separate account managers, exchange traded funds and mutual funds in one
convenient account utilizing an active overlay portfolio manager. The project involved adding new innovative models to manage portfolios in a
fluctuating market.

Responsibilities:
 Gained thorough understanding about the existing UMA Products - Portfolio Strategy Managed Models (PSM) and Fund Strategy
Managed Models (FSM).
 Reviewed the current business process and gained knowledge of the existing front office tools and billing application of the bank for
UMA products.
 Participated in User Acceptance Testing (UAT) of the CFAS (billing application) release.
 Participated in the Scoping sessions for new initiatives and documented Project Plan/ Project Charter.
 Envisioned the future process flow and used Visio to document the same.
 Gathered requirements and documented the Business Requirement Document (BRD).
 Envisioned a Test strategy and documented the Test plan.
 Assisted the Vice President in preparing project schedules and documenting the HR plan.
Environment: MS Office Suite, MS Visio, UML, SQL and PLSQL.

State Street Corporation, MA Sep 2006 – Oct 2007

Business/Data Analyst
State Street provides a wide range of services to institutional investors. State Street offers middle office and back office services to its clients
(eg: AXA, AAAM) through its enterprise application which is a STP (Straight Through Processing) system. The application receives trades via
SWIFT messages into its TOMS (Trade Order Management System). Trades are then passed to GTM (Global Transaction Management)
which references data from GRS (Global Reference System - security master data). Once the data is referenced the trade is confirmed and
settlement messages are sent to the custodian and MCH (Multi Currency Horizon – Fund Accounting system). Each client’s information is
stored in a separate instance of EDW (Enterprise Data Warehouse). The enterprise application had some limitations and could not process
OTC Derivatives.The project involved understanding the enterprise application and developing an extended enterprise module which would
be able to process OTC Derivative trades. The Extended Enterprise Application developed, supported OTC Derivative SWAPS and OTC
Equity Options. The project also involved designing a manual confirmation system for Term Deposits and Repurchase Agreements (Repos).

Responsibilities:
 Obtaining a detailed knowledge of the current business process.
 Reviewed the current business process thoroughly and envisioned the process flow for the future application.
 Conducted JAD Sessions periodically with various stakeholders to discuss open issues and resolve them.
 Analyzed business requirements and segregated them into Use Cases.
 Drafted the business requirement document (BRD) which detailed Use cases by specifying actors, normal flow, sub flow, alternative
flows for each and every use case.
 Designed Use case diagrams, Activity diagrams and Sequence diagrams to articulate the requirements in greater detail.
 Performed various data mapping exercises to map data flowing between several applications.
 Managed reference data for extended enterprise module
 Worked on mapping SWIFT messages (Cash and Security messages – 54X, 202 and 210)
 Involved actively in defining the system specification and the graphical user interface for the exception processing module.
 Implemented RUP and used Rational Tools to create and maintain the various artifacts.
 Assisted the Vice President and the Assistant Vice President in preparing the project schedules, milestone tracking, and resource
allocation using MS Project.
Environment: RUP, UML, Rational Rose, Rational Requisite pro, MS Office Suite, MS Visio, SQL and PLSQL.

Capital One, VA Mar 2005 – June 2006

Business Analyst
The system is a customer’s mortgage accounts management system. It provides various mortgage services such as Current Account
Balance, Payment History, Tax and Insurance Data, Make Payments Online, Apply for a Refinance or New Purchase Loan. The system also
analyzed the customer’s account and informs the customer regarding the savings if he/she refinances

Responsibilities:
 Gained experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of software
development
 Gathered requirements and prepared business requirement documents (BRD).
 Responsible for translating BRD into functional specifications and test plans
 Used Rational Tools to create and maintain the various artifacts such as visual modeling using UML through Rational Rose.
 Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
 Part of team to elicit, organize, and document required functionality and constraints
 Responsible to track, document, capture, manage and communicate the requirements using Rational Requisite Pro which helped in
controlling numerous artifacts produced by the teams who are working on same project.
 Implemented RUP iterative approach, which allowed increasing understanding of the problem through successive refinements, helped
us to incrementally grow an effective solution over multiple iterations.
 Experienced RUP’s development cycle with four consecutive phases - Inception, Elaboration, Construction, and Transition.
 Articulated UML through Use Cases, Use case document by specifying actors, normal flow, sub flow, alternative flows for each and
every use case
 Extensively designed use case diagrams, object diagram, class diagram, state diagram, activity diagram, sequence diagram,
component diagram and deployment diagram.
 Maintained Requirement Traceability Matrix (RTM).
 Reviewed quality with respect to the requirements based on reliability, functionality & performance with the help of QA testing team
 Facilitated Join Application Development (JAD) sessions with the IT groups to ensure timely project deliverables.
 After successful development and testing of the product, participated in UAT, product release and deployment to end-user.
Environment: RUP, UML, Rational Suite (RUP, UML with Rational Rose, Rational Requisite pro, Clear Quest, Rational Robot, Clear Case),
J2EE, HTML.

EDUCATION
 Masters of Science – Computer Science Sam Houston State University. Texas, USA.
 Bachelors of Science – Computer Science VNR Vignana Jyothi Institute to Technology and Science. Hyd, INDIA.