We provide IT Staff Augmentation Services!

Sr Business Analyst Resume

Washington, DC



  • Methodology knowledge of SDLC processes including waterfall development, modified waterfall development, and Agile.
  • Strong sense of commitment to quality, schedule, communication, and presentation.
  • Demonstrated expertise in developing, executing, and maintaining automated and manual test scripts.
  • Proven knowledge soliciting, analyzing, and documenting functional/business/application requirements.
  • Serve as a liaison between business sponsors and technical staff while taking on the key responsibilities of managing expectations of business users.
  • Experience in leading analysis and requirement - gathering efforts for application development projects.
  • Skilled in conducting Joint Application Design (JAD) sessions, brainstorming sessions, requirement reviews, system walkthroughs and customer interviews for various business processes.
  • Ability to critically evaluate information gathered from multiple sources, reconcile system, process or data conflicts decompose high-level information into details and distinguish presented user requests from the underlying true needs.
  • Expert in gathering requirements and document, track, manage and created Requirements Traceability Matrix (RTM).
  • Experience in Functionality, Usability, Reliability, Performance, Regression and UAT testing.
  • Well versed in writing test cases, test plans and Defect Tracking (using Clear Quest and Quality Center).
  • Assisted the project manager with activities like development of business processes, resource management, issue/risk analysis and associated documentation.
  • Experience in writing and executing SQL queries in Toad.
  • Experience in working with Microsoft Office suite (Word, Excel, Access, Visio, Power Point, Office and Outlook) for documentation, analysis and presentation.
  • Experience in Writing User stories in JIRA.
  • Strong analytical, interpersonal, communications and problem-solving skills resulting in efficient & effective execution of client projects.


Methodologies: SDLC, Waterfall, Agile

Databases: Microsoft Access, Oracle 10/11g, MySQL, MS SQL Server

Software: DOORS, Rational Clear Quest, Rational Requisite Pro, HP Quality Center, Microsoft Office; Access, MS Excel, Power Point, Outlook, Visio, Project, SharePoint, Adobe Acrobat, Adobe Illustrator, SAP

SQL Tools: Toad, SQL Plus

OS: Microsoft Windows, UNIX (Sun Solaris)

Defect Tracking Tools: HP ALM, JIRA


Confidential, Washington, DC

Sr Business Analyst


  • Accurate capture of Business requirements, functional and non-functional in the office repository
  • Work with stakeholders to define specific needs and priorities
  • Assisting and sending weekly reports to the project manager regarding different teams business/technical.
  • Following up with the testing teams regarding the test cases
  • Capture and maintain the stakeholder RACI matrix for business functions and information entities Triage system issues and work with technical teams as needed
  • Analyze impact of business process changes on existing systems
  • Validation of requirements feasibility with other functions
  • Maintain business process and requirements catalogue for systems in use. Tracing requirements to the business processes and the applications
  • Disseminating business requirements (e.g. walk-throughs) with delivery and support teams
  • Facilitate the balancing of business needs and product offerings in COTS implementations
  • Evaluate the feasibility of changes in requirements with all functions prior to finalizing with the business
  • Managing requirements baselines and changes to them, including validation with the functional teams
  • Coordinate User acceptance testing of system issues and resolutions
  • Working closely with business & teams to verify, analyze & manage business and system requirements.
  • Act as the liaison between the business and technical teams
  • Writing testing strategy and tip sheets.

Environment: JIRA, MS Office Suite, MS VISIO, HP ALM, SAP

Confidential, Mclean, VA

