SUMMARY:

• Sr. Business Analyst Professional with 9+ years’ experience in the Healthcare, and Financial Industries. Most recently wrapped up with Confidential in which I was a System Analyst.
• Focused mainly on the migration of diagnosis codes from ICD - 09 to ICD-10. Within most of the previous roles was responsible for enhancements to various systems and web portal upgrades to increase efficiency.

TECHNICAL SKILLS:

• Rational Unified Process
• UML
• Agile, Waterfall
• MS Visio
• MS Office (Word, Excel, PowerPoint, Project, Outlook, Access)
• MS SQL Server
• Rational Requisite Pro
• Rational Clear Quest
• HP Quality Center
• Test Director

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential, Eagan, MN

• Utilized RFP (Request for Proposal) to gather estimates on internal-external labor and sketching timeline for project management phases assisting program manager.
• Facilitated efficient and effective information exchange between corporate clients and their TPA vendors and PBMs.
• Managed critical deliverables and performed channelized communication to IT management, executive management, and client stakeholders
• Assisted in formulating external and internal project kick-off presentation deck and wire-frames for proposed workflow.
• Gathered system requirements for numerous deliverables including web integration, dedicated client portals, product marketing portals, Single-Sign-On functionality, enrollment files, claims data feed outbound/inbound, customized billing process extensive user guides and claims data reporting.
• Analyzed functional (system) requirements for interfaces/file transfer specifications; data mapping.
• Designed new system interface and applications to support automated data exchange feeds with carve out vendors to streamline enrollment, reporting, billing data and financial reconciliation process.
• Elicited requirements for financial system transaction posting for SAP FS-CD (SAP for insurance collection and disbursement). Created file transfer spec (FTS) for move-it network convergence landing zone. Including data for medical, dental, health savings account, and external data.
• Generated billing reports in excel using VBA scripting (Macros).
• Conducted UAT; assisted in QA testing (test environment variables) formulated contingency plans for year-end releases.
• Created web portal specification for client-dedicated portals and insurance subscribers’ portal. Customized webpage logos reflecting business partnership. Designed post-authentication environment for subscribers based on services purchased.
• Designed process flows for consumer grievance and consumer appeals tracking system (CATS). Streamlined automated information flow between multiple entities in compliance with HIPAA regulations (insuring entities, state department of insurance), IRO (Independent Review Organization)-OPM (US Office of Personnel Management).
• Designed reporting specs for Health Economics for reporting requirements from business partners in other states for premium, claims utilization assessment for actuarial purposes needed for the new insurance arrangement.
• Worked with developers on updating project management application based in access and oracle DB using RDBMS (Relational Database Management System) techniques.
• Wrote/ part-authored and designed consumer user guide/manual to help access online invoicing systems with insights from marketing and operations team.
• Created data feeds to PBMs and TPAs for Disease Management (DM), Care Management (CM) and Health support products to support requested customizations.
• Managed requirements analysis under established enterprise requirements management guidelines (Rational Unified Process) managed technical using Requisite Pro.

Environment: .Net, RUP, HTML, UML, MS Office, Use Cases, Rational Requisite Pro, Quality Center, MS Visio

IT System Analyst

Confidential, Minneapolis, MN

• Participated in Business Modeling by understanding the needs of the business, and also documenting Business Use Cases as well as System Use Cases.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Participated regularly in walkthroughs and review meetings with PM, QA Lead and development teams.
• Accomplished experience through whole SDLC from requirement analysis till deployment, using highly efficient Scrum process of Software development.
• Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
• Reports were the main driver for cross-functional team meetings that were held twice a day to direct priorities and resources.
• Assisted development team to translate requirements into technical specifications.
• Created and Maintained the Requirement Traceability Matrix (RTM).
• Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop specific acceptance criteria and prepare test exhibits.
• Conducted User Acceptance Testing (UAT) sessions with business users and prepared document for enhancements and bug fixes.
• Conducted production acceptance testing (PAT) sessions with business users in order to ensure that product is meeting acceptance criteria.
• Used Test Director and Mercury ALM to report any bugs found and communicate to the developers and product support team.
• Analyzed and evaluated User Interface Designs, Technical Design Documents and Quality Assurance Test condition the performance of the application from various dimensions.
• Helped create the ‘Business Glossary’ to facilitate efficient understanding of the Business process
• Among the other teams.
• Conducted meetings to document Change Requests for new requirements.
• Designed and developed Use Cases and UML models using Microsoft Visio.

