SUMMARY

• Having experience of 7 years as a Sr. Business Analysis in the field of Confidential and also been focussed into BA.
• Designed the functional requirement of end - to-end risk management solution for CCP OTC derivatives clearing from margin calculation, limit checking, and risk reporting.
• Designed the functional requirement for our margin service which provides initial margin replication for OTC/Listed derivatives clearing across global clearing houses.
• Monitored the global banking regulation on OTC derivatives clearing and design solution for clients to meet regulatory requirements.
• Worked with the SME in customization to business needs and end-to-end implementation of Algo Collateral system for collateral margining of OTC Derivatives per business requirements.
• Responsible for the successful transition and rollout CROME OTC platform for collateral margining of OTC Derivatives.
• Co-ordinated with Operations and business users to understand the product life cycle of various OTC derivatives, Exchange traded products, equities, FX, Prime Finance, Fixed Income and Money Market products which were part of this global AML project for North America, EMEA, APAC and South America regions.
• Implemented Activity Guides, Train stop visualizations, WorkCenters, Dashboard, Company Directory and Pivot Grids in ESS and MSS.
• Successfully implemented SAP IBP S&OP pilot solution to replace manual Sales Forecasting process and future readiness for Consensus Demand Planning and Sales & Operations Planning process.
• Specialized in the CRM Module, MSS Module, Managed Authentication module, Radius Server, Mobile platforms, Log Management systems (Firewall, IDS, IPS), Dashboard, Portal testing.
• Developed & presented various SAP reporting classes for the Procurement to enhance their experience in SAP & to get the information they are looking for.
• Collaborated with IT technical team designing functional specification documents from business requirements for SAP enhancements.
• Provided extensive support to the business users regarding business issues arising out of SAP FICO.
• Worked on CRD (Consolidated Requirement Document) in identifying requirements eventually updating, creating and deprecating requirements.
• Experience in working with RUP methodology, agile methodology and waterfall methodology.
• Created artifacts like Scope document, Project Charter, and CRD/BRD as a Business BA, and created artifacts like FRD, Use Cases, Use case diagrams
• Expertise in developing and presenting Software Test Plans, Test Case Design and Test Scripts based on User Requirements Specification (URS) and System Requirements documents.
• Having full SDLC experience: Planning, Analysis, Design, Development, System test, UAT, Implementation, Maintenance, Knowledge Transfer, Training.
• Developed Validation scripts, documentation and training to support the Plan to Produce portion of the J D Edwards go-live
• Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Flow Diagrams and Class Diagrams for better understanding of the functionality.
• Nominated as a key player for the Business Analyst Group of excellence. Brought in process efficiency by recommending industry standards and practices for documentation and implementing Agile work culture.
• Excellent skills in analysis, design, development and implementation of ETL and reporting components like Informatica, Teradata and SSIS.
• Conceptualized new collateral functions for the Bank, coordinated the execution, and created SOPs between 3 major lines of business and several other groups.
• Developed business oversight & regulatory performance control strategy across OTC derivatives.
• Played a lead role to provide analytics for calibration of inherent risk, residual risk and corresponding risk controls.
• Banking & Capital Markets experience with Front Office & Risk of leading international Prime Brokerage, Wealth Management, Investment Banking, Private Banking, Clearinghouses, SEFs, Exchanges & Buy-side firms
• Documented Financial Data Requirements with regards to Equity Trades, Fixed Income Securities and Equity Swaps to bring the data into Data Warehouse and Business Intelligence Applications.
• Examine and analyze exposed data for existing and new clientele to pinpoint their short and long term treasury product needs. Job requires strong knowledge of treasury and business banking products.
• Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and troubleshoot errors.
• Excellent understanding and work experience over different Equities, Equity derivatives and Fixed Income instruments: Bonds, Cds, Repos, CMOs, CLNs, MBS, ABS; OTC derivatives: Forwards, Futures, Options, Swaps investments.
• Experience with multiple asset classes including Equities, Fixed Income, Foreign Exchange, Bonds, Futures, Swaps and Derivatives, Insurance, Mutual Funds.
• Worked across several key subject matter areas such as Market Risk, Collateral Management for wholesale funding, Fixed Income Trading Platform, Accounting Engine, Card Services.
• Develop databases to capture and store data for Exchange Traded Funds, Mutual Funds, Comingled Products and Single Managed Accounts
• Created and Transform Business Requirements into Function requirement document (FRD).
• Conducted JAD sessions with clients and end users for effective requirement gathering.
• Responsible for presenting and receiving design sign-off for the requirements from the business users and stake holders.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Used UML methodologies to model business requirements in order to help create application design.

