We provide IT Staff Augmentation Services!

Sr.business Analyst Resume

Richardson, TX

SUMMARY

  • 8 years of experience as a Business Analyst (BA) in finance and insurance industries. Result oriented quality focused, keen on learning, creative problem solver and analyzer, good team player with excellent interpersonal and communication skills. Enthusiastic self - starter who can boost productivity, foster efficiency and ensure profitability. Goal driven achiever with strong organizational skills.
  • Expertise in Software Development Life Cycle (SDLC), Agile Development, SCRUM, XP, Rational Unified Process (RUP) and Waterfall methodology from analysis and design through programming and deliverables.
  • Experience in creating “AS IS” and “To BE” business process.
  • Expertise in eliciting requirements using JAD sessions, interviews and brainstorming sessions.
  • Extensive experience in analyzing and documenting functional and non-functional business requirements, user stories and system functional specifications using various tools like Quality Center, Version One, Rational Requisite Pro and JIRA .
  • Excellent business writing skills in developing Business Requirement Documents (BRDs), Use Case Specifications, Functional Specifications (FRDs), System Design Specifications (SDS), Workflows and Unified Modeling Language (UML) Diagrams.
  • Managed the delivery of all projects, including project plans, status meetings, progress reports and initiation/closure activities.
  • Hands on experience writing SQL queries for data analysis and data quality and have prepared data mapping specifications and data dictionaries.
  • Expertise in creating, customizing and reading XML and SOAP codes.
  • Worked extensively in SOA and Object-Oriented Design and Analysis related projects.
  • Experience in evaluating and documenting internal controls, preparing narratives, performing risk assessment and analysis.
  • Experience in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
  • Creation of User Interface mockup screens using Visio and Axure.
  • Experience in System testing and troubleshooting. Performed functional testing, integration testing, Regression Testing and Stress testing with hands on experience performing User Acceptance Test (UAT) and have extensively prepared test plans, test scenarios and test cases.
  • Extensively worked on all phases of Data Warehousing project like Data modeling and conversion for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan and Data presentation to business users.
  • Proficient in Microsoft suite of products including MS Word, MS Excel, MS Access, MS PowerPoint and MS Visio.
  • Experience in creating and troubleshooting test scenarios and test scripts.
  • Sound knowledge about enterprise planning and budgeting, cost management.
  • Extensive experience in business process engineering and software development with expertise in analysis, design, development and implementation of applications.
  • Delivered project plans, statements of work, service agreements, operations and disaster procedures.
  • Hands on experience in designing Data Models and Relational Databases.
  • Experience in Automation Tools such as Quick Test Professional (QTP), Win Runner and LoadRunner in Client/Server applications, Web based applications and Mainframe applications.
  • Proficient in using system modeling tools such as Erwin Data Modeler, RequisitePro and MS Visio.

TECHNICAL SKILLS

  • SDLC Methodologies like Agile
  • XP
  • Scrum
  • RUP
  • Waterfall
  • Rational Requisite Pro
  • Microsoft Office Suites
  • Quality Center
  • Version One
  • Axure
  • Unified Modeling Language
  • SharePoint
  • Oracle BRM
  • SAP
  • Liferay portal
  • SoapUI
  • SOA Service
  • Confluence
  • Microsoft Project
  • Microsoft CRM
  • Microsoft SQL Server 2008/2005/2000
  • T-SQL
  • MS Visual Studio 2005/2008
  • MS Access 2007/2003
  • Windows 9x/NT/2000/XP/Server 2003/2008
  • Erwin Data Modeler 4.2/4.1/4.0
  • XML
  • SQL Server Reporting Services
  • Crystal Reports 11/10/9/8.5
  • C
  • C++
  • Visual Basic 6.0
  • Lotus Notes
  • Photoshop
  • Quick Test Professional (QTP)
  • Win Runner
  • Load Runner
  • Rational Rose.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr.Business Analyst

