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 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, Web Methods

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

CRM: Salesforce.com,Siebel, Microsoft Dynamics

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

System Business Analyst/Project Manager

Responsibilities:

• Responsible for defining the scope of the project, gathering business requirements and documenting them textually or within models.
• Prepared a comprehensive Functional Requirements Document and Supplementary Specification Document (nonfunctional) from the gathered requirements. All documentation was created using the AGILE methodology.
• Interviewing business area experts, asking detailed questions and carefully recording the requirements and performed data analysis.
• Documented the requirements.
• Using GAP analysis, reviewed high level company processes, identified gaps that require operational change in order to optimize the proposed system solutions.
• Involved in detailing project mission, Data Process Flow Diagrams, and made lot of Data models and timelines.
• Analyze business requirements and segregated them into high level and low level Use Cases, activity diagrams / State Chart Diagrams and Robustness Diagram using Enterprise Architect according to UML methodology thus defining the Data Process Models.
• Prepared Business Workflow models that cover "How" business processes are accomplished.
• Prepared Workflow diagrams analyzed AS IS and TO BE scenarios, designed new process flows and documented the business process and various business scenarios.
• Involved in International Marketing of the product in global marketing.
• Involved in designing the Web based application with the offshore team.
• Conducted JAD sessions to develop architectural solution that application meets the business requirements, resolve open issues, and change requirements.
• Exclusively used SQL and Confidential -SQL for designing, modifying and maintaining tables, views and stored procedures accordingly
• Analyzed test results using Analysis Graphs such as User Graphs, Error Graphs, Transaction Graphs and Web Resource Graphs in Regression Test Analysis.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.

Environment: Enterprise Architect, Clear Quest, Clear Case, .Net Technologies, TIBCO,Regression Test, Load Runner, SQL Server 2000, SQL Reporting Services, MS Office 2003, Windows 2000/ XP

Confidential, Charlotte, NC

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 Swift interface MT110 and MT111.
• Updating Xml for all the MTs
• 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.

Environment: TIBCO BW, EMS, Windows 2000/XP/7, MS Outlook, MS project, MS Dynamics, Oracle 11g, Informatica, SWIFT, Microsoft Word, Microsoft Power Point, Visio, SOAP UI

Confidential, San Rafael, CA

SOA 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 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.
• Testing the services in SOAP UI

Environment: Windows 2000/XP, Rally, MS Office, SQL Server, TIBCO BW Oracle11g, SQL, Agile, SFDC, MS Project, MS FrontPage 2003, MS Access, EDI, HTML, UML,RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio, SOAP UI

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/Scrum as 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, HTMLVisio, IBM Mainframes (CICS), Agile, Scrum, MS-Office 2003, MS Share point.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Conducted Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on the business requirements.
• Analyzed and translated client's needs and used this analysis to write formal functional requirements, formal functional design specifications, detailed descriptions of user needs, program functions, and steps to be taken by the product development project teams to develop or modify the systems.
• Strategized project scoping and specifications documents, to clearly communicate the project roadmap.
• Met with all developers and project stakeholders and mapped out timelines, milestones, communication processes.
• Used SQL queries to analyze data and test for integrity.
• Analyzed functional specifications and data from various data sources like mainframe, oracle database and flat files.
• Authored Functional Specifications and communicated them to development and testing teams.
• Handled regular deployment issues across Dev. Prod and Test environments
• Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were met
• Assisted Test Lead, Testers understanding business process and help them successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Helped develop use cases and project plans and to manage project scope.

Environment: Oracle 9i, Oracle 10g, PL/SQL, HP Quality Center 9.2, MS Visio, MS Project, MSP, Fortracs, DRI, LPS Desktop.

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, Rational Requisite Pro, Rational Rose, UML,RUP, Microsoft Excel, Microsoft Word, XML, Informatica, SSRS, Jira, SSIS, Microsoft Power Point, Visio.

Continental, Houston, TX

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