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 wif mid-level managers and developers
• Document new ICDs (for data file transmissions)
• Create mapping document to track data elements from outside sources into teh IBM staging database, tan to teh IBM Data Warehouse, tan to teh IBM 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 wif creation of tasks sorted by phase/release and prioritization among tasks, so that hardware, databases and software can be rolled out in teh 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 wif 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 teh data returned is as expected.
• Map fields to populate reporting demonstration as part of IBM’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 wif 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 wif 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 teh 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:

• Acted as Lead Business Analyst on several projects for Department of Aging and Disabilities Services (DADS) including Cost Avoidance (recoupment), ICD-10 Compliance for Long-term Care, PASRR systematic alerts (alerts regarding online forms used to submit evaluations and certifications of nursing home residents for special services) and Code Table Automation Tool (for internal State System Admin to be able to update Oracle code tables instead of a DBA at TMHP).
• 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 wif 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 teh projects to assist wif tasks such as note-taking during meetings wif 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 teh 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 teh Provider Claims web portal and teh 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 teh 5010 format.
• Conducted sessions wif SMEs to document business requirements, web layout requirements and their supporting system requirements.
• Conducted deliverable reviews wif SMEs, and director level management personnel, as well as wif development and testing leads.
• Oversaw that waterfall methodology was employed.

Confidential - Austin, TX

Senior Business Analyst

Responsibilities:

• Served as part of teh SDU Delivery Group, using a standardized documentation methodology, captured client system requirements in JAD sessions, prepared teh gap analysis document, requirements documents, and detailed Use Cases.
• Supported teh 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 teh design and implementation of systems that performed case-member association and identification, child support payment processing, and teh delivery of child support benefits via Electronic Payment Cards.
• Prepared teh set of requirements documents that became teh base requirements documents that were customized and used by all other team members for similar projects.
• Obtained ITIL v.3 certification on 6/1/2010.

Confidential - Austin, TX

11/09Business Analyst Consultant

Responsibilities:

• Met wif 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 teh Inception and Elaboration phases.
• Created and executed product tests covering each use case during teh 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 wif my State stakeholders during teh 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 teh 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 teh Scrum Master and daily status update “stand-up” meetings, writing user stories and preparing related process flow diagrams that tie back to teh user stories, working wif 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 wif teh user stories, conducting UAT wif teh customer, preparing user documentation, presenting final product to shareholders in NJ via teleconference.
• Worked closely wif product owners, executives, developers and UI designers to define system and interface requirements for merging teh functionality of Hoover’s.com and Selectory.com, both business-oriented websites wif annual sales of $107M.
• Documented data sources from one system to teh other (mapping).
• Conducted requirements reviews wif stakeholders and IT staff.
• Created system tests and unit tests to validate teh design.
• Created Query databases to define field specifications needed for conversion of legacy data.
• Performed acceptance testing wif product owners to validate functionality and usability.
• Developed teh new home page, a user registration page wif back-end tables and constraints, Search Engine Optimization, Manage My Account pages, User login, change password, and forgot password and teh main search page where users search for companies based on over 100 criteria.

Confidential - Austin, TX

Business Analyst & Project Manager

Responsibilities:

• Managed team consisting of Sales, Configuration, Distribution and Support functions as teh Inside Operations Project Manager for $111M Commonwealth of Pennsylvania Contract. Worked wif customers to resolve order deployment issues.
• Monitored storage capacity and user limits. Functioned as teh Business Analyst for teh Managed Deployment team. Prepared and presented monthly and quarterly management reports
• Met wif management stakeholders and developers to define report requirements and tan documented, designed, tested, and migrated teh reports into production.
• Identified teh tables and fields in teh current systems that supply teh reporting data; and work wif DBA’s to identify wat tables and fields teh same data will begin pulling from once teh new systems are implemented.
• Ensured that teh reporting functionality remains teh same throughout iterative releases of teh new systems. Maintained Dell Deployment Readiness Tool (a Quick Base application) in support of 200 Dell 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.
• Worked wif Dell's B2B team and teh customer's SRM team to resolve data mapping errors preventing proper electronic order entry.
• Managed operations activities and supply chain logistics of teh Pennsylvania project team in State and Local Government vertical, including Custom Imaging Manager, Inside Sales Representatives, Order Processors, and Shipping carriers.
• Maintained up-to-teh-minute project status documentation on up to 40 projects at a time. Developed and designed internal processes for teh 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 (Dell BPI # 26514.
• Worked wif customers to resolve order deployment issues.

Confidential - Austin, TX

Lead Business Analyst / PM

Responsibilities:

• Manage team consisting of CPA staff and programmers in a project to automate error reporting of ACH files to teh State of Texas account at Bank One and to credit CHIP accounts wif payments confirmed by teh bank.
• 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 wif internal stakeholders to define teh functional requirements of teh Financial System.
• Specified screen layout requirements for teh 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 wif 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 wif development teams from teh 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 teh 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 teh new software. Recorded defects discovered in bug tracking tool.

Confidential - Omaha, NE

Business Analyst, Quality Assurance Engineer

Responsibilities:

• Worked wif development team to design new Child Support Enforcement systems for teh State of Nebraska. Scheduled and facilitated “brain-storming” sessions wif Business Analysts, Programmers, State Policy Administrators, and teh Project Manager. Researched Federal and State requirements to determine business rules.
• Analyzed existing functionality to determine required enhancements.
• Used Object-Oriented Analysis principals and flow diagrams to identify objects, prepare use cases and create teh 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 teh requirements necessary to complete teh “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 wif 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 teh section.
• Directed and monitored teh work of team members, providing individual and group training as needed. Developed written procedures explaining teh utility of specific system processes and screens used to correct payment-processing errors.
• Developed teh highest knowledge of State and Federal regulations and procedures governing teh child support program in Texas.
• Conducted administrative hearings under Section 231, Texas Family Code.
• Used interpersonal skills to negotiate wif payors, payees and their attorneys, to reach Agreed Orders that were filed in State court.