SUMMARY

• Qualified professional with 8 years of extensive experience in the field of Business Systems Analysis and Data Analysis working with the technical stakeholders to implement business requirements into software applications in Healthcare, Finance & E - Commerce domains.
• Experience in Full Software Development Life Cycle in gathering user requirements, documenting business requirements, system requirements, technical writing, business analysis, system analysis, testing, and implementation of projects.
• 3+ years experience in Agile / Scrum.
• Extensive experience with Rational Unified Process (RUP), Waterfall life cycle & Agile Scrum.
• Extensive experience Change control, tracking and reporting, Process creation, management and control.
• Expert in eliciting and gathering Business Requirements, Conducting meetings, JAD sessions, Translation of Business Requirements to System Requirements and performing User Acceptance Testing with stakeholders and end users.
• Well Versed in documenting Functional and Non-Functional Requirements.
• Experience in ADKAR Change Management Model
• Experience in using real-time communication such as TIBCO BW, TIBCO EMS and JMS.
• Experience in SOA Design, Implementing and testing.
• Well versed in developing Use Case Diagrams in UML and Use Case documents using MS Word.
• Conversant in a broad range of technologies and tools, including business process tools such as Rational Rose, MS Visio for Data Analysis and Data Modeling.
• Expertise in Data Cleaning, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows and UNIX.
• Used SQL to conduct Data Analysis and System Testing. Strong knowledge of SQL ( Inner Join, Right Join, Left Joins, Unions & SQL Functions )
• Very well experienced using Microsoft Office Suite - Word, Excel, Access, and PowerPoint.
• Highly skilled in creating, writing, and executing Test Cases, Test Scripts from Business Requirement documents and Functional Design Documents.
• Experienced in performing functional tests Confidential various stages of SDLC using manual testing and automated testing tools from Mercury Interactive such as Quality Center, Jira and Rational Test Manager.
• Worked in various environments like Windows NT / XP & UNIX. .
• Experienced in UNIX Administration.
• Team player and a self-starter with excellent communications skills, and interpersonal skills with exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, J2EE, HTML, XML, SQL

Data Base: MSAccess,Oracle,SQLServer,DB2,Teradata, SQL Server Reporting Service, Data Warehouse

Reporting Tools: Business Objects, SAS, TOAD, SQL Developer, Informatica® Power Exchange®

Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Linux

Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office, Lotus Notes

Processes/Technologies: Rational Unified Process (RUP), Waterfall, Agile, UML & Microsoft Office SharePoint

Middleware: TIBCO BW, EMS, JMS

Automation Tools: Requisite Pro, QTP, Test Director, Quality Center

CRM: Salesforce.com,Siebel, Microsoft Dynamics

PROFESSIONAL EXPERIENCE

Confidential

SOA System Business Analyst (Middleware)

Responsibilities:

• Gathering user requirements and source system analysis and establishing mappings between sources to target attributes.
• Coordinated and managed team members for enterprise level project deliverables.
• Working closely with WFIS ( Confidential India Services) offshore team on daily basis, scheduling meetings, elucidation on requirements.
• Designing new interface MT110 and MT111.
• Organized daily stand up meetings, retrospective meetings, sprint planning
• Involved in creating and reviewing design documents.
• Creating JMS Objects (Queues, Topics, Bridges, Users)
• Working closely with other application teams to understand the requirements.
• Participate in integration, UAT testing and production readiness check and migration.
• Provide initial production support for whitewater period.

Confidential, San Rafael, CA

Business System Analyst

Responsibilities:

• Interact with multiple stakeholders to gather process requirements to develop new procedures and applications.
• Facilitate JAD sessions and lead walkthroughs for Business Requirements and Data Gathering.
• Product backlog creation, grooming and prioritizations with Product and Business Owners
• Facilitate planning sessions with the scrum team for estimation, task breakdown of backlog items and get commitments.
• Gathering Requirements for new internal Social Collaboration platform
• Conduct daily stand up scrum meetings, identify and take ownership to resolve the impediments immediately.
• Serve as a liaison between end users, development team to resolve issues with requirements and change management.
• Map business requirements to functional requirements
• Perform GAP analysis on requirements and document needed functionality. Conducted current state and future state analysis
• Work with other scrum teams to resolve inter team dependant issues and defects
• Developed a change strategy in ADKAR Model
• Developed functional and system documents and other implementation documents.
• Authored Business Requirement Document (BRD), GAP analysis documentation, which included finding the gaps in the existing processes and recommending new processes. Recommended new/modified requirements as a result of GAP analysis to assist clients needs better.
• Designed and developed Use Cases using UML and Business Process Modeling.
• Was responsible for setting up of milestones for the project.
• Documented the Required Mapping documents.

Environment: Windows 2000/XP, Rally, MS Office, SQL Server,Teradata Oracle11g, SQL, Agile, SFDC, MS Project, MS FrontPage 2003, MS Access, EDI, HTML, Rational Clear Case, Rational Requisite Pro, UML,RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio

Confidential, Annapolis, MD

Business Systems Analyst

Responsibilities:

• Extensively worked with implementing full SDLC methodology.
• Conducted interviews with key business users and SMEs to collect requirement and business process information.
• Conducted JAD Sessions and GAP Analysis for understanding the workflow
• Assisted with developing Project Charters, Business Requirement Specifications (BRS), System Requirement Specification (SRS), System Design Specifications (SDS) and Business Requirements Documents
• Implemented Agile/Scrumas a project management methodology
• Educated upper management and championed the use of Agile/Scrum
• Performed extensive requirement analysis including data analysis and gap analysis.
• Used PowerPoint presentations to conduct walkthroughs with the stakeholders.
• Developed business requirement specification documents as well as high-level project plan.
• Worked with the business to define the role governance process and business process for modification, approval and removal of roles
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Worked with Mainframes admin to create new IDs and delete old ones
• Documented and delivered Functional Specification Document to the project team.
• Participated in the logical and physical design sessions.
• Performed Defect Analysis.
• Involved in Test plan and Test case Documentation.
• Conducted User Acceptance Testing (UAT) and interacted with developers to resolve the issues.

