PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Analyst

Responsibilities:

• BCBS 239 Center of Excellence (DQ CoE) initiative
• Responsible for the Business Rules and Controls work stream
• Designed VISIO work flow diagrams, use cases and templates
• Developed BRD and FSD(s)
• Data Quality testing and defect management in UAT

Sr. Business Analyst

Responsibilities:

• Data Quality & Governance focused on the cross functional audit
• Across business work streams primarily around the annual CCAR submission.
• Review SDLC Methodology evidence for Critical Action Plans (CAP)
• Assessed processes, systems, controls, validation of key controls that the businesshas done or needs to do in order to have sound processes in place.
• Interacted with both internal IA colleagues as well as the business.

Confidential

Sr. Business Analyst / PM - RWA Basel 3 IT Market Risk

Responsibilities:

• Worked with development teams throughout Moody’s system implementation
• Pro-actively communicated and collaborated with business to analyze functional requirements and deliver the appropriate artifacts as needed.
• Acted as the first line of contact to interface with Global Risk Management business users.to
• Critically evaluated information gathered from multiple sources, reconcile conflicts, decomposehigh-level information into details, abstract up from low-level information to create a clearunderstanding, and distinguish user requests from the underlying true needs.
• Conducted data analysis in support of applications and projects, including identifying anddocumenting business rules, data needs and data specifications
• Collaborated across application development and technology teams within IT to ensure thatbusiness requirements are fully understood.
• Participated in the development, testing and implementation of solutions in UAT
• Worked with the project manager, development manager, developers, business analysts, andquality assurance teams to ensure that the project is delivered on time and within budget.
• Participated and assisted with testing, configuration/release management, and deployment in UAT

Confidential

Sr. Business Analyst - Data Sourcing

Responsibilities:

• Documented and published in Power Designer the Current, Interim and Future state detailed end to end (ETE) data flows for Listed Derivatives products across various lines of businesses i.e. Equities, Rates, RMBS / Credit, GLMFX and Markets Prime Finance.
• Identified all EUDA's (end user developed applications) in Access and Excel spreadsheet format for remediation and to mitigate manual processes and Audit points.
• Assisted in the development of the solution pack, PID, BRD and FRD documents for the implementation of a new strategic accounting Sub ledger (ACS).
• Front to back mapping of Listed Derivative R&N source system balance, position and transaction attributes to a data collection template (DBP) required for upload to the Financial Data Warehouse.
• System Testing (ST), System Intergration Testing (SIT) and Defect management in UAT using JIRA and ALM.
• CCAR 14M attribute Data Sourcing / Data Cleansing and analysis for various domain values based on the Fianacial Data Standards for Loan products. Systems included DMI and Global Plus and Axiom.

Confidential

Sr. Business Analyst

Responsibilities:

• Partner with the business and IT stakeholders to gather, document, analyze and communicate BASEL 2 business requirements for OTC Derivatives and Secured Finance products.
• Automated the FRY 8 Fed report by reverse engineering manual processes, UAT testing and deployment into production.
• Data Dictionary Attribute testing for a new Global Basel 2 Calculator which included SIF testing using the Agile approach.
• Update of BRD and FSD requirements documents for Basel 2 RWA calculations.
• Construct test data test cases and ensured results match functional specifications.
• Work with development team to facilitate build effort (e.g. ensure build team understanding of the specifications).
• Test user interfaces and reports in UAT.
• Analyze and document process flows.

Confidential

Consultant - Business Analyst - Product Control

Responsibilities:

• Document purpose, scope, current process and user requirements for BRD - Non Comp Expense Reporting in Product Control (PC). Gather policies, procedures, process flows, data input files, system descriptions etc. Overlay and analyze data source inputs for all Non Comp Expense areas and streams. Document allocation rules for POC to automate current state. Work with developers to recreate PS query extract of allocation data for month end reporting.
• Create test cases in UAT through regression testing. Work with PM / PC to create functional specs and update management of project status.
• IMPACT 9.1.7 System upgrade - UAT testing of various fixes and enhancements. Created test cases with static data for regression testing of various defects prior to production release.
• CAPRI Subledger Conversion - QA testing of new measures based on existing scripts. Performed regression testing of new uploads to the database.
• Account Completeness Initiative - Bloomberg Trading Book Front to Back Office Source System mapping. Source Systems included: ICI IMPACT, BPS, JPMorcom, PeopleSoft, GLOSS, WINFITS, GMI, Applied account ownership at the Desk Head / Trader / Controller level. Data cleansing, data scrubbing. Interacted with BBG IT. Product Controllers and MIS Reporting to the business.
• Systems utilized: SQL, ICI IMPACT, BPS, BPSA, PostEdge, iSquare, ShowCase Suite 8.0, PeopleSoft, Aqua Data Studio 9.0, MDSL, Apeture, BIG, MS Access, Excel.