Responsibilities:

  • Worked extensively on Salesforce customer management tool to manage customer records.
  • Worked under Agile as well as Waterfall SDLC methodology.
  • Gathered requirements from business to initiate changes in Salesforce in order to meet working demands of business.
  • Acted as a point of contact and performed impact analysis to study impacts of other IT projects on SFDC.
  • Conducted meetings with business to gather requirements.
  • Created Business Requirements Document (BRD), Functional Requirement Document (FRD) and traceability matrix as per the requirements received.
  • Worked closely with developers to develop functionality as per the business needs and acted as a liaison between IT and business.
  • Worked extensively on Salesforce setup and customization of different objects, page layouts, user profiles, fields and records.
  • Compiled business rules for developing triggers, workflows and processes.
  • Worked on integration of SSO technology with SF1 (SFDC mobile version) and SFDC (Desktop version).
  • Worked on Salesforce app exchange platform to integrate SFDC with applications and customize the two according to business needs.
  • Collaborated with 3rd party vendors to understand and document the functionalities of application and guide the business accordingly during the requirements meeting.
  • Worked closely with Aetna business associates to create an interface between Aetna and CVS systems so that the records can be exchanged between the two parties.
  • Defined acceptance criteria for QA team.
  • Worked with QA team to test edge cases and inspect the results of different test cases.

Environment: SLC/Waterfall process, Sharepoint, Salesforce.com, JSON, Unified Modeling Language, XML, MS Word, MS Excel, MS Visio, MS PowerPoint, Confluence.

Confidential - Coppell, TX

Sr. Business Analyst/Systems Analyst

Responsibilities:

  • Followed Agile SDLC process for system designing and development.
  • Worked through the discovery phase of CaaS 2.0 to identify projects requests.
  • Identified project scope and created PRF for all projects requests under CaaS 2.0.
  • Worked with off-shore business stakeholders to gather requirements.
  • Used Scopia to conduct online meetings and conferences with off-shore business and development teams.
  • Worked on contact center to design the algorithm for supporting multiple control managers.
  • Worked on SAP billing/invoicing module to understand the process flow and data manipulations.
  • Created Business Requirement Specification (BRS) with the requirements.
  • Reviewed and incorporated feedback and secured business and IT sign-off on business Requirement Specification.
  • Analyzed reports to understand data requirements and AS - IS process.
  • Managed Sharepoint site for the project artifacts.
  • Created Requirement traceability matrix to track requirement development and implementation.
  • Ensured technical solutions are being designed to meet the business requirements.
  • Created use cases for business and development team to identify the edge cases and implement them accordingly.
  • Defined acceptance criteria to meet the exact parameters of business requirements.
  • Worked closely with Quality testers and created test cases and test scenarios for the team.
  • Worked on SOA WebServices architecture to implement reporting functionality between salesforce and EDW, ADW.
  • Worked on XML and JSON codes to perform WebServices testing with the QA team.
  • Consulted with 3rd vendor during QA process to ensure testing is performed on the key requirements.
  • Prioritized defect fixes.
  • Created UAT plan for the project team
  • Conducted user demo for the business and created user manuals for customers.

Environment: SLC/Waterfall process, Sharepoint, SAP, SOA platform, JSON, Unified Modeling Language, XML, MS Word, MS Excel, MS Visio, MS PowerPoint, Confluence, Contact Center.

Confidential, San Antonio, TX

Lead Business Analyst / Systems Analyst / Writer

