SUMMARY

• Experienced Business Analyst with Over 8 years of proven skills in requirement gathering, interacting with developers, documenting various business processes valuating Data Sources, Translating Requirements into Specifications, Application Design payments banking and financial business.
• Excellent knowledge in Software Development Life Cycle (SDLC) / Rational Unified Process (RUP) methodologies, Agile Methodology.
• Expertise in working with Credit card and Banking industry, Financial institutions, Risk Analysis, Financing structures, Capital management, Portfolio Analysis
• Experience with Mortgage loan servicing, Loan Origination, Student Loan Origination
• Hands on experience on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and FedWire.
• Good understanding of Capital Markets debt, derivatives, and foreign exchange portfolio performance attribution and performance composites, Derivatives (Interest Rate, Credit, Equities), ABS, Equity, Loan and Fixed Income Business Process Management
• Extensive knowledge in Payments processing and SWIFT messaging standards. Have good knowledge of CHIPS, FED and ACH.
• Experience in Asset Servicing and involved in driving the SWIFT Standard Release implementation affecting its business operations for Cash Management Payment Services, Settlement Reconciliation, Treasury and Corporate Actions.
• Experience in providing assistance to software developers and testers to resolve defects entered in HP ALM during the testing process.
• Experience in the development, enhancement, and maintenance of ALM models and systems that derive market risk (including interest rate and FX risk).
• Thorough understanding of Anti Money Laundering (AML) procedures and hands on experience of working to ensure AML compliance at client’s place.
• Experience of working with SOX regulatory compliance and controls and Basal III standards.
• Strong experience in processing knowledge of EFT payments processing through Automatic Clearing House ACH, Credit Cards, Check Processing, Third party payments and European payments knowledge.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe, Prototypes and documenting them using Microsoft Visio.
• Working 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).
• Experienced with Loan Origination process and Fixed Income Products like Treasury (Bonds, Notes, and Bill), Mortgaged Backed Securities (MBS), Municipal Bonds, Corporate Bonds, Junk Bonds and Convertible Bonds.
• Experience on well - known Commercial Lending product Misys Loan IQ on all modules with expertise on Accounting.
• Expert in Test driven development & Unit testing methodologies for performing UAT, System Integration testing (SIT), and Business Acceptance Testing (BAT).
• Experience capturing requirements for web development specifically in eCommerce Payment Transactions.
• Experience in database modeling and development of Entity Relationship Diagrams (ERD)
• Experience in Requirement Traceability Matrix (RTM), Data Migration, Periodic Review, GAP Analysis, Risk analysis, CAPAs and Remediation Process.
• Experience in Data mapping, logical data modeling, class diagrams and ER diagrams and used SQL queries to filter data.
• Strong technical background of IBM Mainframes technologies such as COBOL, JCL, VSAM CICS and DB2.
• Experience in Participating with QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, and Business Modeling.
• Experience in database queries of the application database to provide data for business decisions, resolution of issues and validation of solutions.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Expert in creating clear and concise reporting on requested business metrics using Microsoft Power BI, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Microsoft Access, Microsoft Excel, Crystal Reports, Tableau and other reporting tools.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Good knowledge of Power BI Service (SaaS) and the Power BI Embedded service in Azure (PaaS) have APIs for embedding dashboards and reports.
• Experience in creating and maintaining artifacts associated to Agile user features/ stories, use cases, functionality issues, data dictionaries, data mapping and test cases using Visio, JIRA, Confluence.
• Experienced with Rational tools like ReqPro, Clearquest, ClearCase, Rational soda, Rational Rose.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr. Business Analyst

Responsibilities:

