Sr. Business Analyst Resume
EXPERIENCE SUMMARY:
- 7+ years of experience as a Business System analyst/Project Manager with extensive knowledge and experience in Software development life cycle (SDLC) like Agile/Scrum, Waterfall.
- Elicit requirements and manage end user workshops, document and analyze requirements, conducts user surveys, and analyze business process performance, recommend optimization by applying Lean process fundamentals.
- Cross functional project management, liaison, and communication leadership skills to produce high - level and low level solution documentation
- Expertise in gathering of requirements through research, formal-informal sessions, JRP sessions and JAD sessions with SMEs (subject matter experts), Teams, Stakeholders and end users.
- Performed Gap Analysis, Analyzed and documented current state and future state of a system (AS IS - TO Be), Identified and Documented Change Request, Use Case, Functional Design Document, Story Boards and User Stories, Sprint Planning, User Story Estimation, Screen Mockups.
- Proficient in Elicitation techniques like interviewing, questionnaires, brainstorming, focus groups, prototyping, cost/benefit analysis and risk analysis and incident management sessions.
- Experience in Capital Markets, Money Markets, Derivatives (OTC and ETF), Equities, Fixed Income Instruments, Management of Credit Risk (Counterparty Credit Risk) and Liquidity risk and Treasury Securities.
- Expertise in preparing and reviewing User Requirement Specifications (URS), Functional Requirement Specifications (FRS) and Design Specifications (DS) in compliance with applicable FDA rules and regulations.
- Proficient in Technical writing (FRD) and Business Writing (BRD).
- Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
- Conducted and participated in and all Agile SCRUM ceremonies including Daily SCRUM meetings, Sprint Planning, Backlog Grooming, Demo, Sprint Retrospective etc.
- Experienced in creating EPICS, USER STORIES, USE CASES and further refining with detailed ACCEPTANCE CRITERIA.
- Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
- Working knowledge experience in Data services, Data Analysis, Data ETL using SQL queries tools and applications.
- Excellent experience on writing database queries (SQL).
- Participated and conducted design walkthroughs and Inspection review meetings, experienced in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts and Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis.
- Excellent communication and interpersonal skills, self-starter, proven experience in working independently and in a team, timely delivery against aggressive deadlines.
TECHNICAL SKILLS:
SDLC: Waterfall, Agile/ ScrumOperating System
Windows, UNIXTesting Tools: HP ALM/ Quality Center, QTP,TFS, JIRA, MTM
RDBMS: DB2,Oracle 11g, SQL Server, MS Access
Business Tools: MS SharePoint, MS Project, MS Office Suites, Word, Excel, PowerPoint, Rational Rose, Rational Requisite Pro, TFS, MS Visual Studio
Business Skills, Process, Case Tools: Business Definition Requirements, Business Process Analysis & Research, Use Case Modeling & Analysis, JAD/RAD Sessions, Requirements Gathering, Gap Analysis and Impact analysis, Crystal Reports, UML Diagrams.
Languages: SQL, VB Script, HTML, XML.
Browsers: IE, Mozilla Firefox, Google Chrome
PROFESSIONAL EXPERIENCE:
Confidential
Sr. Business Analyst
Responsibilities:
- Maintain hands on Prototyping of Dynamics CRM Government Implementation. Using SSIS and SSRS cross Master Data Management architecture to develop (hands on) rapid solutions including:
- Performed as Acting CRM Lead for the State of North Carolina Department of Transportation. Advised senior staff of CRM and the business case for CRM regarding various implementation options
- Tracked the overall project, supported and facilitated project teams as PM.
- Partnered and co-operated with other teams for successful integration of the project and deliverables.
- Responsible for Managing long term roadmap and implementations as PM.
- Responsible for Attending Product/ Application iteration demos (Sprint Demo) and Stand Ups as a PM
- Supported and facilitated project teams.
- Perform GAP analysis of business rules, business and system process flows, user administration, and requirements.
- Responsible for creating workflow for new account opening with key integrations with credit bureaus and risk database of potential blacklisted customers
- Responsible for requirements on data mapping activities to map the Fixed Income securities (Treasuries, Bonds, Mutual Funds) between old and new system.
- Conducted JAD session to understand business requirements.
- Created UML diagrams (Data migration flow diagrams, Data flow diagrams, Use case diagrams, Activity diagrams, Business process flow diagrams).
- Document test requirements, test designs and test plans.
- Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
- Worked on integration with financial brokerage applications for front office, middle office and back office channels for trading platform.
- Worked on Credit Card process, Transaction approval process, Batching, Clearing and Settlement process, Payment process
- Wrote use cases, user stories, technical specifications, process flows and wire frames for new processing functionality.
- Created list of notifications and BI reports requirements to be sent to financial regulators and integrated with various financial regulatory bodies as per the business need.
- Studied and assessed the client’s systems and business processes based on available documentation, SME interviews and performed reverse presentation.
- Expert in Object Oriented Analysis and Design, Waterfall, Agile Methodology, Jira, Confluence, JAD Sessions, Live Meetings and Interviews.
- Monitoring and reporting tool for deposit data of capital markets.
- Analyzed system requirements, Functionality, Developed Test Plans and Test Cases in Test Director, Prepared Test data and executed them.
- Documented the requirements and workflow for the capital markets assets and liabilities monitoring and reporting system.
- Worked with clients and business analysts to get the definition and clear understanding of requirements to design and implement test cases.
- Extensively used SQL to query the Oracle database to analyze data and set-up data accordingly.
- Provided support after the application went live to fix any bugs and worked on enhancement requests from the users.
- Conducted UAT, created test cases and scripts for UAT and facilitated UAT team for execution.
- Documented UAT outcomes and conducted UAT reviews with End Users and stakeholders and participated in Go-NoGo meetings.
- Reviewed test deliverables, defects, test results created by team members.
- Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts.
- Created reports (daily status reports and weekly reports) and created testing metrics as requested by senior management.
- Creating Requirements Documents, User Stories, and related test plans
- Ensured testing team is following testing standards, guidelines, and testing methodology as documented in Test Approach.
- Worked with designing front-end application by creating screen mock-ups and wire frames.
- Prepare flow charts, ad-hoc financial reports and Ad Sales PowerPoint Presentations
Environment: Microsoft Office Suite, UNIX, SQL, SQL Server, Agile, SDLC, Jira, MS Project, UAT, Requirement Gathering, BRD, Etc.
Confidential
Business Analyst
Responsibilities:
- Analyzed and understood the requirements in a Business needs and Technical specifications perspective by conducting User reviews and JAD sessions.
- Understood and articulated the Business requirements from the Business and then converted them into technical requirements.
- Completed Data Mapping for Group and detail Product analysis and report writing
- Documentation for the Drug Utilization Review System
- Involved in Salesforce Application(CRM) sales cloud and service cloud, Setup activities and customized the apps to match the functional needs of the organization.
- Gathered, maintained, and prioritized system requests, including bug fixes and enhancements for Veeva CRM and related systems.
- Worked on writing business requirements, lead requirements gathering meetings and reviews designs with the business.
- Creation of Gap/Impact Analysis and Operational Analysis, document Medicaid Subrogation and the Drug Rebate Analysis and Management System.
- Created Pivot tables and look up tables to summarize the flat data available and to highlight the desired information using Excel
- Maintained all the stories and tasks in JIRA which was used to know the status of requirements. Implemented JIRA Safe methodologies in the project.
- Use software development process using Agile method in the project and help their members to implement the process.
- Work with the customers and business team and Prepare Business and Requirement Specifications Documents.
- Articulated business rules, developed process diagrams, and authored user requirements specification for address verification and overall sample eligibility validation to ensure Veeva CRM and related systems meet the compliance requirements.
- Gathered all the input/output data and modeled the credit data using the Rational Rose suite.
- 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.
- Developed cluster analysis to segment credit and debit card portfolios as well as provided marketing recommendations.
- Developed an in-house system to research all aspects of merchant credit/debit card activity
- Performed GAP analysis using the AS-IS process flow document and the TO-BE process flow document.
- Developed credit/debit banking transaction modules as per the online banking requirements.
- Developed a thorough and repeatable software requirements methodology utilizing the Rational Unified Process (RUP) and Unified Modeling language (UML).
- Utilized Agile tool "JIRA" for backlog management and created reports for Sprint meetings using Burndown charts and Task boards
- Employed document management tool "Confluence" to ensure efficient cross-functional collaboration
- Identified actors, paths and steps leading to an output and prepared Use Cases, Use Case Narratives and Use Case Diagrams to define actors, interactions and steps to achieve functionality.
- Authored the product backlog for the complete project, derived User Stories for individual iterations, assigned tasks and allocated appropriate resources for completion and acceptance of individual stories.
- Conducted sessions for Developers and QA team to explain the development of the system.
- Created Business Process specifications, application designing using RUP, database schema design and implementation methodology.
- Worked on alternative methods of reporting to create excel reports Dashboards, power queries, pivot tables, and interactive spreadsheets
- Managed theencounterdata collection effort between the health plan and the medical group.
- Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process.
- Prepare requirement specifications such as Use cases and System requirement specifications and Supplementary specifications; Tag and trace system requirements to business requirements
- Designed and implemented basic SQL queries for QA Testing and Report / Data Validation
- Used Clear Case to keep different versions of the documents and Clear Quest to report bugs or defect
- Used Rational RequisitePro as requirement gathering tool.
- Develop SQL scripts to report on specific data criteria
Environment: MS Visio, SQL Server, Rational Requisite Pro, Rational Rose, SQL, UML, Rational Unified Process, Crystal Reports, MS Office.
Confidential
Technical Business Analyst
Responsibilities:
- Gathered, Analyzed and Documented various project Business Requirements, Functional Design Requirements and Technical Design Document with Business Partners, Technical Team and SME's.
- Interviewed business area experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
- Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements.
- Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team.
- Performed technical project consultation, initiation, collection and documentation of client business and functional requirements, solution alternatives, design, testing and implementation support.
- Captured Business Process Flows and Reengineered Process to achieve maximum outputs.
- Managed several full-cycle, large-sized client integration and onboarding projects.
- Worked with developer teams for translation of test scripts and coding standards and requirements.
- Worked with an information architect to create and develop wireframes and mock-up screens for the UI.
- Directly co-ordinated the tester and developer teams for following contextual testing effort
- Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program. Developed Traceability matrix for maintaining/updating system requirements using MS Excel.
- Prepared test plan, test scripts and participated user acceptance testing (UAT).
- Developed high quality documentation including BRD, Use cases, SRS, report specifications, BPM, test plans and user guides.
- Worked on JIRA for bug status tracking and maintained and created status reports for the application.
- Involved in the creating the User Interface Specification Document and User Manual as per project specification with the help of development team
- Participated in daily Agile Scrum, Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for a project of changing the client's software maintenance structure of their various software products.
- Analyzed data to create data conversion for onboarding new clients.
- Worked closely with data warehousing team for the data integration on the Hansel and Pie systems.
- Made selections on the Wire Frames and User Interface (UI) Designs for the software application.
- Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
- Held several Presentations and Briefings regarding the used tool stacks and asserted the use of the same.
- Extensively participated in stand-ups and team meetings including vendor meetings
- Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
Environment: MS Visio, MS Excel, MS PowerPoint, Rational Requisite Pro, Agile methodology.
Confidential - Richmond, VA
Business Analyst
Responsibilities:
- Worked with main business groups such as Customer service call centers, Sales Teams, Accounting, etc. to gather CRM specific user and Business Intelligence (BI) data requirements and business rules.
- 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.
- Worked with the Customer Service Team and analyze the current incident and ticket issuing process for improvement through IT with business process re-engineering approach.
- Documented current and proposed process flow and conducted detailed gap analysis.
- Worked in conjunction with other team members, technical architects and developers to understand system integration and interface requirements.
- Facilitated and conducted JAD sessions with SMEs, key business stakeholders and other IT staff to collect requirement and business process information.
- Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access.
- Worked with an information architect to create and develop wireframes and mock-up screens for the UI.
- Documented requirements associated change requests with requirements and connected requirements with Use cases.
- Also documented user requirements focusing web features to improve the customer experience.
- Developed business process models (BPM) for existing (As-Is) and future (To-Be) business processes.
- Generated canned reports using Business Objects.
- Determined a testing strategy in conjunction with the QA team.
- Used Prototyping method to gather additional requirements from the users in order to describe the business needs in terms of the system being created checked reports using TOAD (Oracle) for errors and provided the information to appropriate department for further investigation.
- Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing (UAT).
- Interfaced with developers to identify and resolve technical issues and bugs in the software to validate end-user requirements.
- Created and maintained the Requirements Traceability Matrix (RTM).
- Performed data driven tests using test data from flat files to check the data flow of entire application and created SQL queries to check the data flow in a Database.
- Development of SQL queries as per the request from the business team in SQL server.
- Performed Business Process Modeling using Visio and customer data analysis.
- Wrote complex SQL queries in TOAD to perform Back-End testing.
- Executed complex integrated systems planning and solution alternative analysis and design.
- Executed business process analysis “As-Is” system & “To-Be” systems & perform gap analysis.
Environment: Agile, SQL, J2EE, MS Project, ClearCase, XML, Web Based Application, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Etc.