Responsibilities:

  • Created deliverables to meet the requirements of extremely fast paced environment.
  • Met and worked with stake-holders to evolve features and functionality during JAD sessions, interviews and meetings.
  • Prepared current business processes (AS IS) and respective mapping document of the current practices to understand work flows.
  • Participated in Project Initiation meeting and Project Planning meetings with teams.
  • Prepared TO-BE business processes from the AS-IS business process based on business and stakeholder feedback and requirement gathered during Kaizen sessions to improve the business process.
  • Worked extensively on service oriented architecture (SOA) platform to create API WebServices calls between service layers.
  • Studied and analyzed data feeds between service layers and created data mapping between source and target.
  • Followed Agile (Scrum) methodology.
  • Gathered requirements from on-shore and off-shore (UK, Australia & Hong Kong) business holders.
  • Analyzed, designed and created Business requirements documents.
  • Designed and implemented Servlet Filter between Oracle BRM and third-party taxation tool to derive currency conversion based on the customer's location.
  • Participated in migration of billing data from legacy database to Oracle BRM and Oracle EBS.
  • Performed data manipulation and data cleaning in order to avail clean customer information to the new database.
  • Created data reports to analyze domestic and international customer markets in terms of usage and revenue.
  • Involved in creating and tracking user stories backlog using Version One.
  • Participated in Backlog grooming sessions with PM, product owner and the team.
  • Involved in creating technical design document and UML diagrams.
  • Worked closely with Quality Analysts to create, validate and troubleshoot test cases and test scenarios.
  • Responsible for developing prototype designs, demonstrating them to project stake holders and gathering their feedback to prepare the code for development.
  • Involved in initiating the technical discussions on project design and development strategies.
  • Participated in daily stand-ups, story-sizing session and sprint-planning sessions along with the development and quality analysis team.
  • Identified and defined acceptance criteria for project iteration.
  • Created data-mapping sheets to support API calls from one service layer to another service layer.
  • Worked with architects to customize JSON and XML codes and creating architecture documents.
  • Worked on integrating Microsoft CRM with Oracle BRM to pull customer information for leveraging promotions and discounts on various accounts.
  • Published documentation on the web in the form of Wiki pages and user manuals.
  • Executed and modified SQL queries to retrieve data from Oracle database.
  • Created Gap Analysis matrix to study and trace the gaps in user stories and functionalities delivered.
  • Participated in Version One cleanup which involved removing duplicate user stories and re-arranging user stories according to Project Phases and time of project go-live.
  • Worked extensively on SOAP to perform testing and validate the output as per requirement.
  • Involved in end-to-end integration testing for a newly on-boarded cloud products like Load Balancers, SAS and DBAAS.
  • Responsible for implementation of Rackspace Cloud products using Oracle technologies such as BRM and Oracle network mediation.
  • Involved in conducting the QA and user training session. The training includes online web conference to class room sessions.

Environment: Agile (Scrum) methodology, Version One, Sharepoint, Oracle Billing Revenue Management Suite (BRM),Oracle EBS, Microsoft CRM, SOA platform, Unified Modeling Language, XML, MS Word, MS Excel, MS Visio, MS PowerPoint, SOAP, SQL, OBIEE, Confluence.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

  • Used Agile methodology for portal development and created artifacts for development team.
  • Worked with off-shore (Canada) business holders to ilicit requirements and created Business Requirement document.
  • Worked closely with the architects to created technical design documents like high level design (HLD) documents and detail design (DLD) documents for each application based on the requirements.
  • Created product backlog by writing user-stories as per the requirements.
  • Worked with technical architects to study feasibility of application on Liferay portal.
  • Created workflows in the applications starting from customer login to form review followed by final submission.
  • Worked with the UI team to create user interface screenshots to be presented to the Business.
  • Created and gave PowerPoint presentations for the business-holders to give a brief synopsis of the application functionality.
  • Designed application screen mock-ups and wireframes to support application development.
  • Developed Sequence Diagrams, ODD using UML.
  • Designed Activity Diagrams using UML to chart out various workflows that occur during customer transaction, and presented them to the SME.
  • Worked as an interface between the users and the different teams involved in the application development for better understanding of the business.
  • Participated in daily stand-ups and weekly status meeting with the on-shore and off-shore team.
  • Prepared use cases and test scenarios to assist quality engineers in testing.
  • Examined, analyzed and modeled test plans and test procedures.
  • Used MS Visio for flowcharting, process model and architectural design of the application.
  • Analyzed different types of Risks and insurances for appropriate application development.
  • Created user-guide/manual to demonstrate functionality of each of the portal applications built.

Environment: Agile Methodology, Liferay portal, HP Quality Center, MS Word, MS Visio, MS Excel, MS PowerPoint, SoapUI, Sharepoint, SQL, Unified Modeling Language.

Confidential, Chicago, IL

Business Analyst / Technical Writer

