SUMMARY

• In - Depth knowledge of SDLC, good understanding of various phases like Requirements, Analysis, Design, Development and Testing. Expertise with Agile, Scrum and Waterfall methodologies.
• Strong understanding of Business Requirement Gathering, Business Process Flow and Business Process Modeling.
• Experienced in writing Project Charters, Vision document and Project Communications plan.
• Experience in conducting Joint Application Development (JAD) Sessions with various business groups, stakeholders, department heads and end users.
• Possess excellent business writing skills required for documenting Business Requirements Document (BRD), Functional Requirements Document (FRD), and Non-Functional Requirements Document (NFRD).
• Proficiency in UML for creating Use Cases, Use Case Diagrams, and Activity diagrams.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Experience in conducting GAP analysis and create the As-Is and To-Be processes flows.
• Experience supporting the business users with User Acceptance Testing (UAT).
• Experience with various project management activities including Schedule Management, Risk and Scope Management, Resource Management, Deliverable Management and Quality Management.
• Good experience in writing the Project Assessment Quotation (PAQ) responses for state government projects.
• Strong SQL skills and ability to compare large volumes of data.
• Experience working on Business Intelligence projects and have good understanding of Data Warehousing and ETL concepts.
• Collaborated with QA teams in most of the projects as part of various testing cycles.
• Strong understanding of BABOK & PMBOK guidelines.
• Experience working with distributed teams within the US and off-shore teams.

TECHNICAL SKILLS

Requirements Management Tools: Team Foundation Server (TFS), JIRA, Rational Requisite Pro, Rational Team Concert (RTC), Rational DOORS

Business Modeling Tools: Rational Rose, MS Visio, MS PowerPoint

Languages: C, XML, VB Script, HTML

Data Bases: SQL Server, DB2, Microsoft Access, Oracle

ETL & Business Intelligence Tools: Informatica PowerCenter, SSRS, Crystal Reports

Testing Tools: Microsoft Test Manager (MTM), Coded UI, Quality Center, Rational Quality Manager (RQM)

PROFESSIONAL EXPERIENCE

Confidential

Lead Business Analyst

Responsibilities:

• Involved in the contractual agreement discussions between State of Ohio and Accenture in identifying the base contract and change order scope items.
• Facilitate JAR sessions involving subject matter experts and inter agency representatives to gather high level business requirements.
• Facilitate Joint Application Development (JAD) sessions involving cross-functional team including major stakeholders from various business units, SME’s, and development teams to gather, define and document functional and non-functional business requirements.
• Assisting the business and technical units with defining design objectives and design documentation based on the requirements gathered.
• Convert high level requirements to low level functional/technical design documents (FDD/TDD).
• Consult with business units on current issues and concerns to help identify and clarify their goals and technical requirements.
• Participate in designing the user interface for the new application along with the technical team and creating multiple mock-up screens and prototypes to better explain the user interface.
• Conducting functionality and application walkthrough sessions for key stakeholders during different phases of the SDLC to receive formal approvals.
• Perform data and gap analysis between the existing CRIS-E application and new Confidential application. Create As-Is and To-Be processes flows, documenting and diagramming current state business processes, desired/future state high-level business processes.
• Working with QA team in writing test plan and test cases based on the requirements gathered.
• Actively involved in System, Functional and Integration testing and supporting the User acceptance testing (UAT).

