PROFESSIONAL SUMMARY:

• 8+ Years of experience as Business Analyst in Finance, Investment and Banking Industry.
• Knowledge of Accounting Principles, Business process models, Acts (GAAP, SOX etc.), Capital Budgeting, Equities, Fixed Income, Derivatives (Options, Futures, Forwards, Swaps), Credit Risk, Market Risk, Commodities and Money Markets.
• Performed analysis and assessments on Capital Markets/Brokerage/Investment Banking Front, Middle and Back office applications, environments and third party service provider's products.
• Excellent knowledge in US GAAP/IFRS compliance and reporting, Statement Analysis, Trend Forecasting, SOX, FASB accounting standards, Auditing assurance standards, Anti - money laundering(AML) act, Bank secrecy act(BSA), FINRA regulations, OFCA regulations, SARS regulations etc.
• Working knowledge and understanding of operational workflows/processes for capital markets and investment banking.
• Experience with enhancement, support and process analysis related to various banking (Investment, retail, & brokerage) applications (bank accounts maintenance, security masters, claims, benchmark performance, collateral, pricing, ticket, etc.
• Working knowledge of all aspects of the mortgage origination process, including underwriting guidelines, mortgage loan documents, and consumer lending compliance.
• Developed/Implemented AML monitoring models in Actimize Application and provided on-going support of the AML Monitoring application.
• 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.
• Supported the risk assessments through the analysis of data elements related to potential indicators of customer, product, or geographic risk, evaluating and enhancing the AML group's risk rating methodologies, and identifying new quantitative factors that can be incorporated into the risk assessment process.
• Development and rollout of a first in class web-based system for the on-boarding and risk monitoring of third-party vendors/suppliers to comply with OCC regulations imposed on banks. 
• Extensive knowledge in banking/Financial standards for Customer Due Diligence (CDD), Customer information program (CIP), Anti-money Laundering (AML) compliance, Know your customer (KYC), Enhanced due diligence (EDD), Special customer type (SCT), Wealth management customer risks types etc.
• In-depth knowledge of software Development Life cycles (SDLC), having thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing.
• Strong knowledge with Basel III, CCAR, KYC rules and regulations. Expertise in Serving as Data Validation and serving as SOX application migration.
• Strong hands on experience in Data Warehousing concepts, Data Mining, DBA tasks like performance tuning and security created ER (Entity relationship Diagrams), Acted as business logic development layer.
• Experience in gathering business requirements, business processes, identifying risk, impact analysis, UML modeling, and Sequence and Activity diagrams.
• Good Skills in translating complex and abstract requirements to simple and easily understood solutions/User Stories.
• Practical Experience in managing projects using Waterfall and AGILE Methodologies.
• Scheduled and conducted meetings with the sponsors/stakeholders. My strength revolves around gathering, managing and documenting business requirements, communicating effectively with upper management, developers, QA team, and End users.
• Proficient in Domain analysis, Gap Analysis using gathered and existing data.
• Extensive experience in Project Management, Gathering Requirements, analyzing them, Data modeling, Business Process Flows, Implementation plans, writing Business Requirements Document (BRD), Requirement Traceability Matrix (RTM), Data Dictionary, Disaster Recovery, SWOT Analysis.
• Working knowledge in creating User Acceptance Tests (UAT), Test Plans, and Test Cases, to ensure Quality Assurance and to test all the business requirements.
• Highly experienced in managing a Project End-to-End, Relationship Management with Third Parties, Risk Management & financial Management.
• Developed Reporting Solutions, BI and Advanced Analytics (Data Visualization and Predictive Modeling)
• Team player with excellent interpersonal and communication skills, technically competent and goal oriented with problem solving skills. Excellent team management and leadership skills additionally, great presentation skills in regards to communication with both business and technical teams.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Responsibilities:

• Conducted meetings with stakeholders to identify problems, resolve issues and provide solutions as per their requirements and business practices for regulatory reporting.
• Gained end-to-end understanding of the technology and data infrastructures behind the daily production and reporting of all counterparty credit risk (CCRT).
• Identified data fields and tables using data dictionaries and SQL queries. Created data mapping documents in Excel to map target data fields and source data fields.
• Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations.
• Provided support to Product Owner in developing, maintaining and grooming product backlog. Used UML to create Use Case diagrams for requirements.
• Work with Regulatory Reporting, Axiom, QA, and data sourcing team in planning, executing, controlling and closing phases of projects and in CCAR reporting automation (FR-Y 9, FR-Y 14Q, and PPNR etc.)
• Develop BRD and data mapping logic to 14Q line items and Pre-provision Net Revenue (PPNR) configuration in Axiom, validating the data mapping using SQL developer
• Collaborate with users and Axiom team to confirm manual data input templates which could be configured by Axiom
• Identify and analyze business problems and defined the scope of activities required to address issues, including requirement definition, logics changes, process review, impact assessment and operational streamlining where necessary
• Analyze documents and identify source data from source systems at State Street for CCAR automation purpose
• Map business functions underlying data and data models, perform data reconciliations, gap analysis at function and data level for CCAR reporting
• Create data maps in the FR-Y 9C, 14Q and analyze in detail FR-Y 9C HC-K, 14Q PPNR Schedules to achieve automation process
• Work on data analysis, data mapping and requirement documentation of CCAR schedules and mapping data for FR Y-9C, 14Q, etc.
• Designed and managed the first DB Finance Comprehensive Capital Analysis and Review (CCAR) submission cross divisional Projection Platform user access implementation program for the Finance CCAR team resulting in access execution/maintenance for more than 200 users to the strategic Projections Platform supporting the development and delivery of the DB Capital Plan to the Federal Reserve Board (FRB).
• Develop detailed Axiom Automation Data flow documentation for senior management review to demonstrate the CCAR automation process from State Street Source Systems to Axiom
• Collaborate with Axiom developers to link data to Federal Reserve Schedule templates
• Perform detailed analysis of MDRM’s and design of CCAR FR-Y 9C, 14Q for PPNR Schedules to understand the FED reporting requirements
• Liaise with Axiom team to co-ordinate all aspects of testing, including planning, execution and close out of UAT phases with reporting team
• Successfully complete Axiom automation UAT and Production Testing for 9C, 14Q. Obtained sign offs by validating Axiom variance in Axiom outputs and legacy files to ensure all the business requirements have been satisfied by Axiom. Liaise schedules’ owners to ensure compliance with Fed instructions and report timing in Axiom
• Synthesized analyses, identified root causes, and developed key work products while performing OFAC screenings as well as stay up to date on various 314(a), 314(b) and BSA regulations.
• Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
• Documented various business rules, thresholds, parameters recommended by the quantitative analysis team.
• Performed data analysis on the current system and generated reports through SSRS and provided reports to senior management team on various business rules which were implemented in the system.
• Data analysis was performed on customers, products or services used, geographic locations involved in the transaction so that Risk Management team can take appropriate actions.
• Determined the client's risk score based upon key attributes such as nature of the business, country of incorporation/ operation, organizational structure and transactional history.
• Analyzed each Trading System and related feeds in INTELLIMATCH Recons which deals with Product and Services like Fixed Income, Derivatives, Options, Equities, Cash Securities, OTC Derivatives, Global Foreign Exchange, Loans, Global Money Markets, Options, and Asset Servicing etc.
• Developed Use Cases and used Rational Rose to draw Process Flow Diagram, Activity Diagram and Sequence Diagram that can help validate different business process.
• Created new alerts if a customer performs several transactions on the same day from different branches or transferring money in several transactions so that it doesn't meets the threshold value.
• A new alert was created if a customer changes his address frequently or provides invalid address then a notification is passed to the risk analyst team for the further review.
• Created the Requirement Traceability Matrix (RTM) in order to project the life cycle activities and work products to the project requirements.
• Conducted Smoke Test and User Acceptance Testing (UAT) to test the application.
• Attend weekly status review meeting with PMO team to report latest progress and issues found in the project.
• Worked closely with Change Management team and attended Change Advisory Board meetings.

Environment: Axiom ControllerView, SQL Developer, CCAR, FR-Y 9C, FR-Y 14Q, PPNR, FR-Y 11, FR-Y 9LP, FFIEC 031, FFIEC 041, FFIEC D09, MS Share Point, MS Project, HP QC, Agile.

Business Analyst

Responsibilities:

• Acted as a liaison between the developers and management, was instrumental in resolving conflicts between stakeholders and technical development teams
• Highly involved in creating Screen Mock-ups/Wireframes, Wireframe Templates for Investment Banking Applications.
• Conducted interviews with key business users to gather requirement and business process information.
• Understood FINERA, IIROC and NASD rules and regulation to comply when writing tests and functional requirements.
• 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.
• Interacted with the SMEs from AML Compliance group, fraud prevention and Cyber security groups and third party vendors to ensure system integrity and functionality of the automated monitoring system.
• Involved in the recommendation for the rules-based flags for any transaction or activity that violated a business rule and enhanced the reporting process of the AML investigations and SAR filings.
• Conducted requirement gathering sessions for the FARM initiative with Risk, Treasury, Finance and Enterprise Data Management groups.
• Conducted requirement gathering sessions to understand source data for consumer, commercial and small business credit cards and how they map to the CCAR credit card monthly (M) schedule.
• Performed source to target data mapping from multiple sources (APPRO - Loan Origination system, FDR and TSYS - loan servicing system) to CCAR credit card schedule. Includes CCAR mapping documents, metadata, reference tables etc.
• Reviewed the requirements with development, test teams. Closely worked with lines of business and SME's to obtain requirement sign-off.
• Gathered requirements for Tactical data acquisition (TDA) for schedule data elements which cannot be automated. Authored and executed Sql scripts to obtain the TDA (tactical data acquisition) data elements and handed off to Operations team for upload to CCAR credit card schedule.
• Supported the business and SME's during UAT phase.
• Liaised with cross-functional teams (business groups, IT and PMO organizations) to drive data remediation efforts.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, and Commodities & FX Currency).
• Figured out the potential changes to existing data status, and mapped data from sources to target database using MS Excel, creating risk weighted assets (RWA) models, and updating automated calculation engine required by BCBS 239 and U.S. Basel III regulations.
• Managed Scrum Master and BA roles including hosting all scrum meetings, getting requirement and feedback from stakeholders, system analysis, solution proposal, and assisting Development and QA team.
• Authored user stories, acceptance criteria, release notes.
• Prioritized user stories based on the requirements gathered from business, validated those user stories and translated those to development team.
• Established Incident Reporting and Change Control procedures using QC.
• Maintained business requirements, use cases, Functional Requirement Specifications document.

