SUMMARY

• 7+ years of experience in Agile (scrum/ Kanban) IT industry in Business Systems Analysis, Data Analysis, Development and Client Relationship Management
• Experience with health care System.
• Lead and manage all aspects of a project from Business Analysis to project planning, engaging with business sponsor and stakeholders, driving IT system design and implementation.
• Study existing business processes and re - engineer them for more improved, optimized, efficient and streamlined processes.
• Experience in various Agile Methodologies including Scrum and Kanban.
• Good knowledge on different modules within healthcare (Membership, billing, enrollment, claims, capitation, providers).
• Hands-on knowledge with QNXT
• Experience handling HIPAA ANSI X12 (270/271, 834, 835, 837, 276/277), ICD9/10, NDC, DRG codes.
• Experience in preparing various documentations like Functional Requirement Document (FRD) / System Requirement Specification (SRS), Source to Target Mapping Document (STTM), Report Specification Document (RSD), Requirement Traceability Matrix (RTM) and other client specific documents.
• Experience in working with various database environments like SQL Server 2005/2008/2012, Oracle 10g /11g and MS Access databases.
• Excellent team player with experience in working medium to large size project team / Strategic initiatives that includes Business stakeholders, Architects, Project Manager, ETL Developers, Quality Assurance team.
• Awareness of all SDLC methodologies & models - Staff Augmentation, Co-development, Managed Service, Fixed Prices, Waterfall, Agile, RUP's Iterative in both onsite-offshore model.
• Proficient in eliciting requirements and assisting the ETL/ Quality assurance team for business intelligence / data warehousing environments including technologies and processes across data sourcing, validation, reconciliation, and reporting.
• Design use cases, create prototypes and proof of concept as part of evaluating new solutions and also write functional spec doc (FSD), high level scope docs, guide IT development teams and assisting with business testing / User Acceptance Testing (UAT).
• Perform business analysis for Data warehouse/BI based systems and deliver high level scope and functional specification documents for ETL, BI Reports design/development
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Worked on multiple tools and technologies, several different IT Applications and databases including Oracle and Teradata, also Informatica ETL and Business Objects, OBIEE.
• Extensive collaboration with the Quality Assurance team in providing inputs to create Test Strategy, Test Plans, and Test case and involved in defect tracking using HP Quality Center.
• Involved in AGILE software development methodology and experienced in managing and capturing requirements in sprints.
• Utilized Team Foundation Server (TFS) and MS Visual Source Safe as Source Code Control Systems.
• Experience on Windows Server 2008, Active Directory and in Software Adaption and Modification Control System.
• Extensive experience in RDBMS database design and experience in writing SQL scripts, Stored Procedures, User Defined Functions (UDF) and Triggers for SQL Server 2005/2008/2012 .
• Self-motivated individual with capability of working in multiple projects, excellent communication skills, ability to work independently or part of a team and able to adopt new skills.

TECHNICAL SKILLS

Change Management Tolls: Clear Quest, ERWIN, Requisite Pro, Test Director

ETL Tools: Informatica 9.1/8.6/8.1/7.1, Data Stage 8.0/7.0,teradata

Database: Microsoft SQL Server 2012/2008/2005, T-SQL, Oracle 11i/10g, PL/SQL

Applications: Microsoft Office, Adobe Acrobat, Microsoft Visio

Product Methodologies: Agile, Waterfall, SCRUM, RUP, SDLC

Business Modeling Tool: MS Visio, Rational Rose, HP Quality Center

Operating System: Windows NT/2003Server/2008Server/XP/Vista/7, Unix, Linux

Version Management: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Business System Analyst

Responsibilities:

• Served as a liaison between the business team members and the Information technology team.
• Contributed to the definition of scope, preparation of work plans and definition of business requirements.
• Facilitated various scrum meetings and GAP discussions in collecting and analyzing requirements
• Facilitated and managed meeting sessions with committee of Subject Matter Expert from various business areas.
• Responsible for functions on projects of moderate to high complexity.
• Check test files and production files in Medical Claim Mainframe System for Step Up Step down Project
• Performing Impact analysis for readiness of ICD-10 conversion.
• Working with business partners within multiple business functions to align technology solutions with business strategies.
• Elicit, document and refine business requirements for the IT organization.
• Responsible for GAP analysis of ICD9-ICD10 implementation and claims processing.
• Responsible for reporting processed, rejected and un processed claims using visual basics and SAS reporting.
• Engage in bug triage and work with engineering team to fix defects, coordinate with operations team to deploy the fixes in UAT/Production.
• Provide Pre-UAT training to users on application features and assist them in UAT execution.
• Responsible for gathering user requirements that are specific to our scope of work.
• Created Detailed Requirement Document (DRD) which provides requirements needed for Data Modeling and ETL development.
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement.
• Developed the Functional Requirement documents, reviewed with stakeholders and received sign-offs.
• Timely identifying issues and raising defects through Clear Quest (Defect Management tool)

Environment: MS Visio, Windows 2000/2003, RUP, Rational Requisite Pro, Rational Rose, MS Office, SDLC, Agile Methodology, UML,SQL, Oracle, MS Project, MS Office.

Confidential, Denver

Business Analyst

Responsibilities:

• Understanding business requirements for Medicare Part D file required for CMS (Risk Management, RAPS and suspect management).
• Worked on developing the business requirements and use cases for FACETS batch processes.
• Worked on customization screens/reports related to Member, Enrollments, and Providers in FACETS.
• Worked on Member Management, Eligibility, Claims, and Provider modules within FACETS
• Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, premium billing, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system to FACETS.
• 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.
• Experienced in using JIRA and RALLY agile scrum tools.
• Responsibilities spanned through all phase of the project life cycle from inception through post-implementation.
• Responsible for Electronic Medical Record implementation with various vendors.
• Conducted one-to-one interviews and group meetings with the Subject Matter Experts (SME’s) to gather the business requirements.
• Created Entity Relationship diagram (ERD’s) and process flow using UML and Microsoft Visio to clearly communicate the business requirements.
• Translated the business needs, wants and objectives into requirement and created Business Requirement Document (BRD) and Functional Requirements Documents (FRD) using Requisite Pro.
• Developed Requirements Traceability Matrix (RTM) to track requirements against test cases during the QA Phase.
• Facilitated formal defect review meetings with project teams and developers to report, demonstrate, prioritized and suggest resolution of issues discovered during testing.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.

Environment: MS Office Tools, Windows XP, Oracle, SQL, Rational Clear Quest, Rational Clear Case, ERWIN, Requisite pro, Microsoft Visio, FACETS 4.21

Confidential, Torrance, CA

Business System Analyst

Responsibilities:

• Involved in gathering requirements and defining scope with non-technical business user constituencies overseas.
• Interviewed various non-technical managers to understand complex, dynamic business rules/process and then created detailed, specific and comprehensive documentation.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) for application development.
• Worked with business users to ensure cohesive articulation of business goals and processes to ensure effective technology solutions.
• Created wireframes for different applications.
• Identified UI requirements, created Wireframes, Prototypes and UI specification using MS Front page.
• Created Need Analysis Documents of the requirements gathered through JAD and individual elicitation sessions using MS Visio.
• Analyzed business requirements into high level and low level Use Cases, Activity Diagrams.
• Involved in analyzing the key data for the data warehouse design as per the information gathered from the SMEs to generate key reports. Reengineered the user interface of the application.
• Worked with business users to support all necessary clarification for the Project Team, Developer Team and Production Support Team to design and implement an effective solution.
• Created Business Process Mapping Diagrams and Documentation for the process improvement recommendations.

Environment: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), UML, Rational Rose, Test Director, MS Office Tools.

Confidential

System Analyst

Responsibilities:

• Created System Requirement Document (SRS)/ Functional Requirement Document (FRD), Source to Target mapping document (STTM) and Requirement Traceability matrix (RTM).
• Scheduled, Facilitated and managed meeting sessions with business team members from various business teams.
• Conducted walkthroughs of SRS, STTM, RTM documents with all stakeholders.
• Performed Data Analysis in SQL Server 2008 and also involved in creating the inventory list of impacted data element.
• Involved in Data Profiling, writing scrub rules, providing input to data modelers that include Data type and length.
• Assisted ETL development done using Data Stage and report development using SSRS.
• Participated in Agile Scrum planning meeting and provide status on daily stand up meetings.
• Participated in the review of Test Strategy and Test plan documents.
• Schedule and facilitate the requirement meetings, weekly touch point meeting with Dev and QA team.
• Interacted with the client during requirement gathering phase.
• Analyzing requirements in order to determine and provide realistic estimates and Solutions.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed basic testing of security features using manual testing
• Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle.

Environment: Visual Studio 2012, SQL Server 2008, Agile Methodologies, Access, UML, MS Visio 2008, Microsoft Office 2008, HP QC, Clear Quest, RUP

Confidential

System Analyst/Test Engineer

Responsibilities:

• Conducting JAD sessions with customers to identify business requirements & propose a solution for them.
• Preparing Functional Requirement Document by using all relevant UML diagrams, wireframes, prototype,
• Mockup screens and simulations.
• Creating Requirement Traceability Matrix (RTM) to trace requirements and manage Change Requests.
• Preparing test plan, test scripts and test cases for the business requirements.
• Executing Test Cases in the concerned test management tool.
• Defect reporting, defect tracking and analysis.
• Participated in regular project team meetings to discuss testing procedure and assignments.
• Preparing daily and weekly status report to the clients
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, and Transformation Developer.
• Assisting the QA team in designing the test plan and test cases. Performed User Acceptance Testing
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.

Environment: SDLC, XML, Agile Methodology, UML, Oracle, MS Project, MS Office.