Sr. Business Analyst Resume
4.00/5 (Submit Your Rating)
Columbus, GA
SUMMARY
- 8+ years of extensive experience as a Business/Systems Analyst in business requirement gathering and analysis, business process re - engineering, object-oriented design and modeling and project management in Banking/Finance,
- 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 and Energy sector,Banking services, Investment banking, Wealth management and Fraud/Anti Money Laundering (AML).
- Hands on experience on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and Fedwire.
- 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.
- Experienced in SDLC methodology for Agile Scrum and traditional Waterfall. Well versed with agile ceremonies and agile tools (JIRA).
- In-depth knowledge in theInvestment Banking Industry, Project Finance, Credit Card Industry, Mortgage Loan Origination, Loan Servicing, Treasury Services ACH, Wire Transfers etc., Brokerage Services, Commercial Banking, Retail Banking, Asset Wealth Management, Liquidity Risk,Cash Management, Capital Marketriskand Credit Risk Fundamentals
- Experience on Azure Data Service and Products: Data factory, Data Lake,Azure Batch, Dockers, Kubernetes, Virtual Machines, Azure express route, Azure traffic manager.
- Strong knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
- Highly experienced record for deliveringBanking & Finance Project for Retail & Commercial Banking- Mortgage Loan Origination, Digital Banking(Online Account opening Retail) & Risk & Regulatory(Liquidity coverage ratio, CCAR ), Knowledge inBasel I, II, IIIwith primarily Agile framework Implementation.
- 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 Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
- Extensive experiences in Investment Banking projects specialized in Securities Trading, and wealth management and risk management.
- Provided expertise and knowledge across various banking system modules covering transactional accounts, Fixed Deposits, Loans Personal Mortgage, Document management, Data warehousing, EFT ATM, Credit Cards, Insurance, Credit Scoring/Risk, Anti money Laundering, Fraud, IVR, File Manager, General Ledger reconciliation, Web, digital and other core modules.
- 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 API's in API Connect and API Manager and Experienced in ASP.NET WEB API and Web Services (SOAP & RESTFUL).
- Experience in conducting due diligence reviews on individual and business accounts and update KYC profiles in accordance with KYC requirements.
- Extensive experience in developing Use Cases, creating Screen Mock ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- 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.
- Highly experienced in Designing process modelling (UML) using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams and Data Modelling.
- 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.).
- 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.
- Transformed business requirements into functional specifications, focusing on workflow analysis and design, user interface - UI design, and process flow modeling.
- Expert in MS Office Products such as Word, Excel, Project, Power Point, Access, Visio.
PROFESSIONAL EXPERIENCE
Confidential, Columbus, GA
Sr. 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.
- Worked on Ad hoc processes including but not limited to import duty payments, invoice payment cancellation, check handling, invoicing contract language reviews.
- Documented AS-IS (current) to TO-BE future state processes.
- Communicated project requirement, business issues, solutions and made recommendations for implementing changes to corporate programs and corporate Card related policies regarding corporate Cardpayments, application queries and other related issues. Accumulated system requirements from various departments through surveys and interviews.
- Collaborate with business stakeholders, technology team, and vendors to conduct BRD walk through, JAD sessions, Technology grooming, IAD logs, Wireframe designing and testing business scenarios.
- Worked with Portfolio managers of Asset/Wealth management group to gather requirements about performance measurement attributes of various assets class.
- 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.
- Involved in the root cause analysis and proposed new business requirements related price verification of Securities, Loans and Derivatives.
- Conducted quarterlyData Owner meetingsto communicate upcomingData Governance initiatives, processes, policies and, best practices.
- Responsible for handling inter-bank communication related to exports through SWIFT messages.
- Actively engaged with various stakeholders such as the client on-boarding KYC teams, Compliance and Business to ensure all AML requirements were fully captured in the Actimize AML System.
- Involved in Software Development Life Cycle (SDLC) documentation, such as a Business Process Description (BPD) and Functional RequireWorking in anAgileTeam for the Enterprise repository & Data Governance arm of the Non-retail business, utilizing JIRA and confluence to conduct daily standups, new intakes and refining sessions with the Scrum Master.
- Set up and facilitated meetings between Electronic Fraud Mitigation department and various business partners, such as Audit, Risk, Corporate Security, and AML, to progress with projects and close Audit findings.
- Helped the Product Owner to create user stories in JIRA and prioritize them based on business value.
- Draft and prepare Suspicious Activity Reports (SARS) Conduct internal fraud investigations of retail and correspondentbankingcustomers' account statements, cash, checks, ATM, ACH, andwiretransfers by reviewing client transaction.
- UsedAzure Enterprise integration Service-SQL Server Stretch Databaseto migrate transactional database with cold data securely toAzure Cloud.
- Worked withthe clienton their Data Governance Strategic Planning initiatives and developed a Unified Data Model.
- Responsible for data analysis and reporting to Management. Used MS Access, MS Excel, MS PowerPoint, MS Outlook, MS Visio, MS Word, SharePoint, Pivot Tables, V-Look Ups, data warehouse, Support Central and advanced reporting functions to develop and manage data reporting.
- 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.
- Involved in providing day-to-day support for the US treasuries, Equities, Fixed Income, Bonds, and Foreign Exchange, Derivatives (Swaps, Future, and Options).
- Worked with all front office systems in ensuring the smooth implementation of trade processing using SWIFT messaging and other protocols for settlements.
- Handling first level escalated complaints and request raised by the commercial loans like equipment finance, project loan, working capital business loan, asset backed loan, line of credit etc.
- Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams DFDs, ER Diagrams using Rational Rose and MS Visio, MS Word and thus defining the Business Process Model and Data Process Model.
- Created Data Migration Checklist and Data Migration plan to transfer data to target systems by defining data transformations to be undertaken for successful data migration into Azure SQL Database.
- Worked on Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
- Maintained key records for purposes of Compliance review, QA/QC, and/or regulatory inquiry. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Validated the API and Web methods using tools like SOAP UI, Jason viewer and REST client for Engine Service, Paid Loader Service and Payment Manager Service.
- 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.
- Actively participate in conducting review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
Confidential, San Francisco, CA
Business Analyst
Responsibilities:
- Worked on Front to back office, worked with fund managers, financial advisors and technical team members.
- Gathered Fraud/AML data requirements from Net Economy and customized them for USA financial institutions such as banks and credit unions.
- Worked with PM to coordinate daily activities between applications development and Product Management.
- Responsible forEnterprise Data Management “Data Governance Analyst” duties; Working with senior leadership in setting strategic priorities, setting milestones, reviewing progress,writing and documenting data policiesand control policies, and reporting status.
- Worked with SWIFT to reduce the cost and to apply reusability and standardization.
- Analysis, review and preparation of process systems and controls for OTC derivatives and cleared trades, securitization exposures and risk rating (PD) frameworks.
- Wrote SQL statements to extract data from the Tables I performedextensive testing on APIfor ensuring accuracy of backend services.
- Participated in gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
- Supported and mediated implementation of the bank's digital products for retail line of business and managed consumer digital banking platform Involved in migration and enhancements to the Online and Mobile Banking platform.
- Extracted data from company's current softwareALSusing SQL to build queries AFS Automated Financial Systems used primarily for commercial construction loans.
- Responsible for the production of BRD, PDD and SRS for the banks critical and high priority systems and for FI, FX, Equities, Repos and Derivatives.
- Actively participated in Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
- Responsible for gathering requirements for transmission of all ACH (Payroll & Corporate payments), initiation of outgoingwiretransfers for small businessbankingcustomers using latest Fiserv vendor product. Involved in REST HTTP standard, Domain naming standard for REST API design.
- Experience in troubleshooting CDD and WLF alert issues and working with Actimize/Oracle Mantas/Norkom/SAS AML Professional services and identified and reported trends of fraudulent inquiries to senior management.
- Successfully completed multiple debit and credit card projects across Digital and Mobile banking Channels.
- Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
- Expedited root cause analysis for the Data Governance Team by assuring the authentication of metadata, detailed reports and priorities of data quality issues among various lines of work.
- Used JIRA to generate and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories, Impediments list, tasks, and defects.
- Designed and developed all Use Cases and UML models using Rational and Visio.
- Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
- Prepared detailed design documents to translate business process effectively for developers and product managers using MS Word and MS Visio.
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
- Involved in Risk Assessment for each project. Extensively performed UAT, Reported all bugs and defects to the development team.
- Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.
- Served as team liaison and driving deliverables on all special regulatory change projects and process enhancements for the team.
- Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
Confidential, Boston MA
Business Analyst
Responsibilities:
- Involved in the analysis of the existing Credit Card processing system, mapping phase according to functionality and data conversion procedure.
- Worked as Business Analyst for Asset Servicing division Involved in driving the SWIFT Standard implementation affecting business operations for Cash Management Payment Services, Settlement Reconciliation and Corporate Actions.
- 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.
- DevelopCustomer Database Mapping DocumentandDigital Transactions Mapping Documentto map allPolicy Administration Systems
- Developed test cases to test pricing & price verification functions for securities, Loans and Derivatives.
- Worked withFinancial Analysts on Fixed Income Analysis(Pricing, Risk, Yield, Duration, and Recommended Strategy) with Excel to support trading, and reviewed with portfolio manager and traders
- Expertise in identifying and documenting detailed Business Requirements pertaining to Portfolio Management, Performance Reporting, Wealth Management, Online Retail Banking, Product Management and Transaction Processing.
- 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.
- 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
- 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, Cincinnati, OH
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, Boston, MA
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.