TECHNICAL SKILLS

Testing Tools: Quality Center, Mercury Test Director.

Service Management System: iTrack, QC (Quality Center), Adox, WebTrax, ReqPro.

Operating Systems: Mainframe, Windows, UNIX,.

Programming Languages: COBOL, C, C++, SQL, Focus, UNIX scripts (csh.ksh), TOAD.

Databases: Oracle, sql, pl/sql.

Querying Tools: SQL Management Studio … Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ, PL/SQL

Software: Microsoft Office, Microsoft Project.

Development Methodologies: Waterfall, Lean, Agile.

PROFESSIONAL EXPERIENCE

Sr. SAP Business Analyst

Confidential - Charlotte,NC

Responsibilities:

• Worked through the End to End technical implementation for SRM 7.0 with EHP2, ECC 6.0 with EHP6 and SAP BPC 10.0 along with the corresponding Business packages on the SAP portal to support procurement and finance to manage business processes.
• Performed multiple project management tasks in support of the Business Intelligence department to include creating critical system support documentation, managing resource schedules and documenting.
• Responsible for requirements gathering, specifications and documentation of regulatory initiatives for OTC derivatives.
• Designed and modified the detailed reports and dashboards relative to business intelligence based on business requirements.
• Developed the enterprise level dashboards for the Operations team using Business Intelligence tools like Dundas BI, Power BI.
• Worked with information systems and product development to continuously automate market data processes
• Managed data reconciliation efforts focused on collecting and comparing trade data from the Front Office systems and Counterparty Credit Risk systems for OTC derivatives.
• Supported areas of the OMD Business Services team by providing guidance and support to the Incentives and Distribution Advocates.
• Completed additional security tasks which may include troubleshoot SAP user's Security issues and Analysis of missing / required SAP authorizations.
• Involved in the successful conversion of client's data from OMD (Optimizing Managerial Decisions) application to Oracle Applications.
• Identified the types of data relevant to OTC derivatives and repos and types of technical and business controls and governance necessary to ensure accurate calculation and reporting of RWA.
• Having strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
• Created artifacts like Scope document, Project Charter, and CRD/BRD as a Business BA, and created artifacts like FRD, Use Cases, Use case diagrams, Wireframes, Prototypes.
• Used Requisite Pro to organize and catalog requirements.
• Worked closely with DISH’s vendors like CSG (ACP platform), TOA (work force management) and Amdocs (Enterprise Product Catalog).
• Involved in the deliverables which include technical documentation for all applicable CRM systems, product training, asset management, recovery, valuation, and reporting, product catalog architecture, and trouble ticketing concerns.
• Successfully led and managed Oracle Database upgrade for SAP systems and BW upgrade from 7.0 to 7.3. which involved close coordination with Basis and SAP.
• Worked with ABAP, BASIS and SAP to apply OSS notes for the issues identified during the upgrade.
• Successfully created a pilot solution on SAP IBP S&OP to replace manual sales forecasting process
• Worked with other CRD project team members to understand business/user needs across the entire project and so got the exposure to multiple business lines and departments
• Worked on a system that facilitates trades of basic Fixed Income Securities like government bonds, treasury bonds, corporate bonds, agency bonds, Asset-backed securities, and Money market securities.
• Advice and coach business partners of policies and procedures on treasury service products and services to mitigate risk.
• Developed SSIS ETL packages to meet data flow needs, automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Served as primary point of contact for the Compliance Department in regards to Mutual Fund transactions and sales practice concerns
• Managed closed deal gathering process for Banking & Capital Markets practice groups.
• Process and business analysis for on-boarding of OTC derivatives Middle Office clients, covering all lifecycle events of complex Interest Rate Derivatives.
• Led team to improve internal pre-trade cost estimation model leading to improved trading strategy selection and one bp reduction in realized return variability.
• Acted as a liaison between the business and IT to identify KBE, data analysis, data mapping, mining, lineage.
• Maintained European Market Infrastructure Regulation (EMIR) reporting and scripting procedures.
• Assisted the trading desk with processing expirations for listed options, futures, OTC products and Total Return Swaps.
• In depth knowledge of capital markets, investment risk and return, portfolio management and retail banking industry.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
• Reviewed bank policies and reports to assess potential risks in areas such as operations, internal/external audit, liquidity, and capital markets.
• Facilitated requirements gathering, regarding business processes, business rules, data elements, and reports, by building collaborative relationships with business SMEs.
• Provided coverage for all asset classes within the Credit Suisse Prime Brokerage offering. Experienced in trade life cycle for Fixed Income, FX, derivatives, and equities. Expertise around product leveraging processes (repo, margin, options, etc) and reporting structures.
• Excellent knowledge and deep understanding of industry standard methodologies like Scrum Agile Framework and Kanban software development system Software Development Life Cycle (SDLC).
• Conducted data mapping activities to map the securities (Fixed Income, Equity, Bonds, FEC's, etc) & its Derivatives (Options, Swaps, Futures, etc) between old and new system.
• Knowledge in broad range of financial practices and principles ranging from financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting to trend analysis, investment banking, asset allocation, portfolio management, risk analysis and derivatives.
• Worked in Data Quality team for regulatory report which was initiated as a Dodd Frank Act to promote transparency and accountability of financial institution and to protect consumers and submitted to Regulatory Agency.
• Screen negative media alerts pertaining to insider trading, stock manipulation and tax evasion.
• Created waterfall framework artifacts such as: BRD, FRD, use case and use case diagrams and UML diagrams.
• Worked with requirements analysts and subject matter experts to identify, understand, and document business needs for the data flow to create market risk and credit risk modules.
• Assisting business users in decision making for possible solutions by providing them guidance on current system behavior, feasibility and impacts from IT perspective.
• Conducting JAD sessions (Joint Application Development) with Business Users for gathering Business Requirements and converting those requirements into Change Request.
• Involved with following products: Stocks, hedge Funds, Fixed Income Securities, Bonds and Bond trading cycle, Equities, Derivatives (Options & Futures).

Business Analyst

Confidential -New York City,NY

Responsibilities:

• Studied OTC Derivatives Trade Lifecycle to analyze trading processes and post-trade processing challenges, and recommended system settings to materialize the STP Environment.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management Knowledge of STP and SWIFT messages.
• Created training materials for the UAT testers to effectively test the functionality.
• Implemented Rapid Deployment Solutions for various SAP Objects such as Maintenance Order, Accounting Doc.
• Involved in the configuration automated "basic user" provisioning and de-provisioning involving revocation ofaccess to make the user "basic user".
• Written Detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, reference data, data attributes and security master database.
• Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, SWIFT for treasury and asset management documentation.
• Facilitated JAD sessions to gather business requirements from stakeholders, SMEs, Servicing Agents for CIA application, business users and external users.
• Worked on integrating the OTC system with the new strategic exposure calculation engine to generate credit risk metrics.
• Diverse practical experience that straddles Retail Banking & Capital Market, Retail lending, Credit Ratings, Asset Management, Custodial Services, Regulatory and Compliance, Securities Lending, and Investment Management System.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Support Capital Markets Compliance team in daily trade monitoring responsibilities such as Private Label
• Working on data mapping for various products in Deposits, Securities, FX and Derivatives.
• Expertise in Capital Markets, strong knowledge and exposure to Equities, Fixed Income instruments, Exchange-Traded, Over-the-Counter (OTC) Derivatives and Alternative Investments
• Worked with the product coverage includes loans, repo, TBAs and OTC derivatives such as interest rate, credit, equity and foreign exchange products
• Co-managed the implementation of a new Commodity Trading and Risk Management system.
• Performed trouble-shooting relating to client- queries relating to valuation of Interest rate, FX, Equity, derivatives (primarily for OTC instruments).
• Model Risk Management Executive accountable for strategic direction and implementation of centralized model validation and governance platform.
• Experience building financial forecast and valuation models in buy-side front office (hedge fund, equity analysis), and in sell-side back office (financial service, business analysis, budgeting, project management).
• Designed and created SQL Databases tables, indexes, and views, User Defined Functions, Stored Procedures and Triggers based on user requirements.
• Having experience of financial risks such as Credit risk, Inflation risk, Counterparty risk, Market risk, Interest Rate risk, Volatility risk, Systematic risk, Unsystematic risk, Country risk, FX risk.
• Team lead for the development technology market risk initiative, which involved the redesign of the entire firm's risk infrastructure to speed up all operational processes.
• Worked with the derivatives Instrument Valuation, risk management and Life-Cycle: Interest rate Swaps, Swaptions, FI, equity derivatives, FX forwards/spot and option trade life-cycle and their underlying risk factors and their risk management.
• Reconcile trade details between both the Financial Consolidated Layer (FCL) and CRES (e.g. Interest Rate Swaps, Credit Defaults Swaps, Swaptions and Total Return Swaps).
• Good understanding of capital markets space specializing in areas including Trading, Fixed Income, Equities, Bonds, Derivatives (Swaps, Options, etc) and Mortgage with sound knowledge of broad range of financial instruments.
• Extensive experience in Requirements Gathering, Business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD) and RTM.
• Proficient in creating screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams, business process flows, and in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
• Followed the Waterfall / Agile methodology for the entire SDLC.
• Partnered and collaborated with internal Subject Matter Experts, Program Managers, Product Managers and other stake holders to ensure we capture all requirements and document then in order to proceed with development to implement a project and/or to deliver a product.
• Experience in developing Business Requirement Documents (BRDs), functional Design Documents, business models and flow charts.
• Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports.