Environment: SharePoint, Rational Team Concert (RTC), Rational DOORS, Rational Quality Manager (RQM), SQL, Java, Oracle, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint and Outlook), Microsoft Project.

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Leading a team of 5 business analysts to analyze the current systems and create the functional artifacts for the proposed system.
• Authored the project charter and communications plan.
• Working closely with Confidential employees to elicit the requirements - Facilitating Joint Application Development (JAD) sessions and Brainstorming sessions involving the management and development teams to gather, define and document high-level business requirements on behalf of the business including acceptance criteria for each requirement.
• Extensively using SharePoint and Team Foundation Server (TFS) to keep track of all the existing and new business requirements and rules.
• Assisting the project manager in multiple activities including Project Timeline, Resource Management, Change Requests, UAT planning, User coordination across all 88 counties of Ohio.
• Single point contact for Third party service providers (TPSP) serving the car dealers in coordinating testing and production issues for Dealer Portal.
• Leading the coordination efforts for requirements and testing activities in obtaining the National Motor Vehicle Title Information System (NMVTIS) certification for the Department of Public Safety, State of Ohio.
• Involved in defining the Scope and understanding client’s expectations.
• Authored Epics, Features and User stories at different levels of granularity. Maintained all the user stories within different projects created in TFS.
• Actively managed the Product Backlog on behalf of the Product Owner.
• Facilitated the Sprint Planning, Sprint Review and Sprint Retrospective sessions with the required participants.
• Active Scrum team member and also responsible for organizing the Daily Scrum meetings.
• Participate in designing the user interface for the new C# .Net application along with the technical team and creating multiple mock-up screens and prototypes to better explain the user interface.
• Created Activity diagrams to display the sequence of activities from start to end for multiple business processes.
• Created Class and sequence diagrams to include in the Design document(s) submitted for third party vendors and external interfaces.
• Maintained Requirements Traceability by creating custom queries in TFS and maintained it throughout the project lifecycle to track the requirements.
• Identified potential change requests and escalated to the management in weekly status reports and as part of leadership meetings.
• Using SharePoint to upload and obtain approvals from the leadership.
• Gathered requirements and involved in the design and implementation of Physical and logical Data warehouse models.
• Perform data and gap analysis between the existing Oracle Forms Confidential II application and new C# .Net Confidential Blue application and create the As-Is and To-Be processes flows, documenting and diagramming current state business processes, desired/future state high-level business processes.
• Using Visio to create business process flows including standard flowcharts and swim lane diagrams.
• Responsible for answering the static questions from testing team as part of static triages and actively participated in bug triages.
• Assisted the testing team in creating test cases and executing in various environments.
• Actively involved in System, Functional and Integration testing and will support the User acceptance (UAT) testing.
• Wrote multiple SQL queries to validate the actual results for test cases.
• Assisting the database team in validating data during data conversion process.
• Conducting functionality and application walkthrough sessions for key stakeholders during different phases of the SDLC to receive formal approvals.

Environment: Agile methodology, SQL Server, Team Foundation Server (TFS), SharePoint, SQL, Lotus Notes, C# .Net, Oracle, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint and Outlook), Microsoft Project.

Confidential

Sr. Systems Analyst

Responsibilities:

• Facilitated Joint Application Development (JAD) sessions involving the management and development teams to gather, define and document high-level business requirements/user stories on behalf of the business including acceptance criteria for each user story.
• Consult with business partners on current issues and concerns to help identify and clarify their goals and technical requirements.
• Created the As-Is and To-Be business processes to identify the gaps in the current system.
• Created multiple mock-up screens and prototypes to provide a better understanding to the clients.
• Participated in defining and prioritizing project work and requests.
• Accurately translate business requirements into user stories.
• Assisted ETL developers in creating Mapping specification documents for the existing Informatica mappings.
• Worked with the ETL developers in creating transformations, mapplets and mappings using Informatica Designer and sessions and tasks using Workflow Manager to move data from multiple sources into targets.
• Worked with different data sources like Flat files, XML files, and other relational and non-relational databases.
• Provide input to training efforts and helping business partners effectively use systems.
• Created Requirements traceability matrix and maintained it throughout the project lifecycle to track the requirements.
• Worked with the QA team in writing test plan and test cases based on the requirements.
• Actively involved in System, Functional and Integration testing and supported the User acceptance (UAT) testing.
• Involved in writing SQL queries to generate and test the reports.
• Involved in writing SQL queries to research and identify any data issues.
• Used JIRA for approvals and to track the System, Integration and UAT testing issues.

Environment: Agile, Scrum, Microsoft Office, MS Project, JIRA, SVN, Bamboo, Traceability Matrix, HP Quality Center, SQL, Informatica PowerCenter 9.5.1, Crystal Reports, ETL