SUMMARY

• Over 7+ years of Banking and Finance Domain experience as a Business Analyst with solid understanding of Business Requirements Gathering, Experience in elicitation of high level and low level requirements.
• Excellent working knowledge of System Development Life Cycle (SDLC) such as Water Fall and Agile.
• Experienced in writing and reviewing Business Requirements Document (BRD), Functional SpecDocument (FSD).
• Participated in the preparation of Design Doc, Process Flow Diagram.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios for enhancement projects.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule - based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Experienced in the business areasAML/KYC, Dodd Frank Compliance, and Operation Risk Management in the large Investment Banks and Finance Companies.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Facilitated JAD sessions, conducted Gap Analysis, and prioritized requirements using interviews, document analysis.
• Interviewing Subject Matter Experts (SME), asking detailed questions and meticulously recording the requirements in a format that can be reviewed and understood by business and technical stakeholders.
• Used BluePrint as our Repository to maintain Evergreen Functional Documents.
• Used RTM to trace requirements to BRD, FRD, Test Plan, Test Cases.
• Experienced in writing Meeting Minutes and conducting Weekly Status Report calls.
• Proficient in MS Excel Vlookup,Pivot Tables, and MS word.
• Creative, fast learner, highly motivated team player, and capable to work independently.

TECHNICAL SKILLS

Business Methodology: Agile, Waterfall

Business Modeling Tools: Microsoft Visio, UML

Tools: Quality Center/ALM, QTP/UFT, JIRA, Bugzilla, SharePoint, LiveLink, FileNet, BluePrint, Net Java, XML.

Database: MS Access, SQL-Server, Teradata, Oracle

Languages: SQL

Applications: Standalone, Client Server, Web Based

Platforms: Window, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Responsibilities:

• Established a Business Analysis methodology around the Rational Unified Process.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Controlled and maintained monthly reporting hierarchy change for all Asset Management businesses
• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Applied knowledge of Portfolio Management, Risk Management, Equity, Fixed Income Securities (Treasury Securities, Corporate Bond, Municipal Bond, MBS, etc)
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Responsible for selecting vendors and integration of check clearance solution with applications from different vendors like Integration with Core Banking system and scanning solutions.
• Reviewed Use Case, User Interfaces(UI), ISD, Business Rule Catalog(BRC) for elaborating the data elements.
• Worked as business analyst to support the re-design of the Mortgage Asset Management System.
• Gathered and Documented Business requirements for the Risk/Return Analysis, and Portfolio Optimization and Diversification.
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Performed User Acceptance Testing (UAT) to test the functionality of the application.
• Have experience in interacting directly with key business users and geographically dispersed stakeholders.
• Experience with full Systems Development Life Cycle (SDLC) - Waterfall and Agile Methodologies.
• Facilitated the weekly meetings with the Developers and PM’s to continuously improve the CDW Archive process.
• Involved in creating the DEM (Data Element Mapping) to specify the Data mapping from various data base sources to the target database.
• Used ALM for defect tracking.
• Applied agile methodologies to elicit requirements for user stories.
• Used BluePrint to create different artifacts like: FSD, BRD and create traces between related documents.

Environment: MS Outlook, MS Word, MS Excel, MS Visio,SQL, ALM, Jira,Teradata, Oracle,SharePoint 2013, FileNet, LiveLink, BluePrint, Agile.

Confidential, Jersey City, NJ

Business System Analyst

Responsibilities:

• Involved in full software development life cycle (SDLC) starting from initial requirement gathering to design, testing, documentation and implementation.
• Prepared Business Requirement Document (BRD), Functional Spec Document (FSD), Data Flow Diagrams (DFD).
• Performed GAP Analysis between “AS IS” and “TO BE” workflow models.
• Worked closely with Investments Data & Client Reporting team in gathering high-standard business requirements, preparing functional specifications, use-case models, test plans and supporting UAT process on scheduled application releases and/or enhancements particularly for Fixed Income and Derivatives products
• Resolved economic discrepancies of Interest rate products such as Swaps, Options, Fixed Income Prime Brokerage and Municipal and Corporate Bond trades.
• Cut number of errors and amplified efficiency 84% through development and implementation of automated solutions for Fixed Income Prime Brokerage business.
• Organized and executed daily Balance sheet review, reconciliation, substantiation, brokerage reporting for Credit derivatives products.
• Created score cards monthly Directly interacted & partnered closely with end users to iteratively collect, document and implement systems requirements to deliver business value critical to the Client Reporting
• Designed the workflow defining the data files reciept process, FTP load process, data extract process, file archiving process, data load process in staging area, data screening & validation process, and business rules application process
• Designed automated Data Challenge process to communicate the data vendor of any data issues
• Built new Fund Data Mart for data storage & access - designed new table structures, defined relationships, data dependencies, data types, and entities constraints
• Worked on requirements gathering for MDM tool implementation and user workflow processes.
• Worked over OBIEE business intelligence tool to setup the customized user reports against the reporting requirements
• Assisted in design, testing, and support of Client Reporting applications
• Created Master Test Plan, Test Cases, Test Scenarios; conducted Functional Testing, System Integration Testing, Data Testing, Regression Testing, Smoke Testing; assisted QA Automation team in creating Test Scripts for conducting Performance Testing, Load Testing, and Stress Testing
• SQL - constructed complex SQL queries, created Database design & models, developed report designs (Crystal Reports) with heavy documentation, status reports, and deployed & managed database scripts from QA to production
• Actively participated in the analysis of requirements, design, test, deployment, and support of technology solutions
• Defined data required for internal reporting & analysis - ensuring data consistency across the vendors, correct program logic definitions, removing data redundancy, normalizing data values, historical data records, and building data dictionaries
• Interviewed SME’s, facilitated JAD sessions and interacted with Business sponsors.
• Worked in mainframe environment and used SQL to query various reporting databases.

Environment: Agile,MS Visio, MS Project, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Access, Oracle, SharePoint 2010, ALM, Jira, Mainframe.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Worked as a BA to assist in upgrading the system that processes the credit card applications
• Managed the IT Software development of the Treasury & Capital Markets systems, supporting Foreign Currency, Derivatives transactions, fixed income, and payment systems with interfaces to Swift, Chips, and Chaps.
• Captured pricing data using Bloomberg and Reuters terminals; to implement and maintain a strategic repository of global pricing for both internal and vendor sources; along with SWIFT Messaging functionalities
• Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
• Created complete set of detailed system flow diagrams, used to guide developers in implementation of Lombardi Teamworks Business Process Management (BPM) software
• Validate all operating model considerations and process documentation (in conjunction with process management group).
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Deep involvement with Portfolio Management accounting system (PMS) & Distribution of web interfaces (DOW) for reconciliation process and Basel II compliance.
• Worked with SWIFT to reduce the cost and to apply reusability and standardization.
• Worked with all front office systems in ensuring the smooth implementation of trade processing using SWIFT messaging and other protocols for settlements.
• Provided key inputs in defining the projects and system requirements
• Suggested measures and recommendations to improve the current application performance.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Also worked as a Data Analyst in Transforming and Modeling the data in online banking, also worked with SWIFT and Quick Test Pro.
• Executed UNIX shell scripts to run the bill payment data transfer process which sends the bill payment data to Bills Processing Application on a daily basis.
• Created test plan and test cases for user acceptance testing. Used Rational testing tools.
• Designed and developed Use case, Activity diagrams, Sequence Diagrams using UML tools with MS Visio
• Analyzed the AS-IS and TO-BE processes to understand the key findings, the short term considerations, the long term considerations and its benefits
• Written and executed Test cases for the application when in (UAT) Environment.
• Updated the Project Manager on a weekly basis with Status Reports.

Environment: Agile,ALM, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Access,, SharePoint 2007, Oracle, UML.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Participated in meetings for GAP Analysis to identify the difference and enhancement between current (As-is) business process and the future (To-be) business flow.
• 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.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Proficient in Database (Oracle, SQL Server) testing skills using advanced SQL, PL/SQL
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Coordinated testing efforts between SunGard and the client.
• Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Used SDLC (System Development Life Cycle) methodologies like the Agile and the waterfall.
• Test results are tracked through MS Excel and made available to all QA team members and a full report is documented every day.

Environment: Waterfall, SharePoint 2007, Windows XP Professional, Oracle, SQL, MS Outlook, MS Access, MS Excel, MS, QC.

Confidential, New York City, NY

Business System Analyst

Responsibilities:

• Involved in requirement gathering of the Data Warehouse, analyzing business requirements, Data Model Design, Data flow from various Sources to Target / DEM.
• Executed SQL statements to check if the data integrity has been maintained.
• Conducted manual (UAT) User Acceptance Testing and (UT) Usability testing.
• Actively participated in enhancement meetings focused on strategizing the testing effort of subsequent projects.

Environment: Quality Center, UNIX / LINUX, MS SQL Server, MS Excel, MS Word, MS Outlook,Waterfall.