We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume Profile

Princeton, NJ

SUMMARY

  • Over 8years of experience as Business Analyst in the Information Technology Industry.
  • In depth knowledge of Software Development Life Cycle process which includes Waterfall, Rational Unified Process methodology RUP and Agile Scrum.
  • Active participation in discovery sessions, interviews, prototyping, document-reviews, plan setup, plan configuration with customers.
  • Created UML Diagrams including Use Cases, Activity Charts, Sequence diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and MS-Visio thus defining the Business Process Model and preparing complex functional requirement documents.
  • Capable in prototyping documents, models and attributes for consistency, completeness and risk minimization.
  • Experienced in conducting Joint Application Development JAD sessions with end users, SMEs and stakeholders and Rapid application development RAD sessions.
  • Involved in Client interaction and support to the marketing team. User meetings resolve implementation and performance issues.
  • Experienced in Enterprise Business Analysis, Requirements Management, Software / Web Usability, Information Architecture, and Training Materials Development consulting services to corporate clients and maintaining SLAs.
  • Simplified existing applications integration architecture build for scalability utilizing SOA as framework and Applied the As Is and To Be process designs in order to identify any potential process gaps and as well as improvement opportunities.
  • Good knowledge of creating SQL Queries for Data Validation and Data Integration.
  • Experienced in SSIS, SSAS, SSRSand SharePoint.
  • Accomplished at UAT user acceptance testing , Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
  • Expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments.
  • Conducted GAP analysis, User Acceptance Testing UAT , SWOT analysis, Cost benefit analysis and ROI analysis.
  • Defects tracking prioritize outstanding defects in reporting system. Coordinate between development team and the management team to resolve any conflicts/defects in terms of requirements.
  • Motivate team players with excellent business, analytical, communication, presentation, and management, technical and written skills.

Financial Domain Knowledge:

  • In-depth knowledge and experience in Equities Stocks, ETF, Equity Linked Notes , Fixed Income Bonds, Convertibles, MBS, ABS, CDO, Synthetic CDO, CMO, Munis, T-Notes, T-Bonds, TIPS, Inflation-indexed Bonds , Derivatives and Swaps Options, Futures, Forwards, CDS, CLNs, CDS Index, Interest Rate Swaps, Equity Swaps, TRS, Credit Spread Options, Index Options , FX FX Options, FX Futures, Currency Swaps, Currency Forwards, FRA , Money Market Instruments T-Bills, Commercial Paper, Repos , and Mutual Funds.
  • Experienced in identifying and documenting detailed business requirements pertaining to Fixed Income Securities, Equities and Equity Trading Cycle, Derivatives, Portfolio Management, and Wealth Management.
  • Experienced in analyzing the existing Risk Management platforms and Trading front-office risk business processes and systems, Investment banking, Investments, Capital Markets, Prime Brokerage, Financial Services, Wealth Management, Portfolio Management, Trading Systems, Fixed Income Securities, Bond strategies, Bloomberg Functions, Mortgage-Backed Securities Securitization, Forwards Equity, bonds, interest rate, currency , Futures interest rate, stock index, currency , listed and OTC Options Stock options, bond options, Interest Rate options on LIBOR, caps floors Swaps Interest swaps, currency swaps, equity swaps, credit swap, Total Return swap ,Warrants, Risk Management Operational, Market, Credit, Liquidity , Product Pricing Reference data, Options expiration/assignment process.

TECHNICAL SKILL-SET

SDLC

Agile Scrum, Waterfall, RUP

Supporting Languages

HTML, XML, SQL

PM Tools

Lean Management, SWOT, CBA, Clarity PPM, Impact, GAP, MS Project 2010, MS Office, MS PowerPoint

Modeling Tools

MS Visio, UML, Adobe Illustrator, Lucid Chart

Business Tools/Reporting Tools

Spotfire 5.0, 6.0 , Cognos 8.4,MS Project, TABLEAU, TABLEAU DESKTOP 8.2, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access, Design Expert, JMP, Crystal reports, MS SharePoint

Supporting Tools

JIRA, Rational Requisite Pro, Rational ClearQuest, Rational ClearCase

Testing Tools

HP Quality Center

Data Warehousing

ETL Tools like Informatica 7, Informatica 9.0.1, I

Others

Oracle Documaker Studio, DB2, COBOL, VSAM, JCL, CICS, zOS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst

Project Description: Confidential is one of the world's largest financial institutions serving individual consumers, small businesses, middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services. The project was part of the Confidential and itsgoal was to build a seamless, leading edge portfolio management system incorporating risk and performance analytics directly into investment strategies. Risk management products and services. The project was part of the Confidential and its goal was to build aseamless, leading edge portfolio management system incorporating risk and performance analytics directly into investment strategies.

