SUMMARY

• A seasoned professional with over 10 years of supporting IT applications in various domains
• Worked with multiple client groups to elicit requirements and prioritize issues.
• Thorough knowledge and understanding of Waterfall and Agile/lean concepts.
• Proficient and has abundant knowledge of Business Process, Software Development Life Cycle (SDLC) and testing life cycle and has first - hand experience with the ITSLCM.
• Have experience in various operating systems including Windows and UNIX and has hands-on experience on web-based, window-based application and GUI applications.
• Have years of experience using the tools such as Remedy, DOORS, Zendesk, JIRA, Serena/HP Business Manager tool for Incident Management.
• Experience in Functional, Integration, Regression, GUI Testing and User Acceptance Testing (UAT).
• Expert in Advanced Excel and its features like Pivot Tables, Charts, Functions like VLOOKUP, HLOOKUP, etc
• Have excellent communication skills and ability to work independently and in a team.
• Excellent knowledge of SQL for querying databases for testing, data analysis and data fixes.
• Proven track record of maintaining beneficial client relationships.
• Excellent analytical and problem solving abilities.
• Self starter with a demonstrated ability to achieve results as part of an effective team.
• Self-taught person in terms of the latest technological trends.

TECHNICAL SKILLS

Methodologies: Agile-Scrum, Waterfall Issue/Defect Tracking

Requirement Management Tools: Remedy, JIRA, Zendesk, PVCS Tracker, PVCS Version Manager, Rally, Peregrine Service Center, HP Service Manager, SharePoint

Rational Requisite: Pro, DOORS

Databases: MS-Access, Oracle

Database Tools: Toad for Oracle, Benthic Golden, SQL Plus, SQL Developer

Workflow Tools: MS-Visio, MS-Office Suit

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Sr. Business Analyst Lead

Responsibilities:

• Analyzed, documented and managed all project requirements and any changes to requirements throughout the software development lifecycle.
• Worked closely with the Development team to validate that the technical design meets the business requirements.
• Gathered business requirements by conducting interviews and group discussions. Translated business needs into functional requirements. Conducted JAD sessions.
• Created process flow diagrams using Visio representing cross functional team flow via Swim Lane diagrams.
• Created Business Requirements (BR) Document, analyzed constraints, created Training documents and guides for users.
• Created project documentation including business case, detail requirements, requirements traceability etc.
• Created test scenarios, test cases and test reports to display results.
• Created SQL queries to support back end testing, involved in setting up of test data and supported data fix on Oracle database.
• Lead the UAT effort by supporting customers with test scenarios and test data.
• Lead the Release Planning effort and provided deployment support to validate applications that have been deployed into Production.
• Created and implemented processes for speedy ticket assignment and resolution.
• Created several reports for management to monitor ticket resolution time and also product release cycles.
• Educated customers on software applications, usage and functionality.
• Identified, troubleshot and resolved many application issues, or business issues to exceed customer expectations.
• Performed Root Causes analysis on frequent occurring incidents and produce report for the management.
• Provided training support to users at the end of the release cycle.
• Provided cross-team training on various applications developed at Confidential .
• Provided quick responses and technical solutions to user requests for several applications at Confidential .
• Gathered user issues, analyzed, prioritized and documented using JIRA.
• Responsible for conducting meetings with users for Open tickets in remedy/JIRA and Production support team meetings.

Environment: MS Office Suite, MS Visio, SharePoint, SQL, Oracle

Confidential, Washington, DC

Business Analyst/Operations Engineer

Responsibilities:

• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans.
• Managed and supported testing team, served as Subject Matter Expert (SME) on the team supporting development and testing team.
• Gathered user issues, analyzed, prioritized and documented them using PVCS Tracker.
• Created test data using various Confidential applications and SQL.
• Performed data analysis as needed, in order to provide production and operations support to the client throughout.
• Ran data fixes as needed using SQL, against an Oracle database.
• Created and executed scripts to update erroneous records in production.
• Supported several key payment processing applications (Web based as well as client-server applications) in use at the Confidential .
• Supported an online letter generator application that was critical for member communication.
• Analyzed and determined the data that erred during application processing using Oracle to resubmit and reprocess data transactions on a daily basis.
• Provided testing support during COOP (Continuity of Operation) activities. Provided Post-Deployment and COOP support to the client.
• Was responsible for running the monthly Health Care Tax Credit report which is a complex and extremely time sensitive report delivered to Congress.
• Ran the Benefit Determination Letter (BDL) monthly report, using Crystal Reports, which is a critical report delivered to executive management in an accurate and timely fashion.
• Provided quick responses and technical solutions to user requests for several applications at Confidential.
• Also provided daily, weekly and monthly reports for different applications as needed.
• Provided training support to users at the end of the release cycle.
• Provided cross-team training on various applications developed at Confidential .
• Prepared ad-hoc reporting and management reporting by working with senior management and business managers

Environment: MS Office Suite, MS Visio, PVCS Version Manager, Merant Tracker SQL, Oracle

Confidential, Knoxville, TN

Sr. Business Analyst

Responsibilities:

• Gathered requirements for Web interfaced Loan Servicing application.
• Supported daily activities of client accounts and addressed concerns regarding Bankruptcy, Foreclosure and Loss Mitigation.
• During enhancement and modernization, facilitated and elicited meeting sessions with Business and Users to get requirements for application involving federal flood, hazard, tax and PMI.
• Decomposed requirements to lowest details for technical team and supported development efforts.
• Created prototypes using Visio and PowerPoint to present the mock-up designs and got users inputs/feedbacks.
• Analyzed testing requirements and contributed towards developing Test Scenarios, Test Plans, Test Case and Test Results documentation.
• Supported QA team during Functional testing, Regression testing, System and Integration testing.
• Verified setups to handle activities related to assessment of loan application for loan qualification.
• Generated reports for processing activities on number of loan application received and processed and pending applications.
• Created and executed SQL queries against database during data validation and help in setting up data for testing and verified in the application after the fix.

Environment: HP Quality Centre 10.0 Rational Clear Case, Rational Clear Quest, Rational Doors, Quest TOAD for Oracle 10g, MS-Access 2003/2007, MS Office Suite, MS Visio

Confidential, Knoxville, TN

Business Analyst

Responsibilities:

• Gathered business requirements by conducting interviews and group discussions.
• Translated business needs into functional requirements. Conducted JAD sessions.
• Created project documentation including business case, detail requirements, requirements traceability etc.
• Analyzed the As-Is and created the To-Be process.
• Conducted gap analysis to define the impact of new requirements on existing system.
• Analyzed, documented and managed all project requirements and any changes to requirements throughout the software development lifecycle.
• Worked closely with the Development team to validate that the technical design meets the business requirements.
• Analyzed testing requirements and contributed towards developing Test Scenarios, Test Plans, Test Case and Test Results documentations.
• Involved in shakeout testing after data migration from production environment to test environment.
• Verified data integrity by Backend testing of the application by writing SQL queries.
• Created Test Cases and mapped the test cases with requirements in Quality Center and generated the RTMs.
• Validated test results, logged defects and generated defect reports using Quality Center.
• Involved in preparing Test Evidence reports and Test Summary Reports.
• Assisted in developing test scripts for GUI Applications, functionality and regression testing.
• Involved in writing Oracle SQL queries to test the data integrity of the backend database
• Communicated with the Development Team concerned on the bugs & issues and resolved.
• Coordinated with the other team members and escalated the priority issues.

Environment: MS Word, MS Excel, SQL, Oracle, MS SharePoint 2003, Mercury Quality Center