SUMMARY

• 7 plus years of Business Analyst/System Analyst and Quality Analyst experience in all phases of System Development Life Cycle (SDLC): from inception through implementation and experience in handling multiple projects concurrently and following Business Process Flows
• Excellent understanding of Business Requirement gathering, Business Process Modeling and Analysis
• In depth knowledge and experience with the Software Development Life Cycle (SDLC), including requirement, Analysis, Design, Development, Testing, data modeling Implementation of software applications and deployment. Proficiency in scrum managed SPRINT based 'Agile' development model.
• Extensive experience in conducting Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating prototypes, user interface, database schema and system design
• Extensive experience in gathering Business/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements Document (BRD)
• Excellent skills in Data warehousing, Data Analysis and Data Mapping
• Experience in implementing Master of Data Management (MDM) Projects
• Excellent Data Warehousing concepts including Meta data and Data Marts.
• Experience in migrating data from OLTP to OLAP using ETL Tools.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response healthcare benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (healthcare claim) and 834 (benefit enrollment)
• Strong expertise in Health Insurance Claim process, social services, Medicaid and Medicare.
• Experience in conducting GAP Analysis, SWOT Analysis, Cost Benefit and ROI Analysis
• Experience in User Acceptance Testing, Smoke Testing, Regression Testing Performance Testing and Functional Testing
• Excellent communication skills, writing skills as well as presentation skills and experience in working with business users as well as senior management
• Capable of managing multiple projects simultaneously
• Exceptional problem solving and sound decision making capabilities
• Organized, goal - oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion
• Flexibility in adaption to a wide range of work environments
• Belief in team work, dedication, and professional ethics within the working environment

TECHNICAL SKILLS

Databases: MS-SQL, MS-Access, Oracle

Languages: SQL, Java, Visual Basic

Methodologies: SDLC, Agile, Waterfall, RUP, UML

Tools: Test Director, Quality Center, JIRA, SharePoint, ALM, CA Agile Central (Rally).

Operating Systems: Windows 95/98/2000/XP/Vista/NT

Project Management: MS Office Suite (Microsoft Word, Microsoft PowerPoint, Microsoft Excel), MS Project

Change Management: Rational ClearQuest

Business Modeling Tools: MS Visio, Rational Rose.

PROFESSIONAL EXPERIENCE

Systems Analyst

Confidential, Eden Prairie, MN

Responsibilities:

• Involved in various stages of the project as part of requirements gathering, Design and Testing
• Involved in various PLM (Product Lifecycle Management) server upgradation projects like OHBS Facets upgrade, Replacing of cosmos with UPM web services and Sybase upgrade.
• Worked closely with the IT solution Architecture team in defying the Features for the PLM projects
• Participating in the planning, development, coordination and presentation of specific testing needs as appropriate to the quality assurance needs of the end user
• Understanding the business requirements and convert them into user stories in Gherkin format, BDD and ATDD.
• Working with development and testing teams to review the user stories.
• Assisting in writing efficient and effective Test Plans, Test Strategy, System testing, End-to-End Testing and User Acceptance testing
• Providing any clarifications and act as a conduit between business and IT resources.
• Involved in coordinating of Offshore and Onshore team in successful implementation of project.
• Involved in Performance testing of Application by writing Performance scripts.
• Attended grooming, retrospective meetings and applied the task based estimations.
• Attended daily stand up meetings and provided updates and impediments to the team.

Systems Analyst

Confidential, Basking Ridge, NJ

Responsibilities:

• Provide single point for the integration and business services that deliver business functionality for UHCthat are:
• Re-usable, Backend agnostic, Consumer Agnostic, Conform to Industry standards and Canonical message models, Can be leveraged by all UHC segments and Conform to quality standards (Architecture Governance)
• Created Service Design Documents (SDD) based on the gatherings with the consumers and backend teams to help the developers to develop the API’s.
• Created Consumer Companion Guide for onboarding the consumers for the developed services and assisted consumers in consuming the services.
• Created high level Process flow diagrams and Service design diagrams using Visio.
• Developed XSDs based on the data mapping document for handling requests for find, get, upload, update content and update document properties document services.
• Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project
• Used SoapUI for API testing both SOAP and REST protocols in different web services, and wrote Xpath/XQuery language codes to add various assertions for the test.
• Involved in various stages of the project as part of requirements gathering, Design and Testing
• Executed Automation framework using Groovy through SoapUI
• Involved in Performance testing of Application using Jmeter and LoadRunner.
• Generated Logs and reports using Jmeter.
• Tested Web services using SOAP UI and SOA Reported Defects to developer. And generated Reports
• Uploaded the Test Cases into HP ALM for testing and defect tracking after Sprint Release.
• Provided Production and deployment support for the document services like find/get.
• Analyze expected behavior of APIs and test results based on requirements
• Responsibilities included user acceptance testing, system Integration testing, and performance testing.
• Followed AGILE (SCRUM) methodologies in the development, and involved in sprint planning every two weeks.
• Attended grooming, retrospective meetings and applied the task based estimations.
• Attended daily stand up meetings and provided updates and impediments to the team.

Environment: SoapUI, Altova XMLspy, CA Agile Central (Rally), Web services, Jmeter, LoadRunner, ALM, MS Visio, Java, CMIS, SharePoint, MS Office, Scrum, Agile. Confidential, Westborough, MA.

Business Systems Analyst

Confidential

Responsibilities:

• Participating in the planning, development, coordination and presentation of specific testing needs as appropriate to the quality assurance needs of the end user
• Coordinated with Business Owner, Application Vendor, Business Project Teams, Payers and Clearing houses to bring all processes to a level of execution to mitigate any impact to current revenue flow under the HIPAA 5010 compliance requirements
• Used EDI tools to verify mapping to X12 format
• Proactively assist healthcare providers to reduce problem occurrence with EDI transactions.
• Used SQL queries to verify data mapping and to retrieve data.
• Performed data analysis and wrote SQL queries to generate certain requirements and KPI’s.
• Conduct back-end testing of the application using SQL queries.
• Do data analysis for various version changes of EDI messages on different sub-systems
• Assisting in writing efficient and effective Test Plans, Test Strategy, System testing, End-to-End Testing and User Acceptance testing
• Assisting business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center
• Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution
• Providing the required test data for the developers in order to fix the defects
• Participating in QA team meeting and bug tracking meetings
• Tracked and reported defects using Jira

Environment: User Acceptance Testing (UAT), JAVA, SoapUI, SQL, JIRA, MS Visio, Windows, MS Office.

Confidential, New York

Business Systems/Data Analyst

Responsibilities:

• Gathered requirements by conducting meetings with key stakeholders, end users and Subject Matter Experts (SMEs).
• Extensively interacted with the stakeholders and the IT Department in finalizing the requirements according to the Center for Medicare and Medicaid Services (CMS) Compliances/Regulations and HIPAA Regulations.
• Facilitated JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Working within a growing knowledge of ANSI 834 (Benefit Enrollment), 820 (Premium Payment),EDI, Privacy, and Security.
• Interacted with thebusinessusers in knowing thebusinessrules and gathered the reporting requirements to design thebusinessobjects reports.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Involved inbusinessrequirements (BRD/High Level Document (HLD) / Low Level Document (LLD)), Functional Requirement Document (FRD), Project Specifications Document (PSD).
• Prepared Unified Modelling Language (UML) diagrams,BusinessProcess and Data Process Model using MS Visio.
• Organized requirements into high level Use Cases and low level Use Case Specifications.
• Created wireframes and developed a prototype of the GUI using Axure and demonstrated it to the stakeholders andbusinessusers and noted feedback from them.
• Coordinated with project stakeholders to track the progress of the project, updated status and lead the review meeting to ensure that schedules and deliverables are met.
• Assisted product owner on working with USER stories to create Product Backlog.
• Facilitated daily scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues that the Scrum Development team faced.
• During requirements churn, did impact analysis and application feasibility study.
• Worked as a data analyst in creating, designing, developing and implementing Master Data Models
• Performed data analysis and cleansing on the basis of business rules and source data.
• Support data transfer implementation process into the data warehouse including setting requirements, design file layout, data testing and deployment.
• Collaborated as the Data Analyst to design data profiling, Data Cleansing and Data Transformation.
• Tracked defects in HP ALM and worked with QA team to resolve defects.
• Educated and coached staff on use of newly installed, federally required statewide automated child support collection and tracking system
• Assisted in the UAT and in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Worked on JIRA for continuous update with project schedules, quality, issues/defects and managing resources.

