SUMMARY:

• Business/Requirement Analyst with five+ years of experience; proven to work with tight schedules and deadlines.
• Strong knowledge of business/process dataflow in organizations and experienced in data ware housing.
• Experienced working on Gherkin for Documentation and later on helpful for automated testing, mostly in Agile environment.
• Worked on Process chain management and Production support as an Analysis Process Designer.
• Experienced with business reviews, functional and system level requirements reviews, and design reviews.
• Possess sound knowledge of various Software Development Life Cycle (SDLC) methodologies such as Waterfall, Agile, Rapid Prototyping and the Rational Unified Process.
• Experienced in the documentation of system, technical and business requirements and specifications, root - cause analysis, GAP analysis and forecasting the risk.
• Experienced in design and development of use and test-case scenarios, developing test plans, test scripts using SQL, conducting System Integration testing (SIT) and user acceptance testing (UAT).
• Experienced in training and implementing new processes and technology.
• Excellent organizational, communication and interpersonal skills while being Self-motivated, adaptive and able to work in a team or independently in a deadline-driven environment.

TECHNICAL SKILLS:

Methodologies &Concepts: RUP, Agile, Waterfall, Wireframes, UML, Root cause Analysis, Project Management, Risk Analysis

Testing Tools: Rational Enterprise Suite, WinRunner, LoadRunner Quick Test Professional

Business Applications: MS Office suite, Star Office suite, Gherkin Documentation

RDBMS: Oracle 8i, 9i, 10g, MS SQL Server, MySQL 5.6, MS Access

Project Management: Microsoft Project, Microsoft Office.

Programming Languages: SQL, PL\SQL, Visual Basic, HTML, XML, UNIX, C

Databases: Oracle 8i/9i/10g, MS SQL Server, MS-Access, IBM DB2

Web Technologies: Microsoft FrontPage.

OS & Server Environments: Windows NT,XP 95/98, Outlook, Unix, Oracle Application Server

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

Business Analyst II

Responsibilities:

• Facilitating Scrum of Scrum framework for offshore teams in India and leading them supporting PO.
• Playing the role of a Requirement Analyst in a RUP environment by eliciting Business Requirements from business users by conducting various meetings.
• Maintaining and keeping track of stakeholders request for system enhancements and changes.
• Using Rational Requisite Pro to analyze and document requirements.
• Preparing Wireframes using MS Visio for User Experience design.
• Working with development and testing teams to accomplish timely Sprint objectives.
• Analyzes the system functionality in relation to impacts of the change requests and other system modifications.
• Documents the change requests providing the reasons and root cause of change while conducting Root Cause Analysis.
• Creates and Modifies the Use Cases for the incoming change requests and system enhancements using MS Visio.
• Empowering and facilitating teams to self - organize and grow cross-functionality
• Protecting team from over-commitment, manage backlog, prioritize resolution of defects/bugs as evidenced by the on-time delivery of 33 major initiatives
• Managing the lifecycle of code development, from ideation to sprints to deployment
• Coordinating and managing code releases and shared APIs with other IT groups
• Communicating with other management, engineers, product managers and support specialists on product issues
• Tracks and communicate with team on velocity and sprint/release progress
• Using Test Director to create reports and graphs to help review the progress of planning tests, running tests, and tracking defects.
• Provided ROM for various projects and system enhancements.
• Reviewed test objectives to make sure that all the possible scenarios causing no risk, are tested for the system enhancements.
• Conducting Sprint Meetings and Brainstorming Sessions for the team.
• Developed project delivery schedule, managed projects and identified resources to successful completion.
• Have excellent technical writing skills with self-motivation and punctuality.

Confidential, Columbus, OH

Business Analyst II

Responsibilities:

• Gathered requirements through interviews, meetings, and existing documentation.
• Set up meetings, conducted Walkthroughs, JAD sessions with Management, SME (Subject Matter Experts), vendors, users and other stakeholders to flesh - out issues and to resolve open and pending issues and to develop specifications.
• Identified and refined scope -- developed scope documents
• Analyzed and documented current state workflow and developed future state using MS Visio, Rational Rose
• Analyzed the requirements and created the Use Case Diagrams, Activity Diagrams, Sequence Diagrams, flow diagrams in Visio for data analysis.
• Conducted gap analysis between existing and future state systems
• Created and managed project templates, requirement types and traceability relationships in Rational Requisite Pro.
• Developed Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace each software requirement to test case.
• Worked on RW2 and Gherkins for documentation and testing of the requirements on the terms of the project criteria.
• Created mapping documents for integrating various systems through a common interface.
• Worked in cross functional teams to identify and resolve issues posed by integration.
• Worked on wire frames, screenshots to develop UI specifications.
• Logged required technical enhancements, defects, and resolved requirement issues, in Excel.
• Involved in extracting and transferring data with data ware house team.
• Participated in team meetings for data ware house concepts, facts and dimensions.
• Worked gathering requirements and used Gherkins for documentation and automated testing for data analysis in simplified notions.
• Assigned problems to appropriate software development team for fixes and resolved requirements issues.
• Attended weekly status reports for project planning and data analysis.
• Checked Test Cases and developed strategies with testing team to track and resolve defects.
• Conducted familiarization, training sessions for business users.
• Involved in Financial team audit discursions to analyze the financial risks and suggested required changes.
• Excellent communication skills and problem solving skills with the clients and non-technical persons.

Confidential

SQL DEVELOPER/DATA ANALYST

Responsibilities:

• Monitor the Database for duplicate records.
• Merge the duplicate records and ensure that the information is associated with company records.
• Resolve the data issues by following up with the end user.
• Coordinate activities and workflow with other Data Stewards in the firm to ensure data changes are done effectively and efficiently
• Review and analyze the database to identify and recommend adjustments and enhancements, including external systems and types of data that could add value to the system.
• Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Wrote T - SQL Scripts to manipulate data for data loads and extracts.
• Utilized several Transformations like Lookup, Aggregate, Conditional Split, and Derived Column for implementing the Transformation Logic in the Packages.
• Ensured better results using Ad- hoc reports.
• Created Stored Procedures, Tables, Functions, and Triggers in SQL Server 2008.
• Analyze the large datasets to draw key marketing insights from the dataset results.
• Assist with end user in training.