We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

VA

SUMMARY

  • Self - driven Business Analyst with 10+ years of total IT experience in all aspects of SDLC - Requirement Gathering, Designing, Development and Testing.
  • Experience in elicitation of requirements using Joint Application Design(JAD) sessions and White Board Sessions with end-users, Subject Matter Expert (SMEs) team, Architects, development and QA team for project meetings.
  • Working experience of SDLC Methodologies such as Waterfall and RUP and knowledge of methodologies such as Prototyping, Agile Scrum.
  • Created Use-Case Specifications, Data flow Diagrams (DFD), UML Diagrams such as Use Case Diagrams and Activity Diagrams.
  • Comprehensive understanding of the Organizational Framework that help to map the AS-IS and TO-BE model using the GAP Analysis, Feasibility studies, and plan an effective approach to build solutions to the business problems/needs/opportunities.
  • Proficient in creating Test Plans, Test Cases and Requirements Traceability Matrix (RTM) to pinpoint software defects, track bugs, validate system functionality
  • Strong knowledge of SQL and Data Modeling. Good understanding of Normalization and proficient in SQL queries, Stored Procedures and User-Defined Functions.
  • Expertise in Unit testing, System Testing, Functional-Testing and UAT
  • Proficient in developing Conceptual and Logical Data-Models using E-R Diagrams.
  • Strong Communication skills and Interaction skills when working with stakeholders, subject area experts, Development team, system implementers, and application end-users.

TECHNICAL SKILLS

Analysis/Modelling Tools: UML, JAD, Data Flow Diagrams, ER- Diagrams

Databases and concepts: SQL Server 2000/2005, MS Access, Oracle 8i/9i/12c, PL/SQL

Requirements Management Tools: Requisite Pro, Rational Doors

Quality Assurance Tools: Quality Center 9.2, HP ALM, JIRA, Bugzilla, TOAD, DB Visualizer

Operating Systems: Windows NT/XP, Windows 7, Windows 8, Windows Server 2003, Unix

Change Management Tools: Rational Clear Quest, Visual Source Safe

Languages: C#, SQL, JavaScript, UML, HTML, XML, CSS, Cobol, PL/SQL

Tools: Microsoft Office (Word, Excel, Power Point, Project, Outlook), MS Visio, Lotus Notes

SDLC Process/Methodologies: RUP, WATERFALL, AGILE (Scrum)

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Business Analyst

Responsibilities:

  • Coordinated process owner and stakeholder meetings and interviews to analyze various business processes and identify business needs in the default loan management module.
  • Performed Gap analysis and developed ‘As Is’ and ‘To Be’ process flow diagrams for the Default Management and payment processing modules and led meetings with the SMEs (subject matter experts) to verify the same for accuracy and completeness.
  • Worked as a liaison between business users, testers and application development team so that all users understand business needs clearly without ambiguity.
  • Performed elicitation and documentation of business and customer requirements, using Requisite Pro.
  • Developed User Acceptance Test Planning including test cases to verify user requirements, documented the defects and followed through the issue resolution until sign off.
  • Exercised SQL queries to retrieve borrower payment history and analyzed data for default trends and generate reports.
  • Improved trend reports for senior management to increase their ability to identify inefficient processes, gauge individual accuracy, quality of work and overall comparison of relative performance.

Environment: Microsoft Office (Excel, Word), Agile, MS Visio, UML, HP ALM, MS SQL Server, SQL, Requisite Pro

Confidential, VA

Sr. Information Analyst

Responsibilities:

  • Proposed a strategy, using the timeline, testing times, and knowledge about what integration points will be key for common core proposed by DEd & CEDS (Command Education Data Standards).
  • Developed Positive and Negative Test Data based on business requirements and a Source to Target (S2T) mapping document to make sure all the business rules were covered.
  • Gathered the Answer Sheet specification requirements with sample data and identified the gap with external vendors (DoE, ETS, Pearson, XEROX and K-12)
  • Created data mapping specification for EDM (Code & Base tables) and tested the data set using SQL.
  • Baselined the data feeds specifications and change control (CQ) used for updates

Environment: HP ALM, MS Word, Excel, PowerPoint, DOORS, Rational Clear Quest, Ab Initio GDE

Confidential, CA

Business Systems Analyst

Responsibilities:

  • Participate in Requirement Elicitation efforts in order to gather and document business requirements primarily for the User Interfaces and explore potential solutions.
  • Facilitate JAD sessions with the Team members and stakeholders and translate the business requirements into functional and non-functional specifications.
  • Involved in creating RTM, test scenarios and test cases with the QA team and verified that all the client requirements have been precisely incorporated in the system design
  • Use systematic techniques for specifying requirements - like use-case scenarios and flow diagrams.
  • Create mock-up User Interfaces and Data Mapping that will cater to the customer’s requirements and make modifications as needed.
  • Used Quality Center to verify that all the test cases have been addressed.

Environment: Visual Studio .Net, C#, ASP.Net 2.0, SQL Server 2005, XML, JavaScript, Microsoft Commerce Server, Visual Source Safe 6.0, HP Quality Center, MS office suite.

Confidential, OH

Business/Data Analyst

Responsibilities:

  • Created Data Flow Diagrams to represent data flow from the various Applications and Databases to the MDW.
  • Analyzed business requirements and converted them into Functional Requirements, Business Rules, and Non-Functional Requirements.
  • Documented requirements per Confidential ’s System Requirement Specification templates.
  • Interviewed business SME’s to solicit requirements and remediate gaps in business requirements.
  • Used DOORs to maintain requirements and to create requirements to business rules traceability.
  • Identify data subject matter experts to assist in defining the meaning of data attributes in use.
  • Interviewed stake holders and data SME’s to identify data sources.
  • Identified data elements required for reporting and created data mapping.
  • Created UAT plan, conducted a detailed walkthrough with all the teams involved in UAT and executed the UAT Plan.
  • Extensively used SQL to create Expected results based on requirements and business rules.
  • Assisted the SME’s in UAT execution and led defect tracking and resolution.

Environment: SQL, Microsoft Office Suite 2010, MS Visio, IBM Doors, IBM Clear Quest, Oracle, DB2, MS SQL Server

Confidential

Business Analyst

Responsibilities:

  • Worked on change requests and enhancements involving changes to the Front End, Business Layer and Data Layer.
  • Worked on requirements for major enhancements which involved extensive modifications to stored procedures and Functions on SQL Server 2005.
  • Created ERD’s to document the design of new entities to be created on SQL Server 2005 as part of the enhancement.
  • Documenting and tracking defects using Bugzilla and follow-up with the development team in order to resolve defects.

Environment: Visual Studio .Net, C#, ASP.Net 2.0, SQL Server 2005, XML, VSS 6.0, Bugzilla

Hire Now