• Conducted JAD sessions with management, SME, brokers, users and other stakeholders for gathering requirements and to discuss open and pending issues.
• Interpret and enforce all terms for facilities as per Loan Agreements.
• Worked intensively on the PL/SQL for creating and working on the database for multiple projects.
• Providing recommendations and helping in resolving errors and reconciling daily bank control of payment centers and treasury services.
• Modeled the fact tables and developed packages to populate them with T-SQL tasks to aggregate product warranties and their overtime amortization.
• Writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents.
• Followed Software Development Life Cycle using Agile (SCRUM)Methodology which is based on iterative and incremental development
• Gathered business and functional requirements for new batch and real time interfaces for the 'Global Loan Platform / Misys Loan IQ' conversion project.
• Worked along with the Lead in project planning and management of internal resources for client risk replacement by formulating strategies to improve business and operational processes by coordinating with the bank market's CIO for public funds, bonds lending, & mutual fund.
• Conducted SCRUM meeting, Sprint meeting and Sprint planning meeting.
• Tested the brokerage and financial services applications like Equities, Fixed Income, Investment Research, Investment Deposits, Accounts (Accounts Activity, Balance Holdings, Portfolio Management, E-statements, Retail Consumer Lending, Mortgage Modules, Integration Module
• Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data.
• Prepare BRD's for Enhancement and test environment when developed by Misys Loan IQ.
• For the Confidential 'International Global Lending' and Merger / Integration projects, performed SQL querying, XML and C# research and data analysis for the Misys Loan IQ database and Loan IQ downstream interfaces.
• Prepares and reviews all collateral balances and movements; create daily margin/collateral movement reporting.
• Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
• Developed complex T-SQL queries to load data including loops with nested cursors and merges.
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer and UNIX shell commands.
• Responsible for integrating Misys Loan IQ with the Confidential lending platform application, as the go forward solution. Part of a 3-member Project Management team that advises Senior Management on the proper interfaces to be used between LIQ and existing legacy systems.
• Met with Credit Risk Analysts and Loan Officers to gather Credit Approval Process and Reporting Requirements (Credit Exposure Data, Loss Data) for Credit Cards (TSYS), Currency Swaps, FX Forwards, REPO, Equities, Fixed Income instruments like Bonds, US Treasuries, Mortgage Backed Securities, and Asset Based Lending Products according to the Basel II compliance guidelines.
• Support Loan Operations by reviewing critical issues and breaks, utilizing Subject Matter Expertise in Loan IQ functionality to determine appropriate solutions based on current business practices. When appropriate, work with development and IT to coordinate challenges that require a more complex solution.
• Performs review of collateral and documents to ensure documents meet agency guidelines or customer agreements in a timely and accurate manner.
• Involved in Analysis of gathered requirements data, verification of requirements and creation of business requirement specifications (BRS). Extensive Knowledge of Loan IQ Data Model.

Confidential, New York

Business Analyst

Responsibilities:

• Analyzed the existing system and business process flow by understanding pre-set business rules and conditions
• The Project included 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.
• Conduct interviews with key business users and used other fact-finding techniques to collect requirements and business process information
• Involved in technical design/analysis indicating the input data sets, sorting and merging techniques to get the required report.
• Responsible for OLB (Online Banking) customer satisfaction score to go up to develop more business for the Retail baking.
• Conducted surveys and brainstorming sessions with SMEs for requirement gathering
• Involved in portfolio analysis and asset management with the SMEs
• Performed extensive requirement analysis including data analysis and gap analysis
• Involved in analysis, design of the architecture using OOAD approach through UML applying Rational Rose
• Designed and developed different project development documents based on SDLC methodology-RUP
• Assisted in creating the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form
• Worked actively in the preparation of Business Requirement Documents, Functional Specification Documents and Change Request Documents
• Wrote User Acceptance Test Plan based on business users’ requirements and reviewed Test Plan templates.
• Provided technical solution related to domain controller, database server, IIS server and FTP server.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Worked closely with QA teams to define test cases and execute test plans
• Designed and implemented basic SQL queries for report and data validation
• Worked with marketing teams to determine the target market and to find out what clients actually wants
• Involved with the technical teams during implementation such that right business requirements are being translated into the system
• Assisted the project managers in feasibility analysis-schedule, technical, economical and operational feasibility
• Analyzed the AS-IS and TO-BE processes to understand the key findings, the short-term considerations, the long-term considerations and its benefits.

Confidential, San Francisco

Business Analyst

Responsibilities:

• Effectively served as Business Analyst for Performance Measurement Audit and Capacity Tests; responsibilities included creating test cases, scripts, test execution schedule, coordinating data set up, managing resources, creating project task plans.
• 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.
• Utilized the business requirements to develop detailed user interface for the application prototype.
• Analyzed the MT 527 SWIFT format and worked with Technical Managers to prepare a mapping mechanism to decipher Trade instructions received through SWIFT.
• Application was developed for Online Banking accessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
• Designed fund settlement process using Society for Worldwide Interbank Financial Telecommunication (SWIFT) messaging protocol for trade cash settlement with custodian banks.
• Conducted user interviews, gather requirements, and analyze the requirements
• Wrote Use cases to demonstrate the business requirements and assisted in developing business models
• Conducting the system and user acceptance testing. Define the test plan, test cases and automation of the test scripts using Rational Suite Tools.
• Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML
• Involved in Writing test scripts for all classes of VB.NET and calling them from NUNIT for testing
• Assisted in developing the Business Flow Diagram using MS Visio
• Worked with cross-functional teams for building the use cases
• Assisted in creating the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form
• Worked with the design team to assist them extensively in designing the database
• Assist end users and IT staff in the use of data to satisfy informational and reporting requirements using SQL and DBMS
• Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Conducted workflow, process diagram and GAP analyses to derive requirements for existing system enhancements
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge.
• Extensively used Microsoft office suite of products for documentation and data interpretation for reporting test status
• Conducted User Acceptance Testing
• Used MS Visio and MS Excel extensively to develop the use cases
• Regularly interacted with onshore and offshore teams to communicate requirements and review test cases and test plans.
• Worked closely with the project manager in handling the whole project
• Used Data mapping to collect and show relations between data
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.

Confidential, New York

Business Analyst

Responsibilities:

• Worked on implementing the data governance standards, policies, and procedures for the control, protection, consistency and delivery of corporate data and information assets.
• Gathered Business requirements from Business owners, Subject matter experts and stakeholders from all the regions across the globe.
• Gathered and analysed third party market data requirements for the business and exceled as a liaison between client and vendor negotiations.
• Worked as a Business/Data analyst as required by the CS for multiple Business Process Reviews' and documented all the Artefacts which are being used by business owners, SME's and stakeholders.
• Involved in creating data governance and privacy policies
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance
• Assisted on designing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions
• Involved in the development of data stewardship program establishing metadata registry responsibilities
• Worked on the implementation of metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
• Gathering the information about manual sources that are not captured in point of delivery (POD) Mappings.
• Assisted in creating the Enterprise Information Group encompassing Business Intelligence Center of Excellence, Data Governance Working Group, Enterprise Data Warehousing and Master Data Management. Provided strategic vision and direction with operational and business leaders for enterprise information initiatives enabling Executives to make information-based decisions
• Involved in various work streams in different phases of the implementation and directly reported to the stakeholders.
• Worked on end-to-end development on integration between various systems.
• Worked on key Middle Office domains (confirmations/settlements, pricing, reconciliation, security master, reference/analytics data, trade operations, performance, attribution, risk data)
• Worked with portfolio managers to gather all the benchmarks, sectors and ratings requirement from market vendors.
• Participated in the Global PMO weekly meetings with the stakeholders and reported key issues, risks of the project.
• Created a global consistent process flow and workflow by working with portfolio managers, Quant teams, Investment Risk teams, Investment accounting team, Trade operations and settlements team, IT and trade support teams.
• Worked on different testing phases and logged, resolved and documented testing defects, open issues in JIRA by coordinating key Subject matter experts.
• Worked on decommissioning the existing systems by analyzing and resolving the potential gaps.
• Created and managed the third-party market data dashboard and tracker which helped the business owners to track the negotiations.
• Involved in daily scrum meetings with the Agile Project team on key principles of Scaled Agile (SAFe) competencies & practices including team ownership, commitment, effective user stories, agile estimation, and transparency.

Confidential 

Business Analyst

Responsibilities:

• Worked as a liaison between PMI Group's SMEs by collecting business requirements, and defining core company processes (5 processes). Communicating requirements to PMI-SDI unit by documenting key deliverables in adherence to Rational Unified Process for all high & low complexity projects as outlined in Project Plan.
• Conducted a walk-through session of the scope document to ensure that the project sponsors and stakeholders understand the project scope and any associated constraints, risks, and issues as early as possible.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and created a business use case.
• Performed data analysis and data validation by writing SQL queries using TOAD against ORACLE database.
• Analyzed business requirements and segregated them in high level and low-level use cases.
• Derived functional and technical requirements specifications based on user requirement Specification (URS).
• Understand and articulate business requirements from user interviews and then converts requirements into technical specifications.
• Wrote clear, concise detailed system requirement specification (SRS) documents and user documentation in accordance to guidelines and standard of a level where developers can interpret design and develop the application with minimum guidance.
• Designed use case diagrams and wrote their specifications in the use case specifications documents based on the requirements gathered.
• Documented requirement traceability matrix in Requisite Pro for traceability of requirements through test cases.
• Worked on risk managements, mortgage loan servicing, commercial, residential mortgage, CMBS, MBS.
• Performed data querying and data validation using SQL statements in Oracle.
• Conducted highly interactive JAD sessions with projects stakeholders such as users, QA analyst, and project management team, identifying and resolving issues.
• Involved in categorizing mortgage prepayment risk, risk analytics for MBS, loan origination, loan servicing, MBS, SMBS, Secondary mortgage insurance, escrow and reserve administration, escrow processing, non- escrow loans collateral inspection and monitoring, income and expense statement review and inspection report
• Integration of various modules related to securities like MBS and mutual Funds with the mortgage and loan application servicing system.
• Assisted Quality assurance team in preparing test strategies and test plans to verify the functionality, security, fault- tolerability, performance and successful system integration
• Using UNIX shell scripting creating batch jobs to create index and analyze tables once the imports are done.
• Used Rational Clear-Case as version Control system for any changes to common documents related to project like use case documents.