Data Analyst Resume
Irvine, TX
SUMMARY:
- Business Analyst with 8 years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
- Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
- In - depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
- Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
- Expertise in the EPIC Medical software application (EMR).
- Knowledgeable of HL7 Messaging protocols.
- Extensive experience in all phases of RUP and SDLvisionC processes
- Assisted in SOX and Six Sigma Procedures
- Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
- Strong oral and exceptional written business communication skills
- Hard working, positive thinking, self starter with a strong goal orientation
- Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
TECHNICAL SKILLS:
Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP,CVS,TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, SQL,Oracle DBA, Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, JAVA, Javascript, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Rational XDE, EMR, Mercury Test Director,DOORS, Business Process Modeler, RequisitePro
EXPERIENCE:
Confidential, Irvine, TX
Data Analyst
Responsibilities:
- Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
- Coordinated participation and sign-off of various business partners and customers.
- Created business requirement documents and integrated the requirements and underlying platform functionality.
- Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
- Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
- Developed HL7 messaging for bi-directional case and disease report exchange, in text and XML formats, in accordance with HL7 specifications;
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Interfaced between Business new product builders and System platform builders.
- Worked with systems area to translate business needs into system requirements.
- Made sure the test cases and test process guarantee accountability to business and systems requirements.
- Extensively involved in data modeling
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Gathered requirements and modeled the data warehouse and the underlying transactional database
- Perform Gap Analysis of the processes to identify and validate requirements.
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Involved in the testing phase right from the Unit testing to the User Acceptance testing.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
- Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
- Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
- Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Tuned the batch programs and online transactions to alleviate performance problems.
- Developed & executed several Optimized queries in SQL on this data.
Environment: RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003.
Confidential, New Hudson, MI
Data Analyst/Business Analyst
Responsibilities:
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
- Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
- Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Worked on data modeling and produced data mapping and data definition documentation
- Configured the Data mapping between Oracle and SQL Server 2005.
- Tested Performance & Accuracy related queries under SQL Server
- Designed and implemented basic SQL queries for testing and report/data validation
- Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
- Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
- Used Data warehousing for Data Profiling to examine the data available in an existing database.
- 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.
- Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
- 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 User Acceptance Testing, gathered and documented User Manuals and Business Rules
Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, IBM Websphere Business Process Modeller, ACORD, XML,Business Objects, TestDirector, LoadRunner
Confidential, Augusta, ME
Business Analyst
Responsibilities:
- As a Business analyzed the Design Documents and system specifications and identified the test requirements. Attended requirements, design, and review and documentation meetings.
- Prepared and was involved in all aspects of test planning development (e.g. goals, objectives, strategies). Created test strategies, test plans, wrote and executed positive and negative test cases for projects and patches tested in the MeCMS application.
- Responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation & Verification process. Worked with Claims, enrollment, eligibility verification for members and providers, benefits setup, and backend payment cycle in facets.
- Analyzed and tested various Common Eligibility Outbound Interface Process and other Inbound/Outbound Facets interfaces
- Validated and tested the applications developed while working on various projects under different subsystem of Confidential application in the testing environments.
- Tested various claims processing while working on different projects like Interims Payment Recapture, J-codes Rebates, Prior Authorization, Voids and Comprehensive waiver in both UAT and E2E testing environments.
- Involved and assisted in Regression testing involving the major claims processing whenever a new patch was deployed in to the test environment.
- Tested the various applications in different module, which includes several Sub modules like Claims Processing, Inquiring Claims, and Updating claims elements through the front end.
- Played a key role in leading all testing efforts surrounding the Capitation & Billing configuration that was applied within the Facets System for the HMO line of business
- Analyzed the configuration set-up within Facets by utilizing the business rules and Capitation Design Workbook
- Manipulated paper, emc as well as HIPAA claim to test the required scenarios in the testing environment.
- Responsible for documentation of Configuration library for Benefit terms and contract terms.
- Tested the six Pilot Providers in E2E environment for Comprehensive waiver testing and reviewed Remittance Advices for these providers.
- Documented all of the conducted test scenarios and test cases and logged the reported defects and updated their statuses using Quality Center.
- Worked closely with Business SMEs while creating test documentation and also while conducting the test. Reviewed and presented the test results to Business users.
- Trained Business users to use the newly build application such as Interims Payment Recapture. Provided post-production support to business users when the application went live.
- Created and executed Manual Test scripts to verify complex system requirements and database testing. Transaction Verified through Data Verification of Backend Database using SQL Queries through Toad.
Environment: QNXT 4.6, Quality Center, Java, Oracle, Toad, UNIX server, Web logic, Windows XP, MS Office, Rational Requisite Pro, Rational Rose, MS Share Point.
Confidential, Olympia, WA
Business Analyst
Responsibilities:
- Documented the detailed business as well as technical requirements to implement new functionalities for MMIS application
- Assisted in defining the initial common terminology to be used throughout the project lifecycle.
- Conducted interviews with the clients for gathering requirements and evaluation/analysis of their data. Converted the Business Requirements Documents into Functional and Non-functional requirements.
- Performed GAP Analysis to check compatibility of existing system infrastructure with new business requirements.
- Conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis.
- Interacted with the internal and external stake holders to ensure deadlines are met and signed off on completion of projects.
- Documented and reported the progress to the management on an ongoing basis.
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle.
- Prepared Activity, Logical, Component and Deployment views to assist development and engineering in understanding the requirements using Rational Rose.
- Extensive use of Rational Requisite Pro for reviewing and analyzing the user requirements.
- Maintained Traceability matrix throughout the project.
- Analyzed and reviewed the System requirement specification document, Test plans and Test cases.
- Interacting with the development team to explain various design documents: Business Use Case Model, Detailed Use Cases, and Vision Document.
- Creating detailed design of the system with the project team including class diagrams, activity diagrams, and sequence and collaboration diagrams.
Environment: MS Office, Windows 2000, .NET, MS Visio, MS Access, Business Objects, MS SharePoint, MS Project, SQL, SOA, HTML.
