SUMMARY

• Sr. Business Analyst Over 9 years of experience as in the field of Information Technology with emphasis on Business Analysis in Business Requirements Gathering, Business Process Flow, Business Process Modelling, Data Analysis, Data Transformations, Data Mapping and Quality Analysis.
• Highly enthusiastic on the functioning of SDLC, particularly in agile product life cycle (SCRUM) methodologies.
• Previous project experience included transformation of non - Agile teams to agile teams.
• Familiar with full life cycle of credit cards applications for different banking systems. Have strong knowledge in following phases of credit cards life cycle.
• Excellent understanding of EFT system such as SWIFT, ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage.
• Exemplary knowledge and experience in the Financial Investment Banking industry with clear conceptual understanding of various financial instruments such as equities, bonds, fixed income securities and derivatives, and asset/portfolio management.
• Strong experience of payments processors such as Credit Card processor First Data, Originator Financial Institutions ODFI, VISA, MASTERCARD,AMEX and DISCOVER networks.
• Strong knowledge of the procedures of Banking & Regulatory Compliance's especially in AML, KYC and Basel Accords.
• Well-versed with leading industry tools like Jira, Version1, Caliber, MS Visio, MS Word, MS Excel and MS PowerPoint to develop various project deliverables like Use case scenarios to enable design and development.
• Excellent in business process modeling notation (BPMN) and workflow modeling tools.
• Good understanding of the software development life cycle (SDLC), rational unified process and agile- scrum methodology and testing life cycle.
• Expert in writing functional and non-functional requirements.
• Experience and proven success overseeing all aspects of organization-wide large-scale IT programs.
• Proficient in Business Analysis, Business Architecture, and Business Modeling and Risk Analysis.
• Adept at eliciting business and functional requirements through meeting, interviewing session, Joint Application Development (JAD) sessions.
• Focused on Banking, Mortgage, and Financial Industries, Investment Banking, Loan IQ and Retail Banking.
• Well Versed in conducting Gap Analysis, in depth knowledge of the AS-IS and TO-BE business processes.
• Experienced meetings coordinator/moderator and Joint Application Design (JAD) facilitator with excellent interpersonal and conflict resolution skills.
• Solid understanding of regulatory reporting, Market Risk Control, CCAR, DFAST (Dodd Frank), Basel II, Basel III and other regulatory reporting processes.
• Experience on requirement documentation of product types and mapping data for FR Y-14A, FR Y-14Q, FR Y-9C, etc. by using Kauffman Hall’s product - AXIOM
• Excellent skills in documenting Business Requirements Document (BRD), Functional Requirements Document (FRD), System Requirement Specifications (SRS), Use Cases and Test Cases.
• Proficient knowledge of Unified Modeling Language. Expert in analyzing and creating Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Flow Diagrams and Sequence Diagrams using MS Visio.
• Expertise in implementing Test Plans, Test cases, Functional testing, Regression Testing and Integration Testing. And maintaining Requirement Traceability Matrices for baseline documents.
• Fluent in a broad range of technologies, including Business process tools such as MS Project, Excel, Access, Visio, Balsamiq and Azure Wire framing/Prototyping tool.
• Experience in various data sources and targets like Oracle, DB2, SQL server, Excel and non-relational sources like flat files, XML SSIS/ Informatica and Power BI
• Competent in creating Unified Modeling Language (UML) diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD), Data Flow Diagrams (DFD), Flow Charts (FC) and Wireframe Prototypes
• Experience in conducting Gap Analysis, expert in creating AS-IS and TO-BE documents.
• Expert in facilitating the entire Testing Life Cycle and experienced in conducting the User Acceptance Test (UAT).
• Expertise in creating Business Process diagrams, Use Case documents & UML diagrams including Use Case diagram, Data Flow diagrams, Flow charts, Activity diagram, Entity Relationship and Sequence diagram.
• Experience in Creating and Maintaining the Requirements Traceability Matrix (RTM)
• Good understanding of SQL queries to extract, update and delete the data from data base.
• In depth of knowledge of software development life cycle (SDLC), waterfall, Agile/Scrum methodologies and Rational Unified Process (RUP).
• Good Experience in using Informatica Power Center ETL tool with industry best practices & knowledge in Reporting tools like Tableau & Power BI
• Extensively interacted with QA Team in executing Test Plans, Test Scenarios and Test Cases for Modules.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) and User Acceptance Testing (UAT).
• Confident, analytical and detail-oriented candidate with excellent multi-tasking capabilities to perform exceptionally in ever-changing and stressful environments.
• Articulate communicator equipped with great work ethic, excellent interpersonal skills with the ability to evaluate alternatives and guide business decisions.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential - Stamford, CT

Responsibilities:

