SUMMARY:

• 8 years of experience in Business Analysis with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design, data mapping, object-oriented designing, unified modeling language UML , SDLC methodology RUP, Agile, SCRUM, XP in domains as diverse as banking, mortgage and insurance
• Proven team player with excellent communication and presentation skills.
• Experience working in all phases of Software Development Life Cycle SDLC .
• Proficient in preparing Business Requirement Document BRD , Software Requirement Specification SRS , System Design Specification SDS , Functional Specifications and User Manuals.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD and Rapid Application Development RAD sessions with IT Groups and Conflict Management with Project team members.
• Extensive experience implementing Rational Unified Process RUP , SCRUM methodology, Object Oriented Analysis and Design OOA/D .
• Competent in Creating Unified Modeling Language UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, Wireframes conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix RTM .
• Having working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements. Experience with Regression, Black Box Testing, Functionality Testing, Unit testing, System Testing, Integration Testing.
• Experience conducting SWOT analysis, Cost benefit analysis and ROI analysis. User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Involved in Fine-tuning of Informatica mapping, Stored Procedures and SQL to obtain optimal performance and throughput.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading ETL and Business Intelligence BI tools like Spotfire and Cognos.
• Proficient in designing multiple enterprise level Spotfire Analytical solutins
• Self-motivated, diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Business System Analyst

Responsibilities:

• Involved in the SDLC phase of requirement analysis, design, and development of the intranet-based application.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
• Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral, Swimlane Diagrams and creation of technical design UI screen , UI Wireframes and Mockups using Microsoft Visio.
• Uploading, maintaining and distributing documents on MS SharePoint 2013.
• Informatica installs upgrades, administration, and maintenance
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Created dashboards for a managerial overview with drill up and drill down capabilities using TIBCO SPOTFIRE.
• Moderated everyday scrum meetings along with the other senior business analysts to improve the efficiency and productivity of each sprint.
• Handling the design, development, testing and deployment of custom data warehouse systems.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Prepared Logical Data Models that contained set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Identifying the appropriate data sources for loading data warehouse.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing UAT .
• Conducted JAD/RAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
• Worked on different Spotifre objects/visualizations like straight tables, line charts, bar charts and pivot tables etc. for dashboard design
• Was responsible for providing analytical support in the Design, Development and Implementation of Project using BI tools like COGNOS and SPOTFIRE.
• Extensively involved in Regression and Black Box testing, executing tests and tracking defects using Quality Center.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: MS Office Suite, SDLC, Agile/Scrum, RUP,SQL Server, UML, MS Visio, Quick Test Pro, HPQC, Project Management, Tibco Spotfire.

Confidential

Sr. Business System Analyst/ Tibco Spotfire

Responsibilities:

• Supported Sr. Business Analyst in developing business models. Conducted JAD sessions to elicit business and system requirements.
• Acted as the primary liaison between the client departments and the Information systems department and interacted with internal as well as external clients, to collect requirements and business process information, documented them in Requirement Document.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Performing gap analysis, IT risks analysis, change request management and producing reports and contingency plans. Acquiring consensus from different stakeholders.
• Use Case analysis and Use Case modeling using MS Visio.
• Creating / Updating AS-IS/TO-BE Business Process Models and validating with stakeholders.
• Usability analysis, creating/updating UI wireframes/prototypes and UI specification documents.
• Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Experience in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Gathered data modeling requirements and created class diagrams, data flow diagrams.
• Creating and Managing Functional Design documents including Functional and Supplemental Requirements, Use Cases, Functional Rules and Business Rules Business Process Diagrams, UI Specs, Data Models.
• Used Informatica to Extract, Transform and Load ETL data for the project.
• Strong data analysis experience and proficient in development and tuning of SQL queries, stored procedures, views, packages using PL/SQL.
• Experience in creating hierarchies, Measures, Slicer Dimension, Filter Function, Calculated Member, Aggregate functions Sum, YTD, MTD , Relative Positions functions, Joins, Behaviors', pivots and KPI's.
• Obtaining approval/ sign off on Functional Design Documents FDDs from various stakeholders.
• Collecting business rules, data mapping, template designing included using SQL queries for RMS reports and requirements for batch processing systems.
• Writing test cases / test scripts from requirements, use cases, business rules and UI spec documents.
• Technical Documentation as per Six Sigma Standards, release review decks for the evolving application.
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team.

Environment: Rational Clear Case, Clear Quest, Requisite Pro, MS Visio, MS Office Crystal Reports, ASP.NET, VB SQL Server, RUP, Waterfall, TIBCO SPOTFIRE.

Confidential

Sr. Business Intelligence Analyst

Responsibilities:

• Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements.
• Extensively used SharePoint for content management, and to share the information with the groups involved during the project.
• Followed standard AML procedures and processes.
• Strong Understanding of Data Warehouse and Business Intelligence concepts
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD .
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• SharePoint development with InfoPath and SharePoint Designer creating custom lists, libraries, workflows and forms.
• Reviewed accounts for completeness according to AML/KYC policies
• Responsible for development, implementation and Support of various RDBMS oracle based IT projects related to ETL, Data warehousing, and Data marts.
• Developed deliverables, schedules and reviews identified in the PM Framework.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS Visio.
• Involved in creating Master Test Plan MTP .
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server.
• Experience in designing Spotfire Layouts to make consistent and professional optimized look to clients.
• Used Dimensional modeling DMR and Snowflake Schema modeling technique to develop models.
• Creation of basic test web parts with Visual Studio.
• Creation and Management of data models, class diagrams, UI Designs / Prototypes.
• Developing a concise test plan and creating/ defining the test steps and test scenarios/test scripts.
• System testing, regression testing, GUI testing, load testing, stress testing, defect tracking.
• Conducted UAT by collaborating with app owners. Wrote test scripts, leveraged existing test cases, wrote use cases. Utilized the RTM to validate and open/close defect tickets in Quality Centre.

Environment: Rational Clear Case, Doors, IBM Web Sphere, XML, UML, JSP, RUP, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, Win Runner, Load Runner, Quick TestPro, SPOTFIRE, MS SharePoint 2007.

Confidential

Sr.Business System Analyst/ BI developer

Responsibilities:

• Studied system feasibility and provided information to the stakeholders with benefits, cost savings and risks.
• Conducted Joint Application Development JAD sessions with business user subject matter experts SME's to collect requirements.
• Analyzed the existing Conventional system and proposed SOA Service-oriented architecture approach for flexibility, quick response to changes in the business environment.
• Assisted in identifying gaps in data collection and content management
• Gathering requirements and business rules for Enterprise Content Management Systems ECM .
• Coordinating daily stand-up Agile/SCRUM reviews between team members and subject matter experts.
• Operational Risk, Credit Risk, IT Risk Analysis and preparing contingency plans.
• Constructing Use Cases, activity diagrams, sequence diagrams as needed during the lifecycle.
• Creating class diagrams, package diagrams, data flows for evolving databases and data warehouses.
• Defining EDI/ EDW / ETL/ ecommerce requirements, data mapping, stored procedures, triggers, layouts for huge number of batch and on-request financial reports and batch processing systems.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• On-site and offshore Vendor Management.
• Presenting Software Requirements Specification SRS to stakeholders and obtaining sign-off.
• Managing change/enhancement requests and updating software architecture documents.
• Developing UI Screens / prototypes/ Wireframes using MS Visio, MS Paint, iRise Visual Studio.
• Functional and Integration testing, regression testing, GUI testing, load testing, stress testing.
• Creating Test Plans, Test Scripts with PL/SQL - Toad and running test cases for applications.
• Creating UAT test scripts and Coordinating UAT sessions.

Environment: Visual Studio.NET, Oracle 11g, SQL, PL/SQL, Windows, MS Visio, MS Project, MS Office Suite MS Word, MS Excel, PowerPoint , and Test Director, Tibco Spotfire.

Confidential

Business System Analyst

Responsibilities:

• Defined scope, objects, goals, risks and produced project charter as per the business requirements.
• Conducted Joint Application Development JAD sessions with business user subject matter experts SME's for requirement gathering.
• Collaborated with the Project Manager to decide on the project approach as well as the preparation of the project plan.
• Streamlined critical processes for project success including concept definition and requirement gathering.
• Developed system specifications as needed to support reporting, policy and claims systems.
• Prepared data integration test cases, review test results and provided analysis for the same.
• Acted as a moderator for issue resolution, if any, between senior management and project teams on process compliance.
• Participated in bi-weekly status meetings with BA lead and program manager to discuss and review the status of the projects.
• Documented the technical design document TDD for data migration.
• Responsible for preparing Business Requirement Document BRD and Functional Requirement Document FRD and then translated it into test scripts Assisted in formulating testing documents like Test Plans and Test summary report.
• Communicated directly with Clients to understand their business needs and to resolve business issues.
• Worked with SQL queries to extract application data to perform application validations.

Environment: Oracle 11g, SQL, PL/SQL, Windows, MS Visio, MS Project, MS Office Suite MS Word, MS Excel, PowerPoint , and Test Director.

Confidential

Business/ Quality Assurance Analyst

Responsibilities:

• Worked with stake holders to detail the decision making process at that time creating business process flow diagrams utilizing MS Visio. This allowed for the identification of duplications of user effort and data collection.
• Assisted in identifying gaps in data collection and content management.
• Created Traceability Matrices from Business Required Documentation that outlines the testing scenarios with supportive test case.
• Gathering requirements and business rules for Enterprise Content Management Systems ECM .
• Prepared AS-IS and To-BE business process flow diagrams using MS Visio.
• Documented requirements, technical, help documents for the end user across the application stakeholders.
• Prepared improved data collection and reporting procedures for competitive business development and sales strategy, uncovered/ created new opportunities, identified dynamic and flexible solutions for managing account activity.
• Developed Positive and Negative test cases and executed manual test cases using Quality Center.
• Analyzed, reported and tracked defects through Quality Center Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• Played a key role in the planning, User Acceptance Testing and implementation of system enhancements and conversions.
• Wrote and executed clear and concise support documentation such as Test Plans and Test Cases.
• Creating UAT test scripts and Coordinating UAT sessions.

Environment: BI, BW, HP Service Desk, HP Service Center, MS Office MS Word, MS Excel, MS PowerPoint , Load Runner, Crystal Reports, Project Manager, Manual Testing.