Business Analyst Data Analysis

Lana Finkelstein *********@*****.*** Cell: 917-***-****

SUMMARY

•Advanced Business Analyst with a proven record of working in the financial services industry focused on regulatory reporting, reengineering, operational process analysis, processes optimization, process modeling, and data analysis and integration.

•Experience in the Front, Middle, and Back Office applications providing support for Global Payments Process mapping and Operational Transformations, KYC Operations, Collateral Substitution and Optimization, Margin Account maintenance, developing reporting tools and other Broker Dealer applications.

•Experience with compliance, regulatory reporting tools and regulatory domains such as, Reg T, Basel Accords rules, Reg. NMS, OATS reporting requirements, FINRA 7400 series, OFAC /LexisNexis products, KYC, Money Laundering, SAR and the PATRIOT Act requirements.

•Experience with transactional data, time series data, data analysis and sourcing, data modeling and integration, Equities, Fixed Income, SWAPS, Derivatives and other Capital Market products. Fundamental understanding of SDLC. Functions well in Agile and Waterfall environments.

•Collaborate with products, finance, compliance, operations, other SMEs and stakeholders across the US and worldwide to interpret regulatory rules, to understand business needs and requirements, current and future state processes, propose and document strategic and tactical solutions, prepare BRDs/FRDs, Epic/ User Stories, USE CASEs as required by the management.

•Produce, evaluate and document test plans, test cases and scenarios, conduct walkthroughs. Run UATs, usability and other tests at various levels to support product verification and validation. Assist QA to generate Test Plans, Test Cases and Scripts.

•Always apply strong analytical and technical expertise to produce robust and reliable software that delivers value to stakeholders and enterprises.

TECHNOLOGY

Industry Knowledge: Securities and Secured Financing, Fixed Income, Equities, Derivatives, SWAPS, Electronic Trading, Financial Markets, Payments Processing, Business Requirements, Data Integration, time series data such as Market and Ratings, Transactional and Reference data, Project Management.

Databases: Oracle, strong SQL/My SQL, ACCESS Db, DB2 for LUW, IMS, VSAM, ISAM, DB2 mainframe

O/S: Windows, z/OS, IBM 4341, IBM 3081, OS/MVS 341, DOS/VSE, Sun SPARCstation

Languages: strong SQL, COBOL2; exposure to Python, PERL, VB, VBA, Shell Scripts, Java, C++

Software: Sterling Trader Pro API, FILEAID, TIBCO MQ Series, FTP/SFTP

Tools: Microsoft Excel, Word, Visio, Tableau, JIRA, Confluence, Gliffy confluence, TSO/SPF, OS JCL, IBM UTILITIES, SPUFI

Other: FIX, SWIFT, ISO 20022, BLOOMBERG terminal, S&P Capital IQ, Knowledge sharing tools TWIKI, AutoSys, mainframe CA-7

CERTIFICATIONS: General Securities Representative Examination SERIES-7

PROFESSIONAL EXPERIENCE

BNY Mellon, Jersey City, NJ

Sr. Business Analyst (Consultant), New York, NY 10/2019 – 07/31/2024

•As a BA in Global Payments and Liquidity Division of USD Clearing Modernization program, supported payments process mapping, migration, transformation, conversion to ISO 20022, optimization and automation.

•Collaborated with the Operations team to understand, analyze and document current and future state processes, to perform gap analysis and design solutions.

•Gathered, consolidated and analyzed information from multiple sources. Designed, proposed and documented strategic and tactical solutions, frameworks and workflows for new reporting tools, payment process migration, automation, optimization, transformation and enhancements as per analysis. Developed, produced and executed UAT scenarios based on collected business/product knowledge.

•Ensured that the Operations team’s needs and priorities for the new business process are accurately documented into detailed business requirements and functional specifications documents.

•Collaborated with technology and UX teams to ensure the suitability of the proposed solutions.

•Obtained user stories sign offs, supported Dev, QA and Operations teams with SAT, UAT and Test Cases.

