PROFESSIONAL SUMMARY:

• Business Analyst, Data Analyst with 8+ years of IT experience focused in industries like - Banking, Healthcare & Insurance with proven experience in designing, developing, supporting critical systems and data within the domains.
• Working knowledge experience in Data services, Data Analysis, Data ETL using SQL queries tools and applications.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Business document, Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Strong project management skills from requirement analysis, process mapping and documentation. Hands-on experience on tools like Rally, JIRA, MS-Project, Confluence for collaboration and tracking.
• Extensive knowledge of SDLC with different methodologies, such as SDLC, Waterfall, Scrum, Agile, RUP, Extreme Programming and Scrum-Waterfall Hybrid.
• Instrumental in clarifying business requirements, experienced in performing Gap Analysis, Impact Analysis, Risk Analysis, Traceability Matrices, SWOT Analysis, Document analysis, AS-IS&TO-BE analysis and Cost Benefit Analysis
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, one-on-one interview sessions, groups’ sessions, prototyping brainstorming, JAD and JAR sessions.
• Thorough understanding of preparation and use of Business Process Modeling Notation (BPMN) to Unified Modeling Language (UML) diagrams including Process Diagram, Activity Chart, Use Case Diagram, Sequence Diagram, Data Flow Diagram and ER Diagram.
• Certified Scrum Master dealt with scrum ceremonies like Product backlog grooming, Sprint planning meeting, Daily scrum, Sprint review, Sprint retrospective meetings.
• Excellent in analyzing and cresting Use-cases, various UML diagrams like Use case diagram, Activity diagram, E-R diagrams, Data flow diagram (DFD’s) using MS-Visio, Balsamiq, mock-ups.
• Experienced in creating Test Plan, Test Scripts, Test Scenarios, Test cases, Requirement Traceability Matrix (RTM), User acceptance Testing (UAT), and familiar with software testing and Regression testing
• Extensive knowledge in Data Warehousing architecture, implementation approaches, schemas and dimensional modeling, Seasoned in Creating Data Models, such as Conceptual model and Logical model.
• Performed ETL using Informatica to load the data into the data warehouse from disparate sources, designing and deploying various reports through Tableau, and IBM Cognos.
• Performed various SQL queries like SELECT, JOIN, VIEW for relevant data retrieval on Oracle database.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation.
• Extensively used SQL queries for business analytics and analysis of data using data manipulation language.
• Skilled with Data Analysis concepts of Data Modeling, Data Dictionary and Normalization, Created Data Mapping Documents to transfer data from legacy to target system and to reduce data and duplication.
• Involved in projects related to implementation of Data warehousing, Data Structures, Schemas, Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice and Pivot. Knowledge of Data-Migration, Data Lineage, Data Migration to Cloud, Systems Mapping and Data-Governance Processes.
• Understanding of Test Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD) used in test-centric development.
• Worked closely with the QA team to conduct functional testing, compliance tensing, performance testing and develop the test plan, test conditions, test cases, ensured adequate testing of software both before and after completion, and conducted UAT.
• Knowledge of Financial and Management Reporting, Business Process Reengineering, Forecasting and Capital Budgeting,KPI reporting, Ad Hoc reports, Dashboards creation and maintenance using Tableau, MicroStrategy and Power BI for the business.
• Strong knowledge of SQL, extraction/ transformation/ loading (ETL) process, and data migration using DTS.
• Worked closely with the QA team to conduct functional testing, compliance tensing, performance testing and develop the test plan, test conditions, test cases, ensured adequate testing of software both before and after completion, and conducted UAT.

TECHNICAL EXPERTISE:

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Extreme Programming (XP), Spiral, SAFE, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement Management Tools: JIRA, Rally, TFS, Version ONE, MS Project, Rational Requisite Pro, HP QC, HP ALM

Reporting Tools: IBM Cognos BI, Micro Strategy, Business Objects, Tableau, SQL Server Reporting Service, Microsoft Power BI, Spotfire.

Graphical & Modeling Tools: MS Visio, Balsamic, Rational Rose, UML, Mockup Screens.

Databases: MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle 9i & 10g (PL/SQL).

ETL Tools: SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager, Informatica Power Center, Oracle Data Integrator.

Testing Tools: HP QTP, LoadRunner, Bugzilla, Selenium, SOAP UI, Oracle Application Testing Suite (OATS)

Microsoft Tools: MS Office Tools (Word, PowerPoint, Excel) MS Access, MS SharePoint, Outlook 365

Languages: SQL, PL/SQL, T-SQL, HTML, XML, C, C++, JAVA. .NET

Operating Systems: Windows XP, 7, 8, 10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Business Analyst/ Scrum Master

Responsibilities:

• Interviewed business experts to elicit key information regarding processes and congruence with company policies.
• Write Detailed Business requirements documents (BRD) and assessment of current System for front, middle and back office reference data, data attributes and security master database.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Worked extensively to write use cases and functional requirement case diagrams, activity diagrams, sequence diagrams, state diagrams based on UML methodology and business process flow diagrams using MS Visio.
• Interacted with the Business Users, Stakeholders and work with Focus group to identify business system needs, obtain sign-off on the Business Requirement documents for Online Banking.
• Working in entire lifecycle of a product from its conception through design and development
• Involve in Risk Analysis & Risk Management for creating and implementing documentation for technical team by supporting and also Designs systems and programs to meet complex business needs.
• Facilitated requirement gathering sessions (JAD) with the business team and stakeholders to collect the business standards, security and service level requirements.
• Worked on Change Control Testing and documentation.
• Worked with offshore team in testing application and gathering test data.
• Defined the workflow for the testing process in the complete software development life cycle.
• Good understanding of Waterfall and AGILE methodology.
• Developed Use Cases using industry standard UML notation to analyze the business from the user perspective.
• Created Use Case and Functional Specification Document to track approved changes to the system.
• Participated in various stages of data mapping and requirement analysis for project needs.
• Work closely with the technical teams in and in to ensure that they have a clear understanding of requirements and support them throughout the development process.
• Co-ordinate with QA team to translate requirements into test plans and tests scripts while overlooking the testing techniques applied.
• Assisted the testing team in creating User Acceptance Test Plan based on business users requirements and reviewed Test Plan templates.
• Experienced in preparing and documenting the User Acceptance Testing (UAT) Test cases and conduction the testing to gain confidence on the application.
• Worked closely with the development team to analyze and troubleshoot bugs.

Environment: MS Visio, MS Project, Agile, MS SharePoint, MS Access, MS Excel, MS Word, MS PowerPoint

Confidential, New York City, NY

Business Systems Analyst/ Scrum Master

Responsibilities:

• Gathered requirementsthrough interviews, meetings, and existing documentation and conducted UAT.
• Accumulated customer requirements from various end through surveys, interviews, brainstorming and JAD sessions and translated them into system requirements.
• Developed prototype of information processing application and facilitated collection of functional requirements from system users and preparation ofbusinessrequirement documents.
• Created use cases, swim lane diagrams, sequence diagrams, activity diagrams or other visual aids to explicitly capture the requirements and lead the development of business process reengineering processes, procedures, and reports.
• Involved in Training, Quality Analysis, and Production Support for some of the users. Also assisted in developing dashboards for end users using MicroStrategy reporting tool. Reports were generated taking into consideration various key metrics.
• Created Wire Frames and Screen Mock ups and layouts using MS Visio.
• Studied the business and technical needs and modeled the “as-is” and “to-be” scenario for the MS Excel files database files
• Develop and report financial budgets, annual plans and monthly forecasts in align with current business objective.
• Provide strategic analytical support and interpretation of results as they affect the operational performance of Semiconductor market in an effort to reduce cost and increase productivity
• Work closely with accounting team in month-end closing, forecasting, monthly accruals, fixed asset management (depreciation), capitalization, and other key issues as they rise to minimize risks and variance to plan, forecast, and target.
• Simulate and normalize complex scenarios to understand, implement and set cost targets for manager to president cost MBO/KPI.

Environment: Waterfall Scrum Hybrid, MS Visio, MS word, MS Excel, Tableau, Oracle DB, Waterfall, SQL, Test Director.

Confidential, Tampa, FL

Business Analyst

Responsibilities:

• Worked on master documents of Business and Technical Architecture for end to end enrollment.
• Developed capabilities for current state of End to End Enrollment according to stakeholders' requirements.
• Participated in capability modeling for product and pricing within the scope of End to End Enrollment.
• Conducted JAD sessions to define the project and to reduce the time frame required to complete deliverables.
• Responsible for business analysis, requirement specifications, risk analysis, project planning and identifying the resources and implementation of the project.
• Created Epics, user stories, business requirements documents and technical design deliverables, process flows, and mockups for all business applications.
• Participated in the identification of the gaps and the pain points in the current state perspective and aiming for the target (future) state and organized meetings, appointments using MS Outlook.
• Facilitated Scrum Ceremonies and ensured that the team follows their process and pursued continuous innovation in their practices
• Recorded meeting minutes at time of conference call or meetings and keep track of all meeting notes.
• Involved in EDI transactions Analysis, Design, Implementation and Documentation.
• Reviewed in preparing the Test Scenarios for Health Care Claim Payment/Advice.
• Assisted with building the EDI 820,834 and 837 transactions processing flow from the Trading Partners to the translator and maintained Requirement Traceability Matrix (RTM).
• Participated in Enrollment and Eligibility Blueprinting Deliverables.
• Use Case development using modeling tool MS Visio.
• Involved in creating Reports and Documents like Requirements Documents, and Management Plan, Issue/Alternatives documents, Project Summary and Plans with formats like PDF, HTML, Excel and Word.
• Involved in up-gradation of 4010 transaction to 5010 by conducting Impact Analysis and Risk Assessment and worked on the mitigation plan to avoid the risks.
• Worked on Operational Business Architecture Reference deck for product, Pricing and Underwriting, and member benefits
• Enhance format template for outcomes of interviews conducted with stakeholders and maintaining communication deck for the same.

Environment: MS Office Suite, SharePoint, MS Visio, MS Project, UML, JIRA, JSON, REST Web Services, XML, SOA, BPMN, Load Runner, Selenium, Postman

Confidential

Business Analyst

Responsibilities:

• Requirements gathering from Subject Matter Experts, project stakeholders and Business users so as to obtain maximum details of requirements and involved in documenting Business Requirement Documents.
• Liaison between the Business needs (business users and sponsor) and the Technical team (development and testing staff), ensuring technical solutions satisfied business requirements.
• Conducted JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Careful documentation of business requirements ensured that they are aligned with UI from the initial stage itself.
• Experience in Medicare advantage and dual advantage.
• Participated daily standup meetings with the Developers.
• Facilitated user interviews and workshops to gather requirements.
• Involved in GAP Analysis and Technical Feasibility study with the technical leads and other SMEs.
• Created process flow diagrams in MS Visio.
• Worked with other team members for requirement analysis and clarifications and recommending changes for the gaps identified.

Environment: MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), Windows 2000, MS Visio, MS Project, Claim, JAD, EDI and UML Use Case.

Confidential

Business Analyst

Responsibilities:

• Engaged with project teams to integrate change management activities into the overall project.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.
• Gathered requirements and prepared business requirement documents (BRD).
• Created Use Cases, FAD’s and Solution Requirement Document based on the business requirements.
• Analyzed the defects with QA and Development teams.
• Conducted face to face meeting, webinars and JAD session to gain process & modeling understanding
• Written multiple Use Cases for multiple transactions include 837I(Health care claim Institutional), 835(Payment/Remittance advice), 276/277 (Claims status), 270/271(inquire/response health care eligibility and benefits; both inbound and outbound).
• Extensively involved in planning efforts for the Digital team including mobile app.
• Worked with the Project Manager (PM) on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
• Worked closely with project manager and other users and created work flow diagrams using MS Visio/UML.
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
• Was involved in Functional System Testing, Integration Testing, Regression Testing, and User Acceptance
• Test using the test cases given by the client before releasing the application.
• Involved in project status meetings, QA review meeting, and System Test meeting.
• Created test cases and test scripts for the User Acceptance testing (UAT).

Environment: MS- Visio, HP ALM Quality Center, HP QTP, SQL Server, MS Office, Agile, Web Services.

Confidential

Business Analyst

Responsibilities:

• Conducted brainstorming and interviews with business heads to finalize the business requirements.
• Worked on a Retail Reporting Application, which had over thirty retail clients
• Elicited, and wrote functional requirements (FRD) for four main features within the retail reporting application
• Coordinated meetings with users and stakeholders to gather Requirements.
• Converted business requirements into functional requirements, created System Requirement Specification (SRS) documents, managed and maintained requirements traceability for the validation feature
• Managed and documented Software Change Requests (SCR).
• Created many screen mockups on JIRA based on the change requests received from business; got it reviewed by the business and obtained their approval on it
• Developed use case with UML for the functionality of the feature
• Interacted with validation and development team during different project phases.
• Collaborated with the clients and development team to ensure requirement feasibility.
• Played a key role in change control document meetings, ensuring proper communication and flow of information regarding product changes.
• Created test plans, test case and test scenarios to validate requirements
• Created and documented system acceptance criteria.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Ensured the application feature were tested for functionality and were adequately controlled in production.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements for this Feature

Environment: MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), Windows 2000, MS Visio, MS Project, UAT, UML.