SUMMARY

• Business analyst with 8+ years of experience in Finance and banking services with a prime focus on, regulatory reporting and other financial services applications; leading in the development, documentation, and delivery of business goals and have Solid understanding of regulatory reporting, Market Risk Control, Basel II, Basel III and other regulatory reporting processes. have good 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.
• Experienced as a Business Analyst/Business process Analystin industry domains including Financial, Brokerage Accounts.
• Experience on CCAR, Basel II, Basel III, Dodd - Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Solid experience in CreditRiskand MarketRiskmanagementand computational methodologiesand Expertise in BASEL II & III credit and marketriskguidelines and various other regulatory policies.
• Experienced in writing complex SQL queries for extracting data from multiple tables and GatherCCAR, PPNR and supplementary metrics (FR Y-14, FR Y-9C) forecast from different businessunits.
• Solid understanding of the fundamentals of Greeks and how it is used in variousRiskManagement Methodologies and Experience in conducting Gap analysis, cost benefit analysis, and risk analysis.
• Knowledge of programming languages and techniques, including SQL, PLSQL and Linux OS
• Good working skills in writing PL/SQL, SQL, triggers, cursors in Oracle 9i/8i and MS SQL Server and optimizing the SQL to improve performance. Involved in UNIX Shell scripting for Informatica ETL Tool.
• Experience in data migration from legacy systems to Oracle Databases using tools like SQL, PL/SQL, SQL Loader and Unix Scripts.
• Hands on experience with UML modeling, Use Case Documents, Use Case Diagrams, class diagrams, interaction diagrams, activity diagrams, state chart diagrams and documentation of every method and attribute.
• Experience with troubleshooting principles, methodologies, and issue resolution techniques
• Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile Scrum and Rational Unified Process (RUP)
• Expertise in providing communication briefings to finance leadership and financial analysts regarding the implementation progress of the transition to an enterprise common system.
• Expertise in drafting technical documentation such as BRD, FRD, System Design Specification, Requirement Traceability Matrix, Test Cases.
• Experience working in a FACETS environment and extensive knowledge about various modules of a FACETS system such as claims and membership
• Experience in facilitating Joint Application Development (JAD) sessions, Rapid application development (RAD) sessions, conducting user interviews and acting as a liaison between the customers, development team and testing team
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Knowledge of trends in technology relating to software applications, Good understanding of the organization’s goals and objective
• Advanced background in waterfall and agile methodologies, with solid understanding of Software Development Life Cycle (SDLC) for applications development, gathering requirements from users and transforming them into system requirements.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server.
• Experience in working on Oracle Financial Services Analytical Applications (OFSAA) framework of Financial Services Data Foundation (FSDF) Data Model.
• Experience in Preparing and reviewing the IFRS annual report and related disclosures

PROFESSIONAL EXPERIENCE

Confidential - NYC, NY

Sr. Business Analyst

Responsibilities:

• Managing all phases of the Software Development Life Cycle (SDLC) including Analysis, Designing, Development, Testing, Deployment, Maintenance and Operational support while balancing resources, schedule, and budget.
• Collected the functional requirements from the business users and translate them into the Business Requirements Documents (BRD)
• Worked closely to prioritize and coordinate individual project tasks and assess time sensitive constraints on development tasks.
• Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk.
• Worked with requirementsanalystsand subject matter experts to identify, understand, and documentbusinessneeds for the data flow to create marketriskand creditriskmodules.
• Member of strategic team responsible for implementing Federal Reserve Board's Comprehensive Capital Analysis and Review (CCAR) supervisory stress testing program
• Interacted with project stakeholders andbusinessgroups to evaluatebusinessneeds and data issues forriskside, and worked with the technology team to implement pragmatic solutions in a timely manner.
• Analyze the new regulatory requirements of Basel Accord of all Pillar 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing (CCAR/ Confidential ).
• Worked on building queries to import data into Tableau Desktop from Oracle SQL Developer for developing downstream dashboards and KPI reports
• Field incoming problem tickets from end users to resolve application and software issues within Oracle E-Business Suite and other software applications used.
• Analyzed time consuming SQL and PL/SQL block queries and tuned them to run in less time by using cost based Optimizer hints, Explain plan.
• Created control files and used SQL* Loader to upload bulk of data and also data from any text file into database tables using SQL script.
• Worked on data modeling, data analysis and requirement documentation of product types and mapping data for FR Y-14A, FR Y-14Q, FR Y-9C, etc. by using AXIOM.
• Created suite of Excel models used monthly for analysis and verification of Basel II results in Production environment.
• Perform hands-on fixes at the desktop level to resolve issues as well as configuring systems and applications.
• Record, track, and document the problem-solving process, including all successful and unsuccessful decisions made, and actions taken, through to final resolution.
• Communicate application problems and issues to key stakeholders, including management, development teams, and end users
• Maintain and enhance performance of all new and existing software and applications across the organization.
• Participate in the design, development, and delivery of software applications training programs and individual classes
• Post software updates, drivers, knowledge bases, and frequently asked questions resources on company intranet to assist in problem resolution.
• Analyze the clients profiles and transaction activity to determine the proper and final decision of the customer's account in accordance with the bank's policies and KYC regulations, federal, state and/or local law requirements
• Used Erwin tool to generate schemas and provided SQL schemas to the development team to create tables in the databases.
• Responsible for managing Capital Markets transformation projects involving trading, accounting and risk management systems implementations, business process optimization initiatives, and industry standards for Fixed Income, Equities, FX and Derivatives lines of businesses.
• Worked on several reporting tools like crystal reports, SQL server reports, report writer etc.
• Performed SIT, UAT for OFSAA ETL operations and implemented credit derivative, Global FX for Finance, Risk and operations systems.
• Generatedad-hocSQLqueriesusing joins, database connections and transformation rules to fetch datafrom legacy Oracle andSQLServerdatabase systems
• Assisted in implementing the Liquidity Module ofOFSAA (Oracle Financial Services Analytical Applications) for LCR / Federal reporting.
• Worked on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.