Business Analyst

Confidential - Minneapolis, MN

Responsibilities:

• Created artifact such as Business Requirements Documents (BRD).
• Gained thorough product knowledge of Amdocs Rater, RLC (Rating Logic Configurator) and EPC (Enterprise Product Catalog).
• Involved in the draft requirements and policies and procedures for in preparation for Blueprinting with SAP MDG, PI, ECC.
• Worked as Business Analyst in Treasury Capital Market team, dealing with Interest rate Swaps, Swaptions, Commodities, Equities, Fixed income, Credit Default Swaps, Commodity Swaps, Foreign-Exchange (FX) Swaps, Straddles, Overnight Index Swaps, Market-to-Market Trades, Cross-Currency Swaps, Caps/Floors, Forward, Collars and Asset Swaps.
• Optimized SQL Server 2012 T-SQL Statements and stored procedures for performance tuning
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Supported front office rates desks with derivatives: swaps, swaptions, muni bonds, FPAs, FRAs, and non-USD FX derivatives.
• Develop and design test cases for pricing new fixed income products and profit-and-loss reporting analysis.
• Analysis, review and preparation of process systems and controls for OTC derivatives and cleared trades, securitization exposures and risk rating (PD) frameworks.
• Lead Risk Analyst for Business Risk Management reporting and data analysis for Account Management Analytics.
• Play the lead role in articulating the scope, business requirements and user-acceptance criteria of various mandatory and discretionary projects in Retirements, Mutual Funds and Insurance/Annuities
• Experience with Helios, T-Max, Inventory, EFT .
• Created standard reports through complex Store Procedures in MS SQL for various Markets. Import source files into MS SQL through Visual Studio SSIS packages and source files from Data warehouse through PL SQL.
• Directed three separate six-month efforts (BRDs, FSD, use cases) involving multiple engineering teams to improve data quality to monitor trading networks.
• Coordinated with Finance & Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) designed to enhance production efficiencies .
• Created business and technical requirements documentation ( FRD, TRD) used to create applications that support the functional, technical and visual requirements.
• Created Test Plans for each UAT project, utilizing business requirement approach documents.
• Conducted gap data analysis and mapping between current and future states in JIRA
• Proposed solutions based on client needs and in line with the parameters and structure of the SDLC organization and processes.
• Understood clearing firm's capital risk requirement, communicated with senior management on any clearing firm's procedural changes
• Exposure to all phases of Software Development Life Cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Review liquidity levels to ensure compliance with Basel Regulations; report various source systems into the liquidity risk infrastructure and credit risk framework.
• Managed a small real estate oriented hedge fund.
• Manage the Barclays Prime Brokerage OTC Clearing and Intermediation Middle Office of Credit Default Swaps(CDS) and Interest Rate Swaps(IRS).
• Conduct quantitative analysis of test score data to investigate systemic test score inflation.
• Used market data sources such as Collateral Analytics, Realquest and DataVerify to ensure sound and supported valuations.
• Managing trade reconciliation process as well as providing metrics around trade confirmation data for all OTC Derivatives products.

