Sr. Business Analyst Resume
Morrisville, NC
SUMMARY
- 7+ years of extensive experience asBusinessSystemsAnalyst, having worked in projects in as diverse sectors asbanking & financial services.
- Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment.
- Working experience with general insurance projects like P&C Insurance.
- Working experience with Banking Credit Risk Calculation and Reporting domain.
- Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases,Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), High Level Design Document (HLD), Requirement Traceability Matrix (RTM) and testing documents.
- Implemented Salesforce.com as the primary enterprise application for Sales, Service and Operations
- Highly experienced in finance domain with exposure to Investment Banking and Global Capital.
- Proficien nCinot in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio.
- Expertise in documenting project plan, BRD, FRD, user guide, test plan etc.
- Extensive experience in gatheringbusinessand application requirements,businessprocesses, identifying risks, impact analysis, UML modelling, sequence and activity diagrams using Rational Rose and Microsoft Visio.
- Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the High - Level business requirements.
- Managed the update process for report sections related to treasury activities, stress scenarios, and hedging practices.
- Expertise in creating Test Plans, Test Cases for Smoke, Integration, System, Functional, Regression, Database, and User Acceptance (UAT) Testing.
- Expert in writing detail system USE cases, developingbusinesstest cases, and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders andbusiness users with wireframes.
- Experienced in working projects and tracking progress with JIRA software.
TECHNICAL SKILLS
Operating Systems: UNIX, Windows 7,8,10.
Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
Application Servers: Websphere, ATG Dynamo, BEA Weblogic
Internet: HTML, XML, VB Script, ASP, JavaScript.
Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum, Calibre RM, DOORS, Sharepoint
Bug Tracking Tools: Mercury Test Director, Rational ClearQuest, Quality Center
Utility Tools: MS Office 365, MS Project, TOAD, Adobe Photoshop
Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin
Development Methodologies: RUP, AGILE, Waterfall, ESDM
PROFESSIONAL EXPERIENCE
Confidential - Morrisville, NC
Sr. Business Analyst
Responsibilities:
- Functional requirements, solution alternatives, functional design, testing and implementation support.
- Performed duty as a liaison between Information Technology andBusinessdepartment.
- Helped QA analysts and technical heads with troubleshooting and fault resolution.
- Responsible to analyze impact of proposed solution across thebusiness, create design document to explain/demonstratebusinessrequirements/specifications to IT team, and contribute abusinessor process perspective during design reviews
- Creating Wireframes from the Stakeholders and converting into UCD.
- Very efficient with MS Office 365 Suites (Word, Excel, PowerPoint, Visio, Project, Outlook).
- Documented credit risk ratings management process and risk models based on Compliance & Regulatory Policies.
- Created Functional Requirement Specification documents - that include UML Use case diagrams.
- Worked with the Data Analysis and Reporting group daily to ensure accurate information was included on all reporting.
- Responsible for interfacing with Development and other impacted workgroups to review and explain
- Actively involved in Portfolio Wide Credit risk functions like risk due to exposures, correlations, VAR due to Credit rating migration etc.
- Worked with the SQL server to understand the data staging and used TOAD to check the data integrity of the tablet solution.
- Implemented queries for storage and validation of data on database using SQL and PL/SQL (simple queries, views, stored procedure).
- Documented Business and Functional Requirements (BRD, FRD).
- Create and executing test cases for complex business. Applications, preferably in the Banking Credit Risk Calculation and Reporting domain.
- Data mapping, logical data modelling, used SQL queries to filter data within the Oracle database tables.
- Coding Database objects like Triggers/Procedures/Functions in SQL Server.
- Owned and executed UAT phase of SDLC including kickoff meeting, fielding questions, entering defects into HP Application Lifecycle Management (ALM).
- Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
- Analyzing existing system logic difficulties and revising the logic and procedures involved as necessary
- Interacting with senior customer personnel on significant technical matters frequently requiring coordination across organizational lines
Confidential, Boston, Massachusetts
Business Analyst
Responsibilities:
- Provided key input in working with users in indentifying and defining system and project requirements.
- Worked on the gathering requirements to provide Wireframes.
- Wrote detailed specifications for a wealth management application, including general ledger entries,played an active role in gathering, analyzing, and writingbusinessrequirements using Requisite Pro.
- Identify potential sources of data for the data warehouse.
- Conducted JAD sessions with the entire team to come up with the possible solutions for thebusiness problems.
- Documented FRS (Functional Requirement Specifications) and assisted Systemsanalystto come up with SRS (System Requirement Specifications)
- Thorough understanding of and experience in Commercial cash management, corporate finance and Information reporting systems.
- Involved in drawing process flow diagrams and work flow diagrams in all phases of the SDLC.
- Translating the business requirements in to correct project artifacts - BRD, FRD, Use Cases and Traceability matrix.
- Created User Acceptance Testing (UAT) collateral, test scenarios and test scripts.
- Conducted Risk Analysis and Credit Risk Estimation & Analysis like Regression Analysis.
- Validated correspondence letters using Microsoft SQL Server, Excel, and proprietary company software
- Created analytical models that estimate future credit risk and losses at the account level for all existing and prospective loan products.
- Very efficient with MS Office 365 Suites (Word, Excel, PowerPoint, Visio, Project, Outlook).
- Worked with the developers to ensure that the applications conform to customer requirements.
- Used PL/SQL and TOAD to query and pull data from ORACLE tables for data analysis, quality assurance, and troubleshooting
- Monitored SQL Server Logs on a Daily bases and addressed errors accordingly.
- Utilize in-depth knowledge of functional and Technical experience in Treasury and Payments applications in conjunction with industry and business skills to deliver solutions to customer.
- Worked with development team to resolve any production environment related issues.
- Played a key role in the planning, testing, and implementation of system enhancements and conversions.
- Analyzed and research on operational procedures and methods and recommend changes for improvement with an emphasis on automation and efficiency.
- Conducted impact analysis for the requested change bybusinessusers/stakeholders to control change in the requirements.
Confidential, Charlotte, NC
Business Analyst
Responsibilities:
- Performed requirements gathering and analysis from thebusinessusers of the system and SME's while adhering to SDLC (Software Development Life Cycle) industry best practices. Used the Agile-scrum methodology for software development.
- Non-life insurance policies, including automobile and home owner’s policies, provide payments depending on the loss from a particular financial event in P&C Insurance
- Gathered and documented business(BRD, FRD) from both formal and informal sessions and validated the needs of thebusinessstakeholders.
- Interacted with Software development team andBusinessusers as a liaison in helping developers to understand thebusinessrequirements, Functional requirements (BRD, FRD) thereby ensuring the proposed applications complies with thebusinessspecifications.
- Successfully improving monthly & quarterly treasury reports comprised of Corporate Cash Management, Money Market Funds & Compliance by inserting corporate slides and coordinating all relevant entities as well.
- Responsible for managing integration with multiple applications to support Credit Risk Application.
- Worked with thebusinessusers and with different levels of management to identify requirements, use cases and to develop functional specifications using the Agile methodology for software development.
- Participated in and contributed to "As-Is" and "To-Be" Process Modeling Sessions, and build process models.
- Liaised among client system technology teams and business unit teams in Credit Risk, Payment Processing, Treasury, Market Risk, Corporate View, and Fixed Income.
- Develop complex SQL queries and stored procedures used to drive business logic \
- Manipulating, cleansing & processing data using Excel, Access and SQL.
- Planned and Conducted User Acceptance Testing (UAT.
- Understood thebusinessrequirements and mapped them into functional and technical requirements.
- Performed Gap Analysis and Impact Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
- Created use case models and activity diagrams using Unified Modeling Language (UML) notations using Rational Rose.
- Created interactive, tabular and graphical reports from the relational and multidimensional data sources using SSRS
- Supported reporting client acceptance specifications, from initial creation, through change management, and acceptance execution. All the activities were carried out using the entire SDLC and managed using MS Project
Confidential, Detroit, MI
Business Analyst
Responsibilities:
- Coordinated with market BAs andbusinessowners to gather requirements.
- Responsible for identifying and maintaining a clear and measurable software development process that is deployable throughout the enterprise using SDLC.
- Followed the AGILE methodology for the entire SDLC.
- Very efficient with MS Office 365 Suites (Word, Excel, PowerPoint, Visio, Project, Outlook).
- Responsible for generating business requirements document (BRD) and requirement traceability matrix.
- Analyzing the Functional Flow, Use Cases, Requirements and Guiding team in technical queries for Manual Testing
- Acted as a primary liaison betweenbusiness/market BAs/ and developers.
- Analyzed test results, identified issues and reported it to the developers and project manager through JIRA.
- Working in Agile team environment with extensive use of Team Foundation Server (TFS).
- Prepared and modified Requirement Specification Documents for different markets.
- Gather and document business needs and translate them into functional requirement document (FRD).
- Documented detailed analysis of end-to-endbusinessprocesses, functional design, workflow mapping and action items, issues and ensured information is accurate and complete.
Confidential
Business Analyst
Responsibilities:
- Prepared various documents such as Business Requirement Documents (BRD), General System designs (GSD) and Impact documents.
- Implemented Salesforce.com as the primary enterprise application for Sales, Service and Operations
- Delivered enhancements forSalesforce.com instance with over 2,500 users
- Facilitated meeting discussions between business users, business analysts and technical analysts.
- Documented organizational policies and procedures in the context of system requirements.
- Wrote EDI documents that tracks the progress of the inbound and outbound files.
- Managed (Admin) the defect and test case management tools with over 300 users for the entire project and used it for tracking the progress of the various phases of the project.
- Conducted several Requirement Gathering Sessions (JAD) for gaining detailed requirements and finalizing Business Requirement Document (BRD)
- Install and configure new Application and SQL Servers databases application.
- Created User Stories Business Rules and Functional Non-Functional Requirements in Team Foundation Server (TFS) to organize the business needs.
- Working with clients to better understand their needs and present solutions using structured SDLC approach.
- Created the Informatica mapping and workflow to load the data from the external source to the Enterprise Data Warehouse (EDW).
- Demonstrated ability to plan and direct project logistics in support of application development.
- Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
- Prioritized the individual word load that involves multiple project assignments and deadlines.
- Created and executed test cases, test scripts, data sets and user procedures.
- Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory. Ensured testing results correspond to business users’ expectations.
- Involved in various project management activities such as Time, Cost, and scope and Risk management.
- Provided user support, including training, help and instructions.