We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Irvine, TX

SUMMARY:

  • Over 7 years of professional experience as a Business Analyst in the Health Care domain
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • Strong knowledge on the Systems Development Life Cycle (SDLC), Rational Unified Process Methodology (RUP), RAD, SWOT, and CRM.
  • Strong skills in creating UML Diagrams and Data Models including Use Case Diagrams, Activity Diagrams, Deployment Diagrams, Data Flow Diagrams (DFD) and Entity - Relationship diagrams using Rational Rose and MS Visio.
  • Experience in Clinical Data Management and Clinical Trial Management.
  • Strong knowledge of Project management skills includes time estimation, task identification, and scope management.
  • Proficient in designing Data Models(logical and physical) for Oracle, DB2 and SQL Server databases.
  • Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
  • Experience in preparing Systems Proposal Reports and performing GAP analysis.
  • Experience and skills in creating design models and Extensive use of UML/RUP for modeling views using tools like Microsoft Visio.
  • Understanding of BEA WebLogic Portal to simplify the production and management of custom-fit portals, allowing a shared services environment to roll out changes with minimal complexity and effort.
  • Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc
  • Conducted requirement analysis techniques such as Business Process Automation, Business Process Improvement, and Business Process re-engineering.
  • Motivated self-starter with exceptional team building, leadership, and verbal skills.
  • In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.

Software/Hardware:

C#.Net, VB.Net, AS 400, Goldmine, HL7, SQL, IDMS, QTP, MS Windows NT 4.0/2000, Windows 95/98, Windows XP, MS Visual Studio.Net, IBM WebSphere 5.0, Power Builder 5, 6.5, 7, Rational Rose, UML 2.0, RUP, OOAD, MS Visio and Visual Studio.Net, Sybase SQl Anywhere 5/6, Adaptive Server Anywhere, MSSQL 7, Oracle 6 / 7.x / 8i / 9i, Oracle - TOAD, Informatica, Bbusiness Object, ETL, Cognos, Erwin ODBC, Visual Source Safe 6.0, Cobol, Source Off-Site, Round-Table, Win CVS, NUnit.net, MS Project, MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, TX

Sr. Business Analyst

Responsibilities:

  • Gathered high level requirements and developed scope of the project for the implementation of Microsoft Office Share Point 2007.
  • Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
  • Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration
  • Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
  • Developed the strategy for developing and implementing new EDI (HL7 and X12) interfaces and converting historical clinical and data.
  • Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions
  • Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
  • Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Involved in analyzing activities for a variety of major projects including Medicare Plan part D, Coordination of Benefits, New Client Implementations, Consumer driven and regularly scheduled system upgrades.
  • Extensively interacted with the stakeholders and the IT Department in finalizing the requirements according to the CMS Compliances/Regulations and HIPAA Regulations.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
  • Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
  • Provide business intelligence analysis to decision-makers using an interactive OLAP tool
  • Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
  • Served as a tool to communicate business requirements to data management vendors to assure consistency across clinical trial projects.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
  • Analyzed trading partner specifications and created EDI mapping guidelines
  • Developed Data Conversion Strategy for converting data from the existing site to the new site.
  • Designed and developed project document templates based on SDLC methodology

Environment: Windows 2000/XP, HL7, Microsoft Office SharePoint 2007, Cognos, Agile, Rational Requisite Pro, MS Office, SQL Server 2005, Cobol, MS Project, MS FrontPage 2003, MS Access, EDI, Documentum 2.0.,UML.

Confidential, Louisville, KY

Business Systems Analyst

Responsibilities:

  • Interacted with business heads to finalize the Business Requirements for the application.
  • Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
  • Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
  • Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Represent Operations Team as Client Liaison for Medicare Part D Plan.
  • Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
  • Implemented Data Modeling standards, including element-naming conventions.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
  • Designed new Business Intelligence (BI) system using Oracle Discoverer 10g to provide reporting under Oracle Applications.
  • Conversion of data from different database environments, while performing Back End Testing.
  • Developed extensive experience in eligibility and benefits calculation for state, federal and local services such as Medicare and Medicaid.
  • Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
  • Developed criteria for IVR and online interface preauthorization process for providers.
  • Was providing broad enterprise business system deployment analysis and support of Oracle Financial.
  • Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Developed and troubleshoot Cognos 8BI Report Studio reports to meet USDOD requirements for uniformed services activities
  • Checked Business Readiness and determined activities of flow.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Developed & executed several Optimized queries in SQL on this data.
  • Wrote Procedure Manuals and was responsible for continuity preparedness.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Office, MS Project, Agile, UML, XML, Windows XP, NT/2000, HTML, Cobol, SQL Server 2000, HL7, Vignette Content management Tool, J2EE (JSP1.2), XML, XSL, XSLT, HTML, Oracle 9i.