Environment: Rally, Rational Requisite Pro, Rational Clear Case, Clear Quest, Oracle 8i, PL/SQL, MS Word, MS PowerPoint, MS Access, MS Visio, MS Excel.

Sr. Business/ Data Analyst

Confidential, Oklahoma, OK

• Used agile methodology for the rapid development of application.
• Extensively worked with SME to better understand the existing claim processing at Confidential .
• Performed and analyzed GAP Analysis of EDI 837 transaction from 4010 to 5010.
• Developed crosswalk for understanding major changes from ICD-9 to ICD-10 versions. Some of the changes included in Loop 1000A (Submitters contact information), Loop 2000A (billing), Loop 2000B (Claim filing Indicator code) etc.
• Developed extensive database queries in SQL Server.
• Performed various operations and functions of Data Warehousing.
• Worked on major areas of IFacets affected by the Enhancement.
• Worked on Business requirements for Legacy to IFacets Transformation project.
• Created extensive database queries for File Compare process.
• Coordinated team application of test driven development (TDD) strategies to optimize system quality and to enable rapid refactoring.
• Created File Transfer Specification document for transferring data from old system to new system.
• Created data mapping and data modeling while working on data transfer task for ICD9 to ICD 10.
• Performed data analysis and data mining to see the right input and get the right output data.
• Validated Integrated ICD 10 with HIPAA 5010.
• Organized and facilitated meetings with the management and the development team to better understand the Business Requirement.
• Gather requirements after JAD sessions with the purpose of defining the functional business, Data and system requirements.
• Identified the scope, business objective and documented the functional requirements for each release.
• Created various new database structures importing from legacy systems using number of tools such as Business Objects and Oracle Warehouse Builder (OWB).
• Used MS-Visio to create Data Flow Diagrams as a Structured Analysis tool.
• Security Strategy Information Security Program Management.
• Threat and Risk Assessment Identity and Access Management.
• IT General Controls IT Application Controls.
• Developed Business flow diagrams, Activity/State diagrams and Sequence diagrams, Use cases so that the development team and other stakeholders can understand the business process.
• Created artifacts for Rational Unified Process (RUP) - system architecture document, supplemental requirements document, architecture diagrams; verifying technical production infrastructure; designing and executing performance tests; and documentation.
• Defined the scope of testing for user acceptance testing.
• Reviewed requirements matrix to ensure all requirements were included in the scope of testing.
• Supported documentation across extended testing team as directed by UAT manager.
• Adhered to all established processes and procedures for UAT.
• Wrote clear, concise and detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret and design and develop the application with minimum guidance.
• Developed Business flow diagrams, Activity/State diagrams and Sequence diagrams so that the development team and other stake holders can understand the business process.
• Worked closely with QA team and Developer to establish traceability matrix to ensure the completeness of the enrollment procedure.
• Guided QA team to write test cases and test scripts to confirm the displayed information and also tested to print the image in the paper.
• Performed functional testing of the application as per the 5010 changes.
• Documented and analyzed all defects using Mercury ALM and tracked them to completion by communicating with the team every day.
• Supported development and Installation team.
• Implemented Alpha Test in order to confirm the functionality of recent conversion.
• Built SharePoint solution using out of the box feature.
• Expertise in SharePoint 2010/2007.
• Extensive experience in developing and building Webparts, using SharePoint object model and Share point designer 2007/2010.

Environment: Mercury ALM, Windows, MS SQL, RUP, MS Visio

Business Analyst

Confidential, Nashville, TN

