SUMMARY:

• 18 years as a Business & Systems Analyst
• 4.5 years as a Project Manager
• 3 years of Agile experience
• ITIL v3 Certified
• Six Sigma (Greenbelt) Certified
• MMIS
• T - MSIS

PROFESSIONAL EXPERIENCE:

Confidential - Austin, TX

Lead Business Analyst

Responsibilities:

• Lead Business Analyst for Truven Health Analytics on numerous Enterprise Data Warehouse Projects
• Remotely host requirements gathering sessions with mid-level managers and developers
• Document new ICDs (for data file transmissions)
• Create mapping document to track data elements from outside sources into the Confidential staging database, then to the Confidential Data Warehouse, then to the Confidential Advantage Suite reporting database. Use SQL to query data results.
• Investigate and document items logged in Rally pertaining to Change Requests, such as details about columns to be added to existing extract feeds, provide calculations identifying how they will be populated, identify data constraints, PK, FK, Default values and Column Sequence.
• Assist PM with creation of tasks sorted by phase/release and prioritization among tasks, so that hardware, databases and software can be rolled out in the proper sequence.
• Update Source-to-Target mapping to correct data issues for CMS T-MSIS implementations
• Identify T-MSIS data elements that cannot be mapped from MMIS and provide remediation plan and date to CMS
• Meet with state executives and subject matter experts to gather requirements, document business rules and create user stories.
• Verify that change requests are correctly implemented by running queries against data and determining whether the data returned is as expected.
• Map fields to populate reporting demonstration as part of Confidential ’s response to RFP in MA.

Confidential - Austin, TX

Senior Business Analyst Consultant

Responsibilities:

• Employ a SCRUM version of Agile SDLC to: create product backlog and tasks.
• Attend daily stand-up, validate tasks with product owner and development, UAT, release to stakeholders
• Prepare Project Proposal, CBA and Resource Estimation Documents
• Prepare Project Plan (MS Project) and host weekly team status meeting to track progress
• Prepare weekly Executive Project Status for distribution to executive team
• Meet with a variety internal customers to understand pain points of current functionality
• Distribute Meeting Minutes to record decisions taken and to track issues to resolution
• Conduct analysis of off the shelf products (COTS)
• Prepare Business Requirements Document and attachments
• Prepare Functional Requirements Document and attachments (e.g., Report automation requirements)
• Prepare Test Plan
• Prepare and execute test cases
• Prepare User Guides for internally-created software and reports
• Use MS SQL Server Management Studio to query tables in DEV and Operations databases

Confidential - Austin, TX

Lead Business / Systems Analyst

Responsibilities:

• Provide mandatory weekly status reports for my projects to Project Coordinator and Executive Management
• Managed and executed all aspects of requirements data gathering and documentation, test case design and execution, executive review and sign-off.
• Elicit business process and system process knowledge from subject matter experts in order to document and refine business and system requirements necessary for coding and comprehensive testing.
• Prepared User Acceptance Tests based on business requirements and linked system requirements. Conducted meetings with executive level staff, developers, and stakeholders from related state agencies to obtain agreement and sign-off on proposed solution and documentation.
• Made assignments to other BAs who joined the projects to assist with tasks such as note-taking during meetings with SMEs, document creation and reviews, and test case creation.
• Assisted Project Coordinator by creating and updating Project Plans for my assigned projects.
• Created online forms that healthcare providers use to send medical service authorizations and requests for payments to the state agency that is responsible for processing them.
• Oversaw data transmission was via Web Services and XML.

Confidential - Austin, TX

Business Analyst Consultant

Responsibilities:

• Used a standardized documentation methodology based on Axzure development software, to capture system requirements necessary to create a new, portable Medicaid claims platform.
• Documented modules to include the Provider Claims web portal and the Medicaid Worker (internal) claims web portal.
• Examined federal standards for filing medical claims as they relate to paper claim forms (Institutional, Professional and Dental) and their X12 counterparts (837I, 837P and 837D) known as the 5010 format.
• Conducted sessions with SMEs to document business requirements, web layout requirements and their supporting system requirements.
• Conducted deliverable reviews with SMEs, and director level management personnel, as well as with development and testing leads.
• Oversaw that waterfall methodology was employed.

Confidential - Austin, TX

Senior Business Analyst

Responsibilities:

• Served as part of the SDU Delivery Group, using a standardized documentation methodology, captured client system requirements in JAD sessions, prepared the gap analysis document, requirements documents, and detailed Use Cases.
• Supported the development and testing teams through requirements clarification.
• Ensured user sign-off for each milestone and user acceptance at project completion.
• Clients included a variety of states' agencies requiring support through the design and implementation of systems that performed case-member association and identification, child support payment processing, and the delivery of child support benefits via Electronic Payment Cards.
• Prepared the set of requirements documents that became the base requirements documents that were customized and used by all other team members for similar projects.

Confidential - Austin, TX

Business Analyst Consultant

Responsibilities:

• Met with State Technical Leads and Business Leads, State Inspector General representative, Project Manager, Developers and other SME’s to define and document Business User Requirements and Functional Design Requirements.
• Created use cases and process flow diagrams during the Inception and Elaboration phases.
• Created and executed product tests covering each use case during the Construction phase.
• Used Quality Center 9.2 to store requirements, tests and test results.
• Validated data in Oracle database during testing. Create User Acceptance Test book to review with my State stakeholders during the Transition phase.
• TMHP’s Medicaid portal is connected to TIERS Integrated eligibility system.
• Facilitated document review meetings at each step to obtain sign-off and to ensure that the State customer receives only high quality deliverables.
• Conducted product verification after implementation.

Confidential - Austin, TX

Business Analyst Consultant

Responsibilities:

• Performed Business Analysis role in an Agile development environment, including weekly assignments by the Scrum Master and daily status update “stand-up” meetings, writing user stories and preparing related process flow diagrams that tie back to the user stories, working with developers to produce screen mocks and code units that tie back to user stories, reviewing developer’s first mini-releases and providing feedback to make it align with the user stories, conducting UAT with the customer, preparing user documentation, presenting final product to shareholders in NJ via teleconference.
• Worked closely with product owners, executives, developers and UI designers to define system and interface requirements for merging the functionality of Hoover’s.com and Selectory.com, both business-oriented websites with annual sales of $107M.
• Documented data sources from one system to the other (mapping).
• Conducted requirements reviews with stakeholders and IT staff.
• Created system tests and unit tests to validate the design.
• Created Query databases to define field specifications needed for conversion of legacy data.
• Performed acceptance testing with product owners to validate functionality and usability.
• Developed the new home page, a user registration page with back-end tables and constraints, Search Engine Optimization, Manage My Account pages, User login, change password, and forgot password and the main search page where users search for companies based on over 100 criteria.

Confidential - Austin, TX

Business Analyst & Project Manager

Responsibilities:

• Monitored storage capacity and user limits.
• Functioned as the Business Analyst for the Managed Deployment team.
• Prepared and presented monthly and quarterly management reports
• Met with management stakeholders and developers to define report requirements and then documented, designed, tested, and migrated the reports into production.
• Identified the tables and fields in the current systems that supply the reporting data; and work with DBA’s to identify what tables and fields the same data will begin pulling from once the new systems are implemented.
• Ensured that the reporting functionality remains the same throughout iterative releases of the new systems.
• Maintained Confidential Deployment Readiness Tool (a Quick Base application) in support of 200 Confidential staff users.
• Monitored storage capacity and user limits.
• Used Excel and Access to prepare monthly and quarterly management reports from data pulled from multiple databases.
• Managed operations activities and supply chain logistics of the Pennsylvania project team in State and Local Government vertical, including Custom Imaging Manager, Inside Sales Representatives, Order Processors, and Shipping carriers.
• Maintained up-to-the-minute project status documentation on up to 40 projects at a time.
• Developed and designed internal processes for the team to use to meet contractual SLA's.
• Escalated any issues that may put a deadline at risk.
• Received a Business Process Improvement (Six Sigma) Green Belt for streamlining my Project's Custom Factory Imaging processes, resulting in a $50,000 reduction in spend and lost time ( Confidential BPI # 26514.
• Worked with customers to resolve order deployment issues.

Confidential - Austin, TX

Lead Business Analyst / PM

Responsibilities:

• Designed core system functionality including accounts receivable, receipts, posting to accounts, balance verification, adjustments, transfers, and refunds. Facilitated meetings between system developers and internal stakeholders.
• Worked with internal stakeholders to define the functional requirements of the Financial System.
• Specified screen layout requirements for the user interfaces.
• Created use cases from business requirements and technical requirements for integrated eligibility to validate whether household income and asset requirements have been met so that S-CHIP is an appropriate option.
• Designed and executed functional and system-level tests from use cases to ensure that business and technical requirements are met.
• Used SQL queries to isolate and retrieve data for test cases. Used SQL scripts to run test cases. Used SQL queries and GUI to verify test case output.
• Created financial reports and capitation reports for internal and external customers in SQL Server 2000 Reporting Services. Documented software malfunctions and prioritizes them with other outstanding tickets.

Confidential, Austin, TX

Business Analyst & Quality Assurance Engineer

Responsibilities:

• In charge of documenting requirements for major components of Verizon's 9-1-1 (Java) interface.
• Developed complete software requirements documentation, including process flow diagrams and data mapping.
• Worked with development teams from the requirements phase through product release to create, maintain, and enhance test case scenarios.
• Established a single repository for all QA tests in PVCS Version Manager.
• Created and maintained the Master Test Plan according to industry standards for a multi-million dollar project.
• Developed, executed and documented tests for both client (C++/Java/web - on Win2000 PC) and server (Oracle 8i on HP-UNIX).
• Created Oracle database instances from scripts provided and load/maintain data.
• Used SQL queries to isolate and retrieve data for test cases.
• Used SQL scripts to run test cases.
• Used SQL queries and GUI to verify test case output.
• Validated user manuals against the new software.
• Recorded defects discovered in bug tracking tool.

Confidential, Omaha, NE

Business Analyst, Quality Assurance Engineer

Responsibilities:

• Worked with development team to design new Child Support Enforcement systems.
• Scheduled and facilitated “brain-storming” sessions with Business Analysts, Programmers, State Policy Administrators, and the Project Manager.
• Researched Federal and State requirements to determine business rules.
• Analyzed existing functionality to determine required enhancements.
• Used Object-Oriented Analysis principles and flow diagrams to identify objects, prepare use cases and create the data dictionary.
• Prepared screen mock-ups using Visual Basic.
• Formed use cases write and execute tests for AS400 server and VB U.I. at progressive stages as programs/modules are redesigned.
• Attended code reviews to ensure business requirements are met. Used SQL queries to isolate and retrieve data for test cases.
• Worked to ensure new development met the requirements necessary to complete the “Federal Deck” as proof that federal requirements had been met.
• Used SQL scripts to run test cases. Used SQL queries and GUI to verify test case output.

Confidential - Austin, TX

Program Specialist

Responsibilities:

• Assisted with data cleanup effort prior to initial conversion from AS-400 to TXCSES 1.0.
• Conducted unit and system tests to ensure correct functionality of TXCSES 1.0.
• Provided individual training to end-users. Performed acceptance testing as Pilot Team member.
• Managed four employees in the section.
• Directed and monitored the work of team members, providing individual and group training as needed. Developed written procedures explaining the utility of specific system processes and screens used to correct payment-processing errors.
• Developed the highest knowledge of State and Federal regulations and procedures governing the child support program in Texas.
• Conducted administrative hearings under Section 231, Texas Family Code.
• Used interpersonal skills to negotiate with payors, payees and their attorneys, to reach Agreed Orders that were filed in State court.