SUMMARY:

• Hands on Expertise in analyzing and requirement gathering, systematic analysis of the requirements, writing system functional specifications including use cases, Joint Application Development (JAD) sessions and use of Rational Requisite pro for requirement Management.
• Expert in writing User stories and Epics.
• Developed test scenarios and implemented test plans for system testing and user acceptance testing (UAT).
• Familiarity with White - Box and Black-Box testing techniques such as Load Testing, Regression Testing, Unit Testing, System Testing, Quality Center and Performance Testing.
• Excellent organizational and presentation skills in directing the To-Be process for business through GAP analysis in order to generate the necessary documents- Business Requirements Document (BRD), System Requirements Specification (SRS), User Requirements Specification (URS), Functional Requirements Document (FRD), Change Request Processes (CRP), and Contingency Planning (CP).
• Experience implementing UML and MS VISIO in creating Use Case Diagram, Activity Diagram, Process Flow Diagram, Sequence Diagram and Class Diagrams.
• Specializing in working with technical staff to create, interpret, and implement business requirements into technical specifications.
• Expertise in Unified Change Management (UCM) to manage change from requirements to release.
• Very Strong SQL skills (writing queries and verifying data). Solid understanding of databases, data ware house, OLTP, OLAP, Data Modeling, Business Intelligent tools like Business Objects.
• Goal Oriented Project Management, Business Process Analysis and Modeling, Testing: Planning, Coordination, Execution, Process Re-engineering & Analysis
• Documentation and delivering ODS to EDW information mapping for ETL Guide.
• Involved closely with the Developer and Testing team during defect resolution phase.
• Extensive experience utilizing AGILE frameworks in SDLC, including SCRUM.
• Strong knowledge of SDLC and project life cycle including Analysis, Design and Review of Business and technical requirements followed by implementation and project closure.
• Experience working on Data Warehouse projects & functional knowledge and experience with ETL tools to manage source data and create/manage data stores for migration and data mining.
• Experience in Configuration Management including post-configuration and post-deployment maintenance.
• Manual testing of GUI, Field Validation(Client-side, Server-side and database)
• Excellent in Developing and evaluating business process Models.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Expertise in Client On-Boarding processes used before the clients are authorized to use the applications.
• Experience in coordination between diversified teams working on the same project in India and USA. Use of SharePoint to share project related confidential documents with in the team.
• Assisting Project Manager in Production Support of multiple applications by addressing the bugs and enhancements raised by business with the help of applications like Virtual Tech Ticket and eTools.
• Supporting the development team for application Migration of .Net 1.1 to .Net 2.2 and .Net 3.5 by giving complete walkthrough of the functional requirements based on approved FRD and approved change requests after FRD approval.
• Analysis of existing data of old system for data mapping and to find data elements, data segments and transaction sets for Electronic Data Interchange between systems. Analysis of different file formats and identification of delimiters and positional to extract data elements from the file formats. Support the team for upload of existing data to new system.
• Experience in conducting GAP analysis, User Acceptance Testing, SWOT analysis, Cost benefit, ROI analysis.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, MS Visio, Enterprise Architect (EA), iGrafx, UML, Justinmind Prototyper(Pro), ATG commerce

Web and App Servers: Web Logic, Web Sphere, MQ Series, MTX, IIS, LDAP, SNA server, SQL Servers, IBM 6000, MQ Series (IBM and MS)

BI Tools: Business Objects (Designer, Dashboard) Cognos, Informatica, Crystal Report

Defect Tracking Tools: Quality Center (Test Director), Rational ClearQuest, Rational ClearCase

Testing Tools: WinRunner, LoadRunner, Quick Test Professional (QTP), Rational TestManager

Methodologies: Rational Unified Process (RUP), Waterfall Method,  Agile, Rapid Application Development (RAD), Application Development Life Cycle (ADLC)

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Project

Data warehousing Tools: Informatica, ETL Load Process, Qlikview, Microstrategy, Tableau Desktop Version 9.1

CRM: Siebel CRM and In house built CRM Application

Operating Systems: Windows XP, 2000, NT, 98, 95, UNIX, MS DOS

Databases: Oracle 8i / 9i, DB2, MS Access, Sybase, MS SQL Server