Environment: Agile Methodology, MS Office Suite, MS Visio, UML, SQL, TSYS, FDR, APPRO, CCAR Credit Cards, Java, Quality Center, SQL Server, DB2.

Charlotte, NC

Business Analyst

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB for Understanding of Trade Reporting requirements (e.g... NASD OATS)
• Participation in the OFAC Vendor Solutions and KYC Vendor Solutions.
• Provided AML Operations for client AML/KYC on-boarding and refresh across Global Banking Markets (GBAM).
• Oversee systems related to BSA, AML, KYC, CIP, OFAC, FinCEN and BSA Risk.
• Responsible for ensuring all BSA/AML related systems met compliance with Federal and State regulations.
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Performed User Acceptance Testing of the Phase I build of the Basel II system.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Created and periodically updated Re-Key AML profiles.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT).
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR's (Small Change Requests).
• Mitigated risk by performing Client On-Boarding and Maintenance and investigating transaction monitoring.
• Developed strategies with Quality Assurance group to implement Test Cases in Test Director for stress testing and UAT (User Acceptance Testing).
• Trained the future users to coordinate their activities vis-à-vis CORD system rather than ARW.
• Assisted the SA to document all custom and system modification after the SCR's were satisfactorily solved.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion.

Environment: Java, Oracle, PL/SQL, SQL Server, UNIX, PMAP, Rational Suite, XML, WinCVS, Windows, TOAD, Crystal Reports, Oracle, UML, MS Project, MS Office, MS Visio.