Business Analyst

Confidential -Tysoms Corner,VA

Responsibilities:

• Produced Business Requirements Documents (BRD) for approved projects.
• Gathered and Documented Functional requirements in the Functional Requirements Document (FRD).
• Knowledge of statistical market, counterparty credit and liquidity risk concepts and reporting methods across a variety of asset types.
• Created complex programs in T-SQL and wrote Stored Procedures, Triggers and Queries with best execution plan.
• Implemented Financial Risk Management project of Equity Swap, Vanilla Swap and OTC/Derivatives Products.
• Presented Scenario Analysis to senior management; suggested trades to control capital risk requirement.
• Demonstrated the qualities of a quick learner by understanding overall billing functionality of the products for all modules like CRM/OMS, Rating, Billing and Enterprise Product Catalog.
• Monitor and maintain Mutual Funds trade rules engine to ensure compliance.
• Development of Operational Key Risk Indicators that provided Retail Loss Committee with quantifiable risk appetite results. Implemented these into Risk Management Association Program.
• Conducted research in surety bonds' market, minorities involvement in assorted industries to forecast minority-owned small businesses' demand for surety bonds
• Test coordinator for new software release supporting and managing UAT, System, and Regression testing utilizing Excel macros and VBA functionality.
• Systematically and rapidly coached agile concepts across teams in a manner that encouraged team members to embrace new thought patterns and stretch to reach new levels of accomplishment.
• Proposed solutions based on client needs and in line with the parameters and structure of the SDLC organization and processes.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and load into Data Mart using Informatica Power Center.
• Involved in testing techniques such as GUI, Use Case, State Transition, Decision Table, Equivalence.
• Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
• Having excellent skills in writing Business Requirement Documents, Functional Requirement Documents, Systems Design Specification, Workflows and diagramming skills for drawing UML diagrams such as State diagrams and Class diagrams.
• Conducted JAD sessions with SME, users and other stakeholders for open and pending issues.
• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Quickly developed an understanding of Hedge Fund Accounting and Trade Operations related to NAV delivery.
• Provided economic support for swaps, acquisition & divestitures as a subject matter expert
• Support designers and programmers for electronic trading System( GLOBEX) match engine.
• Conduct analyses of capital market changes, trends, risk/reward ratios, and dynamics in various time frames.
• Involved in JAD sessions for evaluating Credit Risk, Risk Evaluation (market risk, liquidity risk, VaR), Ratings, and improving Financial Analytics process.
• Monitor changes to the Basel program-wide critical path.
• Process all corporate actions relating to equities held on trading books in a timely fashion
• Understanding of Portfolio analysis report and P&L reports by performing the risk analysis (Credit Risk, Market Risk, Reinvestment Risk and Inflation Risk) based on the client investment objective.
• Collected weekly client highlights and actions for Global Heads of Fixed Income Distribution.
• Built a claim report using SQL Server Reporting Studio to help coworkers identify member enrollment and claim adjustment issues.