Roles Responsibilities

  • Elicited requirements by conducting JAD sessions with key stakeholders from the Capital Markets IT Group, Business Area and Application Development team for the portfolio, forecast and reporting module of the portfolio management system.
  • Created Spotfire report file DXP and Database connection in Spotfire server.
  • Created functional specification documents, based on the technical specification documents for dashboard and reports using Spotfire.
  • Worked with end users to explain Spotfire workbooks, creating ad-hoc reports
  • Coordinated with the PM for project planning using MS-Project and to discuss project technologies and methodologies, Cost-benefit analysis, Impact analysis, SWOT analysis, WBS and project milestones, budget allocations, scheduling, CPM, and risk analysis mitigation.
  • Performed Gap analysis and conducted business modeling by reviewing the existing business artifacts.
  • Authored the Functional Requirements Specification FRS and Business Requirements Document BRD and System Requirements Specification SRS for the project.
  • Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
  • Created static and dynamic prototypes using HTML and CSS for better visualization and understanding of the software solution.
  • Created validation rules and provided verbiage to developers for client-side validation, server-side validation and database validation.
  • Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on SharePoint.
  • Implemented Agile Scrum methodology of application development and set the velocity for each sprint cycle.
  • Conducted daily Scrum meeting, planning meeting, review meeting, retrospect meeting and created the Product backlog.
  • Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.
  • Participated in creating the design and technical specification for the ETL process of the project and provided the data mapping document to the ETL team.
  • Provided test data, monitored UAT and created the Requirements Traceability Matrix RTM using MS Excel.
  • Used HP Quality Center for loading the test scripts and logging defects.
  • Collaborated with the production team by facilitating the implementation of the application, prepared production certification scripts and performed production certification.

Environment: AGILE Scrum methodology, ASP.net, C , JAVA, OLAP, JavaScript, HTML, SOAP, WSDL, XML, JIRA, HP-QC, BPMN, SharePoint 2010, Oracle, SQL Server, MS Access, MS Excel, MS Project, and Test Director.

Confidential

Confidential is a diversified banking company focused primarily on consumer and commercial lending and deposit origination. Its principal business segments are Local Confidential. Local Banking includes consumer, small business and commercial deposits, and lending conducted within its branch network. The National Lending segment consists of three sub-segments: theConfidentialCard sub-segment, which consists of domestic consumer credit and debit card activities the Auto Finance sub-segment, which includes automobile and other motor vehicle financing activities, and the Global Financial Services sub-segment consisting of international lending activities, small business lending, installment loans, home loans, healthcare financing and other diversified activities.The scope of the project involved enhancing Capital One's legacy credit card origination system to an updated in house credit card system. The proposed solution also included implementing a new database, which was responsible for integrating the bank's new credit card features into the system.

Responsibilities:

  • Analyzed the business needs of clients and stakeholders to help identify business problems and propose solutions.
  • Created workshops to understand requirements for Data Warehouse design. Conducted client side validation to study ETL operations on database.
  • Created server-based Spotfireworkbooks DXP dashboards and applications from scratch based on clients needs
  • Created dashboards for a managerial overview with drill up and drill down capabilities.
  • Performed Gap Analysis and analyzed AS IS and TO BE conditions
  • Created Workflow scenarios, designed new process flows, documented the Business Process of the business from the conceptual to procedural level using MS Visio
  • Conducted interview workshops, focus groups, JAD sessions with SME, BO, Sr. Developers, Architects to further breakdown the requirements
  • Conducted Feasibility Analysis and Product backlog planning with the Project Manager
  • Created WBS using MS Project
  • Expressed the requirements through user stories, use cases, business rules, future state mapping and process flow diagrams.
  • Created the Product backlog with help of user stories collected through requirements gathering and gap analysis
  • Created the data-mappingdocument for the integration of existing credit card holders.
  • Acted as a Scrum Master by creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings
  • Created sprint burn down charts and release backlogs for effective Project Management
  • Utilized SharePoint 2010 as an administrator for document management, version control and creating team dashboards on the team site
  • UsedInformatica to ETL Data warehouse data for the project
  • Helped in creating test cases for the system. Develop and Implement test cases on the GUI interfaces to ensure that requirements were met.
  • Worked with SQL queries to extract application data to perform application validations
  • Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team

Environment: HPQC, UML, SCRUM, MS Access, MS Office, ASP, SQL Server SSIS, SSRS, SSAS , Visual Studio, SDLC, MS Visio, BPMN, VSM, SharePoint 2010, Version One.

Confidential

Business Systems Analyst

Project Description: Confidential is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores and more than 12,000 ATMs and the Internet wellsfargo.com across Confidential internationally. The scope of the project was to deploy an application so as to support the foreign exchange trading and to build a global straight-through processing STP hub to automate processes and increase operational control and efficiency across multiple asset classes. The platform uses a single allocation-matching model using SWIFT. This new application also has messaging features to report the trade flow process the transactions electronically.