Confidential - McLean, VA

Business Analyst

Responsibilities:

• Collected the functional requirements from the business users and translate them into the Business Requirements Documents.
• Traded the Forex to test the trading strategies, analyzed the return and practicability of trading strategies
• Participated in preparing forCCARreporting schedules (ex. FRY 14A/Q/M & 9C). Monthly and Quarterly budget forecasting and cost management.
• Worked with FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
• Maintained and updated clients on FOREX daily, weekly and monthly experts' commentaries
• Planned, scoped, developed, and led internal audit for risk management, PPNR andCCAR.
• Provided credit fixed income support to corporate clients and to the Global Syndicated Finance, Loan Trading, and Debt Capital Markets desks.
• Analyzed the new regulatory requirements of Basel Accord of Pillar 1, 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Experienced in the Financial Industry with exposure to Retail Banking, Investment Banking, Capital Markets, Retail Market and Digital Media Market.
• Created new database in SQL Server Management Studio and imported the historical dataand Imported data into R, cleaned and visualized the data and Wrote R script to simulate several trading strategies like pairs trading strategy (XAU/USD and XAG/USD),candle chart strategy (USD/CAD).
• Used SQL* Loader and Oracle Bulk techniques to load data from flat file to Oracle database tables and Created SQL Loader scripts and scheduled cron jobs to transfer data.
• Prepared the SQL Scripts, Packages, Stored Procedures, Functions and Views to implement the Business logic
• Collaborate with stakeholders to discuss the feasibility, profitability, and risk of the project and Assist to develop project plan using Agile Methodology
• Gather detailedbusinessrequirements and deliver detailedbusinessfunctional requirements specifications.
• Create UML diagrams such as Sequence Diagrams, Activity Diagrams and User Stories when needed.
• Support listed/OTC derivatives and Hedges trade capture or trade ordering requirements for system.
• Work experience in Risk Control, Confidential, CCARand other regulatory reporting process
• Interacted with different businesses in RBC to identify the source of the data in order to satisfy the requirements of PPNR schedules for FRY14Q and FRY14A.
• Utilized knowledge of Equity Capital Markets and developed an understanding of clients' needs in order to identifybusinessopportunities.
• Determined alternative approaches to Basel I regulatory capital calculations allowing significant capital savings.
• Created logical data model from the conceptual model and its conversion into the physical database design using Erwin.
• Wrote severalTeradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Performed data validation and integration with different applications and the work flows from the old to the new data base using complex SQL Queries and data base schemas
• Analyze the requirements and design the optimal solution using OBIEE
• Understanding business requirement and accordingly mapping data elements from various source systems to the appropriate table and column in OFSAAFSDFdata model for referential as well as transactional data for FR Y9-C, FR Y14-Q FR Y14-A, FFIEC, PPNR, FR 2052a reports.
• Involved in end to end data analysis to define and maintain various statistical approaches and provide input to OFSAA application to calculate LCR Ratio.
• Developed Market Risk and Credit Risk functional specification for Value at Risk VaR and Regulatory Capital functional specification for the calculation of the Risk Weighted Assets RWA exposures

Confidential - NYC,NY

Business Analyst

Responsibilities:

