SUMMARY:

• Sr. Business Analyst Professional with over 8 years of expertise in the Healthcare, Banking, and Financial domains. Within most of the previous roles was responsible for enhancements to various systems and web portal upgrades to increase efficiency. Highly experienced in working with the development as well as the business side to create complete technical and functional specifications.
• Skilled in analyzing and documenting artifacts such as Business Requirement Document (BRD), Functional Requirement Document (FRD), Non - Functional Requirement Document (NFRD) and Case Specification.
• Well-versed in conducting Feasibility Study, GAP Analysis, Cost Benefit and Impact Analysis.
• Expertise in creating Unified Modeling Language (UML) Diagrams such as Activity Chart, Use Case, Process, Sequence, Data Flow and ER Diagram using Rational Rose, SharePoint designer and MS Visio.
• In-depth knowledge of concepts such as data warehousing, data structures, schemas, and dimensional modeling.
• Excellence in OLAP operations such as roll-up, drill-down, pivot, slicing and dicing based on reporting requirements.
• Proficient in generating data mapping artifact and identifying transformations to cleanse and improve Data Quality.
• Experience in Functional Testing, Regression Testing, Integration Testing, Performance Testing, User Acceptance Testing, and Production Verification Testing.
• Experienced in eliciting, documenting business and functional requirements using various techniques such as Brainstorming, Requirements Workshop, JAD Sessions, Job Shadowing, Interviews, Document Analysis, Survey/Questionnaire, Reverse Engineering, Interface Analysis and Prototyping.
• Led project meetings with stakeholders, SME, UI/UX team, developers to gather and prioritize requirements.
• Served as a key liaison between the management, design and development team.
• Highly skilled in breaking down an Epic in the Product Backlog into User Stories that abide by the INVEST criteria.
• Proficiency in product backlog prioritization techniques (MoSCoW, Business Value, Kano, walking skeleton and Technical Risk) and estimation techniques (Planning Poker, T-shirt sizing and Relative mass evaluation) to assist the product owner in selecting the Product Backlog Items (PBIs) to commit in each Sprint.

TECHNICAL SKILLS:

• UML, JIRA, Rally
• MS SharePoint
• MS Office Suite
• HP ALM, Version One
• Agile, Waterfall
• MS Visio
• SharePoint Designer
• Balsamiq, Wireframes
• MS SQL Server
• Rational Requisite Pro
• Rational Clear Quest
• HP Quality Center
• HP QFT, SOAP UI
• HP LoadRunner
• Oracle Testing Suite
• Selenium
• Informatica Power Center
• Spotfire, IBM Cognos

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst/Migration Project Coordinator

Confidential, NYC, NY

Responsibilities:

• Gathered and documented business/technical requirements for the migration.
• Updated SharePoint and kept it up-to-date with the latest migration schedule/updates.
• Created and managed the project plan, vision document, strategy, and schedule.
• Documented AS-IS business process flows, document templates, escalation matrices, and network topology.
• Created the AS-IS and TO-BE technical environment Visio diagrams.
• Worked with the technical team on defining, documenting and validating the technical migration requirements.
• Created Test Cases and worked with the QA and UAT team after the migration for QA Validation and UAT (User Acceptance Testing)/Functionality Testing.
• Facilitated various JAD sessions with all the stakeholders for final joint approvals and decisions before every migration.
• Responsible for running and managing the Change Management Process and keeping track of all the changes/change requests.
• Worked with SMEs and Business Owners to schedule migration outages and sequence for server migration.

Environment: MS Project, WBS, SharePoint 2010, DB2, SQL Server, MS Visio, Windows, Unix, Linux, Mainframe.

Business Systems Analyst

Confidential, Baltimore, MD

Responsibilities:

• Studied and understood the state of art processes by interacting with stakeholders and in-depth documents analysis.
• Worked closely with business groups to gather requirements, define business strategy, and created a centralized reporting capability for users to perform analytical reports.
• Facilitated JAD sessions and questionnaires as moderator and conducted interviews with various Subject Matter Experts (SMEs) and Stakeholders.
• Prepared Business Requirement Document (BRD) and assisted in preparing system requirement specification (SRS).
• Performed SWOT Analysis of business rules, business and system process flows, user administration and business requirements. Mapped the requirements to the new system and thoroughly documented the same in the BRD.
• Assisted the business intelligence team in providing the insights on types of reports to be extracted.
• Identified the attributes that were vital based on the reporting requirements and ensured they were available.
• Worked on gathering requirements for different Relational Database Management Systems (RDBMS) in extracting the data into staging area and populating them onto Data Warehouse.
• Assisted and worked with ETL developers and data modelers to made sure the model being developed was according to the business requirements.
• Developed Conceptual and Logical ER Diagrams identifying the entities, constraints, relationships and cardinality.
• Responsible for creation of Use Cases and developed Use Case Diagram and Activity Diagram using MS Visio.
• Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models.
• Ensured Data Integrity using various techniques such as performing Data Normalization, Data Validation and Data Validity to enforce accuracy and effectiveness of data.
• Assisted BI developers in creating various types of reports/sub-reports and drilldown like standard and cross tab-reports with bar chart, pie chart, and line-chart graph representation reports using Cognos.
• Worked in Cognos report studio in extracting reports using filters and framework manager in creating data models.
• Worked in dimensional modeling process such as Star Schema and Snowflake Schema.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries on MS SQL Server. Used JOINS and nested queries to export data from the database.
• Managed and tracked requirements of the Application Life Cycle using HP ALM.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing, and Regression Testing.
• Handled change requests by performing Impact Analysis on the business and technology fronts and submitted it for approval from the Change Control Board (CCB).
• Served as a key liaison between the management, design and development team, and assisted the project manager in project tracking and completing tasks according to the project charter.

Environment: Waterfall, MS Office, Cognos, Informatica Power Center, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server, UML, ETL.

Business Systems Analyst

Confidential, Augusta, Maine

Responsibilities:

• Worked to ensure that business process outcomes were in harmony with strategic goals and worked to help improve the management of a business process.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system.
• Assisted in modeling the AS-IS and TO-BE business workflow.
• Assisted in drafting the Business Requirement Document and Functional Requirement Document by collaborating with technical teams and stakeholders.
• Facilitated JAD sessions, Questionnaires, Document Analysis and Interviews with the stakeholders for the requirements elicitation and documented Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Created high fidelity mockup diagrams to understand the work flow in user interfaces.
• Proposed and developed a Business Glossary to unify the definition of key attributes in the organization.
• Proficient at generating Data Mapping Artifact and identified transformations to cleanse and improve Data Quality.
• Used Business Process Management Notation (BPMN) for managing and improving the business process efficiency.
• Created ER Diagrams for one-to-one and one-to-many mapping relationships using SQL Server.
• Performed various SQL query operations such as DML and DDL commands and was responsible for supervising the source to target mappings in Informatica Power Center. Responsible for performing Data Profiling and Data Mapping.
• Developed Test Scenarios/Scripts and Test Plans. Prepared User Acceptance Test Cases (UAT), UAT issue log for tracking the defects and collaborated with system users to conduct the User Acceptance Test.
• Assisted the ETL team in integrating various OLTP to the OLAP by using Informatica and Tableau for reporting.
• Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models and also responsible for performing Data Profiling and Data Mapping.
• Facilitated the team in performing ETL operations to load the data into data marts using Informatica Power Center.
• Worked in dimensional modeling process such as star schema and snow-flake schema.
• Performed SQL queries using Joins and Nested Queries to fetch data from MS SQL Server.
• Prepared and maintained the Requirement Traceability Matrix (RTM) and Monitored performance testing results for several modules within the application.
• Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.

Environment: Waterfall, MS Visio, MS Project, MS Office, UML 2.0, HP ALM, Informatica Power Center, Tableau, HTML5, CSS, Balsamiq, Selenium, Data Mapping, Data Transformation, SOAP, XML.

Business Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Participated in the system development process life cycle from concept through testing, implementation, and support.
• Developed and introduced new features and capabilities in CRM application by analyzing information needs and functional requirements to deliver needed artifacts such as Business Requirement Document (BRD), Functional Requirement Document (FRD) and Use Case Document.
• Created Activity and Sequence Flow Diagrams for the better understanding of the process.
• Interacted with stakeholders and gathered requirements from the business and collected overall system requirement through JAD Sessions and Interviews.
• Implemented security configurations, customizations and integration for profiles and OWDs.
• Coordinated with the offshore development team on the progression and development of the requirements.
• Facilitated with data engineers to conduct data validation and mapping from existing systems into data ETL systems to integrate data to the CRM object and business models.
• Analyzed the defects in UAT and production and categorized/prioritized them and then assigned it to the right resource for fixing the defect.
• Pioneered the company’s CRM software training program, curriculum and materials production. facilitated training for the junior staff on producing critical management sales performance insights.

Environment: Waterfall, Windows 7/8, MS Office Suite, MS Visio, SharePoint, Salesforce CRM, UML.

Business Analyst

Confidential

Responsibilities:

• Responsible for creating and reviewing Business Requirements, Functional Specifications, Project Schedules, Documentation and Test Plans.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system. Assisted in modeling the AS-IS and TO-BE business workflow.
• Assisted in drafting the Business Requirement Document (BRD) by collaborating with technical teams and stakeholders.
• Facilitated JAD sessions, Questionnaires, Document Analysis and Interviews with the stakeholders for the requirements elicitation.
• Created High Fidelity Mockup Diagrams to understand the work flow in user interfaces.
• Created and maintained Use Case Documents based on the system’s requirements. Explained the Business Process Flows and created detailed diagrams such as Use Case Diagrams, Data Flow Diagrams (DFD’s), Activity Diagrams, Sequence Diagrams, Entity Relationship (ER) Diagrams and Work Flow Diagrams using MS Visio.
• Used Business Process Management (BPM) for managing and improving the business process efficiency.
• Created ER Diagrams for one-to-one and one-to-many mapping relationships using SQL Server.
• Used MS Access and Excel to extract, administer and manipulate large data.
• Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.
• Prepared and maintained the Requirement Traceability Matrix (RTM).
• Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.
• Involved in reporting status, milestones, and project plan tracking to project manager and product owner on a weekly basis.

Environment: Waterfall, JIRA, MS Project, MS Office, Mock-Up Screens, UAT, SharePoint.

Business Analyst

Confidential, NYC, NY

Responsibilities:

• Liaised between development team and end-users during various Software Development Lifecycle phases.
• Performed GAP Analysis to define gaps between AS-IS and TO-BE processes.
• Prepared Business Requirement Documents (BRD), System Requirements Specification (SRS) and Use Case Document.
• Assisted Project Manager in Data Analysis, Feasibility Analysis, and SWOT Analysis.
• Prepared Use Case Diagrams, Activity Diagrams & Sequence Diagrams from conceptual to procedural level in MS Visio.
• Conducted Questionnaires, Interviews, JAD, and Brainstorming Sessions to gather business user requirements.
• Used Business Process Management (BPM) for managing and improving the business process efficiency.
• Involved in Data Cleansing through Data Stage and Quality Stage layer.
• Synchronized with project managers in the groundwork of the project plans with any impact due to change request.
• Shaped and managed RTM. Performed Client-Side Validations to check all functionalities of different modules.
• Assisted in writing SQL queries like Select, Update, and Joins to retrieve desired information.

Environment: Waterfall, Wireframes, MS Office, MS Visio, MS Project Professional, Mockup Screens, UML.