Responsibilities:

  • Worked extensively on Agile Development methodology (Scrum) and produced artifacts as per the system designs.
  • Acted as a liaison between business and the development team.
  • Gathered and documented requirements with from business stakeholders and end-users.
  • Wrote Epics, User-Stories and task as per the requirements.
  • Conducted meetings and JAD sessions with the business holders and team during inception phase to review Epics, User Stories and Tasks under each user requirement.
  • Participated in daily Sprint meetings to discuss story progress and challenges. Used JIRA to track User Stories and Tasks corresponding to each user story or epic.
  • Created Software Requirement Specification.
  • Carried on Object-Oriented Design and Analysis (OOA) and documented the same.
  • Worked on SOAP and REST services to develop messaging layer between the interfaces.
  • Analyzed LCE-exchange related data and created object models.
  • Worked on FIXML message specification for the project
  • Organized presentation for the team to review the documentation produced for each iteration at the start of each iteration.
  • Defined Acceptance Criteria for the team before the start of each iteration.
  • Created mapping to show FGW-Session-Firm-Exchange-LCE relationship.
  • Developed UML diagrams to demonstrate flow of events as the data is entered from the WebServices and designed various data and object models to elaborate the course of events.
  • Defined error codes and error text for the front end of the Risk Management application.
  • Worked extensively on FIX protocol and TIBCO tags by creating customer facing FIXML message types and tags supported by Risk Management API WebServices as well as the internal message payload supported by risk Management API, user interface and Fix Gateway.
  • Created user interface wireframes and mockup screen for the front end using Axure.
  • Worked with architects to publish technical documentation on the web.
  • Worked with QA team to define test cases and performed UAT (User Acceptance Testing).
  • Conducted tests using SoapUI to validate FIXML (XML) messages through the WebServices and the GUI.
  • Participated in project demonstrations along with the Quality analyst team after each release.
  • Worked on testing tool BRIO and SoapUI to test iLink, TIBCO tags and FIXML messages respectively.
  • Worked on Microsoft Office Suite (Word, Excel, Visio, and PowerPoint), Quality Center, Rational RequisitePro, JIRA, SnagIt, Sharepoint, Rational ClearQuest, and ClearCase.

Environment: Agile (Scrum) Methodology, JIRA, Quality Center, Rational ClearQuest, ClearCase, Unified Modeling Language, Axure, BRIO, SharePoint, SoapUI, MS Word, MS Excel, MS Visio, Confluence, Cliffy, SnagIt, FIX Protocol, iLink Tags, JSON, TIBCO Tags, SQL, XML, Putty.

Confidential, New York, NY

Business/Systems Analyst

Responsibilities:

  • Worked with Stake holders as Support Analyst, and user department staff to evolve features and functionality.
  • Prepared the current practices ( AS IS) and prepared a mapping document of the current practices to understand work flows
  • Created Business Requirement Document and Functional Requirement Document depicting the needs and scopes ofthe new system.
  • Followed Agile (Scrum) methodology, created storyboards and conducted brainstorming sessions to understand the client specifications and requirements· Documented the business process through Business Requirement Document and Functional Requirement Specification Document.
  • Conducted Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
  • Acted as a team lead on temporary basis.
  • Created System Requirement Specifications and Design Specifications for the project.
  • Designed Activity Diagrams using UML to chart out the various workflows that occur during customer transactions, and presented them to the SME.
  • Developed Sequence Diagrams, OOD using UML.
  • Performed Cost Analysis of the proposed system.
  • Created Traceability Matrix between Test cases and Functional Requirements.
  • Conducted Gap Analysis to ensure all requirements of the current process are met by the proposed system.
  • Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise using Scrum.
  • Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business
  • Developed prototype of new information processing application. Facilitated collection of requirements from system users and preparation of business requirement document using Rational RequisitePro that provided appropriate scope of work for technical team to develop prototype and overall system.
  • Using Scrum provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort and performed System analysis and organizational review of existing QA process.
  • Performed risk assessment and scope definition on data standardization project.
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
  • Conduced data analysis with Architects in order to map the data from source system to the target system and validated whether the data is correctly written in the target tables by using the SQL queries.
  • Experienced in data analysis, database design, data mapping, data mining and data gap/anomaly.
  • Documented the mappings used in ETL processes.
  • Designed and implemented basic SQL queries for QA testing and report / data validation.
  • Prepared the test cases for the scenarios.
  • Extensive experience in analyzing and documenting business requirements and system functional specifications including Use Cases and Gap Analysis.
  • Performed User Acceptance Testing (UAT) to test the functionality of the application.
  • Performed special projects and other duties as assigned.

