SUMMARY:

• Lead Business Systems Analyst with 14 years of experience in building Enterprise Applications and migrating legacy Applications for large US corporations.
• Strong knowledge and hands - on experience in SQL and Relational Databases. Experience in complex querying of databases for Data Analysis and testing.
• Good understanding of (CCAR) -Comprehensive Capital Analysis and Review and risk assessment.
• Exposure to Global Wealth and Investment Management domain
• Extensive Knowledge in Capital Markets, Corporate Finance, Risk Management, Investment Banking, Mortgage, Financial Statement Analysis, Equity, Fixed Income, Alternative Investments, Derivatives, M&A, IPO etc.
• Strong understanding of Risk Management, Anti-Money Laundering (AML), Bank Secrecy Act (BSA), and Know Your Customer (KYC).
• Proven experience in Financial & Regulatory reporting including Basel II, Basel III, FACTA, Dodd-Frank reporting.
• Proven experience in Treasury and Capital markets including Treasury operations, Trade settlement and reconciliation.
• Proficient with (SDLC) methodologies and processes like Agile SCRUM, RUP and Waterfall.
• Proven expertise in successful Requirements gathering using suitable elicitation techniques.
• Experience in conducting Joint Application Development (JAD) sessions with end users, Tech Leads, developments and testing teams for conflict resolution.
• Extensive experience in creating detailed Business Requirements Document (BRD), Functional Requirements Document (FRD), Web Services and APIs Documentation and User Interface Document (UID).
• Experience in working with technical teams to identify and document Non-Functional Requirements (NFR).
• Skilled in providing comprehensive walkthroughs with the aid of wireframes, prototypes, Data Flow Diagrams and UML diagrams (Activity, Sequence, and Use Case).
• Quality Assurance experience in creating test plans and test scripts, reviewing test cases, and validating and monitoring defects using various defect tracking tools.
• Strong testing experience in performing Functional Testing, Regression Testing and User Acceptance Testing (UAT).
• Expert in creating, managing and tracking Requirements Traceability Matrix (RTM).
• Proven active involvement in Post Production Validation and Production Support.

TECHNICAL SKILLS:

Requirements Management Tools SAP Power designer, IBM Rational Rose: User Interface Design Tools Smart Draw, MS Visio, Visual Paradigm, Just in Mind, Snagit, MS Paint

Languages, Tools SQL, XML, HTML, Informatica, Cognos: Project Management Tools MS Project, MS Office (Word, Excel, PowerPoint, Access), SharePoint

Defect Management Tools JIRA, HP ALM, TFS: Databases SQL Server 2000, MS Access, Oracle

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential - Atlanta, GA

Technology: Pega, JIRA Enterprise, Mainframes

Responsibilities:

• Reviewing the business rules for establishing the DOFR for each claim based on various input conditions.
• This impacts multiple source systems like Claims, Provider, Pricing and the target system which is being built for DOFR.
• Establishing the input and output data elements for all these systems and managing the dependencies.
• This project being in agile, playing dual role of BA/SM for the provider and pricing teams as aligning the work of all teams for sprints is critical for delivery planning.
• Mapping the user stories back to epics/capabilities/initiative for traceability.
• Involved in Program Increment planning sessions to align work for each PI releases. Aligning the testing and working with QA teams to support testing.

Business Analyst

Confidential - Tampa, FL

Technology: Salesforce, TFS, ADP, Great Plains (GP), Informatica, Power BI

Responsibilities:

• From a wish list of over 300 reports, worked closely with the business to bring it down to 180 as the reports which they need from EDW.
• Defined and prioritized the KPI reports to be delivered in the 1st phase going live soon.
• Defined and implemented a report intake process for all the reporting requests coming in through informal ways of mail, call or chat.
• The Intake tool created in Salesforce for routing all reporting requests with notifications set for each status changes.
• Querying & Generating list views in Salesforce for marketing team for targeting new leads and inquiries.
• Analyzing the requests and prioritizing them based on business criticality and priority, at times changing the delivery date keeping business informed.
• Creating user stories and prioritizing the product backlog items for grooming for upcoming sprints.
• Assigning the backlog items to developers and tracking progress and supporting for business clarifications.
• Actively involved in backlog grooming and sprint planning events and adjusting the items and tasks to maintain the velocity.
• Working closely with the business to manage the expectations and requirements.
• Working with Canvas LMP team for identifying gaps in Bisk LMS existing reports and Canvas LMP report through analysis of live events and Application API's.
• Creation and maintenance of Business Glossary document.
• Environment: SalesForce, Team Foundation Server (TFS). Informatica cloud, Power BI

Lead Financial Analyst

Confidential - Tampa, FL

Technology: TLM, Abacus, SAP BO

Responsibilities:

• Using smart stream TLM as the standard database for account reconciliation data to validate the account and ledger linkage and balances.
• Validating TLM data with Abacus account data to ensure the accounts status and account owner and funding details.
• Working on 7248 accounts with target to fully link these accounts with respective ledgers.
• Reverse of this work is finding accounts data for overdraft Full-keys which are part of eRecon database but have no account data linked.
• Working with teams from Dalian and Belfast to obtain the missing date from Proof owners and account owners.
• Co-ordinating with Global Reconciliation Unit (GRU) team to obtain reconciliation platform details for non-linked accounts.
• Closely interacting with Bank Network Management ( BNM) team to ensure that account data is updated at regular intervals and to correct the data based on reconciliation details.
• Monitoring and reporting progress to senior management in Bi-weekly status meetings.
• Environment: Smartstream TLM, Abacus, SAP Business Objects, Sharepoint.

Lead Business Systems Analyst / PM

Confidential - Stamford, CT

Technology: Informatica, Cognos, HP ALM

Responsibilities:

• Conducted brainstorming sessions with the business users and Subject Matter Experts (SMEs) to gather requirements.
• Created "As-Is Business Models", by meeting with SMEs stakeholders from interfacing applications
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conducted feasibility
• Documented the business requirements in the form of BRDs.
• Domains training of the team for FX Trading (SPOT, Futures & Options) & Capital markets domains as all the applications belong to these domains.
• Participating in daily project leadership status calls to control the project progress.
• Implemented partial termination of FX trades and supported the team for complete testing of related changes.
• Enhanced and supported the various modules in securities and OTC credit derivatives projects.
• Designed and generated new report on of FX Derivatives (Vanilla European Options) maturities.
• Facilitated daily defect review meetings.
• Documented project learnings and best practices.
• Maintained the Requirements Traceability Matrix (RTM).
• Worked with SQL queries to extract and validate data from databases.
• Facilitated user acceptance testing and test strategies with developers and testers.
• Involved in reviewing Test Cases with the QA team to verify implementation of new features and enhancements
• Environment: RUP, Microsoft office suite, Informatica Powercentre, Cognos, TM1, HP ALM, SQL

Business Systems Analyst

Confidential

Technology: Mainframes, HP QC

Responsibilities:

• Worked closely with Business analyst to understand the business requirements for FATCA implementation related changes.
• Review of Business requirement documents and signing off.
• Collaborated with development teams for design discussions and creation of data models
• Collaborate with testing teams in creation of test cases, review and approval of the same
• Involved in development and testing of annual report to IRS regarding US entities holding accounts in other geographic locations outside of US.
• Assisted the development team in understanding the requirements and got their queries answered from business users.
• Prepared detailed System Requirement Specifications Documents (SRS) to capture the essential functionalities for the proposed changes.
• Responsibilities also included over-looking Test Planning, Test Case development, Functional and Integration Testing.
• Defect logging and tracking of the test results in HPQC.
• Involved in Change Management process, using Requirement Traceability Matrix (RTM) and performing Financial Impact analysis.
• Collaborated with business stakeholders for training and UAT
• Collaborated with all IT teams during deployment and Post production validations
• Environment: Microsoft office suite, AS400, HP QC, RUP

