SUMMARY

• An experienced business analysis professional wif credible track record and leadership activities. Record of boosting efficiency by identifying opportunities and implementing optimized processes. Professional, role - playing and adaptable team player capable of gelling wif and motivating team members to perform above their expectations.
• 10 + years of experience in Business Analysis wif 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, Taxation.
• Experience working in all phases of Software Development Life Cycle (SDLC) including Design, Analysis and Review.
• Exemplary verbal and communication skills dat is necessary to elicit requirements through shadowing, Repository lookups, interviews and JAD sessions wif Business Owners, Business Users, SMEs and specific stakeholders relevant to the project.
• 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 wif Business User Groups, conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions wif IT Groups and Conflict Management wif Project team members.
• Extensive experience implementing Rational Unified Process (RUP), SCRUM methodology, Object Oriented Analysis and Design (OOA/D).
• Comprehensive understanding of Web-services and the corresponding Service Oriented Architecture (SOA).
• High perspective experience in Change Management, Scope creep Identification and Software Configuration Management (SCM).
• 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 dat all aspects of a Project are in Compliance wif the Business Requirements. Experience wif 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 wif Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools like Spotfire and Cognos.
• 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:

PM Tools: Lean Management, SWOT, CBA, Clarity PPM, Impact, GAP, MS Project 2010, MS Office, MS PowerPoint, MS Share Point 2010,2013

Operating Systems: UNIX, Windows 95/98/NP/2000/XP, Linux

MS: Access, MySQL, SQL Server, Oracle

MOSS: 2007, Rational Rose, Rational ClearCase

Bug Tracking Tools: Mercury Test Director, Rational Clear Quest, JIRA

Business Tools: MS Office Suite, MS Visio, MS Project, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS), IBMCognos, Tibco SpotfireTesting Tools:

Quick Test Pro(QTP), Requisite Pro, Test Director

ETL Tools: Informatica 7, Informatica 9.0.1

SDLC: Agile Scrum, Waterfall, RUP

PROFESSIONAL EXPERIENCE:

Confidential, CT

Sr.Business Analyst/Project Manager

Responsibilities:

• Acquired and studied repository artifacts of the existing system to gain an understanding.
• Conducted interviews of the client managers and traders to understand the AS-IS (Present State) process.
• Assisted in business process re-engineering along wif subject matter experts and corporate management.
• Conducted interviews wif the Business Owners (BO) to understand the To-Be (Future state) process.
• Expressed the requirements through user stories, use cases, HTML models, ER diagrams and Process Flow Diagrams.
• Involved in Data Centre, Pricing Centre, and Message Center Console configuration for Eagle.
• Intensively involved in Field mapping exercises for the accuracy of loaded Data.
• Facilitated Daily Scrums, Managed the Timelines for the Different Streams of the Project.
• Involved in taking Various High Level decision regarding the Data flow and Content.
• Created an intuitive and minimal UI for the application, wif an aim for the application to enable “seamless user experience wif minimal lead time.”
• Created the Product backlog wif halp of user stories collected through requirements gathering and gap analysis.
• Constant review and updating of KYC requirements and applying appropriate tenets to client projects
• Acted as a Business Owner creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings.
• Ensured all transactions and contracts adhered to not merely high standards, but complied to KYC guidelines and regulations.
• Communicated wif the AML Partners (AML Advisory, AML Legal Counsel, and Law Enforcement) and across jurisdictions throughout the duration of an investigation
• Created sprint burn down charts and release backlogs for effective Project Management.
• Developed Test plans, Test cases and Performed BA Testing to UAT deployment Testing.
• Managing JIRA as a Platform to monitor the Workflow of different streams of the Project.
• Case Management, Suspicious Activity Report (SAR) Filing, BSA/Patriot Act, Anti-Money Laundering (AML),Know Your Customer (KYC).

Confidential, Waite Park, MN

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.
• Extensive knowledge about the property taxation and all the three phases calculation, assessment and collection.
• Created all the requirements documents such as the business requirement document, use cases, GAP document.
• Extensively involved the mapping of the functionality of the existing system to the new system.
• 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.
• Identifying and clearly defining functional issues and supported IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity DiagraSms, Sequence Diagrams, Component Based Diagrams, and Collateral, Swim lane Diagrams and creation of technical design (UI screen), UI Wireframes and Mockups using Microsoft Visio.
• Acting as a lead for the process improvement team to improve the business processes and reduce the time taken for the frequently performed tasks.
• Interacted wif Subject Matter Experts (SME’s) of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology.
• Prepared Logical Data Models dat 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.
• Conducted JAD/RAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.

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

Confidential, Oaks, PA

Sr.Business System Analyst /SCRUM Master

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 wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Created dashboards for a managerial overview wif drill up and drill down capabilities using TIBCO SPOTFIRE.
• Moderated everyday scrum meetings along wif 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.
• Worked on BPS Advantage and used SQLs to access data from RDMS, which is loaded on nightly batch runs for positions, balances and other data.
• Prepared Logical Data Models dat 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 wif 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.
• Solid understanding of Data (pricing feeds and client data) and Data Analysis for real time market valuations wif respect to Brodridge BPS Advantage
• Worked on different Spotfire 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, Waterfall, RUP, SQL Server, UML, MS Visio, Quick Test Pro, HPQC, Project Management, Tibco Spotfire.

Confidential, New York, NY

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 wif 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 wif 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.
• Gatheird 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 wif 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, Wilmington, DE

Sr. Business Intelligence Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions wif SME’s in understanding the Requirements.
• Extensively used SharePoint for content management, and to share the information wif the groups involved during the project.
• Followed standard AML procedures and processes.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) and Reviewed Design Documents, Requirements Analysis Specifications wif Project Lead, Business Owners and the Technical Lead.
• SharePoint development wif 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 TABLEAU Professional to create worksheet, dashboards and published them to Tableau server.
• Used Dimensional modeling (DMR) and Snowflake Schema modeling technique to develop models.
• Creation of basic test web parts wif 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 wif 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, TABLEAU, MS SharePoint 2007.

Confidential

Sr.Business System Analyst/ BI developer

Responsibilities:

• Studied system feasibility and provided information to the stakeholders wif benefits, cost savings and risks.
• 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).
• 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.
• Created dashboards for a managerial overview wif 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 (wif 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 interviews wif business user subject matter experts (SME’s) for requirement gathering.
• Collaborated wif 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 wif 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 preparingBusiness Requirement Document(BRD) and Functional Requirement Document (FRD) and tan translated it into test scripts Assisted in formulating testing documents like Test Plans and Test summary report.
• Communicated directly wif Clients to understand their business needs and to resolve business issues.
• Worked wif 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 wif stake holders to detail the decision making process at dat 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 dat outlines the testing scenarios wif 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, halp 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 tan constructed the system in such a way dat 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.