SUMMARY

• Qualified professional with 8+ years of extensive experience in the field of Business Analyst working with the technical staff to implement management and staff's business requirements into the software application in Banking industry.
• Strong knowledge of Core Banking System, Retail and Commercial banking business, products, policies and procedures.
• Strong subject matter expertise in Investment/Retail banking, financial statements, cash flow, financing structures, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Good Knowledge on Salesforce CRM - Sales/Service cloud and Force.com platform Communities, Sites experience in designing, solution and development.
• Experience in understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, and Modeling.
• Expertise with Administration and Configuration of Salesforce.com CRM to populate and maintain data.
• Solid experience in Finance Industry, Investment banking, Retail banking, Commercial banking, Credit Cards, Mobile Banking, Wealth Management and Mortgage Services.
• Expertise in credit analysis ( corporate & retail), analysis of financial statements, performance ratios.
• Knowledge of Commercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes.
• Proficient in creating screen mock-ups, wire frames and User Interface Documents, including Screen for Mobile Application.
• Experienced with Microsoft SharePoint, Business Intelligence Analytics SQL Server Integration services SSIS, SQL Server Analysis services, Performance Point Services, Reporting Tools, Salesforce.com, Siebel CRM and other business applications.
• Extensive Knowledge in Capital Markets, Corporate Finance, Risk Management, Investment Banking, Mortgage, Financial Statement Analysis, Equity, Fixed Income and Alternative Investments.
• Experience in implementation, configuration, design, analysis and understanding of SFDC CRM Application.
• Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• Experience on well-known Commercial Lending product Misys Loan IQ on all modules with expertise on Accounting.
• Strong Experience in end-to-end implementations of a core banking modules like deposits, savings, customer information systems including integrations.
• Good understanding knowledge of Commercial Lending, Commercial Loan, Risk analysis.
• Experience on Salesforce CRM platform Worked on different environment of SFDC such as Sales and Service Clouds.
• Expertise in mortgage application and approval Encompass with end-to-end functionality that is affordable and easy to use Loan origination system (LOS).
• Strong experience in Encompass and (LOS) originating a loan vary by loan type, various kinds of loan risk and regulator, lender policy and other factors.
• Experience in Credit Cards which includes Consumer and commercial credit cards, Cards Payable, Payments, Credit Card Acquisitions, Direct Debit, e-statement, Loyalty (reward points), Marketing, Personalization, Alerts and Messages, Customer Management Services and Fraud workflows.
• Having excellent understanding of Financial Accounting, Comprehensive knowledge of Balance Sheets, General Ledger, Trial Balance, Income Statement.
• Expertise in mortgage application and approval Encompass with end-to-end functionality that is affordable and easy to use Loan origination system (LOS).
• Extensive experience with OLTP/OLAP System and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Good Knowledge in data Extraction, Transformation and Loading ETL using various tools such as SQL Server Integration Services SSIS and SQL Replication.
• Strong Knowledge of UML, RUP, Waterfall, Agile Technologies, JIRA, SAFe and Rational Requisite Pro.
• Proficient in developing Use case scenarios to enable design and development of applications using tools like Rational Requisite Pro, JIRA and VersionOne based on the SDLC methodology.
• Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Strong background in software for Banking and Financial services with knowledge on Payments module, SWIFT Messages (MT103, MTn90, MTn91, MTn92, MTn95, MTn96, MT202, MT300, MT320, MT900, MT910, MT940 and MT950) and Confidential (GPP) system.
• Extensive experience in Finance industry, Credit Cards, Investment Banking (GL-General Ledger, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
• Extensive knowledge in Payments processing and SWIFT messaging standards. Have good knowledge of CHIPS, FED and ACH.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Good Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expert Knowledge in the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), KYC, Bank Secrecy Act (BSA), Office of Foreign Assets Control (OFAC) Guidance.
• Strong knowledge in UML, proficient in creating Use Cases, Use Case Diagrams, Sequence Diagrams, Collaboration diagram, Activity Diagrams and other Modeling.
• Extensive experience in Conducting Market Research, Feasibility Studies, and Risks Analysis
• Extensive experience in the management of User Request Change and User Conflicts.
• Ability to organize, document and track changes and defects by using Rational Requisite Pro, Clear Quest, Clear Case.
• Expertise in developing Test Plan, Test Conditions, and Test Cases ensuring adequate testing of software both before and after completion conducting and documenting UAT.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr Business Analyst

