We provide IT Staff Augmentation Services!

Business System Analyst  Resume

4.00/5 (Submit Your Rating)

Bloomfield, IA

SUMMARY:

  • A result oriented individual with over 7+ years of diversified experience in Finance, Bank and Mortgage industry.
  • Expertise in Project Planning, Project Design, creating functional specifications and data flow diagrams.
  • Expertise in translating user requirements into technical specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements using RUP, waterfall and Agile methodology.
  • Possess excellent organizational, interpersonal, communication and documentation skills with good process management skills along with a remarkable ability to gather requirements to bring out quality product.
  • Defining change control processes, risk management, wealth management, cash management processes.
  • Scope assessment, gap analysis, risk evaluation, security reviews, and compliance monitoring.
  • Experience in Root Cause Analysis, GAP Analysis, Feasibility studies, SWOT Analysis, Cost Benefit Analysis using ROI, TCO methodologies, Financial Analysis deriving IRR, NPV and DCF.
  • Expert in Requirement gathering, Authoring Vision Document, User Stories, Business Requirements Specifications (BRD, Glossary, Business Rules, Process flows ( Current - AS-IS and Future- TO BE), Data Elements, Use Case Specification, Software Requirement Specification (SRS), Functional Requirements Specifications(FRS), Test Cases, Screen Mock-ups and Supplementary Specification (Non-Functional Requirements) documents
  • Extensive knowledge of trading systems implementation experience with multi-products and lines of businesses, including global equity finance, treasury, compliance, regulatory initiatives such as Dodd-Frank Title 7 (OTC Derivatives and Swaps), Emerging Markets, EMEA, EMIR, Basel II and Basel III and asset types, product knowledge of Equities, Swaps, Fixed Income, Structured Products, Money Markets, FX, futures & options and both OTC and exchange-traded derivatives products. Extensive Portfolio Accounting, Risk, Pricing and Performance Management experience in a global US, UK, Europe and EMEA location work history.
  • Worked closely with Corporate Finance and Treasury to institute new wire transfer procedures and new expense and clearing accounts
  • Possess strong analytical and problem solving skills with the ability to adapt to a new environment and meet stringent deadlines.
  • Experience include OTC derivatives, structured products, cash derivatives, Mortgage-backed securities including TBA's, FX derivatives, FX swaps, Equity options, Interest Rate derivatives, Inflation Swaps.
  • Ability to successfully manage multiple deadlines and multiple projects effectively through a combination of business and technical skills.
  • Facilitated JAD sessions with the management, vendors, users and other stakeholders for open and pending issues to develop specifications.
  • Professional expertise in MS Office, MS Access and MS Project.
  • Analyzed Enhancement requests and Modification requests.
  • Maintained the Requirements Traceability Matrix (RTM).
  • Highly motivated worthy team player capable enough to work and lead within a team environment besides being capable to work independently.
  • Experienced in Rational Unified Process (RUP) software development process using Rational ClearCase and Rational Rose.
  • Complete change management assessments while creating change management strategy, preparing risk mitigation tactics, identifying and managing anticipated resistance, and consulting and coaching regional teams
  • Maintenance of Test Matrix and Traceability Matrix.
  • Analyzed Business requirement.
  • Hands on experience in RDBMS and data analysis with SQL queries for retrieving, maintaining and organizing data.
  • Experienced as a Business Analyst in a role of responsibility encompassing Requirement Gathering, Decomposition and Analysis besides Quality Assurance.
  • Ability to identify and document critical requirements through analysis.
  • Conducted User Acceptance Testing (UAT) after going through regression testing.
  • Strong business analysis skills and thorough understanding of software development life cycle.
  • Strong ability to understand and document critical data through effective data collection, data analysis and data interpretation.

TECHNICAL SKILLS:

Project Methodologies: UML, RUP, Agile, RAD and Waterfall

Business Modeling Tools: MS Visio, MS Project, Rational Rose

Requirements / Document Tools: Rational Requisite-Pro 2003/05/07, Rational Rose, Clear Quest 2003/05/07, Clear Quest, Clear Case

Risk Assessment Methodologies: COBIT, Model Audit Rule, ITIL.

Database: DB2, MS SQL Server, Oracle

Languages: XML, SQL, Visual Basic

Operating System: Microsoft Windows XP / Vista / 7, Apple OS X, Linux Ubuntu

Data Analysis / Financial Modeling: SPSS, @Risk, and MS Excel (Pivot tables, Vlookup, Macros)

Other Tools: MS Office Suite, Caliber RM, DOORS, SharePoint 2.0

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, IA

Business System Analyst

Responsibilities:

  • Interacted with the SMEs along with Operations Group, production support groups, various teams on business side to gather client specific business requirements and translate them in a various business artifacts for the flow documentation.
  • Facilitated daily scrum meeting, sprint planning meeting, Sprint review meeting, requirement prioritizing under Agile Environment
  • Participated in mortgage loan processing evaluation and documented the needs and requirements for the systems and reviewed the requirements for the existing system to find out areas where additional enhancements are needed.
  • Used DOORS to develop Business Requirement Documents (BRD) and Functional Requirement Document (FRD) for the Online Mortgage Loan origination system
  • Designed business requirement & systematic approach based on project scope and SDLC. Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Served as Configuration Manager, ensuring smooth deployment and releases adhering to Sun Trust Bank defined change management procedures and policies
  • Single point of contact for all Change Management related activities
  • Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
  • Created use cases to depict the interaction between the various actors and the system. Facilitated collection of Functional Requirements from system users, and prepared Business Requirement documents using Rational Requisite Pro.
  • Created well-defined business vision documents, business glossaries and requirements management plan as per the Agile Methodology.
  • Played an integral role in major accounting software updates by testing, post-development training and implementations as well as streamlined operations and eliminated manual process by automating reconciliation of daily cash between two software systems
  • Responsible for mapping of various data elements including business, user-interface, and schema path (services) in coordination with various groups and using various tools like XML spy.
  • Involved in detailing project mission, Data Process Flow Diagrams and timelines. Defined business Use Cases and activity diagrams to represent different workflows and associations.
  • Analyze business requirements and segregated them into high level and low level Use Cases, activity diagrams / State Chart
  • Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
  • Worked on BPS Advantage and used SQLs to access data from RDMS, which is loaded on nightly batch runs for positions, balances and other reference data.
  • Performed client onboarding process relating to account closures and Reference date management
  • Performed Data Analysis for pricing feeds coming from Reuters, Bloomberg and Enterprise Security Master (ESM).
  • Involved in developing a web based environment for margins.
  • OTC derivatives Project documentation and settlements automation including Swaps, IRS, CDS and Index Structured Swaps.
  • Worked extensively on risk calculation and model development, path/scenarios generation and valuation model.
  • Business requirements and assessment of current OTC derivatives trades. Asset classes covered include Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Swaps, Credit Default Swaps, FX Swaps and Money Markets
  • View holdings in the portfolio in terms of market risks - equity, fixed income, currency, and commodities etc., in which drives VaR (Value at Risk), Equities.
  • Facilitated and coordinated Joint Requirement Planning (JRP) sessions for communicating and managing expectations with business users and to understand thoroughly the business process and the interface requirements which need to be incorporated in the application.
  • Communicated transition related issues and impacting events to various departments such as Sales, Credit, New Accounts Coordinated meetings with systems admins, stake holders, vendors, and development for both projects and status meetings.
  • Used SharePoint, PAC2000 and Microsoft Office to help organize and keep track of all project details and business approvals.
  • Provided support for the upkeep and availability of all non-production level environments during normal operation hours. Performed GUI testing and user acceptance testing (UAT).
  • Prepared Game Plans for Enterprise and Enhancement implementations/ Releases and conducted walkthrough sessions for the production developers.
  • Provided training to the business users and involved in preparing user manuals.
  • Prepared financial reports for reporting Margins to the clients on day-to-day basis.
  • Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system. Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users.
  • Analyzed the Market Data and the bottlenecks of various upstream applications in getting the ‘Positions’, ‘Journals’, and ‘Prices’.
  • Used SQL queries for extracting the data from the DB using DB Artisan.
  • Developed XML Schemas and DOM parser for all the XML documents used for data transfer and also developed XSLT code for them.
  • Worked with ETL (Informatica) developers for creating real-time data interfaces and DB extracts (ETL Design).
  • Worked on web service and SOA testing. Involved in API testing for the functionalities using XML scripts.
  • Processed Testing files using Web services and make sure it’s converted into standard XML.
  • Analyzed the bottlenecks between the feed arrival time of the upstream applications and the formal SLAs and analyzed its impact on the downstream applications.
  • Developed Data Models and done Data Mapping across downstream applications of Cameo.
  • Actively involved in developing 130 plus system flows from front-to-back office operations.
  • Worked on Business Intelligence for generating margin reports for clients. Interacted with Business Objects developers and prepared various matrix and graphical reports in business objects.
  • Developed the project plan using MS Project and tracked the progress.
  • Tested Business Objects reports in UAT using Pivot Tables in MS Excel.
  • Organized several meetings with SMEs situated across the globe (London, New York, Tokyo, and Mumbai), using WebEx and conference calls.

Confidential, New Jersey city, NJ

Business System Analyst

Responsibilities:

  • Documented system requirements and supplementary requirements, complying with industry regulations of International Swaps and Derivatives Association (ISDA), Commodity Futures Trading Commission (CFTC) and NFA (National Futures Association).
  • Create and implement change management strategies and plans that minimize employee resistance and maximize employee and stakeholder adoption of changes as a result of a new tool or process changes
  • Queried questions up front to determine key issues and foresee potential show-stoppers that might arise later and in-depth understanding of OTC derivatives operations
  • Performed the as-is and to-be analysis. Interacted with front office to gather requirements and acted as the liaison between IT and business departments.
  • Created PAC2000 tickets for application related Change/ Work Requests for production deployments.
  • Involved in financial analysis using investment data
  • Enhanced end-user access to a wide variety of data using Data warehouse modeling techniques.
  • Contributed to the projects deliverables, which included the Target Operating Model, Business Operating Models, communications strategy, Legal Documentation Remediation approach and implementation plans.
  • Maintained SOX and Dodd frank documentation templates, protocols and user instructions.
  • Managed the on-boarding of new customers and their beneficiaries, and verify the accuracy of information provided in the daily workflow requests.
  • Using Agile SDLC Methodology, I organized and facilitated daily scrum meetings, Sprints planning meeting and sprint review meeting.
  • Business requirement elicitation for Development and testing. Business documentation (BRD).Change management for application environment. Product solution and optimization. UAT test cases. User story/case creation.
  • Identified, analyzed, defined and documented business processes and Use Case Scenarios.
  • Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
  • Conducted joint interactive sessions with the team to decide the new enhancements and project change requests to be included in new releases.
  • Created high level functional requirements and broke them down into User Stories. Also created Functional Requirement Documents, conducted analysis and prioritized requirements.
  • Facilitated joint application development (JAD) sessions by convening project sponsors, group representatives, SMEs’ and technical personnel and documented the minutes.
  • Responsible to track, document, manage and communicate the requirements using Rational RequisitePro which helped in controlling artifacts produced by teams who are working on the same projects by keeping track of simultaneous updates and change notifications.
  • Communicated transition related issues and impacting events to various departments such as Sales, Credit, New Accounts team and client On-boarding team.
  • Performed Risk Analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
  • Maintained a requirement repository for tracing requirements to test cases and solutions.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Establish appropriate security levels for processes, information exchange and system implementation.
  • Assist in the development of conversion and implementation strategies and conduct pre and post implementation reviews, ensuring all technical solutions have met business requirements.
  • Provided user documentation, user training and post implementation support.
  • Conducted internal Technology meetings with Data Modelers, Architects and Developers to formulate a design including Data Models and the ETL Process to source the data and to distribute data to downstream partners through XML interface
  • Played a key role in planning the UAT, and implementation of system enhancements and data migration and conversions.
  • Objectively identified problems and proposed design alternatives where required.
  • Participated in the bug review meetings. Updated requirement document as per business user feedback and changes in functionality of the application.
  • Translated business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using MS Visio.
  • Designed and implemented basic SQL queries for QA testing and report/data validation.
  • Reviewed Test Cases with QA to make sure all application defects were resolved.

Confidential, New York, NY

Business System Analyst

Responsibilities:

  • Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
  • Developed detail class diagrams and sequence diagrams using Rational Rose XDE implementing J2EE patterns in UML design.
  • Involved in construction of data flow diagrams and documented the process.
  • Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
  • Identified internal and external system Requirements, design and configuration set-up.
  • Facilitated functional requirement gathering from system users and prepared business requirement documents (BRD).
  • Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application
  • Implemented the Agile methodology guidelines with its various workflows and artifacts in Requirements Management and Development.
  • Managed and reinforced change control policy and processes which included reinforcing and leading an environment where people management and the economics of change management are the number one priority
  • Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
  • Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
  • Worked with FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
  • Documented the “AS-IS” Business Workflows adhering to UML standards. Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD).
  • Using Business Rules, Business Use-Case Model and Business Object Model participated in Requirement Analysis of the application and performed GAP analysis.
  • Conducted meetings and JAD sessions for project definition, resource identifications and deliverable prototype identification
  • Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
  • Designed and developed all Use Cases and UML models using Rational and Visio.
  • Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Participated in UAT and worked with Quality Center for bug and defect tracking.
  • Involved actively in determining the quality and quantity of data to be provided for UAT.
  • Designed and developed Project document templates based on SDLC methodology.
  • Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
  • Designed Functional and Business classes, which involve LINQ to SQL/XML, Entity Framework implementation using ORM designer.
  • Developed Business Requirement Document as well as High-Level Project Plan.
  • Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
  • Participated in the Logical and Physical Design sessions and developed Design Documents.
  • Worked with developers to make sure that they understood the Use Cases.
  • Wrote SQL queries with joints on multiple tables
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
  • Worked with Quality Control Teams to develop Test Plan and Test Cases.
  • Developed User Manuals, and Training Manuals as per Project Specifications and timelines.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

  • Managed business requirements for the project to move the credit reporting batch to publish counterparty exposure limits earlier as a part of an FSA compliance requirement.
  • Products covered included FX, Rates, Swaps, Fixed Income, Equities, Commodities and Derivatives.
  • The credit batch components included components for trade valuations, deal generation, netting id mappings, collateral recognition, Monte-Carlo simulations and counterparty aggregation.
  • Identified and communicated dependencies and potential risks to the completion of the sprints including resources, costs and systems.
  • Communicated project changes and status to the stakeholders on a daily basis, ensuring each proposed change goes through a systematic project impact analysis.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.
  • Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
  • Tracked and ensured visibility of historical team metrics and progress of the iteration and release.
  • Constantly partnering with project leads to ensure the team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans.
  • As Scrum Master Assisted team with making appropriate commitments through story selection, sizing and tasking.
  • As Scrum Master proactively identified and removed blockers, facilitate frequent retrospectives, sharing metrics to identify and implement improvements.
  • Provided coaching on Agile values and practice to other teams within the company.
  • As Scrum Master involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Standups, User Stories and Acceptance Criteria.
  • Created SQL queries for reporting details on derivative trades as a part of Dodd-Frank framework
  • The batches reported various counterparty exposures and capital limits for all wells Fargo clients across the firm. This was an extremely high visibility project which reported to the steering committee.
  • Worked on all aspects of the project from interacting with directors and senior business partners for requirements, interacting with upstream/downstream data consumers, dev leads and PMs, creating test plans and test cases, post-implementation checks and future enhancements.
  • Developed and enhanced process flows for static data resolution, counterparty limits calculations and reporting.
  • Managed over 300 feeds from various systems of records. Meticulously addressed every detail to ensure a successful end-to-end business process.
  • Created enterprise level flows, demonstrating system architecture, connectivity, trade flows and timelines to identify gaps and develop requirements.
  • Worked extensively with off-shore development teams and tracked their progress through various tollgates over the life of the project. Managed overnight releases working alongside release managers
  • Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
  • Tracked post-deployment progress identified improvements and proposed resolutions to existing issues. Coordinated UAT with business partners, helped identify relevant test data and reporting metrics.
  • Wrote complex SQL queries to conduct Data Validation tests and Data Integrity tests.

