SUMMARY

• 8+ Years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications and Application Design.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) using Waterfall, Iterative, Agile, RUP (Rational Unified Process), and other internal SDLCs and technology delivery frameworks.
• Highly skilled Business Analyst with strong domain knowledge in Retail and Insurance industries.
• Experience in interviewing users, analyzing documents, surveys, site visits, use cases, business analysis, task, and workflow analysis.
• Working experience with the UI/UX designer and bridge the gap between graphical design and technical implementation.
• Extensive experience in gathering Business and Functional Requirements, developing Use Cases, conducting Gap Analysis and Impact Analysis, modeling Businesses Processes, preparing manuals and Knowledge Transfer manuals.
• Proficient in gathering and analyzing user requirements, creating Business Requirement Documents (BRD), Functional Specifications Documents (FSD), Prototyping, UML Diagrams using various tools including MS Visio, Rational Rose.
• Possess In - depth knowledge of software QA methodologies and Strategies like Waterfall and Agile Scrum.
• Experience in Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Established, maintained and terminated MS access for users on multiple applications while providing problem resolution to customers.
• Very good understanding in coordinating Joint Application Development (JAD) sessions.
• Proficient in Microsoft Word, Power Point and MS Access.
• Possess reasonable understanding of different relational databases, writing SQL queries, creating tables, and generating reports
• Strong organization skills with the ability to work on multiple projects/assignment simultaneously.
• Strong interpersonal and communication skills with the ability to express technical and business concepts.
• Ability work under pressure and tight deadlines.

TECHNICAL SKILLS

Business modeling: Microsoft Visio, Model N Revenue Management suite

Documentation: MS Office Suite (PowerPoint, Word, Excel, MS Access, Project and Outlook)SharePoint, Rational Requisite Pro.

Front end tools: Microsoft front page, Microsoft Office, PL/SQL, HTML, XML

Version Tools: Visual Source safe, SVN, JIRA, Team Foundation Service (TFS), SharePoint Testing Mercury, Quick Test Pro, Win Runner

Databases: Oracle, MS SQL Server, DB2

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SR. Business Analyst

Responsibilities:

• Involved the analyzing end user requirements and communicating and modeling them to the development team.
• Extensive worked in JAD sessions with End Users through one on one and group interviews to better understand the user requirements.
• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Best Available Evidence file creation for Third Party Central Support, including copy analysis, payer file creation, analyzing payer response files.
• Creating Test case & Test scripts by Agile Methodology.
• Involved in UX/UI design on new products for strategic planning and meeting facilitation.
• Responsible for SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Performs various Identity and MS Access Management services to ensure the confidentiality.
• Database Audits and Eligibility on Oracle 10g Server using SQL Queries.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Prepared estimates and interfaced with business SME to review the requirements.
• Detail knowledge and understanding of payer environments.
• Coordinated and participated in the analysis and data mapping.
• Creating Test case & Test scripts by Agile Methodology.
• Involved in technical and business understanding of end-to-end payer
• Created extensive use case, activity, sequence diagrams of the required system to enable clear project idea and goals.
• Involved in Developing and build the UX/UI Design organization with the analysis department.
• Maintained and enhanced SSRS and optimized them for reporting efficiency.
• Involved in mapping documents for enrollment according to Reform.
• Worked closely with the Subject Matter Experts to define source to target data mappings and define extract, transformation and load specifications.
• Rewrote/updated their MS Access based programs and Developed with SQL Queries..
• Streamlined the project with component business modeling to increase efficiency and better planning.
• Requirements and changes were monitored and communicated to various stakeholders and project members.
• Met with technical/development team on weekly basis to determine the project strictures such as Privacy protection, communication, and security.

Environment: MS Project, SQL, Rational Unified Process (RUP), Agile, UX/UI, PL/SQL, Oracle, UAT, Rational Requisite Pro, Rational Rose, Clear Quest, Microsoft Visio, Windows, Mercury Test-Director, MS Visio, Business Objects, Windows.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Initiated discussions with the business stakeholders and Subject Matter Experts (SMEs) to understand and document business needs.
• Adjusted the project plan that identified specific tasks to be executed within the expected timeline.
• Ensured that the development team delivered the expected code by the targeted code drop dates.
• Created the BRD (Business Requirement Document) for various project on need basis.
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Extracted data from different sources like Oracle and text files using MS Access, SQL procedures and created datasets.
• Involved in incorporating and implementing UI/UX and SharePoint solutions.
• Gathered requirements, developed Process Model and detailed Business Policies.
• Involved in business analysis and project management and coordinating between the team members according to the business requirements.
• Responsible for tuned project lifecycle to accommodate Agile methodologies.
• Direct effective implementation, integration and execution of reporting on new and existing business initiatives.
• Established, maintained and terminated MS access for users on multiple applications while providing problem resolution to customers.
• Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
• Involved in generating Test Plans and Test Specifications as per business requirements.
• Involved in conducting Manual at various phases of the project development.
• Involved in all major cycles and phases of the project from scope definition risk analysis to UAT and monitoring the release of the product.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of work remaining.
• Followed the Agile Methodology for the entire SDLC.
• Extracted data from different sources like Oracle and text files using MS Access, SQL procedures.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Prepared the Business Workflow using MS-Visio with input, output, pre and post conditions.
• Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.