Responsibilities:

• Participated in gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
• Involved in Writing and executing positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
• Defined rules for security master database consolidation by aggregating data from multiple sources such as Bloomberg, and S&P.
• Worked on various projects teams to implement and convert functionality to ACBS (Advanced Commercial Banking System) application.
• Involved in Reviewing the Design Documents, Requirements Analysis Specifications with Business Owners and the Technical Lead. This module included Online Bill Payments, Transfers, Online Bank Statements Check Images, eMail Wireless Alerts.
• Work with all departments on collaboration tools (Office 365 Suite of tools, cloud based).
• Documented the commercial deposit process which comes thru saving accounts, checking accounts, money market accounts, and s of deposit (CDs).
• Was involved in Business Re-engineering process for automating "get a quote" process and reflect all the daily adjustments in the financial statements (P&L).
• Creation of multiple functional requirements encompassing loan servicing system (vendor application), pre-boarding system (in-house application), and interface between systems (in-house and vendor-provided interface package).
• Utilized Commercial Lending banking application and was responsable for the design and process flow of the system.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance.
• Responsible for gathering user requirements and specifications for designing a mortgage-based loan system using and documenting the same.
• Worked with the full SDLC, elicit, analyze and define requirements. Added much efficiency to the delivered upgrade scripts and steps. These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, and Fixed Assets) across many databases.
• Handled the Credit/Debit Activity of the clients. The major modules are Loan Transaction, savings Management and Recurring Deposit and Fixed Deposit Transaction systems for stakeholder interactions.
• Worked on Transaction Details project which involved making transactions received as part of MT 940 and MT 942 SWIFT statements, in the form of reports.
• Working with the database team they are Used SQL and SAS skills to perform ETL from DB2 and Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats as required.
• Provided active testing support to the testing team. Actively participated in mobile application releases by running test cases, revivifying defects / bugs and properly communicating and highlighting them to the required representatives.
• Reviewed defect reporting and resolution in Mercury Quality Centre to track project progress against schedule. Used Bug Tracking Systems Jira to prioritize.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence team to understand repository objects that support the business requirement and 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.
• Possess understanding of the Structured Finance with a focus on Asset Backed Securitization including MBS, credit cards.
• Evaluated the functionality of the existing collateral management system.
• Worked with client to determine user requirements and goals at requirement elicitation stage using Agile Methodology.
• Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.
• Involved in analysis of KYC data to understand the attributes, schemas and data structures.
• Resolved P&L discrepancies through daily interaction with Front Office, erroneous trade bookings investigation and internal allocation charges.
• Created RTM (Requirements traceability matrix) mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Interacted with various business user groups for gathering the requirements for Salesforce.com CRM implementation.
• Gather business requirements and create business system requirements for the Loan Origination System and the Loan Servicing System.
• Worked on Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Participated in gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
• Worked on various Salesforce.com Standard objects like Accounts, Campaign and Reports.
• Prepared year-end financial statements (P&L, Cash Flow, Balance Sheet) and budgets for the company.
• Created scope statements, use case documents, user stories, process flows and various other project artifacts.
• Working on analyzing the new requirement on Loan Syndication, origination and servicing functionalities for ACBS (Advanced Commercial Banking System) application.
• Interacted with the Salesforce.com premium tech support team on a regular basis.
• Worked on various OnlineBankingprojects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
• Documented the Current and Future State Accounting Work flow as part of Online Payments.
• Involved in Writing the SQL and PL/SQL queries on data staging tables and data warehouse tables to validate the data results.
• Involved in Writing and executing positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
• Preparing the SDD (Story Definition Document) for the Loan Origination System. Analyzed business requirements for testing phase during execution of loan origination system (LOS).
• Worked with the technology team to define the structure and data model for client, compliance & tax reporting data warehouse.
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• Utilized Team Foundation Server (TFS) for the regular project management activities and agile project management.
• Used JIRA bug tracking tool to analyse & capture bugs, track and manage dashboard any type of updates for project release.
• Interacted with the Business users and gathered business requirements for international principal lending business.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Facilitated review sessions with stakeholders to access business needs and elicit requirements.
• Reviewed and analyzed the existing KYC standards in order to develop and document business requirements for the line of business KYC application.
• Collaborated with partners in Compliance, other KYC functional teams and the business to ensure stake-holder's understanding of KYC requirements, system enhancements and regulatory changes.
• Analyzed the process and identified the functionality improvement options to fulfill the business needs. Communicated benefits and risks of each option, and recommended business priorities.
• Worked in partnership with the KYC technical team to translate implementation options into detailed Functional Requirement Specifications and Technical Requirement Specifications.
• Created UML to ensure the business logic is clearly demonstrated to developers. Created use cases to understand the narratives.
• Collaborate with the KYC Operations teams including Quality Control, the Industry Risk Group and the Database Administration team to ensure the teams are prepared for implementation.
• Partnered with the KYC Operational Readiness team to ensure the business is prepared for implementation by Documenting new policies & procedures and Outlining and explaining updates to the KYC application.
• Collect and review due diligence documents for new funds to ensure CIP requirements and KYC regulatory requirements are satisfied in accordance with the bank’s enhanced due diligence policies.Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Effectively conducted AML /KYC formality reports on questionable accounts and transactions.
• 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.
• Involved in Performing data analysis using SQL to generate portfolio summary reports the system used this information to generate reports analyzing returns on equity and fixed income portfolios.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