• Performed Data Analysis and Data Validation by writing complex SQL Queries
• Involved in customizing OBIEE (Analytics) repository and Reports testing and data validations and Offshore team coordination
• Analyzed and createdBusinessRequirements and Functional Requirements for 14Q/A Actuals for various schedules.
• Planned, Defined and Designed data based onbusinessrequirement and provided documentation forCCAR.
• Support RWA calculations according to Prudential Regulation Authority (PRA) and Swiss Financial Market Supervisory Authority (FINMA) Basel III requirements
• Hub and Legal entity level reporting of counterparty credit risk per Confidential Statues.
• Played a title role for retail banking project for Key corp to have a custom tier plan of graded interest, consultingproject from one end to the other using oracle 10g database and generating results as a part of the project.
• Provided Bloomberg clientele with customer support which entailed in visiting and providing the client with the latest products and service.
• Participate in the discussions and technology initiatives in the Equity derivatives platform as a result of Confidential Act and Stress Test ( Confidential ) such as Central repository, Volcker rule and Comprehensive Capital Analysis Review (CCAR)
• Provide guidance to enhance the Capital Adequacy Process (CAP) and Stress Testing (CCAR) framework
• Coordinate the audit scheduling process and take the lead to ensure associate resources are effectively utilized and forCCARreporting.
• Work closely with external auditors to provide information and resolve audit issues forCCAR.
• Conducted performance audits to determine the efficiency, effectiveness, and impact of government programs and regulations and prepared visio articles forCCAR, risk management associated with that.
• Assisted in creating an access database, which maps the 14Q/A MDRMs to the FRY9C MDRMS using GL and SL account information
• Establish and maintain strong working relationships across various CitiBusinessunits (i.e., Legal, Compliance, Finance, Operations, Internal Audit, etc.).
• Maintained knowledge of applicable rules, regulations, policies, laws, and guidelines that impact the finance and contract management process.
• Acted as liaison between management and development team for Requirements and QA testing during the User Acceptance Testing (UAT) phase and involved in user interfaces, requirements and data modeling sessions.
• Experience in writing and analyzingBusinessRequirements Document (BRD), Functional Requirements Document (FRD), Request for Proposals (RFP), Return of Investment (ROI), and Statement of Work (SOW)
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Worked closely with Subject Matter Experts (SME) of all applications for different types ofrisk control violation, including conference call and raising Jira ticket for change request release.
• Worked on detailed FRD, and Solution Options Document per BRD and regulatory requirements
• Analyzing Business Requirements/Functional Documents and preparing Technical documents

Confidential - Santa Clara, CA

Business Analyst

Responsibilities:

• Worked extensively through agile development methodology by dividing the application into iterations
• Creating and maintaining the database using SQL and Excel
• Conduct Brainstorming and JAD Session to gatherBusinessRequirements with Regularity and Compliance subject matter experts to have a good knowledge ofCCARreporting.
• ManagedBusinessProcess Redesign using Six Sigma (DMAIC) methodology for the Counterparty Credit Risk Management in the areas of Counterparty Eligibility Assessment, Risk Surveillance, Risk Mitigation and Corporate Governance and Audit Compliance for single family, multi-family and capital markets services.
• Contributed to formulation of Data Aggregation process underlying the completion of the extensive CCARdata templates, Focus on FR Y 14A and corresponding Capital Plan; Focus was on sourcing, integrating and consolidating financial and modeling data from various databases; Proposed process innovation and automation strategies.
• Integrated financial data and transaction data from source to target database for creating a central Risk Data Repository as required byCCARreporting regulations
• Conduct Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
• Managed the software upgrade implementation for FATCA (Foreign Account Tax Compliance Act) Phase II
• Worked with thebusinessusers and with different levels of management to identify requirements, use cases and to develop functional specifications using the Agile-scrum methodology for software development.
• As part ofCCAR, worked on a Stress Testing solution for a client to check the health of the portfolio of investments for the client to ascertain Capital adequacy.
• As a part ofCCARmarket shock exercise prepared application mapping for FRY 14Q report.
• Design detailed FRD, and Solution Options Document according to BRD and Basel regulatory requirements using Power Designer.
• Model the detailed design of the system using UML diagrams including Sequence Diagrams, Activity Diagrams and Use Case, and Data Flow diagrams using Smart Draw.
• Identify and assess potential data source of Interest Rate, help the market data team to integrate data using ETL tools.
• Identified and communicated dependencies and potential risks to the completion of the sprints including resources, costs & systems,CCARand treasury management.
• Work with Quantitative Analysts to design and administrate new Stressed VaR model and Advanced Monte Carlo Simulation method
• Work with Risk Reporting team to generate new Standard Pillar 3 Reporting framework, distinguish firm-wide global standards within QRM and the unique requirements for US site.
• Involved in design and implementation of Progression and Regression Tests of the new functionalities added in QRM system.
• Manage bugs using Defect Tracking Tool like JIRA, review each defect and assign development team to resolve problems.
• Participated in GAP analysis around the identification of business rules and system process flows, user Administration, requirements, and assumptions
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference