­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­

SUMMARY:

• 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.

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr Business Analyst

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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