SUMMARY

• 8+ years of extensive work experience as a Business Analyst in Banking and Finance domains.
• Strong analytical skill in analyzing Financial Risk such as Interest Rate Risk, Default Risk, Credit Risk, Inflation Risk, Operational Risk, Market Risk, Systematic Risk, and Volatility Risk associated with investing in securities. Detailed knowledge in Risk Management using metrics such as Greeks, VaR, Duration and Convexity.
• Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process.
• Hands on Experience in Global Liquidity Risk Infrastructure (LRI), PPNR, Zero Based Budget, Projection, Prime.
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Working knowledge of Case Management Applications (e.g Actimize) and Strong product knowledge on financial instruments and payment/Treasury products Understanding of AML, KYC process, and Trade Life Cycle Working knowledge of AML/Financial Data (e.g. Wires, checks, ACH, Accounts)
• Knowledge of valuation (Pricing) of Bonds and Common Stocks. Helped in the decision making of right investment through proper valuation by calculating Present Value (PV), Net Present Value (NPV) and Opportunity Cost.
• Strong ETL experience of using Informatica Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor
• Detailed knowledge of Equity market (Common and Preferred stocks), Fixed Income securities like MBS, TBA, CMO, Corporate Bonds, Municipal Bonds, Convertible Bonds, Junk Bonds, Treasury Bonds, Treasury Notes, and Treasury Bills. In depth knowledge of Trading Derivatives which includes Options, Contracts (Future and Forwards) and Swaps (Interest Rate Swaps, Currency Swaps, Total Return Swaps, Credit Default Swaps) in Capital Market.
• Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
• Conducted GAP analysis to capture functionalities of existing systems and analysis requirements of the proposed system or enhancement to bridge the GAP and design solution and followed various SDLC methodologies which include AGILE Scrum, AGILE Extreme Programming, Rational Unified Process (RUP), Iterative, and Incremental and Waterfall models to execute the proposed requirements

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Manhattan, NY

Responsibilities:

• Worked on documentation of project vision and scope, cost-benefit analysis, management of project budget and making project schedule with the Project Manager.
• Conducted and guided JAD and Brainstorming Sessions to gather Business Requirements from Market Risk Group, Risk Reporting Team and other SMEs.
• Assisted Analyst with questions relating to AML/Compliance.
• Developed good practices for risk modelling procedures related to CCAR/DFAST.
• Communicated with all stakeholders and SMEs in all phases of the project, make sure the process is on the right track.
• Assisted in the calibration and validation of Mantas AML scenarios and behavior detection logic.
• Led Business Analysis and Functional Specification areas to plan and execute various consent order projects, ensuring adherence to regulatory requirements (AML, KYC, Dodd-Frank, etc.)
• Provide Short and Long range and Forecasting projections, Work with leadership to develop zero based budgets.
• Participated in data modeling, data analysis and requirement documentation. Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR.
• Design architecture and data flow diagrams, write use cases, and perform data and gap analysis on global AML systems.
• Generate Actimize process flow diagrams for Transportation and Vendor Finance using MS Visio.
• Responsible for the development and maintenance of the SAS code and related processes for the CCAR schedule template data generation and reporting.
• Implement and train business units on new budget and forecasting tool
• Lead on the data sourcing effort for Retail Schedules pertaining to CCAR and the FRY 14Q reporting to FED.
• Extensive use of application TOAD to write SQL queries for data manipulations.
• Extracted data from the database using SAS/Access, SAS/SQL procedures and created SAS data sets for statistical analysis, validation and documentation.
• Responsible for supporting and leading aspects of the firm's Anti-Money Laundering (AML) program.
• Develop and manage project plans, schedules, risk, and projections.
• Participated in preparing for CCAR reporting schedules (ex. FRY 14A/Q/M & 9C) . Monthly and Quarterly budget forecasting and cost management.
• Oversee and manage the funds prime brokerage relationship and relationship with the funds outside accounting firm.
• Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
• Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process.
• Lead on the data sourcing effort for Counterparty Credit, Market and Operational Risk, Income Statement and Balance Sheet Schedules pertaining to CCAR and the FRY9C reporting to FED.
• Created suite of Excel models used monthly for analysis and verification of Basel II results in Production environment.
• Exhaustive data analysis/data investigation of end-to-end data flow to identify data gaps and data integrity issues with focus on raising alerts through AML Mantas Tool.
• From CCAR Dashboards by mapping MDRM keys validated each of the line items in FRY 14A Summary report.
• Responsible for supporting and leading aspects of the firm's Anti-Money Laundering AML program to identify, remediate and track issues, and develop controls to sustain improvements as they are implemented.
• Assist Financial Analyst team with projections, accruals and cash applications
• Assisted in implementing the Liquidity Module of OFSAA (Oracle Financial Services Analytical Applications) for LCR / Federal reporting.
• Analysis and design of CCAR (FRY 14A schedules of Income statement and balance sheet), FRY 9C (few schedules), report requirements in AXIOM.
• Organize and lead quarterly and annual business reviews and adherence to zero based budgeting requirements.
• Create and Maintain SAS and Excel Dashboards needed for data mining, analysis and report automation.
• Collaborated with Axiom developers to link data to Federal Reserve Schedule templates.
• Created and managed the project schedule, monitored the whole team to complete tasks in timely manner.
• Involved in design, analysis, testing and implementation of data warehousing.
• Performed Gap Analysis to understand the existing features and functionalities of the module, and determine new functions to be added into the latest version.
• Developed Zero Based Budget reporting to maximize efficiencies by analyzing overall process flows to optimize departmental performance.
• Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST)
• Have intimate knowledge of the line of business data to ensure Instruction changes have minimal impact to CCAR Schedule.
• Worked as part of the Global Banking & Markets KYC/AML Client Due Diligence team.
• Assisted in the design, development, and management of liquidity stress testing models for the Wholesale and Retail asset classes
• Analyzed the new regulatory requirements on market risk calculation, monitoring, reporting, and testing.
• Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements by using Power Designer.
• Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCARvarious reporting forms.
• Participated in preparation of schedules within several regulatory reports notably FRY9C, FFIEC, FRY 14Q/M, FRY 14A etc.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Accountable in leading Business Acceptance Testing (BAT) team and finance team in implementing of logic deployed to populate regulatory reporting schedules via Created Test Data according to Axiom Mapping Logic and Filtration Logics of the FFIEC 031, FFIEC 041, FRY 14M/Q as per the required Schedules.
• In-depth participation and contribution in extracting and condensing information from the Zero-Based Budget.
• Perform detailed reconciliations of member accounts to ensure accurate billing, payment, and enrollment details. Created reports using SAS /ODS and SAS/views from oracle database tables into different formats like HTML and RTF.
• Scope of Regulatory Reports: Comprehensive Capital Analysis and Review (CCAR), FR Y-14M / FR Y-14A / FR Y-14Q reports covering Enhanced Prudential Standards under Dodd-Frank/DFAST, BASEL III.
• Responsible for the successful development and deployment of CCAR model suite for PD, EAD and LGD models.
• Review, document and test access controls to ensure access rights granted based on Least Privilege principle Designated POC for Zero Based Budget Review efforts on SharePoint for Portfolio Management.
• Assisted the market data team to integrate data using ETL tools, and involved in implementing complex Business Objects reporting solutions
• Conducted various stress testing followed CCAR.
• Resolved issues and conflicts between different stakeholders, found out proper resolutions to make all stakeholders satisfied.
• Led audit team and interviewed Information Technology Directors and Managers to gain understanding of processes and identify risk areas, develop audit plan, gather and analyze data, evaluate controls, prepare audit findings and recommendations for senior management.

