SUMMARY:

Astute, Business Analyst with 6+yrs of consulting experience including Healthcare and Insurance. Possess strong business process modeling skills, and performs interviews and meetings to conceptualize business processes, gather requirements, and to design artifacts including UML Use Cases and Activity diagrams. Demonstrated expertise with Medicare and Medicaid, including Claims, Adjudication and Billing. Skilled at activity diagramming, and developing use cases Models and documents. Skilled at facilitating JAD sessions, interviewing, document review, and brainstorming, in order to document artifacts such as BRDs, FRS, Use Cases, Activity Diagrams, Test Cases, and Test Plans. Extensive experience in Healthcare industry including HIPAA regulations, and EDI standards (X12 and HL7). Experience developing process maps, and AS - IS and TO-BE process conceptualization and improvements. Have strong facilitation, collaboration, and communication skills. A hard-working and results-oriented analyst who consistently goes the extra mile, and is known for teamwork, and character.

TECHNICAL SKILLS:

Business Modeling Tools: Visual Paradigm, MS Visio, PowerPoint, Rational Rose

Requirements Gathering Tools: Rational RequisitePro, MS Word, MS Excel

Microsoft Tools: MS Office, MS Visio, MS Project

SDLC Methodologies: RUP, Prototyping, RAD, Waterfall

Testing Tools: Mercury Test Director

Database: MS Access, Oracle 9i, MySQL

Operating Systems: Windows 2000/XP, Vista, DOS

Programming Languages: PL/SQL,VB.Net, QBasic, HTML,PHP, ASP.Net

Defect Management Tools: Mercury Test Director, Rational ClearQuest

PROFESSIONAL EXPERIENCE:

Confidential, Little Rock, AR

Business Analyst

Responsibilities:

• Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations and to discuss the different ways and means for migrating data.
• Gather requirements from the stakeholders and facilitated meeting for a final sign off as well as developing and maintaining business rules.
• Documented requirements along with a detail data analysis of the systems involved and defined data mapping rules and created source data for the ETL.
• Worked on healthcare standards such as HIPPA 4010, 5010, ICD-9 and SOAP.
• Document the business processed surrounding Medicaid claims, benefit plans, claims payment cycle, waiver programs, and references.
• Involved in analyzing and gathering requirements for various EDI 834 transactions & also SAS reports which includes Analyzing address type of the members, calculate the age of the members, CSV zip code information for the SMI members, Acuity, HI BH Druglist, Access To Medication etc
• Worked as the primary liaison between the business user and the developers throughout the project cycle.
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.
• Worked with CURAM System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPPA 834 and proprietary format files and Reports development.
• Preparing the guidelines of migration to organize the business rules for conversion from scratch.
• Used Toad for Creating and executing SQL Queries for Data Analysis and extensively involved in Database testing.
• Wrote test cases and test scripts for the User Acceptance testing (UAT) and supported unit, integration and regression testing.
• Setup Procedures to Extract, Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse by Using Informatica.
• Authored data flow diagrams, sequence diagrams, and business process models that describe how the data is anticipated to flow from one system to another.
• Experience in writing SQL queries to validate data while performing research/analysis and data modeling.
• Created Interfaces and writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents.
• Actively participated in status report meetings and interacted with developers to discuss the technical issues.
• Setup Procedures to Extract, Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse by Using Informatica.
• Responsible for defect tracking and bug reporting using JIRA; interacted with developers and Business Analysts to discuss and resolve defects.
• Involved in daily defect review meetings to review the status of defect fixes and upcoming build releases.
• Verified and validated all the build or release related issues and resolve then through discussion with business analysts with the users approval.

Confidential, Plano, TX

Business Analyst

Responsibilities:

• Utilized SDLC Methodology to configure and develop process, standards and procedures
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business workflows & task analysis and determine whether any current or proposed systems are impacted by the new development efforts.
• In depth analyzing & testing for 834/835 Inbound & Outbound process of X12 through X-Engine until Submission file to State in ETL Process for Various LOB's.
• Coordinated with various IT teams related to various backends(WGS, Facets, Nasco etc) for Test Data Setup in SIT & UAT environments
• Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using Test Director & Clear Quest
• Projects included designing retail architecture for Do Not Solicit, Customer Proprietary Network Information, U-Verse and DSL product sales and Order Life Cycle Reporting applications. Adhered to a Service-Oriented Architecture framework and utilize System Development Life Cycle and IT Unified Process techniques for all ongoing projects.
• Facilitated problem solving, client interface interaction design, analysis of data flow/data model, and technical leadership with business intelligence teams.
• Performed User Acceptance testing & End to End testing in interaction with Offshore QA/dev teams for various system releases & pushed them to production
• Provided Production support, documented System Release/deployment issues & SOX documentation for Business Signoff.
• All work performed in a SOA (Service Oriented Architecture) and using an Agile development methodology.
• Design/implement multiple enterprise business intelligence solutions to create
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Analyzed various 834 Claims, Membership, Billing, Benefit and plan
• Work closely with EDI to ensure accuracy in data transmissions and shared processes. Transaction sets processed (834,835)
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
• Author release management plans, release notes and code migration documents.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Always maintained excellent problem-solving and communication skills; and effectively listened, negotiated, debated, discussed, brainstormed, communicated, and collaborated with a variety of individuals and groups

