Senior Business Analyst Resume
Minneapolis, MN
SUMMARY:
- 9+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
- Diverse experience in Audit, Tax, Online Banking and Financial Services.
- Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
- Helped the project managers and stakeholders in performing the cost estimation, cost analyses and benefits.
- Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
- Excellent understanding of EFT system (such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage).Knowledge of Online Banking and the whole Fund Transfer process.
- Strong knowledge of software development life cycle (SDLC), waterfall, Agile/Scrum, and RUP (Rational Unified Process).
- 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.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
- Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to a Enterprise Data Warehouse.
- Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting.
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Good experience with Rational Rose, Rational Requite Pro, Rational Clear Quest, Rational Clear Case, MS Project, MS Visio.
- Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
- Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
TECHNICAL SKILLS:
Methodologies: Rational Unified Process, Unified Modeling Language, Joint Application Development (JAD)
Change Management Tools: Rational Clear Quest, Test Director, Clear Case
Business Modeling Tools: Rational Rose Suite, Microsoft Visio, Irise Studio
Business Intelligence: Business Objects, Crystal Reports, Cognos
Project Management: Microsoft Project, Microsoft Office, Lotus Notes
Programming: Java, SQL, PL\SQL
Databases: Oracle, DB2, MS - SQL Server
Industry Exposure: Financial Services, Credit Cards, Investment Banking
Financial Skills: Financial Analysis, Credit Appraisal, MIS Reports generation
WORK EXPERIENCE:
Confidential, Minneapolis, MN
Senior Business Analyst
Responsibilities:
- Involved in defining the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks, and scope exclusions using MS Project.
- Interacted with Business Users and performed Gap Analysis.
- Responsible for coordinating JAD sessions with Business Users to analyze, gather and define the key performance indicator documents and presenting the requirements specifications.
- Served as a liaison between service vendors and business units.
- Defined functional business requirements, analyzed client requirements, and generated workflow processes.
- Communicated with stakeholders and business units for the updates to complete the work in a timely fashion.
- Involved with Data Warehouse team and generated reports using Oracle BI tool.
- Managed requirements and wrote Use Cases.
- Tagged requirements using Rational Requisite Pro.
- Provided full project life cycle flowcharting, analysis, and documentation.
- Provided business requirements status for reporting process of senior management.
- Supported testing team in maintaining and documented computer programs that automate specific applications.
- Involved in UAT planning and execution.
- Created and presented High Level Testing scenarios to business, development, and other stakeholders.
- Created the templates for Test Plan, Test Cases, Process Flow Diagrams, etc.
Confidential, Salem, OR
Senior Business Analyst
Responsibilities:
- Working as a Senior Business Analyst in Agile methodology with Confidential for State Project for Confidential for Child Support Program.
- Initiated the Child Support 101 process with State of Oregon for Business Process Knowledge.
- Gathered and document requirements for multiple process areas such as Case Intake, Paternity Establishment, Support Order Establishment, Enforcement and Financials.
- Created Requirements Traceability Matrix across all the process areas for the Batch Process, Use Cases, Forms and Forms ID, Page Mockups & Hi-Fi Screens, Interface and direction.
- Working closely with the client’s BA’s and SME’s to document state specific requirements.
- Created Process Flows for various sub-process areas for understanding of the business process module and the data flow of User vs System and triggers
- Created JAD(Joint Application Design) & JTD(Joint Technical Design) presentation documents and driven the process of responsibilities and roles for each areas of expertise to organize the tasks.
- Created Functional Design Documents front end UI validations and backend element mapping for end to end Functional Design of the application
- Working in a collaborative environment with the business line and technical team to align the development of the requirements as per client’s needs.
- Owned the Establishment Business process area and worked across all other cross-functional teams for end to end functionality and seamless user experience.
Confidential, Madison, WI
Senior Business System Analyst/ Quality Assurance
Responsibilities:
- Worked as a Senior BSA in an Agile SCRUM environment and Waterfall environment for multiple projects on Amfam.com Auto Quote and Bind team for Amfam.com User Interface enhancements and Re-designing.
- Worked closely with Product Owner on state roll out projects for enhancement of Amfam.com for various states from Classic to Advance - Amfam.com.
- Worked closely with Policy Center and Billing Center Teams as a major impacted teams for any enhancements on Amfam.com.
- Experienced with Policy Center by Guidewire - an application used as a major backend system for Amfam.com UI for any enhancements and changes.
- Worked heavily on Product Model for state specific at Policy level and Vehicle level coverage.
- Worked on various state specific rules and regulations for Policy Administration Constant fee, Financial Responsibility (SR-22), Auto Theft Prevention Program, Anti-Theft and state/policy specific discounts.
- Worked on Homeowners Policies for dwelling and construction attributes and underwriting referrals.
- Worked on Click to Sign model enhancement for Policy Center while binding the policies with e-signature.
- Worked on enhancement of source codes and channel codes from Amfam.com UI, Customer Care & Agents to differentiate the source of sale and the channel through which the sale has been initiated.
- Worked closely with developers, testers, UX designers, Architects, Product Owner and Scrum Master as adopting the agile environment and parallelly shadowing and helping the team to accomplish the sprint goal.
- Represented Amfam.com as a BA in Solution and Kick Off meetings with various teams and departments to understand the impact to Amfam.com Auto Quote and Bind application.
- Documented any impacts which are state specific for the roll outs of states which are in classic and going to advance amfam.com.
- Expert in state specific coverages and limits offered by Amfam.com to the customers for Auto policies.
- Documented business and system requirements for Amfam.com enhancements and flow changes.
- Interviewed Business lines and Product Owners for gathering business rules and high level scope of the projects.
- Reviewed requirements with Business Lines and Product Owner to get the approval on the business need.
- Facilitated requirements review and estimation meetings with developers and testers and UAT team for the roadmap and timeline requirements.
- Worked on Amfam.com JIRA tool to work on defects for multiple projects and provide necessary information needed to fix the defect and/or requirements change.
- Reviewed test cases with test team to ensure that all the requirements are covered and tested functionally.
- Used Rational Requisite Pro for overall Requirements Management and to build the Requirements Traceability Matrix.
- Interacted with End users and participated in JAD session to ensure that their requirements are compliant with code tested.
- Participated in Security meetings to review the requirements and to analyze if the security scan is needed before implementation of the enhancement.
- Represented the Scrum Team during presentation of task accomplished within the sprint to product owners and stakeholders.
- Documented the priorities in the product backlog and helped the product owner to refine the PBI’s (Product Backlog Items).
- Adopted and worked on all the different phases of Agile SCRUM environment SDLC. SCRUM Planning, Product Backlog Items Refinement, Sprint Review, Sprint Retrospective and most important - Feedback.
Environment: Amfam.com, Policy Center, Product Model, Amfam internal JIRA tool, MS office tools, MS Share point, Joint Application Development (JAD), Box, Amfam internal templates for documenting requirements, Clarity Timesheets tool
Confidential, Green Bay, WI
Senior Business System Analyst
Responsibilities:
- Worked as a BSA in a concept project for implementation of Application Performance Monitoring (APM) Solution and Implementation of Telecom Expense Management (TEM) Solution.
- Served as liaison between business and systems team to understand the scope of the project from business and gather requirements from systems perspective.
- Interviewed IT partners such as application owners, Business Solution Managers, Infrastructure team to gather current application monitoring process information “As Is” and documented gaps to understand what is needed to fulfill “To Be” state of the project.
- Gathered various data flow diagrams and system diagrams to understand the point-to-point data flow and monitoring process from one pin point to another.
- This includes a process flow from End User to the infrastructure and other components which makes an application to work.
- Gathered and documented all the business requirements (High level & Detail level) into a Business requirement document.
- Created end-to-end integration flows for implementation of a solution and its integration with Confidential systems.
- Attended demos from multiple vendors providing APM Solution to organizations selected from Magic Quadrant of Gartner.
- Documented and analyzed vendors capability to fulfill Confidential ’s needs based on demos provided in order to narrow down the list of vendors to score the requirements.
- Created technical questionnaire as a part of requirements score card to be given out to all selected vendors to gauge their abilities to fulfill our requirements.
- Scored all the vendor responses vs Confidential ’s mandate and desired requirements and selected the top vendors to do Proof-of-Concept with.
- Worked closely with Systems Engineer to help create an environment to install vendor solution to do proof of concept.
- Worked closely with vendors to get them network access and create dashboards as per Confidential ’s requirements.
- Interviewed app owners and team to gather and document the success criteria based on the type of application selected as a candidate (Homegrown, Compiled and partly homegrown and compiled, cloud based applications).
- Created test cases based on various scenarios given out by interviewing app owners to fulfill their success criteria.
- Documented Actual results from Proof-of-Concept and compared the Actual results vs Expected results to gauge vendor application performance with Confidential ’s success criteria.
- Created Current and Future State business process flows to understand the transformation of manual process to automation.
- Created Usage scenarios for integrations between the Solution application and Confidential systems.
- Participated in the JAD sessions along with technical team members and client to elicit requirements.
- Worked closely with Systems Analyst to capture functional requirements from functional specifications for reports and integrations.
- Documented data requirement based on reports and UI specs from sandbox of the Solution application.
Environment: MS office tools, Community Manager, Joint Application Development (JAD), MS Share point and Confidential internal templates for documenting requirements, Innotas Timesheets too
Confidential, Bloomington, IL
Execution Business Analyst/ Quality Analyst
Responsibilities:
- Participated in strategic and planning architecture as a subject matter expert on behalf of their specific area.
- Responsible for reviewing Business Requirements Documents BRDs, functional requirement documents FRDs, and Test cases for the CCN Impact.
- Served as a liaison between systems and business partners from other departments for business related issues.
- Worked closely with the Business Architects to create future state architecture and ensure the vision is achieved within execution efforts.
- Facilitate Verification and Review meetings to identify bugs in the initial stages of Requirements and Design of the project.
- Create and review Wireframes and page mockups to help business users visualize the website.
- Responsible for overall management of the testing scope of various tracks in the project which includes Performance Testing, Data Validation & Integration Testing, UI Functional, End-to-End Testing, UAT Testing, and Production Shake out Testing.
- Facilitated Joint Application Development (JAD) sessions with all IT group members for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
- Review Test Cases to ensure accurate and complete testing of CCN requirements.
- Responsible to understand and document testing requirements, provide test estimates, create and review test cases, execute and review test results.
- Assisted in User Acceptance Test before the go-live of the project.
- Maintain strong relationships with Customer Care Network Team and the Development Center Team of Excellence.
Environment: MEGA, Test Link, Trac, MS Visio, Lotus Notes 8.5, Sales Force Toolkit, MS Office tools, MS Share point
Confidential, San Diego, CA
Business Analyst
Responsibilities:
- Involved in all phases of Software development life cycle (SDLC) in Agile Scrum framework.
- Analysed and collected business requirements, identified system interfaces and created the requirements specification document for property and casualty project.
- Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
- Extensively interacted with both user group and development team.
- Managed and tracked change control process of requirements and design changes.
- Documented the changes, issues and their impact on the system design and delivery.
- Recommended suitable financial products to the clients as per their investment policy statement for their wealth management
- Integrated new Wealth Outlook client financial software and advised associates.
- Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
- Experience in the Interest Rate Derivatives and Interest Rate Futures business.
- Experience and knowledge of interest rates, credit derivatives, FX derivatives and currency hedges.
- Assisted PM with project planning, estimating, budgeting, resource allocation, collaboration and time capture.
- Reviewed trade confirmations for derivatives trades, including rates, credit, equity, and commodity and FX derivatives.
- Managed and created outstanding trades and the firm’s trade documentation.
- Designed and analysed Business Process Model, Use Case model and test procedures based on RUP methodology using Rational Rose.
- Used SQL queries to extract data from database to perform data analysis.
- Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stakeholders and document analysis. Performed user interviews.
- Experience developing storyboard and user stories to elicit requirements from the product owners.
- Participated in daily SCRUM meetings to discuss the bottlenecks and the tasks status.
- Performed manual testing and recorded results in ClearQuest and used SQL queries for enhancements.
- Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owner & stakeholders and document analysis. Performed user interviews.
- Work on the Data Modeling, Entities and Attributes of the Data points and Templates. Building API in XML based on the requirements.
- Assisted the database team in understanding the ETL requirements for data migration from business users.
- Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
- Communicated with management concerning development process within areas of assigned responsibilities using MS Share point (MOSS).
- Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
- Conducted User Acceptance Testing (UAT), Unit testing and System testing.
- Monitored Defect Tracking system using JIRA to prioritize defects and devise a plan for future enhancements and delivered the artifacts in a timely basis.
Environment: Oracle 8x/9i, Asp. Net, SQL, MS Project, MS Office Suite, RUP, UML, CA Clarity, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS office suite 2003, MS Visio 2003.
Confidential, Denver, CO
Business Analyst/ Quality Analyst
Responsibilities:
- Determined user/business/functional requirements.
- Created vision, scope and use case documents, business process models, use case diagrams, activity diagrams and state chart diagrams.
- Involved in design and development of web based software using ASP.NET
- Facilitated changes to the SharePoint governance policies, procedures and processes
- Performed corporate analysis case study of the potential and rationale for implementing a company-wide Access Control wealth Management Program. Presented the findings and recommendations to executive management
- Performed business process analysis and created business process diagrams using the industry standard BPMN modeling tools like VISIO and Enterprise Architect.
- Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
- Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues and created minutes of meeting for the sessions conducted.
- Conducted Joint Application Development (JAD) sessions and meetings for shadowing and helping the project manager, stakeholders and product managers in performing the estimation of the project cost and analysing costs in different phases of the project and cost benefits on those phases.
- Responsible for managing and translating business requirements and information architecture requirements into functional specifications for the SharePoint development team.
- Collected, documented the BRD and FRD managed the documents using Caliber RM for multiple projects
- Used MS SharePoint as a data repository for Document and Content Management
- Validated technical designs created by IT developers against functional specifications.
- Coordinated work plans between project manager and client using MS Project.
- Worked closely with the DB team in database modeling which included logical and physical data models.
- Managed the project tasks, timelines and publish other useful documents using Microsoft Office Sharepoint Server (MOSS).
- Managing Relational Database (RDBMS) and updating the data warehouse in Oracle PL/SQL on a regular basis by the Business Intelligence/ETL process.
- Analyzed and assessed the clients systems and business processes using business process diagrams.
- Expertise in leveraging wireframes or prototypes during the requirements process
- Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams and Change Management documents.
- Used SQL to query the database for performing data analysis and data modeling using Erwin.
- Adept at mentoring the business stakeholders and technical team on the system functionalities
- Worked with ETL teams in defining the data transformation required for the migration.
- Assisted in building a business analysis process model using Rational Rose and Visio.
- Performed requirement analysis, developed all the use cases and workflows.
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
- Developed Use cases for all the surrounds interacting with the enrollment system. Also assisted Testing Team in coming up with appropriate test cases.
- Assist the technical team in understanding and developing the appropriate functionality.
Environment: MS SQL, C++, Web services, Windows XP, Caliber RM, Test Director, Rational ClearQuest, Rational ClearCase, UML, Rational Suite, MS Visio, MS Project
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Extensively involved in every phase of the RUP process starting from Inception to Transition.
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
- 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.
- Interacted with Architects, business and other stakeholders and created the Back-End Use Cases for Online Payments project.
- Application was developed for Online Banking accessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
- Establish and maintain effective oversight of other product projects, such as for Flexcube FX/MM or Loans, or upstream/downstream systems such as Transactor, Citidirect etc., to ensure that they are in step with the Flexcube program.
- Review the design of controls and operational effectiveness of processes in Flexcube and legacy mainframe applications.
- Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
- Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer System (EFT) such as CHIPS and ACH.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
- Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control.
- Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
- Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
- Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
- Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
- Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
- Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
- Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, VBScript, MS Project, Dreamweaver, SharePoint, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, Test Director, Load Runner
Confidential, New York, NY
Business Analyst
Responsibilities:
- Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
- Documented the Current and Future State Accounting Work flow as part of Online Payments.
- Attended meetings and JAD sessions for cost estimation and cost analyses with project and product managers and stakeholders.
- Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
- Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
- Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead and updated project schedule in Primavera
- Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
- My work as a Business Analyst on TMS (Transaction Management System) included remittance processing to clients on developing Lock boxes.
- Prioritized, plan and managed multiple projects using Primavera Project Planner Tool
- Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
- Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Design and develop the data load process using Informatica PowerCenter and XML Style sheets and ACORD XML.
- Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
- Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
Environment: Rational Clear Case, Doors, IBM WebSphere, Primavera, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro