Business Systems Analyst Resume
Dallas, TX
SUMMARY
- Qualified professional with nearly 7 years of extensive experience in the field of Business / Systems Analyst. working with the implement management and staff's business requirements into the software application in Healthcare /Pharmaceutical Industry.
- Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross - platform environment.
- Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements. Knowledge and vast experience of PMBOK and BABOK.
- In-depth knowledge of creating use cases, Claims Processing and functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
- Knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare and EDI
- Expertise in understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis .
- Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
- Build EDI test environment and provide parallel testing and start-up process
- Expertise in the use of tools such as Caliber RM, Rational Rose, Requisite Pro, Starteam, Test Director
- Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Extensively used rational tools for UML, tracking and reporting and applied the Rational Unified Process in all areas of a software development life cycle.
- Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
- Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Commissions and Billing Modules of Facets.
- Gathered and documented Non-functional requirements.
- Experienced in preparing Business Process Re-engineering Models
- Written multiple Use Cases for EDI transactions (Inbound and Response) including 837, 276, 277, 835, 834, 820, 270, 271 transactions.
- Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
- Familiar with HIPAA EDI transactions such as 834,835, 837 (P, D, I) 276, 277, 278 etc
- In depth knowledge of SDLC and implementation of the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
- Test Data Generation for Quality Assurance using various testing tools like EDISIM or EDIFECS, conducting JAD (Joint Application Design) sessions.
- Good hands on experience testing of inquiry screens to support EDI transactions.
- Utilized a fusion of industry knowledge and technical programming to provide executive management the development and implementation of interactive busines s tools, and strategic analysis, vital for use in mission-critical decision-making
- Extensive Knowledge about all the phases of Business Analysis Life cycle like Requirements Elicitation, Requirements Analysis, Requirements Documentation and Requirements Management.
- Conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way using Rational Requisite Pro to track development.
- Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
- Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
- Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
- Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
- Used Rational ClearQuest for tracking and prioritizing defects and for enhancements after base lining the requirements.
TECHNICAL SKILLS
Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, DoorsErwin Data Modeler 4x, Business Object (Crystal Reports)
Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis
Methodologies: RUP, OOAD, UML & Business/Data Modeling
Project Management Tools: MS Project, Microsoft Office, Lotus Notes
Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker
Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux
Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2
Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET
Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center
PROFESSIONAL EXPERIENCE
Confidential, Memphis, TN
Sr. Business Analyst
Responsibilities:
- Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
- Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts. Enforced the business rules for Sample Management process by implementing validations and restrictions.
- Involved in performance tuning efforts on the back end database by tracing SQL queries.
- Created Workflows and Workflow policies, used policies and runtime events to invoke the workflow processes to automate the business process.
- Involved in resolving the issues found during Unit Testing & User acceptance Testing.
- Worked on Correspondence templates and recipients to generate custom Letters with merged field functionally to be sent to the partners.
- Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
- Supported PMO by mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation. Experience in implementing Microsoft Office SharePoint .
- Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
- Successfully defined and implemented Project Management processes and procedures based on BABOK, and PMBOK for multiple groups.
- Conducted project kick off meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
- Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design (OOD) concepts and UML using Rational Requisite Pro.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Supervise and manage projects throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
- Conducted meeting with the EDI team and other stakeholders team members to discuss the requirements
- Involved in meetings with product manager, project manager, onsite and offshore team members to resolve issues and roadblocks during the project.
- Identifying and modeling Use case diagrams, Sequence diagrams, Activity diagrams, Collaboration diagrams using UML.
- Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
- Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
- Coordinated with EDI team, developers and production support team at various stages of the project
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
- Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
- Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
- Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
- Assisted the technical team in translating application functionality into application architecture.
- Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
- Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
- Organized meetings to discuss outstanding issues with QA and developers.
Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller,WinRunner, Test Director
Confidential, Lincolnshire, IL
Business Analyst
Responsibilities:
- Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
- Assisted the project manager in preparing the project schedules, milestone tracking, resource allocation using Microsoft project. Involved in Change Request (CR) meetings with Business users of Retail, Pharmacy and Photo.
- Wrote Business Requirements, analyzed them and tested them. Constantly worked in a BABOK methodology environment to execute Business Analysis best practices. Involved in testing XML scripts consist of Sale summary of Retail, Pharmacy and Photo.
- Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
- Interaction with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process.
- Extensively used Ms SharePoint a content management platform, for managing content across the organization within a shared repository.
- Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
- Designed Functional Specification Documents for the reports. Managed timely completion of multiple projects in parallel- worked in close conjunction with the Project Management Office (PMO) to define scope of the project and its deliverables.
- Had planned deadlines assigning the responsibilities, monitored and summarized project progress on weekly basis.
- Extensive use of Excel to create Functional Specification Documents & Templates.
- Designed the process flow diagrams for flow of information and report creation process.
- Worked with a cross functional team including Sales and Marketing
- Conducted RAD sessions for the report users, requestors, and the developers. Responsible for Analysis and Designing by using tools such as iRise.
- Responsibilities of checking of data in database by writing and executing SQL statements and UAT on NGPOS Environment consist of MPOS, KIOSK, PHARMACY and PHOTO
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD Generated wireframes and prototype for the GUI. Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
- Documented all the changes in the initial templates and was responsible for Release Management.
- Reviewed Requirements & deliverables for delivery timeline.
- Used MS Visio to create Flow diagrams and Use Case Diagrams.
- Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.
- Coordinated with the developer, on day-to-day basis, during the development process.
- Involved in manual testing and UAT with the development team and QA team.
- Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
- Worked on Report Re-engineering Project and made enhancements to the system flow.
- Modified System flow diagrams using SDLC.
- Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
- Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
- Responsible for writing Test cases to cover overall quality assurance using Test Director
- Performed initial manual testing of the application as part of sanity testing
- Created various checkpoints in the script using Win Runner
- Application and network performance testing analysis
Environment: PL/SQL, SQL Server, XML, Windows 95/98/2000, ODBC, Internet Explorer and Netscape, Web Logic, UNIX, Rational Req. pro, clear case, Rational Rose, iRise, Clear Quest, UML, Ms Visio, and Ms Project
Confidential - New Jersey
Business Analyst
Responsibilities:
- Gathered user requirements and directed developers for practical deliverables.
- Worked with the full SDLC, elicit, analyze and define requirements.
- Conducted JAD sessions with the clients to identify the requirements.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling. Created UI specifications Used IRISE Studio for designing and simulation of web applications.
- Used Rational Unified Process (RUP) for streamlining the team’s development activities.
- Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Worked extensively with insurance brokers
- Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
- Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
- Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint.
- Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
- Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
- Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
- Deep understanding of Structured System Development Methodologies
- Designing and customizing data models for Data warehouse supporting data from multiple sources
- Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
- Defined, developed specs for federal reporting specific to Medicare Advantage
- Conducted user interviews, gathering requirements, analyzing the requirements using Rational Rose, Requisite Pro - RUP.
- Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
- Tested claims adjudication and group and enrollment in Amisys for New Medicare advantage members
- Well versed with HIPAA, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing alternative solutions using best practice model and principles.
- Worked with Claims, enrollment, eligibility verification for members and providers, benefits setup, and backend payment cycle in facets.
- Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
- Work with project manager to build out plans using project management tool.
- Researched the existing client processes and guided the team in aligning with the HIPAA rules and regulations for the systems for all the EDI transaction sets.
- Interacted with Business Users to conduct thorough Requirements Analysis.
- Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB.
- Responsible for creating a business process and workflow documentation using BPMN standards.
- Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
- Created standard test case template according to the company requirements and standards.
- Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
- Used MS Visio for Process modeling and Business Process flow diagrams
- Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
- Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
- Tracked UAT issues/bugs and prepared reports.
- Performed job of contact point for all stakeholders (business, legal, compliance, development).
- Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS Excel, RUP, Oracle, UML, iRise, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.
Confidential, Dallas, TX
Business Systems Analyst
Responsibilities:
- Studied the CMS regulation for reporting requirements Attended HIPAA training
- Work closely with Business Owners and Stakeholders to outline Business Requirements using rational requisite pro.
- Work with System analyst and IS teams to understand the flow of data.
- Reviewed and analyzed data from various sources.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Planned and documented procedures for data processing and prepared data flow diagrams for the application
- In-depth knowledge and solid experience in the design, development, implementation, management, and testing of EDI applications.
- Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
- Created context and workflow models, information and business requirement models, Use Case and Object Models during the analysis using Rational tools.
- Create standard benefit packages for Medicare Advantage and Part D plans, such as requiring that Medicare Advantage plans charge no more cost-sharing for services than what is charged under Original Medicar .
- Implemented Facets NASCO claims management system to allow for more efficient claims processing, membership enrollment and provider data maintenance.
- HIPAA EDI transactions such as 834,835, 837 (P, D, I) 276, 277, 278.
- Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams
- Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
- Defined Functional Test Cases, documented, Executed test script in Facets system.
- Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
- Analyzed trading partner specifications and created EDI mapping guidelines
- Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
- Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
- 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.
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Analyzed the test results with Win runner reports
- Analyzed results and EDI ANSI X12 file mapping and reported on standard analysis spreadsheet.
- Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts. Acted as a liaison between client and payer/intermediary.
- Highly experienced Senior EDI Programmer Analyst with a record of developing and supporting successful IT applications and solutions, with an emphasis on technical, as well as non-technical, Customer Service.
- Skilled at utilizing EDI translation software, including mapping, debugging, trading partner relationships, and user files. Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
Environment: Requisite Pro, Rational Rose, Agile, HL7Interfaces, PL/SQL, HTML, MS Office, MS Visio, EDI, Rational Clear Quest, Rational Clear Case, UML,RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio.