We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Chicago, IL

SUMMARY

  • Over 9 years of diverse experience as a Business Analyst in domains like Finance, Banking and Mortgage with the aptitude to work independently and in teams to meet business deliverables with a result oriented approach.
  • Strong knowledge of Software Development Life Cycle (SDLC) models (Agile, SCRUM, Waterfall, Spiral Model) & Iterative Models (RUP - Rational Unified Process).
  • Extensive experience in interacting with customers and Subject Matter Experts (SME) to gather and document business requirements across multiple business process areas.
  • Extensive experience in documenting Business Requirement Documents (BRD), Functional Requirement Documents (FRD), User Stories, Unified Modeling Language (UML) diagrams (Use Case, Activity Diagrams, and Sequence Diagrams) and validation of requirements.
  • Extensive Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
  • Strong experience in coordinating Joint Application Development (JAD) sessions and interviews.
  • Expertise in diverse Retail Banking sectors including lending, deposits, payments, cards, trade finance, treasury, KYC, AML, Payment system.
  • Strong understanding of Credit Loans, Auto Loans, Commercial Loans, Home Loans & Investment banking.
  • Strong Understanding of different mortgage instruments like Mortgage Backed Securities MBS, Collateralized Mortgage Obligations CMO, Asset Backed Securities ABS, including the tranche structuring and credit enhancement processes to manage prepayment and credit risk.
  • Experience on well-known Commercial Lending product Misys Loan IQ on all modules.
  • Experience on Loan Originating, Loan Servicing, Loan Modification, Commercial Lending.
  • Experience working on Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
  • Experienced in Cards Payment processing and Retail Banking operations like Customer Relationship Management (CRM) and Enterprise Teller (ET).
  • Strong knowledge in products like savings account, checking account, money market, Time deposits, Certificate of deposit(CDs), KYC, AML, ATM, loans, credit, mortgage, asset & liability products, cash management, Foreign Exchange Internet baking, wire transfers(EFT, ACH, payments) and SWIFT.
  • Good experience on Online Banking, Retail Banking, E-Commerce, Online Transaction Processing (OTP) and Electronic Fund Transfer.
  • Experienced working in projects including Credit cards/Gift cards test, Enterprise Payment Foundation, IWM (Integrated Workforce Management).
  • Solid understanding and knowledge of Equities, Derivatives (Futures, Options, Forwards, Swaps), and Regulatory Reporting (FRY9C, CCAR, FR2420, FFIEC Report) FFIEC, RWA, Risk Analysis.
  • Experienced in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
  • Good knowledge of different financial services include commercial banking, middle-market lending, asset-based lending, leasing, cash management and trade finance.
  • Excellent knowledge in Corporate Finance, Wealth Management, Derivative products such as Options and Futures, Swaps and Swap Options involving Credit and Interest rate and other OTC derivatives, Fixed Income, Trade Life Cycle, OMS (Order Management Systems), FIX protocol, Section 508.
  • Sound knowledge with investment banking, Regulatory Compliance, regulatory reporting regulations like Basel II Accord.
  • Domain knowledge of Fixed Income Securities, Money Market instruments, Capital Market Securities, Treasury, Brokerage, Performance and Risk analytics, Legal and Compliance.
  • Experience working with Electronic Claims clearing houses like Automated Clearing Houses (ACH) for electronic payment, remittance data processing and services.
  • Proficient in evaluating SQL queries for data extraction, Data mapping, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), and Data Warehousing.
  • Experienced with Data Analysis using Excel and SQL as the querying interface. Excellent working experience with SQL Server.
  • Hands on experience as an expert user of MS Excel, MS Visio, MS PowerPoint, MS Access, Business Objects.
  • Good experience of working with various bug tracking tools like HP Quality Center, Rational Clear Quest and JIRA and a very good understanding of the Defect Life Cycle.
  • Experience in assisting DBAs to create Data Model by designing conceptual data model and entity-relationship diagrams (defined entities, relationships, and attributes).
  • Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
  • Experienced in implementing basic SQL queries for QA testing and report / data validation.
  • Experienced in preparing and documenting User Acceptance Test (UAT) plan and obtaining the necessary signoffs from the concerned business units.
  • Expertise in designing and developing Test Plans and Test Scripts.
  • Experienced with QA Team in defining the Test Plans, Test Cases and test execution.

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. Business Analyst