Bank of America, Jersey City, NJ

Sr Business Analyst (Consultant) 02/2019 – 09/2019

•BA in Wholesale Credit Risk Technology Division. Supported initiative to transform and integrate multiple loan legacy systems into Loan IQ - consolidated platform that will book, process, service and manage all components of Wholesale Credit Lifecycle for the enterprise.

•Analyzed, structured, mapped and transformed source data for storage in target Database for consumption by Loan IQ users.

Hedge Serv, New York, NY

Product Owner 07/2018 - 01/2019

•PO in the Front & Middle Office at Hedge Serv collaborated with the business community and end users to gather, sort out and accurately formulate business requirements and functional specifications.

•Applied knowledge of capital markets and various asset classes to provide analysis and support of trading activities for tradable market securities such as SWAPS, Options, Repos/Reverse Repos, Fixed Income/Bonds, Equities with data mining and data management software (Oracle/SQL).

•In the Middle Office worked on SWAPS Allocation, Confirmation and Client Onboarding functions.

•Produced meaningful, clearly formulated technical requirements documentation, test scenarios and test cases.

•Performed UAT and sanity testing of the product roll-out for the weekly releases.

•Provided post-production testing and support.

•Communicated with upper management and stakeholders on a regular basis.

JPMorgan Chase & Co., New York, NY

Business Analyst 02/2015 – 07/2018.

•As a BA in the Middle Office in the Liquidity Risk Infrastructure (LRI), worked in Operational Data Store (ODS) providing SME expertise in Equities, Fixed Income, SWAPS, Derivatives and other Capital Market products for the regulatory reporting, analytics, modeling and stress testing users.

•In collaboration with LOBs and impacted stakeholders such as Liquidity Risk Management, Audit, Compliance, product owners, data warehousing, technology, QA, UX, analytics and regulatory reporting teams proposed solutions, managed and produced clear business requirements and functional specifications for projects such as:

•data requirements for liquidity regulatory reporting (LCR, NSFR, FR2052a, 5G)

•Data gap analysis, sourcing, normalization, synthesization, transformation and integration

•Initial and Variation Margin maintenance requirements

•Collateral Selection, Management, Substitution, Optimization requirements

•Settlement process for bi-lateral and tri-party transactions

•Managed E2E implementation of LRI projects by providing data and business analysis, data modeling, documenting business requirements and functional specifications, communicating requirements to stakeholders and downstream applications, supporting SIT/UAT QA testing.

•Executed and participated in prioritization of the project plans, provided release and post-release support, collected sign offs from all stakeholders.

S&P Global previously known as McGraw-Hill Financial/S&P Capital IQ

Business Analyst (Data Modeling and Integration, Reference Data) 09/2012 – 02/2015

•BA in S&P Capital IQ. Functioned as liaison between business customers, internal data sources, external vendors, technology and QA teams.

•Facilitated implementation of the new SDL processes to transform and integrate Moody’s Credit Analytics Data into SDLdatabase .

•Provided business and functional requirements for S&P Credit Analytics Data integration process.

•Performed analysis and modeling of Credit Analytics Data delivered to SDL from internal sources (S&P) as well as external vendors such as Moody’s and Fitch. Interpreted Ratings Data from external vendors for the technology team.

•Analyzed business requirements to understand the business needs and developed use cases to demonstrate the business requirements.

•Analyzed and documented the impact of proposed solutions to downstream and upstream applications.

•Developed and executed project plans to facilitate timely implementation of the proposed solutions, to track project progress, to identify risks, to communicate risks, status and potential impact on the business to upper management and to downstream/upstream applications.

•Ensured that the developed functional documentation solution can be easily translated into test plans.

ECHO Trade -- New York, NY 09/2008 – 08/2012

Equity Trader Assistant/Business Analyst

•Created User Stories, defined Business Requirements of trading Algorithms, mapping those Business Requirements into Functional Specifications and programming code. Used VBA, Sterling ActiveX API to code real time order processing proprietary trading applications, used FIX protocol to exchange electronic messages with the exchange. Supported FIX based applications.

