Sr. Business Systems Analyst Resume
3.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY
- 8+ years of Industry experience as a Business Systems Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping, Functional design and documentation, Evaluating Data Analysis, Data Mapping, Translating Requirements into Specifications and Application Design.
- Expertise in working with card processing and banking industry, financial institutions, Risk Analysis, Financing structures, Capital management, Portfolio Analysis.
- Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile Scrum and Rational Unified Process (RUP).
- Strong exposure in store and credit card processing / Debit Card accounts and processing transactions. Having strong domain knowledge in application catering to banking/Credit cards / mortgage business. Familiar with full life cycle of credit cards applications for different banking systems. Have strong knowledge in following phases of credit cards life cycle. Good knowledge of Wealth Management Accelerator (WMA), Wealth Management
- Experienced in developing process/sub - process/activity flows profiles in design of new applications and integrating the ITIL controls at initial and detail design- level. Developed policies and procedures to align with new /updated processes and comply with current laws and regulation SOX.
- Worked on projects encompassing Portfolio Management, Wealth Management, and Trade Order Management.
- Responsible for supervisory oversight and control of the processes and data quality for all Fixed Income derivatives product types and life-cycle events for both onshore and offshore teams.
- Served as an analyst providing guidance and advice to team members on account management, bids and designing effective solutions.
- Works across digital teams, such as web development, digital marketing & communications, web merchandising, and copy teams to prioritize and implement improvements to user experience based on analytic findings.
- Expert in gathering project requirement, business issues, solutions and made recommendations for implementing changes to corporate programs and corporate card related policies regarding corporate card payments, application queries and other related issues.
- Extensive experience on API development with micro-service architecture and orchestrator.
- Good understanding of trading process. Prepared Use Case Diagrams to explain the business requirements for Trading Customer with the options to buy or sell Foreign Exchange.
- Hands on experience with the complete front to back trade lifecycle. Front Office Derivatives Trading (Trade Capture, Trade Valuation, Swap Pricing and Valuation, Trade Execution, Clearing, Margin Management and Back Office (Trade Matching, Trade Reporting, Confirmations/ Affirmation with Derive SERV).
- Excellent in conducting JAD sessions with Stakeholders, SME's, and User Interface Leads, QA analysts to discuss issues and to resolve them.
- Hands on experience in designing and implementing of new FDA modules using T-SQL (Sybase database development tasks) for Database Platform.
- Having knowledge in the imaging and digital channels like online banking, online transactions and digital accounts processing and online solutions for the customer queries.
- Experienced in API testing and documentation using Postman and Swagger to check if the API's are returning the data in JSON, XML format as defined in the API documentation and required by workflow and experienced in documenting Web-services/API’s manually in MS Application and using markdown language/editors.
- Provided suggestions to User Interface Leads on converting the use cases into Wire frames.
- Ability to manage multiple concurrent projects through complete life cycle from requirements to implementation.
- Vast experience in performing SDLC tasks - Requirement gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
- Experience in Using JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
- Proficient in process flows, specifications and diagrams for system integrations (internal and third party), data mapping and APIs. Knowledge of middleware, databases and web site reporting technologies.
- Strong understanding of risk control; including Value at Risk (VAR), Anti-Money Laundering (AML), Bank Secrecy Act (BSA), and Know Your Customer (KYC).
- Experience in creating Business Requirement Document, Functional, User Stories and Non-Functional Specifications.
- Good Knowledge in writing SQL queries, table Joins and understanding Database concepts.
- Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, and XML, Flat files into the staging area and Design ETL processes that span multiple projects.
- 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. Experience in Creating and Maintaining the Requirements Traceability Matrix (RTM).
- Expertise in implementing Test Plans, Test cases, Functional testing, Regression Testing and Integration Testing. And maintaining Requirement Traceability Matrices for baseline documents.
- Strong Knowledge in Facilitating onboarding and creation of file feeds for benefit admins to submit weekly/monthly enrollment data, and initialized internal systems to receive, decrypt, and process new EDI text files.
- Possess In-depth knowledge of software QA methodologies and Strategies like Waterfall and Agile Scrum.
- Experience with the ability to build relationships and work collaboratively as a team member with outside divisions and department.
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
Sr. Business Systems Analyst
Responsibilities:
- Involved in review, analysis, and evaluation detailed business and functional requirements, documentation, request of proposal and request for information, process flows and data models of Fidessa CTP migration project including project charter, project deliverables, cost/benefits analysis, scope and control.
- Obtained and verified financial information, such as applicant's credit rating and income level.
- Managed consumer digital banking platform Involved in migration and enhancements to the Online and Mobile Banking platform.
- Communicated directly with mortgage banker, customers, agents and attorneys to achieve an ideal customer experience
- Worked with different teams (i.e., Business, IT, Foreign Exchange, etc.) to analyze, design and develop business solutions
- Worked closely with Quantitative Analysts to design and implement new Stressed VAR model and Advanced Monte Carlo Simulation method.
- Good knowledge in Corporate Finance, Investment Banking, Credit Risk, Asset Management, Wealth Management, Margin Accounts, Risk Management, Investment Products.
- Elicited business and functional requirements using in interviews, document analysis, business process descriptions, use cases, business analysis and workflow analysis with the use of Waterfall and Agile methodologies
- Worked on developing a new Credit Card processing application which was all automated and replacing existing system
- Working closely on emergency Card processing and coordinating with vendors till the time the corporate cards are delivered to the card members.
- Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
- Supervised a team of five analysts, interviewed Stakeholders to gather requirements and performed feasibility analysis of their needs during the deployment of the Bank’s Online and digital Banking Solutions to top tier customers.
- 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.
- Well - versed in Oriented Analysis and Design using Unified Modeling Language (UML), Rational Unified Process (RUP), and Waterfall cycle, Rational Rose, Requisite Pro, Rational Clear Case and MS Visio.
- Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
- Worked with the ERP tool and creates the test cases, test scripts and perform user acceptance testing.
- Performed data validation testing using SQL queries to validate data. Reviewed the vendor API to reduce stock issues.
- Involved and reviewed API only user for performing regular updates from legacy system using REST API.
- Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk. Project requirements for cash management practices adhered to accounting principles or GAAP and IFRS.
- Exposed to Agile methodology Performed Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
- Worked closely with various business departments including Credit Risk Reporting group to understand Dodd Frank requirements to report consolidated credit exposure and limits at single counter party level.
- Worked with developers in writing of complex SQL queries to resolve data issues in source system databases.
- Determined functional requirements through conducting user interviews and created business requirement document (BRD) and traceability matrix, and thus develop standardization of processes.
- Worked with SOX control owners and auditors to ensure compliance and improve business processes.
- Worked as a liaison between developers and QA team in creating Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible.
- Involved in creating class diagram, sequence diagram, and collaboration diagram using MS Visio.
- Supported development team in unit testing by providing testing data during User Acceptance Testing (UAT) phase.
Confidential, Auburn, MI
Business Systems Analyst
Responsibilities:
- Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies.
- Provides the most comprehensive and adaptable digital retail banking platform and innovative solutions designed to help banks and credit unions.
- Successfully completed multiple debit and credit card projects across Digital and Mobile banking Channels.
- As a Business Solution Analyst for Centralized Card Processing initiative, responsible for identifying and defining the interface system, data and vendor requirements from the GAP identified from current and future process to implement a reconciling system for debit card and gift card transactions.
- Executed all aspects of business analysis, reporting, database management, and financial analysis. Conducting Smoke Testing, UAT testing, User Interface testing, functional testing, Integration testing, Regression testing, Back- end testing, UI testing, Parallel testing, Rules testing.
- Worked on Requirement analysis with business analysts and attending Agile/Scrum model meetings to review the requirements and scope API testing validates the JSON output with the expected output, and also compares the JSON output with XML input.
- Deep understanding of Investment Management, wealth Management, Prime Brokerage Services, Money and Capital Market Instruments.
- Responsible for writing the Business Requirement Document for the Intercompany Reconciliation project which reconciles trades between the Booking Legal Entity and the Counter Party Legal Entity on maturity and currency level.
- Confirming integration of Order Management System and Work Order Management System.
- Elicited business and functional requirements using in interviews, document analysis, business process descriptions, use cases, business analysis andworkflowanalysis with the use of Waterfall and Agile methodologies.
- Involved in providing XML samples, Business purpose of the APIs, on boarding sheet, etc. to key resources belonging to different system modules. Facilitated Connectivity Setup & Connectivity Testing with Infrastructure Team.
- Followed the Waterfall Model of software development implementing the Six Sigma methodology.
- Designed various report layouts of different source systems that are built on the data marts based on the user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
- Managed the workflows and dependencies of teams external to the Onboarding/KYC Team. Completed daily CSE confirmation matching of proposals, mismatch, host one-sided, Counter Party (CP) one-sided, and risk mitigated queues. Utilized CSE work item manager and CSE search application tools.
- Involved in development phase meetings for Business Analysis and Requirements Gathering.
- Close elicitation and presentation with senior management team members and client senior executives to help understand the complexity of the requirements and designs.
- Great effort in regression testing the information or data using SQL skills, data governance and carrying data stewardship skills creating data dictionaries.
- Creating data flow diagrams and data mapping for various processes in the project life cycle.
- Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.
- Data flow diagrams, entity relationship diagrams created for projects across various program initiatives.
Confidential - Columbus, OH
Business/ Systems Analyst
Responsibilities:
- Experience in managing projects consisting multi-site/global teams, multiple platforms and changing requirements.
- Building rapport with individuals across the business enabling me to understand how the bank works from trade reporting perspective (backend to frontend reporting).
- Worked as a BA to assist in upgrading the system in the credit card processing.
- Communicated project requirement, business issues, solutions and made recommendations for implementing changes to corporate programs and corporate card related policies regarding corporate card payments, application queries and other related issues.
- Supported Bank’s Digital and Retail banking customers through defining, refining, documenting, and managing the build process for software development, processes and Value-Added services.
- Conducted interviews, sessions, workshops to gather and document business requirements (BRD) and subsequently translate them into functional requirements (FRD).
- Involved in GAP Analysis; identified and documented improving areas to meet financial markets requirement regulations.
- Tracked project progress, coordinated and held meetings, reported project status to senior management.
- Documents operational objectives by working closely with business managers to study business functions; gathering information; evaluating output requirements and formats.
- Gathered and documented the business requirements into detailed business requirements document.
- Facilitated JAD sessions. Ability to identify and document critical requirements through analysis.
- Worked with the Business team in documenting the process flow for their Loan, deposit and Derivatives product booking.
- Strong knowledge of the Systems Development Life Cycle (SDLC) models such as Water Fall.
- Performed Back-End Testing, database table manipulations of relational database systems by writing complex SQL queries manually.
- Involved in executing several test cases and scripts with the testing team to test the API based feature extension on API testing tool Postman and performed black box and white box testing to test the system for bugs for further improvements
- Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
- Involved in creating UML diagrams such as Sequence Diagrams, Activity Diagrams and User Stories when needed.
- Worked with other business analysts to created, brainstormed and redesigned User Interface.
- Conducted Requirement Walkthroughs with the development and testing teams to ensure the requirements are clarified and accurate before the development and testing started.
- Coordinated series of workshops to gather, document, and finalize business requirements and proposed workflows.
- Documented and submitted for approval business requirements documents, functional specifications document, and data mapping sheets, process and business flow diagrams, test cases.
Confidential - Pittsburg, PA
Business Analyst
Responsibilities:
- Performed Requirements Elicitation by conducting interviews, surveys, workshops and created BRD and FRD.
- Interacted with Senior Management to understand their requirements regarding integration of Previous Day reporting and Current Day Reporting.
- Conducted Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
- Authored various Use Cases and UML methodology to define the Data Flow Diagram (DFD).
- Conducted AD sessions, user interviews, and detailed research and requirement meetings to capture the requirements and prepare BRD.
- Made use of REST API to integrate Previous Day Reporting and Current Day Reporting databases.
- Contacted treasury management team to understand the current user interface system for the payments section and how the ACH, Wire transfers should show up in the application.
- Involved in creating user Interface Document (UID), Wireframes, and Prototypes to help developers in the development process.
- Worked on Product and Sprint Backlog and helped Product owners with the Release plan.
- Verify the proposed regulatory controls for counter party risk mitigation, with the policy team to make sure they are at par with related regulatory requirements (e.g., Credit Risk Policy, BACA Policy, Elevated Approval Policy, Overdraft Policy, Liquidity product Policy etc.
- Participated in data quality checks and ensured correction of data quality issues from source systems and improved reference data sourcing for facility, counter party and other relevant attributes.
- Involved in design and implementation of Progression and Regression Tests and reviewed Test Plan and Test Cases.
- Conducted quick Smoke Test after each bill in testing and Planned User Acceptance Test (UAT).
- Extensively evaluated the Acceptance Criteria that was used by developers, testing team and by Product Owner to ensure that the intent is effectively captured.
Confidential, Chicago, IL
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.
- Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
- 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.
- 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 maintaining requirements traceability matrix (RTM) to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan using JIRA.
- 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 daily.
- Involved in generation and execution of SQL queries.