Confidential, Cleveland, OH

Jr. Business Analyst

Responsibilities:

  • Collected Business Requirements, analyzed data/workflows, defined scope, financial projections and performed cost/benefit analysis.
  • Acted as an interface between the business planning team and the technical development team to understand the requirements and constraints and work around these to deliver the project execution plan.
  • Created business process models such as data flow diagrams and Entity Relationship diagrams (ER-Diagrams) to illustrate the design of the new system.
  • Participated in the UI work sessions and responsible for communicating the same to the team.
  • Liaised with the technical team and created the functional specs document tying the requirements back to the scope and business requirement document.
  • Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
  • Designed and developed project document templates based on agile (scrum) SDLC methodology.
  • Created the Build Turn over document or report on every build. Facilitated functional requirement gathering from system users and prepared business requirement documents (BRD).
  • Created and reviewed lists of backlogs to make sure the requirements are accurately met Under Agile Methodology.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Developed financial snapshots, dashboards and presentations to provide executives with insights on major capital investments and strategic programs.
  • Refined existing reporting and data management procedures to advance communication between business partners and senior leaders.
  • Researched, defined and implemented a financial tool capturing depreciation for all assets linked to capital projects.
  • Gathered project requirements from the business group.
  • Worked with the development team to make sure that they understood the user requirements and that the system developed met those requirements.
  • Created use cases, collaboration diagrams, deployment diagrams and several interface and application design documents.
  • Verified and validated all defined Business Requirements and associated functionality by administering Test Strategies
  • Developed prototype of new information processing application. Facilitated collection of functional requirements from system user
  • Worked as an Interface among users and different teams involved in the application development to promote a better understanding of the business and IT processes
  • Performed and co-ordinated system testing, regression testing of various builds during integration, performance and user acceptance testing using Rational Test Suite.
  • Participated in developing test plans and test procedure templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
  • Performed manual testing on the new reports for business users for data and format issues.
  • Developed prototypes of GUI and obtained sign off from customers.
  • Designed interfaces to other external systems.
  • Actively involved in the architectural group discussions.
  • Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group By.

We'd love your feedback!