•Analyzed, coded, implemented, executed and supported OPG, MOC and others Proprietary Trading Algorithms against my professional trading account. Captured the daily trades for trade behavior analysis.

•Configured MS-EXCEL templates to obtain Real Time market data feed to run theoretical spread sheets, to perform data analysis, to model and test Proprietary Trading Algorithms. Collected and analyzed EOD data received daily through Real Time market data feed to build Historical Data for future data analysis and to perform all calculations necessary to prepare Database for the next business day using MS-EXCEL/VBA.

LEHMAN BROTHERS -- Jersey City, NJ 08/2001 – 04/2008

Business Analyst/Systems Analyst

•As a BA in the Enterprise Integrated Solutions Group functioned as liaison between business customers, vendors and LB technology teams defining Business Requirements of various systems, mapping those Business Requirements into Functional Specifications. Created Use Cases using MS-Visio.

•Collaborated with the PM to identify business issues and to prioritize assigned tasks.

•Collaborated with product owners, technology and UX teams to produce clear business requirements and functional specifications. Facilitated JAD sessions and walkthrough. Obtained sign offs.

•Worked on various functions for the Middle Office. and Back Office, such as trade booking to ensure that transactions are booked, trade allocation to ensure that each account or portfolio receives the correct amount of securities or cash, Client Onboarding, corporate and regulatory reports such as OATS, PNL calculations.

•Collaborated with business users to conduct walkthroughs, to provide expert product support and troubleshooting of products and services. Participated in gap analysis.

•Collaborated with QA to generate Test Plans, Test Cases and Scripts; provided BA support with SIT/UAT efforts.

•As a system analyst for CPI (Customer Profile Information) system, supported compliance and regulatory projects such as OFAC and LexisNexis products, KYC/CIP.

•Interfaced with the business users, analyzed, maintained, coded and implemented CPI’s internal and external User Interfaces and reconciliation processes (CPI to ADP, CPI to GAC, CPI to Sequent, CPI to Neuberger Berman). Interfaces are needed to transmit data to CPI’s external and internal partners.

•Performed data analysis to assist business users to evaluate data in the fraud detection process. Analyzed, coded, tested, implemented, and documented Lexis-Nexis project, which created external Credit Risk Feed to comply with Money Laundering and the Patriot Act requirements.

•Produced Technical Documentation—including online help, user guides/manuals, maintained log of project related incidents/issues and other documents. Used TWIKI to gather information to produce clear documentation. Used JIRA as bug and project tracking tool.

•Collaborated across multiple technology teams to coordinate, to set up infrastructure, and to facilitate CPI Disaster Recovery tests required by Legal and Compliance department.

MERRILL LYNCH – New York, NY 09/97 – 07/2001

Applications L1&L2 Production Support Analyst/Consultant

•For ML SWAT team provided analysis, L1/L2 technical and production support, daily coverage of the firm’s various systems, as well as broad support of mainframe and distributed applications. Actively monitored and analyzed error logs to provide troubleshooting of connectivity and other production issues, facilitated fast resolution of those issues.

•Kept and maintained a log of project production issues across the enterprise.

•Communicated across multiple applications and users/customers to prepare requirements for permanent production problem resolutions, making suggestions/ recommendations on enhancements of daily failed jobs and transactions.

LEHMAN BROTHERS – Jersey City, NJ 01/92 – 09/97

Consultant/Systems Analyst

•Worked on Lehman Institutional Client Support system. The system was designed to allow the enterprise to track customer accounts. The project was to convert the LINKS system due to separation of Lehman’s business associates.

•Analyzed, designed, coded, enhanced, tested, documented and implemented on-line transactions and batch processes.

EDUCATION

PURDUE UNIVERSITY B.S. Computer Science

Indianapolis, IN

New York UNIVERSITY Computer Science,

New York, NY

Various Java and Java technology related courses.

Contact this candidate