Minneapolis, MN

Business Analyst

Responsibilities:

• Created business use case, functional (FRS) and technical specifications for trading system.
• Litated interviewing and brainstorming sessions with the stakeholders and SME's in understanding the requirements pertaining to the trading application process.
• Worked extensively on Data warehousing, extensively used Data Stage an ETL tool to design mappings to move data from Source to Target database-using Stages.
• Involved in building staging area for the project and then moving data from staging into CDX Datamart
• Analysis of the mapping document and coding the business validations accordingly
• Used star schema data model with suitable dimensions and facts.
• Created Extract jobs from DB2 sources for different customers of Retail, wholesale and Small business
• Worked with the different stages like Source Dataset, Lookup, Aggregator, Joins, Filter, Funnel, and Remove duplicates, Sort stages.
• Configured reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Generated and implemented MicroStrategy reports by creating projects, attributes, hierarchies, metrics, filters, and templates
• Responsible for creating various project reports for stakeholder, development and QA teams on scheduled basis using MS SharePoint.
• Coordinated User Training and drafted User Handbook.
• Scheduled daily meeting with developers, system analysts and testers to discuss steps and address issues.
• Reviewed Test Plans and Test Cases and work with testing team to implement all the tests.
• Participated in Smoke Test after production.
• Prepared Business Requirement Document (BRD) and then converted Business requirements into Functional Requirements Specification.
• Supported daily compliance and risk reporting for overnight data inflows and outflows to/from accounting systems to Investment Repository Database.
• Conducted Gap Analysis on the shortcoming of existing system and Duration Analysis to evaluate the new STP (Straight-through Processing) functionality.
• Allocate outbound expedite cost by customer for Profit and Loss report and prepare month end accruals.
• Co-ordinate work packages with different team members onsite and offshore
• Involved in Review of the code sent from the offshore team
• Involved in development of the Transformation jobs which involved Joins of different tables
• Load jobs were created with the dataset created during Transformations and are loaded into the Oracle Tables
• Involved in meetings with Mapping Team and resolved the issues raised during the Development of jobs
• Extensive coding using staging variables, derivations and constraints to implement business logic
• Involved in Performance Tuning on the Source and Target at Data Stage Level and Data Loading
• Used Data stage Manager to Import the metadata / Schema definitions into various jobs.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Involved in Unit Testing, Functional Testing and Provide process run time
• Provided Micro Design document describing project milestones and other activities related to project
• Designed and conducted user acceptance testing (UAT) and resolved new scenarios brought by users.
• Created UML Diagrams including Use Case Diagram, Activity Diagram and User Interface Cases (UID) as needed using Rational Rose and MS Vision.