Environment: Agile - Scrum, SQL Server 2012, MS Office (Word, PowerPoint, Excel), MS Visio, SharePoint, Spotfire, HP ALM/QC, Axure, JIRA

Confidential, CA

Business Analyst

Responsibilities:

• Implemented the SDLC for the developing life cycle and followed the standards process in the application
• Translated business requirements into functional requirements and approaches for developers
• Provided management support to the off-shore End to End integration/ Regression Test Team
• Workflow documentation and comprehensive training to the healthcare clients
• Analyzed corporate healthcare business processes to develop customized solutions
• Working with Medicare operational management to monitor, trend and report on operational metrics such as timeliness, workload, and staff trending, customer satisfaction, and other key measures to facilitate performance excellence
• Interacted with healthcare clients to gather requirements, objectives, and input and output requirements
• Developed test cases and scripts for front end testing
• Performed execution of test cases manually to verify expected results and Ensured the accuracy and consistency of the data during the data loading process
• Developed Use case, Functional, Object diagrams using Rational Rose
• Responsible for architecting integrated HIPAA, Medicare solutions, Facets
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule
• Developed a detailed test plan and test cases to cover all the requirements
• Used rational Rose to create UML diagrams such as use case, activity, sequence, class and component diagrams
• Developed Flowchart and process diagram using Microsoft Visio
• Analyzed data architecture, documented and delivered data mapping, performed risk analysis

Environment: SQL, SSRS, Test Director, MS Office, UML, Rational Rose, Windows XP, Tableau.

Confidential, Addison, TX

Business System Analyst

Responsibilities:

• Prepared the Functional Specification Document (FSD) and Software Requirement Specifications (SRS) as per SEI CMM standards
• Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project
• Implemented RUP (Rational Unified Process) methodology for iterative and incremental development of the system
• Worked on improvement of Claims Reimbursement User Interface for a better experience and in corporate changes as per HIPAA guidelines using the gap analysis
• Wrote SQL scripts for creating performance evaluation reports
• Developed test cases and test plans on the basis of requirements and also did manual testing of the functionality of the application to ensure that the application is able to handle a lot of data.
• Used UML to create use case diagrams, sequence diagrams and activity diagrams
• Performed Backend testing by using PL/SQL queries to test the integrity of the application
• Developed flowchart and process diagram using MS Visio
• Conducted interviews with clients to analyze their data and gather requirements
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly
• Was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle
• Identified bugs during the test phase and reported them using HP Quality Center.
• Maintained Traceability Matrix throughout the project
• Used the Rational Unified Process (RUP) to build the different phases of Software Development Life Cycle (SDLC)

Environment: RUP, SQL, MS Visio, MS Office, UML, Windows XP, Rational test Manger.

Confidential, Northbrook, Illinois

Business System Analyst

Responsibilities:

• Fully responsible for understanding business logic and designing requirements, assisting other business analysts in generating Functional Requirement specifications (FRS) and User Requirements Specifications (URS) and communication with the developers
• Developed use cases, workflow, screen mock-ups and conversion requirements
• Coordinated work plans between project manager and client using MS Project
• Helped in reviewing and editing of the test scripts
• Followed UML based methods using Rational Rose to develop use cases and activity diagrams; assisted developers in creating sequence diagrams and collaboration diagrams
• Reviewed business process, URS, and functional requirements
• Assisted in process modeling; conducted and participated in JAD sessions with system users; helped with design walkthroughs with stakeholders for base lining architecture
• Created and tested scripts for the premium calculations and claim limits and deductible
• Involved in detailing project mission, data process flow diagrams, and timelines
• Developed Test plans and Test cases according to business requirements with the help of Mercury Test Director
• Used Rational ClearQuest for handling change requests
• Participated in automated regression and Non-functional test plans
• Maintained Requirement Traceability matrix throughout the project

Environment: RUP, Rational Requisite Pro, Rational ClearQuest, MS Office, Visio, Project, Windows XP, UML, SQL.

Confidential

SQL Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers
• Responsible for Design and Normalization of the database tables
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS)
• Gathered requirements for the creation of Data Flow processes for the SSIS packages
• Used various Control Flow Tasks in the development of various complicated packages
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services)

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL SSRS, SQL SSIS.