• Used agile methodology.
• Gathered requirements from various business areas like Claims, Provider Relations, Enrollment, Finance and Benefits Administration for their updates to the Claim Processing Engine.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Developed and implemented Test Strategies using the Test Director.
• Creating Microsoft Excel dashboards and reports on daily weekly basis analyzing key performance indicators.
• Reduced web analytics reporting hours by 25% by creating report templates with automation and data consolidation. Helped other teams to reduce project hours by 80% by analyzing web analytics data and providing feedback to focus on major areas to increase return on investment.
• Assisted QA team in testing phase by creating Test Plans and Test Cases documents.
• Followed the RUP methodology for the entire Software Development Cycles.
• Assisted the development team during the second and third iteration using the RUP model.
• Checked the data flow through the front end to backend and used SQL queries to extract the data from the database.
• Involved in project planning, coordination and implemented QA methodology.
• Developed the Requirements Traceability Matrix, prioritized and determined impact of all applications.
• Identified the all applications and interviewed the application owners to recommend the process improvements.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Defect Tracking and Bug Reporting was performed using Test Director

Environment: RUP, Enterprise Architect, Rational Suite Requisite Pro, HP ALM, MS Project, MS Visio, MS Access, MS SharePoint.

Business Analyst

Confidential, Sandusky, Ohio

• Gathered user requirements to develop requirement documents, functional specification documents, testing methodology documents and training documents.
• Conducted JRP sessions with stake holders and portfolio team to capture business requirements and system behavior.
• Gathered detail requirements in the areas of financial instruments, Asset management for corporations, Public funds and Foundations.
• Performed analysis on swaps, derivatives stocks, bonds, fixed income and other financial instruments.
• Conducted Business Analysis and Business Requirements Gathering.
• Reviewed business process flow with RUP methodologies/tools for work flow and case diagrams.
• Partnered with Project Managers and SMEs to assess and document the impact of managing current project requirements.
• Partnered with SMEs in writing functional and technical specifications.
• Performed metadata analysis on the databases.
• Performed data mapping of ITG’s client database to the data warehouse for reporting.
• Worked in Misys summit.
• Analysis and interpretation of client’s securities data for liability and profitability.
• Worked on creating training manuals, job aids and process aids.
• Involved in Testing Methodology Document, both for Unit Testing and Systems Testing.
• Reviewed test cases and helped set up test data.

Environment: RUP, SQL Server, Windows NT, PL SQL, Erwin 4.0, Visio, Data Warehousing, MS Project 2000, Microsoft Access, Excel, Word & Power Point.

Business Analyst

Confidential, Dallas, TX

• Performed Stakeholder Analysis to identify the key players for project success.
• Participated in Stakeholder Management to communicate effectively with the right stakeholders.
• Identified and involved all key stakeholders, contributors, business, operations and technical resources that must participate in a project and ensure that contributors are motivated to complete assigned tasks within the parameters of the project plan.
• Facilitated JAD sessions for communicating and managing expectations with Confidential whose customers were going to be the final users of the product.
• Scheduled meeting with developers, SA’s (System’s Analyst) and testers to collaborate resource allocation and project completion using MS Project.
• Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process, Requisite Pro.
• Created Process Work flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD) and final Design Document as per SEI CMM standards.
• Created and managed project templates, Use Case project templates, requirement types and trace-ability relationships in Requisite Pro.
• Proactively managed Software development, Requirements Analysis & Design, RFP/ RFI creation using Rational Rose and Requisite Pro.
• Responsible for creating business flow diagrams (using MS-Visio) and charts for E-commerce.
• Provided implementation assessment for Rational Requisite Pro, Rational Rose, UML and RUP.
• Participated in QA Team meetings for weekly QA testing reviews.
• Used ALM to create and maintain Test Requirements, bug tracking and reporting.
• Developed and executed Test Scripts for Smoke Test prior to Build deployment.
• Used Test Director for Maintained Test Matrix and Traceability Matrix.
• Prepared user manual for SWIFT net bulk payment.
• Created product documentation, including online help, printed user manual, and training materials.

Environment: Rational Requisite Pro, SWIFT. Rational Rose, RUP, UML, SQL, PL/SQL, MS Office, MS-Project, Windows 2000, ALM, Crystal Reports.