Environment: Unix/Linux, Windows, Core Java, Python, Perl, Oracle Database, MS Vision, Rational Rose, MS SharePoint, IBM DataStage, Oracle, SQL server, SQL, PL/SQL, Toad, Autosys, UNIX Shell Scripting, Aqua data studio, DB2.

New York, N

Jr. Business Analyst

Responsibilities:

• Worked with business requirements subject matter experts to identify and understand requirements and produce the report design specification.
• Responsible for Analysing Client Profile from Global Trading System (GTS) using Citrix.
• Gathered the requirements from End Users and prepared Low Level Designs and High Level Designs for designing the reports.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Designed and developed balance sheet, profit and loss statement and other reports to summarize current and projected company financial position.
• Worked with SME and Tech leads to gather the data regarding the Capital Markets and Asset Management.
• Prepared, analysed AS IS and TO BE of existing architecture and performed GAP Analysis, created workflow scenarios, designed new process flows and documented the Business Process and various Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
• Conducted JAD sessions and involved in all phases of software development life cycle in RUP framework.
• Led client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts in Trading shares, Equities and Fixed Incomes like Bonds, and converted them into functional requirements by implementing the RUP methodology, authored the same in Business Requirement Document (BRD).
• Created Business Process Diagrams (BPD) and Business Flow Diagrams using MS Visio.
• Prepared graphical depictions of Textual Use Cases, creating Use Case Diagrams, and Activity Diagrams.
• Performed Fixed Income Analysis (Pricing, Risk, Yield, Duration, and Recommended Strategy) in Excel to support trading, and reviewed with portfolio manager and traders.
• Assisted Risk Management Group in Financial analysis and Risk analysis on calculation of PV, FV, and other key trade metrics (e.g. Breakeven Rate) to test new Risk Analytic Tool.
• Performed Data Analysis and used SQL queries for Data Mining and Data Validation.
• Run SQL queries from multiple databases (data warehouse) for research, data integrity, and validation provide Adhoc reports to investment, accounting, and risk and compliance groups.
• Worked extensively on creating Application Objects like Metrics (level, conditional etc.), Compound Metrics, Filters, Custom Groups and Consolidations to generate reports for business analysis using the MicroStrategy Desktop and MicroStrategy Web Interfaces.
• Created various reports, Data sets and then used those for building Dash Boards and enabled flash mode as per user's request.
• Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
• Created drill maps for end users to drill up, down, with across hierarchies and recover data.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Analysis made with MSFT SSAS Tabular for revenue analysis and Category analysis.

Environment: Microsoft Office Suite, MS Visio, MS Project, MicroStrategy (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Capital Markets, Teradata, Oracle, UNIX, Windows .