Environment: Agile (Scrum) Methodology, Quality Center, UML, Rational Rose, Microsoft SQL Server, MS Visio, MS Word, MS Excel, MS Access, MS PowerPoint, Windows 2000 Professional, XML.

Confidential, NY

Business Analyst

Responsibilities:

  • Prepared the documentation of the required functionalities in the “TO BE” system.
  • Prepared the Use cases and test scenarios
  • Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering and prepared User Requirement Specifications document.
  • Involved in walkthroughs and meetings with development team to discuss related issues.
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Prepared the Mapping workflow documents for the CRM implementation.
  • Modeled the business and application using RUP methodology and UML.
  • Conducted Business Process Flow analysis by crafting Activity diagrams, Use Case diagrams and logical Class diagram according to UML methodology thus defining the Data Process Models.
  • Implemented and integrated RUP solution with complete line of traceability for all the artifacts of web development projects.
  • Involved in the creation and maintenance of the Workflow plans and artifacts.
  • Developed timelines for project delivery, and managed projects and resources to successful completion
  • Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
  • Analyzed different types of Risks such as Credit Risk, Market Risk etc and developed the test cases with all these parameters to analyze the securities.
  • Actively worked on large database maintenance activities including data modeling, mapping, development, integration, analysis and testing.
  • Based on the physical model, developed strategies for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
  • Worked with the UI team to create the User Interface screenshots to be presented to the Business.
  • Examined, analyzed and modeled Test plans & Test procedures based on RUP methodology.
  • Performed Gap Analysis of the AS-IS and TO-BE process within the organization to analyze and fill the existing gaps in the business processes.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • Worked on the project plan with the project manager using Microsoft Project
  • Acted as a primary liaison between the business line, operations, and the technical areas throughout the project cycle.
  • Wrote Stored Procedures, functions, views to perform several database level operations
  • Conducted the UAT.
  • Developed Test plans and scripts using Test Manager and utilized use cases as a basis for performing Integration and System testing.
  • Performed Regression Testing using HP Win Runner.
  • Worked with development and testing teams to accomplish timely release objectives.
  • Worked with DBA to resolve database related issues.

Environment: MS Word, MS Excel, MS Access, MS PowerPoint, Windows 2000 Professional, Windows Server, XP, UML, Cognos, MS Visio, MS Project, Test Manager, RequisitePro, Erwin Data Modeler, HP Win Runner.

Confidential, NJ

Business Analyst

Responsibilities:

  • Applied RUP methodology, created storyboards and conducted workshops, surveys, JAD sessions, rival service research, brainstorming sessions to understand the client specifications and requirements· Documented the business process through Business Requirement Document and Functional Requirement Specification Document
  • Gathered requirements from the Stake Holders and delivered BRD to the stake holders
  • Prepared the use cases and test cases
  • Used JAD sessions in gathering business requirements from various users and stakeholders to understand the needs of the business.
  • Extensively created use cases and activity diagrams using Rational Rose and requirement management using Rational Requisite Pro and Rational Doors.
  • Modeled the detailed design of the system using UML and Rational Rose, Use Case Diagrams, Sequence Diagrams, Activity Diagrams and State Chart Diagrams.
  • Involved in designing various GUI screens such as Portfolio selection based on date, kind of investment, Ratings, performance etc. and performing sensitivity analysis with changes in the parameters.
  • Created the conceptual data model working with the functional and technical team.
  • Developed logical /physical data models in Erwin based on the specifications built and established referential integrity on the system.
  • Worked on all phases of Data Warehousing like Data mining, Data Cleansing, Data modeling for data staging and Data Mart, ETL, Indexing, Quality Assurance, Data updating plan and Data presentation to business users.
  • Analyzed data ingeneral ledger, sub ledger and source system databases to identify sources of imbalance and variance.
  • Responsible for setting up QA procedures, process for testing the applications and products involving different types of testing and the associated documents and test cases and signoff documents.
  • Helped in developing QA Test plans for Functional, Integration and System Testing
  • Responsible for the overall logical and physical data modeling of the system for easy access to required data on time from data warehouse.
  • Extensively involved with backend testing by writing complex SQL queries.
  • Actively involved in Data Mapping of the entire module

Environment: Windows Server, RUP, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Rational Test Manager, Word, MS Excel, MS Access, MS PowerPoint.

Hire Now