SUMMARY

• Over 8+ years of professional experience in the Information Technology industry, with expertise in areas of as a Business Systems Analyst, Software Quality Lead & UAT Coordination. Effective team member with excellent interpersonal skills.
• Extensive Experience in Financial, Insurance and Health Care Industries.
• Strong experience in Complete Software Development Life cycle (SDLC) of Data warehouse and HL7 & HIPAA Compliant Applications.
• Hands on experience in Waterfall, RUP and Agile (scrum) methodologies and thorough understanding of Object Oriented Analysis and Design (OOA&D) concepts.
• Extensive design experience in creating UML diagrams such as Use Cases, Activity Diagrams and Sequence Diagrams using MS Visio and Rational Rose.
• Experienced in GAP Analysis, Requirement Traceability Matrix(RTM), SWOT Analysis, Risk Analysis, Impact analyses, Portfolio analyses and Cost Benefit Analysis.
• In depth knowledge of HIPAA 4010, 5010, EDI (file formats like 837 I/P/D, 835) Claim processing, ICD - 9, ICD-10, & HL7.
• Expertise in User Interface Design through wireframes and mock-ups. Familiar with conducting usability studies for the purpose of user interface and layout improvements.
• Hands on Experience with Master Data Management efforts and creation of MDM related artefacts.
• Experience with data manipulation, conversion, transformation and generation of reports
• Good conceptual understanding of Data Warehousing. Proven experience in complete project life cycle - Design, Development, Maintenance and Documentation of Enterprise DataWarehouse, DataMart’s, and Operational Data Stores (ODS).
• Support all electronic interfaces of claim and eligibility systems - 837, 277CA, 835, 834
• Experienced working with Contivo for data transformation and VB skills. Worked with XML, XSD and XSLT and Excel skillsets.
• Worked with the on-site project manager to determine which API services had higher priority based on the agile development.
• Experienced in creating visually attractive Reports using Excel, visual basic, power BI and SQL Server Reporting Services (SSRS).
• Created reports from large data sets by writing complex SQL queries with Inner and Outer Joins.
• Experience in ETL and BI platforms in creating requirements and providing solutions.
• Proficient with web technologies such as HTML, XML, Web Services, Ektron and Alfresco.
• Comprehensive knowledge of SDLC with experience in black box, regression, integration, UAT, load and performance testing
• Assisted DBA’s in building data models identifying various attributes and tables.
• Extensive experience in Physician Workflow, EHR/EMR Web Portals, Health Information Exchange (HIE).
• Generated and validated Radiology and Transcription test messages for Interface validation using EPIC Hyperspace.
• Experience in conducting Joint Application Development (JAD) sessions and requirement gathering sessions to converge early toward a design acceptable to the customer
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users
• Worked in close co-ordination with the testing team in developing Test plan and Test cases from functional and business requirements.

TECHNICAL SKILLS

Methodologies /Business Modeling Tools: Spiral/Waterfall, RAD, JAD, RUP, Agile, SCRUM, UML, Prototyping, Use Case, MS Visio, MS Office Suite, MS Project, Rational Rose, Rational Requisite Pro

Office & Graphics: MS Word, Excel, Power Point, Project, Outlook, Adobe Photoshop

Operating Systems: Windows, XP, MS-DOS, Linux RH, UNIX

Database: MS-Access, SQL Server, PL/SQL, Windows

Working knowledge of Testing Tools: HP Load Runner, Win Runner, Test runner

Technologies: Duck Creek, Guidewire, SharePoint, POS

Business Skills: Business Requirements Gathering Techniques, Business Gap/Process Analysis, Data Analysis, Use Cases, Document Analysis, Existing and Future Workflow Analysis, Impact Analyses, Facilitating Group discussions, Training

PROFESSIONAL EXPERIENCE

Confidential - Rochester, NY

Sr. Business Analyst

Responsibilities:

• Gathered and analyzed business requirements to develop User Requirements Specifications of the application to be developed.
• Used Agile Methodology with extensive training in Rally tool. Conducted sprint planning and sprint review meetings.
• Conducted every day scrum calls and reviewed developed product.
• Responsible for planning sprints for application development. Grooming, developing and assigning planned epics and User Stories for new sprint.
• Closely involved with software development team in assigning tasks and understanding technical needs and provided documentation.
• I have helped Eligible Professionals seek certified EHR technology, determine the necessary technological capability, functionality, and privacy and security capabilities to help them meet the meaningful use criteria.
• Coordinated with Business and Development Team to convey business needs and end-user sentiments.
• Gather and document requirements for EMR system configuration.
• Followed HIPAA compliance and other security issues to safeguard patient information.
• Performed Mapping, Gap Analysis and Feasibility Studies for web service call response and UI display.
• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
• Developed PRDs, SRDs, and traceability matrices.
• Changed and Reviewed SIM services data and content data analysis tasks such as data mapping, gap analysis, mapping document conversion, XML Schema (XSD) updating, XML Schema conversion to Excel spreadsheet formats.
• I have been engaged in helping physician practices establish Medicare and Medicaid EHR Meaningful Use.
• Developed and maintained Flow Diagrams for understanding the newly developed application.
• Involved in writing and reviewing Test Cases during application development based on User Stories. Used Quality Center as a testing tool.
• Compute payroll that includes pay changes and collect and analyze statistical data required to prepare payroll reports.
• Arranged interviews with all the stakeholders to review and understand the gathered business requirements
• Documented all the sources of customer Data and created mapping documents.
• Validated the Customer records to ensure Data Quality and correctness.
• Verified and validated all build or release related issues and resolved them through discussion with business analysts with users’ approval.
• Created User Acceptance Testing (UAT) Plans and detailed documentation for the Claim Management Application.
• Facilitated and ensured user awareness of new functionality through training sessions, demos and release notes post every production release.

Environment: MS Office, MS Visio 2010, MS SQL Server-2013, SharePoint, Power BI, Visual Studio

Confidential - New York City, NY

Sr. Business Analyst

Responsibilities:

• Gathered and analyzed business requirements to develop User Requirements Specifications of the application to be developed.
• Managed end-to-end product stream. Involved in user prioritization meetings and resolved issues with business users/stakeholders for the system enhancements.
• Documented all the sources of customer Data and created mapping documents.
• Validated the Customer records to ensure Data Quality and correctness.
• Validated Customer Records using IBM Inspector in the process of identifying the Golden Record of Customer.
• Developed EPIC’s from the Themes and Documented the Product Backlog for the release.
• Presented and Detailed Product Backlog Items to the Scrum Team in the Sprint Planning Sessions and assisted them in arriving at the Story Points for the User Stories.
• Perform Requirement Elicitation by interviewing the physicians, Radiology and laboratory technicians.
• Process and maintain all status reports and pay changes through ADP and paper system
• Reviewed user Stories and Acceptance Criteria with the team
• Assisted the Scrum Master in Creating and Managing the Release Planning Documents in the VersionOne and Share Point Repository.
• Assist in developing and maintaining data integrity protocol between HR, Payroll, and Accounting, between departments and business leaders
• Experience on SQL queries to extract data from databases to get the output.
• Assisted Scrum master in Developing the Task Sheet and Burn down Charts.
• Facilitated Demos of the software output of each Sprint and assisted Business in making Decisions on the release during the Sprint Review Meetings.
• Conducted requirements Churns between Sprints to update the product backlog.
• Conducted Analytics and Assessments to derive the Team Velocity based on the various Sprint Outputs.
• Prepared Data Flow Diagrams and Use case models using MS-Visio.
• Managed requirement change requests and implemented procedures for test changes.
• Created master test plan and test cases and coordinated with users for the new system testing.
• Worked with QA team during the automatedtestingand preparation of testing reports using HP Quality Center.
• Held project level testing status meeting to review new defects and status of open defects.
• Facilitated UAT (User Acceptance Testing) for the application
• Provided production support after the deployment of Window7 server.

Environment: Agile, JIRA, MS Office, Lync 2013, MS Project, MS Visio 2010, MS SQL Server, ASP.net, SharePoint 2010, ServiceNow.

Confidential - Minneapolis, MN

Business Analyst

Responsibilities:

• Gathered requirements through a series of interview sessions and group meetings with the identified users and developers to design, build and release the Public Facing Website.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout the Project to resolve open issues.
• Performed HL7 standards analysis and documented the enhancements to meet the end state requirements.
• Assist with weekly payroll processing and analysis.
• Produced Visuals for the application using Azure tool and created Use Cases, State diagrams, Sequence Diagrams and Activity Diagrams.
• Experience writing, testing, implementing, and transitioning programs for various depts as well as Hipaa compliancy - ANSI X12 834, 837, 999/997, 277ca
• Developed EPIC’s from the Themes and Documented the Product Backlog for the release.
• Presented and Detailed Product Backlog Items to the Scrum Team in the Sprint Planning Sessions and assisted them in arriving at the Story Points for the User Stories.
• Reviewed user Stories and Acceptance Criteria with the team
• Assisted the Scrum Master in Creating and Managing the Release Planning Documents in the VersionOne and Share Point Repository.
• Assisted Scrum master in Developing the Task Sheet and Burn down Charts.
• Facilitated Demos of the software output of each Sprint and assisted Business in making Decisions on the release during the Sprint Review Meetings.
• Conducted requirements Churns between Sprints to update the product backlog.
• Conducted Analytics and Assessments to derive the Team Velocity based on the various Sprint Outputs.
• Designed HL7 mapping and UI document for the Website.
• Used SQL statements and procedures to fetch the data from the database.
• Created UI mock ups and PoC’s for the Public facing user interface and the adverse event Reporting form.
• Extensively analyzed XML’s and documented business rules and Validations for XML documents.
• Worked closely with the Scrum Dev architects and Content Engineers for Design and Development of Infobutton WebServices.
• Worked with Scrum QA team to go over the various test scenarios for different types XML Elements and Data Fields in the WebServices.
• Created the UAT document and conducted the UAT testing and Smoke Testing for the Release.