Responsibilities

  • Coordinated with SME's of Foreign Exchange Trading, Futures, and Options to capture requirements dependencies for enhancements in the application.
  • Functional experience in FX Foreign Exchange processes, related applications based on technologies such as SWIFT. Also involved in applications for trade processing and Fund reconciliation.
  • Extensively used SharePoint for content management, and to share the information with the groups involved during the project.
  • Documented existing and proposed process flow and conducted GAPanalysis.
  • Identified and Analyzed key potential Risks along with the entire Project Development Life Cycle, Developed Risk Mitigation Plan, and assisted PM in Risk Management.
  • Performed Project planning requirements gathering by using RUP methodology
  • Prepared Use Case Diagrams to explain the business requirements for Trading Customer with the options to buy or sell Foreign Exchange.
  • Coordinated with system analysts Tech lead to create Software requirements document.
  • Maintained and kept track of stakeholder's requests for enhancements and changes using Rational Clear Quest. Written SQL scripts to pull the data from the existing database based on the business rules.
  • 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.
  • Assisted in creating enterprise banking data model, created SQL stored procedures to access customer information and implementing corresponding data access objects.

Environment: RUP, Rational Requisite Pro, UML Use Cases, HTML, SQL, Use Case Documentation, MS Visio, SQL, Rational Clear Quest, SharePoint.

Confidential is one of India's leading banking and financial services groups, offering a wide range of financial services that encompass every sphere of life.The scope of the project was about developing enhancement project an Online Banking Application that will help customers accessing their savings account, checking account, and credit card account via Internet.

Responsibilities

  • Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system.
  • Involved in analyzing Business Requirements and developing System Specifications.
  • Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.
  • Did rigorous load testing using Load Runner.
  • Assessed business priorities, and advised business units on risks and Cost-Benefit analysis.
  • Used Rational Rose to generate various UML Diagrams.
  • Organized cross training of team members and users to become more responsive.
  • Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
  • Involved in incident reporting and change and configuration management procedures using Clear Case.
  • Ensured that the modifications suggested by the users were incorporated into the application.
  • Formed a bridge between the Project Manager and different teams with effective presentations.

Environment: Load Runner, UML, Clear Case, MS Access, MS Office, ASP, SQL Server, Visual Studio, SDLC.

Confidential is a private broking firm and a member of Multi commodity Exchange of INDIA having their clientele located in all over India. The scope of the project was to avoid all manual/physical transaction and create web based application so their spread clientele can login online and receive their Position file, Transaction details, Statements and Confirms, Margin details, Market Watch for their selected Portfolio, Brokerage Statements and Tax information online.

Responsibilities:

  • Facilitated collection of requirements from system users and preparation of Business/Functional requirement documents utilizing UML RUP methodology to provide appropriate scope of work for technical team to develop prototype and overall system.
  • Analyze and prioritize requirements and use them to outline timeline for completion of goals.
  • Performed GAP Analysis with system functionality and existing Business Processes.
  • UML and RUP process for productivity in communicating specifications to design development team. Analyzed and designed Use Case Diagrams using UML/Visio.
  • Managed scope and requirements throughout the project life cycle.
  • Discuss and propose conversion / interface solutions with the clients and users.
  • Performed Functional Testing, Integration Testing, System testing and Regression testing.
  • Wrote Test cases, test scripts and test plans for UAT.

Environment: Rational Requisite Pro, RUP, UML, SQL, MS-Office Suite Word, PowerPoint, Access, Excel, Outlook , MS Visio and Crystal Reports.

Confidential is an Industrial Credit and Investment Corporation of Confidential Lombard is a sister concern company of Confidential bank. The scope of the project was to work on screen enhancements of existing health care claim processing system.

Responsibilities:

  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Conducted interviews with project managers, business users to collect requirement and business process information.
  • Developed PowerPoint presentations for monthly meetings with upper management.
  • Teamed up with Insurance advisors to perform market survey and learn client requirements to assist technical team in
  • Software development.
  • Participated in SLA Service Level Agreement writing for different financial productsandinsurance products like
  • Personal Insurance, General Insurance, Property and Casualty Insurance, Car Finance, Personal finance, Education
  • Loan and Housing Loan.
  • Conducted a budget planning of the project through walkthroughs and meetings involving various leads from
  • Development, QA and Technical Support teams.
  • Created Data Flow Diagrams, Activity diagrams and Use cases for the audit planning process.
  • Coordinated in developing test scenarios, test cases and implemented test plan with QA team.
  • Assisted in development of training materials for new technology and process improvement.

Environment: UML, RUP, SDLC, Rational Requisite Pro, Rational Rose, Windows 2000, MS Office, MS Project, MS Visio.

Hire Now