Responsibilities:

  • Worked on Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
  • Organized many Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), workshops and sessions with end-user/clients/stake holders and the development group.
  • Collaborate in a large scale, low level infrastructure assessment. Gathering requirements, current state, gaps and develop road map for the project.
  • Worked under project manager in developing project plans & scope, clarifying project requests, providing root cause analyses, sharing best practices, and presenting findings and proposals in a professional format.
  • Involved in creating and updating Guidelines document (Styles, Font, and Margin etc.) to apply on all the required Forms.
  • Managing Identity & Access Management (IAM) tool training for application managers as part of the on boarding process for the GIS program, critical for business audit/compliance to address enterprise governance inquiries.
  • Maintain effective relationships with various system administrators and development teams supporting the IFC Treasury desk front, middle and back office operations.
  • Involved in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
  • Work closely with Financial Advisors, as well as organizations such as Capital Markets, Mutual Funds, Advisory, Risk, Compliance, Legal, Operations and Technology.
  • Based on analysis of legacy Forms data and stakeholders need interacting with Guide wire team about Cov Term patterns and coverage type (Electable, Required, Suggested) to print on Forms.
  • Assisted the project manager in preparing the project schedules, milestone tracking, and resource allocation using MS Project.
  • Brought digital campaigns to life by collaborating with agencies, Brand Marketing, Social and Traditional Media, Legal, and Public Relations teams.
  • Identified, researched, investigated, analyzed, defined and documented business processes, also worked closely with technical leads, information architects, and SQL developer team.
  • Wrote Use Cases, Test Cases and created Requirement Traceability Matrix (RTM) to track all documents like Technical Design Document (TDD), System Application Development (SAD).
  • Prepared Business Object Models and Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
  • Partnered with digital agencies to ensure messaging and look and feel of creative stayed true to brand voice.
  • Develop and maintain documentation, BI dash boards and reports.
  • Worked on various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
  • Building customized request forms based on client-driven requirements, testing system enhancements and obtaining client UAT sign-off prior to production environment roll-out.
  • Conducted functional walkthrough sessions to educate teams with ongoing developments.
  • Developed process flows for user authentication, password requests, login creation etc.
  • Created Class Diagrams, State Diagrams, Sequence Diagrams, use cases using MS Visio.
  • Performed GAP analysis to identify the discrepancy between what is and what should be in the website layout and then developed a plan to close the gap.
  • Documented Test Scripts, Test flows, Test performance using MS Word and MS Excel.
  • Reviewed test scripts for the new functionality by working with offshore team, reviewed test results and performed User Acceptance Testing (UAT).

Confidential - Chicago, IL

Business Analyst

Responsibilities:

  • Worked with key project stakeholders and business partners to plan and convey business vision for capital projects.
  • Participated in review and analysis of business requirements, adding additional cases as needed, insuring they are complete and testable.
  • Worked in Agile development environment and guided the team to document epic and stories and requirement maintenance using tools like JIRA and Confluence.
  • Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
  • Regularly holding sessions with Lines of Business (LOB) to document, implement and maintain the metadata and business rules for the bank's data, beginning with the data required for CCAR.
  • Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
  • Defined various processes for Banking Domain such as Account Opening for Savings Bank, Current Account, Term Deposits, Insurance products, Bill Pay Services etc.
  • Created User Stories for Web Service API's needed to address the new UX flow. Defined the data elements for the API's in the functional specs document.
  • Provide tactical, strategic systematic and manual solutions to ensure all modules on Client On-Boarding, Withholding and Tax -reporting are FATCA compliant.
  • Worked on the credit approval system that was responsible for granting credit approval for loans.
  • Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
  • Support the assessment of CCAR IHC report preparation environment.
  • Prepared the CCAR reporting schedules (FRY 14A/Q) on certain periodic basis.
  • Involved in identifying AML/KYC norms for specific country and created configuration templates for daily investigating/monitoring of alerts on all transactions based on threshold for Actimize department.
  • Created process documentation and flows for the business units by working closely with individual teams to determine a strategy and implemented the core documents into a central Share point repository.
  • Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
  • Created and updated LOB end-user system documents.
  • Closely collaborate with development team to architect best practices for API platforms.
  • Assisted managers and Analyst to script the Business Plan to analyze portfolio risk-reward ratios, evaluate completeness and accuracy in firm's financial information and advice on short or long-run investment strategies.
  • Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
  • Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
  • Involved in coordinating with the database design team, using SQL to Query databases and providing inputs in finalizing the data model, report layouts.
  • Generated data mapping documents from production databases to the warehouse.
  • Reviewed test cases written by QA team and ensured all the functionalities are being tested thoroughly.
  • Worked with the QA team on defining QA process and overlooked the entire QA process.
  • Extensively used JIRA to track defects and project activities.
  • Produced clear user manuals & training guides for User Acceptance Testing (UAT) and deployment for end-clients with step-by-step instructions and appropriate GUI screenshots.

Confidential - Cleveland, OH

Business Analyst

