Business Analyst Resume
CA
SUMMARY
- 9+ years of professional experience as a Business Analyst within Finance and Banking domains.
- Extensive experience in analysing and requirements gathering and writing system functional specifications including use cases.
- Excellent in Developing and evaluating business process Models.
- Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
- Deep understanding of enterprise data warehouses.
- Strong experience in RUP Business Modelling process.
- Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
- Extensive experience in Card services companies, Payment processing companies, Mortgage services, Investments, Insurance, Payroll, Banking domain, Retail, commercial and corporate lending.
- Specific domain knowledge and experience in the asset management, capital markets, investment banking, retail & corporate lending, risk and regulatory reporting, accounting, treasury and mortgage lending
- Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
- Excellent in Developing and evaluating business process Models.
- Used Query Analyser, Execution Plan to optimize SQL Queries.
- Extensive experience in requirements analysis, requirements documentation (including functional requirements, workflows, use cases, user stories and acceptance criteria in Agile, and other documentation technologies), requirements management, process decomposition diagrams and process flows, and generation of detailed specifications for database design and algorithms for subsequent coding.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera,
- Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Strong visual modelling and business process modelling skills using Rational Unified Process (RUP) and Agile Unified Process (AUP) with tools like Rational Rose, MS Visio.
- Well experienced in developing Use Case Models, Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD), Activity Diagrams, Sequence Diagrams and UML CASE tools.
- Developed Data mart to consolidate multiple databases in order to make reporting simple
- Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Query Analyzer and SQL Navigator.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
- Professional experience in business analysis, operations management and development, design, documentation and testing.
- Experienced in implementing Software Development Life Cycle; Waterfall and Agile projects
- Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
- Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
TECHNICAL SKILLS
Requirements management tools: JIRA, SAP Power Designer, IBM Rational RequisitePro, LoadRunner
Document management tools: MS SharePoint, Confluence
UML and prototyping tools: MS Visio, SmartDraw, IBM Rational Rose, Balsamiq mockups, iRise
Operating Systems: MS Windows, Mackintosh, Linux, Unix
Test management tools: QC, JIRA, HP ALM (QC), Microsoft Test Manager (MTM) and RationalClearQuest, HP UFT
Business Intelligence tools: Excel, Tableau
Languages: R, XML, SQL, HTML, VBScript
Databases: MS SQL Server, DB2, MS Team Foundation Server (TFS)
Methodologies: Agile (Scrum), Rational Unified Process (RUP), Waterfall
Others: MS Word, MS PowerPoint, MS Access, SAP MM, WMS, Toad, VBScript
PROFESSIONAL EXPERIENCE:
Confidential - CA
Business Analyst
Responsibilities:
- Created presentations to communicate the results. Supported the modelling of strategic financial plans to ensure reliable and comprehensive budgets, stress tests and forecasts for both internal and external stakeholders, capturing all dimensions of the Corporate Lending business (Balance Sheet, Profit and Loss, Capital position and Cashflows).
- Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed
- Securities
- Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
- Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
- Performed data and cost analysis using account payable data
- Involved in Six Sigma process analysis.
- Developed a well-rounded knowledge of wealth management through working directly with an experienced advisor in a small firm
- Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
- Designed and implemented SCEIS SAP Report Manual
- Involved in Corporate Lending module as Single Point of Contact for the engagement
- Involved depth understanding of Credit Risk management for the application
- Conducted interviews with end-users to collect requirement and business process information.
- Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches
- Responsible for active wealth management and relationship deepening to increase team revenue.
- Configured the Automatic Payment Program for account payables including partial payment. Generated business intelligence by utilizing rawdatadrawn from the EDW and applying various excel functions including VLOOKUP and pivot tables to aggregatedata.
Confidential - Chicago, IL
Business Analyst
Responsibilities:
- Obtaining a detailed knowledge of the business process being followed in the project environment.
- Extracting the business requirements from the end users keeping in mind their need for the application, and documenting it for the developers.
- Used TSYS on the E-Business Platform which strengthening the application position in the card industry providing cardholders with a superior, safer online experience.
- Used TSYS fraud control products include TSYS CardGuard, TSYS CardGuard Real Time Decision, TSYS Notification
- Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
- Analyse business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
- Prepared Business workflow models that cover "How" business processes are accomplished.
- Analyzed Business Requirements to produce System Requirements for the technical team using MS Vision.
- Various versions of the documents generated during the project were maintained and managed using Rational ClearCase.
- Collaborated closely with project manager to prepare project plans, budgeting, scope, features and analyzed the existing system along with business process flow
- Conducted group-effort in documenting the Pre-Business Requirements documentation for current AS-IS and future TO-BE scenarios to assist new Project Managers in processes and methodologies orientation
- Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
- Bugs, which would enhance the usability of the application, were logged using Rational ClearQuest.
- Interacting with the developers on resolving the reported bugs and various technical issues.
- Involved in preparing a simple and detailed User manual for the application, for an intended novice user.
Confidential - Detroit, MI
Business Analyst
Responsibilities:
- Attended Scrum ceremonies like Sprint planning meetings, Daily Scrum Meeting and Scrum review meetings
- Performed data mapping to establish mapping between source and target
- Used Tableau to generate internal reports to study and analyze the planned interfaces. Carry out appropriate review exercise, taking into account all the evidence and the individual circumstances of the customer, to ascertain whether there was a legitimate condition of sanction or whether the customer made an expressed wish for an IRP product
- Assist Global Markets to arrive at an 'in the round' decision on the quality of the sale, in conjunction with Skilled Person / FCA
- Analysis of all financial information relevant to the case and presentation of findings as required on each case including recommendation of whether any redress should be paid, and the form it should take
- Wrote change request specifications for corporate lending such as secondary loans trading and online notifications
- Trained bank users on functionality such as commercial and syndicated lending, static data set-up, accounting and settlements
- Relevant product knowledge including in depth knowledge of commercial and corporate lending products and a robust knowledge of interest rate hedging product and understanding of loan covenants and documentation
- Ability to understand and interpret financial accounts, and use various credit analysis techniques, apply insight into lending decisions and business knowledge to understand lending solutions.
- People / Team Management:
- Collaborate with senior developers and the Data Architect to design and build BI and reporting solutions against Relational databases that satisfy all functional and technical requirements.
Confidential - New York, NY
Business Analyst Systems Engineer
Responsibilities:
- Performed extensive "Gap analysis" of the Wealth Management application to document existing business process flows and derive requirements for the proposed functionalities
- Worked towards building digital wealth management application that help our client build brands and empower better decision making among their target audiences resulting in better outcomes.
- Analyzed IT application for the global wealth management firm and implemented major enhancements while incorporating third party banking software for expansion in Asia-Pacific.
- Used Rational Rose and UML to document requirements use cases and process flows like sequence, activity etc.
- Authored Meeting Agenda and Meeting Minutes for the meetings held with the Business and the technical team.
- Provided to users, and involved in conducting UAT sessions to gain user confidence and approval.
- Worked closely with Senior Management to create Work-Breakdown Structure, Resource Breakdown Structure using MS Project.
- Assisted rollouts, tracked adoption and helped with production issues.
- Create project plans and technical requirements documentation for various projects directly impacting several hundred thousand customers.
- Write business requirements in waterfall, iterative, and agile project environments.
- Performed Root Cause analysis to identify and recommend test scope and test approach improvements
- Administered Joint Application Development (JAD) sessions and interviewed end-users to elicit business requirements; Categorized and documented these requirements in the form of user stories and epics
- Collaborated with the Product Owner to conduct story writing workshops; Participated in writing user stories, defining acceptance criteria and estimating the level of effort to complete each user story
- Teamed-up with Subject Matter Experts to comprehend the artifacts within Investment Portfolio Management, Performance Management, Trade Lifecycle and Asset Management including asset allocation, asset diversification, risk & return analysis and cashflow management
Confidential, Pittsburgh, PA
Business Analyst
Responsibilities:
- Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing,LoanMonitoring and Asset Management.
- Worked as a business analyst to build Strategy Web application for financial statements and inspections
- Identified, researched, investigated, analyzed, defined and documented business processes
- Participated in UAT with end users to check the Compliance of thesystemwith the business Track defects and documented them in Rational Clear Quest.
- Assisted in creating proposal for porting Personal Loans workflow to the EmpowerLoanOrigination(LOS) Tool
- Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling
- Using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
- Analysis of Mortgage Processing workflow
- Troubleshoot help-desk tickets for EmpowerLoanProcessing Systems and 3rd party applications.
- Created functional specifications and design requirements for integration of current Wholesale ManagementSystemwith DealerLoanSystemto meet business requirements.
- Performed data profiling, data cleansing, and data validation using SAS.
- Worked on Black Knights Empower LOS for Retail, Wholesale, and Commercial Loans.
- Created the Test strategy and made the team well versed with it.
- Coordinated with the team for the test execution and QA process.
- Communicated the overall status to the client and also took care of the excalations.
- Providedmortgageindustry expertise and appliedbusinessanalystskills to assist in the functioning of LoanSphere, aloan origination system (LOS)
Confidential
Business Analyst
Responsibilities:
- Work responsibilities primarily involve understanding the business logic, gathering and developing requirements, creating Process Flow Diagrams, generating documentation (BRD & SRS), designing test cases, and Producing User Guide and updating Implementation Manual as part of the project deliverables.
- Performed data analysis and data migration activities including identification of source & target tables, defining data parameters and producing Data Mapping Documents as part of the Application Migration Project deliverables.
- Worked with client teams and stakeholders to discover, document, and categorize user stories (used Agile Methodology) and prioritized user stories accordingly. Worked with stakeholders and the Scrum team to help develop milestone schedules.
- Worked on Oracle database to handle Equity Big Data and performed SQL queries to do the Data Analysis. Revision in regulatory pattern work required using queries across multiple databases often. Troubleshoot the production issue by using SQL stored procedures and looking at the production code to make sure the code is written per the requirements and any new changes did not interfere with the existing functionality.
- Conducted Data Analysis by creating Advanced SQL Queries using Toad for Oracle, Advanced Access & Excel.
- Extracted, compiled and tracked data and analyzed data to generate reports.
- Maintain Traceability matrix in Excel throughout the project.
- Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and Primary stakeholders for Requirement gathering in Definition Stage using MS Word.
- Gather and document Business Requirements document (BRD), Functional and Non-functional Requirements (FRD).