Sr Business Analyst


  • Comprehends basic to complex business issues and contributes to IT business projects by translating business needs into understandable requirements
  • Maintained User stories in JIRA, worked with product owner in grooming backlog items and setting release scope
  • Works on web based user Interface(UI) applications.
  • Created adhoc excel reports using pivot tables
  • Wrote SQL queries to validate data in the backend matches with the report in frontend
  • Support changes and enhancements from development through production; recommending and implementing system enhancements and testing
  • Develops new program specifications to support specific user needs and system upgrades, including new releases and resolves problems with the current system
  • Analyzes system enhancement requests to determine feasibility, extent of changes, resource requirements and project time estimates
  • Meets with users to determine the end user’s specific needs within the system
  • Provides daily production support, including maintenance of the database, completion of routine service requests and research problems
  • Involved in writing and modifying SQL validation scripts and writing scripts in SQL/PLSQL to validate the outputs
  • Translates business requirements into business needs and the go to person between the technical and business teams
  • Also executed various SQL Queries to perform the backend testing
  • Manages the merger and maintenance of new data to be ingested in the system
  • Perform Research analysis and identified functional points and converted business needs into Business requirement document (BRD) and Software requirements specifications (SRS) and User Interface (UI) specifications.
  • Maintains manuals, standard business and status reports, training material, and other documentation
  • Provides users with application documentation of fixes and/or enhancements and communication

Environment: JIRA, MS Office Suite, MS VISIO, Toad Oracle11g, HP ALM, DOORS, SharePoint, SQL, Pivot Table

Confidential, NY

Business Data Intelligence Analyst


  • Participated in meetings with the business users to understand and confirm business objects reporting requirements. Conducted workshops with them to confirm the sample report layouts.
  • Creation of data mappings specification documents and doing enhancements to ensure the document adheres to the new requirements.
  • Refined/groomed product backlog items and defined acceptance criteria.
  • Maintained User stories, created subtasks for developers and Testers.
  • Creation of landing zone tables in database for comparing and filtering the unchanged data; staging zone tables where the data is cleansed and finally loaded into the EDW.
  • Extracted data from existing data source and performed ad-hoc queries using SQL.
  • Coordination with Development and QA team
  • Documented and Reviewed Requirements to build the Business Requirement Document for the 1’st Phase of the Project.
  • Worked closely with data architect and data modeler to design logical and physical data model.
  • Fine tuning and optimizing the mappings to improve the performance thereby decreasing the run time.
  • Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Generating estimates of Change Requests for new and amended functionality.

Environment: Oracle 10g, Business Objects XI R3, SQL, Toad, Info view, DOORS, Agile

Confidential, Washington D.C.

BA / Quality Assurance Analyst


  • Liaison with Client, development, operations and technical support teams to document the requirements.
  • Study business requirements and conduct User Interviews to identify and document the requirements.
  • Help Project Manager in designing and updating the Product Flow diagram.
  • Update and maintain requirements.
  • Provide requirement clarifications to development and testing teams.
  • Involved in developing Test Plans and test cases using Requirement and Design documents while specifying testing overview, approach, strategy, scope, roles and responsibilities.
  • Execute test cases in Quality Center and raised defects in Clear Quest for logging, tracking and reporting bugs in the application.
  • Created traceability matrix (RTM Reports) report prior and post user acceptance testing.
  • Worked with cross functional teams in order to establish comprehensive business and functional requirements and translate those requirements into software design specifications using various notations of UML.
  • Execute SQL queries for data retrieval and validation.
  • Communicate daily updates and issues through status meetings.
  • Work with project manager and the development team for production verification.

Environment: HP Quality Center, Clear Quest, Oracle, UML, SQL, MS Power Point, MS Excel, MS Visio, MS Word

Confidential, DE

Business Analyst


  • Worked with cross functional teams in order to establish comprehensive business and functional requirements and translate those requirements into software design specifications using various notations of UML.
  • Conducted requirements analysis and performed GAP analysis.
  • Facilitated JAD sessions with the clients to gain an understanding of the issues and drive to a solution.
  • Performed Extensive Data Analysis on Oracle Databases.
  • Developed Source to Target Mappings using Excel Spreadsheets and maintained them by versioning.
  • Executed SQL to ensure data is populated into correct table and data integrity is maintained.
  • Submitted change requests, viewed and modified existing change requests, checked already listed data quality issues using Rational Clear Quest.
  • Worked in Mercury Quality Center to write and execute test cases based on business requirements.

Environment: HP Quality Center, Clear Quest, Oracle, SQL, MS Power Point, MS Excel, MS Visio, MS Word

Hire Now