Confidential, Storm Lake, IA

Business Analyst

Responsibilities:

• Worked on gathering requirements for automating interfacing with other banks through SWIFT for updating the financial transactions.
• Involved in Designing and implementing the Stateful session beans for Core Financial Services, Charges and SWIFT messages.
• Worked with data flow diagrams, data analysis, and Process flow diagrams
• Responsible for handling inter-bank communication related to exports through SWIFT messages.
• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Assisted in developing RTM (Requirements Traceability Matrix) using JIRA. Maintaining all the assignments on JIRA.
• Worked on streamlining existing loan origination system (Empower) to ensure the loans are processed effectively, quickly, and also reflect recent TRID regulatory changes.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on AGILE methodology.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence team to understand repository objects that support the business requirement and process.
• 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.
• Responsible for creating Use Cases,BusinessProcess Modeling and Work Flow Diagrams using MS Visio and MS
• Excel Performed the requirement analysis and documented the requirements.
• Prepared year-end financial statements (P&L, Cash Flow, Balance Sheet) for the company.
• Created use case scenarios and documented work flow andbusinessprocess using Rational Rose.

Confidential, Oakwood, TX

Business Analyst

Responsibilities:

• Gathered requirements and involved in modelling the data warehouse and the underlying transactional database.
• Worked on various Swift messages for payments.
• Involved in Converting various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations.
• Participated in using the Agile Methodologies on projects utilizing full Systems Development Lifecycle (SDLC), while using MS SharePoint for storing project documents.
• Involved in Developing thr Use Cases using UML and Business Process Modelling.
• Used JIRA to write user stories as part of the AGILE methodology.
• Delivered presentations on Project Status and Current Open Issues Report to Users, Stakeholders and other involved groups.
• Conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.