Business Analyst

Confidential - Orlando, FL

Technology: JBase, Oracle, Infobasic

Responsibilities:

• Response to RFI & RFP's.
• Requirement gathering and elicitation through user workshops, interviews & questionnaires.
• Mapping the requirements to product functionalities and identifying the gaps.
• Writing the detailed functional specifications for proposed solutions and customizations.
• UAT support and issue tracking & closure.
• Also worked on no. of Risk & Finance reporting projects for Basel II reporting and Central Bank reporting requirements.
• Monthly and Quarterly budget forecasting and cost management.
• Implemented ACH (Automated Clearing House) solution for a client in Eastern Caribbean region.
• Worked on several projects to standardize the operations of a client in CCOM (Common Caribbean Operating Model).
• Development of Risk Management framework for a client to manage Credit Risk & Operational Risks.
• Report on Calculation of risk capital based on total Risk Weighted Assets of a bank.
• Worked on a Data mining project to create a remote central data warehouse for data from multiple applications to use for reporting purposes.
• As part of CCAR, worked on a Stress Testing solution for a client to check the health of the Credit portfolio for the client to ascertain Capital adequacy.
• Implemented a solution to identify prospects for private wealth management business of a bank based on assets held by a customer in the bank.
• Environment: Confidential T24, Oracle, Microsoft Office Suite, TAABS tool

Project Analyst

Confidential - New York, NY

• Technology: SEAT testing tool
• Project Name: T24 implementation
• The headquarters and branches, including overseas branches, of SMBC engage in deposit taking, lending, securities brokering and trading, securities investment, money transfer, foreign currency exchange, corporate bond trustee services and custody services, financial futures underwriting, investment trust sales and other commercial banking activities.
• Confidential (SMBC) is implementing T24 for its 18 overseas branches.
• Responsibilities:
• Functional testing based on BR documents, process charts and Functional Specification documents.
• Testing core modules of Funds Transfer(FT), Teller(TT), Deposits (LD) and Syndicated Lending(SL) also local development and System Amendment Requests(SAR)
• Based on the FS of selected modules, Test scripts identification, modification and running regression cycles for each new builds being deployed.
• SEAT is a built in tool capable of capturing test scripts based on input of transactions.
• It's also pre-configured with standard test scripts for all modules of T24 which were used for our regression testing.
• Change management and Test case development for new changes.
• Reporting the regression testing reports and logging of issues.
• Analysis of test results.
• Environment: Confidential T24, Microsoft Office Suite, SEAT tool
• Business Analyst
• Corporation Bank - Mangalore, Karnataka
• Project Name #1: PeopleSoft HRMS implementation (User side)
• PeopleSoft HRMS project was for replacing various systems being used by Personnel Administration Division of Corporation Bank for different functions like Employee master data, Leave administration, benefits administration, payroll etc. as per the recommendations of BCG.
• Responsibilities:
• As a Business Analyst, my responsibilities involved,
• Study of existing systems & processes.
• Functional Requirement gathering & analysis.
• Process mapping for the redesigned processes.
• Coordinating with user divisions for formulating SRS & the tender document.
• Hosting pre-bid meeting to resolve bidders' queries.
• Evaluation of technical offers based on internal evaluation matrix.
• Environment: Microsoft Office Suite, Peoplesoft HRMS, IBAS Banking suit
• Project Name #2: Helpdesk - Retail Banking This Project Helpdesk - Retail Banking was for operational technical support to branches for routine system related operational issues and support for pre-migration activities for migration to Core banking to verify that the system is as per the migration requirements and to identify and report the discrepancies.

Environment: Microsoft Office Suite, IBAS Banking suit, e-TDS module