Business Analyst

Confidential, New York, NY

Responsibilities:

• Used Rally to keep track of user stories, Participated in User Story Grooming.
• Prepared the CCAR reporting schedules (FRY 14A/Q) on certain periodic basis.
• Gathered Business Requirements, defined the scope of the project, analyze and prioritized requirements, developed customized business strategies, and identified high potential business opportunities
• Automated the generation of Customer Due Diligence (CDD) and Enhance Due Diligence (EDD) reports in compliance with AML regulation.
• Assisted in performing liquidity risk & credit risk analysis on outstanding loans under different pressured scenarios.
• 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.
• Analysis and implementation of solutions and packages sent by Actimize.
• Held meetings with stakeholders for gathering business requirements for Appway and Mantas.
• Assist in credit structuring scenarios, including credit memo and financial Projections
• Participate in the development and execution of annual planning and quarterly forecasting.
• Created and coordinated annual operating budgets for two facilities using zero based budget methodology for a combined operating budget.
• Actively aided and contributed to the procurement of new projects, ranging from Actimize oriented solutions to Reporting solutions using Excel VBA Macros.
• Familiar with Mantas system, Lexis Nexis, using media screening, customer screening, Eclipse, ECADD, SAR Database, Customer Compliance System, and proprietary systems to perform searches.
• Work with region and country AML Compliance leads to support start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
• Analysis and design of CCAR (FRY 14Q and FRY 14M - all schedules), FRY 9C (few schedules), FFIEC102, etc. report requirements in AXIOM.
• Created Business Rule requirements using JRules for Income Statement and Balance Sheet using US GAAP/ IFRS and created mockup reports in Cognos for the IT team.
• Worked as primary coordinator for risk weighted assets reporting for relevant financial and regulatory work through presentation stream & primary subject matter expert for Basel III regulatory capital rules.
• Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
• Complete Gap Analysis and built Source to Target mappings and Data Lineage documents to deliver data from several source systems to AxiomSL Dynamic Data Warehouse and Integration Center (DDW/iC) for construction and execution of over 20 different CCAR (Comprehensive Capital Analysis & Review) Submissions and DFAST Stress Models.
• Conducted JAD sessions, met with client and end users to accelerate the design of IT solutions and depict the user's view of the business needs and to jointly develop a solution
• Created burn down chart of the whole project and each sprint while conducting daily scrum meetings with developers.
• Ensure data integrity and accuracy with other regulatory submissions (FRY 9C, FRY 14A, FRY 14M, GL system, etc.)
• Statistical analysis of data; creating permanent formatted SAS data sets for present and future analysis.
• Develop and run complex financial models to produce projections, simulate scenarios, and obtain comparative financial data.
• Knowledge of CCAR, Dodd Frank Annual Stress Testing (DFAST) Regulations, and effects on economic scenarios on bank's regulatory capital.
• Responsible for applying regulations based on Basel III, which further can be implemented into DFAST and CCAR, which help to project Liquidity Impact.
• Involved in making appropriate commitments through story selection, sizing and tasking.
• Involved in Scrum Sprint Planning Sessions, Backlog Grooming Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria
• Developed UML diagrams (use case diagrams, activity diagrams, sequence diagrams, and class diagrams) to validate entity reference data and verification of the customer records: legal name, address, business purpose legitimacy and analysis of transaction activity)
• Designed and implemented basic SQL queries for data warehouse, and did data profiling
• Created wireframes to help developers build the application in Visual Basic and held data modeling sessions by developing DFD.
• Ability to apply knowledge of regulatory/ compliance risk management and AML related requirements as they relate to money laundering and terrorist financing within IRT accounts.
• Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations
• Issued the Test Plan Document, Test Planning, Test Design and Test Execution and was involved in the Testing Process which verified and validated all the defined business requirements and associated functionalities.
• Managed a zero-based budget, providing supporting documentation for each purchase within a calendar year. Identified cost saving purchases, maintaining a high technical return.
• Compiled data in the FRY 14A summary templates for mid-year DFAST submissions and the FRY 14A CCAR submission.
• Lead the UAT effort and was single point of contact for all the User Testing issues and Change Management.
• Created the Requirement Traceability Matrix (RTM) to project the life cycle activities and work products to the project requirements.
• Coordinated System Integration Testing (SIT), and Regression testing for the project implementation.
• Effectively led the effort and implementation of the Business User Acceptance Testing.
• Worked closely with Change Management team and attended Change Advisory Board meetings.