Environment: Life70, DB2, QSAM, VSAM, TeamWorks, EZTRIEVE, COBOL, Assembler, J2EE, MS SQL Server 2005, MS Office, MS Visio, Certify, MQC, VB.Net, Java

Confidential , Austin, Texas Area

Business Analyst

Responsibilities:

• Evaluated business process requirements to ensure proper system configuration (i.e. identifying key decisions, process changes, pain points, interface issues, training considerations, etc.)
• Managing software projects development and delivering custom made solutions based on Service Oriented Architecture SOA.
• Served as a liaison between the internal and external business community (Claims, Billing, Membership, Capitation, Customer service, membership management, provider management, advanced Healthcare management, provider agreement management) and the project team
• Understood the healthcare plans offered, including Medicaid Managed Plans such as Children and Adolescent Care, Women’s Preventive Care, Maternal Care, Asthma Care, Diabetes Care, Cardiovascular Care, and Mental Health
• Performed Functionality testing, Integration testing, System and UAT. Documented and logged the results and defects.
• Gathered AS-IS and TO-BE information about Confidential ’s work processes and information flows (Claims process, Membership, Enrollment), and conceptualized using swim lane activity diagrams
• Created and reviewed User Requirements Document, Use Cases, and Functional Requirements Document
• Gathered and prioritized requirements, developed business scenarios to check how the system would work with the roles and processes of the departments, and developed acceptance criteria
• Used the DataStage Designer to develop processes for extracting, cleansinfg, transforms, integrating and loading data into data warehouse database.
• Facilitated review of Enrollment, Claims, Commissions, and membership portlets’ designs with architects and developers to ensure that the goals of the portal requirements were satisfied
• Utilized Microsoft SQL 2005 and associated business intelligence tools (SSIS, SSAS, SSRS) to provide focused transaction and task monitoring and error handling on an enterprise level.
• Produced UML Activity diagrams with defined swim lanes using MS Visio as part of claims process analysis
• Brought valuable knowledge and solutions to business groups to enhance competitive edge with Facets Extended Enterprise(TM) administrative system implementation
• Contribute in the build and design of an automated documentation system that met business process needs by providing comprehensive knowledge of workflows, policies and procedures, patient care objectives, regulatory requirements, and industry best practices for membership management
• Analyzed & Tested HIPAA Gateway Application Interface for all inbound and outbound messages (Healthcare Eligibility 270 and 271, Healthcare Claim Status request 276 and 277, Healthcare Claim 834)
• Participated in all phases of the Facets Extended Enterprise(TM) administrative system implementation including the planning, designing/building/validation (DBV), testing, and Go-live support phases
• Involved with various aspects of the project’s needs such as the logging, tracking, and resolution of issues, current state workflow assessments, facilitating/presenting DBV sessions, and assist with integration testing
• Worked on modules related to Providers, Contract & Claims and worked with Claims, Provider attributes, enabling EOB & Remit rules associated with Provider configuration process in Facets.
• Conducted User Acceptance Testing and user training pertaining to old and new Affinity Provider ID appearing on documents providers receive from Affinity (mainly occur with EOPs, capitation rosters, PCP membership rosters, provider directory listings and some system generated letters)

Environment: Facets4.7, Facets Extended Enterprise(TM), Oracle, MS Word, Windows XP, S SQL, VB.NET, HTML

Confidential, Palo Alto, CA

Business Systems Analyst

Responsibilities:

• Gathered User and Business Requirements through interviews, surveys, prototyping and observing Stored and modified requirements.
• Liaised between technical and business teams for obtaining status/updates as well as sharing best practices.
• Created Need Analysis Documents of the requirements gathered through JAD and JRP individual elicitation sessions using MS Word.
• Created User Requirement Specifications (URS), Business Requirement Document (BRD) and Functional Requirement Specifications (FRS) documents.
• Created Use cases, Use Case Diagrams, Activity Diagrams, Business Flow Diagrams and Business flow diagram using Rational Rose and Rational Requisite Pro.
• Involved in analysis of the technical specifications of the current system and the infrastructure needs performed Gap analysis.
• Created complex stored procedures using SQL with multiple table joins and comprehended and isolated areas problems.
• Made Screen Mockups/Definitions and Dependencies using Excel.
• Extensively used SharePoint to document project processes and procedures, communicate requirement and version control them.
• Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.
• Experienced setting up test scenarios and executing on these scenarios and worked closely with testing team to make sure all the changes made to requirements documents are implemented in there Test Cases
• Maintained various versions of the documents generated during the project using Rational Clear Case
• Used Agile development methods to promote development iterations, team work, collaboration and process adaptability and strong experience with Scrum
• Created User Stories to capture all requirements.
• Set up definitions and process for test phases including Product test, Integration test, System test and User Acceptance Test (UAT).
• Conducted GUI testing, Functional Testing, Smoke Testing, Integration Testing, Performance and User Acceptance Testing on the application.
• Extensively worked on Mercury Test Director for bug reporting/tracking.
• Worked with SQL extensively to test database integrity.
• Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a project
• Conducted Training Sessions to familiarize users with system.

Environment: Agile/Scrum, Rational Rose, Rational Requisite Pro, UNIX, MS Visio, MS Project, MS SharePoint, HTML, Windows, Oracle, SQL, people soft, IBM Web sphere, Business Intelligence.

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Assisted in the Project manager in creating and updating the Vision Documents, Business case, and the Project Plan to define Objective, Scope and Risks. Also assisted in creating RUP iteration plans and phase plans
• Elicited requirements, and managed Change Configuration to maintain an orderly procedure for managing requirement changes after sign off
• Elicited functional specifications, conducted feasibility analysis, and performed impact analysis
• Elicited Business Rules and other Non-functional specifications for the new system by interviewing the Subject Matter Experts (Doctors & Nurses) to further understand the business models
• Authored functional specifications for different HL7 system interfaces: ADT (registration), SIU (scheduling), OMG (rad order entry), and ORP/RDS (Rx processing)
• Responsible for Back-End Testing Using SQL Commands using TOAD.
• Documented and reported feedback made by users. Documented out of scope (but relevant) requirements to aid in new Initiatives or Enhancement projects (future upgrades)
• Created Request For Proposal to identify possible vendors and obtained cost and functionality information
• Created UML Activity Diagrams to depict business processes (AS-IS and TO-BE) and analyzed them for their efficiency and productivity
• Tracked UAT issues/bugs and prepared reports.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Created Use Case Model using Rational Rose for developers and other stakeholders to understand the business process, depict roles, and procedures
• Facilitated requirement-eliciting sessions (JAD sessions) with Subject Matter Experts and other Key Users and documented the requirements in an easy to understand format by both the business and technical personnel
• Constructed Use Cases and Wireframes and translated them into a Functional Requirement Specifications document
• Performed manual testing, including validation/smoke testing of HL7 interface messages on each new build before delivering to quality assurance team
• Assisted quality assurance team to functional-test the new HL7 interfaces always keeping in mind HL7 and HIPAA guidelines, and coordinated user acceptance testing using derived test data
• Created Online User Guide comprising different scenarios, screenshots, and troubleshooting procedures

Environment: MS Project, MS Excel, MS Word, Rational Rose, MS PowerPoint, UAT,Oracle 9i, Citrix (server), Epic

Confidential, Santa Ana, CA

Business Analyst

Responsibilities:

• Worked in accordance to the activities/roles laid down in each phase of software development life cycle created using Rational Unified Process
• Created specifications for EDI HL7 (A28, A31, ADT) and X12 (834/837) transactions that were transmitted between Claims Editor and Legacy Billing application and external Payers
• Organized meetings to elicit expert knowledge of the TO-BE business process in an effort to generate requirements
• Analyzed business requirements and created Use Cases, activity diagrams using MS Visio
• Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
• Updated requirements document, Use Cases, and FRS according to Change Control Committee’s approval of CR and the Traceability of the documents
• Performed GAP Analysis by comparing the existing system to the future system to create “AS-IS” and “TO-BE” flow charts and generating risk assessment
• Drafted a Traceability Matrix in Excel and imported it into Rational RequisitePro
• Worked as a liaison between the developers and the QA team in creating the Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible
• Maintained and Reviewed Change Requests and documented all analysis
• Conducted User Acceptance Tests to ensure that all mutually agreed upon user requirements had been met and to gather additional requirements for enhancements to the application for future release

Environment: J2EE, XML, HTML,UAT,WebLogic, Oracle9i, MS Word, MS Outlook, MS PowerPoint, MS Visio, Rational RequisitePro