SUMMARY

• Professional experience of over 8+ years working in various comprehensive projects in Health Insurance, Hospital, Pharmaceutical and Retail domains as a Jr .net developer, Business Analyst, Business System Analyst and a Scrum Master.
• Experienced and in - depth knowledge of different phases of System Development Life Cycle (SDLC) and methodologies such as Waterfall, Agile-Scrum, SAFe, and Waterfall-Scrum Hybrid.
• Conducted various analysis like GAP Analysis, Feasibility Analysis, Impact Analysis, Cost Benefit Analysis, Risk Analysis, and SWOT Analysis.
• Used different Elicitation Techniques for the Requirements Gathering like Brainstorming Sessions, Joint Application Development (JAD), Interview Sessions, Workshops, Focus Group, Surveys, Questionnaires, Document Analysis, and Observations with Subject Matter Expert (SME's), Business users and Business Owners.
• Proficient in gathering and analyzing the Business Requirements and documenting them into Business Requirement Document (BRD), Functional Specification Document (FSD) and System Requirement specification (SRS).
• Experience in creating Test Plans, Test Scenarios and Test cases and documenting project processes and procedures.
• Experienced in handling and implementing the change effectively by using change management process.
• Experience with various tools for planning, tracking and managing projects such as Atlassian Jira, Team Foundation Server(TFS), HP Agile Manager and MS Project Professional.
• Good knowledge in process modelling and created UML Diagrams (Use Cases, Sequence Diagrams, and Activity Diagrams) Workflow diagrams with the help of MS Visio, and Rational Rose.
• Designed Prototype, Mock-up screen, and Wireframes using MS Visio while developing GUI applications
• Expertise in facilitating UAT testing, Regression testing, Smoke testing, and SIT testing.
• Experienced in writing the User Stories using the INVEST format and handling the requirement churn.
• Recorded and maintained the artifacts like Sprint Burn down charts, Product Burn down charts, product backlog and impediments list. Efficient in facilitating estimation techniques such as Planning Poker, T-shirt sizing and prioritization techniques like Moscow and Kano techniques.
• Developed and maintained all project related documentation needed for implementation of application.
• Used SharePoint and docSTAR for Content Management for managing documents.
• Designed and developed web pages using ASP.NET and JavaScript.
• Experience with database queries on various RDBMS like Oracle, SQL Server, My SQL, MS Access, Stored procedure writing and Online Analytical Processing (OLAP).
• Knowledge in Data warehousing concepts- Data modelling, Data mapping, Conceptual, Logical & Physical Data Model, Star schema, Snowflake schema, and Normalization.
• Experience with data analysis & data mapping.
• Experience in designing dimensional modelling, star and snow flake schemas, Fact and dimension tables, physical and logical data modelling using Erwin modelling tool.
• Working knowledge of XML including validation of Web Methods, Web Services, WSDL,SOAP, UDDI, HTML, AJAX and CSS
• Developed systems complying withthe rules defined by Health Insurance Portability & Accountability Act (HIPAA) and Health & Human Services (HHS): Privacy Rule, Security Rule, Transactions & Code Sets Rule, Unique Identifiers Rule (NPI)
• Good understanding of Health Insurance Programs (Medicaid, Medicare Part A, Part B, Part C, Part D) and Managed Care Programs (HMO, PPO, POS), with expertise in HIPAA transactions and paper claim forms (CMS 1500, UB 04).
• Experience in working on Step-Up/Step-Down solution during transition from compliance.
• Knowledge of File Formats used for EDI transactions ASC X 12 837/276/277/834 , 999 Functional Acknowledgement and TA1 Interchange Acknowledgement
• Knowledge on Healthcare Claim Processing and HIPAA Standard Transactions X12-837 for Equivalent status request and response, X12-270/271 Eligibility inquiry and response for a Health Plan,
• Good Knowledge in Medicaid Management Information Systems (MMIS), Claims Process, Electronic Medical Records, Electronic Health Records and HL7 standards.
• Assisted in converting ICD-9 codes to ICD-10 codes by General Equivalence Mapping (GEM).

TECHNICAL SKILLS

Requirements Management: JIRA, Team Foundation Server (TFS), HP ALM.

Methodologies: Waterfall, Agile-Scrum, Agile-Waterfall.

Database: MS Access, MS SQL, SQL Server, Oracle 11g.

MS Office Tools: Word, Excel, PowerPoint, Visio

Project Management Tools: MS Project, MS SharePoint server 2007,2010,2013, JIRA

Business Modelling tools: Visio, Rational Rose.

ETL Tools: Informatica

Reporting tools: Tableau, IBM cognos, Crystal Reports

Testing Tools: HP Quality Center, HP ALM

Operating Systems: Microsoft Windows 7,8,10, XP / vista

Languages: HTML,XML,AJAX, SQL,VB.net,c#.net

Healthcare: HIPAA compliance, Medicare, Medicaid, MMIS, HL7, ICD-10

EDI Transaction sets: 270,271,276,277,834,835,837

PROFESSIONAL EXPERIENCE

SR. BUSINESS SYSTEM ANALYST/SCRUM MASTER

Confidential, Plymouth Meeting, PA

Responsibilities:

• Performed extensive Document Reviews and GAP analysis to develop a thorough understanding of AS-IS business processes model and TO-BE business Process model.
• Performed Impact Analysis to determine the impact of the enhancement on the business and organisation.
• Performed Feasibility Study, Cost-Benefit Analysis and Return on Investment(ROI) in order to mitigate certain risks associated with the project.
• Conducted JAD sessions, interviews and Brainstorming sessions with key stakeholders and SME’s to gather requirements.
• Created Vision document and Business Glossary. Worked onbusiness rulesfor the application.
• As a scrum master, facilitated the Scrum meetings- Sprint Planning, Daily scrum, and Review, Retrospective and Product Backlog Refinement meetings with the Scrum development team.
• Maintained Scrum artifacts like Sprint burn down chart, Product burn down chart and Impediment List.
• Effectively Time boxed Daily Scrum meetings, maintained the record and analyzed all the scrum activities in the Scrum Retrospective meeting along with scrum development team.
• Used JIRA for drafting the User stories and managing the requirements.
• Assisted the Product owner in prioritizing the product backlog using Kano technique.
• Facilitated the estimation of efforts required using Planning poker technique along with Scrum team.
• Analyzed the data in the database and presented reports to the client and the business team.
• Interacted with the client managers and the business partners to validate the findings.
• Maintained the Requirement Traceability Matrix (RTM) and worked with the Business Team to review UAT validation scenarios.
• Performed User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an error repository and managed the testing process with the QA team. Logged and tracked the defects using HP Quality Centre.
• Improved collaboration in the scrum team as the team is new to the process and helped people understand the work dynamics within scrum.

Environment: Waterfall - Scrum, MS Office (Word, PowerPoint, Visio), Share point 2013, JIRA 6.0, HP Quality Centre, Visual Studio, Tableau, SQL SERVER 2012.

SR. BUSINESS ANALYST/SCRUM MASTER

Confidential, BRONX, NY

Responsibilities:

• Interviewed the end users, asked detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business people and technical people.
• Conducted GAP Analysis of current state (As-Is) and proposed state (To-Be) situations.
• Conducted Requirement Workshop to gather requirements from various departments. Conducted Focus Groups and Interviews with physicians and to understand additional functionalities deemed critical.
• Prepared a Questionnaire and conducted a survey to understand the user needs.
• Created Business Requirement Documents (BRD), Functional Requirement Specification (FRS).
• Assisted the project manager in Project Budgeting and Resource scheduling, in order to optimize the utilization of the project resources using MS project.
• Worked with GUI development, designed the initial UI wireframes, and mock-ups.
• Used MS VISIO to create Use Case diagrams, activity and Sequence diagrams so that the development team and other stake holders can understand thebusiness process.
• Performed duties of agile coach by educating the team on prioritization and estimation techniques.
• Created GUI components such as checkboxes, radio buttons, drop buttons, drop down menus
• As a scrum master, facilitated and time-boxed all the scrum ceremonies and Backlog grooming session.
• Created and maintained Sprint burn down chart and release/product burn down charts.
• Helped team to maintain optimal Velocity, and complete story points in each sprint consistently.
• Assisted in logical data modelling, creating ER diagrams to structure data in the SQL Server environments.
• Managed Product Backlog with the help of Product owner and Scrum development team by using JIRA also generated reports to analyze the performance of the project.
• Authored Test Cases for various Test Scenarios, documented UAT Plan, and helped managing defects and issues log using HP ALM during the testing phase.
• Assisted in creating Data Model, ER Diagrams and used these artifacts to develop the Design Model: use case Diagrams, Activity and Sequence Diagrams.
• Manage the meta-data for the Subject Area models for the Data Warehouse environment.
• Document all source-to-target data mapping for the EDW.
• Developed fact tables and established relationship using dimension modelling as basis for designing Data Warehouse.
• Designed and implemented SQL queries for managing database, QA testing and data validation.
• Used SharePoint as a content management to document the artifacts and other documents.
• Developed reports using Tableau v9.0 to communicate information using graphs, charts and others.
• Assisted in creating materials for hospital employees to get them familiarized with the new technological advancements to be incorporated by the hospital.

Environment: Waterfall-Scrum, HP ALM, Balsamiq, Visual Studio, Tableau, SQL SERVER 2012, AJAX, IIS Web Server, Java Script, HTML, CSS, SharePoint 2013

SR. BUSINESS ANALYST

Confidential

Responsibilities:

• Worked as a Liaison between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Documented the requirements to meet end-state requirements and complied Business Specification Document, Software Requirement Specification Document and Use Case document.
• Performed SWOT and GAP Analysis to discover new functionality requirements, prioritized them on the basis of actual business needs. Involved in Risk Analysis and auditing business processes.
• Developed an analysis model that includes Use Case diagrams, and Activity diagrams using UML methodologies in MS Visio, which provided the development team a view of the requirements for design and construction phases.
• Supervised and Maintained the Requirement Traceability Matrix (RTM).
• Arranged weekly team meetings to assign tasks and acquisition of status reports from individual team members.
• Effectively managed change by deploying change management techniques such as Change Assessment and Impact Analysis.
• Created sample Wire frames for better understanding of the system by Business and technology teams.
• Identified Test Harnesses, which assisted QA effort in reducing the redundancy of Automation Scripts and made them more reusable.
• Designed and implemented basic SQL queries for QA Team for User Acceptance Testing.
• Reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Team Foundation Server 2010(TFS) has been used for all the source code maintenance among the whole team members.
• Experienced in designing and development test-case scenarios, test plans and test cases.
• Facilitated System Integration testing (SIT), and User Acceptance Testing (UAT).

Environment: Waterfall, MS Project, Windows8/9, Web Services, MS SQL, Ms Visio, MS Excel, HP ALM, Oracle 11g, TFS.

BUSINESS ANALYST

Confidential, Wallingfort, Connecticut

Responsibilities:

• Conducted interviews with the Business users, SME’s, Developers, PMs and QA teams to better understand the business processes and application knowledge.
• Reviewed the existing Business documents, TR3 guides to understand the current system.
• Conducted Gap analysis to identify the gaps in the existing 4010 and to be 5010 implementation.
• Conducted System appreciation to understand the current system behavior and the sensitivity and impact around the changes through system study and interviews with IT and Business SME.
• Conducted impact analysis to analyze the impact of the migration.
• Conducted JAD sessions with IT and business users to finalize the Business rules associated with the identified changes.
• Assisted in creating system Analysis document, 5010 mapping document and Status report.
• Successfully received Sign-offs by utilizing Clear Quest tool after resolving all open questions.
• Lead and facilitated numerous meetings to help answer any question on requirements during Design, Development, Testing and Implementation Phase.
• Created testing function specific scenarios for exception conditions with gap in data.
• Involved in forward and backward mapping between ICD 9 and ICD 10
• Worked with Architects and Developers in altering the various HIPAA 837, 270/271, 834(File Format Cleaning) Claim work flows.
• Used docSTAR, content management tool to document the artifacts.
• Prepared data mapping for HIPAA transactions between HIPAA and proprietary formats.
• Analyzed production data using SQL Server to understand problems and triage issues with developers and management. Created SQL Queries, stored procedures to retrieve, manipulate and analyze data.
• Assisting business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
• Participated in the production of HIPAA 5010 EDI Test data

Environment: Waterfall, HPALM, MS Visio, SQL, MS Office (Word, PowerPoint, Excel), MS-Project, docSTAR, HTML Windows XP, IBM Cognos.

BUSINESS ANALYST

Confidential

Responsibilities:

• Gathered requirements by conducting interviews, JAD sessions and Job shadowing.
• Conducted GAP Analysis of current state (As-Is) and proposed state (To-Be) situations.
• Created Use Case Diagrams, Activity Diagrams, and State Chart Diagrams using UML methodology.
• Prepared workflow diagrams, analyzed AS-IS and TO-BE scenarios, designed new process flows and documented the business process and various business scenarios.
• Involved in the calculations and documentation using MS Excel, MS word, and PowerPoint
• As a Scrum Master, documented Sprint backlogs and facilitated all Scrum Ceremonies.
• Created artifacts such as Sprint Burn down charts and Product/Release Backlogs.
• Performed the User Acceptance Test (UAT) and suggested recommendations for the application.
• Maintained complete documentation of the entire process along with all its activities.
• Responsible for Data analysis, Data profiling, Data mapping and traceability matrix deliverables
• Performed ad hoc statistical and data mining analyses
• Experience with SQL queries and worked with the queries for data manipulation.
• Created ER diagrams to establish different entities, relationships and different data mapping from various database into a single source.
• Informatica was used to extrapolate the difference and results of data mapping.
• Data validation, analysis and generating accurate reports using Tableau.
• Executed SQL queries to test data manipulations for data warehouse that detect functional acknowledgement.

Environment: Waterfall-Scrum, MS Excel, MS Word, Requisite Pro, MS Project, MS Visio, Outlook, Microsoft SQL Server, Microsoft Visual studio, Tableau

.NET DEVELOPER

Confidential

Responsibilities:

• Involved in design and development of UI using ASP.Net and JavaScript after interacting with users for requirements.
• Implemented the project using Confidential -Tier architecture with presentation tier (ASP.NET)
• Configured the Web Configuration file for Authentication, Session, and Trace.
• Developed Test cases and subsequently unit tested various modules.
• Used AGILE development Methodology to ensure teamwork, collaboration and process adaptability throughout the life-cycle of the project.
• Used Validation Controls and JavaScript to perform client-side validations on web forms.
• Used ADO.NET Connection, Command, Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in SQL Server 2005.
• Involved in designing database by creating Tables, Constraints, Functions, Triggers and Store Procedures using SQL in SQL server 2005.
• Developing classic ASP page creating queries and stored procedure on SQL server 2005 and fixing defects found in the current ASP page.
• Developed and consumed Web Service for communication and exchanging data.
• Used Visual Studio.NET debugger and ASP.NET trace functionality to debug the application.
• Used Visual Source Safe for version control and history during development.
• Involved in reporting using Crystal Reports.

ENVIRONMENT: .Net Framework, VB.NET, ASP.NET, ADO.NET, Java Script, XML, ASP, VB script, HTML, Microsoft Visual Studio, Visual Source Safe, SQL Server, Windows Server, Crystal Reports

JR .NET DEVELOPER

Confidential

Responsibilities:

• Implemented the project using ASP.NET, Visual C# and back-end database as SQL Server 2005.
• Developed C#.Net components to implement the business logic, consumed instances of these using ASP.NET
• Designed User Controls in the Application using ASP.NET for writing reusable User Interface UI and encapsulating the functionality.
• Used ADO.NET extensively for database manipulations and connections.
• Used Data Grid, Dataset and Data Reader to retrieve, display and manipulate data.
• Performed validations on web Forms using .NET validation controls and also JavaScript.
• Created and consumed Web services using Visual C#, ASP.NET.
• Implemented optimized SQL stored Procedures.
• Used Crystals Reports to generate dynamic reports in page called Report Builder.

Environment: ASP.NET, Microsoft .NET Framework 2.0, ADO.NET, AJAX, Oracle 9i, IIS 6.0, CSS, C#JavaScript, SSRS, Microsoft SQL Server 2005, Crystal Reports, SharePoint 2007