Business Analyst

Confidential, Reston, VA

Responsibilities:

• Business Analyst with strong Banking domain experience.
• Intricately involved in all aspects of the IFRS, USGAAP and Local Regulatory Reporting projects
• Advised Financial Services institutions on infrastructure (technology/process/people) issues and opportunities for regulatory reporting both financial reporting (FFIEC031, FRY 11, FR 2314, etc.) and risk reporting.
• Collected data from various databases to automate the entire process of CTR and SAM, generated reports by using Mantas.
• Collaborated with the marketing team in identifying the needs of the bank's customers.
• Established a Business Analysis methodology around the RUP (Rational Unified Process)
• Facilitated numerous JAD (Joint Application Development) sessions utilized for the creation of design documents and system specifications for applications.
• Managed the submittal of necessary documents concerning real property management, operations, maintenance, and capital improvement projects.
• Responsible for all pre-and post-go live business requirements and proper documentation. Managed project list of IT department to prioritize deliverables. Set up and reviewed testing, training and documentation on all modifications and enhancement. Identifying entity types and then assigning attributes to those entities (Data Modeling)
• Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages. \
• Worked on a Risk Management System, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk (delta) information
• Responsible for data mapping of feeds from several reference data systems, including Bloomberg, to many in-house applications.
• Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions
• Assisted and executed associated project plans and test scripts for User Acceptance Testing (UAT) and subsequent user training.
• Developed strategic partnerships with various business units to develop a solid knowledge base of the business, including the business plan, products, processes and revenue streams.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.

Business Analyst

Confidential, NYC, NY

Responsibilities:

• Worked with and mentored the teams on Defect Prevention, Agile Scrum methodology, Design Principles and Code Refactoring.
• Got involved in the User Acceptance Testing (UAT) and SIT and documented the test scenarios and outcome.
• Adept at creating and transforming business requirements into functional requirements and designing business models employing UML diagrams using MS Visio.
• Current state assessment to determine business need analysis, fit /gap, reconfiguration and redesign of application settings, parameters and Lawson Process Flow.
• Successfully prioritized and initiated system upgrades and enhancements based off future workflows and Authored the Business Requirement Document (BRD), developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Worked in direct contact with payroll notifying them as to when deductions were to be made due to fraudulent use of sick time, as well as, recommending termination for repeat offenders of the attendance policy.
• Responsible for gathering new business requirements, on-going configuration updates and end-user testing.
• Managing UAT testing and test scripting, criteria, and execution through hands-on as an end user and directly with end users.
• Managed user acceptance and parallel testing using best practice policies and broad-based industry knowledge for the upgrade
• Created and documented Business Requirement Documents (BRDs), business rules & data mapping documents, workflows, wireframes, and mock-ups per project need.