Environment: Windows 2000/XP, SDLC, .Net Technologies (ASP.NET, C#), Java Script, HTML, Visio, IBM Mainframes (CICS), Agile, Scrum, MS-Office 2003, MS Share point.

Confidential, Cupertino, CA

Sr. Business Analyst / QA

Responsibilities:

• Participated in Project planning and facilitated JAD sessions to understand business process
• Extensively worked on Agile methodology and gathered user/business requirements by writing User Stories
• Designed, created, and maintained Ecommerce website to host documentation.
• Involved in Requirements Gathering & Analysis by Actively soliciting, analyzing and negotiating customer requirements while leading the technical requirements analysis, driving the system design and construction
• Participated in lot of conference calls Net Meeting and Daily Stand up Meetings.
• Identified opportunities for business process improvement and initiate efforts to make improvements
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Documented use cases, created use case diagrams that described the behavior of the system and modeled them in Rational Rose.
• Identified, organized, and documented the changing requirements of the project using Rational RequisitePro.
• Logged defects to Rational ClearQuest and interacted with developers to resolve the defects then verify fixes and close bugs
• Acted as liaison between management and development team for Requirements and QA. Also wrote test plans, test cases, run various test suites to see the expected results.
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Interacted with management, system analysts and technical developers for successful completion of set project goals
• Reviewed the Requirements Specifications, refined Master test plan, Test Schedules according to the project deadlines using various testing tools.

Environment: Windows 2000/XP, UML, Agile, Rational Tool Suite (Requisitepro, ClearCase, Rational Rose, ClearQuest) Visual Basic, Crystal Reports, Java Script, HTML, ASP, Oracle 8i.Visio, Regression Test, Load Runner and Quick Test Pro, MS-Office 2003.

Confidential, Hartford. CT

Business Systems Analyst

Responsibilities:

• Assisted the Project manager in creating and updating the Vision Document, Business case, Business Requirements, User Requirements and Project Plan.
• Facilitated requirement-eliciting sessions (JAD sessions) with Subject Matter Experts and other Key Users and documented the requirements in an easy to understand format by both the business and technical stakeholders
• Elicited functional specifications, system requirements, conducted feasibility analysis and performed current state and future state analysis
• Elicited Business Rules and other Non-functional specifications for the new system by interviewing the Subject Matter Experts to further understand the business models
• Involved in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Created UML Activity Diagrams to depict business processes (AS-IS and TO-BE) and analyzed them for their efficiency and productivity
• Created Use Case Model using Rational Rose for developers and technical stakeholders to understand the business process, depict roles, and procedures
• Created the logical models and generated the physical models in the databases using Rational Rose.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema.
• Created Wireframes, GUI and Prototypes in Axure Wireframe tool.
• Establish a project repository to house all team documents and served as a gatekeeper for the repository
• Involved in documentation to describe ETL program development, Source to Target logic, coding, testing, changes and corrections.
• Designed SQL queries to capture reporting data from SQL server reporting services.
• Used Excel based statistical analysis and created pivot tables and charts for business reporting and assistance in data driven decision process.
• Worked on the SQL query to extract the data required for data validation.
• Analyzed and developed large quantities of data in SQL to manipulate modify and debug various tables for reporting services. Used Inner Join, Right Join, Union & SQL Functions
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Prepare and maintain project documentation and status reports
• Developed Formula’s, Macros, lookup functions, pivot tables to aid in the reporting criteria definition
• Participated in Testing of the Reports & UAT Testing and by developing Test Cases and Test Scripts.
• Used Data Analysis tools to validate data and conduct testing.

Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, MS Office, SQL Server, SQL Developer, TOAD, Agile, MS Project, MS Access, Rational Clear Quest, Eclipsys, Rational Clear Case, SAS, Rational Requisite Pro, Rational Rose, UML,RUP, Microsoft Excel, Microsoft Word, XML, Informatica Power Exchange, SSRS, Jira, SSIS, Microsoft Power Point, Visio.

Confidential, Houston, Texas

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Worked closely with the Product Managers, Rewards SME’s, Operations Personal, Call Center Employees to gather requirements for the customer portal.
• Worked on development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Requirements, Design & Validation.
• Developed estimates, project plans (Microsoft project), training material
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and enterprise data warehouse.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, UNIX / Oracle Platform, NIKU, MS Visio, MS Outlook, MS project, MS Dynamics, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition.
• Working in Documents Management System to track and store images of paper documents.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.
• Involved in designing business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the db2 database.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Identified the various dimensions of reporting and defined the reporting requirements and also identified the source data and mapped to the target locations.
• Conducted meetings for the Data Modeling and Analysis.
• Created the logical models and generated the physical models in the databases using Rational Rose.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema.
• Used SQL Server Reporting Services for reporting and dashboards
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Monthly and quarterly management meetings with travel liaison for consistent communication.
• Database of individual traveler personal profiles for efficiency and accuracy with each reservation
• Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the Entity relationships between the data elements to analyze and document business data requirements.
• Perform data analysis and system testing to validate requirements
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Involved in User Acceptance Testing (UAT) and Test Execution.

Environment: Visio, IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server, SAS, HTML, XML, UNIX, Windows NT, MS Access