• Conducted user interviews, gathered requirements from business users using Visio & Rational Requisite Pro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Responsible for performing Functional, Regression and User Acceptance testing on enhancements made.
• Participated in the UAT for integration using Mercury Test Director.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams using Rational Rose according to the UML methodology.
• Developed use cases/diagrams, conceptual model, behavior diagrams using MS Visio.
• Creating and upgrading payment processing procedures time to time for bank operations.
• 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.
• Wrote user stories using agile/scrum methodology and performed tasks and backlog intervals. Used JIRA for Sprint storing creating, tracking and update for entire sprint.
• Monitoring credit card application and reporting to high level management about possible risk and ensured compliance. Sketched diagrams of proposed and existing systems using Visio.
• Implemented the entire Agile Methodology of application development with its various workflows.
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects.
• Worked with other LOB on initiative of identifying gaps and discrepancies in regulatory reporting application.
• Identified UI requirements, created Wireframes, Prototypes and UI specification using Axure.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Worked with various business channels, and the fixed income trading desk to determine suitability and recommend appropriate fixed income securities and their derivatives.
• Prepared functional requirement documentation for ACH account analysis AA -pricing and billing.
• Performed additional tasks as assigned, improving the effective administration of the AML and KYC Policies.
• Conducted JAD sessions with different stakeholders and development team as and when necessary to elicit use cases.
• Developed and maintained the project plan using MS Project
• Created Reports/Visualizations/Dashboards in Power BI using filters at Visualization level/page level/report level.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.
• Interacted with various clients to gather requirements, objectives, and input and output requirements retail banking, manufacturing, and utility industries.
• Responsible for Optimization of Informatica mappings, sessions, SQL queries. Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in testing REST, SOAP Web Services and XML with tool SOAP UI to locate WSDL file on internet, create Test cases, run them, do load testing, security testing.
• Participated in regular status update meetings with the Project Management team and QA Team meetings
• Responsible for submitting the bugs into the Test director depending upon their priority.
• Supported Design and Deployment team to resolve reported problems.
• Helped transition the team to use Agile Software Development methodology.
• Used standard office technology and basic Microsoft applications including Visio, Word, Excel, and PowerPoint.

Sr. Business Analyst

Confidential, Kansas City, MO

Responsibilities:

• Documented business requirements and technical requirements document using process and data models to explain detailed business implications and impacts.
• Utilized RavenFlow and Visio to create multiple as-Is and To-Be process flow diagrams and Integration Point Diagrams to assist with requirements interpretation.
• Assisted with the Bloomberg AIM and Charles River Trading Inbound and Outbound feeds analysis.
• Gathered and documented UX\UI (visual) requirements, functional and non-functional requirements in Business Technical Requirement Document.
• Participated in understanding existing Sovereign's ACH processing system, daily PEP payment processing and analysis of PEP reports, payment distribution, daily reconciliation and balancing
• Serve as a point of contact for the client’s stakeholders and provided customer support in addition to team building with on and off shore agile teams.
• Analyzed and documented business processes, use cases, workflow diagrams and obtained sign-off from client on specifications which included SWIFT, ACH, and wires requirements.
• Conducted research, analysis and provide qualitative/quantitative insights to lead and direct projects and initiatives to meet the Firm's AML/KYC Standards.
• Worked on Upgrading existing Credit Cards application by incorporating new functional changes introduced by MasterCard network.
• I was responsible for analysis, design and development for VISA and MasterCard scheme compliances.
• Performed documentation such as Regulatory Reporting FR Y-14A/Q, FR Y9, FFIEC 041, FFIEC 031 reports and Dodd Frank (Dodd-Frank Act Stress Test).
• Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
• Transitioned into a senior role as a BA and adapted to systems development for retail banking data analytics.
• Build Platform features, user stories, and maintained backlog with priorities, using Rally and JIRA platforms.
• Wrote SQL queries to perform Data Validation and Data Integrity testing to ensure data quality.
• Prepare business requirement documents to build the new data mart at product level
• Prepared Use Cases for the functional requirements to define the system rules.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Dataflow Diagrams in MS Visio to effectively communicate the requirements.
• Reviewed the reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content and Analyzed existing business requirements in Tableau.
• Conducted requirements definition and analysis to capture, clarify, and confirm the requirements.Closely interacted with developers and QAs to communicate and validate requirements as needed.
• Assisted Project Manager in managing requirements by coordinating and facilitating requirement tracking using Requirement Traceability Matrix (RTM).
• Stored and modified requirements in MS Word. Documented business requirements with wireframes and mockups to explain in detail the business implications
• Responsible for preparation test cases, test scripts, Decision tables and documented it for regression testing.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Involved in the Testing phase, reviewed test strategy and created test cases to ensure the transformation to the new database and worked with SQL queries for data manipulations, responsible for data mapping.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Confidential - St. Louis, MO

Responsibilities:

• Conducted JAD sessions with SMEs and developers to get a better understanding of functionality of different tools.
• Involved in RUP Business Modeling process and worked extensively on creating and updating Use Case Diagrams, State Diagrams, Activity Diagrams and technical designs (UI screen) using Microsoft Visio.
• Constantly partnered with project leads to ensure the team is producing solutions that meet established standards, procedures, practices, address issues, risks, and mitigation plans.
• Resposible of gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
• Cooperated with CCAR team on delivering of the Basel capital regulatory reporting results to serve the CCAR various reporting forms.
• Worked extensively with SME's including heads in areas of fixed income derivatives, options, foreign exchange (FX)
• Responsible for handling inter-bank communication related to exports through SWIFT messages.
• Used the Waterfall methodology during the whole SDLC, facilitated daily scrum meeting and ensure the integrity of the process.
• Created wireframes based on requirements and refined with development team.
• Created As-Is and To-Be process flow diagrams and supported narrative documentation
• Conducted a comprehensive use case analysis to determine key features of the tools.
• Documented business requirements into Functional Requirement Document (FRD) that included Functional Requirements, Data Requirements and System Requirements.
• Modeled Use cases, Activity Diagram and Workflow Diagram using MS Visio for a better understanding of functions.
• Prepared graphical depictions of Use Cases, Business process diagrams
• Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• As business analyst analyzed and compared features analysis between BI tools like Tableau and Microsoft Power BI.
• Developed Reports againstSQL Serverdata sources and Modified existing Crystal Reports to address changes in business requirements.
• Worked on updating and enhancing daily margin processing of listing derivatives according to Dodd-Frank stipulations and ACH.
• Liaison between the Business Banking AML team, AML/KYC Operations, Compliance/AML, Controls and IT.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Cooperated project progress by tracking activity with developers and QAs for each sprint. Dedicated a good portion of time with QA team in performing front-end and back-end Regression testing.
• Implemented the DAX functions for various calculations for efficient data visualization in Power BI and Used SAS stored process created selection screens, web reports and dash boards
• Involved in testing process with end-users by conducting User acceptance testing (UAT), provided guidance to end users by creating user manual.
• Signed off progress and completion report which were then submitted to project management on a weekly basis.

Business Analyst

Confidential - Cleveland, OH

Responsibilities:

• Performed tasks within the requirements life cycle - gather high-level requirements via interviews and JAD sessions and filter those requirements into functional and non-functional specifications.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and technical lead.
• Worked with the Quality Assurance team to create Test Plan and Test Cases, integration, and system testing.
• Resposible of Mapping the Payments engine with High-performance banking for Payments- SEPA Direct Debit and SEPA credit transfer.
• Worked on regulatory reporting framework and Reporting domain projects like Basel Reporting, CCAR, and Liquidity Reporting.
• Involved in providing day-to-day support for the US treasuries, Equities, Fixed Income, Bonds, and Foreign Exchange.
• Conducted JAD sessions to gather requirements and develop Business Requirements Document.
• Created Use cases, use case Diagram, Activity diagram, and other flow charts to define the business process.
• Followed Software Development Life Cycle (SDLC) using RUP which is an iterative and incremental software development methodology.
• Prepared Use Cases based on Business Requirement and used MS Visio and Rational Rose to create use cases, activity diagrams, state chart diagrams, sequence diagrams, collaboration diagrams.
• Created wire frames and developed a prototype of the graphical user interface (GUI) and demonstrated to the stakeholders and business users and took feedback from them.
• Revised functional requirement documentations (FRD) and other core materials throughout the SDLC, making all necessary revisions for requirement refinement and defect correction.
• Reviewed Test Cases with QA and made sure all defects raised were closed.
• Used MS Word & Visio to document data flow of the AS IS process and TO BE process.
• Involved in Knowledge Management Activities such documentation of release processes, creation of FAQ for resolution of common issues.
• Responsible for ensuring smooth delivery of regular executive business AML/KYC presentations/reports and the final outputs for ad-hoc projects
• Worked heavily on SQL Server database to extract data and build Business reports.
• Worked on testing tools like HP Quality Center, Rational Rose, experienced in preparing user instruction and use cases to conduct User Acceptance Testing (UAT).

Business Analyst

Confidential - Detroit, MI

Responsibilities:

• Involved in performing GAP Analysis by identifying existing technologies and documenting enhancements to meet end state requirements.
• Worked in assistance by the team on the implementation of SDLC which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Worked on CCAR FR Y-14Q report for new FRB requirement like Disposition Loans, Disposed Scheduled Shift & Syndication Loan.
• Interacted with Architects, system and other stakeholders and created the Back-End Use Cases for Online Payments.
• Worked with the team following a structured approach to organize requirements into logical groupings of essential
• Business processes, business rules, information needs and insured that critical requirement are not missed.
• Facilitated JAD sessions by formulating and defining systems scope and objectives through research and fact-finding combined with understanding of business systems, business requirements, and industry requirements.
• Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show end-to-end business model and business process mapping exercise including swim lanes
• Used SQL queries to gather information to conduct Data Analysis on the client profile data to find missing data fields in the database and customize them.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).
• Created relationships in Requirement Traceability Matrix (RTM) linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Coordinated with the project team and testing team to revise project artifacts (use-cases website specifications, test scripts, and web content analysis) to reflect requirement changes.
• Involved in verification and validation of all issues returned from developers and involved in regression testing. participated in the process of data mapping of products and benefit systems and ensuring all data fields are functioning correctly