Confidential

Consultant - Product Control - Global Credit Trading

Responsibilities:

• Data Quality testing of P& L Reporting Tool that compares the sub system settlement feeds to the Front Office Reporting system to the SAP General Ledger.
• Products included: Bonds, Swaps, CDS, Futures, Options, Equities, Repurchase Agreements and Loans.
• Interacted with ABS / CDO / RMBS / Distressed / Structured Products Business Area Controllers for onboarding business to a new reconciliation platform in MS Access. Data cleansing, mapping and testing of data for the monthly P&L reporting close.
• Reconciliation of P&L, Carry, Transfer Pricing, Reserves, JV, Fees, topside journal entries and Balance Sheet.
• Front Office to Back Office cash reconciliations on Principal / Coupon / Fees “breaks” utilizing ADP / ICI Impact for High Yield / Hedge and the above-mentioned Trading Books.
• Systems utilized: ADP, SQL, ICI IMPACT, SAP, Summit, LS2, ERIS, Calico, Moar, Ransys, Computron, DB Trader, DB Rat, DB Equity, MS Access, and Excel. Core IFRS / US GAAP .

Confidential

Data Quality Lead Analyst

Responsibilities:

• As part of the Basel 2 Balance Sheet Data Quality Team, performed the following: Reconciliation of Basel II Capital Engine Balance Sheet data to Source System data from various data streams for Money Markets, OTC Derivatives, Commercial Loans and Security Financing products.
• Reconciled trade details per PeopleSoft (Accounting) data against INSIGHT (Risk System) data and CART (External Reporting) data.
• Reviewed failed trades against Business Rules for proper resolution by gathering supporting documents from external sources.
• Reviewed Book errors, data enrichment errors, counter-party errors, validation errors, account-mapping errors, and other mapping errors.
• Logged defects in Mercury Quality Center for defects noted in the reconciliation process.
• Regressions testing to determine defects were properly fixed by IT.
• Communicated with Data Quality team and Regional Entity Controllers to resolve various errors.
• Interfaced with PeopleSoft Reports to query database for trade and transaction details, manual and top-level adjustments.
• Sytems utilized: SQL, People Soft, Loan Net, Global 1, GIS, GMI, Trade IQ, Loan IQ, MS Access.

Confidential

Consultant - Regulatory Reporting

Responsibilities:

• Conducted business analysis across global product areas: Equities, Fixed Income, Money Markets, Trade Finance and Futures and Options to implement global Sarbanes Oxley Initiative. Performed (QAR) Quality Assurance Review analysis and define the business workflows for all Sub-systems / Sub ledger from deal capture to GL.
• Implemented and maintained monthly account substantiation process by utilizing Microsoft Excel spread sheets, pivot tables, Access data bases, Microsoft Visio and Power Point presentations.
• NYSE Regulatory Reporting ReconciliationTeam.
• Research and resolution of current and historical balance sheet discrepancies in compliance to SEC 15C3-1 Net Capital Rule.
• Analysis and comparison of firm inventory to General Ledger balances for haircut purposes on monthly Focus Reporting Tie Out.
• FR2004 Reporting - Schedules A.B.C.SI.WI. Re-implemented changes to Reporting system. Tested changes in UAT and refilled 6 months of reports to Federal Reserve examiners.
• Stock Record reconciliation - historic research and recovery of outstanding Stock Record differences due to new system conversion from ADP Cage 3 to Espear involving Operations Domestic / International settlements, P& S, Reorg, Stock Loan / Borrow.
• Systems utilized: SQL, ADP Cage 3, ICI IMPACT, ESPEAR, Loan Net, Global 1, DTC, MS Access and Excel.

Confidential

Consultant

Responsibilities:

• Daily comparison of cash and securities movements of the Bank of NY records with the Federal Reserve Bank from September .
• Adjust cash and position differences due to systems improprieties during this period.

Confidential

Consultant

Responsibilities:

• Stock Loan Reconciliation on Global 1 / Loan Net.
• Compared the loan net systems daily activity to various stock loan suspense accounts.
• Reconstructed and rebalanced cage and stock loan settlements.
• Recovered $2.3 million through this process and reduced bank exposure.

Confidential

Consultant

Responsibilities:

• Duties included recovery of Receive and Deliver cash and securities differences; Stock Loan and Borrow analysis.
• Recovered over $5,000,000 in Prime Broker suspense accounts.
• Assisted Managing Director on daily settlement discrepancies, due to ADP Cage III conversion.

Confidential

Consultant - DVP / RVP

Responsibilities:

• Daily reconciliation and processing of adjustments related to security and cash discrepancies between DTC and Confidential proprietary systems.
• Aged reconciliation of outstanding security exceptions in order to reduce firm exposure.
• This involved research of all reorg, daily trades, security lending and margin transactions.