Languages: SQL, Java, .NET 1.1 and 2.0, HTML, XML, C sharp, ASP, Oracle, XML

Requirements Management Tools: Clarity, MS Team Foundation Server (MS TFS), MS Share Point, Rational RequisitePro

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Business System Analyst

Responsibilities:

• Gather business requirements for all business processes by coordinated Joint Requirement Planning (JRP) sessions & group meetings with system owners and development team, to define system requirements, system interaction specifications and brainstorm solution design during analysis phase.
• Documented requirements and  defined the scope of the project with Project Managers and Clients.
• Worked on JIRA to create Bug report.
• Created views in Tableau Desktop that were published to team for reviewing data analysis and customization using filters and other actions. Used Tableau to develop in-depth Dashboard Drill Down and Links to interrelated performance metrics .
• Gathered and converted data over to Tableau using T-SQL/SAS/Excel data over to tableau reports and Dashboards.
• Responsible for the project to enhance the functionalities of various existing applications linked to ecommerce.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Cognos. 
• Generated adhoc reports using OBIEE and report them to the business people for further analysis.
• Partnered with business stakeholders to define acceptance criteria and success metrics for proposed solution.
• Management of source code repositories, builds and deploys using Microsoft’s Team Foundation Server.
• Document process workflows textually as well as in UML diagrams according to RUP, for the stakeholder review.
• Collaborated with cross-application teams to design comprehensive solution based on business and system requirements.
• Responsible for project sprint planning, review, product backlog and daily scrum meeting follow ups and status updates. Also responsible to coordinate with off shore team and make sure we are moving as planned.
• Documented the use case scenarios from the business requirements using Rational Requisite Pro.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Active participation in Systems testing, Integration testing and Stress testing. Coordinated QA efforts with QA team.
• Participated in daily and weekly status meetings and mentoring the team. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Designed various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), UML diagrams and Systems Design Specification (SDS).
• Designed and maintained SQL scripts and optimize SQL queries.
• Extracted data to create ad-hoc reports and validated to ensure data integrity.
• Fixed defects that were reported during functional testing of the product using .NET Framework and test functionality after fixing the defects.
• Effectively involved in various stages of the development starting from the project planning till production and maintenance using Agile Methodology.
• Used Team Foundation Server (TFS) for Version Control and Source code repository.

Environment: Windows, MS Access, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), ETL, .NET, Oracle, JCL,  Crystal reports, RUP, UML, JIRA SQL, SWOT, Teradata, AGILE, ClearQuest, GAP Analysis, Win Runner

Confidential

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Examined and managed website content by using various modules in ATG commerce platform to create a user -friendly environment for better customer experience. 
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Mainatined requirements in JIRA for tracking and testing purposes.
• Used Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Lead the configuration of the client's business process workflow repository utilizing various process modeling tools based upon my recommendations.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Assisted in developing and managing Project Plans and Schedules. Also, managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Performed all necessary programming, testing and documentation for COBOL, DB2 batch programs and sub-routines.
• Used SQL to extract and collect data to generate reports using BI tools such as Tableau. Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Perform various data analysis and data profiling using SQL.
• Experience in producing tables, graphs, reports and also maintain large databases
• Generate reports using OBIEE and other BI tools to forecast the behaviour of customers in helping business people to come up with promising marketing strategies.
• Develop quarterly reports on developing trends in the market and help forecast needs and determine new strategies.
• Creating, developing global Business and User policies for various BI tools such as Tableau, Microstartegy andQlikview. Also, built complex formulas in Tableau for various business calculations.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents are generated during the project were maintained and managed using RationalClearCase and performed defect tracking using Rational Clear Quest.
• Created manual Test Cases in HP ALM for various user stories based on Release and Sprint Plan.
• Developed and conducted a two day accelerated business process modeling training session for the business analysis team based on new business processes.
• Assessed training needs for the project and ensured proper training is provided for end users.

Environment: MS Office suite, MS Visio.MS Access, MS Excel, RUP, UML, JIRA, HP ALM, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, Business Objects.

Confidential, Chicago, IL

Responsibilities:

