Sr. Business Analyst Resume
3.00/5 (Submit Your Rating)
Tempa, FL
SUMMARY
- Around 8+ years of working experience as Business system Analyst with Banking and Financial domain knowledge.
- Solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
- Having experience in Business process design, and object - oriented analysis in various industry domains such asRetail Banking,Banking services, and Fraud/Anti Money Laundering (AML).
- Experienced in SDLC methodology for Agile Scrum and traditional Waterfall. Well versed with Agile ceremonies and Agile tools (JIRA).
- Tracked bugs and reported issues and defects using JIRA.
- Experience analysing and documenting project scope documentsandSOWs, project plan, project/requirement change request forms,BRD, FRD, SDD, requirementtraceability matrix,use cases/sequence diagrams,UML,wireframes/mock-ups, end user documentation andBPMnotations
- Financial domain expertise with extensive Credit/Debit Card application experience.
- Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer,ForeignExchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements.
- Extensive knowledge in CRM tools like Salesforce, Microsoft Dynamics 365, Zoho, and other CRM platforms.
- Worked extensively with SME's including heads in areas of fixed income derivatives, options, foreign exchange (FX), futures and risk managers in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
- Strong knowledge in products like savings account, checking account, money market, Time deposits, Certificate of deposit (CDs), KYC (Know Your Customer), AML (Anti money laundering), ATM, loans, credit, mortgage, asset & liability products, cash management, ForeignExchange Internet baking, wire transfers (EFT, ACH, payments) and SWIFT.
- Extensive experience in company's property management software; prepared documents, reports, and spreadsheets related to leases, renewals, common area maintenance payments, evictions and real estate taxes.
- Extensive experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
- Working with terminals on more efficient way of collecting and managingpaymentsfrom the customers
- Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
- Experience in analysis, design of APIs in API Connect and API Manager and Experienced in ASP.NET WEB API and Web Services (SOAP & RESTFUL).
- Extensive experience in developing Use Cases, creating Screen Mock ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Prepared FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
- Worked on API documentation using Swagger tool. Analyzed domain specific API's while conducting the Interface analysis so that it interacts with the system effectively.
- Expert in MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio. Spreadsheets, graphs, charts, pivot tables, pivot charts, V-LOOKUP, Macros, advanced Excel and Access functions and formulas.
- Worked with various bug tracking tools like HP Quality Centre, Rational ClearQuest and JIRA and a very good understanding of the Defect Life Cycle.
- Highly experienced in Designing process modelling (UML) using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams and Data Modelling.
- SQL/PL SQL:Strong SQL knowledge for querying the database and proficient in developing Tables, Joins, Data Modelling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
- Experienced with ETL Informatica Power Center and other ETL tools such as data stage and creating Database objects (Tables, Views, Stored Procedures, and Triggers etc.).
- Worked with User Experience (UX) and User Interface (UI) teams while driving the functional requirements and Wireframes.
- Well versed in Service Oriented Architecture and XMLschema generation.
- Experienced in documenting REST API request and response files strong understanding ofXMLandJSON.
- Demonstrated ability to perform Root Cause Analysis, consider both the long and short-term impact of proposed solutions and develop effective solutions.
- Assisted the QA team to design Test plans and Test Cases for User Acceptance Testing (UAT), Black-box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, and Performance Testing in both manual and automation testing environment and creation of Test plans, Test cases and Test scenarios for validating it againstbusinessrequirements document.
PROFESSIONAL EXPERIENCE
Sr. Business Analyst
Confidential, Tempa, FL
Responsibilities:
- Responsible for gathering requirements after coordinating with Business users and stakeholders.
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve issues and come to an agreement quickly.
- Investigated, researched, analyzed and assessedAMLrisks in procedures, processes and proposed businesschanges.
- Worked onElectronic Bank Statement (EBS), Positive pay, ACH paymentsandWire Transfer,liquidity forecastandconfiguringandcustomizing multiple payment methodsandautomatic clearing.
- Analyzed/prepared USD high value Fedwire payments to prevent REG W violations
- Managing all treasury management products such as Internet Banking, Business Banking, Telephone (VRU) Banking, Mobile Banking, Bill Presentment, ATM/Debit cards, Remote Deposit Capture (RDC), Automated Clearing House (ACH), Positive Pay, Lockbox, Wire Transfers (Fedwire) and Merchant Services
- Accountable for gathering and documenting Business requirements and converting them into functional specifications.
- Working knowledge of Equity securities and trading life cycle.
- Integrated various profitability ratios including Profit margin, Return on Assets, Return on Equity from in house application.
- Involved in doing coding and modeling using Java, PL/SQL and Visual Modeler
- Involved in performing GAP Analysis/Impact Analysis by identifying existing features and documenting enhancements to meet end state requirements.
- Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirements.
- Provide analysis and appropriate communication to help drive strategic decisions towards the new automated liquidity Risk Reporting system (LRI); managing coordination of enhancements to the bank's strategic liquidity management.
- Designed fund settlement process using Society for Worldwide Interbank Financial Telecommunication (SWIFT) messaging protocol for trade cash settlement with custodian banks.
- Conducted analysis to improve existing User Interface and design UI prototypes to demonstrate the application UI and its workings.
- Extensively used Oracle Software Mantas for identifying and preventing any suspicious activities from multiple channels.
- Assisted inProject Managementactivities such as creating project plan, tracking open issues and coordinating cross-functional communications across multiple teams.
- Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for multiple applications.
- Defining ETL (extract, transform, and load) using SSIS service to configure packets and deploy development standards and conventions.
- Used MS Office extensively (Word, Excel, Visio, Power Point, Outlook, and Project) for graphs, presentation and documentation throughout the project and Used SQL for Data Analysis.
- Prepared Use Cases, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams according to the UML methodology.
- Developed Test Plan with Test cases and test scripts to test all business and functional requirements are met.
- Provided business support to conduct User Acceptance Test (UAT)
- Created PowerPoint presentations and project updates using MS Project for management review
- Communicated and interacted with Development teams across multiple groups to ensure integration of AML application with multiple applications.
- Created PowerPoint presentations and project updates using MS Project for management review
- Validated the Test Cases against the functional requirements.
- Prepared and documented Use-Cases using UML based on requirements gathered from stakeholders.
Business Analyst
Confidentia, NY
Responsibilities:
- Collectedbusinessrequirements frombusinessusers, which provided appropriate project scope for the technical team to develop prototype and the overall system.
- Created a development plan for the overall project, including the coarse-gained project plan, showing iterations and evaluation criteria for each iteration.
- Responsible for Freight tracking, documentation, MIS analysis and resolution of issues of the customer satisfaction.
- Helped customers in increasing the shareholder value and broadening lending and deposit base.
- Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement
- Worked on MS CRM Dynamics for handling the customer claim inquiries, Validation and Case Creation.
- Enabled Harris Bank to operate on one data processing system by converting checking, savings and money market accounts off of theMetavantesystem and on to the FIS Systematics' application, IM.
- Conducted intensive data analysis over in scope databases and created various coverage documents to support the project initiation Phase.
- Created BRD, FRD using JAD sessions and used UML forBusinessProcess Modeling, Use Cases, Activity Diagrams, Wireframe prototypes and documenting them using Microsoft Visio.
- Responsible for conducting assessment of data quality of the data leveraged by compliance processes like Trade Surveillance, AMLetc.
- Used Oracle TOAD and SQL to pull data in order to determine input for user reports
- Used Business Objects to develop and maintain a BO Universe for Financial Reporting as well as create and maintained Crystal Reports within the BO Tool.
- Coordinate user acceptance and regression testing for Oracle patching initiative, directly supporting 20 SME business users
- Documented testing objectives for surveillance alert generation and assisted in identifying gaps, emerging needs, and redundancies.
- Implemented methodologies for digital projects to ensure projects are delivered on-time, within budget, adhere to high quality standards and meet or exceed customer expectations.
- Involved in various aspects of the scrum framework, including sprint planning meetings, daily scrum meetings, sprint review and retrospective meetings.
- Documented functional specifications for OFAC (Office of Foreign Assets Control) andAML(Anti-Money Laundering) requirements under BSA (Bank Secrecy Act).
- Participated in internal banking audit OFAC compliance initiatives gathering and verifying data stream flows end to end through FIS/Metavante, ACH, Lock-box application platforms.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Ran and tested required queries and reports before publishing.
- Created data mapping document for the application after finalizing the attributes and tables with businessusers.
- Prepared sequence diagrams, data flow diagrams andbusinessprocess models that depict how the payment instruction would apply to the UI, backend services layer and General Ledger application.
- Ensured the compatibility of the newbusinessrequirements with the existing system infrastructure and developed testing scenarios to check how the system would work under different scenarios and developed acceptance criteria.
- Facilitated User Acceptance Testing (UAT) along with the Subject Matter Experts (SME) and assisted in functional testing, integration testing, and system testing processes.
Confidential -Yonkers, NY
Business Analyst
Responsibilities:
- Involved in the analysis of the existing Credit Card processing system, mapping phase according to functionality and data conversion procedure.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Involved in prioritizing the defects and writing business requirements to resolve them.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Involved in Reviewing the API specification with different stakeholders like API provider team and business owner.
- Involved in preparing tenant invoices, processed payments, and performed monthly reconciliations.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
- Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
- Utilized SQL queries for data validation and report generation; worked with XML, Json, SOAP UI, SOAP REST and JIRA.
- Expert in MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio. Spreadsheets, graphs, charts, pivot tables, pivot charts, V-LOOKUP, Macros, advanced Excel and Access functions and formulas.
- Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
- Involved in developing Systems Specifications document to define the impact of the new requirements on the existing system.
- Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
- Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
- Worked closely with the QA and testing team and assisted them with creating various test scenarios and test cases for User Acceptance Testing to ensure that the system provides business value and caters end user needs and tested API using POST, PUT, GET, DELETE on API testing tool Postman and documented the same.
- Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
- Co-ordinate User acceptance testing (UAT) performed by the business users.
- Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
- Involved in conducting review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
Confidential, Tampa, FL
Business Analyst
Responsibilities:
- Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
- Collaborated in building a business process model using Rational Rose, RequisitePro, and Visio.
- Involved in business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
- Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
- Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
- Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements by using Power Designer.
- Involved in extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issue.
- Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
- Gathered user and business requirements through interviews, surveys, prototyping and observing from Fixed Income Portfolio Managers/Advisors. Stored and modified requirements in MS Word.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
- Involved in performing requirement analysis, went through all the use cases and issue logs.
- Involved in customer's risk in terms of propensity to commit money laundering, terrorist finance, or identity theft.
- Provided clear and concise technical documentation regarding requirements management plans, Technical Requirements, supplemental Requirements, Test Plans and Test Cases.
- Executed several Optimized queries in SQL on this data.
- UsedRequirement Traceability Matrix(RTM) for mapping requirements to test cases usingJIRA.
- Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements by using Power Designer.
Confidential, Dallas, TX
Business Analyst
Responsibilities:
- Interacted with Business Users to conduct thorough Requirements Analysis.
- Reviewed and analyzed the business environment and identified process improvements.
- Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
- Worked on activities with project manager and various other teams using MS Project.
- Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
- Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
- Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
- Worked on SDLC, Business analysis, Gap Analysis and Quality Assurance of application software in Agile framework.
- Helped in testing activities by developingTest plans, Test cases, Use Case ScenariosusingJIRA.
- Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
- Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Involved in developing Test Plans and Test Cases according to Business Requirements.
- Acted as User Acceptance Testing coordinator, monitored business testing, and interfaced with the development team regarding defect status and fixes on a daily basis.
- Involved in generation and execution of SQL queries.