Environment: MS Office, SharePoint, Agile, Microsoft SQL Server, JIRA, UX/UI, PL/SQL, Quality Center, Win Runner, TFS, Visual Studio, Windows.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Worked in Scrum Agile Methodology environment.
• Scheduled Sprint Planning, Sprint Retrospective and Daily standup meetings.
• Involved in all the phases of a System Development Life Cycle (SDLC) to ensure that business objectives were met.
• Document reporting department process and assist with developing and implementing new processes.
• Gathered Business Requirements by interacting with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes.
• Evaluated solutions for business problems/bottlenecks and evaluated alternate methods to increase efficiency and improve control.
• Used the Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Analyzed and documented information system requirements and the corresponding impact on business processes.
• Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project.
• Conducted Joint Application Development (JAD) sessions and well experienced in interacting with individuals at all levels.
• Consulted with users, resolved problem to meet specific technical and business needs.
• Validation and Verification accountability for all the deliverables of software development projects.
• Assisted the team in preparing Test Plans and Test cases, detecting bugs in the system.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers.
• Prepared reports and presentations for weekly management meeting to update senior management staff on project deliverables, progression and timelines.
• Trained team members with project knowledge and business processes.

Environment: MS Office, SharePoint, Agile, Microsoft SQL Server, Quality Center, Win Runner, TFS, Clear quest, JAD, UAT, Visual Studio, Visual Source Safe, Windows.

Confidential, Lincoln, RI

Business Analyst

Responsibilities:

• Interacted with stakeholders and gathered requirements as per the Business needs.
• Gathered Requirements from various Business Areas like Provider Relations,
• Implemented RUP methodology for iterative and incremental development of the system Performed GAP analysis and provided rationale for GAPS that could remain
• Created Process Flow Charts, Business Requirements Documents, Functional Specification Documents.
• Developed Flowchart and process diagram using Microsoft Visio.
• Conducted GAP analysis by understanding the as-Is system and the To-Be system requirements by having discussions with the SME's.
• Gather requirements and estimate effort interfaces.
• Define interface requirements gap analysis and develop detailed specifications.
• Created Use Case scenarios and documented workflow and Business process using Rational Rose.
• Compiled the Vision Document and composed detailed Use Case Specification Documents in Rational Requisite Pro.
• Created High Level Design document for the new process, integrated with legacy.
• Prepared Functional Design Specifications (FRS) employing Use case scenarios, sequence diagrams, DFDs and class diagrams.
• Used UML to perform Use-Case analysis to capture the dynamic aspect of the application.
• Ensured the accuracy and consistency of the data during the data loading process.
• Developed State Diagrams, Activity diagrams and Class Diagrams in MS Visio using UML.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data on different test runs.
• Contributed in reviewing and editing of the test scripts.
• Assisted with user testing of systems (UAT) and ensuring that appropriate documentation is in place.

Environment: MS Office, SharePoint, Quality Center, Microsoft Visio, RUP, UAT, SVN, Windows.

Confidential, Northbrook, IL

Business Analyst

Responsibilities:

• Gathered and documented requirements from a diverse user community.
• Successfully conducted JAD Sessions with SME's and Business Users to gather requirements.
• Accurately identified the various groups and created pivot tables for further classification and thus, created a better understanding of the groups.
• Delivered high-level functional designs for projects and enhancements and fulfilled client requirements
• Translated requirements to functional design documents for complex systems/processes.
• Interacted with application developers and communicated user needs and requirements.
• Developed test plans, reviewed test cases, reviewed test scripts and wrote user documentation.
• Identified & coordinated all client application groups supporting client business apps
• Report status of client business app readiness for Windows.
• Supporting business app groups in resolving Windows related issues.
• Used MS Project to manage schedules, deadlines and resources and to collaborate on the project
• Extensively performed UAT.

Environment: Lotus Notes, UAT, MS Visio, MS Excel, MS Project, Rational Requisite Pro, Microsoft Office Suite, Microsoft Windows XP, Windows, MS SharePoint.