SUMMARY

• 6+ years of experience in Healthcare and IT companies wif a degree in MBA wif specialization in Information technology.
• Ability to perform GAP analysis between “as is” and “to be” scenarios.
• Experience in assisting technical team in different phases of SDLC such as Design, Development and Quality Assurance.
• Experience in creating, updating, auditing and sending reports of production/project to teh client and team on daily basis using Excel, SQL and PowerPoint.
• Experience in Software Development Methodologies (SDLC): Agile (Scrum)
• Ability to take ownership of a project and complete teh task on given time.
• Expertise in facilitating JAD sessions developing user stories, use cases and process modelling using MS VISIO.
• Experience in using Tableau by connecting Excel spreadsheet to analyze and represent data.
• Excellent understanding of Data ETL using SQL query and MS office.
• Knowledge about internal controlandrisk management. As worked in process where teh team had access to client’s confidential information.
• Crafted various documents like Business Requirement Document (BRD), Functional Requirement Document (FRD), Requirement Traceability Matrix (RTM), Change Management Documentation and Use case specification.
• Developed prototypes like process workflows, wireframes and mockup screens using MS VISIO and Axure Pro to train teh users and to provide User Interface (UI) noledge
• Tracked Project status, issues and decomposed Epics into User Stories and tasks using JIRA and Confluence.
• Experience in working wif QA testing teams, while interacting wif business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.
• Worked on business requirements by participating and conducting Interviews, Joint Application Development (JAD), Document Analysis, Requirement Workshops wif End - users, Project Manager, Subject Matter Expert (SME’s) and Stakeholders.
• Developed workflows, Business Process Modeling Notation (BPMN) and Unified Modelling Language (UML) diagrams which included Use Cases, Activity diagrams, Class Diagrams, Sequence diagrams, Data Flow diagrams and E-R diagrams in Visio and Lucid chart.
• Experience in using MS office: MS Excel, MS Visio, PowerPoint and Access.
• Knowledge in Programming Languages: C, C++, JAVA, SQL.
• Excellent problem solving, interpersonal and communication skills wif teh ability to multi-task.
• Ability to learn quickly and understand teh process, technology and structure of teh process.
• Strongly believe in teamwork and has worked in team wif great coordination and understanding.
• Ability to coordinate and interact wif client and team regarding teh issues, progress and strategies to achieve teh team goals.
• TEMPEffective communication skills wif teh ability to communicate wif clients about teh progress of teh project and to resolve teh issues raised during teh project.

TECHNICAL SKILLS

Methodologies: Agile, SDLC, Scrum, V-shape modeling

Management Tools: JIRA, SharePoint, Unified Modeling Language (UML)

Business Modeling& Versioning Tools: MS VISIO, Rational Rose, Axure RP Pro

MS Office: MS Project, MS Word, MS Excel, MS PowerPoint, MS Access

Programming Languages: Structured Query Language (SQL)

Operating System: Windows NT/98/2000/XP.

Databases: Access, Oracle, MY SQL Server.

SDLC Methods: Agile (scrum)

Testing tools: Rational Clear Quest Test Manager, HP Quality Center.

Apps & Webservers: Apache web server, Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, MA

Business Analyst

Responsibilities:

• Requirement elicitation using techniques such as survey/questionnaires, brainstorming sessions, interviews, analysis, requirements workshops, business-process descriptions and joint application development (JAD) sessions wif internal and external stakeholders.
• Developed UML to create Use cases diagrams and activity diagram using MS Visio.
• Created performance evaluation report using SQL.
• Communication wif external and internal customers to analyze information needs and functional requirements, to delivers teh artifacts as needed by preparing (BRD) Business Requirements Document, Use case, etc.,
• Efficient in Prototyping Application User Interfaces using Wireframes and Mock-ups wif focused attention to detail in enriching User Experience and User Interaction. Used Axure Pro to make these prototypes.
• Experience in writing User Stories following teh INVEST criteria and in defining acceptance criteria and prioritizing User Stories based.
• Collaborate wif developers and SME’s to resolve issues, to establish technical vision and analyze requirements.
• Maintained teh requirements traceability matrix (RTM) for tracking teh origin of teh project status.
• Designed and documented Enterprise Change Requests (ECR’s)
• Worked wif team/program level stakeholders and PO to create artifacts like status reports, program planning, team/program Kanban backlogs, dashboards, product initiatives and features.
• Interacted wif teh Stakeholders and assisted teh Product Owner to write User Stories, help in prioritization and assist in defining teh acceptance criteria.
• Participating in teh Quality assurance (QA) processes to ensure requirements are met.
• Regular meetings wif Business partners on teh status of issues, action plans and timeframe for resolution throughout teh development cycle.
• Analyzed indicators and compiling reports of performance indicators, providing trended data using appropriate techniques.
• Compile and automate loading of data sources from various programs and departments, providing support for data integrity and data validation.
• Experience on IBM rational integrated tools Rational Rose for requirement management and analyses Use Case and creating workflows.
• Organizing and collaborating teams for meetings and emails using MS Outlook and Skype.
• Used JIRA extensively to do planning, tracking, release management, issue management, scrum boards and reporting for all projects.
• Perform complex program analysis - evaluate, recommend and plan actions to create processes to integrate teh business analyst role into teh welfare automated systems Agile (Scrum) development process.
• Assisted in performing Integration Testing, UAT testing based on designed Test Cases, Traceability Matrix and Test Scenarios to eliminate any kind of bugs or defects from teh system.
• Coordinated teh gathering and reconciliation of detailed business requirements and systems requirements for system development wifin an agile development model.
• Used MS Project to do project reporting, status reports, resource allocation, Gantt Charts etc. for all projects.

Environment: IBM Rational Rose, MS Office, MS-Visio, Agile, MS Project, Jira, UML, MS SQL Server 2012, MS Excel, Axure RP Pro, outlook, Skype.

Confidential, TN

Business Analyst

Responsibilities:

• Gatheird and documented existing client data using Microsoft Excel in order to perform gap analysis
• Prepared and tracked projects through weekly reports and deliverables
• Participated in numerous meetings to help answer any question on requirements during Design, Development, Testing and Implementation phase
• Used UML diagrams for data capture activities to ensure consistency and accuracy of data during teh data loading process.
• Used MS Project for generating reports.
• Experience in SQL queries to retrieve and validate data, prepared for data mapping document.
• Participated in JAD/JRD sessions for documentation and submitting teh documents for sign-off.
• Performed UAT testing to validate system and application performance.
• Used JIRA to track project and issues. Also updated changes in JIRA
• Implemented numerous automated data collection systems utilizing MS ACCESS and Excel.
• Coordinated wif testing teams in creation of test cases, review and approval of teh same, to make sure teh requirements are met.
• Created User Stories out of Epics, Themes and Sprints and calculated velocity and story-points in TFS.
• Evaluated and documented risk related to requirements implementation, testing processes, and project communication when sprint planning.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh Data Marts.
• Performed GAP (AS-IS and TO-BE) analysis to assess teh current state of teh project and create a project plan for teh progress of teh project based on business and functional requirements.
• Identified any incoming changes in teh processes and recommended change management strategies.
• Developed Test Cases, User Acceptance Testing (UAT), and Regression Testing to assist wif Quality Assurance (QA) and verify that requirements were fulfilled.
• Worked wif team and client closely and prepared teh data mapping document.
• Created dashboards in Excel for data interpretation and reporting by using Pivot Tables and VLOOKUP for various releases.
• Develop ETL mappings for flat-file data sources (XML, .csv, .txt) and loading teh data from these sources into Dynamic CRM portal wif SSIS tool.

Environment: UML, MS project, JIRA, MS Access, Windows OS, MS office, VISIO, MS SQL Server 2008, TFS, Sharepoint, SSIS.

Confidential, RI

Business Analyst

Responsibilities:

• Assisted in gathering functional, business and technical requirements using individual and group meetings.
• Implemented analyses against data resources, including administrative healthcare claims, surveys, and electronic health records, to evaluate data.
• Assisted and conducted data collection, database development, and basic statistical analyses from information gatheird in patient surveys, electronic health records, clinic administrative databases, and other sources.
• Responsible to create different data flow diagrams and UML diagrams to describe teh overall EDI transaction sets for different claims.
• Worked on teh Healthcare Data for requirement gathering and analysis. Healthcare data which included Membership claims, benefits, eligibility check, ICD10, Exposure to Health Care Industry standards like HIPAA / PHI. Plus, Knowledge of Claims Processing.
• Collaborated wif cross-functional teams to correct identified CRM reporting errors.
• Implemented ETL process on existing data for data validation.
• Experience in SQL queries to retrieve and validate data, prepared for data mapping document.
• Participated in JAD/JRD sessions for documentation and submitting teh documents for sign-off.
• Worked on SharePoint to access teh data and understand teh documents shared wif Project management and senior Business Analyst.
• CreatedUse cases to extract business process flows and workflows involved in teh project. Carried out defect tracking usingClear Quest.
• Facilitated file sharing and tracking business flow using SharePoint.

Environment:MS Office, Agile, Outlook, SQL, MS Excel, SharePoint, Rational Clear Quest

Confidential

Business Process Associate / System Analyst

Responsibilities:

• Conducted Business process analysis, task/workflow analysis.
• Created use case to plan, organize and to understand teh process flow which included teh three P’s payers, providers and patients. Also, to explain how to understand and work on a claim which includes patients’ information such as: membership, claim Id, plan information, RX, etc.,
• Coordinating wif third party, IT team, Walgreens corporate (USA) and other teams to resolve a complex issue.
• Completed HIPAA compliance certification which included data integrity and regulation on dealing wif healthcare claim information.
• Built complex SQL queries to extract data to identify and audit claims wif issues or to identify any new trend for analyzing and reporting.
• Played a substantial role in defining processes and in gathering business and functional requirements.
• Used SAP business object to analyze, export or update data. It was also useful to extract data to prepare reports, identify trends.
• Provided separate data analysis on claims which had Medicare (Part A and Part B) or Medicaid coverage
• Resolving pending claim in teh outstanding balance by making appropriate adjustments and if necessary, contacting pharmacy or insurance company.
• Developed operational solutions by coordinating wif pharmacy, retail operations, IT team, process improvement teams, and others.
• Facilitated Joint Application Development (JAD) sessions wif teh management, Developer and client to make sure everyone is in synchronous wif teh business requirement processes.
• Analyzing production data to determine areas of improvement.
• Gatheird information from clients to set goals for teh month and discuss any issues or requirement they need us to fulfil
• Performed Gap Analysis to understand teh business process and identify teh opportunities and threats for improvement.
• Audited claims which were worked by team.
• Performed other responsibilities such as: Adjusted any claims that has been rejected, organize health insurance claim forms, Review patient bills and statements using Electronic Health Records.
• Conducted weekly calls wif teh client to update them wif a progress. Also discussed about teh issues identified by teh team throughout teh week.

Environment: Microsoft office, Excel, SQL server, outlook, UML, Agile, SAP business object and internal tools.

Confidential

Business analyst

Responsibilities:

• Developed reports which were required to run on daily basis.
• Analyzed business requirement through interviews, documentations and workflow analysis.
• Documented teh reviews, requirements and issues discussed in JAD/BRD sessions.
• Used Tableau to analyze and represent data by connecting it to excel spreadsheet and by using pivot table and VLOOKUP.
• Used JIRA to track any kind of issue and capture history of teh product. Which was useful to provide client wif troubleshooting.
• Facilitated user acceptance testing (UAT) for teh client where they could verify whether teh requirements are met.
• Interacted wif End-Users, Database Administrators, and Oracle Support Analysts.
• Developed a simple database and ETL process to load data for business process and to manage client portfolio.
• Build advanced SharePoint workflows and workflow-based solutions.
• Worked on data trends, to achieve actionable insights and analyze results for clients.
• Analyzed client’s requirement and developed operational and technical solutions.
• Conducted data analysis using SQL and Excel to create reports such as weekly /monthly production report.
• Analyzed organizational expansion by conducting business impact analysis.
• Integrated business solutions wif organizational goals while reaching consensus of teh clients.
• Extensively used MS Project for generating reports and presented it to Executives as required.

Environment: MS Office Tools, Windows XP, MS Project, MS PowerPoint, SharePoint, MS-Word, MS-Excel, JIRA, Tableau