Environment: Agile, TFS, MS Office, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server

Confidential - New York City, NY

Business Analyst

Responsibilities:

• Gathered and analyzed business requirements to develop User Requirements Specifications of the application to be developed.
• Managed end-to-end product stream. Involved in user prioritization meetings and resolved issues with business users/stakeholders for the system enhancements.
• Automated manual process to reduce cost and increase productivity
• Extensively used Enterprise Architect and MS Visio to formalize Requirements and report the same to the Implementation and testing teams.
• Gained a clear understanding of the Medico-Financial processes.
• Conducted JAD sessions both as Facilitator and Scribe.
• Created Use cases and Use Case Stories Formatting Use Case Narratives.
• Closely interacted and updated with Team Lead, Systems Testing Team and Associate Managers on weekly Status updates about the Project development.
• Developed test cases and scripts based on business requirements for the GUI, functional & Performance testing.
• Worked on Test Cases for the Med-Underwriting Processes, G-Fin and Securities applications.
• Worked with QA team during the automatedtestingand preparation of testing reports using HP Quality Center.
• Held project level testing status meeting to review new defects and status of open defects.
• Facilitated UAT (User Acceptance Testing) for the application
• Provided production support after the deployment of Window7 server.

Environment: MS-Word, Advanced Excel, MS Access DB, SQL Server 2008, Power Point, HP Quality Center, Windows XP, Windows 7, MS Visio.

Confidential - Providence, RI

Business System Analyst

Responsibilities:

• Worked with the core team to gather businessrequirements from multiple stakeholders, accounting, operations and management groups - and reconciled conflicts by conducting Joint Application Development (JAD) sessions based on the project scope.
• Analyzed Business Requirements and segregated them into high and low level Use Cases and Activity Diagrams using MS Visio.
• Performed GAP analysis involving the current state and proposed state.
• Worked closely with other BAs and ETL Leads/Managers and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation.
• Provided the ETL team with the Datamapping document and assisted them to create the mappings.
• Worked closely with the architects, database administrators and technical team during Data Mapping and Data Integration.
• Experience in analyzing data using excel and creating Pivot tables and creating reports using SQL.
• Involved with Analysis of reference data from Accounting Systems and Investment Accounting Groups.
• Perform HR functions to include processing payroll through ADP, orientating new associates, process unemployment and worker compensation claims and maintaining employee files.
• Organized meetings with the SMEs and Data Owners to walk through the findings and determine the cleansing process.
• Authored Requirements documentation (BRD, FRD); workflow design and analysis.
• Provided TO-BE process design, Gap analyses.
• Experience in data mapping, data analysis and creating reports (Using SQL database and visual studio).
• Provided ETL process design and requirements, Data MappingandBI reporting requirements.
• Provided DTD (Document Type Definition) for XML files to be used in the ETL process.
• Participated in Change Management Board meetings to ensure deliverability of functional requirements change and to assign priority to approved changes.
• UI modeling and Functionalityfor Web based Dashboard.
• Provided Use Casemodels,unittest and UAT scenarios,developmentteam support.

Environment: MS-Word, Advanced Excel, MS Access DB, SQL Server 2008, Power Point, HP Quality Center, Windows XP, Windows 7, SQL, Informatica Power Center 8.6, Oracle 10g, MS Visio.

Confidential

Business Analyst

Responsibilities:

• Interacted closely with the Business users (Physicians) along with the administration and management to gather business requirements and analyze the functionalities to be incorporated into the system
• Participated in JAD sessions / conducted interviews for analyzing business requirements and reviewing them with business and technical teams
• Identified all necessary Business and System Use Cases from requirements, created UML diagrams, including Use Case Diagrams, Activity Diagrams and Data Flow Diagrams using MS Visio.
• Attended demo sessions to understand existing system functionalities
• Arranged interviews with all the stakeholders to review and understand the gathered business requirements
• Developed UID Documents, FRD and other SDLC Artifacts
• Coordinated with system architects and developers to convert business requirements into system requirements
• Conducted Demos and walkthroughs for Confirming Business requirements
• Developed UAT strategy, UAT Plan and facilitated UAT
• Verified and validated all build or release related issues and resolved them through discussion with business analysts with users’ approval.
• Conducted Smoke tests in Production and Documented Lessons Learnt during the Project.