Business System Analyst Resume
SUMMARY:
- Business Analyst with 5+ years of experience in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
- Have experienced as Business Analysis, with cross functional experience in Real Estate and Financial services industry with Investment Banking, Asset Management, Portfolio management, Trades Lifecycle and Brokerage service.
- Extensive experience in the field of Property & Casualty Insurance & Business Systems Analyst participation on projects which involved the development of all aspects of new specialty insurance line, including IT systems support and business processes.
- Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
- Having very strong Software asset management knowledge.
- Acquired extensive knowledge of financial products and services, such as Fixed Income investments, Equities, Derivatives, Mutual Funds, Brokerage, portfolio management, Cash Management & Asset management.
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Excellent understanding of equity reference data warehouse concepts such as equity reference data marts, disk utilization analytics Meta equity reference data, logical and physical equity reference data modelling.
- Strong working knowledge on SQL.
- Strong understanding of information technology capabilities and dependencies, including platforms, content management, e - document strategies and process mapping.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Very Strong in Excel, VBA.
- Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
- Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
TECHNICAL SKILLS:
Modeling Tools: Rational RequisitePro, HPALM,UML, MS Visio, BPMN, Rational Rose, Rational Clear Case
Methodologies / Frameworks: RUP, Agile/Scrum, SDLC, Waterfall.
Database: MS SQL Server 2012/2008/2005 , MS Access.
BI Reporting Tools: Tableau, Microstrategy, Crystal Reports, Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microstrategy reporting system.
ETL Tools: Data stage, Informatica, IBM Cognos.
QA Testing Tools: HP QC, JIRA, Load Runner, MS Test Manager 2013
Documentation Tools: MS Office Suite, SharePoint 2010/2013, PEGA 7.
Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/Reporting, Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up,MDM
Finance: Fixed Income, Pension & retirement, Securities, Mortgage Loans, Mortgage Backed Securities (MBS), Property & Casualty Insurance, Derivatives, Bonds, Mutual Funds, Equities, Sweeps, Swaps, Pricing, Brokerage, Stocks, Bloomberg Data
Project Management Tools: MS Project professional, MS Project Server
PROFESSIONAL EXPERIENCE:
Confidential, Chicago, IL
Business System Analyst
Responsibilities:
- Involved in brainstorming and JAD session with the client in order to identify all the business requirements for rate, quote, bind & issue a policy.
- Explained Property and Casualty terms, Insurance Rules, Workers Compensation, Claims Procedures to development teams
- Analysis of business requirements and system requirements of the client and also for Property and casualty modules
- Worked on Commercial Lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business.
- Used IBM WebSphere Business Modeler to understand and transform business through superior business modeling.
- Performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
- Used data analysis techniques to validate business rules and identified low quality missing data in the existing enterprise data warehouse (EDW).
- Prepared extremely detailed ETL design documents and target-source mapping templates based on requirements gathered.
- Gathered reporting requirement and generated reports using Microsoft SSIS and SSRS BI tool
- Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
- Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
- Used SQL for extracting data from the Oracle database and performed data analysis
- Performed Defect Tracking and Change Control Procedures using Spira and Squish respectively.
- Involved in User-acceptance testing (UAT) and helping business in validating various defects and change requests raised during the testing.
- Attend daily and weekly communications meeting with different team members along with Project managers, and business users during the UAT and Model Office Testing.
- Triaged the production support tickets using System Center Service Manger (SCSM)
Environments: Business Objects, Cognos 8.4, Informatica, IBM WebSphere, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2007, XML, Power Designer
Confidential, Denver, CO
Business Analyst
Responsibilities:
- Interfaced with Business in understanding the present functionality of Advisor tab and defining the phases in which the complete migration would be done.
- Interaction with clients to understand a broad range of reporting requirements, and validating it with the regulatory requirements for reporting for a Prime Brokerage.
- Worked in the RUP Framework involved in iterations at each phase of the software life cycle.
- Customized RUP according to the standard operating procedures and developed Requirements Management Plan.
- Responsible for 24x7 coverage for various mainframe based Cobol applications using DB2, VSAM and IMS databases
- Was responsible for creating the various end to end Straw man flows for the work streams and the Clearing Broker/Dealer using MS Visio.
- Performed basic sanity testing via navigation and workflow of the application.
- Perform Financial Statement Analysis (FSA) relating to Fund of Funds (FOF) Portfolio Valuations in comparison to the financial statements of the underlying securities & brokerage reports.
- 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.
- Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
- Conducted user interviews, gathered Requirements, analyzed the Requirements and managed change requirement.
- Conducted interviews with end-users to collect requirement and business process information.
- Developed business process models in RUP to document existing and future business processes.
- Designed and developed project document templates based on SDLC methodology.
- Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
- Developed business requirement specification documents as well as high-level project plan.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
- Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
- Relieved pressure off the PM by maintaining artifacts and portions of the project binder.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
- Conducted User Acceptance Testing (UAT).
Environment: Rational Unified Process (RUP), Rational Requisite Pro, Rational Test Manager, Win Runner, Rational Clear Quest, IMS. HTML, XML, XSL and XSLT.
Confidential, Coral Gables, FL
Business Systems Analyst
Responsibilities:
- Gathered requirements from business users and analyzed them using Rational RequisitePro.
- Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
- Managed certification and compliance with the Payment Card Industry (PCI) Data Security Standard (DSS)
- Identified and implemented policies, security configuration standards, guidelines, processes and controls that are required to comply with PCI Data Security Standards (DSS)
- Use Case creation for Payment Credit Card (PCI Compliance).
- Expertise in Performance Management, Asset Management, Cash Management, Portfolio Management, Credit Management, Client Reporting and implementing its benefits.
- Good understanding of Financial Statement Analysis, Capital Budgeting, Portfolio Analysis & Stock Valuation.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
- Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio.
- Participated in the vendor selection process by, doing a GAP Analysis on the vendor (clearing broker) contracts and once selected, served as a liaison between the vendor and the Business Design Team.
- Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Reviewing project documentation for clarity/ completeness and potential domain or function impact.
- Proficient in Data modeling and mapping ER diagrams and hands on experience with Erwin data modeler
- Implemented the entire RUP Methodology of application development with its various workflows, artifacts, and activities.
- Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing.
- Tracked changes using Rational Clear Quest and conducted User Acceptance Testing (UAT).
- Created Metrics for the National Dashboard by utilizing data from EPIC and Clarity data sources.
- Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place.
- Participated in developing of Training Materials for the new technology and User Training.
- Worked effectively with Project Manager in handling the whole project.
Environment: Windows, Oracle, SQL, MS Visio, MS Access, MS Project, MS SharePoint, UML, Clarity, Requisite pro, Rational Clear Quest.
Confidential, Roseland, NJ
Business analyst
Responsibilities:
- Interacted with SMEs such as Prudential’s investment managers, loan originating managers, and process analysts to gather requirements and goals through interviews and surveys to understand the business process. Conducted controlled brain-storming sessions with project focus groups.
- Involved in gathering and synthesizing business requirements and translated them into functional and non-functional requirements to be used as input to the functional design specifications.
- Mastered knowledge of property and casualty (P&C) insurances in order to identify the risk of lending portfolios.
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to agreement terms.
- Interacted with technical architects to identify and analyze the given information, procedures, decision flows, and also evaluated existing procedures.
- Acted as liaison between the SME’s and the technical teams, handled scheduling, resource planning and allocation matters, conducted status meetings and compiled reports.
- Extensively worked on creating User Requirement Specifications, Functional Requirement Specifications, and Business Process Documents and also assisted in developing System Requirements.
- Designed use case diagrams to present a better view of the system and enable the technical team to identify the key processes.
- Prepared use cases, use case scenarios and elaborated them using UML diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio.
- Contributed in customizations, enhancements, updates, and changing functionalities of web page.
- Created and executed Test Cases.
- Assisted in functional testing for both manual testing and automated testing using Win Runner.
Environment: Windows, MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Project, MS SharePoint, MS Visio, HP Quality Center, Win Runner, Mercury Test Director, UML, SQL.