Responsibilities:

  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Conducted meeting sessions with committee of SMEs from various business areas including Loan Monitoring and Marketing.
  • Excellent Knowledge of Customer Segmentation, Portfolio Analysis/Mgmt, FDR processes and FICO Score generation.
  • Conducted interviews with key business users to collect requirement and business process information.
  • Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
  • Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Analyzed and translated business requirements into system specifications utilizing UML.
  • Co-ordinated with documenting processes used agile methodology to write the Business Requirements documents and designed Functional specifications.
  • Created Project Initiation Document (PID) and defined the scope for an over-arching Basel II Readiness project, to encompass all other Basel II projects within the enterprise.
  • Collaborated with Basel II team on credit risk analysis and issue resolution.
  • Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II.
  • Reviewed business requirements document for ACH (automatic clearing house) through interviews, surveys, prototyping and observing from senior managers and UI (User Interfellace).
  • Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
  • Conduct training on Endur modules Front Office, Middle Office, Back Office & Operations for commodities trading, risk, supply & distribution and Treasury Management.
  • Gathered knowledge on Home Loans Point of Sale and LoanOrigination system, Product guidelines - Conventional, FHA, VA, Underwriting guidelines, Interfaces like Ernst Fees, Fraud Guard, Flood, Mortgage Insurance, SDX, Wolters Kluwer (WKFS).
  • Created requirements analysis and design phase artifacts using, MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
  • Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
  • Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
  • Involved throughout the development process and verifying adherence using the requirements Traceability Matrix (RTM).
  • Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
  • Created Use Case specifications, flow diagrams, for a clearer understanding of the business process with possible alternate scenarios for the business team and the developer.
  • Worked on queries database using SQL.
  • Worked with data quality governance teams to ensure each work-stream and project within the Basel II framework adhered to strict data quality and maintenance standards.
  • Provided end user production support for Empower LOS trouble shooting issues and writing up defects (Underwriting Lead).
  • Prepared Test plans which include an introduction, various test strategies, test schedules, QA team’s role, test deliverables, etc.
  • Worked with development team and customized batch and real-time client interfaces supporting Money Transfer, Automated Clearing House (ACH) and credit card processing.
  • Wrote User Acceptance Test Plan based on business users’ requirements and reviewed Test Plan templates.
  • Delivered and maintained extensive documentation for future extendibility of the system.

Confidential - Chicago, IL

Business Analyst

Responsibilities:

  • Working with clients to better understand their needs and present solutions using structured SDLC approach.
  • Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
  • Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
  • Worked on Development and Support activities like Acquisition, Delivery, Crystallization, Synchronization, and Workflow etc., which involved creating new consolidation rules using formula engine language.
  • Worked on enabling automated transfer by enhancing flexibility, and straight - through processing (STP) of payment initiation, clearing and settlement transactions using ACH, wires, and/or checks by aligning the ISO 20022 XML messaging standard with Automated Clearing House formats (CCD, PPD, CTX) and SWIFT MT standards (MT103, MT202).
  • Build and customized the loan IQ feed for Treasury downstream and also a reverse feed from treasury to capture the Money cost rates and currency conversion rates.
  • Was part of a major team in application solutions for new product development i.e., Hedge Fund, Exchange Traded Funds, home loan portfolios; including administration, operations, compliance, client facing analysis and reporting.
  • Interacted with Loan IQ operations individual for creating various transactional reports which capture cash flow transactions, reprising frequencies, index and spread rates.
  • Coordinated with different agencies in tracking the progress of the software development and resolving the issues and worked with the UI team to create the User Interface Mock-ups to be presented to the Business.
  • Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.
  • Enhanced procedures and controls throughout the accounting department, processing journal entries and performing accounting corrections to ensure accurate records.
  • Created Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Tracked change requests and monitored workload and schedule.
  • Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling.
  • Authored progress and completion report which were then submitted to project management on a weekly basis in MS project.
  • Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences.
  • Conducted JAD sessions with management, SME, users and other stakeholders for open and pending issues.
  • Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
  • Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
  • Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
  • Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
  • Comprehensive experience in writing Test Plans, Test Cases and Test Scripts.
  • Collaborated with Quality Assurance Analyst in manual testing.

Confidential - Jersey City, NJ

Business Analyst

Responsibilities:

  • Liaison between stakeholders, system users, clients and managers, software development team and the QA term to gather requirements.
  • Involved in the facilitation of (JAD) Joint application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
  • Involved in Requirement Scoping and analyzing high priority requirement for implementation.
  • Studied and analyzed competitor's applications and brainstormed to gather effective requirements for a quality product.
  • Created Business Requirements Document and converted them into System Requirement specifications document.
  • Followed the RUP methodology right from inception to the projects transition.
  • Coordinated with the development team, database team, data warehousing team and QA team throughout all phases in the RUP methodology.
  • Worked on business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.
  • Analyzed Requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect.
  • Learned how to create and manage project templates, use case project templates, requirement types and traceability relationship in Requisite Pro.
  • Interacted with QA Team in writing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application.
  • Archived all project documents and implemented the UCM model for activity-based Configuration Management using Clear Case.
  • Used Rational Clear Quest for defect tracking and change management request and reported them.
  • Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Hire Now