Sr. Business Analyst Resume
Topeka, KS
SUMMARY:
- 8+ years of professional experience as a Business Analyst with a strong understanding of Business Analysis, System Analysis, Business Process Management and Business Process Modeling.
- Excellent experience in the Travel/Airline and Retail Industries.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Understanding of Portfolio Management - Asset Allocation, Performance Attribution and Portfolio Accounting
- Good understanding of real-time analytics using business intelligent platforms such as Tableau Software.
- Knowledge of Financial products and services such as Fixed Income Instruments, Equities, Derivatives, and Hedge Funds.
- Knowledge of Claims Processing and Underwriting of insurance products.
- Knowledge of STP and SWIFT messages.
- Experience with large data, Data Mapping and Data Analysis and data reporting including Tableau, IBM Cognos, Data Mining and Data Warehousing software like Informatica and SSIS.
- Extensive experience in collecting and analyzing user requirements, performing thorough GAP analysis and generating detailed Business Requirements Document, Functional Specifications Document and System Requirements Specifications.
- Effective communicator leading various information gathering meetings, user interviews, Joint Application Development (JAD) sessions and presentations.
- Effective in establishing project plan and milestones, managing scope and in helping ensure that timelines are met.
- Apt in Object Oriented Analysis (OOA) and UML.
- Proficient in developing Wireframes, Use Cases, Data Flow Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams, Class Diagrams, Entity Relationship Diagrams and Business Process Diagrams. .
- Proficient in writing SQL queries for data analysis and validation.
- Expertise in developing QA Test Plan, Test Conditions, and Test Cases to ensure complete and adequate testing as well as coordinating and conducting User Acceptance Testing (UAT).
- Diligent team player with enhanced analytical, communication, organization and leadership skills.
- Tactful resource in managing user request changes and user conflicts.
TECHNICAL SKILLS:
Tools: UML, Rational Rose, Requisite Pro, Clear Quest, Clear Case, Microsoft Visio, DOORS, MS Word, MS Excel and MS PowerPoint, Microsoft Office Sharepoint Server (MOSS), Business Objects, Mercury Test Director, JIRA bug tracking tool, BugZilla, ERwin, MS Dreamweaver, MS Photoshop, uPerform, SnagIT
Modeling Techniques: Use Case Modeling, UML (Use case, Sequence diagram, Activity Diagram, Class Diagram, Entity Relationship Diagram), Object Oriented Analysis and Design
Methodologies: RUP, RAD, Waterfall, Scrum and Agile
Operating System: Win 95/98/NT/2000/XP, UNIX
Database: SQL, MS Access, Oracle
PROFESSIONAL EXPERIENCE:
Confidential, Topeka, KS
Sr. Business Analyst
Responsibilities:
- Interacted extensively with SMEs to understand and document their requirements pertaining to Fixed Income Instruments (such as Corporate Bonds, Treasury Securities, Municipal Bonds, Agency/GSE securities, CDs, MBS and New Issue Offerings), Corporate Actions, Risk Analysis, Portfolio Performance Attribution and Optimization.
- Worked with Financial Analysts to evaluate benchmarks that included a vast array of global indices as well as customized benchmarks.
- Assisted the project manager in developing timelines for project delivery as well as assessing risks and impact of changes. Participated in various project related presentations.
- Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
- Responsible for implementing supply chain and operations solutions in the exploration & production lines
- Lead, develop and implement the planning system improvements to maintain optimal inventories throughout the global supply chain
- Collaborated with other team members to write detailed Business Requirements Document. Developed Functional Requirements Specifications and System Requirement Specification from the business requirements.
- Designed Use Cases, Use Case Diagrams, Use Case Scenarios, Workflow and Data Flow Diagrams. Business Process Flow Diagrams, Activity and Sequence Diagrams using Microsoft Visio.
- Involved in various brainstorming sessions to investigate, identify, analyze and solidify business rules.
- Extensively used Tableau for data analysis and business intelligence.
- Reviewed with architect and technical team various technical design documents as well as input and output parameters for various web services.
- Participate in Development Solution in regards to Interwoven TeamSite related design and implementation concepts.
- Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (similar to XML), and TIBCO configure and provide custom enhancements to the client.
- Created and maintained a Traceability Matrix using Rational Requisite Pro.
- Managed requirements using DOORS, a tool newly introduced in the organization. Trained team members on effectively using DOORS for capturing, linking and analyzing requirements and their traceability.
- Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
- Generated wireframes and prototype for the GUI.
- Worked with the QA team to develop test plan, test cases and test conditions for integration and functional testing. Traceability Matrix was used to ensure complete end-to-end testing.
- Coordinated UAT. Reported all bugs and defects to the development team.
- Performed data analysis and ran various SQL queries to critically evaluated test results.
Environment: RUP, Rational Requisite Pro, Tableau, Rational Rose, Rational Clear Case, Rational Clear quest, Java, Visio, Oracle 9, Sybase, UNIX, XML, Linux, HTML, Windows
Confidential, Atlanta, GA
Sr. Business Analyst
Responsibilities:
- Helped Project Manger in project design and project plan using the RUP Methodology.
- Served as an intricate team member in preparing Scope and Vision document. Helped manage scope and identify risks throughout the project life cycle.
- 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.
- Interviewed SMEs to understand the current systems and processes.
- Performed detailed data analysis and assisted in building business process analysis model.
- Documented current and proposed process flow and conducted detailed gap analysis.
- Used Tableau for data reporting, studying the trends, data patterns and for data forecasting.
- Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
- Expertise with supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
- Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
- Co-authored detailed Business Requirements Document and Functional Specification Document.
- Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design (OOD) concepts and UML using Rational Requisite Pro.
- Worked with an information architect to create and develop wireframes and mock-up screens for the UI.
- Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
- Conducted highly interactive JAD sessions with project stakeholders to identify and resolve issues. Ensured consensus between Line of Business and IT Teams.
- Wrote specifications for various reports. Generated canned reports using Business Objects.
- Determined a testing strategy in conjunction with the QA team. Assisted in writing detailed Test Plan, Test Cases and Test Case Scenarios for system testing, integration testing and functional testing.
- Assisted in performing and coordinating unit, performance and functional testing.
- Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.
- Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.
Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, Tableau, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Test Director
Confidential, Chicago, IL
Business Systems Analyst
Responsibilities:
- Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
- Served as the primary liaison between the business and IT for E-Commerce Project (internal search)
- Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
- Worked on enhancements on Retail Merchandising System (RMS) by gathering business requirements, analysis, design, coding, testing and implementation.
- Responsibilities for several applications including business intelligence tools, supply chain management application, and assortment planning tool.
- Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
- Worked and assisted in developing E-commerce based web application for customer to make purchase order for themselves individually without any agent in between.
- Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
- Worked with Architects, Programmers, Development testers, Quality Assurance testers, and other System and Business Analysts that represented all other interfacing Applications and Middleware components for the various Application Projects assigned.
- Leveraged expertise with JIRA to develop/manage business documents and business objects.
- Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.
- Facilitated JAD sessions to expedite the processes of data mapping.
- Utilized corporation developed Agile SDLC methodology, Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Used HP Quality Center for requirements management, test management and business process testing.
- Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
- Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
- Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
- Worked on the Retail Merchandising and Point of Sale & UI system to automate the buying process of consumers.
- Developed XML schema to validate business rules in the generated XML files
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Performed the requirement analysis and documented the requirements using Rational Requisite Pro
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
- Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
Environment: Tableau, Requisite Pro, ClearCase, ClearQuest, WinRunner 6.0, LoadRunner, Rational Clear Case, Perl and Oracle 8.5 on Windows NT, Java, UML, Rational Rose, PL/SQL, and UNIX
Confidential, Boston, MA
Business Analyst
Responsibilities:
- Assisted the Business Analyst to provide estimation on the number of hours required to deliver the clients requirement, and in process work on financial planning and budgeting.
- Performed Business Process Modeling, created Use Case Model, Process Flow diagram and Activity diagrams using Microsoft Visio
- Part of JAD sessions with different groups of users.
- Helped in performing GAP Analysis between AS IS and TO BE workflow models
- Helped maintain the Requirements Traceability Matrix (RTM) for efficient requirement gathering and basis for test planning.
- Involved in creating test plans and testing with the QA team
- Assisted in facilitating interviews and gathering and prioritizing requirements from system users and prepared business requirements and functional requirements.
- Helped provide appropriate scope of work for technical team to develop prototype.
- Used HP Quality center to assign defects and keep track of the defects.
- Assisted in conducting Business Acceptance Testing.
- Assisted in gathering Business Rules and document user manuals.
- Assisted to develop the Test Cases to be used in testing based on Business Requirements.
Environment: Open Project, Oracle, MS Office Suite, Windows 2000, Internet Explorer, SQL, MS Visio, Crystal Reports Server 2008
Confidential, Secaucus, NJ
Business Analyst
Responsibilities:
- Worked with the core team to design business requirement collection approach based on the project scope and SDLC Methodology.
- Worked closely with SMEs and business users in understanding and documenting their current process, gaps and requirements around various aspects of hedge fund management: asset classes, corporate actions, performance reports, client reports, general ledger, P&L and reconciliation.
- Critically evaluated requirements gathered from multiple stakeholders - accounting, operations and management groups - and reconciled conflicts.
- Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements
- Designed the business process flow for the new platform in conjunction with SMEs.
- Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions and custodial data. Identified various data sources from where the data had to be extracted for the new platform.
- Conducted data accuracy analysis, and support stakeholders for decision-making &Tableau for report generation of the data to be analyzed from large data sets.
- Responsible for producing process flow diagrams for TO-BE process flows and AS-IS process flows using Microsoft Visio.
- Performed detailed GAP analysis involving the current state and proposed state analysis. Critically evaluate information gathered from multiple sources and reconcile conflicts.
- Designed and developed Use Cases, Use Case Diagram, Activity Diagrams and Data Flow Diagrams.
- Developed a thorough and repeatable software requirements methodology utilizing the Rational Unified Process (RUP) and Unified Modeling language (UML)
- Creation of Business Process specifications, application designing using RUP, database schema design and implementation methodology
- The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
- Assisted the development team to oversee ETL processes using Informatica.
- Created wireframes for the GUI of the reporting portal.
- Collaborated with the QA team to develop the test strategy, test conditions and test case scripts to be used in testing based on business requirements, technical specifications and/or product knowledge.
- Coordinated Integration Testing and User Acceptance Testing (UAT).
- Designed and implemented basic SQL queries for testing and report/data validation. Data validated included but was not limited to Net Asset Values (NAV), general ledger balances and realized gains and losses.
- Reported and assessed all application defects, user issues and resolution status to the higher manager using JIRA Bug Tracking software.
Environment: Java, UML, Rational Rose, Tableau, Requisite Pro, ClearCase, ClearQuest, WinRunner 6.0, Load Runner 6.0, Rational Clear Case, Perl and Oracle 8.5 on Windows NT, PL/SQL, and UNIX
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Served as a liaison between various business units and information technology groups.
- Understood functionalities supported by the various web applications and the current system design and architecture. Identified and understood various products and services including mutual funds and retirement services.
- Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
- XML order header and order detail data transfer; inventory/supply chain management modules
- Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML and OOD
- Worked together with other team members in interviewing various business groups and identifying and prioritizing business and functional requirements.
- Performed extensive data analysis with other functional analysts on data received from various sources and in different formats.
- Worked together with SMEs, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.
- Mapped the current and proposed process and conducted thorough GAP analysis
- Generated Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.
- Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
- Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases,
- Involved in writing test plan, test cases and test scripts for end-to-end testing.
- Reviewed test results and reported bugs/issues using Mercury Test Director.
- Assisted in UAT and end user training.
Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Test Director
