SUMMARY:

• Over 7+ years of experience in the IT Industry as a Business Analyst
• Experience in gathering requirements for system design and development while interacting with business users, Stakeholders.
• Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into functional/technical requirements
• Experience in eliciting and documenting business requirements
• Excellent understanding and knowledge of various SDLC models like Waterfall, Agile, and RUP (Rational Unified Process)
• Experienced in all phases of the Data Warehouse Project Life Cycle such as Project Management, Architecture, Data Warehouse design, Development, Unit & Integrated Testing and Quality control
• Excellent writing skills in preparing business requirements document (BRD), system requirements specifications (SRS), system design specification (SDS), functional requirement document, and defining project plans
• Strong communication skills in engaging Project Sponsors, Business stakeholders, subject matter experts and Business Users in gathering the intricate workings of business processes
• Experience in eliciting and documenting business requirements
• Experienced in performing gap analysis, SWOT, feasibility and risk analysis
• Conducted and facilitated Joint Application Development (JAD) sessions. Gathered and prioritized requirement using interviews, document analysis, requirements workshops, site visits, and surveys
• Skilled in UML - Use case diagrams, Activity Diagrams, data flow diagrams, and Class diagrams
• Extensive experience with Financial teams in performing Cost Benefit Analysis (CBA)
• Skilled in creating Work Breakdown Structure (WBS) diagrams, Entity Relationship Diagram (ERD), identifying Milestones, Task Dependencies and Critical Paths using Gantt Charts
• Proficient in the use of tools like Rational Rose, Requisitepro and MS Visio.
• Ability to work independently and manage business requirements with a delivery-focused approach and excellent team building skills, problem solving skills, documentation and support with deep hands-on experience in managing and coordinating several projects successfully.
• Experience with Reports, Dashboards, Forecasts, Workflows.
• Excellent Analytical, Interpersonal, Communicational, Presentational, Administration Skills. Organized, Goal-Oriented, Self-Starter, and ability to master new technologies, manages multiple tasks while following through from Start to completion with limited supervision.
• Strong communicator and creative problem-solver skilled at transforming business needsinto software Solutions utilizing the technical skills and business knowledge

TECHNICAL SKILLS:

Methodologies: Waterfall, Spiral, SCRUM, RUP, and Agile

Project Management: Microsoft Project, Microsoft Word, Microsoft PowerPoint and Microsoft Excel

Business Modeling Tools: Enterprise architect, Microsoft Visio, Rational Rose, Dreamweaver

Defect Tracking Tools: Quality Centre, Rational Clearquest

Databases: Oracle, MS SQL Server, MS Access

Operating System: Windows 9x/XP/NT, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Business Analyst

Responsibilities:

• Analysis of functional and nonfunctional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Extensively used MS Access to pull the data from various databases and integrate the data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data.
• Experience in developing test plans and strategies and have conducted User Acceptance Testing (UAT) with users and customers and wrote issues log based on outcomes of UAT
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues

Environment: Quality Center, MS Excel,MS SQL, Business Objects, ETL Tools Informatica, Oracle, Teradata SQL Assistant

Business Analyst

Responsibilities:

• Prepared vision document, scope statement, project charter for defining the scope of the project and outlining business background, needs, risks, assumptions and constraints.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Conducted extensive domain research partnering with business and HIPAA act supervising government officials for interpreting business needs.
• Used questionnaire, surveys, Joint application design (JAD) sessions and Brainstorming sessions as requirement elicitation techniques.
• Drafted Process Flow models for entire Life Customer Communication Business process.
• Documented use case specifications on the basis of requirements gathered from business partners, FINEOS vendor side, other adjoining teams functions (Life Tax, Life Finance, Health etc.) stakeholders.
• Developed strong understanding of various life insurance modules such as Life policy servicing, Life Claims (Death, Disability, General, FCB), Life Adjudication, tax operations, and billing and payment services.
• Developed strong functional competency in IT Service Management (ITSM) and IT Infrastructure Library (ITIL) framework viz. Service Strategy, Service Design, Service transition, Service Operations, and Continual service Improvement, Change Management.
• Responsible for creating Business Requirement Document (BRD), Functional Requirements (FRD), Use cases, Functional prototypes, acceptance test cases, Meeting minutes, weekly status reports.
• Created Requirement traceability documents to establish the origin, progress and documented all associated details such as Functional Requirement, Business case scenarios, use case, test cases etc.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and manage deadlines.
• Created new, user-interface designs, mock-ups, wireframes and prototypes.
• Conducted functionality walkthroughs with development team and system, business stakeholders.
• Scheduled meetings with developers, systems analyst and testers to collaborate resource allocation, create staffing plans and project completion using MS Project.
• Extensively worked with quality analyst to make sure that the functionality meets specified quality standards.
• Kept a track of the testing sprints. Helped writing the test cases and assisted the testing team with functional, non-functional, black box and acceptance testing.
• Acted as a liaison to the Training team to facilitate them to deploy the training.
• Worked with the Policy and Procedure team as required to define new/updated policies and procedures.
• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans. customers. It is a powerful

Environment: Windows 7, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio 2010/2007), application, Crystal Reports, MS Customer Account & Securities Reference data warehouse, XML,

Business Analyst

Responsibilities:

• Worked directly with Senior Product Manager to understand the business expectations and customer needs.
• Understood the needs of the marketing team and helped them select and implement Omniture Site Catalyst.
• Was involved in creating RFP and short listing vendors for implementing a marketing analytics system.
• Used Crystal Reports to generate sales reports from the Business Object Universe to enable the Business team better assess the need for the current project
• Manual testing for checking the data flow of the application using SQL
• Drafted the Technical Solutions related to Business Objects development.
• Conducted focus groups and questionnaire analysis to understand the user’s motivations and needs.
• Worked with product manager to writes user stories as part of an Agile project framework that directly support primary objectives of the project, are appropriate in size for iterative development and include clear and specific acceptance criteria.
• Led requirement gathering sessions to help define the business and system objectives, documenting scope, identifying constraints and measures of success for the system to be developed.
• Prepare high level vision documents (Project Charter), Business requirement Document (BRD) and Functional requirement Document (FSD) for the project
• Documented and prioritized user stories in product backlog and sprint backlog.
• Developed Gap Analysis to compare and contrast “AS IS” and “TO BE” situation using MS Visio

Environment: Omniture, Business Objects, Rational Rose, MS SQL server, MS Word, MS Project, MS PowerPoint, Agile SDLC, Crystal Reports.

Marketing Business Analyst

Responsibilities:

• Worked closely with the product manager to understand the business expectation from the new version of the website
• Created and deployed dashboard to understand the involvement of the users with the website and in understand what features of the website are used more by the users
• Used MS Excel extensively and used its features like pivot tables, filters and macros to communicate to all the teams involved
• Implemented SAP Business Objects technologies to provide an integrated reporting solution set
• Worked with the marketing teams to create online campaigns to build awareness for the website
• Took Lead in facilitating discussions to anticipate future needs, requirements and opportunities
• Designed A/B tests and did the after tests analysis
• Generated Requirements Traceability Matrix
• Designed Project Charter, BRD and FSD to ensure all business requirements were documented
• Interacted with executive sponsors to identify business requirements, project objectives and implement scope changes

Environment:: Windows, Rational Rose, MS Word, MS Project, MS PowerPoint, Agile SDLC, IBM ClearCase, Crystal Reports, QuickTest Professional, Mercury Quality Center, Content Management System.

Lead Business Analyst

Responsibilities:

• Provided a full project lifecycle management from developing business case to delivery and transition to operations
• Developed PMO team to be highly regarded due to education and change Management
• Working in a combined role of SME, SharePoint Architect, Developer and Administrator
• Used management tools for the use of project planning/tracking and resource scheduling including the use of MS Project Enterprise and SharePoint
• Worked on MS Visio to design and create Process Flow Charts, Activity diagrams with Swimlanes, Data Flow Diagrams and Use Case Diagrams
• Tracked project risks, issues, action items, and decisions weekly for three projects
• Closely worked with the stakeholders and technical teams for defining the SLAs and Approach for Load, Endurance and Stress Testing