USHA PATEL
781-***-**** https://www.linkedin.com/in/ushapatel1 ********@*****.*** Waltham, MA
SUMMARY
Assistant Vice President in Data Operations and Solution team with extensive Financial Services Industry experience. Provide end-to-end solutions bridging technology and business to enable the implementation of successful finance reengineering projects. Demonstrated expertise in P&L Revenue Accounting, BCBS 239 Regulatory Data Governance, BASEL Regulatory Reporting Framework, UK Balance Sheet and P&L Regulatory Reporting, Client and Market Data Management, Same Day Trading, Cash Management, and Reconciliation. Manage teams to foster strong performance and the accomplishment of aggressive goals. Focused on business growth, cutting costs by streamlining operations, and increasing revenue.
CORE COMPETENCIES
Project Management
Business Analysis
Systems Integration
Business Analysis
P&L Regulatory Reporting
Requirements Gathering
BI Reporting - Spotfire
Data Governance
BCBS 239 Data Governance
Business Process Optimization
Oracle PL / SQL Certification
Data Analysis
BASEL Regulatory Reporting
Data Governance
Microsoft Office 365
Data Lineage
Client Relationship Management
Agile/Waterfall
Data Analysis
Data Mapping/ Lineage
JIRA/RTC
Visio
PROFESSIONAL EXPERIENCE
STATE STREET CORPORATION, Boston, MA 2013 – May 2024
Assistant Vice President / Business Analyst (2021 – May 2024)
Revenue Accrual Workstation (RAW)
●Analyzed complex data models and revenue accrual calculations. Consolidated requirements and end-to-end design and testing for dashboard in TIBCO Spotfire for Revenue Accruals and Bill Trending reports
●Completed a deep dive into the entire manual business process model to get all revenue data and used SpotFire tool to do a proof of concept to provide system solution
●Implemented the Revenue Accrual Workstation using SDLC -Waterfall/Agile methodology
●Developed use cases, workflows, screen shots and powerpoint presentation for JAD sessions
●Validated the functionality and usability of the Revenue Accrual Workstation (RAW). Developed user test plans, coordinated test execution and resources, and managed issue tracking and resolution using Jira/RTC prior to production deployment
●Modified and updated SQL queries (views) for billed and unbilled data sets from different billing systems like Billing Express, Central Billing system (CBS), CBS Web, Oracle Revenue Master Billing system (ORMB) and published in TIBCO Data Virtualization. Used strong SQL database experience: querying, data drill down, and data analysis
●Created and implemented the Data Quality dashboard in compliance with BCBS 239 and catalogued data definition and data lineage in IGC (Information Governance Catalog)
●Documented requirements for Oracle Analytics Server (OAS) data storage to allow users to store large volumes of billed data in a consistent format and established a process to allow for history maintenance and access control for audit and governance
●Managed a team of 3 QAs for testing and validation of billed, unbilled and revenue data sets. Managed the UAT cycle along with issues triaging, analysis and resolution
UK Regulatory Reporting, Automated Reconciliation and Procurement Data Flows (2020 – 2021)
●Gathered and documented user requirements, data flow and mapping, SOPs for an axiom-based UK Regulatory Reporting, which included Balance sheet, Profit & Loss forms implementation
●Worked with product owners and developers across multiple teams, with Controllers, Global Accounting Office (GAO), and Business units, to develop standardized Business Requirement Documents
●Assisted in development of Counterparty management for Automated Balance sheet and Profit & Loss forms in Axiom by mapping and creating rules to follow the order of execution
●Worked on the closure of high visibility MRA from the Federal Reserve Board, partnering with Treasury and Technology teams to strategies operational improvements and close gaps in time, avoiding regulatory fines
●Identified and resolved discrepancies in Regulatory Report 2052a related to securities and legal entities by conducting in-depth data analysis between the Counterparty Management System and Security Data Mart
●Reviewed Third Party Risk Management processes for Co-Star, Tririga and FIT to deliver systems / data flows to identify an opportunity to build an “integrated data solution” for Third Party Management, to improve insights and analytics
Data Management / Governance and Data Lineage (2018 - 2020)
●Developed and executed comprehensive project plans for BCBS 239 compliance initiatives, considering architectural, strategic, and requirement aspects
●Consolidated and completed data lineage for RDR, RWS and CMS by evaluating data pipelines and transformations (23+ upstream data sources) in the ETL process and documenting the end-to-end data process in the data catalog
●Redesigned and enhanced the User Interface for the Risk Data Repository (RDR) to align with evolving business requirements, improving usability and supporting scalable risk data management
●Conducted BCBS 239 Gap analysis by surveying various business units. Identified and closed gaps by building operational processes and systemic enhancements, working with IT and business teams
●Liaised with regulators and internal auditors to ensure that BCBS 239 compliance activities were accurately reported through effective communication, project updates and governance councils
●Used strong experience working with complex datasets, understanding of data lineage, and documentation of business attributes captured in various databases, including advanced Excel skills
●Maintained and developed Data Quality Framework built on BI Tools: TIBCO Spotfire
Implementation of Interfaces to Oracle (2016 - 2018)
●Designed and developed functional documents for various interface projects in collaboration with product owners and developers
●Managed the implementation of various interfaces (Commercial Real Estate, Fixed Rate and Municipal Loans, Credit Enhancement and European Leveraged Loans) with multiple cross-functional teams, such as Finance, Business, Operations and Oracle IT
●Developed project documentation to include Project Scopes, Project Plans, Meeting Notes and Issue / Resolution Logs
●Worked on interface conversion from Oracle 11 version to Oracle R12 version. Collaborated across various business units to ensure interface files are compatible with Oracle R12
●Supported the development of new system connections, file format changes and regression testing, including QAT and UAT testing
●Worked as a technology-domain expert, collaborating closely with IT and Business units to implement data migration and process optimization solutions for ICAMS project
●Documented user requirements and implemented end to end Automated Daily Reconciliation process in data lake for Federal Regulation (Single Counterparty Credit Limit, SCCL)
Business Analyst (Contract) (2013 - 2016)
●Supported in the implementation of Moody’s RAY for BASEL FFIEC 101 reports automated submission in Axiom using agile methodology
●Worked with product owners and developers to develop standardized Business Requirement Documents
●Served as scrum master and reported project metrics to management- managed UAT test plans; triaged and resolved issues
●Prepared and analyzed of the quarterly regulatory reports required by FFIEC Regulators
(e.g. FR Y 14Q and FFIEC 101 etc.)
●Supported in analysis of variances for regulatory reports
●followed regulatory changes closely and worked with IT department to implement in Axiom for regulatory report submission
●Prepared and presented IMS Actual/Forecast Budget/Revenue/Expense to Controllers and GAO team
OTHER RELEVANT EXPERIENCE
WELLS FARGO ADVANTAGE FUNDS, Boston, MA 1998 – 2012
Project Coordinator (2008 – 2012)
●Expertise in project management using internal methodology, risk analysis, building business & test plan, monitoring and prioritizing issues resolution, training and updates to senior managers
●Assisted in complex projects such as corporate mergers and acquisitions, conversion of systems and various corporate initiatives by planning, documenting and coordinating activities to ensure successful completion of the projects in required time
●Performed Project Manager role for various projects such as purging of account histories, liquidation of funds, setting up transmission for external clients, established social codes, Omnibus conversion and proxy voting to shareholders
●Provided financial reporting on daily and monthly basis using large databases that hold more than 2 million active shareholders to the Wells Fargo Business Integration team, IT, Sales Reporting, Dealer Services, Institutional Services and Fund Administration, as well as external business partners
●Created SQL queries in MS Access database to generate ad-hoc reports of trading analysis for portfolio managers and senior management
●Recognized for development of the Inquiry Tracking database system on SharePoint that allowed users to initiate and track status of the requests and provided trending reports for management. This helped to save 20 hours of team working time on a monthly basis
●Built strong business relationship across all functions, geographies and levels of the organization by supporting day to day process, system maintenance, and system upgrades
EVERGREEN SERVICES COMPANY, Boston, MA
Institutional Service Analyst (1998 – 2008)
●Oversaw day to day operations within the department and ensured timely completion of all functions
●Built strong business relationship with high net-worth customers by servicing their needs and by keeping them appraised of market impact, Evergreen initiatives and products changes
●Managed a complex financial spreadsheet to provide client estimates, projected trading and real time trading activity numbers to the portfolio managers
●Coordinated significantly large trade orders with customers and portfolio managers to avoid negative financial impact to the fund
●Processed Money Market fund trades totaling in excess of $1B in net amount, prepared wires and created balance reports
●Closed funds for same day trading at their respective closing times and forwarded the information such as “super sheets” and money movement journals to Control and Custody for money settlement and rate calculation
●Provided ongoing training to teammates and new employees; this helped to reduce high turnover rate by 50%
EDUCATION
Bachelor of Accounting and Economics, Bombay University, Mumbai, India
AWARDS
State Street & Wells Fargo
●Outstanding Employee and Ace Award for Outstanding Performance
●Star Award for Outstanding Performance
●Six (6) Silver Spoke Award for Teamwork, People Advocacy, and Outstanding Performance
●Several Bravo Awards