• Analyzed clients systems and business processes.
• Addressed all aspects of credit card business.
• Wrote and maintained Business Requirements Documents BRDs  and Functional Requirements Documents FRDs defining new systems operations for the Online Banking project using Rational Requisite Pro.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing system.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Used JIRA for Defect tracking.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Developed online help system using RoboHelp and Captivate.
• Designed and developed Project document templates based on SDLC methodology.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Activity Diagrams, Sequence Diagrams, and OOD. Also developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.

Environment:  Windows XP, Microsoft Office SharePoint, MS Office,  MS Project, MS Access, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Rational Rose, Agile, UML, JIRA, Business Objects, BRD, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio

Confidential

Business Process Analyst

Responsibilities:

• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Used Scrum and waterfall methodologies.
• Wrote SQL statements to extract data from the Tables.
• Conducting Joint Application Development (JAD/JAR) sessions with IT Groups and Conflict Management with Project team members.
• Assisted with project team and Managers in the whole project lifecycle phases including scope analyzing, requirements gathering, development and quality assurance.
• Conducted interviews with various business users to collect requirement and business process information using MS Visio and Requisite pro.
• Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis.
• Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Organized and Scheduled user interviews, user meetings, group meetings, and JAD sessions.
• Designed and developed all Use Cases and UML models using Rational and Visio.
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Windows, Microsoft Office SharePoint, MS Office,  MS Project, MS Access, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Rational Rose, Agile, UML, Business Objects, BRD, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio

Confidential, San Francisco, CA

Business Systems Analyst

RESPONSIBILITIES:

• Hosted requirements gathering meetings with various teams.
• Involved in JAD sessions with SMEs and business users to analyze and gather the requirements for UI.
• Documented requirements and received sign off.
• Helped PM in finalizing scope based on the requirements.
• Worked on PLM team center.
• Hosted functional design sessions with functional analyst and prepared use case diagrams based on UML.
• Coordinated with the technical team for any functionality related questions.
• Coordinated discussions with third party like banks for setting up payment gateway.
• Successfully used Scrum Analysis Model (Agile) for gathering requirements by facilitating Use Case Workshops and sessions.
• Worked with release manager to schedule various releases in Test/staging and production environment.
• Organized weekly Project Status and Task Review meetings.
• Created PowerPoint presentations and project updates using MS Project for management review.
• Developed, executed and validated user acceptance test plans (UAT) and implementation support

Environment: Agile, MS Office Suite, MS Project, UML, Use Case Analysis.

Confidential, Houston, TX

Business Analyst/Quality Analyst

RESPONSIBILITIES:

• Managed and assisted in the project scope, deliverables, milestones, schedules, and budgets.
• Collaborate and act as a liaison between business, vendors, and IT organizations by planning, conducting, and directing the analysis of business problems.
• Evaluated processes, procedures, and provides recommendations for redesign improvements
• Analyzed the scope of the project and worked with business end-users to define business needs.
• Coordinated JAD sessions & group meetings with stakeholders, end users and system owners and development team to define system requirements and system interface specifications.
• Performed GAP analysis and developed the Business Process Models (BPM) using Visio and UML diagram.
• Employed Agile Methodology to conduct the system development
• Delivered the comprehensive Business Requirements Document (BRD) and Functional Requirement Specifications (FRS) document.
• Documented Use Case Narratives and used MS Visio to model UML Diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class diagrams and Business Process Diagrams for the application's design.
• Created wireframes and developed UI mockups and Conducted back-end testing of the application using SQL queries
• Supported QA team (wrote test-cases and used Quality Center) while performing User Acceptance Testing to make sure all requirements are developed correctly.
• Documented the UAT plan for the project and worked with the UAT Team to ensure every acceptance criteria for the requirements has been included in the UAT task plan.
• Performed integration testing, product testing, User Acceptance Testing (UAT) and data driven testing.
• Coordinated and managed the Change Request (CR) Control process for the project by facilitating group meetings, one-on- one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project.
• Conducted regular meetings with development team members, Project Manager and testing team to better understand system functionality in order to improve quality.
• Involved in writing and implementation of the test plan, and various test cases for UAT.
• Conducted User Acceptance Testing (UAT) and developed the test plans, test scenarios, test cases and test data to be used in testing based on business requirements, technical specifications and product knowledge.

Environment: MS Visio, SQL, Java, Windows 2000/2003, MS Project, MS Word, UAT, MS Excel, Rational Requisite Pro, Rational Rose