Confidential, IL

Business Analyst

Responsibilities:

  • Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
  • Performed Cost benefit, ROI and ROM studies
  • I was involved in the clinical data management system (CDMS) to manage the data of a clinical trial and medical writing.
  • Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
  • Conducted user interviews and documented business and functional requirements.
  • Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Responsible for architecting integrated HIPAA, Medicare solutions, Facets.
  • Responsible for 24x7 coverage for various mainframe based Cobol applications using DB2, VSAM and IMS databases
  • Defined, developed specs for federal reporting specific to Medicare Advantage.
  • Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
  • Developed Data Conversion Strategy for converting data from the existing site to the new site.
  • Created use case scenarios and documented work flow and business process using Rational Rose
  • Involved in project management using MS Project
  • Documented requirements, associated change requests with requirements and connected requirements with Use cases.
  • Performed logical/physical data modeling, data distribution, Forward/Reverse Engineering of Data Models using Allfusion ERwin 3.x/4.x Data Modeler.
  • Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
  • Develop, execute, analyze and document system test case scenarios and tests scripts for the contact management system. Thorough working knowledge of ACDs, IVRs and CTI.
  • Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
  • Involved in performance tuning and monitoring of T-SQL blocks.
  • Used Rational Clear case for version control
  • Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
  • Queried database using SQL for backend testing
  • Used Rational clear quest for defect management

Environment: Windows XP Professional, SQL 2000, Oracle9i, MS Access 2000, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Cobol, Cognos, HL7, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.

Confidential, Marlton NJ

Business Analyst

Responsibilities:

  • Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
  • Involved in with data migration (ETL development), document data manipulation processes and scripts.
  • Responsible for preparing Software Requirement Specification (SRS) and documenting them.
  • Created Process Work flows, Functional Specifications documents and documented system requirements.
  • Performed all necessary programming, testing and documentation for COBOL, DB2 batch programs and sub-routines.
  • Extensive involved in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
  • Responsible for maintaining database of Medicare D inquiries.
  • Develop detailed unit test plans and scripts and conducted rigorous testing per requirements and assisted in data mapping.
  • Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
  • Interacted with various cross-functional teams on building business use cases, and understanding expenses and revenue stream.
  • Worked with Quality Control Teams to develop Test Plan and Test Cases.
  • Interaction with the developers to report and correct bugs.
  • Developed Test Plans and Test Cases according to Business Requirements.
  • Use HL7 implementation methodology to create specifications, assist with unit testing, and perform integrated testing for messaging between the state Departments of Health and the location office
  • Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units
  • Analysis of new Business Requirements and preparation of the Functional Design Specifications
  • Interacted with clients like SPF Securities to finalize their website look and contents.
  • Utilize HL7 implementation methodology to develop Electronic Laboratory Reporting interfaces

Environment: J2EE (JSP 1.1), EJB(2.0), Servlets 2.2, JMS, Java2 (JDK 1.3), STRUTS,JDBC2.0, XML, XSL, XSLT, Rational Rose, PL/SQL, HTML, CSS, JavaScript, Cognos, HL7, Websphere4.0,Oracle 8.0, WebSphere Studio Application Developer v5.0, Cobol, Win2000, Unix(AIX)

Confidential, Marietta, GA

Business Analyst

Responsibilities:

  • Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
  • Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
  • Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
  • Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
  • Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Planned and documented procedures for data processing and prepared data flow diagrams for the application.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Created HL7 compliant script for proprietary Oracle messaging system
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
  • Designed and implemented integrated business model using Cognos ePlanning Analyst Software.
  • Participated in the development of the data modeling methodology to be used in the project.
  • Analyzed trading partner specifications and created EDI mapping guidelines
  • Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.

Environment: Windows 2000/XP, Microsoft Office SharePoint, Cobol, Cognos, HL7, Rational Requisite Pro, MS Office, SQL Server, MS Project, MS FrontPage, MS Access, EDI, Documentum 2.0.,UML.

Hire Now